ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Jackson" and fips = 41029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055746 | 1055746 | 2021-02-22 | Jackson | Oregon | 41029 | 8160 | 108 |
1052500 | 1052500 | 2021-02-21 | Jackson | Oregon | 41029 | 8117 | 108 |
1049253 | 1049253 | 2021-02-20 | Jackson | Oregon | 41029 | 8115 | 108 |
1046006 | 1046006 | 2021-02-19 | Jackson | Oregon | 41029 | 8078 | 107 |
1042761 | 1042761 | 2021-02-18 | Jackson | Oregon | 41029 | 8027 | 107 |
1039516 | 1039516 | 2021-02-17 | Jackson | Oregon | 41029 | 8004 | 107 |
1036271 | 1036271 | 2021-02-16 | Jackson | Oregon | 41029 | 7953 | 106 |
1033026 | 1033026 | 2021-02-15 | Jackson | Oregon | 41029 | 7911 | 106 |
1029780 | 1029780 | 2021-02-14 | Jackson | Oregon | 41029 | 7904 | 106 |
1026533 | 1026533 | 2021-02-13 | Jackson | Oregon | 41029 | 7893 | 106 |
1023288 | 1023288 | 2021-02-12 | Jackson | Oregon | 41029 | 7861 | 106 |
1020043 | 1020043 | 2021-02-11 | Jackson | Oregon | 41029 | 7832 | 106 |
1016798 | 1016798 | 2021-02-10 | Jackson | Oregon | 41029 | 7788 | 105 |
1013553 | 1013553 | 2021-02-09 | Jackson | Oregon | 41029 | 7764 | 105 |
1010308 | 1010308 | 2021-02-08 | Jackson | Oregon | 41029 | 7742 | 105 |
1007062 | 1007062 | 2021-02-07 | Jackson | Oregon | 41029 | 7734 | 105 |
1003816 | 1003816 | 2021-02-06 | Jackson | Oregon | 41029 | 7712 | 105 |
1000570 | 1000570 | 2021-02-05 | Jackson | Oregon | 41029 | 7673 | 105 |
997324 | 997324 | 2021-02-04 | Jackson | Oregon | 41029 | 7641 | 105 |
994078 | 994078 | 2021-02-03 | Jackson | Oregon | 41029 | 7594 | 104 |
990832 | 990832 | 2021-02-02 | Jackson | Oregon | 41029 | 7553 | 103 |
987586 | 987586 | 2021-02-01 | Jackson | Oregon | 41029 | 7501 | 101 |
984339 | 984339 | 2021-01-31 | Jackson | Oregon | 41029 | 7456 | 100 |
981092 | 981092 | 2021-01-30 | Jackson | Oregon | 41029 | 7456 | 100 |
977846 | 977846 | 2021-01-29 | Jackson | Oregon | 41029 | 7416 | 98 |
974601 | 974601 | 2021-01-28 | Jackson | Oregon | 41029 | 7291 | 98 |
971356 | 971356 | 2021-01-27 | Jackson | Oregon | 41029 | 7267 | 98 |
968111 | 968111 | 2021-01-26 | Jackson | Oregon | 41029 | 7234 | 97 |
964867 | 964867 | 2021-01-25 | Jackson | Oregon | 41029 | 7189 | 96 |
961622 | 961622 | 2021-01-24 | Jackson | Oregon | 41029 | 7169 | 96 |
958377 | 958377 | 2021-01-23 | Jackson | Oregon | 41029 | 7122 | 95 |
955131 | 955131 | 2021-01-22 | Jackson | Oregon | 41029 | 7073 | 95 |
951886 | 951886 | 2021-01-21 | Jackson | Oregon | 41029 | 7043 | 90 |
948641 | 948641 | 2021-01-20 | Jackson | Oregon | 41029 | 7004 | 85 |
945395 | 945395 | 2021-01-19 | Jackson | Oregon | 41029 | 6970 | 85 |
942148 | 942148 | 2021-01-18 | Jackson | Oregon | 41029 | 6930 | 85 |
938903 | 938903 | 2021-01-17 | Jackson | Oregon | 41029 | 6892 | 85 |
935658 | 935658 | 2021-01-16 | Jackson | Oregon | 41029 | 6862 | 84 |
932413 | 932413 | 2021-01-15 | Jackson | Oregon | 41029 | 6806 | 82 |
929168 | 929168 | 2021-01-14 | Jackson | Oregon | 41029 | 6757 | 82 |
925923 | 925923 | 2021-01-13 | Jackson | Oregon | 41029 | 6682 | 82 |
922677 | 922677 | 2021-01-12 | Jackson | Oregon | 41029 | 6627 | 81 |
919432 | 919432 | 2021-01-11 | Jackson | Oregon | 41029 | 6563 | 80 |
916187 | 916187 | 2021-01-10 | Jackson | Oregon | 41029 | 6524 | 80 |
912942 | 912942 | 2021-01-09 | Jackson | Oregon | 41029 | 6486 | 80 |
909697 | 909697 | 2021-01-08 | Jackson | Oregon | 41029 | 6364 | 77 |
906452 | 906452 | 2021-01-07 | Jackson | Oregon | 41029 | 6281 | 75 |
903206 | 903206 | 2021-01-06 | Jackson | Oregon | 41029 | 6210 | 75 |
899961 | 899961 | 2021-01-05 | Jackson | Oregon | 41029 | 6173 | 74 |
896716 | 896716 | 2021-01-04 | Jackson | Oregon | 41029 | 6108 | 72 |
893470 | 893470 | 2021-01-03 | Jackson | Oregon | 41029 | 6069 | 72 |
890224 | 890224 | 2021-01-02 | Jackson | Oregon | 41029 | 5955 | 72 |
886977 | 886977 | 2021-01-01 | Jackson | Oregon | 41029 | 5933 | 72 |
883732 | 883732 | 2020-12-31 | Jackson | Oregon | 41029 | 5884 | 72 |
880487 | 880487 | 2020-12-30 | Jackson | Oregon | 41029 | 5780 | 71 |
877242 | 877242 | 2020-12-29 | Jackson | Oregon | 41029 | 5721 | 69 |
873997 | 873997 | 2020-12-28 | Jackson | Oregon | 41029 | 5616 | 66 |
870752 | 870752 | 2020-12-27 | Jackson | Oregon | 41029 | 5616 | 66 |
867507 | 867507 | 2020-12-26 | Jackson | Oregon | 41029 | 5551 | 64 |
864262 | 864262 | 2020-12-25 | Jackson | Oregon | 41029 | 5551 | 64 |
861017 | 861017 | 2020-12-24 | Jackson | Oregon | 41029 | 5487 | 64 |
857772 | 857772 | 2020-12-23 | Jackson | Oregon | 41029 | 5459 | 63 |
854527 | 854527 | 2020-12-22 | Jackson | Oregon | 41029 | 5411 | 62 |
851282 | 851282 | 2020-12-21 | Jackson | Oregon | 41029 | 5350 | 60 |
848037 | 848037 | 2020-12-20 | Jackson | Oregon | 41029 | 5309 | 58 |
844792 | 844792 | 2020-12-19 | Jackson | Oregon | 41029 | 5264 | 58 |
841546 | 841546 | 2020-12-18 | Jackson | Oregon | 41029 | 5191 | 55 |
838301 | 838301 | 2020-12-17 | Jackson | Oregon | 41029 | 5117 | 54 |
835055 | 835055 | 2020-12-16 | Jackson | Oregon | 41029 | 5039 | 53 |
831809 | 831809 | 2020-12-15 | Jackson | Oregon | 41029 | 4978 | 52 |
828562 | 828562 | 2020-12-14 | Jackson | Oregon | 41029 | 4897 | 50 |
825316 | 825316 | 2020-12-13 | Jackson | Oregon | 41029 | 4857 | 50 |
822069 | 822069 | 2020-12-12 | Jackson | Oregon | 41029 | 4769 | 49 |
818823 | 818823 | 2020-12-11 | Jackson | Oregon | 41029 | 4704 | 48 |
815577 | 815577 | 2020-12-10 | Jackson | Oregon | 41029 | 4624 | 45 |
812331 | 812331 | 2020-12-09 | Jackson | Oregon | 41029 | 4566 | 44 |
809087 | 809087 | 2020-12-08 | Jackson | Oregon | 41029 | 4514 | 44 |
805842 | 805842 | 2020-12-07 | Jackson | Oregon | 41029 | 4408 | 41 |
802597 | 802597 | 2020-12-06 | Jackson | Oregon | 41029 | 4388 | 41 |
799352 | 799352 | 2020-12-05 | Jackson | Oregon | 41029 | 4287 | 41 |
796107 | 796107 | 2020-12-04 | Jackson | Oregon | 41029 | 4201 | 41 |
792862 | 792862 | 2020-12-03 | Jackson | Oregon | 41029 | 4028 | 38 |
789617 | 789617 | 2020-12-02 | Jackson | Oregon | 41029 | 4017 | 37 |
786372 | 786372 | 2020-12-01 | Jackson | Oregon | 41029 | 3951 | 35 |
783128 | 783128 | 2020-11-30 | Jackson | Oregon | 41029 | 3879 | 31 |
779882 | 779882 | 2020-11-29 | Jackson | Oregon | 41029 | 3825 | 31 |
776637 | 776637 | 2020-11-28 | Jackson | Oregon | 41029 | 3768 | 30 |
773392 | 773392 | 2020-11-27 | Jackson | Oregon | 41029 | 3644 | 28 |
770147 | 770147 | 2020-11-26 | Jackson | Oregon | 41029 | 3643 | 28 |
766901 | 766901 | 2020-11-25 | Jackson | Oregon | 41029 | 3579 | 25 |
763656 | 763656 | 2020-11-24 | Jackson | Oregon | 41029 | 3490 | 24 |
760411 | 760411 | 2020-11-23 | Jackson | Oregon | 41029 | 3436 | 23 |
757166 | 757166 | 2020-11-22 | Jackson | Oregon | 41029 | 3356 | 23 |
753919 | 753919 | 2020-11-21 | Jackson | Oregon | 41029 | 3302 | 23 |
750673 | 750673 | 2020-11-20 | Jackson | Oregon | 41029 | 3240 | 19 |
747427 | 747427 | 2020-11-19 | Jackson | Oregon | 41029 | 3156 | 19 |
744181 | 744181 | 2020-11-18 | Jackson | Oregon | 41029 | 3067 | 11 |
740934 | 740934 | 2020-11-17 | Jackson | Oregon | 41029 | 2959 | 10 |
737688 | 737688 | 2020-11-16 | Jackson | Oregon | 41029 | 2900 | 10 |
734444 | 734444 | 2020-11-15 | Jackson | Oregon | 41029 | 2842 | 10 |
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);