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 P005008 = 0 and P005009 = 9 sorted by PSA

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003004, P003005, P003006, P003007, P003008, 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
224 224 1000000US110010084021005 Block 1005, Block Group 1, Census Tract 84.02, District of Columbia, District of Columbia 245 118 103 3 10 1 1 9 245 236 113 101 2 10 1 0 9 9 5 2 1 0 0 1 0 110010084021005 1 104 104 1 psa_21 1D2
959 959 1000000US110010084101002 Block 1002, Block Group 1, Census Tract 84.10, District of Columbia, District of Columbia 135 51 66 1 5 0 3 9 135 129 48 66 1 5 0 0 9 6 3 0 0 0 0 3 0 110010084101002 1 104 104 1 psa_21 1D2
3082 3082 1000000US110010084022005 Block 2005, Block Group 2, Census Tract 84.02, District of Columbia, District of Columbia 110 80 16 0 5 0 0 9 110 107 78 15 0 5 0 0 9 3 2 1 0 0 0 0 0 110010084022005 1 104 104 1 psa_21 1D2
6010 6010 1000000US110010071002008 Block 2008, Block Group 2, Census Tract 71, District of Columbia, District of Columbia 76 33 23 0 1 0 0 19 76 62 29 23 0 1 0 0 9 14 4 0 0 0 0 0 10 110010071002008 1 106 106 1 psa_13 1D3
85 85 1000000US110010067002004 Block 2004, Block Group 2, Census Tract 67, District of Columbia, District of Columbia 158 125 14 1 6 1 0 11 158 154 123 14 1 6 1 0 9 4 2 0 0 0 0 0 2 110010067002004 1 107 107 1 psa_16 1D2
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
5941 5941 1000000US110010080012011 Block 2011, Block Group 2, Census Tract 80.01, District of Columbia, District of Columbia 127 71 44 0 3 0 0 9 127 125 69 44 0 3 0 0 9 2 2 0 0 0 0 0 0 110010080012011 1 108 108 1 psa_17 1D2
4805 4805 1000000US110010015001033 Block 1033, Block Group 1, Census Tract 15, District of Columbia, District of Columbia 86 70 4 0 1 0 1 10 86 77 64 3 0 1 0 0 9 9 6 1 0 0 0 1 1 110010015001033 2 201 201 2 psa_55 2D1
2511 2511 1000000US110010010015002 Block 5002, Block Group 5, Census Tract 10.01, District of Columbia, District of Columbia 72 51 5 0 7 0 0 9 72 69 48 5 0 7 0 0 9 3 3 0 0 0 0 0 0 110010010015002 2 202 202 2 psa_52 2D1
5497 5497 1000000US110010010012030 Block 2030, Block Group 2, Census Tract 10.01, District of Columbia, District of Columbia 183 137 34 1 2 0 0 9 183 176 130 34 1 2 0 0 9 7 7 0 0 0 0 0 0 110010010012030 2 202 202 2 psa_52 2D1
778 778 1000000US110010013012000 Block 2000, Block Group 2, Census Tract 13.01, District of Columbia, District of Columbia 207 161 27 2 5 0 2 10 207 182 140 27 1 5 0 0 9 25 21 0 1 0 0 2 1 110010013012000 2 203 203 2 psa_50 2D1
2626 2626 1000000US110010008014004 Block 4004, Block Group 4, Census Tract 8.01, District of Columbia, District of Columbia 282 218 20 0 29 0 5 10 282 261 203 20 0 29 0 0 9 21 15 0 0 0 0 5 1 110010008014004 2 205 205 2 psa_46 2D2
539 539 1000000US110010108003001 Block 3001, Block Group 3, Census Tract 108.00, District of Columbia, District of Columbia 200 173 9 0 9 0 0 9 200 200 173 9 0 9 0 0 9 0 0 0 0 0 0 0 0 110010108003001 2 207 207 2 psa_24 2D3
4765 4765 1000000US110010055002001 Block 2001, Block Group 2, Census Tract 55, District of Columbia, District of Columbia 171 132 9 0 21 0 0 9 171 157 118 9 0 21 0 0 9 14 14 0 0 0 0 0 0 110010055002001 2 207 207 2 psa_24 2D3
4898 4898 1000000US110010055002005 Block 2005, Block Group 2, Census Tract 55, District of Columbia, District of Columbia 335 286 7 1 30 0 1 10 335 312 267 7 0 29 0 0 9 23 19 0 1 1 0 1 1 110010055002005 2 207 207 2 psa_24 2D3
2086 2086 1000000US110010029001007 Block 1007, Block Group 1, Census Tract 29, District of Columbia, District of Columbia 162 104 29 1 4 0 14 10 162 138 95 29 1 4 0 0 9 24 9 0 0 0 0 14 1 110010029001007 3 302 302 3 psa_42 3D1
3065 3065 1000000US110010028022001 Block 2001, Block Group 2, Census Tract 28.02, District of Columbia, District of Columbia 772 288 78 19 30 0 305 52 772 250 138 71 2 30 0 0 9 522 150 7 17 0 0 305 43 110010028022001 3 302 302 3 psa_42 3D1
4191 4191 1000000US110010027022007 Block 2007, Block Group 2, Census Tract 27.02, District of Columbia, District of Columbia 295 147 129 2 4 0 2 11 295 283 142 126 2 4 0 0 9 12 5 3 0 0 0 2 2 110010027022007 3 302 302 3 psa_42 3D1
5200 5200 1000000US110010030002004 Block 2004, Block Group 2, Census Tract 30, District of Columbia, District of Columbia 242 93 49 2 5 0 73 20 242 139 77 48 0 5 0 0 9 103 16 1 2 0 0 73 11 110010030002004 3 302 302 3 psa_42 3D1
1749 1749 1000000US110010040011001 Block 1001, Block Group 1, Census Tract 40.01, District of Columbia, District of Columbia 323 295 5 0 12 0 0 11 323 300 274 5 0 12 0 0 9 23 21 0 0 0 0 0 2 110010040011001 3 303 303 3 psa_37 3D3
5956 5956 1000000US110010039003003 Block 3003, Block Group 3, Census Tract 39, District of Columbia, District of Columbia 301 218 32 4 12 0 18 17 301 242 189 30 2 12 0 0 9 59 29 2 2 0 0 18 8 110010039003003 3 303 303 3 psa_37 3D3
3708 3708 1000000US110010034002023 Block 2023, Block Group 2, Census Tract 34, District of Columbia, District of Columbia 154 63 72 0 3 0 1 15 154 143 60 71 0 3 0 0 9 11 3 1 0 0 0 1 6 110010034002023 3 306 306 3 psa_38 3D2
1526 1526 1000000US110010050012005 Block 2005, Block Group 2, Census Tract 50.01, District of Columbia, District of Columbia 206 129 40 0 22 0 6 9 206 187 117 39 0 22 0 0 9 19 12 1 0 0 0 6 0 110010050012005 3 307 307 3 psa_28 3D3
24 24 1000000US110010048021006 Block 1006, Block Group 1, Census Tract 48.02, District of Columbia, District of Columbia 407 282 55 1 41 1 17 10 407 375 269 55 1 41 0 0 9 32 13 0 0 0 1 17 1 110010048021006 3 308 308 3 psa_27 3D2
6041 6041 1000000US110010017022000 Block 2000, Block Group 2, Census Tract 17.02, District of Columbia, District of Columbia 184 53 103 0 10 0 7 11 184 167 46 103 0 9 0 0 9 17 7 0 0 1 0 7 2 110010017022000 4 401 401 4 psa_56 4D1
4401 4401 1000000US110010019012000 Block 2000, Block Group 2, Census Tract 19.01, District of Columbia, District of Columbia 121 13 99 0 0 0 0 9 121 121 13 99 0 0 0 0 9 0 0 0 0 0 0 0 0 110010019012000 4 402 402 4 psa_53 4D1
2351 2351 1000000US110010020022003 Block 2003, Block Group 2, Census Tract 20.02, District of Columbia, District of Columbia 237 56 80 0 0 7 44 50 237 96 8 79 0 0 0 0 9 141 48 1 0 0 7 44 41 110010020022003 4 403 403 4 psa_51 4D1
4363 4363 1000000US110010095041002 Block 1002, Block Group 1, Census Tract 95.04, District of Columbia, District of Columbia 106 29 67 1 0 0 0 9 106 103 27 66 1 0 0 0 9 3 2 1 0 0 0 0 0 110010095041002 4 405 405 4 psa_49 4D2
614 614 1000000US110010095041008 Block 1008, Block Group 1, Census Tract 95.04, District of Columbia, District of Columbia 58 13 32 0 4 0 0 9 58 58 13 32 0 4 0 0 9 0 0 0 0 0 0 0 0 110010095041008 5 504 504 5 psa_43 5D2
4372 4372 1000000US110010088024000 Block 4000, Block Group 4, Census Tract 88.02, District of Columbia, District of Columbia 268 23 227 0 1 4 4 9 268 250 12 224 0 1 4 0 9 18 11 3 0 0 0 4 0 110010088024000 5 506 506 5 psa_26 5D3
291 291 1000000US110010096021000 Block 1000, Block Group 1, Census Tract 96.02, District of Columbia, District of Columbia 408 4 389 3 1 0 0 11 408 399 1 388 0 1 0 0 9 9 3 1 3 0 0 0 2 110010096021000 6 601 601 6 psa_30 6D1
736 736 1000000US110010077081002 Block 1002, Block Group 1, Census Tract 77.08, District of Columbia, District of Columbia 227 0 217 0 0 0 0 10 227 226 0 217 0 0 0 0 9 1 0 0 0 0 0 0 1 110010077081002 6 603 603 6 psa_15 6D3
2058 2058 1000000US110010099053004 Block 3004, Block Group 3, Census Tract 99.05, District of Columbia, District of Columbia 227 0 218 0 0 0 0 9 227 225 0 216 0 0 0 0 9 2 0 2 0 0 0 0 0 110010099053004 6 604 604 6 psa_14 6D3
2608 2608 1000000US110010077071011 Block 1011, Block Group 1, Census Tract 77.07, District of Columbia, District of Columbia 165 4 151 0 0 0 0 10 165 164 4 151 0 0 0 0 9 1 0 0 0 0 0 0 1 110010077071011 6 604 604 6 psa_14 6D3
173 173 1000000US110010076042018 Block 2018, Block Group 2, Census Tract 76.04, District of Columbia, District of Columbia 415 6 397 0 3 0 0 9 415 415 6 397 0 3 0 0 9 0 0 0 0 0 0 0 0 110010076042018 6 606 606 6 psa_7 6D2
1211 1211 1000000US110010075041009 Block 1009, Block Group 1, Census Tract 75.04, District of Columbia, District of Columbia 165 2 153 0 0 0 0 10 165 164 2 153 0 0 0 0 9 1 0 0 0 0 0 0 1 110010075041009 7 701 701 7 psa_9 7D1
6347 6347 1000000US110010075032005 Block 2005, Block Group 2, Census Tract 75.03, District of Columbia, District of Columbia 287 2 274 0 0 0 0 11 287 277 1 267 0 0 0 0 9 10 1 7 0 0 0 0 2 110010075032005 7 701 701 7 psa_9 7D1
2702 2702 1000000US110010075022009 Block 2009, Block Group 2, Census Tract 75.02, District of Columbia, District of Columbia 485 9 462 0 3 0 0 11 485 477 7 458 0 3 0 0 9 8 2 4 0 0 0 0 2 110010075022009 7 702 702 7 psa_6 7D1
3064 3064 1000000US110010073011035 Block 1035, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 31 17 4 0 0 0 0 10 31 27 14 4 0 0 0 0 9 4 3 0 0 0 0 0 1 110010073011035 7 707 707 7 psa_4 7D2
4507 4507 1000000US110010073011142 Block 1142, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 97 55 16 0 12 0 0 14 97 83 51 14 0 9 0 0 9 14 4 2 0 3 0 0 5 110010073011142 7 707 707 7 psa_4 7D2

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