chicago_2010blocks_2020policedistricts_population

2010 population by US Census block, with each block linked to the police district area in which it sits, as those districts were drawn in 2020. For details and column descriptions see this blog post.

Data license: CC BY-SA 4.0 · Data source: US Census & Chicago Open Data Portal, combined by John Keefe

6 rows where P005014 = 4 and P005017 = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003004, P003005, P003006, P003008, P005005, P005006, P005009, P005015

P005017 ✖

P005014 ✖

Link rowid ▼ GEOID10 dist_num 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
8387 8387 170315805022006 9 1000000US170315805022006 Block 2006, Block Group 2, Census Tract 5805.02, Cook County, Illinois 192 102 0 1 6 2 78 3 192 16 13 0 1 2 0 0 0 176 89 0 0 4 2 78 3
16871 16871 170312205003002 14 1000000US170312205003002 Block 3002, Block Group 3, Census Tract 2205, Cook County, Illinois 119 77 5 0 7 0 23 7 119 67 55 5 0 3 0 0 4 52 22 0 0 4 0 23 3
20701 20701 170312411002006 14 1000000US170312411002006 Block 2006, Block Group 2, Census Tract 2411, Cook County, Illinois 109 49 13 8 7 0 28 4 109 37 18 13 2 3 0 0 1 72 31 0 6 4 0 28 3
41630 41630 170310307062001 20 1000000US170310307062001 Block 2001, Block Group 2, Census Tract 307.06, Cook County, Illinois 251 148 22 1 69 0 7 4 251 221 133 22 0 65 0 0 1 30 15 0 1 4 0 7 3
41640 41640 170312106012007 14 1000000US170312106012007 Block 2007, Block Group 2, Census Tract 2106.01, Cook County, Illinois 142 65 1 0 7 1 65 3 142 26 22 1 0 3 0 0 0 116 43 0 0 4 1 65 3
44218 44218 170318316004005 25 1000000US170318316004005 Block 4005, Block Group 4, Census Tract 8316, Cook County, Illinois 90 21 31 0 11 0 24 3 90 45 7 31 0 7 0 0 0 45 14 0 0 4 0 24 3

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "chicago_2010blocks_2020policedistricts_population" (
"GEOID10" INTEGER,
  "dist_num" INTEGER,
  "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
);