ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 152 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2230746 | 2230746 | 2022-02-19 | Clare | Michigan | 26035 | 6607 | 152 |
2227495 | 2227495 | 2022-02-18 | Clare | Michigan | 26035 | 6607 | 152 |
2224244 | 2224244 | 2022-02-17 | Clare | Michigan | 26035 | 6607 | 152 |
2220993 | 2220993 | 2022-02-16 | Clare | Michigan | 26035 | 6607 | 152 |
2194962 | 2194962 | 2022-02-08 | Barry | Michigan | 26015 | 13857 | 152 |
2191708 | 2191708 | 2022-02-07 | Barry | Michigan | 26015 | 13857 | 152 |
2110406 | 2110406 | 2022-01-13 | Ionia | Michigan | 26067 | 16146 | 152 |
2107155 | 2107155 | 2022-01-12 | Ionia | Michigan | 26067 | 16146 | 152 |
2035684 | 2035684 | 2021-12-21 | St. Joseph | Michigan | 26149 | 10650 | 152 |
2032434 | 2032434 | 2021-12-20 | St. Joseph | Michigan | 26149 | 10650 | 152 |
2029183 | 2029183 | 2021-12-19 | St. Joseph | Michigan | 26149 | 10601 | 152 |
2025932 | 2025932 | 2021-12-18 | St. Joseph | Michigan | 26149 | 10601 | 152 |
2022681 | 2022681 | 2021-12-17 | St. Joseph | Michigan | 26149 | 10601 | 152 |
2006378 | 2006378 | 2021-12-12 | Gratiot | Michigan | 26057 | 10258 | 152 |
2003127 | 2003127 | 2021-12-11 | Gratiot | Michigan | 26057 | 10258 | 152 |
1999877 | 1999877 | 2021-12-10 | Gratiot | Michigan | 26057 | 10258 | 152 |
1996609 | 1996609 | 2021-12-09 | Branch | Michigan | 26023 | 8889 | 152 |
1993358 | 1993358 | 2021-12-08 | Branch | Michigan | 26023 | 8889 | 152 |
1778949 | 1778949 | 2021-10-03 | Van Buren | Michigan | 26159 | 8443 | 152 |
1775699 | 1775699 | 2021-10-02 | Van Buren | Michigan | 26159 | 8443 | 152 |
1772449 | 1772449 | 2021-10-01 | Van Buren | Michigan | 26159 | 8443 | 152 |
1398901 | 1398901 | 2021-06-08 | Allegan | Michigan | 26005 | 11134 | 152 |
1249608 | 1249608 | 2021-04-23 | Lenawee | Michigan | 26091 | 10054 | 152 |
1226910 | 1226910 | 2021-04-16 | Tuscola | Michigan | 26157 | 4960 | 152 |
1200892 | 1200892 | 2021-04-08 | Lapeer | Michigan | 26087 | 7708 | 152 |
1197643 | 1197643 | 2021-04-07 | Lapeer | Michigan | 26087 | 7609 | 152 |
1135946 | 1135946 | 2021-03-19 | Livingston | Michigan | 26093 | 11225 | 152 |
1132700 | 1132700 | 2021-03-18 | Livingston | Michigan | 26093 | 11168 | 152 |
1129452 | 1129452 | 2021-03-17 | Livingston | Michigan | 26093 | 11081 | 152 |
1064507 | 1064507 | 2021-02-25 | Eaton | Michigan | 26045 | 6245 | 152 |
834095 | 834095 | 2020-12-16 | Jackson | Michigan | 26075 | 9561 | 152 |
827577 | 827577 | 2020-12-14 | Calhoun | Michigan | 26025 | 7104 | 152 |
804926 | 804926 | 2020-12-07 | Washtenaw | Michigan | 26161 | 11629 | 152 |
665407 | 665407 | 2020-10-25 | Saginaw | Michigan | 26145 | 3689 | 152 |
662162 | 662162 | 2020-10-24 | Saginaw | Michigan | 26145 | 3689 | 152 |
658918 | 658918 | 2020-10-23 | Saginaw | Michigan | 26145 | 3621 | 152 |
655673 | 655673 | 2020-10-22 | Saginaw | Michigan | 26145 | 3572 | 152 |
374348 | 374348 | 2020-07-27 | Kent | Michigan | 26081 | 6829 | 152 |
371136 | 371136 | 2020-07-26 | Kent | Michigan | 26081 | 6787 | 152 |
367926 | 367926 | 2020-07-25 | Kent | Michigan | 26081 | 6654 | 152 |
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);