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

14 rows where P003006 = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003003, P003004, P003005, P003007, P003008, P005001, P005002, P005003, P005004, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005016, P005017

P003006 ✖

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
292 292 170312209012006 25 1000000US170312209012006 Block 2006, Block Group 2, Census Tract 2209.01, Cook County, Illinois 166 45 11 0 0 6 103 1 166 0 0 0 0 0 0 0 0 166 45 11 0 0 6 103 1
861 861 170311508003015 16 1000000US170311508003015 Block 3015, Block Group 3, Census Tract 1508, Cook County, Illinois 107 60 0 0 1 6 38 2 107 19 18 0 0 1 0 0 0 88 42 0 0 0 6 38 2
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
16477 16477 170311904022011 25 1000000US170311904022011 Block 2011, Block Group 2, Census Tract 1904.02, Cook County, Illinois 107 41 4 13 3 6 31 9 107 21 14 4 0 3 0 0 0 86 27 0 13 0 6 31 9
18048 18048 170311904022017 25 1000000US170311904022017 Block 2017, Block Group 2, Census Tract 1904.02, Cook County, Illinois 129 34 0 1 2 6 74 12 129 13 11 0 1 1 0 0 0 116 23 0 0 1 6 74 12
20169 20169 170310718001008 18 1000000US170310718001008 Block 1008, Block Group 1, Census Tract 718, Cook County, Illinois 543 161 357 1 7 6 4 7 543 523 157 353 1 7 0 1 4 20 4 4 0 0 6 3 3
22530 22530 170311604001013 17 1000000US170311604001013 Block 1013, Block Group 1, Census Tract 1604, Cook County, Illinois 96 61 6 0 6 6 7 10 96 40 27 1 0 6 0 1 5 56 34 5 0 0 6 6 5
25689 25689 170311613004002 17 1000000US170311613004002 Block 4002, Block Group 4, Census Tract 1613, Cook County, Illinois 68 46 4 0 0 6 10 2 68 34 29 4 0 0 0 0 1 34 17 0 0 0 6 10 1
30889 30889 170316303002016 8 1000000US170316303002016 Block 2016, Block Group 2, Census Tract 6303, Cook County, Illinois 152 54 6 5 0 6 77 4 152 9 7 2 0 0 0 0 0 143 47 4 5 0 6 77 4
31639 31639 170312504003003 25 1000000US170312504003003 Block 3003, Block Group 3, Census Tract 2504, Cook County, Illinois 100 0 86 3 0 6 5 0 100 89 0 86 3 0 0 0 0 11 0 0 0 0 6 5 0
34006 34006 170312215001010 14 1000000US170312215001010 Block 1010, Block Group 1, Census Tract 2215, Cook County, Illinois 54 38 1 0 0 6 6 3 54 13 12 1 0 0 0 0 0 41 26 0 0 0 6 6 3
35859 35859 170311101001018 16 1000000US170311101001018 Block 1018, Block Group 1, Census Tract 1101, Cook County, Illinois 21 8 0 0 7 6 0 0 21 14 7 0 0 7 0 0 0 7 1 0 0 0 6 0 0
36668 36668 170312306001011 25 1000000US170312306001011 Block 1011, Block Group 1, Census Tract 2306, Cook County, Illinois 124 46 22 4 0 6 42 4 124 24 1 17 0 0 6 0 0 100 45 5 4 0 0 42 4
39061 39061 170312207021006 25 1000000US170312207021006 Block 1006, Block Group 1, Census Tract 2207.02, Cook County, Illinois 52 24 3 0 0 6 19 0 52 20 11 3 0 0 6 0 0 32 13 0 0 0 0 19 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
);