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 GEOID10

View and edit SQL

Link rowid GEOID10 ▼ dist_num
41430 170310102012007 24
88216 170310102012007 24
22111 170310102012008 24
68897 170310102012008 24
42911 170310102012009 24
89697 170310102012009 24
39473 170310102012010 24
86259 170310102012010 24
42912 170310102012011 24
89698 170310102012011 24
1497 170310102012012 24
48283 170310102012012 24
39478 170310102012013 24
86264 170310102012013 24
17365 170310102012014 24
64151 170310102012014 24
28483 170310102012015 24
75269 170310102012015 24
38045 170310102012016 24
84831 170310102012016 24
342 170310102012017 24
47128 170310102012017 24
36945 170310102012018 24
83731 170310102012018 24
41431 170310102012019 24
88217 170310102012019 24
36687 170310102012020 24
83473 170310102012020 24
1253 170310102012021 24
48039 170310102012021 24
2622 170310102012022 24
49408 170310102012022 24
41890 170310102012023 24
88676 170310102012023 24
2017 170310102012024 24
48803 170310102012024 24
36946 170310102012025 24
83732 170310102012025 24
34921 170310102012026 24
81707 170310102012026 24
11525 170310102012027 24
58311 170310102012027 24
16768 170310102012028 24
63554 170310102012028 24
41891 170310102012029 24
88677 170310102012029 24
10795 170310102012030 24
57581 170310102012030 24
38046 170310102012031 24
84832 170310102012031 24
36688 170310102012032 24
83474 170310102012032 24
34427 170310102012033 24
81213 170310102012033 24
2623 170310102012034 24
49409 170310102012034 24
11526 170310102012035 24
58312 170310102012035 24
41153 170310102012036 24
87939 170310102012036 24
41889 170310102012037 24
88675 170310102012037 24
42175 170310102012038 24
88961 170310102012038 24
34426 170310102012039 24
81212 170310102012039 24
1758 170310102012040 24
48544 170310102012040 24
20685 170310102013000 24
67471 170310102013000 24
8989 170310102013001 24
55775 170310102013001 24
41896 170310102013002 24
88682 170310102013002 24
34433 170310102013003 24
81219 170310102013003 24
2419 170310102013004 24
49205 170310102013004 24
34803 170310102013005 24
81589 170310102013005 24
42176 170310102013006 24
88962 170310102013006 24
34929 170310102013007 24
81715 170310102013007 24
45357 170310102013008 24
92143 170310102013008 24
18592 170310102013009 24
65378 170310102013009 24
15038 170310102013010 24
61824 170310102013010 24
36279 170310102013011 24
83065 170310102013011 24
9462 170310102021000 24
56248 170310102021000 24
30073 170310102021001 24
76859 170310102021001 24
23007 170310102021002 24
69793 170310102021002 24
2777 170310102021003 24
49563 170310102021003 24

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 26.588ms · Data license: CC BY-SA 4.0 · Data source: US Census & Chicago Open Data Portal, combined by John Keefe