ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where deaths = 149 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2230749 | 2230749 | 2022-02-19 | Delta | Michigan | 26041 | 9805 | 149 |
2227498 | 2227498 | 2022-02-18 | Delta | Michigan | 26041 | 9805 | 149 |
2224247 | 2224247 | 2022-02-17 | Delta | Michigan | 26041 | 9805 | 149 |
2220996 | 2220996 | 2022-02-16 | Delta | Michigan | 26041 | 9805 | 149 |
2211242 | 2211242 | 2022-02-13 | Delta | Michigan | 26041 | 9745 | 149 |
2207989 | 2207989 | 2022-02-12 | Delta | Michigan | 26041 | 9745 | 149 |
2204736 | 2204736 | 2022-02-11 | Delta | Michigan | 26041 | 9745 | 149 |
2201524 | 2201524 | 2022-02-10 | Newaygo | Michigan | 26123 | 11133 | 149 |
2198270 | 2198270 | 2022-02-09 | Newaygo | Michigan | 26123 | 11133 | 149 |
2194972 | 2194972 | 2022-02-08 | Clare | Michigan | 26035 | 6491 | 149 |
2191718 | 2191718 | 2022-02-07 | Clare | Michigan | 26035 | 6491 | 149 |
2188465 | 2188465 | 2022-02-06 | Clare | Michigan | 26035 | 6454 | 149 |
2185212 | 2185212 | 2022-02-05 | Clare | Michigan | 26035 | 6454 | 149 |
2181960 | 2181960 | 2022-02-04 | Clare | Michigan | 26035 | 6454 | 149 |
2006386 | 2006386 | 2021-12-12 | Isabella | Michigan | 26073 | 10763 | 149 |
2003135 | 2003135 | 2021-12-11 | Isabella | Michigan | 26073 | 10763 | 149 |
1999885 | 1999885 | 2021-12-10 | Isabella | Michigan | 26073 | 10763 | 149 |
1960902 | 1960902 | 2021-11-28 | Montcalm | Michigan | 26117 | 12325 | 149 |
1957651 | 1957651 | 2021-11-27 | Montcalm | Michigan | 26117 | 12325 | 149 |
1954400 | 1954400 | 2021-11-26 | Montcalm | Michigan | 26117 | 12325 | 149 |
1951149 | 1951149 | 2021-11-25 | Montcalm | Michigan | 26117 | 12325 | 149 |
1947898 | 1947898 | 2021-11-24 | Montcalm | Michigan | 26117 | 12325 | 149 |
1915393 | 1915393 | 2021-11-14 | Midland | Michigan | 26111 | 11092 | 149 |
1912143 | 1912143 | 2021-11-13 | Midland | Michigan | 26111 | 11092 | 149 |
1908893 | 1908893 | 2021-11-12 | Midland | Michigan | 26111 | 11092 | 149 |
1762702 | 1762702 | 2021-09-28 | Van Buren | Michigan | 26159 | 8292 | 149 |
1759453 | 1759453 | 2021-09-27 | Van Buren | Michigan | 26159 | 8292 | 149 |
1372937 | 1372937 | 2021-05-31 | Allegan | Michigan | 26005 | 11079 | 149 |
1369692 | 1369692 | 2021-05-30 | Allegan | Michigan | 26005 | 11079 | 149 |
1366446 | 1366446 | 2021-05-29 | Allegan | Michigan | 26005 | 11079 | 149 |
1220415 | 1220415 | 2021-04-14 | Tuscola | Michigan | 26157 | 4815 | 149 |
1217167 | 1217167 | 2021-04-13 | Tuscola | Michigan | 26157 | 4769 | 149 |
1194394 | 1194394 | 2021-04-06 | Lapeer | Michigan | 26087 | 7508 | 149 |
1109973 | 1109973 | 2021-03-11 | Livingston | Michigan | 26093 | 10801 | 149 |
1106727 | 1106727 | 2021-03-10 | Livingston | Michigan | 26093 | 10734 | 149 |
1103481 | 1103481 | 2021-03-09 | Livingston | Michigan | 26093 | 10681 | 149 |
1100235 | 1100235 | 2021-03-08 | Livingston | Michigan | 26093 | 10658 | 149 |
1096988 | 1096988 | 2021-03-07 | Livingston | Michigan | 26093 | 10586 | 149 |
1093741 | 1093741 | 2021-03-06 | Livingston | Michigan | 26093 | 10586 | 149 |
886037 | 886037 | 2021-01-01 | Monroe | Michigan | 26115 | 7595 | 149 |
882792 | 882792 | 2020-12-31 | Monroe | Michigan | 26115 | 7595 | 149 |
879547 | 879547 | 2020-12-30 | Monroe | Michigan | 26115 | 7595 | 149 |
824328 | 824328 | 2020-12-13 | Berrien | Michigan | 26021 | 8358 | 149 |
821082 | 821082 | 2020-12-12 | Berrien | Michigan | 26021 | 8288 | 149 |
791946 | 791946 | 2020-12-03 | Washtenaw | Michigan | 26161 | 11198 | 149 |
743220 | 743220 | 2020-11-18 | Kalamazoo | Michigan | 26077 | 7725 | 149 |
649183 | 649183 | 2020-10-20 | Saginaw | Michigan | 26145 | 3479 | 149 |
645939 | 645939 | 2020-10-19 | Saginaw | Michigan | 26145 | 3454 | 149 |
355104 | 355104 | 2020-07-21 | Kent | Michigan | 26081 | 6430 | 149 |
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);