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

23 rows where P005008 = 0 and P005009 = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003004, P003005, P003006, P003007, P003008, P005002, P005003, P005004, P005005, P005006, P005007, P005010, P005011, P005012, P005013, P005014, P005015, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005009 ✖

P005008 ✖

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
1 1 1000000US110010040021000 Block 1000, Block Group 1, Census Tract 40.02, District of Columbia, District of Columbia 273 199 24 0 10 1 22 17 273 216 182 12 0 10 1 0 11 57 17 12 0 0 0 22 6 110010040021000 3 303 303 3 psa_37 3D3
4 4 1000000US110010040022001 Block 2001, Block Group 2, Census Tract 40.02, District of Columbia, District of Columbia 345 298 26 0 7 0 2 12 345 325 282 25 0 7 0 0 11 20 16 1 0 0 0 2 1 110010040022001 3 303 303 3 psa_37 3D3
136 136 1000000US110010074031005 Block 1005, Block Group 1, Census Tract 74.03, District of Columbia, District of Columbia 635 1 621 1 1 0 0 11 635 628 1 614 1 1 0 0 11 7 0 7 0 0 0 0 0 110010074031005 7 704 704 7 psa_5 7D2
167 167 1000000US110010076034003 Block 4003, Block Group 4, Census Tract 76.03, District of Columbia, District of Columbia 491 28 447 0 0 0 5 11 491 480 28 441 0 0 0 0 11 11 0 6 0 0 0 5 0 110010076034003 6 606 606 6 psa_7 6D2
185 185 1000000US110010077082006 Block 2006, Block Group 2, Census Tract 77.08, District of Columbia, District of Columbia 303 1 289 0 1 0 0 12 303 302 1 289 0 1 0 0 11 1 0 0 0 0 0 0 1 110010077082006 6 603 603 6 psa_15 6D3
244 244 1000000US110010092011006 Block 1006, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 250 40 183 1 1 0 10 15 250 226 36 178 0 1 0 0 11 24 4 5 1 0 0 10 4 110010092011006 5 502 502 5 psa_40 5D1
346 346 1000000US110010008022008 Block 2008, Block Group 2, Census Tract 8.02, District of Columbia, District of Columbia 206 182 0 0 13 0 0 11 206 192 168 0 0 13 0 0 11 14 14 0 0 0 0 0 0 110010008022008 2 205 205 2 psa_46 2D2
1777 1777 1000000US110010095031002 Block 1002, Block Group 1, Census Tract 95.03, District of Columbia, District of Columbia 197 0 184 1 1 0 0 11 197 195 0 182 1 1 0 0 11 2 0 2 0 0 0 0 0 110010095031002 4 405 405 4 psa_49 4D2
2116 2116 1000000US110010038001003 Block 1003, Block Group 1, Census Tract 38, District of Columbia, District of Columbia 312 238 10 2 32 0 7 23 312 222 170 8 1 32 0 0 11 90 68 2 1 0 0 7 12 110010038001003 3 303 303 3 psa_37 3D3
2278 2278 1000000US110010012002008 Block 2008, Block Group 2, Census Tract 12, District of Columbia, District of Columbia 335 274 11 2 33 0 4 11 335 303 246 11 2 33 0 0 11 32 28 0 0 0 0 4 0 110010012002008 2 203 203 2 psa_50 2D1
2301 2301 1000000US110010088023000 Block 3000, Block Group 3, Census Tract 88.02, District of Columbia, District of Columbia 260 29 217 1 2 0 0 11 260 258 28 217 0 2 0 0 11 2 1 0 1 0 0 0 0 110010088023000 5 506 506 5 psa_26 5D3
2386 2386 1000000US110010056002008 Block 2008, Block Group 2, Census Tract 56, District of Columbia, District of Columbia 198 159 16 0 12 0 0 11 198 196 159 14 0 12 0 0 11 2 0 2 0 0 0 0 0 110010056002008 2 207 207 2 psa_24 2D3
2599 2599 1000000US110010084022006 Block 2006, Block Group 2, Census Tract 84.02, District of Columbia, District of Columbia 280 152 97 1 15 0 2 13 280 258 141 92 1 13 0 0 11 22 11 5 0 2 0 2 2 110010084022006 1 104 104 1 psa_21 1D2
3160 3160 1000000US110010047021000 Block 1000, Block Group 1, Census Tract 47.02, District of Columbia, District of Columbia 336 65 243 0 8 0 8 12 336 322 63 240 0 8 0 0 11 14 2 3 0 0 0 8 1 110010047021000 1 102 102 1 psa_18 1D1
3634 3634 1000000US110010058002004 Block 2004, Block Group 2, Census Tract 58, District of Columbia, District of Columbia 385 288 24 0 54 0 5 14 385 357 268 24 0 54 0 0 11 28 20 0 0 0 0 5 3 110010058002004 1 101 101 1 psa_20 1D1
4485 4485 1000000US110010014022000 Block 2000, Block Group 2, Census Tract 14.02, District of Columbia, District of Columbia 390 318 48 0 4 0 7 13 390 376 313 48 0 4 0 0 11 14 5 0 0 0 0 7 2 110010014022000 2 201 201 2 psa_55 2D1
4827 4827 1000000US110010022021002 Block 1002, Block Group 1, Census Tract 22.02, District of Columbia, District of Columbia 134 8 73 0 0 1 40 12 134 84 2 71 0 0 0 0 11 50 6 2 0 0 1 40 1 110010022021002 4 407 407 4 psa_47 4D2
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
5368 5368 1000000US110010082001004 Block 1004, Block Group 1, Census Tract 82, District of Columbia, District of Columbia 298 262 4 0 15 0 5 12 298 282 253 3 0 15 0 0 11 16 9 1 0 0 0 5 1 110010082001004 1 108 108 1 psa_17 1D2
5443 5443 1000000US110010099072005 Block 2005, Block Group 2, Census Tract 99.07, District of Columbia, District of Columbia 451 0 430 0 4 1 0 16 451 446 0 430 0 4 1 0 11 5 0 0 0 0 0 0 5 110010099072005 6 604 604 6 psa_14 6D3
5812 5812 1000000US110010005011007 Block 1007, Block Group 1, Census Tract 5.01, District of Columbia, District of Columbia 215 181 3 0 16 0 4 11 215 204 174 3 0 16 0 0 11 11 7 0 0 0 0 4 0 110010005011007 2 204 204 2 psa_44 2D2
5869 5869 1000000US110010074081000 Block 1000, Block Group 1, Census Tract 74.08, District of Columbia, District of Columbia 1136 23 1097 3 2 0 0 11 1136 1113 17 1080 3 2 0 0 11 23 6 17 0 0 0 0 0 110010074081000 7 702 702 7 psa_6 7D1
6335 6335 1000000US110010034001001 Block 1001, Block Group 1, Census Tract 34, District of Columbia, District of Columbia 283 23 240 0 7 1 1 11 283 270 16 235 0 7 1 0 11 13 7 5 0 0 0 1 0 110010034001001 3 306 306 3 psa_38 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
);