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-11-05 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 |
---|---|---|---|---|---|---|---|
701993 | 701993 | 2020-11-05 | Baker | Oregon | 41001 | 172 | 3 |
701994 | 701994 | 2020-11-05 | Benton | Oregon | 41003 | 484 | 6 |
701995 | 701995 | 2020-11-05 | Clackamas | Oregon | 41005 | 3657 | 70 |
701996 | 701996 | 2020-11-05 | Clatsop | Oregon | 41007 | 273 | 0 |
701997 | 701997 | 2020-11-05 | Columbia | Oregon | 41009 | 297 | 2 |
701998 | 701998 | 2020-11-05 | Coos | Oregon | 41011 | 276 | 1 |
701999 | 701999 | 2020-11-05 | Crook | Oregon | 41013 | 131 | 5 |
702000 | 702000 | 2020-11-05 | Curry | Oregon | 41015 | 66 | 2 |
702001 | 702001 | 2020-11-05 | Deschutes | Oregon | 41017 | 1370 | 13 |
702002 | 702002 | 2020-11-05 | Douglas | Oregon | 41019 | 421 | 10 |
702003 | 702003 | 2020-11-05 | Gilliam | Oregon | 41021 | 17 | 0 |
702004 | 702004 | 2020-11-05 | Grant | Oregon | 41023 | 25 | 0 |
702005 | 702005 | 2020-11-05 | Harney | Oregon | 41025 | 40 | 0 |
702006 | 702006 | 2020-11-05 | Hood River | Oregon | 41027 | 295 | 1 |
702007 | 702007 | 2020-11-05 | Jackson | Oregon | 41029 | 2114 | 8 |
702008 | 702008 | 2020-11-05 | Jefferson | Oregon | 41031 | 622 | 11 |
702009 | 702009 | 2020-11-05 | Josephine | Oregon | 41033 | 289 | 4 |
702010 | 702010 | 2020-11-05 | Klamath | Oregon | 41035 | 448 | 3 |
702011 | 702011 | 2020-11-05 | Lake | Oregon | 41037 | 48 | 0 |
702012 | 702012 | 2020-11-05 | Lane | Oregon | 41039 | 2689 | 28 |
702013 | 702013 | 2020-11-05 | Lincoln | Oregon | 41041 | 523 | 13 |
702014 | 702014 | 2020-11-05 | Linn | Oregon | 41043 | 960 | 17 |
702015 | 702015 | 2020-11-05 | Malheur | Oregon | 41045 | 2036 | 38 |
702016 | 702016 | 2020-11-05 | Marion | Oregon | 41047 | 6533 | 115 |
702017 | 702017 | 2020-11-05 | Morrow | Oregon | 41049 | 565 | 7 |
702018 | 702018 | 2020-11-05 | Multnomah | Oregon | 41051 | 10505 | 176 |
702019 | 702019 | 2020-11-05 | Polk | Oregon | 41053 | 740 | 15 |
702020 | 702020 | 2020-11-05 | Sherman | Oregon | 41055 | 23 | 0 |
702021 | 702021 | 2020-11-05 | Tillamook | Oregon | 41057 | 82 | 0 |
702022 | 702022 | 2020-11-05 | Umatilla | Oregon | 41059 | 3556 | 45 |
702023 | 702023 | 2020-11-05 | Union | Oregon | 41061 | 513 | 2 |
702024 | 702024 | 2020-11-05 | Wallowa | Oregon | 41063 | 62 | 2 |
702025 | 702025 | 2020-11-05 | Wasco | Oregon | 41065 | 375 | 16 |
702026 | 702026 | 2020-11-05 | Washington | Oregon | 41067 | 6543 | 82 |
702027 | 702027 | 2020-11-05 | Wheeler | Oregon | 41069 | 1 | 0 |
702028 | 702028 | 2020-11-05 | Yamhill | Oregon | 41071 | 1088 | 15 |
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);