ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 87 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 |
---|---|---|---|---|---|---|---|
723781 | 723781 | 2020-11-12 | Oscoda | Michigan | 26135 | 87 | 2 |
629640 | 629640 | 2020-10-14 | Antrim | Michigan | 26009 | 87 | 0 |
610198 | 610198 | 2020-10-08 | Chippewa | Michigan | 26033 | 87 | 0 |
606956 | 606956 | 2020-10-07 | Chippewa | Michigan | 26033 | 87 | 0 |
581047 | 581047 | 2020-09-29 | Kalkaska | Michigan | 26079 | 87 | 4 |
542206 | 542206 | 2020-09-17 | Roscommon | Michigan | 26143 | 87 | 4 |
538914 | 538914 | 2020-09-16 | Cheboygan | Michigan | 26031 | 87 | 2 |
538924 | 538924 | 2020-09-16 | Gladwin | Michigan | 26051 | 87 | 2 |
535733 | 535733 | 2020-09-15 | Roscommon | Michigan | 26143 | 87 | 4 |
532498 | 532498 | 2020-09-14 | Roscommon | Michigan | 26143 | 87 | 4 |
458147 | 458147 | 2020-08-22 | Wexford | Michigan | 26165 | 87 | 4 |
406494 | 406494 | 2020-08-06 | Delta | Michigan | 26041 | 87 | 3 |
371169 | 371169 | 2020-07-26 | Sanilac | Michigan | 26151 | 87 | 6 |
367959 | 367959 | 2020-07-25 | Sanilac | Michigan | 26151 | 87 | 6 |
323171 | 323171 | 2020-07-11 | Marquette | Michigan | 26103 | 87 | 11 |
275765 | 275765 | 2020-06-26 | Montcalm | Michigan | 26117 | 87 | 1 |
222725 | 222725 | 2020-06-09 | Barry | Michigan | 26015 | 87 | 2 |
219630 | 219630 | 2020-06-08 | Barry | Michigan | 26015 | 87 | 2 |
216538 | 216538 | 2020-06-07 | Barry | Michigan | 26015 | 87 | 2 |
155485 | 155485 | 2020-05-18 | St. Joseph | Michigan | 26149 | 87 | 1 |
137395 | 137395 | 2020-05-12 | Alpena | Michigan | 26007 | 87 | 8 |
134405 | 134405 | 2020-05-11 | Alpena | Michigan | 26007 | 87 | 8 |
131414 | 131414 | 2020-05-10 | Alpena | Michigan | 26007 | 87 | 8 |
128424 | 128424 | 2020-05-09 | Alpena | Michigan | 26007 | 87 | 8 |
93696 | 93696 | 2020-04-27 | Otsego | Michigan | 26137 | 87 | 8 |
90875 | 90875 | 2020-04-26 | Otsego | Michigan | 26137 | 87 | 8 |
79628 | 79628 | 2020-04-22 | Lenawee | Michigan | 26091 | 87 | 0 |
65754 | 65754 | 2020-04-17 | Eaton | Michigan | 26045 | 87 | 5 |
46910 | 46910 | 2020-04-10 | Lapeer | Michigan | 26087 | 87 | 6 |
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);