ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 173 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1308044 | 1308044 | 2021-05-11 | Keweenaw | Michigan | 26083 | 173 | 2 |
1304798 | 1304798 | 2021-05-10 | Keweenaw | Michigan | 26083 | 173 | 2 |
1301552 | 1301552 | 2021-05-09 | Keweenaw | Michigan | 26083 | 173 | 2 |
1298304 | 1298304 | 2021-05-08 | Keweenaw | Michigan | 26083 | 173 | 2 |
1295058 | 1295058 | 2021-05-07 | Keweenaw | Michigan | 26083 | 173 | 2 |
1291812 | 1291812 | 2021-05-06 | Keweenaw | Michigan | 26083 | 173 | 2 |
1288566 | 1288566 | 2021-05-05 | Keweenaw | Michigan | 26083 | 173 | 2 |
1285320 | 1285320 | 2021-05-04 | Keweenaw | Michigan | 26083 | 173 | 2 |
1282074 | 1282074 | 2021-05-03 | Keweenaw | Michigan | 26083 | 173 | 2 |
1278827 | 1278827 | 2021-05-02 | Keweenaw | Michigan | 26083 | 173 | 2 |
1275580 | 1275580 | 2021-05-01 | Keweenaw | Michigan | 26083 | 173 | 2 |
1269086 | 1269086 | 2021-04-29 | Keweenaw | Michigan | 26083 | 173 | 2 |
778959 | 778959 | 2020-11-29 | Schoolcraft | Michigan | 26153 | 173 | 2 |
775714 | 775714 | 2020-11-28 | Schoolcraft | Michigan | 26153 | 173 | 2 |
723770 | 723770 | 2020-11-12 | Missaukee | Michigan | 26113 | 173 | 1 |
720472 | 720472 | 2020-11-11 | Alger | Michigan | 26003 | 173 | 1 |
701017 | 701017 | 2020-11-05 | Baraga | Michigan | 26013 | 173 | 4 |
697811 | 697811 | 2020-11-04 | Leelanau | Michigan | 26089 | 173 | 2 |
600478 | 600478 | 2020-10-05 | Emmet | Michigan | 26047 | 173 | 4 |
538967 | 538967 | 2020-09-16 | Otsego | Michigan | 26137 | 173 | 11 |
438732 | 438732 | 2020-08-16 | Huron | Michigan | 26063 | 173 | 4 |
422628 | 422628 | 2020-08-11 | Marquette | Michigan | 26103 | 173 | 11 |
406481 | 406481 | 2020-08-06 | Barry | Michigan | 26015 | 173 | 2 |
313647 | 313647 | 2020-07-08 | Midland | Michigan | 26111 | 173 | 9 |
256976 | 256976 | 2020-06-20 | Oceana | Michigan | 26127 | 173 | 3 |
201197 | 201197 | 2020-06-02 | Unknown | Michigan | 173 | 5 | |
167542 | 167542 | 2020-05-22 | Eaton | Michigan | 26045 | 173 | 6 |
158504 | 158504 | 2020-05-19 | Tuscola | Michigan | 26157 | 173 | 21 |
146383 | 146383 | 2020-05-15 | Allegan | Michigan | 26005 | 173 | 2 |
99384 | 99384 | 2020-04-29 | Shiawassee | Michigan | 26155 | 173 | 8 |
96538 | 96538 | 2020-04-28 | Shiawassee | Michigan | 26155 | 173 | 8 |
88060 | 88060 | 2020-04-25 | Ottawa | Michigan | 26139 | 173 | 8 |
79643 | 79643 | 2020-04-22 | Muskegon | Michigan | 26121 | 173 | 11 |
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);