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 = 0 and P005017 = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003005, P003006, P003007, P003008, P005003, P005005, P005006, P005007, 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
339 339 1000000US110010008012009 Block 2009, Block Group 2, Census Tract 8.01, District of Columbia, District of Columbia 38 26 3 0 0 0 0 9 38 29 23 3 0 0 0 0 3 9 3 0 0 0 0 0 6 110010008012009 2 205 205 2 psa_46 2D2
2143 2143 1000000US110010111002003 Block 2003, Block Group 2, Census Tract 111, District of Columbia, District of Columbia 129 11 110 0 0 1 0 7 129 123 11 110 0 0 1 0 1 6 0 0 0 0 0 0 6 110010111002003 5 503 503 5 psa_45 5D2
2798 2798 1000000US110010020012011 Block 2011, Block Group 2, Census Tract 20.01, District of Columbia, District of Columbia 110 29 59 0 6 4 1 11 110 96 22 59 0 6 4 0 5 14 7 0 0 0 0 1 6 110010020012011 4 403 403 4 psa_51 4D1
3103 3103 1000000US110010049022004 Block 2004, Block Group 2, Census Tract 49.02, District of Columbia, District of Columbia 247 149 32 1 20 0 33 12 247 187 128 32 1 20 0 0 6 60 21 0 0 0 0 33 6 110010049022004 3 307 307 3 psa_28 3D3
3537 3537 1000000US110010027022002 Block 2002, Block Group 2, Census Tract 27.02, District of Columbia, District of Columbia 269 191 33 3 7 0 23 12 269 228 178 33 2 6 0 3 6 41 13 0 1 1 0 20 6 110010027022002 3 302 302 3 psa_42 3D1
4253 4253 1000000US110010095092010 Block 2010, Block Group 2, Census Tract 95.09, District of Columbia, District of Columbia 135 14 112 0 0 0 3 6 135 119 7 112 0 0 0 0 0 16 7 0 0 0 0 3 6 110010095092010 4 405 405 4 psa_49 4D2
4341 4341 1000000US110010032001001 Block 1001, Block Group 1, Census Tract 32, District of Columbia, District of Columbia 130 31 86 0 3 0 4 6 130 113 24 86 0 3 0 0 0 17 7 0 0 0 0 4 6 110010032001001 4 409 409 4 psa_41 4D3
5550 5550 1000000US110010095013000 Block 3000, Block Group 3, Census Tract 95.01, District of Columbia, District of Columbia 137 8 119 0 0 0 1 9 137 130 8 119 0 0 0 0 3 7 0 0 0 0 0 1 6 110010095013000 4 405 405 4 psa_49 4D2
5574 5574 1000000US110010078043012 Block 3012, Block Group 3, Census Tract 78.04, District of Columbia, District of Columbia 49 0 39 2 1 0 0 7 49 43 0 39 2 1 0 0 1 6 0 0 0 0 0 0 6 110010078043012 6 608 608 6 psa_19 6D1
6050 6050 1000000US110010076052000 Block 2000, Block Group 2, Census Tract 76.05, District of Columbia, District of Columbia 89 1 77 0 0 0 1 10 89 83 1 77 0 0 0 1 4 6 0 0 0 0 0 0 6 110010076052000 6 607 607 6 psa_10 6D2
6151 6151 1000000US110010055005001 Block 5001, Block Group 5, Census Tract 55, District of Columbia, District of Columbia 258 188 10 1 41 1 4 13 258 235 176 10 1 40 1 0 7 23 12 0 0 1 0 4 6 110010055005001 2 208 208 2 psa_33 2D3
6373 6373 1000000US110010087021003 Block 1003, Block Group 1, Census Tract 87.02, District of Columbia, District of Columbia 176 13 149 0 7 0 1 6 176 163 8 149 0 6 0 0 0 13 5 0 0 1 0 1 6 110010087021003 5 502 502 5 psa_40 5D1
6453 6453 1000000US110010075022006 Block 2006, Block Group 2, Census Tract 75.02, District of Columbia, District of Columbia 98 0 92 0 0 0 0 6 98 92 0 92 0 0 0 0 0 6 0 0 0 0 0 0 6 110010075022006 7 702 702 7 psa_6 7D1

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