ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
256 rows where deaths = 42 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Gladwin 21
- Houghton 16
- Lapeer 15
- Mason 12
- Charlevoix 10
- Antrim 9
- Emmet 9
- Leelanau 9
- Menominee 9
- Oscoda 9
- Barry 8
- Cheboygan 8
- Calhoun 7
- Missaukee 7
- Roscommon 7
- Isabella 5
- Montmorency 5
- Otsego 5
- Wexford 5
- Alpena 4
- Cass 4
- Chippewa 4
- Gogebic 4
- Huron 4
- Ingham 4
- Ionia 4
- Berrien 3
- Clare 3
- Jackson 3
- Kalamazoo 3
- …
state 1
- Michigan · 256 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110417 | 2110417 | 2022-01-13 | Leelanau | Michigan | 26089 | 2834 | 42 |
2107166 | 2107166 | 2022-01-12 | Leelanau | Michigan | 26089 | 2834 | 42 |
2103915 | 2103915 | 2022-01-11 | Leelanau | Michigan | 26089 | 2749 | 42 |
2103930 | 2103930 | 2022-01-11 | Montmorency | Michigan | 26119 | 1401 | 42 |
2100664 | 2100664 | 2022-01-10 | Leelanau | Michigan | 26089 | 2749 | 42 |
2100679 | 2100679 | 2022-01-10 | Montmorency | Michigan | 26119 | 1401 | 42 |
2097413 | 2097413 | 2022-01-09 | Leelanau | Michigan | 26089 | 2685 | 42 |
2097428 | 2097428 | 2022-01-09 | Montmorency | Michigan | 26119 | 1389 | 42 |
2094161 | 2094161 | 2022-01-08 | Leelanau | Michigan | 26089 | 2685 | 42 |
2094176 | 2094176 | 2022-01-08 | Montmorency | Michigan | 26119 | 1389 | 42 |
2090909 | 2090909 | 2022-01-07 | Leelanau | Michigan | 26089 | 2685 | 42 |
2090924 | 2090924 | 2022-01-07 | Montmorency | Michigan | 26119 | 1389 | 42 |
2087658 | 2087658 | 2022-01-06 | Leelanau | Michigan | 26089 | 2622 | 42 |
2084406 | 2084406 | 2022-01-05 | Leelanau | Michigan | 26089 | 2622 | 42 |
1990135 | 1990135 | 2021-12-07 | Kalkaska | Michigan | 26079 | 2257 | 42 |
1990152 | 1990152 | 2021-12-07 | Missaukee | Michigan | 26113 | 2120 | 42 |
1986885 | 1986885 | 2021-12-06 | Kalkaska | Michigan | 26079 | 2257 | 42 |
1986902 | 1986902 | 2021-12-06 | Missaukee | Michigan | 26113 | 2120 | 42 |
1983652 | 1983652 | 2021-12-05 | Missaukee | Michigan | 26113 | 2110 | 42 |
1980402 | 1980402 | 2021-12-04 | Missaukee | Michigan | 26113 | 2110 | 42 |
1977152 | 1977152 | 2021-12-03 | Missaukee | Michigan | 26113 | 2110 | 42 |
1973902 | 1973902 | 2021-12-02 | Missaukee | Michigan | 26113 | 2102 | 42 |
1970653 | 1970653 | 2021-12-01 | Missaukee | Michigan | 26113 | 2102 | 42 |
1967351 | 1967351 | 2021-11-30 | Antrim | Michigan | 26009 | 2848 | 42 |
1967414 | 1967414 | 2021-11-30 | Oscoda | Michigan | 26135 | 1094 | 42 |
1964099 | 1964099 | 2021-11-29 | Antrim | Michigan | 26009 | 2816 | 42 |
1964162 | 1964162 | 2021-11-29 | Oscoda | Michigan | 26135 | 1094 | 42 |
1960848 | 1960848 | 2021-11-28 | Antrim | Michigan | 26009 | 2774 | 42 |
1960858 | 1960858 | 2021-11-28 | Charlevoix | Michigan | 26029 | 2977 | 42 |
1960911 | 1960911 | 2021-11-28 | Oscoda | Michigan | 26135 | 1087 | 42 |
1957597 | 1957597 | 2021-11-27 | Antrim | Michigan | 26009 | 2774 | 42 |
1957607 | 1957607 | 2021-11-27 | Charlevoix | Michigan | 26029 | 2977 | 42 |
1957660 | 1957660 | 2021-11-27 | Oscoda | Michigan | 26135 | 1087 | 42 |
1954346 | 1954346 | 2021-11-26 | Antrim | Michigan | 26009 | 2774 | 42 |
1954356 | 1954356 | 2021-11-26 | Charlevoix | Michigan | 26029 | 2977 | 42 |
1954409 | 1954409 | 2021-11-26 | Oscoda | Michigan | 26135 | 1087 | 42 |
1951095 | 1951095 | 2021-11-25 | Antrim | Michigan | 26009 | 2774 | 42 |
1951105 | 1951105 | 2021-11-25 | Charlevoix | Michigan | 26029 | 2977 | 42 |
1951158 | 1951158 | 2021-11-25 | Oscoda | Michigan | 26135 | 1087 | 42 |
1947844 | 1947844 | 2021-11-24 | Antrim | Michigan | 26009 | 2774 | 42 |
1947854 | 1947854 | 2021-11-24 | Charlevoix | Michigan | 26029 | 2977 | 42 |
1947907 | 1947907 | 2021-11-24 | Oscoda | Michigan | 26135 | 1087 | 42 |
1944593 | 1944593 | 2021-11-23 | Antrim | Michigan | 26009 | 2758 | 42 |
1944594 | 1944594 | 2021-11-23 | Arenac | Michigan | 26011 | 2040 | 42 |
1944603 | 1944603 | 2021-11-23 | Charlevoix | Michigan | 26029 | 2953 | 42 |
1944656 | 1944656 | 2021-11-23 | Oscoda | Michigan | 26135 | 1077 | 42 |
1941342 | 1941342 | 2021-11-22 | Antrim | Michigan | 26009 | 2745 | 42 |
1941343 | 1941343 | 2021-11-22 | Arenac | Michigan | 26011 | 2040 | 42 |
1941352 | 1941352 | 2021-11-22 | Charlevoix | Michigan | 26029 | 2933 | 42 |
1941405 | 1941405 | 2021-11-22 | Oscoda | Michigan | 26135 | 1077 | 42 |
1938102 | 1938102 | 2021-11-21 | Charlevoix | Michigan | 26029 | 2886 | 42 |
1934852 | 1934852 | 2021-11-20 | Charlevoix | Michigan | 26029 | 2886 | 42 |
1931602 | 1931602 | 2021-11-19 | Charlevoix | Michigan | 26029 | 2886 | 42 |
1928346 | 1928346 | 2021-11-18 | Benzie | Michigan | 26019 | 1912 | 42 |
1925096 | 1925096 | 2021-11-17 | Benzie | Michigan | 26019 | 1912 | 42 |
1921888 | 1921888 | 2021-11-16 | Manistee | Michigan | 26101 | 2692 | 42 |
1918638 | 1918638 | 2021-11-15 | Manistee | Michigan | 26101 | 2692 | 42 |
1860098 | 1860098 | 2021-10-28 | Alcona | Michigan | 26001 | 1138 | 42 |
1856849 | 1856849 | 2021-10-27 | Alcona | Michigan | 26001 | 1138 | 42 |
1762674 | 1762674 | 2021-09-28 | Mason | Michigan | 26105 | 2675 | 42 |
1759425 | 1759425 | 2021-09-27 | Mason | Michigan | 26105 | 2675 | 42 |
1756177 | 1756177 | 2021-09-26 | Mason | Michigan | 26105 | 2637 | 42 |
1752929 | 1752929 | 2021-09-25 | Mason | Michigan | 26105 | 2637 | 42 |
1749681 | 1749681 | 2021-09-24 | Mason | Michigan | 26105 | 2637 | 42 |
1746431 | 1746431 | 2021-09-23 | Mason | Michigan | 26105 | 2603 | 42 |
1743182 | 1743182 | 2021-09-22 | Mason | Michigan | 26105 | 2603 | 42 |
1739933 | 1739933 | 2021-09-21 | Mason | Michigan | 26105 | 2586 | 42 |
1736684 | 1736684 | 2021-09-20 | Mason | Michigan | 26105 | 2586 | 42 |
1733434 | 1733434 | 2021-09-19 | Mason | Michigan | 26105 | 2545 | 42 |
1730184 | 1730184 | 2021-09-18 | Mason | Michigan | 26105 | 2545 | 42 |
1726934 | 1726934 | 2021-09-17 | Mason | Michigan | 26105 | 2545 | 42 |
1694407 | 1694407 | 2021-09-07 | Baraga | Michigan | 26013 | 1076 | 42 |
1694469 | 1694469 | 2021-09-07 | Otsego | Michigan | 26137 | 2577 | 42 |
1691220 | 1691220 | 2021-09-06 | Otsego | Michigan | 26137 | 2577 | 42 |
1687970 | 1687970 | 2021-09-05 | Otsego | Michigan | 26137 | 2577 | 42 |
1684720 | 1684720 | 2021-09-04 | Otsego | Michigan | 26137 | 2577 | 42 |
1681469 | 1681469 | 2021-09-03 | Otsego | Michigan | 26137 | 2577 | 42 |
1402174 | 1402174 | 2021-06-09 | Houghton | Michigan | 26061 | 3135 | 42 |
1398929 | 1398929 | 2021-06-08 | Houghton | Michigan | 26061 | 3135 | 42 |
1395683 | 1395683 | 2021-06-07 | Houghton | Michigan | 26061 | 3135 | 42 |
1392437 | 1392437 | 2021-06-06 | Houghton | Michigan | 26061 | 3135 | 42 |
1389192 | 1389192 | 2021-06-05 | Houghton | Michigan | 26061 | 3135 | 42 |
1385947 | 1385947 | 2021-06-04 | Houghton | Michigan | 26061 | 3135 | 42 |
1382702 | 1382702 | 2021-06-03 | Houghton | Michigan | 26061 | 3134 | 42 |
1379449 | 1379449 | 2021-06-02 | Emmet | Michigan | 26047 | 2371 | 42 |
1379456 | 1379456 | 2021-06-02 | Houghton | Michigan | 26061 | 3131 | 42 |
1376204 | 1376204 | 2021-06-01 | Emmet | Michigan | 26047 | 2371 | 42 |
1376211 | 1376211 | 2021-06-01 | Houghton | Michigan | 26061 | 3129 | 42 |
1372958 | 1372958 | 2021-05-31 | Emmet | Michigan | 26047 | 2369 | 42 |
1372965 | 1372965 | 2021-05-31 | Houghton | Michigan | 26061 | 3127 | 42 |
1369713 | 1369713 | 2021-05-30 | Emmet | Michigan | 26047 | 2369 | 42 |
1369720 | 1369720 | 2021-05-30 | Houghton | Michigan | 26061 | 3127 | 42 |
1366467 | 1366467 | 2021-05-29 | Emmet | Michigan | 26047 | 2369 | 42 |
1366474 | 1366474 | 2021-05-29 | Houghton | Michigan | 26061 | 3127 | 42 |
1363221 | 1363221 | 2021-05-28 | Emmet | Michigan | 26047 | 2369 | 42 |
1363228 | 1363228 | 2021-05-28 | Houghton | Michigan | 26061 | 3126 | 42 |
1359974 | 1359974 | 2021-05-27 | Emmet | Michigan | 26047 | 2368 | 42 |
1359981 | 1359981 | 2021-05-27 | Houghton | Michigan | 26061 | 3125 | 42 |
1356728 | 1356728 | 2021-05-26 | Emmet | Michigan | 26047 | 2368 | 42 |
1356735 | 1356735 | 2021-05-26 | Houghton | Michigan | 26061 | 3124 | 42 |
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);