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

15 rows where P005008 = 3 and POLDIST_ID = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003004, P003005, P003006, P003007, P003008, P005005, P005006, P005007, P005009, P005010, P005011, P005012, P005013, P005014, P005016, P005017, PSA, NAME, 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
48 48 1000000US110010053014002 Block 4002, Block Group 4, Census Tract 53.01, District of Columbia, District of Columbia 167 132 3 0 15 0 11 6 167 150 123 3 0 15 0 3 6 17 9 0 0 0 0 8 0 110010053014002 3 301 301 3 psa_31 3D3
1535 1535 1000000US110010046002018 Block 2018, Block Group 2, Census Tract 46, District of Columbia, District of Columbia 86 37 37 0 4 0 4 4 86 81 33 37 0 4 0 3 4 5 4 0 0 0 0 1 0 110010046002018 3 308 308 3 psa_27 3D2
2283 2283 1000000US110010035002005 Block 2005, Block Group 2, Census Tract 35, District of Columbia, District of Columbia 767 20 670 3 45 0 4 25 767 750 17 659 3 45 0 3 23 17 3 11 0 0 0 1 2 110010035002005 3 305 305 3 psa_32 3D2
2552 2552 1000000US110010038003004 Block 3004, Block Group 3, Census Tract 38, District of Columbia, District of Columbia 455 192 129 5 4 0 101 24 455 290 144 128 4 4 0 3 7 165 48 1 1 0 0 98 17 110010038003004 3 303 303 3 psa_37 3D3
2557 2557 1000000US110010038002000 Block 2000, Block Group 2, Census Tract 38, District of Columbia, District of Columbia 748 495 119 3 57 1 38 35 748 653 451 117 2 55 1 3 24 95 44 2 1 2 0 35 11 110010038002000 3 303 303 3 psa_37 3D3
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
3322 3322 1000000US110010044001006 Block 1006, Block Group 1, Census Tract 44, District of Columbia, District of Columbia 535 410 50 1 48 0 18 8 535 493 383 50 1 48 0 3 8 42 27 0 0 0 0 15 0 110010044001006 3 305 305 3 psa_32 3D2
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
4354 4354 1000000US110010042012004 Block 2004, Block Group 2, Census Tract 42.01, District of Columbia, District of Columbia 449 378 27 0 24 0 8 12 449 427 363 27 0 24 0 3 10 22 15 0 0 0 0 5 2 110010042012004 3 301 301 3 psa_31 3D3
4701 4701 1000000US110010034001004 Block 1004, Block Group 1, Census Tract 34, District of Columbia, District of Columbia 147 52 80 0 6 0 5 4 147 134 46 79 0 2 0 3 4 13 6 1 0 4 0 2 0 110010034001004 3 306 306 3 psa_38 3D2
4711 4711 1000000US110010048011005 Block 1005, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 232 48 154 3 4 0 18 5 232 211 44 154 1 4 0 3 5 21 4 0 2 0 0 15 0 110010048011005 3 308 308 3 psa_27 3D2
5182 5182 1000000US110010053014003 Block 4003, Block Group 4, Census Tract 53.01, District of Columbia, District of Columbia 330 285 4 1 27 0 4 9 330 307 263 4 1 27 0 3 9 23 22 0 0 0 0 1 0 110010053014003 3 301 301 3 psa_31 3D3
5450 5450 1000000US110010052014001 Block 4001, Block Group 4, Census Tract 52.01, District of Columbia, District of Columbia 182 144 14 0 11 0 5 8 182 176 140 14 0 11 0 3 8 6 4 0 0 0 0 2 0 110010052014001 3 301 301 3 psa_31 3D3
6167 6167 1000000US110010039004000 Block 4000, Block Group 4, Census Tract 39, District of Columbia, District of Columbia 537 420 58 1 20 1 11 26 537 486 384 57 1 20 1 3 20 51 36 1 0 0 0 8 6 110010039004000 3 303 303 3 psa_37 3D3
6489 6489 1000000US110010048021001 Block 1001, Block Group 1, Census Tract 48.02, District of Columbia, District of Columbia 159 86 44 0 11 0 11 7 159 141 76 44 0 11 0 3 7 18 10 0 0 0 0 8 0 110010048021001 3 308 308 3 psa_27 3D2

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