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-12-24 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
861003 | 861003 | 2020-12-24 | Baker | Oregon | 41001 | 422 | 5 |
861004 | 861004 | 2020-12-24 | Benton | Oregon | 41003 | 1254 | 11 |
861005 | 861005 | 2020-12-24 | Clackamas | Oregon | 41005 | 9393 | 112 |
861006 | 861006 | 2020-12-24 | Clatsop | Oregon | 41007 | 513 | 3 |
861007 | 861007 | 2020-12-24 | Columbia | Oregon | 41009 | 776 | 12 |
861008 | 861008 | 2020-12-24 | Coos | Oregon | 41011 | 687 | 6 |
861009 | 861009 | 2020-12-24 | Crook | Oregon | 41013 | 411 | 7 |
861010 | 861010 | 2020-12-24 | Curry | Oregon | 41015 | 261 | 3 |
861011 | 861011 | 2020-12-24 | Deschutes | Oregon | 41017 | 3702 | 20 |
861012 | 861012 | 2020-12-24 | Douglas | Oregon | 41019 | 1328 | 37 |
861013 | 861013 | 2020-12-24 | Gilliam | Oregon | 41021 | 33 | 1 |
861014 | 861014 | 2020-12-24 | Grant | Oregon | 41023 | 168 | 1 |
861015 | 861015 | 2020-12-24 | Harney | Oregon | 41025 | 128 | 1 |
861016 | 861016 | 2020-12-24 | Hood River | Oregon | 41027 | 750 | 11 |
861017 | 861017 | 2020-12-24 | Jackson | Oregon | 41029 | 5487 | 64 |
861018 | 861018 | 2020-12-24 | Jefferson | Oregon | 41031 | 1324 | 16 |
861019 | 861019 | 2020-12-24 | Josephine | Oregon | 41033 | 1057 | 20 |
861020 | 861020 | 2020-12-24 | Klamath | Oregon | 41035 | 1743 | 16 |
861021 | 861021 | 2020-12-24 | Lake | Oregon | 41037 | 187 | 4 |
861022 | 861022 | 2020-12-24 | Lane | Oregon | 41039 | 6470 | 84 |
861023 | 861023 | 2020-12-24 | Lincoln | Oregon | 41041 | 835 | 17 |
861024 | 861024 | 2020-12-24 | Linn | Oregon | 41043 | 2463 | 32 |
861025 | 861025 | 2020-12-24 | Malheur | Oregon | 41045 | 2794 | 50 |
861026 | 861026 | 2020-12-24 | Marion | Oregon | 41047 | 12976 | 203 |
861027 | 861027 | 2020-12-24 | Morrow | Oregon | 41049 | 785 | 8 |
861028 | 861028 | 2020-12-24 | Multnomah | Oregon | 41051 | 23990 | 381 |
861029 | 861029 | 2020-12-24 | Polk | Oregon | 41053 | 1819 | 25 |
861030 | 861030 | 2020-12-24 | Sherman | Oregon | 41055 | 31 | 0 |
861031 | 861031 | 2020-12-24 | Tillamook | Oregon | 41057 | 278 | 0 |
861032 | 861032 | 2020-12-24 | Umatilla | Oregon | 41059 | 5300 | 56 |
861033 | 861033 | 2020-12-24 | Union | Oregon | 41061 | 965 | 13 |
861034 | 861034 | 2020-12-24 | Wallowa | Oregon | 41063 | 76 | 3 |
861035 | 861035 | 2020-12-24 | Wasco | Oregon | 41065 | 826 | 22 |
861036 | 861036 | 2020-12-24 | Washington | Oregon | 41067 | 15072 | 139 |
861037 | 861037 | 2020-12-24 | Wheeler | Oregon | 41069 | 16 | 0 |
861038 | 861038 | 2020-12-24 | Yamhill | Oregon | 41071 | 2502 | 34 |
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);