ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
420 rows where deaths = 66 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clinton 67
- Madison 56
- Henry 39
- Hardin 32
- Ashtabula 16
- Portage 15
- Union 14
- Auglaize 10
- Highland 10
- Lake 10
- Ross 10
- Seneca 10
- Athens 7
- Carroll 7
- Coshocton 7
- Fayette 7
- Morrow 7
- Ottawa 7
- Warren 7
- Wayne 6
- Williams 6
- Lorain 5
- Shelby 5
- Champaign 4
- Defiance 4
- Guernsey 4
- Hocking 4
- Jefferson 4
- Wyandot 4
- Columbiana 3
- …
state 1
- Ohio · 420 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179544 | 2179544 | 2022-02-03 | Harrison | Ohio | 39067 | 3143 | 66 |
2176293 | 2176293 | 2022-02-02 | Harrison | Ohio | 39067 | 3131 | 66 |
2173039 | 2173039 | 2022-02-01 | Harrison | Ohio | 39067 | 3117 | 66 |
2020231 | 2020231 | 2021-12-16 | Morrow | Ohio | 39117 | 5461 | 66 |
2016980 | 2016980 | 2021-12-15 | Morrow | Ohio | 39117 | 5437 | 66 |
2013730 | 2013730 | 2021-12-14 | Morrow | Ohio | 39117 | 5407 | 66 |
2010479 | 2010479 | 2021-12-13 | Morrow | Ohio | 39117 | 5392 | 66 |
2007228 | 2007228 | 2021-12-12 | Morrow | Ohio | 39117 | 5368 | 66 |
2003977 | 2003977 | 2021-12-11 | Morrow | Ohio | 39117 | 5359 | 66 |
2000726 | 2000726 | 2021-12-10 | Morrow | Ohio | 39117 | 5341 | 66 |
1919495 | 1919495 | 2021-11-15 | Wyandot | Ohio | 39175 | 3501 | 66 |
1916245 | 1916245 | 2021-11-14 | Wyandot | Ohio | 39175 | 3498 | 66 |
1912995 | 1912995 | 2021-11-13 | Wyandot | Ohio | 39175 | 3497 | 66 |
1909745 | 1909745 | 2021-11-12 | Wyandot | Ohio | 39175 | 3479 | 66 |
1906431 | 1906431 | 2021-11-11 | Fayette | Ohio | 39047 | 4540 | 66 |
1906487 | 1906487 | 2021-11-11 | Union | Ohio | 39159 | 8761 | 66 |
1903182 | 1903182 | 2021-11-10 | Fayette | Ohio | 39047 | 4506 | 66 |
1903238 | 1903238 | 2021-11-10 | Union | Ohio | 39159 | 8718 | 66 |
1899932 | 1899932 | 2021-11-09 | Fayette | Ohio | 39047 | 4482 | 66 |
1899988 | 1899988 | 2021-11-09 | Union | Ohio | 39159 | 8660 | 66 |
1896682 | 1896682 | 2021-11-08 | Fayette | Ohio | 39047 | 4450 | 66 |
1896738 | 1896738 | 2021-11-08 | Union | Ohio | 39159 | 8613 | 66 |
1893432 | 1893432 | 2021-11-07 | Fayette | Ohio | 39047 | 4444 | 66 |
1893488 | 1893488 | 2021-11-07 | Union | Ohio | 39159 | 8596 | 66 |
1890182 | 1890182 | 2021-11-06 | Fayette | Ohio | 39047 | 4426 | 66 |
1890238 | 1890238 | 2021-11-06 | Union | Ohio | 39159 | 8564 | 66 |
1886932 | 1886932 | 2021-11-05 | Fayette | Ohio | 39047 | 4415 | 66 |
1886988 | 1886988 | 2021-11-05 | Union | Ohio | 39159 | 8537 | 66 |
1883668 | 1883668 | 2021-11-04 | Carroll | Ohio | 39019 | 3147 | 66 |
1883738 | 1883738 | 2021-11-04 | Union | Ohio | 39159 | 8495 | 66 |
1880419 | 1880419 | 2021-11-03 | Carroll | Ohio | 39019 | 3133 | 66 |
1880489 | 1880489 | 2021-11-03 | Union | Ohio | 39159 | 8458 | 66 |
1877170 | 1877170 | 2021-11-02 | Carroll | Ohio | 39019 | 3120 | 66 |
1877240 | 1877240 | 2021-11-02 | Union | Ohio | 39159 | 8420 | 66 |
1873921 | 1873921 | 2021-11-01 | Carroll | Ohio | 39019 | 3107 | 66 |
1873991 | 1873991 | 2021-11-01 | Union | Ohio | 39159 | 8393 | 66 |
1870672 | 1870672 | 2021-10-31 | Carroll | Ohio | 39019 | 3099 | 66 |
1870742 | 1870742 | 2021-10-31 | Union | Ohio | 39159 | 8374 | 66 |
1867423 | 1867423 | 2021-10-30 | Carroll | Ohio | 39019 | 3095 | 66 |
1867493 | 1867493 | 2021-10-30 | Union | Ohio | 39159 | 8350 | 66 |
1864174 | 1864174 | 2021-10-29 | Carroll | Ohio | 39019 | 3089 | 66 |
1864244 | 1864244 | 2021-10-29 | Union | Ohio | 39159 | 8320 | 66 |
1860979 | 1860979 | 2021-10-28 | Perry | Ohio | 39127 | 5231 | 66 |
1857730 | 1857730 | 2021-10-27 | Perry | Ohio | 39127 | 5220 | 66 |
1854481 | 1854481 | 2021-10-26 | Perry | Ohio | 39127 | 5211 | 66 |
1838196 | 1838196 | 2021-10-21 | Gallia | Ohio | 39053 | 4162 | 66 |
1834947 | 1834947 | 2021-10-20 | Gallia | Ohio | 39053 | 4143 | 66 |
1831698 | 1831698 | 2021-10-19 | Gallia | Ohio | 39053 | 4128 | 66 |
1805690 | 1805690 | 2021-10-11 | Champaign | Ohio | 39021 | 4914 | 66 |
1802440 | 1802440 | 2021-10-10 | Champaign | Ohio | 39021 | 4906 | 66 |
1799191 | 1799191 | 2021-10-09 | Champaign | Ohio | 39021 | 4876 | 66 |
1795942 | 1795942 | 2021-10-08 | Champaign | Ohio | 39021 | 4869 | 66 |
1792687 | 1792687 | 2021-10-07 | Athens | Ohio | 39009 | 7466 | 66 |
1789438 | 1789438 | 2021-10-06 | Athens | Ohio | 39009 | 7442 | 66 |
1786190 | 1786190 | 2021-10-05 | Athens | Ohio | 39009 | 7399 | 66 |
1782941 | 1782941 | 2021-10-04 | Athens | Ohio | 39009 | 7368 | 66 |
1782966 | 1782966 | 2021-10-04 | Guernsey | Ohio | 39059 | 5162 | 66 |
1779692 | 1779692 | 2021-10-03 | Athens | Ohio | 39009 | 7349 | 66 |
1779717 | 1779717 | 2021-10-03 | Guernsey | Ohio | 39059 | 5139 | 66 |
1776442 | 1776442 | 2021-10-02 | Athens | Ohio | 39009 | 7336 | 66 |
1776467 | 1776467 | 2021-10-02 | Guernsey | Ohio | 39059 | 5112 | 66 |
1773192 | 1773192 | 2021-10-01 | Athens | Ohio | 39009 | 7308 | 66 |
1773217 | 1773217 | 2021-10-01 | Guernsey | Ohio | 39059 | 5076 | 66 |
1747212 | 1747212 | 2021-09-23 | Coshocton | Ohio | 39031 | 3816 | 66 |
1743963 | 1743963 | 2021-09-22 | Coshocton | Ohio | 39031 | 3747 | 66 |
1740714 | 1740714 | 2021-09-21 | Coshocton | Ohio | 39031 | 3713 | 66 |
1737465 | 1737465 | 2021-09-20 | Coshocton | Ohio | 39031 | 3651 | 66 |
1734215 | 1734215 | 2021-09-19 | Coshocton | Ohio | 39031 | 3620 | 66 |
1730965 | 1730965 | 2021-09-18 | Coshocton | Ohio | 39031 | 3594 | 66 |
1727715 | 1727715 | 2021-09-17 | Coshocton | Ohio | 39031 | 3541 | 66 |
1714738 | 1714738 | 2021-09-13 | Hardin | Ohio | 39065 | 3348 | 66 |
1714742 | 1714742 | 2021-09-13 | Hocking | Ohio | 39073 | 2741 | 66 |
1711492 | 1711492 | 2021-09-12 | Hardin | Ohio | 39065 | 3327 | 66 |
1711496 | 1711496 | 2021-09-12 | Hocking | Ohio | 39073 | 2724 | 66 |
1708245 | 1708245 | 2021-09-11 | Hardin | Ohio | 39065 | 3310 | 66 |
1708249 | 1708249 | 2021-09-11 | Hocking | Ohio | 39073 | 2712 | 66 |
1704998 | 1704998 | 2021-09-10 | Hardin | Ohio | 39065 | 3273 | 66 |
1705002 | 1705002 | 2021-09-10 | Hocking | Ohio | 39073 | 2687 | 66 |
1701748 | 1701748 | 2021-09-09 | Hardin | Ohio | 39065 | 3235 | 66 |
1701764 | 1701764 | 2021-09-09 | Madison | Ohio | 39097 | 5101 | 66 |
1698499 | 1698499 | 2021-09-08 | Hardin | Ohio | 39065 | 3195 | 66 |
1698515 | 1698515 | 2021-09-08 | Madison | Ohio | 39097 | 5053 | 66 |
1695251 | 1695251 | 2021-09-07 | Hardin | Ohio | 39065 | 3172 | 66 |
1695267 | 1695267 | 2021-09-07 | Madison | Ohio | 39097 | 5031 | 66 |
1692003 | 1692003 | 2021-09-06 | Hardin | Ohio | 39065 | 3153 | 66 |
1692019 | 1692019 | 2021-09-06 | Madison | Ohio | 39097 | 5019 | 66 |
1688754 | 1688754 | 2021-09-05 | Hardin | Ohio | 39065 | 3132 | 66 |
1688770 | 1688770 | 2021-09-05 | Madison | Ohio | 39097 | 4999 | 66 |
1685504 | 1685504 | 2021-09-04 | Hardin | Ohio | 39065 | 3107 | 66 |
1685520 | 1685520 | 2021-09-04 | Madison | Ohio | 39097 | 4990 | 66 |
1682253 | 1682253 | 2021-09-03 | Hardin | Ohio | 39065 | 3087 | 66 |
1682269 | 1682269 | 2021-09-03 | Madison | Ohio | 39097 | 4963 | 66 |
1679003 | 1679003 | 2021-09-02 | Hardin | Ohio | 39065 | 3066 | 66 |
1675755 | 1675755 | 2021-09-01 | Hardin | Ohio | 39065 | 3048 | 66 |
1672508 | 1672508 | 2021-08-31 | Hardin | Ohio | 39065 | 3021 | 66 |
1669260 | 1669260 | 2021-08-30 | Hardin | Ohio | 39065 | 2997 | 66 |
1666013 | 1666013 | 2021-08-29 | Hardin | Ohio | 39065 | 2987 | 66 |
1662765 | 1662765 | 2021-08-28 | Hardin | Ohio | 39065 | 2977 | 66 |
1659517 | 1659517 | 2021-08-27 | Hardin | Ohio | 39065 | 2967 | 66 |
1656268 | 1656268 | 2021-08-26 | Hardin | Ohio | 39065 | 2953 | 66 |
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);