ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Sherman" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176454 | 2176454 | 2022-02-02 | Sherman | Oregon | 41055 | 292 | 3 |
2173200 | 2173200 | 2022-02-01 | Sherman | Oregon | 41055 | 290 | 3 |
2169948 | 2169948 | 2022-01-31 | Sherman | Oregon | 41055 | 289 | 3 |
2166693 | 2166693 | 2022-01-30 | Sherman | Oregon | 41055 | 290 | 3 |
2163438 | 2163438 | 2022-01-29 | Sherman | Oregon | 41055 | 290 | 3 |
2160183 | 2160183 | 2022-01-28 | Sherman | Oregon | 41055 | 290 | 3 |
2156928 | 2156928 | 2022-01-27 | Sherman | Oregon | 41055 | 288 | 3 |
2153675 | 2153675 | 2022-01-26 | Sherman | Oregon | 41055 | 283 | 3 |
2150423 | 2150423 | 2022-01-25 | Sherman | Oregon | 41055 | 277 | 3 |
2147171 | 2147171 | 2022-01-24 | Sherman | Oregon | 41055 | 270 | 3 |
2143917 | 2143917 | 2022-01-23 | Sherman | Oregon | 41055 | 233 | 3 |
2140662 | 2140662 | 2022-01-22 | Sherman | Oregon | 41055 | 233 | 3 |
2137406 | 2137406 | 2022-01-21 | Sherman | Oregon | 41055 | 233 | 3 |
2134152 | 2134152 | 2022-01-20 | Sherman | Oregon | 41055 | 233 | 3 |
2130900 | 2130900 | 2022-01-19 | Sherman | Oregon | 41055 | 230 | 3 |
2127646 | 2127646 | 2022-01-18 | Sherman | Oregon | 41055 | 230 | 3 |
2124394 | 2124394 | 2022-01-17 | Sherman | Oregon | 41055 | 228 | 3 |
2121142 | 2121142 | 2022-01-16 | Sherman | Oregon | 41055 | 228 | 3 |
2117890 | 2117890 | 2022-01-15 | Sherman | Oregon | 41055 | 228 | 3 |
2114639 | 2114639 | 2022-01-14 | Sherman | Oregon | 41055 | 228 | 3 |
2111387 | 2111387 | 2022-01-13 | Sherman | Oregon | 41055 | 224 | 3 |
2108135 | 2108135 | 2022-01-12 | Sherman | Oregon | 41055 | 223 | 3 |
2104884 | 2104884 | 2022-01-11 | Sherman | Oregon | 41055 | 216 | 3 |
2101633 | 2101633 | 2022-01-10 | Sherman | Oregon | 41055 | 213 | 3 |
2098382 | 2098382 | 2022-01-09 | Sherman | Oregon | 41055 | 212 | 3 |
2095130 | 2095130 | 2022-01-08 | Sherman | Oregon | 41055 | 212 | 3 |
2091878 | 2091878 | 2022-01-07 | Sherman | Oregon | 41055 | 212 | 3 |
2088626 | 2088626 | 2022-01-06 | Sherman | Oregon | 41055 | 210 | 3 |
2085375 | 2085375 | 2022-01-05 | Sherman | Oregon | 41055 | 208 | 3 |
2082123 | 2082123 | 2022-01-04 | Sherman | Oregon | 41055 | 208 | 3 |
2078871 | 2078871 | 2022-01-03 | Sherman | Oregon | 41055 | 201 | 3 |
2075620 | 2075620 | 2022-01-02 | Sherman | Oregon | 41055 | 201 | 3 |
2072369 | 2072369 | 2022-01-01 | Sherman | Oregon | 41055 | 201 | 3 |
2069118 | 2069118 | 2021-12-31 | Sherman | Oregon | 41055 | 201 | 3 |
2065867 | 2065867 | 2021-12-30 | Sherman | Oregon | 41055 | 201 | 3 |
2062617 | 2062617 | 2021-12-29 | Sherman | Oregon | 41055 | 198 | 3 |
2059367 | 2059367 | 2021-12-28 | Sherman | Oregon | 41055 | 198 | 3 |
2056118 | 2056118 | 2021-12-27 | Sherman | Oregon | 41055 | 198 | 3 |
2052869 | 2052869 | 2021-12-26 | Sherman | Oregon | 41055 | 198 | 3 |
2049619 | 2049619 | 2021-12-25 | Sherman | Oregon | 41055 | 198 | 3 |
2046369 | 2046369 | 2021-12-24 | Sherman | Oregon | 41055 | 198 | 3 |
2043119 | 2043119 | 2021-12-23 | Sherman | Oregon | 41055 | 198 | 3 |
2039870 | 2039870 | 2021-12-22 | Sherman | Oregon | 41055 | 197 | 3 |
2036620 | 2036620 | 2021-12-21 | Sherman | Oregon | 41055 | 197 | 3 |
2033370 | 2033370 | 2021-12-20 | Sherman | Oregon | 41055 | 196 | 3 |
2030120 | 2030120 | 2021-12-19 | Sherman | Oregon | 41055 | 195 | 3 |
2026869 | 2026869 | 2021-12-18 | Sherman | Oregon | 41055 | 195 | 3 |
2023618 | 2023618 | 2021-12-17 | Sherman | Oregon | 41055 | 195 | 3 |
2020367 | 2020367 | 2021-12-16 | Sherman | Oregon | 41055 | 195 | 3 |
2017116 | 2017116 | 2021-12-15 | Sherman | Oregon | 41055 | 195 | 3 |
2013866 | 2013866 | 2021-12-14 | Sherman | Oregon | 41055 | 195 | 3 |
2010615 | 2010615 | 2021-12-13 | Sherman | Oregon | 41055 | 195 | 3 |
2007364 | 2007364 | 2021-12-12 | Sherman | Oregon | 41055 | 195 | 3 |
2004113 | 2004113 | 2021-12-11 | Sherman | Oregon | 41055 | 195 | 3 |
2000862 | 2000862 | 2021-12-10 | Sherman | Oregon | 41055 | 195 | 3 |
1997612 | 1997612 | 2021-12-09 | Sherman | Oregon | 41055 | 195 | 3 |
1994361 | 1994361 | 2021-12-08 | Sherman | Oregon | 41055 | 195 | 3 |
1991110 | 1991110 | 2021-12-07 | Sherman | Oregon | 41055 | 195 | 3 |
1987859 | 1987859 | 2021-12-06 | Sherman | Oregon | 41055 | 193 | 3 |
1984609 | 1984609 | 2021-12-05 | Sherman | Oregon | 41055 | 193 | 3 |
1981359 | 1981359 | 2021-12-04 | Sherman | Oregon | 41055 | 193 | 3 |
1978109 | 1978109 | 2021-12-03 | Sherman | Oregon | 41055 | 193 | 3 |
1974859 | 1974859 | 2021-12-02 | Sherman | Oregon | 41055 | 191 | 3 |
1971610 | 1971610 | 2021-12-01 | Sherman | Oregon | 41055 | 191 | 3 |
1968360 | 1968360 | 2021-11-30 | Sherman | Oregon | 41055 | 191 | 3 |
1965109 | 1965109 | 2021-11-29 | Sherman | Oregon | 41055 | 190 | 3 |
1961857 | 1961857 | 2021-11-28 | Sherman | Oregon | 41055 | 190 | 3 |
1958606 | 1958606 | 2021-11-27 | Sherman | Oregon | 41055 | 190 | 3 |
1955355 | 1955355 | 2021-11-26 | Sherman | Oregon | 41055 | 190 | 3 |
1952104 | 1952104 | 2021-11-25 | Sherman | Oregon | 41055 | 190 | 3 |
1948853 | 1948853 | 2021-11-24 | Sherman | Oregon | 41055 | 190 | 3 |
1945602 | 1945602 | 2021-11-23 | Sherman | Oregon | 41055 | 190 | 3 |
1942351 | 1942351 | 2021-11-22 | Sherman | Oregon | 41055 | 188 | 3 |
1939101 | 1939101 | 2021-11-21 | Sherman | Oregon | 41055 | 188 | 3 |
1935851 | 1935851 | 2021-11-20 | Sherman | Oregon | 41055 | 188 | 3 |
1932601 | 1932601 | 2021-11-19 | Sherman | Oregon | 41055 | 188 | 3 |
1929350 | 1929350 | 2021-11-18 | Sherman | Oregon | 41055 | 188 | 3 |
1926100 | 1926100 | 2021-11-17 | Sherman | Oregon | 41055 | 185 | 3 |
1922850 | 1922850 | 2021-11-16 | Sherman | Oregon | 41055 | 185 | 3 |
1919601 | 1919601 | 2021-11-15 | Sherman | Oregon | 41055 | 184 | 3 |
1916351 | 1916351 | 2021-11-14 | Sherman | Oregon | 41055 | 178 | 3 |
1913101 | 1913101 | 2021-11-13 | Sherman | Oregon | 41055 | 178 | 3 |
1909851 | 1909851 | 2021-11-12 | Sherman | Oregon | 41055 | 178 | 3 |
1906602 | 1906602 | 2021-11-11 | Sherman | Oregon | 41055 | 176 | 3 |
1903353 | 1903353 | 2021-11-10 | Sherman | Oregon | 41055 | 176 | 3 |
1900103 | 1900103 | 2021-11-09 | Sherman | Oregon | 41055 | 175 | 3 |
1896853 | 1896853 | 2021-11-08 | Sherman | Oregon | 41055 | 175 | 3 |
1893603 | 1893603 | 2021-11-07 | Sherman | Oregon | 41055 | 175 | 3 |
1890353 | 1890353 | 2021-11-06 | Sherman | Oregon | 41055 | 175 | 3 |
1887103 | 1887103 | 2021-11-05 | Sherman | Oregon | 41055 | 175 | 3 |
1883853 | 1883853 | 2021-11-04 | Sherman | Oregon | 41055 | 175 | 3 |
1880604 | 1880604 | 2021-11-03 | Sherman | Oregon | 41055 | 172 | 3 |
1877355 | 1877355 | 2021-11-02 | Sherman | Oregon | 41055 | 172 | 3 |
1874106 | 1874106 | 2021-11-01 | Sherman | Oregon | 41055 | 165 | 3 |
1870857 | 1870857 | 2021-10-31 | Sherman | Oregon | 41055 | 164 | 3 |
1867608 | 1867608 | 2021-10-30 | Sherman | Oregon | 41055 | 164 | 3 |
1864359 | 1864359 | 2021-10-29 | Sherman | Oregon | 41055 | 164 | 3 |
1861110 | 1861110 | 2021-10-28 | Sherman | Oregon | 41055 | 160 | 3 |
1857861 | 1857861 | 2021-10-27 | Sherman | Oregon | 41055 | 160 | 3 |
1854612 | 1854612 | 2021-10-26 | Sherman | Oregon | 41055 | 157 | 3 |
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);