ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Harrison" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947646 | 1947646 | 2021-11-24 | Harrison | Kentucky | 21097 | 3566 | 48 |
1944395 | 1944395 | 2021-11-23 | Harrison | Kentucky | 21097 | 3556 | 48 |
1941145 | 1941145 | 2021-11-22 | Harrison | Kentucky | 21097 | 3544 | 47 |
1937895 | 1937895 | 2021-11-21 | Harrison | Kentucky | 21097 | 3519 | 45 |
1934645 | 1934645 | 2021-11-20 | Harrison | Kentucky | 21097 | 3519 | 45 |
1931394 | 1931394 | 2021-11-19 | Harrison | Kentucky | 21097 | 3519 | 45 |
1928143 | 1928143 | 2021-11-18 | Harrison | Kentucky | 21097 | 3508 | 41 |
1924893 | 1924893 | 2021-11-17 | Harrison | Kentucky | 21097 | 3499 | 40 |
1921644 | 1921644 | 2021-11-16 | Harrison | Kentucky | 21097 | 3486 | 40 |
1918394 | 1918394 | 2021-11-15 | Harrison | Kentucky | 21097 | 3477 | 40 |
1915144 | 1915144 | 2021-11-14 | Harrison | Kentucky | 21097 | 3450 | 40 |
1911894 | 1911894 | 2021-11-13 | Harrison | Kentucky | 21097 | 3450 | 40 |
1908645 | 1908645 | 2021-11-12 | Harrison | Kentucky | 21097 | 3450 | 40 |
1905396 | 1905396 | 2021-11-11 | Harrison | Kentucky | 21097 | 3420 | 40 |
1902146 | 1902146 | 2021-11-10 | Harrison | Kentucky | 21097 | 3420 | 40 |
1898896 | 1898896 | 2021-11-09 | Harrison | Kentucky | 21097 | 3398 | 40 |
1895646 | 1895646 | 2021-11-08 | Harrison | Kentucky | 21097 | 3392 | 39 |
1892396 | 1892396 | 2021-11-07 | Harrison | Kentucky | 21097 | 3356 | 39 |
1889146 | 1889146 | 2021-11-06 | Harrison | Kentucky | 21097 | 3356 | 39 |
1885896 | 1885896 | 2021-11-05 | Harrison | Kentucky | 21097 | 3356 | 39 |
1882647 | 1882647 | 2021-11-04 | Harrison | Kentucky | 21097 | 3347 | 39 |
1879398 | 1879398 | 2021-11-03 | Harrison | Kentucky | 21097 | 3341 | 39 |
1876149 | 1876149 | 2021-11-02 | Harrison | Kentucky | 21097 | 3336 | 39 |
1872900 | 1872900 | 2021-11-01 | Harrison | Kentucky | 21097 | 3329 | 39 |
1869651 | 1869651 | 2021-10-31 | Harrison | Kentucky | 21097 | 3319 | 39 |
1866402 | 1866402 | 2021-10-30 | Harrison | Kentucky | 21097 | 3319 | 39 |
1863153 | 1863153 | 2021-10-29 | Harrison | Kentucky | 21097 | 3319 | 39 |
1859904 | 1859904 | 2021-10-28 | Harrison | Kentucky | 21097 | 3315 | 39 |
1856655 | 1856655 | 2021-10-27 | Harrison | Kentucky | 21097 | 3306 | 39 |
1853406 | 1853406 | 2021-10-26 | Harrison | Kentucky | 21097 | 3300 | 38 |
1850157 | 1850157 | 2021-10-25 | Harrison | Kentucky | 21097 | 3298 | 38 |
1846907 | 1846907 | 2021-10-24 | Harrison | Kentucky | 21097 | 3281 | 36 |
1843657 | 1843657 | 2021-10-23 | Harrison | Kentucky | 21097 | 3281 | 36 |
1840407 | 1840407 | 2021-10-22 | Harrison | Kentucky | 21097 | 3281 | 36 |
1837158 | 1837158 | 2021-10-21 | Harrison | Kentucky | 21097 | 3272 | 36 |
1833909 | 1833909 | 2021-10-20 | Harrison | Kentucky | 21097 | 3264 | 36 |
1830660 | 1830660 | 2021-10-19 | Harrison | Kentucky | 21097 | 3241 | 36 |
1827411 | 1827411 | 2021-10-18 | Harrison | Kentucky | 21097 | 3220 | 36 |
1824162 | 1824162 | 2021-10-17 | Harrison | Kentucky | 21097 | 3206 | 35 |
1820913 | 1820913 | 2021-10-16 | Harrison | Kentucky | 21097 | 3206 | 35 |
1817664 | 1817664 | 2021-10-15 | Harrison | Kentucky | 21097 | 3206 | 35 |
1814416 | 1814416 | 2021-10-14 | Harrison | Kentucky | 21097 | 3192 | 33 |
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 |
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);