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

11 rows where P005017 = 4 and SECTOR = "2D2"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003004, P003007, P003008, P005004, P005005, P005006, P005008, P005009, P005011, P005012, P005013, P005014, 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
320 320 1000000US110010003002004 Block 2004, Block Group 2, Census Tract 3, District of Columbia, District of Columbia 615 514 18 4 36 0 18 25 615 564 484 17 4 35 0 3 21 51 30 1 0 1 0 15 4 110010003002004 2 204 204 2 psa_44 2D2
342 342 1000000US110010008013001 Block 3001, Block Group 3, Census Tract 8.01, District of Columbia, District of Columbia 370 339 4 0 18 0 1 8 370 341 316 3 0 18 0 0 4 29 23 1 0 0 0 1 4 110010008013001 2 205 205 2 psa_46 2D2
1375 1375 1000000US110010001002001 Block 2001, Block Group 2, Census Tract 1, District of Columbia, District of Columbia 273 237 9 0 13 0 3 11 273 248 219 8 0 13 0 1 7 25 18 1 0 0 0 2 4 110010001002001 2 206 206 2 psa_29 2D2
1462 1462 1000000US110010005022006 Block 2006, Block Group 2, Census Tract 5.02, District of Columbia, District of Columbia 653 549 22 0 47 0 11 24 653 612 521 21 0 47 0 3 20 41 28 1 0 0 0 8 4 110010005022006 2 204 204 2 psa_44 2D2
2033 2033 1000000US110010002024001 Block 4001, Block Group 4, Census Tract 2.02, District of Columbia, District of Columbia 123 75 11 1 21 0 7 8 123 109 73 10 1 20 0 1 4 14 2 1 0 1 0 6 4 110010002024001 2 206 206 2 psa_29 2D2
2047 2047 1000000US110010001001000 Block 1000, Block Group 1, Census Tract 1, District of Columbia, District of Columbia 324 270 7 2 23 0 10 12 324 279 239 7 2 23 0 0 8 45 31 0 0 0 0 10 4 110010001001000 2 206 206 2 psa_29 2D2
2304 2304 1000000US110010007011003 Block 1003, Block Group 1, Census Tract 7.01, District of Columbia, District of Columbia 52 45 0 0 0 0 0 7 52 44 41 0 0 0 0 0 3 8 4 0 0 0 0 0 4 110010007011003 2 204 204 2 psa_44 2D2
4054 4054 1000000US110010005022001 Block 2001, Block Group 2, Census Tract 5.02, District of Columbia, District of Columbia 197 151 16 0 12 0 7 11 197 175 142 14 0 12 0 0 7 22 9 2 0 0 0 7 4 110010005022001 2 204 204 2 psa_44 2D2
4110 4110 1000000US110010010021000 Block 1000, Block Group 1, Census Tract 10.02, District of Columbia, District of Columbia 1255 969 74 2 165 0 11 34 1255 1156 889 69 1 165 0 2 30 99 80 5 1 0 0 9 4 110010010021000 2 204 204 2 psa_44 2D2
4957 4957 1000000US110010007021000 Block 1000, Block Group 1, Census Tract 7.02, District of Columbia, District of Columbia 515 439 15 1 27 0 17 16 515 458 399 14 0 27 0 6 12 57 40 1 1 0 0 11 4 110010007021000 2 204 204 2 psa_44 2D2
6141 6141 1000000US110010005021008 Block 1008, Block Group 1, Census Tract 5.02, District of Columbia, District of Columbia 184 154 2 3 14 0 5 6 184 150 131 2 1 13 0 1 2 34 23 0 2 1 0 4 4 110010005021008 2 204 204 2 psa_44 2D2

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