ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 195 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2263250 | 2263250 | 2022-03-01 | Branch | Michigan | 26023 | 12048 | 195 |
2259999 | 2259999 | 2022-02-28 | Branch | Michigan | 26023 | 12048 | 195 |
2256755 | 2256755 | 2022-02-27 | Clinton | Michigan | 26037 | 20774 | 195 |
2253504 | 2253504 | 2022-02-26 | Clinton | Michigan | 26037 | 20774 | 195 |
2250253 | 2250253 | 2022-02-25 | Clinton | Michigan | 26037 | 20774 | 195 |
2247002 | 2247002 | 2022-02-24 | Clinton | Michigan | 26037 | 20690 | 195 |
2243751 | 2243751 | 2022-02-23 | Clinton | Michigan | 26037 | 20690 | 195 |
2172213 | 2172213 | 2022-02-01 | Grand Traverse | Michigan | 26055 | 15980 | 195 |
2168960 | 2168960 | 2022-01-31 | Grand Traverse | Michigan | 26055 | 15980 | 195 |
2165705 | 2165705 | 2022-01-30 | Grand Traverse | Michigan | 26055 | 15824 | 195 |
2162450 | 2162450 | 2022-01-29 | Grand Traverse | Michigan | 26055 | 15824 | 195 |
2159195 | 2159195 | 2022-01-28 | Grand Traverse | Michigan | 26055 | 15824 | 195 |
2155941 | 2155941 | 2022-01-27 | Grand Traverse | Michigan | 26055 | 15627 | 195 |
2152688 | 2152688 | 2022-01-26 | Grand Traverse | Michigan | 26055 | 15627 | 195 |
2126687 | 2126687 | 2022-01-18 | Midland | Michigan | 26111 | 15334 | 195 |
2123435 | 2123435 | 2022-01-17 | Midland | Michigan | 26111 | 15334 | 195 |
2120183 | 2120183 | 2022-01-16 | Midland | Michigan | 26111 | 15334 | 195 |
2116931 | 2116931 | 2022-01-15 | Midland | Michigan | 26111 | 15334 | 195 |
2113680 | 2113680 | 2022-01-14 | Midland | Michigan | 26111 | 15334 | 195 |
2035687 | 2035687 | 2021-12-21 | Van Buren | Michigan | 26159 | 12335 | 195 |
2032437 | 2032437 | 2021-12-20 | Van Buren | Michigan | 26159 | 12335 | 195 |
2029186 | 2029186 | 2021-12-19 | Van Buren | Michigan | 26159 | 12223 | 195 |
2025935 | 2025935 | 2021-12-18 | Van Buren | Michigan | 26159 | 12223 | 195 |
2022684 | 2022684 | 2021-12-17 | Van Buren | Michigan | 26159 | 12223 | 195 |
2019433 | 2019433 | 2021-12-16 | Van Buren | Michigan | 26159 | 12101 | 195 |
2016183 | 2016183 | 2021-12-15 | Van Buren | Michigan | 26159 | 12101 | 195 |
1876345 | 1876345 | 2021-11-02 | Allegan | Michigan | 26005 | 15038 | 195 |
1873096 | 1873096 | 2021-11-01 | Allegan | Michigan | 26005 | 15038 | 195 |
1860176 | 1860176 | 2021-10-28 | Tuscola | Michigan | 26157 | 7436 | 195 |
1856927 | 1856927 | 2021-10-27 | Tuscola | Michigan | 26157 | 7436 | 195 |
1808157 | 1808157 | 2021-10-12 | Lenawee | Michigan | 26091 | 13614 | 195 |
1804906 | 1804906 | 2021-10-11 | Lenawee | Michigan | 26091 | 13614 | 195 |
1801657 | 1801657 | 2021-10-10 | Lenawee | Michigan | 26091 | 13475 | 195 |
1798408 | 1798408 | 2021-10-09 | Lenawee | Michigan | 26091 | 13475 | 195 |
1795159 | 1795159 | 2021-10-08 | Lenawee | Michigan | 26091 | 13475 | 195 |
1791910 | 1791910 | 2021-10-07 | Lenawee | Michigan | 26091 | 13303 | 195 |
1788661 | 1788661 | 2021-10-06 | Lenawee | Michigan | 26091 | 13303 | 195 |
1619733 | 1619733 | 2021-08-15 | Livingston | Michigan | 26093 | 17404 | 195 |
1616485 | 1616485 | 2021-08-14 | Livingston | Michigan | 26093 | 17404 | 195 |
1613237 | 1613237 | 2021-08-13 | Livingston | Michigan | 26093 | 17404 | 195 |
1609988 | 1609988 | 2021-08-12 | Livingston | Michigan | 26093 | 17330 | 195 |
1606740 | 1606740 | 2021-08-11 | Livingston | Michigan | 26093 | 17330 | 195 |
1603491 | 1603491 | 2021-08-10 | Livingston | Michigan | 26093 | 17271 | 195 |
1600242 | 1600242 | 2021-08-09 | Livingston | Michigan | 26093 | 17271 | 195 |
1596994 | 1596994 | 2021-08-08 | Livingston | Michigan | 26093 | 17192 | 195 |
1593745 | 1593745 | 2021-08-07 | Livingston | Michigan | 26093 | 17192 | 195 |
1590496 | 1590496 | 2021-08-06 | Livingston | Michigan | 26093 | 17192 | 195 |
1587247 | 1587247 | 2021-08-05 | Livingston | Michigan | 26093 | 17102 | 195 |
1583996 | 1583996 | 2021-08-04 | Livingston | Michigan | 26093 | 17102 | 195 |
1580747 | 1580747 | 2021-08-03 | Livingston | Michigan | 26093 | 17102 | 195 |
1577498 | 1577498 | 2021-08-02 | Livingston | Michigan | 26093 | 17023 | 195 |
1574250 | 1574250 | 2021-08-01 | Livingston | Michigan | 26093 | 17023 | 195 |
1571002 | 1571002 | 2021-07-31 | Livingston | Michigan | 26093 | 17023 | 195 |
1567754 | 1567754 | 2021-07-30 | Livingston | Michigan | 26093 | 17023 | 195 |
1437894 | 1437894 | 2021-06-20 | Livingston | Michigan | 26093 | 16772 | 195 |
1434647 | 1434647 | 2021-06-19 | Livingston | Michigan | 26093 | 16772 | 195 |
1431400 | 1431400 | 2021-06-18 | Livingston | Michigan | 26093 | 16772 | 195 |
1428155 | 1428155 | 2021-06-17 | Livingston | Michigan | 26093 | 16771 | 195 |
1424910 | 1424910 | 2021-06-16 | Livingston | Michigan | 26093 | 16767 | 195 |
1421662 | 1421662 | 2021-06-15 | Livingston | Michigan | 26093 | 16763 | 195 |
1311272 | 1311272 | 2021-05-12 | Eaton | Michigan | 26045 | 9910 | 195 |
1308025 | 1308025 | 2021-05-11 | Eaton | Michigan | 26045 | 9880 | 195 |
1304779 | 1304779 | 2021-05-10 | Eaton | Michigan | 26045 | 9867 | 195 |
1032086 | 1032086 | 2021-02-15 | Monroe | Michigan | 26115 | 9516 | 195 |
1028839 | 1028839 | 2021-02-14 | Monroe | Michigan | 26115 | 9490 | 195 |
1025593 | 1025593 | 2021-02-13 | Monroe | Michigan | 26115 | 9490 | 195 |
895731 | 895731 | 2021-01-04 | Calhoun | Michigan | 26025 | 7920 | 195 |
869836 | 869836 | 2020-12-27 | Washtenaw | Michigan | 26161 | 13742 | 195 |
866591 | 866591 | 2020-12-26 | Washtenaw | Michigan | 26161 | 13742 | 195 |
746501 | 746501 | 2020-11-19 | Saginaw | Michigan | 26145 | 6995 | 195 |
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);