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

18 rows where P005009 = 0 and P005012 = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003004, P003005, P003007, P003008, P005001, P005003, P005005, P005006, P005008, P005010, P005011, P005013, P005016, P005017, 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
239 239 1000000US110010090001002 Block 1002, Block Group 1, Census Tract 90, District of Columbia, District of Columbia 23 1 17 0 0 0 0 5 23 13 1 12 0 0 0 0 0 10 0 5 0 0 0 0 5 110010090001002 5 503 503 5 psa_45 5D2
477 477 1000000US110010099021012 Block 1012, Block Group 1, Census Tract 99.02, District of Columbia, District of Columbia 180 2 178 0 0 0 0 0 180 174 1 173 0 0 0 0 0 6 1 5 0 0 0 0 0 110010099021012 6 605 605 6 psa_11 6D2
768 768 1000000US110010078082007 Block 2007, Block Group 2, Census Tract 78.08, District of Columbia, District of Columbia 122 0 122 0 0 0 0 0 122 117 0 117 0 0 0 0 0 5 0 5 0 0 0 0 0 110010078082007 6 608 608 6 psa_19 6D1
1159 1159 1000000US110010019013010 Block 3010, Block Group 3, Census Tract 19.01, District of Columbia, District of Columbia 78 12 62 0 4 0 0 0 78 64 3 57 0 4 0 0 0 14 9 5 0 0 0 0 0 110010019013010 4 402 402 4 psa_53 4D1
1290 1290 1000000US110010020023003 Block 3003, Block Group 3, Census Tract 20.02, District of Columbia, District of Columbia 142 2 102 0 0 0 38 0 142 99 2 97 0 0 0 0 0 43 0 5 0 0 0 38 0 110010020023003 4 403 403 4 psa_51 4D1
2268 2268 1000000US110010078062000 Block 2000, Block Group 2, Census Tract 78.06, District of Columbia, District of Columbia 75 3 71 1 0 0 0 0 75 70 3 66 1 0 0 0 0 5 0 5 0 0 0 0 0 110010078062000 6 602 602 6 psa_25 6D1
2706 2706 1000000US110010095082001 Block 2001, Block Group 2, Census Tract 95.08, District of Columbia, District of Columbia 242 5 237 0 0 0 0 0 242 234 2 232 0 0 0 0 0 8 3 5 0 0 0 0 0 110010095082001 4 406 406 4 psa_54 4D2
2771 2771 1000000US110010049021000 Block 1000, Block Group 1, Census Tract 49.02, District of Columbia, District of Columbia 340 10 326 0 0 0 4 0 340 323 2 321 0 0 0 0 0 17 8 5 0 0 0 4 0 110010049021000 3 307 307 3 psa_28 3D3
3839 3839 1000000US110010031001004 Block 1004, Block Group 1, Census Tract 31, District of Columbia, District of Columbia 141 40 53 1 10 0 37 0 141 86 28 48 0 10 0 0 0 55 12 5 1 0 0 37 0 110010031001004 4 409 409 4 psa_41 4D3
4212 4212 1000000US110010074041008 Block 1008, Block Group 1, Census Tract 74.04, District of Columbia, District of Columbia 118 1 114 0 0 0 2 1 118 110 1 109 0 0 0 0 0 8 0 5 0 0 0 2 1 110010074041008 7 704 704 7 psa_5 7D2
5057 5057 1000000US110010078034001 Block 4001, Block Group 4, Census Tract 78.03, District of Columbia, District of Columbia 163 1 154 0 1 0 6 1 163 151 1 149 0 1 0 0 0 12 0 5 0 0 0 6 1 110010078034001 6 602 602 6 psa_25 6D1
5235 5235 1000000US110010076015018 Block 5018, Block Group 5, Census Tract 76.01, District of Columbia, District of Columbia 165 0 164 0 1 0 0 0 165 160 0 159 0 1 0 0 0 5 0 5 0 0 0 0 0 110010076015018 6 607 607 6 psa_10 6D2
5599 5599 1000000US110010077033000 Block 3000, Block Group 3, Census Tract 77.03, District of Columbia, District of Columbia 112 1 110 1 0 0 0 0 112 107 1 105 1 0 0 0 0 5 0 5 0 0 0 0 0 110010077033000 6 603 603 6 psa_15 6D3
5769 5769 1000000US110010076032000 Block 2000, Block Group 2, Census Tract 76.03, District of Columbia, District of Columbia 27 0 27 0 0 0 0 0 27 22 0 22 0 0 0 0 0 5 0 5 0 0 0 0 0 110010076032000 6 606 606 6 psa_7 6D2
5800 5800 1000000US110010035001001 Block 1001, Block Group 1, Census Tract 35, District of Columbia, District of Columbia 91 38 47 4 0 0 2 0 91 84 38 42 4 0 0 0 0 7 0 5 0 0 0 2 0 110010035001001 3 304 304 3 psa_36 3D1
5985 5985 1000000US110010023012009 Block 2009, Block Group 2, Census Tract 23.01, District of Columbia, District of Columbia 115 12 95 0 4 0 4 0 115 106 12 90 0 4 0 0 0 9 0 5 0 0 0 4 0 110010023012009 4 407 407 4 psa_47 4D2
6013 6013 1000000US110010031001009 Block 1009, Block Group 1, Census Tract 31, District of Columbia, District of Columbia 210 100 57 0 5 0 42 6 210 136 78 52 0 5 0 1 0 74 22 5 0 0 0 41 6 110010031001009 3 302 302 3 psa_42 3D1
6170 6170 1000000US110010094004003 Block 4003, Block Group 4, Census Tract 94, District of Columbia, District of Columbia 23 0 23 0 0 0 0 0 23 18 0 18 0 0 0 0 0 5 0 5 0 0 0 0 0 110010094004003 5 503 503 5 psa_45 5D2

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