ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
433 rows where deaths = 18 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Unknown 89
- Montmorency 51
- Leelanau 35
- Van Buren 25
- Oscoda 20
- Missaukee 13
- Clinton 12
- Ontonagon 12
- Wexford 11
- Antrim 10
- Monroe 10
- Lake 9
- Osceola 8
- Alcona 7
- Isabella 7
- Mackinac 7
- Charlevoix 6
- Mason 6
- Presque Isle 6
- Calhoun 5
- Chippewa 4
- Grand Traverse 4
- Iosco 4
- Lenawee 4
- Manistee 4
- Alpena 3
- Emmet 3
- Kalamazoo 3
- Marquette 3
- Mecosta 3
- …
state 1
- Michigan · 433 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2035655 | 2035655 | 2021-12-21 | Mackinac | Michigan | 26097 | 1652 | 18 |
2032405 | 2032405 | 2021-12-20 | Mackinac | Michigan | 26097 | 1652 | 18 |
2029154 | 2029154 | 2021-12-19 | Mackinac | Michigan | 26097 | 1644 | 18 |
2025903 | 2025903 | 2021-12-18 | Mackinac | Michigan | 26097 | 1644 | 18 |
2022652 | 2022652 | 2021-12-17 | Mackinac | Michigan | 26097 | 1644 | 18 |
2019401 | 2019401 | 2021-12-16 | Mackinac | Michigan | 26097 | 1628 | 18 |
2016151 | 2016151 | 2021-12-15 | Mackinac | Michigan | 26097 | 1628 | 18 |
1996677 | 1996677 | 2021-12-09 | Unknown | Michigan | 1613 | 18 | |
1983675 | 1983675 | 2021-12-05 | Unknown | Michigan | 1749 | 18 | |
1980425 | 1980425 | 2021-12-04 | Unknown | Michigan | 2091 | 18 | |
1977175 | 1977175 | 2021-12-03 | Unknown | Michigan | 2091 | 18 | |
1973865 | 1973865 | 2021-12-02 | Crawford | Michigan | 26039 | 1771 | 18 |
1970616 | 1970616 | 2021-12-01 | Crawford | Michigan | 26039 | 1771 | 18 |
1967426 | 1967426 | 2021-11-30 | Unknown | Michigan | 1482 | 18 | |
1964174 | 1964174 | 2021-11-29 | Unknown | Michigan | 1929 | 18 | |
1960923 | 1960923 | 2021-11-28 | Unknown | Michigan | 1517 | 18 | |
1957672 | 1957672 | 2021-11-27 | Unknown | Michigan | 1717 | 18 | |
1954421 | 1954421 | 2021-11-26 | Unknown | Michigan | 1717 | 18 | |
1951170 | 1951170 | 2021-11-25 | Unknown | Michigan | 1759 | 18 | |
1947919 | 1947919 | 2021-11-24 | Unknown | Michigan | 1921 | 18 | |
1941417 | 1941417 | 2021-11-22 | Unknown | Michigan | 1901 | 18 | |
1925166 | 1925166 | 2021-11-17 | Unknown | Michigan | 1811 | 18 | |
1921917 | 1921917 | 2021-11-16 | Unknown | Michigan | 1306 | 18 | |
1918667 | 1918667 | 2021-11-15 | Unknown | Michigan | 1724 | 18 | |
1785447 | 1785447 | 2021-10-05 | Unknown | Michigan | 947 | 18 | |
1782198 | 1782198 | 2021-10-04 | Unknown | Michigan | 947 | 18 | |
1778948 | 1778948 | 2021-10-03 | Unknown | Michigan | 947 | 18 | |
1775698 | 1775698 | 2021-10-02 | Unknown | Michigan | 947 | 18 | |
1772448 | 1772448 | 2021-10-01 | Unknown | Michigan | 947 | 18 | |
1769162 | 1769162 | 2021-09-30 | Lake | Michigan | 26085 | 814 | 18 |
1769199 | 1769199 | 2021-09-30 | Unknown | Michigan | 898 | 18 | |
1765913 | 1765913 | 2021-09-29 | Lake | Michigan | 26085 | 814 | 18 |
1765950 | 1765950 | 2021-09-29 | Unknown | Michigan | 898 | 18 | |
1762664 | 1762664 | 2021-09-28 | Lake | Michigan | 26085 | 807 | 18 |
1762701 | 1762701 | 2021-09-28 | Unknown | Michigan | 873 | 18 | |
1759415 | 1759415 | 2021-09-27 | Lake | Michigan | 26085 | 807 | 18 |
1759452 | 1759452 | 2021-09-27 | Unknown | Michigan | 873 | 18 | |
1756167 | 1756167 | 2021-09-26 | Lake | Michigan | 26085 | 798 | 18 |
1756204 | 1756204 | 2021-09-26 | Unknown | Michigan | 880 | 18 | |
1752919 | 1752919 | 2021-09-25 | Lake | Michigan | 26085 | 798 | 18 |
1752956 | 1752956 | 2021-09-25 | Unknown | Michigan | 880 | 18 | |
1749671 | 1749671 | 2021-09-24 | Lake | Michigan | 26085 | 798 | 18 |
1749708 | 1749708 | 2021-09-24 | Unknown | Michigan | 880 | 18 | |
1746421 | 1746421 | 2021-09-23 | Lake | Michigan | 26085 | 791 | 18 |
1746458 | 1746458 | 2021-09-23 | Unknown | Michigan | 871 | 18 | |
1743172 | 1743172 | 2021-09-22 | Lake | Michigan | 26085 | 791 | 18 |
1743209 | 1743209 | 2021-09-22 | Unknown | Michigan | 871 | 18 | |
1739960 | 1739960 | 2021-09-21 | Unknown | Michigan | 861 | 18 | |
1736711 | 1736711 | 2021-09-20 | Unknown | Michigan | 861 | 18 | |
1733461 | 1733461 | 2021-09-19 | Unknown | Michigan | 867 | 18 | |
1730211 | 1730211 | 2021-09-18 | Unknown | Michigan | 867 | 18 | |
1726961 | 1726961 | 2021-09-17 | Unknown | Michigan | 867 | 18 | |
1723712 | 1723712 | 2021-09-16 | Unknown | Michigan | 848 | 18 | |
1720463 | 1720463 | 2021-09-15 | Unknown | Michigan | 848 | 18 | |
1717215 | 1717215 | 2021-09-14 | Unknown | Michigan | 830 | 18 | |
1713967 | 1713967 | 2021-09-13 | Unknown | Michigan | 830 | 18 | |
1710721 | 1710721 | 2021-09-12 | Unknown | Michigan | 829 | 18 | |
1707474 | 1707474 | 2021-09-11 | Unknown | Michigan | 829 | 18 | |
1704227 | 1704227 | 2021-09-10 | Unknown | Michigan | 829 | 18 | |
1700977 | 1700977 | 2021-09-09 | Unknown | Michigan | 820 | 18 | |
1697728 | 1697728 | 2021-09-08 | Unknown | Michigan | 820 | 18 | |
1694480 | 1694480 | 2021-09-07 | Unknown | Michigan | 822 | 18 | |
1691231 | 1691231 | 2021-09-06 | Unknown | Michigan | 814 | 18 | |
1687981 | 1687981 | 2021-09-05 | Unknown | Michigan | 814 | 18 | |
1684731 | 1684731 | 2021-09-04 | Unknown | Michigan | 814 | 18 | |
1681480 | 1681480 | 2021-09-03 | Unknown | Michigan | 814 | 18 | |
1678232 | 1678232 | 2021-09-02 | Unknown | Michigan | 812 | 18 | |
1674984 | 1674984 | 2021-09-01 | Unknown | Michigan | 812 | 18 | |
1671736 | 1671736 | 2021-08-31 | Unknown | Michigan | 806 | 18 | |
1668489 | 1668489 | 2021-08-30 | Unknown | Michigan | 806 | 18 | |
1665242 | 1665242 | 2021-08-29 | Unknown | Michigan | 806 | 18 | |
1661994 | 1661994 | 2021-08-28 | Unknown | Michigan | 806 | 18 | |
1658746 | 1658746 | 2021-08-27 | Unknown | Michigan | 806 | 18 | |
1655497 | 1655497 | 2021-08-26 | Unknown | Michigan | 813 | 18 | |
1652250 | 1652250 | 2021-08-25 | Unknown | Michigan | 813 | 18 | |
1649002 | 1649002 | 2021-08-24 | Unknown | Michigan | 797 | 18 | |
1645753 | 1645753 | 2021-08-23 | Unknown | Michigan | 797 | 18 | |
1642504 | 1642504 | 2021-08-22 | Unknown | Michigan | 794 | 18 | |
1639254 | 1639254 | 2021-08-21 | Unknown | Michigan | 794 | 18 | |
1636004 | 1636004 | 2021-08-20 | Unknown | Michigan | 794 | 18 | |
1632754 | 1632754 | 2021-08-19 | Unknown | Michigan | 790 | 18 | |
1629507 | 1629507 | 2021-08-18 | Unknown | Michigan | 790 | 18 | |
1626260 | 1626260 | 2021-08-17 | Unknown | Michigan | 782 | 18 | |
1623013 | 1623013 | 2021-08-16 | Unknown | Michigan | 782 | 18 | |
1619766 | 1619766 | 2021-08-15 | Unknown | Michigan | 781 | 18 | |
1616518 | 1616518 | 2021-08-14 | Unknown | Michigan | 781 | 18 | |
1613270 | 1613270 | 2021-08-13 | Unknown | Michigan | 781 | 18 | |
1610021 | 1610021 | 2021-08-12 | Unknown | Michigan | 777 | 18 | |
1606773 | 1606773 | 2021-08-11 | Unknown | Michigan | 777 | 18 | |
1603524 | 1603524 | 2021-08-10 | Unknown | Michigan | 771 | 18 | |
1600275 | 1600275 | 2021-08-09 | Unknown | Michigan | 771 | 18 | |
1597027 | 1597027 | 2021-08-08 | Unknown | Michigan | 771 | 18 | |
1593778 | 1593778 | 2021-08-07 | Unknown | Michigan | 771 | 18 | |
1590529 | 1590529 | 2021-08-06 | Unknown | Michigan | 771 | 18 | |
1587280 | 1587280 | 2021-08-05 | Unknown | Michigan | 765 | 18 | |
1584029 | 1584029 | 2021-08-04 | Unknown | Michigan | 765 | 18 | |
1580780 | 1580780 | 2021-08-03 | Unknown | Michigan | 765 | 18 | |
1577531 | 1577531 | 2021-08-02 | Unknown | Michigan | 758 | 18 | |
1574283 | 1574283 | 2021-08-01 | Unknown | Michigan | 758 | 18 | |
1571035 | 1571035 | 2021-07-31 | Unknown | Michigan | 758 | 18 |
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);