ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39049 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812203 | 1812203 | 2021-10-13 | Franklin | Ohio | 39049 | 161300 | 1643 |
1808954 | 1808954 | 2021-10-12 | Franklin | Ohio | 39049 | 160901 | 1643 |
1805704 | 1805704 | 2021-10-11 | Franklin | Ohio | 39049 | 160553 | 1640 |
1802454 | 1802454 | 2021-10-10 | Franklin | Ohio | 39049 | 160316 | 1640 |
1799205 | 1799205 | 2021-10-09 | Franklin | Ohio | 39049 | 159913 | 1640 |
1795956 | 1795956 | 2021-10-08 | Franklin | Ohio | 39049 | 159683 | 1640 |
1792707 | 1792707 | 2021-10-07 | Franklin | Ohio | 39049 | 159040 | 1611 |
1789458 | 1789458 | 2021-10-06 | Franklin | Ohio | 39049 | 158547 | 1611 |
1786210 | 1786210 | 2021-10-05 | Franklin | Ohio | 39049 | 158084 | 1611 |
1782961 | 1782961 | 2021-10-04 | Franklin | Ohio | 39049 | 157634 | 1602 |
1779712 | 1779712 | 2021-10-03 | Franklin | Ohio | 39049 | 157296 | 1602 |
1776462 | 1776462 | 2021-10-02 | Franklin | Ohio | 39049 | 157071 | 1602 |
1773212 | 1773212 | 2021-10-01 | Franklin | Ohio | 39049 | 156600 | 1602 |
1769962 | 1769962 | 2021-09-30 | Franklin | Ohio | 39049 | 156085 | 1578 |
1766713 | 1766713 | 2021-09-29 | Franklin | Ohio | 39049 | 155603 | 1578 |
1763464 | 1763464 | 2021-09-28 | Franklin | Ohio | 39049 | 155063 | 1578 |
1760215 | 1760215 | 2021-09-27 | Franklin | Ohio | 39049 | 154453 | 1574 |
1756967 | 1756967 | 2021-09-26 | Franklin | Ohio | 39049 | 154178 | 1574 |
1753719 | 1753719 | 2021-09-25 | Franklin | Ohio | 39049 | 153888 | 1574 |
1750471 | 1750471 | 2021-09-24 | Franklin | Ohio | 39049 | 153446 | 1574 |
1747221 | 1747221 | 2021-09-23 | Franklin | Ohio | 39049 | 152782 | 1560 |
1743972 | 1743972 | 2021-09-22 | Franklin | Ohio | 39049 | 152222 | 1560 |
1740723 | 1740723 | 2021-09-21 | Franklin | Ohio | 39049 | 151577 | 1560 |
1737474 | 1737474 | 2021-09-20 | Franklin | Ohio | 39049 | 151037 | 1556 |
1734224 | 1734224 | 2021-09-19 | Franklin | Ohio | 39049 | 150587 | 1556 |
1730974 | 1730974 | 2021-09-18 | Franklin | Ohio | 39049 | 150219 | 1556 |
1727724 | 1727724 | 2021-09-17 | Franklin | Ohio | 39049 | 149655 | 1556 |
1724475 | 1724475 | 2021-09-16 | Franklin | Ohio | 39049 | 148873 | 1537 |
1721226 | 1721226 | 2021-09-15 | Franklin | Ohio | 39049 | 148064 | 1537 |
1717978 | 1717978 | 2021-09-14 | Franklin | Ohio | 39049 | 147419 | 1537 |
1714730 | 1714730 | 2021-09-13 | Franklin | Ohio | 39049 | 146809 | 1533 |
1711484 | 1711484 | 2021-09-12 | Franklin | Ohio | 39049 | 146227 | 1533 |
1708237 | 1708237 | 2021-09-11 | Franklin | Ohio | 39049 | 145898 | 1533 |
1704990 | 1704990 | 2021-09-10 | Franklin | Ohio | 39049 | 145214 | 1533 |
1701740 | 1701740 | 2021-09-09 | Franklin | Ohio | 39049 | 144545 | 1524 |
1698491 | 1698491 | 2021-09-08 | Franklin | Ohio | 39049 | 143797 | 1524 |
1695243 | 1695243 | 2021-09-07 | Franklin | Ohio | 39049 | 143212 | 1524 |
1691995 | 1691995 | 2021-09-06 | Franklin | Ohio | 39049 | 142864 | 1519 |
1688746 | 1688746 | 2021-09-05 | Franklin | Ohio | 39049 | 142532 | 1519 |
1685496 | 1685496 | 2021-09-04 | Franklin | Ohio | 39049 | 142106 | 1519 |
1682245 | 1682245 | 2021-09-03 | Franklin | Ohio | 39049 | 141582 | 1519 |
1678995 | 1678995 | 2021-09-02 | Franklin | Ohio | 39049 | 140970 | 1516 |
1675747 | 1675747 | 2021-09-01 | Franklin | Ohio | 39049 | 140370 | 1516 |
1672500 | 1672500 | 2021-08-31 | Franklin | Ohio | 39049 | 139758 | 1516 |
1669252 | 1669252 | 2021-08-30 | Franklin | Ohio | 39049 | 139178 | 1512 |
1666005 | 1666005 | 2021-08-29 | Franklin | Ohio | 39049 | 138918 | 1512 |
1662757 | 1662757 | 2021-08-28 | Franklin | Ohio | 39049 | 138592 | 1512 |
1659509 | 1659509 | 2021-08-27 | Franklin | Ohio | 39049 | 138155 | 1512 |
1656260 | 1656260 | 2021-08-26 | Franklin | Ohio | 39049 | 137735 | 1508 |
1653013 | 1653013 | 2021-08-25 | Franklin | Ohio | 39049 | 137270 | 1508 |
1649766 | 1649766 | 2021-08-24 | Franklin | Ohio | 39049 | 136889 | 1508 |
1646517 | 1646517 | 2021-08-23 | Franklin | Ohio | 39049 | 136460 | 1507 |
1643268 | 1643268 | 2021-08-22 | Franklin | Ohio | 39049 | 136182 | 1507 |
1640018 | 1640018 | 2021-08-21 | Franklin | Ohio | 39049 | 135974 | 1507 |
1636768 | 1636768 | 2021-08-20 | Franklin | Ohio | 39049 | 135666 | 1507 |
1633518 | 1633518 | 2021-08-19 | Franklin | Ohio | 39049 | 135287 | 1504 |
1630271 | 1630271 | 2021-08-18 | Franklin | Ohio | 39049 | 135007 | 1504 |
1627024 | 1627024 | 2021-08-17 | Franklin | Ohio | 39049 | 134700 | 1504 |
1623777 | 1623777 | 2021-08-16 | Franklin | Ohio | 39049 | 134342 | 1502 |
1620530 | 1620530 | 2021-08-15 | Franklin | Ohio | 39049 | 134177 | 1502 |
1617282 | 1617282 | 2021-08-14 | Franklin | Ohio | 39049 | 133970 | 1502 |
1614034 | 1614034 | 2021-08-13 | Franklin | Ohio | 39049 | 133749 | 1502 |
1610785 | 1610785 | 2021-08-12 | Franklin | Ohio | 39049 | 133426 | 1500 |
1607537 | 1607537 | 2021-08-11 | Franklin | Ohio | 39049 | 133083 | 1500 |
1604288 | 1604288 | 2021-08-10 | Franklin | Ohio | 39049 | 132759 | 1500 |
1601039 | 1601039 | 2021-08-09 | Franklin | Ohio | 39049 | 132478 | 1499 |
1597791 | 1597791 | 2021-08-08 | Franklin | Ohio | 39049 | 132355 | 1499 |
1594542 | 1594542 | 2021-08-07 | Franklin | Ohio | 39049 | 132188 | 1499 |
1591293 | 1591293 | 2021-08-06 | Franklin | Ohio | 39049 | 131951 | 1499 |
1588044 | 1588044 | 2021-08-05 | Franklin | Ohio | 39049 | 131733 | 1496 |
1584794 | 1584794 | 2021-08-04 | Franklin | Ohio | 39049 | 131537 | 1496 |
1581544 | 1581544 | 2021-08-03 | Franklin | Ohio | 39049 | 131291 | 1496 |
1578295 | 1578295 | 2021-08-02 | Franklin | Ohio | 39049 | 131111 | 1493 |
1575047 | 1575047 | 2021-08-01 | Franklin | Ohio | 39049 | 131036 | 1493 |
1571799 | 1571799 | 2021-07-31 | Franklin | Ohio | 39049 | 130973 | 1493 |
1568551 | 1568551 | 2021-07-30 | Franklin | Ohio | 39049 | 130816 | 1493 |
1565303 | 1565303 | 2021-07-29 | Franklin | Ohio | 39049 | 130709 | 1493 |
1562055 | 1562055 | 2021-07-28 | Franklin | Ohio | 39049 | 130563 | 1493 |
1558807 | 1558807 | 2021-07-27 | Franklin | Ohio | 39049 | 130433 | 1493 |
1555560 | 1555560 | 2021-07-26 | Franklin | Ohio | 39049 | 130291 | 1493 |
1552313 | 1552313 | 2021-07-25 | Franklin | Ohio | 39049 | 130214 | 1493 |
1549066 | 1549066 | 2021-07-24 | Franklin | Ohio | 39049 | 130169 | 1493 |
1545819 | 1545819 | 2021-07-23 | Franklin | Ohio | 39049 | 130071 | 1493 |
1542572 | 1542572 | 2021-07-22 | Franklin | Ohio | 39049 | 129993 | 1492 |
1539324 | 1539324 | 2021-07-21 | Franklin | Ohio | 39049 | 129900 | 1492 |
1536077 | 1536077 | 2021-07-20 | Franklin | Ohio | 39049 | 129828 | 1492 |
1532829 | 1532829 | 2021-07-19 | Franklin | Ohio | 39049 | 129764 | 1491 |
1529582 | 1529582 | 2021-07-18 | Franklin | Ohio | 39049 | 129725 | 1491 |
1526335 | 1526335 | 2021-07-17 | Franklin | Ohio | 39049 | 129696 | 1491 |
1523088 | 1523088 | 2021-07-16 | Franklin | Ohio | 39049 | 129657 | 1491 |
1519840 | 1519840 | 2021-07-15 | Franklin | Ohio | 39049 | 129600 | 1487 |
1516592 | 1516592 | 2021-07-14 | Franklin | Ohio | 39049 | 129531 | 1487 |
1513345 | 1513345 | 2021-07-13 | Franklin | Ohio | 39049 | 129489 | 1487 |
1510099 | 1510099 | 2021-07-12 | Franklin | Ohio | 39049 | 129463 | 1487 |
1506852 | 1506852 | 2021-07-11 | Franklin | Ohio | 39049 | 129439 | 1487 |
1503606 | 1503606 | 2021-07-10 | Franklin | Ohio | 39049 | 129420 | 1487 |
1500360 | 1500360 | 2021-07-09 | Franklin | Ohio | 39049 | 129383 | 1487 |
1497114 | 1497114 | 2021-07-08 | Franklin | Ohio | 39049 | 129352 | 1487 |
1493867 | 1493867 | 2021-07-07 | Franklin | Ohio | 39049 | 129322 | 1487 |
1490620 | 1490620 | 2021-07-06 | Franklin | Ohio | 39049 | 129289 | 1487 |
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);