ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,591 rows where deaths = 0 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Luce 277
- Mackinac 244
- Chippewa 227
- Antrim 222
- Montmorency 213
- Osceola 213
- Lake 199
- Schoolcraft 197
- Mason 186
- Baraga 165
- Leelanau 165
- Newaygo 161
- Menominee 159
- Houghton 152
- Keweenaw 148
- Roscommon 142
- Alger 131
- Manistee 127
- Ontonagon 119
- Presque Isle 110
- Benzie 88
- Ogemaw 63
- Oscoda 38
- Huron 35
- Allegan 34
- Lenawee 33
- Charlevoix 31
- Bay 30
- Gladwin 29
- Monroe 26
- …
state 1
- Michigan · 4,591 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
924972 | 924972 | 2021-01-13 | Luce | Michigan | 26095 | 981 | 0 |
921727 | 921727 | 2021-01-12 | Luce | Michigan | 26095 | 980 | 0 |
918482 | 918482 | 2021-01-11 | Luce | Michigan | 26095 | 980 | 0 |
915237 | 915237 | 2021-01-10 | Luce | Michigan | 26095 | 980 | 0 |
911992 | 911992 | 2021-01-09 | Luce | Michigan | 26095 | 980 | 0 |
908747 | 908747 | 2021-01-08 | Luce | Michigan | 26095 | 980 | 0 |
905501 | 905501 | 2021-01-07 | Luce | Michigan | 26095 | 979 | 0 |
902256 | 902256 | 2021-01-06 | Luce | Michigan | 26095 | 979 | 0 |
899011 | 899011 | 2021-01-05 | Luce | Michigan | 26095 | 979 | 0 |
895766 | 895766 | 2021-01-04 | Luce | Michigan | 26095 | 979 | 0 |
892519 | 892519 | 2021-01-03 | Luce | Michigan | 26095 | 979 | 0 |
889273 | 889273 | 2021-01-02 | Luce | Michigan | 26095 | 979 | 0 |
886027 | 886027 | 2021-01-01 | Luce | Michigan | 26095 | 976 | 0 |
882782 | 882782 | 2020-12-31 | Luce | Michigan | 26095 | 976 | 0 |
879537 | 879537 | 2020-12-30 | Luce | Michigan | 26095 | 976 | 0 |
876292 | 876292 | 2020-12-29 | Luce | Michigan | 26095 | 976 | 0 |
873047 | 873047 | 2020-12-28 | Luce | Michigan | 26095 | 979 | 0 |
869802 | 869802 | 2020-12-27 | Luce | Michigan | 26095 | 975 | 0 |
866557 | 866557 | 2020-12-26 | Luce | Michigan | 26095 | 975 | 0 |
863312 | 863312 | 2020-12-25 | Luce | Michigan | 26095 | 971 | 0 |
860067 | 860067 | 2020-12-24 | Luce | Michigan | 26095 | 971 | 0 |
856822 | 856822 | 2020-12-23 | Luce | Michigan | 26095 | 971 | 0 |
853577 | 853577 | 2020-12-22 | Luce | Michigan | 26095 | 971 | 0 |
850332 | 850332 | 2020-12-21 | Luce | Michigan | 26095 | 970 | 0 |
847087 | 847087 | 2020-12-20 | Luce | Michigan | 26095 | 970 | 0 |
843841 | 843841 | 2020-12-19 | Luce | Michigan | 26095 | 970 | 0 |
840596 | 840596 | 2020-12-18 | Luce | Michigan | 26095 | 970 | 0 |
837351 | 837351 | 2020-12-17 | Luce | Michigan | 26095 | 970 | 0 |
834105 | 834105 | 2020-12-16 | Luce | Michigan | 26095 | 969 | 0 |
830858 | 830858 | 2020-12-15 | Luce | Michigan | 26095 | 966 | 0 |
827612 | 827612 | 2020-12-14 | Luce | Michigan | 26095 | 966 | 0 |
824365 | 824365 | 2020-12-13 | Luce | Michigan | 26095 | 967 | 0 |
821119 | 821119 | 2020-12-12 | Luce | Michigan | 26095 | 967 | 0 |
817873 | 817873 | 2020-12-11 | Luce | Michigan | 26095 | 965 | 0 |
814627 | 814627 | 2020-12-10 | Luce | Michigan | 26095 | 962 | 0 |
811382 | 811382 | 2020-12-09 | Luce | Michigan | 26095 | 962 | 0 |
808137 | 808137 | 2020-12-08 | Luce | Michigan | 26095 | 961 | 0 |
804892 | 804892 | 2020-12-07 | Luce | Michigan | 26095 | 961 | 0 |
801647 | 801647 | 2020-12-06 | Luce | Michigan | 26095 | 961 | 0 |
798402 | 798402 | 2020-12-05 | Luce | Michigan | 26095 | 961 | 0 |
795157 | 795157 | 2020-12-04 | Luce | Michigan | 26095 | 960 | 0 |
791912 | 791912 | 2020-12-03 | Luce | Michigan | 26095 | 588 | 0 |
788667 | 788667 | 2020-12-02 | Luce | Michigan | 26095 | 589 | 0 |
785422 | 785422 | 2020-12-01 | Luce | Michigan | 26095 | 586 | 0 |
782178 | 782178 | 2020-11-30 | Luce | Michigan | 26095 | 586 | 0 |
782179 | 782179 | 2020-11-30 | Mackinac | Michigan | 26097 | 291 | 0 |
778932 | 778932 | 2020-11-29 | Luce | Michigan | 26095 | 585 | 0 |
778933 | 778933 | 2020-11-29 | Mackinac | Michigan | 26097 | 281 | 0 |
775687 | 775687 | 2020-11-28 | Luce | Michigan | 26095 | 585 | 0 |
775688 | 775688 | 2020-11-28 | Mackinac | Michigan | 26097 | 281 | 0 |
772442 | 772442 | 2020-11-27 | Luce | Michigan | 26095 | 584 | 0 |
772443 | 772443 | 2020-11-27 | Mackinac | Michigan | 26097 | 277 | 0 |
769197 | 769197 | 2020-11-26 | Luce | Michigan | 26095 | 579 | 0 |
769198 | 769198 | 2020-11-26 | Mackinac | Michigan | 26097 | 263 | 0 |
765951 | 765951 | 2020-11-25 | Luce | Michigan | 26095 | 579 | 0 |
765952 | 765952 | 2020-11-25 | Mackinac | Michigan | 26097 | 263 | 0 |
762706 | 762706 | 2020-11-24 | Luce | Michigan | 26095 | 577 | 0 |
762707 | 762707 | 2020-11-24 | Mackinac | Michigan | 26097 | 259 | 0 |
759461 | 759461 | 2020-11-23 | Luce | Michigan | 26095 | 573 | 0 |
759462 | 759462 | 2020-11-23 | Mackinac | Michigan | 26097 | 249 | 0 |
756214 | 756214 | 2020-11-22 | Luce | Michigan | 26095 | 571 | 0 |
756215 | 756215 | 2020-11-22 | Mackinac | Michigan | 26097 | 246 | 0 |
752968 | 752968 | 2020-11-21 | Luce | Michigan | 26095 | 571 | 0 |
752969 | 752969 | 2020-11-21 | Mackinac | Michigan | 26097 | 246 | 0 |
749722 | 749722 | 2020-11-20 | Luce | Michigan | 26095 | 571 | 0 |
749723 | 749723 | 2020-11-20 | Mackinac | Michigan | 26097 | 239 | 0 |
746476 | 746476 | 2020-11-19 | Luce | Michigan | 26095 | 570 | 0 |
746477 | 746477 | 2020-11-19 | Mackinac | Michigan | 26097 | 237 | 0 |
743229 | 743229 | 2020-11-18 | Luce | Michigan | 26095 | 564 | 0 |
743230 | 743230 | 2020-11-18 | Mackinac | Michigan | 26097 | 233 | 0 |
739982 | 739982 | 2020-11-17 | Luce | Michigan | 26095 | 562 | 0 |
739983 | 739983 | 2020-11-17 | Mackinac | Michigan | 26097 | 228 | 0 |
736738 | 736738 | 2020-11-16 | Luce | Michigan | 26095 | 560 | 0 |
736739 | 736739 | 2020-11-16 | Mackinac | Michigan | 26097 | 221 | 0 |
736750 | 736750 | 2020-11-16 | Montmorency | Michigan | 26119 | 92 | 0 |
733492 | 733492 | 2020-11-15 | Luce | Michigan | 26095 | 558 | 0 |
733493 | 733493 | 2020-11-15 | Mackinac | Michigan | 26097 | 216 | 0 |
733504 | 733504 | 2020-11-15 | Montmorency | Michigan | 26119 | 81 | 0 |
730247 | 730247 | 2020-11-14 | Luce | Michigan | 26095 | 558 | 0 |
730248 | 730248 | 2020-11-14 | Mackinac | Michigan | 26097 | 216 | 0 |
730259 | 730259 | 2020-11-14 | Montmorency | Michigan | 26119 | 81 | 0 |
727004 | 727004 | 2020-11-13 | Luce | Michigan | 26095 | 560 | 0 |
727005 | 727005 | 2020-11-13 | Mackinac | Michigan | 26097 | 211 | 0 |
727016 | 727016 | 2020-11-13 | Montmorency | Michigan | 26119 | 77 | 0 |
723730 | 723730 | 2020-11-12 | Chippewa | Michigan | 26033 | 463 | 0 |
723761 | 723761 | 2020-11-12 | Luce | Michigan | 26095 | 543 | 0 |
723762 | 723762 | 2020-11-12 | Mackinac | Michigan | 26097 | 208 | 0 |
723773 | 723773 | 2020-11-12 | Montmorency | Michigan | 26119 | 67 | 0 |
720487 | 720487 | 2020-11-11 | Chippewa | Michigan | 26033 | 427 | 0 |
720518 | 720518 | 2020-11-11 | Luce | Michigan | 26095 | 540 | 0 |
720519 | 720519 | 2020-11-11 | Mackinac | Michigan | 26097 | 201 | 0 |
720530 | 720530 | 2020-11-11 | Montmorency | Michigan | 26119 | 64 | 0 |
717244 | 717244 | 2020-11-10 | Chippewa | Michigan | 26033 | 396 | 0 |
717275 | 717275 | 2020-11-10 | Luce | Michigan | 26095 | 537 | 0 |
717276 | 717276 | 2020-11-10 | Mackinac | Michigan | 26097 | 193 | 0 |
717287 | 717287 | 2020-11-10 | Montmorency | Michigan | 26119 | 60 | 0 |
714000 | 714000 | 2020-11-09 | Chippewa | Michigan | 26033 | 357 | 0 |
714031 | 714031 | 2020-11-09 | Luce | Michigan | 26095 | 530 | 0 |
714032 | 714032 | 2020-11-09 | Mackinac | Michigan | 26097 | 191 | 0 |
714043 | 714043 | 2020-11-09 | Montmorency | Michigan | 26119 | 52 | 0 |
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);