ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 21 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
770143 | 770143 | 2020-11-26 | Gilliam | Oregon | 41021 | 21 | 0 |
766897 | 766897 | 2020-11-25 | Gilliam | Oregon | 41021 | 21 | 0 |
763652 | 763652 | 2020-11-24 | Gilliam | Oregon | 41021 | 21 | 0 |
760407 | 760407 | 2020-11-23 | Gilliam | Oregon | 41021 | 21 | 0 |
757162 | 757162 | 2020-11-22 | Gilliam | Oregon | 41021 | 21 | 0 |
753915 | 753915 | 2020-11-21 | Gilliam | Oregon | 41021 | 21 | 0 |
750669 | 750669 | 2020-11-20 | Gilliam | Oregon | 41021 | 21 | 0 |
747423 | 747423 | 2020-11-19 | Gilliam | Oregon | 41021 | 21 | 0 |
744177 | 744177 | 2020-11-18 | Gilliam | Oregon | 41021 | 21 | 0 |
692291 | 692291 | 2020-11-02 | Sherman | Oregon | 41055 | 21 | 0 |
659840 | 659840 | 2020-10-23 | Harney | Oregon | 41025 | 21 | 0 |
497832 | 497832 | 2020-09-03 | Curry | Oregon | 41015 | 21 | 0 |
494599 | 494599 | 2020-09-02 | Curry | Oregon | 41015 | 21 | 0 |
465527 | 465527 | 2020-08-24 | Wallowa | Oregon | 41063 | 21 | 1 |
462298 | 462298 | 2020-08-23 | Wallowa | Oregon | 41063 | 21 | 1 |
459070 | 459070 | 2020-08-22 | Wallowa | Oregon | 41063 | 21 | 1 |
455842 | 455842 | 2020-08-21 | Wallowa | Oregon | 41063 | 21 | 1 |
452614 | 452614 | 2020-08-20 | Wallowa | Oregon | 41063 | 21 | 1 |
449386 | 449386 | 2020-08-19 | Wallowa | Oregon | 41063 | 21 | 1 |
446158 | 446158 | 2020-08-18 | Wallowa | Oregon | 41063 | 21 | 1 |
442932 | 442932 | 2020-08-17 | Wallowa | Oregon | 41063 | 21 | 1 |
439705 | 439705 | 2020-08-16 | Wallowa | Oregon | 41063 | 21 | 1 |
436480 | 436480 | 2020-08-15 | Wallowa | Oregon | 41063 | 21 | 1 |
308212 | 308212 | 2020-07-06 | Lake | Oregon | 41037 | 21 | 0 |
305045 | 305045 | 2020-07-05 | Lake | Oregon | 41037 | 21 | 0 |
301882 | 301882 | 2020-07-04 | Lake | Oregon | 41037 | 21 | 0 |
236047 | 236047 | 2020-06-13 | Columbia | Oregon | 41009 | 21 | 0 |
186714 | 186714 | 2020-05-28 | Wasco | Oregon | 41065 | 21 | 1 |
162364 | 162364 | 2020-05-20 | Malheur | Oregon | 41045 | 21 | 0 |
159337 | 159337 | 2020-05-19 | Malheur | Oregon | 41045 | 21 | 0 |
156316 | 156316 | 2020-05-18 | Malheur | Oregon | 41045 | 21 | 0 |
108755 | 108755 | 2020-05-02 | Coos | Oregon | 41011 | 21 | 0 |
108765 | 108765 | 2020-05-02 | Josephine | Oregon | 41033 | 21 | 1 |
105888 | 105888 | 2020-05-01 | Coos | Oregon | 41011 | 21 | 0 |
105898 | 105898 | 2020-05-01 | Josephine | Oregon | 41033 | 21 | 1 |
47646 | 47646 | 2020-04-10 | Benton | Oregon | 41003 | 21 | 2 |
45029 | 45029 | 2020-04-09 | Benton | Oregon | 41003 | 21 | 2 |
42443 | 42443 | 2020-04-08 | Benton | Oregon | 41003 | 21 | 1 |
39883 | 39883 | 2020-04-07 | Benton | Oregon | 41003 | 21 | 1 |
37362 | 37362 | 2020-04-06 | Benton | Oregon | 41003 | 21 | 1 |
30076 | 30076 | 2020-04-03 | Lane | Oregon | 41039 | 21 | 1 |
27743 | 27743 | 2020-04-02 | Lane | Oregon | 41039 | 21 | 1 |
23270 | 23270 | 2020-03-31 | Jackson | Oregon | 41029 | 21 | 0 |
13551 | 13551 | 2020-03-26 | Clackamas | Oregon | 41005 | 21 | 2 |
11935 | 11935 | 2020-03-25 | Clackamas | Oregon | 41005 | 21 | 2 |
9167 | 9167 | 2020-03-23 | Multnomah | Oregon | 41051 | 21 | 1 |
3621 | 3621 | 2020-03-17 | Washington | Oregon | 41067 | 21 | 0 |
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);