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

7 rows where P005008 = 3 and P005009 = 1

View and edit SQL

Suggested facets: P003004, P003005, P003006, P003007, P003008, P005003, P005005, P005006, P005007, P005010, P005011, P005013, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005009

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
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
1988 1000000US110010068021003 Block 1003, Block Group 1, Census Tract 68.02, District of Columbia, District of Columbia 110 52 50 0 2 0 4 2 110 102 46 50 0 2 0 3 1 8 6 0 0 0 0 1 1 110010068021003 1 107 107 1 psa_16 1D2
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 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
3140 1000000US110010019014008 Block 4008, Block Group 4, Census Tract 19.01, District of Columbia, District of Columbia 96 14 61 1 2 0 16 2 96 81 13 61 1 2 0 3 1 15 1 0 0 0 0 13 1 110010019014008 4 402 402 4 psa_53 4D1
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
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

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