ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Ohio" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814459 | 1814459 | 2021-10-14 | Ohio | Kentucky | 21183 | 4269 | 78 |
1811210 | 1811210 | 2021-10-13 | Ohio | Kentucky | 21183 | 4253 | 77 |
1807961 | 1807961 | 2021-10-12 | Ohio | Kentucky | 21183 | 4234 | 76 |
1804710 | 1804710 | 2021-10-11 | Ohio | Kentucky | 21183 | 4212 | 76 |
1801461 | 1801461 | 2021-10-10 | Ohio | Kentucky | 21183 | 4191 | 75 |
1798212 | 1798212 | 2021-10-09 | Ohio | Kentucky | 21183 | 4191 | 75 |
1794963 | 1794963 | 2021-10-08 | Ohio | Kentucky | 21183 | 4191 | 75 |
1791715 | 1791715 | 2021-10-07 | Ohio | Kentucky | 21183 | 4177 | 75 |
1788466 | 1788466 | 2021-10-06 | Ohio | Kentucky | 21183 | 4161 | 75 |
1785217 | 1785217 | 2021-10-05 | Ohio | Kentucky | 21183 | 4149 | 74 |
1781968 | 1781968 | 2021-10-04 | Ohio | Kentucky | 21183 | 4138 | 74 |
1778718 | 1778718 | 2021-10-03 | Ohio | Kentucky | 21183 | 4109 | 74 |
1775468 | 1775468 | 2021-10-02 | Ohio | Kentucky | 21183 | 4109 | 74 |
1772218 | 1772218 | 2021-10-01 | Ohio | Kentucky | 21183 | 4109 | 74 |
1768969 | 1768969 | 2021-09-30 | Ohio | Kentucky | 21183 | 4081 | 74 |
1765720 | 1765720 | 2021-09-29 | Ohio | Kentucky | 21183 | 4062 | 74 |
1762471 | 1762471 | 2021-09-28 | Ohio | Kentucky | 21183 | 4036 | 73 |
1759223 | 1759223 | 2021-09-27 | Ohio | Kentucky | 21183 | 3994 | 72 |
1755975 | 1755975 | 2021-09-26 | Ohio | Kentucky | 21183 | 3940 | 71 |
1752727 | 1752727 | 2021-09-25 | Ohio | Kentucky | 21183 | 3940 | 71 |
1749478 | 1749478 | 2021-09-24 | Ohio | Kentucky | 21183 | 3940 | 71 |
1746228 | 1746228 | 2021-09-23 | Ohio | Kentucky | 21183 | 3919 | 71 |
1742979 | 1742979 | 2021-09-22 | Ohio | Kentucky | 21183 | 3884 | 70 |
1739730 | 1739730 | 2021-09-21 | Ohio | Kentucky | 21183 | 3856 | 68 |
1736481 | 1736481 | 2021-09-20 | Ohio | Kentucky | 21183 | 3820 | 68 |
1733231 | 1733231 | 2021-09-19 | Ohio | Kentucky | 21183 | 3772 | 65 |
1729981 | 1729981 | 2021-09-18 | Ohio | Kentucky | 21183 | 3772 | 65 |
1726731 | 1726731 | 2021-09-17 | Ohio | Kentucky | 21183 | 3772 | 65 |
1723482 | 1723482 | 2021-09-16 | Ohio | Kentucky | 21183 | 3733 | 63 |
1720233 | 1720233 | 2021-09-15 | Ohio | Kentucky | 21183 | 3705 | 63 |
1716985 | 1716985 | 2021-09-14 | Ohio | Kentucky | 21183 | 3677 | 63 |
1713739 | 1713739 | 2021-09-13 | Ohio | Kentucky | 21183 | 3642 | 62 |
1710492 | 1710492 | 2021-09-12 | Ohio | Kentucky | 21183 | 3569 | 61 |
1707245 | 1707245 | 2021-09-11 | Ohio | Kentucky | 21183 | 3569 | 61 |
1703997 | 1703997 | 2021-09-10 | Ohio | Kentucky | 21183 | 3569 | 61 |
1700747 | 1700747 | 2021-09-09 | Ohio | Kentucky | 21183 | 3526 | 61 |
1697498 | 1697498 | 2021-09-08 | Ohio | Kentucky | 21183 | 3499 | 61 |
1694250 | 1694250 | 2021-09-07 | Ohio | Kentucky | 21183 | 3469 | 61 |
1691001 | 1691001 | 2021-09-06 | Ohio | Kentucky | 21183 | 3400 | 59 |
1687751 | 1687751 | 2021-09-05 | Ohio | Kentucky | 21183 | 3400 | 59 |
1684501 | 1684501 | 2021-09-04 | Ohio | Kentucky | 21183 | 3400 | 59 |
1681250 | 1681250 | 2021-09-03 | Ohio | Kentucky | 21183 | 3400 | 59 |
1678002 | 1678002 | 2021-09-02 | Ohio | Kentucky | 21183 | 3380 | 59 |
1674755 | 1674755 | 2021-09-01 | Ohio | Kentucky | 21183 | 3345 | 59 |
1671506 | 1671506 | 2021-08-31 | Ohio | Kentucky | 21183 | 3311 | 59 |
1668259 | 1668259 | 2021-08-30 | Ohio | Kentucky | 21183 | 3274 | 59 |
1665012 | 1665012 | 2021-08-29 | Ohio | Kentucky | 21183 | 3199 | 59 |
1661764 | 1661764 | 2021-08-28 | Ohio | Kentucky | 21183 | 3199 | 59 |
1658516 | 1658516 | 2021-08-27 | Ohio | Kentucky | 21183 | 3199 | 59 |
1655268 | 1655268 | 2021-08-26 | Ohio | Kentucky | 21183 | 3176 | 58 |
1652021 | 1652021 | 2021-08-25 | Ohio | Kentucky | 21183 | 3139 | 58 |
1648772 | 1648772 | 2021-08-24 | Ohio | Kentucky | 21183 | 3114 | 58 |
1645524 | 1645524 | 2021-08-23 | Ohio | Kentucky | 21183 | 3057 | 58 |
1642275 | 1642275 | 2021-08-22 | Ohio | Kentucky | 21183 | 2993 | 58 |
1639025 | 1639025 | 2021-08-21 | Ohio | Kentucky | 21183 | 2993 | 58 |
1635775 | 1635775 | 2021-08-20 | Ohio | Kentucky | 21183 | 2993 | 58 |
1632525 | 1632525 | 2021-08-19 | Ohio | Kentucky | 21183 | 2969 | 57 |
1629278 | 1629278 | 2021-08-18 | Ohio | Kentucky | 21183 | 2930 | 57 |
1626031 | 1626031 | 2021-08-17 | Ohio | Kentucky | 21183 | 2914 | 57 |
1622784 | 1622784 | 2021-08-16 | Ohio | Kentucky | 21183 | 2892 | 57 |
1619537 | 1619537 | 2021-08-15 | Ohio | Kentucky | 21183 | 2852 | 56 |
1616289 | 1616289 | 2021-08-14 | Ohio | Kentucky | 21183 | 2852 | 56 |
1613040 | 1613040 | 2021-08-13 | Ohio | Kentucky | 21183 | 2852 | 56 |
1609792 | 1609792 | 2021-08-12 | Ohio | Kentucky | 21183 | 2827 | 56 |
1606543 | 1606543 | 2021-08-11 | Ohio | Kentucky | 21183 | 2813 | 56 |
1603294 | 1603294 | 2021-08-10 | Ohio | Kentucky | 21183 | 2785 | 56 |
1600045 | 1600045 | 2021-08-09 | Ohio | Kentucky | 21183 | 2754 | 56 |
1596797 | 1596797 | 2021-08-08 | Ohio | Kentucky | 21183 | 2723 | 55 |
1593548 | 1593548 | 2021-08-07 | Ohio | Kentucky | 21183 | 2723 | 55 |
1590299 | 1590299 | 2021-08-06 | Ohio | Kentucky | 21183 | 2723 | 55 |
1587050 | 1587050 | 2021-08-05 | Ohio | Kentucky | 21183 | 2708 | 55 |
1583800 | 1583800 | 2021-08-04 | Ohio | Kentucky | 21183 | 2699 | 55 |
1580550 | 1580550 | 2021-08-03 | Ohio | Kentucky | 21183 | 2688 | 55 |
1577301 | 1577301 | 2021-08-02 | Ohio | Kentucky | 21183 | 2680 | 55 |
1574053 | 1574053 | 2021-08-01 | Ohio | Kentucky | 21183 | 2650 | 55 |
1570805 | 1570805 | 2021-07-31 | Ohio | Kentucky | 21183 | 2650 | 55 |
1567557 | 1567557 | 2021-07-30 | Ohio | Kentucky | 21183 | 2650 | 55 |
1564309 | 1564309 | 2021-07-29 | Ohio | Kentucky | 21183 | 2631 | 55 |
1561061 | 1561061 | 2021-07-28 | Ohio | Kentucky | 21183 | 2618 | 55 |
1557814 | 1557814 | 2021-07-27 | Ohio | Kentucky | 21183 | 2610 | 55 |
1554567 | 1554567 | 2021-07-26 | Ohio | Kentucky | 21183 | 2595 | 55 |
1551320 | 1551320 | 2021-07-25 | Ohio | Kentucky | 21183 | 2575 | 55 |
1548073 | 1548073 | 2021-07-24 | Ohio | Kentucky | 21183 | 2575 | 55 |
1544826 | 1544826 | 2021-07-23 | Ohio | Kentucky | 21183 | 2575 | 55 |
1541578 | 1541578 | 2021-07-22 | Ohio | Kentucky | 21183 | 2566 | 55 |
1538331 | 1538331 | 2021-07-21 | Ohio | Kentucky | 21183 | 2560 | 55 |
1535083 | 1535083 | 2021-07-20 | Ohio | Kentucky | 21183 | 2549 | 55 |
1531836 | 1531836 | 2021-07-19 | Ohio | Kentucky | 21183 | 2542 | 55 |
1528589 | 1528589 | 2021-07-18 | Ohio | Kentucky | 21183 | 2538 | 55 |
1525342 | 1525342 | 2021-07-17 | Ohio | Kentucky | 21183 | 2538 | 55 |
1522094 | 1522094 | 2021-07-16 | Ohio | Kentucky | 21183 | 2538 | 55 |
1518846 | 1518846 | 2021-07-15 | Ohio | Kentucky | 21183 | 2536 | 55 |
1515599 | 1515599 | 2021-07-14 | Ohio | Kentucky | 21183 | 2536 | 55 |
1512353 | 1512353 | 2021-07-13 | Ohio | Kentucky | 21183 | 2532 | 55 |
1509106 | 1509106 | 2021-07-12 | Ohio | Kentucky | 21183 | 2529 | 55 |
1505860 | 1505860 | 2021-07-11 | Ohio | Kentucky | 21183 | 2528 | 55 |
1502614 | 1502614 | 2021-07-10 | Ohio | Kentucky | 21183 | 2528 | 55 |
1499368 | 1499368 | 2021-07-09 | Ohio | Kentucky | 21183 | 2528 | 55 |
1496121 | 1496121 | 2021-07-08 | Ohio | Kentucky | 21183 | 2526 | 55 |
1492875 | 1492875 | 2021-07-07 | Ohio | Kentucky | 21183 | 2525 | 55 |
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);