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 = 13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003003, P003005, P003006, P003007, P003008, P005002, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005015, P005016, 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
1042 1042 170313008001006 10 1000000US170313008001006 Block 1006, Block Group 1, Census Tract 3008, Cook County, Illinois 105 30 12 13 0 0 48 2 105 9 0 7 0 0 0 0 2 96 30 5 13 0 0 48 0
2234 2234 170313514001030 2 1000000US170313514001030 Block 1030, Block Group 1, Census Tract 3514, Cook County, Illinois 275 3 254 13 0 0 0 5 275 275 3 254 13 0 0 0 5 0 0 0 0 0 0 0 0
3489 3489 170318351004005 8 1000000US170318351004005 Block 4005, Block Group 4, Census Tract 8351, Cook County, Illinois 93 43 0 13 0 0 37 0 93 15 12 0 3 0 0 0 0 78 31 0 10 0 0 37 0
6575 6575 170311907021001 25 1000000US170311907021001 Block 1001, Block Group 1, Census Tract 1907.02, Cook County, Illinois 166 65 0 13 0 0 88 0 166 2 2 0 0 0 0 0 0 164 63 0 13 0 0 88 0
13814 13814 170312228001002 14 1000000US170312228001002 Block 1002, Block Group 1, Census Tract 2228, Cook County, Illinois 94 40 2 13 0 0 36 3 94 10 9 1 0 0 0 0 0 84 31 1 13 0 0 36 3
16477 16477 170311904022011 25 1000000US170311904022011 Block 2011, Block Group 2, Census Tract 1904.02, Cook County, Illinois 107 41 4 13 3 6 31 9 107 21 14 4 0 3 0 0 0 86 27 0 13 0 6 31 9
20943 20943 170313108002008 12 1000000US170313108002008 Block 2008, Block Group 2, Census Tract 3108, Cook County, Illinois 269 105 14 13 1 0 121 15 269 53 30 13 2 1 0 1 6 216 75 1 11 0 0 120 9
24226 24226 170314313012009 4 1000000US170314313012009 Block 2009, Block Group 2, Census Tract 4313.01, Cook County, Illinois 187 2 170 13 0 0 0 2 187 187 2 170 13 0 0 0 2 0 0 0 0 0 0 0 0
27112 27112 170318407001010 10 1000000US170318407001010 Block 1010, Block Group 1, Census Tract 8407, Cook County, Illinois 195 34 51 13 0 0 93 4 195 74 15 50 5 0 0 1 3 121 19 1 8 0 0 92 1
27864 27864 170318408002009 10 1000000US170318408002009 Block 2009, Block Group 2, Census Tract 8408, Cook County, Illinois 159 52 1 13 0 0 91 2 159 3 2 0 0 0 0 1 0 156 50 1 13 0 0 90 2
30019 30019 170311105022007 16 1000000US170311105022007 Block 2007, Block Group 2, Census Tract 1105.02, Cook County, Illinois 76 46 0 13 10 0 0 7 76 65 39 0 13 10 0 0 3 11 7 0 0 0 0 0 4
36054 36054 170316303002011 8 1000000US170316303002011 Block 2011, Block Group 2, Census Tract 6303, Cook County, Illinois 128 35 0 13 0 0 74 6 128 2 2 0 0 0 0 0 0 126 33 0 13 0 0 74 6
45713 45713 170318397001001 9 1000000US170318397001001 Block 1001, Block Group 1, Census Tract 8397, Cook County, Illinois 388 230 15 13 66 0 55 9 388 246 162 15 0 66 0 0 3 142 68 0 13 0 0 55 6

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