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 |
---|---|---|---|---|---|---|---|
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 |
731198 | 731198 | 2020-11-14 | Jackson | Oregon | 41029 | 2805 | 10 |
727954 | 727954 | 2020-11-13 | Jackson | Oregon | 41029 | 2694 | 10 |
724710 | 724710 | 2020-11-12 | Jackson | Oregon | 41029 | 2605 | 8 |
721467 | 721467 | 2020-11-11 | Jackson | Oregon | 41029 | 2484 | 8 |
718224 | 718224 | 2020-11-10 | Jackson | Oregon | 41029 | 2435 | 8 |
714981 | 714981 | 2020-11-09 | Jackson | Oregon | 41029 | 2380 | 8 |
711737 | 711737 | 2020-11-08 | Jackson | Oregon | 41029 | 2339 | 8 |
708493 | 708493 | 2020-11-07 | Jackson | Oregon | 41029 | 2274 | 8 |
705250 | 705250 | 2020-11-06 | Jackson | Oregon | 41029 | 2197 | 8 |
702007 | 702007 | 2020-11-05 | Jackson | Oregon | 41029 | 2114 | 8 |
698763 | 698763 | 2020-11-04 | Jackson | Oregon | 41029 | 2049 | 8 |
695520 | 695520 | 2020-11-03 | Jackson | Oregon | 41029 | 1998 | 7 |
692278 | 692278 | 2020-11-02 | Jackson | Oregon | 41029 | 1928 | 7 |
689034 | 689034 | 2020-11-01 | Jackson | Oregon | 41029 | 1911 | 7 |
685789 | 685789 | 2020-10-31 | Jackson | Oregon | 41029 | 1876 | 7 |
682546 | 682546 | 2020-10-30 | Jackson | Oregon | 41029 | 1865 | 7 |
679303 | 679303 | 2020-10-29 | Jackson | Oregon | 41029 | 1796 | 7 |
676060 | 676060 | 2020-10-28 | Jackson | Oregon | 41029 | 1742 | 7 |
672817 | 672817 | 2020-10-27 | Jackson | Oregon | 41029 | 1707 | 6 |
669575 | 669575 | 2020-10-26 | Jackson | Oregon | 41029 | 1684 | 6 |
666331 | 666331 | 2020-10-25 | Jackson | Oregon | 41029 | 1669 | 6 |
663086 | 663086 | 2020-10-24 | Jackson | Oregon | 41029 | 1650 | 6 |
659842 | 659842 | 2020-10-23 | Jackson | Oregon | 41029 | 1617 | 6 |
656598 | 656598 | 2020-10-22 | Jackson | Oregon | 41029 | 1584 | 6 |
653353 | 653353 | 2020-10-21 | Jackson | Oregon | 41029 | 1555 | 6 |
650108 | 650108 | 2020-10-20 | Jackson | Oregon | 41029 | 1519 | 6 |
646864 | 646864 | 2020-10-19 | Jackson | Oregon | 41029 | 1510 | 6 |
643618 | 643618 | 2020-10-18 | Jackson | Oregon | 41029 | 1492 | 6 |
640370 | 640370 | 2020-10-17 | Jackson | Oregon | 41029 | 1471 | 6 |
637124 | 637124 | 2020-10-16 | Jackson | Oregon | 41029 | 1448 | 6 |
633878 | 633878 | 2020-10-15 | Jackson | Oregon | 41029 | 1430 | 6 |
630633 | 630633 | 2020-10-14 | Jackson | Oregon | 41029 | 1413 | 6 |
627389 | 627389 | 2020-10-13 | Jackson | Oregon | 41029 | 1385 | 6 |
624147 | 624147 | 2020-10-12 | Jackson | Oregon | 41029 | 1372 | 6 |
620904 | 620904 | 2020-10-11 | Jackson | Oregon | 41029 | 1364 | 6 |
617662 | 617662 | 2020-10-10 | Jackson | Oregon | 41029 | 1357 | 6 |
614420 | 614420 | 2020-10-09 | Jackson | Oregon | 41029 | 1335 | 6 |
611179 | 611179 | 2020-10-08 | Jackson | Oregon | 41029 | 1311 | 6 |
607937 | 607937 | 2020-10-07 | Jackson | Oregon | 41029 | 1295 | 6 |
604694 | 604694 | 2020-10-06 | Jackson | Oregon | 41029 | 1275 | 6 |
601452 | 601452 | 2020-10-05 | Jackson | Oregon | 41029 | 1267 | 6 |
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);