ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
493 rows where deaths = 34 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Presque Isle 105
- Baraga 48
- Ogemaw 47
- Osceola 26
- Benzie 21
- Antrim 19
- Cheboygan 18
- Emmet 18
- Ontonagon 16
- Houghton 15
- Shiawassee 13
- Lake 12
- Tuscola 10
- Branch 9
- Livingston 8
- Otsego 8
- Barry 7
- Manistee 7
- Oscoda 7
- Roscommon 7
- Wexford 6
- Arenac 5
- Charlevoix 5
- Hillsdale 5
- Missaukee 5
- Mecosta 4
- Clinton 3
- Allegan 2
- Chippewa 2
- Delta 2
- …
state 1
- Michigan · 493 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2292588 | 2292588 | 2022-03-10 | Unknown | Michigan | 11981 | 34 | |
2240524 | 2240524 | 2022-02-22 | Lake | Michigan | 26085 | 1802 | 34 |
2237273 | 2237273 | 2022-02-21 | Lake | Michigan | 26085 | 1802 | 34 |
2234022 | 2234022 | 2022-02-20 | Lake | Michigan | 26085 | 1802 | 34 |
2230771 | 2230771 | 2022-02-19 | Lake | Michigan | 26085 | 1791 | 34 |
2227520 | 2227520 | 2022-02-18 | Lake | Michigan | 26085 | 1791 | 34 |
2224269 | 2224269 | 2022-02-17 | Lake | Michigan | 26085 | 1791 | 34 |
2221018 | 2221018 | 2022-02-16 | Lake | Michigan | 26085 | 1791 | 34 |
2217767 | 2217767 | 2022-02-15 | Lake | Michigan | 26085 | 1788 | 34 |
2214516 | 2214516 | 2022-02-14 | Lake | Michigan | 26085 | 1788 | 34 |
2211264 | 2211264 | 2022-02-13 | Lake | Michigan | 26085 | 1778 | 34 |
2208011 | 2208011 | 2022-02-12 | Lake | Michigan | 26085 | 1778 | 34 |
2204758 | 2204758 | 2022-02-11 | Lake | Michigan | 26085 | 1778 | 34 |
2201528 | 2201528 | 2022-02-10 | Ontonagon | Michigan | 26131 | 945 | 34 |
2198274 | 2198274 | 2022-02-09 | Ontonagon | Michigan | 26131 | 945 | 34 |
2195020 | 2195020 | 2022-02-08 | Ontonagon | Michigan | 26131 | 937 | 34 |
2191766 | 2191766 | 2022-02-07 | Ontonagon | Michigan | 26131 | 937 | 34 |
2188513 | 2188513 | 2022-02-06 | Ontonagon | Michigan | 26131 | 935 | 34 |
2185260 | 2185260 | 2022-02-05 | Ontonagon | Michigan | 26131 | 935 | 34 |
2182008 | 2182008 | 2022-02-04 | Ontonagon | Michigan | 26131 | 935 | 34 |
2178756 | 2178756 | 2022-02-03 | Ontonagon | Michigan | 26131 | 931 | 34 |
2175504 | 2175504 | 2022-02-02 | Ontonagon | Michigan | 26131 | 931 | 34 |
2172251 | 2172251 | 2022-02-01 | Ontonagon | Michigan | 26131 | 926 | 34 |
2168998 | 2168998 | 2022-01-31 | Ontonagon | Michigan | 26131 | 926 | 34 |
2165743 | 2165743 | 2022-01-30 | Ontonagon | Michigan | 26131 | 921 | 34 |
2162488 | 2162488 | 2022-01-29 | Ontonagon | Michigan | 26131 | 921 | 34 |
2159233 | 2159233 | 2022-01-28 | Ontonagon | Michigan | 26131 | 921 | 34 |
2155979 | 2155979 | 2022-01-27 | Ontonagon | Michigan | 26131 | 913 | 34 |
2152726 | 2152726 | 2022-01-26 | Ontonagon | Michigan | 26131 | 913 | 34 |
1967391 | 1967391 | 2021-11-30 | Leelanau | Michigan | 26089 | 2101 | 34 |
1964139 | 1964139 | 2021-11-29 | Leelanau | Michigan | 26089 | 2101 | 34 |
1869850 | 1869850 | 2021-10-31 | Arenac | Michigan | 26011 | 1831 | 34 |
1869859 | 1869859 | 2021-10-31 | Charlevoix | Michigan | 26029 | 2587 | 34 |
1866601 | 1866601 | 2021-10-30 | Arenac | Michigan | 26011 | 1831 | 34 |
1866610 | 1866610 | 2021-10-30 | Charlevoix | Michigan | 26029 | 2587 | 34 |
1863352 | 1863352 | 2021-10-29 | Arenac | Michigan | 26011 | 1831 | 34 |
1863361 | 1863361 | 2021-10-29 | Charlevoix | Michigan | 26029 | 2587 | 34 |
1860103 | 1860103 | 2021-10-28 | Arenac | Michigan | 26011 | 1809 | 34 |
1860112 | 1860112 | 2021-10-28 | Charlevoix | Michigan | 26029 | 2581 | 34 |
1856854 | 1856854 | 2021-10-27 | Arenac | Michigan | 26011 | 1809 | 34 |
1856863 | 1856863 | 2021-10-27 | Charlevoix | Michigan | 26029 | 2572 | 34 |
1853667 | 1853667 | 2021-10-26 | Oscoda | Michigan | 26135 | 948 | 34 |
1850418 | 1850418 | 2021-10-25 | Oscoda | Michigan | 26135 | 948 | 34 |
1847168 | 1847168 | 2021-10-24 | Oscoda | Michigan | 26135 | 942 | 34 |
1843918 | 1843918 | 2021-10-23 | Oscoda | Michigan | 26135 | 942 | 34 |
1840668 | 1840668 | 2021-10-22 | Oscoda | Michigan | 26135 | 942 | 34 |
1837419 | 1837419 | 2021-10-21 | Oscoda | Michigan | 26135 | 923 | 34 |
1834170 | 1834170 | 2021-10-20 | Oscoda | Michigan | 26135 | 923 | 34 |
1830910 | 1830910 | 2021-10-19 | Missaukee | Michigan | 26113 | 1803 | 34 |
1830920 | 1830920 | 2021-10-19 | Osceola | Michigan | 26133 | 2901 | 34 |
1827661 | 1827661 | 2021-10-18 | Missaukee | Michigan | 26113 | 1803 | 34 |
1827671 | 1827671 | 2021-10-18 | Osceola | Michigan | 26133 | 2901 | 34 |
1824406 | 1824406 | 2021-10-17 | Manistee | Michigan | 26101 | 2405 | 34 |
1824412 | 1824412 | 2021-10-17 | Missaukee | Michigan | 26113 | 1792 | 34 |
1824422 | 1824422 | 2021-10-17 | Osceola | Michigan | 26133 | 2836 | 34 |
1821157 | 1821157 | 2021-10-16 | Manistee | Michigan | 26101 | 2405 | 34 |
1821163 | 1821163 | 2021-10-16 | Missaukee | Michigan | 26113 | 1792 | 34 |
1821173 | 1821173 | 2021-10-16 | Osceola | Michigan | 26133 | 2836 | 34 |
1817908 | 1817908 | 2021-10-15 | Manistee | Michigan | 26101 | 2405 | 34 |
1817914 | 1817914 | 2021-10-15 | Missaukee | Michigan | 26113 | 1792 | 34 |
1817924 | 1817924 | 2021-10-15 | Osceola | Michigan | 26133 | 2836 | 34 |
1814659 | 1814659 | 2021-10-14 | Manistee | Michigan | 26101 | 2393 | 34 |
1814675 | 1814675 | 2021-10-14 | Osceola | Michigan | 26133 | 2764 | 34 |
1811411 | 1811411 | 2021-10-13 | Manistee | Michigan | 26101 | 2393 | 34 |
1811427 | 1811427 | 2021-10-13 | Osceola | Michigan | 26133 | 2764 | 34 |
1808162 | 1808162 | 2021-10-12 | Manistee | Michigan | 26101 | 2372 | 34 |
1808178 | 1808178 | 2021-10-12 | Osceola | Michigan | 26133 | 2722 | 34 |
1804911 | 1804911 | 2021-10-11 | Manistee | Michigan | 26101 | 2372 | 34 |
1804927 | 1804927 | 2021-10-11 | Osceola | Michigan | 26133 | 2722 | 34 |
1801678 | 1801678 | 2021-10-10 | Osceola | Michigan | 26133 | 2663 | 34 |
1798429 | 1798429 | 2021-10-09 | Osceola | Michigan | 26133 | 2663 | 34 |
1795180 | 1795180 | 2021-10-08 | Osceola | Michigan | 26133 | 2663 | 34 |
1791931 | 1791931 | 2021-10-07 | Osceola | Michigan | 26133 | 2585 | 34 |
1788682 | 1788682 | 2021-10-06 | Osceola | Michigan | 26133 | 2585 | 34 |
1785434 | 1785434 | 2021-10-05 | Osceola | Michigan | 26133 | 2544 | 34 |
1782185 | 1782185 | 2021-10-04 | Osceola | Michigan | 26133 | 2544 | 34 |
1778873 | 1778873 | 2021-10-03 | Antrim | Michigan | 26009 | 2024 | 34 |
1778935 | 1778935 | 2021-10-03 | Osceola | Michigan | 26133 | 2492 | 34 |
1775623 | 1775623 | 2021-10-02 | Antrim | Michigan | 26009 | 2021 | 34 |
1775685 | 1775685 | 2021-10-02 | Osceola | Michigan | 26133 | 2492 | 34 |
1772373 | 1772373 | 2021-10-01 | Antrim | Michigan | 26009 | 2021 | 34 |
1772435 | 1772435 | 2021-10-01 | Osceola | Michigan | 26133 | 2492 | 34 |
1769124 | 1769124 | 2021-09-30 | Antrim | Michigan | 26009 | 2004 | 34 |
1769186 | 1769186 | 2021-09-30 | Osceola | Michigan | 26133 | 2452 | 34 |
1765875 | 1765875 | 2021-09-29 | Antrim | Michigan | 26009 | 1983 | 34 |
1765937 | 1765937 | 2021-09-29 | Osceola | Michigan | 26133 | 2452 | 34 |
1762626 | 1762626 | 2021-09-28 | Antrim | Michigan | 26009 | 1969 | 34 |
1762688 | 1762688 | 2021-09-28 | Osceola | Michigan | 26133 | 2398 | 34 |
1759377 | 1759377 | 2021-09-27 | Antrim | Michigan | 26009 | 1947 | 34 |
1759439 | 1759439 | 2021-09-27 | Osceola | Michigan | 26133 | 2398 | 34 |
1756129 | 1756129 | 2021-09-26 | Antrim | Michigan | 26009 | 1928 | 34 |
1756191 | 1756191 | 2021-09-26 | Osceola | Michigan | 26133 | 2356 | 34 |
1752881 | 1752881 | 2021-09-25 | Antrim | Michigan | 26009 | 1928 | 34 |
1752943 | 1752943 | 2021-09-25 | Osceola | Michigan | 26133 | 2356 | 34 |
1749633 | 1749633 | 2021-09-24 | Antrim | Michigan | 26009 | 1928 | 34 |
1749695 | 1749695 | 2021-09-24 | Osceola | Michigan | 26133 | 2356 | 34 |
1746383 | 1746383 | 2021-09-23 | Antrim | Michigan | 26009 | 1919 | 34 |
1743134 | 1743134 | 2021-09-22 | Antrim | Michigan | 26009 | 1914 | 34 |
1739885 | 1739885 | 2021-09-21 | Antrim | Michigan | 26009 | 1903 | 34 |
1736636 | 1736636 | 2021-09-20 | Antrim | Michigan | 26009 | 1900 | 34 |
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);