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-21 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
653339 | 653339 | 2020-10-21 | Baker | Oregon | 41001 | 113 | 2 |
653340 | 653340 | 2020-10-21 | Benton | Oregon | 41003 | 418 | 6 |
653341 | 653341 | 2020-10-21 | Clackamas | Oregon | 41005 | 2990 | 66 |
653342 | 653342 | 2020-10-21 | Clatsop | Oregon | 41007 | 235 | 0 |
653343 | 653343 | 2020-10-21 | Columbia | Oregon | 41009 | 249 | 1 |
653344 | 653344 | 2020-10-21 | Coos | Oregon | 41011 | 229 | 0 |
653345 | 653345 | 2020-10-21 | Crook | Oregon | 41013 | 87 | 2 |
653346 | 653346 | 2020-10-21 | Curry | Oregon | 41015 | 56 | 1 |
653347 | 653347 | 2020-10-21 | Deschutes | Oregon | 41017 | 1074 | 13 |
653348 | 653348 | 2020-10-21 | Douglas | Oregon | 41019 | 331 | 4 |
653349 | 653349 | 2020-10-21 | Gilliam | Oregon | 41021 | 11 | 0 |
653350 | 653350 | 2020-10-21 | Grant | Oregon | 41023 | 10 | 0 |
653351 | 653351 | 2020-10-21 | Harney | Oregon | 41025 | 17 | 0 |
653352 | 653352 | 2020-10-21 | Hood River | Oregon | 41027 | 272 | 1 |
653353 | 653353 | 2020-10-21 | Jackson | Oregon | 41029 | 1555 | 6 |
653354 | 653354 | 2020-10-21 | Jefferson | Oregon | 41031 | 597 | 9 |
653355 | 653355 | 2020-10-21 | Josephine | Oregon | 41033 | 258 | 3 |
653356 | 653356 | 2020-10-21 | Klamath | Oregon | 41035 | 401 | 3 |
653357 | 653357 | 2020-10-21 | Lake | Oregon | 41037 | 35 | 0 |
653358 | 653358 | 2020-10-21 | Lane | Oregon | 41039 | 2212 | 26 |
653359 | 653359 | 2020-10-21 | Lincoln | Oregon | 41041 | 509 | 13 |
653360 | 653360 | 2020-10-21 | Linn | Oregon | 41043 | 764 | 14 |
653361 | 653361 | 2020-10-21 | Malheur | Oregon | 41045 | 1866 | 34 |
653362 | 653362 | 2020-10-21 | Marion | Oregon | 41047 | 5590 | 106 |
653363 | 653363 | 2020-10-21 | Morrow | Oregon | 41049 | 542 | 6 |
653364 | 653364 | 2020-10-21 | Multnomah | Oregon | 41051 | 8743 | 157 |
653365 | 653365 | 2020-10-21 | Polk | Oregon | 41053 | 639 | 15 |
653366 | 653366 | 2020-10-21 | Sherman | Oregon | 41055 | 18 | 0 |
653367 | 653367 | 2020-10-21 | Tillamook | Oregon | 41057 | 70 | 0 |
653368 | 653368 | 2020-10-21 | Umatilla | Oregon | 41059 | 3307 | 43 |
653369 | 653369 | 2020-10-21 | Union | Oregon | 41061 | 458 | 2 |
653370 | 653370 | 2020-10-21 | Wallowa | Oregon | 41063 | 40 | 2 |
653371 | 653371 | 2020-10-21 | Wasco | Oregon | 41065 | 335 | 15 |
653372 | 653372 | 2020-10-21 | Washington | Oregon | 41067 | 5470 | 73 |
653373 | 653373 | 2020-10-21 | Wheeler | Oregon | 41069 | 1 | 0 |
653374 | 653374 | 2020-10-21 | Yamhill | Oregon | 41071 | 956 | 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);