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 descending

View and edit SQL

Link rowid GEOID10 ▲ dist_num
46755 170438408023001 16
93541 170438408023001 16
46722 170438408023000 16
93508 170438408023000 16
46741 170438408011019 16
93527 170438408011019 16
46715 170438408011018 16
93501 170438408011018 16
46756 170438408011014 16
93542 170438408011014 16
46726 170438408011013 16
93512 170438408011013 16
46727 170438408011012 16
93513 170438408011012 16
46752 170438408011011 16
93538 170438408011011 16
46718 170438408011006 16
93504 170438408011006 16
46737 170438408011005 16
93523 170438408011005 16
46728 170438408011003 16
93514 170438408011003 16
46758 170438408011002 16
93544 170438408011002 16
46747 170438408011001 16
93533 170438408011001 16
46724 170438408011000 16
93510 170438408011000 16
46733 170438400002082 16
93519 170438400002082 16
46749 170438400002081 16
93535 170438400002081 16
46743 170438400002070 16
93529 170438400002070 16
46736 170438400002061 16
93522 170438400002061 16
46745 170438400002057 16
93531 170438400002057 16
46753 170438400002056 16
93539 170438400002056 16
46742 170438400002055 16
93528 170438400002055 16
46759 170438400002054 16
93545 170438400002054 16
46754 170438400002053 16
93540 170438400002053 16
46744 170438400002052 16
93530 170438400002052 16
46751 170438400002051 16
93537 170438400002051 16
46723 170438400002049 16
93509 170438400002049 16
46738 170438400002048 16
93524 170438400002048 16
46734 170438400002044 16
93520 170438400002044 16
46748 170438400002043 16
93534 170438400002043 16
46732 170438400002042 16
93518 170438400002042 16
46714 170438400002041 16
93500 170438400002041 16
46730 170438400002040 16
93516 170438400002040 16
46757 170438400002039 16
93543 170438400002039 16
46725 170438400002038 16
93511 170438400002038 16
46735 170438400002037 16
93521 170438400002037 16
46729 170438400002036 16
93515 170438400002036 16
46731 170438400002010 16
93517 170438400002010 16
46716 170438400002009 16
93502 170438400002009 16
46720 170438400002008 16
93506 170438400002008 16
46719 170438400002007 16
93505 170438400002007 16
46721 170438400002006 16
93507 170438400002006 16
46750 170438400002005 16
93536 170438400002005 16
46717 170438400002004 16
93503 170438400002004 16
46740 170438400002003 16
93526 170438400002003 16
46746 170438400002002 16
93532 170438400002002 16
46739 170438400002001 16
93525 170438400002001 16
46713 170438400002000 16
93499 170438400002000 16
7072 170319801001010 8
53858 170319801001010 8
29007 170319801001009 8
75793 170319801001009 8
36564 170319801001008 8
83350 170319801001008 8

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