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

142 rows where P005008 = 4

✎ View and edit SQL

This data as json, CSV (advanced)

P005008 ✖

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
33981 33981 170311002003007 16 1000000US170311002003007 Block 3007, Block Group 3, Census Tract 1002, Cook County, Illinois 23 18 0 0 0 0 5 0 23 22 18 0 0 0 0 4 0 1 0 0 0 0 0 1 0
34151 34151 170314402012019 6 1000000US170314402012019 Block 2019, Block Group 2, Census Tract 4402.01, Cook County, Illinois 42 0 38 0 0 0 4 0 42 42 0 38 0 0 0 4 0 0 0 0 0 0 0 0 0
34316 34316 170318412001004 12 1000000US170318412001004 Block 1004, Block Group 1, Census Tract 8412, Cook County, Illinois 145 58 6 4 1 0 66 10 145 33 19 6 0 1 0 4 3 112 39 0 4 0 0 62 7
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
35420 35420 170318316005001 25 1000000US170318316005001 Block 5001, Block Group 5, Census Tract 8316, Cook County, Illinois 84 38 15 0 3 0 28 0 84 36 14 15 0 3 0 4 0 48 24 0 0 0 0 24 0
35461 35461 170311407021006 17 1000000US170311407021006 Block 1006, Block Group 1, Census Tract 1407.02, Cook County, Illinois 141 56 5 4 8 0 66 2 141 49 28 5 4 8 0 4 0 92 28 0 0 0 0 62 2
35553 35553 170314309001000 3 1000000US170314309001000 Block 1000, Block Group 1, Census Tract 4309, Cook County, Illinois 42 0 32 0 0 0 5 5 42 36 0 32 0 0 0 4 0 6 0 0 0 0 0 1 5
35915 35915 170312228001005 14 1000000US170312228001005 Block 1005, Block Group 1, Census Tract 2228, Cook County, Illinois 118 55 6 0 0 0 51 6 118 34 19 6 0 0 0 4 5 84 36 0 0 0 0 47 1
36344 36344 170317202003031 22 1000000US170317202003031 Block 3031, Block Group 3, Census Tract 7202, Cook County, Illinois 59 36 19 0 0 0 4 0 59 58 35 19 0 0 0 4 0 1 1 0 0 0 0 0 0
36475 36475 170310208023001 24 1000000US170310208023001 Block 3001, Block Group 3, Census Tract 208.02, Cook County, Illinois 72 7 1 0 49 0 8 7 72 67 6 1 0 49 0 4 7 5 1 0 0 0 0 4 0
36695 36695 170310818002052 18 1000000US170310818002052 Block 2052, Block Group 2, Census Tract 818, Cook County, Illinois 215 178 2 0 25 0 4 6 215 209 172 2 0 25 0 4 6 6 6 0 0 0 0 0 0
37060 37060 170310714003002 18 1000000US170310714003002 Block 3002, Block Group 3, Census Tract 714, Cook County, Illinois 805 716 14 0 52 1 5 17 805 774 686 14 0 52 1 4 17 31 30 0 0 0 0 1 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
37936 37936 170310816001002 18 1000000US170310816001002 Block 1002, Block Group 1, Census Tract 816, Cook County, Illinois 511 400 6 2 91 0 4 8 511 494 383 6 2 91 0 4 8 17 17 0 0 0 0 0 0
38159 38159 170317608031005 16 1000000US170317608031005 Block 1005, Block Group 1, Census Tract 7608.03, Cook County, Illinois 126 100 3 0 9 0 8 6 126 117 95 3 0 9 0 4 6 9 5 0 0 0 0 4 0
38392 38392 170316611004010 8 1000000US170316611004010 Block 4010, Block Group 4, Census Tract 6611, Cook County, Illinois 63 30 22 0 0 0 5 6 63 29 3 22 0 0 0 4 0 34 27 0 0 0 0 1 6
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
39106 39106 170311607002010 17 1000000US170311607002010 Block 2010, Block Group 2, Census Tract 1607, Cook County, Illinois 97 27 4 0 7 0 49 10 97 42 24 4 0 7 0 4 3 55 3 0 0 0 0 45 7
39480 39480 170310107012006 24 1000000US170310107012006 Block 2006, Block Group 2, Census Tract 107.01, Cook County, Illinois 123 67 23 0 17 0 10 6 123 108 58 23 0 17 0 4 6 15 9 0 0 0 0 6 0
39555 39555 170316304001005 9 1000000US170316304001005 Block 1005, Block Group 1, Census Tract 6304, Cook County, Illinois 77 35 0 0 0 0 41 1 77 7 3 0 0 0 0 4 0 70 32 0 0 0 0 37 1
39578 39578 170314111002003 2 1000000US170314111002003 Block 2003, Block Group 2, Census Tract 4111, Cook County, Illinois 512 361 23 2 101 0 10 15 512 483 344 20 0 101 0 4 14 29 17 3 2 0 0 6 1
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
40619 40619 170310302002009 24 1000000US170310302002009 Block 2009, Block Group 2, Census Tract 302, Cook County, Illinois 82 72 2 0 1 0 7 0 82 75 68 2 0 1 0 4 0 7 4 0 0 0 0 3 0
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
42636 42636 170317608011014 16 1000000US170317608011014 Block 1014, Block Group 1, Census Tract 7608.01, Cook County, Illinois 322 252 9 1 51 0 9 0 322 304 240 9 0 51 0 4 0 18 12 0 1 0 0 5 0
43204 43204 170315906002007 9 1000000US170315906002007 Block 2007, Block Group 2, Census Tract 5906, Cook County, Illinois 146 98 0 0 0 0 39 9 146 27 22 0 0 0 0 4 1 119 76 0 0 0 0 35 8
43228 43228 170310209012000 24 1000000US170310209012000 Block 2000, Block Group 2, Census Tract 209.01, Cook County, Illinois 144 77 11 0 49 0 6 1 144 135 70 11 0 49 0 4 1 9 7 0 0 0 0 2 0
43279 43279 170312922002006 10 1000000US170312922002006 Block 2006, Block Group 2, Census Tract 2922, Cook County, Illinois 130 3 119 0 1 0 6 1 130 125 1 119 0 1 0 4 0 5 2 0 0 0 0 2 1
43649 43649 170315804002005 8 1000000US170315804002005 Block 2005, Block Group 2, Census Tract 5804, Cook County, Illinois 128 56 0 1 6 0 65 0 128 18 8 0 0 6 0 4 0 110 48 0 1 0 0 61 0
43711 43711 170312422001006 12 1000000US170312422001006 Block 1006, Block Group 1, Census Tract 2422, Cook County, Illinois 62 6 14 3 5 0 34 0 62 18 0 14 0 0 0 4 0 44 6 0 3 5 0 30 0
43796 43796 170311906021002 25 1000000US170311906021002 Block 1002, Block Group 1, Census Tract 1906.02, Cook County, Illinois 112 32 0 0 0 0 80 0 112 12 8 0 0 0 0 4 0 100 24 0 0 0 0 76 0
43869 43869 170313511001002 2 1000000US170313511001002 Block 1002, Block Group 1, Census Tract 3511, Cook County, Illinois 599 1 589 2 0 0 6 1 599 597 1 589 2 0 0 4 1 2 0 0 0 0 0 2 0
44178 44178 170310301022001 24 1000000US170310301022001 Block 2001, Block Group 2, Census Tract 301.02, Cook County, Illinois 400 204 87 4 40 0 40 25 400 319 174 84 3 37 0 4 17 81 30 3 1 3 0 36 8
44799 44799 170314102001001 2 1000000US170314102001001 Block 1001, Block Group 1, Census Tract 4102, Cook County, Illinois 283 164 40 0 62 0 4 13 283 273 154 40 0 62 0 4 13 10 10 0 0 0 0 0 0
44818 44818 170311404004003 17 1000000US170311404004003 Block 4003, Block Group 4, Census Tract 1404, Cook County, Illinois 36 25 0 2 5 0 4 0 36 31 20 0 2 5 0 4 0 5 5 0 0 0 0 0 0
44930 44930 170315611001015 8 1000000US170315611001015 Block 1015, Block Group 1, Census Tract 5611, Cook County, Illinois 65 50 0 0 2 0 8 5 65 47 40 0 0 2 0 4 1 18 10 0 0 0 0 4 4
45017 45017 170311001001007 16 1000000US170311001001007 Block 1007, Block Group 1, Census Tract 1001, Cook County, Illinois 67 56 0 0 0 0 11 0 67 56 52 0 0 0 0 4 0 11 4 0 0 0 0 7 0
45348 45348 170312209013004 25 1000000US170312209013004 Block 3004, Block Group 3, Census Tract 2209.01, Cook County, Illinois 75 36 10 0 0 0 20 9 75 20 6 10 0 0 0 4 0 55 30 0 0 0 0 16 9
45592 45592 170313904001006 2 1000000US170313904001006 Block 1006, Block Group 1, Census Tract 3904, Cook County, Illinois 50 16 23 0 3 0 4 4 50 46 14 21 0 3 0 4 4 4 2 2 0 0 0 0 0
45655 45655 170316608004000 8 1000000US170316608004000 Block 4000, Block Group 4, Census Tract 6608, Cook County, Illinois 127 9 53 0 0 0 61 4 127 66 5 53 0 0 0 4 4 61 4 0 0 0 0 57 0
46492 46492 170311908004010 25 1000000US170311908004010 Block 4010, Block Group 4, Census Tract 1908, Cook County, Illinois 56 29 3 0 0 0 24 0 56 20 13 3 0 0 0 4 0 36 16 0 0 0 0 20 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
);