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

17 rows where P003004 = 0 and P005012 = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003006, P003007, P003008, P005002, P005003, P005004, P005006, P005008, P005009, P005011, P005014, P005015, 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
4914 4914 170312209012005 25 1000000US170312209012005 Block 2005, Block Group 2, Census Tract 2209.01, Cook County, Illinois 207 47 99 0 0 0 51 10 207 98 7 89 0 0 0 0 2 109 40 10 0 0 0 51 8
6619 6619 170314406001006 6 1000000US170314406001006 Block 1006, Block Group 1, Census Tract 4406, Cook County, Illinois 64 0 64 0 0 0 0 0 64 54 0 54 0 0 0 0 0 10 0 10 0 0 0 0 0
10209 10209 170311913021012 25 1000000US170311913021012 Block 1012, Block Group 1, Census Tract 1913.02, Cook County, Illinois 127 58 11 0 7 1 50 0 127 20 12 1 0 7 0 0 0 107 46 10 0 0 1 50 0
10244 10244 170318351004015 8 1000000US170318351004015 Block 4015, Block Group 4, Census Tract 8351, Cook County, Illinois 60 19 10 0 1 0 30 0 60 2 2 0 0 0 0 0 0 58 17 10 0 1 0 30 0
11257 11257 170311402002002 17 1000000US170311402002002 Block 2002, Block Group 2, Census Tract 1402, Cook County, Illinois 198 76 15 0 34 0 70 3 198 44 5 5 0 34 0 0 0 154 71 10 0 0 0 70 3
12253 12253 170312411002015 14 1000000US170312411002015 Block 2015, Block Group 2, Census Tract 2411, Cook County, Illinois 81 39 24 0 0 0 12 6 81 37 18 14 0 0 0 0 5 44 21 10 0 0 0 12 1
13161 13161 170311903001020 25 1000000US170311903001020 Block 1020, Block Group 1, Census Tract 1903, Cook County, Illinois 107 82 11 0 0 0 10 4 107 60 56 1 0 0 0 1 2 47 26 10 0 0 0 9 2
13230 13230 170312502002013 25 1000000US170312502002013 Block 2013, Block Group 2, Census Tract 2502, Cook County, Illinois 113 10 96 0 0 0 7 0 113 87 1 86 0 0 0 0 0 26 9 10 0 0 0 7 0
13807 13807 170312209012000 25 1000000US170312209012000 Block 2000, Block Group 2, Census Tract 2209.01, Cook County, Illinois 225 96 18 0 0 0 103 8 225 36 24 8 0 0 0 0 4 189 72 10 0 0 0 103 4
18813 18813 170318366001006 12 1000000US170318366001006 Block 1006, Block Group 1, Census Tract 8366, Cook County, Illinois 136 67 28 0 6 0 32 3 136 85 59 18 0 6 0 0 2 51 8 10 0 0 0 32 1
27283 27283 170316104001005 9 1000000US170316104001005 Block 1005, Block Group 1, Census Tract 6104, Cook County, Illinois 288 150 11 0 0 0 117 10 288 7 6 1 0 0 0 0 0 281 144 10 0 0 0 117 10
29229 29229 170312003002006 25 1000000US170312003002006 Block 2006, Block Group 2, Census Tract 2003, Cook County, Illinois 131 28 16 0 0 1 76 10 131 12 6 6 0 0 0 0 0 119 22 10 0 0 1 76 10
33016 33016 170311911004007 25 1000000US170311911004007 Block 4007, Block Group 4, Census Tract 1911, Cook County, Illinois 228 94 10 0 0 0 122 2 228 8 8 0 0 0 0 0 0 220 86 10 0 0 0 122 2
34800 34800 170312311001009 11 1000000US170312311001009 Block 1009, Block Group 1, Census Tract 2311, Cook County, Illinois 110 13 77 0 0 0 18 2 110 70 2 67 0 0 0 0 1 40 11 10 0 0 0 18 1
35952 35952 170310307033000 20 1000000US170310307033000 Block 3000, Block Group 3, Census Tract 307.03, Cook County, Illinois 317 123 106 0 43 0 32 13 317 264 112 96 0 41 0 3 12 53 11 10 0 2 0 29 1
37548 37548 170318435001038 10 1000000US170318435001038 Block 1038, Block Group 1, Census Tract 8435, Cook County, Illinois 88 37 16 0 0 0 35 0 88 6 0 6 0 0 0 0 0 82 37 10 0 0 0 35 0
45616 45616 170314607002008 4 1000000US170314607002008 Block 2008, Block Group 2, Census Tract 4607, Cook County, Illinois 93 41 47 0 0 0 2 3 93 37 0 37 0 0 0 0 0 56 41 10 0 0 0 2 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
);