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

9 rows where P005006 = 36 sorted by GIS_ID

✎ View and edit SQL

This data as json, CSV (advanced)

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

P005013 ✖

  • 0 9

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
5542 5542 1000000US110010110002000 Block 2000, Block Group 2, Census Tract 110, District of Columbia, District of Columbia 832 550 219 2 36 0 7 18 832 804 532 218 2 36 0 2 14 28 18 1 0 0 0 5 4 110010110002000 1 103 103 1 psa_12 1D1
71 71 1000000US110010059001024 Block 1024, Block Group 1, Census Tract 59, District of Columbia, District of Columbia 281 62 167 0 36 0 8 8 281 267 55 167 0 36 0 2 7 14 7 0 0 0 0 6 1 110010059001024 1 102 102 1 psa_18 1D1
45 45 1000000US110010052011002 Block 1002, Block Group 1, Census Tract 52.01, District of Columbia, District of Columbia 475 385 35 2 37 0 4 12 475 440 362 32 2 36 0 0 8 35 23 3 0 1 0 4 4 110010052011002 2 208 208 2 psa_33 2D3
1032 1032 1000000US110010053012004 Block 2004, Block Group 2, Census Tract 53.01, District of Columbia, District of Columbia 417 336 16 2 36 0 8 19 417 392 319 16 2 36 0 1 18 25 17 0 0 0 0 7 1 110010053012004 2 208 208 2 psa_33 2D3
451 451 1000000US110010038002002 Block 2002, Block Group 2, Census Tract 38, District of Columbia, District of Columbia 633 512 38 0 36 0 24 23 633 573 477 38 0 36 0 1 21 60 35 0 0 0 0 23 2 110010038002002 3 303 303 3 psa_37 3D3
1474 1474 1000000US110010090002003 Block 2003, Block Group 2, Census Tract 90, District of Columbia, District of Columbia 285 41 196 0 36 0 0 12 285 283 41 196 0 36 0 0 10 2 0 0 0 0 0 0 2 110010090002003 5 503 503 5 psa_45 5D2
2584 2584 1000000US110010012001011 Block 1011, Block Group 1, Census Tract 12, District of Columbia, District of Columbia 421 342 20 0 36 0 7 16 421 372 306 18 0 36 0 3 9 49 36 2 0 0 0 4 7 110010012001011 2 203 203 2 psa_50 2D1
3013 3013 1000000US110010014023001 Block 3001, Block Group 3, Census Tract 14.02, District of Columbia, District of Columbia 221 157 21 1 36 0 4 2 221 193 131 21 1 36 0 2 2 28 26 0 0 0 0 2 0 110010014023001 2 201 201 2 psa_55 2D1
480 480 1000000US110010101001005 Block 1005, Block Group 1, Census Tract 101, District of Columbia, District of Columbia 541 395 92 0 37 2 7 8 541 506 374 85 0 36 2 1 8 35 21 7 0 1 0 6 0 110010101001005 2 209 209 2 psa_57 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
);