ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 24 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
812344 | 812344 | 2020-12-09 | Sherman | Oregon | 41055 | 24 | 0 |
809100 | 809100 | 2020-12-08 | Sherman | Oregon | 41055 | 24 | 0 |
805838 | 805838 | 2020-12-07 | Gilliam | Oregon | 41021 | 24 | 1 |
805855 | 805855 | 2020-12-07 | Sherman | Oregon | 41055 | 24 | 0 |
802593 | 802593 | 2020-12-06 | Gilliam | Oregon | 41021 | 24 | 0 |
802610 | 802610 | 2020-12-06 | Sherman | Oregon | 41055 | 24 | 0 |
799348 | 799348 | 2020-12-05 | Gilliam | Oregon | 41021 | 24 | 0 |
799365 | 799365 | 2020-12-05 | Sherman | Oregon | 41055 | 24 | 0 |
796103 | 796103 | 2020-12-04 | Gilliam | Oregon | 41021 | 24 | 0 |
796120 | 796120 | 2020-12-04 | Sherman | Oregon | 41055 | 24 | 0 |
520469 | 520469 | 2020-09-10 | Curry | Oregon | 41015 | 24 | 0 |
517233 | 517233 | 2020-09-09 | Curry | Oregon | 41015 | 24 | 0 |
391387 | 391387 | 2020-08-01 | Tillamook | Oregon | 41057 | 24 | 0 |
388170 | 388170 | 2020-07-31 | Tillamook | Oregon | 41057 | 24 | 0 |
384953 | 384953 | 2020-07-30 | Tillamook | Oregon | 41057 | 24 | 0 |
381735 | 381735 | 2020-07-29 | Tillamook | Oregon | 41057 | 24 | 0 |
378518 | 378518 | 2020-07-28 | Tillamook | Oregon | 41057 | 24 | 0 |
375302 | 375302 | 2020-07-27 | Tillamook | Oregon | 41057 | 24 | 0 |
372089 | 372089 | 2020-07-26 | Tillamook | Oregon | 41057 | 24 | 0 |
368877 | 368877 | 2020-07-25 | Tillamook | Oregon | 41057 | 24 | 0 |
365668 | 365668 | 2020-07-24 | Tillamook | Oregon | 41057 | 24 | 0 |
362462 | 362462 | 2020-07-23 | Tillamook | Oregon | 41057 | 24 | 0 |
343236 | 343236 | 2020-07-17 | Lake | Oregon | 41037 | 24 | 0 |
340038 | 340038 | 2020-07-16 | Lake | Oregon | 41037 | 24 | 0 |
336841 | 336841 | 2020-07-15 | Lake | Oregon | 41037 | 24 | 0 |
333647 | 333647 | 2020-07-14 | Lake | Oregon | 41037 | 24 | 0 |
330455 | 330455 | 2020-07-13 | Lake | Oregon | 41037 | 24 | 0 |
327269 | 327269 | 2020-07-12 | Lake | Oregon | 41037 | 24 | 0 |
324084 | 324084 | 2020-07-11 | Lake | Oregon | 41037 | 24 | 0 |
320904 | 320904 | 2020-07-10 | Lake | Oregon | 41037 | 24 | 0 |
317726 | 317726 | 2020-07-09 | Lake | Oregon | 41037 | 24 | 0 |
245387 | 245387 | 2020-06-16 | Josephine | Oregon | 41033 | 24 | 1 |
202041 | 202041 | 2020-06-02 | Josephine | Oregon | 41033 | 24 | 1 |
198966 | 198966 | 2020-06-01 | Josephine | Oregon | 41033 | 24 | 1 |
198982 | 198982 | 2020-06-01 | Wasco | Oregon | 41065 | 24 | 1 |
195909 | 195909 | 2020-05-31 | Wasco | Oregon | 41065 | 24 | 1 |
183640 | 183640 | 2020-05-27 | Jefferson | Oregon | 41031 | 24 | 0 |
180591 | 180591 | 2020-05-26 | Jefferson | Oregon | 41031 | 24 | 0 |
177548 | 177548 | 2020-05-25 | Jefferson | Oregon | 41031 | 24 | 0 |
165393 | 165393 | 2020-05-21 | Malheur | Oregon | 41045 | 24 | 0 |
162358 | 162358 | 2020-05-20 | Jefferson | Oregon | 41031 | 24 | 0 |
159331 | 159331 | 2020-05-19 | Jefferson | Oregon | 41031 | 24 | 0 |
156310 | 156310 | 2020-05-18 | Jefferson | Oregon | 41031 | 24 | 0 |
153293 | 153293 | 2020-05-17 | Jefferson | Oregon | 41031 | 24 | 0 |
150277 | 150277 | 2020-05-16 | Douglas | Oregon | 41019 | 24 | 0 |
150282 | 150282 | 2020-05-16 | Jefferson | Oregon | 41031 | 24 | 0 |
147275 | 147275 | 2020-05-15 | Jefferson | Oregon | 41031 | 24 | 0 |
144269 | 144269 | 2020-05-14 | Douglas | Oregon | 41019 | 24 | 0 |
144274 | 144274 | 2020-05-14 | Jefferson | Oregon | 41031 | 24 | 0 |
141273 | 141273 | 2020-05-13 | Douglas | Oregon | 41019 | 24 | 0 |
141278 | 141278 | 2020-05-13 | Jefferson | Oregon | 41031 | 24 | 0 |
138277 | 138277 | 2020-05-12 | Douglas | Oregon | 41019 | 24 | 0 |
138282 | 138282 | 2020-05-12 | Jefferson | Oregon | 41031 | 24 | 0 |
135287 | 135287 | 2020-05-11 | Douglas | Oregon | 41019 | 24 | 0 |
135292 | 135292 | 2020-05-11 | Jefferson | Oregon | 41031 | 24 | 0 |
135293 | 135293 | 2020-05-11 | Josephine | Oregon | 41033 | 24 | 1 |
132296 | 132296 | 2020-05-10 | Douglas | Oregon | 41019 | 24 | 0 |
132301 | 132301 | 2020-05-10 | Jefferson | Oregon | 41031 | 24 | 0 |
132302 | 132302 | 2020-05-10 | Josephine | Oregon | 41033 | 24 | 1 |
129307 | 129307 | 2020-05-09 | Douglas | Oregon | 41019 | 24 | 0 |
129312 | 129312 | 2020-05-09 | Jefferson | Oregon | 41031 | 24 | 0 |
129313 | 129313 | 2020-05-09 | Josephine | Oregon | 41033 | 24 | 1 |
126318 | 126318 | 2020-05-08 | Douglas | Oregon | 41019 | 24 | 0 |
126324 | 126324 | 2020-05-08 | Josephine | Oregon | 41033 | 24 | 1 |
123335 | 123335 | 2020-05-07 | Douglas | Oregon | 41019 | 24 | 0 |
123341 | 123341 | 2020-05-07 | Josephine | Oregon | 41033 | 24 | 1 |
120358 | 120358 | 2020-05-06 | Douglas | Oregon | 41019 | 24 | 0 |
120364 | 120364 | 2020-05-06 | Josephine | Oregon | 41033 | 24 | 1 |
117396 | 117396 | 2020-05-05 | Douglas | Oregon | 41019 | 24 | 0 |
117402 | 117402 | 2020-05-05 | Josephine | Oregon | 41033 | 24 | 1 |
114515 | 114515 | 2020-05-04 | Douglas | Oregon | 41019 | 24 | 0 |
111633 | 111633 | 2020-05-03 | Douglas | Oregon | 41019 | 24 | 0 |
108759 | 108759 | 2020-05-02 | Douglas | Oregon | 41019 | 24 | 0 |
105892 | 105892 | 2020-05-01 | Douglas | Oregon | 41019 | 24 | 0 |
83228 | 83228 | 2020-04-23 | Douglas | Oregon | 41019 | 24 | 0 |
58362 | 58362 | 2020-04-14 | Benton | Oregon | 41003 | 24 | 3 |
47658 | 47658 | 2020-04-10 | Klamath | Oregon | 41035 | 24 | 0 |
34907 | 34907 | 2020-04-05 | Polk | Oregon | 41053 | 24 | 1 |
32466 | 32466 | 2020-04-04 | Lane | Oregon | 41039 | 24 | 1 |
23266 | 23266 | 2020-03-31 | Deschutes | Oregon | 41017 | 24 | 0 |
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);