ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where deaths = 6, fips = 41025 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1247313 | 1247313 | 2021-04-22 | Harney | Oregon | 41025 | 315 | 6 |
1244066 | 1244066 | 2021-04-21 | Harney | Oregon | 41025 | 315 | 6 |
1240819 | 1240819 | 2021-04-20 | Harney | Oregon | 41025 | 313 | 6 |
1237572 | 1237572 | 2021-04-19 | Harney | Oregon | 41025 | 306 | 6 |
1234325 | 1234325 | 2021-04-18 | Harney | Oregon | 41025 | 306 | 6 |
1231077 | 1231077 | 2021-04-17 | Harney | Oregon | 41025 | 305 | 6 |
1227829 | 1227829 | 2021-04-16 | Harney | Oregon | 41025 | 304 | 6 |
1224581 | 1224581 | 2021-04-15 | Harney | Oregon | 41025 | 304 | 6 |
1221334 | 1221334 | 2021-04-14 | Harney | Oregon | 41025 | 304 | 6 |
1218086 | 1218086 | 2021-04-13 | Harney | Oregon | 41025 | 303 | 6 |
1214838 | 1214838 | 2021-04-12 | Harney | Oregon | 41025 | 300 | 6 |
1211591 | 1211591 | 2021-04-11 | Harney | Oregon | 41025 | 300 | 6 |
1208342 | 1208342 | 2021-04-10 | Harney | Oregon | 41025 | 300 | 6 |
1205094 | 1205094 | 2021-04-09 | Harney | Oregon | 41025 | 299 | 6 |
1201846 | 1201846 | 2021-04-08 | Harney | Oregon | 41025 | 298 | 6 |
1198597 | 1198597 | 2021-04-07 | Harney | Oregon | 41025 | 298 | 6 |
1195348 | 1195348 | 2021-04-06 | Harney | Oregon | 41025 | 297 | 6 |
1192100 | 1192100 | 2021-04-05 | Harney | Oregon | 41025 | 294 | 6 |
1188851 | 1188851 | 2021-04-04 | Harney | Oregon | 41025 | 294 | 6 |
1185604 | 1185604 | 2021-04-03 | Harney | Oregon | 41025 | 294 | 6 |
1182357 | 1182357 | 2021-04-02 | Harney | Oregon | 41025 | 294 | 6 |
1179110 | 1179110 | 2021-04-01 | Harney | Oregon | 41025 | 289 | 6 |
1175863 | 1175863 | 2021-03-31 | Harney | Oregon | 41025 | 289 | 6 |
1172616 | 1172616 | 2021-03-30 | Harney | Oregon | 41025 | 288 | 6 |
1169369 | 1169369 | 2021-03-29 | Harney | Oregon | 41025 | 287 | 6 |
1166121 | 1166121 | 2021-03-28 | Harney | Oregon | 41025 | 285 | 6 |
1162873 | 1162873 | 2021-03-27 | Harney | Oregon | 41025 | 285 | 6 |
1159624 | 1159624 | 2021-03-26 | Harney | Oregon | 41025 | 285 | 6 |
1156377 | 1156377 | 2021-03-25 | Harney | Oregon | 41025 | 283 | 6 |
1153130 | 1153130 | 2021-03-24 | Harney | Oregon | 41025 | 283 | 6 |
1149883 | 1149883 | 2021-03-23 | Harney | Oregon | 41025 | 283 | 6 |
1146636 | 1146636 | 2021-03-22 | Harney | Oregon | 41025 | 283 | 6 |
1143389 | 1143389 | 2021-03-21 | Harney | Oregon | 41025 | 283 | 6 |
1140142 | 1140142 | 2021-03-20 | Harney | Oregon | 41025 | 283 | 6 |
1136896 | 1136896 | 2021-03-19 | Harney | Oregon | 41025 | 283 | 6 |
1133650 | 1133650 | 2021-03-18 | Harney | Oregon | 41025 | 282 | 6 |
1130402 | 1130402 | 2021-03-17 | Harney | Oregon | 41025 | 282 | 6 |
1127155 | 1127155 | 2021-03-16 | Harney | Oregon | 41025 | 280 | 6 |
1123909 | 1123909 | 2021-03-15 | Harney | Oregon | 41025 | 279 | 6 |
1120663 | 1120663 | 2021-03-14 | Harney | Oregon | 41025 | 278 | 6 |
1117416 | 1117416 | 2021-03-13 | Harney | Oregon | 41025 | 278 | 6 |
1114169 | 1114169 | 2021-03-12 | Harney | Oregon | 41025 | 278 | 6 |
1110923 | 1110923 | 2021-03-11 | Harney | Oregon | 41025 | 278 | 6 |
1107677 | 1107677 | 2021-03-10 | Harney | Oregon | 41025 | 278 | 6 |
1104431 | 1104431 | 2021-03-09 | Harney | Oregon | 41025 | 278 | 6 |
1101185 | 1101185 | 2021-03-08 | Harney | Oregon | 41025 | 278 | 6 |
1097939 | 1097939 | 2021-03-07 | Harney | Oregon | 41025 | 278 | 6 |
1094691 | 1094691 | 2021-03-06 | Harney | Oregon | 41025 | 278 | 6 |
1091445 | 1091445 | 2021-03-05 | Harney | Oregon | 41025 | 277 | 6 |
1088199 | 1088199 | 2021-03-04 | Harney | Oregon | 41025 | 277 | 6 |
1084954 | 1084954 | 2021-03-03 | Harney | Oregon | 41025 | 277 | 6 |
1081708 | 1081708 | 2021-03-02 | Harney | Oregon | 41025 | 275 | 6 |
1078462 | 1078462 | 2021-03-01 | Harney | Oregon | 41025 | 273 | 6 |
1075217 | 1075217 | 2021-02-28 | Harney | Oregon | 41025 | 273 | 6 |
1071971 | 1071971 | 2021-02-27 | Harney | Oregon | 41025 | 273 | 6 |
1068725 | 1068725 | 2021-02-26 | Harney | Oregon | 41025 | 273 | 6 |
1065480 | 1065480 | 2021-02-25 | Harney | Oregon | 41025 | 272 | 6 |
1062235 | 1062235 | 2021-02-24 | Harney | Oregon | 41025 | 271 | 6 |
1058990 | 1058990 | 2021-02-23 | Harney | Oregon | 41025 | 272 | 6 |
1055744 | 1055744 | 2021-02-22 | Harney | Oregon | 41025 | 268 | 6 |
1052498 | 1052498 | 2021-02-21 | Harney | Oregon | 41025 | 266 | 6 |
1049251 | 1049251 | 2021-02-20 | Harney | Oregon | 41025 | 266 | 6 |
1046004 | 1046004 | 2021-02-19 | Harney | Oregon | 41025 | 266 | 6 |
1042759 | 1042759 | 2021-02-18 | Harney | Oregon | 41025 | 263 | 6 |
1039514 | 1039514 | 2021-02-17 | Harney | Oregon | 41025 | 262 | 6 |
1036269 | 1036269 | 2021-02-16 | Harney | Oregon | 41025 | 253 | 6 |
1033024 | 1033024 | 2021-02-15 | Harney | Oregon | 41025 | 252 | 6 |
1029778 | 1029778 | 2021-02-14 | Harney | Oregon | 41025 | 248 | 6 |
1026531 | 1026531 | 2021-02-13 | Harney | Oregon | 41025 | 243 | 6 |
1023286 | 1023286 | 2021-02-12 | Harney | Oregon | 41025 | 243 | 6 |
1020041 | 1020041 | 2021-02-11 | Harney | Oregon | 41025 | 240 | 6 |
1016796 | 1016796 | 2021-02-10 | Harney | Oregon | 41025 | 235 | 6 |
1013551 | 1013551 | 2021-02-09 | Harney | Oregon | 41025 | 235 | 6 |
1010306 | 1010306 | 2021-02-08 | Harney | Oregon | 41025 | 217 | 6 |
1007060 | 1007060 | 2021-02-07 | Harney | Oregon | 41025 | 217 | 6 |
1003814 | 1003814 | 2021-02-06 | Harney | Oregon | 41025 | 215 | 6 |
1000568 | 1000568 | 2021-02-05 | Harney | Oregon | 41025 | 214 | 6 |
997322 | 997322 | 2021-02-04 | Harney | Oregon | 41025 | 206 | 6 |
994076 | 994076 | 2021-02-03 | Harney | Oregon | 41025 | 202 | 6 |
990830 | 990830 | 2021-02-02 | Harney | Oregon | 41025 | 198 | 6 |
987584 | 987584 | 2021-02-01 | Harney | Oregon | 41025 | 195 | 6 |
984337 | 984337 | 2021-01-31 | Harney | Oregon | 41025 | 195 | 6 |
981090 | 981090 | 2021-01-30 | Harney | Oregon | 41025 | 195 | 6 |
977844 | 977844 | 2021-01-29 | Harney | Oregon | 41025 | 195 | 6 |
974599 | 974599 | 2021-01-28 | Harney | Oregon | 41025 | 193 | 6 |
971354 | 971354 | 2021-01-27 | Harney | Oregon | 41025 | 191 | 6 |
968109 | 968109 | 2021-01-26 | Harney | Oregon | 41025 | 190 | 6 |
964865 | 964865 | 2021-01-25 | Harney | Oregon | 41025 | 182 | 6 |
961620 | 961620 | 2021-01-24 | Harney | Oregon | 41025 | 181 | 6 |
958375 | 958375 | 2021-01-23 | Harney | Oregon | 41025 | 180 | 6 |
955129 | 955129 | 2021-01-22 | Harney | Oregon | 41025 | 179 | 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);