chicago_2010blocks_2020policedistricts_population
Data license: CC BY-SA 4.0 · Data source: US Census & Chicago Open Data Portal, combined by John Keefe
3 rows where P005008 = 4 and P005012 = 4
This data as json, CSV (advanced)
Suggested facets: P003004, P003005, P005005, P005006, P005009, P005017
Link | rowid ▼ | GEOID10 | dist_num | GEO_ID | NAME_x | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13229 | 13229 | 170312502002007 | 25 | 1000000US170312502002007 | Block 2007, Block Group 2, Census Tract 2502, Cook County, Illinois | 81 | 9 | 60 | 0 | 0 | 0 | 12 | 0 | 81 | 61 | 1 | 56 | 0 | 0 | 0 | 4 | 0 | 20 | 8 | 4 | 0 | 0 | 0 | 8 | 0 |
13709 | 13709 | 170311607005009 | 17 | 1000000US170311607005009 | Block 5009, Block Group 5, Census Tract 1607, Cook County, Illinois | 87 | 41 | 5 | 0 | 0 | 0 | 38 | 3 | 87 | 10 | 5 | 1 | 0 | 0 | 0 | 4 | 0 | 77 | 36 | 4 | 0 | 0 | 0 | 34 | 3 |
19157 | 19157 | 170314301021004 | 3 | 1000000US170314301021004 | Block 1004, Block Group 1, Census Tract 4301.02, Cook County, Illinois | 301 | 12 | 272 | 2 | 1 | 0 | 9 | 5 | 301 | 292 | 12 | 268 | 2 | 1 | 0 | 4 | 5 | 9 | 0 | 4 | 0 | 0 | 0 | 5 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "chicago_2010blocks_2020policedistricts_population" ( "GEOID10" INTEGER, "dist_num" INTEGER, "GEO_ID" TEXT, "NAME_x" TEXT, "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 );