chicago_2010blocks_2020policedistricts_population

2010 population by US Census block, with each block linked to the police district area in which it sits, 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

13 rows where P003004 = 14

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003003, P003005, P003006, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005015, P005017

P003004 ✖

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
1466 1466 170310105022002 24 1000000US170310105022002 Block 2002, Block Group 2, Census Tract 105.02, Cook County, Illinois 149 101 14 14 11 0 5 4 149 120 93 14 0 11 0 0 2 29 8 0 14 0 0 5 2
2156 2156 170310311003003 20 1000000US170310311003003 Block 3003, Block Group 3, Census Tract 311, Cook County, Illinois 173 126 2 14 16 0 10 5 173 144 110 2 14 16 0 0 2 29 16 0 0 0 0 10 3
5849 5849 170318339001013 4 1000000US170318339001013 Block 1013, Block Group 1, Census Tract 8339, Cook County, Illinois 123 22 49 14 0 0 37 1 123 47 0 46 0 0 0 1 0 76 22 3 14 0 0 36 1
11499 11499 170310306032002 20 1000000US170310306032002 Block 2002, Block Group 2, Census Tract 306.03, Cook County, Illinois 496 259 108 14 28 0 64 23 496 329 181 104 3 28 0 1 12 167 78 4 11 0 0 63 11
27476 27476 170311510023002 16 1000000US170311510023002 Block 3002, Block Group 3, Census Tract 1510.02, Cook County, Illinois 253 146 1 14 0 0 76 16 253 54 53 1 0 0 0 0 0 199 93 0 14 0 0 76 16
29053 29053 170313009001005 10 1000000US170313009001005 Block 1005, Block Group 1, Census Tract 3009, Cook County, Illinois 239 68 5 14 0 0 142 10 239 2 0 2 0 0 0 0 0 237 68 3 14 0 0 142 10
30379 30379 170313109002002 12 1000000US170313109002002 Block 2002, Block Group 2, Census Tract 3109, Cook County, Illinois 186 73 0 14 0 0 91 8 186 23 20 0 0 0 0 0 3 163 53 0 14 0 0 91 5
30780 30780 170312105022003 25 1000000US170312105022003 Block 2003, Block Group 2, Census Tract 2105.02, Cook County, Illinois 221 159 0 14 4 1 26 17 221 65 57 0 0 4 0 0 4 156 102 0 14 0 1 26 13
36002 36002 170312426002002 12 1000000US170312426002002 Block 2002, Block Group 2, Census Tract 2426, Cook County, Illinois 135 66 18 14 3 0 28 6 135 46 33 9 0 3 0 0 1 89 33 9 14 0 0 28 5
37508 37508 170317002002000 8 1000000US170317002002000 Block 2000, Block Group 2, Census Tract 7002, Cook County, Illinois 300 174 8 14 2 0 90 12 300 91 75 8 0 2 0 0 6 209 99 0 14 0 0 90 6
38256 38256 170313018011007 10 1000000US170313018011007 Block 1007, Block Group 1, Census Tract 3018.01, Cook County, Illinois 164 65 2 14 2 0 67 14 164 3 2 0 0 1 0 0 0 161 63 2 14 1 0 67 14
44374 44374 170318435001018 10 1000000US170318435001018 Block 1018, Block Group 1, Census Tract 8435, Cook County, Illinois 94 17 4 14 0 0 56 3 94 4 1 0 3 0 0 0 0 90 16 4 11 0 0 56 3
45028 45028 170311401001008 17 1000000US170311401001008 Block 1008, Block Group 1, Census Tract 1401, Cook County, Illinois 200 74 6 14 48 0 51 7 200 81 22 5 0 48 0 0 6 119 52 1 14 0 0 51 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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