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

9,304 rows where dist_num = 8

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 8 · 9,304 ✖
Link rowid ▼ GEOID10 dist_num
61 61 170315705001020 8
62 62 170315608002002 8
67 67 170317004011012 8
68 68 170316611004013 8
69 69 170316609003010 8
70 70 170316503011001 8
71 71 170318352001032 8
72 72 170315607001001 8
73 73 170316404001017 8
74 74 170316404002031 8
75 75 170316404002019 8
76 76 170315610006010 8
80 80 170317004023014 8
81 81 170317004021004 8
82 82 170317003011011 8
83 83 170317004012025 8
84 84 170317004012019 8
109 109 170316607001020 8
122 122 170316303002028 8
480 480 170316503013026 8
481 481 170316502002003 8
482 482 170316501003010 8
483 483 170316501002016 8
484 484 170316501001003 8
485 485 170316501001007 8
486 486 170316501004008 8
487 487 170316502001022 8
488 488 170316502001006 8
489 489 170316502001007 8
490 490 170316502001013 8
491 491 170316203002016 8
492 492 170316204003001 8
493 493 170316203001017 8
494 494 170316203001006 8
495 495 170316203006017 8
496 496 170316203001022 8
497 497 170316203001001 8
498 498 170316201003009 8
499 499 170316201002026 8
500 500 170316309002017 8
501 501 170316309002007 8
502 502 170316309003018 8
503 503 170316309003019 8
504 504 170316604003002 8
505 505 170316604001001 8
506 506 170316309002018 8
507 507 170316309001013 8
508 508 170316309003007 8
509 509 170316308002008 8
568 568 170318352001045 8
569 569 170315611001020 8
621 621 170315610006018 8
622 622 170315611003013 8
623 623 170315611003012 8
624 624 170315608005004 8
625 625 170315608005019 8
626 626 170315602003004 8
627 627 170315602002000 8
628 628 170316309002016 8
629 629 170316608002000 8
630 630 170316608003002 8
631 631 170316610004003 8
632 632 170317004012007 8
633 633 170317005021012 8
635 635 170317003021018 8
683 683 170316611002004 8
700 700 170317005013010 8
701 701 170317004014004 8
702 702 170317004014007 8
703 703 170316408001004 8
704 704 170316401001009 8
705 705 170315607001020 8
706 706 170315607001018 8
708 708 170316608001012 8
722 722 170315705002011 8
723 723 170315607002009 8
724 724 170315608002018 8
751 751 170316303001010 8
768 768 170318351001028 8
769 769 170318351001017 8
775 775 170316204002011 8
776 776 170316309001021 8
777 777 170316203001002 8
1109 1109 170316308002012 8
1110 1110 170316308003011 8
1111 1111 170316308003007 8
1112 1112 170316308004001 8
1113 1113 170316603023006 8
1114 1114 170316603021007 8
1115 1115 170318350003009 8
1116 1116 170316603011002 8
1117 1117 170316603011018 8
1118 1118 170316604002001 8
1119 1119 170316603024009 8
1120 1120 170316603011014 8
1121 1121 170316606003004 8
1122 1122 170318351001031 8
1123 1123 170318350001004 8
1124 1124 170318350001014 8
1125 1125 170318350005012 8

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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