ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Kenton" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947656 | 1947656 | 2021-11-24 | Kenton | Kentucky | 21117 | 26386 | 285 |
1944405 | 1944405 | 2021-11-23 | Kenton | Kentucky | 21117 | 26251 | 285 |
1941155 | 1941155 | 2021-11-22 | Kenton | Kentucky | 21117 | 26213 | 285 |
1937905 | 1937905 | 2021-11-21 | Kenton | Kentucky | 21117 | 26017 | 285 |
1934655 | 1934655 | 2021-11-20 | Kenton | Kentucky | 21117 | 26017 | 285 |
1931404 | 1931404 | 2021-11-19 | Kenton | Kentucky | 21117 | 26017 | 285 |
1928153 | 1928153 | 2021-11-18 | Kenton | Kentucky | 21117 | 25927 | 285 |
1924903 | 1924903 | 2021-11-17 | Kenton | Kentucky | 21117 | 25831 | 285 |
1921654 | 1921654 | 2021-11-16 | Kenton | Kentucky | 21117 | 25738 | 285 |
1918404 | 1918404 | 2021-11-15 | Kenton | Kentucky | 21117 | 25688 | 285 |
1915154 | 1915154 | 2021-11-14 | Kenton | Kentucky | 21117 | 25532 | 285 |
1911904 | 1911904 | 2021-11-13 | Kenton | Kentucky | 21117 | 25532 | 285 |
1908655 | 1908655 | 2021-11-12 | Kenton | Kentucky | 21117 | 25532 | 285 |
1905406 | 1905406 | 2021-11-11 | Kenton | Kentucky | 21117 | 25364 | 281 |
1902156 | 1902156 | 2021-11-10 | Kenton | Kentucky | 21117 | 25364 | 281 |
1898906 | 1898906 | 2021-11-09 | Kenton | Kentucky | 21117 | 25317 | 276 |
1895656 | 1895656 | 2021-11-08 | Kenton | Kentucky | 21117 | 25231 | 276 |
1892406 | 1892406 | 2021-11-07 | Kenton | Kentucky | 21117 | 25086 | 276 |
1889156 | 1889156 | 2021-11-06 | Kenton | Kentucky | 21117 | 25086 | 276 |
1885906 | 1885906 | 2021-11-05 | Kenton | Kentucky | 21117 | 25086 | 276 |
1882657 | 1882657 | 2021-11-04 | Kenton | Kentucky | 21117 | 25086 | 276 |
1879408 | 1879408 | 2021-11-03 | Kenton | Kentucky | 21117 | 25039 | 276 |
1876159 | 1876159 | 2021-11-02 | Kenton | Kentucky | 21117 | 24972 | 276 |
1872910 | 1872910 | 2021-11-01 | Kenton | Kentucky | 21117 | 24942 | 276 |
1869661 | 1869661 | 2021-10-31 | Kenton | Kentucky | 21117 | 24787 | 276 |
1866412 | 1866412 | 2021-10-30 | Kenton | Kentucky | 21117 | 24787 | 276 |
1863163 | 1863163 | 2021-10-29 | Kenton | Kentucky | 21117 | 24787 | 276 |
1859914 | 1859914 | 2021-10-28 | Kenton | Kentucky | 21117 | 24743 | 276 |
1856665 | 1856665 | 2021-10-27 | Kenton | Kentucky | 21117 | 24705 | 274 |
1853416 | 1853416 | 2021-10-26 | Kenton | Kentucky | 21117 | 24645 | 273 |
1850167 | 1850167 | 2021-10-25 | Kenton | Kentucky | 21117 | 24620 | 273 |
1846917 | 1846917 | 2021-10-24 | Kenton | Kentucky | 21117 | 24525 | 271 |
1843667 | 1843667 | 2021-10-23 | Kenton | Kentucky | 21117 | 24525 | 271 |
1840417 | 1840417 | 2021-10-22 | Kenton | Kentucky | 21117 | 24525 | 271 |
1837168 | 1837168 | 2021-10-21 | Kenton | Kentucky | 21117 | 24470 | 271 |
1833919 | 1833919 | 2021-10-20 | Kenton | Kentucky | 21117 | 24454 | 266 |
1830670 | 1830670 | 2021-10-19 | Kenton | Kentucky | 21117 | 24390 | 265 |
1827421 | 1827421 | 2021-10-18 | Kenton | Kentucky | 21117 | 24270 | 257 |
1824172 | 1824172 | 2021-10-17 | Kenton | Kentucky | 21117 | 24161 | 257 |
1820923 | 1820923 | 2021-10-16 | Kenton | Kentucky | 21117 | 24161 | 257 |
1817674 | 1817674 | 2021-10-15 | Kenton | Kentucky | 21117 | 24161 | 257 |
1814426 | 1814426 | 2021-10-14 | Kenton | Kentucky | 21117 | 24063 | 258 |
1811177 | 1811177 | 2021-10-13 | Kenton | Kentucky | 21117 | 24017 | 257 |
1807928 | 1807928 | 2021-10-12 | Kenton | Kentucky | 21117 | 23940 | 257 |
1804677 | 1804677 | 2021-10-11 | Kenton | Kentucky | 21117 | 23886 | 257 |
1801428 | 1801428 | 2021-10-10 | Kenton | Kentucky | 21117 | 23641 | 257 |
1798179 | 1798179 | 2021-10-09 | Kenton | Kentucky | 21117 | 23641 | 257 |
1794930 | 1794930 | 2021-10-08 | Kenton | Kentucky | 21117 | 23641 | 257 |
1791682 | 1791682 | 2021-10-07 | Kenton | Kentucky | 21117 | 23587 | 257 |
1788433 | 1788433 | 2021-10-06 | Kenton | Kentucky | 21117 | 23449 | 255 |
1785184 | 1785184 | 2021-10-05 | Kenton | Kentucky | 21117 | 23380 | 255 |
1781935 | 1781935 | 2021-10-04 | Kenton | Kentucky | 21117 | 23237 | 255 |
1778685 | 1778685 | 2021-10-03 | Kenton | Kentucky | 21117 | 23083 | 255 |
1775435 | 1775435 | 2021-10-02 | Kenton | Kentucky | 21117 | 23083 | 255 |
1772185 | 1772185 | 2021-10-01 | Kenton | Kentucky | 21117 | 23083 | 255 |
1768936 | 1768936 | 2021-09-30 | Kenton | Kentucky | 21117 | 22952 | 255 |
1765687 | 1765687 | 2021-09-29 | Kenton | Kentucky | 21117 | 22841 | 249 |
1762438 | 1762438 | 2021-09-28 | Kenton | Kentucky | 21117 | 22699 | 249 |
1759190 | 1759190 | 2021-09-27 | Kenton | Kentucky | 21117 | 22588 | 245 |
1755942 | 1755942 | 2021-09-26 | Kenton | Kentucky | 21117 | 22289 | 244 |
1752694 | 1752694 | 2021-09-25 | Kenton | Kentucky | 21117 | 22289 | 244 |
1749445 | 1749445 | 2021-09-24 | Kenton | Kentucky | 21117 | 22289 | 244 |
1746195 | 1746195 | 2021-09-23 | Kenton | Kentucky | 21117 | 22230 | 244 |
1742946 | 1742946 | 2021-09-22 | Kenton | Kentucky | 21117 | 22109 | 244 |
1739697 | 1739697 | 2021-09-21 | Kenton | Kentucky | 21117 | 22015 | 240 |
1736448 | 1736448 | 2021-09-20 | Kenton | Kentucky | 21117 | 21897 | 238 |
1733198 | 1733198 | 2021-09-19 | Kenton | Kentucky | 21117 | 21617 | 238 |
1729948 | 1729948 | 2021-09-18 | Kenton | Kentucky | 21117 | 21617 | 238 |
1726698 | 1726698 | 2021-09-17 | Kenton | Kentucky | 21117 | 21617 | 238 |
1723449 | 1723449 | 2021-09-16 | Kenton | Kentucky | 21117 | 21491 | 238 |
1720200 | 1720200 | 2021-09-15 | Kenton | Kentucky | 21117 | 21367 | 236 |
1716952 | 1716952 | 2021-09-14 | Kenton | Kentucky | 21117 | 21246 | 236 |
1713706 | 1713706 | 2021-09-13 | Kenton | Kentucky | 21117 | 21052 | 233 |
1710459 | 1710459 | 2021-09-12 | Kenton | Kentucky | 21117 | 20806 | 233 |
1707212 | 1707212 | 2021-09-11 | Kenton | Kentucky | 21117 | 20806 | 233 |
1703964 | 1703964 | 2021-09-10 | Kenton | Kentucky | 21117 | 20806 | 233 |
1700714 | 1700714 | 2021-09-09 | Kenton | Kentucky | 21117 | 20663 | 233 |
1697465 | 1697465 | 2021-09-08 | Kenton | Kentucky | 21117 | 20561 | 230 |
1694217 | 1694217 | 2021-09-07 | Kenton | Kentucky | 21117 | 20462 | 229 |
1690968 | 1690968 | 2021-09-06 | Kenton | Kentucky | 21117 | 20078 | 229 |
1687718 | 1687718 | 2021-09-05 | Kenton | Kentucky | 21117 | 20078 | 229 |
1684468 | 1684468 | 2021-09-04 | Kenton | Kentucky | 21117 | 20078 | 229 |
1681217 | 1681217 | 2021-09-03 | Kenton | Kentucky | 21117 | 20078 | 229 |
1677969 | 1677969 | 2021-09-02 | Kenton | Kentucky | 21117 | 19876 | 229 |
1674722 | 1674722 | 2021-09-01 | Kenton | Kentucky | 21117 | 19807 | 229 |
1671473 | 1671473 | 2021-08-31 | Kenton | Kentucky | 21117 | 19747 | 229 |
1668226 | 1668226 | 2021-08-30 | Kenton | Kentucky | 21117 | 19651 | 225 |
1664979 | 1664979 | 2021-08-29 | Kenton | Kentucky | 21117 | 19353 | 225 |
1661731 | 1661731 | 2021-08-28 | Kenton | Kentucky | 21117 | 19353 | 225 |
1658483 | 1658483 | 2021-08-27 | Kenton | Kentucky | 21117 | 19353 | 225 |
1655235 | 1655235 | 2021-08-26 | Kenton | Kentucky | 21117 | 19258 | 225 |
1651988 | 1651988 | 2021-08-25 | Kenton | Kentucky | 21117 | 19151 | 225 |
1648739 | 1648739 | 2021-08-24 | Kenton | Kentucky | 21117 | 19076 | 223 |
1645491 | 1645491 | 2021-08-23 | Kenton | Kentucky | 21117 | 18976 | 220 |
1642242 | 1642242 | 2021-08-22 | Kenton | Kentucky | 21117 | 18757 | 220 |
1638992 | 1638992 | 2021-08-21 | Kenton | Kentucky | 21117 | 18757 | 220 |
1635742 | 1635742 | 2021-08-20 | Kenton | Kentucky | 21117 | 18757 | 220 |
1632492 | 1632492 | 2021-08-19 | Kenton | Kentucky | 21117 | 18675 | 220 |
1629245 | 1629245 | 2021-08-18 | Kenton | Kentucky | 21117 | 18558 | 220 |
1625998 | 1625998 | 2021-08-17 | Kenton | Kentucky | 21117 | 18511 | 220 |
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);