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-12 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
724696 | 724696 | 2020-11-12 | Baker | Oregon | 41001 | 198 | 3 |
724697 | 724697 | 2020-11-12 | Benton | Oregon | 41003 | 568 | 6 |
724698 | 724698 | 2020-11-12 | Clackamas | Oregon | 41005 | 4266 | 72 |
724699 | 724699 | 2020-11-12 | Clatsop | Oregon | 41007 | 294 | 0 |
724700 | 724700 | 2020-11-12 | Columbia | Oregon | 41009 | 332 | 2 |
724701 | 724701 | 2020-11-12 | Coos | Oregon | 41011 | 314 | 1 |
724702 | 724702 | 2020-11-12 | Crook | Oregon | 41013 | 156 | 5 |
724703 | 724703 | 2020-11-12 | Curry | Oregon | 41015 | 81 | 2 |
724704 | 724704 | 2020-11-12 | Deschutes | Oregon | 41017 | 1559 | 14 |
724705 | 724705 | 2020-11-12 | Douglas | Oregon | 41019 | 556 | 10 |
724706 | 724706 | 2020-11-12 | Gilliam | Oregon | 41021 | 17 | 0 |
724707 | 724707 | 2020-11-12 | Grant | Oregon | 41023 | 65 | 0 |
724708 | 724708 | 2020-11-12 | Harney | Oregon | 41025 | 52 | 0 |
724709 | 724709 | 2020-11-12 | Hood River | Oregon | 41027 | 309 | 1 |
724710 | 724710 | 2020-11-12 | Jackson | Oregon | 41029 | 2605 | 8 |
724711 | 724711 | 2020-11-12 | Jefferson | Oregon | 41031 | 660 | 11 |
724712 | 724712 | 2020-11-12 | Josephine | Oregon | 41033 | 326 | 4 |
724713 | 724713 | 2020-11-12 | Klamath | Oregon | 41035 | 498 | 3 |
724714 | 724714 | 2020-11-12 | Lake | Oregon | 41037 | 54 | 0 |
724715 | 724715 | 2020-11-12 | Lane | Oregon | 41039 | 3056 | 33 |
724716 | 724716 | 2020-11-12 | Lincoln | Oregon | 41041 | 530 | 13 |
724717 | 724717 | 2020-11-12 | Linn | Oregon | 41043 | 1039 | 17 |
724718 | 724718 | 2020-11-12 | Malheur | Oregon | 41045 | 2108 | 38 |
724719 | 724719 | 2020-11-12 | Marion | Oregon | 41047 | 7146 | 122 |
724720 | 724720 | 2020-11-12 | Morrow | Oregon | 41049 | 585 | 7 |
724721 | 724721 | 2020-11-12 | Multnomah | Oregon | 41051 | 12139 | 191 |
724722 | 724722 | 2020-11-12 | Polk | Oregon | 41053 | 843 | 15 |
724723 | 724723 | 2020-11-12 | Sherman | Oregon | 41055 | 23 | 0 |
724724 | 724724 | 2020-11-12 | Tillamook | Oregon | 41057 | 91 | 0 |
724725 | 724725 | 2020-11-12 | Umatilla | Oregon | 41059 | 3748 | 45 |
724726 | 724726 | 2020-11-12 | Union | Oregon | 41061 | 564 | 2 |
724727 | 724727 | 2020-11-12 | Wallowa | Oregon | 41063 | 67 | 2 |
724728 | 724728 | 2020-11-12 | Wasco | Oregon | 41065 | 390 | 17 |
724729 | 724729 | 2020-11-12 | Washington | Oregon | 41067 | 7376 | 89 |
724730 | 724730 | 2020-11-12 | Wheeler | Oregon | 41069 | 1 | 0 |
724731 | 724731 | 2020-11-12 | Yamhill | Oregon | 41071 | 1263 | 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);