ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21101 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947648 | 1947648 | 2021-11-24 | Henderson | Kentucky | 21101 | 8225 | 123 |
1944397 | 1944397 | 2021-11-23 | Henderson | Kentucky | 21101 | 8210 | 123 |
1941147 | 1941147 | 2021-11-22 | Henderson | Kentucky | 21101 | 8196 | 122 |
1937897 | 1937897 | 2021-11-21 | Henderson | Kentucky | 21101 | 8161 | 122 |
1934647 | 1934647 | 2021-11-20 | Henderson | Kentucky | 21101 | 8161 | 122 |
1931396 | 1931396 | 2021-11-19 | Henderson | Kentucky | 21101 | 8161 | 122 |
1928145 | 1928145 | 2021-11-18 | Henderson | Kentucky | 21101 | 8171 | 108 |
1924895 | 1924895 | 2021-11-17 | Henderson | Kentucky | 21101 | 8157 | 108 |
1921646 | 1921646 | 2021-11-16 | Henderson | Kentucky | 21101 | 8132 | 108 |
1918396 | 1918396 | 2021-11-15 | Henderson | Kentucky | 21101 | 8123 | 108 |
1915146 | 1915146 | 2021-11-14 | Henderson | Kentucky | 21101 | 8109 | 107 |
1911896 | 1911896 | 2021-11-13 | Henderson | Kentucky | 21101 | 8109 | 107 |
1908647 | 1908647 | 2021-11-12 | Henderson | Kentucky | 21101 | 8109 | 107 |
1905398 | 1905398 | 2021-11-11 | Henderson | Kentucky | 21101 | 8083 | 107 |
1902148 | 1902148 | 2021-11-10 | Henderson | Kentucky | 21101 | 8083 | 107 |
1898898 | 1898898 | 2021-11-09 | Henderson | Kentucky | 21101 | 8068 | 106 |
1895648 | 1895648 | 2021-11-08 | Henderson | Kentucky | 21101 | 8057 | 106 |
1892398 | 1892398 | 2021-11-07 | Henderson | Kentucky | 21101 | 8037 | 101 |
1889148 | 1889148 | 2021-11-06 | Henderson | Kentucky | 21101 | 8037 | 101 |
1885898 | 1885898 | 2021-11-05 | Henderson | Kentucky | 21101 | 8037 | 101 |
1882649 | 1882649 | 2021-11-04 | Henderson | Kentucky | 21101 | 8023 | 100 |
1879400 | 1879400 | 2021-11-03 | Henderson | Kentucky | 21101 | 8012 | 100 |
1876151 | 1876151 | 2021-11-02 | Henderson | Kentucky | 21101 | 8007 | 99 |
1872902 | 1872902 | 2021-11-01 | Henderson | Kentucky | 21101 | 7991 | 99 |
1869653 | 1869653 | 2021-10-31 | Henderson | Kentucky | 21101 | 7980 | 99 |
1866404 | 1866404 | 2021-10-30 | Henderson | Kentucky | 21101 | 7980 | 99 |
1863155 | 1863155 | 2021-10-29 | Henderson | Kentucky | 21101 | 7980 | 99 |
1859906 | 1859906 | 2021-10-28 | Henderson | Kentucky | 21101 | 7960 | 99 |
1856657 | 1856657 | 2021-10-27 | Henderson | Kentucky | 21101 | 7950 | 99 |
1853408 | 1853408 | 2021-10-26 | Henderson | Kentucky | 21101 | 7936 | 99 |
1850159 | 1850159 | 2021-10-25 | Henderson | Kentucky | 21101 | 7928 | 99 |
1846909 | 1846909 | 2021-10-24 | Henderson | Kentucky | 21101 | 7914 | 98 |
1843659 | 1843659 | 2021-10-23 | Henderson | Kentucky | 21101 | 7914 | 98 |
1840409 | 1840409 | 2021-10-22 | Henderson | Kentucky | 21101 | 7914 | 98 |
1837160 | 1837160 | 2021-10-21 | Henderson | Kentucky | 21101 | 7903 | 98 |
1833911 | 1833911 | 2021-10-20 | Henderson | Kentucky | 21101 | 7896 | 98 |
1830662 | 1830662 | 2021-10-19 | Henderson | Kentucky | 21101 | 7887 | 98 |
1827413 | 1827413 | 2021-10-18 | Henderson | Kentucky | 21101 | 7881 | 98 |
1824164 | 1824164 | 2021-10-17 | Henderson | Kentucky | 21101 | 7864 | 98 |
1820915 | 1820915 | 2021-10-16 | Henderson | Kentucky | 21101 | 7864 | 98 |
1817666 | 1817666 | 2021-10-15 | Henderson | Kentucky | 21101 | 7864 | 98 |
1814418 | 1814418 | 2021-10-14 | Henderson | Kentucky | 21101 | 7851 | 98 |
1811169 | 1811169 | 2021-10-13 | Henderson | Kentucky | 21101 | 7823 | 98 |
1807920 | 1807920 | 2021-10-12 | Henderson | Kentucky | 21101 | 7795 | 98 |
1804669 | 1804669 | 2021-10-11 | Henderson | Kentucky | 21101 | 7783 | 98 |
1801420 | 1801420 | 2021-10-10 | Henderson | Kentucky | 21101 | 7757 | 97 |
1798171 | 1798171 | 2021-10-09 | Henderson | Kentucky | 21101 | 7757 | 97 |
1794922 | 1794922 | 2021-10-08 | Henderson | Kentucky | 21101 | 7757 | 97 |
1791674 | 1791674 | 2021-10-07 | Henderson | Kentucky | 21101 | 7706 | 95 |
1788425 | 1788425 | 2021-10-06 | Henderson | Kentucky | 21101 | 7686 | 95 |
1785176 | 1785176 | 2021-10-05 | Henderson | Kentucky | 21101 | 7664 | 95 |
1781927 | 1781927 | 2021-10-04 | Henderson | Kentucky | 21101 | 7634 | 94 |
1778677 | 1778677 | 2021-10-03 | Henderson | Kentucky | 21101 | 7574 | 94 |
1775427 | 1775427 | 2021-10-02 | Henderson | Kentucky | 21101 | 7574 | 94 |
1772177 | 1772177 | 2021-10-01 | Henderson | Kentucky | 21101 | 7574 | 94 |
1768928 | 1768928 | 2021-09-30 | Henderson | Kentucky | 21101 | 7531 | 94 |
1765679 | 1765679 | 2021-09-29 | Henderson | Kentucky | 21101 | 7515 | 94 |
1762430 | 1762430 | 2021-09-28 | Henderson | Kentucky | 21101 | 7492 | 94 |
1759182 | 1759182 | 2021-09-27 | Henderson | Kentucky | 21101 | 7462 | 90 |
1755934 | 1755934 | 2021-09-26 | Henderson | Kentucky | 21101 | 7434 | 90 |
1752686 | 1752686 | 2021-09-25 | Henderson | Kentucky | 21101 | 7434 | 90 |
1749437 | 1749437 | 2021-09-24 | Henderson | Kentucky | 21101 | 7434 | 90 |
1746187 | 1746187 | 2021-09-23 | Henderson | Kentucky | 21101 | 7409 | 90 |
1742938 | 1742938 | 2021-09-22 | Henderson | Kentucky | 21101 | 7395 | 89 |
1739689 | 1739689 | 2021-09-21 | Henderson | Kentucky | 21101 | 7356 | 89 |
1736440 | 1736440 | 2021-09-20 | Henderson | Kentucky | 21101 | 7346 | 89 |
1733190 | 1733190 | 2021-09-19 | Henderson | Kentucky | 21101 | 7290 | 89 |
1729940 | 1729940 | 2021-09-18 | Henderson | Kentucky | 21101 | 7290 | 89 |
1726690 | 1726690 | 2021-09-17 | Henderson | Kentucky | 21101 | 7290 | 89 |
1723441 | 1723441 | 2021-09-16 | Henderson | Kentucky | 21101 | 7266 | 88 |
1720192 | 1720192 | 2021-09-15 | Henderson | Kentucky | 21101 | 7219 | 88 |
1716944 | 1716944 | 2021-09-14 | Henderson | Kentucky | 21101 | 7142 | 88 |
1713698 | 1713698 | 2021-09-13 | Henderson | Kentucky | 21101 | 7105 | 88 |
1710451 | 1710451 | 2021-09-12 | Henderson | Kentucky | 21101 | 7019 | 88 |
1707204 | 1707204 | 2021-09-11 | Henderson | Kentucky | 21101 | 7019 | 88 |
1703956 | 1703956 | 2021-09-10 | Henderson | Kentucky | 21101 | 7019 | 88 |
1700706 | 1700706 | 2021-09-09 | Henderson | Kentucky | 21101 | 6981 | 88 |
1697457 | 1697457 | 2021-09-08 | Henderson | Kentucky | 21101 | 6930 | 88 |
1694209 | 1694209 | 2021-09-07 | Henderson | Kentucky | 21101 | 6869 | 88 |
1690960 | 1690960 | 2021-09-06 | Henderson | Kentucky | 21101 | 6725 | 87 |
1687710 | 1687710 | 2021-09-05 | Henderson | Kentucky | 21101 | 6725 | 87 |
1684460 | 1684460 | 2021-09-04 | Henderson | Kentucky | 21101 | 6725 | 87 |
1681209 | 1681209 | 2021-09-03 | Henderson | Kentucky | 21101 | 6725 | 87 |
1677961 | 1677961 | 2021-09-02 | Henderson | Kentucky | 21101 | 6658 | 87 |
1674714 | 1674714 | 2021-09-01 | Henderson | Kentucky | 21101 | 6567 | 86 |
1671465 | 1671465 | 2021-08-31 | Henderson | Kentucky | 21101 | 6491 | 86 |
1668218 | 1668218 | 2021-08-30 | Henderson | Kentucky | 21101 | 6466 | 85 |
1664971 | 1664971 | 2021-08-29 | Henderson | Kentucky | 21101 | 6372 | 85 |
1661723 | 1661723 | 2021-08-28 | Henderson | Kentucky | 21101 | 6372 | 85 |
1658475 | 1658475 | 2021-08-27 | Henderson | Kentucky | 21101 | 6372 | 85 |
1655227 | 1655227 | 2021-08-26 | Henderson | Kentucky | 21101 | 6312 | 85 |
1651980 | 1651980 | 2021-08-25 | Henderson | Kentucky | 21101 | 6249 | 85 |
1648731 | 1648731 | 2021-08-24 | Henderson | Kentucky | 21101 | 6184 | 83 |
1645483 | 1645483 | 2021-08-23 | Henderson | Kentucky | 21101 | 6097 | 83 |
1642234 | 1642234 | 2021-08-22 | Henderson | Kentucky | 21101 | 6023 | 83 |
1638984 | 1638984 | 2021-08-21 | Henderson | Kentucky | 21101 | 6023 | 83 |
1635734 | 1635734 | 2021-08-20 | Henderson | Kentucky | 21101 | 6023 | 83 |
1632484 | 1632484 | 2021-08-19 | Henderson | Kentucky | 21101 | 5952 | 82 |
1629237 | 1629237 | 2021-08-18 | Henderson | Kentucky | 21101 | 5883 | 82 |
1625990 | 1625990 | 2021-08-17 | Henderson | Kentucky | 21101 | 5818 | 82 |
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);