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-03 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
695506 | 695506 | 2020-11-03 | Baker | Oregon | 41001 | 152 | 3 |
695507 | 695507 | 2020-11-03 | Benton | Oregon | 41003 | 474 | 6 |
695508 | 695508 | 2020-11-03 | Clackamas | Oregon | 41005 | 3535 | 69 |
695509 | 695509 | 2020-11-03 | Clatsop | Oregon | 41007 | 268 | 0 |
695510 | 695510 | 2020-11-03 | Columbia | Oregon | 41009 | 285 | 2 |
695511 | 695511 | 2020-11-03 | Coos | Oregon | 41011 | 273 | 1 |
695512 | 695512 | 2020-11-03 | Crook | Oregon | 41013 | 118 | 4 |
695513 | 695513 | 2020-11-03 | Curry | Oregon | 41015 | 66 | 2 |
695514 | 695514 | 2020-11-03 | Deschutes | Oregon | 41017 | 1308 | 13 |
695515 | 695515 | 2020-11-03 | Douglas | Oregon | 41019 | 400 | 8 |
695516 | 695516 | 2020-11-03 | Gilliam | Oregon | 41021 | 17 | 0 |
695517 | 695517 | 2020-11-03 | Grant | Oregon | 41023 | 18 | 0 |
695518 | 695518 | 2020-11-03 | Harney | Oregon | 41025 | 39 | 0 |
695519 | 695519 | 2020-11-03 | Hood River | Oregon | 41027 | 291 | 1 |
695520 | 695520 | 2020-11-03 | Jackson | Oregon | 41029 | 1998 | 7 |
695521 | 695521 | 2020-11-03 | Jefferson | Oregon | 41031 | 613 | 11 |
695522 | 695522 | 2020-11-03 | Josephine | Oregon | 41033 | 279 | 4 |
695523 | 695523 | 2020-11-03 | Klamath | Oregon | 41035 | 444 | 3 |
695524 | 695524 | 2020-11-03 | Lake | Oregon | 41037 | 47 | 0 |
695525 | 695525 | 2020-11-03 | Lane | Oregon | 41039 | 2633 | 28 |
695526 | 695526 | 2020-11-03 | Lincoln | Oregon | 41041 | 522 | 13 |
695527 | 695527 | 2020-11-03 | Linn | Oregon | 41043 | 923 | 17 |
695528 | 695528 | 2020-11-03 | Malheur | Oregon | 41045 | 2008 | 38 |
695529 | 695529 | 2020-11-03 | Marion | Oregon | 41047 | 6375 | 114 |
695530 | 695530 | 2020-11-03 | Morrow | Oregon | 41049 | 560 | 7 |
695531 | 695531 | 2020-11-03 | Multnomah | Oregon | 41051 | 10139 | 175 |
695532 | 695532 | 2020-11-03 | Polk | Oregon | 41053 | 719 | 15 |
695533 | 695533 | 2020-11-03 | Sherman | Oregon | 41055 | 23 | 0 |
695534 | 695534 | 2020-11-03 | Tillamook | Oregon | 41057 | 80 | 0 |
695535 | 695535 | 2020-11-03 | Umatilla | Oregon | 41059 | 3509 | 45 |
695536 | 695536 | 2020-11-03 | Union | Oregon | 41061 | 503 | 2 |
695537 | 695537 | 2020-11-03 | Wallowa | Oregon | 41063 | 58 | 2 |
695538 | 695538 | 2020-11-03 | Wasco | Oregon | 41065 | 368 | 16 |
695539 | 695539 | 2020-11-03 | Washington | Oregon | 41067 | 6356 | 80 |
695540 | 695540 | 2020-11-03 | Wheeler | Oregon | 41069 | 1 | 0 |
695541 | 695541 | 2020-11-03 | Yamhill | Oregon | 41071 | 1058 | 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);