ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 21097 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811167 | 1811167 | 2021-10-13 | Harrison | Kentucky | 21097 | 3165 | 33 |
1807918 | 1807918 | 2021-10-12 | Harrison | Kentucky | 21097 | 3133 | 33 |
1804667 | 1804667 | 2021-10-11 | Harrison | Kentucky | 21097 | 3117 | 30 |
1801418 | 1801418 | 2021-10-10 | Harrison | Kentucky | 21097 | 3097 | 30 |
1798169 | 1798169 | 2021-10-09 | Harrison | Kentucky | 21097 | 3097 | 30 |
1794920 | 1794920 | 2021-10-08 | Harrison | Kentucky | 21097 | 3097 | 30 |
1791672 | 1791672 | 2021-10-07 | Harrison | Kentucky | 21097 | 3092 | 30 |
1788423 | 1788423 | 2021-10-06 | Harrison | Kentucky | 21097 | 3077 | 30 |
1785174 | 1785174 | 2021-10-05 | Harrison | Kentucky | 21097 | 3051 | 30 |
1781925 | 1781925 | 2021-10-04 | Harrison | Kentucky | 21097 | 3033 | 30 |
1778675 | 1778675 | 2021-10-03 | Harrison | Kentucky | 21097 | 3009 | 29 |
1775425 | 1775425 | 2021-10-02 | Harrison | Kentucky | 21097 | 3009 | 29 |
1772175 | 1772175 | 2021-10-01 | Harrison | Kentucky | 21097 | 3009 | 29 |
1768926 | 1768926 | 2021-09-30 | Harrison | Kentucky | 21097 | 2982 | 29 |
1765677 | 1765677 | 2021-09-29 | Harrison | Kentucky | 21097 | 2957 | 29 |
1762428 | 1762428 | 2021-09-28 | Harrison | Kentucky | 21097 | 2938 | 29 |
1759180 | 1759180 | 2021-09-27 | Harrison | Kentucky | 21097 | 2913 | 29 |
1755932 | 1755932 | 2021-09-26 | Harrison | Kentucky | 21097 | 2864 | 29 |
1752684 | 1752684 | 2021-09-25 | Harrison | Kentucky | 21097 | 2864 | 29 |
1749435 | 1749435 | 2021-09-24 | Harrison | Kentucky | 21097 | 2864 | 29 |
1746185 | 1746185 | 2021-09-23 | Harrison | Kentucky | 21097 | 2842 | 29 |
1742936 | 1742936 | 2021-09-22 | Harrison | Kentucky | 21097 | 2819 | 29 |
1739687 | 1739687 | 2021-09-21 | Harrison | Kentucky | 21097 | 2797 | 29 |
1736438 | 1736438 | 2021-09-20 | Harrison | Kentucky | 21097 | 2766 | 29 |
1733188 | 1733188 | 2021-09-19 | Harrison | Kentucky | 21097 | 2721 | 29 |
1729938 | 1729938 | 2021-09-18 | Harrison | Kentucky | 21097 | 2721 | 29 |
1726688 | 1726688 | 2021-09-17 | Harrison | Kentucky | 21097 | 2721 | 29 |
1723439 | 1723439 | 2021-09-16 | Harrison | Kentucky | 21097 | 2671 | 29 |
1720190 | 1720190 | 2021-09-15 | Harrison | Kentucky | 21097 | 2641 | 28 |
1716942 | 1716942 | 2021-09-14 | Harrison | Kentucky | 21097 | 2610 | 28 |
1713696 | 1713696 | 2021-09-13 | Harrison | Kentucky | 21097 | 2586 | 28 |
1710449 | 1710449 | 2021-09-12 | Harrison | Kentucky | 21097 | 2529 | 28 |
1707202 | 1707202 | 2021-09-11 | Harrison | Kentucky | 21097 | 2529 | 28 |
1703954 | 1703954 | 2021-09-10 | Harrison | Kentucky | 21097 | 2529 | 28 |
1700704 | 1700704 | 2021-09-09 | Harrison | Kentucky | 21097 | 2512 | 28 |
1697455 | 1697455 | 2021-09-08 | Harrison | Kentucky | 21097 | 2474 | 28 |
1694207 | 1694207 | 2021-09-07 | Harrison | Kentucky | 21097 | 2435 | 28 |
1690958 | 1690958 | 2021-09-06 | Harrison | Kentucky | 21097 | 2352 | 28 |
1687708 | 1687708 | 2021-09-05 | Harrison | Kentucky | 21097 | 2352 | 28 |
1684458 | 1684458 | 2021-09-04 | Harrison | Kentucky | 21097 | 2352 | 28 |
1681207 | 1681207 | 2021-09-03 | Harrison | Kentucky | 21097 | 2352 | 28 |
1677959 | 1677959 | 2021-09-02 | Harrison | Kentucky | 21097 | 2323 | 28 |
1674712 | 1674712 | 2021-09-01 | Harrison | Kentucky | 21097 | 2297 | 28 |
1671463 | 1671463 | 2021-08-31 | Harrison | Kentucky | 21097 | 2268 | 28 |
1668216 | 1668216 | 2021-08-30 | Harrison | Kentucky | 21097 | 2241 | 28 |
1664969 | 1664969 | 2021-08-29 | Harrison | Kentucky | 21097 | 2201 | 28 |
1661721 | 1661721 | 2021-08-28 | Harrison | Kentucky | 21097 | 2201 | 28 |
1658473 | 1658473 | 2021-08-27 | Harrison | Kentucky | 21097 | 2201 | 28 |
1655225 | 1655225 | 2021-08-26 | Harrison | Kentucky | 21097 | 2180 | 28 |
1651978 | 1651978 | 2021-08-25 | Harrison | Kentucky | 21097 | 2151 | 28 |
1648729 | 1648729 | 2021-08-24 | Harrison | Kentucky | 21097 | 2127 | 27 |
1645481 | 1645481 | 2021-08-23 | Harrison | Kentucky | 21097 | 2102 | 27 |
1642232 | 1642232 | 2021-08-22 | Harrison | Kentucky | 21097 | 2058 | 27 |
1638982 | 1638982 | 2021-08-21 | Harrison | Kentucky | 21097 | 2058 | 27 |
1635732 | 1635732 | 2021-08-20 | Harrison | Kentucky | 21097 | 2058 | 27 |
1632482 | 1632482 | 2021-08-19 | Harrison | Kentucky | 21097 | 2045 | 27 |
1629235 | 1629235 | 2021-08-18 | Harrison | Kentucky | 21097 | 2029 | 27 |
1625988 | 1625988 | 2021-08-17 | Harrison | Kentucky | 21097 | 2015 | 27 |
1622741 | 1622741 | 2021-08-16 | Harrison | Kentucky | 21097 | 2001 | 27 |
1619494 | 1619494 | 2021-08-15 | Harrison | Kentucky | 21097 | 1970 | 27 |
1616246 | 1616246 | 2021-08-14 | Harrison | Kentucky | 21097 | 1970 | 27 |
1612997 | 1612997 | 2021-08-13 | Harrison | Kentucky | 21097 | 1970 | 27 |
1609749 | 1609749 | 2021-08-12 | Harrison | Kentucky | 21097 | 1951 | 27 |
1606500 | 1606500 | 2021-08-11 | Harrison | Kentucky | 21097 | 1933 | 27 |
1603251 | 1603251 | 2021-08-10 | Harrison | Kentucky | 21097 | 1930 | 27 |
1600002 | 1600002 | 2021-08-09 | Harrison | Kentucky | 21097 | 1921 | 27 |
1596754 | 1596754 | 2021-08-08 | Harrison | Kentucky | 21097 | 1897 | 27 |
1593505 | 1593505 | 2021-08-07 | Harrison | Kentucky | 21097 | 1897 | 27 |
1590256 | 1590256 | 2021-08-06 | Harrison | Kentucky | 21097 | 1897 | 27 |
1587007 | 1587007 | 2021-08-05 | Harrison | Kentucky | 21097 | 1892 | 27 |
1583757 | 1583757 | 2021-08-04 | Harrison | Kentucky | 21097 | 1886 | 27 |
1580507 | 1580507 | 2021-08-03 | Harrison | Kentucky | 21097 | 1879 | 27 |
1577258 | 1577258 | 2021-08-02 | Harrison | Kentucky | 21097 | 1879 | 27 |
1574010 | 1574010 | 2021-08-01 | Harrison | Kentucky | 21097 | 1866 | 27 |
1570762 | 1570762 | 2021-07-31 | Harrison | Kentucky | 21097 | 1866 | 27 |
1567514 | 1567514 | 2021-07-30 | Harrison | Kentucky | 21097 | 1866 | 27 |
1564266 | 1564266 | 2021-07-29 | Harrison | Kentucky | 21097 | 1865 | 27 |
1561018 | 1561018 | 2021-07-28 | Harrison | Kentucky | 21097 | 1860 | 27 |
1557771 | 1557771 | 2021-07-27 | Harrison | Kentucky | 21097 | 1857 | 27 |
1554524 | 1554524 | 2021-07-26 | Harrison | Kentucky | 21097 | 1853 | 27 |
1551277 | 1551277 | 2021-07-25 | Harrison | Kentucky | 21097 | 1851 | 27 |
1548030 | 1548030 | 2021-07-24 | Harrison | Kentucky | 21097 | 1851 | 27 |
1544783 | 1544783 | 2021-07-23 | Harrison | Kentucky | 21097 | 1851 | 27 |
1541535 | 1541535 | 2021-07-22 | Harrison | Kentucky | 21097 | 1845 | 27 |
1538288 | 1538288 | 2021-07-21 | Harrison | Kentucky | 21097 | 1844 | 27 |
1535040 | 1535040 | 2021-07-20 | Harrison | Kentucky | 21097 | 1842 | 27 |
1531793 | 1531793 | 2021-07-19 | Harrison | Kentucky | 21097 | 1839 | 27 |
1528546 | 1528546 | 2021-07-18 | Harrison | Kentucky | 21097 | 1836 | 27 |
1525299 | 1525299 | 2021-07-17 | Harrison | Kentucky | 21097 | 1836 | 27 |
1522051 | 1522051 | 2021-07-16 | Harrison | Kentucky | 21097 | 1836 | 27 |
1518803 | 1518803 | 2021-07-15 | Harrison | Kentucky | 21097 | 1836 | 27 |
1515556 | 1515556 | 2021-07-14 | Harrison | Kentucky | 21097 | 1837 | 25 |
1512310 | 1512310 | 2021-07-13 | Harrison | Kentucky | 21097 | 1836 | 25 |
1509063 | 1509063 | 2021-07-12 | Harrison | Kentucky | 21097 | 1837 | 25 |
1505817 | 1505817 | 2021-07-11 | Harrison | Kentucky | 21097 | 1837 | 25 |
1502571 | 1502571 | 2021-07-10 | Harrison | Kentucky | 21097 | 1837 | 25 |
1499325 | 1499325 | 2021-07-09 | Harrison | Kentucky | 21097 | 1837 | 25 |
1496078 | 1496078 | 2021-07-08 | Harrison | Kentucky | 21097 | 1837 | 25 |
1492832 | 1492832 | 2021-07-07 | Harrison | Kentucky | 21097 | 1836 | 25 |
1489585 | 1489585 | 2021-07-06 | Harrison | Kentucky | 21097 | 1836 | 25 |
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);