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 |
---|---|---|---|---|---|---|---|
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 |
1851199 | 1851199 | 2021-10-25 | Hamilton | Ohio | 39061 | 105605 | 1431 |
1847949 | 1847949 | 2021-10-24 | Hamilton | Ohio | 39061 | 105489 | 1431 |
1844699 | 1844699 | 2021-10-23 | Hamilton | Ohio | 39061 | 105366 | 1431 |
1841449 | 1841449 | 2021-10-22 | Hamilton | Ohio | 39061 | 105206 | 1431 |
1838200 | 1838200 | 2021-10-21 | Hamilton | Ohio | 39061 | 105042 | 1416 |
1834951 | 1834951 | 2021-10-20 | Hamilton | Ohio | 39061 | 104869 | 1416 |
1831702 | 1831702 | 2021-10-19 | Hamilton | Ohio | 39061 | 104626 | 1416 |
1828453 | 1828453 | 2021-10-18 | Hamilton | Ohio | 39061 | 104476 | 1409 |
1825204 | 1825204 | 2021-10-17 | Hamilton | Ohio | 39061 | 104360 | 1409 |
1821955 | 1821955 | 2021-10-16 | Hamilton | Ohio | 39061 | 104229 | 1409 |
1818706 | 1818706 | 2021-10-15 | Hamilton | Ohio | 39061 | 104030 | 1409 |
1815457 | 1815457 | 2021-10-14 | Hamilton | Ohio | 39061 | 103798 | 1388 |
1812209 | 1812209 | 2021-10-13 | Hamilton | Ohio | 39061 | 103546 | 1388 |
1808960 | 1808960 | 2021-10-12 | Hamilton | Ohio | 39061 | 103275 | 1388 |
1805710 | 1805710 | 2021-10-11 | Hamilton | Ohio | 39061 | 103118 | 1379 |
1802460 | 1802460 | 2021-10-10 | Hamilton | Ohio | 39061 | 102982 | 1379 |
1799211 | 1799211 | 2021-10-09 | Hamilton | Ohio | 39061 | 102702 | 1379 |
1795962 | 1795962 | 2021-10-08 | Hamilton | Ohio | 39061 | 102541 | 1379 |
1792713 | 1792713 | 2021-10-07 | Hamilton | Ohio | 39061 | 102238 | 1359 |
1789464 | 1789464 | 2021-10-06 | Hamilton | Ohio | 39061 | 101908 | 1359 |
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);