ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 377 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 11
state 1
- Michigan · 17 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1119708 | 1119708 | 2021-03-14 | Lake | Michigan | 26085 | 377 | 11 |
1116461 | 1116461 | 2021-03-13 | Lake | Michigan | 26085 | 377 | 11 |
1113215 | 1113215 | 2021-03-12 | Lake | Michigan | 26085 | 377 | 11 |
876293 | 876293 | 2020-12-29 | Mackinac | Michigan | 26097 | 377 | 2 |
785414 | 785414 | 2020-12-01 | Kalkaska | Michigan | 26079 | 377 | 5 |
782175 | 782175 | 2020-11-30 | Leelanau | Michigan | 26089 | 377 | 3 |
769155 | 769155 | 2020-11-26 | Arenac | Michigan | 26011 | 377 | 12 |
765909 | 765909 | 2020-11-25 | Arenac | Michigan | 26011 | 377 | 12 |
710774 | 710774 | 2020-11-08 | Iosco | Michigan | 26069 | 377 | 17 |
707530 | 707530 | 2020-11-07 | Iosco | Michigan | 26069 | 377 | 17 |
606947 | 606947 | 2020-10-07 | Barry | Michigan | 26015 | 377 | 4 |
577818 | 577818 | 2020-09-28 | Marquette | Michigan | 26103 | 377 | 12 |
568061 | 568061 | 2020-09-25 | Delta | Michigan | 26041 | 377 | 7 |
432328 | 432328 | 2020-08-14 | Tuscola | Michigan | 26157 | 377 | 29 |
244461 | 244461 | 2020-06-16 | Bay | Michigan | 26017 | 377 | 29 |
238241 | 238241 | 2020-06-14 | Bay | Michigan | 26017 | 377 | 29 |
213451 | 213451 | 2020-06-06 | Bay | Michigan | 26017 | 377 | 27 |
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);