ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 188 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
county 10
state 1
- Oregon · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2244737 | 2244737 | 2022-02-23 | Klamath | Oregon | 41035 | 13870 | 188 |
2241486 | 2241486 | 2022-02-22 | Klamath | Oregon | 41035 | 13861 | 188 |
2238235 | 2238235 | 2022-02-21 | Klamath | Oregon | 41035 | 13804 | 188 |
2234984 | 2234984 | 2022-02-20 | Klamath | Oregon | 41035 | 13804 | 188 |
2231733 | 2231733 | 2022-02-19 | Klamath | Oregon | 41035 | 13804 | 188 |
2228482 | 2228482 | 2022-02-18 | Klamath | Oregon | 41035 | 13804 | 188 |
2225231 | 2225231 | 2022-02-17 | Klamath | Oregon | 41035 | 13757 | 188 |
2225249 | 2225249 | 2022-02-17 | Yamhill | Oregon | 41071 | 17298 | 188 |
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 |
1997606 | 1997606 | 2021-12-09 | Linn | Oregon | 41043 | 15113 | 188 |
1805863 | 1805863 | 2021-10-11 | Josephine | Oregon | 41033 | 9150 | 188 |
1740875 | 1740875 | 2021-09-21 | Douglas | Oregon | 41019 | 10795 | 188 |
1737626 | 1737626 | 2021-09-20 | Douglas | Oregon | 41019 | 10712 | 188 |
1666167 | 1666167 | 2021-08-29 | Lane | Oregon | 41039 | 20056 | 188 |
1662919 | 1662919 | 2021-08-28 | Lane | Oregon | 41039 | 20056 | 188 |
1659671 | 1659671 | 2021-08-27 | Lane | Oregon | 41039 | 20056 | 188 |
1656422 | 1656422 | 2021-08-26 | Lane | Oregon | 41039 | 19759 | 188 |
977865 | 977865 | 2021-01-29 | Washington | Oregon | 41067 | 19687 | 188 |
835064 | 835064 | 2020-12-16 | Marion | Oregon | 41047 | 11892 | 188 |
718235 | 718235 | 2020-11-10 | Multnomah | Oregon | 41051 | 11497 | 188 |
714992 | 714992 | 2020-11-09 | Multnomah | Oregon | 41051 | 11348 | 188 |
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);