ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Geauga" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812206 | 1812206 | 2021-10-13 | Geauga | Ohio | 39055 | 8699 | 158 |
1808957 | 1808957 | 2021-10-12 | Geauga | Ohio | 39055 | 8656 | 158 |
1805707 | 1805707 | 2021-10-11 | Geauga | Ohio | 39055 | 8631 | 158 |
1802457 | 1802457 | 2021-10-10 | Geauga | Ohio | 39055 | 8610 | 158 |
1799208 | 1799208 | 2021-10-09 | Geauga | Ohio | 39055 | 8582 | 158 |
1795959 | 1795959 | 2021-10-08 | Geauga | Ohio | 39055 | 8560 | 158 |
1792710 | 1792710 | 2021-10-07 | Geauga | Ohio | 39055 | 8535 | 158 |
1789461 | 1789461 | 2021-10-06 | Geauga | Ohio | 39055 | 8505 | 158 |
1786213 | 1786213 | 2021-10-05 | Geauga | Ohio | 39055 | 8487 | 158 |
1782964 | 1782964 | 2021-10-04 | Geauga | Ohio | 39055 | 8461 | 158 |
1779715 | 1779715 | 2021-10-03 | Geauga | Ohio | 39055 | 8440 | 158 |
1776465 | 1776465 | 2021-10-02 | Geauga | Ohio | 39055 | 8421 | 158 |
1773215 | 1773215 | 2021-10-01 | Geauga | Ohio | 39055 | 8402 | 158 |
1769965 | 1769965 | 2021-09-30 | Geauga | Ohio | 39055 | 8365 | 157 |
1766716 | 1766716 | 2021-09-29 | Geauga | Ohio | 39055 | 8339 | 157 |
1763467 | 1763467 | 2021-09-28 | Geauga | Ohio | 39055 | 8312 | 157 |
1760218 | 1760218 | 2021-09-27 | Geauga | Ohio | 39055 | 8294 | 156 |
1756970 | 1756970 | 2021-09-26 | Geauga | Ohio | 39055 | 8272 | 156 |
1753722 | 1753722 | 2021-09-25 | Geauga | Ohio | 39055 | 8251 | 156 |
1750474 | 1750474 | 2021-09-24 | Geauga | Ohio | 39055 | 8226 | 156 |
1747224 | 1747224 | 2021-09-23 | Geauga | Ohio | 39055 | 8196 | 156 |
1743975 | 1743975 | 2021-09-22 | Geauga | Ohio | 39055 | 8173 | 156 |
1740726 | 1740726 | 2021-09-21 | Geauga | Ohio | 39055 | 8148 | 156 |
1737477 | 1737477 | 2021-09-20 | Geauga | Ohio | 39055 | 8116 | 155 |
1734227 | 1734227 | 2021-09-19 | Geauga | Ohio | 39055 | 8100 | 155 |
1730977 | 1730977 | 2021-09-18 | Geauga | Ohio | 39055 | 8066 | 155 |
1727727 | 1727727 | 2021-09-17 | Geauga | Ohio | 39055 | 8041 | 155 |
1724478 | 1724478 | 2021-09-16 | Geauga | Ohio | 39055 | 8012 | 155 |
1721229 | 1721229 | 2021-09-15 | Geauga | Ohio | 39055 | 7976 | 155 |
1717981 | 1717981 | 2021-09-14 | Geauga | Ohio | 39055 | 7942 | 155 |
1714733 | 1714733 | 2021-09-13 | Geauga | Ohio | 39055 | 7887 | 155 |
1711487 | 1711487 | 2021-09-12 | Geauga | Ohio | 39055 | 7858 | 155 |
1708240 | 1708240 | 2021-09-11 | Geauga | Ohio | 39055 | 7836 | 155 |
1704993 | 1704993 | 2021-09-10 | Geauga | Ohio | 39055 | 7800 | 155 |
1701743 | 1701743 | 2021-09-09 | Geauga | Ohio | 39055 | 7768 | 155 |
1698494 | 1698494 | 2021-09-08 | Geauga | Ohio | 39055 | 7746 | 155 |
1695246 | 1695246 | 2021-09-07 | Geauga | Ohio | 39055 | 7717 | 155 |
1691998 | 1691998 | 2021-09-06 | Geauga | Ohio | 39055 | 7680 | 155 |
1688749 | 1688749 | 2021-09-05 | Geauga | Ohio | 39055 | 7666 | 155 |
1685499 | 1685499 | 2021-09-04 | Geauga | Ohio | 39055 | 7636 | 155 |
1682248 | 1682248 | 2021-09-03 | Geauga | Ohio | 39055 | 7608 | 155 |
1678998 | 1678998 | 2021-09-02 | Geauga | Ohio | 39055 | 7583 | 155 |
1675750 | 1675750 | 2021-09-01 | Geauga | Ohio | 39055 | 7548 | 155 |
1672503 | 1672503 | 2021-08-31 | Geauga | Ohio | 39055 | 7525 | 155 |
1669255 | 1669255 | 2021-08-30 | Geauga | Ohio | 39055 | 7492 | 155 |
1666008 | 1666008 | 2021-08-29 | Geauga | Ohio | 39055 | 7465 | 155 |
1662760 | 1662760 | 2021-08-28 | Geauga | Ohio | 39055 | 7441 | 155 |
1659512 | 1659512 | 2021-08-27 | Geauga | Ohio | 39055 | 7409 | 155 |
1656263 | 1656263 | 2021-08-26 | Geauga | Ohio | 39055 | 7386 | 155 |
1653016 | 1653016 | 2021-08-25 | Geauga | Ohio | 39055 | 7364 | 155 |
1649769 | 1649769 | 2021-08-24 | Geauga | Ohio | 39055 | 7336 | 155 |
1646520 | 1646520 | 2021-08-23 | Geauga | Ohio | 39055 | 7318 | 153 |
1643271 | 1643271 | 2021-08-22 | Geauga | Ohio | 39055 | 7299 | 153 |
1640021 | 1640021 | 2021-08-21 | Geauga | Ohio | 39055 | 7287 | 153 |
1636771 | 1636771 | 2021-08-20 | Geauga | Ohio | 39055 | 7270 | 153 |
1633521 | 1633521 | 2021-08-19 | Geauga | Ohio | 39055 | 7251 | 153 |
1630274 | 1630274 | 2021-08-18 | Geauga | Ohio | 39055 | 7240 | 153 |
1627027 | 1627027 | 2021-08-17 | Geauga | Ohio | 39055 | 7221 | 153 |
1623780 | 1623780 | 2021-08-16 | Geauga | Ohio | 39055 | 7199 | 153 |
1620533 | 1620533 | 2021-08-15 | Geauga | Ohio | 39055 | 7188 | 153 |
1617285 | 1617285 | 2021-08-14 | Geauga | Ohio | 39055 | 7175 | 153 |
1614037 | 1614037 | 2021-08-13 | Geauga | Ohio | 39055 | 7158 | 153 |
1610788 | 1610788 | 2021-08-12 | Geauga | Ohio | 39055 | 7145 | 153 |
1607540 | 1607540 | 2021-08-11 | Geauga | Ohio | 39055 | 7123 | 153 |
1604291 | 1604291 | 2021-08-10 | Geauga | Ohio | 39055 | 7109 | 153 |
1601042 | 1601042 | 2021-08-09 | Geauga | Ohio | 39055 | 7091 | 153 |
1597794 | 1597794 | 2021-08-08 | Geauga | Ohio | 39055 | 7082 | 153 |
1594545 | 1594545 | 2021-08-07 | Geauga | Ohio | 39055 | 7075 | 153 |
1591296 | 1591296 | 2021-08-06 | Geauga | Ohio | 39055 | 7065 | 153 |
1588047 | 1588047 | 2021-08-05 | Geauga | Ohio | 39055 | 7055 | 153 |
1584797 | 1584797 | 2021-08-04 | Geauga | Ohio | 39055 | 7044 | 153 |
1581547 | 1581547 | 2021-08-03 | Geauga | Ohio | 39055 | 7032 | 153 |
1578298 | 1578298 | 2021-08-02 | Geauga | Ohio | 39055 | 7019 | 153 |
1575050 | 1575050 | 2021-08-01 | Geauga | Ohio | 39055 | 7013 | 153 |
1571802 | 1571802 | 2021-07-31 | Geauga | Ohio | 39055 | 7008 | 153 |
1568554 | 1568554 | 2021-07-30 | Geauga | Ohio | 39055 | 6994 | 153 |
1565306 | 1565306 | 2021-07-29 | Geauga | Ohio | 39055 | 6987 | 153 |
1562058 | 1562058 | 2021-07-28 | Geauga | Ohio | 39055 | 6975 | 153 |
1558810 | 1558810 | 2021-07-27 | Geauga | Ohio | 39055 | 6962 | 153 |
1555563 | 1555563 | 2021-07-26 | Geauga | Ohio | 39055 | 6948 | 153 |
1552316 | 1552316 | 2021-07-25 | Geauga | Ohio | 39055 | 6946 | 153 |
1549069 | 1549069 | 2021-07-24 | Geauga | Ohio | 39055 | 6943 | 153 |
1545822 | 1545822 | 2021-07-23 | Geauga | Ohio | 39055 | 6939 | 153 |
1542575 | 1542575 | 2021-07-22 | Geauga | Ohio | 39055 | 6931 | 153 |
1539327 | 1539327 | 2021-07-21 | Geauga | Ohio | 39055 | 6925 | 153 |
1536080 | 1536080 | 2021-07-20 | Geauga | Ohio | 39055 | 6919 | 153 |
1532832 | 1532832 | 2021-07-19 | Geauga | Ohio | 39055 | 6907 | 153 |
1529585 | 1529585 | 2021-07-18 | Geauga | Ohio | 39055 | 6903 | 153 |
1526338 | 1526338 | 2021-07-17 | Geauga | Ohio | 39055 | 6898 | 153 |
1523091 | 1523091 | 2021-07-16 | Geauga | Ohio | 39055 | 6894 | 153 |
1519843 | 1519843 | 2021-07-15 | Geauga | Ohio | 39055 | 6893 | 153 |
1516595 | 1516595 | 2021-07-14 | Geauga | Ohio | 39055 | 6889 | 153 |
1513348 | 1513348 | 2021-07-13 | Geauga | Ohio | 39055 | 6886 | 153 |
1510102 | 1510102 | 2021-07-12 | Geauga | Ohio | 39055 | 6884 | 153 |
1506855 | 1506855 | 2021-07-11 | Geauga | Ohio | 39055 | 6883 | 153 |
1503609 | 1503609 | 2021-07-10 | Geauga | Ohio | 39055 | 6883 | 153 |
1500363 | 1500363 | 2021-07-09 | Geauga | Ohio | 39055 | 6884 | 153 |
1497117 | 1497117 | 2021-07-08 | Geauga | Ohio | 39055 | 6882 | 153 |
1493870 | 1493870 | 2021-07-07 | Geauga | Ohio | 39055 | 6877 | 153 |
1490623 | 1490623 | 2021-07-06 | Geauga | Ohio | 39055 | 6872 | 153 |
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);