ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Leelanau" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175483 | 2175483 | 2022-02-02 | Leelanau | Michigan | 26089 | 3378 | 46 |
2172230 | 2172230 | 2022-02-01 | Leelanau | Michigan | 26089 | 3341 | 44 |
2168977 | 2168977 | 2022-01-31 | Leelanau | Michigan | 26089 | 3341 | 44 |
2165722 | 2165722 | 2022-01-30 | Leelanau | Michigan | 26089 | 3315 | 44 |
2162467 | 2162467 | 2022-01-29 | Leelanau | Michigan | 26089 | 3315 | 44 |
2159212 | 2159212 | 2022-01-28 | Leelanau | Michigan | 26089 | 3315 | 44 |
2155958 | 2155958 | 2022-01-27 | Leelanau | Michigan | 26089 | 3278 | 44 |
2152705 | 2152705 | 2022-01-26 | Leelanau | Michigan | 26089 | 3278 | 44 |
2149453 | 2149453 | 2022-01-25 | Leelanau | Michigan | 26089 | 3206 | 44 |
2146201 | 2146201 | 2022-01-24 | Leelanau | Michigan | 26089 | 3206 | 44 |
2142946 | 2142946 | 2022-01-23 | Leelanau | Michigan | 26089 | 3146 | 44 |
2139691 | 2139691 | 2022-01-22 | Leelanau | Michigan | 26089 | 3146 | 44 |
2136435 | 2136435 | 2022-01-21 | Leelanau | Michigan | 26089 | 3146 | 44 |
2133183 | 2133183 | 2022-01-20 | Leelanau | Michigan | 26089 | 3061 | 44 |
2129930 | 2129930 | 2022-01-19 | Leelanau | Michigan | 26089 | 3061 | 44 |
2126676 | 2126676 | 2022-01-18 | Leelanau | Michigan | 26089 | 2890 | 43 |
2123424 | 2123424 | 2022-01-17 | Leelanau | Michigan | 26089 | 2890 | 43 |
2120172 | 2120172 | 2022-01-16 | Leelanau | Michigan | 26089 | 2890 | 43 |
2116920 | 2116920 | 2022-01-15 | Leelanau | Michigan | 26089 | 2890 | 43 |
2113669 | 2113669 | 2022-01-14 | Leelanau | Michigan | 26089 | 2890 | 43 |
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 |
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);