ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where cases = 453 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Michigan · 16 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1288590 | 1288590 | 2021-05-05 | Ontonagon | Michigan | 26131 | 453 | 21 |
1285344 | 1285344 | 2021-05-04 | Ontonagon | Michigan | 26131 | 453 | 21 |
1269110 | 1269110 | 2021-04-29 | Ontonagon | Michigan | 26131 | 453 | 21 |
1265863 | 1265863 | 2021-04-28 | Ontonagon | Michigan | 26131 | 453 | 21 |
1132702 | 1132702 | 2021-03-18 | Mackinac | Michigan | 26097 | 453 | 3 |
1129454 | 1129454 | 2021-03-17 | Mackinac | Michigan | 26097 | 453 | 3 |
1126207 | 1126207 | 2021-03-16 | Mackinac | Michigan | 26097 | 453 | 3 |
898965 | 898965 | 2021-01-05 | Alger | Michigan | 26003 | 453 | 2 |
895720 | 895720 | 2021-01-04 | Alger | Michigan | 26003 | 453 | 2 |
801650 | 801650 | 2020-12-06 | Manistee | Michigan | 26101 | 453 | 8 |
798405 | 798405 | 2020-12-05 | Manistee | Michigan | 26101 | 453 | 8 |
769165 | 769165 | 2020-11-26 | Cheboygan | Michigan | 26031 | 453 | 17 |
765919 | 765919 | 2020-11-25 | Cheboygan | Michigan | 26031 | 453 | 17 |
603748 | 603748 | 2020-10-06 | Marquette | Michigan | 26103 | 453 | 12 |
355141 | 355141 | 2020-07-21 | St. Joseph | Michigan | 26149 | 453 | 6 |
68519 | 68519 | 2020-04-18 | Jackson | Michigan | 26075 | 453 | 15 |
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);