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 P005005 = 2 and P005012 = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003004, P003005, P003006, P003007, P003008, P005006, P005007, P005008, P005010, P005011, P005013, P005014, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

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
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
1109 1109 1000000US110010094003000 Block 3000, Block Group 3, Census Tract 94, District of Columbia, District of Columbia 144 28 83 2 16 0 14 1 144 112 14 80 2 16 0 0 0 32 14 3 0 0 0 14 1 110010094003000 5 503 503 5 psa_45 5D2
1644 1644 1000000US110010027013000 Block 3000, Block Group 3, Census Tract 27.01, District of Columbia, District of Columbia 482 372 64 3 18 0 6 19 482 441 343 61 2 18 0 1 16 41 29 3 1 0 0 5 3 110010027013000 3 302 302 3 psa_42 3D1
2913 2913 1000000US110010084022001 Block 2001, Block Group 2, Census Tract 84.02, District of Columbia, District of Columbia 279 38 230 2 1 3 1 4 279 273 37 227 2 1 3 0 3 6 1 3 0 0 0 1 1 110010084022001 1 104 104 1 psa_21 1D2
3603 3603 1000000US110010098011003 Block 1003, Block Group 1, Census Tract 98.01, District of Columbia, District of Columbia 301 0 295 2 0 0 0 4 301 298 0 292 2 0 0 0 4 3 0 3 0 0 0 0 0 110010098011003 7 706 706 7 psa_2 7D3
4191 4191 1000000US110010027022007 Block 2007, Block Group 2, Census Tract 27.02, District of Columbia, District of Columbia 295 147 129 2 4 0 2 11 295 283 142 126 2 4 0 0 9 12 5 3 0 0 0 2 2 110010027022007 3 302 302 3 psa_42 3D1
4459 4459 1000000US110010095081004 Block 1004, Block Group 1, Census Tract 95.08, District of Columbia, District of Columbia 293 48 224 2 5 0 7 7 293 277 44 221 2 5 0 0 5 16 4 3 0 0 0 7 2 110010095081004 4 406 406 4 psa_54 4D2
5900 5900 1000000US110010101002001 Block 2001, Block Group 2, Census Tract 101, District of Columbia, District of Columbia 676 312 79 2 217 0 39 27 676 569 248 76 2 216 0 9 18 107 64 3 0 1 0 30 9 110010101002001 2 208 208 2 psa_33 2D3
6304 6304 1000000US110010077033001 Block 3001, Block Group 3, Census Tract 77.03, District of Columbia, District of Columbia 832 2 813 2 0 0 2 13 832 826 2 810 2 0 0 0 12 6 0 3 0 0 0 2 1 110010077033001 6 603 603 6 psa_15 6D3

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