ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 39113 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812235 | 1812235 | 2021-10-13 | Montgomery | Ohio | 39113 | 72337 | 1227 |
1808986 | 1808986 | 2021-10-12 | Montgomery | Ohio | 39113 | 72134 | 1227 |
1805736 | 1805736 | 2021-10-11 | Montgomery | Ohio | 39113 | 71950 | 1216 |
1802486 | 1802486 | 2021-10-10 | Montgomery | Ohio | 39113 | 71831 | 1216 |
1799237 | 1799237 | 2021-10-09 | Montgomery | Ohio | 39113 | 71558 | 1216 |
1795988 | 1795988 | 2021-10-08 | Montgomery | Ohio | 39113 | 71390 | 1216 |
1792739 | 1792739 | 2021-10-07 | Montgomery | Ohio | 39113 | 71060 | 1192 |
1789490 | 1789490 | 2021-10-06 | Montgomery | Ohio | 39113 | 70773 | 1192 |
1786242 | 1786242 | 2021-10-05 | Montgomery | Ohio | 39113 | 70478 | 1192 |
1782993 | 1782993 | 2021-10-04 | Montgomery | Ohio | 39113 | 70270 | 1183 |
1779744 | 1779744 | 2021-10-03 | Montgomery | Ohio | 39113 | 70025 | 1183 |
1776494 | 1776494 | 2021-10-02 | Montgomery | Ohio | 39113 | 69841 | 1183 |
1773244 | 1773244 | 2021-10-01 | Montgomery | Ohio | 39113 | 69545 | 1183 |
1769994 | 1769994 | 2021-09-30 | Montgomery | Ohio | 39113 | 69249 | 1166 |
1766745 | 1766745 | 2021-09-29 | Montgomery | Ohio | 39113 | 68880 | 1166 |
1763496 | 1763496 | 2021-09-28 | Montgomery | Ohio | 39113 | 68633 | 1166 |
1760247 | 1760247 | 2021-09-27 | Montgomery | Ohio | 39113 | 68268 | 1161 |
1756999 | 1756999 | 2021-09-26 | Montgomery | Ohio | 39113 | 68137 | 1161 |
1753751 | 1753751 | 2021-09-25 | Montgomery | Ohio | 39113 | 67967 | 1161 |
1750503 | 1750503 | 2021-09-24 | Montgomery | Ohio | 39113 | 67700 | 1161 |
1747253 | 1747253 | 2021-09-23 | Montgomery | Ohio | 39113 | 67439 | 1141 |
1744004 | 1744004 | 2021-09-22 | Montgomery | Ohio | 39113 | 67027 | 1141 |
1740755 | 1740755 | 2021-09-21 | Montgomery | Ohio | 39113 | 66795 | 1141 |
1737506 | 1737506 | 2021-09-20 | Montgomery | Ohio | 39113 | 66464 | 1136 |
1734256 | 1734256 | 2021-09-19 | Montgomery | Ohio | 39113 | 66195 | 1136 |
1731006 | 1731006 | 2021-09-18 | Montgomery | Ohio | 39113 | 65916 | 1136 |
1727756 | 1727756 | 2021-09-17 | Montgomery | Ohio | 39113 | 65559 | 1136 |
1724507 | 1724507 | 2021-09-16 | Montgomery | Ohio | 39113 | 65099 | 1122 |
1721258 | 1721258 | 2021-09-15 | Montgomery | Ohio | 39113 | 64745 | 1122 |
1718010 | 1718010 | 2021-09-14 | Montgomery | Ohio | 39113 | 64425 | 1122 |
1714762 | 1714762 | 2021-09-13 | Montgomery | Ohio | 39113 | 64121 | 1113 |
1711516 | 1711516 | 2021-09-12 | Montgomery | Ohio | 39113 | 63812 | 1113 |
1708269 | 1708269 | 2021-09-11 | Montgomery | Ohio | 39113 | 63589 | 1113 |
1705022 | 1705022 | 2021-09-10 | Montgomery | Ohio | 39113 | 63048 | 1113 |
1701772 | 1701772 | 2021-09-09 | Montgomery | Ohio | 39113 | 62503 | 1103 |
1698523 | 1698523 | 2021-09-08 | Montgomery | Ohio | 39113 | 62163 | 1103 |
1695275 | 1695275 | 2021-09-07 | Montgomery | Ohio | 39113 | 61830 | 1103 |
1692027 | 1692027 | 2021-09-06 | Montgomery | Ohio | 39113 | 61656 | 1097 |
1688778 | 1688778 | 2021-09-05 | Montgomery | Ohio | 39113 | 61449 | 1097 |
1685528 | 1685528 | 2021-09-04 | Montgomery | Ohio | 39113 | 61069 | 1097 |
1682277 | 1682277 | 2021-09-03 | Montgomery | Ohio | 39113 | 60667 | 1097 |
1679027 | 1679027 | 2021-09-02 | Montgomery | Ohio | 39113 | 60337 | 1084 |
1675779 | 1675779 | 2021-09-01 | Montgomery | Ohio | 39113 | 59923 | 1084 |
1672532 | 1672532 | 2021-08-31 | Montgomery | Ohio | 39113 | 59606 | 1084 |
1669284 | 1669284 | 2021-08-30 | Montgomery | Ohio | 39113 | 59231 | 1082 |
1666037 | 1666037 | 2021-08-29 | Montgomery | Ohio | 39113 | 59077 | 1082 |
1662789 | 1662789 | 2021-08-28 | Montgomery | Ohio | 39113 | 58864 | 1082 |
1659541 | 1659541 | 2021-08-27 | Montgomery | Ohio | 39113 | 58547 | 1082 |
1656292 | 1656292 | 2021-08-26 | Montgomery | Ohio | 39113 | 58238 | 1078 |
1653045 | 1653045 | 2021-08-25 | Montgomery | Ohio | 39113 | 57911 | 1078 |
1649798 | 1649798 | 2021-08-24 | Montgomery | Ohio | 39113 | 57637 | 1078 |
1646549 | 1646549 | 2021-08-23 | Montgomery | Ohio | 39113 | 57423 | 1077 |
1643300 | 1643300 | 2021-08-22 | Montgomery | Ohio | 39113 | 57212 | 1077 |
1640050 | 1640050 | 2021-08-21 | Montgomery | Ohio | 39113 | 57100 | 1077 |
1636800 | 1636800 | 2021-08-20 | Montgomery | Ohio | 39113 | 56908 | 1077 |
1633550 | 1633550 | 2021-08-19 | Montgomery | Ohio | 39113 | 56699 | 1074 |
1630303 | 1630303 | 2021-08-18 | Montgomery | Ohio | 39113 | 56490 | 1074 |
1627056 | 1627056 | 2021-08-17 | Montgomery | Ohio | 39113 | 56277 | 1074 |
1623809 | 1623809 | 2021-08-16 | Montgomery | Ohio | 39113 | 56095 | 1071 |
1620562 | 1620562 | 2021-08-15 | Montgomery | Ohio | 39113 | 56037 | 1071 |
1617314 | 1617314 | 2021-08-14 | Montgomery | Ohio | 39113 | 55856 | 1071 |
1614066 | 1614066 | 2021-08-13 | Montgomery | Ohio | 39113 | 55667 | 1071 |
1610817 | 1610817 | 2021-08-12 | Montgomery | Ohio | 39113 | 55494 | 1065 |
1607569 | 1607569 | 2021-08-11 | Montgomery | Ohio | 39113 | 55309 | 1065 |
1604320 | 1604320 | 2021-08-10 | Montgomery | Ohio | 39113 | 55047 | 1065 |
1601071 | 1601071 | 2021-08-09 | Montgomery | Ohio | 39113 | 54899 | 1065 |
1597823 | 1597823 | 2021-08-08 | Montgomery | Ohio | 39113 | 54843 | 1065 |
1594574 | 1594574 | 2021-08-07 | Montgomery | Ohio | 39113 | 54725 | 1065 |
1591325 | 1591325 | 2021-08-06 | Montgomery | Ohio | 39113 | 54519 | 1065 |
1588076 | 1588076 | 2021-08-05 | Montgomery | Ohio | 39113 | 54423 | 1064 |
1584826 | 1584826 | 2021-08-04 | Montgomery | Ohio | 39113 | 54301 | 1064 |
1581576 | 1581576 | 2021-08-03 | Montgomery | Ohio | 39113 | 54190 | 1064 |
1578327 | 1578327 | 2021-08-02 | Montgomery | Ohio | 39113 | 54055 | 1062 |
1575079 | 1575079 | 2021-08-01 | Montgomery | Ohio | 39113 | 53995 | 1062 |
1571831 | 1571831 | 2021-07-31 | Montgomery | Ohio | 39113 | 53918 | 1062 |
1568583 | 1568583 | 2021-07-30 | Montgomery | Ohio | 39113 | 53804 | 1062 |
1565335 | 1565335 | 2021-07-29 | Montgomery | Ohio | 39113 | 53732 | 1062 |
1562087 | 1562087 | 2021-07-28 | Montgomery | Ohio | 39113 | 53658 | 1062 |
1558839 | 1558839 | 2021-07-27 | Montgomery | Ohio | 39113 | 53542 | 1062 |
1555592 | 1555592 | 2021-07-26 | Montgomery | Ohio | 39113 | 53449 | 1059 |
1552345 | 1552345 | 2021-07-25 | Montgomery | Ohio | 39113 | 53422 | 1059 |
1549098 | 1549098 | 2021-07-24 | Montgomery | Ohio | 39113 | 53372 | 1059 |
1545851 | 1545851 | 2021-07-23 | Montgomery | Ohio | 39113 | 53335 | 1059 |
1542604 | 1542604 | 2021-07-22 | Montgomery | Ohio | 39113 | 53254 | 1060 |
1539356 | 1539356 | 2021-07-21 | Montgomery | Ohio | 39113 | 53200 | 1060 |
1536109 | 1536109 | 2021-07-20 | Montgomery | Ohio | 39113 | 53135 | 1060 |
1532861 | 1532861 | 2021-07-19 | Montgomery | Ohio | 39113 | 53090 | 1059 |
1529614 | 1529614 | 2021-07-18 | Montgomery | Ohio | 39113 | 53048 | 1059 |
1526367 | 1526367 | 2021-07-17 | Montgomery | Ohio | 39113 | 53009 | 1059 |
1523120 | 1523120 | 2021-07-16 | Montgomery | Ohio | 39113 | 52965 | 1059 |
1519872 | 1519872 | 2021-07-15 | Montgomery | Ohio | 39113 | 52929 | 1059 |
1516624 | 1516624 | 2021-07-14 | Montgomery | Ohio | 39113 | 52888 | 1059 |
1513377 | 1513377 | 2021-07-13 | Montgomery | Ohio | 39113 | 52860 | 1059 |
1510131 | 1510131 | 2021-07-12 | Montgomery | Ohio | 39113 | 52831 | 1058 |
1506884 | 1506884 | 2021-07-11 | Montgomery | Ohio | 39113 | 52819 | 1058 |
1503638 | 1503638 | 2021-07-10 | Montgomery | Ohio | 39113 | 52793 | 1058 |
1500392 | 1500392 | 2021-07-09 | Montgomery | Ohio | 39113 | 52748 | 1058 |
1497146 | 1497146 | 2021-07-08 | Montgomery | Ohio | 39113 | 52735 | 1056 |
1493899 | 1493899 | 2021-07-07 | Montgomery | Ohio | 39113 | 52713 | 1056 |
1490652 | 1490652 | 2021-07-06 | Montgomery | Ohio | 39113 | 52706 | 1056 |
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);