ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where cases = 3 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 |
---|---|---|---|---|---|---|---|
783148 | 783148 | 2020-11-30 | Wheeler | Oregon | 41069 | 3 | 0 |
779903 | 779903 | 2020-11-29 | Wheeler | Oregon | 41069 | 3 | 0 |
776657 | 776657 | 2020-11-28 | Wheeler | Oregon | 41069 | 3 | 0 |
773412 | 773412 | 2020-11-27 | Wheeler | Oregon | 41069 | 3 | 0 |
770167 | 770167 | 2020-11-26 | Wheeler | Oregon | 41069 | 3 | 0 |
766921 | 766921 | 2020-11-25 | Wheeler | Oregon | 41069 | 3 | 0 |
763676 | 763676 | 2020-11-24 | Wheeler | Oregon | 41069 | 3 | 0 |
760431 | 760431 | 2020-11-23 | Wheeler | Oregon | 41069 | 3 | 0 |
407455 | 407455 | 2020-08-06 | Grant | Oregon | 41023 | 3 | 0 |
384935 | 384935 | 2020-07-30 | Gilliam | Oregon | 41021 | 3 | 0 |
381717 | 381717 | 2020-07-29 | Gilliam | Oregon | 41021 | 3 | 0 |
378500 | 378500 | 2020-07-28 | Gilliam | Oregon | 41021 | 3 | 0 |
375284 | 375284 | 2020-07-27 | Gilliam | Oregon | 41021 | 3 | 0 |
372071 | 372071 | 2020-07-26 | Gilliam | Oregon | 41021 | 3 | 0 |
368859 | 368859 | 2020-07-25 | Gilliam | Oregon | 41021 | 3 | 0 |
365650 | 365650 | 2020-07-24 | Gilliam | Oregon | 41021 | 3 | 0 |
352833 | 352833 | 2020-07-20 | Harney | Oregon | 41025 | 3 | 0 |
320913 | 320913 | 2020-07-10 | Sherman | Oregon | 41055 | 3 | 0 |
317735 | 317735 | 2020-07-09 | Sherman | Oregon | 41055 | 3 | 0 |
314562 | 314562 | 2020-07-08 | Sherman | Oregon | 41055 | 3 | 0 |
311390 | 311390 | 2020-07-07 | Sherman | Oregon | 41055 | 3 | 0 |
308221 | 308221 | 2020-07-06 | Sherman | Oregon | 41055 | 3 | 0 |
305054 | 305054 | 2020-07-05 | Sherman | Oregon | 41055 | 3 | 0 |
226759 | 226759 | 2020-06-10 | Wallowa | Oregon | 41063 | 3 | 0 |
223659 | 223659 | 2020-06-09 | Wallowa | Oregon | 41063 | 3 | 0 |
220564 | 220564 | 2020-06-08 | Wallowa | Oregon | 41063 | 3 | 0 |
217472 | 217472 | 2020-06-07 | Wallowa | Oregon | 41063 | 3 | 0 |
214382 | 214382 | 2020-06-06 | Wallowa | Oregon | 41063 | 3 | 0 |
147261 | 147261 | 2020-05-15 | Baker | Oregon | 41001 | 3 | 0 |
80425 | 80425 | 2020-04-22 | Coos | Oregon | 41011 | 3 | 0 |
66555 | 66555 | 2020-04-17 | Curry | Oregon | 41015 | 3 | 0 |
63809 | 63809 | 2020-04-16 | Curry | Oregon | 41015 | 3 | 0 |
61083 | 61083 | 2020-04-15 | Curry | Oregon | 41015 | 3 | 0 |
58368 | 58368 | 2020-04-14 | Curry | Oregon | 41015 | 3 | 0 |
55666 | 55666 | 2020-04-13 | Curry | Oregon | 41015 | 3 | 0 |
52981 | 52981 | 2020-04-12 | Curry | Oregon | 41015 | 3 | 0 |
50308 | 50308 | 2020-04-11 | Curry | Oregon | 41015 | 3 | 0 |
50319 | 50319 | 2020-04-11 | Malheur | Oregon | 41045 | 3 | 0 |
47651 | 47651 | 2020-04-10 | Curry | Oregon | 41015 | 3 | 0 |
47670 | 47670 | 2020-04-10 | Union | Oregon | 41061 | 3 | 0 |
45034 | 45034 | 2020-04-09 | Curry | Oregon | 41015 | 3 | 0 |
45038 | 45038 | 2020-04-09 | Hood River | Oregon | 41027 | 3 | 0 |
45053 | 45053 | 2020-04-09 | Union | Oregon | 41061 | 3 | 0 |
42452 | 42452 | 2020-04-08 | Hood River | Oregon | 41027 | 3 | 0 |
42461 | 42461 | 2020-04-08 | Morrow | Oregon | 41049 | 3 | 0 |
42465 | 42465 | 2020-04-08 | Tillamook | Oregon | 41057 | 3 | 0 |
42467 | 42467 | 2020-04-08 | Union | Oregon | 41061 | 3 | 0 |
39905 | 39905 | 2020-04-07 | Tillamook | Oregon | 41057 | 3 | 0 |
39907 | 39907 | 2020-04-07 | Union | Oregon | 41061 | 3 | 0 |
37384 | 37384 | 2020-04-06 | Tillamook | Oregon | 41057 | 3 | 0 |
37386 | 37386 | 2020-04-06 | Union | Oregon | 41061 | 3 | 0 |
34909 | 34909 | 2020-04-05 | Tillamook | Oregon | 41057 | 3 | 0 |
34911 | 34911 | 2020-04-05 | Union | Oregon | 41061 | 3 | 0 |
32457 | 32457 | 2020-04-04 | Columbia | Oregon | 41009 | 3 | 0 |
32462 | 32462 | 2020-04-04 | Hood River | Oregon | 41027 | 3 | 0 |
32474 | 32474 | 2020-04-04 | Tillamook | Oregon | 41057 | 3 | 0 |
32476 | 32476 | 2020-04-04 | Union | Oregon | 41061 | 3 | 0 |
30072 | 30072 | 2020-04-03 | Hood River | Oregon | 41027 | 3 | 0 |
30084 | 30084 | 2020-04-03 | Tillamook | Oregon | 41057 | 3 | 0 |
30086 | 30086 | 2020-04-03 | Union | Oregon | 41061 | 3 | 0 |
27734 | 27734 | 2020-04-02 | Clatsop | Oregon | 41007 | 3 | 0 |
27739 | 27739 | 2020-04-02 | Hood River | Oregon | 41027 | 3 | 0 |
27751 | 27751 | 2020-04-02 | Tillamook | Oregon | 41057 | 3 | 0 |
27753 | 27753 | 2020-04-02 | Union | Oregon | 41061 | 3 | 0 |
25462 | 25462 | 2020-04-01 | Clatsop | Oregon | 41007 | 3 | 0 |
25467 | 25467 | 2020-04-01 | Hood River | Oregon | 41027 | 3 | 0 |
25472 | 25472 | 2020-04-01 | Lincoln | Oregon | 41041 | 3 | 0 |
25479 | 25479 | 2020-04-01 | Tillamook | Oregon | 41057 | 3 | 0 |
23264 | 23264 | 2020-03-31 | Clatsop | Oregon | 41007 | 3 | 0 |
23269 | 23269 | 2020-03-31 | Hood River | Oregon | 41027 | 3 | 0 |
23281 | 23281 | 2020-03-31 | Tillamook | Oregon | 41057 | 3 | 0 |
21131 | 21131 | 2020-03-30 | Clatsop | Oregon | 41007 | 3 | 0 |
21147 | 21147 | 2020-03-30 | Tillamook | Oregon | 41057 | 3 | 0 |
19081 | 19081 | 2020-03-29 | Clatsop | Oregon | 41007 | 3 | 0 |
19100 | 19100 | 2020-03-29 | Wasco | Oregon | 41065 | 3 | 0 |
17143 | 17143 | 2020-03-28 | Clatsop | Oregon | 41007 | 3 | 0 |
15313 | 15313 | 2020-03-27 | Umatilla | Oregon | 41059 | 3 | 0 |
13554 | 13554 | 2020-03-26 | Douglas | Oregon | 41019 | 3 | 0 |
11938 | 11938 | 2020-03-25 | Douglas | Oregon | 41019 | 3 | 0 |
11949 | 11949 | 2020-03-25 | Polk | Oregon | 41053 | 3 | 0 |
10480 | 10480 | 2020-03-24 | Jackson | Oregon | 41029 | 3 | 0 |
10487 | 10487 | 2020-03-24 | Polk | Oregon | 41053 | 3 | 0 |
9168 | 9168 | 2020-03-23 | Polk | Oregon | 41053 | 3 | 0 |
6839 | 6839 | 2020-03-21 | Lane | Oregon | 41039 | 3 | 1 |
4233 | 4233 | 2020-03-18 | Multnomah | Oregon | 41051 | 3 | 1 |
3618 | 3618 | 2020-03-17 | Multnomah | Oregon | 41051 | 3 | 1 |
3088 | 3088 | 2020-03-16 | Marion | Oregon | 41047 | 3 | 0 |
2199 | 2199 | 2020-03-14 | Deschutes | Oregon | 41017 | 3 | 0 |
725 | 725 | 2020-03-07 | Washington | Oregon | 41067 | 3 | 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);