ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 39139 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812248 | 1812248 | 2021-10-13 | Richland | Ohio | 39139 | 18089 | 270 |
1808999 | 1808999 | 2021-10-12 | Richland | Ohio | 39139 | 17999 | 270 |
1805749 | 1805749 | 2021-10-11 | Richland | Ohio | 39139 | 17931 | 265 |
1802499 | 1802499 | 2021-10-10 | Richland | Ohio | 39139 | 17883 | 265 |
1799250 | 1799250 | 2021-10-09 | Richland | Ohio | 39139 | 17829 | 265 |
1796001 | 1796001 | 2021-10-08 | Richland | Ohio | 39139 | 17767 | 265 |
1792752 | 1792752 | 2021-10-07 | Richland | Ohio | 39139 | 17684 | 255 |
1789503 | 1789503 | 2021-10-06 | Richland | Ohio | 39139 | 17586 | 255 |
1786255 | 1786255 | 2021-10-05 | Richland | Ohio | 39139 | 17489 | 255 |
1783006 | 1783006 | 2021-10-04 | Richland | Ohio | 39139 | 17394 | 252 |
1779757 | 1779757 | 2021-10-03 | Richland | Ohio | 39139 | 17306 | 252 |
1776507 | 1776507 | 2021-10-02 | Richland | Ohio | 39139 | 17276 | 252 |
1773257 | 1773257 | 2021-10-01 | Richland | Ohio | 39139 | 17220 | 252 |
1770007 | 1770007 | 2021-09-30 | Richland | Ohio | 39139 | 17115 | 240 |
1766758 | 1766758 | 2021-09-29 | Richland | Ohio | 39139 | 17044 | 240 |
1763509 | 1763509 | 2021-09-28 | Richland | Ohio | 39139 | 16924 | 240 |
1760260 | 1760260 | 2021-09-27 | Richland | Ohio | 39139 | 16793 | 236 |
1757012 | 1757012 | 2021-09-26 | Richland | Ohio | 39139 | 16749 | 236 |
1753764 | 1753764 | 2021-09-25 | Richland | Ohio | 39139 | 16680 | 236 |
1750516 | 1750516 | 2021-09-24 | Richland | Ohio | 39139 | 16602 | 236 |
1747266 | 1747266 | 2021-09-23 | Richland | Ohio | 39139 | 16428 | 234 |
1744017 | 1744017 | 2021-09-22 | Richland | Ohio | 39139 | 16314 | 234 |
1740768 | 1740768 | 2021-09-21 | Richland | Ohio | 39139 | 16226 | 234 |
1737519 | 1737519 | 2021-09-20 | Richland | Ohio | 39139 | 16141 | 231 |
1734269 | 1734269 | 2021-09-19 | Richland | Ohio | 39139 | 16024 | 231 |
1731019 | 1731019 | 2021-09-18 | Richland | Ohio | 39139 | 15949 | 231 |
1727769 | 1727769 | 2021-09-17 | Richland | Ohio | 39139 | 15873 | 231 |
1724520 | 1724520 | 2021-09-16 | Richland | Ohio | 39139 | 15700 | 228 |
1721271 | 1721271 | 2021-09-15 | Richland | Ohio | 39139 | 15540 | 228 |
1718023 | 1718023 | 2021-09-14 | Richland | Ohio | 39139 | 15409 | 228 |
1714775 | 1714775 | 2021-09-13 | Richland | Ohio | 39139 | 15280 | 226 |
1711529 | 1711529 | 2021-09-12 | Richland | Ohio | 39139 | 15146 | 226 |
1708282 | 1708282 | 2021-09-11 | Richland | Ohio | 39139 | 15071 | 226 |
1705035 | 1705035 | 2021-09-10 | Richland | Ohio | 39139 | 14911 | 226 |
1701785 | 1701785 | 2021-09-09 | Richland | Ohio | 39139 | 14741 | 225 |
1698536 | 1698536 | 2021-09-08 | Richland | Ohio | 39139 | 14573 | 225 |
1695288 | 1695288 | 2021-09-07 | Richland | Ohio | 39139 | 14400 | 225 |
1692040 | 1692040 | 2021-09-06 | Richland | Ohio | 39139 | 14280 | 221 |
1688791 | 1688791 | 2021-09-05 | Richland | Ohio | 39139 | 14220 | 221 |
1685541 | 1685541 | 2021-09-04 | Richland | Ohio | 39139 | 14123 | 221 |
1682290 | 1682290 | 2021-09-03 | Richland | Ohio | 39139 | 13993 | 221 |
1679040 | 1679040 | 2021-09-02 | Richland | Ohio | 39139 | 13864 | 219 |
1675792 | 1675792 | 2021-09-01 | Richland | Ohio | 39139 | 13696 | 219 |
1672545 | 1672545 | 2021-08-31 | Richland | Ohio | 39139 | 13557 | 219 |
1669297 | 1669297 | 2021-08-30 | Richland | Ohio | 39139 | 13422 | 218 |
1666050 | 1666050 | 2021-08-29 | Richland | Ohio | 39139 | 13372 | 218 |
1662802 | 1662802 | 2021-08-28 | Richland | Ohio | 39139 | 13258 | 218 |
1659554 | 1659554 | 2021-08-27 | Richland | Ohio | 39139 | 13163 | 218 |
1656305 | 1656305 | 2021-08-26 | Richland | Ohio | 39139 | 13047 | 216 |
1653058 | 1653058 | 2021-08-25 | Richland | Ohio | 39139 | 12982 | 216 |
1649811 | 1649811 | 2021-08-24 | Richland | Ohio | 39139 | 12887 | 216 |
1646562 | 1646562 | 2021-08-23 | Richland | Ohio | 39139 | 12810 | 215 |
1643313 | 1643313 | 2021-08-22 | Richland | Ohio | 39139 | 12758 | 215 |
1640063 | 1640063 | 2021-08-21 | Richland | Ohio | 39139 | 12696 | 215 |
1636813 | 1636813 | 2021-08-20 | Richland | Ohio | 39139 | 12630 | 215 |
1633563 | 1633563 | 2021-08-19 | Richland | Ohio | 39139 | 12574 | 214 |
1630316 | 1630316 | 2021-08-18 | Richland | Ohio | 39139 | 12487 | 214 |
1627069 | 1627069 | 2021-08-17 | Richland | Ohio | 39139 | 12423 | 214 |
1623822 | 1623822 | 2021-08-16 | Richland | Ohio | 39139 | 12373 | 214 |
1620575 | 1620575 | 2021-08-15 | Richland | Ohio | 39139 | 12329 | 214 |
1617327 | 1617327 | 2021-08-14 | Richland | Ohio | 39139 | 12283 | 214 |
1614079 | 1614079 | 2021-08-13 | Richland | Ohio | 39139 | 12245 | 214 |
1610830 | 1610830 | 2021-08-12 | Richland | Ohio | 39139 | 12194 | 214 |
1607582 | 1607582 | 2021-08-11 | Richland | Ohio | 39139 | 12129 | 214 |
1604333 | 1604333 | 2021-08-10 | Richland | Ohio | 39139 | 12078 | 214 |
1601084 | 1601084 | 2021-08-09 | Richland | Ohio | 39139 | 12051 | 214 |
1597836 | 1597836 | 2021-08-08 | Richland | Ohio | 39139 | 12038 | 214 |
1594587 | 1594587 | 2021-08-07 | Richland | Ohio | 39139 | 12004 | 214 |
1591338 | 1591338 | 2021-08-06 | Richland | Ohio | 39139 | 11979 | 214 |
1588089 | 1588089 | 2021-08-05 | Richland | Ohio | 39139 | 11949 | 214 |
1584839 | 1584839 | 2021-08-04 | Richland | Ohio | 39139 | 11919 | 214 |
1581589 | 1581589 | 2021-08-03 | Richland | Ohio | 39139 | 11870 | 214 |
1578340 | 1578340 | 2021-08-02 | Richland | Ohio | 39139 | 11845 | 214 |
1575092 | 1575092 | 2021-08-01 | Richland | Ohio | 39139 | 11826 | 214 |
1571844 | 1571844 | 2021-07-31 | Richland | Ohio | 39139 | 11807 | 214 |
1568596 | 1568596 | 2021-07-30 | Richland | Ohio | 39139 | 11785 | 214 |
1565348 | 1565348 | 2021-07-29 | Richland | Ohio | 39139 | 11764 | 213 |
1562100 | 1562100 | 2021-07-28 | Richland | Ohio | 39139 | 11748 | 213 |
1558852 | 1558852 | 2021-07-27 | Richland | Ohio | 39139 | 11740 | 213 |
1555605 | 1555605 | 2021-07-26 | Richland | Ohio | 39139 | 11726 | 213 |
1552358 | 1552358 | 2021-07-25 | Richland | Ohio | 39139 | 11722 | 213 |
1549111 | 1549111 | 2021-07-24 | Richland | Ohio | 39139 | 11719 | 213 |
1545864 | 1545864 | 2021-07-23 | Richland | Ohio | 39139 | 11707 | 213 |
1542617 | 1542617 | 2021-07-22 | Richland | Ohio | 39139 | 11701 | 213 |
1539369 | 1539369 | 2021-07-21 | Richland | Ohio | 39139 | 11685 | 213 |
1536122 | 1536122 | 2021-07-20 | Richland | Ohio | 39139 | 11678 | 213 |
1532874 | 1532874 | 2021-07-19 | Richland | Ohio | 39139 | 11672 | 213 |
1529627 | 1529627 | 2021-07-18 | Richland | Ohio | 39139 | 11668 | 213 |
1526380 | 1526380 | 2021-07-17 | Richland | Ohio | 39139 | 11665 | 213 |
1523133 | 1523133 | 2021-07-16 | Richland | Ohio | 39139 | 11659 | 213 |
1519885 | 1519885 | 2021-07-15 | Richland | Ohio | 39139 | 11656 | 213 |
1516637 | 1516637 | 2021-07-14 | Richland | Ohio | 39139 | 11653 | 213 |
1513390 | 1513390 | 2021-07-13 | Richland | Ohio | 39139 | 11649 | 213 |
1510144 | 1510144 | 2021-07-12 | Richland | Ohio | 39139 | 11649 | 213 |
1506897 | 1506897 | 2021-07-11 | Richland | Ohio | 39139 | 11647 | 213 |
1503651 | 1503651 | 2021-07-10 | Richland | Ohio | 39139 | 11644 | 213 |
1500405 | 1500405 | 2021-07-09 | Richland | Ohio | 39139 | 11642 | 213 |
1497159 | 1497159 | 2021-07-08 | Richland | Ohio | 39139 | 11638 | 212 |
1493912 | 1493912 | 2021-07-07 | Richland | Ohio | 39139 | 11633 | 212 |
1490665 | 1490665 | 2021-07-06 | Richland | Ohio | 39139 | 11633 | 211 |
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);