ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26045 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921702 | 921702 | 2021-01-12 | Eaton | Michigan | 26045 | 5239 | 111 |
918457 | 918457 | 2021-01-11 | Eaton | Michigan | 26045 | 5186 | 110 |
915212 | 915212 | 2021-01-10 | Eaton | Michigan | 26045 | 5136 | 106 |
911967 | 911967 | 2021-01-09 | Eaton | Michigan | 26045 | 5136 | 106 |
908722 | 908722 | 2021-01-08 | Eaton | Michigan | 26045 | 5072 | 102 |
905476 | 905476 | 2021-01-07 | Eaton | Michigan | 26045 | 5052 | 102 |
902231 | 902231 | 2021-01-06 | Eaton | Michigan | 26045 | 4997 | 100 |
898986 | 898986 | 2021-01-05 | Eaton | Michigan | 26045 | 4938 | 100 |
895741 | 895741 | 2021-01-04 | Eaton | Michigan | 26045 | 4896 | 97 |
892494 | 892494 | 2021-01-03 | Eaton | Michigan | 26045 | 4810 | 95 |
889248 | 889248 | 2021-01-02 | Eaton | Michigan | 26045 | 4810 | 95 |
886002 | 886002 | 2021-01-01 | Eaton | Michigan | 26045 | 4667 | 88 |
882757 | 882757 | 2020-12-31 | Eaton | Michigan | 26045 | 4667 | 88 |
879512 | 879512 | 2020-12-30 | Eaton | Michigan | 26045 | 4667 | 88 |
876267 | 876267 | 2020-12-29 | Eaton | Michigan | 26045 | 4620 | 89 |
873022 | 873022 | 2020-12-28 | Eaton | Michigan | 26045 | 4540 | 87 |
869777 | 869777 | 2020-12-27 | Eaton | Michigan | 26045 | 4485 | 87 |
866532 | 866532 | 2020-12-26 | Eaton | Michigan | 26045 | 4485 | 87 |
863287 | 863287 | 2020-12-25 | Eaton | Michigan | 26045 | 4405 | 82 |
860042 | 860042 | 2020-12-24 | Eaton | Michigan | 26045 | 4405 | 82 |
856797 | 856797 | 2020-12-23 | Eaton | Michigan | 26045 | 4405 | 82 |
853552 | 853552 | 2020-12-22 | Eaton | Michigan | 26045 | 4370 | 82 |
850307 | 850307 | 2020-12-21 | Eaton | Michigan | 26045 | 4327 | 82 |
847062 | 847062 | 2020-12-20 | Eaton | Michigan | 26045 | 4266 | 79 |
843816 | 843816 | 2020-12-19 | Eaton | Michigan | 26045 | 4266 | 79 |
840571 | 840571 | 2020-12-18 | Eaton | Michigan | 26045 | 4237 | 76 |
837326 | 837326 | 2020-12-17 | Eaton | Michigan | 26045 | 4164 | 74 |
834080 | 834080 | 2020-12-16 | Eaton | Michigan | 26045 | 4118 | 72 |
830833 | 830833 | 2020-12-15 | Eaton | Michigan | 26045 | 4077 | 71 |
827587 | 827587 | 2020-12-14 | Eaton | Michigan | 26045 | 4030 | 69 |
824340 | 824340 | 2020-12-13 | Eaton | Michigan | 26045 | 3978 | 67 |
821094 | 821094 | 2020-12-12 | Eaton | Michigan | 26045 | 3978 | 67 |
817848 | 817848 | 2020-12-11 | Eaton | Michigan | 26045 | 3945 | 64 |
814602 | 814602 | 2020-12-10 | Eaton | Michigan | 26045 | 3900 | 62 |
811357 | 811357 | 2020-12-09 | Eaton | Michigan | 26045 | 3810 | 61 |
808112 | 808112 | 2020-12-08 | Eaton | Michigan | 26045 | 3743 | 59 |
804867 | 804867 | 2020-12-07 | Eaton | Michigan | 26045 | 3689 | 56 |
801622 | 801622 | 2020-12-06 | Eaton | Michigan | 26045 | 3585 | 52 |
798377 | 798377 | 2020-12-05 | Eaton | Michigan | 26045 | 3585 | 52 |
795132 | 795132 | 2020-12-04 | Eaton | Michigan | 26045 | 3531 | 51 |
791887 | 791887 | 2020-12-03 | Eaton | Michigan | 26045 | 3433 | 48 |
788642 | 788642 | 2020-12-02 | Eaton | Michigan | 26045 | 3342 | 45 |
785397 | 785397 | 2020-12-01 | Eaton | Michigan | 26045 | 3254 | 44 |
782153 | 782153 | 2020-11-30 | Eaton | Michigan | 26045 | 3178 | 42 |
778907 | 778907 | 2020-11-29 | Eaton | Michigan | 26045 | 3076 | 37 |
775662 | 775662 | 2020-11-28 | Eaton | Michigan | 26045 | 3076 | 37 |
772417 | 772417 | 2020-11-27 | Eaton | Michigan | 26045 | 2948 | 36 |
769172 | 769172 | 2020-11-26 | Eaton | Michigan | 26045 | 2823 | 33 |
765926 | 765926 | 2020-11-25 | Eaton | Michigan | 26045 | 2823 | 33 |
762681 | 762681 | 2020-11-24 | Eaton | Michigan | 26045 | 2774 | 33 |
759436 | 759436 | 2020-11-23 | Eaton | Michigan | 26045 | 2702 | 30 |
756189 | 756189 | 2020-11-22 | Eaton | Michigan | 26045 | 2564 | 29 |
752943 | 752943 | 2020-11-21 | Eaton | Michigan | 26045 | 2564 | 29 |
749697 | 749697 | 2020-11-20 | Eaton | Michigan | 26045 | 2510 | 27 |
746451 | 746451 | 2020-11-19 | Eaton | Michigan | 26045 | 2424 | 25 |
743204 | 743204 | 2020-11-18 | Eaton | Michigan | 26045 | 2348 | 24 |
739957 | 739957 | 2020-11-17 | Eaton | Michigan | 26045 | 2270 | 24 |
736713 | 736713 | 2020-11-16 | Eaton | Michigan | 26045 | 2199 | 23 |
733467 | 733467 | 2020-11-15 | Eaton | Michigan | 26045 | 2086 | 23 |
730222 | 730222 | 2020-11-14 | Eaton | Michigan | 26045 | 2086 | 23 |
726979 | 726979 | 2020-11-13 | Eaton | Michigan | 26045 | 1957 | 23 |
723736 | 723736 | 2020-11-12 | Eaton | Michigan | 26045 | 1889 | 21 |
720493 | 720493 | 2020-11-11 | Eaton | Michigan | 26045 | 1798 | 21 |
717250 | 717250 | 2020-11-10 | Eaton | Michigan | 26045 | 1748 | 19 |
714006 | 714006 | 2020-11-09 | Eaton | Michigan | 26045 | 1709 | 16 |
710762 | 710762 | 2020-11-08 | Eaton | Michigan | 26045 | 1624 | 13 |
707518 | 707518 | 2020-11-07 | Eaton | Michigan | 26045 | 1624 | 13 |
704275 | 704275 | 2020-11-06 | Eaton | Michigan | 26045 | 1556 | 14 |
701033 | 701033 | 2020-11-05 | Eaton | Michigan | 26045 | 1486 | 14 |
697789 | 697789 | 2020-11-04 | Eaton | Michigan | 26045 | 1412 | 12 |
694546 | 694546 | 2020-11-03 | Eaton | Michigan | 26045 | 1390 | 12 |
691304 | 691304 | 2020-11-02 | Eaton | Michigan | 26045 | 1359 | 11 |
688059 | 688059 | 2020-11-01 | Eaton | Michigan | 26045 | 1304 | 11 |
684815 | 684815 | 2020-10-31 | Eaton | Michigan | 26045 | 1304 | 11 |
681572 | 681572 | 2020-10-30 | Eaton | Michigan | 26045 | 1245 | 11 |
678328 | 678328 | 2020-10-29 | Eaton | Michigan | 26045 | 1228 | 11 |
675086 | 675086 | 2020-10-28 | Eaton | Michigan | 26045 | 1180 | 11 |
671843 | 671843 | 2020-10-27 | Eaton | Michigan | 26045 | 1156 | 11 |
668601 | 668601 | 2020-10-26 | Eaton | Michigan | 26045 | 1131 | 11 |
665357 | 665357 | 2020-10-25 | Eaton | Michigan | 26045 | 1092 | 11 |
662112 | 662112 | 2020-10-24 | Eaton | Michigan | 26045 | 1092 | 11 |
658868 | 658868 | 2020-10-23 | Eaton | Michigan | 26045 | 1039 | 11 |
655623 | 655623 | 2020-10-22 | Eaton | Michigan | 26045 | 1031 | 11 |
652378 | 652378 | 2020-10-21 | Eaton | Michigan | 26045 | 1010 | 11 |
649133 | 649133 | 2020-10-20 | Eaton | Michigan | 26045 | 984 | 10 |
645889 | 645889 | 2020-10-19 | Eaton | Michigan | 26045 | 970 | 10 |
642642 | 642642 | 2020-10-18 | Eaton | Michigan | 26045 | 894 | 10 |
639395 | 639395 | 2020-10-17 | Eaton | Michigan | 26045 | 894 | 10 |
636149 | 636149 | 2020-10-16 | Eaton | Michigan | 26045 | 894 | 10 |
632903 | 632903 | 2020-10-15 | Eaton | Michigan | 26045 | 878 | 10 |
629658 | 629658 | 2020-10-14 | Eaton | Michigan | 26045 | 852 | 10 |
626414 | 626414 | 2020-10-13 | Eaton | Michigan | 26045 | 838 | 10 |
623172 | 623172 | 2020-10-12 | Eaton | Michigan | 26045 | 828 | 10 |
619929 | 619929 | 2020-10-11 | Eaton | Michigan | 26045 | 816 | 10 |
616687 | 616687 | 2020-10-10 | Eaton | Michigan | 26045 | 816 | 10 |
613446 | 613446 | 2020-10-09 | Eaton | Michigan | 26045 | 799 | 10 |
610204 | 610204 | 2020-10-08 | Eaton | Michigan | 26045 | 781 | 10 |
606962 | 606962 | 2020-10-07 | Eaton | Michigan | 26045 | 763 | 10 |
603719 | 603719 | 2020-10-06 | Eaton | Michigan | 26045 | 749 | 10 |
600477 | 600477 | 2020-10-05 | Eaton | Michigan | 26045 | 740 | 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);