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

22 rows where P005016 = 20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003004, P003005, P003006, P003007, P003008, P005001, P005003, P005005, P005006, P005008, P005009, P005010, P005011, P005013, P005014, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005012 ✖

P005007 ✖

P005016 ✖

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
388 388 1000000US110010020012004 Block 2004, Block Group 2, Census Tract 20.01, District of Columbia, District of Columbia 90 17 51 0 0 0 20 2 90 66 17 48 0 0 0 0 1 24 0 3 0 0 0 20 1 110010020012004 4 403 403 4 psa_51 4D1
391 391 1000000US110010021014003 Block 4003, Block Group 4, Census Tract 21.01, District of Columbia, District of Columbia 121 17 74 6 0 0 20 4 121 77 2 74 0 0 0 0 1 44 15 0 6 0 0 20 3 110010021014003 4 403 403 4 psa_51 4D1
734 734 1000000US110010022021004 Block 1004, Block Group 1, Census Tract 22.02, District of Columbia, District of Columbia 121 8 88 4 0 0 20 1 121 94 6 86 1 0 0 0 1 27 2 2 3 0 0 20 0 110010022021004 4 407 407 4 psa_47 4D2
1297 1297 1000000US110010095011004 Block 1004, Block Group 1, Census Tract 95.01, District of Columbia, District of Columbia 344 32 278 0 2 0 21 11 344 315 31 274 0 2 0 1 7 29 1 4 0 0 0 20 4 110010095011004 4 405 405 4 psa_49 4D2
1329 1329 1000000US110010092011004 Block 1004, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 662 199 396 0 26 1 23 17 662 609 173 394 0 26 1 3 12 53 26 2 0 0 0 20 5 110010092011004 5 502 502 5 psa_40 5D1
2270 2270 1000000US110010022021006 Block 1006, Block Group 1, Census Tract 22.02, District of Columbia, District of Columbia 156 16 112 1 3 0 20 4 156 136 16 112 1 3 0 0 4 20 0 0 0 0 0 20 0 110010022021006 4 407 407 4 psa_47 4D2
2298 2298 1000000US110010021013000 Block 3000, Block Group 3, Census Tract 21.01, District of Columbia, District of Columbia 200 17 149 0 0 0 20 14 200 157 11 140 0 0 0 0 6 43 6 9 0 0 0 20 8 110010021013000 4 403 403 4 psa_51 4D1
2667 2667 1000000US110010013021001 Block 1001, Block Group 1, Census Tract 13.02, District of Columbia, District of Columbia 2196 1703 178 4 224 1 24 62 2196 2023 1561 176 2 221 1 4 58 173 142 2 2 3 0 20 4 110010013021001 2 203 203 2 psa_50 2D1
2773 2773 1000000US110010035001006 Block 1006, Block Group 1, Census Tract 35, District of Columbia, District of Columbia 296 92 148 0 9 0 23 24 296 227 68 142 0 9 0 3 5 69 24 6 0 0 0 20 19 110010035001006 3 304 304 3 psa_36 3D1
2837 2837 1000000US110010023011000 Block 1000, Block Group 1, Census Tract 23.01, District of Columbia, District of Columbia 174 15 134 0 1 0 20 4 174 139 10 128 0 1 0 0 0 35 5 6 0 0 0 20 4 110010023011000 4 407 407 4 psa_47 4D2
2985 2985 1000000US110010080012012 Block 2012, Block Group 2, Census Tract 80.01, District of Columbia, District of Columbia 191 59 101 0 4 0 21 6 191 162 58 98 0 4 0 1 1 29 1 3 0 0 0 20 5 110010080012012 1 104 104 1 psa_21 1D2
3537 3537 1000000US110010027022002 Block 2002, Block Group 2, Census Tract 27.02, District of Columbia, District of Columbia 269 191 33 3 7 0 23 12 269 228 178 33 2 6 0 3 6 41 13 0 1 1 0 20 6 110010027022002 3 302 302 3 psa_42 3D1
3595 3595 1000000US110010025021003 Block 1003, Block Group 1, Census Tract 25.02, District of Columbia, District of Columbia 105 3 76 1 2 0 20 3 105 80 3 72 1 2 0 0 2 25 0 4 0 0 0 20 1 110010025021003 4 404 404 4 psa_48 4D3
3934 3934 1000000US110010021022009 Block 2009, Block Group 2, Census Tract 21.02, District of Columbia, District of Columbia 223 30 159 0 6 0 23 5 223 195 25 156 0 6 0 3 5 28 5 3 0 0 0 20 0 110010021022009 4 403 403 4 psa_51 4D1
4315 4315 1000000US110010025022006 Block 2006, Block Group 2, Census Tract 25.02, District of Columbia, District of Columbia 206 86 87 1 1 0 21 10 206 176 82 83 1 1 0 1 8 30 4 4 0 0 0 20 2 110010025022006 4 404 404 4 psa_48 4D3
4340 4340 1000000US110010021026004 Block 6004, Block Group 6, Census Tract 21.02, District of Columbia, District of Columbia 179 33 121 0 0 0 20 5 179 130 7 121 0 0 0 0 2 49 26 0 0 0 0 20 3 110010021026004 4 403 403 4 psa_51 4D1
4343 4343 1000000US110010022023006 Block 3006, Block Group 3, Census Tract 22.02, District of Columbia, District of Columbia 168 9 133 3 0 0 20 3 168 138 9 125 1 0 0 0 3 30 0 8 2 0 0 20 0 110010022023006 4 407 407 4 psa_47 4D2
4402 4402 1000000US110010050022003 Block 2003, Block Group 2, Census Tract 50.02, District of Columbia, District of Columbia 575 427 48 0 49 2 21 28 575 499 380 45 0 49 2 1 22 76 47 3 0 0 0 20 6 110010050022003 3 307 307 3 psa_28 3D3
4472 4472 1000000US110010040011002 Block 1002, Block Group 1, Census Tract 40.01, District of Columbia, District of Columbia 518 431 17 0 16 0 20 34 518 424 366 14 0 16 0 0 28 94 65 3 0 0 0 20 6 110010040011002 3 303 303 3 psa_37 3D3
4735 4735 1000000US110010030001000 Block 1000, Block Group 1, Census Tract 30, District of Columbia, District of Columbia 128 63 30 0 8 0 22 5 128 100 57 29 0 8 0 2 4 28 6 1 0 0 0 20 1 110010030001000 3 302 302 3 psa_42 3D1
6067 6067 1000000US110010022021000 Block 1000, Block Group 1, Census Tract 22.02, District of Columbia, District of Columbia 77 11 46 0 0 0 20 0 77 53 7 46 0 0 0 0 0 24 4 0 0 0 0 20 0 110010022021000 4 407 407 4 psa_47 4D2
6229 6229 1000000US110010024002009 Block 2009, Block Group 2, Census Tract 24, District of Columbia, District of Columbia 110 18 65 1 4 0 20 2 110 83 14 63 1 4 0 0 1 27 4 2 0 0 0 20 1 110010024002009 4 407 407 4 psa_47 4D2

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
);