ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

321 rows where fips = 41067 sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

  • 41067 · 321 ✖

county

Link rowid date ▲ county state fips cases deaths
926022 926022 2021-01-13 Washington Oregon 41067 18086 164
922776 922776 2021-01-12 Washington Oregon 41067 17975 160
919531 919531 2021-01-11 Washington Oregon 41067 17819 160
916286 916286 2021-01-10 Washington Oregon 41067 17506 155
913041 913041 2021-01-09 Washington Oregon 41067 17326 155
909796 909796 2021-01-08 Washington Oregon 41067 17156 155
906551 906551 2021-01-07 Washington Oregon 41067 16902 152
903305 903305 2021-01-06 Washington Oregon 41067 16868 152
900060 900060 2021-01-05 Washington Oregon 41067 16838 147
896815 896815 2021-01-04 Washington Oregon 41067 16735 147
893569 893569 2021-01-03 Washington Oregon 41067 16595 143
890323 890323 2021-01-02 Washington Oregon 41067 16381 143
887076 887076 2021-01-01 Washington Oregon 41067 16290 143
883831 883831 2020-12-31 Washington Oregon 41067 16070 142
880586 880586 2020-12-30 Washington Oregon 41067 15888 142
877341 877341 2020-12-29 Washington Oregon 41067 15785 140
874096 874096 2020-12-28 Washington Oregon 41067 15728 140
870851 870851 2020-12-27 Washington Oregon 41067 15433 140
867606 867606 2020-12-26 Washington Oregon 41067 15158 140
864361 864361 2020-12-25 Washington Oregon 41067 15158 140
861116 861116 2020-12-24 Washington Oregon 41067 15072 139
857871 857871 2020-12-23 Washington Oregon 41067 14997 139
854626 854626 2020-12-22 Washington Oregon 41067 14878 138
851381 851381 2020-12-21 Washington Oregon 41067 14726 135
848136 848136 2020-12-20 Washington Oregon 41067 14616 134
844891 844891 2020-12-19 Washington Oregon 41067 14362 134
841645 841645 2020-12-18 Washington Oregon 41067 14217 131
838400 838400 2020-12-17 Washington Oregon 41067 13991 129
835154 835154 2020-12-16 Washington Oregon 41067 13776 128
831908 831908 2020-12-15 Washington Oregon 41067 13636 120
828661 828661 2020-12-14 Washington Oregon 41067 13588 119
825415 825415 2020-12-13 Washington Oregon 41067 13324 116
822168 822168 2020-12-12 Washington Oregon 41067 13226 116
818922 818922 2020-12-11 Washington Oregon 41067 12983 116
815676 815676 2020-12-10 Washington Oregon 41067 12767 114
812430 812430 2020-12-09 Washington Oregon 41067 12534 114
809186 809186 2020-12-08 Washington Oregon 41067 12375 111
805941 805941 2020-12-07 Washington Oregon 41067 12209 109
802696 802696 2020-12-06 Washington Oregon 41067 11982 108
799450 799450 2020-12-05 Washington Oregon 41067 11801 108
796204 796204 2020-12-04 Washington Oregon 41067 11493 107
792959 792959 2020-12-03 Washington Oregon 41067 11175 104
789713 789713 2020-12-02 Washington Oregon 41067 10958 104
786467 786467 2020-12-01 Washington Oregon 41067 10714 103
783223 783223 2020-11-30 Washington Oregon 41067 10556 102
779978 779978 2020-11-29 Washington Oregon 41067 10347 101
776732 776732 2020-11-28 Washington Oregon 41067 10135 99
773486 773486 2020-11-27 Washington Oregon 41067 9974 99
770241 770241 2020-11-26 Washington Oregon 41067 9678 99
766994 766994 2020-11-25 Washington Oregon 41067 9401 98
763748 763748 2020-11-24 Washington Oregon 41067 9222 98
760502 760502 2020-11-23 Washington Oregon 41067 9038 96
757256 757256 2020-11-22 Washington Oregon 41067 8815 96
754009 754009 2020-11-21 Washington Oregon 41067 8687 96
750762 750762 2020-11-20 Washington Oregon 41067 8466 95
747515 747515 2020-11-19 Washington Oregon 41067 8313 95
744268 744268 2020-11-18 Washington Oregon 41067 8191 94
741021 741021 2020-11-17 Washington Oregon 41067 8020 92
737775 737775 2020-11-16 Washington Oregon 41067 7937 91
734530 734530 2020-11-15 Washington Oregon 41067 7825 89
731284 731284 2020-11-14 Washington Oregon 41067 7714 89
728040 728040 2020-11-13 Washington Oregon 41067 7523 89
724795 724795 2020-11-12 Washington Oregon 41067 7376 89
721551 721551 2020-11-11 Washington Oregon 41067 7207 89
718307 718307 2020-11-10 Washington Oregon 41067 7108 89
715063 715063 2020-11-09 Washington Oregon 41067 7014 88
711819 711819 2020-11-08 Washington Oregon 41067 6897 88
708575 708575 2020-11-07 Washington Oregon 41067 6795 87
705332 705332 2020-11-06 Washington Oregon 41067 6663 83
702089 702089 2020-11-05 Washington Oregon 41067 6543 82
698844 698844 2020-11-04 Washington Oregon 41067 6412 82
695600 695600 2020-11-03 Washington Oregon 41067 6356 80
692357 692357 2020-11-02 Washington Oregon 41067 6298 79
689113 689113 2020-11-01 Washington Oregon 41067 6230 79
685868 685868 2020-10-31 Washington Oregon 41067 6170 78
682624 682624 2020-10-30 Washington Oregon 41067 6082 78
679380 679380 2020-10-29 Washington Oregon 41067 5991 78
676137 676137 2020-10-28 Washington Oregon 41067 5885 78
672893 672893 2020-10-27 Washington Oregon 41067 5838 77
669651 669651 2020-10-26 Washington Oregon 41067 5790 76
666407 666407 2020-10-25 Washington Oregon 41067 5739 75
663161 663161 2020-10-24 Washington Oregon 41067 5681 75
659916 659916 2020-10-23 Washington Oregon 41067 5612 74
656672 656672 2020-10-22 Washington Oregon 41067 5524 74
653427 653427 2020-10-21 Washington Oregon 41067 5470 73
650182 650182 2020-10-20 Washington Oregon 41067 5429 72
646938 646938 2020-10-19 Washington Oregon 41067 5385 70
643692 643692 2020-10-18 Washington Oregon 41067 5365 70
640444 640444 2020-10-17 Washington Oregon 41067 5345 70
637198 637198 2020-10-16 Washington Oregon 41067 5298 70
633952 633952 2020-10-15 Washington Oregon 41067 5241 68
630707 630707 2020-10-14 Washington Oregon 41067 5196 68
627463 627463 2020-10-13 Washington Oregon 41067 5146 67
624221 624221 2020-10-12 Washington Oregon 41067 5100 67
620978 620978 2020-10-11 Washington Oregon 41067 5066 67
617736 617736 2020-10-10 Washington Oregon 41067 5004 67
614494 614494 2020-10-09 Washington Oregon 41067 4957 67
611253 611253 2020-10-08 Washington Oregon 41067 4921 65
608011 608011 2020-10-07 Washington Oregon 41067 4863 63
604768 604768 2020-10-06 Washington Oregon 41067 4840 62

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);