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

14 rows where P003006 = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dist_num, P003003, P003004, P003005, P003007, P003008, P005003, P005004, P005005, P005006, P005007, P005008, P005009, P005011, P005012, P005013, P005015, P005016, P005017

P003006 ✖

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
149 149 170318316002003 25 1000000US170318316002003 Block 2003, Block Group 2, Census Tract 8316, Cook County, Illinois 148 69 8 7 0 5 49 10 148 38 27 8 0 0 0 0 3 110 42 0 7 0 5 49 7
1406 1406 170311105022016 16 1000000US170311105022016 Block 2016, Block Group 2, Census Tract 1105.02, Cook County, Illinois 44 37 1 0 0 5 1 0 44 33 32 1 0 0 0 0 0 11 5 0 0 0 5 1 0
3808 3808 170315804004007 8 1000000US170315804004007 Block 4007, Block Group 4, Census Tract 5804, Cook County, Illinois 117 16 0 0 0 5 94 2 117 10 10 0 0 0 0 0 0 107 6 0 0 0 5 94 2
4661 4661 170311510024006 16 1000000US170311510024006 Block 4006, Block Group 4, Census Tract 1510.02, Cook County, Illinois 99 41 12 1 7 5 33 0 99 34 9 12 1 7 5 0 0 65 32 0 0 0 0 33 0
4672 4672 170311908002012 25 1000000US170311908002012 Block 2012, Block Group 2, Census Tract 1908, Cook County, Illinois 60 48 0 0 2 5 5 0 60 14 12 0 0 2 0 0 0 46 36 0 0 0 5 5 0
9101 9101 170311408001005 17 1000000US170311408001005 Block 1005, Block Group 1, Census Tract 1408, Cook County, Illinois 163 72 13 10 1 5 55 7 163 57 38 10 0 1 5 0 3 106 34 3 10 0 0 55 4
19548 19548 170317203003009 22 1000000US170317203003009 Block 3009, Block Group 3, Census Tract 7203, Cook County, Illinois 39 34 0 0 0 5 0 0 39 37 32 0 0 0 5 0 0 2 2 0 0 0 0 0 0
21758 21758 170316401001007 8 1000000US170316401001007 Block 1007, Block Group 1, Census Tract 6401, Cook County, Illinois 79 38 0 0 0 5 32 4 79 21 13 0 0 0 0 4 4 58 25 0 0 0 5 28 0
25800 25800 170310206021008 24 1000000US170310206021008 Block 1008, Block Group 1, Census Tract 206.02, Cook County, Illinois 113 66 9 2 20 5 5 6 113 69 39 8 0 20 0 0 2 44 27 1 2 0 5 5 4
29266 29266 170316503011021 8 1000000US170316503011021 Block 1021, Block Group 1, Census Tract 6503.01, Cook County, Illinois 55 23 0 0 0 5 27 0 55 15 15 0 0 0 0 0 0 40 8 0 0 0 5 27 0
36130 36130 170312312004004 11 1000000US170312312004004 Block 4004, Block Group 4, Census Tract 2312, Cook County, Illinois 88 35 38 0 0 5 10 0 88 36 0 36 0 0 0 0 0 52 35 2 0 0 5 10 0
39281 39281 170311105022027 16 1000000US170311105022027 Block 2027, Block Group 2, Census Tract 1105.02, Cook County, Illinois 71 39 4 0 9 5 11 3 71 53 35 4 0 9 5 0 0 18 4 0 0 0 0 11 3
39950 39950 170311904011017 25 1000000US170311904011017 Block 1017, Block Group 1, Census Tract 1904.01, Cook County, Illinois 58 44 0 0 2 5 7 0 58 16 14 0 0 2 0 0 0 42 30 0 0 0 5 7 0
43963 43963 170314905001003 5 1000000US170314905001003 Block 1003, Block Group 1, Census Tract 4905, Cook County, Illinois 291 25 248 0 2 5 3 8 291 281 20 245 0 2 5 1 8 10 5 3 0 0 0 2 0

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