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

10 rows where P005016 = 1 and SECTOR = "7D2"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003005, P003007, P003008, P005003, P005005, P005006, P005008, P005009, P005010, P005012, P005014, 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
134 134 1000000US110010074031002 Block 1002, Block Group 1, Census Tract 74.03, District of Columbia, District of Columbia 1322 9 1304 0 4 0 1 4 1322 1315 9 1300 0 3 0 0 3 7 0 4 0 1 0 1 1 110010074031002 7 704 704 7 psa_5 7D2
490 490 1000000US110010104001021 Block 1021, Block Group 1, Census Tract 104, District of Columbia, District of Columbia 118 0 117 0 0 0 1 0 118 117 0 117 0 0 0 0 0 1 0 0 0 0 0 1 0 110010104001021 7 707 707 7 psa_4 7D2
845 845 1000000US110010098032006 Block 2006, Block Group 2, Census Tract 98.03, District of Columbia, District of Columbia 82 0 81 0 0 0 1 0 82 81 0 81 0 0 0 0 0 1 0 0 0 0 0 1 0 110010098032006 7 707 707 7 psa_4 7D2
3352 3352 1000000US110010104002016 Block 2016, Block Group 2, Census Tract 104, District of Columbia, District of Columbia 166 3 162 0 0 0 1 0 166 157 3 154 0 0 0 0 0 9 0 8 0 0 0 1 0 110010104002016 7 707 707 7 psa_4 7D2
4262 4262 1000000US110010073043002 Block 3002, Block Group 3, Census Tract 73.04, District of Columbia, District of Columbia 51 4 42 0 0 0 2 3 51 47 4 42 0 0 0 1 0 4 0 0 0 0 0 1 3 110010073043002 7 705 705 7 psa_3 7D2
5192 5192 1000000US110010073042003 Block 2003, Block Group 2, Census Tract 73.04, District of Columbia, District of Columbia 100 0 93 6 0 0 1 0 100 98 0 92 6 0 0 0 0 2 0 1 0 0 0 1 0 110010073042003 7 705 705 7 psa_3 7D2
5436 5436 1000000US110010098032003 Block 2003, Block Group 2, Census Tract 98.03, District of Columbia, District of Columbia 133 0 131 0 0 0 1 1 133 132 0 131 0 0 0 0 1 1 0 0 0 0 0 1 0 110010098032003 7 707 707 7 psa_4 7D2
5529 5529 1000000US110010104001017 Block 1017, Block Group 1, Census Tract 104, District of Columbia, District of Columbia 142 4 136 0 0 0 1 1 142 141 4 136 0 0 0 0 1 1 0 0 0 0 0 1 0 110010104001017 7 707 707 7 psa_4 7D2
5807 5807 1000000US110010074092002 Block 2002, Block Group 2, Census Tract 74.09, District of Columbia, District of Columbia 183 0 167 0 5 0 1 10 183 182 0 167 0 5 0 0 10 1 0 0 0 0 0 1 0 110010074092002 7 704 704 7 psa_5 7D2
6135 6135 1000000US110010073042005 Block 2005, Block Group 2, Census Tract 73.04, District of Columbia, District of Columbia 80 6 73 0 0 0 1 0 80 77 6 71 0 0 0 0 0 3 0 2 0 0 0 1 0 110010073042005 7 705 705 7 psa_3 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
);