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 P005011 = 2256 sorted by P005001

✎ View and edit SQL

This data as json, CSV (advanced)

P005011 ✖

  • 2256 · 2 ✖

P005006 ✖

P003003 ✖

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
1 1 1 62781 35208 13657 138 10835 29 1088 1826 62781 59015 32952 13452 95 10790 22 157 1547 3766 2256 205 43 45 7 931 279
24 24 1 62781 35208 13657 138 10835 29 1088 1826 62781 59015 32952 13452 95 10790 22 157 1547 3766 2256 205 43 45 7 931 279

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