ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where cases = 8 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
607933 | 607933 | 2020-10-07 | Gilliam | Oregon | 41021 | 8 | 0 |
604690 | 604690 | 2020-10-06 | Gilliam | Oregon | 41021 | 8 | 0 |
601448 | 601448 | 2020-10-05 | Gilliam | Oregon | 41021 | 8 | 0 |
598205 | 598205 | 2020-10-04 | Gilliam | Oregon | 41021 | 8 | 0 |
594962 | 594962 | 2020-10-03 | Gilliam | Oregon | 41021 | 8 | 0 |
591721 | 591721 | 2020-10-02 | Gilliam | Oregon | 41021 | 8 | 0 |
588480 | 588480 | 2020-10-01 | Gilliam | Oregon | 41021 | 8 | 0 |
585240 | 585240 | 2020-09-30 | Gilliam | Oregon | 41021 | 8 | 0 |
582000 | 582000 | 2020-09-29 | Gilliam | Oregon | 41021 | 8 | 0 |
578760 | 578760 | 2020-09-28 | Gilliam | Oregon | 41021 | 8 | 0 |
575519 | 575519 | 2020-09-27 | Gilliam | Oregon | 41021 | 8 | 0 |
572275 | 572275 | 2020-09-26 | Gilliam | Oregon | 41021 | 8 | 0 |
569033 | 569033 | 2020-09-25 | Gilliam | Oregon | 41021 | 8 | 0 |
565792 | 565792 | 2020-09-24 | Gilliam | Oregon | 41021 | 8 | 0 |
562551 | 562551 | 2020-09-23 | Gilliam | Oregon | 41021 | 8 | 0 |
562552 | 562552 | 2020-09-23 | Grant | Oregon | 41023 | 8 | 0 |
559314 | 559314 | 2020-09-22 | Gilliam | Oregon | 41021 | 8 | 0 |
559315 | 559315 | 2020-09-22 | Grant | Oregon | 41023 | 8 | 0 |
556077 | 556077 | 2020-09-21 | Gilliam | Oregon | 41021 | 8 | 0 |
556078 | 556078 | 2020-09-21 | Grant | Oregon | 41023 | 8 | 0 |
552840 | 552840 | 2020-09-20 | Gilliam | Oregon | 41021 | 8 | 0 |
552841 | 552841 | 2020-09-20 | Grant | Oregon | 41023 | 8 | 0 |
549602 | 549602 | 2020-09-19 | Grant | Oregon | 41023 | 8 | 0 |
546363 | 546363 | 2020-09-18 | Grant | Oregon | 41023 | 8 | 0 |
539890 | 539890 | 2020-09-16 | Grant | Oregon | 41023 | 8 | 0 |
536653 | 536653 | 2020-09-15 | Grant | Oregon | 41023 | 8 | 0 |
533417 | 533417 | 2020-09-14 | Grant | Oregon | 41023 | 8 | 0 |
530182 | 530182 | 2020-09-13 | Grant | Oregon | 41023 | 8 | 0 |
526945 | 526945 | 2020-09-12 | Grant | Oregon | 41023 | 8 | 0 |
523709 | 523709 | 2020-09-11 | Grant | Oregon | 41023 | 8 | 0 |
520473 | 520473 | 2020-09-10 | Grant | Oregon | 41023 | 8 | 0 |
517237 | 517237 | 2020-09-09 | Grant | Oregon | 41023 | 8 | 0 |
514002 | 514002 | 2020-09-08 | Grant | Oregon | 41023 | 8 | 0 |
510769 | 510769 | 2020-09-07 | Grant | Oregon | 41023 | 8 | 0 |
507536 | 507536 | 2020-09-06 | Grant | Oregon | 41023 | 8 | 0 |
504304 | 504304 | 2020-09-05 | Grant | Oregon | 41023 | 8 | 0 |
501070 | 501070 | 2020-09-04 | Grant | Oregon | 41023 | 8 | 0 |
497836 | 497836 | 2020-09-03 | Grant | Oregon | 41023 | 8 | 0 |
494603 | 494603 | 2020-09-02 | Grant | Oregon | 41023 | 8 | 0 |
491369 | 491369 | 2020-09-01 | Grant | Oregon | 41023 | 8 | 0 |
488136 | 488136 | 2020-08-31 | Grant | Oregon | 41023 | 8 | 0 |
484903 | 484903 | 2020-08-30 | Grant | Oregon | 41023 | 8 | 0 |
481668 | 481668 | 2020-08-29 | Grant | Oregon | 41023 | 8 | 0 |
478434 | 478434 | 2020-08-28 | Grant | Oregon | 41023 | 8 | 0 |
475201 | 475201 | 2020-08-27 | Grant | Oregon | 41023 | 8 | 0 |
471967 | 471967 | 2020-08-26 | Grant | Oregon | 41023 | 8 | 0 |
468735 | 468735 | 2020-08-25 | Grant | Oregon | 41023 | 8 | 0 |
465507 | 465507 | 2020-08-24 | Grant | Oregon | 41023 | 8 | 0 |
462278 | 462278 | 2020-08-23 | Grant | Oregon | 41023 | 8 | 0 |
459050 | 459050 | 2020-08-22 | Grant | Oregon | 41023 | 8 | 0 |
397804 | 397804 | 2020-08-03 | Harney | Oregon | 41025 | 8 | 0 |
394587 | 394587 | 2020-08-02 | Harney | Oregon | 41025 | 8 | 0 |
391371 | 391371 | 2020-08-01 | Harney | Oregon | 41025 | 8 | 0 |
388154 | 388154 | 2020-07-31 | Harney | Oregon | 41025 | 8 | 0 |
384937 | 384937 | 2020-07-30 | Harney | Oregon | 41025 | 8 | 0 |
384952 | 384952 | 2020-07-30 | Sherman | Oregon | 41055 | 8 | 0 |
381719 | 381719 | 2020-07-29 | Harney | Oregon | 41025 | 8 | 0 |
381734 | 381734 | 2020-07-29 | Sherman | Oregon | 41055 | 8 | 0 |
378502 | 378502 | 2020-07-28 | Harney | Oregon | 41025 | 8 | 0 |
378517 | 378517 | 2020-07-28 | Sherman | Oregon | 41055 | 8 | 0 |
375301 | 375301 | 2020-07-27 | Sherman | Oregon | 41055 | 8 | 0 |
372088 | 372088 | 2020-07-26 | Sherman | Oregon | 41055 | 8 | 0 |
368876 | 368876 | 2020-07-25 | Sherman | Oregon | 41055 | 8 | 0 |
365667 | 365667 | 2020-07-24 | Sherman | Oregon | 41055 | 8 | 0 |
362461 | 362461 | 2020-07-23 | Sherman | Oregon | 41055 | 8 | 0 |
359255 | 359255 | 2020-07-22 | Sherman | Oregon | 41055 | 8 | 0 |
356051 | 356051 | 2020-07-21 | Sherman | Oregon | 41055 | 8 | 0 |
352848 | 352848 | 2020-07-20 | Sherman | Oregon | 41055 | 8 | 0 |
349645 | 349645 | 2020-07-19 | Sherman | Oregon | 41055 | 8 | 0 |
346445 | 346445 | 2020-07-18 | Sherman | Oregon | 41055 | 8 | 0 |
317708 | 317708 | 2020-07-09 | Baker | Oregon | 41001 | 8 | 0 |
314535 | 314535 | 2020-07-08 | Baker | Oregon | 41001 | 8 | 0 |
311370 | 311370 | 2020-07-07 | Curry | Oregon | 41015 | 8 | 0 |
308201 | 308201 | 2020-07-06 | Curry | Oregon | 41015 | 8 | 0 |
305034 | 305034 | 2020-07-05 | Curry | Oregon | 41015 | 8 | 0 |
301871 | 301871 | 2020-07-04 | Curry | Oregon | 41015 | 8 | 0 |
298708 | 298708 | 2020-07-03 | Curry | Oregon | 41015 | 8 | 0 |
289264 | 289264 | 2020-06-30 | Wallowa | Oregon | 41063 | 8 | 0 |
286113 | 286113 | 2020-06-29 | Wallowa | Oregon | 41063 | 8 | 0 |
282968 | 282968 | 2020-06-28 | Wallowa | Oregon | 41063 | 8 | 0 |
279822 | 279822 | 2020-06-27 | Wallowa | Oregon | 41063 | 8 | 0 |
276674 | 276674 | 2020-06-26 | Wallowa | Oregon | 41063 | 8 | 0 |
273527 | 273527 | 2020-06-25 | Wallowa | Oregon | 41063 | 8 | 0 |
270388 | 270388 | 2020-06-24 | Wallowa | Oregon | 41063 | 8 | 0 |
267254 | 267254 | 2020-06-23 | Wallowa | Oregon | 41063 | 8 | 0 |
264126 | 264126 | 2020-06-22 | Wallowa | Oregon | 41063 | 8 | 0 |
260998 | 260998 | 2020-06-21 | Wallowa | Oregon | 41063 | 8 | 0 |
242266 | 242266 | 2020-06-15 | Crook | Oregon | 41013 | 8 | 0 |
239157 | 239157 | 2020-06-14 | Crook | Oregon | 41013 | 8 | 0 |
236049 | 236049 | 2020-06-13 | Crook | Oregon | 41013 | 8 | 0 |
232944 | 232944 | 2020-06-12 | Crook | Oregon | 41013 | 8 | 0 |
229839 | 229839 | 2020-06-11 | Crook | Oregon | 41013 | 8 | 0 |
229862 | 229862 | 2020-06-11 | Union | Oregon | 41061 | 8 | 0 |
171466 | 171466 | 2020-05-23 | Lincoln | Oregon | 41041 | 8 | 0 |
168427 | 168427 | 2020-05-22 | Lincoln | Oregon | 41041 | 8 | 0 |
165391 | 165391 | 2020-05-21 | Lincoln | Oregon | 41041 | 8 | 0 |
162362 | 162362 | 2020-05-20 | Lincoln | Oregon | 41041 | 8 | 0 |
159335 | 159335 | 2020-05-19 | Lincoln | Oregon | 41041 | 8 | 0 |
156314 | 156314 | 2020-05-18 | Lincoln | Oregon | 41041 | 8 | 0 |
153297 | 153297 | 2020-05-17 | Lincoln | Oregon | 41041 | 8 | 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);