ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
201 rows where deaths = 100 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2247892 | 2247892 | 2022-02-24 | Wyandot | Ohio | 39175 | 5388 | 100 |
2244641 | 2244641 | 2022-02-23 | Wyandot | Ohio | 39175 | 5386 | 100 |
2241390 | 2241390 | 2022-02-22 | Wyandot | Ohio | 39175 | 5387 | 100 |
2215328 | 2215328 | 2022-02-14 | Henry | Ohio | 39069 | 6353 | 100 |
2215359 | 2215359 | 2022-02-14 | Pike | Ohio | 39131 | 7270 | 100 |
2212077 | 2212077 | 2022-02-13 | Henry | Ohio | 39069 | 6351 | 100 |
2212108 | 2212108 | 2022-02-13 | Pike | Ohio | 39131 | 7265 | 100 |
2208824 | 2208824 | 2022-02-12 | Henry | Ohio | 39069 | 6346 | 100 |
2208855 | 2208855 | 2022-02-12 | Pike | Ohio | 39131 | 7261 | 100 |
2205571 | 2205571 | 2022-02-11 | Henry | Ohio | 39069 | 6339 | 100 |
2205602 | 2205602 | 2022-02-11 | Pike | Ohio | 39131 | 7251 | 100 |
2202318 | 2202318 | 2022-02-10 | Henry | Ohio | 39069 | 6329 | 100 |
2199064 | 2199064 | 2022-02-09 | Henry | Ohio | 39069 | 6327 | 100 |
2195810 | 2195810 | 2022-02-08 | Henry | Ohio | 39069 | 6310 | 100 |
2192545 | 2192545 | 2022-02-07 | Fayette | Ohio | 39047 | 7610 | 100 |
2189291 | 2189291 | 2022-02-06 | Fayette | Ohio | 39047 | 7607 | 100 |
2186038 | 2186038 | 2022-02-05 | Fayette | Ohio | 39047 | 7597 | 100 |
2182786 | 2182786 | 2022-02-04 | Fayette | Ohio | 39047 | 7591 | 100 |
2133967 | 2133967 | 2022-01-20 | Carroll | Ohio | 39019 | 4909 | 100 |
2130715 | 2130715 | 2022-01-19 | Carroll | Ohio | 39019 | 4877 | 100 |
2127461 | 2127461 | 2022-01-18 | Carroll | Ohio | 39019 | 4853 | 100 |
2124209 | 2124209 | 2022-01-17 | Carroll | Ohio | 39019 | 4828 | 100 |
2120957 | 2120957 | 2022-01-16 | Carroll | Ohio | 39019 | 4791 | 100 |
2117705 | 2117705 | 2022-01-15 | Carroll | Ohio | 39019 | 4772 | 100 |
2114454 | 2114454 | 2022-01-14 | Carroll | Ohio | 39019 | 4689 | 100 |
2101475 | 2101475 | 2022-01-10 | Hocking | Ohio | 39073 | 5105 | 100 |
2098224 | 2098224 | 2022-01-09 | Hocking | Ohio | 39073 | 5061 | 100 |
2094972 | 2094972 | 2022-01-08 | Hocking | Ohio | 39073 | 5041 | 100 |
2091720 | 2091720 | 2022-01-07 | Hocking | Ohio | 39073 | 4995 | 100 |
2078706 | 2078706 | 2022-01-03 | Guernsey | Ohio | 39059 | 7899 | 100 |
2075455 | 2075455 | 2022-01-02 | Guernsey | Ohio | 39059 | 7857 | 100 |
2072204 | 2072204 | 2022-01-01 | Guernsey | Ohio | 39059 | 7802 | 100 |
2068953 | 2068953 | 2021-12-31 | Guernsey | Ohio | 39059 | 7802 | 100 |
2033180 | 2033180 | 2021-12-20 | Athens | Ohio | 39009 | 8726 | 100 |
2029930 | 2029930 | 2021-12-19 | Athens | Ohio | 39009 | 8716 | 100 |
2026679 | 2026679 | 2021-12-18 | Athens | Ohio | 39009 | 8698 | 100 |
2023428 | 2023428 | 2021-12-17 | Athens | Ohio | 39009 | 8673 | 100 |
2020226 | 2020226 | 2021-12-16 | Mercer | Ohio | 39107 | 7189 | 100 |
2020254 | 2020254 | 2021-12-16 | Van Wert | Ohio | 39161 | 4919 | 100 |
2016975 | 2016975 | 2021-12-15 | Mercer | Ohio | 39107 | 7173 | 100 |
2017003 | 2017003 | 2021-12-15 | Van Wert | Ohio | 39161 | 4899 | 100 |
2013725 | 2013725 | 2021-12-14 | Mercer | Ohio | 39107 | 7153 | 100 |
2013753 | 2013753 | 2021-12-14 | Van Wert | Ohio | 39161 | 4882 | 100 |
2010474 | 2010474 | 2021-12-13 | Mercer | Ohio | 39107 | 7124 | 100 |
2007223 | 2007223 | 2021-12-12 | Mercer | Ohio | 39107 | 7113 | 100 |
2003972 | 2003972 | 2021-12-11 | Mercer | Ohio | 39107 | 7107 | 100 |
2000721 | 2000721 | 2021-12-10 | Mercer | Ohio | 39107 | 7086 | 100 |
1997471 | 1997471 | 2021-12-09 | Mercer | Ohio | 39107 | 7066 | 100 |
1994220 | 1994220 | 2021-12-08 | Mercer | Ohio | 39107 | 7035 | 100 |
1990969 | 1990969 | 2021-12-07 | Mercer | Ohio | 39107 | 7001 | 100 |
1987697 | 1987697 | 2021-12-06 | Hardin | Ohio | 39065 | 4960 | 100 |
1987718 | 1987718 | 2021-12-06 | Mercer | Ohio | 39107 | 6964 | 100 |
1984447 | 1984447 | 2021-12-05 | Hardin | Ohio | 39065 | 4947 | 100 |
1984468 | 1984468 | 2021-12-05 | Mercer | Ohio | 39107 | 6959 | 100 |
1981197 | 1981197 | 2021-12-04 | Hardin | Ohio | 39065 | 4934 | 100 |
1981218 | 1981218 | 2021-12-04 | Mercer | Ohio | 39107 | 6954 | 100 |
1977947 | 1977947 | 2021-12-03 | Hardin | Ohio | 39065 | 4895 | 100 |
1977968 | 1977968 | 2021-12-03 | Mercer | Ohio | 39107 | 6933 | 100 |
1942172 | 1942172 | 2021-11-22 | Coshocton | Ohio | 39031 | 5416 | 100 |
1938922 | 1938922 | 2021-11-21 | Coshocton | Ohio | 39031 | 5392 | 100 |
1935672 | 1935672 | 2021-11-20 | Coshocton | Ohio | 39031 | 5381 | 100 |
1932422 | 1932422 | 2021-11-19 | Coshocton | Ohio | 39031 | 5352 | 100 |
1929171 | 1929171 | 2021-11-18 | Coshocton | Ohio | 39031 | 5325 | 100 |
1925921 | 1925921 | 2021-11-17 | Coshocton | Ohio | 39031 | 5309 | 100 |
1922671 | 1922671 | 2021-11-16 | Coshocton | Ohio | 39031 | 5274 | 100 |
1896659 | 1896659 | 2021-11-08 | Adams | Ohio | 39001 | 4302 | 100 |
1893409 | 1893409 | 2021-11-07 | Adams | Ohio | 39001 | 4298 | 100 |
1890159 | 1890159 | 2021-11-06 | Adams | Ohio | 39001 | 4290 | 100 |
1886909 | 1886909 | 2021-11-05 | Adams | Ohio | 39001 | 4282 | 100 |
1883672 | 1883672 | 2021-11-04 | Clinton | Ohio | 39027 | 5977 | 100 |
1880423 | 1880423 | 2021-11-03 | Clinton | Ohio | 39027 | 5964 | 100 |
1877174 | 1877174 | 2021-11-02 | Clinton | Ohio | 39027 | 5940 | 100 |
1873925 | 1873925 | 2021-11-01 | Clinton | Ohio | 39027 | 5927 | 100 |
1870676 | 1870676 | 2021-10-31 | Clinton | Ohio | 39027 | 5916 | 100 |
1867427 | 1867427 | 2021-10-30 | Clinton | Ohio | 39027 | 5910 | 100 |
1864178 | 1864178 | 2021-10-29 | Clinton | Ohio | 39027 | 5906 | 100 |
1737469 | 1737469 | 2021-09-20 | Defiance | Ohio | 39039 | 5396 | 100 |
1734219 | 1734219 | 2021-09-19 | Defiance | Ohio | 39039 | 5387 | 100 |
1730969 | 1730969 | 2021-09-18 | Defiance | Ohio | 39039 | 5361 | 100 |
1727719 | 1727719 | 2021-09-17 | Defiance | Ohio | 39039 | 5337 | 100 |
1724470 | 1724470 | 2021-09-16 | Defiance | Ohio | 39039 | 5304 | 100 |
1721221 | 1721221 | 2021-09-15 | Defiance | Ohio | 39039 | 5278 | 100 |
1717973 | 1717973 | 2021-09-14 | Defiance | Ohio | 39039 | 5242 | 100 |
1714725 | 1714725 | 2021-09-13 | Defiance | Ohio | 39039 | 5209 | 100 |
1711479 | 1711479 | 2021-09-12 | Defiance | Ohio | 39039 | 5199 | 100 |
1708232 | 1708232 | 2021-09-11 | Defiance | Ohio | 39039 | 5188 | 100 |
1704985 | 1704985 | 2021-09-10 | Defiance | Ohio | 39039 | 5171 | 100 |
1701735 | 1701735 | 2021-09-09 | Defiance | Ohio | 39039 | 5124 | 100 |
1698486 | 1698486 | 2021-09-08 | Defiance | Ohio | 39039 | 5085 | 100 |
1695238 | 1695238 | 2021-09-07 | Defiance | Ohio | 39039 | 5047 | 100 |
1691990 | 1691990 | 2021-09-06 | Defiance | Ohio | 39039 | 5038 | 100 |
1688741 | 1688741 | 2021-09-05 | Defiance | Ohio | 39039 | 5011 | 100 |
1685491 | 1685491 | 2021-09-04 | Defiance | Ohio | 39039 | 4988 | 100 |
1682240 | 1682240 | 2021-09-03 | Defiance | Ohio | 39039 | 4961 | 100 |
1678990 | 1678990 | 2021-09-02 | Defiance | Ohio | 39039 | 4926 | 100 |
1675742 | 1675742 | 2021-09-01 | Defiance | Ohio | 39039 | 4885 | 100 |
1672495 | 1672495 | 2021-08-31 | Defiance | Ohio | 39039 | 4851 | 100 |
1669247 | 1669247 | 2021-08-30 | Defiance | Ohio | 39039 | 4824 | 100 |
1666000 | 1666000 | 2021-08-29 | Defiance | Ohio | 39039 | 4814 | 100 |
1662752 | 1662752 | 2021-08-28 | Defiance | Ohio | 39039 | 4795 | 100 |
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);