ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
144 rows where deaths = 82 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 |
---|---|---|---|---|---|---|---|
2384604 | 2384604 | 2022-04-07 | Lincoln | Oregon | 41041 | 7013 | 82 |
2381349 | 2381349 | 2022-04-06 | Lincoln | Oregon | 41041 | 7009 | 82 |
2378094 | 2378094 | 2022-04-05 | Lincoln | Oregon | 41041 | 7006 | 82 |
2374840 | 2374840 | 2022-04-04 | Lincoln | Oregon | 41041 | 7006 | 82 |
2270745 | 2270745 | 2022-03-03 | Jefferson | Oregon | 41031 | 7154 | 82 |
2267493 | 2267493 | 2022-03-02 | Jefferson | Oregon | 41031 | 7148 | 82 |
2264240 | 2264240 | 2022-03-01 | Jefferson | Oregon | 41031 | 7146 | 82 |
1896848 | 1896848 | 2021-11-08 | Malheur | Oregon | 41045 | 5821 | 82 |
1893598 | 1893598 | 2021-11-07 | Malheur | Oregon | 41045 | 5814 | 82 |
1890348 | 1890348 | 2021-11-06 | Malheur | Oregon | 41045 | 5814 | 82 |
1887098 | 1887098 | 2021-11-05 | Malheur | Oregon | 41045 | 5814 | 82 |
1883848 | 1883848 | 2021-11-04 | Malheur | Oregon | 41045 | 5803 | 82 |
1880599 | 1880599 | 2021-11-03 | Malheur | Oregon | 41045 | 5797 | 82 |
1877354 | 1877354 | 2021-11-02 | Polk | Oregon | 41053 | 7648 | 82 |
1874105 | 1874105 | 2021-11-01 | Polk | Oregon | 41053 | 7601 | 82 |
1870856 | 1870856 | 2021-10-31 | Polk | Oregon | 41053 | 7561 | 82 |
1867607 | 1867607 | 2021-10-30 | Polk | Oregon | 41053 | 7561 | 82 |
1864358 | 1864358 | 2021-10-29 | Polk | Oregon | 41053 | 7561 | 82 |
1792855 | 1792855 | 2021-10-07 | Coos | Oregon | 41011 | 4718 | 82 |
1789606 | 1789606 | 2021-10-06 | Coos | Oregon | 41011 | 4684 | 82 |
1786358 | 1786358 | 2021-10-05 | Coos | Oregon | 41011 | 4652 | 82 |
1672660 | 1672660 | 2021-08-31 | Klamath | Oregon | 41035 | 5722 | 82 |
1669412 | 1669412 | 2021-08-30 | Klamath | Oregon | 41035 | 5635 | 82 |
1666169 | 1666169 | 2021-08-29 | Linn | Oregon | 41043 | 8020 | 82 |
1662921 | 1662921 | 2021-08-28 | Linn | Oregon | 41043 | 8020 | 82 |
1659673 | 1659673 | 2021-08-27 | Linn | Oregon | 41043 | 8020 | 82 |
1656424 | 1656424 | 2021-08-26 | Linn | Oregon | 41043 | 7871 | 82 |
1653177 | 1653177 | 2021-08-25 | Linn | Oregon | 41043 | 7767 | 82 |
1649930 | 1649930 | 2021-08-24 | Linn | Oregon | 41043 | 7680 | 82 |
1646681 | 1646681 | 2021-08-23 | Linn | Oregon | 41043 | 7571 | 82 |
1643432 | 1643432 | 2021-08-22 | Linn | Oregon | 41043 | 7393 | 82 |
1640182 | 1640182 | 2021-08-21 | Linn | Oregon | 41043 | 7393 | 82 |
1636932 | 1636932 | 2021-08-20 | Linn | Oregon | 41043 | 7393 | 82 |
1633682 | 1633682 | 2021-08-19 | Linn | Oregon | 41043 | 7288 | 82 |
1630435 | 1630435 | 2021-08-18 | Linn | Oregon | 41043 | 7215 | 82 |
1627188 | 1627188 | 2021-08-17 | Linn | Oregon | 41043 | 7147 | 82 |
1623936 | 1623936 | 2021-08-16 | Josephine | Oregon | 41033 | 5556 | 82 |
1623941 | 1623941 | 2021-08-16 | Linn | Oregon | 41043 | 7036 | 82 |
1620689 | 1620689 | 2021-08-15 | Josephine | Oregon | 41033 | 5195 | 82 |
1620694 | 1620694 | 2021-08-15 | Linn | Oregon | 41043 | 6858 | 82 |
1617441 | 1617441 | 2021-08-14 | Josephine | Oregon | 41033 | 5195 | 82 |
1617446 | 1617446 | 2021-08-14 | Linn | Oregon | 41043 | 6858 | 82 |
1614193 | 1614193 | 2021-08-13 | Josephine | Oregon | 41033 | 5195 | 82 |
1614198 | 1614198 | 2021-08-13 | Linn | Oregon | 41043 | 6858 | 82 |
1610944 | 1610944 | 2021-08-12 | Josephine | Oregon | 41033 | 5120 | 82 |
1610949 | 1610949 | 2021-08-12 | Linn | Oregon | 41043 | 6787 | 82 |
1607701 | 1607701 | 2021-08-11 | Linn | Oregon | 41043 | 6757 | 82 |
1604452 | 1604452 | 2021-08-10 | Linn | Oregon | 41043 | 6720 | 82 |
1601203 | 1601203 | 2021-08-09 | Linn | Oregon | 41043 | 6645 | 82 |
1597955 | 1597955 | 2021-08-08 | Linn | Oregon | 41043 | 6493 | 82 |
1597969 | 1597969 | 2021-08-08 | Yamhill | Oregon | 41071 | 5215 | 82 |
1594706 | 1594706 | 2021-08-07 | Linn | Oregon | 41043 | 6493 | 82 |
1594720 | 1594720 | 2021-08-07 | Yamhill | Oregon | 41071 | 5215 | 82 |
1591457 | 1591457 | 2021-08-06 | Linn | Oregon | 41043 | 6493 | 82 |
1591471 | 1591471 | 2021-08-06 | Yamhill | Oregon | 41071 | 5215 | 82 |
1588208 | 1588208 | 2021-08-05 | Linn | Oregon | 41043 | 6485 | 82 |
1588222 | 1588222 | 2021-08-05 | Yamhill | Oregon | 41071 | 5185 | 82 |
1584958 | 1584958 | 2021-08-04 | Linn | Oregon | 41043 | 6448 | 82 |
1584972 | 1584972 | 2021-08-04 | Yamhill | Oregon | 41071 | 5158 | 82 |
1581708 | 1581708 | 2021-08-03 | Linn | Oregon | 41043 | 6421 | 82 |
1581722 | 1581722 | 2021-08-03 | Yamhill | Oregon | 41071 | 5135 | 82 |
1578459 | 1578459 | 2021-08-02 | Linn | Oregon | 41043 | 6377 | 82 |
1575211 | 1575211 | 2021-08-01 | Linn | Oregon | 41043 | 6277 | 82 |
1571963 | 1571963 | 2021-07-31 | Linn | Oregon | 41043 | 6277 | 82 |
1568715 | 1568715 | 2021-07-30 | Linn | Oregon | 41043 | 6277 | 82 |
1565467 | 1565467 | 2021-07-29 | Linn | Oregon | 41043 | 6248 | 82 |
1516743 | 1516743 | 2021-07-14 | Deschutes | Oregon | 41017 | 10219 | 82 |
1513496 | 1513496 | 2021-07-13 | Deschutes | Oregon | 41017 | 10208 | 82 |
1510250 | 1510250 | 2021-07-12 | Deschutes | Oregon | 41017 | 10203 | 82 |
1507003 | 1507003 | 2021-07-11 | Deschutes | Oregon | 41017 | 10182 | 82 |
1503757 | 1503757 | 2021-07-10 | Deschutes | Oregon | 41017 | 10182 | 82 |
1500511 | 1500511 | 2021-07-09 | Deschutes | Oregon | 41017 | 10182 | 82 |
1497265 | 1497265 | 2021-07-08 | Deschutes | Oregon | 41017 | 10167 | 82 |
1494018 | 1494018 | 2021-07-07 | Deschutes | Oregon | 41017 | 10157 | 82 |
1490771 | 1490771 | 2021-07-06 | Deschutes | Oregon | 41017 | 10148 | 82 |
1487524 | 1487524 | 2021-07-05 | Deschutes | Oregon | 41017 | 10125 | 82 |
1484277 | 1484277 | 2021-07-04 | Deschutes | Oregon | 41017 | 10125 | 82 |
1481031 | 1481031 | 2021-07-03 | Deschutes | Oregon | 41017 | 10125 | 82 |
1477784 | 1477784 | 2021-07-02 | Deschutes | Oregon | 41017 | 10125 | 82 |
1474538 | 1474538 | 2021-07-01 | Deschutes | Oregon | 41017 | 10112 | 82 |
1471292 | 1471292 | 2021-06-30 | Deschutes | Oregon | 41017 | 10100 | 82 |
1468047 | 1468047 | 2021-06-29 | Deschutes | Oregon | 41017 | 10095 | 82 |
1464802 | 1464802 | 2021-06-28 | Deschutes | Oregon | 41017 | 10088 | 82 |
1461557 | 1461557 | 2021-06-27 | Deschutes | Oregon | 41017 | 10083 | 82 |
1458312 | 1458312 | 2021-06-26 | Deschutes | Oregon | 41017 | 10075 | 82 |
1455067 | 1455067 | 2021-06-25 | Deschutes | Oregon | 41017 | 10067 | 82 |
1451822 | 1451822 | 2021-06-24 | Deschutes | Oregon | 41017 | 10055 | 82 |
1448576 | 1448576 | 2021-06-23 | Deschutes | Oregon | 41017 | 10041 | 82 |
1445331 | 1445331 | 2021-06-22 | Deschutes | Oregon | 41017 | 10027 | 82 |
1442086 | 1442086 | 2021-06-21 | Deschutes | Oregon | 41017 | 10018 | 82 |
1438841 | 1438841 | 2021-06-20 | Deschutes | Oregon | 41017 | 10015 | 82 |
1438842 | 1438842 | 2021-06-20 | Douglas | Oregon | 41019 | 3879 | 82 |
1435594 | 1435594 | 2021-06-19 | Deschutes | Oregon | 41017 | 10002 | 82 |
1435595 | 1435595 | 2021-06-19 | Douglas | Oregon | 41019 | 3873 | 82 |
1432347 | 1432347 | 2021-06-18 | Deschutes | Oregon | 41017 | 9986 | 82 |
1192117 | 1192117 | 2021-04-05 | Umatilla | Oregon | 41059 | 7884 | 82 |
1188868 | 1188868 | 2021-04-04 | Umatilla | Oregon | 41059 | 7884 | 82 |
1185621 | 1185621 | 2021-04-03 | Umatilla | Oregon | 41059 | 7884 | 82 |
1182374 | 1182374 | 2021-04-02 | Umatilla | Oregon | 41059 | 7878 | 82 |
1179127 | 1179127 | 2021-04-01 | Umatilla | Oregon | 41059 | 7871 | 82 |
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);