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

13 rows where P005012 = 2 and P005017 = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003004, P003005, P003007, P003008, P005001, P005003, P005005, P005006, P005008, P005009, P005010, P005011, P005013, P005014, P005016, DISTRICT, PSA, NAME, POLDIST_ID, 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
47 47 1000000US110010052013001 Block 3001, Block Group 3, Census Tract 52.01, District of Columbia, District of Columbia 661 537 38 2 54 0 11 19 661 597 487 36 2 53 0 2 17 64 50 2 0 1 0 9 2 110010052013001 2 208 208 2 psa_33 2D3
642 642 1000000US110010099061008 Block 1008, Block Group 1, Census Tract 99.06, District of Columbia, District of Columbia 165 2 159 0 0 0 0 4 165 161 2 157 0 0 0 0 2 4 0 2 0 0 0 0 2 110010099061008 6 604 604 6 psa_14 6D3
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
2651 2651 1000000US110010044002006 Block 2006, Block Group 2, Census Tract 44, District of Columbia, District of Columbia 111 78 19 1 2 0 4 7 111 104 78 17 1 2 0 1 5 7 0 2 0 0 0 3 2 110010044002006 3 305 305 3 psa_32 3D2
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
3551 3551 1000000US110010021026003 Block 6003, Block Group 6, Census Tract 21.02, District of Columbia, District of Columbia 161 25 107 0 0 0 25 4 161 126 19 105 0 0 0 0 2 35 6 2 0 0 0 25 2 110010021026003 4 403 403 4 psa_51 4D1
3588 3588 1000000US110010095091004 Block 1004, Block Group 1, Census Tract 95.09, District of Columbia, District of Columbia 111 7 86 2 0 0 14 2 111 88 2 84 1 0 0 1 0 23 5 2 1 0 0 13 2 110010095091004 4 405 405 4 psa_49 4D2
3922 3922 1000000US110010041001000 Block 1000, Block Group 1, Census Tract 41, District of Columbia, District of Columbia 452 383 14 0 32 0 7 16 452 405 345 12 0 32 0 2 14 47 38 2 0 0 0 5 2 110010041001000 2 208 208 2 psa_33 2D3
3982 3982 1000000US110010071001008 Block 1008, Block Group 1, Census Tract 71, District of Columbia, District of Columbia 249 98 119 3 4 0 17 8 249 221 91 117 3 4 0 0 6 28 7 2 0 0 0 17 2 110010071001008 1 106 106 1 psa_13 1D3
5011 5011 1000000US110010077034003 Block 4003, Block Group 4, Census Tract 77.03, District of Columbia, District of Columbia 439 8 424 0 0 0 1 6 439 432 6 422 0 0 0 0 4 7 2 2 0 0 0 1 2 110010077034003 6 603 603 6 psa_15 6D3
5104 5104 1000000US110010003002003 Block 2003, Block Group 2, Census Tract 3, District of Columbia, District of Columbia 134 103 12 0 9 0 3 7 134 114 92 10 0 7 0 0 5 20 11 2 0 2 0 3 2 110010003002003 2 204 204 2 psa_44 2D2
5280 5280 1000000US110010020022001 Block 2001, Block Group 2, Census Tract 20.02, District of Columbia, District of Columbia 178 25 112 0 1 0 37 3 178 135 22 110 0 1 0 1 1 43 3 2 0 0 0 36 2 110010020022001 4 403 403 4 psa_51 4D1
5736 5736 1000000US110010073011063 Block 1063, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 228 147 46 1 10 0 8 16 228 195 127 44 1 9 0 0 14 33 20 2 0 1 0 8 2 110010073011063 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
);