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

10 rows where P005015 = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003003, P003004, P003005, P003006, P003007, P003008, P005004, P005006, P005007, P005008, P005009, P005012, P005013, P005016, P005017

P005015 ✖

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
149 149 170318316002003 25 1000000US170318316002003 Block 2003, Block Group 2, Census Tract 8316, Cook County, Illinois 148 69 8 7 0 5 49 10 148 38 27 8 0 0 0 0 3 110 42 0 7 0 5 49 7
1406 1406 170311105022016 16 1000000US170311105022016 Block 2016, Block Group 2, Census Tract 1105.02, Cook County, Illinois 44 37 1 0 0 5 1 0 44 33 32 1 0 0 0 0 0 11 5 0 0 0 5 1 0
3808 3808 170315804004007 8 1000000US170315804004007 Block 4007, Block Group 4, Census Tract 5804, Cook County, Illinois 117 16 0 0 0 5 94 2 117 10 10 0 0 0 0 0 0 107 6 0 0 0 5 94 2
4672 4672 170311908002012 25 1000000US170311908002012 Block 2012, Block Group 2, Census Tract 1908, Cook County, Illinois 60 48 0 0 2 5 5 0 60 14 12 0 0 2 0 0 0 46 36 0 0 0 5 5 0
6895 6895 170311906022022 25 1000000US170311906022022 Block 2022, Block Group 2, Census Tract 1906.02, Cook County, Illinois 104 73 0 0 0 6 19 6 104 18 17 0 0 0 1 0 0 86 56 0 0 0 5 19 6
21758 21758 170316401001007 8 1000000US170316401001007 Block 1007, Block Group 1, Census Tract 6401, Cook County, Illinois 79 38 0 0 0 5 32 4 79 21 13 0 0 0 0 4 4 58 25 0 0 0 5 28 0
25800 25800 170310206021008 24 1000000US170310206021008 Block 1008, Block Group 1, Census Tract 206.02, Cook County, Illinois 113 66 9 2 20 5 5 6 113 69 39 8 0 20 0 0 2 44 27 1 2 0 5 5 4
29266 29266 170316503011021 8 1000000US170316503011021 Block 1021, Block Group 1, Census Tract 6503.01, Cook County, Illinois 55 23 0 0 0 5 27 0 55 15 15 0 0 0 0 0 0 40 8 0 0 0 5 27 0
36130 36130 170312312004004 11 1000000US170312312004004 Block 4004, Block Group 4, Census Tract 2312, Cook County, Illinois 88 35 38 0 0 5 10 0 88 36 0 36 0 0 0 0 0 52 35 2 0 0 5 10 0
39950 39950 170311904011017 25 1000000US170311904011017 Block 1017, Block Group 1, Census Tract 1904.01, Cook County, Illinois 58 44 0 0 2 5 7 0 58 16 14 0 0 2 0 0 0 42 30 0 0 0 5 7 0

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