ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 258 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090523 | 1090523 | 2021-03-05 | Schoolcraft | Michigan | 26153 | 258 | 5 |
1087278 | 1087278 | 2021-03-04 | Schoolcraft | Michigan | 26153 | 258 | 5 |
827624 | 827624 | 2020-12-14 | Montmorency | Michigan | 26119 | 258 | 5 |
817893 | 817893 | 2020-12-11 | Oscoda | Michigan | 26135 | 258 | 11 |
791866 | 791866 | 2020-12-03 | Alger | Michigan | 26003 | 258 | 2 |
645898 | 645898 | 2020-10-19 | Huron | Michigan | 26063 | 258 | 5 |
603732 | 603732 | 2020-10-06 | Iron | Michigan | 26071 | 258 | 10 |
529270 | 529270 | 2020-09-13 | Unknown | Michigan | 258 | 3 | |
526034 | 526034 | 2020-09-12 | Unknown | Michigan | 258 | 3 | |
496901 | 496901 | 2020-09-03 | Menominee | Michigan | 26109 | 258 | 0 |
406503 | 406503 | 2020-08-06 | Hillsdale | Michigan | 26059 | 258 | 25 |
367899 | 367899 | 2020-07-25 | Cass | Michigan | 26027 | 258 | 8 |
367919 | 367919 | 2020-07-25 | Ionia | Michigan | 26067 | 258 | 5 |
358345 | 358345 | 2020-07-22 | Tuscola | Michigan | 26157 | 258 | 27 |
244475 | 244475 | 2020-06-16 | Eaton | Michigan | 26045 | 258 | 7 |
241364 | 241364 | 2020-06-15 | Eaton | Michigan | 26045 | 258 | 7 |
204199 | 204199 | 2020-06-03 | Allegan | Michigan | 26005 | 258 | 6 |
201122 | 201122 | 2020-06-02 | Allegan | Michigan | 26005 | 258 | 6 |
128433 | 128433 | 2020-05-09 | Calhoun | Michigan | 26025 | 258 | 17 |
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);