ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where "date" is on date 2020-10-10 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 |
---|---|---|---|---|---|---|---|
617648 | 617648 | 2020-10-10 | Baker | Oregon | 41001 | 111 | 2 |
617649 | 617649 | 2020-10-10 | Benton | Oregon | 41003 | 380 | 6 |
617650 | 617650 | 2020-10-10 | Clackamas | Oregon | 41005 | 2707 | 65 |
617651 | 617651 | 2020-10-10 | Clatsop | Oregon | 41007 | 230 | 0 |
617652 | 617652 | 2020-10-10 | Columbia | Oregon | 41009 | 227 | 1 |
617653 | 617653 | 2020-10-10 | Coos | Oregon | 41011 | 196 | 0 |
617654 | 617654 | 2020-10-10 | Crook | Oregon | 41013 | 68 | 1 |
617655 | 617655 | 2020-10-10 | Curry | Oregon | 41015 | 38 | 0 |
617656 | 617656 | 2020-10-10 | Deschutes | Oregon | 41017 | 978 | 13 |
617657 | 617657 | 2020-10-10 | Douglas | Oregon | 41019 | 283 | 4 |
617658 | 617658 | 2020-10-10 | Gilliam | Oregon | 41021 | 10 | 0 |
617659 | 617659 | 2020-10-10 | Grant | Oregon | 41023 | 10 | 0 |
617660 | 617660 | 2020-10-10 | Harney | Oregon | 41025 | 13 | 0 |
617661 | 617661 | 2020-10-10 | Hood River | Oregon | 41027 | 267 | 0 |
617662 | 617662 | 2020-10-10 | Jackson | Oregon | 41029 | 1357 | 6 |
617663 | 617663 | 2020-10-10 | Jefferson | Oregon | 41031 | 588 | 8 |
617664 | 617664 | 2020-10-10 | Josephine | Oregon | 41033 | 236 | 2 |
617665 | 617665 | 2020-10-10 | Klamath | Oregon | 41035 | 380 | 3 |
617666 | 617666 | 2020-10-10 | Lake | Oregon | 41037 | 34 | 0 |
617667 | 617667 | 2020-10-10 | Lane | Oregon | 41039 | 1780 | 21 |
617668 | 617668 | 2020-10-10 | Lincoln | Oregon | 41041 | 495 | 13 |
617669 | 617669 | 2020-10-10 | Linn | Oregon | 41043 | 660 | 14 |
617670 | 617670 | 2020-10-10 | Malheur | Oregon | 41045 | 1770 | 33 |
617671 | 617671 | 2020-10-10 | Marion | Oregon | 41047 | 5156 | 101 |
617672 | 617672 | 2020-10-10 | Morrow | Oregon | 41049 | 532 | 6 |
617673 | 617673 | 2020-10-10 | Multnomah | Oregon | 41051 | 7917 | 146 |
617674 | 617674 | 2020-10-10 | Polk | Oregon | 41053 | 582 | 15 |
617675 | 617675 | 2020-10-10 | Sherman | Oregon | 41055 | 18 | 0 |
617676 | 617676 | 2020-10-10 | Tillamook | Oregon | 41057 | 63 | 0 |
617677 | 617677 | 2020-10-10 | Umatilla | Oregon | 41059 | 3158 | 42 |
617678 | 617678 | 2020-10-10 | Union | Oregon | 41061 | 451 | 2 |
617679 | 617679 | 2020-10-10 | Wallowa | Oregon | 41063 | 36 | 1 |
617680 | 617680 | 2020-10-10 | Wasco | Oregon | 41065 | 321 | 14 |
617681 | 617681 | 2020-10-10 | Washington | Oregon | 41067 | 5004 | 67 |
617682 | 617682 | 2020-10-10 | Yamhill | Oregon | 41071 | 869 | 14 |
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);