chicago_2010pop_by_2020policedistricts

2010 Chicago population by police district, 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

2 rows where P005008 = 231 sorted by P003006

✎ View and edit SQL

This data as json, CSV (advanced)

P005008 ✖

P005001 ✖

P003005 ✖

Link rowid dist_num 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
8 8 8 247373 118778 53462 1632 2168 61 64904 6368 247373 107519 51491 52219 247 2001 18 231 1312 139854 67287 1243 1385 167 43 64673 5056
31 31 8 247373 118778 53462 1632 2168 61 64904 6368 247373 107519 51491 52219 247 2001 18 231 1312 139854 67287 1243 1385 167 43 64673 5056

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "chicago_2010pop_by_2020policedistricts" (
"dist_num" INTEGER,
  "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
);