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

12 rows where P005012 = 12 sorted by P005012

✎ View and edit SQL

This data as json, CSV (advanced)

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

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
1989 1989 170312311001014 11 1000000US170312311001014 Block 1014, Block Group 1, Census Tract 2311, Cook County, Illinois 63 3 56 0 0 0 4 0 63 44 0 44 0 0 0 0 0 19 3 12 0 0 0 4 0
6087 6087 170314602001008 4 1000000US170314602001008 Block 1008, Block Group 1, Census Tract 4602, Cook County, Illinois 74 7 43 0 0 0 24 0 74 31 0 31 0 0 0 0 0 43 7 12 0 0 0 24 0
7376 7376 170314607001004 4 1000000US170314607001004 Block 1004, Block Group 1, Census Tract 4607, Cook County, Illinois 929 10 868 0 0 0 38 13 929 869 5 856 0 0 0 2 6 60 5 12 0 0 0 36 7
10788 10788 170312309001018 14 1000000US170312309001018 Block 1018, Block Group 1, Census Tract 2309, Cook County, Illinois 139 33 57 7 0 0 40 2 139 61 15 45 0 0 0 1 0 78 18 12 7 0 0 39 2
11525 11525 170310102012027 24 1000000US170310102012027 Block 2027, Block Group 2, Census Tract 102.01, Cook County, Illinois 116 25 73 0 2 0 14 2 116 81 16 61 0 2 0 0 2 35 9 12 0 0 0 14 0
18505 18505 170316706001016 7 1000000US170316706001016 Block 1016, Block Group 1, Census Tract 6706, Cook County, Illinois 83 0 83 0 0 0 0 0 83 71 0 71 0 0 0 0 0 12 0 12 0 0 0 0 0
21868 21868 170311913013013 25 1000000US170311913013013 Block 3013, Block Group 3, Census Tract 1913.01, Cook County, Illinois 39 8 12 0 5 0 14 0 39 5 0 0 0 5 0 0 0 34 8 12 0 0 0 14 0
22156 22156 170313204001043 1 1000000US170313204001043 Block 1043, Block Group 1, Census Tract 3204, Cook County, Illinois 1470 994 319 7 41 2 51 56 1470 1329 931 307 6 41 2 4 38 141 63 12 1 0 0 47 18
25279 25279 170311403023005 17 1000000US170311403023005 Block 3005, Block Group 3, Census Tract 1403.02, Cook County, Illinois 510 271 78 5 90 1 33 32 510 355 188 66 0 90 1 0 10 155 83 12 5 0 0 33 22
30147 30147 170311908002006 25 1000000US170311908002006 Block 2006, Block Group 2, Census Tract 1908, Cook County, Illinois 121 44 12 4 0 0 57 4 121 9 9 0 0 0 0 0 0 112 35 12 4 0 0 57 4
33108 33108 170312309002012 14 1000000US170312309002012 Block 2012, Block Group 2, Census Tract 2309, Cook County, Illinois 76 31 18 0 0 0 20 7 76 15 9 6 0 0 0 0 0 61 22 12 0 0 0 20 7
46253 46253 170312604001031 11 1000000US170312604001031 Block 1031, Block Group 1, Census Tract 2604, Cook County, Illinois 174 0 167 0 0 0 0 7 174 162 0 155 0 0 0 0 7 12 0 12 0 0 0 0 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
);