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

View and edit SQL

Link rowid GEOID10 dist_num ▼
5727 170318390001005 1
5756 170313301004074 1
5824 170313302002025 1
5825 170318419002024 1
5922 170318410001028 1
5923 170318391001101 1
5994 170313302002013 1
6015 170312819001012 1
6061 170312819001005 1
6062 170318419001034 1
6065 170313504001004 1
6099 170318391001072 1
6195 170313302002034 1
6196 170318391002059 1
6197 170318419002021 1
6212 170318411001031 1
6213 170313302002040 1
6214 170318390003004 1
6215 170313301001002 1
6216 170313301003011 1
6356 170318410001038 1
6357 170313206002011 1
6358 170318391001091 1
6359 170318391002024 1
6360 170312819001013 1
6379 170318391002020 1
6380 170318391002038 1
6382 170313302002001 1
6383 170313302002002 1
6503 170318392002011 1
6533 170313302002026 1
6651 170318419002089 1
6654 170318392002023 1
6655 170318410001066 1
6672 170318419001032 1
7103 170318419002028 1
7231 170313302001002 1
7232 170313301002010 1
7233 170318390001000 1
7234 170318391001106 1
7235 170318391002018 1
7257 170318410001022 1
7258 170318391001087 1
7259 170312819003002 1
7260 170312819003003 1
7381 170312819003010 1
7518 170318410001054 1
7616 170318391001107 1
7816 170312801002003 1
7836 170310814031008 1
8069 170318391002006 1
8153 170313201002020 1
8154 170313201001008 1
8155 170313201004013 1
8177 170318410001009 1
8178 170318410001060 1
8279 170313201004016 1
8333 170318410001061 1
8356 170318391001016 1
8357 170318391001038 1
8358 170318391001066 1
8585 170313201002013 1
8586 170313201001022 1
8587 170313201001009 1
8706 170318391002047 1
8926 170313206002017 1
8927 170313204001015 1
8928 170313201001020 1
9004 170313201004026 1
9005 170313201004028 1
9147 170313204001002 1
9150 170318419001038 1
9166 170318410001058 1
9167 170313501001004 1
9232 170318410001065 1
9257 170318391001065 1
9343 170313204001001 1
9344 170313201004029 1
9431 170318392002007 1
9432 170318410001026 1
9491 170318419001042 1
9492 170318391002011 1
9494 170313302002009 1
9512 170312801002031 1
9513 170312801002018 1
9514 170318391001082 1
9515 170313204001014 1
9598 170318410001016 1
9599 170313301004044 1
9600 170313301004041 1
9601 170318392002021 1
9702 170313201002028 1
9898 170318391002053 1
10124 170313301001004 1
10356 170318391001052 1
10357 170318391001045 1
10543 170313301004049 1
10763 170318391001014 1
10951 170313206001008 1
10960 170313504001008 1

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