ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 79 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
869796 | 869796 | 2020-12-27 | Keweenaw | Michigan | 26083 | 79 | 2 |
866551 | 866551 | 2020-12-26 | Keweenaw | Michigan | 26083 | 79 | 2 |
811376 | 811376 | 2020-12-09 | Keweenaw | Michigan | 26083 | 79 | 2 |
681620 | 681620 | 2020-10-30 | Presque Isle | Michigan | 26141 | 79 | 1 |
658911 | 658911 | 2020-10-23 | Ontonagon | Michigan | 26131 | 79 | 0 |
655607 | 655607 | 2020-10-22 | Baraga | Michigan | 26013 | 79 | 4 |
626456 | 626456 | 2020-10-13 | Ogemaw | Michigan | 26129 | 79 | 5 |
619911 | 619911 | 2020-10-11 | Antrim | Michigan | 26009 | 79 | 0 |
616669 | 616669 | 2020-10-10 | Antrim | Michigan | 26009 | 79 | 0 |
610186 | 610186 | 2020-10-08 | Antrim | Michigan | 26009 | 79 | 0 |
581024 | 581024 | 2020-09-29 | Chippewa | Michigan | 26033 | 79 | 0 |
577783 | 577783 | 2020-09-28 | Chippewa | Michigan | 26033 | 79 | 0 |
574535 | 574535 | 2020-09-27 | Benzie | Michigan | 26019 | 79 | 2 |
574542 | 574542 | 2020-09-27 | Chippewa | Michigan | 26033 | 79 | 0 |
571292 | 571292 | 2020-09-26 | Benzie | Michigan | 26019 | 79 | 2 |
571299 | 571299 | 2020-09-26 | Chippewa | Michigan | 26033 | 79 | 0 |
568050 | 568050 | 2020-09-25 | Benzie | Michigan | 26019 | 79 | 2 |
564810 | 564810 | 2020-09-24 | Benzie | Michigan | 26019 | 79 | 2 |
558333 | 558333 | 2020-09-22 | Benzie | Michigan | 26019 | 79 | 2 |
555096 | 555096 | 2020-09-21 | Benzie | Michigan | 26019 | 79 | 2 |
535701 | 535701 | 2020-09-15 | Kalkaska | Michigan | 26079 | 79 | 4 |
532466 | 532466 | 2020-09-14 | Kalkaska | Michigan | 26079 | 79 | 4 |
529241 | 529241 | 2020-09-13 | Manistee | Michigan | 26101 | 79 | 2 |
526005 | 526005 | 2020-09-12 | Manistee | Michigan | 26101 | 79 | 2 |
522769 | 522769 | 2020-09-11 | Manistee | Michigan | 26101 | 79 | 2 |
519532 | 519532 | 2020-09-10 | Manistee | Michigan | 26101 | 79 | 2 |
516297 | 516297 | 2020-09-09 | Manistee | Michigan | 26101 | 79 | 2 |
509795 | 509795 | 2020-09-07 | Charlevoix | Michigan | 26029 | 79 | 3 |
509852 | 509852 | 2020-09-07 | Roscommon | Michigan | 26143 | 79 | 4 |
506562 | 506562 | 2020-09-06 | Charlevoix | Michigan | 26029 | 79 | 3 |
503329 | 503329 | 2020-09-05 | Charlevoix | Michigan | 26029 | 79 | 3 |
493639 | 493639 | 2020-09-02 | Gladwin | Michigan | 26051 | 79 | 2 |
493680 | 493680 | 2020-09-02 | Osceola | Michigan | 26133 | 79 | 0 |
490394 | 490394 | 2020-09-01 | Charlevoix | Michigan | 26029 | 79 | 3 |
490405 | 490405 | 2020-09-01 | Gladwin | Michigan | 26051 | 79 | 2 |
490446 | 490446 | 2020-09-01 | Osceola | Michigan | 26133 | 79 | 0 |
487162 | 487162 | 2020-08-31 | Cheboygan | Michigan | 26031 | 79 | 2 |
487213 | 487213 | 2020-08-31 | Osceola | Michigan | 26133 | 79 | 0 |
483928 | 483928 | 2020-08-30 | Cheboygan | Michigan | 26031 | 79 | 2 |
445237 | 445237 | 2020-08-18 | Wexford | Michigan | 26165 | 79 | 4 |
358340 | 358340 | 2020-07-22 | Sanilac | Michigan | 26151 | 79 | 6 |
339117 | 339117 | 2020-07-16 | Mason | Michigan | 26105 | 79 | 0 |
332728 | 332728 | 2020-07-14 | Mason | Michigan | 26105 | 79 | 0 |
216588 | 216588 | 2020-06-07 | Montcalm | Michigan | 26117 | 79 | 1 |
182745 | 182745 | 2020-05-27 | Cass | Michigan | 26027 | 79 | 2 |
179739 | 179739 | 2020-05-26 | Midland | Michigan | 26111 | 79 | 8 |
176695 | 176695 | 2020-05-25 | Midland | Michigan | 26111 | 79 | 8 |
173652 | 173652 | 2020-05-24 | Midland | Michigan | 26111 | 79 | 8 |
170610 | 170610 | 2020-05-23 | Midland | Michigan | 26111 | 79 | 8 |
170616 | 170616 | 2020-05-23 | Newaygo | Michigan | 26123 | 79 | 0 |
167573 | 167573 | 2020-05-22 | Midland | Michigan | 26111 | 79 | 8 |
143455 | 143455 | 2020-05-14 | St. Joseph | Michigan | 26149 | 79 | 1 |
68491 | 68491 | 2020-04-18 | Bay | Michigan | 26017 | 79 | 2 |
57591 | 57591 | 2020-04-14 | Hillsdale | Michigan | 26059 | 79 | 9 |
49550 | 49550 | 2020-04-11 | Kalamazoo | Michigan | 26077 | 79 | 7 |
27097 | 27097 | 2020-04-02 | Monroe | Michigan | 26115 | 79 | 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);