ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,303 rows where deaths = 5 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Crawford 302
- Schoolcraft 300
- Grand Traverse 124
- Ogemaw 66
- Alger 57
- Huron 50
- Sanilac 35
- Unknown 27
- Ionia 26
- Manistee 22
- Oceana 17
- Eaton 14
- Keweenaw 14
- Luce 13
- Presque Isle 13
- St. Joseph 13
- Charlevoix 12
- Antrim 11
- Barry 11
- Baraga 9
- Kalkaska 9
- Montcalm 9
- Arenac 8
- Roscommon 8
- Benzie 7
- Delta 7
- Dickinson 7
- Calhoun 6
- Missaukee 6
- Cass 5
- …
state 1
- Michigan · 1,303 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1905630 | 1905630 | 2021-11-11 | Keweenaw | Michigan | 26083 | 294 | 5 |
1905663 | 1905663 | 2021-11-11 | Schoolcraft | Michigan | 26153 | 905 | 5 |
1902381 | 1902381 | 2021-11-10 | Keweenaw | Michigan | 26083 | 294 | 5 |
1902414 | 1902414 | 2021-11-10 | Schoolcraft | Michigan | 26153 | 905 | 5 |
1899131 | 1899131 | 2021-11-09 | Keweenaw | Michigan | 26083 | 289 | 5 |
1899164 | 1899164 | 2021-11-09 | Schoolcraft | Michigan | 26153 | 882 | 5 |
1895881 | 1895881 | 2021-11-08 | Keweenaw | Michigan | 26083 | 289 | 5 |
1895914 | 1895914 | 2021-11-08 | Schoolcraft | Michigan | 26153 | 882 | 5 |
1892631 | 1892631 | 2021-11-07 | Keweenaw | Michigan | 26083 | 277 | 5 |
1892664 | 1892664 | 2021-11-07 | Schoolcraft | Michigan | 26153 | 862 | 5 |
1889381 | 1889381 | 2021-11-06 | Keweenaw | Michigan | 26083 | 277 | 5 |
1889414 | 1889414 | 2021-11-06 | Schoolcraft | Michigan | 26153 | 862 | 5 |
1886131 | 1886131 | 2021-11-05 | Keweenaw | Michigan | 26083 | 277 | 5 |
1886164 | 1886164 | 2021-11-05 | Schoolcraft | Michigan | 26153 | 862 | 5 |
1882882 | 1882882 | 2021-11-04 | Keweenaw | Michigan | 26083 | 270 | 5 |
1882915 | 1882915 | 2021-11-04 | Schoolcraft | Michigan | 26153 | 845 | 5 |
1879633 | 1879633 | 2021-11-03 | Keweenaw | Michigan | 26083 | 270 | 5 |
1879666 | 1879666 | 2021-11-03 | Schoolcraft | Michigan | 26153 | 845 | 5 |
1876384 | 1876384 | 2021-11-02 | Keweenaw | Michigan | 26083 | 264 | 5 |
1876417 | 1876417 | 2021-11-02 | Schoolcraft | Michigan | 26153 | 827 | 5 |
1873135 | 1873135 | 2021-11-01 | Keweenaw | Michigan | 26083 | 264 | 5 |
1873168 | 1873168 | 2021-11-01 | Schoolcraft | Michigan | 26153 | 827 | 5 |
1869886 | 1869886 | 2021-10-31 | Keweenaw | Michigan | 26083 | 262 | 5 |
1869919 | 1869919 | 2021-10-31 | Schoolcraft | Michigan | 26153 | 816 | 5 |
1866637 | 1866637 | 2021-10-30 | Keweenaw | Michigan | 26083 | 262 | 5 |
1866670 | 1866670 | 2021-10-30 | Schoolcraft | Michigan | 26153 | 816 | 5 |
1863388 | 1863388 | 2021-10-29 | Keweenaw | Michigan | 26083 | 262 | 5 |
1863421 | 1863421 | 2021-10-29 | Schoolcraft | Michigan | 26153 | 816 | 5 |
1860172 | 1860172 | 2021-10-28 | Schoolcraft | Michigan | 26153 | 804 | 5 |
1856923 | 1856923 | 2021-10-27 | Schoolcraft | Michigan | 26153 | 804 | 5 |
1853674 | 1853674 | 2021-10-26 | Schoolcraft | Michigan | 26153 | 798 | 5 |
1850425 | 1850425 | 2021-10-25 | Schoolcraft | Michigan | 26153 | 798 | 5 |
1847175 | 1847175 | 2021-10-24 | Schoolcraft | Michigan | 26153 | 796 | 5 |
1843925 | 1843925 | 2021-10-23 | Schoolcraft | Michigan | 26153 | 796 | 5 |
1840675 | 1840675 | 2021-10-22 | Schoolcraft | Michigan | 26153 | 796 | 5 |
1837426 | 1837426 | 2021-10-21 | Schoolcraft | Michigan | 26153 | 779 | 5 |
1834177 | 1834177 | 2021-10-20 | Schoolcraft | Michigan | 26153 | 779 | 5 |
1830928 | 1830928 | 2021-10-19 | Schoolcraft | Michigan | 26153 | 764 | 5 |
1827679 | 1827679 | 2021-10-18 | Schoolcraft | Michigan | 26153 | 764 | 5 |
1824430 | 1824430 | 2021-10-17 | Schoolcraft | Michigan | 26153 | 753 | 5 |
1821181 | 1821181 | 2021-10-16 | Schoolcraft | Michigan | 26153 | 753 | 5 |
1817932 | 1817932 | 2021-10-15 | Schoolcraft | Michigan | 26153 | 753 | 5 |
1814683 | 1814683 | 2021-10-14 | Schoolcraft | Michigan | 26153 | 735 | 5 |
1811435 | 1811435 | 2021-10-13 | Schoolcraft | Michigan | 26153 | 735 | 5 |
1808186 | 1808186 | 2021-10-12 | Schoolcraft | Michigan | 26153 | 723 | 5 |
1804935 | 1804935 | 2021-10-11 | Schoolcraft | Michigan | 26153 | 723 | 5 |
1801686 | 1801686 | 2021-10-10 | Schoolcraft | Michigan | 26153 | 706 | 5 |
1798437 | 1798437 | 2021-10-09 | Schoolcraft | Michigan | 26153 | 706 | 5 |
1795188 | 1795188 | 2021-10-08 | Schoolcraft | Michigan | 26153 | 706 | 5 |
1791939 | 1791939 | 2021-10-07 | Schoolcraft | Michigan | 26153 | 692 | 5 |
1788690 | 1788690 | 2021-10-06 | Schoolcraft | Michigan | 26153 | 692 | 5 |
1785442 | 1785442 | 2021-10-05 | Schoolcraft | Michigan | 26153 | 668 | 5 |
1782193 | 1782193 | 2021-10-04 | Schoolcraft | Michigan | 26153 | 668 | 5 |
1778943 | 1778943 | 2021-10-03 | Schoolcraft | Michigan | 26153 | 649 | 5 |
1775693 | 1775693 | 2021-10-02 | Schoolcraft | Michigan | 26153 | 649 | 5 |
1772443 | 1772443 | 2021-10-01 | Schoolcraft | Michigan | 26153 | 649 | 5 |
1769194 | 1769194 | 2021-09-30 | Schoolcraft | Michigan | 26153 | 621 | 5 |
1765945 | 1765945 | 2021-09-29 | Schoolcraft | Michigan | 26153 | 621 | 5 |
1762696 | 1762696 | 2021-09-28 | Schoolcraft | Michigan | 26153 | 590 | 5 |
1759447 | 1759447 | 2021-09-27 | Schoolcraft | Michigan | 26153 | 590 | 5 |
1756173 | 1756173 | 2021-09-26 | Mackinac | Michigan | 26097 | 964 | 5 |
1756199 | 1756199 | 2021-09-26 | Schoolcraft | Michigan | 26153 | 585 | 5 |
1752925 | 1752925 | 2021-09-25 | Mackinac | Michigan | 26097 | 964 | 5 |
1752951 | 1752951 | 2021-09-25 | Schoolcraft | Michigan | 26153 | 585 | 5 |
1749677 | 1749677 | 2021-09-24 | Mackinac | Michigan | 26097 | 964 | 5 |
1749703 | 1749703 | 2021-09-24 | Schoolcraft | Michigan | 26153 | 585 | 5 |
1746427 | 1746427 | 2021-09-23 | Mackinac | Michigan | 26097 | 934 | 5 |
1746453 | 1746453 | 2021-09-23 | Schoolcraft | Michigan | 26153 | 563 | 5 |
1743178 | 1743178 | 2021-09-22 | Mackinac | Michigan | 26097 | 934 | 5 |
1743204 | 1743204 | 2021-09-22 | Schoolcraft | Michigan | 26153 | 563 | 5 |
1739955 | 1739955 | 2021-09-21 | Schoolcraft | Michigan | 26153 | 544 | 5 |
1736706 | 1736706 | 2021-09-20 | Schoolcraft | Michigan | 26153 | 544 | 5 |
1733456 | 1733456 | 2021-09-19 | Schoolcraft | Michigan | 26153 | 540 | 5 |
1730206 | 1730206 | 2021-09-18 | Schoolcraft | Michigan | 26153 | 540 | 5 |
1726956 | 1726956 | 2021-09-17 | Schoolcraft | Michigan | 26153 | 540 | 5 |
1723707 | 1723707 | 2021-09-16 | Schoolcraft | Michigan | 26153 | 533 | 5 |
1720458 | 1720458 | 2021-09-15 | Schoolcraft | Michigan | 26153 | 533 | 5 |
1717210 | 1717210 | 2021-09-14 | Schoolcraft | Michigan | 26153 | 525 | 5 |
1713962 | 1713962 | 2021-09-13 | Schoolcraft | Michigan | 26153 | 525 | 5 |
1710716 | 1710716 | 2021-09-12 | Schoolcraft | Michigan | 26153 | 519 | 5 |
1707469 | 1707469 | 2021-09-11 | Schoolcraft | Michigan | 26153 | 519 | 5 |
1704222 | 1704222 | 2021-09-10 | Schoolcraft | Michigan | 26153 | 519 | 5 |
1700972 | 1700972 | 2021-09-09 | Schoolcraft | Michigan | 26153 | 515 | 5 |
1697723 | 1697723 | 2021-09-08 | Schoolcraft | Michigan | 26153 | 515 | 5 |
1694475 | 1694475 | 2021-09-07 | Schoolcraft | Michigan | 26153 | 509 | 5 |
1691226 | 1691226 | 2021-09-06 | Schoolcraft | Michigan | 26153 | 502 | 5 |
1687976 | 1687976 | 2021-09-05 | Schoolcraft | Michigan | 26153 | 502 | 5 |
1684726 | 1684726 | 2021-09-04 | Schoolcraft | Michigan | 26153 | 502 | 5 |
1681475 | 1681475 | 2021-09-03 | Schoolcraft | Michigan | 26153 | 502 | 5 |
1678227 | 1678227 | 2021-09-02 | Schoolcraft | Michigan | 26153 | 493 | 5 |
1674979 | 1674979 | 2021-09-01 | Schoolcraft | Michigan | 26153 | 493 | 5 |
1671731 | 1671731 | 2021-08-31 | Schoolcraft | Michigan | 26153 | 485 | 5 |
1668484 | 1668484 | 2021-08-30 | Schoolcraft | Michigan | 26153 | 485 | 5 |
1665237 | 1665237 | 2021-08-29 | Schoolcraft | Michigan | 26153 | 480 | 5 |
1661989 | 1661989 | 2021-08-28 | Schoolcraft | Michigan | 26153 | 480 | 5 |
1658741 | 1658741 | 2021-08-27 | Schoolcraft | Michigan | 26153 | 480 | 5 |
1655492 | 1655492 | 2021-08-26 | Schoolcraft | Michigan | 26153 | 478 | 5 |
1652245 | 1652245 | 2021-08-25 | Schoolcraft | Michigan | 26153 | 478 | 5 |
1648997 | 1648997 | 2021-08-24 | Schoolcraft | Michigan | 26153 | 467 | 5 |
1645748 | 1645748 | 2021-08-23 | Schoolcraft | Michigan | 26153 | 467 | 5 |
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);