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,174 rows where dist_num = 19

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 19 · 4,174 ✖
Link rowid ▼ GEOID10 dist_num
277 277 170310706002004 19
280 280 170310624001007 19
281 281 170310603002007 19
322 322 170310321005001 19
323 323 170310608001002 19
344 344 170310508001020 19
345 345 170310511001001 19
346 346 170310514001005 19
580 580 170310633012000 19
581 581 170310619022001 19
582 582 170310701021001 19
910 910 170310406002013 19
911 911 170310406003000 19
913 913 170310505005002 19
914 914 170318437002002 19
922 922 170310501002014 19
923 923 170310506001018 19
926 926 170310407001009 19
927 927 170310408002008 19
928 928 170310408001003 19
929 929 170310509001017 19
930 930 170310503001012 19
931 931 170310505005001 19
932 932 170310514002007 19
933 933 170310707002002 19
934 934 170310511001013 19
935 935 170318437002014 19
950 950 170310512002013 19
972 972 170310317001000 19
1097 1097 170310509001021 19
1098 1098 170310510001021 19
1099 1099 170318437002033 19
1174 1174 170310506001015 19
1251 1251 170318321003004 19
1276 1276 170310703002002 19
1457 1457 170310507001013 19
1458 1458 170310625001010 19
1470 1470 170310633031003 19
1471 1471 170310608002002 19
1472 1472 170310314004006 19
1477 1477 170310407002009 19
1482 1482 170310633021002 19
1483 1483 170310619024002 19
1484 1484 170310632001003 19
1498 1498 170318320001020 19
1499 1499 170310628001001 19
1500 1500 170310318001013 19
1501 1501 170310602002005 19
1502 1502 170310602002008 19
1503 1503 170310604001015 19
1508 1508 170310317003000 19
1509 1509 170310601003001 19
1510 1510 170310601003002 19
1511 1511 170310601002002 19
1512 1512 170310605001004 19
1513 1513 170310605001007 19
1514 1514 170310704003001 19
1515 1515 170310705001008 19
1516 1516 170310705002000 19
1517 1517 170310704002008 19
1518 1518 170310603002014 19
1526 1526 170310502002014 19
1527 1527 170310508001003 19
1657 1657 170310628003015 19
1668 1668 170310627003008 19
1669 1669 170310705003009 19
1673 1673 170310706001005 19
1741 1741 170310317004002 19
1754 1754 170310611001002 19
1755 1755 170310630003006 19
1956 1956 170310407003001 19
1965 1965 170310622001009 19
1966 1966 170310317002009 19
1979 1979 170310703001024 19
1980 1980 170310318001015 19
1982 1982 170310625001000 19
1986 1986 170310506001006 19
2026 2026 170310508001018 19
2038 2038 170310628002009 19
2039 2039 170310705001003 19
2040 2040 170310705001001 19
2122 2122 170310506002006 19
2123 2123 170310506002015 19
2129 2129 170310409001018 19
2134 2134 170310407002003 19
2135 2135 170310407003003 19
2136 2136 170310407002007 19
2137 2137 170310407003002 19
2159 2159 170310315012000 19
2160 2160 170310706002017 19
2161 2161 170318437002021 19
2162 2162 170318437002018 19
2163 2163 170318437002015 19
2164 2164 170310510001014 19
2165 2165 170310511001019 19
2166 2166 170310512002006 19
2167 2167 170310511001023 19
2168 2168 170310513002002 19
2169 2169 170310706002003 19
2170 2170 170310706002006 19

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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