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-08-13 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
429996 | 429996 | 2020-08-13 | Baker | Oregon | 41001 | 45 | 0 |
429997 | 429997 | 2020-08-13 | Benton | Oregon | 41003 | 181 | 6 |
429998 | 429998 | 2020-08-13 | Clackamas | Oregon | 41005 | 1607 | 50 |
429999 | 429999 | 2020-08-13 | Clatsop | Oregon | 41007 | 87 | 0 |
430000 | 430000 | 2020-08-13 | Columbia | Oregon | 41009 | 103 | 1 |
430001 | 430001 | 2020-08-13 | Coos | Oregon | 41011 | 91 | 0 |
430002 | 430002 | 2020-08-13 | Crook | Oregon | 41013 | 51 | 1 |
430003 | 430003 | 2020-08-13 | Curry | Oregon | 41015 | 17 | 0 |
430004 | 430004 | 2020-08-13 | Deschutes | Oregon | 41017 | 621 | 11 |
430005 | 430005 | 2020-08-13 | Douglas | Oregon | 41019 | 159 | 1 |
430006 | 430006 | 2020-08-13 | Gilliam | Oregon | 41021 | 4 | 0 |
430007 | 430007 | 2020-08-13 | Grant | Oregon | 41023 | 4 | 0 |
430008 | 430008 | 2020-08-13 | Harney | Oregon | 41025 | 11 | 0 |
430009 | 430009 | 2020-08-13 | Hood River | Oregon | 41027 | 207 | 0 |
430010 | 430010 | 2020-08-13 | Jackson | Oregon | 41029 | 515 | 2 |
430011 | 430011 | 2020-08-13 | Jefferson | Oregon | 41031 | 392 | 4 |
430012 | 430012 | 2020-08-13 | Josephine | Oregon | 41033 | 130 | 2 |
430013 | 430013 | 2020-08-13 | Klamath | Oregon | 41035 | 206 | 2 |
430014 | 430014 | 2020-08-13 | Lake | Oregon | 41037 | 32 | 0 |
430015 | 430015 | 2020-08-13 | Lane | Oregon | 41039 | 611 | 3 |
430016 | 430016 | 2020-08-13 | Lincoln | Oregon | 41041 | 428 | 9 |
430017 | 430017 | 2020-08-13 | Linn | Oregon | 41043 | 306 | 11 |
430018 | 430018 | 2020-08-13 | Malheur | Oregon | 41045 | 851 | 15 |
430019 | 430019 | 2020-08-13 | Marion | Oregon | 41047 | 3040 | 73 |
430020 | 430020 | 2020-08-13 | Morrow | Oregon | 41049 | 384 | 3 |
430021 | 430021 | 2020-08-13 | Multnomah | Oregon | 41051 | 5135 | 103 |
430022 | 430022 | 2020-08-13 | Polk | Oregon | 41053 | 337 | 12 |
430023 | 430023 | 2020-08-13 | Sherman | Oregon | 41055 | 16 | 0 |
430024 | 430024 | 2020-08-13 | Tillamook | Oregon | 41057 | 35 | 0 |
430025 | 430025 | 2020-08-13 | Umatilla | Oregon | 41059 | 2377 | 32 |
430026 | 430026 | 2020-08-13 | Union | Oregon | 41061 | 397 | 2 |
430027 | 430027 | 2020-08-13 | Wallowa | Oregon | 41063 | 20 | 1 |
430028 | 430028 | 2020-08-13 | Wasco | Oregon | 41065 | 197 | 3 |
430029 | 430029 | 2020-08-13 | Washington | Oregon | 41067 | 3235 | 27 |
430030 | 430030 | 2020-08-13 | Yamhill | Oregon | 41071 | 483 | 13 |
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);