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

4,046 rows where dist_num = 14

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 14 · 4,046 ✖
Link rowid ▼ GEOID10 dist_num
284 284 170312406001000 14
285 285 170312222002013 14
286 286 170312413001014 14
287 287 170312106023013 14
300 300 170318310001001 14
301 301 170312222001026 14
302 302 170312405001025 14
303 303 170318423001014 14
304 304 170318423001001 14
305 305 170312402001024 14
306 306 170318423001045 14
319 319 170312302001006 14
324 324 170312106022002 14
326 326 170312308001003 14
330 330 170312109001041 14
353 353 170312415002015 14
380 380 170312303001007 14
453 453 170312210002012 14
454 454 170312228001006 14
455 455 170312206021005 14
456 456 170312206024016 14
457 457 170312206024005 14
458 458 170312206024007 14
459 459 170312106022013 14
460 460 170312206024010 14
571 571 170318309001043 14
589 589 170312225001016 14
590 590 170312415001001 14
596 596 170312408002006 14
615 615 170318322001006 14
616 616 170312107003006 14
620 620 170312301001007 14
639 639 170312108001025 14
641 641 170312109002012 14
648 648 170312410002010 14
901 901 170312206022002 14
904 904 170312301001021 14
912 912 170312205001014 14
915 915 170318309001008 14
924 924 170318323001027 14
936 936 170318309001018 14
947 947 170312405001004 14
949 949 170318323001036 14
969 969 170312106012003 14
1025 1025 170312415002004 14
1089 1089 170318309002010 14
1090 1090 170318309002009 14
1091 1091 170312204002019 14
1092 1092 170318310002013 14
1093 1093 170318310002009 14
1094 1094 170318323001080 14
1095 1095 170312213001011 14
1096 1096 170312214001003 14
1104 1104 170312109001023 14
1105 1105 170312109001022 14
1106 1106 170312109001037 14
1107 1107 170312108001008 14
1108 1108 170312107001002 14
1169 1169 170312402001002 14
1175 1175 170318309001030 14
1252 1252 170312213002005 14
1271 1271 170318323001018 14
1274 1274 170312407001005 14
1282 1282 170312227002014 14
1480 1480 170318323001066 14
1485 1485 170312106013005 14
1486 1486 170312107003016 14
1487 1487 170312107003024 14
1490 1490 170312109001035 14
1504 1504 170312205002008 14
1505 1505 170312213003005 14
1519 1519 170312214002001 14
1524 1524 170318324001020 14
1588 1588 170312228001010 14
1646 1646 170312212002002 14
1647 1647 170312212002006 14
1648 1648 170312213001007 14
1649 1649 170312203001016 14
1650 1650 170312215002011 14
1651 1651 170312215002006 14
1652 1652 170312215001012 14
1653 1653 170312215001015 14
1654 1654 170312215002027 14
1655 1655 170312215001014 14
1656 1656 170312215001027 14
1658 1658 170312216001024 14
1659 1659 170312216002024 14
1660 1660 170312216002029 14
1661 1661 170312216002017 14
1662 1662 170312216001036 14
1663 1663 170312216001037 14
1664 1664 170318322003005 14
1665 1665 170318322002028 14
1666 1666 170318323001061 14
1667 1667 170318323001074 14
1670 1670 170318322001012 14
1671 1671 170318322001014 14
1672 1672 170312216001005 14
1736 1736 170312206012000 14
1737 1737 170312206012002 14

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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