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

40 rows where P005009 = 11

✎ View and edit SQL

This data as json, CSV (advanced)

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

P005013 ✖

P005007 ✖

P005009 ✖

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
55 55 1000000US110010056001007 Block 1007, Block Group 1, Census Tract 56, District of Columbia, District of Columbia 434 335 14 1 56 0 11 17 434 401 319 12 1 56 0 2 11 33 16 2 0 0 0 9 6 110010056001007 2 207 207 2 psa_24 2D3
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
765 765 1000000US110010018032005 Block 2005, Block Group 2, Census Tract 18.03, District of Columbia, District of Columbia 696 38 452 1 26 1 144 34 696 502 11 451 0 26 1 2 11 194 27 1 1 0 0 142 23 110010018032005 4 402 402 4 psa_53 4D1
891 891 1000000US110010055002010 Block 2010, Block Group 2, Census Tract 55, District of Columbia, District of Columbia 398 336 10 0 33 0 7 12 398 372 315 8 0 33 0 5 11 26 21 2 0 0 0 2 1 110010055002010 2 207 207 2 psa_24 2D3
1235 1235 1000000US110010036003002 Block 3002, Block Group 3, Census Tract 36, District of Columbia, District of Columbia 328 192 83 1 12 0 28 12 328 278 174 80 1 11 0 1 11 50 18 3 0 1 0 27 1 110010036003002 3 304 304 3 psa_36 3D1
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
1813 1813 1000000US110010012004026 Block 4026, Block Group 4, Census Tract 12, District of Columbia, District of Columbia 228 154 8 5 30 0 13 18 228 170 120 8 0 30 0 1 11 58 34 0 5 0 0 12 7 110010012004026 2 202 202 2 psa_52 2D1
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
3094 3094 1000000US110010042012005 Block 2005, Block Group 2, Census Tract 42.01, District of Columbia, District of Columbia 438 367 22 1 29 0 8 11 438 411 347 22 1 29 0 1 11 27 20 0 0 0 0 7 0 110010042012005 3 301 301 3 psa_31 3D3
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
3189 3189 1000000US110010028012002 Block 2002, Block Group 2, Census Tract 28.01, District of Columbia, District of Columbia 748 194 178 5 28 0 293 50 748 268 57 169 2 28 0 1 11 480 137 9 3 0 0 292 39 110010028012002 4 408 408 4 psa_39 4D3
3373 3373 1000000US110010015005009 Block 5009, Block Group 5, Census Tract 15, District of Columbia, District of Columbia 136 120 0 0 0 0 4 12 136 128 113 0 0 0 0 4 11 8 7 0 0 0 0 0 1 110010015005009 2 201 201 2 psa_55 2D1
3470 3470 1000000US110010040022002 Block 2002, Block Group 2, Census Tract 40.02, District of Columbia, District of Columbia 420 327 52 1 23 0 3 14 420 404 317 52 0 23 0 1 11 16 10 0 1 0 0 2 3 110010040022002 3 303 303 3 psa_37 3D3
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
4013 4013 1000000US110010042012003 Block 2003, Block Group 2, Census Tract 42.01, District of Columbia, District of Columbia 446 393 11 2 19 0 9 12 446 417 374 11 1 19 0 1 11 29 19 0 1 0 0 8 1 110010042012003 3 301 301 3 psa_31 3D3
4126 4126 1000000US110010074062000 Block 2000, Block Group 2, Census Tract 74.06, District of Columbia, District of Columbia 1624 7 1584 4 2 0 12 15 1624 1595 2 1574 4 2 0 2 11 29 5 10 0 0 0 10 4 110010074062000 7 703 703 7 psa_8 7D1
4178 4178 1000000US110010018042000 Block 2000, Block Group 2, Census Tract 18.04, District of Columbia, District of Columbia 581 51 426 3 16 0 66 19 581 457 9 417 0 16 0 4 11 124 42 9 3 0 0 62 8 110010018042000 4 401 401 4 psa_56 4D1
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
4743 4743 1000000US110010034002004 Block 2004, Block Group 2, Census Tract 34, District of Columbia, District of Columbia 242 10 208 1 8 1 1 13 242 228 10 196 1 8 1 1 11 14 0 12 0 0 0 0 2 110010034002004 3 306 306 3 psa_38 3D2
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
5143 5143 1000000US110010028022000 Block 2000, Block Group 2, Census Tract 28.02, District of Columbia, District of Columbia 568 273 135 6 22 0 112 20 568 387 216 134 3 22 0 1 11 181 57 1 3 0 0 111 9 110010028022000 4 408 408 4 psa_39 4D3
5336 5336 1000000US110010047021008 Block 1008, Block Group 1, Census Tract 47.02, District of Columbia, District of Columbia 371 225 47 0 80 0 5 14 371 359 218 46 0 80 0 4 11 12 7 1 0 0 0 1 3 110010047021008 1 101 101 1 psa_20 1D1
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
5415 5415 1000000US110010073011109 Block 1109, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 340 175 100 1 15 6 20 23 340 280 148 95 1 15 6 4 11 60 27 5 0 0 0 16 12 110010073011109 7 708 708 7 psa_1 7D3
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
6025 6025 1000000US110010092011003 Block 1003, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 324 279 12 0 10 0 12 11 324 298 264 11 0 9 0 3 11 26 15 1 0 1 0 9 0 110010092011003 5 502 502 5 psa_40 5D1
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
);