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

This data as json, CSV (advanced)

Link rowid GEOID10 dist_num ▲
5508 5508 170318105014000 31
5509 5509 170318106002013 31
5510 5510 170318106002029 31
5511 5511 170318106002006 31
5512 5512 170317709011013 31
5513 5513 170318104003050 31
5514 5514 170317709021001 31
5515 5515 170318105025001 31
5516 5516 170318105025008 31
5517 5517 170317709021000 31
5518 5518 170317709021004 31
5598 5598 170311505012010 31
5764 5764 170318105022003 31
5765 5765 170318104003052 31
5766 5766 170318104003054 31
5767 5767 170318106001029 31
5768 5768 170318106003002 31
5769 5769 170318106003008 31
5770 5770 170318105022011 31
5771 5771 170318105022009 31
5772 5772 170318105021011 31
5773 5773 170318105021013 31
5774 5774 170318106002015 31
5775 5775 170318106001018 31
5776 5776 170318106002035 31
5777 5777 170318106002037 31
5778 5778 170318106002036 31
5779 5779 170318105021008 31
5780 5780 170318105023006 31
5781 5781 170318105023004 31
5782 5782 170318105023009 31
5783 5783 170318106001024 31
5784 5784 170318105015013 31
11757 11757 170317709014028 31
11758 11758 170318105021002 31
11759 11759 170318105021016 31
11760 11760 170318106001014 31
11761 11761 170318106002004 31
11762 11762 170318106002000 31
11765 11765 170318105024010 31
11766 11766 170318105024018 31
11767 11767 170318105022000 31
11768 11768 170318105021015 31
11769 11769 170318105021009 31
11770 11770 170318104003062 31
11771 11771 170318104003060 31
11772 11772 170318104003044 31
11773 11773 170318105015003 31
11774 11774 170318105023013 31
11775 11775 170318105013008 31
11776 11776 170318105015006 31
11777 11777 170318105013002 31
11778 11778 170318105013001 31
11779 11779 170318105011016 31
11780 11780 170318105025017 31
11781 11781 170317709021016 31
11782 11782 170318105011013 31
11783 11783 170318106003015 31
11784 11784 170318105015010 31
11785 11785 170317709012010 31
11786 11786 170317709021017 31
11787 11787 170318105011002 31
11788 11788 170318105011012 31
11789 11789 170317709022014 31
11790 11790 170317709022008 31
11792 11792 170317709021007 31
11793 11793 170318105014007 31
11794 11794 170317709011014 31
11795 11795 170317709021008 31
11796 11796 170318105025018 31
11797 11797 170317709011011 31
11798 11798 170317709012000 31
11799 11799 170317709022020 31
11800 11800 170317709012007 31
11801 11801 170318105022005 31
11802 11802 170317709011010 31
11803 11803 170318106001017 31
11804 11804 170318106002043 31
11805 11805 170318105025012 31
11806 11806 170318106002025 31
11807 11807 170318105023011 31
11808 11808 170318106002039 31
11809 11809 170318105024007 31
11810 11810 170318105024015 31
11811 11811 170318105015016 31
11812 11812 170317709014007 31
11813 11813 170317709014029 31
11814 11814 170318105014012 31
12485 12485 170317709022011 31
12486 12486 170317709022022 31
12487 12487 170317709022019 31
12488 12488 170317709022028 31
12489 12489 170317709022003 31
12911 12911 170317709022007 31
12912 12912 170317709022004 31
13469 13469 170317709014005 31
13470 13470 170317709013012 31
13471 13471 170318104003059 31
13472 13472 170318105013007 31
13473 13473 170318105024008 31

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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