ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
261 rows where deaths = 68 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Highland 35
- Henry 28
- Wayne 25
- Portage 21
- Monroe 14
- Defiance 13
- Van Wert 11
- Harrison 10
- Miami 9
- Clinton 7
- Fulton 7
- Jackson 7
- Madison 7
- Paulding 7
- Scioto 5
- Athens 4
- Brown 4
- Columbiana 4
- Erie 4
- Williams 4
- Crawford 3
- Gallia 3
- Guernsey 3
- Hardin 3
- Sandusky 3
- Wyandot 3
- Ashtabula 2
- Greene 2
- Lorain 2
- Shelby 2
- …
state 1
- Ohio · 261 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2238084 | 2238084 | 2022-02-21 | Harrison | Ohio | 39067 | 3189 | 68 |
2234833 | 2234833 | 2022-02-20 | Harrison | Ohio | 39067 | 3188 | 68 |
2231582 | 2231582 | 2022-02-19 | Harrison | Ohio | 39067 | 3187 | 68 |
2228331 | 2228331 | 2022-02-18 | Harrison | Ohio | 39067 | 3186 | 68 |
2225080 | 2225080 | 2022-02-17 | Harrison | Ohio | 39067 | 3185 | 68 |
2221829 | 2221829 | 2022-02-16 | Harrison | Ohio | 39067 | 3180 | 68 |
2218578 | 2218578 | 2022-02-15 | Harrison | Ohio | 39067 | 3177 | 68 |
2202317 | 2202317 | 2022-02-10 | Harrison | Ohio | 39067 | 3166 | 68 |
2202346 | 2202346 | 2022-02-10 | Paulding | Ohio | 39125 | 4550 | 68 |
2199063 | 2199063 | 2022-02-09 | Harrison | Ohio | 39067 | 3158 | 68 |
2199092 | 2199092 | 2022-02-09 | Paulding | Ohio | 39125 | 4544 | 68 |
2195809 | 2195809 | 2022-02-08 | Harrison | Ohio | 39067 | 3156 | 68 |
2195838 | 2195838 | 2022-02-08 | Paulding | Ohio | 39125 | 4536 | 68 |
2192584 | 2192584 | 2022-02-07 | Paulding | Ohio | 39125 | 4530 | 68 |
2189330 | 2189330 | 2022-02-06 | Paulding | Ohio | 39125 | 4520 | 68 |
2186077 | 2186077 | 2022-02-05 | Paulding | Ohio | 39125 | 4518 | 68 |
2182825 | 2182825 | 2022-02-04 | Paulding | Ohio | 39125 | 4506 | 68 |
2156789 | 2156789 | 2022-01-27 | Monroe | Ohio | 39111 | 3266 | 68 |
2153536 | 2153536 | 2022-01-26 | Monroe | Ohio | 39111 | 3243 | 68 |
2150284 | 2150284 | 2022-01-25 | Monroe | Ohio | 39111 | 3219 | 68 |
2147032 | 2147032 | 2022-01-24 | Monroe | Ohio | 39111 | 3164 | 68 |
2143778 | 2143778 | 2022-01-23 | Monroe | Ohio | 39111 | 3148 | 68 |
2140523 | 2140523 | 2022-01-22 | Monroe | Ohio | 39111 | 3138 | 68 |
2137267 | 2137267 | 2022-01-21 | Monroe | Ohio | 39111 | 3116 | 68 |
2134013 | 2134013 | 2022-01-20 | Monroe | Ohio | 39111 | 3074 | 68 |
2130761 | 2130761 | 2022-01-19 | Monroe | Ohio | 39111 | 3033 | 68 |
2127507 | 2127507 | 2022-01-18 | Monroe | Ohio | 39111 | 3002 | 68 |
2124255 | 2124255 | 2022-01-17 | Monroe | Ohio | 39111 | 2993 | 68 |
2121003 | 2121003 | 2022-01-16 | Monroe | Ohio | 39111 | 2982 | 68 |
2117751 | 2117751 | 2022-01-15 | Monroe | Ohio | 39111 | 2959 | 68 |
2114500 | 2114500 | 2022-01-14 | Monroe | Ohio | 39111 | 2926 | 68 |
1929244 | 1929244 | 2021-11-18 | Wyandot | Ohio | 39175 | 3550 | 68 |
1925994 | 1925994 | 2021-11-17 | Wyandot | Ohio | 39175 | 3539 | 68 |
1922744 | 1922744 | 2021-11-16 | Wyandot | Ohio | 39175 | 3527 | 68 |
1860942 | 1860942 | 2021-10-28 | Gallia | Ohio | 39053 | 4249 | 68 |
1857693 | 1857693 | 2021-10-27 | Gallia | Ohio | 39053 | 4230 | 68 |
1854444 | 1854444 | 2021-10-26 | Gallia | Ohio | 39053 | 4207 | 68 |
1838199 | 1838199 | 2021-10-21 | Guernsey | Ohio | 39059 | 5834 | 68 |
1834950 | 1834950 | 2021-10-20 | Guernsey | Ohio | 39059 | 5803 | 68 |
1831701 | 1831701 | 2021-10-19 | Guernsey | Ohio | 39059 | 5769 | 68 |
1805684 | 1805684 | 2021-10-11 | Athens | Ohio | 39009 | 7543 | 68 |
1805719 | 1805719 | 2021-10-11 | Jackson | Ohio | 39079 | 4812 | 68 |
1802434 | 1802434 | 2021-10-10 | Athens | Ohio | 39009 | 7531 | 68 |
1802469 | 1802469 | 2021-10-10 | Jackson | Ohio | 39079 | 4784 | 68 |
1799185 | 1799185 | 2021-10-09 | Athens | Ohio | 39009 | 7505 | 68 |
1799220 | 1799220 | 2021-10-09 | Jackson | Ohio | 39079 | 4753 | 68 |
1795936 | 1795936 | 2021-10-08 | Athens | Ohio | 39009 | 7485 | 68 |
1795971 | 1795971 | 2021-10-08 | Jackson | Ohio | 39079 | 4748 | 68 |
1792722 | 1792722 | 2021-10-07 | Jackson | Ohio | 39079 | 4720 | 68 |
1789473 | 1789473 | 2021-10-06 | Jackson | Ohio | 39079 | 4677 | 68 |
1786225 | 1786225 | 2021-10-05 | Jackson | Ohio | 39079 | 4631 | 68 |
1747231 | 1747231 | 2021-09-23 | Henry | Ohio | 39069 | 3273 | 68 |
1743982 | 1743982 | 2021-09-22 | Henry | Ohio | 39069 | 3246 | 68 |
1740733 | 1740733 | 2021-09-21 | Henry | Ohio | 39069 | 3226 | 68 |
1737457 | 1737457 | 2021-09-20 | Brown | Ohio | 39015 | 5556 | 68 |
1737484 | 1737484 | 2021-09-20 | Henry | Ohio | 39069 | 3209 | 68 |
1734207 | 1734207 | 2021-09-19 | Brown | Ohio | 39015 | 5535 | 68 |
1734234 | 1734234 | 2021-09-19 | Henry | Ohio | 39069 | 3200 | 68 |
1730957 | 1730957 | 2021-09-18 | Brown | Ohio | 39015 | 5510 | 68 |
1730984 | 1730984 | 2021-09-18 | Henry | Ohio | 39069 | 3188 | 68 |
1727707 | 1727707 | 2021-09-17 | Brown | Ohio | 39015 | 5471 | 68 |
1727734 | 1727734 | 2021-09-17 | Henry | Ohio | 39069 | 3176 | 68 |
1724483 | 1724483 | 2021-09-16 | Hardin | Ohio | 39065 | 3446 | 68 |
1724485 | 1724485 | 2021-09-16 | Henry | Ohio | 39069 | 3149 | 68 |
1724499 | 1724499 | 2021-09-16 | Madison | Ohio | 39097 | 5297 | 68 |
1721234 | 1721234 | 2021-09-15 | Hardin | Ohio | 39065 | 3418 | 68 |
1721236 | 1721236 | 2021-09-15 | Henry | Ohio | 39069 | 3126 | 68 |
1721250 | 1721250 | 2021-09-15 | Madison | Ohio | 39097 | 5273 | 68 |
1717986 | 1717986 | 2021-09-14 | Hardin | Ohio | 39065 | 3372 | 68 |
1717988 | 1717988 | 2021-09-14 | Henry | Ohio | 39069 | 3107 | 68 |
1718002 | 1718002 | 2021-09-14 | Madison | Ohio | 39097 | 5237 | 68 |
1714740 | 1714740 | 2021-09-13 | Henry | Ohio | 39069 | 3090 | 68 |
1714754 | 1714754 | 2021-09-13 | Madison | Ohio | 39097 | 5209 | 68 |
1714787 | 1714787 | 2021-09-13 | Van Wert | Ohio | 39161 | 2963 | 68 |
1711494 | 1711494 | 2021-09-12 | Henry | Ohio | 39069 | 3082 | 68 |
1711508 | 1711508 | 2021-09-12 | Madison | Ohio | 39097 | 5185 | 68 |
1711541 | 1711541 | 2021-09-12 | Van Wert | Ohio | 39161 | 2952 | 68 |
1708247 | 1708247 | 2021-09-11 | Henry | Ohio | 39069 | 3075 | 68 |
1708261 | 1708261 | 2021-09-11 | Madison | Ohio | 39097 | 5175 | 68 |
1708294 | 1708294 | 2021-09-11 | Van Wert | Ohio | 39161 | 2942 | 68 |
1705000 | 1705000 | 2021-09-10 | Henry | Ohio | 39069 | 3061 | 68 |
1705014 | 1705014 | 2021-09-10 | Madison | Ohio | 39097 | 5138 | 68 |
1705047 | 1705047 | 2021-09-10 | Van Wert | Ohio | 39161 | 2907 | 68 |
1701750 | 1701750 | 2021-09-09 | Henry | Ohio | 39069 | 3049 | 68 |
1701797 | 1701797 | 2021-09-09 | Van Wert | Ohio | 39161 | 2879 | 68 |
1698501 | 1698501 | 2021-09-08 | Henry | Ohio | 39069 | 3032 | 68 |
1698548 | 1698548 | 2021-09-08 | Van Wert | Ohio | 39161 | 2873 | 68 |
1695253 | 1695253 | 2021-09-07 | Henry | Ohio | 39069 | 3017 | 68 |
1695300 | 1695300 | 2021-09-07 | Van Wert | Ohio | 39161 | 2857 | 68 |
1692005 | 1692005 | 2021-09-06 | Henry | Ohio | 39069 | 3009 | 68 |
1692052 | 1692052 | 2021-09-06 | Van Wert | Ohio | 39161 | 2846 | 68 |
1688756 | 1688756 | 2021-09-05 | Henry | Ohio | 39069 | 2997 | 68 |
1688803 | 1688803 | 2021-09-05 | Van Wert | Ohio | 39161 | 2842 | 68 |
1685506 | 1685506 | 2021-09-04 | Henry | Ohio | 39069 | 2988 | 68 |
1685553 | 1685553 | 2021-09-04 | Van Wert | Ohio | 39161 | 2836 | 68 |
1682255 | 1682255 | 2021-09-03 | Henry | Ohio | 39069 | 2972 | 68 |
1682302 | 1682302 | 2021-09-03 | Van Wert | Ohio | 39161 | 2822 | 68 |
1679005 | 1679005 | 2021-09-02 | Henry | Ohio | 39069 | 2954 | 68 |
1675757 | 1675757 | 2021-09-01 | Henry | Ohio | 39069 | 2940 | 68 |
1672510 | 1672510 | 2021-08-31 | Henry | Ohio | 39069 | 2933 | 68 |
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);