ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Menifee" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811201 | 1811201 | 2021-10-13 | Menifee | Kentucky | 21165 | 812 | 21 |
1807952 | 1807952 | 2021-10-12 | Menifee | Kentucky | 21165 | 811 | 21 |
1804701 | 1804701 | 2021-10-11 | Menifee | Kentucky | 21165 | 810 | 21 |
1801452 | 1801452 | 2021-10-10 | Menifee | Kentucky | 21165 | 803 | 20 |
1798203 | 1798203 | 2021-10-09 | Menifee | Kentucky | 21165 | 803 | 20 |
1794954 | 1794954 | 2021-10-08 | Menifee | Kentucky | 21165 | 803 | 20 |
1791706 | 1791706 | 2021-10-07 | Menifee | Kentucky | 21165 | 801 | 20 |
1788457 | 1788457 | 2021-10-06 | Menifee | Kentucky | 21165 | 801 | 20 |
1785208 | 1785208 | 2021-10-05 | Menifee | Kentucky | 21165 | 799 | 20 |
1781959 | 1781959 | 2021-10-04 | Menifee | Kentucky | 21165 | 796 | 20 |
1778709 | 1778709 | 2021-10-03 | Menifee | Kentucky | 21165 | 789 | 20 |
1775459 | 1775459 | 2021-10-02 | Menifee | Kentucky | 21165 | 789 | 20 |
1772209 | 1772209 | 2021-10-01 | Menifee | Kentucky | 21165 | 789 | 20 |
1768960 | 1768960 | 2021-09-30 | Menifee | Kentucky | 21165 | 787 | 20 |
1765711 | 1765711 | 2021-09-29 | Menifee | Kentucky | 21165 | 785 | 20 |
1762462 | 1762462 | 2021-09-28 | Menifee | Kentucky | 21165 | 785 | 20 |
1759214 | 1759214 | 2021-09-27 | Menifee | Kentucky | 21165 | 782 | 19 |
1755966 | 1755966 | 2021-09-26 | Menifee | Kentucky | 21165 | 777 | 19 |
1752718 | 1752718 | 2021-09-25 | Menifee | Kentucky | 21165 | 777 | 19 |
1749469 | 1749469 | 2021-09-24 | Menifee | Kentucky | 21165 | 777 | 19 |
1746219 | 1746219 | 2021-09-23 | Menifee | Kentucky | 21165 | 775 | 19 |
1742970 | 1742970 | 2021-09-22 | Menifee | Kentucky | 21165 | 769 | 19 |
1739721 | 1739721 | 2021-09-21 | Menifee | Kentucky | 21165 | 767 | 19 |
1736472 | 1736472 | 2021-09-20 | Menifee | Kentucky | 21165 | 766 | 19 |
1733222 | 1733222 | 2021-09-19 | Menifee | Kentucky | 21165 | 762 | 19 |
1729972 | 1729972 | 2021-09-18 | Menifee | Kentucky | 21165 | 762 | 19 |
1726722 | 1726722 | 2021-09-17 | Menifee | Kentucky | 21165 | 762 | 19 |
1723473 | 1723473 | 2021-09-16 | Menifee | Kentucky | 21165 | 735 | 17 |
1720224 | 1720224 | 2021-09-15 | Menifee | Kentucky | 21165 | 726 | 17 |
1716976 | 1716976 | 2021-09-14 | Menifee | Kentucky | 21165 | 724 | 17 |
1713730 | 1713730 | 2021-09-13 | Menifee | Kentucky | 21165 | 722 | 17 |
1710483 | 1710483 | 2021-09-12 | Menifee | Kentucky | 21165 | 709 | 17 |
1707236 | 1707236 | 2021-09-11 | Menifee | Kentucky | 21165 | 709 | 17 |
1703988 | 1703988 | 2021-09-10 | Menifee | Kentucky | 21165 | 709 | 17 |
1700738 | 1700738 | 2021-09-09 | Menifee | Kentucky | 21165 | 703 | 17 |
1697489 | 1697489 | 2021-09-08 | Menifee | Kentucky | 21165 | 701 | 17 |
1694241 | 1694241 | 2021-09-07 | Menifee | Kentucky | 21165 | 693 | 17 |
1690992 | 1690992 | 2021-09-06 | Menifee | Kentucky | 21165 | 678 | 17 |
1687742 | 1687742 | 2021-09-05 | Menifee | Kentucky | 21165 | 678 | 17 |
1684492 | 1684492 | 2021-09-04 | Menifee | Kentucky | 21165 | 678 | 17 |
1681241 | 1681241 | 2021-09-03 | Menifee | Kentucky | 21165 | 678 | 17 |
1677993 | 1677993 | 2021-09-02 | Menifee | Kentucky | 21165 | 672 | 17 |
1674746 | 1674746 | 2021-09-01 | Menifee | Kentucky | 21165 | 669 | 17 |
1671497 | 1671497 | 2021-08-31 | Menifee | Kentucky | 21165 | 654 | 17 |
1668250 | 1668250 | 2021-08-30 | Menifee | Kentucky | 21165 | 644 | 17 |
1665003 | 1665003 | 2021-08-29 | Menifee | Kentucky | 21165 | 637 | 17 |
1661755 | 1661755 | 2021-08-28 | Menifee | Kentucky | 21165 | 637 | 17 |
1658507 | 1658507 | 2021-08-27 | Menifee | Kentucky | 21165 | 637 | 17 |
1655259 | 1655259 | 2021-08-26 | Menifee | Kentucky | 21165 | 629 | 17 |
1652012 | 1652012 | 2021-08-25 | Menifee | Kentucky | 21165 | 611 | 17 |
1648763 | 1648763 | 2021-08-24 | Menifee | Kentucky | 21165 | 606 | 17 |
1645515 | 1645515 | 2021-08-23 | Menifee | Kentucky | 21165 | 598 | 17 |
1642266 | 1642266 | 2021-08-22 | Menifee | Kentucky | 21165 | 595 | 17 |
1639016 | 1639016 | 2021-08-21 | Menifee | Kentucky | 21165 | 595 | 17 |
1635766 | 1635766 | 2021-08-20 | Menifee | Kentucky | 21165 | 595 | 17 |
1632516 | 1632516 | 2021-08-19 | Menifee | Kentucky | 21165 | 586 | 17 |
1629269 | 1629269 | 2021-08-18 | Menifee | Kentucky | 21165 | 569 | 17 |
1626022 | 1626022 | 2021-08-17 | Menifee | Kentucky | 21165 | 556 | 17 |
1622775 | 1622775 | 2021-08-16 | Menifee | Kentucky | 21165 | 554 | 17 |
1619528 | 1619528 | 2021-08-15 | Menifee | Kentucky | 21165 | 541 | 17 |
1616280 | 1616280 | 2021-08-14 | Menifee | Kentucky | 21165 | 541 | 17 |
1613031 | 1613031 | 2021-08-13 | Menifee | Kentucky | 21165 | 541 | 17 |
1609783 | 1609783 | 2021-08-12 | Menifee | Kentucky | 21165 | 539 | 17 |
1606534 | 1606534 | 2021-08-11 | Menifee | Kentucky | 21165 | 528 | 17 |
1603285 | 1603285 | 2021-08-10 | Menifee | Kentucky | 21165 | 524 | 17 |
1600036 | 1600036 | 2021-08-09 | Menifee | Kentucky | 21165 | 516 | 17 |
1596788 | 1596788 | 2021-08-08 | Menifee | Kentucky | 21165 | 511 | 17 |
1593539 | 1593539 | 2021-08-07 | Menifee | Kentucky | 21165 | 511 | 17 |
1590290 | 1590290 | 2021-08-06 | Menifee | Kentucky | 21165 | 511 | 17 |
1587041 | 1587041 | 2021-08-05 | Menifee | Kentucky | 21165 | 505 | 17 |
1583791 | 1583791 | 2021-08-04 | Menifee | Kentucky | 21165 | 500 | 17 |
1580541 | 1580541 | 2021-08-03 | Menifee | Kentucky | 21165 | 497 | 17 |
1577292 | 1577292 | 2021-08-02 | Menifee | Kentucky | 21165 | 497 | 17 |
1574044 | 1574044 | 2021-08-01 | Menifee | Kentucky | 21165 | 496 | 17 |
1570796 | 1570796 | 2021-07-31 | Menifee | Kentucky | 21165 | 496 | 17 |
1567548 | 1567548 | 2021-07-30 | Menifee | Kentucky | 21165 | 496 | 17 |
1564300 | 1564300 | 2021-07-29 | Menifee | Kentucky | 21165 | 496 | 17 |
1561052 | 1561052 | 2021-07-28 | Menifee | Kentucky | 21165 | 494 | 17 |
1557805 | 1557805 | 2021-07-27 | Menifee | Kentucky | 21165 | 494 | 17 |
1554558 | 1554558 | 2021-07-26 | Menifee | Kentucky | 21165 | 492 | 17 |
1551311 | 1551311 | 2021-07-25 | Menifee | Kentucky | 21165 | 492 | 17 |
1548064 | 1548064 | 2021-07-24 | Menifee | Kentucky | 21165 | 492 | 17 |
1544817 | 1544817 | 2021-07-23 | Menifee | Kentucky | 21165 | 492 | 17 |
1541569 | 1541569 | 2021-07-22 | Menifee | Kentucky | 21165 | 492 | 17 |
1538322 | 1538322 | 2021-07-21 | Menifee | Kentucky | 21165 | 490 | 17 |
1535074 | 1535074 | 2021-07-20 | Menifee | Kentucky | 21165 | 489 | 17 |
1531827 | 1531827 | 2021-07-19 | Menifee | Kentucky | 21165 | 487 | 17 |
1528580 | 1528580 | 2021-07-18 | Menifee | Kentucky | 21165 | 488 | 17 |
1525333 | 1525333 | 2021-07-17 | Menifee | Kentucky | 21165 | 488 | 17 |
1522085 | 1522085 | 2021-07-16 | Menifee | Kentucky | 21165 | 488 | 17 |
1518837 | 1518837 | 2021-07-15 | Menifee | Kentucky | 21165 | 488 | 17 |
1515590 | 1515590 | 2021-07-14 | Menifee | Kentucky | 21165 | 488 | 17 |
1512344 | 1512344 | 2021-07-13 | Menifee | Kentucky | 21165 | 488 | 17 |
1509097 | 1509097 | 2021-07-12 | Menifee | Kentucky | 21165 | 488 | 17 |
1505851 | 1505851 | 2021-07-11 | Menifee | Kentucky | 21165 | 489 | 17 |
1502605 | 1502605 | 2021-07-10 | Menifee | Kentucky | 21165 | 489 | 17 |
1499359 | 1499359 | 2021-07-09 | Menifee | Kentucky | 21165 | 489 | 17 |
1496112 | 1496112 | 2021-07-08 | Menifee | Kentucky | 21165 | 489 | 17 |
1492866 | 1492866 | 2021-07-07 | Menifee | Kentucky | 21165 | 489 | 17 |
1489619 | 1489619 | 2021-07-06 | Menifee | Kentucky | 21165 | 489 | 17 |
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);