ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Defiance" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176279 | 2176279 | 2022-02-02 | Defiance | Ohio | 39039 | 9937 | 146 |
2173025 | 2173025 | 2022-02-01 | Defiance | Ohio | 39039 | 9894 | 146 |
2169773 | 2169773 | 2022-01-31 | Defiance | Ohio | 39039 | 9872 | 141 |
2166518 | 2166518 | 2022-01-30 | Defiance | Ohio | 39039 | 9861 | 141 |
2163263 | 2163263 | 2022-01-29 | Defiance | Ohio | 39039 | 9846 | 141 |
2160008 | 2160008 | 2022-01-28 | Defiance | Ohio | 39039 | 9794 | 141 |
2156753 | 2156753 | 2022-01-27 | Defiance | Ohio | 39039 | 9750 | 139 |
2153500 | 2153500 | 2022-01-26 | Defiance | Ohio | 39039 | 9693 | 139 |
2150248 | 2150248 | 2022-01-25 | Defiance | Ohio | 39039 | 9583 | 139 |
2146996 | 2146996 | 2022-01-24 | Defiance | Ohio | 39039 | 9567 | 137 |
2143742 | 2143742 | 2022-01-23 | Defiance | Ohio | 39039 | 9533 | 137 |
2140487 | 2140487 | 2022-01-22 | Defiance | Ohio | 39039 | 9486 | 137 |
2137231 | 2137231 | 2022-01-21 | Defiance | Ohio | 39039 | 9406 | 137 |
2133977 | 2133977 | 2022-01-20 | Defiance | Ohio | 39039 | 9321 | 135 |
2130725 | 2130725 | 2022-01-19 | Defiance | Ohio | 39039 | 9209 | 135 |
2127471 | 2127471 | 2022-01-18 | Defiance | Ohio | 39039 | 9116 | 135 |
2124219 | 2124219 | 2022-01-17 | Defiance | Ohio | 39039 | 9057 | 134 |
2120967 | 2120967 | 2022-01-16 | Defiance | Ohio | 39039 | 8990 | 134 |
2117715 | 2117715 | 2022-01-15 | Defiance | Ohio | 39039 | 8917 | 134 |
2114464 | 2114464 | 2022-01-14 | Defiance | Ohio | 39039 | 8800 | 134 |
2111212 | 2111212 | 2022-01-13 | Defiance | Ohio | 39039 | 8623 | 131 |
2107960 | 2107960 | 2022-01-12 | Defiance | Ohio | 39039 | 8573 | 131 |
2104709 | 2104709 | 2022-01-11 | Defiance | Ohio | 39039 | 8493 | 131 |
2101458 | 2101458 | 2022-01-10 | Defiance | Ohio | 39039 | 8447 | 130 |
2098207 | 2098207 | 2022-01-09 | Defiance | Ohio | 39039 | 8414 | 130 |
2094955 | 2094955 | 2022-01-08 | Defiance | Ohio | 39039 | 8376 | 130 |
2091703 | 2091703 | 2022-01-07 | Defiance | Ohio | 39039 | 8324 | 130 |
2088451 | 2088451 | 2022-01-06 | Defiance | Ohio | 39039 | 8262 | 129 |
2085200 | 2085200 | 2022-01-05 | Defiance | Ohio | 39039 | 8229 | 129 |
2081948 | 2081948 | 2022-01-04 | Defiance | Ohio | 39039 | 8156 | 129 |
2078696 | 2078696 | 2022-01-03 | Defiance | Ohio | 39039 | 8121 | 129 |
2075445 | 2075445 | 2022-01-02 | Defiance | Ohio | 39039 | 8084 | 129 |
2072194 | 2072194 | 2022-01-01 | Defiance | Ohio | 39039 | 8041 | 129 |
2068943 | 2068943 | 2021-12-31 | Defiance | Ohio | 39039 | 8041 | 129 |
2065692 | 2065692 | 2021-12-30 | Defiance | Ohio | 39039 | 7993 | 125 |
2062442 | 2062442 | 2021-12-29 | Defiance | Ohio | 39039 | 7973 | 125 |
2059192 | 2059192 | 2021-12-28 | Defiance | Ohio | 39039 | 7935 | 125 |
2055943 | 2055943 | 2021-12-27 | Defiance | Ohio | 39039 | 7913 | 125 |
2052694 | 2052694 | 2021-12-26 | Defiance | Ohio | 39039 | 7910 | 125 |
2049444 | 2049444 | 2021-12-25 | Defiance | Ohio | 39039 | 7885 | 125 |
2046194 | 2046194 | 2021-12-24 | Defiance | Ohio | 39039 | 7885 | 125 |
2042944 | 2042944 | 2021-12-23 | Defiance | Ohio | 39039 | 7863 | 122 |
2039695 | 2039695 | 2021-12-22 | Defiance | Ohio | 39039 | 7836 | 122 |
2036445 | 2036445 | 2021-12-21 | Defiance | Ohio | 39039 | 7818 | 122 |
2033195 | 2033195 | 2021-12-20 | Defiance | Ohio | 39039 | 7794 | 118 |
2029945 | 2029945 | 2021-12-19 | Defiance | Ohio | 39039 | 7780 | 118 |
2026694 | 2026694 | 2021-12-18 | Defiance | Ohio | 39039 | 7762 | 118 |
2023443 | 2023443 | 2021-12-17 | Defiance | Ohio | 39039 | 7740 | 118 |
2020192 | 2020192 | 2021-12-16 | Defiance | Ohio | 39039 | 7707 | 118 |
2016941 | 2016941 | 2021-12-15 | Defiance | Ohio | 39039 | 7680 | 118 |
2013691 | 2013691 | 2021-12-14 | Defiance | Ohio | 39039 | 7653 | 118 |
2010440 | 2010440 | 2021-12-13 | Defiance | Ohio | 39039 | 7618 | 117 |
2007189 | 2007189 | 2021-12-12 | Defiance | Ohio | 39039 | 7608 | 117 |
2003938 | 2003938 | 2021-12-11 | Defiance | Ohio | 39039 | 7586 | 117 |
2000687 | 2000687 | 2021-12-10 | Defiance | Ohio | 39039 | 7566 | 117 |
1997437 | 1997437 | 2021-12-09 | Defiance | Ohio | 39039 | 7544 | 117 |
1994186 | 1994186 | 2021-12-08 | Defiance | Ohio | 39039 | 7502 | 117 |
1990935 | 1990935 | 2021-12-07 | Defiance | Ohio | 39039 | 7471 | 117 |
1987684 | 1987684 | 2021-12-06 | Defiance | Ohio | 39039 | 7431 | 117 |
1984434 | 1984434 | 2021-12-05 | Defiance | Ohio | 39039 | 7418 | 117 |
1981184 | 1981184 | 2021-12-04 | Defiance | Ohio | 39039 | 7404 | 117 |
1977934 | 1977934 | 2021-12-03 | Defiance | Ohio | 39039 | 7358 | 117 |
1974684 | 1974684 | 2021-12-02 | Defiance | Ohio | 39039 | 7331 | 115 |
1971435 | 1971435 | 2021-12-01 | Defiance | Ohio | 39039 | 7280 | 115 |
1968185 | 1968185 | 2021-11-30 | Defiance | Ohio | 39039 | 7243 | 115 |
1964934 | 1964934 | 2021-11-29 | Defiance | Ohio | 39039 | 7210 | 114 |
1961682 | 1961682 | 2021-11-28 | Defiance | Ohio | 39039 | 7186 | 114 |
1958431 | 1958431 | 2021-11-27 | Defiance | Ohio | 39039 | 7174 | 114 |
1955180 | 1955180 | 2021-11-26 | Defiance | Ohio | 39039 | 7162 | 114 |
1951929 | 1951929 | 2021-11-25 | Defiance | Ohio | 39039 | 7117 | 114 |
1948678 | 1948678 | 2021-11-24 | Defiance | Ohio | 39039 | 7117 | 114 |
1945427 | 1945427 | 2021-11-23 | Defiance | Ohio | 39039 | 7088 | 114 |
1942176 | 1942176 | 2021-11-22 | Defiance | Ohio | 39039 | 7044 | 114 |
1938926 | 1938926 | 2021-11-21 | Defiance | Ohio | 39039 | 7031 | 114 |
1935676 | 1935676 | 2021-11-20 | Defiance | Ohio | 39039 | 7006 | 114 |
1932426 | 1932426 | 2021-11-19 | Defiance | Ohio | 39039 | 6971 | 114 |
1929175 | 1929175 | 2021-11-18 | Defiance | Ohio | 39039 | 6938 | 112 |
1925925 | 1925925 | 2021-11-17 | Defiance | Ohio | 39039 | 6896 | 112 |
1922675 | 1922675 | 2021-11-16 | Defiance | Ohio | 39039 | 6855 | 112 |
1919426 | 1919426 | 2021-11-15 | Defiance | Ohio | 39039 | 6823 | 111 |
1916176 | 1916176 | 2021-11-14 | Defiance | Ohio | 39039 | 6803 | 111 |
1912926 | 1912926 | 2021-11-13 | Defiance | Ohio | 39039 | 6779 | 111 |
1909676 | 1909676 | 2021-11-12 | Defiance | Ohio | 39039 | 6748 | 111 |
1906427 | 1906427 | 2021-11-11 | Defiance | Ohio | 39039 | 6718 | 111 |
1903178 | 1903178 | 2021-11-10 | Defiance | Ohio | 39039 | 6670 | 111 |
1899928 | 1899928 | 2021-11-09 | Defiance | Ohio | 39039 | 6625 | 111 |
1896678 | 1896678 | 2021-11-08 | Defiance | Ohio | 39039 | 6590 | 110 |
1893428 | 1893428 | 2021-11-07 | Defiance | Ohio | 39039 | 6571 | 110 |
1890178 | 1890178 | 2021-11-06 | Defiance | Ohio | 39039 | 6546 | 110 |
1886928 | 1886928 | 2021-11-05 | Defiance | Ohio | 39039 | 6531 | 110 |
1883678 | 1883678 | 2021-11-04 | Defiance | Ohio | 39039 | 6489 | 109 |
1880429 | 1880429 | 2021-11-03 | Defiance | Ohio | 39039 | 6449 | 109 |
1877180 | 1877180 | 2021-11-02 | Defiance | Ohio | 39039 | 6410 | 109 |
1873931 | 1873931 | 2021-11-01 | Defiance | Ohio | 39039 | 6385 | 108 |
1870682 | 1870682 | 2021-10-31 | Defiance | Ohio | 39039 | 6379 | 108 |
1867433 | 1867433 | 2021-10-30 | Defiance | Ohio | 39039 | 6365 | 108 |
1864184 | 1864184 | 2021-10-29 | Defiance | Ohio | 39039 | 6356 | 108 |
1860935 | 1860935 | 2021-10-28 | Defiance | Ohio | 39039 | 6329 | 105 |
1857686 | 1857686 | 2021-10-27 | Defiance | Ohio | 39039 | 6295 | 105 |
1854437 | 1854437 | 2021-10-26 | Defiance | Ohio | 39039 | 6268 | 105 |
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);