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

4 rows where P005007 = 3 sorted by P005011

✎ View and edit SQL

This data as json, CSV (advanced)

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

P005009 ✖

P005001 ✖

P003002 ✖

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
23 23 31 24266 21756 129 43 1227 6 744 361 24266 22036 20452 116 23 1205 3 23 214 2230 1304 13 20 22 3 721 147
46 46 31 24266 21756 129 43 1227 6 744 361 24266 22036 20452 116 23 1205 3 23 214 2230 1304 13 20 22 3 721 147
10 10 10 118093 38171 40080 1099 321 16 35543 2863 118093 44652 4300 39440 144 239 3 121 405 73441 33871 640 955 82 13 35422 2458
33 33 10 118093 38171 40080 1099 321 16 35543 2863 118093 44652 4300 39440 144 239 3 121 405 73441 33871 640 955 82 13 35422 2458

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