ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where deaths = 144 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Geauga 18
- Van Wert 14
- Coshocton 11
- Jefferson 11
- Ross 10
- Champaign 9
- Mercer 9
- Crawford 7
- Pickaway 7
- Preble 7
- Seneca 7
- Lorain 5
- Belmont 4
- Butler 4
- Guernsey 4
- Huron 4
- Knox 4
- Scioto 4
- Washington 4
- Ashtabula 3
- Fulton 3
- Hardin 3
- Marion 3
- Montgomery 3
- Muskingum 3
- Williams 3
- Clark 2
- Greene 2
- Trumbull 2
- Licking 1
- …
state 1
- Ohio · 173 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501697 | 2501697 | 2022-05-13 | Mercer | Ohio | 39107 | 9715 | 144 |
2498439 | 2498439 | 2022-05-12 | Mercer | Ohio | 39107 | 9715 | 144 |
2495181 | 2495181 | 2022-05-11 | Mercer | Ohio | 39107 | 9699 | 144 |
2491923 | 2491923 | 2022-05-10 | Mercer | Ohio | 39107 | 9699 | 144 |
2488665 | 2488665 | 2022-05-09 | Mercer | Ohio | 39107 | 9699 | 144 |
2485408 | 2485408 | 2022-05-08 | Mercer | Ohio | 39107 | 9699 | 144 |
2482150 | 2482150 | 2022-05-07 | Mercer | Ohio | 39107 | 9699 | 144 |
2478892 | 2478892 | 2022-05-06 | Mercer | Ohio | 39107 | 9699 | 144 |
2475634 | 2475634 | 2022-05-05 | Mercer | Ohio | 39107 | 9699 | 144 |
2381243 | 2381243 | 2022-04-06 | Van Wert | Ohio | 39161 | 6707 | 144 |
2377988 | 2377988 | 2022-04-05 | Van Wert | Ohio | 39161 | 6707 | 144 |
2374734 | 2374734 | 2022-04-04 | Van Wert | Ohio | 39161 | 6707 | 144 |
2371482 | 2371482 | 2022-04-03 | Van Wert | Ohio | 39161 | 6707 | 144 |
2368229 | 2368229 | 2022-04-02 | Van Wert | Ohio | 39161 | 6707 | 144 |
2364976 | 2364976 | 2022-04-01 | Van Wert | Ohio | 39161 | 6707 | 144 |
2361723 | 2361723 | 2022-03-31 | Van Wert | Ohio | 39161 | 6707 | 144 |
2358469 | 2358469 | 2022-03-30 | Van Wert | Ohio | 39161 | 6705 | 144 |
2355215 | 2355215 | 2022-03-29 | Van Wert | Ohio | 39161 | 6705 | 144 |
2351962 | 2351962 | 2022-03-28 | Van Wert | Ohio | 39161 | 6705 | 144 |
2348710 | 2348710 | 2022-03-27 | Van Wert | Ohio | 39161 | 6705 | 144 |
2345457 | 2345457 | 2022-03-26 | Van Wert | Ohio | 39161 | 6705 | 144 |
2342204 | 2342204 | 2022-03-25 | Van Wert | Ohio | 39161 | 6705 | 144 |
2338951 | 2338951 | 2022-03-24 | Van Wert | Ohio | 39161 | 6705 | 144 |
2312853 | 2312853 | 2022-03-16 | Champaign | Ohio | 39021 | 8692 | 144 |
2309600 | 2309600 | 2022-03-15 | Champaign | Ohio | 39021 | 8692 | 144 |
2306347 | 2306347 | 2022-03-14 | Champaign | Ohio | 39021 | 8692 | 144 |
2303096 | 2303096 | 2022-03-13 | Champaign | Ohio | 39021 | 8692 | 144 |
2299844 | 2299844 | 2022-03-12 | Champaign | Ohio | 39021 | 8692 | 144 |
2296592 | 2296592 | 2022-03-11 | Champaign | Ohio | 39021 | 8692 | 144 |
2293340 | 2293340 | 2022-03-10 | Champaign | Ohio | 39021 | 8691 | 144 |
2290088 | 2290088 | 2022-03-09 | Champaign | Ohio | 39021 | 8688 | 144 |
2286836 | 2286836 | 2022-03-08 | Champaign | Ohio | 39021 | 8687 | 144 |
2260837 | 2260837 | 2022-02-28 | Guernsey | Ohio | 39059 | 10365 | 144 |
2257586 | 2257586 | 2022-02-27 | Guernsey | Ohio | 39059 | 10361 | 144 |
2254335 | 2254335 | 2022-02-26 | Guernsey | Ohio | 39059 | 10361 | 144 |
2251084 | 2251084 | 2022-02-25 | Guernsey | Ohio | 39059 | 10353 | 144 |
2247836 | 2247836 | 2022-02-24 | Hardin | Ohio | 39065 | 7027 | 144 |
2244585 | 2244585 | 2022-02-23 | Hardin | Ohio | 39065 | 7023 | 144 |
2241334 | 2241334 | 2022-02-22 | Hardin | Ohio | 39065 | 7021 | 144 |
2238066 | 2238066 | 2022-02-21 | Coshocton | Ohio | 39031 | 7885 | 144 |
2234815 | 2234815 | 2022-02-20 | Coshocton | Ohio | 39031 | 7878 | 144 |
2231564 | 2231564 | 2022-02-19 | Coshocton | Ohio | 39031 | 7878 | 144 |
2228313 | 2228313 | 2022-02-18 | Coshocton | Ohio | 39031 | 7866 | 144 |
2225062 | 2225062 | 2022-02-17 | Coshocton | Ohio | 39031 | 7858 | 144 |
2221811 | 2221811 | 2022-02-16 | Coshocton | Ohio | 39031 | 7853 | 144 |
2218560 | 2218560 | 2022-02-15 | Coshocton | Ohio | 39031 | 7844 | 144 |
2215309 | 2215309 | 2022-02-14 | Coshocton | Ohio | 39031 | 7839 | 144 |
2212058 | 2212058 | 2022-02-13 | Coshocton | Ohio | 39031 | 7836 | 144 |
2208805 | 2208805 | 2022-02-12 | Coshocton | Ohio | 39031 | 7832 | 144 |
2205552 | 2205552 | 2022-02-11 | Coshocton | Ohio | 39031 | 7826 | 144 |
2156820 | 2156820 | 2022-01-27 | Williams | Ohio | 39171 | 8528 | 144 |
2153567 | 2153567 | 2022-01-26 | Williams | Ohio | 39171 | 8452 | 144 |
2150315 | 2150315 | 2022-01-25 | Williams | Ohio | 39171 | 8364 | 144 |
2111218 | 2111218 | 2022-01-13 | Fulton | Ohio | 39051 | 8837 | 144 |
2107966 | 2107966 | 2022-01-12 | Fulton | Ohio | 39051 | 8741 | 144 |
2104715 | 2104715 | 2022-01-11 | Fulton | Ohio | 39051 | 8647 | 144 |
2042992 | 2042992 | 2021-12-23 | Preble | Ohio | 39135 | 6826 | 144 |
2039743 | 2039743 | 2021-12-22 | Preble | Ohio | 39135 | 6789 | 144 |
2036493 | 2036493 | 2021-12-21 | Preble | Ohio | 39135 | 6751 | 144 |
2033243 | 2033243 | 2021-12-20 | Preble | Ohio | 39135 | 6711 | 144 |
2029993 | 2029993 | 2021-12-19 | Preble | Ohio | 39135 | 6689 | 144 |
2026742 | 2026742 | 2021-12-18 | Preble | Ohio | 39135 | 6667 | 144 |
2023491 | 2023491 | 2021-12-17 | Preble | Ohio | 39135 | 6650 | 144 |
1929172 | 1929172 | 2021-11-18 | Crawford | Ohio | 39033 | 6778 | 144 |
1925922 | 1925922 | 2021-11-17 | Crawford | Ohio | 39033 | 6747 | 144 |
1922672 | 1922672 | 2021-11-16 | Crawford | Ohio | 39033 | 6713 | 144 |
1919423 | 1919423 | 2021-11-15 | Crawford | Ohio | 39033 | 6687 | 144 |
1916173 | 1916173 | 2021-11-14 | Crawford | Ohio | 39033 | 6670 | 144 |
1912923 | 1912923 | 2021-11-13 | Crawford | Ohio | 39033 | 6657 | 144 |
1909673 | 1909673 | 2021-11-12 | Crawford | Ohio | 39033 | 6638 | 144 |
1883723 | 1883723 | 2021-11-04 | Pickaway | Ohio | 39129 | 11532 | 144 |
1880474 | 1880474 | 2021-11-03 | Pickaway | Ohio | 39129 | 11517 | 144 |
1877225 | 1877225 | 2021-11-02 | Pickaway | Ohio | 39129 | 11486 | 144 |
1873950 | 1873950 | 2021-11-01 | Huron | Ohio | 39077 | 8648 | 144 |
1873976 | 1873976 | 2021-11-01 | Pickaway | Ohio | 39129 | 11475 | 144 |
1870701 | 1870701 | 2021-10-31 | Huron | Ohio | 39077 | 8633 | 144 |
1870727 | 1870727 | 2021-10-31 | Pickaway | Ohio | 39129 | 11465 | 144 |
1867452 | 1867452 | 2021-10-30 | Huron | Ohio | 39077 | 8619 | 144 |
1867478 | 1867478 | 2021-10-30 | Pickaway | Ohio | 39129 | 11460 | 144 |
1864203 | 1864203 | 2021-10-29 | Huron | Ohio | 39077 | 8590 | 144 |
1864229 | 1864229 | 2021-10-29 | Pickaway | Ohio | 39129 | 11451 | 144 |
1851210 | 1851210 | 2021-10-25 | Knox | Ohio | 39083 | 7766 | 144 |
1851253 | 1851253 | 2021-10-25 | Washington | Ohio | 39167 | 8114 | 144 |
1847960 | 1847960 | 2021-10-24 | Knox | Ohio | 39083 | 7751 | 144 |
1848003 | 1848003 | 2021-10-24 | Washington | Ohio | 39167 | 8105 | 144 |
1844710 | 1844710 | 2021-10-23 | Knox | Ohio | 39083 | 7739 | 144 |
1844753 | 1844753 | 2021-10-23 | Washington | Ohio | 39167 | 8093 | 144 |
1841460 | 1841460 | 2021-10-22 | Knox | Ohio | 39083 | 7705 | 144 |
1841503 | 1841503 | 2021-10-22 | Washington | Ohio | 39167 | 8085 | 144 |
1838243 | 1838243 | 2021-10-21 | Seneca | Ohio | 39147 | 7306 | 144 |
1834994 | 1834994 | 2021-10-20 | Seneca | Ohio | 39147 | 7261 | 144 |
1831745 | 1831745 | 2021-10-19 | Seneca | Ohio | 39147 | 7233 | 144 |
1828496 | 1828496 | 2021-10-18 | Seneca | Ohio | 39147 | 7208 | 144 |
1825247 | 1825247 | 2021-10-17 | Seneca | Ohio | 39147 | 7193 | 144 |
1821998 | 1821998 | 2021-10-16 | Seneca | Ohio | 39147 | 7184 | 144 |
1818749 | 1818749 | 2021-10-15 | Seneca | Ohio | 39147 | 7166 | 144 |
1805752 | 1805752 | 2021-10-11 | Scioto | Ohio | 39145 | 11190 | 144 |
1802502 | 1802502 | 2021-10-10 | Scioto | Ohio | 39145 | 11167 | 144 |
1799253 | 1799253 | 2021-10-09 | Scioto | Ohio | 39145 | 11141 | 144 |
1796004 | 1796004 | 2021-10-08 | Scioto | Ohio | 39145 | 11123 | 144 |
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);