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 ▼
10983 170318391001003 1
10997 170318410001012 1
10998 170318410001059 1
10999 170318392001001 1
11000 170313501002009 1
11012 170318410001034 1
11013 170318410001032 1
11179 170318390003010 1
11200 170313301004021 1
11201 170313301004075 1
11607 170313204001040 1
11608 170318419001005 1
11847 170313201002017 1
11965 170318419002078 1
11977 170318419001045 1
11995 170313201003002 1
12000 170313301004004 1
12001 170313301004027 1
12002 170313301004025 1
12003 170313301004076 1
12049 170318391001009 1
12082 170313301003005 1
12091 170318419001052 1
12104 170313201004008 1
12113 170313301004005 1
12138 170313201003007 1
12174 170318391001105 1
12175 170318391002045 1
12181 170313504001006 1
12182 170318410001070 1
12217 170318410001045 1
12218 170313206002014 1
12259 170313301004085 1
12260 170313501002002 1
12466 170313302002008 1
12605 170318390001003 1
12606 170318419002023 1
12607 170318419002020 1
12608 170318419002004 1
12616 170313206001011 1
12617 170318391002044 1
12618 170318391002037 1
12619 170318419001044 1
12701 170313201004000 1
12904 170318391001011 1
12905 170313201002004 1
12906 170313301004034 1
13045 170318390001006 1
13046 170318419002025 1
13123 170318419002084 1
13124 170318419002116 1
13200 170313501001003 1
13201 170318391001069 1
13401 170313301003014 1
13413 170313301003003 1
13496 170318419002091 1
13574 170313206002007 1
13910 170318419001033 1
13938 170313301002016 1
13939 170313301004016 1
14082 170313301004010 1
14083 170313301004003 1
14084 170313301004070 1
14335 170318410001048 1
14336 170318390004000 1
14337 170313301002005 1
14338 170318391002046 1
14407 170313201002015 1
14408 170313201003006 1
14428 170313201002024 1
14588 170313501001010 1
14589 170313501001011 1
14598 170313504001007 1
14827 170313201004012 1
14832 170313206001002 1
14833 170313201001000 1
14841 170313501002001 1
14987 170313301002013 1
15198 170313501002005 1
15207 170313501001009 1
15514 170313301003004 1
15516 170318392001004 1
15558 170313204001038 1
15561 170313201004030 1
15657 170318390002003 1
15658 170313301003012 1
15659 170318391002051 1
16055 170318391001089 1
16056 170318391002000 1
16057 170318391002001 1
16058 170312819003000 1
16064 170318392002018 1
16112 170313301004083 1
16379 170318392002006 1
16441 170313301004032 1
16442 170313204001020 1
16673 170318391001075 1
16674 170318391001039 1
16710 170313201004017 1
16914 170318410001047 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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