ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21101 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716944 | 1716944 | 2021-09-14 | Henderson | Kentucky | 21101 | 7142 | 88 |
1713698 | 1713698 | 2021-09-13 | Henderson | Kentucky | 21101 | 7105 | 88 |
1710451 | 1710451 | 2021-09-12 | Henderson | Kentucky | 21101 | 7019 | 88 |
1707204 | 1707204 | 2021-09-11 | Henderson | Kentucky | 21101 | 7019 | 88 |
1703956 | 1703956 | 2021-09-10 | Henderson | Kentucky | 21101 | 7019 | 88 |
1700706 | 1700706 | 2021-09-09 | Henderson | Kentucky | 21101 | 6981 | 88 |
1697457 | 1697457 | 2021-09-08 | Henderson | Kentucky | 21101 | 6930 | 88 |
1694209 | 1694209 | 2021-09-07 | Henderson | Kentucky | 21101 | 6869 | 88 |
1690960 | 1690960 | 2021-09-06 | Henderson | Kentucky | 21101 | 6725 | 87 |
1687710 | 1687710 | 2021-09-05 | Henderson | Kentucky | 21101 | 6725 | 87 |
1684460 | 1684460 | 2021-09-04 | Henderson | Kentucky | 21101 | 6725 | 87 |
1681209 | 1681209 | 2021-09-03 | Henderson | Kentucky | 21101 | 6725 | 87 |
1677961 | 1677961 | 2021-09-02 | Henderson | Kentucky | 21101 | 6658 | 87 |
1674714 | 1674714 | 2021-09-01 | Henderson | Kentucky | 21101 | 6567 | 86 |
1671465 | 1671465 | 2021-08-31 | Henderson | Kentucky | 21101 | 6491 | 86 |
1668218 | 1668218 | 2021-08-30 | Henderson | Kentucky | 21101 | 6466 | 85 |
1664971 | 1664971 | 2021-08-29 | Henderson | Kentucky | 21101 | 6372 | 85 |
1661723 | 1661723 | 2021-08-28 | Henderson | Kentucky | 21101 | 6372 | 85 |
1658475 | 1658475 | 2021-08-27 | Henderson | Kentucky | 21101 | 6372 | 85 |
1655227 | 1655227 | 2021-08-26 | Henderson | Kentucky | 21101 | 6312 | 85 |
1651980 | 1651980 | 2021-08-25 | Henderson | Kentucky | 21101 | 6249 | 85 |
1648731 | 1648731 | 2021-08-24 | Henderson | Kentucky | 21101 | 6184 | 83 |
1645483 | 1645483 | 2021-08-23 | Henderson | Kentucky | 21101 | 6097 | 83 |
1642234 | 1642234 | 2021-08-22 | Henderson | Kentucky | 21101 | 6023 | 83 |
1638984 | 1638984 | 2021-08-21 | Henderson | Kentucky | 21101 | 6023 | 83 |
1635734 | 1635734 | 2021-08-20 | Henderson | Kentucky | 21101 | 6023 | 83 |
1632484 | 1632484 | 2021-08-19 | Henderson | Kentucky | 21101 | 5952 | 82 |
1629237 | 1629237 | 2021-08-18 | Henderson | Kentucky | 21101 | 5883 | 82 |
1625990 | 1625990 | 2021-08-17 | Henderson | Kentucky | 21101 | 5818 | 82 |
1622743 | 1622743 | 2021-08-16 | Henderson | Kentucky | 21101 | 5788 | 82 |
1619496 | 1619496 | 2021-08-15 | Henderson | Kentucky | 21101 | 5700 | 81 |
1616248 | 1616248 | 2021-08-14 | Henderson | Kentucky | 21101 | 5700 | 81 |
1612999 | 1612999 | 2021-08-13 | Henderson | Kentucky | 21101 | 5700 | 81 |
1609751 | 1609751 | 2021-08-12 | Henderson | Kentucky | 21101 | 5669 | 80 |
1606502 | 1606502 | 2021-08-11 | Henderson | Kentucky | 21101 | 5631 | 80 |
1603253 | 1603253 | 2021-08-10 | Henderson | Kentucky | 21101 | 5557 | 80 |
1600004 | 1600004 | 2021-08-09 | Henderson | Kentucky | 21101 | 5536 | 80 |
1596756 | 1596756 | 2021-08-08 | Henderson | Kentucky | 21101 | 5476 | 80 |
1593507 | 1593507 | 2021-08-07 | Henderson | Kentucky | 21101 | 5476 | 80 |
1590258 | 1590258 | 2021-08-06 | Henderson | Kentucky | 21101 | 5476 | 80 |
1587009 | 1587009 | 2021-08-05 | Henderson | Kentucky | 21101 | 5437 | 80 |
1583759 | 1583759 | 2021-08-04 | Henderson | Kentucky | 21101 | 5408 | 80 |
1580509 | 1580509 | 2021-08-03 | Henderson | Kentucky | 21101 | 5344 | 80 |
1577260 | 1577260 | 2021-08-02 | Henderson | Kentucky | 21101 | 5322 | 79 |
1574012 | 1574012 | 2021-08-01 | Henderson | Kentucky | 21101 | 5269 | 79 |
1570764 | 1570764 | 2021-07-31 | Henderson | Kentucky | 21101 | 5269 | 79 |
1567516 | 1567516 | 2021-07-30 | Henderson | Kentucky | 21101 | 5269 | 79 |
1564268 | 1564268 | 2021-07-29 | Henderson | Kentucky | 21101 | 5240 | 79 |
1561020 | 1561020 | 2021-07-28 | Henderson | Kentucky | 21101 | 5209 | 79 |
1557773 | 1557773 | 2021-07-27 | Henderson | Kentucky | 21101 | 5174 | 79 |
1554526 | 1554526 | 2021-07-26 | Henderson | Kentucky | 21101 | 5165 | 79 |
1551279 | 1551279 | 2021-07-25 | Henderson | Kentucky | 21101 | 5133 | 79 |
1548032 | 1548032 | 2021-07-24 | Henderson | Kentucky | 21101 | 5133 | 79 |
1544785 | 1544785 | 2021-07-23 | Henderson | Kentucky | 21101 | 5133 | 79 |
1541537 | 1541537 | 2021-07-22 | Henderson | Kentucky | 21101 | 5100 | 79 |
1538290 | 1538290 | 2021-07-21 | Henderson | Kentucky | 21101 | 5082 | 79 |
1535042 | 1535042 | 2021-07-20 | Henderson | Kentucky | 21101 | 5073 | 79 |
1531795 | 1531795 | 2021-07-19 | Henderson | Kentucky | 21101 | 5058 | 79 |
1528548 | 1528548 | 2021-07-18 | Henderson | Kentucky | 21101 | 5046 | 79 |
1525301 | 1525301 | 2021-07-17 | Henderson | Kentucky | 21101 | 5046 | 79 |
1522053 | 1522053 | 2021-07-16 | Henderson | Kentucky | 21101 | 5046 | 79 |
1518805 | 1518805 | 2021-07-15 | Henderson | Kentucky | 21101 | 5030 | 79 |
1515558 | 1515558 | 2021-07-14 | Henderson | Kentucky | 21101 | 5022 | 79 |
1512312 | 1512312 | 2021-07-13 | Henderson | Kentucky | 21101 | 5018 | 79 |
1509065 | 1509065 | 2021-07-12 | Henderson | Kentucky | 21101 | 5011 | 79 |
1505819 | 1505819 | 2021-07-11 | Henderson | Kentucky | 21101 | 5004 | 79 |
1502573 | 1502573 | 2021-07-10 | Henderson | Kentucky | 21101 | 5004 | 79 |
1499327 | 1499327 | 2021-07-09 | Henderson | Kentucky | 21101 | 5004 | 79 |
1496080 | 1496080 | 2021-07-08 | Henderson | Kentucky | 21101 | 4993 | 79 |
1492834 | 1492834 | 2021-07-07 | Henderson | Kentucky | 21101 | 4991 | 79 |
1489587 | 1489587 | 2021-07-06 | Henderson | Kentucky | 21101 | 4980 | 79 |
1486340 | 1486340 | 2021-07-05 | Henderson | Kentucky | 21101 | 4988 | 79 |
1483094 | 1483094 | 2021-07-04 | Henderson | Kentucky | 21101 | 4988 | 79 |
1479847 | 1479847 | 2021-07-03 | Henderson | Kentucky | 21101 | 4988 | 79 |
1476601 | 1476601 | 2021-07-02 | Henderson | Kentucky | 21101 | 4988 | 79 |
1473355 | 1473355 | 2021-07-01 | Henderson | Kentucky | 21101 | 4984 | 79 |
1470109 | 1470109 | 2021-06-30 | Henderson | Kentucky | 21101 | 4980 | 79 |
1466864 | 1466864 | 2021-06-29 | Henderson | Kentucky | 21101 | 4979 | 79 |
1463619 | 1463619 | 2021-06-28 | Henderson | Kentucky | 21101 | 4979 | 79 |
1460374 | 1460374 | 2021-06-27 | Henderson | Kentucky | 21101 | 4973 | 79 |
1457129 | 1457129 | 2021-06-26 | Henderson | Kentucky | 21101 | 4973 | 79 |
1453884 | 1453884 | 2021-06-25 | Henderson | Kentucky | 21101 | 4973 | 79 |
1450638 | 1450638 | 2021-06-24 | Henderson | Kentucky | 21101 | 4973 | 79 |
1447393 | 1447393 | 2021-06-23 | Henderson | Kentucky | 21101 | 4971 | 79 |
1444148 | 1444148 | 2021-06-22 | Henderson | Kentucky | 21101 | 4970 | 79 |
1440903 | 1440903 | 2021-06-21 | Henderson | Kentucky | 21101 | 4969 | 79 |
1437656 | 1437656 | 2021-06-20 | Henderson | Kentucky | 21101 | 4963 | 79 |
1434409 | 1434409 | 2021-06-19 | Henderson | Kentucky | 21101 | 4963 | 79 |
1431163 | 1431163 | 2021-06-18 | Henderson | Kentucky | 21101 | 4963 | 79 |
1427918 | 1427918 | 2021-06-17 | Henderson | Kentucky | 21101 | 4962 | 79 |
1424673 | 1424673 | 2021-06-16 | Henderson | Kentucky | 21101 | 4960 | 79 |
1421425 | 1421425 | 2021-06-15 | Henderson | Kentucky | 21101 | 4959 | 79 |
1418180 | 1418180 | 2021-06-14 | Henderson | Kentucky | 21101 | 4959 | 79 |
1414934 | 1414934 | 2021-06-13 | Henderson | Kentucky | 21101 | 4958 | 79 |
1411689 | 1411689 | 2021-06-12 | Henderson | Kentucky | 21101 | 4958 | 79 |
1408444 | 1408444 | 2021-06-11 | Henderson | Kentucky | 21101 | 4956 | 78 |
1405198 | 1405198 | 2021-06-10 | Henderson | Kentucky | 21101 | 4956 | 78 |
1401953 | 1401953 | 2021-06-09 | Henderson | Kentucky | 21101 | 4954 | 78 |
1398708 | 1398708 | 2021-06-08 | Henderson | Kentucky | 21101 | 4944 | 78 |
1395461 | 1395461 | 2021-06-07 | Henderson | Kentucky | 21101 | 4939 | 78 |
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);