ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Lake" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175481 | 2175481 | 2022-02-02 | Lake | Michigan | 26085 | 1718 | 33 |
2172228 | 2172228 | 2022-02-01 | Lake | Michigan | 26085 | 1687 | 33 |
2168975 | 2168975 | 2022-01-31 | Lake | Michigan | 26085 | 1687 | 33 |
2165720 | 2165720 | 2022-01-30 | Lake | Michigan | 26085 | 1664 | 33 |
2162465 | 2162465 | 2022-01-29 | Lake | Michigan | 26085 | 1664 | 33 |
2159210 | 2159210 | 2022-01-28 | Lake | Michigan | 26085 | 1664 | 33 |
2155956 | 2155956 | 2022-01-27 | Lake | Michigan | 26085 | 1636 | 33 |
2152703 | 2152703 | 2022-01-26 | Lake | Michigan | 26085 | 1636 | 33 |
2149451 | 2149451 | 2022-01-25 | Lake | Michigan | 26085 | 1613 | 33 |
2146199 | 2146199 | 2022-01-24 | Lake | Michigan | 26085 | 1613 | 33 |
2142944 | 2142944 | 2022-01-23 | Lake | Michigan | 26085 | 1571 | 33 |
2139689 | 2139689 | 2022-01-22 | Lake | Michigan | 26085 | 1571 | 33 |
2136433 | 2136433 | 2022-01-21 | Lake | Michigan | 26085 | 1571 | 33 |
2133181 | 2133181 | 2022-01-20 | Lake | Michigan | 26085 | 1548 | 33 |
2129928 | 2129928 | 2022-01-19 | Lake | Michigan | 26085 | 1548 | 33 |
2126674 | 2126674 | 2022-01-18 | Lake | Michigan | 26085 | 1492 | 32 |
2123422 | 2123422 | 2022-01-17 | Lake | Michigan | 26085 | 1492 | 32 |
2120170 | 2120170 | 2022-01-16 | Lake | Michigan | 26085 | 1492 | 32 |
2116918 | 2116918 | 2022-01-15 | Lake | Michigan | 26085 | 1492 | 32 |
2113667 | 2113667 | 2022-01-14 | Lake | Michigan | 26085 | 1492 | 32 |
2110415 | 2110415 | 2022-01-13 | Lake | Michigan | 26085 | 1477 | 32 |
2107164 | 2107164 | 2022-01-12 | Lake | Michigan | 26085 | 1477 | 32 |
2103913 | 2103913 | 2022-01-11 | Lake | Michigan | 26085 | 1466 | 31 |
2100662 | 2100662 | 2022-01-10 | Lake | Michigan | 26085 | 1466 | 31 |
2097411 | 2097411 | 2022-01-09 | Lake | Michigan | 26085 | 1451 | 31 |
2094159 | 2094159 | 2022-01-08 | Lake | Michigan | 26085 | 1451 | 31 |
2090907 | 2090907 | 2022-01-07 | Lake | Michigan | 26085 | 1451 | 31 |
2087656 | 2087656 | 2022-01-06 | Lake | Michigan | 26085 | 1436 | 31 |
2084404 | 2084404 | 2022-01-05 | Lake | Michigan | 26085 | 1436 | 31 |
2081152 | 2081152 | 2022-01-04 | Lake | Michigan | 26085 | 1432 | 31 |
2077900 | 2077900 | 2022-01-03 | Lake | Michigan | 26085 | 1432 | 31 |
2074649 | 2074649 | 2022-01-02 | Lake | Michigan | 26085 | 1403 | 31 |
2071398 | 2071398 | 2022-01-01 | Lake | Michigan | 26085 | 1403 | 31 |
2068147 | 2068147 | 2021-12-31 | Lake | Michigan | 26085 | 1403 | 31 |
2064896 | 2064896 | 2021-12-30 | Lake | Michigan | 26085 | 1403 | 31 |
2061646 | 2061646 | 2021-12-29 | Lake | Michigan | 26085 | 1403 | 31 |
2058397 | 2058397 | 2021-12-28 | Lake | Michigan | 26085 | 1391 | 31 |
2055148 | 2055148 | 2021-12-27 | Lake | Michigan | 26085 | 1391 | 31 |
2051898 | 2051898 | 2021-12-26 | Lake | Michigan | 26085 | 1372 | 31 |
2048648 | 2048648 | 2021-12-25 | Lake | Michigan | 26085 | 1372 | 31 |
2045398 | 2045398 | 2021-12-24 | Lake | Michigan | 26085 | 1372 | 31 |
2042148 | 2042148 | 2021-12-23 | Lake | Michigan | 26085 | 1372 | 31 |
2038899 | 2038899 | 2021-12-22 | Lake | Michigan | 26085 | 1372 | 31 |
2035649 | 2035649 | 2021-12-21 | Lake | Michigan | 26085 | 1360 | 30 |
2032399 | 2032399 | 2021-12-20 | Lake | Michigan | 26085 | 1360 | 30 |
2029148 | 2029148 | 2021-12-19 | Lake | Michigan | 26085 | 1347 | 30 |
2025897 | 2025897 | 2021-12-18 | Lake | Michigan | 26085 | 1347 | 30 |
2022646 | 2022646 | 2021-12-17 | Lake | Michigan | 26085 | 1347 | 30 |
2019395 | 2019395 | 2021-12-16 | Lake | Michigan | 26085 | 1332 | 29 |
2016145 | 2016145 | 2021-12-15 | Lake | Michigan | 26085 | 1332 | 29 |
2012894 | 2012894 | 2021-12-14 | Lake | Michigan | 26085 | 1323 | 28 |
2009643 | 2009643 | 2021-12-13 | Lake | Michigan | 26085 | 1323 | 28 |
2006392 | 2006392 | 2021-12-12 | Lake | Michigan | 26085 | 1300 | 28 |
2003141 | 2003141 | 2021-12-11 | Lake | Michigan | 26085 | 1300 | 28 |
1999891 | 1999891 | 2021-12-10 | Lake | Michigan | 26085 | 1300 | 28 |
1996640 | 1996640 | 2021-12-09 | Lake | Michigan | 26085 | 1279 | 28 |
1993389 | 1993389 | 2021-12-08 | Lake | Michigan | 26085 | 1279 | 28 |
1990138 | 1990138 | 2021-12-07 | Lake | Michigan | 26085 | 1253 | 27 |
1986888 | 1986888 | 2021-12-06 | Lake | Michigan | 26085 | 1253 | 27 |
1983638 | 1983638 | 2021-12-05 | Lake | Michigan | 26085 | 1225 | 27 |
1980388 | 1980388 | 2021-12-04 | Lake | Michigan | 26085 | 1225 | 27 |
1977138 | 1977138 | 2021-12-03 | Lake | Michigan | 26085 | 1225 | 27 |
1973888 | 1973888 | 2021-12-02 | Lake | Michigan | 26085 | 1206 | 27 |
1970639 | 1970639 | 2021-12-01 | Lake | Michigan | 26085 | 1206 | 27 |
1967389 | 1967389 | 2021-11-30 | Lake | Michigan | 26085 | 1182 | 25 |
1964137 | 1964137 | 2021-11-29 | Lake | Michigan | 26085 | 1182 | 25 |
1960886 | 1960886 | 2021-11-28 | Lake | Michigan | 26085 | 1154 | 25 |
1957635 | 1957635 | 2021-11-27 | Lake | Michigan | 26085 | 1154 | 25 |
1954384 | 1954384 | 2021-11-26 | Lake | Michigan | 26085 | 1154 | 25 |
1951133 | 1951133 | 2021-11-25 | Lake | Michigan | 26085 | 1154 | 25 |
1947882 | 1947882 | 2021-11-24 | Lake | Michigan | 26085 | 1154 | 25 |
1944631 | 1944631 | 2021-11-23 | Lake | Michigan | 26085 | 1136 | 24 |
1941380 | 1941380 | 2021-11-22 | Lake | Michigan | 26085 | 1136 | 24 |
1938130 | 1938130 | 2021-11-21 | Lake | Michigan | 26085 | 1120 | 24 |
1934880 | 1934880 | 2021-11-20 | Lake | Michigan | 26085 | 1120 | 24 |
1931630 | 1931630 | 2021-11-19 | Lake | Michigan | 26085 | 1120 | 24 |
1928379 | 1928379 | 2021-11-18 | Lake | Michigan | 26085 | 1089 | 24 |
1925129 | 1925129 | 2021-11-17 | Lake | Michigan | 26085 | 1089 | 24 |
1921880 | 1921880 | 2021-11-16 | Lake | Michigan | 26085 | 1072 | 24 |
1918630 | 1918630 | 2021-11-15 | Lake | Michigan | 26085 | 1072 | 24 |
1915380 | 1915380 | 2021-11-14 | Lake | Michigan | 26085 | 1045 | 24 |
1912130 | 1912130 | 2021-11-13 | Lake | Michigan | 26085 | 1045 | 24 |
1908880 | 1908880 | 2021-11-12 | Lake | Michigan | 26085 | 1045 | 24 |
1905631 | 1905631 | 2021-11-11 | Lake | Michigan | 26085 | 1027 | 24 |
1902382 | 1902382 | 2021-11-10 | Lake | Michigan | 26085 | 1027 | 24 |
1899132 | 1899132 | 2021-11-09 | Lake | Michigan | 26085 | 1020 | 22 |
1895882 | 1895882 | 2021-11-08 | Lake | Michigan | 26085 | 1020 | 22 |
1892632 | 1892632 | 2021-11-07 | Lake | Michigan | 26085 | 1015 | 22 |
1889382 | 1889382 | 2021-11-06 | Lake | Michigan | 26085 | 1015 | 22 |
1886132 | 1886132 | 2021-11-05 | Lake | Michigan | 26085 | 1015 | 22 |
1882883 | 1882883 | 2021-11-04 | Lake | Michigan | 26085 | 1003 | 22 |
1879634 | 1879634 | 2021-11-03 | Lake | Michigan | 26085 | 1003 | 22 |
1876385 | 1876385 | 2021-11-02 | Lake | Michigan | 26085 | 993 | 22 |
1873136 | 1873136 | 2021-11-01 | Lake | Michigan | 26085 | 993 | 22 |
1869887 | 1869887 | 2021-10-31 | Lake | Michigan | 26085 | 981 | 22 |
1866638 | 1866638 | 2021-10-30 | Lake | Michigan | 26085 | 981 | 22 |
1863389 | 1863389 | 2021-10-29 | Lake | Michigan | 26085 | 981 | 22 |
1860140 | 1860140 | 2021-10-28 | Lake | Michigan | 26085 | 966 | 22 |
1856891 | 1856891 | 2021-10-27 | Lake | Michigan | 26085 | 966 | 22 |
1853642 | 1853642 | 2021-10-26 | Lake | Michigan | 26085 | 954 | 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);