ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 21135 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811186 | 1811186 | 2021-10-13 | Lewis | Kentucky | 21135 | 2436 | 55 |
1807937 | 1807937 | 2021-10-12 | Lewis | Kentucky | 21135 | 2422 | 55 |
1804686 | 1804686 | 2021-10-11 | Lewis | Kentucky | 21135 | 2409 | 55 |
1801437 | 1801437 | 2021-10-10 | Lewis | Kentucky | 21135 | 2392 | 54 |
1798188 | 1798188 | 2021-10-09 | Lewis | Kentucky | 21135 | 2392 | 54 |
1794939 | 1794939 | 2021-10-08 | Lewis | Kentucky | 21135 | 2392 | 54 |
1791691 | 1791691 | 2021-10-07 | Lewis | Kentucky | 21135 | 2326 | 54 |
1788442 | 1788442 | 2021-10-06 | Lewis | Kentucky | 21135 | 2295 | 54 |
1785193 | 1785193 | 2021-10-05 | Lewis | Kentucky | 21135 | 2259 | 54 |
1781944 | 1781944 | 2021-10-04 | Lewis | Kentucky | 21135 | 2249 | 54 |
1778694 | 1778694 | 2021-10-03 | Lewis | Kentucky | 21135 | 2243 | 54 |
1775444 | 1775444 | 2021-10-02 | Lewis | Kentucky | 21135 | 2243 | 54 |
1772194 | 1772194 | 2021-10-01 | Lewis | Kentucky | 21135 | 2243 | 54 |
1768945 | 1768945 | 2021-09-30 | Lewis | Kentucky | 21135 | 2230 | 54 |
1765696 | 1765696 | 2021-09-29 | Lewis | Kentucky | 21135 | 2213 | 53 |
1762447 | 1762447 | 2021-09-28 | Lewis | Kentucky | 21135 | 2203 | 52 |
1759199 | 1759199 | 2021-09-27 | Lewis | Kentucky | 21135 | 2196 | 52 |
1755951 | 1755951 | 2021-09-26 | Lewis | Kentucky | 21135 | 2178 | 51 |
1752703 | 1752703 | 2021-09-25 | Lewis | Kentucky | 21135 | 2178 | 51 |
1749454 | 1749454 | 2021-09-24 | Lewis | Kentucky | 21135 | 2178 | 51 |
1746204 | 1746204 | 2021-09-23 | Lewis | Kentucky | 21135 | 2163 | 51 |
1742955 | 1742955 | 2021-09-22 | Lewis | Kentucky | 21135 | 2147 | 50 |
1739706 | 1739706 | 2021-09-21 | Lewis | Kentucky | 21135 | 2119 | 49 |
1736457 | 1736457 | 2021-09-20 | Lewis | Kentucky | 21135 | 2111 | 49 |
1733207 | 1733207 | 2021-09-19 | Lewis | Kentucky | 21135 | 2084 | 48 |
1729957 | 1729957 | 2021-09-18 | Lewis | Kentucky | 21135 | 2084 | 48 |
1726707 | 1726707 | 2021-09-17 | Lewis | Kentucky | 21135 | 2084 | 48 |
1723458 | 1723458 | 2021-09-16 | Lewis | Kentucky | 21135 | 2070 | 48 |
1720209 | 1720209 | 2021-09-15 | Lewis | Kentucky | 21135 | 2040 | 48 |
1716961 | 1716961 | 2021-09-14 | Lewis | Kentucky | 21135 | 2018 | 48 |
1713715 | 1713715 | 2021-09-13 | Lewis | Kentucky | 21135 | 2005 | 48 |
1710468 | 1710468 | 2021-09-12 | Lewis | Kentucky | 21135 | 1981 | 48 |
1707221 | 1707221 | 2021-09-11 | Lewis | Kentucky | 21135 | 1981 | 48 |
1703973 | 1703973 | 2021-09-10 | Lewis | Kentucky | 21135 | 1981 | 48 |
1700723 | 1700723 | 2021-09-09 | Lewis | Kentucky | 21135 | 1962 | 48 |
1697474 | 1697474 | 2021-09-08 | Lewis | Kentucky | 21135 | 1925 | 48 |
1694226 | 1694226 | 2021-09-07 | Lewis | Kentucky | 21135 | 1901 | 48 |
1690977 | 1690977 | 2021-09-06 | Lewis | Kentucky | 21135 | 1881 | 48 |
1687727 | 1687727 | 2021-09-05 | Lewis | Kentucky | 21135 | 1881 | 48 |
1684477 | 1684477 | 2021-09-04 | Lewis | Kentucky | 21135 | 1881 | 48 |
1681226 | 1681226 | 2021-09-03 | Lewis | Kentucky | 21135 | 1881 | 48 |
1677978 | 1677978 | 2021-09-02 | Lewis | Kentucky | 21135 | 1864 | 48 |
1674731 | 1674731 | 2021-09-01 | Lewis | Kentucky | 21135 | 1848 | 48 |
1671482 | 1671482 | 2021-08-31 | Lewis | Kentucky | 21135 | 1817 | 48 |
1668235 | 1668235 | 2021-08-30 | Lewis | Kentucky | 21135 | 1798 | 48 |
1664988 | 1664988 | 2021-08-29 | Lewis | Kentucky | 21135 | 1773 | 47 |
1661740 | 1661740 | 2021-08-28 | Lewis | Kentucky | 21135 | 1773 | 47 |
1658492 | 1658492 | 2021-08-27 | Lewis | Kentucky | 21135 | 1773 | 47 |
1655244 | 1655244 | 2021-08-26 | Lewis | Kentucky | 21135 | 1759 | 46 |
1651997 | 1651997 | 2021-08-25 | Lewis | Kentucky | 21135 | 1736 | 46 |
1648748 | 1648748 | 2021-08-24 | Lewis | Kentucky | 21135 | 1719 | 45 |
1645500 | 1645500 | 2021-08-23 | Lewis | Kentucky | 21135 | 1692 | 45 |
1642251 | 1642251 | 2021-08-22 | Lewis | Kentucky | 21135 | 1674 | 44 |
1639001 | 1639001 | 2021-08-21 | Lewis | Kentucky | 21135 | 1674 | 44 |
1635751 | 1635751 | 2021-08-20 | Lewis | Kentucky | 21135 | 1674 | 44 |
1632501 | 1632501 | 2021-08-19 | Lewis | Kentucky | 21135 | 1658 | 44 |
1629254 | 1629254 | 2021-08-18 | Lewis | Kentucky | 21135 | 1637 | 44 |
1626007 | 1626007 | 2021-08-17 | Lewis | Kentucky | 21135 | 1608 | 43 |
1622760 | 1622760 | 2021-08-16 | Lewis | Kentucky | 21135 | 1598 | 42 |
1619513 | 1619513 | 2021-08-15 | Lewis | Kentucky | 21135 | 1581 | 42 |
1616265 | 1616265 | 2021-08-14 | Lewis | Kentucky | 21135 | 1581 | 42 |
1613016 | 1613016 | 2021-08-13 | Lewis | Kentucky | 21135 | 1581 | 42 |
1609768 | 1609768 | 2021-08-12 | Lewis | Kentucky | 21135 | 1559 | 42 |
1606519 | 1606519 | 2021-08-11 | Lewis | Kentucky | 21135 | 1548 | 42 |
1603270 | 1603270 | 2021-08-10 | Lewis | Kentucky | 21135 | 1523 | 42 |
1600021 | 1600021 | 2021-08-09 | Lewis | Kentucky | 21135 | 1512 | 42 |
1596773 | 1596773 | 2021-08-08 | Lewis | Kentucky | 21135 | 1504 | 42 |
1593524 | 1593524 | 2021-08-07 | Lewis | Kentucky | 21135 | 1504 | 42 |
1590275 | 1590275 | 2021-08-06 | Lewis | Kentucky | 21135 | 1504 | 42 |
1587026 | 1587026 | 2021-08-05 | Lewis | Kentucky | 21135 | 1499 | 42 |
1583776 | 1583776 | 2021-08-04 | Lewis | Kentucky | 21135 | 1486 | 42 |
1580526 | 1580526 | 2021-08-03 | Lewis | Kentucky | 21135 | 1472 | 42 |
1577277 | 1577277 | 2021-08-02 | Lewis | Kentucky | 21135 | 1466 | 41 |
1574029 | 1574029 | 2021-08-01 | Lewis | Kentucky | 21135 | 1455 | 41 |
1570781 | 1570781 | 2021-07-31 | Lewis | Kentucky | 21135 | 1455 | 41 |
1567533 | 1567533 | 2021-07-30 | Lewis | Kentucky | 21135 | 1455 | 41 |
1564285 | 1564285 | 2021-07-29 | Lewis | Kentucky | 21135 | 1450 | 41 |
1561037 | 1561037 | 2021-07-28 | Lewis | Kentucky | 21135 | 1443 | 41 |
1557790 | 1557790 | 2021-07-27 | Lewis | Kentucky | 21135 | 1436 | 41 |
1554543 | 1554543 | 2021-07-26 | Lewis | Kentucky | 21135 | 1433 | 41 |
1551296 | 1551296 | 2021-07-25 | Lewis | Kentucky | 21135 | 1423 | 41 |
1548049 | 1548049 | 2021-07-24 | Lewis | Kentucky | 21135 | 1423 | 41 |
1544802 | 1544802 | 2021-07-23 | Lewis | Kentucky | 21135 | 1423 | 41 |
1541554 | 1541554 | 2021-07-22 | Lewis | Kentucky | 21135 | 1419 | 41 |
1538307 | 1538307 | 2021-07-21 | Lewis | Kentucky | 21135 | 1414 | 41 |
1535059 | 1535059 | 2021-07-20 | Lewis | Kentucky | 21135 | 1409 | 41 |
1531812 | 1531812 | 2021-07-19 | Lewis | Kentucky | 21135 | 1400 | 41 |
1528565 | 1528565 | 2021-07-18 | Lewis | Kentucky | 21135 | 1395 | 41 |
1525318 | 1525318 | 2021-07-17 | Lewis | Kentucky | 21135 | 1395 | 41 |
1522070 | 1522070 | 2021-07-16 | Lewis | Kentucky | 21135 | 1395 | 41 |
1518822 | 1518822 | 2021-07-15 | Lewis | Kentucky | 21135 | 1393 | 41 |
1515575 | 1515575 | 2021-07-14 | Lewis | Kentucky | 21135 | 1382 | 41 |
1512329 | 1512329 | 2021-07-13 | Lewis | Kentucky | 21135 | 1373 | 41 |
1509082 | 1509082 | 2021-07-12 | Lewis | Kentucky | 21135 | 1370 | 41 |
1505836 | 1505836 | 2021-07-11 | Lewis | Kentucky | 21135 | 1367 | 40 |
1502590 | 1502590 | 2021-07-10 | Lewis | Kentucky | 21135 | 1367 | 40 |
1499344 | 1499344 | 2021-07-09 | Lewis | Kentucky | 21135 | 1367 | 40 |
1496097 | 1496097 | 2021-07-08 | Lewis | Kentucky | 21135 | 1367 | 40 |
1492851 | 1492851 | 2021-07-07 | Lewis | Kentucky | 21135 | 1367 | 40 |
1489604 | 1489604 | 2021-07-06 | Lewis | Kentucky | 21135 | 1365 | 40 |
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);