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-12-05 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
799338 | 799338 | 2020-12-05 | Baker | Oregon | 41001 | 325 | 4 |
799339 | 799339 | 2020-12-05 | Benton | Oregon | 41003 | 896 | 7 |
799340 | 799340 | 2020-12-05 | Clackamas | Oregon | 41005 | 7091 | 87 |
799341 | 799341 | 2020-12-05 | Clatsop | Oregon | 41007 | 403 | 0 |
799342 | 799342 | 2020-12-05 | Columbia | Oregon | 41009 | 578 | 6 |
799343 | 799343 | 2020-12-05 | Coos | Oregon | 41011 | 505 | 3 |
799344 | 799344 | 2020-12-05 | Crook | Oregon | 41013 | 282 | 6 |
799345 | 799345 | 2020-12-05 | Curry | Oregon | 41015 | 160 | 2 |
799346 | 799346 | 2020-12-05 | Deschutes | Oregon | 41017 | 2761 | 15 |
799347 | 799347 | 2020-12-05 | Douglas | Oregon | 41019 | 1050 | 23 |
799348 | 799348 | 2020-12-05 | Gilliam | Oregon | 41021 | 24 | 0 |
799349 | 799349 | 2020-12-05 | Grant | Oregon | 41023 | 142 | 1 |
799350 | 799350 | 2020-12-05 | Harney | Oregon | 41025 | 110 | 1 |
799351 | 799351 | 2020-12-05 | Hood River | Oregon | 41027 | 473 | 3 |
799352 | 799352 | 2020-12-05 | Jackson | Oregon | 41029 | 4287 | 41 |
799353 | 799353 | 2020-12-05 | Jefferson | Oregon | 41031 | 932 | 11 |
799354 | 799354 | 2020-12-05 | Josephine | Oregon | 41033 | 650 | 6 |
799355 | 799355 | 2020-12-05 | Klamath | Oregon | 41035 | 1127 | 8 |
799356 | 799356 | 2020-12-05 | Lake | Oregon | 41037 | 149 | 1 |
799357 | 799357 | 2020-12-05 | Lane | Oregon | 41039 | 4838 | 52 |
799358 | 799358 | 2020-12-05 | Lincoln | Oregon | 41041 | 688 | 16 |
799359 | 799359 | 2020-12-05 | Linn | Oregon | 41043 | 1764 | 24 |
799360 | 799360 | 2020-12-05 | Malheur | Oregon | 41045 | 2550 | 45 |
799361 | 799361 | 2020-12-05 | Marion | Oregon | 41047 | 10118 | 161 |
799362 | 799362 | 2020-12-05 | Morrow | Oregon | 41049 | 700 | 7 |
799363 | 799363 | 2020-12-05 | Multnomah | Oregon | 41051 | 19209 | 269 |
799364 | 799364 | 2020-12-05 | Polk | Oregon | 41053 | 1412 | 22 |
799365 | 799365 | 2020-12-05 | Sherman | Oregon | 41055 | 24 | 0 |
799366 | 799366 | 2020-12-05 | Tillamook | Oregon | 41057 | 158 | 0 |
799367 | 799367 | 2020-12-05 | Umatilla | Oregon | 41059 | 4622 | 50 |
799368 | 799368 | 2020-12-05 | Union | Oregon | 41061 | 844 | 8 |
799369 | 799369 | 2020-12-05 | Wallowa | Oregon | 41063 | 72 | 3 |
799370 | 799370 | 2020-12-05 | Wasco | Oregon | 41065 | 602 | 19 |
799371 | 799371 | 2020-12-05 | Washington | Oregon | 41067 | 11801 | 108 |
799372 | 799372 | 2020-12-05 | Wheeler | Oregon | 41069 | 7 | 0 |
799373 | 799373 | 2020-12-05 | Yamhill | Oregon | 41071 | 1889 | 18 |
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);