ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 39061 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176290 | 2176290 | 2022-02-02 | Hamilton | Ohio | 39061 | 181869 | 1816 |
2173036 | 2173036 | 2022-02-01 | Hamilton | Ohio | 39061 | 181261 | 1816 |
2169784 | 2169784 | 2022-01-31 | Hamilton | Ohio | 39061 | 180817 | 1791 |
2166529 | 2166529 | 2022-01-30 | Hamilton | Ohio | 39061 | 180591 | 1791 |
2163274 | 2163274 | 2022-01-29 | Hamilton | Ohio | 39061 | 180144 | 1791 |
2160019 | 2160019 | 2022-01-28 | Hamilton | Ohio | 39061 | 179456 | 1791 |
2156764 | 2156764 | 2022-01-27 | Hamilton | Ohio | 39061 | 178654 | 1767 |
2153511 | 2153511 | 2022-01-26 | Hamilton | Ohio | 39061 | 177787 | 1767 |
2150259 | 2150259 | 2022-01-25 | Hamilton | Ohio | 39061 | 176086 | 1767 |
2147007 | 2147007 | 2022-01-24 | Hamilton | Ohio | 39061 | 175809 | 1756 |
2143753 | 2143753 | 2022-01-23 | Hamilton | Ohio | 39061 | 175147 | 1756 |
2140498 | 2140498 | 2022-01-22 | Hamilton | Ohio | 39061 | 174264 | 1756 |
2137242 | 2137242 | 2022-01-21 | Hamilton | Ohio | 39061 | 172998 | 1756 |
2133988 | 2133988 | 2022-01-20 | Hamilton | Ohio | 39061 | 171129 | 1714 |
2130736 | 2130736 | 2022-01-19 | Hamilton | Ohio | 39061 | 169609 | 1714 |
2127482 | 2127482 | 2022-01-18 | Hamilton | Ohio | 39061 | 167931 | 1714 |
2124230 | 2124230 | 2022-01-17 | Hamilton | Ohio | 39061 | 166671 | 1699 |
2120978 | 2120978 | 2022-01-16 | Hamilton | Ohio | 39061 | 164741 | 1699 |
2117726 | 2117726 | 2022-01-15 | Hamilton | Ohio | 39061 | 162442 | 1699 |
2114475 | 2114475 | 2022-01-14 | Hamilton | Ohio | 39061 | 157950 | 1699 |
2111223 | 2111223 | 2022-01-13 | Hamilton | Ohio | 39061 | 154415 | 1684 |
2107971 | 2107971 | 2022-01-12 | Hamilton | Ohio | 39061 | 152652 | 1684 |
2104720 | 2104720 | 2022-01-11 | Hamilton | Ohio | 39061 | 151013 | 1684 |
2101469 | 2101469 | 2022-01-10 | Hamilton | Ohio | 39061 | 148833 | 1677 |
2098218 | 2098218 | 2022-01-09 | Hamilton | Ohio | 39061 | 147629 | 1677 |
2094966 | 2094966 | 2022-01-08 | Hamilton | Ohio | 39061 | 145454 | 1677 |
2091714 | 2091714 | 2022-01-07 | Hamilton | Ohio | 39061 | 143634 | 1677 |
2088462 | 2088462 | 2022-01-06 | Hamilton | Ohio | 39061 | 141626 | 1653 |
2085211 | 2085211 | 2022-01-05 | Hamilton | Ohio | 39061 | 139752 | 1653 |
2081959 | 2081959 | 2022-01-04 | Hamilton | Ohio | 39061 | 137991 | 1653 |
2078707 | 2078707 | 2022-01-03 | Hamilton | Ohio | 39061 | 136370 | 1649 |
2075456 | 2075456 | 2022-01-02 | Hamilton | Ohio | 39061 | 134814 | 1649 |
2072205 | 2072205 | 2022-01-01 | Hamilton | Ohio | 39061 | 131890 | 1649 |
2068954 | 2068954 | 2021-12-31 | Hamilton | Ohio | 39061 | 131890 | 1649 |
2065703 | 2065703 | 2021-12-30 | Hamilton | Ohio | 39061 | 130284 | 1637 |
2062453 | 2062453 | 2021-12-29 | Hamilton | Ohio | 39061 | 128424 | 1637 |
2059203 | 2059203 | 2021-12-28 | Hamilton | Ohio | 39061 | 127091 | 1637 |
2055954 | 2055954 | 2021-12-27 | Hamilton | Ohio | 39061 | 125738 | 1624 |
2052705 | 2052705 | 2021-12-26 | Hamilton | Ohio | 39061 | 125029 | 1624 |
2049455 | 2049455 | 2021-12-25 | Hamilton | Ohio | 39061 | 124055 | 1624 |
2046205 | 2046205 | 2021-12-24 | Hamilton | Ohio | 39061 | 124055 | 1624 |
2042955 | 2042955 | 2021-12-23 | Hamilton | Ohio | 39061 | 123377 | 1603 |
2039706 | 2039706 | 2021-12-22 | Hamilton | Ohio | 39061 | 122529 | 1603 |
2036456 | 2036456 | 2021-12-21 | Hamilton | Ohio | 39061 | 121972 | 1603 |
2033206 | 2033206 | 2021-12-20 | Hamilton | Ohio | 39061 | 121537 | 1597 |
2029956 | 2029956 | 2021-12-19 | Hamilton | Ohio | 39061 | 121171 | 1597 |
2026705 | 2026705 | 2021-12-18 | Hamilton | Ohio | 39061 | 120875 | 1597 |
2023454 | 2023454 | 2021-12-17 | Hamilton | Ohio | 39061 | 120481 | 1597 |
2020203 | 2020203 | 2021-12-16 | Hamilton | Ohio | 39061 | 120052 | 1573 |
2016952 | 2016952 | 2021-12-15 | Hamilton | Ohio | 39061 | 118872 | 1573 |
2013702 | 2013702 | 2021-12-14 | Hamilton | Ohio | 39061 | 118417 | 1573 |
2010451 | 2010451 | 2021-12-13 | Hamilton | Ohio | 39061 | 117103 | 1559 |
2007200 | 2007200 | 2021-12-12 | Hamilton | Ohio | 39061 | 116790 | 1559 |
2003949 | 2003949 | 2021-12-11 | Hamilton | Ohio | 39061 | 116608 | 1559 |
2000698 | 2000698 | 2021-12-10 | Hamilton | Ohio | 39061 | 116183 | 1559 |
1997448 | 1997448 | 2021-12-09 | Hamilton | Ohio | 39061 | 115850 | 1549 |
1994197 | 1994197 | 2021-12-08 | Hamilton | Ohio | 39061 | 115465 | 1549 |
1990946 | 1990946 | 2021-12-07 | Hamilton | Ohio | 39061 | 114988 | 1549 |
1987695 | 1987695 | 2021-12-06 | Hamilton | Ohio | 39061 | 114644 | 1544 |
1984445 | 1984445 | 2021-12-05 | Hamilton | Ohio | 39061 | 114437 | 1544 |
1981195 | 1981195 | 2021-12-04 | Hamilton | Ohio | 39061 | 114154 | 1544 |
1977945 | 1977945 | 2021-12-03 | Hamilton | Ohio | 39061 | 113772 | 1544 |
1974695 | 1974695 | 2021-12-02 | Hamilton | Ohio | 39061 | 113285 | 1528 |
1971446 | 1971446 | 2021-12-01 | Hamilton | Ohio | 39061 | 112892 | 1528 |
1968196 | 1968196 | 2021-11-30 | Hamilton | Ohio | 39061 | 112539 | 1528 |
1964945 | 1964945 | 2021-11-29 | Hamilton | Ohio | 39061 | 112264 | 1528 |
1961693 | 1961693 | 2021-11-28 | Hamilton | Ohio | 39061 | 112032 | 1528 |
1958442 | 1958442 | 2021-11-27 | Hamilton | Ohio | 39061 | 111874 | 1528 |
1955191 | 1955191 | 2021-11-26 | Hamilton | Ohio | 39061 | 111731 | 1528 |
1951940 | 1951940 | 2021-11-25 | Hamilton | Ohio | 39061 | 111309 | 1514 |
1948689 | 1948689 | 2021-11-24 | Hamilton | Ohio | 39061 | 111309 | 1514 |
1945438 | 1945438 | 2021-11-23 | Hamilton | Ohio | 39061 | 111034 | 1514 |
1942187 | 1942187 | 2021-11-22 | Hamilton | Ohio | 39061 | 110791 | 1504 |
1938937 | 1938937 | 2021-11-21 | Hamilton | Ohio | 39061 | 110637 | 1504 |
1935687 | 1935687 | 2021-11-20 | Hamilton | Ohio | 39061 | 110497 | 1504 |
1932437 | 1932437 | 2021-11-19 | Hamilton | Ohio | 39061 | 110262 | 1504 |
1929186 | 1929186 | 2021-11-18 | Hamilton | Ohio | 39061 | 109978 | 1495 |
1925936 | 1925936 | 2021-11-17 | Hamilton | Ohio | 39061 | 109699 | 1495 |
1922686 | 1922686 | 2021-11-16 | Hamilton | Ohio | 39061 | 109404 | 1495 |
1919437 | 1919437 | 2021-11-15 | Hamilton | Ohio | 39061 | 109220 | 1493 |
1916187 | 1916187 | 2021-11-14 | Hamilton | Ohio | 39061 | 109052 | 1493 |
1912937 | 1912937 | 2021-11-13 | Hamilton | Ohio | 39061 | 108892 | 1493 |
1909687 | 1909687 | 2021-11-12 | Hamilton | Ohio | 39061 | 108716 | 1493 |
1906438 | 1906438 | 2021-11-11 | Hamilton | Ohio | 39061 | 108456 | 1483 |
1903189 | 1903189 | 2021-11-10 | Hamilton | Ohio | 39061 | 108240 | 1483 |
1899939 | 1899939 | 2021-11-09 | Hamilton | Ohio | 39061 | 108024 | 1483 |
1896689 | 1896689 | 2021-11-08 | Hamilton | Ohio | 39061 | 107870 | 1475 |
1893439 | 1893439 | 2021-11-07 | Hamilton | Ohio | 39061 | 107738 | 1475 |
1890189 | 1890189 | 2021-11-06 | Hamilton | Ohio | 39061 | 107514 | 1475 |
1886939 | 1886939 | 2021-11-05 | Hamilton | Ohio | 39061 | 107367 | 1475 |
1883689 | 1883689 | 2021-11-04 | Hamilton | Ohio | 39061 | 107158 | 1460 |
1880440 | 1880440 | 2021-11-03 | Hamilton | Ohio | 39061 | 106962 | 1460 |
1877191 | 1877191 | 2021-11-02 | Hamilton | Ohio | 39061 | 106773 | 1460 |
1873942 | 1873942 | 2021-11-01 | Hamilton | Ohio | 39061 | 106631 | 1450 |
1870693 | 1870693 | 2021-10-31 | Hamilton | Ohio | 39061 | 106518 | 1450 |
1867444 | 1867444 | 2021-10-30 | Hamilton | Ohio | 39061 | 106385 | 1450 |
1864195 | 1864195 | 2021-10-29 | Hamilton | Ohio | 39061 | 106239 | 1450 |
1860946 | 1860946 | 2021-10-28 | Hamilton | Ohio | 39061 | 106083 | 1433 |
1857697 | 1857697 | 2021-10-27 | Hamilton | Ohio | 39061 | 105888 | 1433 |
1854448 | 1854448 | 2021-10-26 | Hamilton | Ohio | 39061 | 105744 | 1433 |
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);