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

32 rows where P005009 = 7 and POLDIST_ID = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003004, P003005, P003006, P003007, P003008, P005003, P005004, P005005, P005006, P005007, P005008, P005010, P005011, P005012, P005013, P005014, P005015, P005016, P005017, PSA, NAME, GIS_ID, SECTOR

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
2 2 1000000US110010040021001 Block 1001, Block Group 1, Census Tract 40.02, District of Columbia, District of Columbia 407 346 27 1 17 0 9 7 407 362 313 23 1 17 0 1 7 45 33 4 0 0 0 8 0 110010040021001 3 303 303 3 psa_37 3D3
5 5 1000000US110010040022003 Block 2003, Block Group 2, Census Tract 40.02, District of Columbia, District of Columbia 315 239 24 1 35 0 9 7 315 288 221 24 1 35 0 0 7 27 18 0 0 0 0 9 0 110010040022003 3 303 303 3 psa_37 3D3
23 23 1000000US110010048011017 Block 1017, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 210 105 84 0 12 0 0 9 210 197 95 83 0 12 0 0 7 13 10 1 0 0 0 0 2 110010048011017 3 308 308 3 psa_27 3D2
34 34 1000000US110010050012004 Block 2004, Block Group 2, Census Tract 50.01, District of Columbia, District of Columbia 155 115 19 2 11 0 0 8 155 147 111 18 0 11 0 0 7 8 4 1 2 0 0 0 1 110010050012004 3 307 307 3 psa_28 3D3
36 36 1000000US110010050021002 Block 1002, Block Group 1, Census Tract 50.02, District of Columbia, District of Columbia 658 92 454 4 8 1 85 14 658 543 74 453 1 8 0 0 7 115 18 1 3 0 1 85 7 110010050021002 3 307 307 3 psa_28 3D3
42 42 1000000US110010050024000 Block 4000, Block Group 4, Census Tract 50.02, District of Columbia, District of Columbia 780 253 40 0 49 0 408 30 780 250 160 30 0 47 0 6 7 530 93 10 0 2 0 402 23 110010050024000 3 307 307 3 psa_28 3D3
433 433 1000000US110010027023001 Block 3001, Block Group 3, Census Tract 27.02, District of Columbia, District of Columbia 186 129 34 0 8 0 4 11 186 156 108 33 0 8 0 0 7 30 21 1 0 0 0 4 4 110010027023001 3 302 302 3 psa_42 3D1
457 457 1000000US110010040011003 Block 1003, Block Group 1, Census Tract 40.01, District of Columbia, District of Columbia 331 276 19 2 18 1 6 9 331 311 264 19 2 18 1 0 7 20 12 0 0 0 0 6 2 110010040011003 3 303 303 3 psa_37 3D3
693 693 1000000US110010035001002 Block 1002, Block Group 1, Census Tract 35, District of Columbia, District of Columbia 248 24 161 2 5 0 45 11 248 193 19 161 1 5 0 0 7 55 5 0 1 0 0 45 4 110010035001002 3 304 304 3 psa_36 3D1
954 954 1000000US110010029002010 Block 2010, Block Group 2, Census Tract 29, District of Columbia, District of Columbia 176 107 45 2 6 0 7 9 176 152 96 43 0 6 0 0 7 24 11 2 2 0 0 7 2 110010029002010 3 302 302 3 psa_42 3D1
1158 1158 1000000US110010052012002 Block 2002, Block Group 2, Census Tract 52.01, District of Columbia, District of Columbia 172 143 5 0 14 1 2 7 172 154 127 5 0 14 1 0 7 18 16 0 0 0 0 2 0 110010052012002 3 301 301 3 psa_31 3D3
1286 1286 1000000US110010027022000 Block 2000, Block Group 2, Census Tract 27.02, District of Columbia, District of Columbia 270 224 18 3 5 0 9 11 270 228 198 18 0 5 0 0 7 42 26 0 3 0 0 9 4 110010027022000 3 302 302 3 psa_42 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
1442 1442 1000000US110010049022013 Block 2013, Block Group 2, Census Tract 49.02, District of Columbia, District of Columbia 371 278 22 3 45 0 11 12 371 331 255 22 0 45 0 2 7 40 23 0 3 0 0 9 5 110010049022013 3 307 307 3 psa_28 3D3
1600 1600 1000000US110010050024002 Block 4002, Block Group 4, Census Tract 50.02, District of Columbia, District of Columbia 302 169 78 0 29 0 19 7 302 245 132 77 0 29 0 0 7 57 37 1 0 0 0 19 0 110010050024002 3 307 307 3 psa_28 3D3
1671 1671 1000000US110010049012011 Block 2011, Block Group 2, Census Tract 49.01, District of Columbia, District of Columbia 123 84 21 0 5 0 5 8 123 103 69 21 0 5 0 1 7 20 15 0 0 0 0 4 1 110010049012011 3 307 307 3 psa_28 3D3
1779 1779 1000000US110010048011012 Block 1012, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 93 45 30 0 7 0 4 7 93 86 42 30 0 7 0 0 7 7 3 0 0 0 0 4 0 110010048011012 3 308 308 3 psa_27 3D2
1976 1976 1000000US110010033021003 Block 1003, Block Group 1, Census Tract 33.02, District of Columbia, District of Columbia 278 79 161 0 8 0 22 8 278 243 72 156 0 8 0 0 7 35 7 5 0 0 0 22 1 110010033021003 3 308 308 3 psa_27 3D2
2105 2105 1000000US110010042011000 Block 1000, Block Group 1, Census Tract 42.01, District of Columbia, District of Columbia 238 165 51 0 10 0 5 7 238 227 160 49 0 10 0 1 7 11 5 2 0 0 0 4 0 110010042011000 3 301 301 3 psa_31 3D3
2335 2335 1000000US110010031001017 Block 1017, Block Group 1, Census Tract 31, District of Columbia, District of Columbia 203 66 108 0 12 0 0 17 203 178 51 108 0 12 0 0 7 25 15 0 0 0 0 0 10 110010031001017 3 304 304 3 psa_36 3D1
2552 2552 1000000US110010038003004 Block 3004, Block Group 3, Census Tract 38, District of Columbia, District of Columbia 455 192 129 5 4 0 101 24 455 290 144 128 4 4 0 3 7 165 48 1 1 0 0 98 17 110010038003004 3 303 303 3 psa_37 3D3
3159 3159 1000000US110010033012000 Block 2000, Block Group 2, Census Tract 33.01, District of Columbia, District of Columbia 271 83 165 1 5 1 9 7 271 259 81 164 1 5 0 1 7 12 2 1 0 0 1 8 0 110010033012000 3 306 306 3 psa_38 3D2
3262 3262 1000000US110010027012005 Block 2005, Block Group 2, Census Tract 27.01, District of Columbia, District of Columbia 122 83 26 0 6 0 0 7 122 119 80 26 0 6 0 0 7 3 3 0 0 0 0 0 0 110010027012005 3 302 302 3 psa_42 3D1
3542 3542 1000000US110010039003002 Block 3002, Block Group 3, Census Tract 39, District of Columbia, District of Columbia 423 285 87 0 14 1 19 17 423 366 259 84 0 14 0 2 7 57 26 3 0 0 1 17 10 110010039003002 3 303 303 3 psa_37 3D3
4792 4792 1000000US110010033013003 Block 3003, Block Group 3, Census Tract 33.01, District of Columbia, District of Columbia 175 36 124 0 3 0 5 7 175 169 33 122 0 3 0 4 7 6 3 2 0 0 0 1 0 110010033013003 3 306 306 3 psa_38 3D2
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
4948 4948 1000000US110010044002018 Block 2018, Block Group 2, Census Tract 44, District of Columbia, District of Columbia 166 91 56 0 9 0 0 10 166 152 82 54 0 9 0 0 7 14 9 2 0 0 0 0 3 110010044002018 3 305 305 3 psa_32 3D2
5252 5252 1000000US110010035001000 Block 1000, Block Group 1, Census Tract 35, District of Columbia, District of Columbia 245 84 120 0 3 0 26 12 245 199 73 115 0 3 0 1 7 46 11 5 0 0 0 25 5 110010035001000 3 304 304 3 psa_36 3D1
5489 5489 1000000US110010036002002 Block 2002, Block Group 2, Census Tract 36, District of Columbia, District of Columbia 528 138 250 4 37 0 86 13 528 371 87 238 1 37 0 1 7 157 51 12 3 0 0 85 6 110010036002002 3 304 304 3 psa_36 3D1
6395 6395 1000000US110010034002026 Block 2026, Block Group 2, Census Tract 34, District of Columbia, District of Columbia 142 43 77 0 14 0 0 8 142 137 43 73 0 14 0 0 7 5 0 4 0 0 0 0 1 110010034002026 3 308 308 3 psa_27 3D2
6488 6488 1000000US110010035001004 Block 1004, Block Group 1, Census Tract 35, District of Columbia, District of Columbia 192 80 70 2 6 0 26 8 192 142 69 60 0 6 0 0 7 50 11 10 2 0 0 26 1 110010035001004 3 304 304 3 psa_36 3D1
6489 6489 1000000US110010048021001 Block 1001, Block Group 1, Census Tract 48.02, District of Columbia, District of Columbia 159 86 44 0 11 0 11 7 159 141 76 44 0 11 0 3 7 18 10 0 0 0 0 8 0 110010048021001 3 308 308 3 psa_27 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
);