ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Ashtabula" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812182 | 1812182 | 2021-10-13 | Ashtabula | Ohio | 39007 | 9266 | 194 |
1808933 | 1808933 | 2021-10-12 | Ashtabula | Ohio | 39007 | 9218 | 194 |
1805683 | 1805683 | 2021-10-11 | Ashtabula | Ohio | 39007 | 9199 | 192 |
1802433 | 1802433 | 2021-10-10 | Ashtabula | Ohio | 39007 | 9164 | 192 |
1799184 | 1799184 | 2021-10-09 | Ashtabula | Ohio | 39007 | 9089 | 192 |
1795935 | 1795935 | 2021-10-08 | Ashtabula | Ohio | 39007 | 9051 | 192 |
1792686 | 1792686 | 2021-10-07 | Ashtabula | Ohio | 39007 | 8977 | 192 |
1789437 | 1789437 | 2021-10-06 | Ashtabula | Ohio | 39007 | 8901 | 192 |
1786189 | 1786189 | 2021-10-05 | Ashtabula | Ohio | 39007 | 8863 | 192 |
1782940 | 1782940 | 2021-10-04 | Ashtabula | Ohio | 39007 | 8835 | 190 |
1779691 | 1779691 | 2021-10-03 | Ashtabula | Ohio | 39007 | 8813 | 190 |
1776441 | 1776441 | 2021-10-02 | Ashtabula | Ohio | 39007 | 8786 | 190 |
1773191 | 1773191 | 2021-10-01 | Ashtabula | Ohio | 39007 | 8728 | 190 |
1769941 | 1769941 | 2021-09-30 | Ashtabula | Ohio | 39007 | 8682 | 188 |
1766692 | 1766692 | 2021-09-29 | Ashtabula | Ohio | 39007 | 8613 | 188 |
1763443 | 1763443 | 2021-09-28 | Ashtabula | Ohio | 39007 | 8566 | 188 |
1760194 | 1760194 | 2021-09-27 | Ashtabula | Ohio | 39007 | 8533 | 187 |
1756946 | 1756946 | 2021-09-26 | Ashtabula | Ohio | 39007 | 8509 | 187 |
1753698 | 1753698 | 2021-09-25 | Ashtabula | Ohio | 39007 | 8474 | 187 |
1750450 | 1750450 | 2021-09-24 | Ashtabula | Ohio | 39007 | 8423 | 187 |
1747200 | 1747200 | 2021-09-23 | Ashtabula | Ohio | 39007 | 8376 | 185 |
1743951 | 1743951 | 2021-09-22 | Ashtabula | Ohio | 39007 | 8317 | 185 |
1740702 | 1740702 | 2021-09-21 | Ashtabula | Ohio | 39007 | 8280 | 185 |
1737453 | 1737453 | 2021-09-20 | Ashtabula | Ohio | 39007 | 8239 | 185 |
1734203 | 1734203 | 2021-09-19 | Ashtabula | Ohio | 39007 | 8208 | 185 |
1730953 | 1730953 | 2021-09-18 | Ashtabula | Ohio | 39007 | 8180 | 185 |
1727703 | 1727703 | 2021-09-17 | Ashtabula | Ohio | 39007 | 8161 | 185 |
1724454 | 1724454 | 2021-09-16 | Ashtabula | Ohio | 39007 | 8130 | 184 |
1721205 | 1721205 | 2021-09-15 | Ashtabula | Ohio | 39007 | 8083 | 184 |
1717957 | 1717957 | 2021-09-14 | Ashtabula | Ohio | 39007 | 8031 | 184 |
1714709 | 1714709 | 2021-09-13 | Ashtabula | Ohio | 39007 | 7991 | 184 |
1711463 | 1711463 | 2021-09-12 | Ashtabula | Ohio | 39007 | 7949 | 184 |
1708216 | 1708216 | 2021-09-11 | Ashtabula | Ohio | 39007 | 7919 | 184 |
1704969 | 1704969 | 2021-09-10 | Ashtabula | Ohio | 39007 | 7883 | 184 |
1701719 | 1701719 | 2021-09-09 | Ashtabula | Ohio | 39007 | 7846 | 184 |
1698470 | 1698470 | 2021-09-08 | Ashtabula | Ohio | 39007 | 7783 | 184 |
1695222 | 1695222 | 2021-09-07 | Ashtabula | Ohio | 39007 | 7754 | 184 |
1691974 | 1691974 | 2021-09-06 | Ashtabula | Ohio | 39007 | 7728 | 183 |
1688725 | 1688725 | 2021-09-05 | Ashtabula | Ohio | 39007 | 7714 | 183 |
1685475 | 1685475 | 2021-09-04 | Ashtabula | Ohio | 39007 | 7693 | 183 |
1682224 | 1682224 | 2021-09-03 | Ashtabula | Ohio | 39007 | 7663 | 183 |
1678974 | 1678974 | 2021-09-02 | Ashtabula | Ohio | 39007 | 7644 | 182 |
1675726 | 1675726 | 2021-09-01 | Ashtabula | Ohio | 39007 | 7620 | 182 |
1672479 | 1672479 | 2021-08-31 | Ashtabula | Ohio | 39007 | 7596 | 182 |
1669231 | 1669231 | 2021-08-30 | Ashtabula | Ohio | 39007 | 7581 | 182 |
1665984 | 1665984 | 2021-08-29 | Ashtabula | Ohio | 39007 | 7570 | 182 |
1662736 | 1662736 | 2021-08-28 | Ashtabula | Ohio | 39007 | 7553 | 182 |
1659488 | 1659488 | 2021-08-27 | Ashtabula | Ohio | 39007 | 7538 | 182 |
1656239 | 1656239 | 2021-08-26 | Ashtabula | Ohio | 39007 | 7525 | 182 |
1652992 | 1652992 | 2021-08-25 | Ashtabula | Ohio | 39007 | 7518 | 182 |
1649745 | 1649745 | 2021-08-24 | Ashtabula | Ohio | 39007 | 7501 | 182 |
1646496 | 1646496 | 2021-08-23 | Ashtabula | Ohio | 39007 | 7494 | 182 |
1643247 | 1643247 | 2021-08-22 | Ashtabula | Ohio | 39007 | 7485 | 182 |
1639997 | 1639997 | 2021-08-21 | Ashtabula | Ohio | 39007 | 7476 | 182 |
1636747 | 1636747 | 2021-08-20 | Ashtabula | Ohio | 39007 | 7468 | 182 |
1633497 | 1633497 | 2021-08-19 | Ashtabula | Ohio | 39007 | 7452 | 182 |
1630250 | 1630250 | 2021-08-18 | Ashtabula | Ohio | 39007 | 7441 | 182 |
1627003 | 1627003 | 2021-08-17 | Ashtabula | Ohio | 39007 | 7432 | 182 |
1623756 | 1623756 | 2021-08-16 | Ashtabula | Ohio | 39007 | 7426 | 181 |
1620509 | 1620509 | 2021-08-15 | Ashtabula | Ohio | 39007 | 7411 | 181 |
1617261 | 1617261 | 2021-08-14 | Ashtabula | Ohio | 39007 | 7399 | 181 |
1614013 | 1614013 | 2021-08-13 | Ashtabula | Ohio | 39007 | 7390 | 181 |
1610764 | 1610764 | 2021-08-12 | Ashtabula | Ohio | 39007 | 7380 | 181 |
1607516 | 1607516 | 2021-08-11 | Ashtabula | Ohio | 39007 | 7368 | 181 |
1604267 | 1604267 | 2021-08-10 | Ashtabula | Ohio | 39007 | 7358 | 181 |
1601018 | 1601018 | 2021-08-09 | Ashtabula | Ohio | 39007 | 7346 | 181 |
1597770 | 1597770 | 2021-08-08 | Ashtabula | Ohio | 39007 | 7341 | 181 |
1594521 | 1594521 | 2021-08-07 | Ashtabula | Ohio | 39007 | 7340 | 181 |
1591272 | 1591272 | 2021-08-06 | Ashtabula | Ohio | 39007 | 7332 | 181 |
1588023 | 1588023 | 2021-08-05 | Ashtabula | Ohio | 39007 | 7327 | 180 |
1584773 | 1584773 | 2021-08-04 | Ashtabula | Ohio | 39007 | 7324 | 180 |
1581523 | 1581523 | 2021-08-03 | Ashtabula | Ohio | 39007 | 7318 | 180 |
1578274 | 1578274 | 2021-08-02 | Ashtabula | Ohio | 39007 | 7310 | 179 |
1575026 | 1575026 | 2021-08-01 | Ashtabula | Ohio | 39007 | 7305 | 179 |
1571778 | 1571778 | 2021-07-31 | Ashtabula | Ohio | 39007 | 7294 | 179 |
1568530 | 1568530 | 2021-07-30 | Ashtabula | Ohio | 39007 | 7291 | 179 |
1565282 | 1565282 | 2021-07-29 | Ashtabula | Ohio | 39007 | 7284 | 179 |
1562034 | 1562034 | 2021-07-28 | Ashtabula | Ohio | 39007 | 7280 | 179 |
1558786 | 1558786 | 2021-07-27 | Ashtabula | Ohio | 39007 | 7281 | 179 |
1555539 | 1555539 | 2021-07-26 | Ashtabula | Ohio | 39007 | 7272 | 179 |
1552292 | 1552292 | 2021-07-25 | Ashtabula | Ohio | 39007 | 7270 | 179 |
1549045 | 1549045 | 2021-07-24 | Ashtabula | Ohio | 39007 | 7269 | 179 |
1545798 | 1545798 | 2021-07-23 | Ashtabula | Ohio | 39007 | 7264 | 179 |
1542551 | 1542551 | 2021-07-22 | Ashtabula | Ohio | 39007 | 7263 | 179 |
1539303 | 1539303 | 2021-07-21 | Ashtabula | Ohio | 39007 | 7258 | 179 |
1536056 | 1536056 | 2021-07-20 | Ashtabula | Ohio | 39007 | 7251 | 179 |
1532808 | 1532808 | 2021-07-19 | Ashtabula | Ohio | 39007 | 7245 | 179 |
1529561 | 1529561 | 2021-07-18 | Ashtabula | Ohio | 39007 | 7244 | 179 |
1526314 | 1526314 | 2021-07-17 | Ashtabula | Ohio | 39007 | 7239 | 179 |
1523067 | 1523067 | 2021-07-16 | Ashtabula | Ohio | 39007 | 7238 | 179 |
1519819 | 1519819 | 2021-07-15 | Ashtabula | Ohio | 39007 | 7234 | 179 |
1516571 | 1516571 | 2021-07-14 | Ashtabula | Ohio | 39007 | 7232 | 179 |
1513324 | 1513324 | 2021-07-13 | Ashtabula | Ohio | 39007 | 7231 | 179 |
1510078 | 1510078 | 2021-07-12 | Ashtabula | Ohio | 39007 | 7231 | 179 |
1506831 | 1506831 | 2021-07-11 | Ashtabula | Ohio | 39007 | 7230 | 179 |
1503585 | 1503585 | 2021-07-10 | Ashtabula | Ohio | 39007 | 7229 | 179 |
1500339 | 1500339 | 2021-07-09 | Ashtabula | Ohio | 39007 | 7229 | 179 |
1497093 | 1497093 | 2021-07-08 | Ashtabula | Ohio | 39007 | 7226 | 179 |
1493846 | 1493846 | 2021-07-07 | Ashtabula | Ohio | 39007 | 7220 | 179 |
1490599 | 1490599 | 2021-07-06 | Ashtabula | Ohio | 39007 | 7219 | 179 |
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);