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

8 rows where P005013 = 13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003003, P003004, P003005, P003006, P003008, P005002, P005003, P005004, P005005, P005006, P005008, P005009, P005011, P005012, P005015, P005017

P005013 ✖

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
1042 1042 170313008001006 10 1000000US170313008001006 Block 1006, Block Group 1, Census Tract 3008, Cook County, Illinois 105 30 12 13 0 0 48 2 105 9 0 7 0 0 0 0 2 96 30 5 13 0 0 48 0
6575 6575 170311907021001 25 1000000US170311907021001 Block 1001, Block Group 1, Census Tract 1907.02, Cook County, Illinois 166 65 0 13 0 0 88 0 166 2 2 0 0 0 0 0 0 164 63 0 13 0 0 88 0
13814 13814 170312228001002 14 1000000US170312228001002 Block 1002, Block Group 1, Census Tract 2228, Cook County, Illinois 94 40 2 13 0 0 36 3 94 10 9 1 0 0 0 0 0 84 31 1 13 0 0 36 3
16477 16477 170311904022011 25 1000000US170311904022011 Block 2011, Block Group 2, Census Tract 1904.02, Cook County, Illinois 107 41 4 13 3 6 31 9 107 21 14 4 0 3 0 0 0 86 27 0 13 0 6 31 9
26830 26830 170316103001014 9 1000000US170316103001014 Block 1014, Block Group 1, Census Tract 6103, Cook County, Illinois 167 69 8 16 1 0 68 5 167 20 6 8 3 1 0 0 2 147 63 0 13 0 0 68 3
27864 27864 170318408002009 10 1000000US170318408002009 Block 2009, Block Group 2, Census Tract 8408, Cook County, Illinois 159 52 1 13 0 0 91 2 159 3 2 0 0 0 0 1 0 156 50 1 13 0 0 90 2
36054 36054 170316303002011 8 1000000US170316303002011 Block 2011, Block Group 2, Census Tract 6303, Cook County, Illinois 128 35 0 13 0 0 74 6 128 2 2 0 0 0 0 0 0 126 33 0 13 0 0 74 6
45713 45713 170318397001001 9 1000000US170318397001001 Block 1001, Block Group 1, Census Tract 8397, Cook County, Illinois 388 230 15 13 66 0 55 9 388 246 162 15 0 66 0 0 3 142 68 0 13 0 0 55 6

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