chicago_2010blocks_2020policedistricts_key

Just a list of US Census block numbers and the police districts in which they sit. Join this to US Census tables to get aggregates by precinct, as those precincts existed in 2020. For details see this blog post.

Data license: CC BY-SA 4.0 · Data source: US Census & Chicago Open Data Portal, combined by John Keefe

896 rows where dist_num = 31

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 31 · 896 ✖
Link rowid ▼ GEOID10 dist_num
1 1 170318105015005 31
2 2 170318105015000 31
3 3 170318105023016 31
4 4 170317709014009 31
5 5 170318105012006 31
6 6 170317709013002 31
7 7 170318106002016 31
8 8 170317709013001 31
9 9 170317709011012 31
10 10 170317709012001 31
11 11 170317709011016 31
12 12 170318104003038 31
13 13 170318106001033 31
14 14 170318106002008 31
15 15 170318105021010 31
16 16 170318105021014 31
17 17 170318105022010 31
18 18 170317709022015 31
19 19 170317709011009 31
20 20 170318106001025 31
21 21 170318105022022 31
22 22 170318106002012 31
23 23 170318106002023 31
24 24 170318106002024 31
25 25 170318106001019 31
26 26 170318106002034 31
27 27 170318106001034 31
28 28 170318105022006 31
29 29 170318104003066 31
30 30 170318106001002 31
31 31 170318106003001 31
32 32 170318105024003 31
33 33 170318105023001 31
34 34 170318105023005 31
35 35 170318104003063 31
36 36 170318104003057 31
37 37 170318106001026 31
38 38 170318105022014 31
39 39 170318105024013 31
40 40 170318105025006 31
41 41 170318105015014 31
42 42 170317709014023 31
43 43 170318105012002 31
44 44 170318105022019 31
45 45 170318105015002 31
46 46 170318106001012 31
47 47 170317709011007 31
48 48 170317709022001 31
49 49 170317709022023 31
50 50 170318105015012 31
51 51 170318105011011 31
52 52 170318105025004 31
53 53 170317709011006 31
54 54 170317709011017 31
55 55 170318105012000 31
56 56 170318106003018 31
57 57 170318104003042 31
58 58 170318106002005 31
59 59 170317709022017 31
60 60 170317709021009 31
688 688 170318105015007 31
689 689 170318105015026 31
690 690 170318105014014 31
691 691 170317709014003 31
692 692 170317709014008 31
693 693 170317709021012 31
694 694 170318106003012 31
695 695 170318105021004 31
1811 1811 170317709022016 31
2297 2297 170317709022006 31
2715 2715 170317709022005 31
3077 3077 170317709022002 31
5233 5233 170318105024017 31
5234 5234 170317709014020 31
5235 5235 170318104003045 31
5236 5236 170318105022017 31
5237 5237 170317709013009 31
5238 5238 170318106001028 31
5239 5239 170318106001007 31
5240 5240 170318106001008 31
5241 5241 170318105015024 31
5242 5242 170317709014014 31
5243 5243 170318106003013 31
5244 5244 170317709013005 31
5245 5245 170318104003064 31
5246 5246 170318105015015 31
5247 5247 170318105015017 31
5248 5248 170318105015009 31
5249 5249 170318105011010 31
5250 5250 170318105011015 31
5498 5498 170318106002046 31
5499 5499 170318106002021 31
5500 5500 170318105025005 31
5501 5501 170317709021018 31
5502 5502 170318105014006 31
5503 5503 170318105012010 31
5504 5504 170317709012012 31
5505 5505 170317709021019 31
5506 5506 170317709021014 31
5507 5507 170318105022013 31

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "chicago_2010blocks_2020policedistricts_key" (
"GEOID10" INTEGER,
  "dist_num" INTEGER
);