ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where deaths = 70 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488780 | 2488780 | 2022-05-09 | Benton | Oregon | 41003 | 16078 | 70 |
2485523 | 2485523 | 2022-05-08 | Benton | Oregon | 41003 | 15993 | 70 |
2482265 | 2482265 | 2022-05-07 | Benton | Oregon | 41003 | 15993 | 70 |
2479007 | 2479007 | 2022-05-06 | Benton | Oregon | 41003 | 15993 | 70 |
2475749 | 2475749 | 2022-05-05 | Benton | Oregon | 41003 | 15978 | 70 |
2472492 | 2472492 | 2022-05-04 | Benton | Oregon | 41003 | 15931 | 70 |
2469236 | 2469236 | 2022-05-03 | Benton | Oregon | 41003 | 15902 | 70 |
2465980 | 2465980 | 2022-05-02 | Benton | Oregon | 41003 | 15863 | 70 |
2462725 | 2462725 | 2022-05-01 | Benton | Oregon | 41003 | 15795 | 70 |
2459469 | 2459469 | 2022-04-30 | Benton | Oregon | 41003 | 15795 | 70 |
2456213 | 2456213 | 2022-04-29 | Benton | Oregon | 41003 | 15795 | 70 |
2452957 | 2452957 | 2022-04-28 | Benton | Oregon | 41003 | 15750 | 70 |
2449701 | 2449701 | 2022-04-27 | Benton | Oregon | 41003 | 15711 | 70 |
2446444 | 2446444 | 2022-04-26 | Benton | Oregon | 41003 | 15654 | 70 |
2443189 | 2443189 | 2022-04-25 | Benton | Oregon | 41003 | 15601 | 70 |
2257744 | 2257744 | 2022-02-27 | Lincoln | Oregon | 41041 | 6877 | 70 |
2254493 | 2254493 | 2022-02-26 | Lincoln | Oregon | 41041 | 6877 | 70 |
2251242 | 2251242 | 2022-02-25 | Lincoln | Oregon | 41041 | 6877 | 70 |
2247991 | 2247991 | 2022-02-24 | Lincoln | Oregon | 41041 | 6860 | 70 |
2202481 | 2202481 | 2022-02-10 | Union | Oregon | 41061 | 4860 | 70 |
2199227 | 2199227 | 2022-02-09 | Union | Oregon | 41061 | 4840 | 70 |
2195973 | 2195973 | 2022-02-08 | Union | Oregon | 41061 | 4825 | 70 |
2192719 | 2192719 | 2022-02-07 | Union | Oregon | 41061 | 4791 | 70 |
2189465 | 2189465 | 2022-02-06 | Union | Oregon | 41061 | 4769 | 70 |
2186212 | 2186212 | 2022-02-05 | Union | Oregon | 41061 | 4769 | 70 |
2182960 | 2182960 | 2022-02-04 | Union | Oregon | 41061 | 4769 | 70 |
2179682 | 2179682 | 2022-02-03 | Columbia | Oregon | 41009 | 6849 | 70 |
2134140 | 2134140 | 2022-01-20 | Jefferson | Oregon | 41031 | 5666 | 70 |
2130888 | 2130888 | 2022-01-19 | Jefferson | Oregon | 41031 | 5540 | 70 |
2127634 | 2127634 | 2022-01-18 | Jefferson | Oregon | 41031 | 5492 | 70 |
2124382 | 2124382 | 2022-01-17 | Jefferson | Oregon | 41031 | 5253 | 70 |
2121130 | 2121130 | 2022-01-16 | Jefferson | Oregon | 41031 | 5253 | 70 |
2117878 | 2117878 | 2022-01-15 | Jefferson | Oregon | 41031 | 5253 | 70 |
2114627 | 2114627 | 2022-01-14 | Jefferson | Oregon | 41031 | 5253 | 70 |
2111375 | 2111375 | 2022-01-13 | Jefferson | Oregon | 41031 | 5154 | 70 |
2108123 | 2108123 | 2022-01-12 | Jefferson | Oregon | 41031 | 5041 | 70 |
1783126 | 1783126 | 2021-10-04 | Malheur | Oregon | 41045 | 5184 | 70 |
1779877 | 1779877 | 2021-10-03 | Malheur | Oregon | 41045 | 5150 | 70 |
1776627 | 1776627 | 2021-10-02 | Malheur | Oregon | 41045 | 5150 | 70 |
1773377 | 1773377 | 2021-10-01 | Malheur | Oregon | 41045 | 5150 | 70 |
1770127 | 1770127 | 2021-09-30 | Malheur | Oregon | 41045 | 5124 | 70 |
1766878 | 1766878 | 2021-09-29 | Malheur | Oregon | 41045 | 5077 | 70 |
1737643 | 1737643 | 2021-09-20 | Polk | Oregon | 41053 | 6235 | 70 |
1734393 | 1734393 | 2021-09-19 | Polk | Oregon | 41053 | 6177 | 70 |
1731143 | 1731143 | 2021-09-18 | Polk | Oregon | 41053 | 6177 | 70 |
1727893 | 1727893 | 2021-09-17 | Polk | Oregon | 41053 | 6177 | 70 |
1351215 | 1351215 | 2021-05-24 | Klamath | Oregon | 41035 | 4609 | 70 |
1347969 | 1347969 | 2021-05-23 | Klamath | Oregon | 41035 | 4609 | 70 |
1344721 | 1344721 | 2021-05-22 | Klamath | Oregon | 41035 | 4602 | 70 |
1338229 | 1338229 | 2021-05-20 | Linn | Oregon | 41043 | 5136 | 70 |
1334982 | 1334982 | 2021-05-19 | Linn | Oregon | 41043 | 5090 | 70 |
1318745 | 1318745 | 2021-05-14 | Josephine | Oregon | 41033 | 3355 | 70 |
1315497 | 1315497 | 2021-05-13 | Josephine | Oregon | 41033 | 3345 | 70 |
1312244 | 1312244 | 2021-05-12 | Douglas | Oregon | 41019 | 3259 | 70 |
1308997 | 1308997 | 2021-05-11 | Douglas | Oregon | 41019 | 3244 | 70 |
1305751 | 1305751 | 2021-05-10 | Douglas | Oregon | 41019 | 3231 | 70 |
1302505 | 1302505 | 2021-05-09 | Douglas | Oregon | 41019 | 3225 | 70 |
1299257 | 1299257 | 2021-05-08 | Douglas | Oregon | 41019 | 3220 | 70 |
1296011 | 1296011 | 2021-05-07 | Douglas | Oregon | 41019 | 3217 | 70 |
1292765 | 1292765 | 2021-05-06 | Douglas | Oregon | 41019 | 3205 | 70 |
1289519 | 1289519 | 2021-05-05 | Douglas | Oregon | 41019 | 3192 | 70 |
1286273 | 1286273 | 2021-05-04 | Douglas | Oregon | 41019 | 3180 | 70 |
1283027 | 1283027 | 2021-05-03 | Douglas | Oregon | 41019 | 3173 | 70 |
1192096 | 1192096 | 2021-04-05 | Deschutes | Oregon | 41017 | 6470 | 70 |
1192123 | 1192123 | 2021-04-05 | Yamhill | Oregon | 41071 | 3991 | 70 |
1188847 | 1188847 | 2021-04-04 | Deschutes | Oregon | 41017 | 6456 | 70 |
1188874 | 1188874 | 2021-04-04 | Yamhill | Oregon | 41071 | 3974 | 70 |
1185600 | 1185600 | 2021-04-03 | Deschutes | Oregon | 41017 | 6426 | 70 |
1185627 | 1185627 | 2021-04-03 | Yamhill | Oregon | 41071 | 3968 | 70 |
1182353 | 1182353 | 2021-04-02 | Deschutes | Oregon | 41017 | 6396 | 70 |
1182380 | 1182380 | 2021-04-02 | Yamhill | Oregon | 41071 | 3956 | 70 |
1179106 | 1179106 | 2021-04-01 | Deschutes | Oregon | 41017 | 6370 | 70 |
1179133 | 1179133 | 2021-04-01 | Yamhill | Oregon | 41071 | 3943 | 70 |
1175859 | 1175859 | 2021-03-31 | Deschutes | Oregon | 41017 | 6341 | 70 |
1175886 | 1175886 | 2021-03-31 | Yamhill | Oregon | 41071 | 3935 | 70 |
1172612 | 1172612 | 2021-03-30 | Deschutes | Oregon | 41017 | 6327 | 70 |
1172639 | 1172639 | 2021-03-30 | Yamhill | Oregon | 41071 | 3930 | 70 |
1169365 | 1169365 | 2021-03-29 | Deschutes | Oregon | 41017 | 6316 | 70 |
1169392 | 1169392 | 2021-03-29 | Yamhill | Oregon | 41071 | 3928 | 70 |
1166117 | 1166117 | 2021-03-28 | Deschutes | Oregon | 41017 | 6302 | 70 |
1166144 | 1166144 | 2021-03-28 | Yamhill | Oregon | 41071 | 3917 | 70 |
1162869 | 1162869 | 2021-03-27 | Deschutes | Oregon | 41017 | 6293 | 70 |
1162896 | 1162896 | 2021-03-27 | Yamhill | Oregon | 41071 | 3907 | 70 |
1159620 | 1159620 | 2021-03-26 | Deschutes | Oregon | 41017 | 6269 | 70 |
1159647 | 1159647 | 2021-03-26 | Yamhill | Oregon | 41071 | 3905 | 70 |
1156373 | 1156373 | 2021-03-25 | Deschutes | Oregon | 41017 | 6244 | 70 |
1156400 | 1156400 | 2021-03-25 | Yamhill | Oregon | 41071 | 3895 | 70 |
1153126 | 1153126 | 2021-03-24 | Deschutes | Oregon | 41017 | 6223 | 70 |
1153153 | 1153153 | 2021-03-24 | Yamhill | Oregon | 41071 | 3889 | 70 |
1149879 | 1149879 | 2021-03-23 | Deschutes | Oregon | 41017 | 6201 | 70 |
1149906 | 1149906 | 2021-03-23 | Yamhill | Oregon | 41071 | 3884 | 70 |
1146632 | 1146632 | 2021-03-22 | Deschutes | Oregon | 41017 | 6178 | 70 |
1146659 | 1146659 | 2021-03-22 | Yamhill | Oregon | 41071 | 3878 | 70 |
1143385 | 1143385 | 2021-03-21 | Deschutes | Oregon | 41017 | 6173 | 70 |
1143412 | 1143412 | 2021-03-21 | Yamhill | Oregon | 41071 | 3872 | 70 |
1140138 | 1140138 | 2021-03-20 | Deschutes | Oregon | 41017 | 6163 | 70 |
1140165 | 1140165 | 2021-03-20 | Yamhill | Oregon | 41071 | 3872 | 70 |
1136892 | 1136892 | 2021-03-19 | Deschutes | Oregon | 41017 | 6161 | 70 |
1133646 | 1133646 | 2021-03-18 | Deschutes | Oregon | 41017 | 6147 | 70 |
1130398 | 1130398 | 2021-03-17 | Deschutes | Oregon | 41017 | 6136 | 70 |
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);