ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where deaths = 7 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Alger 125
- Allegan 96
- Sanilac 74
- Eaton 59
- Ionia 58
- Isabella 56
- Grand Traverse 24
- Van Buren 24
- Schoolcraft 21
- Charlevoix 15
- Montcalm 15
- Crawford 14
- Mackinac 14
- Mecosta 12
- Missaukee 9
- Menominee 7
- Roscommon 7
- St. Joseph 7
- Iosco 6
- Kalkaska 6
- Cass 5
- Delta 5
- Keweenaw 5
- Mason 5
- Ogemaw 5
- Unknown 5
- Huron 4
- Kalamazoo 4
- Lenawee 4
- Ottawa 4
- …
state 1
- Michigan · 766 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2133186 | 2133186 | 2022-01-20 | Luce | Michigan | 26095 | 2092 | 7 |
2129933 | 2129933 | 2022-01-19 | Luce | Michigan | 26095 | 2092 | 7 |
2035681 | 2035681 | 2021-12-21 | Schoolcraft | Michigan | 26153 | 1172 | 7 |
2032431 | 2032431 | 2021-12-20 | Schoolcraft | Michigan | 26153 | 1172 | 7 |
2029180 | 2029180 | 2021-12-19 | Schoolcraft | Michigan | 26153 | 1170 | 7 |
2025929 | 2025929 | 2021-12-18 | Schoolcraft | Michigan | 26153 | 1170 | 7 |
2022678 | 2022678 | 2021-12-17 | Schoolcraft | Michigan | 26153 | 1170 | 7 |
2019427 | 2019427 | 2021-12-16 | Schoolcraft | Michigan | 26153 | 1163 | 7 |
2016177 | 2016177 | 2021-12-15 | Schoolcraft | Michigan | 26153 | 1163 | 7 |
2012926 | 2012926 | 2021-12-14 | Schoolcraft | Michigan | 26153 | 1133 | 7 |
2009675 | 2009675 | 2021-12-13 | Schoolcraft | Michigan | 26153 | 1133 | 7 |
2006424 | 2006424 | 2021-12-12 | Schoolcraft | Michigan | 26153 | 1126 | 7 |
2003173 | 2003173 | 2021-12-11 | Schoolcraft | Michigan | 26153 | 1126 | 7 |
1999923 | 1999923 | 2021-12-10 | Schoolcraft | Michigan | 26153 | 1126 | 7 |
1996672 | 1996672 | 2021-12-09 | Schoolcraft | Michigan | 26153 | 1114 | 7 |
1993421 | 1993421 | 2021-12-08 | Schoolcraft | Michigan | 26153 | 1114 | 7 |
1990170 | 1990170 | 2021-12-07 | Schoolcraft | Michigan | 26153 | 1081 | 7 |
1986920 | 1986920 | 2021-12-06 | Schoolcraft | Michigan | 26153 | 1081 | 7 |
1983670 | 1983670 | 2021-12-05 | Schoolcraft | Michigan | 26153 | 1074 | 7 |
1980420 | 1980420 | 2021-12-04 | Schoolcraft | Michigan | 26153 | 1074 | 7 |
1977170 | 1977170 | 2021-12-03 | Schoolcraft | Michigan | 26153 | 1074 | 7 |
1973920 | 1973920 | 2021-12-02 | Schoolcraft | Michigan | 26153 | 1050 | 7 |
1970671 | 1970671 | 2021-12-01 | Schoolcraft | Michigan | 26153 | 1050 | 7 |
1938129 | 1938129 | 2021-11-21 | Keweenaw | Michigan | 26083 | 334 | 7 |
1934879 | 1934879 | 2021-11-20 | Keweenaw | Michigan | 26083 | 334 | 7 |
1931629 | 1931629 | 2021-11-19 | Keweenaw | Michigan | 26083 | 334 | 7 |
1928378 | 1928378 | 2021-11-18 | Keweenaw | Michigan | 26083 | 326 | 7 |
1925128 | 1925128 | 2021-11-17 | Keweenaw | Michigan | 26083 | 326 | 7 |
1830902 | 1830902 | 2021-10-19 | Mackinac | Michigan | 26097 | 1233 | 7 |
1827653 | 1827653 | 2021-10-18 | Mackinac | Michigan | 26097 | 1233 | 7 |
1824404 | 1824404 | 2021-10-17 | Mackinac | Michigan | 26097 | 1215 | 7 |
1821155 | 1821155 | 2021-10-16 | Mackinac | Michigan | 26097 | 1215 | 7 |
1817906 | 1817906 | 2021-10-15 | Mackinac | Michigan | 26097 | 1215 | 7 |
1814657 | 1814657 | 2021-10-14 | Mackinac | Michigan | 26097 | 1187 | 7 |
1811409 | 1811409 | 2021-10-13 | Mackinac | Michigan | 26097 | 1187 | 7 |
1808160 | 1808160 | 2021-10-12 | Mackinac | Michigan | 26097 | 1158 | 7 |
1804909 | 1804909 | 2021-10-11 | Mackinac | Michigan | 26097 | 1158 | 7 |
1801660 | 1801660 | 2021-10-10 | Mackinac | Michigan | 26097 | 1145 | 7 |
1798411 | 1798411 | 2021-10-09 | Mackinac | Michigan | 26097 | 1145 | 7 |
1795162 | 1795162 | 2021-10-08 | Mackinac | Michigan | 26097 | 1145 | 7 |
1791913 | 1791913 | 2021-10-07 | Mackinac | Michigan | 26097 | 1113 | 7 |
1788664 | 1788664 | 2021-10-06 | Mackinac | Michigan | 26097 | 1113 | 7 |
1785369 | 1785369 | 2021-10-05 | Alger | Michigan | 26003 | 892 | 7 |
1782120 | 1782120 | 2021-10-04 | Alger | Michigan | 26003 | 892 | 7 |
1778870 | 1778870 | 2021-10-03 | Alger | Michigan | 26003 | 882 | 7 |
1775620 | 1775620 | 2021-10-02 | Alger | Michigan | 26003 | 882 | 7 |
1772370 | 1772370 | 2021-10-01 | Alger | Michigan | 26003 | 882 | 7 |
1769121 | 1769121 | 2021-09-30 | Alger | Michigan | 26003 | 866 | 7 |
1765872 | 1765872 | 2021-09-29 | Alger | Michigan | 26003 | 866 | 7 |
1762623 | 1762623 | 2021-09-28 | Alger | Michigan | 26003 | 854 | 7 |
1759374 | 1759374 | 2021-09-27 | Alger | Michigan | 26003 | 854 | 7 |
1756126 | 1756126 | 2021-09-26 | Alger | Michigan | 26003 | 846 | 7 |
1752878 | 1752878 | 2021-09-25 | Alger | Michigan | 26003 | 846 | 7 |
1749630 | 1749630 | 2021-09-24 | Alger | Michigan | 26003 | 846 | 7 |
1746380 | 1746380 | 2021-09-23 | Alger | Michigan | 26003 | 837 | 7 |
1743131 | 1743131 | 2021-09-22 | Alger | Michigan | 26003 | 837 | 7 |
1739882 | 1739882 | 2021-09-21 | Alger | Michigan | 26003 | 814 | 7 |
1736633 | 1736633 | 2021-09-20 | Alger | Michigan | 26003 | 814 | 7 |
1733383 | 1733383 | 2021-09-19 | Alger | Michigan | 26003 | 798 | 7 |
1730133 | 1730133 | 2021-09-18 | Alger | Michigan | 26003 | 798 | 7 |
1726883 | 1726883 | 2021-09-17 | Alger | Michigan | 26003 | 798 | 7 |
1723634 | 1723634 | 2021-09-16 | Alger | Michigan | 26003 | 787 | 7 |
1720385 | 1720385 | 2021-09-15 | Alger | Michigan | 26003 | 787 | 7 |
1717137 | 1717137 | 2021-09-14 | Alger | Michigan | 26003 | 768 | 7 |
1713889 | 1713889 | 2021-09-13 | Alger | Michigan | 26003 | 768 | 7 |
1710643 | 1710643 | 2021-09-12 | Alger | Michigan | 26003 | 751 | 7 |
1707396 | 1707396 | 2021-09-11 | Alger | Michigan | 26003 | 751 | 7 |
1704149 | 1704149 | 2021-09-10 | Alger | Michigan | 26003 | 751 | 7 |
1700899 | 1700899 | 2021-09-09 | Alger | Michigan | 26003 | 738 | 7 |
1697650 | 1697650 | 2021-09-08 | Alger | Michigan | 26003 | 738 | 7 |
1694402 | 1694402 | 2021-09-07 | Alger | Michigan | 26003 | 730 | 7 |
1691153 | 1691153 | 2021-09-06 | Alger | Michigan | 26003 | 719 | 7 |
1687903 | 1687903 | 2021-09-05 | Alger | Michigan | 26003 | 719 | 7 |
1684653 | 1684653 | 2021-09-04 | Alger | Michigan | 26003 | 719 | 7 |
1681402 | 1681402 | 2021-09-03 | Alger | Michigan | 26003 | 719 | 7 |
1678154 | 1678154 | 2021-09-02 | Alger | Michigan | 26003 | 714 | 7 |
1674906 | 1674906 | 2021-09-01 | Alger | Michigan | 26003 | 714 | 7 |
1671658 | 1671658 | 2021-08-31 | Alger | Michigan | 26003 | 708 | 7 |
1668411 | 1668411 | 2021-08-30 | Alger | Michigan | 26003 | 708 | 7 |
1665164 | 1665164 | 2021-08-29 | Alger | Michigan | 26003 | 704 | 7 |
1661916 | 1661916 | 2021-08-28 | Alger | Michigan | 26003 | 704 | 7 |
1658668 | 1658668 | 2021-08-27 | Alger | Michigan | 26003 | 704 | 7 |
1655419 | 1655419 | 2021-08-26 | Alger | Michigan | 26003 | 700 | 7 |
1652172 | 1652172 | 2021-08-25 | Alger | Michigan | 26003 | 700 | 7 |
1648924 | 1648924 | 2021-08-24 | Alger | Michigan | 26003 | 690 | 7 |
1645675 | 1645675 | 2021-08-23 | Alger | Michigan | 26003 | 690 | 7 |
1642426 | 1642426 | 2021-08-22 | Alger | Michigan | 26003 | 687 | 7 |
1639176 | 1639176 | 2021-08-21 | Alger | Michigan | 26003 | 687 | 7 |
1635926 | 1635926 | 2021-08-20 | Alger | Michigan | 26003 | 687 | 7 |
1632676 | 1632676 | 2021-08-19 | Alger | Michigan | 26003 | 677 | 7 |
1629429 | 1629429 | 2021-08-18 | Alger | Michigan | 26003 | 677 | 7 |
1626182 | 1626182 | 2021-08-17 | Alger | Michigan | 26003 | 677 | 7 |
1622935 | 1622935 | 2021-08-16 | Alger | Michigan | 26003 | 677 | 7 |
1619688 | 1619688 | 2021-08-15 | Alger | Michigan | 26003 | 675 | 7 |
1616440 | 1616440 | 2021-08-14 | Alger | Michigan | 26003 | 675 | 7 |
1613192 | 1613192 | 2021-08-13 | Alger | Michigan | 26003 | 675 | 7 |
1609943 | 1609943 | 2021-08-12 | Alger | Michigan | 26003 | 672 | 7 |
1606695 | 1606695 | 2021-08-11 | Alger | Michigan | 26003 | 672 | 7 |
1603446 | 1603446 | 2021-08-10 | Alger | Michigan | 26003 | 671 | 7 |
1600197 | 1600197 | 2021-08-09 | Alger | Michigan | 26003 | 671 | 7 |
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);