chicago_2010blocks_2020policedistricts_population
Data license: CC BY-SA 4.0 · Data source: US Census & Chicago Open Data Portal, combined by John Keefe
11 rows where P005008 = 9
This data as json, CSV (advanced)
Suggested facets: dist_num, P003001, P003003, P003004, P003005, P003006, P003007, P003008, P005001, P005003, P005004, P005005, P005006, P005007, P005009, P005010, P005011, P005012, P005013, P005014, P005015, P005016, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1131 | 1131 | 170316608001007 | 8 | 1000000US170316608001007 | Block 1007, Block Group 1, Census Tract 6608, Cook County, Illinois | 75 | 0 | 55 | 0 | 0 | 0 | 9 | 11 | 75 | 75 | 0 | 55 | 0 | 0 | 0 | 9 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
9754 | 9754 | 170311502002017 | 16 | 1000000US170311502002017 | Block 2017, Block Group 2, Census Tract 1502, Cook County, Illinois | 63 | 39 | 0 | 0 | 1 | 0 | 17 | 6 | 63 | 35 | 25 | 0 | 0 | 1 | 0 | 9 | 0 | 28 | 14 | 0 | 0 | 0 | 0 | 8 | 6 |
11283 | 11283 | 170310209011011 | 24 | 1000000US170310209011011 | Block 1011, Block Group 1, Census Tract 209.01, Cook County, Illinois | 142 | 40 | 15 | 6 | 56 | 0 | 19 | 6 | 142 | 117 | 26 | 15 | 5 | 56 | 0 | 9 | 6 | 25 | 14 | 0 | 1 | 0 | 0 | 10 | 0 |
17311 | 17311 | 170310402011009 | 20 | 1000000US170310402011009 | Block 1009, Block Group 1, Census Tract 402.01, Cook County, Illinois | 82 | 46 | 0 | 0 | 0 | 0 | 21 | 15 | 82 | 53 | 33 | 0 | 0 | 0 | 0 | 9 | 11 | 29 | 13 | 0 | 0 | 0 | 0 | 12 | 4 |
21883 | 21883 | 170311607003010 | 17 | 1000000US170311607003010 | Block 3010, Block Group 3, Census Tract 1607, Cook County, Illinois | 83 | 54 | 2 | 0 | 11 | 0 | 14 | 2 | 83 | 46 | 24 | 2 | 0 | 11 | 0 | 9 | 0 | 37 | 30 | 0 | 0 | 0 | 0 | 5 | 2 |
22221 | 22221 | 170317608011017 | 16 | 1000000US170317608011017 | Block 1017, Block Group 1, Census Tract 7608.01, Cook County, Illinois | 1590 | 980 | 159 | 0 | 342 | 3 | 62 | 44 | 1590 | 1422 | 888 | 154 | 0 | 341 | 1 | 9 | 29 | 168 | 92 | 5 | 0 | 1 | 2 | 53 | 15 |
26905 | 26905 | 170312207023002 | 25 | 1000000US170312207023002 | Block 3002, Block Group 3, Census Tract 2207.02, Cook County, Illinois | 63 | 26 | 0 | 0 | 0 | 0 | 37 | 0 | 63 | 20 | 11 | 0 | 0 | 0 | 0 | 9 | 0 | 43 | 15 | 0 | 0 | 0 | 0 | 28 | 0 |
30047 | 30047 | 170311407011005 | 17 | 1000000US170311407011005 | Block 1005, Block Group 1, Census Tract 1407.01, Cook County, Illinois | 125 | 35 | 0 | 1 | 47 | 0 | 35 | 7 | 125 | 57 | 12 | 0 | 1 | 35 | 0 | 9 | 0 | 68 | 23 | 0 | 0 | 12 | 0 | 26 | 7 |
34075 | 34075 | 170311301001019 | 17 | 1000000US170311301001019 | Block 1019, Block Group 1, Census Tract 1301, Cook County, Illinois | 50 | 32 | 0 | 0 | 9 | 0 | 9 | 0 | 50 | 50 | 32 | 0 | 0 | 9 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
39365 | 39365 | 170310404025005 | 20 | 1000000US170310404025005 | Block 5005, Block Group 5, Census Tract 404.02, Cook County, Illinois | 171 | 128 | 3 | 0 | 9 | 0 | 25 | 6 | 171 | 130 | 108 | 3 | 0 | 5 | 0 | 9 | 5 | 41 | 20 | 0 | 0 | 4 | 0 | 16 | 1 |
43734 | 43734 | 170313106002016 | 12 | 1000000US170313106002016 | Block 2016, Block Group 2, Census Tract 3106, Cook County, Illinois | 153 | 75 | 8 | 0 | 0 | 0 | 63 | 7 | 153 | 40 | 25 | 6 | 0 | 0 | 0 | 9 | 0 | 113 | 50 | 2 | 0 | 0 | 0 | 54 | 7 |
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 );