ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
288 rows where deaths = 81 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 |
---|---|---|---|---|---|---|---|
2404004 | 2404004 | 2022-04-13 | Monroe | Ohio | 39111 | 3471 | 81 |
2400749 | 2400749 | 2022-04-12 | Monroe | Ohio | 39111 | 3471 | 81 |
2397494 | 2397494 | 2022-04-11 | Monroe | Ohio | 39111 | 3471 | 81 |
2394239 | 2394239 | 2022-04-10 | Monroe | Ohio | 39111 | 3471 | 81 |
2390983 | 2390983 | 2022-04-09 | Monroe | Ohio | 39111 | 3471 | 81 |
2387727 | 2387727 | 2022-04-08 | Monroe | Ohio | 39111 | 3471 | 81 |
2384472 | 2384472 | 2022-04-07 | Monroe | Ohio | 39111 | 3471 | 81 |
2381217 | 2381217 | 2022-04-06 | Monroe | Ohio | 39111 | 3469 | 81 |
2377962 | 2377962 | 2022-04-05 | Monroe | Ohio | 39111 | 3469 | 81 |
2374708 | 2374708 | 2022-04-04 | Monroe | Ohio | 39111 | 3469 | 81 |
2371456 | 2371456 | 2022-04-03 | Monroe | Ohio | 39111 | 3469 | 81 |
2368203 | 2368203 | 2022-04-02 | Monroe | Ohio | 39111 | 3469 | 81 |
2364950 | 2364950 | 2022-04-01 | Monroe | Ohio | 39111 | 3469 | 81 |
2361697 | 2361697 | 2022-03-31 | Monroe | Ohio | 39111 | 3469 | 81 |
2358443 | 2358443 | 2022-03-30 | Monroe | Ohio | 39111 | 3466 | 81 |
2355189 | 2355189 | 2022-03-29 | Monroe | Ohio | 39111 | 3466 | 81 |
2351936 | 2351936 | 2022-03-28 | Monroe | Ohio | 39111 | 3466 | 81 |
2348684 | 2348684 | 2022-03-27 | Monroe | Ohio | 39111 | 3466 | 81 |
2345431 | 2345431 | 2022-03-26 | Monroe | Ohio | 39111 | 3466 | 81 |
2342178 | 2342178 | 2022-03-25 | Monroe | Ohio | 39111 | 3466 | 81 |
2338925 | 2338925 | 2022-03-24 | Monroe | Ohio | 39111 | 3466 | 81 |
2101518 | 2101518 | 2022-01-10 | Union | Ohio | 39159 | 11904 | 81 |
2098267 | 2098267 | 2022-01-09 | Union | Ohio | 39159 | 11803 | 81 |
2095015 | 2095015 | 2022-01-08 | Union | Ohio | 39159 | 11678 | 81 |
2091763 | 2091763 | 2022-01-07 | Union | Ohio | 39159 | 11586 | 81 |
2088511 | 2088511 | 2022-01-06 | Union | Ohio | 39159 | 11458 | 81 |
2085260 | 2085260 | 2022-01-05 | Union | Ohio | 39159 | 11329 | 81 |
2082008 | 2082008 | 2022-01-04 | Union | Ohio | 39159 | 11175 | 81 |
2078742 | 2078742 | 2022-01-03 | Pike | Ohio | 39131 | 5192 | 81 |
2078756 | 2078756 | 2022-01-03 | Union | Ohio | 39159 | 11068 | 81 |
2075491 | 2075491 | 2022-01-02 | Pike | Ohio | 39131 | 5133 | 81 |
2075505 | 2075505 | 2022-01-02 | Union | Ohio | 39159 | 11003 | 81 |
2072240 | 2072240 | 2022-01-01 | Pike | Ohio | 39131 | 5096 | 81 |
2072254 | 2072254 | 2022-01-01 | Union | Ohio | 39159 | 10864 | 81 |
2068989 | 2068989 | 2021-12-31 | Pike | Ohio | 39131 | 5096 | 81 |
2069003 | 2069003 | 2021-12-31 | Union | Ohio | 39159 | 10864 | 81 |
2065738 | 2065738 | 2021-12-30 | Pike | Ohio | 39131 | 5057 | 81 |
2065761 | 2065761 | 2021-12-30 | Wyandot | Ohio | 39175 | 4162 | 81 |
2062488 | 2062488 | 2021-12-29 | Pike | Ohio | 39131 | 5019 | 81 |
2062511 | 2062511 | 2021-12-29 | Wyandot | Ohio | 39175 | 4139 | 81 |
2059238 | 2059238 | 2021-12-28 | Pike | Ohio | 39131 | 4997 | 81 |
2059261 | 2059261 | 2021-12-28 | Wyandot | Ohio | 39175 | 4117 | 81 |
2055989 | 2055989 | 2021-12-27 | Pike | Ohio | 39131 | 4984 | 81 |
2056012 | 2056012 | 2021-12-27 | Wyandot | Ohio | 39175 | 4099 | 81 |
2052740 | 2052740 | 2021-12-26 | Pike | Ohio | 39131 | 4970 | 81 |
2052763 | 2052763 | 2021-12-26 | Wyandot | Ohio | 39175 | 4099 | 81 |
2049490 | 2049490 | 2021-12-25 | Pike | Ohio | 39131 | 4948 | 81 |
2049513 | 2049513 | 2021-12-25 | Wyandot | Ohio | 39175 | 4095 | 81 |
2046240 | 2046240 | 2021-12-24 | Pike | Ohio | 39131 | 4948 | 81 |
2046263 | 2046263 | 2021-12-24 | Wyandot | Ohio | 39175 | 4095 | 81 |
2042951 | 2042951 | 2021-12-23 | Gallia | Ohio | 39053 | 5058 | 81 |
2039702 | 2039702 | 2021-12-22 | Gallia | Ohio | 39053 | 5036 | 81 |
2036452 | 2036452 | 2021-12-21 | Gallia | Ohio | 39053 | 5008 | 81 |
2033202 | 2033202 | 2021-12-20 | Gallia | Ohio | 39053 | 4990 | 81 |
2029952 | 2029952 | 2021-12-19 | Gallia | Ohio | 39053 | 4987 | 81 |
2026701 | 2026701 | 2021-12-18 | Gallia | Ohio | 39053 | 4980 | 81 |
2023450 | 2023450 | 2021-12-17 | Gallia | Ohio | 39053 | 4963 | 81 |
2020207 | 2020207 | 2021-12-16 | Henry | Ohio | 39069 | 4591 | 81 |
2016956 | 2016956 | 2021-12-15 | Henry | Ohio | 39069 | 4570 | 81 |
2013706 | 2013706 | 2021-12-14 | Henry | Ohio | 39069 | 4550 | 81 |
2010455 | 2010455 | 2021-12-13 | Henry | Ohio | 39069 | 4530 | 81 |
2007204 | 2007204 | 2021-12-12 | Henry | Ohio | 39069 | 4528 | 81 |
2003953 | 2003953 | 2021-12-11 | Henry | Ohio | 39069 | 4520 | 81 |
2000702 | 2000702 | 2021-12-10 | Henry | Ohio | 39069 | 4504 | 81 |
1997481 | 1997481 | 2021-12-09 | Perry | Ohio | 39127 | 5774 | 81 |
1994230 | 1994230 | 2021-12-08 | Perry | Ohio | 39127 | 5755 | 81 |
1990979 | 1990979 | 2021-12-07 | Perry | Ohio | 39127 | 5734 | 81 |
1929185 | 1929185 | 2021-11-18 | Guernsey | Ohio | 39059 | 6602 | 81 |
1925935 | 1925935 | 2021-11-17 | Guernsey | Ohio | 39059 | 6549 | 81 |
1922685 | 1922685 | 2021-11-16 | Guernsey | Ohio | 39059 | 6527 | 81 |
1919417 | 1919417 | 2021-11-15 | Champaign | Ohio | 39021 | 5453 | 81 |
1916167 | 1916167 | 2021-11-14 | Champaign | Ohio | 39021 | 5440 | 81 |
1912917 | 1912917 | 2021-11-13 | Champaign | Ohio | 39021 | 5438 | 81 |
1909667 | 1909667 | 2021-11-12 | Champaign | Ohio | 39021 | 5420 | 81 |
1815434 | 1815434 | 2021-10-14 | Brown | Ohio | 39015 | 6248 | 81 |
1812186 | 1812186 | 2021-10-13 | Brown | Ohio | 39015 | 6223 | 81 |
1808937 | 1808937 | 2021-10-12 | Brown | Ohio | 39015 | 6197 | 81 |
1792683 | 1792683 | 2021-10-07 | Adams | Ohio | 39001 | 3965 | 81 |
1789434 | 1789434 | 2021-10-06 | Adams | Ohio | 39001 | 3948 | 81 |
1786186 | 1786186 | 2021-10-05 | Adams | Ohio | 39001 | 3925 | 81 |
1760204 | 1760204 | 2021-09-27 | Clinton | Ohio | 39027 | 5376 | 81 |
1756956 | 1756956 | 2021-09-26 | Clinton | Ohio | 39027 | 5357 | 81 |
1753708 | 1753708 | 2021-09-25 | Clinton | Ohio | 39027 | 5337 | 81 |
1750460 | 1750460 | 2021-09-24 | Clinton | Ohio | 39027 | 5320 | 81 |
1747232 | 1747232 | 2021-09-23 | Highland | Ohio | 39071 | 5450 | 81 |
1743983 | 1743983 | 2021-09-22 | Highland | Ohio | 39071 | 5415 | 81 |
1740734 | 1740734 | 2021-09-21 | Highland | Ohio | 39071 | 5382 | 81 |
1737485 | 1737485 | 2021-09-20 | Highland | Ohio | 39071 | 5325 | 81 |
1737536 | 1737536 | 2021-09-20 | Williams | Ohio | 39171 | 4515 | 81 |
1734235 | 1734235 | 2021-09-19 | Highland | Ohio | 39071 | 5307 | 81 |
1734286 | 1734286 | 2021-09-19 | Williams | Ohio | 39171 | 4497 | 81 |
1730985 | 1730985 | 2021-09-18 | Highland | Ohio | 39071 | 5275 | 81 |
1731036 | 1731036 | 2021-09-18 | Williams | Ohio | 39171 | 4482 | 81 |
1727735 | 1727735 | 2021-09-17 | Highland | Ohio | 39071 | 5244 | 81 |
1727786 | 1727786 | 2021-09-17 | Williams | Ohio | 39171 | 4447 | 81 |
1724476 | 1724476 | 2021-09-16 | Fulton | Ohio | 39051 | 5132 | 81 |
1724537 | 1724537 | 2021-09-16 | Williams | Ohio | 39171 | 4401 | 81 |
1721227 | 1721227 | 2021-09-15 | Fulton | Ohio | 39051 | 5087 | 81 |
1721288 | 1721288 | 2021-09-15 | Williams | Ohio | 39171 | 4372 | 81 |
1717979 | 1717979 | 2021-09-14 | Fulton | Ohio | 39051 | 5059 | 81 |
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);