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

93,572 rows sorted by rowid descending

View and edit SQL

Link rowid ▲ GEOID10 dist_num
93472 170310629002006 19
93471 170311913013014 25
93470 170311002004003 16
93469 170311103001008 16
93468 170311711002021 16
93467 170311506003015 16
93466 170311003001030 16
93465 170311702001016 16
93464 170311702003001 16
93463 170311505023011 16
93462 170311505021009 16
93461 170311505012005 16
93460 170311913011027 25
93459 170311001001031 16
93458 170311001001033 16
93457 170311103003012 16
93456 170311103003014 16
93455 170311801001016 25
93454 170311904012004 25
93453 170312504002024 25
93452 170312503001007 25
93451 170311913021019 25
93450 170312505004021 25
93449 170311801004015 25
93448 170311710005023 16
93447 170311105012004 16
93446 170311102001007 16
93445 170311003006012 16
93444 170311003006009 16
93443 170311006003030 16
93442 170311703003011 16
93441 170311703004012 16
93440 170311701001003 16
93439 170318316004002 25
93438 170318316004003 25
93437 170318316004001 25
93436 170311801003007 25
93435 170312505007015 25
93434 170311005005005 16
93433 170311704001016 16
93432 170311709001024 25
93431 170319800001061 16
93430 170319800001010 16
93429 170314407001003 6
93428 170314402023006 6
93427 170318343001027 4
93426 170318343005011 4
93425 170314407001014 6
93424 170314401022013 6
93423 170314804003045 4
93422 170314804004011 4
93421 170314804001020 4
93420 170318346004012 7
93419 170318356002020 9
93418 170315302001003 5
93417 170314802002003 4
93416 170318343005010 4
93415 170314402022011 6
93414 170314804005009 4
93413 170314804003043 4
93412 170314804005012 4
93411 170314802001011 4
93410 170315103002029 4
93409 170318391001104 1
93408 170313301003006 1
93407 170313301001000 1
93406 170313206002005 1
93405 170313206002012 1
93404 170318410001040 1
93403 170313301002020 1
93402 170313302002038 1
93401 170318370002018 11
93400 170318370001008 11
93399 170312518003006 11
93398 170312515002000 15
93397 170312515003007 15
93396 170315608005012 8
93395 170315608005008 8
93394 170315701001016 8
93393 170318305001037 8
93392 170315705001000 8
93391 170315602001003 8
93390 170316203001007 8
93389 170316203001021 8
93388 170316308004023 8
93387 170316713002007 7
93386 170316112002007 9
93385 170316112001010 9
93384 170315302004036 5
93383 170314910002017 5
93382 170314913004008 5
93381 170314406001027 6
93380 170314903001003 6
93379 170314909022028 5
93378 170314908001015 5
93377 170315806004012 9
93376 170318403003001 9
93375 170318432002084 9
93374 170318432002087 9
93373 170318413004022 9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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