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

22 rows where DISTRICT = 4 and P005012 = 6

✎ 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, P005008, P005009, P005010, P005011, P005013, P005014, P005016, P005017, PSA, NAME, GIS_ID, SECTOR

P005012 ✖

DISTRICT ✖

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
260 260 1000000US110010095011002 Block 1002, Block Group 1, Census Tract 95.01, District of Columbia, District of Columbia 116 5 83 1 0 0 25 2 116 83 5 77 1 0 0 0 0 33 0 6 0 0 0 25 2 110010095011002 4 405 405 4 psa_49 4D2
265 265 1000000US110010095013005 Block 3005, Block Group 3, Census Tract 95.01, District of Columbia, District of Columbia 361 98 245 0 2 0 9 7 361 340 93 239 0 2 0 0 6 21 5 6 0 0 0 9 1 110010095013005 4 405 405 4 psa_49 4D2
1049 1049 1000000US110010021022008 Block 2008, Block Group 2, Census Tract 21.02, District of Columbia, District of Columbia 161 14 140 0 0 0 5 2 161 146 11 134 0 0 0 0 1 15 3 6 0 0 0 5 1 110010021022008 4 403 403 4 psa_51 4D1
1113 1113 1000000US110010095091006 Block 1006, Block Group 1, Census Tract 95.09, District of Columbia, District of Columbia 139 0 138 0 1 0 0 0 139 133 0 132 0 1 0 0 0 6 0 6 0 0 0 0 0 110010095091006 4 405 405 4 psa_49 4D2
1667 1667 1000000US110010019013000 Block 3000, Block Group 3, Census Tract 19.01, District of Columbia, District of Columbia 129 20 82 0 0 0 17 10 129 100 17 76 0 0 0 0 7 29 3 6 0 0 0 17 3 110010019013000 4 402 402 4 psa_53 4D1
1696 1696 1000000US110010103003011 Block 3011, Block Group 3, Census Tract 103, District of Columbia, District of Columbia 401 71 216 13 7 2 71 21 401 279 45 210 5 7 2 1 9 122 26 6 8 0 0 70 12 110010103003011 4 401 401 4 psa_56 4D1
1945 1945 1000000US110010028011001 Block 1001, Block Group 1, Census Tract 28.01, District of Columbia, District of Columbia 234 62 104 4 6 0 47 11 234 164 52 98 4 6 0 2 2 70 10 6 0 0 0 45 9 110010028011001 4 408 408 4 psa_39 4D3
2236 2236 1000000US110010020022002 Block 2002, Block Group 2, Census Tract 20.02, District of Columbia, District of Columbia 198 19 149 0 0 0 23 7 198 161 13 143 0 0 0 0 5 37 6 6 0 0 0 23 2 110010020022002 4 403 403 4 psa_51 4D1
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
2538 2538 1000000US110010022022007 Block 2007, Block Group 2, Census Tract 22.02, District of Columbia, District of Columbia 67 2 51 0 0 0 11 3 67 46 1 45 0 0 0 0 0 21 1 6 0 0 0 11 3 110010022022007 4 407 407 4 psa_47 4D2
2837 2837 1000000US110010023011000 Block 1000, Block Group 1, Census Tract 23.01, District of Columbia, District of Columbia 174 15 134 0 1 0 20 4 174 139 10 128 0 1 0 0 0 35 5 6 0 0 0 20 4 110010023011000 4 407 407 4 psa_47 4D2
2906 2906 1000000US110010022023000 Block 3000, Block Group 3, Census Tract 22.02, District of Columbia, District of Columbia 128 9 113 0 0 0 0 6 128 121 8 107 0 0 0 0 6 7 1 6 0 0 0 0 0 110010022023000 4 407 407 4 psa_47 4D2
3167 3167 1000000US110010025023004 Block 3004, Block Group 3, Census Tract 25.02, District of Columbia, District of Columbia 273 72 120 0 6 0 54 21 273 161 35 114 0 5 0 2 5 112 37 6 0 1 0 52 16 110010025023004 4 404 404 4 psa_48 4D3
3536 3536 1000000US110010018043004 Block 3004, Block Group 3, Census Tract 18.04, District of Columbia, District of Columbia 487 50 342 2 1 0 72 20 487 365 17 336 2 1 0 6 3 122 33 6 0 0 0 66 17 110010018043004 4 402 402 4 psa_53 4D1
3651 3651 1000000US110010029002003 Block 2003, Block Group 2, Census Tract 29, District of Columbia, District of Columbia 109 48 41 1 2 0 12 5 109 70 30 35 0 2 0 0 3 39 18 6 1 0 0 12 2 110010029002003 4 408 408 4 psa_39 4D3
4245 4245 1000000US110010021012001 Block 2001, Block Group 2, Census Tract 21.01, District of Columbia, District of Columbia 284 42 140 2 9 0 75 16 284 172 20 134 2 9 0 1 6 112 22 6 0 0 0 74 10 110010021012001 4 403 403 4 psa_51 4D1
4289 4289 1000000US110010021011008 Block 1008, Block Group 1, Census Tract 21.01, District of Columbia, District of Columbia 145 3 119 0 8 0 11 4 145 124 3 113 0 8 0 0 0 21 0 6 0 0 0 11 4 110010021011008 4 403 403 4 psa_51 4D1
4333 4333 1000000US110010018042007 Block 2007, Block Group 2, Census Tract 18.04, District of Columbia, District of Columbia 86 16 56 2 5 0 6 1 86 62 5 50 1 5 0 1 0 24 11 6 1 0 0 5 1 110010018042007 4 402 402 4 psa_53 4D1
4376 4376 1000000US110010020023000 Block 3000, Block Group 3, Census Tract 20.02, District of Columbia, District of Columbia 98 15 70 0 0 0 7 6 98 69 3 64 0 0 0 0 2 29 12 6 0 0 0 7 4 110010020023000 4 403 403 4 psa_51 4D1
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
5700 5700 1000000US110010022012005 Block 2005, Block Group 2, Census Tract 22.01, District of Columbia, District of Columbia 143 15 100 0 7 0 18 3 143 105 3 94 0 7 0 0 1 38 12 6 0 0 0 18 2 110010022012005 4 407 407 4 psa_47 4D2
6244 6244 1000000US110010025023003 Block 3003, Block Group 3, Census Tract 25.02, District of Columbia, District of Columbia 271 71 134 2 7 0 47 10 271 209 59 128 2 7 0 7 6 62 12 6 0 0 0 40 4 110010025023003 4 404 404 4 psa_48 4D3

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