ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
397 rows where deaths = 38 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1997500 | 1997500 | 2021-12-09 | Vinton | Ohio | 39163 | 1927 | 38 |
1994249 | 1994249 | 2021-12-08 | Vinton | Ohio | 39163 | 1923 | 38 |
1990998 | 1990998 | 2021-12-07 | Vinton | Ohio | 39163 | 1908 | 38 |
1987747 | 1987747 | 2021-12-06 | Vinton | Ohio | 39163 | 1897 | 38 |
1984497 | 1984497 | 2021-12-05 | Vinton | Ohio | 39163 | 1891 | 38 |
1981247 | 1981247 | 2021-12-04 | Vinton | Ohio | 39163 | 1881 | 38 |
1977997 | 1977997 | 2021-12-03 | Vinton | Ohio | 39163 | 1876 | 38 |
1974722 | 1974722 | 2021-12-02 | Morgan | Ohio | 39115 | 2152 | 38 |
1971473 | 1971473 | 2021-12-01 | Morgan | Ohio | 39115 | 2144 | 38 |
1968223 | 1968223 | 2021-11-30 | Morgan | Ohio | 39115 | 2121 | 38 |
1964972 | 1964972 | 2021-11-29 | Morgan | Ohio | 39115 | 2101 | 38 |
1961720 | 1961720 | 2021-11-28 | Morgan | Ohio | 39115 | 2096 | 38 |
1958469 | 1958469 | 2021-11-27 | Morgan | Ohio | 39115 | 2089 | 38 |
1955218 | 1955218 | 2021-11-26 | Morgan | Ohio | 39115 | 2083 | 38 |
1951967 | 1951967 | 2021-11-25 | Morgan | Ohio | 39115 | 2071 | 38 |
1948716 | 1948716 | 2021-11-24 | Morgan | Ohio | 39115 | 2071 | 38 |
1945465 | 1945465 | 2021-11-23 | Morgan | Ohio | 39115 | 2064 | 38 |
1942214 | 1942214 | 2021-11-22 | Morgan | Ohio | 39115 | 2058 | 38 |
1938964 | 1938964 | 2021-11-21 | Morgan | Ohio | 39115 | 2057 | 38 |
1935714 | 1935714 | 2021-11-20 | Morgan | Ohio | 39115 | 2049 | 38 |
1932464 | 1932464 | 2021-11-19 | Morgan | Ohio | 39115 | 2043 | 38 |
1929213 | 1929213 | 2021-11-18 | Morgan | Ohio | 39115 | 2042 | 38 |
1925963 | 1925963 | 2021-11-17 | Morgan | Ohio | 39115 | 2025 | 38 |
1922713 | 1922713 | 2021-11-16 | Morgan | Ohio | 39115 | 2016 | 38 |
1714771 | 1714771 | 2021-09-13 | Pike | Ohio | 39131 | 3583 | 38 |
1711525 | 1711525 | 2021-09-12 | Pike | Ohio | 39131 | 3552 | 38 |
1708278 | 1708278 | 2021-09-11 | Pike | Ohio | 39131 | 3518 | 38 |
1705031 | 1705031 | 2021-09-10 | Pike | Ohio | 39131 | 3459 | 38 |
1701749 | 1701749 | 2021-09-09 | Harrison | Ohio | 39067 | 1343 | 38 |
1701781 | 1701781 | 2021-09-09 | Pike | Ohio | 39131 | 3391 | 38 |
1698500 | 1698500 | 2021-09-08 | Harrison | Ohio | 39067 | 1324 | 38 |
1698532 | 1698532 | 2021-09-08 | Pike | Ohio | 39131 | 3362 | 38 |
1695252 | 1695252 | 2021-09-07 | Harrison | Ohio | 39067 | 1312 | 38 |
1695284 | 1695284 | 2021-09-07 | Pike | Ohio | 39131 | 3299 | 38 |
1692004 | 1692004 | 2021-09-06 | Harrison | Ohio | 39067 | 1301 | 38 |
1692036 | 1692036 | 2021-09-06 | Pike | Ohio | 39131 | 3272 | 38 |
1688755 | 1688755 | 2021-09-05 | Harrison | Ohio | 39067 | 1297 | 38 |
1688787 | 1688787 | 2021-09-05 | Pike | Ohio | 39131 | 3246 | 38 |
1685505 | 1685505 | 2021-09-04 | Harrison | Ohio | 39067 | 1287 | 38 |
1685537 | 1685537 | 2021-09-04 | Pike | Ohio | 39131 | 3190 | 38 |
1682254 | 1682254 | 2021-09-03 | Harrison | Ohio | 39067 | 1283 | 38 |
1682286 | 1682286 | 2021-09-03 | Pike | Ohio | 39131 | 3122 | 38 |
1679004 | 1679004 | 2021-09-02 | Harrison | Ohio | 39067 | 1278 | 38 |
1679036 | 1679036 | 2021-09-02 | Pike | Ohio | 39131 | 3067 | 38 |
1675756 | 1675756 | 2021-09-01 | Harrison | Ohio | 39067 | 1274 | 38 |
1675788 | 1675788 | 2021-09-01 | Pike | Ohio | 39131 | 3009 | 38 |
1672509 | 1672509 | 2021-08-31 | Harrison | Ohio | 39067 | 1268 | 38 |
1672541 | 1672541 | 2021-08-31 | Pike | Ohio | 39131 | 2948 | 38 |
1669261 | 1669261 | 2021-08-30 | Harrison | Ohio | 39067 | 1259 | 38 |
1669293 | 1669293 | 2021-08-30 | Pike | Ohio | 39131 | 2903 | 38 |
1666014 | 1666014 | 2021-08-29 | Harrison | Ohio | 39067 | 1253 | 38 |
1666046 | 1666046 | 2021-08-29 | Pike | Ohio | 39131 | 2881 | 38 |
1662766 | 1662766 | 2021-08-28 | Harrison | Ohio | 39067 | 1249 | 38 |
1662798 | 1662798 | 2021-08-28 | Pike | Ohio | 39131 | 2843 | 38 |
1659518 | 1659518 | 2021-08-27 | Harrison | Ohio | 39067 | 1246 | 38 |
1659550 | 1659550 | 2021-08-27 | Pike | Ohio | 39131 | 2806 | 38 |
1656269 | 1656269 | 2021-08-26 | Harrison | Ohio | 39067 | 1240 | 38 |
1656301 | 1656301 | 2021-08-26 | Pike | Ohio | 39131 | 2775 | 38 |
1653022 | 1653022 | 2021-08-25 | Harrison | Ohio | 39067 | 1230 | 38 |
1653054 | 1653054 | 2021-08-25 | Pike | Ohio | 39131 | 2741 | 38 |
1649775 | 1649775 | 2021-08-24 | Harrison | Ohio | 39067 | 1226 | 38 |
1649807 | 1649807 | 2021-08-24 | Pike | Ohio | 39131 | 2705 | 38 |
1646526 | 1646526 | 2021-08-23 | Harrison | Ohio | 39067 | 1221 | 38 |
1643277 | 1643277 | 2021-08-22 | Harrison | Ohio | 39067 | 1221 | 38 |
1640027 | 1640027 | 2021-08-21 | Harrison | Ohio | 39067 | 1219 | 38 |
1636777 | 1636777 | 2021-08-20 | Harrison | Ohio | 39067 | 1218 | 38 |
1633527 | 1633527 | 2021-08-19 | Harrison | Ohio | 39067 | 1213 | 38 |
1630280 | 1630280 | 2021-08-18 | Harrison | Ohio | 39067 | 1206 | 38 |
1627033 | 1627033 | 2021-08-17 | Harrison | Ohio | 39067 | 1201 | 38 |
1623786 | 1623786 | 2021-08-16 | Harrison | Ohio | 39067 | 1195 | 38 |
1620539 | 1620539 | 2021-08-15 | Harrison | Ohio | 39067 | 1191 | 38 |
1617291 | 1617291 | 2021-08-14 | Harrison | Ohio | 39067 | 1191 | 38 |
1614043 | 1614043 | 2021-08-13 | Harrison | Ohio | 39067 | 1186 | 38 |
1610794 | 1610794 | 2021-08-12 | Harrison | Ohio | 39067 | 1184 | 38 |
1607546 | 1607546 | 2021-08-11 | Harrison | Ohio | 39067 | 1179 | 38 |
1604297 | 1604297 | 2021-08-10 | Harrison | Ohio | 39067 | 1176 | 38 |
1601048 | 1601048 | 2021-08-09 | Harrison | Ohio | 39067 | 1171 | 38 |
1597800 | 1597800 | 2021-08-08 | Harrison | Ohio | 39067 | 1171 | 38 |
1594551 | 1594551 | 2021-08-07 | Harrison | Ohio | 39067 | 1169 | 38 |
1591302 | 1591302 | 2021-08-06 | Harrison | Ohio | 39067 | 1167 | 38 |
1588053 | 1588053 | 2021-08-05 | Harrison | Ohio | 39067 | 1164 | 38 |
1584803 | 1584803 | 2021-08-04 | Harrison | Ohio | 39067 | 1161 | 38 |
1581553 | 1581553 | 2021-08-03 | Harrison | Ohio | 39067 | 1157 | 38 |
1578304 | 1578304 | 2021-08-02 | Harrison | Ohio | 39067 | 1155 | 38 |
1575056 | 1575056 | 2021-08-01 | Harrison | Ohio | 39067 | 1155 | 38 |
1571808 | 1571808 | 2021-07-31 | Harrison | Ohio | 39067 | 1155 | 38 |
1568560 | 1568560 | 2021-07-30 | Harrison | Ohio | 39067 | 1154 | 38 |
1565312 | 1565312 | 2021-07-29 | Harrison | Ohio | 39067 | 1154 | 38 |
1562064 | 1562064 | 2021-07-28 | Harrison | Ohio | 39067 | 1154 | 38 |
1558816 | 1558816 | 2021-07-27 | Harrison | Ohio | 39067 | 1152 | 38 |
1555569 | 1555569 | 2021-07-26 | Harrison | Ohio | 39067 | 1152 | 38 |
1552322 | 1552322 | 2021-07-25 | Harrison | Ohio | 39067 | 1151 | 38 |
1549075 | 1549075 | 2021-07-24 | Harrison | Ohio | 39067 | 1151 | 38 |
1545828 | 1545828 | 2021-07-23 | Harrison | Ohio | 39067 | 1150 | 38 |
1542581 | 1542581 | 2021-07-22 | Harrison | Ohio | 39067 | 1150 | 38 |
1539333 | 1539333 | 2021-07-21 | Harrison | Ohio | 39067 | 1149 | 38 |
1536086 | 1536086 | 2021-07-20 | Harrison | Ohio | 39067 | 1149 | 38 |
1532838 | 1532838 | 2021-07-19 | Harrison | Ohio | 39067 | 1149 | 38 |
1529591 | 1529591 | 2021-07-18 | Harrison | Ohio | 39067 | 1149 | 38 |
1526344 | 1526344 | 2021-07-17 | Harrison | Ohio | 39067 | 1149 | 38 |
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);