ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Polk" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
912954 | 912954 | 2021-01-09 | Polk | Oregon | 41053 | 2231 | 34 |
909709 | 909709 | 2021-01-08 | Polk | Oregon | 41053 | 2193 | 33 |
906464 | 906464 | 2021-01-07 | Polk | Oregon | 41053 | 2151 | 33 |
903218 | 903218 | 2021-01-06 | Polk | Oregon | 41053 | 2124 | 33 |
899973 | 899973 | 2021-01-05 | Polk | Oregon | 41053 | 2111 | 33 |
896728 | 896728 | 2021-01-04 | Polk | Oregon | 41053 | 2084 | 33 |
893482 | 893482 | 2021-01-03 | Polk | Oregon | 41053 | 2066 | 33 |
890236 | 890236 | 2021-01-02 | Polk | Oregon | 41053 | 2035 | 30 |
886989 | 886989 | 2021-01-01 | Polk | Oregon | 41053 | 1998 | 30 |
883744 | 883744 | 2020-12-31 | Polk | Oregon | 41053 | 1977 | 30 |
880499 | 880499 | 2020-12-30 | Polk | Oregon | 41053 | 1939 | 30 |
877254 | 877254 | 2020-12-29 | Polk | Oregon | 41053 | 1919 | 28 |
874009 | 874009 | 2020-12-28 | Polk | Oregon | 41053 | 1875 | 25 |
870764 | 870764 | 2020-12-27 | Polk | Oregon | 41053 | 1875 | 25 |
867519 | 867519 | 2020-12-26 | Polk | Oregon | 41053 | 1831 | 25 |
864274 | 864274 | 2020-12-25 | Polk | Oregon | 41053 | 1831 | 25 |
861029 | 861029 | 2020-12-24 | Polk | Oregon | 41053 | 1819 | 25 |
857784 | 857784 | 2020-12-23 | Polk | Oregon | 41053 | 1809 | 25 |
854539 | 854539 | 2020-12-22 | Polk | Oregon | 41053 | 1785 | 24 |
851294 | 851294 | 2020-12-21 | Polk | Oregon | 41053 | 1750 | 24 |
848049 | 848049 | 2020-12-20 | Polk | Oregon | 41053 | 1739 | 24 |
844804 | 844804 | 2020-12-19 | Polk | Oregon | 41053 | 1726 | 24 |
841558 | 841558 | 2020-12-18 | Polk | Oregon | 41053 | 1695 | 24 |
838313 | 838313 | 2020-12-17 | Polk | Oregon | 41053 | 1677 | 24 |
835067 | 835067 | 2020-12-16 | Polk | Oregon | 41053 | 1657 | 24 |
831821 | 831821 | 2020-12-15 | Polk | Oregon | 41053 | 1629 | 24 |
828574 | 828574 | 2020-12-14 | Polk | Oregon | 41053 | 1608 | 24 |
825328 | 825328 | 2020-12-13 | Polk | Oregon | 41053 | 1582 | 24 |
822081 | 822081 | 2020-12-12 | Polk | Oregon | 41053 | 1566 | 24 |
818835 | 818835 | 2020-12-11 | Polk | Oregon | 41053 | 1548 | 24 |
815589 | 815589 | 2020-12-10 | Polk | Oregon | 41053 | 1525 | 24 |
812343 | 812343 | 2020-12-09 | Polk | Oregon | 41053 | 1495 | 24 |
809099 | 809099 | 2020-12-08 | Polk | Oregon | 41053 | 1470 | 24 |
805854 | 805854 | 2020-12-07 | Polk | Oregon | 41053 | 1454 | 23 |
802609 | 802609 | 2020-12-06 | Polk | Oregon | 41053 | 1431 | 23 |
799364 | 799364 | 2020-12-05 | Polk | Oregon | 41053 | 1412 | 22 |
796119 | 796119 | 2020-12-04 | Polk | Oregon | 41053 | 1387 | 20 |
792874 | 792874 | 2020-12-03 | Polk | Oregon | 41053 | 1343 | 19 |
789629 | 789629 | 2020-12-02 | Polk | Oregon | 41053 | 1332 | 19 |
786384 | 786384 | 2020-12-01 | Polk | Oregon | 41053 | 1300 | 19 |
783140 | 783140 | 2020-11-30 | Polk | Oregon | 41053 | 1275 | 16 |
779894 | 779894 | 2020-11-29 | Polk | Oregon | 41053 | 1250 | 16 |
776649 | 776649 | 2020-11-28 | Polk | Oregon | 41053 | 1214 | 16 |
773404 | 773404 | 2020-11-27 | Polk | Oregon | 41053 | 1168 | 16 |
770159 | 770159 | 2020-11-26 | Polk | Oregon | 41053 | 1168 | 16 |
766913 | 766913 | 2020-11-25 | Polk | Oregon | 41053 | 1140 | 15 |
763668 | 763668 | 2020-11-24 | Polk | Oregon | 41053 | 1106 | 15 |
760423 | 760423 | 2020-11-23 | Polk | Oregon | 41053 | 1076 | 15 |
757178 | 757178 | 2020-11-22 | Polk | Oregon | 41053 | 1051 | 15 |
753931 | 753931 | 2020-11-21 | Polk | Oregon | 41053 | 1025 | 15 |
750685 | 750685 | 2020-11-20 | Polk | Oregon | 41053 | 983 | 15 |
747439 | 747439 | 2020-11-19 | Polk | Oregon | 41053 | 961 | 15 |
744193 | 744193 | 2020-11-18 | Polk | Oregon | 41053 | 940 | 15 |
740946 | 740946 | 2020-11-17 | Polk | Oregon | 41053 | 930 | 15 |
737700 | 737700 | 2020-11-16 | Polk | Oregon | 41053 | 906 | 15 |
734456 | 734456 | 2020-11-15 | Polk | Oregon | 41053 | 891 | 15 |
731210 | 731210 | 2020-11-14 | Polk | Oregon | 41053 | 873 | 15 |
727966 | 727966 | 2020-11-13 | Polk | Oregon | 41053 | 857 | 15 |
724722 | 724722 | 2020-11-12 | Polk | Oregon | 41053 | 843 | 15 |
721479 | 721479 | 2020-11-11 | Polk | Oregon | 41053 | 825 | 15 |
718236 | 718236 | 2020-11-10 | Polk | Oregon | 41053 | 815 | 15 |
714993 | 714993 | 2020-11-09 | Polk | Oregon | 41053 | 800 | 15 |
711749 | 711749 | 2020-11-08 | Polk | Oregon | 41053 | 783 | 15 |
708505 | 708505 | 2020-11-07 | Polk | Oregon | 41053 | 766 | 15 |
705262 | 705262 | 2020-11-06 | Polk | Oregon | 41053 | 755 | 15 |
702019 | 702019 | 2020-11-05 | Polk | Oregon | 41053 | 740 | 15 |
698775 | 698775 | 2020-11-04 | Polk | Oregon | 41053 | 732 | 15 |
695532 | 695532 | 2020-11-03 | Polk | Oregon | 41053 | 719 | 15 |
692290 | 692290 | 2020-11-02 | Polk | Oregon | 41053 | 706 | 15 |
689046 | 689046 | 2020-11-01 | Polk | Oregon | 41053 | 695 | 15 |
685801 | 685801 | 2020-10-31 | Polk | Oregon | 41053 | 690 | 15 |
682558 | 682558 | 2020-10-30 | Polk | Oregon | 41053 | 675 | 15 |
679315 | 679315 | 2020-10-29 | Polk | Oregon | 41053 | 668 | 15 |
676072 | 676072 | 2020-10-28 | Polk | Oregon | 41053 | 663 | 15 |
672829 | 672829 | 2020-10-27 | Polk | Oregon | 41053 | 657 | 15 |
669587 | 669587 | 2020-10-26 | Polk | Oregon | 41053 | 654 | 15 |
666343 | 666343 | 2020-10-25 | Polk | Oregon | 41053 | 650 | 15 |
663098 | 663098 | 2020-10-24 | Polk | Oregon | 41053 | 648 | 15 |
659854 | 659854 | 2020-10-23 | Polk | Oregon | 41053 | 643 | 15 |
656610 | 656610 | 2020-10-22 | Polk | Oregon | 41053 | 640 | 15 |
653365 | 653365 | 2020-10-21 | Polk | Oregon | 41053 | 639 | 15 |
650120 | 650120 | 2020-10-20 | Polk | Oregon | 41053 | 637 | 15 |
646876 | 646876 | 2020-10-19 | Polk | Oregon | 41053 | 631 | 15 |
643630 | 643630 | 2020-10-18 | Polk | Oregon | 41053 | 628 | 15 |
640382 | 640382 | 2020-10-17 | Polk | Oregon | 41053 | 626 | 15 |
637136 | 637136 | 2020-10-16 | Polk | Oregon | 41053 | 618 | 15 |
633890 | 633890 | 2020-10-15 | Polk | Oregon | 41053 | 606 | 15 |
630645 | 630645 | 2020-10-14 | Polk | Oregon | 41053 | 594 | 15 |
627401 | 627401 | 2020-10-13 | Polk | Oregon | 41053 | 590 | 15 |
624159 | 624159 | 2020-10-12 | Polk | Oregon | 41053 | 587 | 15 |
620916 | 620916 | 2020-10-11 | Polk | Oregon | 41053 | 586 | 15 |
617674 | 617674 | 2020-10-10 | Polk | Oregon | 41053 | 582 | 15 |
614432 | 614432 | 2020-10-09 | Polk | Oregon | 41053 | 581 | 15 |
611191 | 611191 | 2020-10-08 | Polk | Oregon | 41053 | 574 | 15 |
607949 | 607949 | 2020-10-07 | Polk | Oregon | 41053 | 570 | 15 |
604706 | 604706 | 2020-10-06 | Polk | Oregon | 41053 | 567 | 15 |
601464 | 601464 | 2020-10-05 | Polk | Oregon | 41053 | 556 | 15 |
598221 | 598221 | 2020-10-04 | Polk | Oregon | 41053 | 553 | 15 |
594978 | 594978 | 2020-10-03 | Polk | Oregon | 41053 | 549 | 15 |
591737 | 591737 | 2020-10-02 | Polk | Oregon | 41053 | 543 | 15 |
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);