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-05-10 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492037 | 2492037 | 2022-05-10 | Baker | Oregon | 41001 | 3226 | 48 |
2492038 | 2492038 | 2022-05-10 | Benton | Oregon | 41003 | 16149 | 71 |
2492039 | 2492039 | 2022-05-10 | Clackamas | Oregon | 41005 | 63267 | 631 |
2492040 | 2492040 | 2022-05-10 | Clatsop | Oregon | 41007 | 4779 | 50 |
2492041 | 2492041 | 2022-05-10 | Columbia | Oregon | 41009 | 7919 | 95 |
2492042 | 2492042 | 2022-05-10 | Coos | Oregon | 41011 | 10808 | 153 |
2492043 | 2492043 | 2022-05-10 | Crook | Oregon | 41013 | 6144 | 79 |
2492044 | 2492044 | 2022-05-10 | Curry | Oregon | 41015 | 3379 | 54 |
2492045 | 2492045 | 2022-05-10 | Deschutes | Oregon | 41017 | 47576 | 286 |
2492046 | 2492046 | 2022-05-10 | Douglas | Oregon | 41019 | 19950 | 392 |
2492047 | 2492047 | 2022-05-10 | Gilliam | Oregon | 41021 | 284 | 5 |
2492048 | 2492048 | 2022-05-10 | Grant | Oregon | 41023 | 1702 | 21 |
2492049 | 2492049 | 2022-05-10 | Harney | Oregon | 41025 | 1613 | 38 |
2492050 | 2492050 | 2022-05-10 | Hood River | Oregon | 41027 | 3667 | 43 |
2492051 | 2492051 | 2022-05-10 | Jackson | Oregon | 41029 | 43410 | 533 |
2492052 | 2492052 | 2022-05-10 | Jefferson | Oregon | 41031 | 7301 | 92 |
2492053 | 2492053 | 2022-05-10 | Josephine | Oregon | 41033 | 16590 | 339 |
2492054 | 2492054 | 2022-05-10 | Klamath | Oregon | 41035 | 14270 | 222 |
2492055 | 2492055 | 2022-05-10 | Lake | Oregon | 41037 | 1425 | 29 |
2492056 | 2492056 | 2022-05-10 | Lane | Oregon | 41039 | 59436 | 540 |
2492057 | 2492057 | 2022-05-10 | Lincoln | Oregon | 41041 | 7182 | 85 |
2492058 | 2492058 | 2022-05-10 | Linn | Oregon | 41043 | 27153 | 268 |
2492059 | 2492059 | 2022-05-10 | Malheur | Oregon | 41045 | 8244 | 108 |
2492060 | 2492060 | 2022-05-10 | Marion | Oregon | 41047 | 70476 | 720 |
2492061 | 2492061 | 2022-05-10 | Morrow | Oregon | 41049 | 2978 | 34 |
2492062 | 2492062 | 2022-05-10 | Multnomah | Oregon | 41051 | 122650 | 1203 |
2492063 | 2492063 | 2022-05-10 | Polk | Oregon | 41053 | 15706 | 134 |
2492064 | 2492064 | 2022-05-10 | Sherman | Oregon | 41055 | 321 | 6 |
2492065 | 2492065 | 2022-05-10 | Tillamook | Oregon | 41057 | 3805 | 64 |
2492066 | 2492066 | 2022-05-10 | Umatilla | Oregon | 41059 | 22512 | 225 |
2492067 | 2492067 | 2022-05-10 | Union | Oregon | 41061 | 5060 | 80 |
2492068 | 2492068 | 2022-05-10 | Wallowa | Oregon | 41063 | 1266 | 16 |
2492069 | 2492069 | 2022-05-10 | Wasco | Oregon | 41065 | 5201 | 63 |
2492070 | 2492070 | 2022-05-10 | Washington | Oregon | 41067 | 90141 | 594 |
2492071 | 2492071 | 2022-05-10 | Wheeler | Oregon | 41069 | 245 | 3 |
2492072 | 2492072 | 2022-05-10 | Yamhill | Oregon | 41071 | 18179 | 222 |
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);