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-04-11 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2397606 | 2397606 | 2022-04-11 | Baker | Oregon | 41001 | 3210 | 48 |
2397607 | 2397607 | 2022-04-11 | Benton | Oregon | 41003 | 15243 | 69 |
2397608 | 2397608 | 2022-04-11 | Clackamas | Oregon | 41005 | 60255 | 605 |
2397609 | 2397609 | 2022-04-11 | Clatsop | Oregon | 41007 | 4605 | 48 |
2397610 | 2397610 | 2022-04-11 | Columbia | Oregon | 41009 | 7590 | 93 |
2397611 | 2397611 | 2022-04-11 | Coos | Oregon | 41011 | 10684 | 150 |
2397612 | 2397612 | 2022-04-11 | Crook | Oregon | 41013 | 6044 | 77 |
2397613 | 2397613 | 2022-04-11 | Curry | Oregon | 41015 | 3348 | 52 |
2397614 | 2397614 | 2022-04-11 | Deschutes | Oregon | 41017 | 46017 | 277 |
2397615 | 2397615 | 2022-04-11 | Douglas | Oregon | 41019 | 19752 | 385 |
2397616 | 2397616 | 2022-04-11 | Gilliam | Oregon | 41021 | 283 | 5 |
2397617 | 2397617 | 2022-04-11 | Grant | Oregon | 41023 | 1676 | 22 |
2397618 | 2397618 | 2022-04-11 | Harney | Oregon | 41025 | 1602 | 37 |
2397619 | 2397619 | 2022-04-11 | Hood River | Oregon | 41027 | 3564 | 43 |
2397620 | 2397620 | 2022-04-11 | Jackson | Oregon | 41029 | 42717 | 521 |
2397621 | 2397621 | 2022-04-11 | Jefferson | Oregon | 41031 | 7225 | 89 |
2397622 | 2397622 | 2022-04-11 | Josephine | Oregon | 41033 | 16340 | 329 |
2397623 | 2397623 | 2022-04-11 | Klamath | Oregon | 41035 | 14122 | 214 |
2397624 | 2397624 | 2022-04-11 | Lake | Oregon | 41037 | 1407 | 27 |
2397625 | 2397625 | 2022-04-11 | Lane | Oregon | 41039 | 57421 | 516 |
2397626 | 2397626 | 2022-04-11 | Lincoln | Oregon | 41041 | 7027 | 83 |
2397627 | 2397627 | 2022-04-11 | Linn | Oregon | 41043 | 26503 | 262 |
2397628 | 2397628 | 2022-04-11 | Malheur | Oregon | 41045 | 8207 | 108 |
2397629 | 2397629 | 2022-04-11 | Marion | Oregon | 41047 | 68952 | 701 |
2397630 | 2397630 | 2022-04-11 | Morrow | Oregon | 41049 | 2952 | 33 |
2397631 | 2397631 | 2022-04-11 | Multnomah | Oregon | 41051 | 114232 | 1172 |
2397632 | 2397632 | 2022-04-11 | Polk | Oregon | 41053 | 15278 | 129 |
2397633 | 2397633 | 2022-04-11 | Sherman | Oregon | 41055 | 319 | 6 |
2397634 | 2397634 | 2022-04-11 | Tillamook | Oregon | 41057 | 3668 | 64 |
2397635 | 2397635 | 2022-04-11 | Umatilla | Oregon | 41059 | 22359 | 210 |
2397636 | 2397636 | 2022-04-11 | Union | Oregon | 41061 | 5020 | 76 |
2397637 | 2397637 | 2022-04-11 | Wallowa | Oregon | 41063 | 1251 | 16 |
2397638 | 2397638 | 2022-04-11 | Wasco | Oregon | 41065 | 5130 | 60 |
2397639 | 2397639 | 2022-04-11 | Washington | Oregon | 41067 | 85513 | 571 |
2397640 | 2397640 | 2022-04-11 | Wheeler | Oregon | 41069 | 242 | 3 |
2397641 | 2397641 | 2022-04-11 | Yamhill | Oregon | 41071 | 17754 | 214 |
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);