ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Umatilla" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176456 | 2176456 | 2022-02-02 | Umatilla | Oregon | 41059 | 21278 | 194 |
2173202 | 2173202 | 2022-02-01 | Umatilla | Oregon | 41059 | 21164 | 194 |
2169950 | 2169950 | 2022-01-31 | Umatilla | Oregon | 41059 | 21069 | 194 |
2166695 | 2166695 | 2022-01-30 | Umatilla | Oregon | 41059 | 20801 | 193 |
2163440 | 2163440 | 2022-01-29 | Umatilla | Oregon | 41059 | 20801 | 193 |
2160185 | 2160185 | 2022-01-28 | Umatilla | Oregon | 41059 | 20801 | 193 |
2156930 | 2156930 | 2022-01-27 | Umatilla | Oregon | 41059 | 20623 | 192 |
2153677 | 2153677 | 2022-01-26 | Umatilla | Oregon | 41059 | 20443 | 192 |
2150425 | 2150425 | 2022-01-25 | Umatilla | Oregon | 41059 | 20245 | 190 |
2147173 | 2147173 | 2022-01-24 | Umatilla | Oregon | 41059 | 20036 | 190 |
2143919 | 2143919 | 2022-01-23 | Umatilla | Oregon | 41059 | 19500 | 190 |
2140664 | 2140664 | 2022-01-22 | Umatilla | Oregon | 41059 | 19500 | 190 |
2137408 | 2137408 | 2022-01-21 | Umatilla | Oregon | 41059 | 19500 | 190 |
2134154 | 2134154 | 2022-01-20 | Umatilla | Oregon | 41059 | 19183 | 190 |
2130902 | 2130902 | 2022-01-19 | Umatilla | Oregon | 41059 | 18893 | 190 |
2127648 | 2127648 | 2022-01-18 | Umatilla | Oregon | 41059 | 18593 | 190 |
2124396 | 2124396 | 2022-01-17 | Umatilla | Oregon | 41059 | 17891 | 190 |
2121144 | 2121144 | 2022-01-16 | Umatilla | Oregon | 41059 | 17891 | 190 |
2117892 | 2117892 | 2022-01-15 | Umatilla | Oregon | 41059 | 17891 | 190 |
2114641 | 2114641 | 2022-01-14 | Umatilla | Oregon | 41059 | 17891 | 190 |
2111389 | 2111389 | 2022-01-13 | Umatilla | Oregon | 41059 | 17642 | 190 |
2108137 | 2108137 | 2022-01-12 | Umatilla | Oregon | 41059 | 17375 | 189 |
2104886 | 2104886 | 2022-01-11 | Umatilla | Oregon | 41059 | 17052 | 188 |
2101635 | 2101635 | 2022-01-10 | Umatilla | Oregon | 41059 | 16738 | 188 |
2098384 | 2098384 | 2022-01-09 | Umatilla | Oregon | 41059 | 16525 | 188 |
2095132 | 2095132 | 2022-01-08 | Umatilla | Oregon | 41059 | 16525 | 188 |
2091880 | 2091880 | 2022-01-07 | Umatilla | Oregon | 41059 | 16525 | 188 |
2088628 | 2088628 | 2022-01-06 | Umatilla | Oregon | 41059 | 16357 | 187 |
2085377 | 2085377 | 2022-01-05 | Umatilla | Oregon | 41059 | 16051 | 187 |
2082125 | 2082125 | 2022-01-04 | Umatilla | Oregon | 41059 | 15834 | 187 |
2078873 | 2078873 | 2022-01-03 | Umatilla | Oregon | 41059 | 15725 | 187 |
2075622 | 2075622 | 2022-01-02 | Umatilla | Oregon | 41059 | 15664 | 187 |
2072371 | 2072371 | 2022-01-01 | Umatilla | Oregon | 41059 | 15664 | 187 |
2069120 | 2069120 | 2021-12-31 | Umatilla | Oregon | 41059 | 15664 | 187 |
2065869 | 2065869 | 2021-12-30 | Umatilla | Oregon | 41059 | 15664 | 187 |
2062619 | 2062619 | 2021-12-29 | Umatilla | Oregon | 41059 | 15542 | 187 |
2059369 | 2059369 | 2021-12-28 | Umatilla | Oregon | 41059 | 15452 | 187 |
2056120 | 2056120 | 2021-12-27 | Umatilla | Oregon | 41059 | 15373 | 187 |
2052871 | 2052871 | 2021-12-26 | Umatilla | Oregon | 41059 | 15337 | 186 |
2049621 | 2049621 | 2021-12-25 | Umatilla | Oregon | 41059 | 15337 | 186 |
2046371 | 2046371 | 2021-12-24 | Umatilla | Oregon | 41059 | 15337 | 186 |
2043121 | 2043121 | 2021-12-23 | Umatilla | Oregon | 41059 | 15337 | 186 |
2039872 | 2039872 | 2021-12-22 | Umatilla | Oregon | 41059 | 15312 | 186 |
2036622 | 2036622 | 2021-12-21 | Umatilla | Oregon | 41059 | 15299 | 186 |
2033372 | 2033372 | 2021-12-20 | Umatilla | Oregon | 41059 | 15287 | 186 |
2030122 | 2030122 | 2021-12-19 | Umatilla | Oregon | 41059 | 15278 | 185 |
2026871 | 2026871 | 2021-12-18 | Umatilla | Oregon | 41059 | 15278 | 185 |
2023620 | 2023620 | 2021-12-17 | Umatilla | Oregon | 41059 | 15278 | 185 |
2020369 | 2020369 | 2021-12-16 | Umatilla | Oregon | 41059 | 15268 | 185 |
2017118 | 2017118 | 2021-12-15 | Umatilla | Oregon | 41059 | 15254 | 185 |
2013868 | 2013868 | 2021-12-14 | Umatilla | Oregon | 41059 | 15239 | 185 |
2010617 | 2010617 | 2021-12-13 | Umatilla | Oregon | 41059 | 15217 | 185 |
2007366 | 2007366 | 2021-12-12 | Umatilla | Oregon | 41059 | 15209 | 184 |
2004115 | 2004115 | 2021-12-11 | Umatilla | Oregon | 41059 | 15209 | 184 |
2000864 | 2000864 | 2021-12-10 | Umatilla | Oregon | 41059 | 15209 | 184 |
1997614 | 1997614 | 2021-12-09 | Umatilla | Oregon | 41059 | 15198 | 184 |
1994363 | 1994363 | 2021-12-08 | Umatilla | Oregon | 41059 | 15191 | 184 |
1991112 | 1991112 | 2021-12-07 | Umatilla | Oregon | 41059 | 15178 | 184 |
1987861 | 1987861 | 2021-12-06 | Umatilla | Oregon | 41059 | 15155 | 184 |
1984611 | 1984611 | 2021-12-05 | Umatilla | Oregon | 41059 | 15144 | 184 |
1981361 | 1981361 | 2021-12-04 | Umatilla | Oregon | 41059 | 15144 | 184 |
1978111 | 1978111 | 2021-12-03 | Umatilla | Oregon | 41059 | 15144 | 184 |
1974861 | 1974861 | 2021-12-02 | Umatilla | Oregon | 41059 | 15141 | 183 |
1971612 | 1971612 | 2021-12-01 | Umatilla | Oregon | 41059 | 15135 | 182 |
1968362 | 1968362 | 2021-11-30 | Umatilla | Oregon | 41059 | 15126 | 180 |
1965111 | 1965111 | 2021-11-29 | Umatilla | Oregon | 41059 | 15098 | 180 |
1961859 | 1961859 | 2021-11-28 | Umatilla | Oregon | 41059 | 15087 | 180 |
1958608 | 1958608 | 2021-11-27 | Umatilla | Oregon | 41059 | 15087 | 180 |
1955357 | 1955357 | 2021-11-26 | Umatilla | Oregon | 41059 | 15087 | 180 |
1952106 | 1952106 | 2021-11-25 | Umatilla | Oregon | 41059 | 15087 | 180 |
1948855 | 1948855 | 2021-11-24 | Umatilla | Oregon | 41059 | 15087 | 180 |
1945604 | 1945604 | 2021-11-23 | Umatilla | Oregon | 41059 | 15072 | 179 |
1942353 | 1942353 | 2021-11-22 | Umatilla | Oregon | 41059 | 15057 | 177 |
1939103 | 1939103 | 2021-11-21 | Umatilla | Oregon | 41059 | 15042 | 176 |
1935853 | 1935853 | 2021-11-20 | Umatilla | Oregon | 41059 | 15042 | 176 |
1932603 | 1932603 | 2021-11-19 | Umatilla | Oregon | 41059 | 15042 | 176 |
1929352 | 1929352 | 2021-11-18 | Umatilla | Oregon | 41059 | 15020 | 170 |
1926102 | 1926102 | 2021-11-17 | Umatilla | Oregon | 41059 | 15004 | 170 |
1922852 | 1922852 | 2021-11-16 | Umatilla | Oregon | 41059 | 14994 | 169 |
1919603 | 1919603 | 2021-11-15 | Umatilla | Oregon | 41059 | 14973 | 169 |
1916353 | 1916353 | 2021-11-14 | Umatilla | Oregon | 41059 | 14945 | 166 |
1913103 | 1913103 | 2021-11-13 | Umatilla | Oregon | 41059 | 14945 | 166 |
1909853 | 1909853 | 2021-11-12 | Umatilla | Oregon | 41059 | 14945 | 166 |
1906604 | 1906604 | 2021-11-11 | Umatilla | Oregon | 41059 | 14923 | 166 |
1903355 | 1903355 | 2021-11-10 | Umatilla | Oregon | 41059 | 14923 | 166 |
1900105 | 1900105 | 2021-11-09 | Umatilla | Oregon | 41059 | 14896 | 166 |
1896855 | 1896855 | 2021-11-08 | Umatilla | Oregon | 41059 | 14849 | 165 |
1893605 | 1893605 | 2021-11-07 | Umatilla | Oregon | 41059 | 14820 | 164 |
1890355 | 1890355 | 2021-11-06 | Umatilla | Oregon | 41059 | 14820 | 164 |
1887105 | 1887105 | 2021-11-05 | Umatilla | Oregon | 41059 | 14820 | 164 |
1883855 | 1883855 | 2021-11-04 | Umatilla | Oregon | 41059 | 14785 | 160 |
1880606 | 1880606 | 2021-11-03 | Umatilla | Oregon | 41059 | 14758 | 155 |
1877357 | 1877357 | 2021-11-02 | Umatilla | Oregon | 41059 | 14728 | 155 |
1874108 | 1874108 | 2021-11-01 | Umatilla | Oregon | 41059 | 14696 | 153 |
1870859 | 1870859 | 2021-10-31 | Umatilla | Oregon | 41059 | 14673 | 152 |
1867610 | 1867610 | 2021-10-30 | Umatilla | Oregon | 41059 | 14673 | 152 |
1864361 | 1864361 | 2021-10-29 | Umatilla | Oregon | 41059 | 14673 | 152 |
1861112 | 1861112 | 2021-10-28 | Umatilla | Oregon | 41059 | 14645 | 152 |
1857863 | 1857863 | 2021-10-27 | Umatilla | Oregon | 41059 | 14616 | 151 |
1854614 | 1854614 | 2021-10-26 | Umatilla | Oregon | 41059 | 14567 | 151 |
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);