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 2022-03-06 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2280489 | 2280489 | 2022-03-06 | Baker | Oregon | 41001 | 3194 | 46 |
2280490 | 2280490 | 2022-03-06 | Benton | Oregon | 41003 | 14865 | 62 |
2280491 | 2280491 | 2022-03-06 | Clackamas | Oregon | 41005 | 59292 | 530 |
2280492 | 2280492 | 2022-03-06 | Clatsop | Oregon | 41007 | 4527 | 39 |
2280493 | 2280493 | 2022-03-06 | Columbia | Oregon | 41009 | 7459 | 75 |
2280494 | 2280494 | 2022-03-06 | Coos | Oregon | 41011 | 10492 | 143 |
2280495 | 2280495 | 2022-03-06 | Crook | Oregon | 41013 | 5995 | 76 |
2280496 | 2280496 | 2022-03-06 | Curry | Oregon | 41015 | 3291 | 44 |
2280497 | 2280497 | 2022-03-06 | Deschutes | Oregon | 41017 | 45373 | 244 |
2280498 | 2280498 | 2022-03-06 | Douglas | Oregon | 41019 | 19493 | 372 |
2280499 | 2280499 | 2022-03-06 | Gilliam | Oregon | 41021 | 281 | 5 |
2280500 | 2280500 | 2022-03-06 | Grant | Oregon | 41023 | 1572 | 18 |
2280501 | 2280501 | 2022-03-06 | Harney | Oregon | 41025 | 1589 | 37 |
2280502 | 2280502 | 2022-03-06 | Hood River | Oregon | 41027 | 3491 | 42 |
2280503 | 2280503 | 2022-03-06 | Jackson | Oregon | 41029 | 42196 | 486 |
2280504 | 2280504 | 2022-03-06 | Jefferson | Oregon | 41031 | 7159 | 84 |
2280505 | 2280505 | 2022-03-06 | Josephine | Oregon | 41033 | 16083 | 314 |
2280506 | 2280506 | 2022-03-06 | Klamath | Oregon | 41035 | 13982 | 196 |
2280507 | 2280507 | 2022-03-06 | Lake | Oregon | 41037 | 1384 | 24 |
2280508 | 2280508 | 2022-03-06 | Lane | Oregon | 41039 | 56436 | 471 |
2280509 | 2280509 | 2022-03-06 | Lincoln | Oregon | 41041 | 6931 | 73 |
2280510 | 2280510 | 2022-03-06 | Linn | Oregon | 41043 | 26106 | 234 |
2280511 | 2280511 | 2022-03-06 | Malheur | Oregon | 41045 | 8176 | 101 |
2280512 | 2280512 | 2022-03-06 | Marion | Oregon | 41047 | 68389 | 660 |
2280513 | 2280513 | 2022-03-06 | Morrow | Oregon | 41049 | 2942 | 31 |
2280514 | 2280514 | 2022-03-06 | Multnomah | Oregon | 41051 | 111223 | 1062 |
2280515 | 2280515 | 2022-03-06 | Polk | Oregon | 41053 | 15117 | 127 |
2280516 | 2280516 | 2022-03-06 | Sherman | Oregon | 41055 | 313 | 4 |
2280517 | 2280517 | 2022-03-06 | Tillamook | Oregon | 41057 | 3596 | 57 |
2280518 | 2280518 | 2022-03-06 | Umatilla | Oregon | 41059 | 22243 | 201 |
2280519 | 2280519 | 2022-03-06 | Union | Oregon | 41061 | 5002 | 74 |
2280520 | 2280520 | 2022-03-06 | Wallowa | Oregon | 41063 | 1235 | 14 |
2280521 | 2280521 | 2022-03-06 | Wasco | Oregon | 41065 | 5064 | 55 |
2280522 | 2280522 | 2022-03-06 | Washington | Oregon | 41067 | 84400 | 511 |
2280523 | 2280523 | 2022-03-06 | Wheeler | Oregon | 41069 | 243 | 3 |
2280524 | 2280524 | 2022-03-06 | Yamhill | Oregon | 41071 | 17583 | 194 |
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);