ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Nelson" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716983 | 1716983 | 2021-09-14 | Nelson | Kentucky | 21179 | 7165 | 70 |
1713737 | 1713737 | 2021-09-13 | Nelson | Kentucky | 21179 | 7119 | 70 |
1710490 | 1710490 | 2021-09-12 | Nelson | Kentucky | 21179 | 7012 | 70 |
1707243 | 1707243 | 2021-09-11 | Nelson | Kentucky | 21179 | 7012 | 70 |
1703995 | 1703995 | 2021-09-10 | Nelson | Kentucky | 21179 | 7012 | 70 |
1700745 | 1700745 | 2021-09-09 | Nelson | Kentucky | 21179 | 6948 | 70 |
1697496 | 1697496 | 2021-09-08 | Nelson | Kentucky | 21179 | 6862 | 70 |
1694248 | 1694248 | 2021-09-07 | Nelson | Kentucky | 21179 | 6798 | 70 |
1690999 | 1690999 | 2021-09-06 | Nelson | Kentucky | 21179 | 6661 | 70 |
1687749 | 1687749 | 2021-09-05 | Nelson | Kentucky | 21179 | 6661 | 70 |
1684499 | 1684499 | 2021-09-04 | Nelson | Kentucky | 21179 | 6661 | 70 |
1681248 | 1681248 | 2021-09-03 | Nelson | Kentucky | 21179 | 6661 | 70 |
1678000 | 1678000 | 2021-09-02 | Nelson | Kentucky | 21179 | 6604 | 68 |
1674753 | 1674753 | 2021-09-01 | Nelson | Kentucky | 21179 | 6546 | 68 |
1671504 | 1671504 | 2021-08-31 | Nelson | Kentucky | 21179 | 6496 | 68 |
1668257 | 1668257 | 2021-08-30 | Nelson | Kentucky | 21179 | 6422 | 68 |
1665010 | 1665010 | 2021-08-29 | Nelson | Kentucky | 21179 | 6336 | 68 |
1661762 | 1661762 | 2021-08-28 | Nelson | Kentucky | 21179 | 6336 | 68 |
1658514 | 1658514 | 2021-08-27 | Nelson | Kentucky | 21179 | 6336 | 68 |
1655266 | 1655266 | 2021-08-26 | Nelson | Kentucky | 21179 | 6265 | 66 |
1652019 | 1652019 | 2021-08-25 | Nelson | Kentucky | 21179 | 6206 | 66 |
1648770 | 1648770 | 2021-08-24 | Nelson | Kentucky | 21179 | 6123 | 64 |
1645522 | 1645522 | 2021-08-23 | Nelson | Kentucky | 21179 | 6042 | 64 |
1642273 | 1642273 | 2021-08-22 | Nelson | Kentucky | 21179 | 5917 | 64 |
1639023 | 1639023 | 2021-08-21 | Nelson | Kentucky | 21179 | 5917 | 64 |
1635773 | 1635773 | 2021-08-20 | Nelson | Kentucky | 21179 | 5917 | 64 |
1632523 | 1632523 | 2021-08-19 | Nelson | Kentucky | 21179 | 5875 | 63 |
1629276 | 1629276 | 2021-08-18 | Nelson | Kentucky | 21179 | 5787 | 63 |
1626029 | 1626029 | 2021-08-17 | Nelson | Kentucky | 21179 | 5746 | 63 |
1622782 | 1622782 | 2021-08-16 | Nelson | Kentucky | 21179 | 5702 | 63 |
1619535 | 1619535 | 2021-08-15 | Nelson | Kentucky | 21179 | 5621 | 63 |
1616287 | 1616287 | 2021-08-14 | Nelson | Kentucky | 21179 | 5621 | 63 |
1613038 | 1613038 | 2021-08-13 | Nelson | Kentucky | 21179 | 5621 | 63 |
1609790 | 1609790 | 2021-08-12 | Nelson | Kentucky | 21179 | 5558 | 63 |
1606541 | 1606541 | 2021-08-11 | Nelson | Kentucky | 21179 | 5508 | 63 |
1603292 | 1603292 | 2021-08-10 | Nelson | Kentucky | 21179 | 5475 | 63 |
1600043 | 1600043 | 2021-08-09 | Nelson | Kentucky | 21179 | 5449 | 63 |
1596795 | 1596795 | 2021-08-08 | Nelson | Kentucky | 21179 | 5370 | 63 |
1593546 | 1593546 | 2021-08-07 | Nelson | Kentucky | 21179 | 5370 | 63 |
1590297 | 1590297 | 2021-08-06 | Nelson | Kentucky | 21179 | 5370 | 63 |
1587048 | 1587048 | 2021-08-05 | Nelson | Kentucky | 21179 | 5335 | 63 |
1583798 | 1583798 | 2021-08-04 | Nelson | Kentucky | 21179 | 5311 | 63 |
1580548 | 1580548 | 2021-08-03 | Nelson | Kentucky | 21179 | 5273 | 63 |
1577299 | 1577299 | 2021-08-02 | Nelson | Kentucky | 21179 | 5258 | 63 |
1574051 | 1574051 | 2021-08-01 | Nelson | Kentucky | 21179 | 5204 | 63 |
1570803 | 1570803 | 2021-07-31 | Nelson | Kentucky | 21179 | 5204 | 63 |
1567555 | 1567555 | 2021-07-30 | Nelson | Kentucky | 21179 | 5204 | 63 |
1564307 | 1564307 | 2021-07-29 | Nelson | Kentucky | 21179 | 5181 | 63 |
1561059 | 1561059 | 2021-07-28 | Nelson | Kentucky | 21179 | 5159 | 63 |
1557812 | 1557812 | 2021-07-27 | Nelson | Kentucky | 21179 | 5132 | 63 |
1554565 | 1554565 | 2021-07-26 | Nelson | Kentucky | 21179 | 5122 | 63 |
1551318 | 1551318 | 2021-07-25 | Nelson | Kentucky | 21179 | 5100 | 63 |
1548071 | 1548071 | 2021-07-24 | Nelson | Kentucky | 21179 | 5100 | 63 |
1544824 | 1544824 | 2021-07-23 | Nelson | Kentucky | 21179 | 5100 | 63 |
1541576 | 1541576 | 2021-07-22 | Nelson | Kentucky | 21179 | 5091 | 63 |
1538329 | 1538329 | 2021-07-21 | Nelson | Kentucky | 21179 | 5078 | 63 |
1535081 | 1535081 | 2021-07-20 | Nelson | Kentucky | 21179 | 5066 | 63 |
1531834 | 1531834 | 2021-07-19 | Nelson | Kentucky | 21179 | 5060 | 63 |
1528587 | 1528587 | 2021-07-18 | Nelson | Kentucky | 21179 | 5055 | 63 |
1525340 | 1525340 | 2021-07-17 | Nelson | Kentucky | 21179 | 5055 | 63 |
1522092 | 1522092 | 2021-07-16 | Nelson | Kentucky | 21179 | 5055 | 63 |
1518844 | 1518844 | 2021-07-15 | Nelson | Kentucky | 21179 | 5053 | 63 |
1515597 | 1515597 | 2021-07-14 | Nelson | Kentucky | 21179 | 5048 | 63 |
1512351 | 1512351 | 2021-07-13 | Nelson | Kentucky | 21179 | 5043 | 63 |
1509104 | 1509104 | 2021-07-12 | Nelson | Kentucky | 21179 | 5039 | 63 |
1505858 | 1505858 | 2021-07-11 | Nelson | Kentucky | 21179 | 5034 | 63 |
1502612 | 1502612 | 2021-07-10 | Nelson | Kentucky | 21179 | 5034 | 63 |
1499366 | 1499366 | 2021-07-09 | Nelson | Kentucky | 21179 | 5034 | 63 |
1496119 | 1496119 | 2021-07-08 | Nelson | Kentucky | 21179 | 5032 | 63 |
1492873 | 1492873 | 2021-07-07 | Nelson | Kentucky | 21179 | 5030 | 63 |
1489626 | 1489626 | 2021-07-06 | Nelson | Kentucky | 21179 | 5027 | 62 |
1486379 | 1486379 | 2021-07-05 | Nelson | Kentucky | 21179 | 5017 | 62 |
1483133 | 1483133 | 2021-07-04 | Nelson | Kentucky | 21179 | 5017 | 62 |
1479886 | 1479886 | 2021-07-03 | Nelson | Kentucky | 21179 | 5017 | 62 |
1476640 | 1476640 | 2021-07-02 | Nelson | Kentucky | 21179 | 5017 | 62 |
1473394 | 1473394 | 2021-07-01 | Nelson | Kentucky | 21179 | 5020 | 62 |
1470148 | 1470148 | 2021-06-30 | Nelson | Kentucky | 21179 | 5017 | 62 |
1466903 | 1466903 | 2021-06-29 | Nelson | Kentucky | 21179 | 5014 | 62 |
1463658 | 1463658 | 2021-06-28 | Nelson | Kentucky | 21179 | 5015 | 62 |
1460413 | 1460413 | 2021-06-27 | Nelson | Kentucky | 21179 | 5016 | 61 |
1457168 | 1457168 | 2021-06-26 | Nelson | Kentucky | 21179 | 5016 | 61 |
1453923 | 1453923 | 2021-06-25 | Nelson | Kentucky | 21179 | 5016 | 61 |
1450677 | 1450677 | 2021-06-24 | Nelson | Kentucky | 21179 | 5014 | 61 |
1447432 | 1447432 | 2021-06-23 | Nelson | Kentucky | 21179 | 5012 | 61 |
1444187 | 1444187 | 2021-06-22 | Nelson | Kentucky | 21179 | 5013 | 61 |
1440942 | 1440942 | 2021-06-21 | Nelson | Kentucky | 21179 | 5009 | 61 |
1437695 | 1437695 | 2021-06-20 | Nelson | Kentucky | 21179 | 5009 | 61 |
1434448 | 1434448 | 2021-06-19 | Nelson | Kentucky | 21179 | 5009 | 61 |
1431202 | 1431202 | 2021-06-18 | Nelson | Kentucky | 21179 | 5009 | 61 |
1427957 | 1427957 | 2021-06-17 | Nelson | Kentucky | 21179 | 5007 | 61 |
1424712 | 1424712 | 2021-06-16 | Nelson | Kentucky | 21179 | 5007 | 61 |
1421464 | 1421464 | 2021-06-15 | Nelson | Kentucky | 21179 | 5003 | 61 |
1418219 | 1418219 | 2021-06-14 | Nelson | Kentucky | 21179 | 5000 | 61 |
1414973 | 1414973 | 2021-06-13 | Nelson | Kentucky | 21179 | 4999 | 61 |
1411728 | 1411728 | 2021-06-12 | Nelson | Kentucky | 21179 | 4998 | 61 |
1408483 | 1408483 | 2021-06-11 | Nelson | Kentucky | 21179 | 4998 | 61 |
1405237 | 1405237 | 2021-06-10 | Nelson | Kentucky | 21179 | 4995 | 60 |
1401992 | 1401992 | 2021-06-09 | Nelson | Kentucky | 21179 | 4991 | 60 |
1398747 | 1398747 | 2021-06-08 | Nelson | Kentucky | 21179 | 4988 | 60 |
1395500 | 1395500 | 2021-06-07 | Nelson | Kentucky | 21179 | 4980 | 60 |
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);