ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1487373 | 1487373 | 2021-07-05 | Franklin | Ohio | 39049 | 129263 | 1487 |
1484126 | 1484126 | 2021-07-04 | Franklin | Ohio | 39049 | 129236 | 1487 |
1480880 | 1480880 | 2021-07-03 | Franklin | Ohio | 39049 | 129236 | 1487 |
1477633 | 1477633 | 2021-07-02 | Franklin | Ohio | 39049 | 129220 | 1487 |
1474387 | 1474387 | 2021-07-01 | Franklin | Ohio | 39049 | 129199 | 1482 |
1471141 | 1471141 | 2021-06-30 | Franklin | Ohio | 39049 | 129181 | 1482 |
1467896 | 1467896 | 2021-06-29 | Franklin | Ohio | 39049 | 129164 | 1482 |
1464651 | 1464651 | 2021-06-28 | Franklin | Ohio | 39049 | 129120 | 1478 |
1461406 | 1461406 | 2021-06-27 | Franklin | Ohio | 39049 | 129083 | 1478 |
1458161 | 1458161 | 2021-06-26 | Franklin | Ohio | 39049 | 129060 | 1478 |
1454916 | 1454916 | 2021-06-25 | Franklin | Ohio | 39049 | 129028 | 1478 |
1451671 | 1451671 | 2021-06-24 | Franklin | Ohio | 39049 | 129009 | 1469 |
1448425 | 1448425 | 2021-06-23 | Franklin | Ohio | 39049 | 128952 | 1469 |
1445180 | 1445180 | 2021-06-22 | Franklin | Ohio | 39049 | 128856 | 1469 |
1441935 | 1441935 | 2021-06-21 | Franklin | Ohio | 39049 | 128765 | 1467 |
1438690 | 1438690 | 2021-06-20 | Franklin | Ohio | 39049 | 128749 | 1467 |
1435443 | 1435443 | 2021-06-19 | Franklin | Ohio | 39049 | 128720 | 1467 |
1432196 | 1432196 | 2021-06-18 | Franklin | Ohio | 39049 | 128697 | 1467 |
1428950 | 1428950 | 2021-06-17 | Franklin | Ohio | 39049 | 128642 | 1460 |
1425705 | 1425705 | 2021-06-16 | Franklin | Ohio | 39049 | 128632 | 1460 |
1422458 | 1422458 | 2021-06-15 | Franklin | Ohio | 39049 | 128549 | 1460 |
1419212 | 1419212 | 2021-06-14 | Franklin | Ohio | 39049 | 128506 | 1459 |
1415967 | 1415967 | 2021-06-13 | Franklin | Ohio | 39049 | 128492 | 1459 |
1412721 | 1412721 | 2021-06-12 | Franklin | Ohio | 39049 | 128460 | 1459 |
1409476 | 1409476 | 2021-06-11 | Franklin | Ohio | 39049 | 128395 | 1459 |
1406231 | 1406231 | 2021-06-10 | Franklin | Ohio | 39049 | 128361 | 1451 |
1402985 | 1402985 | 2021-06-09 | Franklin | Ohio | 39049 | 128322 | 1451 |
1399740 | 1399740 | 2021-06-08 | Franklin | Ohio | 39049 | 128266 | 1451 |
1396495 | 1396495 | 2021-06-07 | Franklin | Ohio | 39049 | 128222 | 1450 |
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);