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

19 rows where P005008 = 4 and P005012 = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003002, P003003, P003004, P003005, P003006, P003007, P003008, P005002, P005003, P005004, P005005, P005006, P005007, P005009, P005010, P005011, P005013, P005014, P005015, P005016, P005017

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
342 342 170310102012017 24 1000000US170310102012017 Block 2017, Block Group 2, Census Tract 102.01, Cook County, Illinois 127 31 83 0 3 0 4 6 127 121 27 82 0 3 0 4 5 6 4 1 0 0 0 0 1
8497 8497 170316606005005 8 1000000US170316606005005 Block 5005, Block Group 5, Census Tract 6606, Cook County, Illinois 134 10 113 0 0 0 8 3 134 117 1 112 0 0 0 4 0 17 9 1 0 0 0 4 3
9751 9751 170310312004004 20 1000000US170310312004004 Block 4004, Block Group 4, Census Tract 312, Cook County, Illinois 279 107 109 0 51 0 8 4 279 268 102 108 0 51 0 4 3 11 5 1 0 0 0 4 1
10446 10446 170312209021013 25 1000000US170312209021013 Block 1013, Block Group 1, Census Tract 2209.02, Cook County, Illinois 64 5 10 0 0 0 49 0 64 15 2 9 0 0 0 4 0 49 3 1 0 0 0 45 0
13651 13651 170318419002110 12 1000000US170318419002110 Block 2110, Block Group 2, Census Tract 8419, Cook County, Illinois 177 96 27 0 38 0 7 9 177 154 79 26 0 36 0 4 9 23 17 1 0 2 0 3 0
19551 19551 170317203001003 22 1000000US170317203001003 Block 1003, Block Group 1, Census Tract 7203, Cook County, Illinois 31 19 8 0 0 0 4 0 31 30 19 7 0 0 0 4 0 1 0 1 0 0 0 0 0
20549 20549 170312607002008 11 1000000US170312607002008 Block 2008, Block Group 2, Census Tract 2607, Cook County, Illinois 98 1 92 0 0 0 5 0 98 96 1 91 0 0 0 4 0 2 0 1 0 0 0 1 0
20686 20686 170310107022008 24 1000000US170310107022008 Block 2008, Block Group 2, Census Tract 107.02, Cook County, Illinois 282 86 35 5 1 1 115 39 282 70 31 34 0 1 0 4 0 212 55 1 5 0 1 111 39
27822 27822 170314403005001 6 1000000US170314403005001 Block 5001, Block Group 5, Census Tract 4403, Cook County, Illinois 320 3 306 1 0 0 4 6 320 319 3 305 1 0 0 4 6 1 0 1 0 0 0 0 0
29203 29203 170310311001005 20 1000000US170310311001005 Block 1005, Block Group 1, Census Tract 311, Cook County, Illinois 259 163 13 0 50 0 23 10 259 223 148 12 0 50 0 4 9 36 15 1 0 0 0 19 1
30615 30615 170314313012004 4 1000000US170314313012004 Block 2004, Block Group 2, Census Tract 4313.01, Cook County, Illinois 239 3 221 0 0 1 4 10 239 238 3 220 0 0 1 4 10 1 0 1 0 0 0 0 0
32262 32262 170310104002004 24 1000000US170310104002004 Block 2004, Block Group 2, Census Tract 104, Cook County, Illinois 202 113 44 0 23 4 10 8 202 186 109 43 0 23 3 4 4 16 4 1 0 0 1 6 4
33826 33826 170311401001007 17 1000000US170311401001007 Block 1007, Block Group 1, Census Tract 1401, Cook County, Illinois 208 123 15 0 21 0 37 12 208 115 72 14 0 15 0 4 10 93 51 1 0 6 0 33 2
35199 35199 170313814001005 2 1000000US170313814001005 Block 1005, Block Group 1, Census Tract 3814, Cook County, Illinois 76 0 66 2 0 0 4 4 76 75 0 65 2 0 0 4 4 1 0 1 0 0 0 0 0
37497 37497 170318397002009 9 1000000US170318397002009 Block 2009, Block Group 2, Census Tract 8397, Cook County, Illinois 200 120 2 1 29 0 34 14 200 130 89 1 1 29 0 4 6 70 31 1 0 0 0 30 8
38735 38735 170315401021053 5 1000000US170315401021053 Block 1053, Block Group 1, Census Tract 5401.02, Cook County, Illinois 712 2 703 0 0 0 4 3 712 711 2 702 0 0 0 4 3 1 0 1 0 0 0 0 0
39932 39932 170314107001013 2 1000000US170314107001013 Block 1013, Block Group 1, Census Tract 4107, Cook County, Illinois 462 314 44 2 60 0 13 29 462 425 293 43 1 59 0 4 25 37 21 1 1 1 0 9 4
39967 39967 170310103002015 24 1000000US170310103002015 Block 2015, Block Group 2, Census Tract 103, Cook County, Illinois 299 155 77 2 11 0 34 20 299 241 134 76 2 11 0 4 14 58 21 1 0 0 0 30 6
40698 40698 170311909001013 25 1000000US170311909001013 Block 1013, Block Group 1, Census Tract 1909, Cook County, Illinois 140 63 4 1 1 0 53 18 140 15 5 3 1 1 0 4 1 125 58 1 0 0 0 49 17

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