ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 26089 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110417 | 2110417 | 2022-01-13 | Leelanau | Michigan | 26089 | 2834 | 42 |
2107166 | 2107166 | 2022-01-12 | Leelanau | Michigan | 26089 | 2834 | 42 |
2103915 | 2103915 | 2022-01-11 | Leelanau | Michigan | 26089 | 2749 | 42 |
2100664 | 2100664 | 2022-01-10 | Leelanau | Michigan | 26089 | 2749 | 42 |
2097413 | 2097413 | 2022-01-09 | Leelanau | Michigan | 26089 | 2685 | 42 |
2094161 | 2094161 | 2022-01-08 | Leelanau | Michigan | 26089 | 2685 | 42 |
2090909 | 2090909 | 2022-01-07 | Leelanau | Michigan | 26089 | 2685 | 42 |
2087658 | 2087658 | 2022-01-06 | Leelanau | Michigan | 26089 | 2622 | 42 |
2084406 | 2084406 | 2022-01-05 | Leelanau | Michigan | 26089 | 2622 | 42 |
2081154 | 2081154 | 2022-01-04 | Leelanau | Michigan | 26089 | 2560 | 41 |
2077902 | 2077902 | 2022-01-03 | Leelanau | Michigan | 26089 | 2560 | 41 |
2074651 | 2074651 | 2022-01-02 | Leelanau | Michigan | 26089 | 2509 | 41 |
2071400 | 2071400 | 2022-01-01 | Leelanau | Michigan | 26089 | 2509 | 41 |
2068149 | 2068149 | 2021-12-31 | Leelanau | Michigan | 26089 | 2509 | 41 |
2064898 | 2064898 | 2021-12-30 | Leelanau | Michigan | 26089 | 2509 | 41 |
2061648 | 2061648 | 2021-12-29 | Leelanau | Michigan | 26089 | 2509 | 41 |
2058399 | 2058399 | 2021-12-28 | Leelanau | Michigan | 26089 | 2461 | 41 |
2055150 | 2055150 | 2021-12-27 | Leelanau | Michigan | 26089 | 2461 | 41 |
2051900 | 2051900 | 2021-12-26 | Leelanau | Michigan | 26089 | 2431 | 41 |
2048650 | 2048650 | 2021-12-25 | Leelanau | Michigan | 26089 | 2431 | 41 |
2045400 | 2045400 | 2021-12-24 | Leelanau | Michigan | 26089 | 2431 | 41 |
2042150 | 2042150 | 2021-12-23 | Leelanau | Michigan | 26089 | 2431 | 41 |
2038901 | 2038901 | 2021-12-22 | Leelanau | Michigan | 26089 | 2431 | 41 |
2035651 | 2035651 | 2021-12-21 | Leelanau | Michigan | 26089 | 2417 | 41 |
2032401 | 2032401 | 2021-12-20 | Leelanau | Michigan | 26089 | 2417 | 41 |
2029150 | 2029150 | 2021-12-19 | Leelanau | Michigan | 26089 | 2389 | 39 |
2025899 | 2025899 | 2021-12-18 | Leelanau | Michigan | 26089 | 2389 | 39 |
2022648 | 2022648 | 2021-12-17 | Leelanau | Michigan | 26089 | 2389 | 39 |
2019397 | 2019397 | 2021-12-16 | Leelanau | Michigan | 26089 | 2373 | 38 |
2016147 | 2016147 | 2021-12-15 | Leelanau | Michigan | 26089 | 2373 | 38 |
2012896 | 2012896 | 2021-12-14 | Leelanau | Michigan | 26089 | 2353 | 37 |
2009645 | 2009645 | 2021-12-13 | Leelanau | Michigan | 26089 | 2353 | 37 |
2006394 | 2006394 | 2021-12-12 | Leelanau | Michigan | 26089 | 2326 | 37 |
2003143 | 2003143 | 2021-12-11 | Leelanau | Michigan | 26089 | 2326 | 37 |
1999893 | 1999893 | 2021-12-10 | Leelanau | Michigan | 26089 | 2326 | 37 |
1996642 | 1996642 | 2021-12-09 | Leelanau | Michigan | 26089 | 2301 | 36 |
1993391 | 1993391 | 2021-12-08 | Leelanau | Michigan | 26089 | 2301 | 36 |
1990140 | 1990140 | 2021-12-07 | Leelanau | Michigan | 26089 | 2248 | 36 |
1986890 | 1986890 | 2021-12-06 | Leelanau | Michigan | 26089 | 2248 | 36 |
1983640 | 1983640 | 2021-12-05 | Leelanau | Michigan | 26089 | 2223 | 35 |
1980390 | 1980390 | 2021-12-04 | Leelanau | Michigan | 26089 | 2223 | 35 |
1977140 | 1977140 | 2021-12-03 | Leelanau | Michigan | 26089 | 2223 | 35 |
1973890 | 1973890 | 2021-12-02 | Leelanau | Michigan | 26089 | 2157 | 35 |
1970641 | 1970641 | 2021-12-01 | Leelanau | Michigan | 26089 | 2157 | 35 |
1967391 | 1967391 | 2021-11-30 | Leelanau | Michigan | 26089 | 2101 | 34 |
1964139 | 1964139 | 2021-11-29 | Leelanau | Michigan | 26089 | 2101 | 34 |
1960888 | 1960888 | 2021-11-28 | Leelanau | Michigan | 26089 | 2055 | 32 |
1957637 | 1957637 | 2021-11-27 | Leelanau | Michigan | 26089 | 2055 | 32 |
1954386 | 1954386 | 2021-11-26 | Leelanau | Michigan | 26089 | 2055 | 32 |
1951135 | 1951135 | 2021-11-25 | Leelanau | Michigan | 26089 | 2055 | 32 |
1947884 | 1947884 | 2021-11-24 | Leelanau | Michigan | 26089 | 2055 | 32 |
1944633 | 1944633 | 2021-11-23 | Leelanau | Michigan | 26089 | 1996 | 30 |
1941382 | 1941382 | 2021-11-22 | Leelanau | Michigan | 26089 | 1996 | 30 |
1938132 | 1938132 | 2021-11-21 | Leelanau | Michigan | 26089 | 1956 | 29 |
1934882 | 1934882 | 2021-11-20 | Leelanau | Michigan | 26089 | 1956 | 29 |
1931632 | 1931632 | 2021-11-19 | Leelanau | Michigan | 26089 | 1956 | 29 |
1928381 | 1928381 | 2021-11-18 | Leelanau | Michigan | 26089 | 1916 | 27 |
1925131 | 1925131 | 2021-11-17 | Leelanau | Michigan | 26089 | 1916 | 27 |
1921882 | 1921882 | 2021-11-16 | Leelanau | Michigan | 26089 | 1874 | 26 |
1918632 | 1918632 | 2021-11-15 | Leelanau | Michigan | 26089 | 1874 | 26 |
1915382 | 1915382 | 2021-11-14 | Leelanau | Michigan | 26089 | 1826 | 26 |
1912132 | 1912132 | 2021-11-13 | Leelanau | Michigan | 26089 | 1826 | 26 |
1908882 | 1908882 | 2021-11-12 | Leelanau | Michigan | 26089 | 1826 | 26 |
1905633 | 1905633 | 2021-11-11 | Leelanau | Michigan | 26089 | 1792 | 26 |
1902384 | 1902384 | 2021-11-10 | Leelanau | Michigan | 26089 | 1792 | 26 |
1899134 | 1899134 | 2021-11-09 | Leelanau | Michigan | 26089 | 1755 | 25 |
1895884 | 1895884 | 2021-11-08 | Leelanau | Michigan | 26089 | 1755 | 25 |
1892634 | 1892634 | 2021-11-07 | Leelanau | Michigan | 26089 | 1730 | 26 |
1889384 | 1889384 | 2021-11-06 | Leelanau | Michigan | 26089 | 1730 | 26 |
1886134 | 1886134 | 2021-11-05 | Leelanau | Michigan | 26089 | 1730 | 26 |
1882885 | 1882885 | 2021-11-04 | Leelanau | Michigan | 26089 | 1705 | 26 |
1879636 | 1879636 | 2021-11-03 | Leelanau | Michigan | 26089 | 1705 | 26 |
1876387 | 1876387 | 2021-11-02 | Leelanau | Michigan | 26089 | 1674 | 26 |
1873138 | 1873138 | 2021-11-01 | Leelanau | Michigan | 26089 | 1674 | 26 |
1869889 | 1869889 | 2021-10-31 | Leelanau | Michigan | 26089 | 1650 | 25 |
1866640 | 1866640 | 2021-10-30 | Leelanau | Michigan | 26089 | 1650 | 25 |
1863391 | 1863391 | 2021-10-29 | Leelanau | Michigan | 26089 | 1650 | 25 |
1860142 | 1860142 | 2021-10-28 | Leelanau | Michigan | 26089 | 1640 | 25 |
1856893 | 1856893 | 2021-10-27 | Leelanau | Michigan | 26089 | 1640 | 25 |
1853644 | 1853644 | 2021-10-26 | Leelanau | Michigan | 26089 | 1614 | 25 |
1850395 | 1850395 | 2021-10-25 | Leelanau | Michigan | 26089 | 1614 | 25 |
1847145 | 1847145 | 2021-10-24 | Leelanau | Michigan | 26089 | 1599 | 25 |
1843895 | 1843895 | 2021-10-23 | Leelanau | Michigan | 26089 | 1599 | 25 |
1840645 | 1840645 | 2021-10-22 | Leelanau | Michigan | 26089 | 1599 | 25 |
1837396 | 1837396 | 2021-10-21 | Leelanau | Michigan | 26089 | 1595 | 24 |
1834147 | 1834147 | 2021-10-20 | Leelanau | Michigan | 26089 | 1595 | 24 |
1830898 | 1830898 | 2021-10-19 | Leelanau | Michigan | 26089 | 1579 | 24 |
1827649 | 1827649 | 2021-10-18 | Leelanau | Michigan | 26089 | 1579 | 24 |
1824400 | 1824400 | 2021-10-17 | Leelanau | Michigan | 26089 | 1572 | 24 |
1821151 | 1821151 | 2021-10-16 | Leelanau | Michigan | 26089 | 1572 | 24 |
1817902 | 1817902 | 2021-10-15 | Leelanau | Michigan | 26089 | 1572 | 24 |
1814653 | 1814653 | 2021-10-14 | Leelanau | Michigan | 26089 | 1567 | 24 |
1811405 | 1811405 | 2021-10-13 | Leelanau | Michigan | 26089 | 1567 | 24 |
1808156 | 1808156 | 2021-10-12 | Leelanau | Michigan | 26089 | 1558 | 24 |
1804905 | 1804905 | 2021-10-11 | Leelanau | Michigan | 26089 | 1558 | 24 |
1801656 | 1801656 | 2021-10-10 | Leelanau | Michigan | 26089 | 1547 | 24 |
1798407 | 1798407 | 2021-10-09 | Leelanau | Michigan | 26089 | 1547 | 24 |
1795158 | 1795158 | 2021-10-08 | Leelanau | Michigan | 26089 | 1547 | 24 |
1791909 | 1791909 | 2021-10-07 | Leelanau | Michigan | 26089 | 1536 | 24 |
1788660 | 1788660 | 2021-10-06 | Leelanau | Michigan | 26089 | 1536 | 24 |
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);