ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 1620 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
county 9
state 1
- Michigan · 18 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2133140 | 2133140 | 2022-01-20 | Alger | Michigan | 26003 | 1620 | 11 |
2129887 | 2129887 | 2022-01-19 | Alger | Michigan | 26003 | 1620 | 11 |
2019359 | 2019359 | 2021-12-16 | Baraga | Michigan | 26013 | 1620 | 48 |
2016109 | 2016109 | 2021-12-15 | Baraga | Michigan | 26013 | 1620 | 48 |
1938107 | 1938107 | 2021-11-21 | Crawford | Michigan | 26039 | 1620 | 17 |
1934857 | 1934857 | 2021-11-20 | Crawford | Michigan | 26039 | 1620 | 17 |
1931607 | 1931607 | 2021-11-19 | Crawford | Michigan | 26039 | 1620 | 17 |
1733438 | 1733438 | 2021-09-19 | Missaukee | Michigan | 26113 | 1620 | 29 |
1730188 | 1730188 | 2021-09-18 | Missaukee | Michigan | 26113 | 1620 | 29 |
1726938 | 1726938 | 2021-09-17 | Missaukee | Michigan | 26113 | 1620 | 29 |
1311264 | 1311264 | 2021-05-12 | Charlevoix | Michigan | 26029 | 1620 | 20 |
1308017 | 1308017 | 2021-05-11 | Charlevoix | Michigan | 26029 | 1620 | 20 |
1083976 | 1083976 | 2021-03-03 | Clare | Michigan | 26035 | 1620 | 69 |
863319 | 863319 | 2020-12-25 | Menominee | Michigan | 26109 | 1620 | 25 |
860074 | 860074 | 2020-12-24 | Menominee | Michigan | 26109 | 1620 | 25 |
856829 | 856829 | 2020-12-23 | Menominee | Michigan | 26109 | 1620 | 25 |
107912 | 107912 | 2020-05-02 | Genesee | Michigan | 26049 | 1620 | 196 |
22668 | 22668 | 2020-03-31 | Oakland | Michigan | 26125 | 1620 | 75 |
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);