ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 17021 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930784 | 930784 | 2021-01-15 | Christian | Illinois | 17021 | 2953 | 73 |
927539 | 927539 | 2021-01-14 | Christian | Illinois | 17021 | 2923 | 72 |
924293 | 924293 | 2021-01-13 | Christian | Illinois | 17021 | 2896 | 72 |
921048 | 921048 | 2021-01-12 | Christian | Illinois | 17021 | 2880 | 71 |
917803 | 917803 | 2021-01-11 | Christian | Illinois | 17021 | 2851 | 70 |
914558 | 914558 | 2021-01-10 | Christian | Illinois | 17021 | 2836 | 70 |
911313 | 911313 | 2021-01-09 | Christian | Illinois | 17021 | 2820 | 70 |
908068 | 908068 | 2021-01-08 | Christian | Illinois | 17021 | 2799 | 70 |
904822 | 904822 | 2021-01-07 | Christian | Illinois | 17021 | 2763 | 70 |
901577 | 901577 | 2021-01-06 | Christian | Illinois | 17021 | 2718 | 68 |
898332 | 898332 | 2021-01-05 | Christian | Illinois | 17021 | 2702 | 68 |
895087 | 895087 | 2021-01-04 | Christian | Illinois | 17021 | 2682 | 68 |
891840 | 891840 | 2021-01-03 | Christian | Illinois | 17021 | 2671 | 68 |
888593 | 888593 | 2021-01-02 | Christian | Illinois | 17021 | 2652 | 67 |
885348 | 885348 | 2021-01-01 | Christian | Illinois | 17021 | 2600 | 66 |
882103 | 882103 | 2020-12-31 | Christian | Illinois | 17021 | 2600 | 66 |
878858 | 878858 | 2020-12-30 | Christian | Illinois | 17021 | 2567 | 64 |
875613 | 875613 | 2020-12-29 | Christian | Illinois | 17021 | 2548 | 64 |
872368 | 872368 | 2020-12-28 | Christian | Illinois | 17021 | 2525 | 63 |
869123 | 869123 | 2020-12-27 | Christian | Illinois | 17021 | 2516 | 63 |
865878 | 865878 | 2020-12-26 | Christian | Illinois | 17021 | 2496 | 63 |
862633 | 862633 | 2020-12-25 | Christian | Illinois | 17021 | 2493 | 63 |
859388 | 859388 | 2020-12-24 | Christian | Illinois | 17021 | 2483 | 63 |
856143 | 856143 | 2020-12-23 | Christian | Illinois | 17021 | 2450 | 59 |
852898 | 852898 | 2020-12-22 | Christian | Illinois | 17021 | 2438 | 59 |
849653 | 849653 | 2020-12-21 | Christian | Illinois | 17021 | 2428 | 58 |
846408 | 846408 | 2020-12-20 | Christian | Illinois | 17021 | 2421 | 58 |
843162 | 843162 | 2020-12-19 | Christian | Illinois | 17021 | 2407 | 57 |
839917 | 839917 | 2020-12-18 | Christian | Illinois | 17021 | 2381 | 57 |
836672 | 836672 | 2020-12-17 | Christian | Illinois | 17021 | 2357 | 57 |
833426 | 833426 | 2020-12-16 | Christian | Illinois | 17021 | 2336 | 55 |
830179 | 830179 | 2020-12-15 | Christian | Illinois | 17021 | 2322 | 53 |
826933 | 826933 | 2020-12-14 | Christian | Illinois | 17021 | 2311 | 53 |
823686 | 823686 | 2020-12-13 | Christian | Illinois | 17021 | 2256 | 53 |
820440 | 820440 | 2020-12-12 | Christian | Illinois | 17021 | 2230 | 52 |
817194 | 817194 | 2020-12-11 | Christian | Illinois | 17021 | 2204 | 52 |
813948 | 813948 | 2020-12-10 | Christian | Illinois | 17021 | 2130 | 51 |
810703 | 810703 | 2020-12-09 | Christian | Illinois | 17021 | 2100 | 51 |
807458 | 807458 | 2020-12-08 | Christian | Illinois | 17021 | 2068 | 50 |
804213 | 804213 | 2020-12-07 | Christian | Illinois | 17021 | 2056 | 48 |
800968 | 800968 | 2020-12-06 | Christian | Illinois | 17021 | 2039 | 48 |
797723 | 797723 | 2020-12-05 | Christian | Illinois | 17021 | 2016 | 47 |
794478 | 794478 | 2020-12-04 | Christian | Illinois | 17021 | 1984 | 47 |
791233 | 791233 | 2020-12-03 | Christian | Illinois | 17021 | 1969 | 44 |
787988 | 787988 | 2020-12-02 | Christian | Illinois | 17021 | 1940 | 44 |
784744 | 784744 | 2020-12-01 | Christian | Illinois | 17021 | 1914 | 44 |
781499 | 781499 | 2020-11-30 | Christian | Illinois | 17021 | 1903 | 44 |
778253 | 778253 | 2020-11-29 | Christian | Illinois | 17021 | 1894 | 44 |
775008 | 775008 | 2020-11-28 | Christian | Illinois | 17021 | 1882 | 44 |
771763 | 771763 | 2020-11-27 | Christian | Illinois | 17021 | 1854 | 44 |
768518 | 768518 | 2020-11-26 | Christian | Illinois | 17021 | 1841 | 43 |
765272 | 765272 | 2020-11-25 | Christian | Illinois | 17021 | 1807 | 41 |
762027 | 762027 | 2020-11-24 | Christian | Illinois | 17021 | 1776 | 41 |
758782 | 758782 | 2020-11-23 | Christian | Illinois | 17021 | 1748 | 40 |
755535 | 755535 | 2020-11-22 | Christian | Illinois | 17021 | 1731 | 39 |
752289 | 752289 | 2020-11-21 | Christian | Illinois | 17021 | 1719 | 38 |
749043 | 749043 | 2020-11-20 | Christian | Illinois | 17021 | 1692 | 37 |
745797 | 745797 | 2020-11-19 | Christian | Illinois | 17021 | 1631 | 36 |
742550 | 742550 | 2020-11-18 | Christian | Illinois | 17021 | 1591 | 34 |
739303 | 739303 | 2020-11-17 | Christian | Illinois | 17021 | 1558 | 34 |
736059 | 736059 | 2020-11-16 | Christian | Illinois | 17021 | 1524 | 34 |
732813 | 732813 | 2020-11-15 | Christian | Illinois | 17021 | 1495 | 34 |
729568 | 729568 | 2020-11-14 | Christian | Illinois | 17021 | 1454 | 34 |
726325 | 726325 | 2020-11-13 | Christian | Illinois | 17021 | 1425 | 32 |
723082 | 723082 | 2020-11-12 | Christian | Illinois | 17021 | 1360 | 32 |
719839 | 719839 | 2020-11-11 | Christian | Illinois | 17021 | 1313 | 32 |
716596 | 716596 | 2020-11-10 | Christian | Illinois | 17021 | 1265 | 32 |
713352 | 713352 | 2020-11-09 | Christian | Illinois | 17021 | 1224 | 32 |
710108 | 710108 | 2020-11-08 | Christian | Illinois | 17021 | 1182 | 32 |
706864 | 706864 | 2020-11-07 | Christian | Illinois | 17021 | 1129 | 32 |
703621 | 703621 | 2020-11-06 | Christian | Illinois | 17021 | 1083 | 32 |
700378 | 700378 | 2020-11-05 | Christian | Illinois | 17021 | 1050 | 32 |
697134 | 697134 | 2020-11-04 | Christian | Illinois | 17021 | 978 | 32 |
693892 | 693892 | 2020-11-03 | Christian | Illinois | 17021 | 942 | 32 |
690649 | 690649 | 2020-11-02 | Christian | Illinois | 17021 | 924 | 32 |
687404 | 687404 | 2020-11-01 | Christian | Illinois | 17021 | 912 | 32 |
684160 | 684160 | 2020-10-31 | Christian | Illinois | 17021 | 888 | 32 |
680917 | 680917 | 2020-10-30 | Christian | Illinois | 17021 | 888 | 32 |
677674 | 677674 | 2020-10-29 | Christian | Illinois | 17021 | 868 | 31 |
674431 | 674431 | 2020-10-28 | Christian | Illinois | 17021 | 846 | 30 |
671189 | 671189 | 2020-10-27 | Christian | Illinois | 17021 | 829 | 30 |
667946 | 667946 | 2020-10-26 | Christian | Illinois | 17021 | 825 | 30 |
664702 | 664702 | 2020-10-25 | Christian | Illinois | 17021 | 816 | 30 |
661457 | 661457 | 2020-10-24 | Christian | Illinois | 17021 | 811 | 30 |
658213 | 658213 | 2020-10-23 | Christian | Illinois | 17021 | 803 | 30 |
654968 | 654968 | 2020-10-22 | Christian | Illinois | 17021 | 800 | 28 |
651723 | 651723 | 2020-10-21 | Christian | Illinois | 17021 | 794 | 27 |
648479 | 648479 | 2020-10-20 | Christian | Illinois | 17021 | 784 | 26 |
645234 | 645234 | 2020-10-19 | Christian | Illinois | 17021 | 771 | 26 |
641987 | 641987 | 2020-10-18 | Christian | Illinois | 17021 | 763 | 26 |
638740 | 638740 | 2020-10-17 | Christian | Illinois | 17021 | 750 | 26 |
635494 | 635494 | 2020-10-16 | Christian | Illinois | 17021 | 747 | 26 |
632248 | 632248 | 2020-10-15 | Christian | Illinois | 17021 | 739 | 24 |
629004 | 629004 | 2020-10-14 | Christian | Illinois | 17021 | 724 | 23 |
625761 | 625761 | 2020-10-13 | Christian | Illinois | 17021 | 712 | 22 |
622519 | 622519 | 2020-10-12 | Christian | Illinois | 17021 | 708 | 22 |
619275 | 619275 | 2020-10-11 | Christian | Illinois | 17021 | 705 | 22 |
616033 | 616033 | 2020-10-10 | Christian | Illinois | 17021 | 699 | 22 |
612792 | 612792 | 2020-10-09 | Christian | Illinois | 17021 | 691 | 21 |
609550 | 609550 | 2020-10-08 | Christian | Illinois | 17021 | 680 | 21 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);