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-14 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
828548 | 828548 | 2020-12-14 | Baker | Oregon | 41001 | 363 | 4 |
828549 | 828549 | 2020-12-14 | Benton | Oregon | 41003 | 1080 | 8 |
828550 | 828550 | 2020-12-14 | Clackamas | Oregon | 41005 | 8247 | 99 |
828551 | 828551 | 2020-12-14 | Clatsop | Oregon | 41007 | 457 | 1 |
828552 | 828552 | 2020-12-14 | Columbia | Oregon | 41009 | 675 | 7 |
828553 | 828553 | 2020-12-14 | Coos | Oregon | 41011 | 589 | 4 |
828554 | 828554 | 2020-12-14 | Crook | Oregon | 41013 | 351 | 6 |
828555 | 828555 | 2020-12-14 | Curry | Oregon | 41015 | 211 | 2 |
828556 | 828556 | 2020-12-14 | Deschutes | Oregon | 41017 | 3262 | 18 |
828557 | 828557 | 2020-12-14 | Douglas | Oregon | 41019 | 1204 | 30 |
828558 | 828558 | 2020-12-14 | Gilliam | Oregon | 41021 | 26 | 1 |
828559 | 828559 | 2020-12-14 | Grant | Oregon | 41023 | 159 | 1 |
828560 | 828560 | 2020-12-14 | Harney | Oregon | 41025 | 117 | 1 |
828561 | 828561 | 2020-12-14 | Hood River | Oregon | 41027 | 585 | 5 |
828562 | 828562 | 2020-12-14 | Jackson | Oregon | 41029 | 4897 | 50 |
828563 | 828563 | 2020-12-14 | Jefferson | Oregon | 41031 | 1151 | 12 |
828564 | 828564 | 2020-12-14 | Josephine | Oregon | 41033 | 839 | 10 |
828565 | 828565 | 2020-12-14 | Klamath | Oregon | 41035 | 1415 | 11 |
828566 | 828566 | 2020-12-14 | Lake | Oregon | 41037 | 174 | 1 |
828567 | 828567 | 2020-12-14 | Lane | Oregon | 41039 | 5629 | 68 |
828568 | 828568 | 2020-12-14 | Lincoln | Oregon | 41041 | 777 | 16 |
828569 | 828569 | 2020-12-14 | Linn | Oregon | 41043 | 2099 | 27 |
828570 | 828570 | 2020-12-14 | Malheur | Oregon | 41045 | 2626 | 45 |
828571 | 828571 | 2020-12-14 | Marion | Oregon | 41047 | 11577 | 180 |
828572 | 828572 | 2020-12-14 | Morrow | Oregon | 41049 | 748 | 7 |
828573 | 828573 | 2020-12-14 | Multnomah | Oregon | 41051 | 21561 | 307 |
828574 | 828574 | 2020-12-14 | Polk | Oregon | 41053 | 1608 | 24 |
828575 | 828575 | 2020-12-14 | Sherman | Oregon | 41055 | 27 | 0 |
828576 | 828576 | 2020-12-14 | Tillamook | Oregon | 41057 | 196 | 0 |
828577 | 828577 | 2020-12-14 | Umatilla | Oregon | 41059 | 4904 | 52 |
828578 | 828578 | 2020-12-14 | Union | Oregon | 41061 | 907 | 10 |
828579 | 828579 | 2020-12-14 | Wallowa | Oregon | 41063 | 74 | 3 |
828580 | 828580 | 2020-12-14 | Wasco | Oregon | 41065 | 701 | 19 |
828581 | 828581 | 2020-12-14 | Washington | Oregon | 41067 | 13588 | 119 |
828582 | 828582 | 2020-12-14 | Wheeler | Oregon | 41069 | 11 | 0 |
828583 | 828583 | 2020-12-14 | Yamhill | Oregon | 41071 | 2207 | 20 |
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);