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

93,572 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ GEOID10 dist_num
401 401 170318374002035 11
402 402 170318374002017 11
403 403 170318374002021 11
404 404 170312827002016 11
405 405 170312827002008 11
406 406 170312827002007 11
407 407 170312827002022 11
408 408 170318429004013 12
409 409 170318429004029 12
410 410 170312428001016 12
411 411 170312428001000 12
412 412 170312429001020 12
413 413 170312428001041 12
414 414 170312428001043 12
415 415 170312429002002 12
416 416 170312429002007 12
417 417 170318378001027 12
418 418 170312430001002 12
419 419 170312433002013 12
420 420 170312433002024 12
421 421 170318330002023 12
422 422 170318330002029 12
423 423 170312434003000 12
424 424 170312434002000 12
425 425 170312435001007 12
426 426 170310208024001 24
427 427 170310208024008 24
428 428 170310207011023 20
429 429 170310207012003 20
430 430 170310207012013 20
431 431 170310208012000 20
432 432 170310208013018 20
433 433 170310207012018 20
434 434 170310208011019 20
435 435 170310208011014 20
436 436 170310208011013 20
437 437 170310209021022 24
438 438 170310304002010 20
439 439 170310304002002 20
440 440 170310304002016 20
441 441 170310309001003 20
442 442 170310305002020 20
443 443 170310305002003 20
444 444 170311007004006 16
445 445 170311007004013 16
446 446 170310305003017 20
447 447 170310305003018 20
448 448 170310305001012 20
449 449 170310306013002 20
450 450 170310302002011 24
451 451 170310302002012 24
452 452 170310301013001 24
453 453 170312210002012 14
454 454 170312228001006 14
455 455 170312206021005 14
456 456 170312206024016 14
457 457 170312206024005 14
458 458 170312206024007 14
459 459 170312106022013 14
460 460 170312206024010 14
461 461 170312207023004 25
462 462 170312207024006 25
463 463 170312105021001 25
464 464 170312105022007 25
465 465 170312105012012 25
466 466 170312105012002 25
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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