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 |
---|---|---|---|---|---|---|---|
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 |
1622748 | 1622748 | 2021-08-16 | Jefferson | Kentucky | 21111 | 89907 | 1360 |
1619501 | 1619501 | 2021-08-15 | Jefferson | Kentucky | 21111 | 89118 | 1356 |
1616253 | 1616253 | 2021-08-14 | Jefferson | Kentucky | 21111 | 88986 | 1356 |
1613004 | 1613004 | 2021-08-13 | Jefferson | Kentucky | 21111 | 88986 | 1356 |
1609756 | 1609756 | 2021-08-12 | Jefferson | Kentucky | 21111 | 88502 | 1355 |
1606507 | 1606507 | 2021-08-11 | Jefferson | Kentucky | 21111 | 88189 | 1354 |
1603258 | 1603258 | 2021-08-10 | Jefferson | Kentucky | 21111 | 87845 | 1353 |
1600009 | 1600009 | 2021-08-09 | Jefferson | Kentucky | 21111 | 87633 | 1353 |
1596761 | 1596761 | 2021-08-08 | Jefferson | Kentucky | 21111 | 86960 | 1352 |
1593512 | 1593512 | 2021-08-07 | Jefferson | Kentucky | 21111 | 86838 | 1352 |
1590263 | 1590263 | 2021-08-06 | Jefferson | Kentucky | 21111 | 86838 | 1352 |
1587014 | 1587014 | 2021-08-05 | Jefferson | Kentucky | 21111 | 86524 | 1350 |
1583764 | 1583764 | 2021-08-04 | Jefferson | Kentucky | 21111 | 86189 | 1350 |
1580514 | 1580514 | 2021-08-03 | Jefferson | Kentucky | 21111 | 85901 | 1348 |
1577265 | 1577265 | 2021-08-02 | Jefferson | Kentucky | 21111 | 85706 | 1347 |
1574017 | 1574017 | 2021-08-01 | Jefferson | Kentucky | 21111 | 85181 | 1347 |
1570769 | 1570769 | 2021-07-31 | Jefferson | Kentucky | 21111 | 85181 | 1347 |
1567521 | 1567521 | 2021-07-30 | Jefferson | Kentucky | 21111 | 85181 | 1347 |
1564273 | 1564273 | 2021-07-29 | Jefferson | Kentucky | 21111 | 84967 | 1346 |
1561025 | 1561025 | 2021-07-28 | Jefferson | Kentucky | 21111 | 84777 | 1346 |
1557778 | 1557778 | 2021-07-27 | Jefferson | Kentucky | 21111 | 84626 | 1346 |
1554531 | 1554531 | 2021-07-26 | Jefferson | Kentucky | 21111 | 84513 | 1346 |
1551284 | 1551284 | 2021-07-25 | Jefferson | Kentucky | 21111 | 84173 | 1345 |
1548037 | 1548037 | 2021-07-24 | Jefferson | Kentucky | 21111 | 84173 | 1345 |
1544790 | 1544790 | 2021-07-23 | Jefferson | Kentucky | 21111 | 84173 | 1345 |
1541542 | 1541542 | 2021-07-22 | Jefferson | Kentucky | 21111 | 84043 | 1345 |
1538295 | 1538295 | 2021-07-21 | Jefferson | Kentucky | 21111 | 83939 | 1345 |
1535047 | 1535047 | 2021-07-20 | Jefferson | Kentucky | 21111 | 83857 | 1345 |
1531800 | 1531800 | 2021-07-19 | Jefferson | Kentucky | 21111 | 83752 | 1345 |
1528553 | 1528553 | 2021-07-18 | Jefferson | Kentucky | 21111 | 83574 | 1343 |
1525306 | 1525306 | 2021-07-17 | Jefferson | Kentucky | 21111 | 83574 | 1343 |
1522058 | 1522058 | 2021-07-16 | Jefferson | Kentucky | 21111 | 83574 | 1343 |
1518810 | 1518810 | 2021-07-15 | Jefferson | Kentucky | 21111 | 83529 | 1343 |
1515563 | 1515563 | 2021-07-14 | Jefferson | Kentucky | 21111 | 83477 | 1343 |
1512317 | 1512317 | 2021-07-13 | Jefferson | Kentucky | 21111 | 83425 | 1343 |
1509070 | 1509070 | 2021-07-12 | Jefferson | Kentucky | 21111 | 83393 | 1343 |
1505824 | 1505824 | 2021-07-11 | Jefferson | Kentucky | 21111 | 83274 | 1342 |
1502578 | 1502578 | 2021-07-10 | Jefferson | Kentucky | 21111 | 83274 | 1342 |
1499332 | 1499332 | 2021-07-09 | Jefferson | Kentucky | 21111 | 83274 | 1342 |
1496085 | 1496085 | 2021-07-08 | Jefferson | Kentucky | 21111 | 83255 | 1341 |
1492839 | 1492839 | 2021-07-07 | Jefferson | Kentucky | 21111 | 83236 | 1341 |
1489592 | 1489592 | 2021-07-06 | Jefferson | Kentucky | 21111 | 83251 | 1341 |
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);