ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39007 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176263 | 2176263 | 2022-02-02 | Ashtabula | Ohio | 39007 | 19024 | 373 |
2173009 | 2173009 | 2022-02-01 | Ashtabula | Ohio | 39007 | 18968 | 373 |
2169757 | 2169757 | 2022-01-31 | Ashtabula | Ohio | 39007 | 18927 | 370 |
2166502 | 2166502 | 2022-01-30 | Ashtabula | Ohio | 39007 | 18895 | 370 |
2163247 | 2163247 | 2022-01-29 | Ashtabula | Ohio | 39007 | 18875 | 370 |
2159992 | 2159992 | 2022-01-28 | Ashtabula | Ohio | 39007 | 18823 | 370 |
2156737 | 2156737 | 2022-01-27 | Ashtabula | Ohio | 39007 | 18780 | 366 |
2153484 | 2153484 | 2022-01-26 | Ashtabula | Ohio | 39007 | 18738 | 366 |
2150232 | 2150232 | 2022-01-25 | Ashtabula | Ohio | 39007 | 18628 | 366 |
2146980 | 2146980 | 2022-01-24 | Ashtabula | Ohio | 39007 | 18569 | 362 |
2143726 | 2143726 | 2022-01-23 | Ashtabula | Ohio | 39007 | 18521 | 362 |
2140471 | 2140471 | 2022-01-22 | Ashtabula | Ohio | 39007 | 18489 | 362 |
2137215 | 2137215 | 2022-01-21 | Ashtabula | Ohio | 39007 | 18332 | 362 |
2133961 | 2133961 | 2022-01-20 | Ashtabula | Ohio | 39007 | 18260 | 342 |
2130709 | 2130709 | 2022-01-19 | Ashtabula | Ohio | 39007 | 18102 | 342 |
2127455 | 2127455 | 2022-01-18 | Ashtabula | Ohio | 39007 | 17989 | 342 |
2124203 | 2124203 | 2022-01-17 | Ashtabula | Ohio | 39007 | 17932 | 338 |
2120951 | 2120951 | 2022-01-16 | Ashtabula | Ohio | 39007 | 17862 | 338 |
2117699 | 2117699 | 2022-01-15 | Ashtabula | Ohio | 39007 | 17768 | 338 |
2114448 | 2114448 | 2022-01-14 | Ashtabula | Ohio | 39007 | 17535 | 338 |
2111196 | 2111196 | 2022-01-13 | Ashtabula | Ohio | 39007 | 17334 | 326 |
2107944 | 2107944 | 2022-01-12 | Ashtabula | Ohio | 39007 | 17208 | 326 |
2104693 | 2104693 | 2022-01-11 | Ashtabula | Ohio | 39007 | 17033 | 326 |
2101442 | 2101442 | 2022-01-10 | Ashtabula | Ohio | 39007 | 16826 | 314 |
2098191 | 2098191 | 2022-01-09 | Ashtabula | Ohio | 39007 | 16732 | 314 |
2094939 | 2094939 | 2022-01-08 | Ashtabula | Ohio | 39007 | 16652 | 314 |
2091687 | 2091687 | 2022-01-07 | Ashtabula | Ohio | 39007 | 16506 | 314 |
2088435 | 2088435 | 2022-01-06 | Ashtabula | Ohio | 39007 | 16334 | 311 |
2085184 | 2085184 | 2022-01-05 | Ashtabula | Ohio | 39007 | 16185 | 311 |
2081932 | 2081932 | 2022-01-04 | Ashtabula | Ohio | 39007 | 15983 | 311 |
2078680 | 2078680 | 2022-01-03 | Ashtabula | Ohio | 39007 | 15773 | 309 |
2075429 | 2075429 | 2022-01-02 | Ashtabula | Ohio | 39007 | 15700 | 309 |
2072178 | 2072178 | 2022-01-01 | Ashtabula | Ohio | 39007 | 15510 | 309 |
2068927 | 2068927 | 2021-12-31 | Ashtabula | Ohio | 39007 | 15510 | 309 |
2065676 | 2065676 | 2021-12-30 | Ashtabula | Ohio | 39007 | 15359 | 298 |
2062426 | 2062426 | 2021-12-29 | Ashtabula | Ohio | 39007 | 15189 | 298 |
2059176 | 2059176 | 2021-12-28 | Ashtabula | Ohio | 39007 | 15052 | 298 |
2055927 | 2055927 | 2021-12-27 | Ashtabula | Ohio | 39007 | 14899 | 297 |
2052678 | 2052678 | 2021-12-26 | Ashtabula | Ohio | 39007 | 14848 | 297 |
2049428 | 2049428 | 2021-12-25 | Ashtabula | Ohio | 39007 | 14754 | 297 |
2046178 | 2046178 | 2021-12-24 | Ashtabula | Ohio | 39007 | 14754 | 297 |
2042928 | 2042928 | 2021-12-23 | Ashtabula | Ohio | 39007 | 14632 | 282 |
2039679 | 2039679 | 2021-12-22 | Ashtabula | Ohio | 39007 | 14484 | 282 |
2036429 | 2036429 | 2021-12-21 | Ashtabula | Ohio | 39007 | 14374 | 282 |
2033179 | 2033179 | 2021-12-20 | Ashtabula | Ohio | 39007 | 14238 | 279 |
2029929 | 2029929 | 2021-12-19 | Ashtabula | Ohio | 39007 | 14161 | 279 |
2026678 | 2026678 | 2021-12-18 | Ashtabula | Ohio | 39007 | 14117 | 279 |
2023427 | 2023427 | 2021-12-17 | Ashtabula | Ohio | 39007 | 13983 | 279 |
2020176 | 2020176 | 2021-12-16 | Ashtabula | Ohio | 39007 | 13887 | 265 |
2016925 | 2016925 | 2021-12-15 | Ashtabula | Ohio | 39007 | 13820 | 265 |
2013675 | 2013675 | 2021-12-14 | Ashtabula | Ohio | 39007 | 13718 | 265 |
2010424 | 2010424 | 2021-12-13 | Ashtabula | Ohio | 39007 | 13639 | 252 |
2007173 | 2007173 | 2021-12-12 | Ashtabula | Ohio | 39007 | 13576 | 252 |
2003922 | 2003922 | 2021-12-11 | Ashtabula | Ohio | 39007 | 13512 | 252 |
2000671 | 2000671 | 2021-12-10 | Ashtabula | Ohio | 39007 | 13420 | 252 |
1997421 | 1997421 | 2021-12-09 | Ashtabula | Ohio | 39007 | 13334 | 240 |
1994170 | 1994170 | 2021-12-08 | Ashtabula | Ohio | 39007 | 13214 | 240 |
1990919 | 1990919 | 2021-12-07 | Ashtabula | Ohio | 39007 | 13065 | 240 |
1987668 | 1987668 | 2021-12-06 | Ashtabula | Ohio | 39007 | 12980 | 237 |
1984418 | 1984418 | 2021-12-05 | Ashtabula | Ohio | 39007 | 12927 | 237 |
1981168 | 1981168 | 2021-12-04 | Ashtabula | Ohio | 39007 | 12860 | 237 |
1977918 | 1977918 | 2021-12-03 | Ashtabula | Ohio | 39007 | 12732 | 237 |
1974668 | 1974668 | 2021-12-02 | Ashtabula | Ohio | 39007 | 12618 | 232 |
1971419 | 1971419 | 2021-12-01 | Ashtabula | Ohio | 39007 | 12501 | 232 |
1968169 | 1968169 | 2021-11-30 | Ashtabula | Ohio | 39007 | 12417 | 232 |
1964918 | 1964918 | 2021-11-29 | Ashtabula | Ohio | 39007 | 12314 | 225 |
1961666 | 1961666 | 2021-11-28 | Ashtabula | Ohio | 39007 | 12255 | 225 |
1958415 | 1958415 | 2021-11-27 | Ashtabula | Ohio | 39007 | 12171 | 225 |
1955164 | 1955164 | 2021-11-26 | Ashtabula | Ohio | 39007 | 12096 | 225 |
1951913 | 1951913 | 2021-11-25 | Ashtabula | Ohio | 39007 | 11949 | 223 |
1948662 | 1948662 | 2021-11-24 | Ashtabula | Ohio | 39007 | 11949 | 223 |
1945411 | 1945411 | 2021-11-23 | Ashtabula | Ohio | 39007 | 11859 | 223 |
1942160 | 1942160 | 2021-11-22 | Ashtabula | Ohio | 39007 | 11752 | 223 |
1938910 | 1938910 | 2021-11-21 | Ashtabula | Ohio | 39007 | 11672 | 223 |
1935660 | 1935660 | 2021-11-20 | Ashtabula | Ohio | 39007 | 11589 | 223 |
1932410 | 1932410 | 2021-11-19 | Ashtabula | Ohio | 39007 | 11523 | 223 |
1929159 | 1929159 | 2021-11-18 | Ashtabula | Ohio | 39007 | 11419 | 219 |
1925909 | 1925909 | 2021-11-17 | Ashtabula | Ohio | 39007 | 11320 | 219 |
1922659 | 1922659 | 2021-11-16 | Ashtabula | Ohio | 39007 | 11227 | 219 |
1919410 | 1919410 | 2021-11-15 | Ashtabula | Ohio | 39007 | 11166 | 217 |
1916160 | 1916160 | 2021-11-14 | Ashtabula | Ohio | 39007 | 11093 | 217 |
1912910 | 1912910 | 2021-11-13 | Ashtabula | Ohio | 39007 | 11006 | 217 |
1909660 | 1909660 | 2021-11-12 | Ashtabula | Ohio | 39007 | 10910 | 217 |
1906411 | 1906411 | 2021-11-11 | Ashtabula | Ohio | 39007 | 10838 | 214 |
1903162 | 1903162 | 2021-11-10 | Ashtabula | Ohio | 39007 | 10781 | 214 |
1899912 | 1899912 | 2021-11-09 | Ashtabula | Ohio | 39007 | 10702 | 214 |
1896662 | 1896662 | 2021-11-08 | Ashtabula | Ohio | 39007 | 10649 | 211 |
1893412 | 1893412 | 2021-11-07 | Ashtabula | Ohio | 39007 | 10558 | 211 |
1890162 | 1890162 | 2021-11-06 | Ashtabula | Ohio | 39007 | 10478 | 211 |
1886912 | 1886912 | 2021-11-05 | Ashtabula | Ohio | 39007 | 10431 | 211 |
1883662 | 1883662 | 2021-11-04 | Ashtabula | Ohio | 39007 | 10349 | 206 |
1880413 | 1880413 | 2021-11-03 | Ashtabula | Ohio | 39007 | 10273 | 206 |
1877164 | 1877164 | 2021-11-02 | Ashtabula | Ohio | 39007 | 10209 | 206 |
1873915 | 1873915 | 2021-11-01 | Ashtabula | Ohio | 39007 | 10164 | 206 |
1870666 | 1870666 | 2021-10-31 | Ashtabula | Ohio | 39007 | 10121 | 206 |
1867417 | 1867417 | 2021-10-30 | Ashtabula | Ohio | 39007 | 10060 | 206 |
1864168 | 1864168 | 2021-10-29 | Ashtabula | Ohio | 39007 | 9996 | 206 |
1860919 | 1860919 | 2021-10-28 | Ashtabula | Ohio | 39007 | 9947 | 204 |
1857670 | 1857670 | 2021-10-27 | Ashtabula | Ohio | 39007 | 9888 | 204 |
1854421 | 1854421 | 2021-10-26 | Ashtabula | Ohio | 39007 | 9854 | 204 |
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);