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

3,922 rows where dist_num = 6

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 6 · 3,922 ✖
Link rowid ▼ GEOID10 dist_num
85 85 170317108002011 6
86 86 170317101001023 6
117 117 170317110001001 6
510 510 170317109001025 6
511 511 170317109001005 6
512 512 170317109002043 6
513 513 170317109002032 6
709 709 170317107004011 6
715 715 170317106002005 6
716 716 170317106001005 6
717 717 170317107001007 6
737 737 170314409003008 6
738 738 170316912002022 6
743 743 170314408001000 6
770 770 170317107002010 6
771 771 170317108005007 6
1188 1188 170317111003023 6
1227 1227 170318340002022 6
1246 1246 170317110002012 6
1313 1313 170318424001041 6
1314 1314 170314403001008 6
1325 1325 170318340002033 6
1326 1326 170318340001036 6
1329 1329 170318340002030 6
1346 1346 170318424003011 6
1347 1347 170316912003015 6
1354 1354 170314408002012 6
1355 1355 170314409002020 6
1723 1723 170316915002007 6
1773 1773 170314403002017 6
1780 1780 170314401013004 6
1789 1789 170314904001032 6
1813 1813 170317111003021 6
1819 1819 170317112004049 6
1825 1825 170317104005020 6
1838 1838 170318424001001 6
1846 1846 170317108004006 6
1847 1847 170317108001006 6
1848 1848 170317102001014 6
1854 1854 170317109001009 6
1862 1862 170314406001026 6
1863 1863 170317111001004 6
1864 1864 170317111002018 6
1869 1869 170317110002018 6
1870 1870 170317110002029 6
1876 1876 170318424002072 6
2259 2259 170318424002044 6
2261 2261 170317112001025 6
2307 2307 170317107004009 6
2308 2308 170317111003003 6
2315 2315 170317104005011 6
2331 2331 170316912003008 6
2343 2343 170318424002031 6
2351 2351 170317108005010 6
2352 2352 170317108005008 6
2523 2523 170317112003021 6
2683 2683 170316913001020 6
2684 2684 170316913001025 6
2685 2685 170316914004011 6
2686 2686 170316913002010 6
2687 2687 170316913002004 6
2688 2688 170316914003002 6
2689 2689 170314402014012 6
2690 2690 170314403002009 6
2691 2691 170314403004018 6
2741 2741 170314903002001 6
2747 2747 170317109002001 6
2762 2762 170316912001010 6
2763 2763 170318424003032 6
2764 2764 170318340002008 6
2767 2767 170314903002012 6
2875 2875 170317112004026 6
2876 2876 170317112004018 6
2877 2877 170317112004002 6
2878 2878 170317112003014 6
2879 2879 170317111003017 6
2890 2890 170317110003016 6
2892 2892 170317110003011 6
2893 2893 170317110003009 6
2894 2894 170317111001013 6
2895 2895 170317110003004 6
2896 2896 170317111002010 6
2897 2897 170317111001009 6
2898 2898 170317110001009 6
2899 2899 170317107003009 6
2900 2900 170317107004008 6
2901 2901 170317106002011 6
2902 2902 170317106001008 6
2903 2903 170317112001014 6
2904 2904 170317112001003 6
3047 3047 170314403002031 6
3048 3048 170314403003014 6
3049 3049 170314403003015 6
3050 3050 170314406001005 6
3051 3051 170314406001009 6
3052 3052 170314407002013 6
3053 3053 170314406001028 6
3054 3054 170314409002006 6
3055 3055 170314408002009 6
3056 3056 170314903001010 6

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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