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

51 rows where P005008 = 1 and P005012 = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003004, P003005, P003006, P003008, P005005, P005006, P005007, P005009, P005013, 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
1758 1758 170310102012040 24 1000000US170310102012040 Block 2040, Block Group 2, Census Tract 102.01, Cook County, Illinois 246 68 90 2 24 1 51 10 246 177 55 87 2 24 1 1 7 69 13 3 0 0 0 50 3
1987 1987 170312207024002 25 1000000US170312207024002 Block 4002, Block Group 4, Census Tract 2207.02, Cook County, Illinois 109 74 3 0 0 0 29 3 109 23 22 0 0 0 0 1 0 86 52 3 0 0 0 28 3
2017 2017 170310102012024 24 1000000US170310102012024 Block 2024, Block Group 2, Census Tract 102.01, Cook County, Illinois 378 139 141 3 5 3 69 18 378 242 81 138 1 5 3 1 13 136 58 3 2 0 0 68 5
2580 2580 170310307061011 20 1000000US170310307061011 Block 1011, Block Group 1, Census Tract 307.06, Cook County, Illinois 752 389 151 0 163 0 18 31 752 687 352 148 0 163 0 1 23 65 37 3 0 0 0 17 8
3509 3509 170312214003007 14 1000000US170312214003007 Block 3007, Block Group 3, Census Tract 2214, Cook County, Illinois 81 40 9 0 3 0 22 7 81 47 31 6 0 3 0 1 6 34 9 3 0 0 0 21 1
4342 4342 170315805011014 9 1000000US170315805011014 Block 1014, Block Group 1, Census Tract 5805.01, Cook County, Illinois 84 34 6 0 0 0 43 1 84 8 4 3 0 0 0 1 0 76 30 3 0 0 0 42 1
5849 5849 170318339001013 4 1000000US170318339001013 Block 1013, Block Group 1, Census Tract 8339, Cook County, Illinois 123 22 49 14 0 0 37 1 123 47 0 46 0 0 0 1 0 76 22 3 14 0 0 36 1
6230 6230 170315102002002 4 1000000US170315102002002 Block 2002, Block Group 2, Census Tract 5102, Cook County, Illinois 431 5 416 1 0 0 5 4 431 423 4 413 1 0 0 1 4 8 1 3 0 0 0 4 0
7254 7254 170314307002006 3 1000000US170314307002006 Block 2006, Block Group 2, Census Tract 4307, Cook County, Illinois 280 12 259 1 0 0 3 5 280 274 11 256 1 0 0 1 5 6 1 3 0 0 0 2 0
8003 8003 170317104006001 6 1000000US170317104006001 Block 6001, Block Group 6, Census Tract 7104, Cook County, Illinois 293 1 287 0 0 0 1 4 293 290 1 284 0 0 0 1 4 3 0 3 0 0 0 0 0
8132 8132 170310101001003 24 1000000US170310101001003 Block 1003, Block Group 1, Census Tract 101, Cook County, Illinois 335 171 110 6 5 0 29 14 335 227 103 107 1 5 0 1 10 108 68 3 5 0 0 28 4
9316 9316 170312207011000 25 1000000US170312207011000 Block 1000, Block Group 1, Census Tract 2207.01, Cook County, Illinois 110 64 4 0 1 1 34 6 110 37 27 1 0 1 1 1 6 73 37 3 0 0 0 33 0
14780 14780 170311906012002 25 1000000US170311906012002 Block 2002, Block Group 2, Census Tract 1906.01, Cook County, Illinois 102 46 3 5 0 0 48 0 102 9 5 0 3 0 0 1 0 93 41 3 2 0 0 47 0
14866 14866 170317001001035 8 1000000US170317001001035 Block 1035, Block Group 1, Census Tract 7001, Cook County, Illinois 52 3 25 0 0 0 22 2 52 25 2 22 0 0 0 1 0 27 1 3 0 0 0 21 2
16396 16396 170312831001006 12 1000000US170312831001006 Block 1006, Block Group 1, Census Tract 2831, Cook County, Illinois 581 45 469 1 55 0 6 5 581 562 35 466 0 55 0 1 5 19 10 3 1 0 0 5 0
18684 18684 170310313004004 20 1000000US170310313004004 Block 4004, Block Group 4, Census Tract 313, Cook County, Illinois 439 190 220 2 11 0 4 12 439 408 172 217 2 11 0 1 5 31 18 3 0 0 0 3 7
19591 19591 170310307011000 20 1000000US170310307011000 Block 1000, Block Group 1, Census Tract 307.01, Cook County, Illinois 468 242 157 4 22 0 24 19 468 406 212 154 1 21 0 1 17 62 30 3 3 1 0 23 2
20649 20649 170312004022001 25 1000000US170312004022001 Block 2001, Block Group 2, Census Tract 2004.02, Cook County, Illinois 161 49 10 0 2 2 85 13 161 14 4 7 0 2 0 1 0 147 45 3 0 0 2 84 13
21849 21849 170318330001057 12 1000000US170318330001057 Block 1057, Block Group 1, Census Tract 8330, Cook County, Illinois 222 80 129 1 1 1 9 1 222 206 77 126 0 1 1 1 0 16 3 3 1 0 0 8 1
21999 21999 170318308002003 19 1000000US170318308002003 Block 2003, Block Group 2, Census Tract 8308, Cook County, Illinois 293 189 18 0 12 0 57 17 293 191 155 15 0 12 0 1 8 102 34 3 0 0 0 56 9
22158 22158 170313301002018 1 1000000US170313301002018 Block 2018, Block Group 2, Census Tract 3301, Cook County, Illinois 193 20 165 1 1 0 3 3 193 183 16 162 0 1 0 1 3 10 4 3 1 0 0 2 0
23081 23081 170310315012003 19 1000000US170310315012003 Block 2003, Block Group 2, Census Tract 315.01, Cook County, Illinois 422 210 40 5 50 0 104 13 422 244 145 37 4 50 0 1 7 178 65 3 1 0 0 103 6
23160 23160 170316007002029 9 1000000US170316007002029 Block 2029, Block Group 2, Census Tract 6007, Cook County, Illinois 137 49 8 0 44 0 28 8 137 80 30 5 0 44 0 1 0 57 19 3 0 0 0 27 8
23340 23340 170313201001018 1 1000000US170313201001018 Block 1018, Block Group 1, Census Tract 3201, Cook County, Illinois 452 275 90 1 59 0 13 14 452 414 254 87 1 59 0 1 12 38 21 3 0 0 0 12 2
23885 23885 170312109002002 14 1000000US170312109002002 Block 2002, Block Group 2, Census Tract 2109, Cook County, Illinois 64 46 5 0 0 0 12 1 64 36 33 2 0 0 0 1 0 28 13 3 0 0 0 11 1
27197 27197 170310105013004 24 1000000US170310105013004 Block 3004, Block Group 3, Census Tract 105.01, Cook County, Illinois 130 64 37 0 15 0 8 6 130 113 58 34 0 15 0 1 5 17 6 3 0 0 0 7 1
27332 27332 170318390001001 1 1000000US170318390001001 Block 1001, Block Group 1, Census Tract 8390, Cook County, Illinois 718 558 53 2 50 2 20 33 718 660 528 50 2 50 2 1 27 58 30 3 0 0 0 19 6
28005 28005 170313106001021 12 1000000US170313106001021 Block 1021, Block Group 1, Census Tract 3106, Cook County, Illinois 156 73 14 5 1 0 57 6 156 45 26 11 0 1 0 1 6 111 47 3 5 0 0 56 0
29640 29640 170311608005008 17 1000000US170311608005008 Block 5008, Block Group 5, Census Tract 1608, Cook County, Illinois 58 36 8 0 0 0 9 5 58 19 13 5 0 0 0 1 0 39 23 3 0 0 0 8 5
29844 29844 170318428001000 9 1000000US170318428001000 Block 1000, Block Group 1, Census Tract 8428, Cook County, Illinois 163 53 3 6 0 0 97 4 163 6 5 0 0 0 0 1 0 157 48 3 6 0 0 96 4
30443 30443 170310633031002 19 1000000US170310633031002 Block 1002, Block Group 1, Census Tract 633.03, Cook County, Illinois 428 403 7 0 13 0 1 4 428 417 395 4 0 13 0 1 4 11 8 3 0 0 0 0 0
31291 31291 170318412002007 12 1000000US170318412002007 Block 2007, Block Group 2, Census Tract 8412, Cook County, Illinois 117 54 5 4 0 0 51 3 117 18 15 2 0 0 0 1 0 99 39 3 4 0 0 50 3
31560 31560 170316110001034 9 1000000US170316110001034 Block 1034, Block Group 1, Census Tract 6110, Cook County, Illinois 31 0 30 0 0 0 1 0 31 28 0 27 0 0 0 1 0 3 0 3 0 0 0 0 0
31764 31764 170312105012004 25 1000000US170312105012004 Block 2004, Block Group 2, Census Tract 2105.01, Cook County, Illinois 391 242 27 2 29 0 67 24 391 233 168 24 2 26 0 1 12 158 74 3 0 3 0 66 12
31833 31833 170318428001004 9 1000000US170318428001004 Block 1004, Block Group 1, Census Tract 8428, Cook County, Illinois 121 48 4 7 0 0 62 0 121 4 2 1 0 0 0 1 0 117 46 3 7 0 0 61 0
32299 32299 170310402021007 20 1000000US170310402021007 Block 1007, Block Group 1, Census Tract 402.02, Cook County, Illinois 116 31 37 0 34 0 10 4 116 99 28 34 0 34 0 1 2 17 3 3 0 0 0 9 2
34068 34068 170311606012007 17 1000000US170311606012007 Block 2007, Block Group 2, Census Tract 1606.01, Cook County, Illinois 77 53 4 0 8 0 6 6 77 44 36 1 0 5 0 1 1 33 17 3 0 3 0 5 5
34896 34896 170310302004016 24 1000000US170310302004016 Block 4016, Block Group 4, Census Tract 302, Cook County, Illinois 120 66 18 5 14 0 16 1 120 97 65 15 1 14 0 1 1 23 1 3 4 0 0 15 0
35958 35958 170310105021004 24 1000000US170310105021004 Block 1004, Block Group 1, Census Tract 105.02, Cook County, Illinois 140 43 72 1 6 0 10 8 140 122 37 69 1 6 0 1 8 18 6 3 0 0 0 9 0
35969 35969 170318306004011 24 1000000US170318306004011 Block 4011, Block Group 4, Census Tract 8306, Cook County, Illinois 149 55 54 0 4 0 18 18 149 103 32 51 0 4 0 1 15 46 23 3 0 0 0 17 3
35997 35997 170312211001000 14 1000000US170312211001000 Block 1000, Block Group 1, Census Tract 2211, Cook County, Illinois 112 67 26 1 1 1 11 5 112 73 46 23 0 1 1 1 1 39 21 3 1 0 0 10 4
36725 36725 170314109002002 2 1000000US170314109002002 Block 2002, Block Group 2, Census Tract 4109, Cook County, Illinois 306 145 104 6 32 0 3 16 306 285 138 101 0 32 0 1 13 21 7 3 6 0 0 2 3
38232 38232 170310402024017 20 1000000US170310402024017 Block 4017, Block Group 4, Census Tract 402.02, Cook County, Illinois 306 164 76 4 23 0 18 21 306 242 133 73 2 22 0 1 11 64 31 3 2 1 0 17 10
38814 38814 170314203001000 2 1000000US170314203001000 Block 1000, Block Group 1, Census Tract 4203, Cook County, Illinois 1021 621 78 0 240 0 31 51 1021 895 545 75 0 238 0 1 36 126 76 3 0 2 0 30 15
39052 39052 170311406022000 17 1000000US170311406022000 Block 2000, Block Group 2, Census Tract 1406.02, Cook County, Illinois 203 117 16 9 8 0 41 12 203 76 44 13 0 8 0 1 10 127 73 3 9 0 0 40 2
39674 39674 170312206023000 14 1000000US170312206023000 Block 3000, Block Group 3, Census Tract 2206.02, Cook County, Illinois 272 137 71 0 3 4 38 19 272 118 45 68 0 2 0 1 2 154 92 3 0 1 4 37 17
42254 42254 170313802001003 2 1000000US170313802001003 Block 1003, Block Group 1, Census Tract 3802, Cook County, Illinois 180 6 165 0 1 0 1 7 180 176 5 162 0 1 0 1 7 4 1 3 0 0 0 0 0
42337 42337 170312435001008 12 1000000US170312435001008 Block 1008, Block Group 1, Census Tract 2435, Cook County, Illinois 85 68 4 0 4 0 6 3 85 62 53 1 0 4 0 1 3 23 15 3 0 0 0 5 0
43963 43963 170314905001003 5 1000000US170314905001003 Block 1003, Block Group 1, Census Tract 4905, Cook County, Illinois 291 25 248 0 2 5 3 8 291 281 20 245 0 2 5 1 8 10 5 3 0 0 0 2 0
45162 45162 170311505021001 16 1000000US170311505021001 Block 1001, Block Group 1, Census Tract 1505.02, Cook County, Illinois 194 131 3 0 7 0 43 10 194 111 102 0 0 7 0 1 1 83 29 3 0 0 0 42 9
45499 45499 170318378001017 12 1000000US170318378001017 Block 1017, Block Group 1, Census Tract 8378, Cook County, Illinois 232 58 161 1 3 0 8 1 232 198 35 158 0 3 0 1 1 34 23 3 1 0 0 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
);