ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Jefferson" and fips = 41031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948642 | 948642 | 2021-01-20 | Jefferson | Oregon | 41031 | 1712 | 25 |
945396 | 945396 | 2021-01-19 | Jefferson | Oregon | 41031 | 1707 | 25 |
942149 | 942149 | 2021-01-18 | Jefferson | Oregon | 41031 | 1705 | 25 |
938904 | 938904 | 2021-01-17 | Jefferson | Oregon | 41031 | 1702 | 25 |
935659 | 935659 | 2021-01-16 | Jefferson | Oregon | 41031 | 1687 | 25 |
932414 | 932414 | 2021-01-15 | Jefferson | Oregon | 41031 | 1675 | 25 |
929169 | 929169 | 2021-01-14 | Jefferson | Oregon | 41031 | 1661 | 25 |
925924 | 925924 | 2021-01-13 | Jefferson | Oregon | 41031 | 1649 | 24 |
922678 | 922678 | 2021-01-12 | Jefferson | Oregon | 41031 | 1627 | 23 |
919433 | 919433 | 2021-01-11 | Jefferson | Oregon | 41031 | 1608 | 21 |
916188 | 916188 | 2021-01-10 | Jefferson | Oregon | 41031 | 1603 | 20 |
912943 | 912943 | 2021-01-09 | Jefferson | Oregon | 41031 | 1592 | 20 |
909698 | 909698 | 2021-01-08 | Jefferson | Oregon | 41031 | 1584 | 20 |
906453 | 906453 | 2021-01-07 | Jefferson | Oregon | 41031 | 1582 | 20 |
903207 | 903207 | 2021-01-06 | Jefferson | Oregon | 41031 | 1562 | 20 |
899962 | 899962 | 2021-01-05 | Jefferson | Oregon | 41031 | 1549 | 20 |
896717 | 896717 | 2021-01-04 | Jefferson | Oregon | 41031 | 1540 | 18 |
893471 | 893471 | 2021-01-03 | Jefferson | Oregon | 41031 | 1534 | 18 |
890225 | 890225 | 2021-01-02 | Jefferson | Oregon | 41031 | 1467 | 18 |
886978 | 886978 | 2021-01-01 | Jefferson | Oregon | 41031 | 1439 | 18 |
883733 | 883733 | 2020-12-31 | Jefferson | Oregon | 41031 | 1425 | 17 |
880488 | 880488 | 2020-12-30 | Jefferson | Oregon | 41031 | 1392 | 17 |
877243 | 877243 | 2020-12-29 | Jefferson | Oregon | 41031 | 1383 | 17 |
873998 | 873998 | 2020-12-28 | Jefferson | Oregon | 41031 | 1380 | 16 |
870753 | 870753 | 2020-12-27 | Jefferson | Oregon | 41031 | 1380 | 16 |
867508 | 867508 | 2020-12-26 | Jefferson | Oregon | 41031 | 1378 | 16 |
864263 | 864263 | 2020-12-25 | Jefferson | Oregon | 41031 | 1345 | 16 |
861018 | 861018 | 2020-12-24 | Jefferson | Oregon | 41031 | 1324 | 16 |
857773 | 857773 | 2020-12-23 | Jefferson | Oregon | 41031 | 1313 | 16 |
854528 | 854528 | 2020-12-22 | Jefferson | Oregon | 41031 | 1306 | 14 |
851283 | 851283 | 2020-12-21 | Jefferson | Oregon | 41031 | 1286 | 14 |
848038 | 848038 | 2020-12-20 | Jefferson | Oregon | 41031 | 1259 | 14 |
844793 | 844793 | 2020-12-19 | Jefferson | Oregon | 41031 | 1256 | 14 |
841547 | 841547 | 2020-12-18 | Jefferson | Oregon | 41031 | 1230 | 12 |
838302 | 838302 | 2020-12-17 | Jefferson | Oregon | 41031 | 1204 | 12 |
835056 | 835056 | 2020-12-16 | Jefferson | Oregon | 41031 | 1195 | 12 |
831810 | 831810 | 2020-12-15 | Jefferson | Oregon | 41031 | 1166 | 12 |
828563 | 828563 | 2020-12-14 | Jefferson | Oregon | 41031 | 1151 | 12 |
825317 | 825317 | 2020-12-13 | Jefferson | Oregon | 41031 | 1147 | 12 |
822070 | 822070 | 2020-12-12 | Jefferson | Oregon | 41031 | 1130 | 12 |
818824 | 818824 | 2020-12-11 | Jefferson | Oregon | 41031 | 1107 | 12 |
815578 | 815578 | 2020-12-10 | Jefferson | Oregon | 41031 | 1086 | 11 |
812332 | 812332 | 2020-12-09 | Jefferson | Oregon | 41031 | 1035 | 11 |
809088 | 809088 | 2020-12-08 | Jefferson | Oregon | 41031 | 1014 | 11 |
805843 | 805843 | 2020-12-07 | Jefferson | Oregon | 41031 | 986 | 11 |
802598 | 802598 | 2020-12-06 | Jefferson | Oregon | 41031 | 942 | 11 |
799353 | 799353 | 2020-12-05 | Jefferson | Oregon | 41031 | 932 | 11 |
796108 | 796108 | 2020-12-04 | Jefferson | Oregon | 41031 | 912 | 11 |
792863 | 792863 | 2020-12-03 | Jefferson | Oregon | 41031 | 878 | 11 |
789618 | 789618 | 2020-12-02 | Jefferson | Oregon | 41031 | 874 | 11 |
786373 | 786373 | 2020-12-01 | Jefferson | Oregon | 41031 | 862 | 11 |
783129 | 783129 | 2020-11-30 | Jefferson | Oregon | 41031 | 843 | 11 |
779883 | 779883 | 2020-11-29 | Jefferson | Oregon | 41031 | 834 | 11 |
776638 | 776638 | 2020-11-28 | Jefferson | Oregon | 41031 | 814 | 11 |
773393 | 773393 | 2020-11-27 | Jefferson | Oregon | 41031 | 808 | 11 |
770148 | 770148 | 2020-11-26 | Jefferson | Oregon | 41031 | 804 | 11 |
766902 | 766902 | 2020-11-25 | Jefferson | Oregon | 41031 | 798 | 11 |
763657 | 763657 | 2020-11-24 | Jefferson | Oregon | 41031 | 786 | 11 |
760412 | 760412 | 2020-11-23 | Jefferson | Oregon | 41031 | 773 | 11 |
757167 | 757167 | 2020-11-22 | Jefferson | Oregon | 41031 | 765 | 11 |
753920 | 753920 | 2020-11-21 | Jefferson | Oregon | 41031 | 757 | 11 |
750674 | 750674 | 2020-11-20 | Jefferson | Oregon | 41031 | 749 | 11 |
747428 | 747428 | 2020-11-19 | Jefferson | Oregon | 41031 | 738 | 11 |
744182 | 744182 | 2020-11-18 | Jefferson | Oregon | 41031 | 728 | 11 |
740935 | 740935 | 2020-11-17 | Jefferson | Oregon | 41031 | 713 | 11 |
737689 | 737689 | 2020-11-16 | Jefferson | Oregon | 41031 | 686 | 11 |
734445 | 734445 | 2020-11-15 | Jefferson | Oregon | 41031 | 685 | 11 |
731199 | 731199 | 2020-11-14 | Jefferson | Oregon | 41031 | 685 | 11 |
727955 | 727955 | 2020-11-13 | Jefferson | Oregon | 41031 | 674 | 11 |
724711 | 724711 | 2020-11-12 | Jefferson | Oregon | 41031 | 660 | 11 |
721468 | 721468 | 2020-11-11 | Jefferson | Oregon | 41031 | 659 | 11 |
718225 | 718225 | 2020-11-10 | Jefferson | Oregon | 41031 | 645 | 11 |
714982 | 714982 | 2020-11-09 | Jefferson | Oregon | 41031 | 639 | 11 |
711738 | 711738 | 2020-11-08 | Jefferson | Oregon | 41031 | 634 | 11 |
708494 | 708494 | 2020-11-07 | Jefferson | Oregon | 41031 | 633 | 11 |
705251 | 705251 | 2020-11-06 | Jefferson | Oregon | 41031 | 629 | 11 |
702008 | 702008 | 2020-11-05 | Jefferson | Oregon | 41031 | 622 | 11 |
698764 | 698764 | 2020-11-04 | Jefferson | Oregon | 41031 | 618 | 11 |
695521 | 695521 | 2020-11-03 | Jefferson | Oregon | 41031 | 613 | 11 |
692279 | 692279 | 2020-11-02 | Jefferson | Oregon | 41031 | 612 | 10 |
689035 | 689035 | 2020-11-01 | Jefferson | Oregon | 41031 | 611 | 10 |
685790 | 685790 | 2020-10-31 | Jefferson | Oregon | 41031 | 611 | 10 |
682547 | 682547 | 2020-10-30 | Jefferson | Oregon | 41031 | 609 | 10 |
679304 | 679304 | 2020-10-29 | Jefferson | Oregon | 41031 | 607 | 10 |
676061 | 676061 | 2020-10-28 | Jefferson | Oregon | 41031 | 605 | 10 |
672818 | 672818 | 2020-10-27 | Jefferson | Oregon | 41031 | 605 | 9 |
669576 | 669576 | 2020-10-26 | Jefferson | Oregon | 41031 | 604 | 9 |
666332 | 666332 | 2020-10-25 | Jefferson | Oregon | 41031 | 604 | 9 |
663087 | 663087 | 2020-10-24 | Jefferson | Oregon | 41031 | 603 | 9 |
659843 | 659843 | 2020-10-23 | Jefferson | Oregon | 41031 | 600 | 9 |
656599 | 656599 | 2020-10-22 | Jefferson | Oregon | 41031 | 599 | 9 |
653354 | 653354 | 2020-10-21 | Jefferson | Oregon | 41031 | 597 | 9 |
650109 | 650109 | 2020-10-20 | Jefferson | Oregon | 41031 | 597 | 9 |
646865 | 646865 | 2020-10-19 | Jefferson | Oregon | 41031 | 593 | 9 |
643619 | 643619 | 2020-10-18 | Jefferson | Oregon | 41031 | 593 | 9 |
640371 | 640371 | 2020-10-17 | Jefferson | Oregon | 41031 | 593 | 9 |
637125 | 637125 | 2020-10-16 | Jefferson | Oregon | 41031 | 593 | 9 |
633879 | 633879 | 2020-10-15 | Jefferson | Oregon | 41031 | 590 | 8 |
630634 | 630634 | 2020-10-14 | Jefferson | Oregon | 41031 | 591 | 8 |
627390 | 627390 | 2020-10-13 | Jefferson | Oregon | 41031 | 590 | 8 |
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);