ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Darke" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812197 | 1812197 | 2021-10-13 | Darke | Ohio | 39037 | 7477 | 150 |
1808948 | 1808948 | 2021-10-12 | Darke | Ohio | 39037 | 7423 | 150 |
1805698 | 1805698 | 2021-10-11 | Darke | Ohio | 39037 | 7386 | 147 |
1802448 | 1802448 | 2021-10-10 | Darke | Ohio | 39037 | 7384 | 147 |
1799199 | 1799199 | 2021-10-09 | Darke | Ohio | 39037 | 7367 | 147 |
1795950 | 1795950 | 2021-10-08 | Darke | Ohio | 39037 | 7354 | 147 |
1792701 | 1792701 | 2021-10-07 | Darke | Ohio | 39037 | 7320 | 145 |
1789452 | 1789452 | 2021-10-06 | Darke | Ohio | 39037 | 7263 | 145 |
1786204 | 1786204 | 2021-10-05 | Darke | Ohio | 39037 | 7187 | 145 |
1782955 | 1782955 | 2021-10-04 | Darke | Ohio | 39037 | 7164 | 143 |
1779706 | 1779706 | 2021-10-03 | Darke | Ohio | 39037 | 7131 | 143 |
1776456 | 1776456 | 2021-10-02 | Darke | Ohio | 39037 | 7123 | 143 |
1773206 | 1773206 | 2021-10-01 | Darke | Ohio | 39037 | 7088 | 143 |
1769956 | 1769956 | 2021-09-30 | Darke | Ohio | 39037 | 7067 | 140 |
1766707 | 1766707 | 2021-09-29 | Darke | Ohio | 39037 | 6960 | 140 |
1763458 | 1763458 | 2021-09-28 | Darke | Ohio | 39037 | 6940 | 140 |
1760209 | 1760209 | 2021-09-27 | Darke | Ohio | 39037 | 6906 | 137 |
1756961 | 1756961 | 2021-09-26 | Darke | Ohio | 39037 | 6884 | 137 |
1753713 | 1753713 | 2021-09-25 | Darke | Ohio | 39037 | 6875 | 137 |
1750465 | 1750465 | 2021-09-24 | Darke | Ohio | 39037 | 6853 | 137 |
1747215 | 1747215 | 2021-09-23 | Darke | Ohio | 39037 | 6789 | 136 |
1743966 | 1743966 | 2021-09-22 | Darke | Ohio | 39037 | 6756 | 136 |
1740717 | 1740717 | 2021-09-21 | Darke | Ohio | 39037 | 6663 | 136 |
1737468 | 1737468 | 2021-09-20 | Darke | Ohio | 39037 | 6602 | 136 |
1734218 | 1734218 | 2021-09-19 | Darke | Ohio | 39037 | 6569 | 136 |
1730968 | 1730968 | 2021-09-18 | Darke | Ohio | 39037 | 6559 | 136 |
1727718 | 1727718 | 2021-09-17 | Darke | Ohio | 39037 | 6521 | 136 |
1724469 | 1724469 | 2021-09-16 | Darke | Ohio | 39037 | 6458 | 135 |
1721220 | 1721220 | 2021-09-15 | Darke | Ohio | 39037 | 6394 | 135 |
1717972 | 1717972 | 2021-09-14 | Darke | Ohio | 39037 | 6323 | 135 |
1714724 | 1714724 | 2021-09-13 | Darke | Ohio | 39037 | 6265 | 135 |
1711478 | 1711478 | 2021-09-12 | Darke | Ohio | 39037 | 6239 | 135 |
1708231 | 1708231 | 2021-09-11 | Darke | Ohio | 39037 | 6235 | 135 |
1704984 | 1704984 | 2021-09-10 | Darke | Ohio | 39037 | 6199 | 135 |
1701734 | 1701734 | 2021-09-09 | Darke | Ohio | 39037 | 6130 | 133 |
1698485 | 1698485 | 2021-09-08 | Darke | Ohio | 39037 | 6082 | 133 |
1695237 | 1695237 | 2021-09-07 | Darke | Ohio | 39037 | 5995 | 133 |
1691989 | 1691989 | 2021-09-06 | Darke | Ohio | 39037 | 5961 | 133 |
1688740 | 1688740 | 2021-09-05 | Darke | Ohio | 39037 | 5960 | 133 |
1685490 | 1685490 | 2021-09-04 | Darke | Ohio | 39037 | 5943 | 133 |
1682239 | 1682239 | 2021-09-03 | Darke | Ohio | 39037 | 5925 | 133 |
1678989 | 1678989 | 2021-09-02 | Darke | Ohio | 39037 | 5891 | 132 |
1675741 | 1675741 | 2021-09-01 | Darke | Ohio | 39037 | 5856 | 132 |
1672494 | 1672494 | 2021-08-31 | Darke | Ohio | 39037 | 5831 | 132 |
1669246 | 1669246 | 2021-08-30 | Darke | Ohio | 39037 | 5806 | 131 |
1665999 | 1665999 | 2021-08-29 | Darke | Ohio | 39037 | 5788 | 131 |
1662751 | 1662751 | 2021-08-28 | Darke | Ohio | 39037 | 5774 | 131 |
1659503 | 1659503 | 2021-08-27 | Darke | Ohio | 39037 | 5755 | 131 |
1656254 | 1656254 | 2021-08-26 | Darke | Ohio | 39037 | 5745 | 131 |
1653007 | 1653007 | 2021-08-25 | Darke | Ohio | 39037 | 5730 | 131 |
1649760 | 1649760 | 2021-08-24 | Darke | Ohio | 39037 | 5702 | 131 |
1646511 | 1646511 | 2021-08-23 | Darke | Ohio | 39037 | 5684 | 131 |
1643262 | 1643262 | 2021-08-22 | Darke | Ohio | 39037 | 5666 | 131 |
1640012 | 1640012 | 2021-08-21 | Darke | Ohio | 39037 | 5662 | 131 |
1636762 | 1636762 | 2021-08-20 | Darke | Ohio | 39037 | 5651 | 131 |
1633512 | 1633512 | 2021-08-19 | Darke | Ohio | 39037 | 5629 | 131 |
1630265 | 1630265 | 2021-08-18 | Darke | Ohio | 39037 | 5606 | 131 |
1627018 | 1627018 | 2021-08-17 | Darke | Ohio | 39037 | 5586 | 131 |
1623771 | 1623771 | 2021-08-16 | Darke | Ohio | 39037 | 5577 | 131 |
1620524 | 1620524 | 2021-08-15 | Darke | Ohio | 39037 | 5572 | 131 |
1617276 | 1617276 | 2021-08-14 | Darke | Ohio | 39037 | 5565 | 131 |
1614028 | 1614028 | 2021-08-13 | Darke | Ohio | 39037 | 5559 | 131 |
1610779 | 1610779 | 2021-08-12 | Darke | Ohio | 39037 | 5552 | 131 |
1607531 | 1607531 | 2021-08-11 | Darke | Ohio | 39037 | 5533 | 131 |
1604282 | 1604282 | 2021-08-10 | Darke | Ohio | 39037 | 5517 | 131 |
1601033 | 1601033 | 2021-08-09 | Darke | Ohio | 39037 | 5505 | 131 |
1597785 | 1597785 | 2021-08-08 | Darke | Ohio | 39037 | 5500 | 131 |
1594536 | 1594536 | 2021-08-07 | Darke | Ohio | 39037 | 5497 | 131 |
1591287 | 1591287 | 2021-08-06 | Darke | Ohio | 39037 | 5492 | 131 |
1588038 | 1588038 | 2021-08-05 | Darke | Ohio | 39037 | 5489 | 131 |
1584788 | 1584788 | 2021-08-04 | Darke | Ohio | 39037 | 5483 | 131 |
1581538 | 1581538 | 2021-08-03 | Darke | Ohio | 39037 | 5476 | 131 |
1578289 | 1578289 | 2021-08-02 | Darke | Ohio | 39037 | 5470 | 131 |
1575041 | 1575041 | 2021-08-01 | Darke | Ohio | 39037 | 5467 | 131 |
1571793 | 1571793 | 2021-07-31 | Darke | Ohio | 39037 | 5464 | 131 |
1568545 | 1568545 | 2021-07-30 | Darke | Ohio | 39037 | 5455 | 131 |
1565297 | 1565297 | 2021-07-29 | Darke | Ohio | 39037 | 5450 | 131 |
1562049 | 1562049 | 2021-07-28 | Darke | Ohio | 39037 | 5448 | 131 |
1558801 | 1558801 | 2021-07-27 | Darke | Ohio | 39037 | 5444 | 131 |
1555554 | 1555554 | 2021-07-26 | Darke | Ohio | 39037 | 5436 | 130 |
1552307 | 1552307 | 2021-07-25 | Darke | Ohio | 39037 | 5436 | 130 |
1549060 | 1549060 | 2021-07-24 | Darke | Ohio | 39037 | 5436 | 130 |
1545813 | 1545813 | 2021-07-23 | Darke | Ohio | 39037 | 5436 | 130 |
1542566 | 1542566 | 2021-07-22 | Darke | Ohio | 39037 | 5436 | 130 |
1539318 | 1539318 | 2021-07-21 | Darke | Ohio | 39037 | 5436 | 130 |
1536071 | 1536071 | 2021-07-20 | Darke | Ohio | 39037 | 5435 | 130 |
1532823 | 1532823 | 2021-07-19 | Darke | Ohio | 39037 | 5434 | 129 |
1529576 | 1529576 | 2021-07-18 | Darke | Ohio | 39037 | 5435 | 129 |
1526329 | 1526329 | 2021-07-17 | Darke | Ohio | 39037 | 5435 | 129 |
1523082 | 1523082 | 2021-07-16 | Darke | Ohio | 39037 | 5434 | 129 |
1519834 | 1519834 | 2021-07-15 | Darke | Ohio | 39037 | 5434 | 129 |
1516586 | 1516586 | 2021-07-14 | Darke | Ohio | 39037 | 5432 | 129 |
1513339 | 1513339 | 2021-07-13 | Darke | Ohio | 39037 | 5432 | 129 |
1510093 | 1510093 | 2021-07-12 | Darke | Ohio | 39037 | 5432 | 129 |
1506846 | 1506846 | 2021-07-11 | Darke | Ohio | 39037 | 5432 | 129 |
1503600 | 1503600 | 2021-07-10 | Darke | Ohio | 39037 | 5432 | 129 |
1500354 | 1500354 | 2021-07-09 | Darke | Ohio | 39037 | 5431 | 129 |
1497108 | 1497108 | 2021-07-08 | Darke | Ohio | 39037 | 5431 | 129 |
1493861 | 1493861 | 2021-07-07 | Darke | Ohio | 39037 | 5430 | 129 |
1490614 | 1490614 | 2021-07-06 | Darke | Ohio | 39037 | 5430 | 129 |
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);