ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Nelson", fips = 21179 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811208 | 1811208 | 2021-10-13 | Nelson | Kentucky | 21179 | 8096 | 77 |
1807959 | 1807959 | 2021-10-12 | Nelson | Kentucky | 21179 | 8079 | 77 |
1804708 | 1804708 | 2021-10-11 | Nelson | Kentucky | 21179 | 8062 | 77 |
1801459 | 1801459 | 2021-10-10 | Nelson | Kentucky | 21179 | 8013 | 77 |
1798210 | 1798210 | 2021-10-09 | Nelson | Kentucky | 21179 | 8013 | 77 |
1794961 | 1794961 | 2021-10-08 | Nelson | Kentucky | 21179 | 8013 | 77 |
1791713 | 1791713 | 2021-10-07 | Nelson | Kentucky | 21179 | 7986 | 77 |
1788464 | 1788464 | 2021-10-06 | Nelson | Kentucky | 21179 | 7957 | 74 |
1785215 | 1785215 | 2021-10-05 | Nelson | Kentucky | 21179 | 7944 | 74 |
1781966 | 1781966 | 2021-10-04 | Nelson | Kentucky | 21179 | 7902 | 74 |
1778716 | 1778716 | 2021-10-03 | Nelson | Kentucky | 21179 | 7852 | 73 |
1775466 | 1775466 | 2021-10-02 | Nelson | Kentucky | 21179 | 7852 | 73 |
1772216 | 1772216 | 2021-10-01 | Nelson | Kentucky | 21179 | 7852 | 73 |
1768967 | 1768967 | 2021-09-30 | Nelson | Kentucky | 21179 | 7798 | 73 |
1765718 | 1765718 | 2021-09-29 | Nelson | Kentucky | 21179 | 7760 | 73 |
1762469 | 1762469 | 2021-09-28 | Nelson | Kentucky | 21179 | 7712 | 72 |
1759221 | 1759221 | 2021-09-27 | Nelson | Kentucky | 21179 | 7685 | 72 |
1755973 | 1755973 | 2021-09-26 | Nelson | Kentucky | 21179 | 7593 | 72 |
1752725 | 1752725 | 2021-09-25 | Nelson | Kentucky | 21179 | 7593 | 72 |
1749476 | 1749476 | 2021-09-24 | Nelson | Kentucky | 21179 | 7593 | 72 |
1746226 | 1746226 | 2021-09-23 | Nelson | Kentucky | 21179 | 7512 | 72 |
1742977 | 1742977 | 2021-09-22 | Nelson | Kentucky | 21179 | 7464 | 72 |
1739728 | 1739728 | 2021-09-21 | Nelson | Kentucky | 21179 | 7436 | 72 |
1736479 | 1736479 | 2021-09-20 | Nelson | Kentucky | 21179 | 7402 | 72 |
1733229 | 1733229 | 2021-09-19 | Nelson | Kentucky | 21179 | 7321 | 71 |
1729979 | 1729979 | 2021-09-18 | Nelson | Kentucky | 21179 | 7321 | 71 |
1726729 | 1726729 | 2021-09-17 | Nelson | Kentucky | 21179 | 7321 | 71 |
1723480 | 1723480 | 2021-09-16 | Nelson | Kentucky | 21179 | 7252 | 71 |
1720231 | 1720231 | 2021-09-15 | Nelson | Kentucky | 21179 | 7202 | 71 |
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 |
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);