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 P005014 = 1 and POLDIST_ID = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003003, P003004, P003005, P003006, P003007, P003008, P005001, P005002, P005003, P005004, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005012, P005013, P005016, P005017, PSA, NAME, GIS_ID, SECTOR

POLDIST_ID ✖

P005014 ✖

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
6 6 1000000US110010042011004 Block 1004, Block Group 1, Census Tract 42.01, District of Columbia, District of Columbia 211 165 18 1 19 0 5 3 211 188 150 18 1 18 0 0 1 23 15 0 0 1 0 5 2 110010042011004 3 301 301 3 psa_31 3D3
26 26 1000000US110010048022004 Block 2004, Block Group 2, Census Tract 48.02, District of Columbia, District of Columbia 247 156 46 1 31 0 3 10 247 234 146 46 1 30 0 1 10 13 10 0 0 1 0 2 0 110010048022004 3 308 308 3 psa_27 3D2
49 49 1000000US110010053014005 Block 4005, Block Group 4, Census Tract 53.01, District of Columbia, District of Columbia 403 299 15 8 47 1 24 9 403 356 282 15 2 46 1 2 8 47 17 0 6 1 0 22 1 110010053014005 3 301 301 3 psa_31 3D3
889 889 1000000US110010037002000 Block 2000, Block Group 2, Census Tract 37, District of Columbia, District of Columbia 644 203 344 0 19 0 42 36 644 541 180 327 0 18 0 2 14 103 23 17 0 1 0 40 22 110010037002000 3 304 304 3 psa_36 3D1
993 993 1000000US110010038003005 Block 3005, Block Group 3, Census Tract 38, District of Columbia, District of Columbia 123 95 4 0 13 0 9 2 123 104 86 3 0 12 0 1 2 19 9 1 0 1 0 8 0 110010038003005 3 303 303 3 psa_37 3D3
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
1312 1312 1000000US110010053011000 Block 1000, Block Group 1, Census Tract 53.01, District of Columbia, District of Columbia 269 232 9 0 10 0 11 7 269 252 227 9 0 9 0 0 7 17 5 0 0 1 0 11 0 110010053011000 3 301 301 3 psa_31 3D3
2166 2166 1000000US110010034002018 Block 2018, Block Group 2, Census Tract 34, District of Columbia, District of Columbia 46 17 25 0 1 0 1 2 46 43 16 25 0 0 0 0 2 3 1 0 0 1 0 1 0 110010034002018 3 306 306 3 psa_38 3D2
2191 2191 1000000US110010037002004 Block 2004, Block Group 2, Census Tract 37, District of Columbia, District of Columbia 1086 222 738 4 25 0 69 28 1086 953 178 725 2 24 0 4 20 133 44 13 2 1 0 65 8 110010037002004 3 304 304 3 psa_36 3D1
2289 2289 1000000US110010030002003 Block 2003, Block Group 2, Census Tract 30, District of Columbia, District of Columbia 397 209 132 0 11 0 25 20 397 347 192 131 0 10 0 1 13 50 17 1 0 1 0 24 7 110010030002003 3 302 302 3 psa_42 3D1
2507 2507 1000000US110010038001000 Block 1000, Block Group 1, Census Tract 38, District of Columbia, District of Columbia 680 461 109 0 34 0 41 35 680 588 421 104 0 33 0 5 25 92 40 5 0 1 0 36 10 110010038001000 3 303 303 3 psa_37 3D3
2881 2881 1000000US110010053011001 Block 1001, Block Group 1, Census Tract 53.01, District of Columbia, District of Columbia 431 361 13 1 35 0 8 13 431 405 349 12 0 34 0 0 10 26 12 1 1 1 0 8 3 110010053011001 3 301 301 3 psa_31 3D3
2916 2916 1000000US110010037002003 Block 2003, Block Group 2, Census Tract 37, District of Columbia, District of Columbia 423 131 220 1 15 0 41 15 423 336 104 207 1 14 0 1 9 87 27 13 0 1 0 40 6 110010037002003 3 304 304 3 psa_36 3D1
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
4125 4125 1000000US110010043002003 Block 2003, Block Group 2, Census Tract 43, District of Columbia, District of Columbia 143 115 9 1 9 0 6 3 143 123 102 9 1 8 0 0 3 20 13 0 0 1 0 6 0 110010043002003 3 301 301 3 psa_31 3D3
4357 4357 1000000US110010042021000 Block 1000, Block Group 1, Census Tract 42.02, District of Columbia, District of Columbia 231 202 2 0 12 0 4 11 231 217 196 2 0 11 0 0 8 14 6 0 0 1 0 4 3 110010042021000 3 301 301 3 psa_31 3D3
4418 4418 1000000US110010034001002 Block 1002, Block Group 1, Census Tract 34, District of Columbia, District of Columbia 92 39 50 1 1 0 0 1 92 91 39 50 1 0 0 0 1 1 0 0 0 1 0 0 0 110010034001002 3 306 306 3 psa_38 3D2
4568 4568 1000000US110010044001017 Block 1017, Block Group 1, Census Tract 44, District of Columbia, District of Columbia 377 285 44 0 29 0 7 12 377 352 267 44 0 28 0 1 12 25 18 0 0 1 0 6 0 110010044001017 3 305 305 3 psa_32 3D2
4751 4751 1000000US110010039001003 Block 1003, Block Group 1, Census Tract 39, District of Columbia, District of Columbia 420 289 63 0 27 1 27 13 420 352 249 63 0 26 1 5 8 68 40 0 0 1 0 22 5 110010039001003 3 303 303 3 psa_37 3D3
4854 4854 1000000US110010028021001 Block 1001, Block Group 1, Census Tract 28.02, District of Columbia, District of Columbia 529 261 87 6 43 0 116 16 529 279 147 82 0 42 0 1 7 250 114 5 6 1 0 115 9 110010028021001 3 302 302 3 psa_42 3D1
5067 5067 1000000US110010046002015 Block 2015, Block Group 2, Census Tract 46, District of Columbia, District of Columbia 219 37 167 0 3 0 2 10 219 203 34 161 0 2 0 1 5 16 3 6 0 1 0 1 5 110010046002015 3 308 308 3 psa_27 3D2
5940 5940 1000000US110010027012002 Block 2002, Block Group 2, Census Tract 27.01, District of Columbia, District of Columbia 327 154 79 1 30 1 42 20 327 248 129 77 0 29 1 0 12 79 25 2 1 1 0 42 8 110010027012002 3 302 302 3 psa_42 3D1
6118 6118 1000000US110010034001003 Block 1003, Block Group 1, Census Tract 34, District of Columbia, District of Columbia 382 30 321 0 9 0 5 17 382 367 28 316 0 8 0 2 13 15 2 5 0 1 0 3 4 110010034001003 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
);