ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 21233 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717010 | 1717010 | 2021-09-14 | Webster | Kentucky | 21233 | 2162 | 29 |
1713764 | 1713764 | 2021-09-13 | Webster | Kentucky | 21233 | 2140 | 29 |
1710517 | 1710517 | 2021-09-12 | Webster | Kentucky | 21233 | 2109 | 29 |
1707270 | 1707270 | 2021-09-11 | Webster | Kentucky | 21233 | 2109 | 29 |
1704022 | 1704022 | 2021-09-10 | Webster | Kentucky | 21233 | 2109 | 29 |
1700772 | 1700772 | 2021-09-09 | Webster | Kentucky | 21233 | 2095 | 29 |
1697523 | 1697523 | 2021-09-08 | Webster | Kentucky | 21233 | 2078 | 28 |
1694275 | 1694275 | 2021-09-07 | Webster | Kentucky | 21233 | 2055 | 28 |
1691026 | 1691026 | 2021-09-06 | Webster | Kentucky | 21233 | 2011 | 28 |
1687776 | 1687776 | 2021-09-05 | Webster | Kentucky | 21233 | 2011 | 28 |
1684526 | 1684526 | 2021-09-04 | Webster | Kentucky | 21233 | 2011 | 28 |
1681275 | 1681275 | 2021-09-03 | Webster | Kentucky | 21233 | 2011 | 28 |
1678027 | 1678027 | 2021-09-02 | Webster | Kentucky | 21233 | 1990 | 28 |
1674780 | 1674780 | 2021-09-01 | Webster | Kentucky | 21233 | 1970 | 26 |
1671531 | 1671531 | 2021-08-31 | Webster | Kentucky | 21233 | 1940 | 26 |
1668284 | 1668284 | 2021-08-30 | Webster | Kentucky | 21233 | 1934 | 26 |
1665037 | 1665037 | 2021-08-29 | Webster | Kentucky | 21233 | 1903 | 26 |
1661789 | 1661789 | 2021-08-28 | Webster | Kentucky | 21233 | 1903 | 26 |
1658541 | 1658541 | 2021-08-27 | Webster | Kentucky | 21233 | 1903 | 26 |
1655293 | 1655293 | 2021-08-26 | Webster | Kentucky | 21233 | 1879 | 26 |
1652046 | 1652046 | 2021-08-25 | Webster | Kentucky | 21233 | 1865 | 26 |
1648797 | 1648797 | 2021-08-24 | Webster | Kentucky | 21233 | 1849 | 26 |
1645549 | 1645549 | 2021-08-23 | Webster | Kentucky | 21233 | 1829 | 26 |
1642300 | 1642300 | 2021-08-22 | Webster | Kentucky | 21233 | 1803 | 26 |
1639050 | 1639050 | 2021-08-21 | Webster | Kentucky | 21233 | 1803 | 26 |
1635800 | 1635800 | 2021-08-20 | Webster | Kentucky | 21233 | 1803 | 26 |
1632550 | 1632550 | 2021-08-19 | Webster | Kentucky | 21233 | 1787 | 25 |
1629303 | 1629303 | 2021-08-18 | Webster | Kentucky | 21233 | 1756 | 25 |
1626056 | 1626056 | 2021-08-17 | Webster | Kentucky | 21233 | 1740 | 25 |
1622809 | 1622809 | 2021-08-16 | Webster | Kentucky | 21233 | 1728 | 25 |
1619562 | 1619562 | 2021-08-15 | Webster | Kentucky | 21233 | 1706 | 25 |
1616314 | 1616314 | 2021-08-14 | Webster | Kentucky | 21233 | 1706 | 25 |
1613065 | 1613065 | 2021-08-13 | Webster | Kentucky | 21233 | 1706 | 25 |
1609817 | 1609817 | 2021-08-12 | Webster | Kentucky | 21233 | 1689 | 25 |
1606568 | 1606568 | 2021-08-11 | Webster | Kentucky | 21233 | 1676 | 25 |
1603319 | 1603319 | 2021-08-10 | Webster | Kentucky | 21233 | 1660 | 25 |
1600070 | 1600070 | 2021-08-09 | Webster | Kentucky | 21233 | 1645 | 25 |
1596822 | 1596822 | 2021-08-08 | Webster | Kentucky | 21233 | 1611 | 25 |
1593573 | 1593573 | 2021-08-07 | Webster | Kentucky | 21233 | 1611 | 25 |
1590324 | 1590324 | 2021-08-06 | Webster | Kentucky | 21233 | 1611 | 25 |
1587075 | 1587075 | 2021-08-05 | Webster | Kentucky | 21233 | 1597 | 24 |
1583825 | 1583825 | 2021-08-04 | Webster | Kentucky | 21233 | 1585 | 24 |
1580575 | 1580575 | 2021-08-03 | Webster | Kentucky | 21233 | 1564 | 24 |
1577326 | 1577326 | 2021-08-02 | Webster | Kentucky | 21233 | 1554 | 23 |
1574078 | 1574078 | 2021-08-01 | Webster | Kentucky | 21233 | 1532 | 23 |
1570830 | 1570830 | 2021-07-31 | Webster | Kentucky | 21233 | 1532 | 23 |
1567582 | 1567582 | 2021-07-30 | Webster | Kentucky | 21233 | 1532 | 23 |
1564334 | 1564334 | 2021-07-29 | Webster | Kentucky | 21233 | 1529 | 22 |
1561086 | 1561086 | 2021-07-28 | Webster | Kentucky | 21233 | 1518 | 22 |
1557839 | 1557839 | 2021-07-27 | Webster | Kentucky | 21233 | 1510 | 22 |
1554592 | 1554592 | 2021-07-26 | Webster | Kentucky | 21233 | 1502 | 22 |
1551345 | 1551345 | 2021-07-25 | Webster | Kentucky | 21233 | 1490 | 22 |
1548098 | 1548098 | 2021-07-24 | Webster | Kentucky | 21233 | 1490 | 22 |
1544851 | 1544851 | 2021-07-23 | Webster | Kentucky | 21233 | 1490 | 22 |
1541603 | 1541603 | 2021-07-22 | Webster | Kentucky | 21233 | 1482 | 22 |
1538356 | 1538356 | 2021-07-21 | Webster | Kentucky | 21233 | 1475 | 22 |
1535108 | 1535108 | 2021-07-20 | Webster | Kentucky | 21233 | 1468 | 22 |
1531861 | 1531861 | 2021-07-19 | Webster | Kentucky | 21233 | 1458 | 22 |
1528614 | 1528614 | 2021-07-18 | Webster | Kentucky | 21233 | 1452 | 22 |
1525367 | 1525367 | 2021-07-17 | Webster | Kentucky | 21233 | 1452 | 22 |
1522119 | 1522119 | 2021-07-16 | Webster | Kentucky | 21233 | 1452 | 22 |
1518871 | 1518871 | 2021-07-15 | Webster | Kentucky | 21233 | 1450 | 22 |
1515624 | 1515624 | 2021-07-14 | Webster | Kentucky | 21233 | 1443 | 22 |
1512378 | 1512378 | 2021-07-13 | Webster | Kentucky | 21233 | 1442 | 22 |
1509131 | 1509131 | 2021-07-12 | Webster | Kentucky | 21233 | 1433 | 22 |
1505885 | 1505885 | 2021-07-11 | Webster | Kentucky | 21233 | 1427 | 22 |
1502639 | 1502639 | 2021-07-10 | Webster | Kentucky | 21233 | 1427 | 22 |
1499393 | 1499393 | 2021-07-09 | Webster | Kentucky | 21233 | 1427 | 22 |
1496146 | 1496146 | 2021-07-08 | Webster | Kentucky | 21233 | 1427 | 22 |
1492900 | 1492900 | 2021-07-07 | Webster | Kentucky | 21233 | 1427 | 22 |
1489653 | 1489653 | 2021-07-06 | Webster | Kentucky | 21233 | 1423 | 22 |
1486406 | 1486406 | 2021-07-05 | Webster | Kentucky | 21233 | 1421 | 22 |
1483160 | 1483160 | 2021-07-04 | Webster | Kentucky | 21233 | 1421 | 22 |
1479913 | 1479913 | 2021-07-03 | Webster | Kentucky | 21233 | 1421 | 22 |
1476667 | 1476667 | 2021-07-02 | Webster | Kentucky | 21233 | 1421 | 22 |
1473421 | 1473421 | 2021-07-01 | Webster | Kentucky | 21233 | 1419 | 22 |
1470175 | 1470175 | 2021-06-30 | Webster | Kentucky | 21233 | 1419 | 22 |
1466930 | 1466930 | 2021-06-29 | Webster | Kentucky | 21233 | 1414 | 22 |
1463685 | 1463685 | 2021-06-28 | Webster | Kentucky | 21233 | 1411 | 22 |
1460440 | 1460440 | 2021-06-27 | Webster | Kentucky | 21233 | 1406 | 22 |
1457195 | 1457195 | 2021-06-26 | Webster | Kentucky | 21233 | 1406 | 22 |
1453950 | 1453950 | 2021-06-25 | Webster | Kentucky | 21233 | 1406 | 22 |
1450704 | 1450704 | 2021-06-24 | Webster | Kentucky | 21233 | 1405 | 22 |
1447459 | 1447459 | 2021-06-23 | Webster | Kentucky | 21233 | 1402 | 22 |
1444214 | 1444214 | 2021-06-22 | Webster | Kentucky | 21233 | 1402 | 22 |
1440969 | 1440969 | 2021-06-21 | Webster | Kentucky | 21233 | 1400 | 21 |
1437722 | 1437722 | 2021-06-20 | Webster | Kentucky | 21233 | 1396 | 21 |
1434475 | 1434475 | 2021-06-19 | Webster | Kentucky | 21233 | 1396 | 21 |
1431229 | 1431229 | 2021-06-18 | Webster | Kentucky | 21233 | 1396 | 21 |
1427984 | 1427984 | 2021-06-17 | Webster | Kentucky | 21233 | 1394 | 21 |
1424739 | 1424739 | 2021-06-16 | Webster | Kentucky | 21233 | 1393 | 21 |
1421491 | 1421491 | 2021-06-15 | Webster | Kentucky | 21233 | 1385 | 21 |
1418246 | 1418246 | 2021-06-14 | Webster | Kentucky | 21233 | 1383 | 21 |
1415000 | 1415000 | 2021-06-13 | Webster | Kentucky | 21233 | 1383 | 21 |
1411755 | 1411755 | 2021-06-12 | Webster | Kentucky | 21233 | 1383 | 21 |
1408510 | 1408510 | 2021-06-11 | Webster | Kentucky | 21233 | 1381 | 21 |
1405264 | 1405264 | 2021-06-10 | Webster | Kentucky | 21233 | 1379 | 21 |
1402019 | 1402019 | 2021-06-09 | Webster | Kentucky | 21233 | 1376 | 21 |
1398774 | 1398774 | 2021-06-08 | Webster | Kentucky | 21233 | 1373 | 21 |
1395527 | 1395527 | 2021-06-07 | Webster | Kentucky | 21233 | 1355 | 21 |
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);