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 2021-01-05 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 |
---|---|---|---|---|---|---|---|
899947 | 899947 | 2021-01-05 | Baker | Oregon | 41001 | 491 | 5 |
899948 | 899948 | 2021-01-05 | Benton | Oregon | 41003 | 1419 | 11 |
899949 | 899949 | 2021-01-05 | Clackamas | Oregon | 41005 | 10545 | 114 |
899950 | 899950 | 2021-01-05 | Clatsop | Oregon | 41007 | 591 | 3 |
899951 | 899951 | 2021-01-05 | Columbia | Oregon | 41009 | 897 | 16 |
899952 | 899952 | 2021-01-05 | Coos | Oregon | 41011 | 825 | 13 |
899953 | 899953 | 2021-01-05 | Crook | Oregon | 41013 | 490 | 7 |
899954 | 899954 | 2021-01-05 | Curry | Oregon | 41015 | 297 | 3 |
899955 | 899955 | 2021-01-05 | Deschutes | Oregon | 41017 | 4276 | 24 |
899956 | 899956 | 2021-01-05 | Douglas | Oregon | 41019 | 1474 | 41 |
899957 | 899957 | 2021-01-05 | Gilliam | Oregon | 41021 | 39 | 1 |
899958 | 899958 | 2021-01-05 | Grant | Oregon | 41023 | 170 | 1 |
899959 | 899959 | 2021-01-05 | Harney | Oregon | 41025 | 145 | 3 |
899960 | 899960 | 2021-01-05 | Hood River | Oregon | 41027 | 848 | 20 |
899961 | 899961 | 2021-01-05 | Jackson | Oregon | 41029 | 6173 | 74 |
899962 | 899962 | 2021-01-05 | Jefferson | Oregon | 41031 | 1549 | 20 |
899963 | 899963 | 2021-01-05 | Josephine | Oregon | 41033 | 1340 | 24 |
899964 | 899964 | 2021-01-05 | Klamath | Oregon | 41035 | 2032 | 21 |
899965 | 899965 | 2021-01-05 | Lake | Oregon | 41037 | 203 | 4 |
899966 | 899966 | 2021-01-05 | Lane | Oregon | 41039 | 7287 | 95 |
899967 | 899967 | 2021-01-05 | Lincoln | Oregon | 41041 | 918 | 17 |
899968 | 899968 | 2021-01-05 | Linn | Oregon | 41043 | 2781 | 35 |
899969 | 899969 | 2021-01-05 | Malheur | Oregon | 41045 | 2961 | 51 |
899970 | 899970 | 2021-01-05 | Marion | Oregon | 41047 | 14660 | 218 |
899971 | 899971 | 2021-01-05 | Morrow | Oregon | 41049 | 850 | 8 |
899972 | 899972 | 2021-01-05 | Multnomah | Oregon | 41051 | 26180 | 404 |
899973 | 899973 | 2021-01-05 | Polk | Oregon | 41053 | 2111 | 33 |
899974 | 899974 | 2021-01-05 | Sherman | Oregon | 41055 | 32 | 0 |
899975 | 899975 | 2021-01-05 | Tillamook | Oregon | 41057 | 331 | 1 |
899976 | 899976 | 2021-01-05 | Umatilla | Oregon | 41059 | 5938 | 58 |
899977 | 899977 | 2021-01-05 | Union | Oregon | 41061 | 995 | 16 |
899978 | 899978 | 2021-01-05 | Wallowa | Oregon | 41063 | 82 | 3 |
899979 | 899979 | 2021-01-05 | Wasco | Oregon | 41065 | 936 | 22 |
899980 | 899980 | 2021-01-05 | Washington | Oregon | 41067 | 16838 | 147 |
899981 | 899981 | 2021-01-05 | Wheeler | Oregon | 41069 | 17 | 1 |
899982 | 899982 | 2021-01-05 | Yamhill | Oregon | 41071 | 2787 | 36 |
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);