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 2022-05-08 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 36
county 36
- Baker 1
- Benton 1
- Clackamas 1
- Clatsop 1
- Columbia 1
- Coos 1
- Crook 1
- Curry 1
- Deschutes 1
- Douglas 1
- Gilliam 1
- Grant 1
- Harney 1
- Hood River 1
- Jackson 1
- Jefferson 1
- Josephine 1
- Klamath 1
- Lake 1
- Lane 1
- Lincoln 1
- Linn 1
- Malheur 1
- Marion 1
- Morrow 1
- Multnomah 1
- Polk 1
- Sherman 1
- Tillamook 1
- Umatilla 1
- Union 1
- Wallowa 1
- Wasco 1
- Washington 1
- Wheeler 1
- Yamhill 1
state 1
- Oregon · 36 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485522 | 2485522 | 2022-05-08 | Baker | Oregon | 41001 | 3226 | 48 |
2485523 | 2485523 | 2022-05-08 | Benton | Oregon | 41003 | 15993 | 70 |
2485524 | 2485524 | 2022-05-08 | Clackamas | Oregon | 41005 | 62664 | 629 |
2485525 | 2485525 | 2022-05-08 | Clatsop | Oregon | 41007 | 4755 | 50 |
2485526 | 2485526 | 2022-05-08 | Columbia | Oregon | 41009 | 7864 | 94 |
2485527 | 2485527 | 2022-05-08 | Coos | Oregon | 41011 | 10779 | 153 |
2485528 | 2485528 | 2022-05-08 | Crook | Oregon | 41013 | 6132 | 79 |
2485529 | 2485529 | 2022-05-08 | Curry | Oregon | 41015 | 3376 | 54 |
2485530 | 2485530 | 2022-05-08 | Deschutes | Oregon | 41017 | 47256 | 286 |
2485531 | 2485531 | 2022-05-08 | Douglas | Oregon | 41019 | 19912 | 392 |
2485532 | 2485532 | 2022-05-08 | Gilliam | Oregon | 41021 | 284 | 5 |
2485533 | 2485533 | 2022-05-08 | Grant | Oregon | 41023 | 1701 | 21 |
2485534 | 2485534 | 2022-05-08 | Harney | Oregon | 41025 | 1610 | 38 |
2485535 | 2485535 | 2022-05-08 | Hood River | Oregon | 41027 | 3648 | 43 |
2485536 | 2485536 | 2022-05-08 | Jackson | Oregon | 41029 | 43316 | 532 |
2485537 | 2485537 | 2022-05-08 | Jefferson | Oregon | 41031 | 7286 | 92 |
2485538 | 2485538 | 2022-05-08 | Josephine | Oregon | 41033 | 16546 | 336 |
2485539 | 2485539 | 2022-05-08 | Klamath | Oregon | 41035 | 14232 | 222 |
2485540 | 2485540 | 2022-05-08 | Lake | Oregon | 41037 | 1423 | 29 |
2485541 | 2485541 | 2022-05-08 | Lane | Oregon | 41039 | 59006 | 538 |
2485542 | 2485542 | 2022-05-08 | Lincoln | Oregon | 41041 | 7145 | 85 |
2485543 | 2485543 | 2022-05-08 | Linn | Oregon | 41043 | 27048 | 268 |
2485544 | 2485544 | 2022-05-08 | Malheur | Oregon | 41045 | 8240 | 108 |
2485545 | 2485545 | 2022-05-08 | Marion | Oregon | 41047 | 70186 | 718 |
2485546 | 2485546 | 2022-05-08 | Morrow | Oregon | 41049 | 2973 | 34 |
2485547 | 2485547 | 2022-05-08 | Multnomah | Oregon | 41051 | 121435 | 1201 |
2485548 | 2485548 | 2022-05-08 | Polk | Oregon | 41053 | 15628 | 134 |
2485549 | 2485549 | 2022-05-08 | Sherman | Oregon | 41055 | 321 | 6 |
2485550 | 2485550 | 2022-05-08 | Tillamook | Oregon | 41057 | 3792 | 64 |
2485551 | 2485551 | 2022-05-08 | Umatilla | Oregon | 41059 | 22466 | 224 |
2485552 | 2485552 | 2022-05-08 | Union | Oregon | 41061 | 5034 | 79 |
2485553 | 2485553 | 2022-05-08 | Wallowa | Oregon | 41063 | 1265 | 16 |
2485554 | 2485554 | 2022-05-08 | Wasco | Oregon | 41065 | 5188 | 63 |
2485555 | 2485555 | 2022-05-08 | Washington | Oregon | 41067 | 89346 | 593 |
2485556 | 2485556 | 2022-05-08 | Wheeler | Oregon | 41069 | 244 | 3 |
2485557 | 2485557 | 2022-05-08 | Yamhill | Oregon | 41071 | 18093 | 221 |
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);