ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Lake" and fips = 47095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176774 | 2176774 | 2022-02-02 | Lake | Tennessee | 47095 | 2581 | 34 |
2173520 | 2173520 | 2022-02-01 | Lake | Tennessee | 47095 | 2489 | 34 |
2170268 | 2170268 | 2022-01-31 | Lake | Tennessee | 47095 | 2489 | 34 |
2167014 | 2167014 | 2022-01-30 | Lake | Tennessee | 47095 | 2489 | 34 |
2163759 | 2163759 | 2022-01-29 | Lake | Tennessee | 47095 | 2489 | 34 |
2160504 | 2160504 | 2022-01-28 | Lake | Tennessee | 47095 | 2489 | 34 |
2157248 | 2157248 | 2022-01-27 | Lake | Tennessee | 47095 | 2489 | 34 |
2153995 | 2153995 | 2022-01-26 | Lake | Tennessee | 47095 | 2489 | 34 |
2150743 | 2150743 | 2022-01-25 | Lake | Tennessee | 47095 | 2337 | 34 |
2147491 | 2147491 | 2022-01-24 | Lake | Tennessee | 47095 | 2337 | 34 |
2144237 | 2144237 | 2022-01-23 | Lake | Tennessee | 47095 | 2337 | 34 |
2140982 | 2140982 | 2022-01-22 | Lake | Tennessee | 47095 | 2337 | 34 |
2137726 | 2137726 | 2022-01-21 | Lake | Tennessee | 47095 | 2337 | 34 |
2134472 | 2134472 | 2022-01-20 | Lake | Tennessee | 47095 | 2337 | 34 |
2131220 | 2131220 | 2022-01-19 | Lake | Tennessee | 47095 | 2337 | 34 |
2127966 | 2127966 | 2022-01-18 | Lake | Tennessee | 47095 | 2177 | 34 |
2124714 | 2124714 | 2022-01-17 | Lake | Tennessee | 47095 | 2177 | 34 |
2121462 | 2121462 | 2022-01-16 | Lake | Tennessee | 47095 | 2177 | 34 |
2118210 | 2118210 | 2022-01-15 | Lake | Tennessee | 47095 | 2177 | 34 |
2114959 | 2114959 | 2022-01-14 | Lake | Tennessee | 47095 | 2177 | 34 |
2111707 | 2111707 | 2022-01-13 | Lake | Tennessee | 47095 | 2177 | 34 |
2108455 | 2108455 | 2022-01-12 | Lake | Tennessee | 47095 | 2177 | 34 |
2105204 | 2105204 | 2022-01-11 | Lake | Tennessee | 47095 | 2100 | 34 |
2101953 | 2101953 | 2022-01-10 | Lake | Tennessee | 47095 | 2100 | 34 |
2098702 | 2098702 | 2022-01-09 | Lake | Tennessee | 47095 | 2100 | 34 |
2095450 | 2095450 | 2022-01-08 | Lake | Tennessee | 47095 | 2100 | 34 |
2092198 | 2092198 | 2022-01-07 | Lake | Tennessee | 47095 | 2100 | 34 |
2088946 | 2088946 | 2022-01-06 | Lake | Tennessee | 47095 | 2100 | 34 |
2085695 | 2085695 | 2022-01-05 | Lake | Tennessee | 47095 | 2100 | 34 |
2082443 | 2082443 | 2022-01-04 | Lake | Tennessee | 47095 | 2100 | 34 |
2079191 | 2079191 | 2022-01-03 | Lake | Tennessee | 47095 | 2089 | 34 |
2075940 | 2075940 | 2022-01-02 | Lake | Tennessee | 47095 | 2065 | 34 |
2072689 | 2072689 | 2022-01-01 | Lake | Tennessee | 47095 | 2065 | 34 |
2069438 | 2069438 | 2021-12-31 | Lake | Tennessee | 47095 | 2065 | 34 |
2066187 | 2066187 | 2021-12-30 | Lake | Tennessee | 47095 | 2065 | 34 |
2062937 | 2062937 | 2021-12-29 | Lake | Tennessee | 47095 | 2060 | 34 |
2059687 | 2059687 | 2021-12-28 | Lake | Tennessee | 47095 | 2053 | 34 |
2056438 | 2056438 | 2021-12-27 | Lake | Tennessee | 47095 | 2050 | 34 |
2053189 | 2053189 | 2021-12-26 | Lake | Tennessee | 47095 | 2048 | 34 |
2049939 | 2049939 | 2021-12-25 | Lake | Tennessee | 47095 | 2048 | 34 |
2046689 | 2046689 | 2021-12-24 | Lake | Tennessee | 47095 | 2048 | 34 |
2043439 | 2043439 | 2021-12-23 | Lake | Tennessee | 47095 | 2048 | 34 |
2040190 | 2040190 | 2021-12-22 | Lake | Tennessee | 47095 | 2044 | 32 |
2036940 | 2036940 | 2021-12-21 | Lake | Tennessee | 47095 | 2043 | 32 |
2033690 | 2033690 | 2021-12-20 | Lake | Tennessee | 47095 | 2042 | 32 |
2030440 | 2030440 | 2021-12-19 | Lake | Tennessee | 47095 | 2042 | 32 |
2027189 | 2027189 | 2021-12-18 | Lake | Tennessee | 47095 | 2042 | 32 |
2023938 | 2023938 | 2021-12-17 | Lake | Tennessee | 47095 | 2042 | 32 |
2020687 | 2020687 | 2021-12-16 | Lake | Tennessee | 47095 | 2041 | 32 |
2017436 | 2017436 | 2021-12-15 | Lake | Tennessee | 47095 | 2041 | 32 |
2014186 | 2014186 | 2021-12-14 | Lake | Tennessee | 47095 | 2038 | 32 |
2010935 | 2010935 | 2021-12-13 | Lake | Tennessee | 47095 | 2038 | 32 |
2007684 | 2007684 | 2021-12-12 | Lake | Tennessee | 47095 | 2035 | 32 |
2004433 | 2004433 | 2021-12-11 | Lake | Tennessee | 47095 | 2035 | 32 |
2001182 | 2001182 | 2021-12-10 | Lake | Tennessee | 47095 | 2035 | 32 |
1997932 | 1997932 | 2021-12-09 | Lake | Tennessee | 47095 | 2033 | 32 |
1994681 | 1994681 | 2021-12-08 | Lake | Tennessee | 47095 | 2033 | 32 |
1991430 | 1991430 | 2021-12-07 | Lake | Tennessee | 47095 | 2031 | 32 |
1988179 | 1988179 | 2021-12-06 | Lake | Tennessee | 47095 | 2029 | 31 |
1984929 | 1984929 | 2021-12-05 | Lake | Tennessee | 47095 | 2027 | 31 |
1981679 | 1981679 | 2021-12-04 | Lake | Tennessee | 47095 | 2027 | 31 |
1978429 | 1978429 | 2021-12-03 | Lake | Tennessee | 47095 | 2027 | 31 |
1975179 | 1975179 | 2021-12-02 | Lake | Tennessee | 47095 | 2027 | 31 |
1971930 | 1971930 | 2021-12-01 | Lake | Tennessee | 47095 | 2027 | 31 |
1968680 | 1968680 | 2021-11-30 | Lake | Tennessee | 47095 | 2026 | 31 |
1965429 | 1965429 | 2021-11-29 | Lake | Tennessee | 47095 | 2024 | 31 |
1962177 | 1962177 | 2021-11-28 | Lake | Tennessee | 47095 | 2024 | 31 |
1958926 | 1958926 | 2021-11-27 | Lake | Tennessee | 47095 | 2024 | 31 |
1955675 | 1955675 | 2021-11-26 | Lake | Tennessee | 47095 | 2024 | 31 |
1952424 | 1952424 | 2021-11-25 | Lake | Tennessee | 47095 | 2024 | 31 |
1949173 | 1949173 | 2021-11-24 | Lake | Tennessee | 47095 | 2024 | 31 |
1945922 | 1945922 | 2021-11-23 | Lake | Tennessee | 47095 | 2023 | 31 |
1942671 | 1942671 | 2021-11-22 | Lake | Tennessee | 47095 | 2023 | 31 |
1939421 | 1939421 | 2021-11-21 | Lake | Tennessee | 47095 | 2022 | 31 |
1936171 | 1936171 | 2021-11-20 | Lake | Tennessee | 47095 | 2022 | 31 |
1932921 | 1932921 | 2021-11-19 | Lake | Tennessee | 47095 | 2022 | 31 |
1929670 | 1929670 | 2021-11-18 | Lake | Tennessee | 47095 | 2022 | 31 |
1926420 | 1926420 | 2021-11-17 | Lake | Tennessee | 47095 | 2022 | 31 |
1923170 | 1923170 | 2021-11-16 | Lake | Tennessee | 47095 | 2021 | 31 |
1919921 | 1919921 | 2021-11-15 | Lake | Tennessee | 47095 | 2021 | 31 |
1916671 | 1916671 | 2021-11-14 | Lake | Tennessee | 47095 | 2021 | 31 |
1913421 | 1913421 | 2021-11-13 | Lake | Tennessee | 47095 | 2021 | 31 |
1910171 | 1910171 | 2021-11-12 | Lake | Tennessee | 47095 | 2021 | 31 |
1906922 | 1906922 | 2021-11-11 | Lake | Tennessee | 47095 | 2020 | 31 |
1903673 | 1903673 | 2021-11-10 | Lake | Tennessee | 47095 | 2020 | 31 |
1900423 | 1900423 | 2021-11-09 | Lake | Tennessee | 47095 | 2020 | 31 |
1897173 | 1897173 | 2021-11-08 | Lake | Tennessee | 47095 | 2020 | 31 |
1893923 | 1893923 | 2021-11-07 | Lake | Tennessee | 47095 | 2020 | 31 |
1890673 | 1890673 | 2021-11-06 | Lake | Tennessee | 47095 | 2020 | 31 |
1887423 | 1887423 | 2021-11-05 | Lake | Tennessee | 47095 | 2020 | 31 |
1884173 | 1884173 | 2021-11-04 | Lake | Tennessee | 47095 | 2020 | 31 |
1880924 | 1880924 | 2021-11-03 | Lake | Tennessee | 47095 | 2020 | 31 |
1877675 | 1877675 | 2021-11-02 | Lake | Tennessee | 47095 | 2020 | 31 |
1874426 | 1874426 | 2021-11-01 | Lake | Tennessee | 47095 | 2020 | 31 |
1871177 | 1871177 | 2021-10-31 | Lake | Tennessee | 47095 | 2020 | 31 |
1867928 | 1867928 | 2021-10-30 | Lake | Tennessee | 47095 | 2020 | 31 |
1864679 | 1864679 | 2021-10-29 | Lake | Tennessee | 47095 | 2020 | 31 |
1861430 | 1861430 | 2021-10-28 | Lake | Tennessee | 47095 | 2020 | 31 |
1858181 | 1858181 | 2021-10-27 | Lake | Tennessee | 47095 | 2020 | 31 |
1854932 | 1854932 | 2021-10-26 | Lake | Tennessee | 47095 | 2019 | 31 |
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);