ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 91 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
733512 | 733512 | 2020-11-15 | Oscoda | Michigan | 26135 | 91 | 2 |
730267 | 730267 | 2020-11-14 | Oscoda | Michigan | 26135 | 91 | 2 |
701053 | 701053 | 2020-11-05 | Lake | Michigan | 26085 | 91 | 1 |
671877 | 671877 | 2020-10-27 | Missaukee | Michigan | 26113 | 91 | 1 |
665340 | 665340 | 2020-10-25 | Arenac | Michigan | 26011 | 91 | 3 |
665400 | 665400 | 2020-10-25 | Ontonagon | Michigan | 26131 | 91 | 0 |
662095 | 662095 | 2020-10-24 | Arenac | Michigan | 26011 | 91 | 3 |
662155 | 662155 | 2020-10-24 | Ontonagon | Michigan | 26131 | 91 | 0 |
642624 | 642624 | 2020-10-18 | Antrim | Michigan | 26009 | 91 | 0 |
639377 | 639377 | 2020-10-17 | Antrim | Michigan | 26009 | 91 | 0 |
636131 | 636131 | 2020-10-16 | Antrim | Michigan | 26009 | 91 | 0 |
623166 | 623166 | 2020-10-12 | Chippewa | Michigan | 26033 | 91 | 0 |
619916 | 619916 | 2020-10-11 | Benzie | Michigan | 26019 | 91 | 2 |
616674 | 616674 | 2020-10-10 | Benzie | Michigan | 26019 | 91 | 2 |
587528 | 587528 | 2020-10-01 | Kalkaska | Michigan | 26079 | 91 | 4 |
574541 | 574541 | 2020-09-27 | Cheboygan | Michigan | 26031 | 91 | 2 |
571298 | 571298 | 2020-09-26 | Cheboygan | Michigan | 26031 | 91 | 2 |
561586 | 561586 | 2020-09-23 | Gladwin | Michigan | 26051 | 91 | 2 |
558349 | 558349 | 2020-09-22 | Gladwin | Michigan | 26051 | 91 | 2 |
555112 | 555112 | 2020-09-21 | Gladwin | Michigan | 26051 | 91 | 2 |
555122 | 555122 | 2020-09-21 | Iron | Michigan | 26071 | 91 | 1 |
555153 | 555153 | 2020-09-21 | Osceola | Michigan | 26133 | 91 | 0 |
555158 | 555158 | 2020-09-21 | Roscommon | Michigan | 26143 | 91 | 4 |
551874 | 551874 | 2020-09-20 | Gladwin | Michigan | 26051 | 91 | 2 |
548635 | 548635 | 2020-09-19 | Gladwin | Michigan | 26051 | 91 | 2 |
487191 | 487191 | 2020-08-31 | Leelanau | Michigan | 26089 | 91 | 1 |
390446 | 390446 | 2020-08-01 | Menominee | Michigan | 26109 | 91 | 0 |
390465 | 390465 | 2020-08-01 | Sanilac | Michigan | 26151 | 91 | 6 |
244460 | 244460 | 2020-06-16 | Barry | Michigan | 26015 | 91 | 2 |
241349 | 241349 | 2020-06-15 | Barry | Michigan | 26015 | 91 | 2 |
238240 | 238240 | 2020-06-14 | Barry | Michigan | 26015 | 91 | 2 |
235133 | 235133 | 2020-06-13 | Barry | Michigan | 26015 | 91 | 2 |
232028 | 232028 | 2020-06-12 | Barry | Michigan | 26015 | 91 | 2 |
176701 | 176701 | 2020-05-25 | Newaygo | Michigan | 26123 | 91 | 0 |
161458 | 161458 | 2020-05-20 | Alpena | Michigan | 26007 | 91 | 9 |
158432 | 158432 | 2020-05-19 | Alpena | Michigan | 26007 | 91 | 9 |
155414 | 155414 | 2020-05-18 | Alpena | Michigan | 26007 | 91 | 9 |
152400 | 152400 | 2020-05-17 | Alpena | Michigan | 26007 | 91 | 9 |
149389 | 149389 | 2020-05-16 | Alpena | Michigan | 26007 | 91 | 9 |
68555 | 68555 | 2020-04-18 | Shiawassee | Michigan | 26155 | 91 | 2 |
65808 | 65808 | 2020-04-17 | Unknown | Michigan | 91 | 10 | |
54901 | 54901 | 2020-04-13 | Kalamazoo | Michigan | 26077 | 91 | 7 |
52201 | 52201 | 2020-04-12 | Clinton | Michigan | 26037 | 91 | 3 |
22646 | 22646 | 2020-03-31 | Ingham | Michigan | 26065 | 91 | 0 |
14773 | 14773 | 2020-03-27 | Genesee | Michigan | 26049 | 91 | 4 |
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);