dc_2010blocks_2020policedistricts_population

2010 DC population by US Census block, with each block linked to the police district and public service area in which it sits. For details and column descriptions see this blog post.

Data license: CC BY-SA 4.0 · Data source: US Census & DC Open Data Portal, combined by John Keefe

20 rows where P003004 = 1 and SECTOR = "2D3"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003003, P003005, P003006, P003007, P003008, P005001, P005003, P005004, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005015, P005016, P005017, PSA, NAME, GIS_ID

Link rowid ▼ GEO_ID NAME_x P003001 P003002 P003003 P003004 P003005 P003006 P003007 P003008 P005001 P005002 P005003 P005004 P005005 P005006 P005007 P005008 P005009 P005010 P005011 P005012 P005013 P005014 P005015 P005016 P005017 GEOID10 DISTRICT PSA NAME POLDIST_ID GIS_ID SECTOR
50 50 1000000US110010055003001 Block 3001, Block Group 3, Census Tract 55, District of Columbia, District of Columbia 363 316 5 1 24 0 5 12 363 343 303 5 0 24 0 1 10 20 13 0 1 0 0 4 2 110010055003001 2 208 208 2 psa_33 2D3
52 52 1000000US110010056001002 Block 1002, Block Group 1, Census Tract 56, District of Columbia, District of Columbia 369 298 17 1 31 0 6 16 369 339 277 16 1 30 0 1 14 30 21 1 0 1 0 5 2 110010056001002 2 207 207 2 psa_24 2D3
55 55 1000000US110010056001007 Block 1007, Block Group 1, Census Tract 56, District of Columbia, District of Columbia 434 335 14 1 56 0 11 17 434 401 319 12 1 56 0 2 11 33 16 2 0 0 0 9 6 110010056001007 2 207 207 2 psa_24 2D3
482 482 1000000US110010101001016 Block 1016, Block Group 1, Census Tract 101, District of Columbia, District of Columbia 158 91 46 1 15 0 1 4 158 146 82 46 1 15 0 0 2 12 9 0 0 0 0 1 2 110010101001016 2 207 207 2 psa_24 2D3
498 498 1000000US110010107002008 Block 2008, Block Group 2, Census Tract 107, District of Columbia, District of Columbia 666 524 20 1 85 0 14 22 666 619 494 19 0 84 0 3 19 47 30 1 1 1 0 11 3 110010107002008 2 208 208 2 psa_33 2D3
604 604 1000000US110010056002018 Block 2018, Block Group 2, Census Tract 56, District of Columbia, District of Columbia 562 438 78 1 24 0 2 19 562 542 420 77 1 24 0 1 19 20 18 1 0 0 0 1 0 110010056002018 2 207 207 2 psa_24 2D3
1012 1012 1000000US110010053013001 Block 3001, Block Group 3, Census Tract 53.01, District of Columbia, District of Columbia 1102 856 51 1 137 2 21 34 1102 986 770 48 0 136 1 5 26 116 86 3 1 1 1 16 8 110010053013001 2 208 208 2 psa_33 2D3
1323 1323 1000000US110010055002004 Block 2004, Block Group 2, Census Tract 55, District of Columbia, District of Columbia 282 232 9 1 30 0 3 7 282 264 217 9 1 30 0 0 7 18 15 0 0 0 0 3 0 110010055002004 2 208 208 2 psa_33 2D3
1674 1674 1000000US110010055003005 Block 3005, Block Group 3, Census Tract 55, District of Columbia, District of Columbia 363 304 15 1 33 0 3 7 363 333 277 15 1 33 0 0 7 30 27 0 0 0 0 3 0 110010055003005 2 207 207 2 psa_24 2D3
2245 2245 1000000US110010055003004 Block 3004, Block Group 3, Census Tract 55, District of Columbia, District of Columbia 180 138 11 1 23 0 0 7 180 170 130 11 1 23 0 0 5 10 8 0 0 0 0 0 2 110010055003004 2 207 207 2 psa_24 2D3
3747 3747 1000000US110010042021002 Block 1002, Block Group 1, Census Tract 42.02, District of Columbia, District of Columbia 212 147 4 1 46 0 3 11 212 199 137 4 1 46 0 1 10 13 10 0 0 0 0 2 1 110010042021002 2 208 208 2 psa_33 2D3
4595 4595 1000000US110010041002010 Block 2010, Block Group 2, Census Tract 41, District of Columbia, District of Columbia 248 216 12 1 12 2 5 0 248 232 204 12 1 12 2 1 0 16 12 0 0 0 0 4 0 110010041002010 2 208 208 2 psa_33 2D3
4898 4898 1000000US110010055002005 Block 2005, Block Group 2, Census Tract 55, District of Columbia, District of Columbia 335 286 7 1 30 0 1 10 335 312 267 7 0 29 0 0 9 23 19 0 1 1 0 1 1 110010055002005 2 207 207 2 psa_24 2D3
5017 5017 1000000US110010101001004 Block 1004, Block Group 1, Census Tract 101, District of Columbia, District of Columbia 553 354 98 1 50 0 21 29 553 469 300 96 1 49 0 0 23 84 54 2 0 1 0 21 6 110010101001004 2 209 209 2 psa_57 2D3
5039 5039 1000000US110010041002003 Block 2003, Block Group 2, Census Tract 41, District of Columbia, District of Columbia 15 13 0 1 1 0 0 0 15 12 11 0 0 1 0 0 0 3 2 0 1 0 0 0 0 110010041002003 2 208 208 2 psa_33 2D3
5260 5260 1000000US110010053012000 Block 2000, Block Group 2, Census Tract 53.01, District of Columbia, District of Columbia 201 167 8 1 18 0 0 7 201 190 160 8 0 18 0 0 4 11 7 0 1 0 0 0 3 110010053012000 2 208 208 2 psa_33 2D3
5636 5636 1000000US110010058001038 Block 1038, Block Group 1, Census Tract 58, District of Columbia, District of Columbia 8 0 7 1 0 0 0 0 8 8 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 110010058001038 2 209 209 2 psa_57 2D3
6071 6071 1000000US110010042022004 Block 2004, Block Group 2, Census Tract 42.02, District of Columbia, District of Columbia 492 424 33 1 23 0 3 8 492 471 409 32 1 23 0 1 5 21 15 1 0 0 0 2 3 110010042022004 2 208 208 2 psa_33 2D3
6151 6151 1000000US110010055005001 Block 5001, Block Group 5, Census Tract 55, District of Columbia, District of Columbia 258 188 10 1 41 1 4 13 258 235 176 10 1 40 1 0 7 23 12 0 0 1 0 4 6 110010055005001 2 208 208 2 psa_33 2D3
6262 6262 1000000US110010107001032 Block 1032, Block Group 1, Census Tract 107, District of Columbia, District of Columbia 53 15 32 1 0 0 3 2 53 44 13 29 1 0 0 0 1 9 2 3 0 0 0 3 1 110010107001032 2 207 207 2 psa_24 2D3

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "dc_2010blocks_2020policedistricts_population" (
"GEO_ID" TEXT,
  "NAME_x" TEXT,
  "P003001" INTEGER,
  "P003002" INTEGER,
  "P003003" INTEGER,
  "P003004" INTEGER,
  "P003005" INTEGER,
  "P003006" INTEGER,
  "P003007" INTEGER,
  "P003008" INTEGER,
  "P005001" INTEGER,
  "P005002" INTEGER,
  "P005003" INTEGER,
  "P005004" INTEGER,
  "P005005" INTEGER,
  "P005006" INTEGER,
  "P005007" INTEGER,
  "P005008" INTEGER,
  "P005009" INTEGER,
  "P005010" INTEGER,
  "P005011" INTEGER,
  "P005012" INTEGER,
  "P005013" INTEGER,
  "P005014" INTEGER,
  "P005015" INTEGER,
  "P005016" INTEGER,
  "P005017" INTEGER,
  "GEOID10" INTEGER,
  "DISTRICT" INTEGER,
  "PSA" INTEGER,
  "NAME" INTEGER,
  "POLDIST_ID" INTEGER,
  "GIS_ID" TEXT,
  "SECTOR" TEXT
);