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 2020-11-01 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
689020 | 689020 | 2020-11-01 | Baker | Oregon | 41001 | 144 | 3 |
689021 | 689021 | 2020-11-01 | Benton | Oregon | 41003 | 465 | 6 |
689022 | 689022 | 2020-11-01 | Clackamas | Oregon | 41005 | 3383 | 67 |
689023 | 689023 | 2020-11-01 | Clatsop | Oregon | 41007 | 257 | 0 |
689024 | 689024 | 2020-11-01 | Columbia | Oregon | 41009 | 280 | 2 |
689025 | 689025 | 2020-11-01 | Coos | Oregon | 41011 | 271 | 1 |
689026 | 689026 | 2020-11-01 | Crook | Oregon | 41013 | 116 | 4 |
689027 | 689027 | 2020-11-01 | Curry | Oregon | 41015 | 62 | 2 |
689028 | 689028 | 2020-11-01 | Deschutes | Oregon | 41017 | 1267 | 13 |
689029 | 689029 | 2020-11-01 | Douglas | Oregon | 41019 | 373 | 8 |
689030 | 689030 | 2020-11-01 | Gilliam | Oregon | 41021 | 17 | 0 |
689031 | 689031 | 2020-11-01 | Grant | Oregon | 41023 | 14 | 0 |
689032 | 689032 | 2020-11-01 | Harney | Oregon | 41025 | 39 | 0 |
689033 | 689033 | 2020-11-01 | Hood River | Oregon | 41027 | 290 | 1 |
689034 | 689034 | 2020-11-01 | Jackson | Oregon | 41029 | 1911 | 7 |
689035 | 689035 | 2020-11-01 | Jefferson | Oregon | 41031 | 611 | 10 |
689036 | 689036 | 2020-11-01 | Josephine | Oregon | 41033 | 277 | 3 |
689037 | 689037 | 2020-11-01 | Klamath | Oregon | 41035 | 437 | 3 |
689038 | 689038 | 2020-11-01 | Lake | Oregon | 41037 | 47 | 0 |
689039 | 689039 | 2020-11-01 | Lane | Oregon | 41039 | 2596 | 28 |
689040 | 689040 | 2020-11-01 | Lincoln | Oregon | 41041 | 521 | 13 |
689041 | 689041 | 2020-11-01 | Linn | Oregon | 41043 | 890 | 17 |
689042 | 689042 | 2020-11-01 | Malheur | Oregon | 41045 | 1985 | 38 |
689043 | 689043 | 2020-11-01 | Marion | Oregon | 41047 | 6252 | 112 |
689044 | 689044 | 2020-11-01 | Morrow | Oregon | 41049 | 559 | 7 |
689045 | 689045 | 2020-11-01 | Multnomah | Oregon | 41051 | 9894 | 172 |
689046 | 689046 | 2020-11-01 | Polk | Oregon | 41053 | 695 | 15 |
689047 | 689047 | 2020-11-01 | Sherman | Oregon | 41055 | 22 | 0 |
689048 | 689048 | 2020-11-01 | Tillamook | Oregon | 41057 | 77 | 0 |
689049 | 689049 | 2020-11-01 | Umatilla | Oregon | 41059 | 3481 | 45 |
689050 | 689050 | 2020-11-01 | Union | Oregon | 41061 | 494 | 2 |
689051 | 689051 | 2020-11-01 | Wallowa | Oregon | 41063 | 56 | 2 |
689052 | 689052 | 2020-11-01 | Wasco | Oregon | 41065 | 362 | 16 |
689053 | 689053 | 2020-11-01 | Washington | Oregon | 41067 | 6230 | 79 |
689054 | 689054 | 2020-11-01 | Wheeler | Oregon | 41069 | 1 | 0 |
689055 | 689055 | 2020-11-01 | Yamhill | Oregon | 41071 | 1043 | 15 |
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);