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,938 rows where dist_num = 20

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 20 · 1,938 ✖
Link rowid ▼ GEOID10 dist_num
321 321 170310402022000 20
428 428 170310207011023 20
429 429 170310207012003 20
430 430 170310207012013 20
431 431 170310208012000 20
432 432 170310208013018 20
433 433 170310207012018 20
434 434 170310208011019 20
435 435 170310208011014 20
436 436 170310208011013 20
438 438 170310304002010 20
439 439 170310304002002 20
440 440 170310304002016 20
441 441 170310309001003 20
442 442 170310305002020 20
443 443 170310305002003 20
446 446 170310305003017 20
447 447 170310305003018 20
448 448 170310305001012 20
449 449 170310306013002 20
907 907 170310401001009 20
925 925 170310208013009 20
963 963 170310402012004 20
964 964 170310402023004 20
965 965 170310402012014 20
970 970 170310308002005 20
971 971 170310311003002 20
973 973 170310305002021 20
974 974 170310308001007 20
1464 1464 170310306012000 20
1465 1465 170310306043000 20
1474 1474 170310208013016 20
1476 1476 170310402013012 20
1479 1479 170310402014000 20
1625 1625 170310402022015 20
1626 1626 170310403002017 20
1627 1627 170310402024013 20
1630 1630 170310403003015 20
1631 1631 170310402024001 20
1964 1964 170310304002000 20
1977 1977 170310308003010 20
2015 2015 170310403001007 20
2016 2016 170310403001001 20
2018 2018 170310308002003 20
2126 2126 170310308003011 20
2133 2133 170310402013003 20
2138 2138 170310404014005 20
2139 2139 170310404023006 20
2140 2140 170310404011007 20
2141 2141 170310404013011 20
2142 2142 170310404011008 20
2143 2143 170310404011005 20
2144 2144 170310404021007 20
2148 2148 170310310003003 20
2149 2149 170310310003001 20
2150 2150 170310310002002 20
2151 2151 170310310001008 20
2152 2152 170310404022000 20
2153 2153 170310310001001 20
2154 2154 170310309004013 20
2155 2155 170310401001013 20
2156 2156 170310311003003 20
2157 2157 170310310002014 20
2158 2158 170310312001000 20
2411 2411 170310207011004 20
2413 2413 170310207011006 20
2415 2415 170310403002002 20
2421 2421 170310308003001 20
2422 2422 170310312003003 20
2423 2423 170310312003005 20
2425 2425 170310305002006 20
2426 2426 170310305002004 20
2441 2441 170310311001002 20
2461 2461 170310404025004 20
2470 2470 170310305003016 20
2482 2482 170310401003015 20
2483 2483 170310401001007 20
2486 2486 170310401001002 20
2487 2487 170310404014004 20
2578 2578 170310313002002 20
2579 2579 170310313005002 20
2580 2580 170310307061011 20
2581 2581 170310308004004 20
2582 2582 170310308004006 20
2583 2583 170310308003006 20
2584 2584 170310307031001 20
2585 2585 170310308002004 20
2586 2586 170310308002006 20
2587 2587 170310307011004 20
2779 2779 170310305001003 20
2780 2780 170310305003012 20
2796 2796 170310208014013 20
2800 2800 170310401003006 20
2811 2811 170310403001010 20
2812 2812 170310403001008 20
2813 2813 170310403001002 20
2838 2838 170310309003012 20
2839 2839 170310309004011 20
2861 2861 170310306013004 20
2862 2862 170310306043003 20

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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