ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Delta" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921700 | 921700 | 2021-01-12 | Delta | Michigan | 26041 | 2981 | 78 |
918455 | 918455 | 2021-01-11 | Delta | Michigan | 26041 | 2977 | 78 |
915210 | 915210 | 2021-01-10 | Delta | Michigan | 26041 | 2971 | 78 |
911965 | 911965 | 2021-01-09 | Delta | Michigan | 26041 | 2971 | 78 |
908720 | 908720 | 2021-01-08 | Delta | Michigan | 26041 | 2967 | 78 |
905474 | 905474 | 2021-01-07 | Delta | Michigan | 26041 | 2961 | 78 |
902229 | 902229 | 2021-01-06 | Delta | Michigan | 26041 | 2953 | 78 |
898984 | 898984 | 2021-01-05 | Delta | Michigan | 26041 | 2932 | 78 |
895739 | 895739 | 2021-01-04 | Delta | Michigan | 26041 | 2921 | 77 |
892492 | 892492 | 2021-01-03 | Delta | Michigan | 26041 | 2916 | 77 |
889246 | 889246 | 2021-01-02 | Delta | Michigan | 26041 | 2916 | 77 |
886000 | 886000 | 2021-01-01 | Delta | Michigan | 26041 | 2889 | 77 |
882755 | 882755 | 2020-12-31 | Delta | Michigan | 26041 | 2889 | 77 |
879510 | 879510 | 2020-12-30 | Delta | Michigan | 26041 | 2889 | 77 |
876265 | 876265 | 2020-12-29 | Delta | Michigan | 26041 | 2878 | 77 |
873020 | 873020 | 2020-12-28 | Delta | Michigan | 26041 | 2869 | 75 |
869775 | 869775 | 2020-12-27 | Delta | Michigan | 26041 | 2867 | 75 |
866530 | 866530 | 2020-12-26 | Delta | Michigan | 26041 | 2867 | 75 |
863285 | 863285 | 2020-12-25 | Delta | Michigan | 26041 | 2853 | 75 |
860040 | 860040 | 2020-12-24 | Delta | Michigan | 26041 | 2853 | 75 |
856795 | 856795 | 2020-12-23 | Delta | Michigan | 26041 | 2853 | 75 |
853550 | 853550 | 2020-12-22 | Delta | Michigan | 26041 | 2841 | 74 |
850305 | 850305 | 2020-12-21 | Delta | Michigan | 26041 | 2836 | 74 |
847060 | 847060 | 2020-12-20 | Delta | Michigan | 26041 | 2820 | 73 |
843814 | 843814 | 2020-12-19 | Delta | Michigan | 26041 | 2820 | 73 |
840569 | 840569 | 2020-12-18 | Delta | Michigan | 26041 | 2823 | 71 |
837324 | 837324 | 2020-12-17 | Delta | Michigan | 26041 | 2814 | 71 |
834078 | 834078 | 2020-12-16 | Delta | Michigan | 26041 | 2799 | 67 |
830831 | 830831 | 2020-12-15 | Delta | Michigan | 26041 | 2775 | 66 |
827585 | 827585 | 2020-12-14 | Delta | Michigan | 26041 | 2768 | 66 |
824338 | 824338 | 2020-12-13 | Delta | Michigan | 26041 | 2749 | 66 |
821092 | 821092 | 2020-12-12 | Delta | Michigan | 26041 | 2749 | 66 |
817846 | 817846 | 2020-12-11 | Delta | Michigan | 26041 | 2738 | 65 |
814600 | 814600 | 2020-12-10 | Delta | Michigan | 26041 | 2723 | 65 |
811355 | 811355 | 2020-12-09 | Delta | Michigan | 26041 | 2697 | 65 |
808110 | 808110 | 2020-12-08 | Delta | Michigan | 26041 | 2662 | 65 |
804865 | 804865 | 2020-12-07 | Delta | Michigan | 26041 | 2647 | 65 |
801620 | 801620 | 2020-12-06 | Delta | Michigan | 26041 | 2626 | 64 |
798375 | 798375 | 2020-12-05 | Delta | Michigan | 26041 | 2626 | 64 |
795130 | 795130 | 2020-12-04 | Delta | Michigan | 26041 | 2613 | 63 |
791885 | 791885 | 2020-12-03 | Delta | Michigan | 26041 | 2588 | 63 |
788640 | 788640 | 2020-12-02 | Delta | Michigan | 26041 | 2554 | 62 |
785395 | 785395 | 2020-12-01 | Delta | Michigan | 26041 | 2504 | 60 |
782151 | 782151 | 2020-11-30 | Delta | Michigan | 26041 | 2492 | 59 |
778905 | 778905 | 2020-11-29 | Delta | Michigan | 26041 | 2437 | 58 |
775660 | 775660 | 2020-11-28 | Delta | Michigan | 26041 | 2437 | 58 |
772415 | 772415 | 2020-11-27 | Delta | Michigan | 26041 | 2404 | 58 |
769170 | 769170 | 2020-11-26 | Delta | Michigan | 26041 | 2343 | 58 |
765924 | 765924 | 2020-11-25 | Delta | Michigan | 26041 | 2343 | 58 |
762679 | 762679 | 2020-11-24 | Delta | Michigan | 26041 | 2336 | 58 |
759434 | 759434 | 2020-11-23 | Delta | Michigan | 26041 | 2318 | 57 |
756187 | 756187 | 2020-11-22 | Delta | Michigan | 26041 | 2286 | 56 |
752941 | 752941 | 2020-11-21 | Delta | Michigan | 26041 | 2286 | 56 |
749695 | 749695 | 2020-11-20 | Delta | Michigan | 26041 | 2261 | 56 |
746449 | 746449 | 2020-11-19 | Delta | Michigan | 26041 | 2218 | 56 |
743202 | 743202 | 2020-11-18 | Delta | Michigan | 26041 | 2150 | 55 |
739955 | 739955 | 2020-11-17 | Delta | Michigan | 26041 | 2108 | 55 |
736711 | 736711 | 2020-11-16 | Delta | Michigan | 26041 | 2075 | 55 |
733465 | 733465 | 2020-11-15 | Delta | Michigan | 26041 | 2036 | 55 |
730220 | 730220 | 2020-11-14 | Delta | Michigan | 26041 | 2036 | 55 |
726977 | 726977 | 2020-11-13 | Delta | Michigan | 26041 | 1982 | 54 |
723734 | 723734 | 2020-11-12 | Delta | Michigan | 26041 | 1895 | 52 |
720491 | 720491 | 2020-11-11 | Delta | Michigan | 26041 | 1799 | 51 |
717248 | 717248 | 2020-11-10 | Delta | Michigan | 26041 | 1773 | 50 |
714004 | 714004 | 2020-11-09 | Delta | Michigan | 26041 | 1745 | 49 |
710760 | 710760 | 2020-11-08 | Delta | Michigan | 26041 | 1672 | 45 |
707516 | 707516 | 2020-11-07 | Delta | Michigan | 26041 | 1672 | 45 |
704273 | 704273 | 2020-11-06 | Delta | Michigan | 26041 | 1644 | 43 |
701031 | 701031 | 2020-11-05 | Delta | Michigan | 26041 | 1608 | 42 |
697787 | 697787 | 2020-11-04 | Delta | Michigan | 26041 | 1524 | 40 |
694544 | 694544 | 2020-11-03 | Delta | Michigan | 26041 | 1456 | 40 |
691302 | 691302 | 2020-11-02 | Delta | Michigan | 26041 | 1420 | 40 |
688057 | 688057 | 2020-11-01 | Delta | Michigan | 26041 | 1397 | 38 |
684813 | 684813 | 2020-10-31 | Delta | Michigan | 26041 | 1397 | 38 |
681570 | 681570 | 2020-10-30 | Delta | Michigan | 26041 | 1332 | 34 |
678326 | 678326 | 2020-10-29 | Delta | Michigan | 26041 | 1300 | 34 |
675084 | 675084 | 2020-10-28 | Delta | Michigan | 26041 | 1263 | 27 |
671841 | 671841 | 2020-10-27 | Delta | Michigan | 26041 | 1201 | 26 |
668599 | 668599 | 2020-10-26 | Delta | Michigan | 26041 | 1178 | 24 |
665355 | 665355 | 2020-10-25 | Delta | Michigan | 26041 | 1140 | 24 |
662110 | 662110 | 2020-10-24 | Delta | Michigan | 26041 | 1140 | 24 |
658866 | 658866 | 2020-10-23 | Delta | Michigan | 26041 | 1111 | 22 |
655621 | 655621 | 2020-10-22 | Delta | Michigan | 26041 | 1097 | 22 |
652376 | 652376 | 2020-10-21 | Delta | Michigan | 26041 | 1051 | 20 |
649131 | 649131 | 2020-10-20 | Delta | Michigan | 26041 | 1027 | 19 |
645887 | 645887 | 2020-10-19 | Delta | Michigan | 26041 | 1005 | 18 |
642640 | 642640 | 2020-10-18 | Delta | Michigan | 26041 | 949 | 16 |
639393 | 639393 | 2020-10-17 | Delta | Michigan | 26041 | 949 | 16 |
636147 | 636147 | 2020-10-16 | Delta | Michigan | 26041 | 949 | 16 |
632901 | 632901 | 2020-10-15 | Delta | Michigan | 26041 | 912 | 16 |
629656 | 629656 | 2020-10-14 | Delta | Michigan | 26041 | 888 | 15 |
626412 | 626412 | 2020-10-13 | Delta | Michigan | 26041 | 849 | 15 |
623170 | 623170 | 2020-10-12 | Delta | Michigan | 26041 | 832 | 14 |
619927 | 619927 | 2020-10-11 | Delta | Michigan | 26041 | 808 | 13 |
616685 | 616685 | 2020-10-10 | Delta | Michigan | 26041 | 808 | 13 |
613444 | 613444 | 2020-10-09 | Delta | Michigan | 26041 | 796 | 13 |
610202 | 610202 | 2020-10-08 | Delta | Michigan | 26041 | 781 | 13 |
606960 | 606960 | 2020-10-07 | Delta | Michigan | 26041 | 753 | 11 |
603717 | 603717 | 2020-10-06 | Delta | Michigan | 26041 | 722 | 10 |
600475 | 600475 | 2020-10-05 | Delta | Michigan | 26041 | 709 | 10 |
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);