ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where deaths = 304 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
state 1
- Michigan · 24 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217770 | 2217770 | 2022-02-15 | Lenawee | Michigan | 26091 | 25440 | 304 |
2214519 | 2214519 | 2022-02-14 | Lenawee | Michigan | 26091 | 25440 | 304 |
2211267 | 2211267 | 2022-02-13 | Lenawee | Michigan | 26091 | 25386 | 304 |
2208014 | 2208014 | 2022-02-12 | Lenawee | Michigan | 26091 | 25386 | 304 |
2204761 | 2204761 | 2022-02-11 | Lenawee | Michigan | 26091 | 25386 | 304 |
2155916 | 2155916 | 2022-01-27 | Allegan | Michigan | 26005 | 24955 | 304 |
2152663 | 2152663 | 2022-01-26 | Allegan | Michigan | 26005 | 24955 | 304 |
1990142 | 1990142 | 2021-12-07 | Livingston | Michigan | 26093 | 29922 | 304 |
1986892 | 1986892 | 2021-12-06 | Livingston | Michigan | 26093 | 29922 | 304 |
1655428 | 1655428 | 2021-08-26 | Berrien | Michigan | 26021 | 16413 | 304 |
1652181 | 1652181 | 2021-08-25 | Berrien | Michigan | 26021 | 16332 | 304 |
1648933 | 1648933 | 2021-08-24 | Berrien | Michigan | 26021 | 16332 | 304 |
1402225 | 1402225 | 2021-06-09 | Washtenaw | Michigan | 26161 | 27063 | 304 |
1398980 | 1398980 | 2021-06-08 | Washtenaw | Michigan | 26161 | 27062 | 304 |
1395734 | 1395734 | 2021-06-07 | Washtenaw | Michigan | 26161 | 27055 | 304 |
1379438 | 1379438 | 2021-06-02 | Calhoun | Michigan | 26025 | 14432 | 304 |
1376193 | 1376193 | 2021-06-01 | Calhoun | Michigan | 26025 | 14419 | 304 |
1340507 | 1340507 | 2021-05-21 | Jackson | Michigan | 26075 | 20830 | 304 |
970397 | 970397 | 2021-01-27 | Kalamazoo | Michigan | 26077 | 14109 | 304 |
970419 | 970419 | 2021-01-27 | Muskegon | Michigan | 26121 | 12314 | 304 |
967152 | 967152 | 2021-01-26 | Kalamazoo | Michigan | 26077 | 13986 | 304 |
967174 | 967174 | 2021-01-26 | Muskegon | Michigan | 26121 | 12306 | 304 |
963908 | 963908 | 2021-01-25 | Kalamazoo | Michigan | 26077 | 13939 | 304 |
924994 | 924994 | 2021-01-13 | Ottawa | Michigan | 26139 | 19926 | 304 |
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);