ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17177 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930862 | 930862 | 2021-01-15 | Stephenson | Illinois | 17177 | 3488 | 74 |
927617 | 927617 | 2021-01-14 | Stephenson | Illinois | 17177 | 3467 | 74 |
924371 | 924371 | 2021-01-13 | Stephenson | Illinois | 17177 | 3441 | 74 |
921126 | 921126 | 2021-01-12 | Stephenson | Illinois | 17177 | 3428 | 73 |
917881 | 917881 | 2021-01-11 | Stephenson | Illinois | 17177 | 3418 | 72 |
914636 | 914636 | 2021-01-10 | Stephenson | Illinois | 17177 | 3408 | 72 |
911391 | 911391 | 2021-01-09 | Stephenson | Illinois | 17177 | 3390 | 72 |
908146 | 908146 | 2021-01-08 | Stephenson | Illinois | 17177 | 3367 | 71 |
904900 | 904900 | 2021-01-07 | Stephenson | Illinois | 17177 | 3344 | 69 |
901655 | 901655 | 2021-01-06 | Stephenson | Illinois | 17177 | 3325 | 68 |
898410 | 898410 | 2021-01-05 | Stephenson | Illinois | 17177 | 3305 | 67 |
895165 | 895165 | 2021-01-04 | Stephenson | Illinois | 17177 | 3296 | 67 |
891918 | 891918 | 2021-01-03 | Stephenson | Illinois | 17177 | 3282 | 66 |
888671 | 888671 | 2021-01-02 | Stephenson | Illinois | 17177 | 3276 | 64 |
885426 | 885426 | 2021-01-01 | Stephenson | Illinois | 17177 | 3242 | 62 |
882181 | 882181 | 2020-12-31 | Stephenson | Illinois | 17177 | 3242 | 62 |
878936 | 878936 | 2020-12-30 | Stephenson | Illinois | 17177 | 3215 | 60 |
875691 | 875691 | 2020-12-29 | Stephenson | Illinois | 17177 | 3205 | 58 |
872446 | 872446 | 2020-12-28 | Stephenson | Illinois | 17177 | 3179 | 58 |
869201 | 869201 | 2020-12-27 | Stephenson | Illinois | 17177 | 3157 | 57 |
865956 | 865956 | 2020-12-26 | Stephenson | Illinois | 17177 | 3149 | 57 |
862711 | 862711 | 2020-12-25 | Stephenson | Illinois | 17177 | 3140 | 57 |
859466 | 859466 | 2020-12-24 | Stephenson | Illinois | 17177 | 3118 | 55 |
856221 | 856221 | 2020-12-23 | Stephenson | Illinois | 17177 | 3104 | 55 |
852976 | 852976 | 2020-12-22 | Stephenson | Illinois | 17177 | 3074 | 54 |
849731 | 849731 | 2020-12-21 | Stephenson | Illinois | 17177 | 3065 | 53 |
846486 | 846486 | 2020-12-20 | Stephenson | Illinois | 17177 | 3051 | 52 |
843240 | 843240 | 2020-12-19 | Stephenson | Illinois | 17177 | 3030 | 52 |
839995 | 839995 | 2020-12-18 | Stephenson | Illinois | 17177 | 3013 | 52 |
836750 | 836750 | 2020-12-17 | Stephenson | Illinois | 17177 | 2989 | 51 |
833504 | 833504 | 2020-12-16 | Stephenson | Illinois | 17177 | 2953 | 51 |
830257 | 830257 | 2020-12-15 | Stephenson | Illinois | 17177 | 2907 | 48 |
827011 | 827011 | 2020-12-14 | Stephenson | Illinois | 17177 | 2889 | 45 |
823764 | 823764 | 2020-12-13 | Stephenson | Illinois | 17177 | 2877 | 45 |
820518 | 820518 | 2020-12-12 | Stephenson | Illinois | 17177 | 2858 | 45 |
817272 | 817272 | 2020-12-11 | Stephenson | Illinois | 17177 | 2813 | 45 |
814026 | 814026 | 2020-12-10 | Stephenson | Illinois | 17177 | 2774 | 44 |
810781 | 810781 | 2020-12-09 | Stephenson | Illinois | 17177 | 2737 | 44 |
807536 | 807536 | 2020-12-08 | Stephenson | Illinois | 17177 | 2713 | 43 |
804291 | 804291 | 2020-12-07 | Stephenson | Illinois | 17177 | 2683 | 42 |
801046 | 801046 | 2020-12-06 | Stephenson | Illinois | 17177 | 2671 | 42 |
797801 | 797801 | 2020-12-05 | Stephenson | Illinois | 17177 | 2642 | 42 |
794556 | 794556 | 2020-12-04 | Stephenson | Illinois | 17177 | 2614 | 41 |
791311 | 791311 | 2020-12-03 | Stephenson | Illinois | 17177 | 2582 | 38 |
788066 | 788066 | 2020-12-02 | Stephenson | Illinois | 17177 | 2537 | 37 |
784822 | 784822 | 2020-12-01 | Stephenson | Illinois | 17177 | 2509 | 36 |
781577 | 781577 | 2020-11-30 | Stephenson | Illinois | 17177 | 2489 | 35 |
778331 | 778331 | 2020-11-29 | Stephenson | Illinois | 17177 | 2466 | 35 |
775086 | 775086 | 2020-11-28 | Stephenson | Illinois | 17177 | 2433 | 35 |
771841 | 771841 | 2020-11-27 | Stephenson | Illinois | 17177 | 2415 | 34 |
768596 | 768596 | 2020-11-26 | Stephenson | Illinois | 17177 | 2378 | 34 |
765350 | 765350 | 2020-11-25 | Stephenson | Illinois | 17177 | 2350 | 34 |
762105 | 762105 | 2020-11-24 | Stephenson | Illinois | 17177 | 2318 | 34 |
758860 | 758860 | 2020-11-23 | Stephenson | Illinois | 17177 | 2288 | 30 |
755613 | 755613 | 2020-11-22 | Stephenson | Illinois | 17177 | 2265 | 29 |
752367 | 752367 | 2020-11-21 | Stephenson | Illinois | 17177 | 2234 | 29 |
749121 | 749121 | 2020-11-20 | Stephenson | Illinois | 17177 | 2206 | 26 |
745875 | 745875 | 2020-11-19 | Stephenson | Illinois | 17177 | 2146 | 25 |
742628 | 742628 | 2020-11-18 | Stephenson | Illinois | 17177 | 2093 | 19 |
739381 | 739381 | 2020-11-17 | Stephenson | Illinois | 17177 | 2067 | 18 |
736137 | 736137 | 2020-11-16 | Stephenson | Illinois | 17177 | 2036 | 18 |
732891 | 732891 | 2020-11-15 | Stephenson | Illinois | 17177 | 1997 | 18 |
729646 | 729646 | 2020-11-14 | Stephenson | Illinois | 17177 | 1961 | 18 |
726403 | 726403 | 2020-11-13 | Stephenson | Illinois | 17177 | 1938 | 17 |
723160 | 723160 | 2020-11-12 | Stephenson | Illinois | 17177 | 1868 | 16 |
719917 | 719917 | 2020-11-11 | Stephenson | Illinois | 17177 | 1795 | 16 |
716674 | 716674 | 2020-11-10 | Stephenson | Illinois | 17177 | 1719 | 16 |
713430 | 713430 | 2020-11-09 | Stephenson | Illinois | 17177 | 1654 | 13 |
710186 | 710186 | 2020-11-08 | Stephenson | Illinois | 17177 | 1618 | 13 |
706942 | 706942 | 2020-11-07 | Stephenson | Illinois | 17177 | 1582 | 13 |
703699 | 703699 | 2020-11-06 | Stephenson | Illinois | 17177 | 1504 | 12 |
700456 | 700456 | 2020-11-05 | Stephenson | Illinois | 17177 | 1443 | 12 |
697212 | 697212 | 2020-11-04 | Stephenson | Illinois | 17177 | 1395 | 11 |
693970 | 693970 | 2020-11-03 | Stephenson | Illinois | 17177 | 1346 | 10 |
690727 | 690727 | 2020-11-02 | Stephenson | Illinois | 17177 | 1318 | 9 |
687482 | 687482 | 2020-11-01 | Stephenson | Illinois | 17177 | 1242 | 9 |
684238 | 684238 | 2020-10-31 | Stephenson | Illinois | 17177 | 1182 | 9 |
680995 | 680995 | 2020-10-30 | Stephenson | Illinois | 17177 | 1182 | 9 |
677752 | 677752 | 2020-10-29 | Stephenson | Illinois | 17177 | 1129 | 9 |
674509 | 674509 | 2020-10-28 | Stephenson | Illinois | 17177 | 1075 | 9 |
671267 | 671267 | 2020-10-27 | Stephenson | Illinois | 17177 | 1032 | 7 |
668024 | 668024 | 2020-10-26 | Stephenson | Illinois | 17177 | 1018 | 7 |
664780 | 664780 | 2020-10-25 | Stephenson | Illinois | 17177 | 981 | 7 |
661535 | 661535 | 2020-10-24 | Stephenson | Illinois | 17177 | 949 | 7 |
658291 | 658291 | 2020-10-23 | Stephenson | Illinois | 17177 | 900 | 7 |
655046 | 655046 | 2020-10-22 | Stephenson | Illinois | 17177 | 865 | 7 |
651801 | 651801 | 2020-10-21 | Stephenson | Illinois | 17177 | 851 | 7 |
648557 | 648557 | 2020-10-20 | Stephenson | Illinois | 17177 | 820 | 7 |
645312 | 645312 | 2020-10-19 | Stephenson | Illinois | 17177 | 814 | 7 |
642065 | 642065 | 2020-10-18 | Stephenson | Illinois | 17177 | 780 | 7 |
638818 | 638818 | 2020-10-17 | Stephenson | Illinois | 17177 | 749 | 7 |
635572 | 635572 | 2020-10-16 | Stephenson | Illinois | 17177 | 746 | 7 |
632326 | 632326 | 2020-10-15 | Stephenson | Illinois | 17177 | 732 | 7 |
629082 | 629082 | 2020-10-14 | Stephenson | Illinois | 17177 | 712 | 7 |
625839 | 625839 | 2020-10-13 | Stephenson | Illinois | 17177 | 707 | 7 |
622597 | 622597 | 2020-10-12 | Stephenson | Illinois | 17177 | 699 | 7 |
619353 | 619353 | 2020-10-11 | Stephenson | Illinois | 17177 | 673 | 7 |
616111 | 616111 | 2020-10-10 | Stephenson | Illinois | 17177 | 666 | 7 |
612870 | 612870 | 2020-10-09 | Stephenson | Illinois | 17177 | 649 | 7 |
609628 | 609628 | 2020-10-08 | Stephenson | Illinois | 17177 | 635 | 7 |
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);