ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17093 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930820 | 930820 | 2021-01-15 | Kendall | Illinois | 17093 | 9681 | 77 |
927575 | 927575 | 2021-01-14 | Kendall | Illinois | 17093 | 9622 | 76 |
924329 | 924329 | 2021-01-13 | Kendall | Illinois | 17093 | 9583 | 76 |
921084 | 921084 | 2021-01-12 | Kendall | Illinois | 17093 | 9514 | 76 |
917839 | 917839 | 2021-01-11 | Kendall | Illinois | 17093 | 9453 | 76 |
914594 | 914594 | 2021-01-10 | Kendall | Illinois | 17093 | 9364 | 76 |
911349 | 911349 | 2021-01-09 | Kendall | Illinois | 17093 | 9364 | 76 |
908104 | 908104 | 2021-01-08 | Kendall | Illinois | 17093 | 9276 | 76 |
904858 | 904858 | 2021-01-07 | Kendall | Illinois | 17093 | 9203 | 76 |
901613 | 901613 | 2021-01-06 | Kendall | Illinois | 17093 | 9131 | 75 |
898368 | 898368 | 2021-01-05 | Kendall | Illinois | 17093 | 9067 | 75 |
895123 | 895123 | 2021-01-04 | Kendall | Illinois | 17093 | 9010 | 75 |
891876 | 891876 | 2021-01-03 | Kendall | Illinois | 17093 | 8851 | 75 |
888629 | 888629 | 2021-01-02 | Kendall | Illinois | 17093 | 8851 | 75 |
885384 | 885384 | 2021-01-01 | Kendall | Illinois | 17093 | 8771 | 73 |
882139 | 882139 | 2020-12-31 | Kendall | Illinois | 17093 | 8771 | 73 |
878894 | 878894 | 2020-12-30 | Kendall | Illinois | 17093 | 8634 | 73 |
875649 | 875649 | 2020-12-29 | Kendall | Illinois | 17093 | 8300 | 73 |
872404 | 872404 | 2020-12-28 | Kendall | Illinois | 17093 | 8258 | 73 |
869159 | 869159 | 2020-12-27 | Kendall | Illinois | 17093 | 8207 | 73 |
865914 | 865914 | 2020-12-26 | Kendall | Illinois | 17093 | 8166 | 73 |
862669 | 862669 | 2020-12-25 | Kendall | Illinois | 17093 | 8148 | 73 |
859424 | 859424 | 2020-12-24 | Kendall | Illinois | 17093 | 8102 | 69 |
856179 | 856179 | 2020-12-23 | Kendall | Illinois | 17093 | 8018 | 69 |
852934 | 852934 | 2020-12-22 | Kendall | Illinois | 17093 | 7953 | 69 |
849689 | 849689 | 2020-12-21 | Kendall | Illinois | 17093 | 7903 | 68 |
846444 | 846444 | 2020-12-20 | Kendall | Illinois | 17093 | 7863 | 68 |
843198 | 843198 | 2020-12-19 | Kendall | Illinois | 17093 | 7816 | 68 |
839953 | 839953 | 2020-12-18 | Kendall | Illinois | 17093 | 7755 | 68 |
836708 | 836708 | 2020-12-17 | Kendall | Illinois | 17093 | 7695 | 67 |
833462 | 833462 | 2020-12-16 | Kendall | Illinois | 17093 | 7591 | 67 |
830215 | 830215 | 2020-12-15 | Kendall | Illinois | 17093 | 7516 | 66 |
826969 | 826969 | 2020-12-14 | Kendall | Illinois | 17093 | 7453 | 65 |
823722 | 823722 | 2020-12-13 | Kendall | Illinois | 17093 | 7376 | 65 |
820476 | 820476 | 2020-12-12 | Kendall | Illinois | 17093 | 7308 | 65 |
817230 | 817230 | 2020-12-11 | Kendall | Illinois | 17093 | 7241 | 64 |
813984 | 813984 | 2020-12-10 | Kendall | Illinois | 17093 | 7191 | 62 |
810739 | 810739 | 2020-12-09 | Kendall | Illinois | 17093 | 7130 | 59 |
807494 | 807494 | 2020-12-08 | Kendall | Illinois | 17093 | 7055 | 60 |
804249 | 804249 | 2020-12-07 | Kendall | Illinois | 17093 | 6967 | 57 |
801004 | 801004 | 2020-12-06 | Kendall | Illinois | 17093 | 6907 | 57 |
797759 | 797759 | 2020-12-05 | Kendall | Illinois | 17093 | 6838 | 56 |
794514 | 794514 | 2020-12-04 | Kendall | Illinois | 17093 | 6757 | 56 |
791269 | 791269 | 2020-12-03 | Kendall | Illinois | 17093 | 6658 | 54 |
788024 | 788024 | 2020-12-02 | Kendall | Illinois | 17093 | 6580 | 52 |
784780 | 784780 | 2020-12-01 | Kendall | Illinois | 17093 | 6495 | 49 |
781535 | 781535 | 2020-11-30 | Kendall | Illinois | 17093 | 6318 | 47 |
778289 | 778289 | 2020-11-29 | Kendall | Illinois | 17093 | 6269 | 47 |
775044 | 775044 | 2020-11-28 | Kendall | Illinois | 17093 | 6216 | 47 |
771799 | 771799 | 2020-11-27 | Kendall | Illinois | 17093 | 6133 | 47 |
768554 | 768554 | 2020-11-26 | Kendall | Illinois | 17093 | 6060 | 44 |
765308 | 765308 | 2020-11-25 | Kendall | Illinois | 17093 | 5947 | 42 |
762063 | 762063 | 2020-11-24 | Kendall | Illinois | 17093 | 5833 | 42 |
758818 | 758818 | 2020-11-23 | Kendall | Illinois | 17093 | 5739 | 41 |
755571 | 755571 | 2020-11-22 | Kendall | Illinois | 17093 | 5646 | 41 |
752325 | 752325 | 2020-11-21 | Kendall | Illinois | 17093 | 5566 | 41 |
749079 | 749079 | 2020-11-20 | Kendall | Illinois | 17093 | 5443 | 40 |
745833 | 745833 | 2020-11-19 | Kendall | Illinois | 17093 | 5298 | 39 |
742586 | 742586 | 2020-11-18 | Kendall | Illinois | 17093 | 5149 | 37 |
739339 | 739339 | 2020-11-17 | Kendall | Illinois | 17093 | 5066 | 35 |
736095 | 736095 | 2020-11-16 | Kendall | Illinois | 17093 | 4913 | 34 |
732849 | 732849 | 2020-11-15 | Kendall | Illinois | 17093 | 4818 | 34 |
729604 | 729604 | 2020-11-14 | Kendall | Illinois | 17093 | 4695 | 34 |
726361 | 726361 | 2020-11-13 | Kendall | Illinois | 17093 | 4602 | 32 |
723118 | 723118 | 2020-11-12 | Kendall | Illinois | 17093 | 4455 | 32 |
719875 | 719875 | 2020-11-11 | Kendall | Illinois | 17093 | 4292 | 32 |
716632 | 716632 | 2020-11-10 | Kendall | Illinois | 17093 | 4144 | 32 |
713388 | 713388 | 2020-11-09 | Kendall | Illinois | 17093 | 3999 | 32 |
710144 | 710144 | 2020-11-08 | Kendall | Illinois | 17093 | 3903 | 32 |
706900 | 706900 | 2020-11-07 | Kendall | Illinois | 17093 | 3801 | 32 |
703657 | 703657 | 2020-11-06 | Kendall | Illinois | 17093 | 3619 | 32 |
700414 | 700414 | 2020-11-05 | Kendall | Illinois | 17093 | 3428 | 30 |
697170 | 697170 | 2020-11-04 | Kendall | Illinois | 17093 | 3331 | 30 |
693928 | 693928 | 2020-11-03 | Kendall | Illinois | 17093 | 3228 | 30 |
690685 | 690685 | 2020-11-02 | Kendall | Illinois | 17093 | 3138 | 30 |
687440 | 687440 | 2020-11-01 | Kendall | Illinois | 17093 | 3083 | 30 |
684196 | 684196 | 2020-10-31 | Kendall | Illinois | 17093 | 2942 | 30 |
680953 | 680953 | 2020-10-30 | Kendall | Illinois | 17093 | 2938 | 30 |
677710 | 677710 | 2020-10-29 | Kendall | Illinois | 17093 | 2869 | 30 |
674467 | 674467 | 2020-10-28 | Kendall | Illinois | 17093 | 2797 | 30 |
671225 | 671225 | 2020-10-27 | Kendall | Illinois | 17093 | 2753 | 30 |
667982 | 667982 | 2020-10-26 | Kendall | Illinois | 17093 | 2714 | 30 |
664738 | 664738 | 2020-10-25 | Kendall | Illinois | 17093 | 2670 | 30 |
661493 | 661493 | 2020-10-24 | Kendall | Illinois | 17093 | 2653 | 30 |
658249 | 658249 | 2020-10-23 | Kendall | Illinois | 17093 | 2633 | 28 |
655004 | 655004 | 2020-10-22 | Kendall | Illinois | 17093 | 2614 | 28 |
651759 | 651759 | 2020-10-21 | Kendall | Illinois | 17093 | 2585 | 29 |
648515 | 648515 | 2020-10-20 | Kendall | Illinois | 17093 | 2540 | 28 |
645270 | 645270 | 2020-10-19 | Kendall | Illinois | 17093 | 2523 | 28 |
642023 | 642023 | 2020-10-18 | Kendall | Illinois | 17093 | 2485 | 28 |
638776 | 638776 | 2020-10-17 | Kendall | Illinois | 17093 | 2485 | 28 |
635530 | 635530 | 2020-10-16 | Kendall | Illinois | 17093 | 2464 | 27 |
632284 | 632284 | 2020-10-15 | Kendall | Illinois | 17093 | 2422 | 27 |
629040 | 629040 | 2020-10-14 | Kendall | Illinois | 17093 | 2365 | 27 |
625797 | 625797 | 2020-10-13 | Kendall | Illinois | 17093 | 2346 | 27 |
622555 | 622555 | 2020-10-12 | Kendall | Illinois | 17093 | 2311 | 27 |
619311 | 619311 | 2020-10-11 | Kendall | Illinois | 17093 | 2293 | 27 |
616069 | 616069 | 2020-10-10 | Kendall | Illinois | 17093 | 2293 | 27 |
612828 | 612828 | 2020-10-09 | Kendall | Illinois | 17093 | 2271 | 26 |
609586 | 609586 | 2020-10-08 | Kendall | Illinois | 17093 | 2252 | 26 |
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);