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

5 rows where P005014 = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003003, P003004, P003005, P005003, P005004, P005005, P005006, P005009, P005012, P005013, P005017

P005014 ✖

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
6477 6477 170318404002031 9 1000000US170318404002031 Block 2031, Block Group 2, Census Tract 8404, Cook County, Illinois 101 30 0 0 51 0 17 3 101 53 10 0 0 43 0 0 0 48 20 0 0 8 0 17 3
14025 14025 170311510023004 16 1000000US170311510023004 Block 3004, Block Group 3, Census Tract 1510.02, Cook County, Illinois 256 130 10 3 8 0 100 5 256 74 62 9 1 0 0 0 2 182 68 1 2 8 0 100 3
20663 20663 170311203001015 17 1000000US170311203001015 Block 1015, Block Group 1, Census Tract 1203, Cook County, Illinois 49 26 0 0 22 0 0 1 49 36 21 0 0 14 0 0 1 13 5 0 0 8 0 0 0
43798 43798 170311906023012 25 1000000US170311906023012 Block 3012, Block Group 3, Census Tract 1906.02, Cook County, Illinois 135 63 3 0 8 0 55 6 135 23 21 2 0 0 0 0 0 112 42 1 0 8 0 55 6
45158 45158 170311913011011 25 1000000US170311913011011 Block 1011, Block Group 1, Census Tract 1913.01, Cook County, Illinois 108 32 18 0 8 0 46 4 108 24 6 18 0 0 0 0 0 84 26 0 0 8 0 46 4

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