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

365 rows where fips = 41067 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

  • 41067 · 365 ✖

county

Link rowid date ▲ county state fips cases deaths
1068746 1068746 2021-02-26 Washington Oregon 41067 21099 213
1065501 1065501 2021-02-25 Washington Oregon 41067 21060 213
1062256 1062256 2021-02-24 Washington Oregon 41067 21001 212
1059011 1059011 2021-02-23 Washington Oregon 41067 20962 209
1055765 1055765 2021-02-22 Washington Oregon 41067 20898 209
1052519 1052519 2021-02-21 Washington Oregon 41067 20867 209
1049272 1049272 2021-02-20 Washington Oregon 41067 20866 209
1046025 1046025 2021-02-19 Washington Oregon 41067 20804 208
1042780 1042780 2021-02-18 Washington Oregon 41067 20751 208
1039535 1039535 2021-02-17 Washington Oregon 41067 20698 208
1036290 1036290 2021-02-16 Washington Oregon 41067 20678 207
1033045 1033045 2021-02-15 Washington Oregon 41067 20657 207
1029799 1029799 2021-02-14 Washington Oregon 41067 20628 207
1026552 1026552 2021-02-13 Washington Oregon 41067 20599 207
1023307 1023307 2021-02-12 Washington Oregon 41067 20547 206
1020062 1020062 2021-02-11 Washington Oregon 41067 20497 200
1016817 1016817 2021-02-10 Washington Oregon 41067 20441 198
1013572 1013572 2021-02-09 Washington Oregon 41067 20390 197
1010327 1010327 2021-02-08 Washington Oregon 41067 20349 197
1007081 1007081 2021-02-07 Washington Oregon 41067 20301 194
1003835 1003835 2021-02-06 Washington Oregon 41067 20254 194
1000589 1000589 2021-02-05 Washington Oregon 41067 20199 194
997343 997343 2021-02-04 Washington Oregon 41067 20106 194
994097 994097 2021-02-03 Washington Oregon 41067 20023 194
990851 990851 2021-02-02 Washington Oregon 41067 19961 194
987605 987605 2021-02-01 Washington Oregon 41067 19895 195
984358 984358 2021-01-31 Washington Oregon 41067 19769 191
981111 981111 2021-01-30 Washington Oregon 41067 19769 191
977865 977865 2021-01-29 Washington Oregon 41067 19687 188
974620 974620 2021-01-28 Washington Oregon 41067 19550 185
971375 971375 2021-01-27 Washington Oregon 41067 19476 185
968130 968130 2021-01-26 Washington Oregon 41067 19370 183
964886 964886 2021-01-25 Washington Oregon 41067 19330 180
961641 961641 2021-01-24 Washington Oregon 41067 19279 179
958396 958396 2021-01-23 Washington Oregon 41067 19216 179
955150 955150 2021-01-22 Washington Oregon 41067 19113 178
951905 951905 2021-01-21 Washington Oregon 41067 18973 176
948660 948660 2021-01-20 Washington Oregon 41067 18867 175
945414 945414 2021-01-19 Washington Oregon 41067 18808 173
942167 942167 2021-01-18 Washington Oregon 41067 18734 171
938922 938922 2021-01-17 Washington Oregon 41067 18644 171
935677 935677 2021-01-16 Washington Oregon 41067 18512 171
932432 932432 2021-01-15 Washington Oregon 41067 18386 166
929187 929187 2021-01-14 Washington Oregon 41067 18245 166
925942 925942 2021-01-13 Washington Oregon 41067 18086 164
922696 922696 2021-01-12 Washington Oregon 41067 17975 160
919451 919451 2021-01-11 Washington Oregon 41067 17819 160
916206 916206 2021-01-10 Washington Oregon 41067 17506 155
912961 912961 2021-01-09 Washington Oregon 41067 17326 155
909716 909716 2021-01-08 Washington Oregon 41067 17156 155
906471 906471 2021-01-07 Washington Oregon 41067 16902 152
903225 903225 2021-01-06 Washington Oregon 41067 16868 152
899980 899980 2021-01-05 Washington Oregon 41067 16838 147
896735 896735 2021-01-04 Washington Oregon 41067 16735 147
893489 893489 2021-01-03 Washington Oregon 41067 16595 143
890243 890243 2021-01-02 Washington Oregon 41067 16381 143
886996 886996 2021-01-01 Washington Oregon 41067 16290 143
883751 883751 2020-12-31 Washington Oregon 41067 16070 142
880506 880506 2020-12-30 Washington Oregon 41067 15888 142
877261 877261 2020-12-29 Washington Oregon 41067 15785 140
874016 874016 2020-12-28 Washington Oregon 41067 15728 140
870771 870771 2020-12-27 Washington Oregon 41067 15433 140
867526 867526 2020-12-26 Washington Oregon 41067 15158 140
864281 864281 2020-12-25 Washington Oregon 41067 15158 140
861036 861036 2020-12-24 Washington Oregon 41067 15072 139
857791 857791 2020-12-23 Washington Oregon 41067 14997 139
854546 854546 2020-12-22 Washington Oregon 41067 14878 138
851301 851301 2020-12-21 Washington Oregon 41067 14726 135
848056 848056 2020-12-20 Washington Oregon 41067 14616 134
844811 844811 2020-12-19 Washington Oregon 41067 14362 134
841565 841565 2020-12-18 Washington Oregon 41067 14217 131
838320 838320 2020-12-17 Washington Oregon 41067 13991 129
835074 835074 2020-12-16 Washington Oregon 41067 13776 128
831828 831828 2020-12-15 Washington Oregon 41067 13636 120
828581 828581 2020-12-14 Washington Oregon 41067 13588 119
825335 825335 2020-12-13 Washington Oregon 41067 13324 116
822088 822088 2020-12-12 Washington Oregon 41067 13226 116
818842 818842 2020-12-11 Washington Oregon 41067 12983 116
815596 815596 2020-12-10 Washington Oregon 41067 12767 114
812350 812350 2020-12-09 Washington Oregon 41067 12534 114
809106 809106 2020-12-08 Washington Oregon 41067 12375 111
805861 805861 2020-12-07 Washington Oregon 41067 12209 109
802616 802616 2020-12-06 Washington Oregon 41067 11982 108
799371 799371 2020-12-05 Washington Oregon 41067 11801 108
796126 796126 2020-12-04 Washington Oregon 41067 11493 107
792881 792881 2020-12-03 Washington Oregon 41067 11175 104
789636 789636 2020-12-02 Washington Oregon 41067 10958 104
786391 786391 2020-12-01 Washington Oregon 41067 10714 103
783147 783147 2020-11-30 Washington Oregon 41067 10556 102
779902 779902 2020-11-29 Washington Oregon 41067 10347 101
776656 776656 2020-11-28 Washington Oregon 41067 10135 99
773411 773411 2020-11-27 Washington Oregon 41067 9974 99
770166 770166 2020-11-26 Washington Oregon 41067 9678 99
766920 766920 2020-11-25 Washington Oregon 41067 9401 98
763675 763675 2020-11-24 Washington Oregon 41067 9222 98
760430 760430 2020-11-23 Washington Oregon 41067 9038 96
757185 757185 2020-11-22 Washington Oregon 41067 8815 96
753938 753938 2020-11-21 Washington Oregon 41067 8687 96
750692 750692 2020-11-20 Washington Oregon 41067 8466 95
747446 747446 2020-11-19 Washington Oregon 41067 8313 95

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);