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 2021-09-20 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1737617 | 1737617 | 2021-09-20 | Baker | Oregon | 41001 | 1744 | 21 |
1737618 | 1737618 | 2021-09-20 | Benton | Oregon | 41003 | 4619 | 27 |
1737619 | 1737619 | 2021-09-20 | Clackamas | Oregon | 41005 | 26570 | 271 |
1737620 | 1737620 | 2021-09-20 | Clatsop | Oregon | 41007 | 2117 | 25 |
1737621 | 1737621 | 2021-09-20 | Columbia | Oregon | 41009 | 3242 | 37 |
1737622 | 1737622 | 2021-09-20 | Coos | Oregon | 41011 | 4120 | 69 |
1737623 | 1737623 | 2021-09-20 | Crook | Oregon | 41013 | 2123 | 38 |
1737624 | 1737624 | 2021-09-20 | Curry | Oregon | 41015 | 1668 | 17 |
1737625 | 1737625 | 2021-09-20 | Deschutes | Oregon | 41017 | 16623 | 102 |
1737626 | 1737626 | 2021-09-20 | Douglas | Oregon | 41019 | 10712 | 188 |
1737627 | 1737627 | 2021-09-20 | Gilliam | Oregon | 41021 | 137 | 4 |
1737628 | 1737628 | 2021-09-20 | Grant | Oregon | 41023 | 755 | 8 |
1737629 | 1737629 | 2021-09-20 | Harney | Oregon | 41025 | 789 | 16 |
1737630 | 1737630 | 2021-09-20 | Hood River | Oregon | 41027 | 1630 | 35 |
1737631 | 1737631 | 2021-09-20 | Jackson | Oregon | 41029 | 20977 | 257 |
1737632 | 1737632 | 2021-09-20 | Jefferson | Oregon | 41031 | 3137 | 46 |
1737633 | 1737633 | 2021-09-20 | Josephine | Oregon | 41033 | 8659 | 165 |
1737634 | 1737634 | 2021-09-20 | Klamath | Oregon | 41035 | 6434 | 91 |
1737635 | 1737635 | 2021-09-20 | Lake | Oregon | 41037 | 676 | 8 |
1737636 | 1737636 | 2021-09-20 | Lane | Oregon | 41039 | 23989 | 246 |
1737637 | 1737637 | 2021-09-20 | Lincoln | Oregon | 41041 | 2763 | 30 |
1737638 | 1737638 | 2021-09-20 | Linn | Oregon | 41043 | 10468 | 86 |
1737639 | 1737639 | 2021-09-20 | Malheur | Oregon | 41045 | 4794 | 67 |
1737640 | 1737640 | 2021-09-20 | Marion | Oregon | 41047 | 32577 | 393 |
1737641 | 1737641 | 2021-09-20 | Morrow | Oregon | 41049 | 1679 | 21 |
1737642 | 1737642 | 2021-09-20 | Multnomah | Oregon | 41051 | 51245 | 642 |
1737643 | 1737643 | 2021-09-20 | Polk | Oregon | 41053 | 6235 | 70 |
1737644 | 1737644 | 2021-09-20 | Sherman | Oregon | 41055 | 128 | 3 |
1737645 | 1737645 | 2021-09-20 | Tillamook | Oregon | 41057 | 1815 | 23 |
1737646 | 1737646 | 2021-09-20 | Umatilla | Oregon | 41059 | 12602 | 125 |
1737647 | 1737647 | 2021-09-20 | Union | Oregon | 41061 | 2727 | 37 |
1737648 | 1737648 | 2021-09-20 | Wallowa | Oregon | 41063 | 508 | 11 |
1737649 | 1737649 | 2021-09-20 | Wasco | Oregon | 41065 | 2390 | 39 |
1737650 | 1737650 | 2021-09-20 | Washington | Oregon | 41067 | 34995 | 276 |
1737651 | 1737651 | 2021-09-20 | Wheeler | Oregon | 41069 | 65 | 1 |
1737652 | 1737652 | 2021-09-20 | Yamhill | Oregon | 41071 | 7449 | 99 |
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);