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

11 rows where P005005 = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003002, P003003, P003005, P003007, P003008, P005003, P005004, P005006, P005009, P005010, P005011, P005012, P005014, P005016, P005017

P005005 ✖

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
1219 1219 170318318002001 17 1000000US170318318002001 Block 2001, Block Group 2, Census Tract 8318, Cook County, Illinois 61 29 9 8 12 0 2 1 61 51 21 9 8 12 0 0 1 10 8 0 0 0 0 2 0
1643 1643 170318318002002 17 1000000US170318318002002 Block 2002, Block Group 2, Census Tract 8318, Cook County, Illinois 53 32 0 8 4 0 3 6 53 47 32 0 8 4 0 0 3 6 0 0 0 0 0 3 3
9625 9625 170314910002031 5 1000000US170314910002031 Block 2031, Block Group 2, Census Tract 4910, Cook County, Illinois 57 0 49 8 0 0 0 0 57 57 0 49 8 0 0 0 0 0 0 0 0 0 0 0 0
15838 15838 170310514001011 19 1000000US170310514001011 Block 1011, Block Group 1, Census Tract 514, Cook County, Illinois 94 77 2 8 2 0 5 0 94 77 65 2 8 2 0 0 0 17 12 0 0 0 0 5 0
22287 22287 170311404005017 17 1000000US170311404005017 Block 5017, Block Group 5, Census Tract 1404, Cook County, Illinois 110 72 0 8 18 0 12 0 110 74 48 0 8 18 0 0 0 36 24 0 0 0 0 12 0
25278 25278 170311403023008 17 1000000US170311403023008 Block 3008, Block Group 3, Census Tract 1403.02, Cook County, Illinois 160 64 15 8 50 0 14 9 160 122 45 15 8 49 0 0 5 38 19 0 0 1 0 14 4
25445 25445 170316716001011 7 1000000US170316716001011 Block 1011, Block Group 1, Census Tract 6716, Cook County, Illinois 41 0 33 8 0 0 0 0 41 40 0 32 8 0 0 0 0 1 0 1 0 0 0 0 0
29294 29294 170317101001016 6 1000000US170317101001016 Block 1016, Block Group 1, Census Tract 7101, Cook County, Illinois 60 0 52 8 0 0 0 0 60 60 0 52 8 0 0 0 0 0 0 0 0 0 0 0 0
30599 30599 170314401021006 6 1000000US170314401021006 Block 1006, Block Group 1, Census Tract 4401.02, Cook County, Illinois 117 0 107 8 0 0 0 2 117 117 0 107 8 0 0 0 2 0 0 0 0 0 0 0 0
42624 42624 170314314001001 3 1000000US170314314001001 Block 1001, Block Group 1, Census Tract 4314, Cook County, Illinois 431 12 402 8 0 0 2 7 431 421 12 400 8 0 0 0 1 10 0 2 0 0 0 2 6
46192 46192 170318347002012 7 1000000US170318347002012 Block 2012, Block Group 2, Census Tract 8347, Cook County, Illinois 121 1 112 8 0 0 0 0 121 121 1 112 8 0 0 0 0 0 0 0 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
);