ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
213 rows where deaths = 78 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Cass 47
- Iosco 18
- Cheboygan 14
- Delta 11
- Marquette 7
- Otsego 7
- Shiawassee 7
- Barry 5
- Chippewa 5
- Dickinson 5
- Hillsdale 5
- Isabella 5
- Mason 5
- Midland 5
- Oceana 5
- St. Clair 5
- Kalamazoo 4
- Muskegon 4
- Unknown 4
- Van Buren 4
- Alpena 3
- Berrien 3
- Manistee 3
- Mecosta 3
- Ottawa 3
- St. Joseph 3
- Clare 2
- Gladwin 2
- Grand Traverse 2
- Ionia 2
- …
state 1
- Michigan · 213 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419485 | 2419485 | 2022-04-18 | Unknown | Michigan | 17062 | 78 | |
2416229 | 2416229 | 2022-04-17 | Unknown | Michigan | 17486 | 78 | |
2412973 | 2412973 | 2022-04-16 | Unknown | Michigan | 17486 | 78 | |
2409717 | 2409717 | 2022-04-15 | Unknown | Michigan | 17486 | 78 | |
2292575 | 2292575 | 2022-03-10 | Osceola | Michigan | 26133 | 4960 | 78 |
2289323 | 2289323 | 2022-03-09 | Osceola | Michigan | 26133 | 4960 | 78 |
2211272 | 2211272 | 2022-02-13 | Manistee | Michigan | 26101 | 4297 | 78 |
2208019 | 2208019 | 2022-02-12 | Manistee | Michigan | 26101 | 4297 | 78 |
2204766 | 2204766 | 2022-02-11 | Manistee | Michigan | 26101 | 4297 | 78 |
2172238 | 2172238 | 2022-02-01 | Mason | Michigan | 26105 | 6100 | 78 |
2168985 | 2168985 | 2022-01-31 | Mason | Michigan | 26105 | 6100 | 78 |
2165730 | 2165730 | 2022-01-30 | Mason | Michigan | 26105 | 5979 | 78 |
2162475 | 2162475 | 2022-01-29 | Mason | Michigan | 26105 | 5979 | 78 |
2159220 | 2159220 | 2022-01-28 | Mason | Michigan | 26105 | 5979 | 78 |
2058423 | 2058423 | 2021-12-28 | Otsego | Michigan | 26137 | 4293 | 78 |
2055174 | 2055174 | 2021-12-27 | Otsego | Michigan | 26137 | 4293 | 78 |
2051924 | 2051924 | 2021-12-26 | Otsego | Michigan | 26137 | 4265 | 78 |
2048674 | 2048674 | 2021-12-25 | Otsego | Michigan | 26137 | 4265 | 78 |
2045424 | 2045424 | 2021-12-24 | Otsego | Michigan | 26137 | 4265 | 78 |
2042174 | 2042174 | 2021-12-23 | Otsego | Michigan | 26137 | 4265 | 78 |
2038925 | 2038925 | 2021-12-22 | Otsego | Michigan | 26137 | 4265 | 78 |
2029159 | 2029159 | 2021-12-19 | Mecosta | Michigan | 26107 | 6199 | 78 |
2025908 | 2025908 | 2021-12-18 | Mecosta | Michigan | 26107 | 6199 | 78 |
2022657 | 2022657 | 2021-12-17 | Mecosta | Michigan | 26107 | 6199 | 78 |
2012867 | 2012867 | 2021-12-14 | Cheboygan | Michigan | 26031 | 3475 | 78 |
2012868 | 2012868 | 2021-12-14 | Chippewa | Michigan | 26033 | 7937 | 78 |
2012915 | 2012915 | 2021-12-14 | Oceana | Michigan | 26127 | 4769 | 78 |
2009616 | 2009616 | 2021-12-13 | Cheboygan | Michigan | 26031 | 3475 | 78 |
2009617 | 2009617 | 2021-12-13 | Chippewa | Michigan | 26033 | 7937 | 78 |
2009664 | 2009664 | 2021-12-13 | Oceana | Michigan | 26127 | 4769 | 78 |
2006365 | 2006365 | 2021-12-12 | Cheboygan | Michigan | 26031 | 3449 | 78 |
2006366 | 2006366 | 2021-12-12 | Chippewa | Michigan | 26033 | 7896 | 78 |
2006413 | 2006413 | 2021-12-12 | Oceana | Michigan | 26127 | 4739 | 78 |
2003114 | 2003114 | 2021-12-11 | Cheboygan | Michigan | 26031 | 3449 | 78 |
2003115 | 2003115 | 2021-12-11 | Chippewa | Michigan | 26033 | 7896 | 78 |
2003162 | 2003162 | 2021-12-11 | Oceana | Michigan | 26127 | 4739 | 78 |
1999864 | 1999864 | 2021-12-10 | Cheboygan | Michigan | 26031 | 3449 | 78 |
1999865 | 1999865 | 2021-12-10 | Chippewa | Michigan | 26033 | 7896 | 78 |
1999912 | 1999912 | 2021-12-10 | Oceana | Michigan | 26127 | 4739 | 78 |
1996613 | 1996613 | 2021-12-09 | Cheboygan | Michigan | 26031 | 3406 | 78 |
1993362 | 1993362 | 2021-12-08 | Cheboygan | Michigan | 26031 | 3406 | 78 |
1990111 | 1990111 | 2021-12-07 | Cheboygan | Michigan | 26031 | 3368 | 78 |
1986861 | 1986861 | 2021-12-06 | Cheboygan | Michigan | 26031 | 3368 | 78 |
1983611 | 1983611 | 2021-12-05 | Cheboygan | Michigan | 26031 | 3333 | 78 |
1980361 | 1980361 | 2021-12-04 | Cheboygan | Michigan | 26031 | 3333 | 78 |
1977111 | 1977111 | 2021-12-03 | Cheboygan | Michigan | 26031 | 3333 | 78 |
1973861 | 1973861 | 2021-12-02 | Cheboygan | Michigan | 26031 | 3298 | 78 |
1970612 | 1970612 | 2021-12-01 | Cheboygan | Michigan | 26031 | 3298 | 78 |
1915341 | 1915341 | 2021-11-14 | Alpena | Michigan | 26007 | 3569 | 78 |
1912091 | 1912091 | 2021-11-13 | Alpena | Michigan | 26007 | 3569 | 78 |
1908841 | 1908841 | 2021-11-12 | Alpena | Michigan | 26007 | 3569 | 78 |
1905614 | 1905614 | 2021-11-11 | Gladwin | Michigan | 26051 | 3479 | 78 |
1902365 | 1902365 | 2021-11-10 | Gladwin | Michigan | 26051 | 3479 | 78 |
1853651 | 1853651 | 2021-10-26 | Marquette | Michigan | 26103 | 7918 | 78 |
1850402 | 1850402 | 2021-10-25 | Marquette | Michigan | 26103 | 7918 | 78 |
1847152 | 1847152 | 2021-10-24 | Marquette | Michigan | 26103 | 7865 | 78 |
1843902 | 1843902 | 2021-10-23 | Marquette | Michigan | 26103 | 7865 | 78 |
1840652 | 1840652 | 2021-10-22 | Marquette | Michigan | 26103 | 7865 | 78 |
1837403 | 1837403 | 2021-10-21 | Marquette | Michigan | 26103 | 7809 | 78 |
1834154 | 1834154 | 2021-10-20 | Marquette | Michigan | 26103 | 7809 | 78 |
1808119 | 1808119 | 2021-10-12 | Barry | Michigan | 26015 | 7322 | 78 |
1808133 | 1808133 | 2021-10-12 | Dickinson | Michigan | 26043 | 3752 | 78 |
1808173 | 1808173 | 2021-10-12 | Newaygo | Michigan | 26123 | 6188 | 78 |
1804868 | 1804868 | 2021-10-11 | Barry | Michigan | 26015 | 7322 | 78 |
1804882 | 1804882 | 2021-10-11 | Dickinson | Michigan | 26043 | 3752 | 78 |
1804922 | 1804922 | 2021-10-11 | Newaygo | Michigan | 26123 | 6188 | 78 |
1801619 | 1801619 | 2021-10-10 | Barry | Michigan | 26015 | 7263 | 78 |
1801633 | 1801633 | 2021-10-10 | Dickinson | Michigan | 26043 | 3725 | 78 |
1798370 | 1798370 | 2021-10-09 | Barry | Michigan | 26015 | 7263 | 78 |
1798384 | 1798384 | 2021-10-09 | Dickinson | Michigan | 26043 | 3725 | 78 |
1795121 | 1795121 | 2021-10-08 | Barry | Michigan | 26015 | 7263 | 78 |
1795135 | 1795135 | 2021-10-08 | Dickinson | Michigan | 26043 | 3725 | 78 |
1700932 | 1700932 | 2021-09-09 | Iosco | Michigan | 26069 | 2237 | 78 |
1697683 | 1697683 | 2021-09-08 | Iosco | Michigan | 26069 | 2237 | 78 |
1694435 | 1694435 | 2021-09-07 | Iosco | Michigan | 26069 | 2229 | 78 |
1691186 | 1691186 | 2021-09-06 | Iosco | Michigan | 26069 | 2197 | 78 |
1687936 | 1687936 | 2021-09-05 | Iosco | Michigan | 26069 | 2197 | 78 |
1684686 | 1684686 | 2021-09-04 | Iosco | Michigan | 26069 | 2197 | 78 |
1681435 | 1681435 | 2021-09-03 | Iosco | Michigan | 26069 | 2197 | 78 |
1678187 | 1678187 | 2021-09-02 | Iosco | Michigan | 26069 | 2182 | 78 |
1674939 | 1674939 | 2021-09-01 | Iosco | Michigan | 26069 | 2182 | 78 |
1671691 | 1671691 | 2021-08-31 | Iosco | Michigan | 26069 | 2173 | 78 |
1668444 | 1668444 | 2021-08-30 | Iosco | Michigan | 26069 | 2173 | 78 |
1665197 | 1665197 | 2021-08-29 | Iosco | Michigan | 26069 | 2149 | 78 |
1661949 | 1661949 | 2021-08-28 | Iosco | Michigan | 26069 | 2149 | 78 |
1658701 | 1658701 | 2021-08-27 | Iosco | Michigan | 26069 | 2149 | 78 |
1655452 | 1655452 | 2021-08-26 | Iosco | Michigan | 26069 | 2139 | 78 |
1652205 | 1652205 | 2021-08-25 | Iosco | Michigan | 26069 | 2139 | 78 |
1648936 | 1648936 | 2021-08-24 | Cass | Michigan | 26027 | 5782 | 78 |
1648957 | 1648957 | 2021-08-24 | Iosco | Michigan | 26069 | 2133 | 78 |
1645687 | 1645687 | 2021-08-23 | Cass | Michigan | 26027 | 5782 | 78 |
1645708 | 1645708 | 2021-08-23 | Iosco | Michigan | 26069 | 2133 | 78 |
1642438 | 1642438 | 2021-08-22 | Cass | Michigan | 26027 | 5743 | 78 |
1639188 | 1639188 | 2021-08-21 | Cass | Michigan | 26027 | 5743 | 78 |
1635938 | 1635938 | 2021-08-20 | Cass | Michigan | 26027 | 5743 | 78 |
1632688 | 1632688 | 2021-08-19 | Cass | Michigan | 26027 | 5712 | 78 |
1629441 | 1629441 | 2021-08-18 | Cass | Michigan | 26027 | 5712 | 78 |
1626194 | 1626194 | 2021-08-17 | Cass | Michigan | 26027 | 5697 | 78 |
1622947 | 1622947 | 2021-08-16 | Cass | Michigan | 26027 | 5697 | 78 |
1619700 | 1619700 | 2021-08-15 | Cass | Michigan | 26027 | 5678 | 78 |
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);