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-17 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 |
---|---|---|---|---|---|---|---|
1039502 | 1039502 | 2021-02-17 | Baker | Oregon | 41001 | 619 | 7 |
1039503 | 1039503 | 2021-02-17 | Benton | Oregon | 41003 | 2198 | 16 |
1039504 | 1039504 | 2021-02-17 | Clackamas | Oregon | 41005 | 13114 | 172 |
1039505 | 1039505 | 2021-02-17 | Clatsop | Oregon | 41007 | 763 | 6 |
1039506 | 1039506 | 2021-02-17 | Columbia | Oregon | 41009 | 1180 | 21 |
1039507 | 1039507 | 2021-02-17 | Coos | Oregon | 41011 | 1301 | 17 |
1039508 | 1039508 | 2021-02-17 | Crook | Oregon | 41013 | 751 | 18 |
1039509 | 1039509 | 2021-02-17 | Curry | Oregon | 41015 | 374 | 6 |
1039510 | 1039510 | 2021-02-17 | Deschutes | Oregon | 41017 | 5795 | 56 |
1039511 | 1039511 | 2021-02-17 | Douglas | Oregon | 41019 | 2247 | 51 |
1039512 | 1039512 | 2021-02-17 | Gilliam | Oregon | 41021 | 53 | 1 |
1039513 | 1039513 | 2021-02-17 | Grant | Oregon | 41023 | 221 | 1 |
1039514 | 1039514 | 2021-02-17 | Harney | Oregon | 41025 | 262 | 6 |
1039515 | 1039515 | 2021-02-17 | Hood River | Oregon | 41027 | 1051 | 29 |
1039516 | 1039516 | 2021-02-17 | Jackson | Oregon | 41029 | 8004 | 107 |
1039517 | 1039517 | 2021-02-17 | Jefferson | Oregon | 41031 | 1900 | 27 |
1039518 | 1039518 | 2021-02-17 | Josephine | Oregon | 41033 | 2213 | 47 |
1039519 | 1039519 | 2021-02-17 | Klamath | Oregon | 41035 | 2729 | 54 |
1039520 | 1039520 | 2021-02-17 | Lake | Oregon | 41037 | 364 | 6 |
1039521 | 1039521 | 2021-02-17 | Lane | Oregon | 41039 | 9919 | 121 |
1039522 | 1039522 | 2021-02-17 | Lincoln | Oregon | 41041 | 1117 | 19 |
1039523 | 1039523 | 2021-02-17 | Linn | Oregon | 41043 | 3513 | 54 |
1039524 | 1039524 | 2021-02-17 | Malheur | Oregon | 41045 | 3317 | 58 |
1039525 | 1039525 | 2021-02-17 | Marion | Oregon | 41047 | 18030 | 278 |
1039526 | 1039526 | 2021-02-17 | Morrow | Oregon | 41049 | 1018 | 13 |
1039527 | 1039527 | 2021-02-17 | Multnomah | Oregon | 41051 | 31344 | 516 |
1039528 | 1039528 | 2021-02-17 | Polk | Oregon | 41053 | 2935 | 42 |
1039529 | 1039529 | 2021-02-17 | Sherman | Oregon | 41055 | 52 | 0 |
1039530 | 1039530 | 2021-02-17 | Tillamook | Oregon | 41057 | 398 | 2 |
1039531 | 1039531 | 2021-02-17 | Umatilla | Oregon | 41059 | 7475 | 79 |
1039532 | 1039532 | 2021-02-17 | Union | Oregon | 41061 | 1257 | 19 |
1039533 | 1039533 | 2021-02-17 | Wallowa | Oregon | 41063 | 139 | 4 |
1039534 | 1039534 | 2021-02-17 | Wasco | Oregon | 41065 | 1213 | 25 |
1039535 | 1039535 | 2021-02-17 | Washington | Oregon | 41067 | 20698 | 208 |
1039536 | 1039536 | 2021-02-17 | Wheeler | Oregon | 41069 | 22 | 1 |
1039537 | 1039537 | 2021-02-17 | Yamhill | Oregon | 41071 | 3671 | 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);