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

6 rows where P005008 = 2 and SECTOR = "5D1"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003004, P003005, P003006, P003007, P005005, P005006, P005007, P005009, P005011, P005012, P005013, P005014, P005016, P005017, PSA, NAME, GIS_ID

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
234 234 1000000US110010088031018 Block 1018, Block Group 1, Census Tract 88.03, District of Columbia, District of Columbia 907 655 120 6 41 4 25 56 907 815 603 113 5 40 4 2 48 92 52 7 1 1 0 23 8 110010088031018 5 501 501 5 psa_35 5D1
247 247 1000000US110010092042003 Block 2003, Block Group 2, Census Tract 92.04, District of Columbia, District of Columbia 1196 26 976 23 1 0 140 30 1196 1014 17 966 6 1 0 2 22 182 9 10 17 0 0 138 8 110010092042003 5 502 502 5 psa_40 5D1
1870 1870 1000000US110010087012011 Block 2011, Block Group 2, Census Tract 87.01, District of Columbia, District of Columbia 106 13 90 0 0 0 2 1 106 105 12 90 0 0 0 2 1 1 1 0 0 0 0 0 0 110010087012011 5 502 502 5 psa_40 5D1
2194 2194 1000000US110010092032000 Block 2000, Block Group 2, Census Tract 92.03, District of Columbia, District of Columbia 119 9 99 0 0 0 5 6 119 109 8 98 0 0 0 2 1 10 1 1 0 0 0 3 5 110010092032000 5 502 502 5 psa_40 5D1
3999 3999 1000000US110010106003002 Block 3002, Block Group 3, Census Tract 106, District of Columbia, District of Columbia 108 38 58 0 0 0 5 7 108 99 34 57 0 0 0 2 6 9 4 1 0 0 0 3 1 110010106003002 5 501 501 5 psa_35 5D1
4263 4263 1000000US110010092032005 Block 2005, Block Group 2, Census Tract 92.03, District of Columbia, District of Columbia 55 12 40 0 1 0 2 0 55 52 9 40 0 1 0 2 0 3 3 0 0 0 0 0 0 110010092032005 5 502 502 5 psa_40 5D1

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