ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 3, fips = 41049 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
514015 | 514015 | 2020-09-08 | Morrow | Oregon | 41049 | 459 | 3 |
510782 | 510782 | 2020-09-07 | Morrow | Oregon | 41049 | 455 | 3 |
507549 | 507549 | 2020-09-06 | Morrow | Oregon | 41049 | 455 | 3 |
504317 | 504317 | 2020-09-05 | Morrow | Oregon | 41049 | 454 | 3 |
501083 | 501083 | 2020-09-04 | Morrow | Oregon | 41049 | 453 | 3 |
497849 | 497849 | 2020-09-03 | Morrow | Oregon | 41049 | 447 | 3 |
494616 | 494616 | 2020-09-02 | Morrow | Oregon | 41049 | 440 | 3 |
491382 | 491382 | 2020-09-01 | Morrow | Oregon | 41049 | 439 | 3 |
488149 | 488149 | 2020-08-31 | Morrow | Oregon | 41049 | 437 | 3 |
484916 | 484916 | 2020-08-30 | Morrow | Oregon | 41049 | 437 | 3 |
481681 | 481681 | 2020-08-29 | Morrow | Oregon | 41049 | 431 | 3 |
478447 | 478447 | 2020-08-28 | Morrow | Oregon | 41049 | 429 | 3 |
475214 | 475214 | 2020-08-27 | Morrow | Oregon | 41049 | 420 | 3 |
471980 | 471980 | 2020-08-26 | Morrow | Oregon | 41049 | 425 | 3 |
468748 | 468748 | 2020-08-25 | Morrow | Oregon | 41049 | 430 | 3 |
465520 | 465520 | 2020-08-24 | Morrow | Oregon | 41049 | 424 | 3 |
462291 | 462291 | 2020-08-23 | Morrow | Oregon | 41049 | 421 | 3 |
459063 | 459063 | 2020-08-22 | Morrow | Oregon | 41049 | 419 | 3 |
455835 | 455835 | 2020-08-21 | Morrow | Oregon | 41049 | 418 | 3 |
452607 | 452607 | 2020-08-20 | Morrow | Oregon | 41049 | 415 | 3 |
449379 | 449379 | 2020-08-19 | Morrow | Oregon | 41049 | 410 | 3 |
446151 | 446151 | 2020-08-18 | Morrow | Oregon | 41049 | 410 | 3 |
442925 | 442925 | 2020-08-17 | Morrow | Oregon | 41049 | 407 | 3 |
439698 | 439698 | 2020-08-16 | Morrow | Oregon | 41049 | 407 | 3 |
436473 | 436473 | 2020-08-15 | Morrow | Oregon | 41049 | 400 | 3 |
433246 | 433246 | 2020-08-14 | Morrow | Oregon | 41049 | 393 | 3 |
430020 | 430020 | 2020-08-13 | Morrow | Oregon | 41049 | 384 | 3 |
426795 | 426795 | 2020-08-12 | Morrow | Oregon | 41049 | 378 | 3 |
423572 | 423572 | 2020-08-11 | Morrow | Oregon | 41049 | 377 | 3 |
420349 | 420349 | 2020-08-10 | Morrow | Oregon | 41049 | 372 | 3 |
417129 | 417129 | 2020-08-09 | Morrow | Oregon | 41049 | 357 | 3 |
413908 | 413908 | 2020-08-08 | Morrow | Oregon | 41049 | 354 | 3 |
410688 | 410688 | 2020-08-07 | Morrow | Oregon | 41049 | 349 | 3 |
407468 | 407468 | 2020-08-06 | Morrow | Oregon | 41049 | 329 | 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);