ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Huron" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812217 | 1812217 | 2021-10-13 | Huron | Ohio | 39077 | 8102 | 138 |
1808968 | 1808968 | 2021-10-12 | Huron | Ohio | 39077 | 8068 | 138 |
1805718 | 1805718 | 2021-10-11 | Huron | Ohio | 39077 | 8031 | 138 |
1802468 | 1802468 | 2021-10-10 | Huron | Ohio | 39077 | 8013 | 138 |
1799219 | 1799219 | 2021-10-09 | Huron | Ohio | 39077 | 7997 | 138 |
1795970 | 1795970 | 2021-10-08 | Huron | Ohio | 39077 | 7978 | 138 |
1792721 | 1792721 | 2021-10-07 | Huron | Ohio | 39077 | 7933 | 134 |
1789472 | 1789472 | 2021-10-06 | Huron | Ohio | 39077 | 7900 | 134 |
1786224 | 1786224 | 2021-10-05 | Huron | Ohio | 39077 | 7862 | 134 |
1782975 | 1782975 | 2021-10-04 | Huron | Ohio | 39077 | 7830 | 133 |
1779726 | 1779726 | 2021-10-03 | Huron | Ohio | 39077 | 7812 | 133 |
1776476 | 1776476 | 2021-10-02 | Huron | Ohio | 39077 | 7791 | 133 |
1773226 | 1773226 | 2021-10-01 | Huron | Ohio | 39077 | 7749 | 133 |
1769976 | 1769976 | 2021-09-30 | Huron | Ohio | 39077 | 7721 | 131 |
1766727 | 1766727 | 2021-09-29 | Huron | Ohio | 39077 | 7686 | 131 |
1763478 | 1763478 | 2021-09-28 | Huron | Ohio | 39077 | 7651 | 131 |
1760229 | 1760229 | 2021-09-27 | Huron | Ohio | 39077 | 7598 | 131 |
1756981 | 1756981 | 2021-09-26 | Huron | Ohio | 39077 | 7566 | 131 |
1753733 | 1753733 | 2021-09-25 | Huron | Ohio | 39077 | 7537 | 131 |
1750485 | 1750485 | 2021-09-24 | Huron | Ohio | 39077 | 7507 | 131 |
1747235 | 1747235 | 2021-09-23 | Huron | Ohio | 39077 | 7476 | 128 |
1743986 | 1743986 | 2021-09-22 | Huron | Ohio | 39077 | 7423 | 128 |
1740737 | 1740737 | 2021-09-21 | Huron | Ohio | 39077 | 7366 | 128 |
1737488 | 1737488 | 2021-09-20 | Huron | Ohio | 39077 | 7309 | 127 |
1734238 | 1734238 | 2021-09-19 | Huron | Ohio | 39077 | 7279 | 127 |
1730988 | 1730988 | 2021-09-18 | Huron | Ohio | 39077 | 7253 | 127 |
1727738 | 1727738 | 2021-09-17 | Huron | Ohio | 39077 | 7210 | 127 |
1724489 | 1724489 | 2021-09-16 | Huron | Ohio | 39077 | 7143 | 125 |
1721240 | 1721240 | 2021-09-15 | Huron | Ohio | 39077 | 7087 | 125 |
1717992 | 1717992 | 2021-09-14 | Huron | Ohio | 39077 | 7020 | 125 |
1714744 | 1714744 | 2021-09-13 | Huron | Ohio | 39077 | 6983 | 124 |
1711498 | 1711498 | 2021-09-12 | Huron | Ohio | 39077 | 6920 | 124 |
1708251 | 1708251 | 2021-09-11 | Huron | Ohio | 39077 | 6887 | 124 |
1705004 | 1705004 | 2021-09-10 | Huron | Ohio | 39077 | 6843 | 124 |
1701754 | 1701754 | 2021-09-09 | Huron | Ohio | 39077 | 6786 | 124 |
1698505 | 1698505 | 2021-09-08 | Huron | Ohio | 39077 | 6710 | 124 |
1695257 | 1695257 | 2021-09-07 | Huron | Ohio | 39077 | 6650 | 124 |
1692009 | 1692009 | 2021-09-06 | Huron | Ohio | 39077 | 6634 | 124 |
1688760 | 1688760 | 2021-09-05 | Huron | Ohio | 39077 | 6596 | 124 |
1685510 | 1685510 | 2021-09-04 | Huron | Ohio | 39077 | 6552 | 124 |
1682259 | 1682259 | 2021-09-03 | Huron | Ohio | 39077 | 6504 | 124 |
1679009 | 1679009 | 2021-09-02 | Huron | Ohio | 39077 | 6453 | 123 |
1675761 | 1675761 | 2021-09-01 | Huron | Ohio | 39077 | 6403 | 123 |
1672514 | 1672514 | 2021-08-31 | Huron | Ohio | 39077 | 6359 | 123 |
1669266 | 1669266 | 2021-08-30 | Huron | Ohio | 39077 | 6314 | 123 |
1666019 | 1666019 | 2021-08-29 | Huron | Ohio | 39077 | 6291 | 123 |
1662771 | 1662771 | 2021-08-28 | Huron | Ohio | 39077 | 6250 | 123 |
1659523 | 1659523 | 2021-08-27 | Huron | Ohio | 39077 | 6224 | 123 |
1656274 | 1656274 | 2021-08-26 | Huron | Ohio | 39077 | 6195 | 123 |
1653027 | 1653027 | 2021-08-25 | Huron | Ohio | 39077 | 6139 | 123 |
1649780 | 1649780 | 2021-08-24 | Huron | Ohio | 39077 | 6102 | 123 |
1646531 | 1646531 | 2021-08-23 | Huron | Ohio | 39077 | 6062 | 123 |
1643282 | 1643282 | 2021-08-22 | Huron | Ohio | 39077 | 6049 | 123 |
1640032 | 1640032 | 2021-08-21 | Huron | Ohio | 39077 | 6009 | 123 |
1636782 | 1636782 | 2021-08-20 | Huron | Ohio | 39077 | 5982 | 123 |
1633532 | 1633532 | 2021-08-19 | Huron | Ohio | 39077 | 5954 | 122 |
1630285 | 1630285 | 2021-08-18 | Huron | Ohio | 39077 | 5921 | 122 |
1627038 | 1627038 | 2021-08-17 | Huron | Ohio | 39077 | 5894 | 122 |
1623791 | 1623791 | 2021-08-16 | Huron | Ohio | 39077 | 5874 | 122 |
1620544 | 1620544 | 2021-08-15 | Huron | Ohio | 39077 | 5859 | 122 |
1617296 | 1617296 | 2021-08-14 | Huron | Ohio | 39077 | 5848 | 122 |
1614048 | 1614048 | 2021-08-13 | Huron | Ohio | 39077 | 5827 | 122 |
1610799 | 1610799 | 2021-08-12 | Huron | Ohio | 39077 | 5813 | 122 |
1607551 | 1607551 | 2021-08-11 | Huron | Ohio | 39077 | 5790 | 122 |
1604302 | 1604302 | 2021-08-10 | Huron | Ohio | 39077 | 5773 | 122 |
1601053 | 1601053 | 2021-08-09 | Huron | Ohio | 39077 | 5762 | 122 |
1597805 | 1597805 | 2021-08-08 | Huron | Ohio | 39077 | 5750 | 122 |
1594556 | 1594556 | 2021-08-07 | Huron | Ohio | 39077 | 5742 | 122 |
1591307 | 1591307 | 2021-08-06 | Huron | Ohio | 39077 | 5727 | 122 |
1588058 | 1588058 | 2021-08-05 | Huron | Ohio | 39077 | 5705 | 122 |
1584808 | 1584808 | 2021-08-04 | Huron | Ohio | 39077 | 5697 | 122 |
1581558 | 1581558 | 2021-08-03 | Huron | Ohio | 39077 | 5678 | 122 |
1578309 | 1578309 | 2021-08-02 | Huron | Ohio | 39077 | 5671 | 122 |
1575061 | 1575061 | 2021-08-01 | Huron | Ohio | 39077 | 5666 | 122 |
1571813 | 1571813 | 2021-07-31 | Huron | Ohio | 39077 | 5664 | 122 |
1568565 | 1568565 | 2021-07-30 | Huron | Ohio | 39077 | 5658 | 122 |
1565317 | 1565317 | 2021-07-29 | Huron | Ohio | 39077 | 5654 | 122 |
1562069 | 1562069 | 2021-07-28 | Huron | Ohio | 39077 | 5644 | 122 |
1558821 | 1558821 | 2021-07-27 | Huron | Ohio | 39077 | 5638 | 122 |
1555574 | 1555574 | 2021-07-26 | Huron | Ohio | 39077 | 5630 | 122 |
1552327 | 1552327 | 2021-07-25 | Huron | Ohio | 39077 | 5624 | 122 |
1549080 | 1549080 | 2021-07-24 | Huron | Ohio | 39077 | 5624 | 122 |
1545833 | 1545833 | 2021-07-23 | Huron | Ohio | 39077 | 5622 | 122 |
1542586 | 1542586 | 2021-07-22 | Huron | Ohio | 39077 | 5618 | 122 |
1539338 | 1539338 | 2021-07-21 | Huron | Ohio | 39077 | 5613 | 122 |
1536091 | 1536091 | 2021-07-20 | Huron | Ohio | 39077 | 5607 | 122 |
1532843 | 1532843 | 2021-07-19 | Huron | Ohio | 39077 | 5602 | 122 |
1529596 | 1529596 | 2021-07-18 | Huron | Ohio | 39077 | 5602 | 122 |
1526349 | 1526349 | 2021-07-17 | Huron | Ohio | 39077 | 5602 | 122 |
1523102 | 1523102 | 2021-07-16 | Huron | Ohio | 39077 | 5600 | 122 |
1519854 | 1519854 | 2021-07-15 | Huron | Ohio | 39077 | 5600 | 122 |
1516606 | 1516606 | 2021-07-14 | Huron | Ohio | 39077 | 5600 | 122 |
1513359 | 1513359 | 2021-07-13 | Huron | Ohio | 39077 | 5596 | 122 |
1510113 | 1510113 | 2021-07-12 | Huron | Ohio | 39077 | 5592 | 122 |
1506866 | 1506866 | 2021-07-11 | Huron | Ohio | 39077 | 5591 | 122 |
1503620 | 1503620 | 2021-07-10 | Huron | Ohio | 39077 | 5589 | 122 |
1500374 | 1500374 | 2021-07-09 | Huron | Ohio | 39077 | 5587 | 122 |
1497128 | 1497128 | 2021-07-08 | Huron | Ohio | 39077 | 5580 | 122 |
1493881 | 1493881 | 2021-07-07 | Huron | Ohio | 39077 | 5577 | 122 |
1490634 | 1490634 | 2021-07-06 | Huron | Ohio | 39077 | 5577 | 122 |
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);