ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where cases = 462 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
county 10
state 1
- Michigan · 15 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2149450 | 2149450 | 2022-01-25 | Keweenaw | Michigan | 26083 | 462 | 11 |
2146198 | 2146198 | 2022-01-24 | Keweenaw | Michigan | 26083 | 462 | 11 |
1317809 | 1317809 | 2021-05-14 | Ontonagon | Michigan | 26131 | 462 | 21 |
723731 | 723731 | 2020-11-12 | Clare | Michigan | 26035 | 462 | 19 |
688063 | 688063 | 2020-11-01 | Gogebic | Michigan | 26053 | 462 | 11 |
684819 | 684819 | 2020-10-31 | Gogebic | Michigan | 26053 | 462 | 11 |
649140 | 649140 | 2020-10-20 | Hillsdale | Michigan | 26059 | 462 | 27 |
496925 | 496925 | 2020-09-03 | Tuscola | Michigan | 26157 | 462 | 29 |
419377 | 419377 | 2020-08-10 | Eaton | Michigan | 26045 | 462 | 8 |
416156 | 416156 | 2020-08-09 | Eaton | Michigan | 26045 | 462 | 8 |
390455 | 390455 | 2020-08-01 | Oceana | Michigan | 26127 | 462 | 6 |
384020 | 384020 | 2020-07-30 | Oceana | Michigan | 26127 | 462 | 6 |
380803 | 380803 | 2020-07-29 | Oceana | Michigan | 26127 | 462 | 6 |
342269 | 342269 | 2020-07-17 | Bay | Michigan | 26017 | 462 | 31 |
216543 | 216543 | 2020-06-07 | Calhoun | Michigan | 26025 | 462 | 26 |
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);