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

5,678 rows where dist_num = 25

✎ View and edit SQL

This data as json, CSV (advanced)

dist_num ✖

  • 25 · 5,678 ✖
Link rowid ▼ GEOID10 dist_num
149 149 170318316002003 25
150 150 170318316002006 25
182 182 170311911005014 25
183 183 170312502001012 25
184 184 170311911002014 25
185 185 170311911003009 25
186 186 170312503001022 25
187 187 170312507001012 25
188 188 170312505003005 25
189 189 170312504004013 25
190 190 170312505002019 25
191 191 170311906011004 25
192 192 170318315001025 25
193 193 170311913011037 25
199 199 170311904021029 25
200 200 170312504002009 25
205 205 170311801002002 25
206 206 170311913011014 25
207 207 170311906013002 25
208 208 170311904012036 25
211 211 170311801001012 25
213 213 170318315001015 25
219 219 170311904022007 25
220 220 170311908004003 25
221 221 170312502001009 25
222 222 170312503002017 25
223 223 170312502001017 25
228 228 170312505004007 25
229 229 170312504005003 25
230 230 170312504005011 25
231 231 170312505002011 25
232 232 170312505002007 25
233 233 170311912001019 25
234 234 170312503003003 25
235 235 170312507004007 25
236 236 170311904022015 25
237 237 170311906023011 25
244 244 170312306002002 25
245 245 170312306003019 25
246 246 170312306004004 25
274 274 170312306001009 25
275 275 170312306001003 25
288 288 170312105021015 25
290 290 170312105011005 25
291 291 170312209012001 25
292 292 170312209012006 25
373 373 170312506003018 25
374 374 170312507003011 25
375 375 170312506002011 25
379 379 170312304001008 25
394 394 170312507003005 25
396 396 170312507002009 25
397 397 170318313001036 25
461 461 170312207023004 25
462 462 170312207024006 25
463 463 170312105021001 25
464 464 170312105022007 25
465 465 170312105012012 25
466 466 170312105012002 25
646 646 170312507001007 25
651 651 170318315001001 25
687 687 170312504001006 25
810 810 170311912001017 25
811 811 170311907023015 25
812 812 170312506001011 25
813 813 170311904011022 25
820 820 170311904011002 25
828 828 170312506004017 25
829 829 170311913022007 25
830 830 170311912002010 25
852 852 170312104001000 25
855 855 170311903004019 25
856 856 170312502002005 25
857 857 170318313001008 25
858 858 170312508002014 25
863 863 170311909001016 25
869 869 170311903001008 25
875 875 170318312003015 25
884 884 170312002002019 25
885 885 170312001003028 25
886 886 170312004012012 25
888 888 170312305002002 25
892 892 170311908003011 25
893 893 170311903003006 25
894 894 170311903003008 25
895 895 170312502001015 25
896 896 170312502001000 25
898 898 170312507002016 25
999 999 170312505002000 25
1000 1000 170312506001001 25
1001 1001 170312508001009 25
1002 1002 170312507005005 25
1003 1003 170312507004002 25
1004 1004 170312506004010 25
1005 1005 170312508001013 25
1006 1006 170312508001019 25
1007 1007 170312506001015 25
1008 1008 170312508002002 25
1009 1009 170312502001018 25
1010 1010 170318313001002 25

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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