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-06 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
705236 | 705236 | 2020-11-06 | Baker | Oregon | 41001 | 176 | 3 |
705237 | 705237 | 2020-11-06 | Benton | Oregon | 41003 | 501 | 6 |
705238 | 705238 | 2020-11-06 | Clackamas | Oregon | 41005 | 3670 | 70 |
705239 | 705239 | 2020-11-06 | Clatsop | Oregon | 41007 | 278 | 0 |
705240 | 705240 | 2020-11-06 | Columbia | Oregon | 41009 | 301 | 2 |
705241 | 705241 | 2020-11-06 | Coos | Oregon | 41011 | 282 | 1 |
705242 | 705242 | 2020-11-06 | Crook | Oregon | 41013 | 136 | 5 |
705243 | 705243 | 2020-11-06 | Curry | Oregon | 41015 | 72 | 2 |
705244 | 705244 | 2020-11-06 | Deschutes | Oregon | 41017 | 1408 | 13 |
705245 | 705245 | 2020-11-06 | Douglas | Oregon | 41019 | 434 | 10 |
705246 | 705246 | 2020-11-06 | Gilliam | Oregon | 41021 | 17 | 0 |
705247 | 705247 | 2020-11-06 | Grant | Oregon | 41023 | 32 | 0 |
705248 | 705248 | 2020-11-06 | Harney | Oregon | 41025 | 45 | 0 |
705249 | 705249 | 2020-11-06 | Hood River | Oregon | 41027 | 296 | 1 |
705250 | 705250 | 2020-11-06 | Jackson | Oregon | 41029 | 2197 | 8 |
705251 | 705251 | 2020-11-06 | Jefferson | Oregon | 41031 | 629 | 11 |
705252 | 705252 | 2020-11-06 | Josephine | Oregon | 41033 | 295 | 4 |
705253 | 705253 | 2020-11-06 | Klamath | Oregon | 41035 | 453 | 3 |
705254 | 705254 | 2020-11-06 | Lake | Oregon | 41037 | 49 | 0 |
705255 | 705255 | 2020-11-06 | Lane | Oregon | 41039 | 2728 | 28 |
705256 | 705256 | 2020-11-06 | Lincoln | Oregon | 41041 | 526 | 13 |
705257 | 705257 | 2020-11-06 | Linn | Oregon | 41043 | 969 | 17 |
705258 | 705258 | 2020-11-06 | Malheur | Oregon | 41045 | 2052 | 38 |
705259 | 705259 | 2020-11-06 | Marion | Oregon | 41047 | 6610 | 116 |
705260 | 705260 | 2020-11-06 | Morrow | Oregon | 41049 | 569 | 7 |
705261 | 705261 | 2020-11-06 | Multnomah | Oregon | 41051 | 10705 | 179 |
705262 | 705262 | 2020-11-06 | Polk | Oregon | 41053 | 755 | 15 |
705263 | 705263 | 2020-11-06 | Sherman | Oregon | 41055 | 23 | 0 |
705264 | 705264 | 2020-11-06 | Tillamook | Oregon | 41057 | 82 | 0 |
705265 | 705265 | 2020-11-06 | Umatilla | Oregon | 41059 | 3593 | 45 |
705266 | 705266 | 2020-11-06 | Union | Oregon | 41061 | 521 | 2 |
705267 | 705267 | 2020-11-06 | Wallowa | Oregon | 41063 | 62 | 2 |
705268 | 705268 | 2020-11-06 | Wasco | Oregon | 41065 | 375 | 17 |
705269 | 705269 | 2020-11-06 | Washington | Oregon | 41067 | 6663 | 83 |
705270 | 705270 | 2020-11-06 | Wheeler | Oregon | 41069 | 1 | 0 |
705271 | 705271 | 2020-11-06 | Yamhill | Oregon | 41071 | 1103 | 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);