ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39005 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176262 | 2176262 | 2022-02-02 | Ashland | Ohio | 39005 | 11619 | 195 |
2173008 | 2173008 | 2022-02-01 | Ashland | Ohio | 39005 | 11581 | 195 |
2169756 | 2169756 | 2022-01-31 | Ashland | Ohio | 39005 | 11555 | 191 |
2166501 | 2166501 | 2022-01-30 | Ashland | Ohio | 39005 | 11527 | 191 |
2163246 | 2163246 | 2022-01-29 | Ashland | Ohio | 39005 | 11506 | 191 |
2159991 | 2159991 | 2022-01-28 | Ashland | Ohio | 39005 | 11480 | 191 |
2156736 | 2156736 | 2022-01-27 | Ashland | Ohio | 39005 | 11438 | 188 |
2153483 | 2153483 | 2022-01-26 | Ashland | Ohio | 39005 | 11358 | 188 |
2150231 | 2150231 | 2022-01-25 | Ashland | Ohio | 39005 | 11273 | 188 |
2146979 | 2146979 | 2022-01-24 | Ashland | Ohio | 39005 | 11248 | 184 |
2143725 | 2143725 | 2022-01-23 | Ashland | Ohio | 39005 | 11196 | 184 |
2140470 | 2140470 | 2022-01-22 | Ashland | Ohio | 39005 | 11157 | 184 |
2137214 | 2137214 | 2022-01-21 | Ashland | Ohio | 39005 | 11083 | 184 |
2133960 | 2133960 | 2022-01-20 | Ashland | Ohio | 39005 | 11022 | 178 |
2130708 | 2130708 | 2022-01-19 | Ashland | Ohio | 39005 | 10916 | 178 |
2127454 | 2127454 | 2022-01-18 | Ashland | Ohio | 39005 | 10830 | 178 |
2124202 | 2124202 | 2022-01-17 | Ashland | Ohio | 39005 | 10795 | 174 |
2120950 | 2120950 | 2022-01-16 | Ashland | Ohio | 39005 | 10713 | 174 |
2117698 | 2117698 | 2022-01-15 | Ashland | Ohio | 39005 | 10602 | 174 |
2114447 | 2114447 | 2022-01-14 | Ashland | Ohio | 39005 | 10406 | 174 |
2111195 | 2111195 | 2022-01-13 | Ashland | Ohio | 39005 | 10231 | 173 |
2107943 | 2107943 | 2022-01-12 | Ashland | Ohio | 39005 | 10175 | 173 |
2104692 | 2104692 | 2022-01-11 | Ashland | Ohio | 39005 | 10094 | 173 |
2101441 | 2101441 | 2022-01-10 | Ashland | Ohio | 39005 | 10027 | 168 |
2098190 | 2098190 | 2022-01-09 | Ashland | Ohio | 39005 | 9962 | 168 |
2094938 | 2094938 | 2022-01-08 | Ashland | Ohio | 39005 | 9921 | 168 |
2091686 | 2091686 | 2022-01-07 | Ashland | Ohio | 39005 | 9820 | 168 |
2088434 | 2088434 | 2022-01-06 | Ashland | Ohio | 39005 | 9743 | 166 |
2085183 | 2085183 | 2022-01-05 | Ashland | Ohio | 39005 | 9668 | 166 |
2081931 | 2081931 | 2022-01-04 | Ashland | Ohio | 39005 | 9560 | 166 |
2078679 | 2078679 | 2022-01-03 | Ashland | Ohio | 39005 | 9498 | 165 |
2075428 | 2075428 | 2022-01-02 | Ashland | Ohio | 39005 | 9426 | 165 |
2072177 | 2072177 | 2022-01-01 | Ashland | Ohio | 39005 | 9235 | 165 |
2068926 | 2068926 | 2021-12-31 | Ashland | Ohio | 39005 | 9235 | 165 |
2065675 | 2065675 | 2021-12-30 | Ashland | Ohio | 39005 | 9140 | 164 |
2062425 | 2062425 | 2021-12-29 | Ashland | Ohio | 39005 | 9060 | 164 |
2059175 | 2059175 | 2021-12-28 | Ashland | Ohio | 39005 | 8980 | 164 |
2055926 | 2055926 | 2021-12-27 | Ashland | Ohio | 39005 | 8919 | 164 |
2052677 | 2052677 | 2021-12-26 | Ashland | Ohio | 39005 | 8909 | 164 |
2049427 | 2049427 | 2021-12-25 | Ashland | Ohio | 39005 | 8821 | 164 |
2046177 | 2046177 | 2021-12-24 | Ashland | Ohio | 39005 | 8821 | 164 |
2042927 | 2042927 | 2021-12-23 | Ashland | Ohio | 39005 | 8778 | 164 |
2039678 | 2039678 | 2021-12-22 | Ashland | Ohio | 39005 | 8707 | 164 |
2036428 | 2036428 | 2021-12-21 | Ashland | Ohio | 39005 | 8645 | 164 |
2033178 | 2033178 | 2021-12-20 | Ashland | Ohio | 39005 | 8620 | 160 |
2029928 | 2029928 | 2021-12-19 | Ashland | Ohio | 39005 | 8600 | 160 |
2026677 | 2026677 | 2021-12-18 | Ashland | Ohio | 39005 | 8579 | 160 |
2023426 | 2023426 | 2021-12-17 | Ashland | Ohio | 39005 | 8546 | 160 |
2020175 | 2020175 | 2021-12-16 | Ashland | Ohio | 39005 | 8496 | 160 |
2016924 | 2016924 | 2021-12-15 | Ashland | Ohio | 39005 | 8459 | 160 |
2013674 | 2013674 | 2021-12-14 | Ashland | Ohio | 39005 | 8402 | 160 |
2010423 | 2010423 | 2021-12-13 | Ashland | Ohio | 39005 | 8360 | 157 |
2007172 | 2007172 | 2021-12-12 | Ashland | Ohio | 39005 | 8338 | 157 |
2003921 | 2003921 | 2021-12-11 | Ashland | Ohio | 39005 | 8314 | 157 |
2000670 | 2000670 | 2021-12-10 | Ashland | Ohio | 39005 | 8276 | 157 |
1997420 | 1997420 | 2021-12-09 | Ashland | Ohio | 39005 | 8242 | 152 |
1994169 | 1994169 | 2021-12-08 | Ashland | Ohio | 39005 | 8218 | 152 |
1990918 | 1990918 | 2021-12-07 | Ashland | Ohio | 39005 | 8166 | 152 |
1987667 | 1987667 | 2021-12-06 | Ashland | Ohio | 39005 | 8130 | 152 |
1984417 | 1984417 | 2021-12-05 | Ashland | Ohio | 39005 | 8102 | 152 |
1981167 | 1981167 | 2021-12-04 | Ashland | Ohio | 39005 | 8068 | 152 |
1977917 | 1977917 | 2021-12-03 | Ashland | Ohio | 39005 | 8029 | 152 |
1974667 | 1974667 | 2021-12-02 | Ashland | Ohio | 39005 | 7956 | 149 |
1971418 | 1971418 | 2021-12-01 | Ashland | Ohio | 39005 | 7917 | 149 |
1968168 | 1968168 | 2021-11-30 | Ashland | Ohio | 39005 | 7873 | 149 |
1964917 | 1964917 | 2021-11-29 | Ashland | Ohio | 39005 | 7840 | 147 |
1961665 | 1961665 | 2021-11-28 | Ashland | Ohio | 39005 | 7801 | 147 |
1958414 | 1958414 | 2021-11-27 | Ashland | Ohio | 39005 | 7777 | 147 |
1955163 | 1955163 | 2021-11-26 | Ashland | Ohio | 39005 | 7752 | 147 |
1951912 | 1951912 | 2021-11-25 | Ashland | Ohio | 39005 | 7710 | 146 |
1948661 | 1948661 | 2021-11-24 | Ashland | Ohio | 39005 | 7710 | 146 |
1945410 | 1945410 | 2021-11-23 | Ashland | Ohio | 39005 | 7677 | 146 |
1942159 | 1942159 | 2021-11-22 | Ashland | Ohio | 39005 | 7632 | 146 |
1938909 | 1938909 | 2021-11-21 | Ashland | Ohio | 39005 | 7607 | 146 |
1935659 | 1935659 | 2021-11-20 | Ashland | Ohio | 39005 | 7595 | 146 |
1932409 | 1932409 | 2021-11-19 | Ashland | Ohio | 39005 | 7561 | 146 |
1929158 | 1929158 | 2021-11-18 | Ashland | Ohio | 39005 | 7526 | 146 |
1925908 | 1925908 | 2021-11-17 | Ashland | Ohio | 39005 | 7472 | 146 |
1922658 | 1922658 | 2021-11-16 | Ashland | Ohio | 39005 | 7438 | 146 |
1919409 | 1919409 | 2021-11-15 | Ashland | Ohio | 39005 | 7413 | 146 |
1916159 | 1916159 | 2021-11-14 | Ashland | Ohio | 39005 | 7393 | 146 |
1912909 | 1912909 | 2021-11-13 | Ashland | Ohio | 39005 | 7377 | 146 |
1909659 | 1909659 | 2021-11-12 | Ashland | Ohio | 39005 | 7361 | 146 |
1906410 | 1906410 | 2021-11-11 | Ashland | Ohio | 39005 | 7340 | 143 |
1903161 | 1903161 | 2021-11-10 | Ashland | Ohio | 39005 | 7323 | 143 |
1899911 | 1899911 | 2021-11-09 | Ashland | Ohio | 39005 | 7296 | 143 |
1896661 | 1896661 | 2021-11-08 | Ashland | Ohio | 39005 | 7281 | 143 |
1893411 | 1893411 | 2021-11-07 | Ashland | Ohio | 39005 | 7259 | 143 |
1890161 | 1890161 | 2021-11-06 | Ashland | Ohio | 39005 | 7241 | 143 |
1886911 | 1886911 | 2021-11-05 | Ashland | Ohio | 39005 | 7229 | 143 |
1883661 | 1883661 | 2021-11-04 | Ashland | Ohio | 39005 | 7193 | 141 |
1880412 | 1880412 | 2021-11-03 | Ashland | Ohio | 39005 | 7171 | 141 |
1877163 | 1877163 | 2021-11-02 | Ashland | Ohio | 39005 | 7151 | 141 |
1873914 | 1873914 | 2021-11-01 | Ashland | Ohio | 39005 | 7136 | 138 |
1870665 | 1870665 | 2021-10-31 | Ashland | Ohio | 39005 | 7122 | 138 |
1867416 | 1867416 | 2021-10-30 | Ashland | Ohio | 39005 | 7103 | 138 |
1864167 | 1864167 | 2021-10-29 | Ashland | Ohio | 39005 | 7079 | 138 |
1860918 | 1860918 | 2021-10-28 | Ashland | Ohio | 39005 | 7065 | 132 |
1857669 | 1857669 | 2021-10-27 | Ashland | Ohio | 39005 | 7041 | 132 |
1854420 | 1854420 | 2021-10-26 | Ashland | Ohio | 39005 | 7011 | 132 |
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);