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

93,572 rows sorted by dist_num descending

View and edit SQL

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