ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Green" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811162 | 1811162 | 2021-10-13 | Green | Kentucky | 21087 | 2399 | 32 |
1807913 | 1807913 | 2021-10-12 | Green | Kentucky | 21087 | 2379 | 30 |
1804662 | 1804662 | 2021-10-11 | Green | Kentucky | 21087 | 2379 | 30 |
1801413 | 1801413 | 2021-10-10 | Green | Kentucky | 21087 | 2372 | 30 |
1798164 | 1798164 | 2021-10-09 | Green | Kentucky | 21087 | 2372 | 30 |
1794915 | 1794915 | 2021-10-08 | Green | Kentucky | 21087 | 2372 | 30 |
1791667 | 1791667 | 2021-10-07 | Green | Kentucky | 21087 | 2362 | 30 |
1788418 | 1788418 | 2021-10-06 | Green | Kentucky | 21087 | 2336 | 30 |
1785169 | 1785169 | 2021-10-05 | Green | Kentucky | 21087 | 2323 | 29 |
1781920 | 1781920 | 2021-10-04 | Green | Kentucky | 21087 | 2299 | 29 |
1778670 | 1778670 | 2021-10-03 | Green | Kentucky | 21087 | 2299 | 29 |
1775420 | 1775420 | 2021-10-02 | Green | Kentucky | 21087 | 2299 | 29 |
1772170 | 1772170 | 2021-10-01 | Green | Kentucky | 21087 | 2273 | 29 |
1768921 | 1768921 | 2021-09-30 | Green | Kentucky | 21087 | 2229 | 30 |
1765672 | 1765672 | 2021-09-29 | Green | Kentucky | 21087 | 2211 | 29 |
1762423 | 1762423 | 2021-09-28 | Green | Kentucky | 21087 | 2185 | 29 |
1759175 | 1759175 | 2021-09-27 | Green | Kentucky | 21087 | 2185 | 29 |
1755927 | 1755927 | 2021-09-26 | Green | Kentucky | 21087 | 2136 | 28 |
1752679 | 1752679 | 2021-09-25 | Green | Kentucky | 21087 | 2136 | 28 |
1749430 | 1749430 | 2021-09-24 | Green | Kentucky | 21087 | 2097 | 27 |
1746180 | 1746180 | 2021-09-23 | Green | Kentucky | 21087 | 2082 | 27 |
1742931 | 1742931 | 2021-09-22 | Green | Kentucky | 21087 | 2048 | 27 |
1739682 | 1739682 | 2021-09-21 | Green | Kentucky | 21087 | 2037 | 27 |
1736433 | 1736433 | 2021-09-20 | Green | Kentucky | 21087 | 2037 | 27 |
1733183 | 1733183 | 2021-09-19 | Green | Kentucky | 21087 | 2007 | 27 |
1729933 | 1729933 | 2021-09-18 | Green | Kentucky | 21087 | 2007 | 27 |
1726683 | 1726683 | 2021-09-17 | Green | Kentucky | 21087 | 1985 | 27 |
1723434 | 1723434 | 2021-09-16 | Green | Kentucky | 21087 | 1966 | 26 |
1720185 | 1720185 | 2021-09-15 | Green | Kentucky | 21087 | 1928 | 26 |
1716937 | 1716937 | 2021-09-14 | Green | Kentucky | 21087 | 1897 | 23 |
1713691 | 1713691 | 2021-09-13 | Green | Kentucky | 21087 | 1875 | 23 |
1710444 | 1710444 | 2021-09-12 | Green | Kentucky | 21087 | 1875 | 23 |
1707197 | 1707197 | 2021-09-11 | Green | Kentucky | 21087 | 1875 | 23 |
1703949 | 1703949 | 2021-09-10 | Green | Kentucky | 21087 | 1857 | 23 |
1700699 | 1700699 | 2021-09-09 | Green | Kentucky | 21087 | 1839 | 23 |
1697450 | 1697450 | 2021-09-08 | Green | Kentucky | 21087 | 1821 | 22 |
1694202 | 1694202 | 2021-09-07 | Green | Kentucky | 21087 | 1776 | 18 |
1690953 | 1690953 | 2021-09-06 | Green | Kentucky | 21087 | 1776 | 18 |
1687703 | 1687703 | 2021-09-05 | Green | Kentucky | 21087 | 1776 | 18 |
1684453 | 1684453 | 2021-09-04 | Green | Kentucky | 21087 | 1776 | 18 |
1681202 | 1681202 | 2021-09-03 | Green | Kentucky | 21087 | 1746 | 18 |
1677954 | 1677954 | 2021-09-02 | Green | Kentucky | 21087 | 1716 | 18 |
1674707 | 1674707 | 2021-09-01 | Green | Kentucky | 21087 | 1716 | 18 |
1671458 | 1671458 | 2021-08-31 | Green | Kentucky | 21087 | 1694 | 18 |
1668211 | 1668211 | 2021-08-30 | Green | Kentucky | 21087 | 1661 | 18 |
1664964 | 1664964 | 2021-08-29 | Green | Kentucky | 21087 | 1640 | 18 |
1661716 | 1661716 | 2021-08-28 | Green | Kentucky | 21087 | 1640 | 18 |
1658468 | 1658468 | 2021-08-27 | Green | Kentucky | 21087 | 1612 | 18 |
1655220 | 1655220 | 2021-08-26 | Green | Kentucky | 21087 | 1580 | 18 |
1651973 | 1651973 | 2021-08-25 | Green | Kentucky | 21087 | 1580 | 18 |
1648724 | 1648724 | 2021-08-24 | Green | Kentucky | 21087 | 1553 | 18 |
1645476 | 1645476 | 2021-08-23 | Green | Kentucky | 21087 | 1509 | 18 |
1642227 | 1642227 | 2021-08-22 | Green | Kentucky | 21087 | 1509 | 18 |
1638977 | 1638977 | 2021-08-21 | Green | Kentucky | 21087 | 1509 | 18 |
1635727 | 1635727 | 2021-08-20 | Green | Kentucky | 21087 | 1509 | 18 |
1632477 | 1632477 | 2021-08-19 | Green | Kentucky | 21087 | 1463 | 18 |
1629230 | 1629230 | 2021-08-18 | Green | Kentucky | 21087 | 1463 | 18 |
1625983 | 1625983 | 2021-08-17 | Green | Kentucky | 21087 | 1430 | 18 |
1622736 | 1622736 | 2021-08-16 | Green | Kentucky | 21087 | 1430 | 18 |
1619489 | 1619489 | 2021-08-15 | Green | Kentucky | 21087 | 1406 | 18 |
1616241 | 1616241 | 2021-08-14 | Green | Kentucky | 21087 | 1406 | 18 |
1612992 | 1612992 | 2021-08-13 | Green | Kentucky | 21087 | 1383 | 18 |
1609744 | 1609744 | 2021-08-12 | Green | Kentucky | 21087 | 1371 | 18 |
1606495 | 1606495 | 2021-08-11 | Green | Kentucky | 21087 | 1371 | 18 |
1603246 | 1603246 | 2021-08-10 | Green | Kentucky | 21087 | 1353 | 18 |
1599997 | 1599997 | 2021-08-09 | Green | Kentucky | 21087 | 1353 | 18 |
1596749 | 1596749 | 2021-08-08 | Green | Kentucky | 21087 | 1341 | 18 |
1593500 | 1593500 | 2021-08-07 | Green | Kentucky | 21087 | 1341 | 18 |
1590251 | 1590251 | 2021-08-06 | Green | Kentucky | 21087 | 1338 | 18 |
1587002 | 1587002 | 2021-08-05 | Green | Kentucky | 21087 | 1338 | 18 |
1583752 | 1583752 | 2021-08-04 | Green | Kentucky | 21087 | 1314 | 18 |
1580502 | 1580502 | 2021-08-03 | Green | Kentucky | 21087 | 1308 | 18 |
1577253 | 1577253 | 2021-08-02 | Green | Kentucky | 21087 | 1308 | 18 |
1574005 | 1574005 | 2021-08-01 | Green | Kentucky | 21087 | 1302 | 18 |
1570757 | 1570757 | 2021-07-31 | Green | Kentucky | 21087 | 1302 | 18 |
1567509 | 1567509 | 2021-07-30 | Green | Kentucky | 21087 | 1290 | 18 |
1564261 | 1564261 | 2021-07-29 | Green | Kentucky | 21087 | 1283 | 18 |
1561013 | 1561013 | 2021-07-28 | Green | Kentucky | 21087 | 1283 | 18 |
1557766 | 1557766 | 2021-07-27 | Green | Kentucky | 21087 | 1264 | 18 |
1554519 | 1554519 | 2021-07-26 | Green | Kentucky | 21087 | 1264 | 18 |
1551272 | 1551272 | 2021-07-25 | Green | Kentucky | 21087 | 1264 | 18 |
1548025 | 1548025 | 2021-07-24 | Green | Kentucky | 21087 | 1264 | 18 |
1544778 | 1544778 | 2021-07-23 | Green | Kentucky | 21087 | 1264 | 18 |
1541530 | 1541530 | 2021-07-22 | Green | Kentucky | 21087 | 1251 | 18 |
1538283 | 1538283 | 2021-07-21 | Green | Kentucky | 21087 | 1249 | 18 |
1535035 | 1535035 | 2021-07-20 | Green | Kentucky | 21087 | 1249 | 18 |
1531788 | 1531788 | 2021-07-19 | Green | Kentucky | 21087 | 1249 | 18 |
1528541 | 1528541 | 2021-07-18 | Green | Kentucky | 21087 | 1249 | 18 |
1525294 | 1525294 | 2021-07-17 | Green | Kentucky | 21087 | 1249 | 18 |
1522046 | 1522046 | 2021-07-16 | Green | Kentucky | 21087 | 1249 | 18 |
1518798 | 1518798 | 2021-07-15 | Green | Kentucky | 21087 | 1243 | 18 |
1515551 | 1515551 | 2021-07-14 | Green | Kentucky | 21087 | 1243 | 18 |
1512305 | 1512305 | 2021-07-13 | Green | Kentucky | 21087 | 1243 | 18 |
1509058 | 1509058 | 2021-07-12 | Green | Kentucky | 21087 | 1243 | 18 |
1505812 | 1505812 | 2021-07-11 | Green | Kentucky | 21087 | 1243 | 18 |
1502566 | 1502566 | 2021-07-10 | Green | Kentucky | 21087 | 1243 | 18 |
1499320 | 1499320 | 2021-07-09 | Green | Kentucky | 21087 | 1243 | 18 |
1496073 | 1496073 | 2021-07-08 | Green | Kentucky | 21087 | 1239 | 18 |
1492827 | 1492827 | 2021-07-07 | Green | Kentucky | 21087 | 1239 | 18 |
1489580 | 1489580 | 2021-07-06 | Green | Kentucky | 21087 | 1239 | 18 |
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);