ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 31 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 |
---|---|---|---|---|---|---|---|
896729 | 896729 | 2021-01-04 | Sherman | Oregon | 41055 | 31 | 0 |
893483 | 893483 | 2021-01-03 | Sherman | Oregon | 41055 | 31 | 0 |
890237 | 890237 | 2021-01-02 | Sherman | Oregon | 41055 | 31 | 0 |
886990 | 886990 | 2021-01-01 | Sherman | Oregon | 41055 | 31 | 0 |
883745 | 883745 | 2020-12-31 | Sherman | Oregon | 41055 | 31 | 0 |
880500 | 880500 | 2020-12-30 | Sherman | Oregon | 41055 | 31 | 0 |
877255 | 877255 | 2020-12-29 | Sherman | Oregon | 41055 | 31 | 0 |
874010 | 874010 | 2020-12-28 | Sherman | Oregon | 41055 | 31 | 0 |
870765 | 870765 | 2020-12-27 | Sherman | Oregon | 41055 | 31 | 0 |
867520 | 867520 | 2020-12-26 | Sherman | Oregon | 41055 | 31 | 0 |
864275 | 864275 | 2020-12-25 | Sherman | Oregon | 41055 | 31 | 0 |
861030 | 861030 | 2020-12-24 | Sherman | Oregon | 41055 | 31 | 0 |
857785 | 857785 | 2020-12-23 | Sherman | Oregon | 41055 | 31 | 0 |
841542 | 841542 | 2020-12-18 | Gilliam | Oregon | 41021 | 31 | 1 |
838297 | 838297 | 2020-12-17 | Gilliam | Oregon | 41021 | 31 | 1 |
581997 | 581997 | 2020-09-29 | Curry | Oregon | 41015 | 31 | 0 |
578757 | 578757 | 2020-09-28 | Curry | Oregon | 41015 | 31 | 0 |
578781 | 578781 | 2020-09-28 | Wallowa | Oregon | 41063 | 31 | 1 |
575516 | 575516 | 2020-09-27 | Curry | Oregon | 41015 | 31 | 0 |
575540 | 575540 | 2020-09-27 | Wallowa | Oregon | 41063 | 31 | 1 |
572272 | 572272 | 2020-09-26 | Curry | Oregon | 41015 | 31 | 0 |
569030 | 569030 | 2020-09-25 | Curry | Oregon | 41015 | 31 | 0 |
565789 | 565789 | 2020-09-24 | Curry | Oregon | 41015 | 31 | 0 |
562548 | 562548 | 2020-09-23 | Curry | Oregon | 41015 | 31 | 0 |
559311 | 559311 | 2020-09-22 | Curry | Oregon | 41015 | 31 | 0 |
510776 | 510776 | 2020-09-07 | Lake | Oregon | 41037 | 31 | 0 |
507543 | 507543 | 2020-09-06 | Lake | Oregon | 41037 | 31 | 0 |
504311 | 504311 | 2020-09-05 | Lake | Oregon | 41037 | 31 | 0 |
501077 | 501077 | 2020-09-04 | Lake | Oregon | 41037 | 31 | 0 |
381725 | 381725 | 2020-07-29 | Lake | Oregon | 41037 | 31 | 0 |
378508 | 378508 | 2020-07-28 | Lake | Oregon | 41037 | 31 | 0 |
375292 | 375292 | 2020-07-27 | Lake | Oregon | 41037 | 31 | 0 |
372079 | 372079 | 2020-07-26 | Lake | Oregon | 41037 | 31 | 0 |
368855 | 368855 | 2020-07-25 | Crook | Oregon | 41013 | 31 | 1 |
368867 | 368867 | 2020-07-25 | Lake | Oregon | 41037 | 31 | 0 |
365658 | 365658 | 2020-07-24 | Lake | Oregon | 41037 | 31 | 0 |
362452 | 362452 | 2020-07-23 | Lake | Oregon | 41037 | 31 | 0 |
295546 | 295546 | 2020-07-02 | Columbia | Oregon | 41009 | 31 | 0 |
282953 | 282953 | 2020-06-28 | Josephine | Oregon | 41033 | 31 | 1 |
260991 | 260991 | 2020-06-21 | Morrow | Oregon | 41049 | 31 | 1 |
205108 | 205108 | 2020-06-03 | Coos | Oregon | 41011 | 31 | 0 |
202031 | 202031 | 2020-06-02 | Coos | Oregon | 41011 | 31 | 0 |
198956 | 198956 | 2020-06-01 | Coos | Oregon | 41011 | 31 | 0 |
195883 | 195883 | 2020-05-31 | Coos | Oregon | 41011 | 31 | 0 |
192814 | 192814 | 2020-05-30 | Coos | Oregon | 41011 | 31 | 0 |
189749 | 189749 | 2020-05-29 | Coos | Oregon | 41011 | 31 | 0 |
186688 | 186688 | 2020-05-28 | Coos | Oregon | 41011 | 31 | 0 |
183631 | 183631 | 2020-05-27 | Coos | Oregon | 41011 | 31 | 0 |
180582 | 180582 | 2020-05-26 | Coos | Oregon | 41011 | 31 | 0 |
177539 | 177539 | 2020-05-25 | Coos | Oregon | 41011 | 31 | 0 |
174495 | 174495 | 2020-05-24 | Coos | Oregon | 41011 | 31 | 0 |
171453 | 171453 | 2020-05-23 | Coos | Oregon | 41011 | 31 | 0 |
168414 | 168414 | 2020-05-22 | Coos | Oregon | 41011 | 31 | 0 |
165378 | 165378 | 2020-05-21 | Coos | Oregon | 41011 | 31 | 0 |
74863 | 74863 | 2020-04-20 | Klamath | Oregon | 41035 | 31 | 0 |
69321 | 69321 | 2020-04-18 | Klamath | Oregon | 41035 | 31 | 0 |
66571 | 66571 | 2020-04-17 | Polk | Oregon | 41053 | 31 | 1 |
42456 | 42456 | 2020-04-08 | Lane | Oregon | 41039 | 31 | 1 |
15295 | 15295 | 2020-03-27 | Clackamas | Oregon | 41005 | 31 | 2 |
5844 | 5844 | 2020-03-20 | Washington | Oregon | 41067 | 31 | 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);