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 2021-11-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 |
---|---|---|---|---|---|---|---|
1913074 | 1913074 | 2021-11-13 | Baker | Oregon | 41001 | 2106 | 30 |
1913075 | 1913075 | 2021-11-13 | Benton | Oregon | 41003 | 5893 | 35 |
1913076 | 1913076 | 2021-11-13 | Clackamas | Oregon | 41005 | 31587 | 343 |
1913077 | 1913077 | 2021-11-13 | Clatsop | Oregon | 41007 | 2529 | 32 |
1913078 | 1913078 | 2021-11-13 | Columbia | Oregon | 41009 | 4109 | 49 |
1913079 | 1913079 | 2021-11-13 | Coos | Oregon | 41011 | 5387 | 103 |
1913080 | 1913080 | 2021-11-13 | Crook | Oregon | 41013 | 3159 | 54 |
1913081 | 1913081 | 2021-11-13 | Curry | Oregon | 41015 | 1860 | 32 |
1913082 | 1913082 | 2021-11-13 | Deschutes | Oregon | 41017 | 22266 | 149 |
1913083 | 1913083 | 2021-11-13 | Douglas | Oregon | 41019 | 12856 | 275 |
1913084 | 1913084 | 2021-11-13 | Gilliam | Oregon | 41021 | 179 | 4 |
1913085 | 1913085 | 2021-11-13 | Grant | Oregon | 41023 | 1072 | 14 |
1913086 | 1913086 | 2021-11-13 | Harney | Oregon | 41025 | 1176 | 30 |
1913087 | 1913087 | 2021-11-13 | Hood River | Oregon | 41027 | 2043 | 37 |
1913088 | 1913088 | 2021-11-13 | Jackson | Oregon | 41029 | 24103 | 339 |
1913089 | 1913089 | 2021-11-13 | Jefferson | Oregon | 41031 | 4058 | 62 |
1913090 | 1913090 | 2021-11-13 | Josephine | Oregon | 41033 | 9848 | 214 |
1913091 | 1913091 | 2021-11-13 | Klamath | Oregon | 41035 | 8760 | 133 |
1913092 | 1913092 | 2021-11-13 | Lake | Oregon | 41037 | 1017 | 15 |
1913093 | 1913093 | 2021-11-13 | Lane | Oregon | 41039 | 29229 | 339 |
1913094 | 1913094 | 2021-11-13 | Lincoln | Oregon | 41041 | 3437 | 46 |
1913095 | 1913095 | 2021-11-13 | Linn | Oregon | 41043 | 14034 | 154 |
1913096 | 1913096 | 2021-11-13 | Malheur | Oregon | 41045 | 5844 | 84 |
1913097 | 1913097 | 2021-11-13 | Marion | Oregon | 41047 | 38725 | 483 |
1913098 | 1913098 | 2021-11-13 | Morrow | Oregon | 41049 | 1926 | 24 |
1913099 | 1913099 | 2021-11-13 | Multnomah | Oregon | 41051 | 58525 | 778 |
1913100 | 1913100 | 2021-11-13 | Polk | Oregon | 41053 | 7867 | 88 |
1913101 | 1913101 | 2021-11-13 | Sherman | Oregon | 41055 | 178 | 3 |
1913102 | 1913102 | 2021-11-13 | Tillamook | Oregon | 41057 | 2100 | 42 |
1913103 | 1913103 | 2021-11-13 | Umatilla | Oregon | 41059 | 14945 | 166 |
1913104 | 1913104 | 2021-11-13 | Union | Oregon | 41061 | 3308 | 50 |
1913105 | 1913105 | 2021-11-13 | Wallowa | Oregon | 41063 | 733 | 12 |
1913106 | 1913106 | 2021-11-13 | Wasco | Oregon | 41065 | 3080 | 41 |
1913107 | 1913107 | 2021-11-13 | Washington | Oregon | 41067 | 40695 | 364 |
1913108 | 1913108 | 2021-11-13 | Wheeler | Oregon | 41069 | 108 | 1 |
1913109 | 1913109 | 2021-11-13 | Yamhill | Oregon | 41071 | 9432 | 125 |
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);