ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39041 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812199 | 1812199 | 2021-10-13 | Delaware | Ohio | 39041 | 23771 | 160 |
1808950 | 1808950 | 2021-10-12 | Delaware | Ohio | 39041 | 23721 | 160 |
1805700 | 1805700 | 2021-10-11 | Delaware | Ohio | 39041 | 23689 | 156 |
1802450 | 1802450 | 2021-10-10 | Delaware | Ohio | 39041 | 23654 | 156 |
1799201 | 1799201 | 2021-10-09 | Delaware | Ohio | 39041 | 23609 | 156 |
1795952 | 1795952 | 2021-10-08 | Delaware | Ohio | 39041 | 23578 | 156 |
1792703 | 1792703 | 2021-10-07 | Delaware | Ohio | 39041 | 23397 | 154 |
1789454 | 1789454 | 2021-10-06 | Delaware | Ohio | 39041 | 23305 | 154 |
1786206 | 1786206 | 2021-10-05 | Delaware | Ohio | 39041 | 23238 | 154 |
1782957 | 1782957 | 2021-10-04 | Delaware | Ohio | 39041 | 23156 | 150 |
1779708 | 1779708 | 2021-10-03 | Delaware | Ohio | 39041 | 23105 | 150 |
1776458 | 1776458 | 2021-10-02 | Delaware | Ohio | 39041 | 23059 | 150 |
1773208 | 1773208 | 2021-10-01 | Delaware | Ohio | 39041 | 22997 | 150 |
1769958 | 1769958 | 2021-09-30 | Delaware | Ohio | 39041 | 22903 | 147 |
1766709 | 1766709 | 2021-09-29 | Delaware | Ohio | 39041 | 22829 | 147 |
1763460 | 1763460 | 2021-09-28 | Delaware | Ohio | 39041 | 22766 | 147 |
1760211 | 1760211 | 2021-09-27 | Delaware | Ohio | 39041 | 22656 | 147 |
1756963 | 1756963 | 2021-09-26 | Delaware | Ohio | 39041 | 22600 | 147 |
1753715 | 1753715 | 2021-09-25 | Delaware | Ohio | 39041 | 22566 | 147 |
1750467 | 1750467 | 2021-09-24 | Delaware | Ohio | 39041 | 22501 | 147 |
1747217 | 1747217 | 2021-09-23 | Delaware | Ohio | 39041 | 22415 | 145 |
1743968 | 1743968 | 2021-09-22 | Delaware | Ohio | 39041 | 22313 | 145 |
1740719 | 1740719 | 2021-09-21 | Delaware | Ohio | 39041 | 22222 | 145 |
1737470 | 1737470 | 2021-09-20 | Delaware | Ohio | 39041 | 22123 | 143 |
1734220 | 1734220 | 2021-09-19 | Delaware | Ohio | 39041 | 22066 | 143 |
1730970 | 1730970 | 2021-09-18 | Delaware | Ohio | 39041 | 22014 | 143 |
1727720 | 1727720 | 2021-09-17 | Delaware | Ohio | 39041 | 21949 | 143 |
1724471 | 1724471 | 2021-09-16 | Delaware | Ohio | 39041 | 21839 | 140 |
1721222 | 1721222 | 2021-09-15 | Delaware | Ohio | 39041 | 21722 | 140 |
1717974 | 1717974 | 2021-09-14 | Delaware | Ohio | 39041 | 21635 | 140 |
1714726 | 1714726 | 2021-09-13 | Delaware | Ohio | 39041 | 21522 | 140 |
1711480 | 1711480 | 2021-09-12 | Delaware | Ohio | 39041 | 21458 | 140 |
1708233 | 1708233 | 2021-09-11 | Delaware | Ohio | 39041 | 21424 | 140 |
1704986 | 1704986 | 2021-09-10 | Delaware | Ohio | 39041 | 21314 | 140 |
1701736 | 1701736 | 2021-09-09 | Delaware | Ohio | 39041 | 21193 | 140 |
1698487 | 1698487 | 2021-09-08 | Delaware | Ohio | 39041 | 21101 | 140 |
1695239 | 1695239 | 2021-09-07 | Delaware | Ohio | 39041 | 21004 | 140 |
1691991 | 1691991 | 2021-09-06 | Delaware | Ohio | 39041 | 20963 | 140 |
1688742 | 1688742 | 2021-09-05 | Delaware | Ohio | 39041 | 20917 | 140 |
1685492 | 1685492 | 2021-09-04 | Delaware | Ohio | 39041 | 20872 | 140 |
1682241 | 1682241 | 2021-09-03 | Delaware | Ohio | 39041 | 20805 | 140 |
1678991 | 1678991 | 2021-09-02 | Delaware | Ohio | 39041 | 20710 | 140 |
1675743 | 1675743 | 2021-09-01 | Delaware | Ohio | 39041 | 20603 | 140 |
1672496 | 1672496 | 2021-08-31 | Delaware | Ohio | 39041 | 20505 | 140 |
1669248 | 1669248 | 2021-08-30 | Delaware | Ohio | 39041 | 20416 | 139 |
1666001 | 1666001 | 2021-08-29 | Delaware | Ohio | 39041 | 20388 | 139 |
1662753 | 1662753 | 2021-08-28 | Delaware | Ohio | 39041 | 20349 | 139 |
1659505 | 1659505 | 2021-08-27 | Delaware | Ohio | 39041 | 20285 | 139 |
1656256 | 1656256 | 2021-08-26 | Delaware | Ohio | 39041 | 20212 | 138 |
1653009 | 1653009 | 2021-08-25 | Delaware | Ohio | 39041 | 20149 | 138 |
1649762 | 1649762 | 2021-08-24 | Delaware | Ohio | 39041 | 20088 | 138 |
1646513 | 1646513 | 2021-08-23 | Delaware | Ohio | 39041 | 20038 | 138 |
1643264 | 1643264 | 2021-08-22 | Delaware | Ohio | 39041 | 19993 | 138 |
1640014 | 1640014 | 2021-08-21 | Delaware | Ohio | 39041 | 19971 | 138 |
1636764 | 1636764 | 2021-08-20 | Delaware | Ohio | 39041 | 19929 | 138 |
1633514 | 1633514 | 2021-08-19 | Delaware | Ohio | 39041 | 19873 | 138 |
1630267 | 1630267 | 2021-08-18 | Delaware | Ohio | 39041 | 19821 | 138 |
1627020 | 1627020 | 2021-08-17 | Delaware | Ohio | 39041 | 19764 | 138 |
1623773 | 1623773 | 2021-08-16 | Delaware | Ohio | 39041 | 19716 | 138 |
1620526 | 1620526 | 2021-08-15 | Delaware | Ohio | 39041 | 19686 | 138 |
1617278 | 1617278 | 2021-08-14 | Delaware | Ohio | 39041 | 19660 | 138 |
1614030 | 1614030 | 2021-08-13 | Delaware | Ohio | 39041 | 19623 | 138 |
1610781 | 1610781 | 2021-08-12 | Delaware | Ohio | 39041 | 19591 | 138 |
1607533 | 1607533 | 2021-08-11 | Delaware | Ohio | 39041 | 19550 | 138 |
1604284 | 1604284 | 2021-08-10 | Delaware | Ohio | 39041 | 19507 | 138 |
1601035 | 1601035 | 2021-08-09 | Delaware | Ohio | 39041 | 19479 | 138 |
1597787 | 1597787 | 2021-08-08 | Delaware | Ohio | 39041 | 19458 | 138 |
1594538 | 1594538 | 2021-08-07 | Delaware | Ohio | 39041 | 19437 | 138 |
1591289 | 1591289 | 2021-08-06 | Delaware | Ohio | 39041 | 19400 | 138 |
1588040 | 1588040 | 2021-08-05 | Delaware | Ohio | 39041 | 19359 | 138 |
1584790 | 1584790 | 2021-08-04 | Delaware | Ohio | 39041 | 19327 | 138 |
1581540 | 1581540 | 2021-08-03 | Delaware | Ohio | 39041 | 19295 | 138 |
1578291 | 1578291 | 2021-08-02 | Delaware | Ohio | 39041 | 19252 | 138 |
1575043 | 1575043 | 2021-08-01 | Delaware | Ohio | 39041 | 19236 | 138 |
1571795 | 1571795 | 2021-07-31 | Delaware | Ohio | 39041 | 19226 | 138 |
1568547 | 1568547 | 2021-07-30 | Delaware | Ohio | 39041 | 19207 | 138 |
1565299 | 1565299 | 2021-07-29 | Delaware | Ohio | 39041 | 19188 | 138 |
1562051 | 1562051 | 2021-07-28 | Delaware | Ohio | 39041 | 19169 | 138 |
1558803 | 1558803 | 2021-07-27 | Delaware | Ohio | 39041 | 19143 | 138 |
1555556 | 1555556 | 2021-07-26 | Delaware | Ohio | 39041 | 19120 | 138 |
1552309 | 1552309 | 2021-07-25 | Delaware | Ohio | 39041 | 19105 | 138 |
1549062 | 1549062 | 2021-07-24 | Delaware | Ohio | 39041 | 19099 | 138 |
1545815 | 1545815 | 2021-07-23 | Delaware | Ohio | 39041 | 19088 | 138 |
1542568 | 1542568 | 2021-07-22 | Delaware | Ohio | 39041 | 19077 | 137 |
1539320 | 1539320 | 2021-07-21 | Delaware | Ohio | 39041 | 19054 | 137 |
1536073 | 1536073 | 2021-07-20 | Delaware | Ohio | 39041 | 19028 | 137 |
1532825 | 1532825 | 2021-07-19 | Delaware | Ohio | 39041 | 19019 | 137 |
1529578 | 1529578 | 2021-07-18 | Delaware | Ohio | 39041 | 19013 | 137 |
1526331 | 1526331 | 2021-07-17 | Delaware | Ohio | 39041 | 19010 | 137 |
1523084 | 1523084 | 2021-07-16 | Delaware | Ohio | 39041 | 19006 | 137 |
1519836 | 1519836 | 2021-07-15 | Delaware | Ohio | 39041 | 19003 | 137 |
1516588 | 1516588 | 2021-07-14 | Delaware | Ohio | 39041 | 18992 | 137 |
1513341 | 1513341 | 2021-07-13 | Delaware | Ohio | 39041 | 18980 | 137 |
1510095 | 1510095 | 2021-07-12 | Delaware | Ohio | 39041 | 18971 | 137 |
1506848 | 1506848 | 2021-07-11 | Delaware | Ohio | 39041 | 18965 | 137 |
1503602 | 1503602 | 2021-07-10 | Delaware | Ohio | 39041 | 18963 | 137 |
1500356 | 1500356 | 2021-07-09 | Delaware | Ohio | 39041 | 18956 | 137 |
1497110 | 1497110 | 2021-07-08 | Delaware | Ohio | 39041 | 18952 | 137 |
1493863 | 1493863 | 2021-07-07 | Delaware | Ohio | 39041 | 18943 | 137 |
1490616 | 1490616 | 2021-07-06 | Delaware | Ohio | 39041 | 18938 | 137 |
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);