ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where deaths = 84 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 |
---|---|---|---|---|---|---|---|
2420415 | 2420415 | 2022-04-18 | Lincoln | Oregon | 41041 | 7038 | 84 |
2417160 | 2417160 | 2022-04-17 | Lincoln | Oregon | 41041 | 7038 | 84 |
2413904 | 2413904 | 2022-04-16 | Lincoln | Oregon | 41041 | 7038 | 84 |
2410648 | 2410648 | 2022-04-15 | Lincoln | Oregon | 41041 | 7038 | 84 |
2407392 | 2407392 | 2022-04-14 | Lincoln | Oregon | 41041 | 7034 | 84 |
2404136 | 2404136 | 2022-04-13 | Lincoln | Oregon | 41041 | 7032 | 84 |
2400881 | 2400881 | 2022-04-12 | Lincoln | Oregon | 41041 | 7027 | 84 |
2293512 | 2293512 | 2022-03-10 | Jefferson | Oregon | 41031 | 7177 | 84 |
2290260 | 2290260 | 2022-03-09 | Jefferson | Oregon | 41031 | 7167 | 84 |
2287008 | 2287008 | 2022-03-08 | Jefferson | Oregon | 41031 | 7166 | 84 |
2283756 | 2283756 | 2022-03-07 | Jefferson | Oregon | 41031 | 7161 | 84 |
2280504 | 2280504 | 2022-03-06 | Jefferson | Oregon | 41031 | 7159 | 84 |
2277251 | 2277251 | 2022-03-05 | Jefferson | Oregon | 41031 | 7159 | 84 |
2273998 | 2273998 | 2022-03-04 | Jefferson | Oregon | 41031 | 7159 | 84 |
1939096 | 1939096 | 2021-11-21 | Malheur | Oregon | 41045 | 5900 | 84 |
1935846 | 1935846 | 2021-11-20 | Malheur | Oregon | 41045 | 5900 | 84 |
1932596 | 1932596 | 2021-11-19 | Malheur | Oregon | 41045 | 5900 | 84 |
1929345 | 1929345 | 2021-11-18 | Malheur | Oregon | 41045 | 5894 | 84 |
1926095 | 1926095 | 2021-11-17 | Malheur | Oregon | 41045 | 5883 | 84 |
1922845 | 1922845 | 2021-11-16 | Malheur | Oregon | 41045 | 5877 | 84 |
1919596 | 1919596 | 2021-11-15 | Malheur | Oregon | 41045 | 5863 | 84 |
1916346 | 1916346 | 2021-11-14 | Malheur | Oregon | 41045 | 5844 | 84 |
1913096 | 1913096 | 2021-11-13 | Malheur | Oregon | 41045 | 5844 | 84 |
1909846 | 1909846 | 2021-11-12 | Malheur | Oregon | 41045 | 5844 | 84 |
1880603 | 1880603 | 2021-11-03 | Polk | Oregon | 41053 | 7685 | 84 |
1698655 | 1698655 | 2021-09-08 | Linn | Oregon | 41043 | 9266 | 84 |
1679155 | 1679155 | 2021-09-02 | Klamath | Oregon | 41035 | 5805 | 84 |
1675907 | 1675907 | 2021-09-01 | Klamath | Oregon | 41035 | 5767 | 84 |
1630430 | 1630430 | 2021-08-18 | Josephine | Oregon | 41033 | 5806 | 84 |
1627202 | 1627202 | 2021-08-17 | Yamhill | Oregon | 41071 | 5660 | 84 |
1623955 | 1623955 | 2021-08-16 | Yamhill | Oregon | 41071 | 5571 | 84 |
1620708 | 1620708 | 2021-08-15 | Yamhill | Oregon | 41071 | 5468 | 84 |
1617460 | 1617460 | 2021-08-14 | Yamhill | Oregon | 41071 | 5468 | 84 |
1614212 | 1614212 | 2021-08-13 | Yamhill | Oregon | 41071 | 5468 | 84 |
1610963 | 1610963 | 2021-08-12 | Yamhill | Oregon | 41071 | 5432 | 84 |
1607715 | 1607715 | 2021-08-11 | Yamhill | Oregon | 41071 | 5385 | 84 |
1604466 | 1604466 | 2021-08-10 | Yamhill | Oregon | 41071 | 5337 | 84 |
1601217 | 1601217 | 2021-08-09 | Yamhill | Oregon | 41071 | 5258 | 84 |
1497266 | 1497266 | 2021-07-08 | Douglas | Oregon | 41019 | 4030 | 84 |
1494019 | 1494019 | 2021-07-07 | Douglas | Oregon | 41019 | 4025 | 84 |
1490772 | 1490772 | 2021-07-06 | Douglas | Oregon | 41019 | 4018 | 84 |
1331743 | 1331743 | 2021-05-18 | Umatilla | Oregon | 41059 | 8262 | 84 |
1328496 | 1328496 | 2021-05-17 | Umatilla | Oregon | 41059 | 8236 | 84 |
1325250 | 1325250 | 2021-05-16 | Umatilla | Oregon | 41059 | 8236 | 84 |
1322004 | 1322004 | 2021-05-15 | Umatilla | Oregon | 41059 | 8236 | 84 |
1318758 | 1318758 | 2021-05-14 | Umatilla | Oregon | 41059 | 8219 | 84 |
1315510 | 1315510 | 2021-05-13 | Umatilla | Oregon | 41059 | 8202 | 84 |
1312264 | 1312264 | 2021-05-12 | Umatilla | Oregon | 41059 | 8185 | 84 |
1309017 | 1309017 | 2021-05-11 | Umatilla | Oregon | 41059 | 8166 | 84 |
1305771 | 1305771 | 2021-05-10 | Umatilla | Oregon | 41059 | 8140 | 84 |
1302525 | 1302525 | 2021-05-09 | Umatilla | Oregon | 41059 | 8140 | 84 |
1299277 | 1299277 | 2021-05-08 | Umatilla | Oregon | 41059 | 8140 | 84 |
1296031 | 1296031 | 2021-05-07 | Umatilla | Oregon | 41059 | 8131 | 84 |
1292785 | 1292785 | 2021-05-06 | Umatilla | Oregon | 41059 | 8121 | 84 |
1289539 | 1289539 | 2021-05-05 | Umatilla | Oregon | 41059 | 8112 | 84 |
1286293 | 1286293 | 2021-05-04 | Umatilla | Oregon | 41059 | 8104 | 84 |
1283047 | 1283047 | 2021-05-03 | Umatilla | Oregon | 41059 | 8089 | 84 |
1279800 | 1279800 | 2021-05-02 | Umatilla | Oregon | 41059 | 8089 | 84 |
1276553 | 1276553 | 2021-05-01 | Umatilla | Oregon | 41059 | 8089 | 84 |
1273306 | 1273306 | 2021-04-30 | Umatilla | Oregon | 41059 | 8080 | 84 |
1270059 | 1270059 | 2021-04-29 | Umatilla | Oregon | 41059 | 8071 | 84 |
1266812 | 1266812 | 2021-04-28 | Umatilla | Oregon | 41059 | 8061 | 84 |
1263565 | 1263565 | 2021-04-27 | Umatilla | Oregon | 41059 | 8044 | 84 |
1260318 | 1260318 | 2021-04-26 | Umatilla | Oregon | 41059 | 8029 | 84 |
1257071 | 1257071 | 2021-04-25 | Umatilla | Oregon | 41059 | 8029 | 84 |
1253824 | 1253824 | 2021-04-24 | Umatilla | Oregon | 41059 | 8029 | 84 |
1250577 | 1250577 | 2021-04-23 | Umatilla | Oregon | 41059 | 8021 | 84 |
935658 | 935658 | 2021-01-16 | Jackson | Oregon | 41029 | 6862 | 84 |
861022 | 861022 | 2020-12-24 | Lane | Oregon | 41039 | 6470 | 84 |
857777 | 857777 | 2020-12-23 | Lane | Oregon | 41039 | 6404 | 84 |
796095 | 796095 | 2020-12-04 | Clackamas | Oregon | 41005 | 7012 | 84 |
792850 | 792850 | 2020-12-03 | Clackamas | Oregon | 41005 | 6841 | 84 |
789605 | 789605 | 2020-12-02 | Clackamas | Oregon | 41005 | 6730 | 84 |
378515 | 378515 | 2020-07-28 | Multnomah | Oregon | 41051 | 4115 | 84 |
372086 | 372086 | 2020-07-26 | Multnomah | Oregon | 41051 | 3926 | 84 |
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);