ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 21111 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947653 | 1947653 | 2021-11-24 | Jefferson | Kentucky | 21111 | 125037 | 1712 |
1944402 | 1944402 | 2021-11-23 | Jefferson | Kentucky | 21111 | 124767 | 1711 |
1941152 | 1941152 | 2021-11-22 | Jefferson | Kentucky | 21111 | 124525 | 1690 |
1937902 | 1937902 | 2021-11-21 | Jefferson | Kentucky | 21111 | 123978 | 1684 |
1934652 | 1934652 | 2021-11-20 | Jefferson | Kentucky | 21111 | 123978 | 1682 |
1931401 | 1931401 | 2021-11-19 | Jefferson | Kentucky | 21111 | 123978 | 1679 |
1928150 | 1928150 | 2021-11-18 | Jefferson | Kentucky | 21111 | 123769 | 1666 |
1924900 | 1924900 | 2021-11-17 | Jefferson | Kentucky | 21111 | 123565 | 1657 |
1921651 | 1921651 | 2021-11-16 | Jefferson | Kentucky | 21111 | 123314 | 1653 |
1918401 | 1918401 | 2021-11-15 | Jefferson | Kentucky | 21111 | 123144 | 1641 |
1915151 | 1915151 | 2021-11-14 | Jefferson | Kentucky | 21111 | 122722 | 1641 |
1911901 | 1911901 | 2021-11-13 | Jefferson | Kentucky | 21111 | 122722 | 1640 |
1908652 | 1908652 | 2021-11-12 | Jefferson | Kentucky | 21111 | 122722 | 1631 |
1905403 | 1905403 | 2021-11-11 | Jefferson | Kentucky | 21111 | 122299 | 1612 |
1902153 | 1902153 | 2021-11-10 | Jefferson | Kentucky | 21111 | 122299 | 1602 |
1898903 | 1898903 | 2021-11-09 | Jefferson | Kentucky | 21111 | 122028 | 1597 |
1895653 | 1895653 | 2021-11-08 | Jefferson | Kentucky | 21111 | 121817 | 1593 |
1892403 | 1892403 | 2021-11-07 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1889153 | 1889153 | 2021-11-06 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1885903 | 1885903 | 2021-11-05 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1882654 | 1882654 | 2021-11-04 | Jefferson | Kentucky | 21111 | 121270 | 1586 |
1879405 | 1879405 | 2021-11-03 | Jefferson | Kentucky | 21111 | 121016 | 1583 |
1876156 | 1876156 | 2021-11-02 | Jefferson | Kentucky | 21111 | 120761 | 1581 |
1872907 | 1872907 | 2021-11-01 | Jefferson | Kentucky | 21111 | 120597 | 1573 |
1869658 | 1869658 | 2021-10-31 | Jefferson | Kentucky | 21111 | 120254 | 1570 |
1866409 | 1866409 | 2021-10-30 | Jefferson | Kentucky | 21111 | 120254 | 1569 |
1863160 | 1863160 | 2021-10-29 | Jefferson | Kentucky | 21111 | 120254 | 1569 |
1859911 | 1859911 | 2021-10-28 | Jefferson | Kentucky | 21111 | 120047 | 1569 |
1856662 | 1856662 | 2021-10-27 | Jefferson | Kentucky | 21111 | 119814 | 1567 |
1853413 | 1853413 | 2021-10-26 | Jefferson | Kentucky | 21111 | 119580 | 1567 |
1850164 | 1850164 | 2021-10-25 | Jefferson | Kentucky | 21111 | 119384 | 1565 |
1846914 | 1846914 | 2021-10-24 | Jefferson | Kentucky | 21111 | 118916 | 1564 |
1843664 | 1843664 | 2021-10-23 | Jefferson | Kentucky | 21111 | 118916 | 1564 |
1840414 | 1840414 | 2021-10-22 | Jefferson | Kentucky | 21111 | 118916 | 1564 |
1837165 | 1837165 | 2021-10-21 | Jefferson | Kentucky | 21111 | 118682 | 1562 |
1833916 | 1833916 | 2021-10-20 | Jefferson | Kentucky | 21111 | 118438 | 1558 |
1830667 | 1830667 | 2021-10-19 | Jefferson | Kentucky | 21111 | 118162 | 1557 |
1827418 | 1827418 | 2021-10-18 | Jefferson | Kentucky | 21111 | 117991 | 1557 |
1824169 | 1824169 | 2021-10-17 | Jefferson | Kentucky | 21111 | 117371 | 1556 |
1820920 | 1820920 | 2021-10-16 | Jefferson | Kentucky | 21111 | 117371 | 1556 |
1817671 | 1817671 | 2021-10-15 | Jefferson | Kentucky | 21111 | 117371 | 1556 |
1814423 | 1814423 | 2021-10-14 | Jefferson | Kentucky | 21111 | 117081 | 1554 |
1811174 | 1811174 | 2021-10-13 | Jefferson | Kentucky | 21111 | 116662 | 1552 |
1807925 | 1807925 | 2021-10-12 | Jefferson | Kentucky | 21111 | 116297 | 1549 |
1804674 | 1804674 | 2021-10-11 | Jefferson | Kentucky | 21111 | 116038 | 1545 |
1801425 | 1801425 | 2021-10-10 | Jefferson | Kentucky | 21111 | 115276 | 1537 |
1798176 | 1798176 | 2021-10-09 | Jefferson | Kentucky | 21111 | 115276 | 1537 |
1794927 | 1794927 | 2021-10-08 | Jefferson | Kentucky | 21111 | 115276 | 1537 |
1791679 | 1791679 | 2021-10-07 | Jefferson | Kentucky | 21111 | 114970 | 1535 |
1788430 | 1788430 | 2021-10-06 | Jefferson | Kentucky | 21111 | 114521 | 1532 |
1785181 | 1785181 | 2021-10-05 | Jefferson | Kentucky | 21111 | 114214 | 1524 |
1781932 | 1781932 | 2021-10-04 | Jefferson | Kentucky | 21111 | 113858 | 1522 |
1778682 | 1778682 | 2021-10-03 | Jefferson | Kentucky | 21111 | 113209 | 1520 |
1775432 | 1775432 | 2021-10-02 | Jefferson | Kentucky | 21111 | 113209 | 1517 |
1772182 | 1772182 | 2021-10-01 | Jefferson | Kentucky | 21111 | 113209 | 1514 |
1768933 | 1768933 | 2021-09-30 | Jefferson | Kentucky | 21111 | 112496 | 1509 |
1765684 | 1765684 | 2021-09-29 | Jefferson | Kentucky | 21111 | 112291 | 1507 |
1762435 | 1762435 | 2021-09-28 | Jefferson | Kentucky | 21111 | 111388 | 1500 |
1759187 | 1759187 | 2021-09-27 | Jefferson | Kentucky | 21111 | 109514 | 1489 |
1755939 | 1755939 | 2021-09-26 | Jefferson | Kentucky | 21111 | 108946 | 1489 |
1752691 | 1752691 | 2021-09-25 | Jefferson | Kentucky | 21111 | 108745 | 1488 |
1749442 | 1749442 | 2021-09-24 | Jefferson | Kentucky | 21111 | 108745 | 1482 |
1746192 | 1746192 | 2021-09-23 | Jefferson | Kentucky | 21111 | 108251 | 1480 |
1742943 | 1742943 | 2021-09-22 | Jefferson | Kentucky | 21111 | 107818 | 1476 |
1739694 | 1739694 | 2021-09-21 | Jefferson | Kentucky | 21111 | 107392 | 1472 |
1736445 | 1736445 | 2021-09-20 | Jefferson | Kentucky | 21111 | 107012 | 1466 |
1733195 | 1733195 | 2021-09-19 | Jefferson | Kentucky | 21111 | 106392 | 1458 |
1729945 | 1729945 | 2021-09-18 | Jefferson | Kentucky | 21111 | 106044 | 1458 |
1726695 | 1726695 | 2021-09-17 | Jefferson | Kentucky | 21111 | 106044 | 1454 |
1723446 | 1723446 | 2021-09-16 | Jefferson | Kentucky | 21111 | 105500 | 1451 |
1720197 | 1720197 | 2021-09-15 | Jefferson | Kentucky | 21111 | 105040 | 1445 |
1716949 | 1716949 | 2021-09-14 | Jefferson | Kentucky | 21111 | 104393 | 1442 |
1713703 | 1713703 | 2021-09-13 | Jefferson | Kentucky | 21111 | 103863 | 1442 |
1710456 | 1710456 | 2021-09-12 | Jefferson | Kentucky | 21111 | 102730 | 1435 |
1707209 | 1707209 | 2021-09-11 | Jefferson | Kentucky | 21111 | 102730 | 1435 |
1703961 | 1703961 | 2021-09-10 | Jefferson | Kentucky | 21111 | 102730 | 1435 |
1700711 | 1700711 | 2021-09-09 | Jefferson | Kentucky | 21111 | 102135 | 1435 |
1697462 | 1697462 | 2021-09-08 | Jefferson | Kentucky | 21111 | 101566 | 1433 |
1694214 | 1694214 | 2021-09-07 | Jefferson | Kentucky | 21111 | 101075 | 1425 |
1690965 | 1690965 | 2021-09-06 | Jefferson | Kentucky | 21111 | 100317 | 1421 |
1687715 | 1687715 | 2021-09-05 | Jefferson | Kentucky | 21111 | 99711 | 1421 |
1684465 | 1684465 | 2021-09-04 | Jefferson | Kentucky | 21111 | 99498 | 1421 |
1681214 | 1681214 | 2021-09-03 | Jefferson | Kentucky | 21111 | 99407 | 1421 |
1677966 | 1677966 | 2021-09-02 | Jefferson | Kentucky | 21111 | 98866 | 1420 |
1674719 | 1674719 | 2021-09-01 | Jefferson | Kentucky | 21111 | 98118 | 1413 |
1671470 | 1671470 | 2021-08-31 | Jefferson | Kentucky | 21111 | 97499 | 1413 |
1668223 | 1668223 | 2021-08-30 | Jefferson | Kentucky | 21111 | 96963 | 1410 |
1664976 | 1664976 | 2021-08-29 | Jefferson | Kentucky | 21111 | 96206 | 1398 |
1661728 | 1661728 | 2021-08-28 | Jefferson | Kentucky | 21111 | 95620 | 1398 |
1658480 | 1658480 | 2021-08-27 | Jefferson | Kentucky | 21111 | 95620 | 1398 |
1655232 | 1655232 | 2021-08-26 | Jefferson | Kentucky | 21111 | 95106 | 1396 |
1651985 | 1651985 | 2021-08-25 | Jefferson | Kentucky | 21111 | 94344 | 1393 |
1648736 | 1648736 | 2021-08-24 | Jefferson | Kentucky | 21111 | 93702 | 1386 |
1645488 | 1645488 | 2021-08-23 | Jefferson | Kentucky | 21111 | 93146 | 1385 |
1642239 | 1642239 | 2021-08-22 | Jefferson | Kentucky | 21111 | 92289 | 1379 |
1638989 | 1638989 | 2021-08-21 | Jefferson | Kentucky | 21111 | 91892 | 1379 |
1635739 | 1635739 | 2021-08-20 | Jefferson | Kentucky | 21111 | 91863 | 1379 |
1632489 | 1632489 | 2021-08-19 | Jefferson | Kentucky | 21111 | 91336 | 1367 |
1629242 | 1629242 | 2021-08-18 | Jefferson | Kentucky | 21111 | 90713 | 1362 |
1625995 | 1625995 | 2021-08-17 | Jefferson | Kentucky | 21111 | 90297 | 1360 |
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);