ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Union" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
906468 | 906468 | 2021-01-07 | Union | Oregon | 41061 | 1012 | 16 |
903222 | 903222 | 2021-01-06 | Union | Oregon | 41061 | 998 | 16 |
899977 | 899977 | 2021-01-05 | Union | Oregon | 41061 | 995 | 16 |
896732 | 896732 | 2021-01-04 | Union | Oregon | 41061 | 992 | 15 |
893486 | 893486 | 2021-01-03 | Union | Oregon | 41061 | 988 | 15 |
890240 | 890240 | 2021-01-02 | Union | Oregon | 41061 | 982 | 14 |
886993 | 886993 | 2021-01-01 | Union | Oregon | 41061 | 982 | 14 |
883748 | 883748 | 2020-12-31 | Union | Oregon | 41061 | 980 | 14 |
880503 | 880503 | 2020-12-30 | Union | Oregon | 41061 | 977 | 14 |
877258 | 877258 | 2020-12-29 | Union | Oregon | 41061 | 975 | 13 |
874013 | 874013 | 2020-12-28 | Union | Oregon | 41061 | 971 | 13 |
870768 | 870768 | 2020-12-27 | Union | Oregon | 41061 | 970 | 13 |
867523 | 867523 | 2020-12-26 | Union | Oregon | 41061 | 967 | 13 |
864278 | 864278 | 2020-12-25 | Union | Oregon | 41061 | 967 | 13 |
861033 | 861033 | 2020-12-24 | Union | Oregon | 41061 | 965 | 13 |
857788 | 857788 | 2020-12-23 | Union | Oregon | 41061 | 958 | 13 |
854543 | 854543 | 2020-12-22 | Union | Oregon | 41061 | 958 | 13 |
851298 | 851298 | 2020-12-21 | Union | Oregon | 41061 | 947 | 13 |
848053 | 848053 | 2020-12-20 | Union | Oregon | 41061 | 946 | 13 |
844808 | 844808 | 2020-12-19 | Union | Oregon | 41061 | 943 | 13 |
841562 | 841562 | 2020-12-18 | Union | Oregon | 41061 | 935 | 12 |
838317 | 838317 | 2020-12-17 | Union | Oregon | 41061 | 934 | 12 |
835071 | 835071 | 2020-12-16 | Union | Oregon | 41061 | 921 | 12 |
831825 | 831825 | 2020-12-15 | Union | Oregon | 41061 | 912 | 11 |
828578 | 828578 | 2020-12-14 | Union | Oregon | 41061 | 907 | 10 |
825332 | 825332 | 2020-12-13 | Union | Oregon | 41061 | 903 | 10 |
822085 | 822085 | 2020-12-12 | Union | Oregon | 41061 | 901 | 10 |
818839 | 818839 | 2020-12-11 | Union | Oregon | 41061 | 883 | 9 |
815593 | 815593 | 2020-12-10 | Union | Oregon | 41061 | 872 | 9 |
812347 | 812347 | 2020-12-09 | Union | Oregon | 41061 | 870 | 8 |
809103 | 809103 | 2020-12-08 | Union | Oregon | 41061 | 863 | 8 |
805858 | 805858 | 2020-12-07 | Union | Oregon | 41061 | 854 | 8 |
802613 | 802613 | 2020-12-06 | Union | Oregon | 41061 | 847 | 8 |
799368 | 799368 | 2020-12-05 | Union | Oregon | 41061 | 844 | 8 |
796123 | 796123 | 2020-12-04 | Union | Oregon | 41061 | 836 | 8 |
792878 | 792878 | 2020-12-03 | Union | Oregon | 41061 | 815 | 8 |
789633 | 789633 | 2020-12-02 | Union | Oregon | 41061 | 809 | 8 |
786388 | 786388 | 2020-12-01 | Union | Oregon | 41061 | 797 | 8 |
783144 | 783144 | 2020-11-30 | Union | Oregon | 41061 | 788 | 6 |
779898 | 779898 | 2020-11-29 | Union | Oregon | 41061 | 782 | 6 |
776653 | 776653 | 2020-11-28 | Union | Oregon | 41061 | 779 | 6 |
773408 | 773408 | 2020-11-27 | Union | Oregon | 41061 | 771 | 5 |
770163 | 770163 | 2020-11-26 | Union | Oregon | 41061 | 749 | 4 |
766917 | 766917 | 2020-11-25 | Union | Oregon | 41061 | 746 | 3 |
763672 | 763672 | 2020-11-24 | Union | Oregon | 41061 | 723 | 3 |
760427 | 760427 | 2020-11-23 | Union | Oregon | 41061 | 717 | 2 |
757182 | 757182 | 2020-11-22 | Union | Oregon | 41061 | 691 | 2 |
753935 | 753935 | 2020-11-21 | Union | Oregon | 41061 | 686 | 2 |
750689 | 750689 | 2020-11-20 | Union | Oregon | 41061 | 655 | 2 |
747443 | 747443 | 2020-11-19 | Union | Oregon | 41061 | 638 | 2 |
744197 | 744197 | 2020-11-18 | Union | Oregon | 41061 | 630 | 2 |
740950 | 740950 | 2020-11-17 | Union | Oregon | 41061 | 627 | 2 |
737704 | 737704 | 2020-11-16 | Union | Oregon | 41061 | 621 | 2 |
734460 | 734460 | 2020-11-15 | Union | Oregon | 41061 | 598 | 2 |
731214 | 731214 | 2020-11-14 | Union | Oregon | 41061 | 579 | 2 |
727970 | 727970 | 2020-11-13 | Union | Oregon | 41061 | 574 | 2 |
724726 | 724726 | 2020-11-12 | Union | Oregon | 41061 | 564 | 2 |
721483 | 721483 | 2020-11-11 | Union | Oregon | 41061 | 562 | 2 |
718240 | 718240 | 2020-11-10 | Union | Oregon | 41061 | 561 | 2 |
714997 | 714997 | 2020-11-09 | Union | Oregon | 41061 | 553 | 2 |
711753 | 711753 | 2020-11-08 | Union | Oregon | 41061 | 540 | 2 |
708509 | 708509 | 2020-11-07 | Union | Oregon | 41061 | 531 | 2 |
705266 | 705266 | 2020-11-06 | Union | Oregon | 41061 | 521 | 2 |
702023 | 702023 | 2020-11-05 | Union | Oregon | 41061 | 513 | 2 |
698779 | 698779 | 2020-11-04 | Union | Oregon | 41061 | 506 | 2 |
695536 | 695536 | 2020-11-03 | Union | Oregon | 41061 | 503 | 2 |
692294 | 692294 | 2020-11-02 | Union | Oregon | 41061 | 495 | 2 |
689050 | 689050 | 2020-11-01 | Union | Oregon | 41061 | 494 | 2 |
685805 | 685805 | 2020-10-31 | Union | Oregon | 41061 | 493 | 2 |
682562 | 682562 | 2020-10-30 | Union | Oregon | 41061 | 487 | 2 |
679319 | 679319 | 2020-10-29 | Union | Oregon | 41061 | 484 | 2 |
676076 | 676076 | 2020-10-28 | Union | Oregon | 41061 | 477 | 2 |
672833 | 672833 | 2020-10-27 | Union | Oregon | 41061 | 468 | 2 |
669591 | 669591 | 2020-10-26 | Union | Oregon | 41061 | 467 | 2 |
666347 | 666347 | 2020-10-25 | Union | Oregon | 41061 | 466 | 2 |
663102 | 663102 | 2020-10-24 | Union | Oregon | 41061 | 465 | 2 |
659858 | 659858 | 2020-10-23 | Union | Oregon | 41061 | 465 | 2 |
656614 | 656614 | 2020-10-22 | Union | Oregon | 41061 | 464 | 2 |
653369 | 653369 | 2020-10-21 | Union | Oregon | 41061 | 458 | 2 |
650124 | 650124 | 2020-10-20 | Union | Oregon | 41061 | 456 | 2 |
646880 | 646880 | 2020-10-19 | Union | Oregon | 41061 | 456 | 2 |
643634 | 643634 | 2020-10-18 | Union | Oregon | 41061 | 456 | 2 |
640386 | 640386 | 2020-10-17 | Union | Oregon | 41061 | 456 | 2 |
637140 | 637140 | 2020-10-16 | Union | Oregon | 41061 | 455 | 2 |
633894 | 633894 | 2020-10-15 | Union | Oregon | 41061 | 455 | 2 |
630649 | 630649 | 2020-10-14 | Union | Oregon | 41061 | 453 | 2 |
627405 | 627405 | 2020-10-13 | Union | Oregon | 41061 | 453 | 2 |
624163 | 624163 | 2020-10-12 | Union | Oregon | 41061 | 451 | 2 |
620920 | 620920 | 2020-10-11 | Union | Oregon | 41061 | 451 | 2 |
617678 | 617678 | 2020-10-10 | Union | Oregon | 41061 | 451 | 2 |
614436 | 614436 | 2020-10-09 | Union | Oregon | 41061 | 451 | 2 |
611195 | 611195 | 2020-10-08 | Union | Oregon | 41061 | 449 | 2 |
607953 | 607953 | 2020-10-07 | Union | Oregon | 41061 | 447 | 2 |
604710 | 604710 | 2020-10-06 | Union | Oregon | 41061 | 447 | 2 |
601468 | 601468 | 2020-10-05 | Union | Oregon | 41061 | 446 | 2 |
598225 | 598225 | 2020-10-04 | Union | Oregon | 41061 | 446 | 2 |
594982 | 594982 | 2020-10-03 | Union | Oregon | 41061 | 446 | 2 |
591741 | 591741 | 2020-10-02 | Union | Oregon | 41061 | 445 | 2 |
588500 | 588500 | 2020-10-01 | Union | Oregon | 41061 | 446 | 2 |
585260 | 585260 | 2020-09-30 | Union | Oregon | 41061 | 446 | 2 |
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);