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-01-26 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2153648 | 2153648 | 2022-01-26 | Baker | Oregon | 41001 | 2846 | 41 |
2153649 | 2153649 | 2022-01-26 | Benton | Oregon | 41003 | 12278 | 50 |
2153650 | 2153650 | 2022-01-26 | Clackamas | Oregon | 41005 | 52423 | 475 |
2153651 | 2153651 | 2022-01-26 | Clatsop | Oregon | 41007 | 3868 | 37 |
2153652 | 2153652 | 2022-01-26 | Columbia | Oregon | 41009 | 6324 | 68 |
2153653 | 2153653 | 2022-01-26 | Coos | Oregon | 41011 | 9006 | 130 |
2153654 | 2153654 | 2022-01-26 | Crook | Oregon | 41013 | 5039 | 62 |
2153655 | 2153655 | 2022-01-26 | Curry | Oregon | 41015 | 2728 | 41 |
2153656 | 2153656 | 2022-01-26 | Deschutes | Oregon | 41017 | 39976 | 231 |
2153657 | 2153657 | 2022-01-26 | Douglas | Oregon | 41019 | 17031 | 330 |
2153658 | 2153658 | 2022-01-26 | Gilliam | Oregon | 41021 | 248 | 4 |
2153659 | 2153659 | 2022-01-26 | Grant | Oregon | 41023 | 1452 | 18 |
2153660 | 2153660 | 2022-01-26 | Harney | Oregon | 41025 | 1358 | 35 |
2153661 | 2153661 | 2022-01-26 | Hood River | Oregon | 41027 | 3035 | 40 |
2153662 | 2153662 | 2022-01-26 | Jackson | Oregon | 41029 | 36675 | 427 |
2153663 | 2153663 | 2022-01-26 | Jefferson | Oregon | 41031 | 6260 | 71 |
2153664 | 2153664 | 2022-01-26 | Josephine | Oregon | 41033 | 13899 | 296 |
2153665 | 2153665 | 2022-01-26 | Klamath | Oregon | 41035 | 12019 | 181 |
2153666 | 2153666 | 2022-01-26 | Lake | Oregon | 41037 | 1221 | 23 |
2153667 | 2153667 | 2022-01-26 | Lane | Oregon | 41039 | 47190 | 402 |
2153668 | 2153668 | 2022-01-26 | Lincoln | Oregon | 41041 | 5649 | 64 |
2153669 | 2153669 | 2022-01-26 | Linn | Oregon | 41043 | 22023 | 222 |
2153670 | 2153670 | 2022-01-26 | Malheur | Oregon | 41045 | 7405 | 97 |
2153671 | 2153671 | 2022-01-26 | Marion | Oregon | 41047 | 59105 | 580 |
2153672 | 2153672 | 2022-01-26 | Morrow | Oregon | 41049 | 2748 | 26 |
2153673 | 2153673 | 2022-01-26 | Multnomah | Oregon | 41051 | 98786 | 956 |
2153674 | 2153674 | 2022-01-26 | Polk | Oregon | 41053 | 12834 | 115 |
2153675 | 2153675 | 2022-01-26 | Sherman | Oregon | 41055 | 283 | 3 |
2153676 | 2153676 | 2022-01-26 | Tillamook | Oregon | 41057 | 3085 | 54 |
2153677 | 2153677 | 2022-01-26 | Umatilla | Oregon | 41059 | 20443 | 192 |
2153678 | 2153678 | 2022-01-26 | Union | Oregon | 41061 | 4371 | 66 |
2153679 | 2153679 | 2022-01-26 | Wallowa | Oregon | 41063 | 1064 | 13 |
2153680 | 2153680 | 2022-01-26 | Wasco | Oregon | 41065 | 4376 | 50 |
2153681 | 2153681 | 2022-01-26 | Washington | Oregon | 41067 | 73233 | 471 |
2153682 | 2153682 | 2022-01-26 | Wheeler | Oregon | 41069 | 207 | 3 |
2153683 | 2153683 | 2022-01-26 | Yamhill | Oregon | 41071 | 14875 | 174 |
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);