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

2,388 rows where dist_num = 3

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 3 · 2,388 ✖
Link rowid ▼ GEOID10 dist_num
125 125 170314304004002 3
128 128 170316904002012 3
129 129 170316904002019 3
174 174 170314305002003 3
553 553 170318439001029 3
554 554 170314302005013 3
555 555 170314302005008 3
578 578 170314205001003 3
584 584 170314301021003 3
665 665 170314201001024 3
676 676 170314201001022 3
685 685 170318418002018 3
780 780 170314307001002 3
781 781 170314110003012 3
1178 1178 170314305003003 3
1179 1179 170314305003002 3
1266 1266 170318425001016 3
1310 1310 170316903001000 3
1312 1312 170318425001018 3
1724 1724 170316909002000 3
1725 1725 170318418002017 3
1726 1726 170316909003002 3
1727 1727 170314304001002 3
1728 1728 170314303002005 3
1729 1729 170314304002003 3
1730 1730 170314304001012 3
1731 1731 170314305003008 3
1732 1732 170314305001000 3
1765 1765 170318418001029 3
1766 1766 170318418002053 3
1767 1767 170318418002052 3
1768 1768 170318418001016 3
1771 1771 170316905001006 3
1772 1772 170316904003010 3
2219 2219 170314301011006 3
2220 2220 170314301011000 3
2262 2262 170314201001001 3
2269 2269 170314302004005 3
2341 2341 170316904004009 3
2668 2668 170314207004006 3
2669 2669 170314207001010 3
2670 2670 170314205002011 3
2671 2671 170314206002011 3
2672 2672 170314206002007 3
2673 2673 170314207005006 3
2674 2674 170314008001008 3
2675 2675 170316910001003 3
2676 2676 170316910001007 3
2677 2677 170316905001029 3
2678 2678 170316904002017 3
2679 2679 170316910002000 3
2680 2680 170316910002007 3
2681 2681 170316909005012 3
2682 2682 170316909005014 3
2703 2703 170314309002004 3
3415 3415 170314304003006 3
3416 3416 170314304004000 3
3417 3417 170314309002009 3
3418 3418 170314309002015 3
3419 3419 170314308001015 3
3420 3420 170314308002013 3
3816 3816 170314212002009 3
3819 3819 170314208002007 3
3820 3820 170318418002044 3
3821 3821 170318418001021 3
4015 4015 170314308001008 3
4016 4016 170314205001001 3
4017 4017 170314204001014 3
4018 4018 170314206001011 3
4019 4019 170314206001002 3
4105 4105 170318425001011 3
4106 4106 170316904002003 3
4795 4795 170318344001000 3
4796 4796 170314203001006 3
4797 4797 170318418002023 3
4798 4798 170318418002026 3
4799 4799 170314304004011 3
4879 4879 170314304003003 3
4880 4880 170314305003004 3
4951 4951 170314208001001 3
4952 4952 170318344002008 3
4953 4953 170318344003013 3
4954 4954 170314207002012 3
4955 4955 170318418002001 3
4956 4956 170314303003003 3
4957 4957 170318439002006 3
4958 4958 170314207001008 3
5013 5013 170314302003002 3
5014 5014 170314302001003 3
5015 5015 170314110002004 3
5016 5016 170314110002007 3
5033 5033 170314207001001 3
5034 5034 170314203001005 3
5065 5065 170314304004005 3
5131 5131 170314207002001 3
5132 5132 170314303001007 3
5133 5133 170318344002000 3
5227 5227 170316909002009 3
5228 5228 170316909002008 3
5258 5258 170316905001000 3

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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