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-03-04 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2273983 | 2273983 | 2022-03-04 | Baker | Oregon | 41001 | 3194 | 46 |
2273984 | 2273984 | 2022-03-04 | Benton | Oregon | 41003 | 14865 | 62 |
2273985 | 2273985 | 2022-03-04 | Clackamas | Oregon | 41005 | 59292 | 530 |
2273986 | 2273986 | 2022-03-04 | Clatsop | Oregon | 41007 | 4527 | 39 |
2273987 | 2273987 | 2022-03-04 | Columbia | Oregon | 41009 | 7459 | 75 |
2273988 | 2273988 | 2022-03-04 | Coos | Oregon | 41011 | 10492 | 143 |
2273989 | 2273989 | 2022-03-04 | Crook | Oregon | 41013 | 5995 | 76 |
2273990 | 2273990 | 2022-03-04 | Curry | Oregon | 41015 | 3291 | 44 |
2273991 | 2273991 | 2022-03-04 | Deschutes | Oregon | 41017 | 45373 | 244 |
2273992 | 2273992 | 2022-03-04 | Douglas | Oregon | 41019 | 19493 | 372 |
2273993 | 2273993 | 2022-03-04 | Gilliam | Oregon | 41021 | 281 | 5 |
2273994 | 2273994 | 2022-03-04 | Grant | Oregon | 41023 | 1572 | 18 |
2273995 | 2273995 | 2022-03-04 | Harney | Oregon | 41025 | 1589 | 37 |
2273996 | 2273996 | 2022-03-04 | Hood River | Oregon | 41027 | 3491 | 42 |
2273997 | 2273997 | 2022-03-04 | Jackson | Oregon | 41029 | 42196 | 486 |
2273998 | 2273998 | 2022-03-04 | Jefferson | Oregon | 41031 | 7159 | 84 |
2273999 | 2273999 | 2022-03-04 | Josephine | Oregon | 41033 | 16083 | 314 |
2274000 | 2274000 | 2022-03-04 | Klamath | Oregon | 41035 | 13982 | 196 |
2274001 | 2274001 | 2022-03-04 | Lake | Oregon | 41037 | 1384 | 24 |
2274002 | 2274002 | 2022-03-04 | Lane | Oregon | 41039 | 56436 | 471 |
2274003 | 2274003 | 2022-03-04 | Lincoln | Oregon | 41041 | 6931 | 73 |
2274004 | 2274004 | 2022-03-04 | Linn | Oregon | 41043 | 26106 | 234 |
2274005 | 2274005 | 2022-03-04 | Malheur | Oregon | 41045 | 8176 | 101 |
2274006 | 2274006 | 2022-03-04 | Marion | Oregon | 41047 | 68389 | 660 |
2274007 | 2274007 | 2022-03-04 | Morrow | Oregon | 41049 | 2942 | 31 |
2274008 | 2274008 | 2022-03-04 | Multnomah | Oregon | 41051 | 111223 | 1062 |
2274009 | 2274009 | 2022-03-04 | Polk | Oregon | 41053 | 15117 | 127 |
2274010 | 2274010 | 2022-03-04 | Sherman | Oregon | 41055 | 313 | 4 |
2274011 | 2274011 | 2022-03-04 | Tillamook | Oregon | 41057 | 3596 | 57 |
2274012 | 2274012 | 2022-03-04 | Umatilla | Oregon | 41059 | 22243 | 201 |
2274013 | 2274013 | 2022-03-04 | Union | Oregon | 41061 | 5002 | 74 |
2274014 | 2274014 | 2022-03-04 | Wallowa | Oregon | 41063 | 1235 | 14 |
2274015 | 2274015 | 2022-03-04 | Wasco | Oregon | 41065 | 5064 | 55 |
2274016 | 2274016 | 2022-03-04 | Washington | Oregon | 41067 | 84400 | 511 |
2274017 | 2274017 | 2022-03-04 | Wheeler | Oregon | 41069 | 243 | 3 |
2274018 | 2274018 | 2022-03-04 | Yamhill | Oregon | 41071 | 17583 | 194 |
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);