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 P005009 = 1222 sorted by P003004

✎ View and edit SQL

This data as json, CSV (advanced)

P005017 ✖

P005009 ✖

  • 1222 · 2 ✖

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
4 4 4 123575 26117 77303 689 311 31 16378 2746 123575 88194 9925 76399 223 258 29 138 1222 35381 16192 904 466 53 2 16240 1524
27 27 4 123575 26117 77303 689 311 31 16378 2746 123575 88194 9925 76399 223 258 29 138 1222 35381 16192 904 466 53 2 16240 1524

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