ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Jefferson" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- …
state 1
- Kentucky · 697 ✖
fips 1
- 21111 697
county 1
- Jefferson · 697 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175252 | 2175252 | 2022-02-02 | Jefferson | Kentucky | 21111 | 206193 | 1940 |
2171999 | 2171999 | 2022-02-01 | Jefferson | Kentucky | 21111 | 203829 | 1939 |
2168746 | 2168746 | 2022-01-31 | Jefferson | Kentucky | 21111 | 203562 | 1938 |
2165491 | 2165491 | 2022-01-30 | Jefferson | Kentucky | 21111 | 202922 | 1932 |
2162236 | 2162236 | 2022-01-29 | Jefferson | Kentucky | 21111 | 201903 | 1932 |
2158981 | 2158981 | 2022-01-28 | Jefferson | Kentucky | 21111 | 200155 | 1932 |
2155727 | 2155727 | 2022-01-27 | Jefferson | Kentucky | 21111 | 199282 | 1926 |
2152474 | 2152474 | 2022-01-26 | Jefferson | Kentucky | 21111 | 196557 | 1922 |
2149222 | 2149222 | 2022-01-25 | Jefferson | Kentucky | 21111 | 193175 | 1916 |
2145970 | 2145970 | 2022-01-24 | Jefferson | Kentucky | 21111 | 191526 | 1914 |
2142715 | 2142715 | 2022-01-23 | Jefferson | Kentucky | 21111 | 190737 | 1913 |
2139460 | 2139460 | 2022-01-22 | Jefferson | Kentucky | 21111 | 189381 | 1913 |
2136204 | 2136204 | 2022-01-21 | Jefferson | Kentucky | 21111 | 186398 | 1913 |
2132952 | 2132952 | 2022-01-20 | Jefferson | Kentucky | 21111 | 184178 | 1905 |
2129699 | 2129699 | 2022-01-19 | Jefferson | Kentucky | 21111 | 182200 | 1904 |
2126445 | 2126445 | 2022-01-18 | Jefferson | Kentucky | 21111 | 179723 | 1904 |
2123193 | 2123193 | 2022-01-17 | Jefferson | Kentucky | 21111 | 178361 | 1888 |
2119941 | 2119941 | 2022-01-16 | Jefferson | Kentucky | 21111 | 176496 | 1888 |
2116689 | 2116689 | 2022-01-15 | Jefferson | Kentucky | 21111 | 171370 | 1888 |
2113438 | 2113438 | 2022-01-14 | Jefferson | Kentucky | 21111 | 170351 | 1888 |
2110186 | 2110186 | 2022-01-13 | Jefferson | Kentucky | 21111 | 168335 | 1885 |
2106935 | 2106935 | 2022-01-12 | Jefferson | Kentucky | 21111 | 166209 | 1884 |
2103684 | 2103684 | 2022-01-11 | Jefferson | Kentucky | 21111 | 163273 | 1880 |
2100433 | 2100433 | 2022-01-10 | Jefferson | Kentucky | 21111 | 161760 | 1878 |
2097182 | 2097182 | 2022-01-09 | Jefferson | Kentucky | 21111 | 160309 | 1867 |
2093930 | 2093930 | 2022-01-08 | Jefferson | Kentucky | 21111 | 158385 | 1867 |
2090678 | 2090678 | 2022-01-07 | Jefferson | Kentucky | 21111 | 155786 | 1867 |
2087427 | 2087427 | 2022-01-06 | Jefferson | Kentucky | 21111 | 154329 | 1867 |
2084175 | 2084175 | 2022-01-05 | Jefferson | Kentucky | 21111 | 150221 | 1859 |
2080923 | 2080923 | 2022-01-04 | Jefferson | Kentucky | 21111 | 147449 | 1851 |
2077671 | 2077671 | 2022-01-03 | Jefferson | Kentucky | 21111 | 145614 | 1850 |
2074420 | 2074420 | 2022-01-02 | Jefferson | Kentucky | 21111 | 144121 | 1834 |
2071169 | 2071169 | 2022-01-01 | Jefferson | Kentucky | 21111 | 143268 | 1834 |
2067918 | 2067918 | 2021-12-31 | Jefferson | Kentucky | 21111 | 141826 | 1834 |
2064667 | 2064667 | 2021-12-30 | Jefferson | Kentucky | 21111 | 139490 | 1834 |
2061417 | 2061417 | 2021-12-29 | Jefferson | Kentucky | 21111 | 138406 | 1834 |
2058168 | 2058168 | 2021-12-28 | Jefferson | Kentucky | 21111 | 136848 | 1830 |
2054919 | 2054919 | 2021-12-27 | Jefferson | Kentucky | 21111 | 135643 | 1826 |
2051669 | 2051669 | 2021-12-26 | Jefferson | Kentucky | 21111 | 134022 | 1802 |
2048419 | 2048419 | 2021-12-25 | Jefferson | Kentucky | 21111 | 133638 | 1802 |
2045169 | 2045169 | 2021-12-24 | Jefferson | Kentucky | 21111 | 133355 | 1802 |
2041920 | 2041920 | 2021-12-23 | Jefferson | Kentucky | 21111 | 133355 | 1802 |
2038670 | 2038670 | 2021-12-22 | Jefferson | Kentucky | 21111 | 133355 | 1801 |
2035420 | 2035420 | 2021-12-21 | Jefferson | Kentucky | 21111 | 132829 | 1797 |
2032170 | 2032170 | 2021-12-20 | Jefferson | Kentucky | 21111 | 132478 | 1791 |
2028919 | 2028919 | 2021-12-19 | Jefferson | Kentucky | 21111 | 131504 | 1791 |
2025668 | 2025668 | 2021-12-18 | Jefferson | Kentucky | 21111 | 131504 | 1791 |
2022417 | 2022417 | 2021-12-17 | Jefferson | Kentucky | 21111 | 131504 | 1791 |
2019166 | 2019166 | 2021-12-16 | Jefferson | Kentucky | 21111 | 131205 | 1790 |
2015916 | 2015916 | 2021-12-15 | Jefferson | Kentucky | 21111 | 130828 | 1785 |
2012665 | 2012665 | 2021-12-14 | Jefferson | Kentucky | 21111 | 130450 | 1780 |
2009414 | 2009414 | 2021-12-13 | Jefferson | Kentucky | 21111 | 130154 | 1780 |
2006163 | 2006163 | 2021-12-12 | Jefferson | Kentucky | 21111 | 129413 | 1780 |
2002912 | 2002912 | 2021-12-11 | Jefferson | Kentucky | 21111 | 129413 | 1780 |
1999662 | 1999662 | 2021-12-10 | Jefferson | Kentucky | 21111 | 129413 | 1780 |
1996411 | 1996411 | 2021-12-09 | Jefferson | Kentucky | 21111 | 129059 | 1780 |
1993160 | 1993160 | 2021-12-08 | Jefferson | Kentucky | 21111 | 128738 | 1780 |
1989909 | 1989909 | 2021-12-07 | Jefferson | Kentucky | 21111 | 128373 | 1780 |
1986659 | 1986659 | 2021-12-06 | Jefferson | Kentucky | 21111 | 128025 | 1780 |
1983409 | 1983409 | 2021-12-05 | Jefferson | Kentucky | 21111 | 127307 | 1777 |
1980159 | 1980159 | 2021-12-04 | Jefferson | Kentucky | 21111 | 127307 | 1777 |
1976909 | 1976909 | 2021-12-03 | Jefferson | Kentucky | 21111 | 127307 | 1766 |
1973660 | 1973660 | 2021-12-02 | Jefferson | Kentucky | 21111 | 126910 | 1761 |
1970410 | 1970410 | 2021-12-01 | Jefferson | Kentucky | 21111 | 126576 | 1749 |
1967160 | 1967160 | 2021-11-30 | Jefferson | Kentucky | 21111 | 126179 | 1733 |
1963908 | 1963908 | 2021-11-29 | Jefferson | Kentucky | 21111 | 125889 | 1733 |
1960657 | 1960657 | 2021-11-28 | Jefferson | Kentucky | 21111 | 125037 | 1722 |
1957406 | 1957406 | 2021-11-27 | Jefferson | Kentucky | 21111 | 125037 | 1722 |
1954155 | 1954155 | 2021-11-26 | Jefferson | Kentucky | 21111 | 125037 | 1716 |
1950904 | 1950904 | 2021-11-25 | Jefferson | Kentucky | 21111 | 125037 | 1716 |
1947653 | 1947653 | 2021-11-24 | Jefferson | Kentucky | 21111 | 125037 | 1712 |
1944402 | 1944402 | 2021-11-23 | Jefferson | Kentucky | 21111 | 124767 | 1711 |
1941152 | 1941152 | 2021-11-22 | Jefferson | Kentucky | 21111 | 124525 | 1690 |
1937902 | 1937902 | 2021-11-21 | Jefferson | Kentucky | 21111 | 123978 | 1684 |
1934652 | 1934652 | 2021-11-20 | Jefferson | Kentucky | 21111 | 123978 | 1682 |
1931401 | 1931401 | 2021-11-19 | Jefferson | Kentucky | 21111 | 123978 | 1679 |
1928150 | 1928150 | 2021-11-18 | Jefferson | Kentucky | 21111 | 123769 | 1666 |
1924900 | 1924900 | 2021-11-17 | Jefferson | Kentucky | 21111 | 123565 | 1657 |
1921651 | 1921651 | 2021-11-16 | Jefferson | Kentucky | 21111 | 123314 | 1653 |
1918401 | 1918401 | 2021-11-15 | Jefferson | Kentucky | 21111 | 123144 | 1641 |
1915151 | 1915151 | 2021-11-14 | Jefferson | Kentucky | 21111 | 122722 | 1641 |
1911901 | 1911901 | 2021-11-13 | Jefferson | Kentucky | 21111 | 122722 | 1640 |
1908652 | 1908652 | 2021-11-12 | Jefferson | Kentucky | 21111 | 122722 | 1631 |
1905403 | 1905403 | 2021-11-11 | Jefferson | Kentucky | 21111 | 122299 | 1612 |
1902153 | 1902153 | 2021-11-10 | Jefferson | Kentucky | 21111 | 122299 | 1602 |
1898903 | 1898903 | 2021-11-09 | Jefferson | Kentucky | 21111 | 122028 | 1597 |
1895653 | 1895653 | 2021-11-08 | Jefferson | Kentucky | 21111 | 121817 | 1593 |
1892403 | 1892403 | 2021-11-07 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1889153 | 1889153 | 2021-11-06 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1885903 | 1885903 | 2021-11-05 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1882654 | 1882654 | 2021-11-04 | Jefferson | Kentucky | 21111 | 121270 | 1586 |
1879405 | 1879405 | 2021-11-03 | Jefferson | Kentucky | 21111 | 121016 | 1583 |
1876156 | 1876156 | 2021-11-02 | Jefferson | Kentucky | 21111 | 120761 | 1581 |
1872907 | 1872907 | 2021-11-01 | Jefferson | Kentucky | 21111 | 120597 | 1573 |
1869658 | 1869658 | 2021-10-31 | Jefferson | Kentucky | 21111 | 120254 | 1570 |
1866409 | 1866409 | 2021-10-30 | Jefferson | Kentucky | 21111 | 120254 | 1569 |
1863160 | 1863160 | 2021-10-29 | Jefferson | Kentucky | 21111 | 120254 | 1569 |
1859911 | 1859911 | 2021-10-28 | Jefferson | Kentucky | 21111 | 120047 | 1569 |
1856662 | 1856662 | 2021-10-27 | Jefferson | Kentucky | 21111 | 119814 | 1567 |
1853413 | 1853413 | 2021-10-26 | Jefferson | Kentucky | 21111 | 119580 | 1567 |
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);