ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
421 rows where deaths = 22 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Ontonagon 113
- Charlevoix 58
- Lenawee 29
- Leelanau 21
- Osceola 17
- Lake 16
- Unknown 12
- Presque Isle 10
- Monroe 9
- Wexford 8
- Antrim 7
- Clare 7
- Mason 7
- Alcona 6
- Calhoun 6
- Mecosta 6
- Menominee 6
- Branch 5
- Clinton 5
- Hillsdale 5
- Arenac 4
- Crawford 4
- Otsego 4
- Bay 3
- Berrien 3
- Cheboygan 3
- Gogebic 3
- Manistee 3
- Marquette 3
- Cass 2
- …
state 1
- Michigan · 421 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2087633 | 2087633 | 2022-01-06 | Crawford | Michigan | 26039 | 1978 | 22 |
2087662 | 2087662 | 2022-01-06 | Mackinac | Michigan | 26097 | 1766 | 22 |
2084381 | 2084381 | 2022-01-05 | Crawford | Michigan | 26039 | 1978 | 22 |
2084410 | 2084410 | 2022-01-05 | Mackinac | Michigan | 26097 | 1766 | 22 |
2081129 | 2081129 | 2022-01-04 | Crawford | Michigan | 26039 | 1962 | 22 |
2077877 | 2077877 | 2022-01-03 | Crawford | Michigan | 26039 | 1962 | 22 |
2051935 | 2051935 | 2021-12-26 | Unknown | Michigan | 1999 | 22 | |
2048685 | 2048685 | 2021-12-25 | Unknown | Michigan | 2148 | 22 | |
2045435 | 2045435 | 2021-12-24 | Unknown | Michigan | 2148 | 22 | |
2042185 | 2042185 | 2021-12-23 | Unknown | Michigan | 2260 | 22 | |
2038936 | 2038936 | 2021-12-22 | Unknown | Michigan | 2428 | 22 | |
2029185 | 2029185 | 2021-12-19 | Unknown | Michigan | 2079 | 22 | |
2025934 | 2025934 | 2021-12-18 | Unknown | Michigan | 2293 | 22 | |
2022683 | 2022683 | 2021-12-17 | Unknown | Michigan | 2293 | 22 | |
1899132 | 1899132 | 2021-11-09 | Lake | Michigan | 26085 | 1020 | 22 |
1899155 | 1899155 | 2021-11-09 | Ontonagon | Michigan | 26131 | 651 | 22 |
1895882 | 1895882 | 2021-11-08 | Lake | Michigan | 26085 | 1020 | 22 |
1895905 | 1895905 | 2021-11-08 | Ontonagon | Michigan | 26131 | 651 | 22 |
1892632 | 1892632 | 2021-11-07 | Lake | Michigan | 26085 | 1015 | 22 |
1892655 | 1892655 | 2021-11-07 | Ontonagon | Michigan | 26131 | 649 | 22 |
1889382 | 1889382 | 2021-11-06 | Lake | Michigan | 26085 | 1015 | 22 |
1889405 | 1889405 | 2021-11-06 | Ontonagon | Michigan | 26131 | 649 | 22 |
1886132 | 1886132 | 2021-11-05 | Lake | Michigan | 26085 | 1015 | 22 |
1886155 | 1886155 | 2021-11-05 | Ontonagon | Michigan | 26131 | 649 | 22 |
1882883 | 1882883 | 2021-11-04 | Lake | Michigan | 26085 | 1003 | 22 |
1882906 | 1882906 | 2021-11-04 | Ontonagon | Michigan | 26131 | 628 | 22 |
1879634 | 1879634 | 2021-11-03 | Lake | Michigan | 26085 | 1003 | 22 |
1879657 | 1879657 | 2021-11-03 | Ontonagon | Michigan | 26131 | 628 | 22 |
1876385 | 1876385 | 2021-11-02 | Lake | Michigan | 26085 | 993 | 22 |
1876408 | 1876408 | 2021-11-02 | Ontonagon | Michigan | 26131 | 623 | 22 |
1873136 | 1873136 | 2021-11-01 | Lake | Michigan | 26085 | 993 | 22 |
1873159 | 1873159 | 2021-11-01 | Ontonagon | Michigan | 26131 | 623 | 22 |
1869887 | 1869887 | 2021-10-31 | Lake | Michigan | 26085 | 981 | 22 |
1869910 | 1869910 | 2021-10-31 | Ontonagon | Michigan | 26131 | 618 | 22 |
1866638 | 1866638 | 2021-10-30 | Lake | Michigan | 26085 | 981 | 22 |
1866661 | 1866661 | 2021-10-30 | Ontonagon | Michigan | 26131 | 618 | 22 |
1863389 | 1863389 | 2021-10-29 | Lake | Michigan | 26085 | 981 | 22 |
1863412 | 1863412 | 2021-10-29 | Ontonagon | Michigan | 26131 | 618 | 22 |
1860140 | 1860140 | 2021-10-28 | Lake | Michigan | 26085 | 966 | 22 |
1860163 | 1860163 | 2021-10-28 | Ontonagon | Michigan | 26131 | 613 | 22 |
1856891 | 1856891 | 2021-10-27 | Lake | Michigan | 26085 | 966 | 22 |
1856914 | 1856914 | 2021-10-27 | Ontonagon | Michigan | 26131 | 613 | 22 |
1853642 | 1853642 | 2021-10-26 | Lake | Michigan | 26085 | 954 | 22 |
1853665 | 1853665 | 2021-10-26 | Ontonagon | Michigan | 26131 | 612 | 22 |
1850393 | 1850393 | 2021-10-25 | Lake | Michigan | 26085 | 954 | 22 |
1850416 | 1850416 | 2021-10-25 | Ontonagon | Michigan | 26131 | 612 | 22 |
1847166 | 1847166 | 2021-10-24 | Ontonagon | Michigan | 26131 | 602 | 22 |
1843916 | 1843916 | 2021-10-23 | Ontonagon | Michigan | 26131 | 602 | 22 |
1840666 | 1840666 | 2021-10-22 | Ontonagon | Michigan | 26131 | 602 | 22 |
1837417 | 1837417 | 2021-10-21 | Ontonagon | Michigan | 26131 | 600 | 22 |
1834168 | 1834168 | 2021-10-20 | Ontonagon | Michigan | 26131 | 600 | 22 |
1830919 | 1830919 | 2021-10-19 | Ontonagon | Michigan | 26131 | 596 | 22 |
1827670 | 1827670 | 2021-10-18 | Ontonagon | Michigan | 26131 | 596 | 22 |
1824421 | 1824421 | 2021-10-17 | Ontonagon | Michigan | 26131 | 593 | 22 |
1821172 | 1821172 | 2021-10-16 | Ontonagon | Michigan | 26131 | 593 | 22 |
1817923 | 1817923 | 2021-10-15 | Ontonagon | Michigan | 26131 | 593 | 22 |
1814674 | 1814674 | 2021-10-14 | Ontonagon | Michigan | 26131 | 590 | 22 |
1811426 | 1811426 | 2021-10-13 | Ontonagon | Michigan | 26131 | 590 | 22 |
1808177 | 1808177 | 2021-10-12 | Ontonagon | Michigan | 26131 | 585 | 22 |
1804926 | 1804926 | 2021-10-11 | Ontonagon | Michigan | 26131 | 585 | 22 |
1801677 | 1801677 | 2021-10-10 | Ontonagon | Michigan | 26131 | 583 | 22 |
1798428 | 1798428 | 2021-10-09 | Ontonagon | Michigan | 26131 | 583 | 22 |
1795179 | 1795179 | 2021-10-08 | Ontonagon | Michigan | 26131 | 583 | 22 |
1791930 | 1791930 | 2021-10-07 | Ontonagon | Michigan | 26131 | 578 | 22 |
1788681 | 1788681 | 2021-10-06 | Ontonagon | Michigan | 26131 | 578 | 22 |
1785433 | 1785433 | 2021-10-05 | Ontonagon | Michigan | 26131 | 572 | 22 |
1782184 | 1782184 | 2021-10-04 | Ontonagon | Michigan | 26131 | 572 | 22 |
1778913 | 1778913 | 2021-10-03 | Leelanau | Michigan | 26089 | 1502 | 22 |
1778934 | 1778934 | 2021-10-03 | Ontonagon | Michigan | 26131 | 570 | 22 |
1775663 | 1775663 | 2021-10-02 | Leelanau | Michigan | 26089 | 1502 | 22 |
1775684 | 1775684 | 2021-10-02 | Ontonagon | Michigan | 26131 | 570 | 22 |
1772413 | 1772413 | 2021-10-01 | Leelanau | Michigan | 26089 | 1502 | 22 |
1772434 | 1772434 | 2021-10-01 | Ontonagon | Michigan | 26131 | 570 | 22 |
1769164 | 1769164 | 2021-09-30 | Leelanau | Michigan | 26089 | 1495 | 22 |
1769185 | 1769185 | 2021-09-30 | Ontonagon | Michigan | 26131 | 569 | 22 |
1765915 | 1765915 | 2021-09-29 | Leelanau | Michigan | 26089 | 1495 | 22 |
1765936 | 1765936 | 2021-09-29 | Ontonagon | Michigan | 26131 | 569 | 22 |
1762666 | 1762666 | 2021-09-28 | Leelanau | Michigan | 26089 | 1484 | 22 |
1762687 | 1762687 | 2021-09-28 | Ontonagon | Michigan | 26131 | 567 | 22 |
1759417 | 1759417 | 2021-09-27 | Leelanau | Michigan | 26089 | 1484 | 22 |
1759438 | 1759438 | 2021-09-27 | Ontonagon | Michigan | 26131 | 567 | 22 |
1756169 | 1756169 | 2021-09-26 | Leelanau | Michigan | 26089 | 1473 | 22 |
1756190 | 1756190 | 2021-09-26 | Ontonagon | Michigan | 26131 | 564 | 22 |
1752921 | 1752921 | 2021-09-25 | Leelanau | Michigan | 26089 | 1473 | 22 |
1752942 | 1752942 | 2021-09-25 | Ontonagon | Michigan | 26131 | 564 | 22 |
1749673 | 1749673 | 2021-09-24 | Leelanau | Michigan | 26089 | 1473 | 22 |
1749694 | 1749694 | 2021-09-24 | Ontonagon | Michigan | 26131 | 564 | 22 |
1746423 | 1746423 | 2021-09-23 | Leelanau | Michigan | 26089 | 1460 | 22 |
1746438 | 1746438 | 2021-09-23 | Montmorency | Michigan | 26119 | 740 | 22 |
1746444 | 1746444 | 2021-09-23 | Ontonagon | Michigan | 26131 | 560 | 22 |
1743174 | 1743174 | 2021-09-22 | Leelanau | Michigan | 26089 | 1460 | 22 |
1743189 | 1743189 | 2021-09-22 | Montmorency | Michigan | 26119 | 740 | 22 |
1743195 | 1743195 | 2021-09-22 | Ontonagon | Michigan | 26131 | 560 | 22 |
1739925 | 1739925 | 2021-09-21 | Leelanau | Michigan | 26089 | 1440 | 22 |
1739946 | 1739946 | 2021-09-21 | Ontonagon | Michigan | 26131 | 559 | 22 |
1736676 | 1736676 | 2021-09-20 | Leelanau | Michigan | 26089 | 1440 | 22 |
1736697 | 1736697 | 2021-09-20 | Ontonagon | Michigan | 26131 | 559 | 22 |
1733426 | 1733426 | 2021-09-19 | Leelanau | Michigan | 26089 | 1430 | 22 |
1733447 | 1733447 | 2021-09-19 | Ontonagon | Michigan | 26131 | 557 | 22 |
1730176 | 1730176 | 2021-09-18 | Leelanau | Michigan | 26089 | 1430 | 22 |
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);