ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where county = "Harrison" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176293 | 2176293 | 2022-02-02 | Harrison | Ohio | 39067 | 3131 | 66 |
2173039 | 2173039 | 2022-02-01 | Harrison | Ohio | 39067 | 3117 | 66 |
2169787 | 2169787 | 2022-01-31 | Harrison | Ohio | 39067 | 3094 | 65 |
2166532 | 2166532 | 2022-01-30 | Harrison | Ohio | 39067 | 3087 | 65 |
2163277 | 2163277 | 2022-01-29 | Harrison | Ohio | 39067 | 3083 | 65 |
2160022 | 2160022 | 2022-01-28 | Harrison | Ohio | 39067 | 3073 | 65 |
2156767 | 2156767 | 2022-01-27 | Harrison | Ohio | 39067 | 3062 | 63 |
2153514 | 2153514 | 2022-01-26 | Harrison | Ohio | 39067 | 3036 | 63 |
2150262 | 2150262 | 2022-01-25 | Harrison | Ohio | 39067 | 3005 | 63 |
2147010 | 2147010 | 2022-01-24 | Harrison | Ohio | 39067 | 2991 | 62 |
2143756 | 2143756 | 2022-01-23 | Harrison | Ohio | 39067 | 2974 | 62 |
2140501 | 2140501 | 2022-01-22 | Harrison | Ohio | 39067 | 2963 | 62 |
2137245 | 2137245 | 2022-01-21 | Harrison | Ohio | 39067 | 2922 | 62 |
2133991 | 2133991 | 2022-01-20 | Harrison | Ohio | 39067 | 2879 | 61 |
2130739 | 2130739 | 2022-01-19 | Harrison | Ohio | 39067 | 2844 | 61 |
2127485 | 2127485 | 2022-01-18 | Harrison | Ohio | 39067 | 2813 | 61 |
2124233 | 2124233 | 2022-01-17 | Harrison | Ohio | 39067 | 2794 | 61 |
2120981 | 2120981 | 2022-01-16 | Harrison | Ohio | 39067 | 2781 | 61 |
2117729 | 2117729 | 2022-01-15 | Harrison | Ohio | 39067 | 2759 | 61 |
2114478 | 2114478 | 2022-01-14 | Harrison | Ohio | 39067 | 2700 | 61 |
2111226 | 2111226 | 2022-01-13 | Harrison | Ohio | 39067 | 2657 | 60 |
2107974 | 2107974 | 2022-01-12 | Harrison | Ohio | 39067 | 2629 | 60 |
2104723 | 2104723 | 2022-01-11 | Harrison | Ohio | 39067 | 2608 | 60 |
2101472 | 2101472 | 2022-01-10 | Harrison | Ohio | 39067 | 2593 | 60 |
2098221 | 2098221 | 2022-01-09 | Harrison | Ohio | 39067 | 2582 | 60 |
2094969 | 2094969 | 2022-01-08 | Harrison | Ohio | 39067 | 2573 | 60 |
2091717 | 2091717 | 2022-01-07 | Harrison | Ohio | 39067 | 2560 | 60 |
2088465 | 2088465 | 2022-01-06 | Harrison | Ohio | 39067 | 2538 | 60 |
2085214 | 2085214 | 2022-01-05 | Harrison | Ohio | 39067 | 2527 | 60 |
2081962 | 2081962 | 2022-01-04 | Harrison | Ohio | 39067 | 2499 | 60 |
2078710 | 2078710 | 2022-01-03 | Harrison | Ohio | 39067 | 2479 | 58 |
2075459 | 2075459 | 2022-01-02 | Harrison | Ohio | 39067 | 2466 | 58 |
2072208 | 2072208 | 2022-01-01 | Harrison | Ohio | 39067 | 2444 | 58 |
2068957 | 2068957 | 2021-12-31 | Harrison | Ohio | 39067 | 2444 | 58 |
2065706 | 2065706 | 2021-12-30 | Harrison | Ohio | 39067 | 2420 | 58 |
2062456 | 2062456 | 2021-12-29 | Harrison | Ohio | 39067 | 2391 | 58 |
2059206 | 2059206 | 2021-12-28 | Harrison | Ohio | 39067 | 2372 | 58 |
2055957 | 2055957 | 2021-12-27 | Harrison | Ohio | 39067 | 2365 | 58 |
2052708 | 2052708 | 2021-12-26 | Harrison | Ohio | 39067 | 2362 | 58 |
2049458 | 2049458 | 2021-12-25 | Harrison | Ohio | 39067 | 2350 | 58 |
2046208 | 2046208 | 2021-12-24 | Harrison | Ohio | 39067 | 2350 | 58 |
2042958 | 2042958 | 2021-12-23 | Harrison | Ohio | 39067 | 2334 | 54 |
2039709 | 2039709 | 2021-12-22 | Harrison | Ohio | 39067 | 2326 | 54 |
2036459 | 2036459 | 2021-12-21 | Harrison | Ohio | 39067 | 2311 | 54 |
2033209 | 2033209 | 2021-12-20 | Harrison | Ohio | 39067 | 2302 | 54 |
2029959 | 2029959 | 2021-12-19 | Harrison | Ohio | 39067 | 2292 | 54 |
2026708 | 2026708 | 2021-12-18 | Harrison | Ohio | 39067 | 2285 | 54 |
2023457 | 2023457 | 2021-12-17 | Harrison | Ohio | 39067 | 2272 | 54 |
2020206 | 2020206 | 2021-12-16 | Harrison | Ohio | 39067 | 2261 | 54 |
2016955 | 2016955 | 2021-12-15 | Harrison | Ohio | 39067 | 2258 | 54 |
2013705 | 2013705 | 2021-12-14 | Harrison | Ohio | 39067 | 2252 | 54 |
2010454 | 2010454 | 2021-12-13 | Harrison | Ohio | 39067 | 2242 | 54 |
2007203 | 2007203 | 2021-12-12 | Harrison | Ohio | 39067 | 2229 | 54 |
2003952 | 2003952 | 2021-12-11 | Harrison | Ohio | 39067 | 2228 | 54 |
2000701 | 2000701 | 2021-12-10 | Harrison | Ohio | 39067 | 2217 | 54 |
1997451 | 1997451 | 2021-12-09 | Harrison | Ohio | 39067 | 2206 | 54 |
1994200 | 1994200 | 2021-12-08 | Harrison | Ohio | 39067 | 2199 | 54 |
1990949 | 1990949 | 2021-12-07 | Harrison | Ohio | 39067 | 2178 | 54 |
1987698 | 1987698 | 2021-12-06 | Harrison | Ohio | 39067 | 2169 | 53 |
1984448 | 1984448 | 2021-12-05 | Harrison | Ohio | 39067 | 2152 | 53 |
1981198 | 1981198 | 2021-12-04 | Harrison | Ohio | 39067 | 2146 | 53 |
1977948 | 1977948 | 2021-12-03 | Harrison | Ohio | 39067 | 2131 | 53 |
1974698 | 1974698 | 2021-12-02 | Harrison | Ohio | 39067 | 2109 | 53 |
1971449 | 1971449 | 2021-12-01 | Harrison | Ohio | 39067 | 2090 | 53 |
1968199 | 1968199 | 2021-11-30 | Harrison | Ohio | 39067 | 2069 | 53 |
1964948 | 1964948 | 2021-11-29 | Harrison | Ohio | 39067 | 2051 | 52 |
1961696 | 1961696 | 2021-11-28 | Harrison | Ohio | 39067 | 2046 | 52 |
1958445 | 1958445 | 2021-11-27 | Harrison | Ohio | 39067 | 2040 | 52 |
1955194 | 1955194 | 2021-11-26 | Harrison | Ohio | 39067 | 2035 | 52 |
1951943 | 1951943 | 2021-11-25 | Harrison | Ohio | 39067 | 2025 | 51 |
1948692 | 1948692 | 2021-11-24 | Harrison | Ohio | 39067 | 2025 | 51 |
1945441 | 1945441 | 2021-11-23 | Harrison | Ohio | 39067 | 2010 | 51 |
1942190 | 1942190 | 2021-11-22 | Harrison | Ohio | 39067 | 2002 | 50 |
1938940 | 1938940 | 2021-11-21 | Harrison | Ohio | 39067 | 2000 | 50 |
1935690 | 1935690 | 2021-11-20 | Harrison | Ohio | 39067 | 1987 | 50 |
1932440 | 1932440 | 2021-11-19 | Harrison | Ohio | 39067 | 1980 | 50 |
1929189 | 1929189 | 2021-11-18 | Harrison | Ohio | 39067 | 1971 | 49 |
1925939 | 1925939 | 2021-11-17 | Harrison | Ohio | 39067 | 1964 | 49 |
1922689 | 1922689 | 2021-11-16 | Harrison | Ohio | 39067 | 1957 | 49 |
1919440 | 1919440 | 2021-11-15 | Harrison | Ohio | 39067 | 1942 | 49 |
1916190 | 1916190 | 2021-11-14 | Harrison | Ohio | 39067 | 1942 | 49 |
1912940 | 1912940 | 2021-11-13 | Harrison | Ohio | 39067 | 1938 | 49 |
1909690 | 1909690 | 2021-11-12 | Harrison | Ohio | 39067 | 1934 | 49 |
1906441 | 1906441 | 2021-11-11 | Harrison | Ohio | 39067 | 1927 | 49 |
1903192 | 1903192 | 2021-11-10 | Harrison | Ohio | 39067 | 1919 | 49 |
1899942 | 1899942 | 2021-11-09 | Harrison | Ohio | 39067 | 1907 | 49 |
1896692 | 1896692 | 2021-11-08 | Harrison | Ohio | 39067 | 1897 | 48 |
1893442 | 1893442 | 2021-11-07 | Harrison | Ohio | 39067 | 1894 | 48 |
1890192 | 1890192 | 2021-11-06 | Harrison | Ohio | 39067 | 1891 | 48 |
1886942 | 1886942 | 2021-11-05 | Harrison | Ohio | 39067 | 1885 | 48 |
1883692 | 1883692 | 2021-11-04 | Harrison | Ohio | 39067 | 1878 | 48 |
1880443 | 1880443 | 2021-11-03 | Harrison | Ohio | 39067 | 1873 | 48 |
1877194 | 1877194 | 2021-11-02 | Harrison | Ohio | 39067 | 1867 | 48 |
1873945 | 1873945 | 2021-11-01 | Harrison | Ohio | 39067 | 1861 | 47 |
1870696 | 1870696 | 2021-10-31 | Harrison | Ohio | 39067 | 1855 | 47 |
1867447 | 1867447 | 2021-10-30 | Harrison | Ohio | 39067 | 1853 | 47 |
1864198 | 1864198 | 2021-10-29 | Harrison | Ohio | 39067 | 1848 | 47 |
1860949 | 1860949 | 2021-10-28 | Harrison | Ohio | 39067 | 1843 | 47 |
1857700 | 1857700 | 2021-10-27 | Harrison | Ohio | 39067 | 1837 | 47 |
1854451 | 1854451 | 2021-10-26 | Harrison | Ohio | 39067 | 1832 | 47 |
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);