ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 21143 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175268 | 2175268 | 2022-02-02 | Lyon | Kentucky | 21143 | 2580 | 32 |
2172015 | 2172015 | 2022-02-01 | Lyon | Kentucky | 21143 | 2564 | 32 |
2168762 | 2168762 | 2022-01-31 | Lyon | Kentucky | 21143 | 2554 | 32 |
2165507 | 2165507 | 2022-01-30 | Lyon | Kentucky | 21143 | 2500 | 31 |
2162252 | 2162252 | 2022-01-29 | Lyon | Kentucky | 21143 | 2500 | 31 |
2158997 | 2158997 | 2022-01-28 | Lyon | Kentucky | 21143 | 2500 | 31 |
2155743 | 2155743 | 2022-01-27 | Lyon | Kentucky | 21143 | 2407 | 31 |
2152490 | 2152490 | 2022-01-26 | Lyon | Kentucky | 21143 | 2400 | 31 |
2149238 | 2149238 | 2022-01-25 | Lyon | Kentucky | 21143 | 2385 | 31 |
2145986 | 2145986 | 2022-01-24 | Lyon | Kentucky | 21143 | 2340 | 31 |
2142731 | 2142731 | 2022-01-23 | Lyon | Kentucky | 21143 | 2268 | 31 |
2139476 | 2139476 | 2022-01-22 | Lyon | Kentucky | 21143 | 2268 | 31 |
2136220 | 2136220 | 2022-01-21 | Lyon | Kentucky | 21143 | 2268 | 31 |
2132968 | 2132968 | 2022-01-20 | Lyon | Kentucky | 21143 | 2242 | 31 |
2129715 | 2129715 | 2022-01-19 | Lyon | Kentucky | 21143 | 2238 | 31 |
2126461 | 2126461 | 2022-01-18 | Lyon | Kentucky | 21143 | 2222 | 31 |
2123209 | 2123209 | 2022-01-17 | Lyon | Kentucky | 21143 | 2191 | 31 |
2119957 | 2119957 | 2022-01-16 | Lyon | Kentucky | 21143 | 2191 | 31 |
2116705 | 2116705 | 2022-01-15 | Lyon | Kentucky | 21143 | 2191 | 31 |
2113454 | 2113454 | 2022-01-14 | Lyon | Kentucky | 21143 | 2191 | 31 |
2110202 | 2110202 | 2022-01-13 | Lyon | Kentucky | 21143 | 2175 | 31 |
2106951 | 2106951 | 2022-01-12 | Lyon | Kentucky | 21143 | 2172 | 31 |
2103700 | 2103700 | 2022-01-11 | Lyon | Kentucky | 21143 | 2166 | 31 |
2100449 | 2100449 | 2022-01-10 | Lyon | Kentucky | 21143 | 2151 | 31 |
2097198 | 2097198 | 2022-01-09 | Lyon | Kentucky | 21143 | 2141 | 30 |
2093946 | 2093946 | 2022-01-08 | Lyon | Kentucky | 21143 | 2141 | 30 |
2090694 | 2090694 | 2022-01-07 | Lyon | Kentucky | 21143 | 2141 | 30 |
2087443 | 2087443 | 2022-01-06 | Lyon | Kentucky | 21143 | 2139 | 30 |
2084191 | 2084191 | 2022-01-05 | Lyon | Kentucky | 21143 | 2136 | 30 |
2080939 | 2080939 | 2022-01-04 | Lyon | Kentucky | 21143 | 2133 | 30 |
2077687 | 2077687 | 2022-01-03 | Lyon | Kentucky | 21143 | 2123 | 29 |
2074436 | 2074436 | 2022-01-02 | Lyon | Kentucky | 21143 | 2107 | 29 |
2071185 | 2071185 | 2022-01-01 | Lyon | Kentucky | 21143 | 2107 | 29 |
2067934 | 2067934 | 2021-12-31 | Lyon | Kentucky | 21143 | 2107 | 29 |
2064683 | 2064683 | 2021-12-30 | Lyon | Kentucky | 21143 | 2107 | 29 |
2061433 | 2061433 | 2021-12-29 | Lyon | Kentucky | 21143 | 2107 | 29 |
2058184 | 2058184 | 2021-12-28 | Lyon | Kentucky | 21143 | 2100 | 29 |
2054935 | 2054935 | 2021-12-27 | Lyon | Kentucky | 21143 | 2098 | 29 |
2051685 | 2051685 | 2021-12-26 | Lyon | Kentucky | 21143 | 2091 | 29 |
2048435 | 2048435 | 2021-12-25 | Lyon | Kentucky | 21143 | 2091 | 29 |
2045185 | 2045185 | 2021-12-24 | Lyon | Kentucky | 21143 | 2091 | 29 |
2041936 | 2041936 | 2021-12-23 | Lyon | Kentucky | 21143 | 2091 | 29 |
2038686 | 2038686 | 2021-12-22 | Lyon | Kentucky | 21143 | 2091 | 29 |
2035436 | 2035436 | 2021-12-21 | Lyon | Kentucky | 21143 | 2088 | 29 |
2032186 | 2032186 | 2021-12-20 | Lyon | Kentucky | 21143 | 2082 | 29 |
2028935 | 2028935 | 2021-12-19 | Lyon | Kentucky | 21143 | 2076 | 29 |
2025684 | 2025684 | 2021-12-18 | Lyon | Kentucky | 21143 | 2076 | 29 |
2022433 | 2022433 | 2021-12-17 | Lyon | Kentucky | 21143 | 2076 | 29 |
2019182 | 2019182 | 2021-12-16 | Lyon | Kentucky | 21143 | 2074 | 29 |
2015932 | 2015932 | 2021-12-15 | Lyon | Kentucky | 21143 | 2073 | 29 |
2012681 | 2012681 | 2021-12-14 | Lyon | Kentucky | 21143 | 2065 | 29 |
2009430 | 2009430 | 2021-12-13 | Lyon | Kentucky | 21143 | 2065 | 29 |
2006179 | 2006179 | 2021-12-12 | Lyon | Kentucky | 21143 | 2061 | 28 |
2002928 | 2002928 | 2021-12-11 | Lyon | Kentucky | 21143 | 2061 | 28 |
1999678 | 1999678 | 2021-12-10 | Lyon | Kentucky | 21143 | 2061 | 28 |
1996427 | 1996427 | 2021-12-09 | Lyon | Kentucky | 21143 | 2054 | 28 |
1993176 | 1993176 | 2021-12-08 | Lyon | Kentucky | 21143 | 2047 | 28 |
1989925 | 1989925 | 2021-12-07 | Lyon | Kentucky | 21143 | 2043 | 27 |
1986675 | 1986675 | 2021-12-06 | Lyon | Kentucky | 21143 | 2034 | 27 |
1983425 | 1983425 | 2021-12-05 | Lyon | Kentucky | 21143 | 2025 | 26 |
1980175 | 1980175 | 2021-12-04 | Lyon | Kentucky | 21143 | 2025 | 26 |
1976925 | 1976925 | 2021-12-03 | Lyon | Kentucky | 21143 | 2025 | 26 |
1973676 | 1973676 | 2021-12-02 | Lyon | Kentucky | 21143 | 2022 | 26 |
1970426 | 1970426 | 2021-12-01 | Lyon | Kentucky | 21143 | 2020 | 26 |
1967176 | 1967176 | 2021-11-30 | Lyon | Kentucky | 21143 | 2012 | 26 |
1963924 | 1963924 | 2021-11-29 | Lyon | Kentucky | 21143 | 2009 | 26 |
1960673 | 1960673 | 2021-11-28 | Lyon | Kentucky | 21143 | 2000 | 26 |
1957422 | 1957422 | 2021-11-27 | Lyon | Kentucky | 21143 | 2000 | 26 |
1954171 | 1954171 | 2021-11-26 | Lyon | Kentucky | 21143 | 2000 | 26 |
1950920 | 1950920 | 2021-11-25 | Lyon | Kentucky | 21143 | 2000 | 26 |
1947669 | 1947669 | 2021-11-24 | Lyon | Kentucky | 21143 | 2000 | 26 |
1944418 | 1944418 | 2021-11-23 | Lyon | Kentucky | 21143 | 1996 | 26 |
1941168 | 1941168 | 2021-11-22 | Lyon | Kentucky | 21143 | 1995 | 26 |
1937918 | 1937918 | 2021-11-21 | Lyon | Kentucky | 21143 | 1992 | 26 |
1934668 | 1934668 | 2021-11-20 | Lyon | Kentucky | 21143 | 1992 | 26 |
1931417 | 1931417 | 2021-11-19 | Lyon | Kentucky | 21143 | 1992 | 26 |
1928166 | 1928166 | 2021-11-18 | Lyon | Kentucky | 21143 | 1992 | 26 |
1924916 | 1924916 | 2021-11-17 | Lyon | Kentucky | 21143 | 1989 | 26 |
1921667 | 1921667 | 2021-11-16 | Lyon | Kentucky | 21143 | 1987 | 26 |
1918417 | 1918417 | 2021-11-15 | Lyon | Kentucky | 21143 | 1986 | 26 |
1915167 | 1915167 | 2021-11-14 | Lyon | Kentucky | 21143 | 1982 | 26 |
1911917 | 1911917 | 2021-11-13 | Lyon | Kentucky | 21143 | 1982 | 26 |
1908668 | 1908668 | 2021-11-12 | Lyon | Kentucky | 21143 | 1982 | 26 |
1905419 | 1905419 | 2021-11-11 | Lyon | Kentucky | 21143 | 1980 | 26 |
1902169 | 1902169 | 2021-11-10 | Lyon | Kentucky | 21143 | 1980 | 26 |
1898919 | 1898919 | 2021-11-09 | Lyon | Kentucky | 21143 | 1976 | 26 |
1895669 | 1895669 | 2021-11-08 | Lyon | Kentucky | 21143 | 1974 | 26 |
1892419 | 1892419 | 2021-11-07 | Lyon | Kentucky | 21143 | 1974 | 26 |
1889169 | 1889169 | 2021-11-06 | Lyon | Kentucky | 21143 | 1974 | 26 |
1885919 | 1885919 | 2021-11-05 | Lyon | Kentucky | 21143 | 1974 | 26 |
1882670 | 1882670 | 2021-11-04 | Lyon | Kentucky | 21143 | 1969 | 26 |
1879421 | 1879421 | 2021-11-03 | Lyon | Kentucky | 21143 | 1969 | 26 |
1876172 | 1876172 | 2021-11-02 | Lyon | Kentucky | 21143 | 1966 | 26 |
1872923 | 1872923 | 2021-11-01 | Lyon | Kentucky | 21143 | 1964 | 26 |
1869674 | 1869674 | 2021-10-31 | Lyon | Kentucky | 21143 | 1961 | 26 |
1866425 | 1866425 | 2021-10-30 | Lyon | Kentucky | 21143 | 1961 | 26 |
1863176 | 1863176 | 2021-10-29 | Lyon | Kentucky | 21143 | 1961 | 26 |
1859927 | 1859927 | 2021-10-28 | Lyon | Kentucky | 21143 | 1953 | 26 |
1856678 | 1856678 | 2021-10-27 | Lyon | Kentucky | 21143 | 1950 | 26 |
1853429 | 1853429 | 2021-10-26 | Lyon | Kentucky | 21143 | 1947 | 26 |
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);