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

25 rows where P005011 = 17 sorted by GIS_ID

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003003, P003004, P003005, P003006, P003007, P003008, P005001, P005004, P005005, P005007, P005008, P005009, P005010, P005012, P005014, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005006 ✖

P005013 ✖

P005011 ✖

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
5883 5883 1000000US110010098072000 Block 2000, Block Group 2, Census Tract 98.07, District of Columbia, District of Columbia 408 23 367 2 0 0 2 14 408 379 6 358 2 0 0 0 13 29 17 9 0 0 0 2 1 110010098072000 7 708 708 7 psa_1 7D3
2981 2981 1000000US110010102001021 Block 1021, Block Group 1, Census Tract 102, District of Columbia, District of Columbia 440 220 177 1 22 0 0 20 440 416 203 174 1 22 0 0 16 24 17 3 0 0 0 0 4 110010102001021 1 103 103 1 psa_12 1D1
3794 3794 1000000US110010069001017 Block 1017, Block Group 1, Census Tract 69, District of Columbia, District of Columbia 273 63 193 1 5 0 0 11 273 253 46 192 1 5 0 0 9 20 17 1 0 0 0 0 2 110010069001017 1 107 107 1 psa_16 1D2
2634 2634 1000000US110010107001007 Block 1007, Block Group 1, Census Tract 107, District of Columbia, District of Columbia 255 211 11 0 29 0 0 4 255 237 194 11 0 29 0 0 3 18 17 0 0 0 0 0 1 110010107001007 2 207 207 2 psa_24 2D3
4175 4175 1000000US110010050023006 Block 3006, Block Group 3, Census Tract 50.02, District of Columbia, District of Columbia 148 45 34 0 0 0 61 8 148 63 28 32 0 0 0 1 2 85 17 2 0 0 0 60 6 110010050023006 3 307 307 3 psa_28 3D3
323 323 1000000US110010003003005 Block 3005, Block Group 3, Census Tract 3, District of Columbia, District of Columbia 82 73 0 0 4 0 0 5 82 65 56 0 0 4 0 0 5 17 17 0 0 0 0 0 0 110010003003005 2 206 206 2 psa_29 2D2
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
1252 1252 1000000US110010043002006 Block 2006, Block Group 2, Census Tract 43, District of Columbia, District of Columbia 225 148 52 1 8 0 10 6 225 194 131 51 0 8 0 0 4 31 17 1 1 0 0 10 2 110010043002006 3 301 301 3 psa_31 3D3
9 9 1000000US110010042022002 Block 2002, Block Group 2, Census Tract 42.02, District of Columbia, District of Columbia 168 137 11 0 9 0 6 5 168 144 120 11 0 9 0 0 4 24 17 0 0 0 0 6 1 110010042022002 2 208 208 2 psa_33 2D3
1032 1032 1000000US110010053012004 Block 2004, Block Group 2, Census Tract 53.01, District of Columbia, District of Columbia 417 336 16 2 36 0 8 19 417 392 319 16 2 36 0 1 18 25 17 0 0 0 0 7 1 110010053012004 2 208 208 2 psa_33 2D3
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
5724 5724 1000000US110010038003007 Block 3007, Block Group 3, Census Tract 38, District of Columbia, District of Columbia 188 104 49 0 8 0 18 9 188 153 87 45 0 8 0 5 8 35 17 4 0 0 0 13 1 110010038003007 3 303 303 3 psa_37 3D3
2439 2439 1000000US110010028012007 Block 2007, Block Group 2, Census Tract 28.01, District of Columbia, District of Columbia 145 51 39 1 19 0 27 8 145 96 34 37 1 19 0 2 3 49 17 2 0 0 0 25 5 110010028012007 4 408 408 4 psa_39 4D3
441 441 1000000US110010032003004 Block 3004, Block Group 3, Census Tract 32, District of Columbia, District of Columbia 172 39 94 0 0 0 29 10 172 114 22 91 0 0 0 1 0 58 17 3 0 0 0 28 10 110010032003004 4 409 409 4 psa_41 4D3
5692 5692 1000000US110010032004001 Block 4001, Block Group 4, Census Tract 32, District of Columbia, District of Columbia 435 78 228 2 4 0 115 8 435 290 61 222 1 4 0 0 2 145 17 6 1 0 0 115 6 110010032004001 4 409 409 4 psa_41 4D3
1954 1954 1000000US110010027021005 Block 1005, Block Group 1, Census Tract 27.02, District of Columbia, District of Columbia 97 82 11 0 2 0 0 2 97 79 65 10 0 2 0 0 2 18 17 1 0 0 0 0 0 110010027021005 3 302 302 3 psa_42 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
333 333 1000000US110010007013000 Block 3000, Block Group 3, Census Tract 7.01, District of Columbia, District of Columbia 710 651 14 1 27 0 10 7 710 683 634 14 0 27 0 2 6 27 17 0 1 0 0 8 1 110010007013000 2 204 204 2 psa_44 2D2
4327 4327 1000000US110010005021011 Block 1011, Block Group 1, Census Tract 5.02, District of Columbia, District of Columbia 287 236 12 0 20 0 6 13 287 261 219 12 0 20 0 0 10 26 17 0 0 0 0 6 3 110010005021011 2 204 204 2 psa_44 2D2
2955 2955 1000000US110010009021002 Block 1002, Block Group 1, Census Tract 9.02, District of Columbia, District of Columbia 179 160 8 0 5 0 0 6 179 158 143 6 0 5 0 0 4 21 17 2 0 0 0 0 2 110010009021002 2 205 205 2 psa_46 2D2
6044 6044 1000000US110010008014000 Block 4000, Block Group 4, Census Tract 8.01, District of Columbia, District of Columbia 446 375 42 0 21 0 0 8 446 422 358 36 0 21 0 0 7 24 17 6 0 0 0 0 1 110010008014000 2 205 205 2 psa_46 2D2
2023 2023 1000000US110010025012012 Block 2012, Block Group 2, Census Tract 25.01, District of Columbia, District of Columbia 198 79 88 0 0 0 26 5 198 154 62 87 0 0 0 0 5 44 17 1 0 0 0 26 0 110010025012012 4 404 404 4 psa_48 4D3
2390 2390 1000000US110010025022005 Block 2005, Block Group 2, Census Tract 25.02, District of Columbia, District of Columbia 74 32 39 0 0 0 0 3 74 57 15 39 0 0 0 0 3 17 17 0 0 0 0 0 0 110010025022005 4 404 404 4 psa_48 4D3
2267 2267 1000000US110010021014009 Block 4009, Block Group 4, Census Tract 21.01, District of Columbia, District of Columbia 117 21 75 2 0 0 18 1 117 75 4 69 2 0 0 0 0 42 17 6 0 0 0 18 1 110010021014009 4 403 403 4 psa_51 4D1
1737 1737 1000000US110010018041005 Block 1005, Block Group 1, Census Tract 18.04, District of Columbia, District of Columbia 116 22 83 0 0 0 5 6 116 88 5 81 0 0 0 0 2 28 17 2 0 0 0 5 4 110010018041005 4 402 402 4 psa_53 4D1

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