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

15 rows where P005007 = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003001, P003003, P003004, P003007, P003008, P005001, P005002, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005016, P005017

P005007 ✖

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
3300 3300 170311502004016 16 1000000US170311502004016 Block 4016, Block Group 4, Census Tract 1502, Cook County, Illinois 38 31 0 0 0 4 0 3 38 36 29 0 0 0 4 0 3 2 2 0 0 0 0 0 0
3398 3398 170318343001012 4 1000000US170318343001012 Block 1012, Block Group 1, Census Tract 8343, Cook County, Illinois 169 4 154 2 0 4 4 1 169 165 4 154 2 0 4 0 1 4 0 0 0 0 0 4 0
6946 6946 170316303002015 8 1000000US170316303002015 Block 2015, Block Group 2, Census Tract 6303, Cook County, Illinois 202 46 0 0 0 4 152 0 202 7 1 0 0 0 4 2 0 195 45 0 0 0 0 150 0
12900 12900 170317306001003 22 1000000US170317306001003 Block 1003, Block Group 1, Census Tract 7306, Cook County, Illinois 83 0 79 0 0 4 0 0 83 83 0 79 0 0 4 0 0 0 0 0 0 0 0 0 0
16079 16079 170314603011003 4 1000000US170314603011003 Block 1003, Block Group 1, Census Tract 4603.01, Cook County, Illinois 83 29 40 0 0 4 9 1 83 45 2 39 0 0 4 0 0 38 27 1 0 0 0 9 1
21865 21865 170312504001008 25 1000000US170312504001008 Block 1008, Block Group 1, Census Tract 2504, Cook County, Illinois 87 1 77 0 0 4 0 5 87 81 1 71 0 0 4 0 5 6 0 6 0 0 0 0 0
25122 25122 170311911002012 25 1000000US170311911002012 Block 2012, Block Group 2, Census Tract 1911, Cook County, Illinois 62 30 0 3 0 4 25 0 62 7 3 0 0 0 4 0 0 55 27 0 3 0 0 25 0
31404 31404 170310402021001 20 1000000US170310402021001 Block 1001, Block Group 1, Census Tract 402.02, Cook County, Illinois 52 18 0 0 28 4 1 1 52 50 17 0 0 28 4 0 1 2 1 0 0 0 0 1 0
32540 32540 170310815002004 18 1000000US170310815002004 Block 2004, Block Group 2, Census Tract 815, Cook County, Illinois 440 345 12 1 72 4 1 5 440 422 330 12 1 71 4 0 4 18 15 0 0 1 0 1 1
34504 34504 170318399002020 9 1000000US170318399002020 Block 2020, Block Group 2, Census Tract 8399, Cook County, Illinois 83 45 3 0 25 4 3 3 83 63 30 3 0 25 4 0 1 20 15 0 0 0 0 3 2
35286 35286 170310814033005 18 1000000US170310814033005 Block 3005, Block Group 3, Census Tract 814.03, Cook County, Illinois 462 326 21 0 96 4 1 14 462 449 315 21 0 96 4 0 13 13 11 0 0 0 0 1 1
35844 35844 170315201001040 4 1000000US170315201001040 Block 1040, Block Group 1, Census Tract 5201, Cook County, Illinois 101 32 0 6 0 4 48 11 101 11 6 0 0 0 4 0 1 90 26 0 6 0 0 48 10
44057 44057 170318318003009 17 1000000US170318318003009 Block 3009, Block Group 3, Census Tract 8318, Cook County, Illinois 61 36 0 0 10 4 4 7 61 52 30 0 0 10 4 1 7 9 6 0 0 0 0 3 0
44070 44070 170312421001007 12 1000000US170312421001007 Block 1007, Block Group 1, Census Tract 2421, Cook County, Illinois 78 40 1 8 4 4 21 0 78 38 29 1 0 4 4 0 0 40 11 0 8 0 0 21 0
45615 45615 170314603011004 4 1000000US170314603011004 Block 1004, Block Group 1, Census Tract 4603.01, Cook County, Illinois 83 6 66 0 0 4 7 0 83 70 0 66 0 0 4 0 0 13 6 0 0 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
);