ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 39097 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176308 | 2176308 | 2022-02-02 | Madison | Ohio | 39097 | 9371 | 116 |
2173054 | 2173054 | 2022-02-01 | Madison | Ohio | 39097 | 9342 | 116 |
2169802 | 2169802 | 2022-01-31 | Madison | Ohio | 39097 | 9310 | 114 |
2166547 | 2166547 | 2022-01-30 | Madison | Ohio | 39097 | 9291 | 114 |
2163292 | 2163292 | 2022-01-29 | Madison | Ohio | 39097 | 9275 | 114 |
2160037 | 2160037 | 2022-01-28 | Madison | Ohio | 39097 | 9247 | 114 |
2156782 | 2156782 | 2022-01-27 | Madison | Ohio | 39097 | 9203 | 113 |
2153529 | 2153529 | 2022-01-26 | Madison | Ohio | 39097 | 9159 | 113 |
2150277 | 2150277 | 2022-01-25 | Madison | Ohio | 39097 | 9078 | 113 |
2147025 | 2147025 | 2022-01-24 | Madison | Ohio | 39097 | 9032 | 111 |
2143771 | 2143771 | 2022-01-23 | Madison | Ohio | 39097 | 9007 | 111 |
2140516 | 2140516 | 2022-01-22 | Madison | Ohio | 39097 | 8971 | 111 |
2137260 | 2137260 | 2022-01-21 | Madison | Ohio | 39097 | 8913 | 111 |
2134006 | 2134006 | 2022-01-20 | Madison | Ohio | 39097 | 8836 | 106 |
2130754 | 2130754 | 2022-01-19 | Madison | Ohio | 39097 | 8730 | 106 |
2127500 | 2127500 | 2022-01-18 | Madison | Ohio | 39097 | 8654 | 106 |
2124248 | 2124248 | 2022-01-17 | Madison | Ohio | 39097 | 8568 | 104 |
2120996 | 2120996 | 2022-01-16 | Madison | Ohio | 39097 | 8508 | 104 |
2117744 | 2117744 | 2022-01-15 | Madison | Ohio | 39097 | 8403 | 104 |
2114493 | 2114493 | 2022-01-14 | Madison | Ohio | 39097 | 8164 | 104 |
2111241 | 2111241 | 2022-01-13 | Madison | Ohio | 39097 | 7998 | 104 |
2107989 | 2107989 | 2022-01-12 | Madison | Ohio | 39097 | 7933 | 104 |
2104738 | 2104738 | 2022-01-11 | Madison | Ohio | 39097 | 7855 | 104 |
2101487 | 2101487 | 2022-01-10 | Madison | Ohio | 39097 | 7817 | 102 |
2098236 | 2098236 | 2022-01-09 | Madison | Ohio | 39097 | 7751 | 102 |
2094984 | 2094984 | 2022-01-08 | Madison | Ohio | 39097 | 7671 | 102 |
2091732 | 2091732 | 2022-01-07 | Madison | Ohio | 39097 | 7632 | 102 |
2088480 | 2088480 | 2022-01-06 | Madison | Ohio | 39097 | 7571 | 102 |
2085229 | 2085229 | 2022-01-05 | Madison | Ohio | 39097 | 7486 | 102 |
2081977 | 2081977 | 2022-01-04 | Madison | Ohio | 39097 | 7423 | 102 |
2078725 | 2078725 | 2022-01-03 | Madison | Ohio | 39097 | 7343 | 101 |
2075474 | 2075474 | 2022-01-02 | Madison | Ohio | 39097 | 7284 | 101 |
2072223 | 2072223 | 2022-01-01 | Madison | Ohio | 39097 | 7200 | 101 |
2068972 | 2068972 | 2021-12-31 | Madison | Ohio | 39097 | 7200 | 101 |
2065721 | 2065721 | 2021-12-30 | Madison | Ohio | 39097 | 7159 | 99 |
2062471 | 2062471 | 2021-12-29 | Madison | Ohio | 39097 | 7101 | 99 |
2059221 | 2059221 | 2021-12-28 | Madison | Ohio | 39097 | 7031 | 99 |
2055972 | 2055972 | 2021-12-27 | Madison | Ohio | 39097 | 6988 | 99 |
2052723 | 2052723 | 2021-12-26 | Madison | Ohio | 39097 | 6975 | 99 |
2049473 | 2049473 | 2021-12-25 | Madison | Ohio | 39097 | 6952 | 99 |
2046223 | 2046223 | 2021-12-24 | Madison | Ohio | 39097 | 6952 | 99 |
2042973 | 2042973 | 2021-12-23 | Madison | Ohio | 39097 | 6921 | 98 |
2039724 | 2039724 | 2021-12-22 | Madison | Ohio | 39097 | 6893 | 98 |
2036474 | 2036474 | 2021-12-21 | Madison | Ohio | 39097 | 6862 | 98 |
2033224 | 2033224 | 2021-12-20 | Madison | Ohio | 39097 | 6831 | 97 |
2029974 | 2029974 | 2021-12-19 | Madison | Ohio | 39097 | 6813 | 97 |
2026723 | 2026723 | 2021-12-18 | Madison | Ohio | 39097 | 6796 | 97 |
2023472 | 2023472 | 2021-12-17 | Madison | Ohio | 39097 | 6772 | 97 |
2020221 | 2020221 | 2021-12-16 | Madison | Ohio | 39097 | 6759 | 95 |
2016970 | 2016970 | 2021-12-15 | Madison | Ohio | 39097 | 6739 | 95 |
2013720 | 2013720 | 2021-12-14 | Madison | Ohio | 39097 | 6708 | 95 |
2010469 | 2010469 | 2021-12-13 | Madison | Ohio | 39097 | 6687 | 94 |
2007218 | 2007218 | 2021-12-12 | Madison | Ohio | 39097 | 6677 | 94 |
2003967 | 2003967 | 2021-12-11 | Madison | Ohio | 39097 | 6660 | 94 |
2000716 | 2000716 | 2021-12-10 | Madison | Ohio | 39097 | 6641 | 94 |
1997466 | 1997466 | 2021-12-09 | Madison | Ohio | 39097 | 6630 | 90 |
1994215 | 1994215 | 2021-12-08 | Madison | Ohio | 39097 | 6594 | 90 |
1990964 | 1990964 | 2021-12-07 | Madison | Ohio | 39097 | 6560 | 90 |
1987713 | 1987713 | 2021-12-06 | Madison | Ohio | 39097 | 6539 | 90 |
1984463 | 1984463 | 2021-12-05 | Madison | Ohio | 39097 | 6525 | 90 |
1981213 | 1981213 | 2021-12-04 | Madison | Ohio | 39097 | 6514 | 90 |
1977963 | 1977963 | 2021-12-03 | Madison | Ohio | 39097 | 6497 | 90 |
1974713 | 1974713 | 2021-12-02 | Madison | Ohio | 39097 | 6480 | 89 |
1971464 | 1971464 | 2021-12-01 | Madison | Ohio | 39097 | 6462 | 89 |
1968214 | 1968214 | 2021-11-30 | Madison | Ohio | 39097 | 6438 | 89 |
1964963 | 1964963 | 2021-11-29 | Madison | Ohio | 39097 | 6413 | 89 |
1961711 | 1961711 | 2021-11-28 | Madison | Ohio | 39097 | 6397 | 89 |
1958460 | 1958460 | 2021-11-27 | Madison | Ohio | 39097 | 6392 | 89 |
1955209 | 1955209 | 2021-11-26 | Madison | Ohio | 39097 | 6385 | 89 |
1951958 | 1951958 | 2021-11-25 | Madison | Ohio | 39097 | 6360 | 87 |
1948707 | 1948707 | 2021-11-24 | Madison | Ohio | 39097 | 6360 | 87 |
1945456 | 1945456 | 2021-11-23 | Madison | Ohio | 39097 | 6346 | 87 |
1942205 | 1942205 | 2021-11-22 | Madison | Ohio | 39097 | 6324 | 87 |
1938955 | 1938955 | 2021-11-21 | Madison | Ohio | 39097 | 6316 | 87 |
1935705 | 1935705 | 2021-11-20 | Madison | Ohio | 39097 | 6310 | 87 |
1932455 | 1932455 | 2021-11-19 | Madison | Ohio | 39097 | 6298 | 87 |
1929204 | 1929204 | 2021-11-18 | Madison | Ohio | 39097 | 6276 | 87 |
1925954 | 1925954 | 2021-11-17 | Madison | Ohio | 39097 | 6259 | 87 |
1922704 | 1922704 | 2021-11-16 | Madison | Ohio | 39097 | 6239 | 87 |
1919455 | 1919455 | 2021-11-15 | Madison | Ohio | 39097 | 6223 | 87 |
1916205 | 1916205 | 2021-11-14 | Madison | Ohio | 39097 | 6211 | 87 |
1912955 | 1912955 | 2021-11-13 | Madison | Ohio | 39097 | 6202 | 87 |
1909705 | 1909705 | 2021-11-12 | Madison | Ohio | 39097 | 6176 | 87 |
1906456 | 1906456 | 2021-11-11 | Madison | Ohio | 39097 | 6172 | 86 |
1903207 | 1903207 | 2021-11-10 | Madison | Ohio | 39097 | 6148 | 86 |
1899957 | 1899957 | 2021-11-09 | Madison | Ohio | 39097 | 6130 | 86 |
1896707 | 1896707 | 2021-11-08 | Madison | Ohio | 39097 | 6111 | 84 |
1893457 | 1893457 | 2021-11-07 | Madison | Ohio | 39097 | 6108 | 84 |
1890207 | 1890207 | 2021-11-06 | Madison | Ohio | 39097 | 6098 | 84 |
1886957 | 1886957 | 2021-11-05 | Madison | Ohio | 39097 | 6093 | 84 |
1883707 | 1883707 | 2021-11-04 | Madison | Ohio | 39097 | 6078 | 84 |
1880458 | 1880458 | 2021-11-03 | Madison | Ohio | 39097 | 6057 | 84 |
1877209 | 1877209 | 2021-11-02 | Madison | Ohio | 39097 | 6047 | 84 |
1873960 | 1873960 | 2021-11-01 | Madison | Ohio | 39097 | 6025 | 83 |
1870711 | 1870711 | 2021-10-31 | Madison | Ohio | 39097 | 6016 | 83 |
1867462 | 1867462 | 2021-10-30 | Madison | Ohio | 39097 | 6011 | 83 |
1864213 | 1864213 | 2021-10-29 | Madison | Ohio | 39097 | 6000 | 83 |
1860964 | 1860964 | 2021-10-28 | Madison | Ohio | 39097 | 5992 | 80 |
1857715 | 1857715 | 2021-10-27 | Madison | Ohio | 39097 | 5985 | 80 |
1854466 | 1854466 | 2021-10-26 | Madison | Ohio | 39097 | 5973 | 80 |
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);