chicago_2010pop_by_2020policedistricts
Data license: CC BY-SA 4.0 · Data source: US Census & Chicago Open Data Portal, combined by John Keefe
2 rows where P003003 = 69202, P003008 = 703, P005007 = 8 and P005008 = 49
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7 | 7 | 7 | 71071 | 511 | 69202 | 149 | 62 | 9 | 435 | 703 | 71071 | 69904 | 262 | 68787 | 136 | 56 | 8 | 49 | 606 | 1167 | 249 | 415 | 13 | 6 | 1 | 386 | 97 |
30 | 30 | 7 | 71071 | 511 | 69202 | 149 | 62 | 9 | 435 | 703 | 71071 | 69904 | 262 | 68787 | 136 | 56 | 8 | 49 | 606 | 1167 | 249 | 415 | 13 | 6 | 1 | 386 | 97 |
Advanced export
JSON shape: default, array, newline-delimited
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 );