ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where county = "Morrow", deaths = 6 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 |
---|---|---|---|---|---|---|---|
669585 | 669585 | 2020-10-26 | Morrow | Oregon | 41049 | 545 | 6 |
666341 | 666341 | 2020-10-25 | Morrow | Oregon | 41049 | 545 | 6 |
663096 | 663096 | 2020-10-24 | Morrow | Oregon | 41049 | 543 | 6 |
659852 | 659852 | 2020-10-23 | Morrow | Oregon | 41049 | 543 | 6 |
656608 | 656608 | 2020-10-22 | Morrow | Oregon | 41049 | 542 | 6 |
653363 | 653363 | 2020-10-21 | Morrow | Oregon | 41049 | 542 | 6 |
650118 | 650118 | 2020-10-20 | Morrow | Oregon | 41049 | 542 | 6 |
646874 | 646874 | 2020-10-19 | Morrow | Oregon | 41049 | 540 | 6 |
643628 | 643628 | 2020-10-18 | Morrow | Oregon | 41049 | 540 | 6 |
640380 | 640380 | 2020-10-17 | Morrow | Oregon | 41049 | 539 | 6 |
637134 | 637134 | 2020-10-16 | Morrow | Oregon | 41049 | 538 | 6 |
633888 | 633888 | 2020-10-15 | Morrow | Oregon | 41049 | 533 | 6 |
630643 | 630643 | 2020-10-14 | Morrow | Oregon | 41049 | 532 | 6 |
627399 | 627399 | 2020-10-13 | Morrow | Oregon | 41049 | 532 | 6 |
624157 | 624157 | 2020-10-12 | Morrow | Oregon | 41049 | 532 | 6 |
620914 | 620914 | 2020-10-11 | Morrow | Oregon | 41049 | 532 | 6 |
617672 | 617672 | 2020-10-10 | Morrow | Oregon | 41049 | 532 | 6 |
614430 | 614430 | 2020-10-09 | Morrow | Oregon | 41049 | 530 | 6 |
611189 | 611189 | 2020-10-08 | Morrow | Oregon | 41049 | 529 | 6 |
607947 | 607947 | 2020-10-07 | Morrow | Oregon | 41049 | 524 | 6 |
604704 | 604704 | 2020-10-06 | Morrow | Oregon | 41049 | 523 | 6 |
601462 | 601462 | 2020-10-05 | Morrow | Oregon | 41049 | 522 | 6 |
598219 | 598219 | 2020-10-04 | Morrow | Oregon | 41049 | 521 | 6 |
594976 | 594976 | 2020-10-03 | Morrow | Oregon | 41049 | 519 | 6 |
591735 | 591735 | 2020-10-02 | Morrow | Oregon | 41049 | 516 | 6 |
588494 | 588494 | 2020-10-01 | Morrow | Oregon | 41049 | 515 | 6 |
585254 | 585254 | 2020-09-30 | Morrow | Oregon | 41049 | 513 | 6 |
582014 | 582014 | 2020-09-29 | Morrow | Oregon | 41049 | 509 | 6 |
578774 | 578774 | 2020-09-28 | Morrow | Oregon | 41049 | 505 | 6 |
575533 | 575533 | 2020-09-27 | Morrow | Oregon | 41049 | 499 | 6 |
572289 | 572289 | 2020-09-26 | Morrow | Oregon | 41049 | 498 | 6 |
569047 | 569047 | 2020-09-25 | Morrow | Oregon | 41049 | 498 | 6 |
565806 | 565806 | 2020-09-24 | Morrow | Oregon | 41049 | 494 | 6 |
562565 | 562565 | 2020-09-23 | Morrow | Oregon | 41049 | 490 | 6 |
559328 | 559328 | 2020-09-22 | Morrow | Oregon | 41049 | 490 | 6 |
556091 | 556091 | 2020-09-21 | Morrow | Oregon | 41049 | 490 | 6 |
552854 | 552854 | 2020-09-20 | Morrow | Oregon | 41049 | 488 | 6 |
549615 | 549615 | 2020-09-19 | Morrow | Oregon | 41049 | 485 | 6 |
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);