ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 139 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
710796 | 710796 | 2020-11-08 | Missaukee | Michigan | 26113 | 139 | 1 |
707552 | 707552 | 2020-11-07 | Missaukee | Michigan | 26113 | 139 | 1 |
678345 | 678345 | 2020-10-29 | Kalkaska | Michigan | 26079 | 139 | 4 |
645886 | 645886 | 2020-10-19 | Crawford | Michigan | 26039 | 139 | 5 |
629661 | 629661 | 2020-10-14 | Gladwin | Michigan | 26051 | 139 | 2 |
603780 | 603780 | 2020-10-06 | Wexford | Michigan | 26165 | 139 | 4 |
551852 | 551852 | 2020-09-20 | Alpena | Michigan | 26007 | 139 | 14 |
548613 | 548613 | 2020-09-19 | Alpena | Michigan | 26007 | 139 | 14 |
538972 | 538972 | 2020-09-16 | Sanilac | Michigan | 26151 | 139 | 7 |
532450 | 532450 | 2020-09-14 | Emmet | Michigan | 26047 | 139 | 4 |
371164 | 371164 | 2020-07-26 | Otsego | Michigan | 26137 | 139 | 10 |
367954 | 367954 | 2020-07-25 | Otsego | Michigan | 26137 | 139 | 10 |
364747 | 364747 | 2020-07-24 | Otsego | Michigan | 26137 | 139 | 10 |
364758 | 364758 | 2020-07-24 | Unknown | Michigan | 139 | 2 | |
361540 | 361540 | 2020-07-23 | Otsego | Michigan | 26137 | 139 | 10 |
358335 | 358335 | 2020-07-22 | Otsego | Michigan | 26137 | 139 | 10 |
355091 | 355091 | 2020-07-21 | Grand Traverse | Michigan | 26055 | 139 | 5 |
355132 | 355132 | 2020-07-21 | Otsego | Michigan | 26137 | 139 | 10 |
329496 | 329496 | 2020-07-13 | Barry | Michigan | 26015 | 139 | 2 |
313628 | 313628 | 2020-07-08 | Isabella | Michigan | 26073 | 139 | 8 |
285161 | 285161 | 2020-06-29 | Cass | Michigan | 26027 | 139 | 5 |
260100 | 260100 | 2020-06-21 | Newaygo | Michigan | 26123 | 139 | 0 |
244531 | 244531 | 2020-06-16 | Unknown | Michigan | 139 | 2 | |
241420 | 241420 | 2020-06-15 | Unknown | Michigan | 139 | 2 | |
198124 | 198124 | 2020-06-01 | Unknown | Michigan | 139 | 3 | |
194995 | 194995 | 2020-05-31 | Clinton | Michigan | 26037 | 139 | 11 |
191927 | 191927 | 2020-05-30 | Clinton | Michigan | 26037 | 139 | 10 |
188863 | 188863 | 2020-05-29 | Clinton | Michigan | 26037 | 139 | 10 |
185805 | 185805 | 2020-05-28 | Clinton | Michigan | 26037 | 139 | 10 |
134477 | 134477 | 2020-05-11 | Tuscola | Michigan | 26157 | 139 | 17 |
36691 | 36691 | 2020-04-06 | Saginaw | Michigan | 26145 | 139 | 2 |
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);