ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where "date" is on date 2020-10-11 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
620890 | 620890 | 2020-10-11 | Baker | Oregon | 41001 | 111 | 2 |
620891 | 620891 | 2020-10-11 | Benton | Oregon | 41003 | 382 | 6 |
620892 | 620892 | 2020-10-11 | Clackamas | Oregon | 41005 | 2742 | 65 |
620893 | 620893 | 2020-10-11 | Clatsop | Oregon | 41007 | 230 | 0 |
620894 | 620894 | 2020-10-11 | Columbia | Oregon | 41009 | 230 | 1 |
620895 | 620895 | 2020-10-11 | Coos | Oregon | 41011 | 196 | 0 |
620896 | 620896 | 2020-10-11 | Crook | Oregon | 41013 | 70 | 1 |
620897 | 620897 | 2020-10-11 | Curry | Oregon | 41015 | 49 | 0 |
620898 | 620898 | 2020-10-11 | Deschutes | Oregon | 41017 | 990 | 13 |
620899 | 620899 | 2020-10-11 | Douglas | Oregon | 41019 | 287 | 4 |
620900 | 620900 | 2020-10-11 | Gilliam | Oregon | 41021 | 10 | 0 |
620901 | 620901 | 2020-10-11 | Grant | Oregon | 41023 | 10 | 0 |
620902 | 620902 | 2020-10-11 | Harney | Oregon | 41025 | 13 | 0 |
620903 | 620903 | 2020-10-11 | Hood River | Oregon | 41027 | 267 | 0 |
620904 | 620904 | 2020-10-11 | Jackson | Oregon | 41029 | 1364 | 6 |
620905 | 620905 | 2020-10-11 | Jefferson | Oregon | 41031 | 588 | 8 |
620906 | 620906 | 2020-10-11 | Josephine | Oregon | 41033 | 243 | 2 |
620907 | 620907 | 2020-10-11 | Klamath | Oregon | 41035 | 385 | 3 |
620908 | 620908 | 2020-10-11 | Lake | Oregon | 41037 | 34 | 0 |
620909 | 620909 | 2020-10-11 | Lane | Oregon | 41039 | 1801 | 21 |
620910 | 620910 | 2020-10-11 | Lincoln | Oregon | 41041 | 496 | 13 |
620911 | 620911 | 2020-10-11 | Linn | Oregon | 41043 | 671 | 14 |
620912 | 620912 | 2020-10-11 | Malheur | Oregon | 41045 | 1775 | 33 |
620913 | 620913 | 2020-10-11 | Marion | Oregon | 41047 | 5205 | 101 |
620914 | 620914 | 2020-10-11 | Morrow | Oregon | 41049 | 532 | 6 |
620915 | 620915 | 2020-10-11 | Multnomah | Oregon | 41051 | 7994 | 146 |
620916 | 620916 | 2020-10-11 | Polk | Oregon | 41053 | 586 | 15 |
620917 | 620917 | 2020-10-11 | Sherman | Oregon | 41055 | 18 | 0 |
620918 | 620918 | 2020-10-11 | Tillamook | Oregon | 41057 | 65 | 0 |
620919 | 620919 | 2020-10-11 | Umatilla | Oregon | 41059 | 3170 | 42 |
620920 | 620920 | 2020-10-11 | Union | Oregon | 41061 | 451 | 2 |
620921 | 620921 | 2020-10-11 | Wallowa | Oregon | 41063 | 36 | 1 |
620922 | 620922 | 2020-10-11 | Wasco | Oregon | 41065 | 322 | 14 |
620923 | 620923 | 2020-10-11 | Washington | Oregon | 41067 | 5066 | 67 |
620924 | 620924 | 2020-10-11 | Wheeler | Oregon | 41069 | 1 | 0 |
620925 | 620925 | 2020-10-11 | Yamhill | Oregon | 41071 | 873 | 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);