ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
162 rows where deaths = 116 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358453 | 2358453 | 2022-03-30 | Pike | Ohio | 39131 | 7446 | 116 |
2355199 | 2355199 | 2022-03-29 | Pike | Ohio | 39131 | 7446 | 116 |
2351946 | 2351946 | 2022-03-28 | Pike | Ohio | 39131 | 7446 | 116 |
2348694 | 2348694 | 2022-03-27 | Pike | Ohio | 39131 | 7446 | 116 |
2345441 | 2345441 | 2022-03-26 | Pike | Ohio | 39131 | 7446 | 116 |
2342188 | 2342188 | 2022-03-25 | Pike | Ohio | 39131 | 7446 | 116 |
2338935 | 2338935 | 2022-03-24 | Pike | Ohio | 39131 | 7446 | 116 |
2335639 | 2335639 | 2022-03-23 | Fayette | Ohio | 39047 | 7762 | 116 |
2332385 | 2332385 | 2022-03-22 | Fayette | Ohio | 39047 | 7762 | 116 |
2329132 | 2329132 | 2022-03-21 | Fayette | Ohio | 39047 | 7762 | 116 |
2325880 | 2325880 | 2022-03-20 | Fayette | Ohio | 39047 | 7762 | 116 |
2322627 | 2322627 | 2022-03-19 | Fayette | Ohio | 39047 | 7762 | 116 |
2319373 | 2319373 | 2022-03-18 | Fayette | Ohio | 39047 | 7762 | 116 |
2316119 | 2316119 | 2022-03-17 | Fayette | Ohio | 39047 | 7762 | 116 |
2312866 | 2312866 | 2022-03-16 | Fayette | Ohio | 39047 | 7760 | 116 |
2309613 | 2309613 | 2022-03-15 | Fayette | Ohio | 39047 | 7760 | 116 |
2306360 | 2306360 | 2022-03-14 | Fayette | Ohio | 39047 | 7760 | 116 |
2303109 | 2303109 | 2022-03-13 | Fayette | Ohio | 39047 | 7760 | 116 |
2299857 | 2299857 | 2022-03-12 | Fayette | Ohio | 39047 | 7760 | 116 |
2296605 | 2296605 | 2022-03-11 | Fayette | Ohio | 39047 | 7759 | 116 |
2293366 | 2293366 | 2022-03-10 | Hocking | Ohio | 39073 | 6585 | 116 |
2290114 | 2290114 | 2022-03-09 | Hocking | Ohio | 39073 | 6577 | 116 |
2286862 | 2286862 | 2022-03-08 | Hocking | Ohio | 39073 | 6566 | 116 |
2283600 | 2283600 | 2022-03-07 | Gallia | Ohio | 39053 | 7412 | 116 |
2280348 | 2280348 | 2022-03-06 | Gallia | Ohio | 39053 | 7408 | 116 |
2277095 | 2277095 | 2022-03-05 | Gallia | Ohio | 39053 | 7408 | 116 |
2273842 | 2273842 | 2022-03-04 | Gallia | Ohio | 39053 | 7401 | 116 |
2270589 | 2270589 | 2022-03-03 | Gallia | Ohio | 39053 | 7388 | 116 |
2267337 | 2267337 | 2022-03-02 | Gallia | Ohio | 39053 | 7382 | 116 |
2264084 | 2264084 | 2022-03-01 | Gallia | Ohio | 39053 | 7369 | 116 |
2225051 | 2225051 | 2022-02-17 | Athens | Ohio | 39009 | 14129 | 116 |
2221800 | 2221800 | 2022-02-16 | Athens | Ohio | 39009 | 14091 | 116 |
2218549 | 2218549 | 2022-02-15 | Athens | Ohio | 39009 | 14053 | 116 |
2215298 | 2215298 | 2022-02-14 | Athens | Ohio | 39009 | 14027 | 116 |
2215303 | 2215303 | 2022-02-14 | Carroll | Ohio | 39019 | 5207 | 116 |
2212047 | 2212047 | 2022-02-13 | Athens | Ohio | 39009 | 14007 | 116 |
2212052 | 2212052 | 2022-02-13 | Carroll | Ohio | 39019 | 5207 | 116 |
2208794 | 2208794 | 2022-02-12 | Athens | Ohio | 39009 | 14000 | 116 |
2208799 | 2208799 | 2022-02-12 | Carroll | Ohio | 39019 | 5207 | 116 |
2205541 | 2205541 | 2022-02-11 | Athens | Ohio | 39009 | 13920 | 116 |
2205546 | 2205546 | 2022-02-11 | Carroll | Ohio | 39019 | 5205 | 116 |
2179559 | 2179559 | 2022-02-03 | Madison | Ohio | 39097 | 9402 | 116 |
2176308 | 2176308 | 2022-02-02 | Madison | Ohio | 39097 | 9371 | 116 |
2173054 | 2173054 | 2022-02-01 | Madison | Ohio | 39097 | 9342 | 116 |
2101500 | 2101500 | 2022-01-10 | Ottawa | Ohio | 39123 | 7047 | 116 |
2098249 | 2098249 | 2022-01-09 | Ottawa | Ohio | 39123 | 7000 | 116 |
2094997 | 2094997 | 2022-01-08 | Ottawa | Ohio | 39123 | 6943 | 116 |
2091745 | 2091745 | 2022-01-07 | Ottawa | Ohio | 39123 | 6889 | 116 |
2078677 | 2078677 | 2022-01-03 | Adams | Ohio | 39001 | 5064 | 116 |
2075426 | 2075426 | 2022-01-02 | Adams | Ohio | 39001 | 5053 | 116 |
2072175 | 2072175 | 2022-01-01 | Adams | Ohio | 39001 | 5008 | 116 |
2068924 | 2068924 | 2021-12-31 | Adams | Ohio | 39001 | 5008 | 116 |
2065673 | 2065673 | 2021-12-30 | Adams | Ohio | 39001 | 4991 | 116 |
2062423 | 2062423 | 2021-12-29 | Adams | Ohio | 39001 | 4980 | 116 |
2059173 | 2059173 | 2021-12-28 | Adams | Ohio | 39001 | 4961 | 116 |
2042957 | 2042957 | 2021-12-23 | Hardin | Ohio | 39065 | 5317 | 116 |
2039708 | 2039708 | 2021-12-22 | Hardin | Ohio | 39065 | 5306 | 116 |
2036458 | 2036458 | 2021-12-21 | Hardin | Ohio | 39065 | 5283 | 116 |
2020218 | 2020218 | 2021-12-16 | Logan | Ohio | 39091 | 7426 | 116 |
2016967 | 2016967 | 2021-12-15 | Logan | Ohio | 39091 | 7392 | 116 |
2013717 | 2013717 | 2021-12-14 | Logan | Ohio | 39091 | 7353 | 116 |
2010466 | 2010466 | 2021-12-13 | Logan | Ohio | 39091 | 7322 | 116 |
2007215 | 2007215 | 2021-12-12 | Logan | Ohio | 39091 | 7307 | 116 |
2003964 | 2003964 | 2021-12-11 | Logan | Ohio | 39091 | 7293 | 116 |
2000713 | 2000713 | 2021-12-10 | Logan | Ohio | 39091 | 7239 | 116 |
1997425 | 1997425 | 2021-12-09 | Brown | Ohio | 39015 | 7350 | 116 |
1994174 | 1994174 | 2021-12-08 | Brown | Ohio | 39015 | 7300 | 116 |
1990923 | 1990923 | 2021-12-07 | Brown | Ohio | 39015 | 7261 | 116 |
1987672 | 1987672 | 2021-12-06 | Brown | Ohio | 39015 | 7225 | 116 |
1984422 | 1984422 | 2021-12-05 | Brown | Ohio | 39015 | 7217 | 116 |
1981172 | 1981172 | 2021-12-04 | Brown | Ohio | 39015 | 7197 | 116 |
1977922 | 1977922 | 2021-12-03 | Brown | Ohio | 39015 | 7173 | 116 |
1929224 | 1929224 | 2021-11-18 | Putnam | Ohio | 39137 | 5863 | 116 |
1925974 | 1925974 | 2021-11-17 | Putnam | Ohio | 39137 | 5816 | 116 |
1922724 | 1922724 | 2021-11-16 | Putnam | Ohio | 39137 | 5789 | 116 |
1919475 | 1919475 | 2021-11-15 | Putnam | Ohio | 39137 | 5755 | 116 |
1916225 | 1916225 | 2021-11-14 | Putnam | Ohio | 39137 | 5738 | 116 |
1912975 | 1912975 | 2021-11-13 | Putnam | Ohio | 39137 | 5724 | 116 |
1909725 | 1909725 | 2021-11-12 | Putnam | Ohio | 39137 | 5702 | 116 |
1737493 | 1737493 | 2021-09-20 | Lawrence | Ohio | 39087 | 8583 | 116 |
1734243 | 1734243 | 2021-09-19 | Lawrence | Ohio | 39087 | 8549 | 116 |
1730993 | 1730993 | 2021-09-18 | Lawrence | Ohio | 39087 | 8516 | 116 |
1727743 | 1727743 | 2021-09-17 | Lawrence | Ohio | 39087 | 8441 | 116 |
1724494 | 1724494 | 2021-09-16 | Lawrence | Ohio | 39087 | 8335 | 116 |
1724535 | 1724535 | 2021-09-16 | Washington | Ohio | 39167 | 6902 | 116 |
1721245 | 1721245 | 2021-09-15 | Lawrence | Ohio | 39087 | 8225 | 116 |
1721286 | 1721286 | 2021-09-15 | Washington | Ohio | 39167 | 6823 | 116 |
1717997 | 1717997 | 2021-09-14 | Lawrence | Ohio | 39087 | 8111 | 116 |
1718038 | 1718038 | 2021-09-14 | Washington | Ohio | 39167 | 6732 | 116 |
1714749 | 1714749 | 2021-09-13 | Lawrence | Ohio | 39087 | 7992 | 116 |
1714790 | 1714790 | 2021-09-13 | Washington | Ohio | 39167 | 6644 | 116 |
1711503 | 1711503 | 2021-09-12 | Lawrence | Ohio | 39087 | 7920 | 116 |
1711544 | 1711544 | 2021-09-12 | Washington | Ohio | 39167 | 6583 | 116 |
1708256 | 1708256 | 2021-09-11 | Lawrence | Ohio | 39087 | 7868 | 116 |
1708297 | 1708297 | 2021-09-11 | Washington | Ohio | 39167 | 6542 | 116 |
1705009 | 1705009 | 2021-09-10 | Lawrence | Ohio | 39087 | 7776 | 116 |
1705050 | 1705050 | 2021-09-10 | Washington | Ohio | 39167 | 6468 | 116 |
1669269 | 1669269 | 2021-08-30 | Knox | Ohio | 39083 | 5418 | 116 |
1666022 | 1666022 | 2021-08-29 | Knox | Ohio | 39083 | 5359 | 116 |
1662774 | 1662774 | 2021-08-28 | Knox | Ohio | 39083 | 5305 | 116 |
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);