ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
806 rows where fips = 41067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195369 | 1195369 | 2021-04-06 | Washington | Oregon | 41067 | 22625 | 228 |
1192121 | 1192121 | 2021-04-05 | Washington | Oregon | 41067 | 22526 | 226 |
1188872 | 1188872 | 2021-04-04 | Washington | Oregon | 41067 | 22526 | 225 |
1185625 | 1185625 | 2021-04-03 | Washington | Oregon | 41067 | 22482 | 225 |
1182378 | 1182378 | 2021-04-02 | Washington | Oregon | 41067 | 22431 | 225 |
1179131 | 1179131 | 2021-04-01 | Washington | Oregon | 41067 | 22382 | 223 |
1175884 | 1175884 | 2021-03-31 | Washington | Oregon | 41067 | 22334 | 223 |
1172637 | 1172637 | 2021-03-30 | Washington | Oregon | 41067 | 22288 | 223 |
1169390 | 1169390 | 2021-03-29 | Washington | Oregon | 41067 | 22214 | 223 |
1166142 | 1166142 | 2021-03-28 | Washington | Oregon | 41067 | 22214 | 221 |
1162894 | 1162894 | 2021-03-27 | Washington | Oregon | 41067 | 22179 | 221 |
1159645 | 1159645 | 2021-03-26 | Washington | Oregon | 41067 | 22115 | 221 |
1156398 | 1156398 | 2021-03-25 | Washington | Oregon | 41067 | 22055 | 221 |
1153151 | 1153151 | 2021-03-24 | Washington | Oregon | 41067 | 22002 | 221 |
1149904 | 1149904 | 2021-03-23 | Washington | Oregon | 41067 | 21974 | 221 |
1146657 | 1146657 | 2021-03-22 | Washington | Oregon | 41067 | 21918 | 221 |
1143410 | 1143410 | 2021-03-21 | Washington | Oregon | 41067 | 21914 | 221 |
1140163 | 1140163 | 2021-03-20 | Washington | Oregon | 41067 | 21884 | 221 |
1136917 | 1136917 | 2021-03-19 | Washington | Oregon | 41067 | 21850 | 221 |
1133671 | 1133671 | 2021-03-18 | Washington | Oregon | 41067 | 21811 | 221 |
1130423 | 1130423 | 2021-03-17 | Washington | Oregon | 41067 | 21786 | 221 |
1127176 | 1127176 | 2021-03-16 | Washington | Oregon | 41067 | 21759 | 220 |
1123930 | 1123930 | 2021-03-15 | Washington | Oregon | 41067 | 21742 | 219 |
1120684 | 1120684 | 2021-03-14 | Washington | Oregon | 41067 | 21709 | 219 |
1117437 | 1117437 | 2021-03-13 | Washington | Oregon | 41067 | 21670 | 219 |
1114190 | 1114190 | 2021-03-12 | Washington | Oregon | 41067 | 21625 | 219 |
1110944 | 1110944 | 2021-03-11 | Washington | Oregon | 41067 | 21580 | 219 |
1107698 | 1107698 | 2021-03-10 | Washington | Oregon | 41067 | 21546 | 219 |
1104452 | 1104452 | 2021-03-09 | Washington | Oregon | 41067 | 21507 | 218 |
1101206 | 1101206 | 2021-03-08 | Washington | Oregon | 41067 | 21460 | 218 |
1097960 | 1097960 | 2021-03-07 | Washington | Oregon | 41067 | 21400 | 218 |
1094712 | 1094712 | 2021-03-06 | Washington | Oregon | 41067 | 21377 | 218 |
1091466 | 1091466 | 2021-03-05 | Washington | Oregon | 41067 | 21364 | 218 |
1088220 | 1088220 | 2021-03-04 | Washington | Oregon | 41067 | 21345 | 216 |
1084975 | 1084975 | 2021-03-03 | Washington | Oregon | 41067 | 21314 | 213 |
1081729 | 1081729 | 2021-03-02 | Washington | Oregon | 41067 | 21287 | 213 |
1078483 | 1078483 | 2021-03-01 | Washington | Oregon | 41067 | 21268 | 213 |
1075238 | 1075238 | 2021-02-28 | Washington | Oregon | 41067 | 21211 | 213 |
1071992 | 1071992 | 2021-02-27 | Washington | Oregon | 41067 | 21170 | 213 |
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 |
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);