ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
450 rows where deaths = 28 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Shiawassee 49
- Presque Isle 44
- Monroe 31
- Otsego 27
- Mackinac 26
- Baraga 21
- Manistee 19
- Osceola 16
- Emmet 15
- Arenac 14
- Benzie 14
- Antrim 13
- Alcona 12
- Unknown 12
- Branch 9
- Ontonagon 9
- Lake 7
- Missaukee 7
- Roscommon 7
- Dickinson 6
- Hillsdale 6
- Iron 6
- Wexford 6
- Cass 5
- Clare 5
- Mason 5
- Charlevoix 4
- Kalkaska 4
- Newaygo 4
- Bay 3
- …
state 1
- Michigan · 450 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2279549 | 2279549 | 2022-03-06 | Mackinac | Michigan | 26097 | 2368 | 28 |
2276296 | 2276296 | 2022-03-05 | Mackinac | Michigan | 26097 | 2368 | 28 |
2273043 | 2273043 | 2022-03-04 | Mackinac | Michigan | 26097 | 2368 | 28 |
2269791 | 2269791 | 2022-03-03 | Mackinac | Michigan | 26097 | 2364 | 28 |
2266538 | 2266538 | 2022-03-02 | Mackinac | Michigan | 26097 | 2364 | 28 |
2263287 | 2263287 | 2022-03-01 | Mackinac | Michigan | 26097 | 2356 | 28 |
2260036 | 2260036 | 2022-02-28 | Mackinac | Michigan | 26097 | 2356 | 28 |
2256785 | 2256785 | 2022-02-27 | Mackinac | Michigan | 26097 | 2352 | 28 |
2253534 | 2253534 | 2022-02-26 | Mackinac | Michigan | 26097 | 2352 | 28 |
2250283 | 2250283 | 2022-02-25 | Mackinac | Michigan | 26097 | 2352 | 28 |
2247032 | 2247032 | 2022-02-24 | Mackinac | Michigan | 26097 | 2349 | 28 |
2243781 | 2243781 | 2022-02-23 | Mackinac | Michigan | 26097 | 2349 | 28 |
2240530 | 2240530 | 2022-02-22 | Mackinac | Michigan | 26097 | 2334 | 28 |
2237279 | 2237279 | 2022-02-21 | Mackinac | Michigan | 26097 | 2334 | 28 |
2237310 | 2237310 | 2022-02-21 | Unknown | Michigan | 11709 | 28 | |
2234028 | 2234028 | 2022-02-20 | Mackinac | Michigan | 26097 | 2334 | 28 |
2234059 | 2234059 | 2022-02-20 | Unknown | Michigan | 11709 | 28 | |
2230777 | 2230777 | 2022-02-19 | Mackinac | Michigan | 26097 | 2322 | 28 |
2230808 | 2230808 | 2022-02-19 | Unknown | Michigan | 10860 | 28 | |
2227526 | 2227526 | 2022-02-18 | Mackinac | Michigan | 26097 | 2322 | 28 |
2227557 | 2227557 | 2022-02-18 | Unknown | Michigan | 10860 | 28 | |
2224275 | 2224275 | 2022-02-17 | Mackinac | Michigan | 26097 | 2322 | 28 |
2224306 | 2224306 | 2022-02-17 | Unknown | Michigan | 10964 | 28 | |
2221024 | 2221024 | 2022-02-16 | Mackinac | Michigan | 26097 | 2322 | 28 |
2217804 | 2217804 | 2022-02-15 | Unknown | Michigan | 11162 | 28 | |
2201511 | 2201511 | 2022-02-10 | Mackinac | Michigan | 26097 | 2301 | 28 |
2198257 | 2198257 | 2022-02-09 | Mackinac | Michigan | 26097 | 2301 | 28 |
2195003 | 2195003 | 2022-02-08 | Mackinac | Michigan | 26097 | 2286 | 28 |
2191749 | 2191749 | 2022-02-07 | Mackinac | Michigan | 26097 | 2286 | 28 |
2188496 | 2188496 | 2022-02-06 | Mackinac | Michigan | 26097 | 2278 | 28 |
2185243 | 2185243 | 2022-02-05 | Mackinac | Michigan | 26097 | 2278 | 28 |
2181991 | 2181991 | 2022-02-04 | Mackinac | Michigan | 26097 | 2278 | 28 |
2172265 | 2172265 | 2022-02-01 | Unknown | Michigan | 9013 | 28 | |
2165757 | 2165757 | 2022-01-30 | Unknown | Michigan | 8787 | 28 | |
2162502 | 2162502 | 2022-01-29 | Unknown | Michigan | 9016 | 28 | |
2159247 | 2159247 | 2022-01-28 | Unknown | Michigan | 9016 | 28 | |
2152740 | 2152740 | 2022-01-26 | Unknown | Michigan | 8476 | 28 | |
2129965 | 2129965 | 2022-01-19 | Unknown | Michigan | 6055 | 28 | |
2110438 | 2110438 | 2022-01-13 | Ontonagon | Michigan | 26131 | 832 | 28 |
2107187 | 2107187 | 2022-01-12 | Ontonagon | Michigan | 26131 | 832 | 28 |
2103936 | 2103936 | 2022-01-11 | Ontonagon | Michigan | 26131 | 822 | 28 |
2100685 | 2100685 | 2022-01-10 | Ontonagon | Michigan | 26131 | 822 | 28 |
2097434 | 2097434 | 2022-01-09 | Ontonagon | Michigan | 26131 | 796 | 28 |
2094182 | 2094182 | 2022-01-08 | Ontonagon | Michigan | 26131 | 796 | 28 |
2090930 | 2090930 | 2022-01-07 | Ontonagon | Michigan | 26131 | 796 | 28 |
2087679 | 2087679 | 2022-01-06 | Ontonagon | Michigan | 26131 | 768 | 28 |
2084427 | 2084427 | 2022-01-05 | Ontonagon | Michigan | 26131 | 768 | 28 |
2012894 | 2012894 | 2021-12-14 | Lake | Michigan | 26085 | 1323 | 28 |
2009643 | 2009643 | 2021-12-13 | Lake | Michigan | 26085 | 1323 | 28 |
2006392 | 2006392 | 2021-12-12 | Lake | Michigan | 26085 | 1300 | 28 |
2003141 | 2003141 | 2021-12-11 | Lake | Michigan | 26085 | 1300 | 28 |
1999891 | 1999891 | 2021-12-10 | Lake | Michigan | 26085 | 1300 | 28 |
1996640 | 1996640 | 2021-12-09 | Lake | Michigan | 26085 | 1279 | 28 |
1993389 | 1993389 | 2021-12-08 | Lake | Michigan | 26085 | 1279 | 28 |
1882900 | 1882900 | 2021-11-04 | Montmorency | Michigan | 26119 | 1011 | 28 |
1879651 | 1879651 | 2021-11-03 | Montmorency | Michigan | 26119 | 1011 | 28 |
1723647 | 1723647 | 2021-09-16 | Charlevoix | Michigan | 26029 | 2024 | 28 |
1720398 | 1720398 | 2021-09-15 | Charlevoix | Michigan | 26029 | 2018 | 28 |
1717150 | 1717150 | 2021-09-14 | Charlevoix | Michigan | 26029 | 2011 | 28 |
1713902 | 1713902 | 2021-09-13 | Charlevoix | Michigan | 26029 | 2003 | 28 |
1694451 | 1694451 | 2021-09-07 | Manistee | Michigan | 26101 | 2160 | 28 |
1691202 | 1691202 | 2021-09-06 | Manistee | Michigan | 26101 | 2147 | 28 |
1687952 | 1687952 | 2021-09-05 | Manistee | Michigan | 26101 | 2147 | 28 |
1684702 | 1684702 | 2021-09-04 | Manistee | Michigan | 26101 | 2147 | 28 |
1681451 | 1681451 | 2021-09-03 | Manistee | Michigan | 26101 | 2147 | 28 |
1678203 | 1678203 | 2021-09-02 | Manistee | Michigan | 26101 | 2133 | 28 |
1674955 | 1674955 | 2021-09-01 | Manistee | Michigan | 26101 | 2133 | 28 |
1671707 | 1671707 | 2021-08-31 | Manistee | Michigan | 26101 | 2118 | 28 |
1668460 | 1668460 | 2021-08-30 | Manistee | Michigan | 26101 | 2118 | 28 |
1665213 | 1665213 | 2021-08-29 | Manistee | Michigan | 26101 | 2114 | 28 |
1661965 | 1661965 | 2021-08-28 | Manistee | Michigan | 26101 | 2114 | 28 |
1658717 | 1658717 | 2021-08-27 | Manistee | Michigan | 26101 | 2114 | 28 |
1655468 | 1655468 | 2021-08-26 | Manistee | Michigan | 26101 | 2093 | 28 |
1652221 | 1652221 | 2021-08-25 | Manistee | Michigan | 26101 | 2093 | 28 |
1648973 | 1648973 | 2021-08-24 | Manistee | Michigan | 26101 | 2083 | 28 |
1645724 | 1645724 | 2021-08-23 | Manistee | Michigan | 26101 | 2083 | 28 |
1642475 | 1642475 | 2021-08-22 | Manistee | Michigan | 26101 | 2066 | 28 |
1639225 | 1639225 | 2021-08-21 | Manistee | Michigan | 26101 | 2066 | 28 |
1635975 | 1635975 | 2021-08-20 | Manistee | Michigan | 26101 | 2066 | 28 |
1619743 | 1619743 | 2021-08-15 | Missaukee | Michigan | 26113 | 1536 | 28 |
1616495 | 1616495 | 2021-08-14 | Missaukee | Michigan | 26113 | 1536 | 28 |
1613247 | 1613247 | 2021-08-13 | Missaukee | Michigan | 26113 | 1536 | 28 |
1609998 | 1609998 | 2021-08-12 | Missaukee | Michigan | 26113 | 1531 | 28 |
1606750 | 1606750 | 2021-08-11 | Missaukee | Michigan | 26113 | 1531 | 28 |
1603501 | 1603501 | 2021-08-10 | Missaukee | Michigan | 26113 | 1531 | 28 |
1600252 | 1600252 | 2021-08-09 | Missaukee | Michigan | 26113 | 1531 | 28 |
1554756 | 1554756 | 2021-07-26 | Kalkaska | Michigan | 26079 | 1157 | 28 |
1551509 | 1551509 | 2021-07-25 | Kalkaska | Michigan | 26079 | 1157 | 28 |
1548262 | 1548262 | 2021-07-24 | Kalkaska | Michigan | 26079 | 1157 | 28 |
1545015 | 1545015 | 2021-07-23 | Kalkaska | Michigan | 26079 | 1157 | 28 |
1359955 | 1359955 | 2021-05-27 | Antrim | Michigan | 26009 | 1624 | 28 |
1356709 | 1356709 | 2021-05-26 | Antrim | Michigan | 26009 | 1623 | 28 |
1353463 | 1353463 | 2021-05-25 | Antrim | Michigan | 26009 | 1617 | 28 |
1350217 | 1350217 | 2021-05-24 | Antrim | Michigan | 26009 | 1617 | 28 |
1346971 | 1346971 | 2021-05-23 | Antrim | Michigan | 26009 | 1615 | 28 |
1343723 | 1343723 | 2021-05-22 | Antrim | Michigan | 26009 | 1615 | 28 |
1340474 | 1340474 | 2021-05-21 | Antrim | Michigan | 26009 | 1615 | 28 |
1340536 | 1340536 | 2021-05-21 | Osceola | Michigan | 26133 | 1925 | 28 |
1337227 | 1337227 | 2021-05-20 | Antrim | Michigan | 26009 | 1615 | 28 |
1337289 | 1337289 | 2021-05-20 | Osceola | Michigan | 26133 | 1922 | 28 |
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);