ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39041 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176280 | 2176280 | 2022-02-02 | Delaware | Ohio | 39041 | 42927 | 234 |
2173026 | 2173026 | 2022-02-01 | Delaware | Ohio | 39041 | 42697 | 234 |
2169774 | 2169774 | 2022-01-31 | Delaware | Ohio | 39041 | 42549 | 231 |
2166519 | 2166519 | 2022-01-30 | Delaware | Ohio | 39041 | 42463 | 231 |
2163264 | 2163264 | 2022-01-29 | Delaware | Ohio | 39041 | 42326 | 231 |
2160009 | 2160009 | 2022-01-28 | Delaware | Ohio | 39041 | 42141 | 231 |
2156754 | 2156754 | 2022-01-27 | Delaware | Ohio | 39041 | 41905 | 226 |
2153501 | 2153501 | 2022-01-26 | Delaware | Ohio | 39041 | 41641 | 226 |
2150249 | 2150249 | 2022-01-25 | Delaware | Ohio | 39041 | 41187 | 226 |
2146997 | 2146997 | 2022-01-24 | Delaware | Ohio | 39041 | 41107 | 220 |
2143743 | 2143743 | 2022-01-23 | Delaware | Ohio | 39041 | 40869 | 220 |
2140488 | 2140488 | 2022-01-22 | Delaware | Ohio | 39041 | 40674 | 220 |
2137232 | 2137232 | 2022-01-21 | Delaware | Ohio | 39041 | 40380 | 220 |
2133978 | 2133978 | 2022-01-20 | Delaware | Ohio | 39041 | 40037 | 212 |
2130726 | 2130726 | 2022-01-19 | Delaware | Ohio | 39041 | 39611 | 212 |
2127472 | 2127472 | 2022-01-18 | Delaware | Ohio | 39041 | 39138 | 212 |
2124220 | 2124220 | 2022-01-17 | Delaware | Ohio | 39041 | 38876 | 210 |
2120968 | 2120968 | 2022-01-16 | Delaware | Ohio | 39041 | 38537 | 210 |
2117716 | 2117716 | 2022-01-15 | Delaware | Ohio | 39041 | 38020 | 210 |
2114465 | 2114465 | 2022-01-14 | Delaware | Ohio | 39041 | 37006 | 210 |
2111213 | 2111213 | 2022-01-13 | Delaware | Ohio | 39041 | 36160 | 206 |
2107961 | 2107961 | 2022-01-12 | Delaware | Ohio | 39041 | 35787 | 206 |
2104710 | 2104710 | 2022-01-11 | Delaware | Ohio | 39041 | 35378 | 206 |
2101459 | 2101459 | 2022-01-10 | Delaware | Ohio | 39041 | 35019 | 200 |
2098208 | 2098208 | 2022-01-09 | Delaware | Ohio | 39041 | 34550 | 200 |
2094956 | 2094956 | 2022-01-08 | Delaware | Ohio | 39041 | 34241 | 200 |
2091704 | 2091704 | 2022-01-07 | Delaware | Ohio | 39041 | 33967 | 200 |
2088452 | 2088452 | 2022-01-06 | Delaware | Ohio | 39041 | 33413 | 198 |
2085201 | 2085201 | 2022-01-05 | Delaware | Ohio | 39041 | 33042 | 198 |
2081949 | 2081949 | 2022-01-04 | Delaware | Ohio | 39041 | 32667 | 198 |
2078697 | 2078697 | 2022-01-03 | Delaware | Ohio | 39041 | 32270 | 198 |
2075446 | 2075446 | 2022-01-02 | Delaware | Ohio | 39041 | 31984 | 198 |
2072195 | 2072195 | 2022-01-01 | Delaware | Ohio | 39041 | 31370 | 198 |
2068944 | 2068944 | 2021-12-31 | Delaware | Ohio | 39041 | 31370 | 198 |
2065693 | 2065693 | 2021-12-30 | Delaware | Ohio | 39041 | 31075 | 197 |
2062443 | 2062443 | 2021-12-29 | Delaware | Ohio | 39041 | 30673 | 197 |
2059193 | 2059193 | 2021-12-28 | Delaware | Ohio | 39041 | 30377 | 197 |
2055944 | 2055944 | 2021-12-27 | Delaware | Ohio | 39041 | 30139 | 197 |
2052695 | 2052695 | 2021-12-26 | Delaware | Ohio | 39041 | 29995 | 197 |
2049445 | 2049445 | 2021-12-25 | Delaware | Ohio | 39041 | 29730 | 197 |
2046195 | 2046195 | 2021-12-24 | Delaware | Ohio | 39041 | 29730 | 197 |
2042945 | 2042945 | 2021-12-23 | Delaware | Ohio | 39041 | 29520 | 191 |
2039696 | 2039696 | 2021-12-22 | Delaware | Ohio | 39041 | 29296 | 191 |
2036446 | 2036446 | 2021-12-21 | Delaware | Ohio | 39041 | 29099 | 191 |
2033196 | 2033196 | 2021-12-20 | Delaware | Ohio | 39041 | 28939 | 189 |
2029946 | 2029946 | 2021-12-19 | Delaware | Ohio | 39041 | 28872 | 189 |
2026695 | 2026695 | 2021-12-18 | Delaware | Ohio | 39041 | 28788 | 189 |
2023444 | 2023444 | 2021-12-17 | Delaware | Ohio | 39041 | 28703 | 189 |
2020193 | 2020193 | 2021-12-16 | Delaware | Ohio | 39041 | 28580 | 189 |
2016942 | 2016942 | 2021-12-15 | Delaware | Ohio | 39041 | 28410 | 189 |
2013692 | 2013692 | 2021-12-14 | Delaware | Ohio | 39041 | 28275 | 189 |
2010441 | 2010441 | 2021-12-13 | Delaware | Ohio | 39041 | 28155 | 189 |
2007190 | 2007190 | 2021-12-12 | Delaware | Ohio | 39041 | 28093 | 189 |
2003939 | 2003939 | 2021-12-11 | Delaware | Ohio | 39041 | 28037 | 189 |
2000688 | 2000688 | 2021-12-10 | Delaware | Ohio | 39041 | 27933 | 189 |
1997438 | 1997438 | 2021-12-09 | Delaware | Ohio | 39041 | 27832 | 187 |
1994187 | 1994187 | 2021-12-08 | Delaware | Ohio | 39041 | 27715 | 187 |
1990936 | 1990936 | 2021-12-07 | Delaware | Ohio | 39041 | 27590 | 187 |
1987685 | 1987685 | 2021-12-06 | Delaware | Ohio | 39041 | 27462 | 185 |
1984435 | 1984435 | 2021-12-05 | Delaware | Ohio | 39041 | 27394 | 185 |
1981185 | 1981185 | 2021-12-04 | Delaware | Ohio | 39041 | 27340 | 185 |
1977935 | 1977935 | 2021-12-03 | Delaware | Ohio | 39041 | 27206 | 185 |
1974685 | 1974685 | 2021-12-02 | Delaware | Ohio | 39041 | 27046 | 182 |
1971436 | 1971436 | 2021-12-01 | Delaware | Ohio | 39041 | 26914 | 182 |
1968186 | 1968186 | 2021-11-30 | Delaware | Ohio | 39041 | 26791 | 182 |
1964935 | 1964935 | 2021-11-29 | Delaware | Ohio | 39041 | 26682 | 182 |
1961683 | 1961683 | 2021-11-28 | Delaware | Ohio | 39041 | 26606 | 182 |
1958432 | 1958432 | 2021-11-27 | Delaware | Ohio | 39041 | 26553 | 182 |
1955181 | 1955181 | 2021-11-26 | Delaware | Ohio | 39041 | 26486 | 182 |
1951930 | 1951930 | 2021-11-25 | Delaware | Ohio | 39041 | 26372 | 182 |
1948679 | 1948679 | 2021-11-24 | Delaware | Ohio | 39041 | 26372 | 182 |
1945428 | 1945428 | 2021-11-23 | Delaware | Ohio | 39041 | 26270 | 182 |
1942177 | 1942177 | 2021-11-22 | Delaware | Ohio | 39041 | 26183 | 179 |
1938927 | 1938927 | 2021-11-21 | Delaware | Ohio | 39041 | 26107 | 179 |
1935677 | 1935677 | 2021-11-20 | Delaware | Ohio | 39041 | 26048 | 179 |
1932427 | 1932427 | 2021-11-19 | Delaware | Ohio | 39041 | 25977 | 179 |
1929176 | 1929176 | 2021-11-18 | Delaware | Ohio | 39041 | 25886 | 179 |
1925926 | 1925926 | 2021-11-17 | Delaware | Ohio | 39041 | 25795 | 179 |
1922676 | 1922676 | 2021-11-16 | Delaware | Ohio | 39041 | 25699 | 179 |
1919427 | 1919427 | 2021-11-15 | Delaware | Ohio | 39041 | 25596 | 178 |
1916177 | 1916177 | 2021-11-14 | Delaware | Ohio | 39041 | 25528 | 178 |
1912927 | 1912927 | 2021-11-13 | Delaware | Ohio | 39041 | 25478 | 178 |
1909677 | 1909677 | 2021-11-12 | Delaware | Ohio | 39041 | 25401 | 178 |
1906428 | 1906428 | 2021-11-11 | Delaware | Ohio | 39041 | 25341 | 177 |
1903179 | 1903179 | 2021-11-10 | Delaware | Ohio | 39041 | 25255 | 177 |
1899929 | 1899929 | 2021-11-09 | Delaware | Ohio | 39041 | 25146 | 177 |
1896679 | 1896679 | 2021-11-08 | Delaware | Ohio | 39041 | 25043 | 176 |
1893429 | 1893429 | 2021-11-07 | Delaware | Ohio | 39041 | 24991 | 176 |
1890179 | 1890179 | 2021-11-06 | Delaware | Ohio | 39041 | 24926 | 176 |
1886929 | 1886929 | 2021-11-05 | Delaware | Ohio | 39041 | 24873 | 176 |
1883679 | 1883679 | 2021-11-04 | Delaware | Ohio | 39041 | 24798 | 172 |
1880430 | 1880430 | 2021-11-03 | Delaware | Ohio | 39041 | 24725 | 172 |
1877181 | 1877181 | 2021-11-02 | Delaware | Ohio | 39041 | 24655 | 172 |
1873932 | 1873932 | 2021-11-01 | Delaware | Ohio | 39041 | 24580 | 171 |
1870683 | 1870683 | 2021-10-31 | Delaware | Ohio | 39041 | 24542 | 171 |
1867434 | 1867434 | 2021-10-30 | Delaware | Ohio | 39041 | 24514 | 171 |
1864185 | 1864185 | 2021-10-29 | Delaware | Ohio | 39041 | 24474 | 171 |
1860936 | 1860936 | 2021-10-28 | Delaware | Ohio | 39041 | 24438 | 166 |
1857687 | 1857687 | 2021-10-27 | Delaware | Ohio | 39041 | 24394 | 166 |
1854438 | 1854438 | 2021-10-26 | Delaware | Ohio | 39041 | 24336 | 166 |
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);