ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 39147 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176333 | 2176333 | 2022-02-02 | Seneca | Ohio | 39147 | 12425 | 213 |
2173079 | 2173079 | 2022-02-01 | Seneca | Ohio | 39147 | 12379 | 213 |
2169827 | 2169827 | 2022-01-31 | Seneca | Ohio | 39147 | 12357 | 210 |
2166572 | 2166572 | 2022-01-30 | Seneca | Ohio | 39147 | 12328 | 210 |
2163317 | 2163317 | 2022-01-29 | Seneca | Ohio | 39147 | 12307 | 210 |
2160062 | 2160062 | 2022-01-28 | Seneca | Ohio | 39147 | 12269 | 210 |
2156807 | 2156807 | 2022-01-27 | Seneca | Ohio | 39147 | 12217 | 207 |
2153554 | 2153554 | 2022-01-26 | Seneca | Ohio | 39147 | 12168 | 207 |
2150302 | 2150302 | 2022-01-25 | Seneca | Ohio | 39147 | 12064 | 207 |
2147050 | 2147050 | 2022-01-24 | Seneca | Ohio | 39147 | 12055 | 204 |
2143796 | 2143796 | 2022-01-23 | Seneca | Ohio | 39147 | 11969 | 204 |
2140541 | 2140541 | 2022-01-22 | Seneca | Ohio | 39147 | 11934 | 204 |
2137285 | 2137285 | 2022-01-21 | Seneca | Ohio | 39147 | 11831 | 204 |
2134031 | 2134031 | 2022-01-20 | Seneca | Ohio | 39147 | 11762 | 200 |
2130779 | 2130779 | 2022-01-19 | Seneca | Ohio | 39147 | 11631 | 200 |
2127525 | 2127525 | 2022-01-18 | Seneca | Ohio | 39147 | 11540 | 200 |
2124273 | 2124273 | 2022-01-17 | Seneca | Ohio | 39147 | 11454 | 200 |
2121021 | 2121021 | 2022-01-16 | Seneca | Ohio | 39147 | 11353 | 200 |
2117769 | 2117769 | 2022-01-15 | Seneca | Ohio | 39147 | 11257 | 200 |
2114518 | 2114518 | 2022-01-14 | Seneca | Ohio | 39147 | 11026 | 200 |
2111266 | 2111266 | 2022-01-13 | Seneca | Ohio | 39147 | 10824 | 197 |
2108014 | 2108014 | 2022-01-12 | Seneca | Ohio | 39147 | 10751 | 197 |
2104763 | 2104763 | 2022-01-11 | Seneca | Ohio | 39147 | 10664 | 197 |
2101512 | 2101512 | 2022-01-10 | Seneca | Ohio | 39147 | 10594 | 194 |
2098261 | 2098261 | 2022-01-09 | Seneca | Ohio | 39147 | 10505 | 194 |
2095009 | 2095009 | 2022-01-08 | Seneca | Ohio | 39147 | 10444 | 194 |
2091757 | 2091757 | 2022-01-07 | Seneca | Ohio | 39147 | 10380 | 194 |
2088505 | 2088505 | 2022-01-06 | Seneca | Ohio | 39147 | 10277 | 192 |
2085254 | 2085254 | 2022-01-05 | Seneca | Ohio | 39147 | 10238 | 192 |
2082002 | 2082002 | 2022-01-04 | Seneca | Ohio | 39147 | 10156 | 192 |
2078750 | 2078750 | 2022-01-03 | Seneca | Ohio | 39147 | 10087 | 188 |
2075499 | 2075499 | 2022-01-02 | Seneca | Ohio | 39147 | 10016 | 188 |
2072248 | 2072248 | 2022-01-01 | Seneca | Ohio | 39147 | 9935 | 188 |
2068997 | 2068997 | 2021-12-31 | Seneca | Ohio | 39147 | 9935 | 188 |
2065746 | 2065746 | 2021-12-30 | Seneca | Ohio | 39147 | 9883 | 176 |
2062496 | 2062496 | 2021-12-29 | Seneca | Ohio | 39147 | 9807 | 176 |
2059246 | 2059246 | 2021-12-28 | Seneca | Ohio | 39147 | 9750 | 176 |
2055997 | 2055997 | 2021-12-27 | Seneca | Ohio | 39147 | 9704 | 175 |
2052748 | 2052748 | 2021-12-26 | Seneca | Ohio | 39147 | 9688 | 175 |
2049498 | 2049498 | 2021-12-25 | Seneca | Ohio | 39147 | 9648 | 175 |
2046248 | 2046248 | 2021-12-24 | Seneca | Ohio | 39147 | 9648 | 175 |
2042998 | 2042998 | 2021-12-23 | Seneca | Ohio | 39147 | 9621 | 172 |
2039749 | 2039749 | 2021-12-22 | Seneca | Ohio | 39147 | 9588 | 172 |
2036499 | 2036499 | 2021-12-21 | Seneca | Ohio | 39147 | 9556 | 172 |
2033249 | 2033249 | 2021-12-20 | Seneca | Ohio | 39147 | 9522 | 170 |
2029999 | 2029999 | 2021-12-19 | Seneca | Ohio | 39147 | 9497 | 170 |
2026748 | 2026748 | 2021-12-18 | Seneca | Ohio | 39147 | 9470 | 170 |
2023497 | 2023497 | 2021-12-17 | Seneca | Ohio | 39147 | 9441 | 170 |
2020246 | 2020246 | 2021-12-16 | Seneca | Ohio | 39147 | 9393 | 168 |
2016995 | 2016995 | 2021-12-15 | Seneca | Ohio | 39147 | 9361 | 168 |
2013745 | 2013745 | 2021-12-14 | Seneca | Ohio | 39147 | 9311 | 168 |
2010494 | 2010494 | 2021-12-13 | Seneca | Ohio | 39147 | 9287 | 166 |
2007243 | 2007243 | 2021-12-12 | Seneca | Ohio | 39147 | 9256 | 166 |
2003992 | 2003992 | 2021-12-11 | Seneca | Ohio | 39147 | 9237 | 166 |
2000741 | 2000741 | 2021-12-10 | Seneca | Ohio | 39147 | 9193 | 166 |
1997491 | 1997491 | 2021-12-09 | Seneca | Ohio | 39147 | 9163 | 161 |
1994240 | 1994240 | 2021-12-08 | Seneca | Ohio | 39147 | 9096 | 161 |
1990989 | 1990989 | 2021-12-07 | Seneca | Ohio | 39147 | 9048 | 161 |
1987738 | 1987738 | 2021-12-06 | Seneca | Ohio | 39147 | 9020 | 161 |
1984488 | 1984488 | 2021-12-05 | Seneca | Ohio | 39147 | 8993 | 161 |
1981238 | 1981238 | 2021-12-04 | Seneca | Ohio | 39147 | 8954 | 161 |
1977988 | 1977988 | 2021-12-03 | Seneca | Ohio | 39147 | 8917 | 161 |
1974738 | 1974738 | 2021-12-02 | Seneca | Ohio | 39147 | 8853 | 157 |
1971489 | 1971489 | 2021-12-01 | Seneca | Ohio | 39147 | 8793 | 157 |
1968239 | 1968239 | 2021-11-30 | Seneca | Ohio | 39147 | 8752 | 157 |
1964988 | 1964988 | 2021-11-29 | Seneca | Ohio | 39147 | 8692 | 156 |
1961736 | 1961736 | 2021-11-28 | Seneca | Ohio | 39147 | 8669 | 156 |
1958485 | 1958485 | 2021-11-27 | Seneca | Ohio | 39147 | 8639 | 156 |
1955234 | 1955234 | 2021-11-26 | Seneca | Ohio | 39147 | 8598 | 156 |
1951983 | 1951983 | 2021-11-25 | Seneca | Ohio | 39147 | 8560 | 155 |
1948732 | 1948732 | 2021-11-24 | Seneca | Ohio | 39147 | 8560 | 155 |
1945481 | 1945481 | 2021-11-23 | Seneca | Ohio | 39147 | 8509 | 155 |
1942230 | 1942230 | 2021-11-22 | Seneca | Ohio | 39147 | 8458 | 154 |
1938980 | 1938980 | 2021-11-21 | Seneca | Ohio | 39147 | 8422 | 154 |
1935730 | 1935730 | 2021-11-20 | Seneca | Ohio | 39147 | 8396 | 154 |
1932480 | 1932480 | 2021-11-19 | Seneca | Ohio | 39147 | 8378 | 154 |
1929229 | 1929229 | 2021-11-18 | Seneca | Ohio | 39147 | 8337 | 154 |
1925979 | 1925979 | 2021-11-17 | Seneca | Ohio | 39147 | 8281 | 154 |
1922729 | 1922729 | 2021-11-16 | Seneca | Ohio | 39147 | 8221 | 154 |
1919480 | 1919480 | 2021-11-15 | Seneca | Ohio | 39147 | 8189 | 153 |
1916230 | 1916230 | 2021-11-14 | Seneca | Ohio | 39147 | 8143 | 153 |
1912980 | 1912980 | 2021-11-13 | Seneca | Ohio | 39147 | 8116 | 153 |
1909730 | 1909730 | 2021-11-12 | Seneca | Ohio | 39147 | 8095 | 153 |
1906481 | 1906481 | 2021-11-11 | Seneca | Ohio | 39147 | 8037 | 152 |
1903232 | 1903232 | 2021-11-10 | Seneca | Ohio | 39147 | 7996 | 152 |
1899982 | 1899982 | 2021-11-09 | Seneca | Ohio | 39147 | 7919 | 152 |
1896732 | 1896732 | 2021-11-08 | Seneca | Ohio | 39147 | 7901 | 150 |
1893482 | 1893482 | 2021-11-07 | Seneca | Ohio | 39147 | 7854 | 150 |
1890232 | 1890232 | 2021-11-06 | Seneca | Ohio | 39147 | 7823 | 150 |
1886982 | 1886982 | 2021-11-05 | Seneca | Ohio | 39147 | 7804 | 150 |
1883732 | 1883732 | 2021-11-04 | Seneca | Ohio | 39147 | 7757 | 149 |
1880483 | 1880483 | 2021-11-03 | Seneca | Ohio | 39147 | 7712 | 149 |
1877234 | 1877234 | 2021-11-02 | Seneca | Ohio | 39147 | 7666 | 149 |
1873985 | 1873985 | 2021-11-01 | Seneca | Ohio | 39147 | 7641 | 148 |
1870736 | 1870736 | 2021-10-31 | Seneca | Ohio | 39147 | 7611 | 148 |
1867487 | 1867487 | 2021-10-30 | Seneca | Ohio | 39147 | 7584 | 148 |
1864238 | 1864238 | 2021-10-29 | Seneca | Ohio | 39147 | 7552 | 148 |
1860989 | 1860989 | 2021-10-28 | Seneca | Ohio | 39147 | 7519 | 146 |
1857740 | 1857740 | 2021-10-27 | Seneca | Ohio | 39147 | 7481 | 146 |
1854491 | 1854491 | 2021-10-26 | Seneca | Ohio | 39147 | 7446 | 146 |
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);