ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 39061 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812209 | 1812209 | 2021-10-13 | Hamilton | Ohio | 39061 | 103546 | 1388 |
1808960 | 1808960 | 2021-10-12 | Hamilton | Ohio | 39061 | 103275 | 1388 |
1805710 | 1805710 | 2021-10-11 | Hamilton | Ohio | 39061 | 103118 | 1379 |
1802460 | 1802460 | 2021-10-10 | Hamilton | Ohio | 39061 | 102982 | 1379 |
1799211 | 1799211 | 2021-10-09 | Hamilton | Ohio | 39061 | 102702 | 1379 |
1795962 | 1795962 | 2021-10-08 | Hamilton | Ohio | 39061 | 102541 | 1379 |
1792713 | 1792713 | 2021-10-07 | Hamilton | Ohio | 39061 | 102238 | 1359 |
1789464 | 1789464 | 2021-10-06 | Hamilton | Ohio | 39061 | 101908 | 1359 |
1786216 | 1786216 | 2021-10-05 | Hamilton | Ohio | 39061 | 101567 | 1359 |
1782967 | 1782967 | 2021-10-04 | Hamilton | Ohio | 39061 | 101339 | 1351 |
1779718 | 1779718 | 2021-10-03 | Hamilton | Ohio | 39061 | 101129 | 1351 |
1776468 | 1776468 | 2021-10-02 | Hamilton | Ohio | 39061 | 100935 | 1351 |
1773218 | 1773218 | 2021-10-01 | Hamilton | Ohio | 39061 | 100609 | 1351 |
1769968 | 1769968 | 2021-09-30 | Hamilton | Ohio | 39061 | 100303 | 1330 |
1766719 | 1766719 | 2021-09-29 | Hamilton | Ohio | 39061 | 99843 | 1330 |
1763470 | 1763470 | 2021-09-28 | Hamilton | Ohio | 39061 | 99498 | 1330 |
1760221 | 1760221 | 2021-09-27 | Hamilton | Ohio | 39061 | 99158 | 1326 |
1756973 | 1756973 | 2021-09-26 | Hamilton | Ohio | 39061 | 98969 | 1326 |
1753725 | 1753725 | 2021-09-25 | Hamilton | Ohio | 39061 | 98708 | 1326 |
1750477 | 1750477 | 2021-09-24 | Hamilton | Ohio | 39061 | 98404 | 1326 |
1747227 | 1747227 | 2021-09-23 | Hamilton | Ohio | 39061 | 97975 | 1320 |
1743978 | 1743978 | 2021-09-22 | Hamilton | Ohio | 39061 | 97605 | 1320 |
1740729 | 1740729 | 2021-09-21 | Hamilton | Ohio | 39061 | 97194 | 1320 |
1737480 | 1737480 | 2021-09-20 | Hamilton | Ohio | 39061 | 96791 | 1318 |
1734230 | 1734230 | 2021-09-19 | Hamilton | Ohio | 39061 | 96550 | 1318 |
1730980 | 1730980 | 2021-09-18 | Hamilton | Ohio | 39061 | 96279 | 1318 |
1727730 | 1727730 | 2021-09-17 | Hamilton | Ohio | 39061 | 95838 | 1318 |
1724481 | 1724481 | 2021-09-16 | Hamilton | Ohio | 39061 | 95329 | 1307 |
1721232 | 1721232 | 2021-09-15 | Hamilton | Ohio | 39061 | 94887 | 1307 |
1717984 | 1717984 | 2021-09-14 | Hamilton | Ohio | 39061 | 94500 | 1307 |
1714736 | 1714736 | 2021-09-13 | Hamilton | Ohio | 39061 | 94134 | 1305 |
1711490 | 1711490 | 2021-09-12 | Hamilton | Ohio | 39061 | 93837 | 1305 |
1708243 | 1708243 | 2021-09-11 | Hamilton | Ohio | 39061 | 93528 | 1305 |
1704996 | 1704996 | 2021-09-10 | Hamilton | Ohio | 39061 | 93002 | 1305 |
1701746 | 1701746 | 2021-09-09 | Hamilton | Ohio | 39061 | 92448 | 1296 |
1698497 | 1698497 | 2021-09-08 | Hamilton | Ohio | 39061 | 92016 | 1296 |
1695249 | 1695249 | 2021-09-07 | Hamilton | Ohio | 39061 | 91634 | 1296 |
1692001 | 1692001 | 2021-09-06 | Hamilton | Ohio | 39061 | 91384 | 1291 |
1688752 | 1688752 | 2021-09-05 | Hamilton | Ohio | 39061 | 91192 | 1291 |
1685502 | 1685502 | 2021-09-04 | Hamilton | Ohio | 39061 | 90700 | 1291 |
1682251 | 1682251 | 2021-09-03 | Hamilton | Ohio | 39061 | 90371 | 1291 |
1679001 | 1679001 | 2021-09-02 | Hamilton | Ohio | 39061 | 90007 | 1289 |
1675753 | 1675753 | 2021-09-01 | Hamilton | Ohio | 39061 | 89539 | 1289 |
1672506 | 1672506 | 2021-08-31 | Hamilton | Ohio | 39061 | 88832 | 1289 |
1669258 | 1669258 | 2021-08-30 | Hamilton | Ohio | 39061 | 88497 | 1283 |
1666011 | 1666011 | 2021-08-29 | Hamilton | Ohio | 39061 | 88367 | 1283 |
1662763 | 1662763 | 2021-08-28 | Hamilton | Ohio | 39061 | 88098 | 1283 |
1659515 | 1659515 | 2021-08-27 | Hamilton | Ohio | 39061 | 87812 | 1283 |
1656266 | 1656266 | 2021-08-26 | Hamilton | Ohio | 39061 | 87568 | 1278 |
1653019 | 1653019 | 2021-08-25 | Hamilton | Ohio | 39061 | 87253 | 1278 |
1649772 | 1649772 | 2021-08-24 | Hamilton | Ohio | 39061 | 86970 | 1278 |
1646523 | 1646523 | 2021-08-23 | Hamilton | Ohio | 39061 | 86757 | 1274 |
1643274 | 1643274 | 2021-08-22 | Hamilton | Ohio | 39061 | 86606 | 1274 |
1640024 | 1640024 | 2021-08-21 | Hamilton | Ohio | 39061 | 86478 | 1274 |
1636774 | 1636774 | 2021-08-20 | Hamilton | Ohio | 39061 | 86308 | 1274 |
1633524 | 1633524 | 2021-08-19 | Hamilton | Ohio | 39061 | 86051 | 1269 |
1630277 | 1630277 | 2021-08-18 | Hamilton | Ohio | 39061 | 85838 | 1269 |
1627030 | 1627030 | 2021-08-17 | Hamilton | Ohio | 39061 | 85607 | 1269 |
1623783 | 1623783 | 2021-08-16 | Hamilton | Ohio | 39061 | 85406 | 1266 |
1620536 | 1620536 | 2021-08-15 | Hamilton | Ohio | 39061 | 85220 | 1266 |
1617288 | 1617288 | 2021-08-14 | Hamilton | Ohio | 39061 | 85081 | 1266 |
1614040 | 1614040 | 2021-08-13 | Hamilton | Ohio | 39061 | 84929 | 1266 |
1610791 | 1610791 | 2021-08-12 | Hamilton | Ohio | 39061 | 84731 | 1266 |
1607543 | 1607543 | 2021-08-11 | Hamilton | Ohio | 39061 | 84456 | 1266 |
1604294 | 1604294 | 2021-08-10 | Hamilton | Ohio | 39061 | 84148 | 1266 |
1601045 | 1601045 | 2021-08-09 | Hamilton | Ohio | 39061 | 83974 | 1266 |
1597797 | 1597797 | 2021-08-08 | Hamilton | Ohio | 39061 | 83873 | 1266 |
1594548 | 1594548 | 2021-08-07 | Hamilton | Ohio | 39061 | 83745 | 1266 |
1591299 | 1591299 | 2021-08-06 | Hamilton | Ohio | 39061 | 83511 | 1266 |
1588050 | 1588050 | 2021-08-05 | Hamilton | Ohio | 39061 | 83390 | 1263 |
1584800 | 1584800 | 2021-08-04 | Hamilton | Ohio | 39061 | 83207 | 1263 |
1581550 | 1581550 | 2021-08-03 | Hamilton | Ohio | 39061 | 83023 | 1263 |
1578301 | 1578301 | 2021-08-02 | Hamilton | Ohio | 39061 | 82922 | 1261 |
1575053 | 1575053 | 2021-08-01 | Hamilton | Ohio | 39061 | 82870 | 1261 |
1571805 | 1571805 | 2021-07-31 | Hamilton | Ohio | 39061 | 82804 | 1261 |
1568557 | 1568557 | 2021-07-30 | Hamilton | Ohio | 39061 | 82697 | 1261 |
1565309 | 1565309 | 2021-07-29 | Hamilton | Ohio | 39061 | 82619 | 1261 |
1562061 | 1562061 | 2021-07-28 | Hamilton | Ohio | 39061 | 82548 | 1261 |
1558813 | 1558813 | 2021-07-27 | Hamilton | Ohio | 39061 | 82442 | 1261 |
1555566 | 1555566 | 2021-07-26 | Hamilton | Ohio | 39061 | 82348 | 1259 |
1552319 | 1552319 | 2021-07-25 | Hamilton | Ohio | 39061 | 82302 | 1259 |
1549072 | 1549072 | 2021-07-24 | Hamilton | Ohio | 39061 | 82261 | 1259 |
1545825 | 1545825 | 2021-07-23 | Hamilton | Ohio | 39061 | 82219 | 1259 |
1542578 | 1542578 | 2021-07-22 | Hamilton | Ohio | 39061 | 82139 | 1259 |
1539330 | 1539330 | 2021-07-21 | Hamilton | Ohio | 39061 | 82075 | 1259 |
1536083 | 1536083 | 2021-07-20 | Hamilton | Ohio | 39061 | 82000 | 1259 |
1532835 | 1532835 | 2021-07-19 | Hamilton | Ohio | 39061 | 81955 | 1259 |
1529588 | 1529588 | 2021-07-18 | Hamilton | Ohio | 39061 | 81926 | 1259 |
1526341 | 1526341 | 2021-07-17 | Hamilton | Ohio | 39061 | 81907 | 1259 |
1523094 | 1523094 | 2021-07-16 | Hamilton | Ohio | 39061 | 81861 | 1259 |
1519846 | 1519846 | 2021-07-15 | Hamilton | Ohio | 39061 | 81826 | 1257 |
1516598 | 1516598 | 2021-07-14 | Hamilton | Ohio | 39061 | 81796 | 1257 |
1513351 | 1513351 | 2021-07-13 | Hamilton | Ohio | 39061 | 81768 | 1257 |
1510105 | 1510105 | 2021-07-12 | Hamilton | Ohio | 39061 | 81743 | 1255 |
1506858 | 1506858 | 2021-07-11 | Hamilton | Ohio | 39061 | 81730 | 1255 |
1503612 | 1503612 | 2021-07-10 | Hamilton | Ohio | 39061 | 81709 | 1255 |
1500366 | 1500366 | 2021-07-09 | Hamilton | Ohio | 39061 | 81694 | 1255 |
1497120 | 1497120 | 2021-07-08 | Hamilton | Ohio | 39061 | 81633 | 1254 |
1493873 | 1493873 | 2021-07-07 | Hamilton | Ohio | 39061 | 81604 | 1254 |
1490626 | 1490626 | 2021-07-06 | Hamilton | Ohio | 39061 | 81588 | 1254 |
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);