ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
889 rows where deaths = 6 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Luce 230
- Oceana 105
- Sanilac 81
- Allegan 68
- Alger 45
- Eaton 39
- Crawford 22
- Schoolcraft 19
- Van Buren 18
- Roscommon 17
- Lake 16
- Cass 12
- Barry 11
- Clare 11
- St. Joseph 11
- Grand Traverse 9
- Lenawee 9
- Mackinac 9
- Antrim 8
- Leelanau 8
- Marquette 7
- Unknown 7
- Wexford 7
- Ingham 6
- Mecosta 6
- Keweenaw 5
- Menominee 5
- Montcalm 5
- Ogemaw 5
- Alcona 4
- …
state 1
- Michigan · 889 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2126679 | 2126679 | 2022-01-18 | Luce | Michigan | 26095 | 2007 | 6 |
2123427 | 2123427 | 2022-01-17 | Luce | Michigan | 26095 | 2007 | 6 |
2120175 | 2120175 | 2022-01-16 | Luce | Michigan | 26095 | 2007 | 6 |
2116923 | 2116923 | 2022-01-15 | Luce | Michigan | 26095 | 2007 | 6 |
2113672 | 2113672 | 2022-01-14 | Luce | Michigan | 26095 | 2007 | 6 |
2110420 | 2110420 | 2022-01-13 | Luce | Michigan | 26095 | 1990 | 6 |
2107169 | 2107169 | 2022-01-12 | Luce | Michigan | 26095 | 1990 | 6 |
2103918 | 2103918 | 2022-01-11 | Luce | Michigan | 26095 | 1975 | 6 |
2100667 | 2100667 | 2022-01-10 | Luce | Michigan | 26095 | 1975 | 6 |
2097416 | 2097416 | 2022-01-09 | Luce | Michigan | 26095 | 1950 | 6 |
2094164 | 2094164 | 2022-01-08 | Luce | Michigan | 26095 | 1950 | 6 |
2090912 | 2090912 | 2022-01-07 | Luce | Michigan | 26095 | 1950 | 6 |
2087661 | 2087661 | 2022-01-06 | Luce | Michigan | 26095 | 1938 | 6 |
2084409 | 2084409 | 2022-01-05 | Luce | Michigan | 26095 | 1938 | 6 |
2081157 | 2081157 | 2022-01-04 | Luce | Michigan | 26095 | 1916 | 6 |
2077905 | 2077905 | 2022-01-03 | Luce | Michigan | 26095 | 1916 | 6 |
2074654 | 2074654 | 2022-01-02 | Luce | Michigan | 26095 | 1898 | 6 |
2071403 | 2071403 | 2022-01-01 | Luce | Michigan | 26095 | 1898 | 6 |
2068152 | 2068152 | 2021-12-31 | Luce | Michigan | 26095 | 1898 | 6 |
2064901 | 2064901 | 2021-12-30 | Luce | Michigan | 26095 | 1898 | 6 |
2061651 | 2061651 | 2021-12-29 | Luce | Michigan | 26095 | 1898 | 6 |
2058402 | 2058402 | 2021-12-28 | Luce | Michigan | 26095 | 1881 | 6 |
2055153 | 2055153 | 2021-12-27 | Luce | Michigan | 26095 | 1881 | 6 |
2051903 | 2051903 | 2021-12-26 | Luce | Michigan | 26095 | 1860 | 6 |
2048653 | 2048653 | 2021-12-25 | Luce | Michigan | 26095 | 1860 | 6 |
2045403 | 2045403 | 2021-12-24 | Luce | Michigan | 26095 | 1860 | 6 |
2042153 | 2042153 | 2021-12-23 | Luce | Michigan | 26095 | 1860 | 6 |
2038904 | 2038904 | 2021-12-22 | Luce | Michigan | 26095 | 1860 | 6 |
2035654 | 2035654 | 2021-12-21 | Luce | Michigan | 26095 | 1847 | 6 |
2032404 | 2032404 | 2021-12-20 | Luce | Michigan | 26095 | 1847 | 6 |
2029153 | 2029153 | 2021-12-19 | Luce | Michigan | 26095 | 1840 | 6 |
2025902 | 2025902 | 2021-12-18 | Luce | Michigan | 26095 | 1840 | 6 |
2022651 | 2022651 | 2021-12-17 | Luce | Michigan | 26095 | 1840 | 6 |
2019400 | 2019400 | 2021-12-16 | Luce | Michigan | 26095 | 1828 | 6 |
2016150 | 2016150 | 2021-12-15 | Luce | Michigan | 26095 | 1828 | 6 |
2012899 | 2012899 | 2021-12-14 | Luce | Michigan | 26095 | 1817 | 6 |
2009648 | 2009648 | 2021-12-13 | Luce | Michigan | 26095 | 1817 | 6 |
2006397 | 2006397 | 2021-12-12 | Luce | Michigan | 26095 | 1797 | 6 |
2003146 | 2003146 | 2021-12-11 | Luce | Michigan | 26095 | 1797 | 6 |
1999896 | 1999896 | 2021-12-10 | Luce | Michigan | 26095 | 1797 | 6 |
1996645 | 1996645 | 2021-12-09 | Luce | Michigan | 26095 | 1787 | 6 |
1993394 | 1993394 | 2021-12-08 | Luce | Michigan | 26095 | 1787 | 6 |
1990143 | 1990143 | 2021-12-07 | Luce | Michigan | 26095 | 1771 | 6 |
1986893 | 1986893 | 2021-12-06 | Luce | Michigan | 26095 | 1771 | 6 |
1983643 | 1983643 | 2021-12-05 | Luce | Michigan | 26095 | 1750 | 6 |
1980393 | 1980393 | 2021-12-04 | Luce | Michigan | 26095 | 1750 | 6 |
1977143 | 1977143 | 2021-12-03 | Luce | Michigan | 26095 | 1750 | 6 |
1973893 | 1973893 | 2021-12-02 | Luce | Michigan | 26095 | 1731 | 6 |
1970644 | 1970644 | 2021-12-01 | Luce | Michigan | 26095 | 1731 | 6 |
1967394 | 1967394 | 2021-11-30 | Luce | Michigan | 26095 | 1715 | 6 |
1967421 | 1967421 | 2021-11-30 | Schoolcraft | Michigan | 26153 | 992 | 6 |
1964142 | 1964142 | 2021-11-29 | Luce | Michigan | 26095 | 1715 | 6 |
1964169 | 1964169 | 2021-11-29 | Schoolcraft | Michigan | 26153 | 992 | 6 |
1960891 | 1960891 | 2021-11-28 | Luce | Michigan | 26095 | 1697 | 6 |
1960918 | 1960918 | 2021-11-28 | Schoolcraft | Michigan | 26153 | 978 | 6 |
1957640 | 1957640 | 2021-11-27 | Luce | Michigan | 26095 | 1697 | 6 |
1957667 | 1957667 | 2021-11-27 | Schoolcraft | Michigan | 26153 | 978 | 6 |
1954389 | 1954389 | 2021-11-26 | Luce | Michigan | 26095 | 1697 | 6 |
1954416 | 1954416 | 2021-11-26 | Schoolcraft | Michigan | 26153 | 978 | 6 |
1951138 | 1951138 | 2021-11-25 | Luce | Michigan | 26095 | 1697 | 6 |
1951165 | 1951165 | 2021-11-25 | Schoolcraft | Michigan | 26153 | 978 | 6 |
1947887 | 1947887 | 2021-11-24 | Luce | Michigan | 26095 | 1697 | 6 |
1947914 | 1947914 | 2021-11-24 | Schoolcraft | Michigan | 26153 | 978 | 6 |
1944636 | 1944636 | 2021-11-23 | Luce | Michigan | 26095 | 1688 | 6 |
1944663 | 1944663 | 2021-11-23 | Schoolcraft | Michigan | 26153 | 968 | 6 |
1941385 | 1941385 | 2021-11-22 | Luce | Michigan | 26095 | 1688 | 6 |
1941412 | 1941412 | 2021-11-22 | Schoolcraft | Michigan | 26153 | 968 | 6 |
1938135 | 1938135 | 2021-11-21 | Luce | Michigan | 26095 | 1677 | 6 |
1938162 | 1938162 | 2021-11-21 | Schoolcraft | Michigan | 26153 | 960 | 6 |
1934885 | 1934885 | 2021-11-20 | Luce | Michigan | 26095 | 1677 | 6 |
1934912 | 1934912 | 2021-11-20 | Schoolcraft | Michigan | 26153 | 960 | 6 |
1931635 | 1931635 | 2021-11-19 | Luce | Michigan | 26095 | 1677 | 6 |
1931662 | 1931662 | 2021-11-19 | Schoolcraft | Michigan | 26153 | 960 | 6 |
1928384 | 1928384 | 2021-11-18 | Luce | Michigan | 26095 | 1668 | 6 |
1928411 | 1928411 | 2021-11-18 | Schoolcraft | Michigan | 26153 | 948 | 6 |
1925134 | 1925134 | 2021-11-17 | Luce | Michigan | 26095 | 1668 | 6 |
1925161 | 1925161 | 2021-11-17 | Schoolcraft | Michigan | 26153 | 948 | 6 |
1921879 | 1921879 | 2021-11-16 | Keweenaw | Michigan | 26083 | 320 | 6 |
1921885 | 1921885 | 2021-11-16 | Luce | Michigan | 26095 | 1664 | 6 |
1921912 | 1921912 | 2021-11-16 | Schoolcraft | Michigan | 26153 | 926 | 6 |
1918629 | 1918629 | 2021-11-15 | Keweenaw | Michigan | 26083 | 320 | 6 |
1918635 | 1918635 | 2021-11-15 | Luce | Michigan | 26095 | 1664 | 6 |
1918662 | 1918662 | 2021-11-15 | Schoolcraft | Michigan | 26153 | 926 | 6 |
1915379 | 1915379 | 2021-11-14 | Keweenaw | Michigan | 26083 | 304 | 6 |
1915385 | 1915385 | 2021-11-14 | Luce | Michigan | 26095 | 1652 | 6 |
1915412 | 1915412 | 2021-11-14 | Schoolcraft | Michigan | 26153 | 912 | 6 |
1912129 | 1912129 | 2021-11-13 | Keweenaw | Michigan | 26083 | 304 | 6 |
1912135 | 1912135 | 2021-11-13 | Luce | Michigan | 26095 | 1652 | 6 |
1912162 | 1912162 | 2021-11-13 | Schoolcraft | Michigan | 26153 | 912 | 6 |
1908879 | 1908879 | 2021-11-12 | Keweenaw | Michigan | 26083 | 304 | 6 |
1908885 | 1908885 | 2021-11-12 | Luce | Michigan | 26095 | 1652 | 6 |
1908912 | 1908912 | 2021-11-12 | Schoolcraft | Michigan | 26153 | 912 | 6 |
1905636 | 1905636 | 2021-11-11 | Luce | Michigan | 26095 | 1645 | 6 |
1902387 | 1902387 | 2021-11-10 | Luce | Michigan | 26095 | 1645 | 6 |
1899137 | 1899137 | 2021-11-09 | Luce | Michigan | 26095 | 1625 | 6 |
1895887 | 1895887 | 2021-11-08 | Luce | Michigan | 26095 | 1625 | 6 |
1892637 | 1892637 | 2021-11-07 | Luce | Michigan | 26095 | 1615 | 6 |
1889387 | 1889387 | 2021-11-06 | Luce | Michigan | 26095 | 1615 | 6 |
1886137 | 1886137 | 2021-11-05 | Luce | Michigan | 26095 | 1615 | 6 |
1882888 | 1882888 | 2021-11-04 | Luce | Michigan | 26095 | 1609 | 6 |
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);