ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 21031 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947613 | 1947613 | 2021-11-24 | Butler | Kentucky | 21031 | 2462 | 40 |
1944362 | 1944362 | 2021-11-23 | Butler | Kentucky | 21031 | 2454 | 40 |
1941112 | 1941112 | 2021-11-22 | Butler | Kentucky | 21031 | 2449 | 40 |
1937862 | 1937862 | 2021-11-21 | Butler | Kentucky | 21031 | 2433 | 40 |
1934612 | 1934612 | 2021-11-20 | Butler | Kentucky | 21031 | 2433 | 40 |
1931361 | 1931361 | 2021-11-19 | Butler | Kentucky | 21031 | 2433 | 40 |
1928110 | 1928110 | 2021-11-18 | Butler | Kentucky | 21031 | 2430 | 40 |
1924860 | 1924860 | 2021-11-17 | Butler | Kentucky | 21031 | 2424 | 40 |
1921611 | 1921611 | 2021-11-16 | Butler | Kentucky | 21031 | 2408 | 40 |
1918361 | 1918361 | 2021-11-15 | Butler | Kentucky | 21031 | 2397 | 40 |
1915111 | 1915111 | 2021-11-14 | Butler | Kentucky | 21031 | 2384 | 40 |
1911861 | 1911861 | 2021-11-13 | Butler | Kentucky | 21031 | 2384 | 40 |
1908612 | 1908612 | 2021-11-12 | Butler | Kentucky | 21031 | 2384 | 40 |
1905363 | 1905363 | 2021-11-11 | Butler | Kentucky | 21031 | 2374 | 39 |
1902113 | 1902113 | 2021-11-10 | Butler | Kentucky | 21031 | 2374 | 39 |
1898863 | 1898863 | 2021-11-09 | Butler | Kentucky | 21031 | 2365 | 39 |
1895613 | 1895613 | 2021-11-08 | Butler | Kentucky | 21031 | 2365 | 39 |
1892363 | 1892363 | 2021-11-07 | Butler | Kentucky | 21031 | 2363 | 37 |
1889113 | 1889113 | 2021-11-06 | Butler | Kentucky | 21031 | 2363 | 37 |
1885863 | 1885863 | 2021-11-05 | Butler | Kentucky | 21031 | 2363 | 37 |
1882614 | 1882614 | 2021-11-04 | Butler | Kentucky | 21031 | 2359 | 37 |
1879365 | 1879365 | 2021-11-03 | Butler | Kentucky | 21031 | 2359 | 37 |
1876116 | 1876116 | 2021-11-02 | Butler | Kentucky | 21031 | 2351 | 37 |
1872867 | 1872867 | 2021-11-01 | Butler | Kentucky | 21031 | 2349 | 37 |
1869618 | 1869618 | 2021-10-31 | Butler | Kentucky | 21031 | 2343 | 36 |
1866369 | 1866369 | 2021-10-30 | Butler | Kentucky | 21031 | 2343 | 36 |
1863120 | 1863120 | 2021-10-29 | Butler | Kentucky | 21031 | 2343 | 36 |
1859871 | 1859871 | 2021-10-28 | Butler | Kentucky | 21031 | 2338 | 36 |
1856622 | 1856622 | 2021-10-27 | Butler | Kentucky | 21031 | 2334 | 35 |
1853373 | 1853373 | 2021-10-26 | Butler | Kentucky | 21031 | 2330 | 35 |
1850124 | 1850124 | 2021-10-25 | Butler | Kentucky | 21031 | 2323 | 35 |
1846874 | 1846874 | 2021-10-24 | Butler | Kentucky | 21031 | 2319 | 35 |
1843624 | 1843624 | 2021-10-23 | Butler | Kentucky | 21031 | 2319 | 35 |
1840374 | 1840374 | 2021-10-22 | Butler | Kentucky | 21031 | 2319 | 35 |
1837125 | 1837125 | 2021-10-21 | Butler | Kentucky | 21031 | 2313 | 35 |
1833876 | 1833876 | 2021-10-20 | Butler | Kentucky | 21031 | 2313 | 35 |
1830627 | 1830627 | 2021-10-19 | Butler | Kentucky | 21031 | 2305 | 35 |
1827378 | 1827378 | 2021-10-18 | Butler | Kentucky | 21031 | 2299 | 34 |
1824129 | 1824129 | 2021-10-17 | Butler | Kentucky | 21031 | 2295 | 32 |
1820880 | 1820880 | 2021-10-16 | Butler | Kentucky | 21031 | 2295 | 32 |
1817631 | 1817631 | 2021-10-15 | Butler | Kentucky | 21031 | 2295 | 32 |
1814383 | 1814383 | 2021-10-14 | Butler | Kentucky | 21031 | 2289 | 32 |
1811134 | 1811134 | 2021-10-13 | Butler | Kentucky | 21031 | 2285 | 32 |
1807885 | 1807885 | 2021-10-12 | Butler | Kentucky | 21031 | 2279 | 32 |
1804634 | 1804634 | 2021-10-11 | Butler | Kentucky | 21031 | 2275 | 32 |
1801385 | 1801385 | 2021-10-10 | Butler | Kentucky | 21031 | 2259 | 31 |
1798136 | 1798136 | 2021-10-09 | Butler | Kentucky | 21031 | 2259 | 31 |
1794887 | 1794887 | 2021-10-08 | Butler | Kentucky | 21031 | 2259 | 31 |
1791639 | 1791639 | 2021-10-07 | Butler | Kentucky | 21031 | 2252 | 31 |
1788390 | 1788390 | 2021-10-06 | Butler | Kentucky | 21031 | 2245 | 31 |
1785141 | 1785141 | 2021-10-05 | Butler | Kentucky | 21031 | 2243 | 29 |
1781892 | 1781892 | 2021-10-04 | Butler | Kentucky | 21031 | 2232 | 29 |
1778642 | 1778642 | 2021-10-03 | Butler | Kentucky | 21031 | 2224 | 29 |
1775392 | 1775392 | 2021-10-02 | Butler | Kentucky | 21031 | 2224 | 29 |
1772142 | 1772142 | 2021-10-01 | Butler | Kentucky | 21031 | 2224 | 29 |
1768893 | 1768893 | 2021-09-30 | Butler | Kentucky | 21031 | 2215 | 29 |
1765644 | 1765644 | 2021-09-29 | Butler | Kentucky | 21031 | 2203 | 29 |
1762395 | 1762395 | 2021-09-28 | Butler | Kentucky | 21031 | 2191 | 29 |
1759147 | 1759147 | 2021-09-27 | Butler | Kentucky | 21031 | 2183 | 29 |
1755899 | 1755899 | 2021-09-26 | Butler | Kentucky | 21031 | 2171 | 29 |
1752651 | 1752651 | 2021-09-25 | Butler | Kentucky | 21031 | 2171 | 29 |
1749402 | 1749402 | 2021-09-24 | Butler | Kentucky | 21031 | 2171 | 29 |
1746152 | 1746152 | 2021-09-23 | Butler | Kentucky | 21031 | 2164 | 29 |
1742903 | 1742903 | 2021-09-22 | Butler | Kentucky | 21031 | 2144 | 29 |
1739654 | 1739654 | 2021-09-21 | Butler | Kentucky | 21031 | 2130 | 29 |
1736405 | 1736405 | 2021-09-20 | Butler | Kentucky | 21031 | 2114 | 29 |
1733155 | 1733155 | 2021-09-19 | Butler | Kentucky | 21031 | 2085 | 29 |
1729905 | 1729905 | 2021-09-18 | Butler | Kentucky | 21031 | 2085 | 29 |
1726655 | 1726655 | 2021-09-17 | Butler | Kentucky | 21031 | 2085 | 29 |
1723406 | 1723406 | 2021-09-16 | Butler | Kentucky | 21031 | 2060 | 29 |
1720157 | 1720157 | 2021-09-15 | Butler | Kentucky | 21031 | 2039 | 29 |
1716909 | 1716909 | 2021-09-14 | Butler | Kentucky | 21031 | 2018 | 29 |
1713663 | 1713663 | 2021-09-13 | Butler | Kentucky | 21031 | 2005 | 29 |
1710416 | 1710416 | 2021-09-12 | Butler | Kentucky | 21031 | 1973 | 28 |
1707169 | 1707169 | 2021-09-11 | Butler | Kentucky | 21031 | 1973 | 28 |
1703921 | 1703921 | 2021-09-10 | Butler | Kentucky | 21031 | 1973 | 28 |
1700671 | 1700671 | 2021-09-09 | Butler | Kentucky | 21031 | 1932 | 28 |
1697422 | 1697422 | 2021-09-08 | Butler | Kentucky | 21031 | 1918 | 28 |
1694174 | 1694174 | 2021-09-07 | Butler | Kentucky | 21031 | 1889 | 28 |
1690925 | 1690925 | 2021-09-06 | Butler | Kentucky | 21031 | 1845 | 28 |
1687675 | 1687675 | 2021-09-05 | Butler | Kentucky | 21031 | 1845 | 28 |
1684425 | 1684425 | 2021-09-04 | Butler | Kentucky | 21031 | 1845 | 28 |
1681174 | 1681174 | 2021-09-03 | Butler | Kentucky | 21031 | 1845 | 28 |
1677926 | 1677926 | 2021-09-02 | Butler | Kentucky | 21031 | 1829 | 28 |
1674679 | 1674679 | 2021-09-01 | Butler | Kentucky | 21031 | 1813 | 28 |
1671430 | 1671430 | 2021-08-31 | Butler | Kentucky | 21031 | 1800 | 28 |
1668183 | 1668183 | 2021-08-30 | Butler | Kentucky | 21031 | 1778 | 28 |
1664936 | 1664936 | 2021-08-29 | Butler | Kentucky | 21031 | 1753 | 28 |
1661688 | 1661688 | 2021-08-28 | Butler | Kentucky | 21031 | 1753 | 28 |
1658440 | 1658440 | 2021-08-27 | Butler | Kentucky | 21031 | 1753 | 28 |
1655192 | 1655192 | 2021-08-26 | Butler | Kentucky | 21031 | 1729 | 28 |
1651945 | 1651945 | 2021-08-25 | Butler | Kentucky | 21031 | 1711 | 28 |
1648696 | 1648696 | 2021-08-24 | Butler | Kentucky | 21031 | 1694 | 28 |
1645448 | 1645448 | 2021-08-23 | Butler | Kentucky | 21031 | 1677 | 28 |
1642199 | 1642199 | 2021-08-22 | Butler | Kentucky | 21031 | 1657 | 28 |
1638949 | 1638949 | 2021-08-21 | Butler | Kentucky | 21031 | 1657 | 28 |
1635699 | 1635699 | 2021-08-20 | Butler | Kentucky | 21031 | 1657 | 28 |
1632449 | 1632449 | 2021-08-19 | Butler | Kentucky | 21031 | 1649 | 28 |
1629202 | 1629202 | 2021-08-18 | Butler | Kentucky | 21031 | 1634 | 28 |
1625955 | 1625955 | 2021-08-17 | Butler | Kentucky | 21031 | 1619 | 28 |
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);