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

37 rows where P005008 = 3 and P005017 = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003005, P003006, P003007, P003008, P005003, P005004, P005005, P005006, P005007, P005009, P005010, P005011, P005012, P005013, P005014, P005016, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005017 ✖

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
48 48 1000000US110010053014002 Block 4002, Block Group 4, Census Tract 53.01, District of Columbia, District of Columbia 167 132 3 0 15 0 11 6 167 150 123 3 0 15 0 3 6 17 9 0 0 0 0 8 0 110010053014002 3 301 301 3 psa_31 3D3
181 181 1000000US110010077071002 Block 1002, Block Group 1, Census Tract 77.07, District of Columbia, District of Columbia 761 4 740 0 0 0 3 14 761 760 4 739 0 0 0 3 14 1 0 1 0 0 0 0 0 110010077071002 6 604 604 6 psa_14 6D3
243 243 1000000US110010090002002 Block 2002, Block Group 2, Census Tract 90, District of Columbia, District of Columbia 630 7 588 0 0 0 16 19 630 613 6 585 0 0 0 3 19 17 1 3 0 0 0 13 0 110010090002002 5 503 503 5 psa_45 5D2
360 360 1000000US110010011001019 Block 1019, Block Group 1, Census Tract 11, District of Columbia, District of Columbia 89 86 0 0 0 0 3 0 89 82 79 0 0 0 0 3 0 7 7 0 0 0 0 0 0 110010011001019 2 201 201 2 psa_55 2D1
632 632 1000000US110010074072004 Block 2004, Block Group 2, Census Tract 74.07, District of Columbia, District of Columbia 17 0 14 0 0 0 3 0 17 17 0 14 0 0 0 3 0 0 0 0 0 0 0 0 0 110010074072004 7 703 703 7 psa_8 7D1
820 820 1000000US110010076052003 Block 2003, Block Group 2, Census Tract 76.05, District of Columbia, District of Columbia 416 9 403 1 0 0 3 0 416 411 4 403 1 0 0 3 0 5 5 0 0 0 0 0 0 110010076052003 6 606 606 6 psa_7 6D2
1091 1091 1000000US110010017021002 Block 1002, Block Group 1, Census Tract 17.02, District of Columbia, District of Columbia 22 5 12 0 0 0 4 1 22 21 5 12 0 0 0 3 1 1 0 0 0 0 0 1 0 110010017021002 4 401 401 4 psa_56 4D1
1535 1535 1000000US110010046002018 Block 2018, Block Group 2, Census Tract 46, District of Columbia, District of Columbia 86 37 37 0 4 0 4 4 86 81 33 37 0 4 0 3 4 5 4 0 0 0 0 1 0 110010046002018 3 308 308 3 psa_27 3D2
1757 1757 1000000US110010065002013 Block 2013, Block Group 2, Census Tract 65, District of Columbia, District of Columbia 174 158 13 0 0 0 3 0 174 167 151 13 0 0 0 3 0 7 7 0 0 0 0 0 0 110010065002013 1 106 106 1 psa_13 1D3
1938 1938 1000000US110010016001019 Block 1019, Block Group 1, Census Tract 16, District of Columbia, District of Columbia 17 5 7 0 0 0 3 2 17 17 5 7 0 0 0 3 2 0 0 0 0 0 0 0 0 110010016001019 4 401 401 4 psa_56 4D1
2429 2429 1000000US110010099021008 Block 1008, Block Group 1, Census Tract 99.02, District of Columbia, District of Columbia 195 2 186 2 0 0 4 1 195 194 2 186 2 0 0 3 1 1 0 0 0 0 0 1 0 110010099021008 6 605 605 6 psa_11 6D2
3038 3038 1000000US110010067001004 Block 1004, Block Group 1, Census Tract 67, District of Columbia, District of Columbia 264 219 31 2 2 1 8 1 264 246 206 31 2 2 1 3 1 18 13 0 0 0 0 5 0 110010067001004 1 107 107 1 psa_16 1D2
3145 3145 1000000US110010022013006 Block 3006, Block Group 3, Census Tract 22.01, District of Columbia, District of Columbia 101 7 79 0 11 0 4 0 101 100 7 79 0 11 0 3 0 1 0 0 0 0 0 1 0 110010022013006 4 407 407 4 psa_47 4D2
3322 3322 1000000US110010044001006 Block 1006, Block Group 1, Census Tract 44, District of Columbia, District of Columbia 535 410 50 1 48 0 18 8 535 493 383 50 1 48 0 3 8 42 27 0 0 0 0 15 0 110010044001006 3 305 305 3 psa_32 3D2
3544 3544 1000000US110010004001012 Block 1012, Block Group 1, Census Tract 4, District of Columbia, District of Columbia 41 37 0 0 1 0 3 0 41 36 32 0 0 1 0 3 0 5 5 0 0 0 0 0 0 110010004001012 2 204 204 2 psa_44 2D2
3934 3934 1000000US110010021022009 Block 2009, Block Group 2, Census Tract 21.02, District of Columbia, District of Columbia 223 30 159 0 6 0 23 5 223 195 25 156 0 6 0 3 5 28 5 3 0 0 0 20 0 110010021022009 4 403 403 4 psa_51 4D1
4066 4066 1000000US110010092032003 Block 2003, Block Group 2, Census Tract 92.03, District of Columbia, District of Columbia 107 10 86 0 0 0 11 0 107 95 9 83 0 0 0 3 0 12 1 3 0 0 0 8 0 110010092032003 5 502 502 5 psa_40 5D1
4116 4116 1000000US110010095051008 Block 1008, Block Group 1, Census Tract 95.05, District of Columbia, District of Columbia 176 4 156 0 2 0 14 0 176 165 4 156 0 2 0 3 0 11 0 0 0 0 0 11 0 110010095051008 4 406 406 4 psa_54 4D2
4173 4173 1000000US110010106002050 Block 2050, Block Group 2, Census Tract 106, District of Columbia, District of Columbia 64 31 23 0 4 0 4 2 64 63 31 23 0 4 0 3 2 1 0 0 0 0 0 1 0 110010106002050 1 104 104 1 psa_21 1D2
4228 4228 1000000US110010099031000 Block 1000, Block Group 1, Census Tract 99.03, District of Columbia, District of Columbia 404 8 379 2 0 0 3 12 404 398 7 375 1 0 0 3 12 6 1 4 1 0 0 0 0 110010099031000 6 604 604 6 psa_14 6D3
4288 4288 1000000US110010013012001 Block 2001, Block Group 2, Census Tract 13.01, District of Columbia, District of Columbia 37 28 5 0 1 0 3 0 37 37 28 5 0 1 0 3 0 0 0 0 0 0 0 0 0 110010013012001 2 203 203 2 psa_50 2D1
4339 4339 1000000US110010095031012 Block 1012, Block Group 1, Census Tract 95.03, District of Columbia, District of Columbia 78 14 54 0 3 0 3 4 78 77 13 54 0 3 0 3 4 1 1 0 0 0 0 0 0 110010095031012 4 405 405 4 psa_49 4D2
4373 4373 1000000US110010095082007 Block 2007, Block Group 2, Census Tract 95.08, District of Columbia, District of Columbia 82 7 68 0 0 0 6 1 82 77 5 68 0 0 0 3 1 5 2 0 0 0 0 3 0 110010095082007 4 406 406 4 psa_54 4D2
4548 4548 1000000US110010012001009 Block 1009, Block Group 1, Census Tract 12, District of Columbia, District of Columbia 38 28 0 0 3 0 5 2 38 34 26 0 0 3 0 3 2 4 2 0 0 0 0 2 0 110010012001009 2 203 203 2 psa_50 2D1
4611 4611 1000000US110010075022003 Block 2003, Block Group 2, Census Tract 75.02, District of Columbia, District of Columbia 144 3 134 0 0 0 3 4 144 141 2 132 0 0 0 3 4 3 1 2 0 0 0 0 0 110010075022003 7 702 702 7 psa_6 7D1
4636 4636 1000000US110010004001020 Block 1020, Block Group 1, Census Tract 4, District of Columbia, District of Columbia 111 88 11 1 6 0 4 1 111 101 80 11 0 6 0 3 1 10 8 0 1 0 0 1 0 110010004001020 2 204 204 2 psa_44 2D2
4701 4701 1000000US110010034001004 Block 1004, Block Group 1, Census Tract 34, District of Columbia, District of Columbia 147 52 80 0 6 0 5 4 147 134 46 79 0 2 0 3 4 13 6 1 0 4 0 2 0 110010034001004 3 306 306 3 psa_38 3D2
4711 4711 1000000US110010048011005 Block 1005, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 232 48 154 3 4 0 18 5 232 211 44 154 1 4 0 3 5 21 4 0 2 0 0 15 0 110010048011005 3 308 308 3 psa_27 3D2
4789 4789 1000000US110010089032002 Block 2002, Block Group 2, Census Tract 89.03, District of Columbia, District of Columbia 658 1 644 1 0 0 4 8 658 654 1 641 1 0 0 3 8 4 0 3 0 0 0 1 0 110010089032002 5 507 507 5 psa_23 5D3
5018 5018 1000000US110010011004016 Block 4016, Block Group 4, Census Tract 11, District of Columbia, District of Columbia 60 47 7 0 0 0 3 3 60 56 43 7 0 0 0 3 3 4 4 0 0 0 0 0 0 110010011004016 2 202 202 2 psa_52 2D1
5108 5108 1000000US110010020023007 Block 3007, Block Group 3, Census Tract 20.02, District of Columbia, District of Columbia 93 10 58 0 1 0 24 0 93 69 10 55 0 1 0 3 0 24 0 3 0 0 0 21 0 110010020023007 4 403 403 4 psa_51 4D1
5182 5182 1000000US110010053014003 Block 4003, Block Group 4, Census Tract 53.01, District of Columbia, District of Columbia 330 285 4 1 27 0 4 9 330 307 263 4 1 27 0 3 9 23 22 0 0 0 0 1 0 110010053014003 3 301 301 3 psa_31 3D3
5190 5190 1000000US110010010013011 Block 3011, Block Group 3, Census Tract 10.01, District of Columbia, District of Columbia 51 46 2 0 0 0 3 0 51 51 46 2 0 0 0 3 0 0 0 0 0 0 0 0 0 110010010013011 2 202 202 2 psa_52 2D1
5450 5450 1000000US110010052014001 Block 4001, Block Group 4, Census Tract 52.01, District of Columbia, District of Columbia 182 144 14 0 11 0 5 8 182 176 140 14 0 11 0 3 8 6 4 0 0 0 0 2 0 110010052014001 3 301 301 3 psa_31 3D3
6025 6025 1000000US110010092011003 Block 1003, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 324 279 12 0 10 0 12 11 324 298 264 11 0 9 0 3 11 26 15 1 0 1 0 9 0 110010092011003 5 502 502 5 psa_40 5D1
6482 6482 1000000US110010101001001 Block 1001, Block Group 1, Census Tract 101, District of Columbia, District of Columbia 201 154 17 0 20 0 6 4 201 182 138 17 0 20 0 3 4 19 16 0 0 0 0 3 0 110010101001001 2 209 209 2 psa_57 2D3
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
);