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-02-19 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1045992 | 1045992 | 2021-02-19 | Baker | Oregon | 41001 | 625 | 7 |
1045993 | 1045993 | 2021-02-19 | Benton | Oregon | 41003 | 2240 | 16 |
1045994 | 1045994 | 2021-02-19 | Clackamas | Oregon | 41005 | 13172 | 172 |
1045995 | 1045995 | 2021-02-19 | Clatsop | Oregon | 41007 | 764 | 6 |
1045996 | 1045996 | 2021-02-19 | Columbia | Oregon | 41009 | 1198 | 21 |
1045997 | 1045997 | 2021-02-19 | Coos | Oregon | 41011 | 1335 | 18 |
1045998 | 1045998 | 2021-02-19 | Crook | Oregon | 41013 | 760 | 18 |
1045999 | 1045999 | 2021-02-19 | Curry | Oregon | 41015 | 386 | 6 |
1046000 | 1046000 | 2021-02-19 | Deschutes | Oregon | 41017 | 5822 | 58 |
1046001 | 1046001 | 2021-02-19 | Douglas | Oregon | 41019 | 2292 | 51 |
1046002 | 1046002 | 2021-02-19 | Gilliam | Oregon | 41021 | 53 | 1 |
1046003 | 1046003 | 2021-02-19 | Grant | Oregon | 41023 | 221 | 1 |
1046004 | 1046004 | 2021-02-19 | Harney | Oregon | 41025 | 266 | 6 |
1046005 | 1046005 | 2021-02-19 | Hood River | Oregon | 41027 | 1054 | 29 |
1046006 | 1046006 | 2021-02-19 | Jackson | Oregon | 41029 | 8078 | 107 |
1046007 | 1046007 | 2021-02-19 | Jefferson | Oregon | 41031 | 1917 | 27 |
1046008 | 1046008 | 2021-02-19 | Josephine | Oregon | 41033 | 2247 | 48 |
1046009 | 1046009 | 2021-02-19 | Klamath | Oregon | 41035 | 2747 | 54 |
1046010 | 1046010 | 2021-02-19 | Lake | Oregon | 41037 | 368 | 6 |
1046011 | 1046011 | 2021-02-19 | Lane | Oregon | 41039 | 9994 | 121 |
1046012 | 1046012 | 2021-02-19 | Lincoln | Oregon | 41041 | 1119 | 19 |
1046013 | 1046013 | 2021-02-19 | Linn | Oregon | 41043 | 3527 | 54 |
1046014 | 1046014 | 2021-02-19 | Malheur | Oregon | 41045 | 3326 | 58 |
1046015 | 1046015 | 2021-02-19 | Marion | Oregon | 41047 | 18117 | 279 |
1046016 | 1046016 | 2021-02-19 | Morrow | Oregon | 41049 | 1026 | 13 |
1046017 | 1046017 | 2021-02-19 | Multnomah | Oregon | 41051 | 31465 | 516 |
1046018 | 1046018 | 2021-02-19 | Polk | Oregon | 41053 | 2963 | 42 |
1046019 | 1046019 | 2021-02-19 | Sherman | Oregon | 41055 | 52 | 0 |
1046020 | 1046020 | 2021-02-19 | Tillamook | Oregon | 41057 | 402 | 2 |
1046021 | 1046021 | 2021-02-19 | Umatilla | Oregon | 41059 | 7508 | 80 |
1046022 | 1046022 | 2021-02-19 | Union | Oregon | 41061 | 1263 | 19 |
1046023 | 1046023 | 2021-02-19 | Wallowa | Oregon | 41063 | 141 | 4 |
1046024 | 1046024 | 2021-02-19 | Wasco | Oregon | 41065 | 1218 | 25 |
1046025 | 1046025 | 2021-02-19 | Washington | Oregon | 41067 | 20804 | 208 |
1046026 | 1046026 | 2021-02-19 | Wheeler | Oregon | 41069 | 22 | 1 |
1046027 | 1046027 | 2021-02-19 | Yamhill | Oregon | 41071 | 3698 | 62 |
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);