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

2,256 rows where dist_num = 18

View and edit SQL

dist_num

  • 18 · 2,256
Link rowid ▼ GEOID10 dist_num
278 170310710002003 18
279 170310710002002 18
294 170310715003001 18
295 170310801005014 18
296 170310814012004 18
310 170310714002003 18
311 170310715003006 18
312 170310801004009 18
313 170310801004006 18
314 170310801003000 18
315 170310814021012 18
316 170310813004004 18
331 170310717002007 18
332 170310803001002 18
333 170318383002001 18
334 170310812012010 18
335 170310815002011 18
336 170310815002012 18
337 170310816001011 18
559 170310715001010 18
576 170310815001002 18
577 170310801005007 18
678 170310818002022 18
916 170310713002012 18
917 170310717001003 18
918 170310717002005 18
919 170310804001008 18
920 170318383002005 18
921 170310818002000 18
937 170310712002011 18
938 170310718001005 18
939 170310716001009 18
940 170310804001010 18
941 170310817002048 18
951 170310711001025 18
952 170318326003017 18
953 170318422001041 18
1011 170318383002012 18
1018 170310818002014 18
1172 170310818002045 18
1459 170318326001009 18
1460 170318422001067 18
1461 170318422001066 18
1491 170310715004010 18
1492 170310811001005 18
1493 170310812012004 18
1494 170310812012005 18
1495 170310815002006 18
1529 170310715006005 18
1530 170310801006001 18
1531 170310812011002 18
1532 170310812011004 18
1613 170310810004000 18
1756 170318326002009 18
1757 170318326002008 18
1809 170310814021005 18
1962 170310802022001 18
1971 170310715004007 18
1972 170310816001001 18
1973 170310816001003 18
1974 170310817002047 18
1981 170318325002011 18
1990 170310812012002 18
1991 170310815002001 18
2019 170310813004008 18
2020 170310814011001 18
2028 170310711002015 18
2029 170310718002003 18
2030 170318422001002 18
2031 170318422001039 18
2032 170318422001058 18
2033 170310819001011 18
2034 170318422001070 18
2035 170310818003014 18
2213 170318325001008 18
2283 170318383001016 18
2293 170310804003001 18
2403 170318325001012 18
2406 170318422001045 18
2435 170318326002007 18
2438 170318326002018 18
2439 170318422001028 18
2607 170310710001017 18
2612 170318325001021 18
2613 170318325001016 18
2619 170310713001001 18
2620 170310710002005 18
2621 170310710002017 18
2821 170310713002000 18
2828 170310801007001 18
2829 170310801002001 18
2830 170310814031021 18
2831 170310814031031 18
2860 170310813002001 18
3198 170310712001016 18
3199 170310713001014 18
3200 170310803003005 18
3201 170310803002005 18
3206 170310818002049 18
3207 170310818002056 18

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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