ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lincoln" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922683 | 922683 | 2021-01-12 | Lincoln | Oregon | 41041 | 964 | 17 |
919438 | 919438 | 2021-01-11 | Lincoln | Oregon | 41041 | 958 | 17 |
916193 | 916193 | 2021-01-10 | Lincoln | Oregon | 41041 | 950 | 17 |
912948 | 912948 | 2021-01-09 | Lincoln | Oregon | 41041 | 947 | 17 |
909703 | 909703 | 2021-01-08 | Lincoln | Oregon | 41041 | 934 | 17 |
906458 | 906458 | 2021-01-07 | Lincoln | Oregon | 41041 | 929 | 17 |
903212 | 903212 | 2021-01-06 | Lincoln | Oregon | 41041 | 921 | 17 |
899967 | 899967 | 2021-01-05 | Lincoln | Oregon | 41041 | 918 | 17 |
896722 | 896722 | 2021-01-04 | Lincoln | Oregon | 41041 | 912 | 17 |
893476 | 893476 | 2021-01-03 | Lincoln | Oregon | 41041 | 908 | 17 |
890230 | 890230 | 2021-01-02 | Lincoln | Oregon | 41041 | 907 | 17 |
886983 | 886983 | 2021-01-01 | Lincoln | Oregon | 41041 | 891 | 17 |
883738 | 883738 | 2020-12-31 | Lincoln | Oregon | 41041 | 880 | 17 |
880493 | 880493 | 2020-12-30 | Lincoln | Oregon | 41041 | 870 | 17 |
877248 | 877248 | 2020-12-29 | Lincoln | Oregon | 41041 | 868 | 17 |
874003 | 874003 | 2020-12-28 | Lincoln | Oregon | 41041 | 855 | 17 |
870758 | 870758 | 2020-12-27 | Lincoln | Oregon | 41041 | 855 | 17 |
867513 | 867513 | 2020-12-26 | Lincoln | Oregon | 41041 | 839 | 17 |
864268 | 864268 | 2020-12-25 | Lincoln | Oregon | 41041 | 839 | 17 |
861023 | 861023 | 2020-12-24 | Lincoln | Oregon | 41041 | 835 | 17 |
857778 | 857778 | 2020-12-23 | Lincoln | Oregon | 41041 | 819 | 17 |
854533 | 854533 | 2020-12-22 | Lincoln | Oregon | 41041 | 814 | 16 |
851288 | 851288 | 2020-12-21 | Lincoln | Oregon | 41041 | 807 | 16 |
848043 | 848043 | 2020-12-20 | Lincoln | Oregon | 41041 | 803 | 16 |
844798 | 844798 | 2020-12-19 | Lincoln | Oregon | 41041 | 800 | 16 |
841552 | 841552 | 2020-12-18 | Lincoln | Oregon | 41041 | 799 | 16 |
838307 | 838307 | 2020-12-17 | Lincoln | Oregon | 41041 | 793 | 16 |
835061 | 835061 | 2020-12-16 | Lincoln | Oregon | 41041 | 785 | 16 |
831815 | 831815 | 2020-12-15 | Lincoln | Oregon | 41041 | 780 | 16 |
828568 | 828568 | 2020-12-14 | Lincoln | Oregon | 41041 | 777 | 16 |
825322 | 825322 | 2020-12-13 | Lincoln | Oregon | 41041 | 770 | 16 |
822075 | 822075 | 2020-12-12 | Lincoln | Oregon | 41041 | 758 | 16 |
818829 | 818829 | 2020-12-11 | Lincoln | Oregon | 41041 | 752 | 16 |
815583 | 815583 | 2020-12-10 | Lincoln | Oregon | 41041 | 741 | 16 |
812337 | 812337 | 2020-12-09 | Lincoln | Oregon | 41041 | 734 | 16 |
809093 | 809093 | 2020-12-08 | Lincoln | Oregon | 41041 | 720 | 16 |
805848 | 805848 | 2020-12-07 | Lincoln | Oregon | 41041 | 709 | 16 |
802603 | 802603 | 2020-12-06 | Lincoln | Oregon | 41041 | 692 | 16 |
799358 | 799358 | 2020-12-05 | Lincoln | Oregon | 41041 | 688 | 16 |
796113 | 796113 | 2020-12-04 | Lincoln | Oregon | 41041 | 678 | 16 |
792868 | 792868 | 2020-12-03 | Lincoln | Oregon | 41041 | 670 | 15 |
789623 | 789623 | 2020-12-02 | Lincoln | Oregon | 41041 | 665 | 15 |
786378 | 786378 | 2020-12-01 | Lincoln | Oregon | 41041 | 646 | 15 |
783134 | 783134 | 2020-11-30 | Lincoln | Oregon | 41041 | 625 | 15 |
779888 | 779888 | 2020-11-29 | Lincoln | Oregon | 41041 | 622 | 15 |
776643 | 776643 | 2020-11-28 | Lincoln | Oregon | 41041 | 616 | 15 |
773398 | 773398 | 2020-11-27 | Lincoln | Oregon | 41041 | 613 | 15 |
770153 | 770153 | 2020-11-26 | Lincoln | Oregon | 41041 | 610 | 15 |
766907 | 766907 | 2020-11-25 | Lincoln | Oregon | 41041 | 600 | 14 |
763662 | 763662 | 2020-11-24 | Lincoln | Oregon | 41041 | 588 | 13 |
760417 | 760417 | 2020-11-23 | Lincoln | Oregon | 41041 | 565 | 13 |
757172 | 757172 | 2020-11-22 | Lincoln | Oregon | 41041 | 563 | 13 |
753925 | 753925 | 2020-11-21 | Lincoln | Oregon | 41041 | 562 | 13 |
750679 | 750679 | 2020-11-20 | Lincoln | Oregon | 41041 | 559 | 13 |
747433 | 747433 | 2020-11-19 | Lincoln | Oregon | 41041 | 552 | 13 |
744187 | 744187 | 2020-11-18 | Lincoln | Oregon | 41041 | 551 | 13 |
740940 | 740940 | 2020-11-17 | Lincoln | Oregon | 41041 | 546 | 13 |
737694 | 737694 | 2020-11-16 | Lincoln | Oregon | 41041 | 544 | 13 |
734450 | 734450 | 2020-11-15 | Lincoln | Oregon | 41041 | 544 | 13 |
731204 | 731204 | 2020-11-14 | Lincoln | Oregon | 41041 | 542 | 13 |
727960 | 727960 | 2020-11-13 | Lincoln | Oregon | 41041 | 532 | 13 |
724716 | 724716 | 2020-11-12 | Lincoln | Oregon | 41041 | 530 | 13 |
721473 | 721473 | 2020-11-11 | Lincoln | Oregon | 41041 | 529 | 13 |
718230 | 718230 | 2020-11-10 | Lincoln | Oregon | 41041 | 529 | 13 |
714987 | 714987 | 2020-11-09 | Lincoln | Oregon | 41041 | 526 | 13 |
711743 | 711743 | 2020-11-08 | Lincoln | Oregon | 41041 | 526 | 13 |
708499 | 708499 | 2020-11-07 | Lincoln | Oregon | 41041 | 526 | 13 |
705256 | 705256 | 2020-11-06 | Lincoln | Oregon | 41041 | 526 | 13 |
702013 | 702013 | 2020-11-05 | Lincoln | Oregon | 41041 | 523 | 13 |
698769 | 698769 | 2020-11-04 | Lincoln | Oregon | 41041 | 522 | 13 |
695526 | 695526 | 2020-11-03 | Lincoln | Oregon | 41041 | 522 | 13 |
692284 | 692284 | 2020-11-02 | Lincoln | Oregon | 41041 | 522 | 13 |
689040 | 689040 | 2020-11-01 | Lincoln | Oregon | 41041 | 521 | 13 |
685795 | 685795 | 2020-10-31 | Lincoln | Oregon | 41041 | 519 | 13 |
682552 | 682552 | 2020-10-30 | Lincoln | Oregon | 41041 | 519 | 13 |
679309 | 679309 | 2020-10-29 | Lincoln | Oregon | 41041 | 518 | 13 |
676066 | 676066 | 2020-10-28 | Lincoln | Oregon | 41041 | 518 | 13 |
672823 | 672823 | 2020-10-27 | Lincoln | Oregon | 41041 | 517 | 13 |
669581 | 669581 | 2020-10-26 | Lincoln | Oregon | 41041 | 517 | 13 |
666337 | 666337 | 2020-10-25 | Lincoln | Oregon | 41041 | 517 | 13 |
663092 | 663092 | 2020-10-24 | Lincoln | Oregon | 41041 | 515 | 13 |
659848 | 659848 | 2020-10-23 | Lincoln | Oregon | 41041 | 511 | 13 |
656604 | 656604 | 2020-10-22 | Lincoln | Oregon | 41041 | 509 | 13 |
653359 | 653359 | 2020-10-21 | Lincoln | Oregon | 41041 | 509 | 13 |
650114 | 650114 | 2020-10-20 | Lincoln | Oregon | 41041 | 508 | 13 |
646870 | 646870 | 2020-10-19 | Lincoln | Oregon | 41041 | 508 | 13 |
643624 | 643624 | 2020-10-18 | Lincoln | Oregon | 41041 | 508 | 13 |
640376 | 640376 | 2020-10-17 | Lincoln | Oregon | 41041 | 507 | 13 |
637130 | 637130 | 2020-10-16 | Lincoln | Oregon | 41041 | 507 | 13 |
633884 | 633884 | 2020-10-15 | Lincoln | Oregon | 41041 | 507 | 13 |
630639 | 630639 | 2020-10-14 | Lincoln | Oregon | 41041 | 503 | 13 |
627395 | 627395 | 2020-10-13 | Lincoln | Oregon | 41041 | 501 | 13 |
624153 | 624153 | 2020-10-12 | Lincoln | Oregon | 41041 | 496 | 13 |
620910 | 620910 | 2020-10-11 | Lincoln | Oregon | 41041 | 496 | 13 |
617668 | 617668 | 2020-10-10 | Lincoln | Oregon | 41041 | 495 | 13 |
614426 | 614426 | 2020-10-09 | Lincoln | Oregon | 41041 | 493 | 13 |
611185 | 611185 | 2020-10-08 | Lincoln | Oregon | 41041 | 492 | 13 |
607943 | 607943 | 2020-10-07 | Lincoln | Oregon | 41041 | 489 | 13 |
604700 | 604700 | 2020-10-06 | Lincoln | Oregon | 41041 | 488 | 13 |
601458 | 601458 | 2020-10-05 | Lincoln | Oregon | 41041 | 485 | 13 |
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);