ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where deaths = 42, fips = 41059 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
630648 | 630648 | 2020-10-14 | Umatilla | Oregon | 41059 | 3223 | 42 |
627404 | 627404 | 2020-10-13 | Umatilla | Oregon | 41059 | 3202 | 42 |
624162 | 624162 | 2020-10-12 | Umatilla | Oregon | 41059 | 3187 | 42 |
620919 | 620919 | 2020-10-11 | Umatilla | Oregon | 41059 | 3170 | 42 |
617677 | 617677 | 2020-10-10 | Umatilla | Oregon | 41059 | 3158 | 42 |
614435 | 614435 | 2020-10-09 | Umatilla | Oregon | 41059 | 3158 | 42 |
611194 | 611194 | 2020-10-08 | Umatilla | Oregon | 41059 | 3143 | 42 |
607952 | 607952 | 2020-10-07 | Umatilla | Oregon | 41059 | 3132 | 42 |
604709 | 604709 | 2020-10-06 | Umatilla | Oregon | 41059 | 3116 | 42 |
601467 | 601467 | 2020-10-05 | Umatilla | Oregon | 41059 | 3109 | 42 |
598224 | 598224 | 2020-10-04 | Umatilla | Oregon | 41059 | 3095 | 42 |
594981 | 594981 | 2020-10-03 | Umatilla | Oregon | 41059 | 3084 | 42 |
591740 | 591740 | 2020-10-02 | Umatilla | Oregon | 41059 | 3081 | 42 |
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);