ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where "date" is on date 2020-05-03 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths
fips 32
county 32
- Benton 1
- Clackamas 1
- Clatsop 1
- Columbia 1
- Coos 1
- Crook 1
- Curry 1
- Deschutes 1
- Douglas 1
- Grant 1
- Harney 1
- Hood River 1
- Jackson 1
- Jefferson 1
- Josephine 1
- Klamath 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
- Yamhill 1
state 1
- Oregon · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
111625 | 111625 | 2020-05-03 | Benton | Oregon | 41003 | 32 | 5 |
111626 | 111626 | 2020-05-03 | Clackamas | Oregon | 41005 | 225 | 7 |
111627 | 111627 | 2020-05-03 | Clatsop | Oregon | 41007 | 7 | 0 |
111628 | 111628 | 2020-05-03 | Columbia | Oregon | 41009 | 14 | 0 |
111629 | 111629 | 2020-05-03 | Coos | Oregon | 41011 | 25 | 0 |
111630 | 111630 | 2020-05-03 | Crook | Oregon | 41013 | 1 | 0 |
111631 | 111631 | 2020-05-03 | Curry | Oregon | 41015 | 4 | 0 |
111632 | 111632 | 2020-05-03 | Deschutes | Oregon | 41017 | 78 | 0 |
111633 | 111633 | 2020-05-03 | Douglas | Oregon | 41019 | 24 | 0 |
111634 | 111634 | 2020-05-03 | Grant | Oregon | 41023 | 1 | 0 |
111635 | 111635 | 2020-05-03 | Harney | Oregon | 41025 | 1 | 0 |
111636 | 111636 | 2020-05-03 | Hood River | Oregon | 41027 | 9 | 0 |
111637 | 111637 | 2020-05-03 | Jackson | Oregon | 41029 | 49 | 0 |
111638 | 111638 | 2020-05-03 | Jefferson | Oregon | 41031 | 13 | 0 |
111639 | 111639 | 2020-05-03 | Josephine | Oregon | 41033 | 22 | 1 |
111640 | 111640 | 2020-05-03 | Klamath | Oregon | 41035 | 39 | 0 |
111641 | 111641 | 2020-05-03 | Lane | Oregon | 41039 | 54 | 2 |
111642 | 111642 | 2020-05-03 | Lincoln | Oregon | 41041 | 5 | 0 |
111643 | 111643 | 2020-05-03 | Linn | Oregon | 41043 | 87 | 7 |
111644 | 111644 | 2020-05-03 | Malheur | Oregon | 41045 | 13 | 0 |
111645 | 111645 | 2020-05-03 | Marion | Oregon | 41047 | 544 | 19 |
111646 | 111646 | 2020-05-03 | Morrow | Oregon | 41049 | 9 | 0 |
111647 | 111647 | 2020-05-03 | Multnomah | Oregon | 41051 | 739 | 46 |
111648 | 111648 | 2020-05-03 | Polk | Oregon | 41053 | 41 | 2 |
111649 | 111649 | 2020-05-03 | Sherman | Oregon | 41055 | 1 | 0 |
111650 | 111650 | 2020-05-03 | Tillamook | Oregon | 41057 | 6 | 0 |
111651 | 111651 | 2020-05-03 | Umatilla | Oregon | 41059 | 64 | 1 |
111652 | 111652 | 2020-05-03 | Union | Oregon | 41061 | 4 | 0 |
111653 | 111653 | 2020-05-03 | Wallowa | Oregon | 41063 | 1 | 0 |
111654 | 111654 | 2020-05-03 | Wasco | Oregon | 41065 | 13 | 1 |
111655 | 111655 | 2020-05-03 | Washington | Oregon | 41067 | 516 | 11 |
111656 | 111656 | 2020-05-03 | Yamhill | Oregon | 41071 | 39 | 7 |
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);