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

20 rows where P005012 = 5 and P005013 = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003002, P003003, P003004, P003005, P003008, P005002, P005003, P005004, P005005, P005006, P005008, P005009, P005014, P005016, P005017

P005013 ✖

P005012 ✖

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
2787 2787 170312408002001 14 1000000US170312408002001 Block 2001, Block Group 2, Census Tract 2408, Cook County, Illinois 76 52 9 1 1 0 12 1 76 19 14 4 0 1 0 0 0 57 38 5 1 0 0 12 1
8700 8700 170318324001011 14 1000000US170318324001011 Block 1011, Block Group 1, Census Tract 8324, Cook County, Illinois 152 87 13 3 6 0 33 10 152 52 36 8 2 5 0 0 1 100 51 5 1 1 0 33 9
12307 12307 170312508002010 25 1000000US170312508002010 Block 2010, Block Group 2, Census Tract 2508, Cook County, Illinois 70 3 61 1 0 0 5 0 70 57 1 56 0 0 0 0 0 13 2 5 1 0 0 5 0
12766 12766 170311902003002 25 1000000US170311902003002 Block 3002, Block Group 3, Census Tract 1902, Cook County, Illinois 104 59 6 1 3 0 27 8 104 22 18 1 0 3 0 0 0 82 41 5 1 0 0 27 8
13810 13810 170312209011009 25 1000000US170312209011009 Block 1009, Block Group 1, Census Tract 2209.01, Cook County, Illinois 193 79 36 2 1 0 62 13 193 41 7 31 1 1 0 0 1 152 72 5 1 0 0 62 12
15732 15732 170311407022012 17 1000000US170311407022012 Block 2012, Block Group 2, Census Tract 1407.02, Cook County, Illinois 77 25 6 2 0 0 37 7 77 8 5 1 1 0 0 0 1 69 20 5 1 0 0 37 6
17529 17529 170312106023008 14 1000000US170312106023008 Block 3008, Block Group 3, Census Tract 2106.02, Cook County, Illinois 207 107 9 1 0 0 84 6 207 20 16 4 0 0 0 0 0 187 91 5 1 0 0 84 6
17980 17980 170312309001006 14 1000000US170312309001006 Block 1006, Block Group 1, Census Tract 2309, Cook County, Illinois 159 77 33 4 4 0 30 11 159 95 55 28 3 4 0 0 5 64 22 5 1 0 0 30 6
19589 19589 170310307062003 20 1000000US170310307062003 Block 2003, Block Group 2, Census Tract 307.06, Cook County, Illinois 349 186 116 2 14 0 15 16 349 318 175 111 1 14 0 1 16 31 11 5 1 0 0 14 0
20064 20064 170313018031002 10 1000000US170313018031002 Block 1002, Block Group 1, Census Tract 3018.03, Cook County, Illinois 182 88 5 1 0 0 87 1 182 0 0 0 0 0 0 0 0 182 88 5 1 0 0 87 1
21566 21566 170313109002000 12 1000000US170313109002000 Block 2000, Block Group 2, Census Tract 3109, Cook County, Illinois 194 103 5 1 0 0 83 2 194 12 12 0 0 0 0 0 0 182 91 5 1 0 0 83 2
21635 21635 170312004012013 25 1000000US170312004012013 Block 2013, Block Group 2, Census Tract 2004.01, Cook County, Illinois 134 52 7 1 0 0 60 14 134 16 10 2 0 0 0 0 4 118 42 5 1 0 0 60 10
22570 22570 170312109001024 14 1000000US170312109001024 Block 1024, Block Group 1, Census Tract 2109, Cook County, Illinois 42 22 6 1 2 0 11 0 42 17 15 1 0 1 0 0 0 25 7 5 1 1 0 11 0
31669 31669 170312211001018 14 1000000US170312211001018 Block 1018, Block Group 1, Census Tract 2211, Cook County, Illinois 138 71 34 1 0 0 26 6 138 77 45 29 0 0 0 0 3 61 26 5 1 0 0 26 3
32329 32329 170318311003000 17 1000000US170318311003000 Block 3000, Block Group 3, Census Tract 8311, Cook County, Illinois 96 71 5 1 3 0 10 6 96 56 53 0 0 3 0 0 0 40 18 5 1 0 0 10 6
33336 33336 170318366002005 11 1000000US170318366002005 Block 2005, Block Group 2, Census Tract 8366, Cook County, Illinois 80 48 14 1 0 0 14 3 80 10 1 9 0 0 0 0 0 70 47 5 1 0 0 14 3
34514 34514 170313903002008 2 1000000US170313903002008 Block 2008, Block Group 2, Census Tract 3903, Cook County, Illinois 298 30 262 2 0 0 1 3 298 287 26 257 1 0 0 0 3 11 4 5 1 0 0 1 0
38161 38161 170311004002009 16 1000000US170311004002009 Block 2009, Block Group 2, Census Tract 1004, Cook County, Illinois 72 64 5 1 2 0 0 0 72 63 61 0 0 2 0 0 0 9 3 5 1 0 0 0 0
41707 41707 170312409001035 12 1000000US170312409001035 Block 1035, Block Group 1, Census Tract 2409, Cook County, Illinois 89 43 20 1 1 0 16 8 89 20 4 15 0 1 0 0 0 69 39 5 1 0 0 16 8
44387 44387 170313006002007 10 1000000US170313006002007 Block 2007, Block Group 2, Census Tract 3006, Cook County, Illinois 157 41 6 1 0 0 93 16 157 6 4 1 0 0 0 0 1 151 37 5 1 0 0 93 15

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