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,302 rows where dist_num = 17

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 17 · 4,302 ✖
Link rowid ▼ GEOID10 dist_num
247 247 170311611002004 17
248 248 170311203003002 17
249 249 170311302001022 17
250 250 170311302001010 17
251 251 170311603003003 17
252 252 170311602003001 17
253 253 170311302001014 17
254 254 170311403021009 17
255 255 170311404002009 17
256 256 170318318005027 17
257 257 170318318004015 17
258 258 170311610001010 17
259 259 170311610002006 17
260 260 170311603001009 17
261 261 170311602001001 17
262 262 170311602001002 17
263 263 170311404005010 17
264 264 170311404005005 17
265 265 170311602004027 17
266 266 170311602004022 17
267 267 170311602003009 17
268 268 170311602004000 17
269 269 170311601001021 17
270 270 170311404005035 17
289 289 170318311004024 17
293 293 170318311001000 17
329 329 170312101001022 17
467 467 170318311003021 17
468 468 170318311004012 17
469 469 170318311004015 17
470 470 170318311001018 17
471 471 170318311004004 17
472 472 170318311003015 17
473 473 170318311003013 17
474 474 170318311003006 17
475 475 170311609001026 17
476 476 170311608003007 17
477 477 170311608005018 17
478 478 170311608001011 17
479 479 170311607004014 17
560 560 170311603002005 17
561 561 170311603002008 17
613 613 170311408002015 17
658 658 170311402003020 17
661 661 170311203003010 17
662 662 170311203002016 17
849 849 170311613001014 17
850 850 170311613002015 17
851 851 170311613002014 17
853 853 170311203001000 17
854 854 170311203001020 17
864 864 170311303003027 17
865 865 170311301003021 17
866 866 170311301001008 17
867 867 170311303004012 17
876 876 170311613004006 17
877 877 170311302001001 17
878 878 170311203002011 17
879 879 170311403021007 17
880 880 170311403023011 17
881 881 170311303002004 17
882 882 170311301002004 17
883 883 170318318005021 17
890 890 170311302001041 17
891 891 170311405002005 17
908 908 170311606023006 17
909 909 170311606023001 17
966 966 170311408004008 17
967 967 170311605021001 17
968 968 170311608005001 17
1081 1081 170311607002011 17
1082 1082 170311607005004 17
1083 1083 170311607003008 17
1084 1084 170311607004000 17
1085 1085 170311607004002 17
1086 1086 170311607004011 17
1087 1087 170311607003000 17
1088 1088 170311607003002 17
1100 1100 170312101003008 17
1101 1101 170312101003005 17
1102 1102 170312101003014 17
1103 1103 170312101002024 17
1207 1207 170311203002008 17
1215 1215 170311302001018 17
1219 1219 170318318002001 17
1247 1247 170311404005030 17
1269 1269 170311606021006 17
1417 1417 170311611002005 17
1418 1418 170311612001005 17
1419 1419 170311612002021 17
1420 1420 170311203004005 17
1421 1421 170311203006009 17
1422 1422 170311203005021 17
1423 1423 170311203002020 17
1424 1424 170311602003007 17
1425 1425 170311601002014 17
1426 1426 170311601002006 17
1427 1427 170311404002004 17
1428 1428 170311302001012 17
1429 1429 170311302001011 17

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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