ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where cases = 160 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
county 11
state 1
- Oregon · 15 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1861110 | 1861110 | 2021-10-28 | Sherman | Oregon | 41055 | 160 | 3 |
1857861 | 1857861 | 2021-10-27 | Sherman | Oregon | 41055 | 160 | 3 |
1260320 | 1260320 | 2021-04-26 | Wallowa | Oregon | 41063 | 160 | 5 |
1257073 | 1257073 | 2021-04-25 | Wallowa | Oregon | 41063 | 160 | 5 |
1253826 | 1253826 | 2021-04-24 | Wallowa | Oregon | 41063 | 160 | 5 |
812335 | 812335 | 2020-12-09 | Lake | Oregon | 41037 | 160 | 1 |
799345 | 799345 | 2020-12-05 | Curry | Oregon | 41015 | 160 | 2 |
585235 | 585235 | 2020-09-30 | Coos | Oregon | 41011 | 160 | 0 |
439683 | 439683 | 2020-08-16 | Douglas | Oregon | 41019 | 160 | 1 |
436458 | 436458 | 2020-08-15 | Douglas | Oregon | 41019 | 160 | 1 |
401008 | 401008 | 2020-08-04 | Benton | Oregon | 41003 | 160 | 6 |
320901 | 320901 | 2020-07-10 | Jefferson | Oregon | 41031 | 160 | 0 |
308220 | 308220 | 2020-07-06 | Polk | Oregon | 41053 | 160 | 12 |
298722 | 298722 | 2020-07-03 | Malheur | Oregon | 41045 | 160 | 1 |
27749 | 27749 | 2020-04-02 | Multnomah | Oregon | 41051 | 160 | 3 |
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);