ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 28 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1305776 | 1305776 | 2021-05-10 | Wheeler | Oregon | 41069 | 28 | 1 |
1302530 | 1302530 | 2021-05-09 | Wheeler | Oregon | 41069 | 28 | 1 |
1299283 | 1299283 | 2021-05-08 | Wheeler | Oregon | 41069 | 28 | 1 |
1296036 | 1296036 | 2021-05-07 | Wheeler | Oregon | 41069 | 28 | 1 |
835051 | 835051 | 2020-12-16 | Gilliam | Oregon | 41021 | 28 | 1 |
569054 | 569054 | 2020-09-25 | Wallowa | Oregon | 41063 | 28 | 1 |
565813 | 565813 | 2020-09-24 | Wallowa | Oregon | 41063 | 28 | 1 |
562559 | 562559 | 2020-09-23 | Lake | Oregon | 41037 | 28 | 0 |
562572 | 562572 | 2020-09-23 | Wallowa | Oregon | 41063 | 28 | 1 |
559322 | 559322 | 2020-09-22 | Lake | Oregon | 41037 | 28 | 0 |
559335 | 559335 | 2020-09-22 | Wallowa | Oregon | 41063 | 28 | 1 |
556085 | 556085 | 2020-09-21 | Lake | Oregon | 41037 | 28 | 0 |
556098 | 556098 | 2020-09-21 | Wallowa | Oregon | 41063 | 28 | 1 |
552861 | 552861 | 2020-09-20 | Wallowa | Oregon | 41063 | 28 | 1 |
549622 | 549622 | 2020-09-19 | Wallowa | Oregon | 41063 | 28 | 1 |
546383 | 546383 | 2020-09-18 | Wallowa | Oregon | 41063 | 28 | 1 |
543146 | 543146 | 2020-09-17 | Wallowa | Oregon | 41063 | 28 | 1 |
394603 | 394603 | 2020-08-02 | Tillamook | Oregon | 41057 | 28 | 0 |
388142 | 388142 | 2020-07-31 | Baker | Oregon | 41001 | 28 | 0 |
352827 | 352827 | 2020-07-20 | Crook | Oregon | 41013 | 28 | 1 |
349636 | 349636 | 2020-07-19 | Lake | Oregon | 41037 | 28 | 0 |
279796 | 279796 | 2020-06-27 | Columbia | Oregon | 41009 | 28 | 0 |
276659 | 276659 | 2020-06-26 | Josephine | Oregon | 41033 | 28 | 1 |
208193 | 208193 | 2020-06-04 | Douglas | Oregon | 41019 | 28 | 0 |
208196 | 208196 | 2020-06-04 | Hood River | Oregon | 41027 | 28 | 0 |
205112 | 205112 | 2020-06-03 | Douglas | Oregon | 41019 | 28 | 0 |
205115 | 205115 | 2020-06-03 | Hood River | Oregon | 41027 | 28 | 0 |
205134 | 205134 | 2020-06-03 | Wasco | Oregon | 41065 | 28 | 1 |
189758 | 189758 | 2020-05-29 | Jefferson | Oregon | 41031 | 28 | 0 |
183647 | 183647 | 2020-05-27 | Malheur | Oregon | 41045 | 28 | 0 |
180597 | 180597 | 2020-05-26 | Malheur | Oregon | 41045 | 28 | 0 |
177554 | 177554 | 2020-05-25 | Malheur | Oregon | 41045 | 28 | 0 |
174510 | 174510 | 2020-05-24 | Malheur | Oregon | 41045 | 28 | 0 |
171468 | 171468 | 2020-05-23 | Malheur | Oregon | 41045 | 28 | 0 |
168429 | 168429 | 2020-05-22 | Malheur | Oregon | 41045 | 28 | 0 |
129301 | 129301 | 2020-05-09 | Clatsop | Oregon | 41007 | 28 | 0 |
120354 | 120354 | 2020-05-06 | Coos | Oregon | 41011 | 28 | 0 |
117392 | 117392 | 2020-05-05 | Coos | Oregon | 41011 | 28 | 0 |
88838 | 88838 | 2020-04-25 | Benton | Oregon | 41003 | 28 | 5 |
74849 | 74849 | 2020-04-20 | Benton | Oregon | 41003 | 28 | 5 |
47674 | 47674 | 2020-04-10 | Yamhill | Oregon | 41071 | 28 | 5 |
42463 | 42463 | 2020-04-08 | Polk | Oregon | 41053 | 28 | 1 |
39903 | 39903 | 2020-04-07 | Polk | Oregon | 41053 | 28 | 1 |
15307 | 15307 | 2020-03-27 | Linn | Oregon | 41043 | 28 | 1 |
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);