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

12 rows where P005006 = 19 sorted by DISTRICT

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003003, P003004, P003006, P003007, P003008, P005005, P005007, P005008, P005009, P005010, P005011, P005012, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005013 ✖

P005006 ✖

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
4913 4913 1000000US110010110004001 Block 4001, Block Group 4, Census Tract 110, District of Columbia, District of Columbia 374 183 156 1 19 0 3 12 374 363 178 154 1 19 0 0 11 11 5 2 0 0 0 3 1 110010110004001 1 105 105 1 psa_22 1D3
324 324 1000000US110010003003006 Block 3006, Block Group 3, Census Tract 3, District of Columbia, District of Columbia 246 216 7 0 19 0 2 2 246 219 191 7 0 19 0 0 2 27 25 0 0 0 0 2 0 110010003003006 2 206 206 2 psa_29 2D2
3698 3698 1000000US110010006001003 Block 1003, Block Group 1, Census Tract 6, District of Columbia, District of Columbia 476 399 17 0 19 1 18 22 476 403 355 14 0 19 1 1 13 73 44 3 0 0 0 17 9 110010006001003 2 203 203 2 psa_50 2D1
4439 4439 1000000US110010011002002 Block 2002, Block Group 2, Census Tract 11, District of Columbia, District of Columbia 275 166 83 0 19 0 0 7 275 259 152 83 0 19 0 0 5 16 14 0 0 0 0 0 2 110010011002002 2 202 202 2 psa_52 2D1
450 450 1000000US110010037003003 Block 3003, Block Group 3, Census Tract 37, District of Columbia, District of Columbia 378 209 108 3 19 1 27 11 378 304 169 106 3 19 1 1 5 74 40 2 0 0 0 26 6 110010037003003 3 304 304 3 psa_36 3D1
2891 2891 1000000US110010043001005 Block 1005, Block Group 1, Census Tract 43, District of Columbia, District of Columbia 326 235 56 5 19 0 5 6 326 296 216 55 1 19 0 0 5 30 19 1 4 0 0 5 1 110010043001005 3 301 301 3 psa_31 3D3
4013 4013 1000000US110010042012003 Block 2003, Block Group 2, Census Tract 42.01, District of Columbia, District of Columbia 446 393 11 2 19 0 9 12 446 417 374 11 1 19 0 1 11 29 19 0 1 0 0 8 1 110010042012003 3 301 301 3 psa_31 3D3
4219 4219 1000000US110010039002010 Block 2010, Block Group 2, Census Tract 39, District of Columbia, District of Columbia 341 285 16 1 19 0 11 9 341 311 266 16 1 19 0 1 8 30 19 0 0 0 0 10 1 110010039002010 3 303 303 3 psa_37 3D3
5120 5120 1000000US110010039003000 Block 3000, Block Group 3, Census Tract 39, District of Columbia, District of Columbia 308 225 39 1 19 0 11 13 308 276 209 33 1 19 0 2 12 32 16 6 0 0 0 9 1 110010039003000 3 303 303 3 psa_37 3D3
424 424 1000000US110010026001004 Block 1004, Block Group 1, Census Tract 26, District of Columbia, District of Columbia 371 153 143 0 19 0 28 28 371 312 130 138 0 19 0 2 23 59 23 5 0 0 0 26 5 110010026001004 4 404 404 4 psa_48 4D3
2439 2439 1000000US110010028012007 Block 2007, Block Group 2, Census Tract 28.01, District of Columbia, District of Columbia 145 51 39 1 19 0 27 8 145 96 34 37 1 19 0 2 3 49 17 2 0 0 0 25 5 110010028012007 4 408 408 4 psa_39 4D3
2610 2610 1000000US110010032003001 Block 3001, Block Group 3, Census Tract 32, District of Columbia, District of Columbia 790 114 517 5 19 1 110 24 790 574 35 509 5 19 1 0 5 216 79 8 0 0 0 110 19 110010032003001 4 409 409 4 psa_41 4D3

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