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

1,728 rows where dist_num = 15

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 15 · 1,728 ✖
Link rowid ▼ GEOID10 dist_num
131 131 170318314002059 15
132 132 170318314002049 15
134 134 170312522025004 15
135 135 170312519001015 15
181 181 170312513005008 15
376 376 170312510001001 15
377 377 170312511001001 15
378 378 170312511004005 15
381 381 170312522025002 15
587 587 170312519001000 15
592 592 170312510001016 15
593 593 170312513003008 15
599 599 170312514001001 15
600 600 170318314002054 15
601 601 170312521022006 15
647 647 170312520003007 15
784 784 170312516001002 15
785 785 170312512002004 15
786 786 170312512003001 15
889 889 170312511002006 15
897 897 170312512001003 15
1014 1014 170312512004015 15
1015 1015 170312512001010 15
1016 1016 170312510001015 15
1021 1021 170312513002003 15
1022 1022 170312511003007 15
1023 1023 170312512003007 15
1024 1024 170312514004004 15
1026 1026 170312519001012 15
1360 1360 170312513005003 15
1384 1384 170312513005009 15
1416 1416 170312510001034 15
1562 1562 170312519004014 15
1563 1563 170312519004007 15
1564 1564 170312520003005 15
1790 1790 170312513002012 15
2292 2292 170318314001021 15
2294 2294 170318314001013 15
3268 3268 170312517001040 15
3269 3269 170312516002014 15
3270 3270 170312516003015 15
3573 3573 170312514003001 15
3574 3574 170312514003004 15
3575 3575 170312515003005 15
3576 3576 170312515004008 15
3577 3577 170312515002015 15
3578 3578 170312514002001 15
3579 3579 170312515004012 15
3580 3580 170312514004011 15
3584 3584 170312518005009 15
3585 3585 170312518001002 15
3586 3586 170312518005016 15
3587 3587 170312519001014 15
3588 3588 170312519001011 15
3589 3589 170318314002048 15
3590 3590 170318314002039 15
3591 3591 170318314002031 15
3592 3592 170318314002037 15
3593 3593 170312521021010 15
3594 3594 170312521021004 15
3595 3595 170318314002001 15
3596 3596 170312521023002 15
3597 3597 170312521023014 15
3598 3598 170312522011004 15
3853 3853 170312520003015 15
3854 3854 170312520003013 15
3855 3855 170312520003017 15
3856 3856 170312521011017 15
3857 3857 170312521011007 15
3874 3874 170312522011002 15
3875 3875 170312522013008 15
3876 3876 170312522022000 15
3899 3899 170318314002012 15
3900 3900 170318314001043 15
4090 4090 170312514004027 15
4110 4110 170318314001023 15
4111 4111 170318314002036 15
4112 4112 170312520002005 15
4228 4228 170318314001004 15
4366 4366 170318314002057 15
5003 5003 170312518004013 15
5004 5004 170312518005011 15
5019 5019 170312515001010 15
5020 5020 170312517001050 15
5138 5138 170312516003009 15
5251 5251 170312512001018 15
5272 5272 170312522025003 15
5281 5281 170312515004014 15
5282 5282 170312515002020 15
5283 5283 170312515002016 15
5284 5284 170312514002007 15
5285 5285 170312514004009 15
5323 5323 170312516003012 15
5324 5324 170312516002005 15
5325 5325 170312518004006 15
5538 5538 170318314002028 15
5558 5558 170312519001004 15
5559 5559 170312519002003 15
5560 5560 170312514004024 15
5561 5561 170312514004022 15

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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