ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where deaths = 78 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2443218 | 2443218 | 2022-04-25 | Union | Oregon | 41061 | 5027 | 78 |
2439962 | 2439962 | 2022-04-24 | Union | Oregon | 41061 | 5027 | 78 |
2436706 | 2436706 | 2022-04-23 | Union | Oregon | 41061 | 5027 | 78 |
2433450 | 2433450 | 2022-04-22 | Union | Oregon | 41061 | 5027 | 78 |
2430194 | 2430194 | 2022-04-21 | Union | Oregon | 41061 | 5027 | 78 |
2426938 | 2426938 | 2022-04-20 | Union | Oregon | 41061 | 5027 | 78 |
2423682 | 2423682 | 2022-04-19 | Union | Oregon | 41061 | 5025 | 78 |
2420425 | 2420425 | 2022-04-18 | Union | Oregon | 41061 | 5024 | 78 |
2417170 | 2417170 | 2022-04-17 | Union | Oregon | 41061 | 5024 | 78 |
2413914 | 2413914 | 2022-04-16 | Union | Oregon | 41061 | 5024 | 78 |
2410658 | 2410658 | 2022-04-15 | Union | Oregon | 41061 | 5024 | 78 |
2348800 | 2348800 | 2022-03-27 | Columbia | Oregon | 41009 | 7537 | 78 |
2345547 | 2345547 | 2022-03-26 | Columbia | Oregon | 41009 | 7537 | 78 |
2342294 | 2342294 | 2022-03-25 | Columbia | Oregon | 41009 | 7537 | 78 |
2339041 | 2339041 | 2022-03-24 | Columbia | Oregon | 41009 | 7536 | 78 |
2335787 | 2335787 | 2022-03-23 | Columbia | Oregon | 41009 | 7536 | 78 |
2332533 | 2332533 | 2022-03-22 | Columbia | Oregon | 41009 | 7534 | 78 |
2329280 | 2329280 | 2022-03-21 | Columbia | Oregon | 41009 | 7532 | 78 |
2326028 | 2326028 | 2022-03-20 | Columbia | Oregon | 41009 | 7526 | 78 |
2322775 | 2322775 | 2022-03-19 | Columbia | Oregon | 41009 | 7526 | 78 |
2319521 | 2319521 | 2022-03-18 | Columbia | Oregon | 41009 | 7526 | 78 |
2316267 | 2316267 | 2022-03-17 | Columbia | Oregon | 41009 | 7521 | 78 |
2309777 | 2309777 | 2022-03-15 | Lincoln | Oregon | 41041 | 6976 | 78 |
2306524 | 2306524 | 2022-03-14 | Lincoln | Oregon | 41041 | 6972 | 78 |
2303273 | 2303273 | 2022-03-13 | Lincoln | Oregon | 41041 | 6969 | 78 |
2300021 | 2300021 | 2022-03-12 | Lincoln | Oregon | 41041 | 6969 | 78 |
2296769 | 2296769 | 2022-03-11 | Lincoln | Oregon | 41041 | 6969 | 78 |
2293517 | 2293517 | 2022-03-10 | Lincoln | Oregon | 41041 | 6959 | 78 |
2241484 | 2241484 | 2022-02-22 | Jefferson | Oregon | 41031 | 7092 | 78 |
2238233 | 2238233 | 2022-02-21 | Jefferson | Oregon | 41031 | 7085 | 78 |
2234982 | 2234982 | 2022-02-20 | Jefferson | Oregon | 41031 | 7085 | 78 |
2231731 | 2231731 | 2022-02-19 | Jefferson | Oregon | 41031 | 7085 | 78 |
2228480 | 2228480 | 2022-02-18 | Jefferson | Oregon | 41031 | 7085 | 78 |
2225229 | 2225229 | 2022-02-17 | Jefferson | Oregon | 41031 | 7083 | 78 |
2221978 | 2221978 | 2022-02-16 | Jefferson | Oregon | 41031 | 7049 | 78 |
2218727 | 2218727 | 2022-02-15 | Jefferson | Oregon | 41031 | 7038 | 78 |
1854607 | 1854607 | 2021-10-26 | Malheur | Oregon | 41045 | 5685 | 78 |
1851358 | 1851358 | 2021-10-25 | Malheur | Oregon | 41045 | 5652 | 78 |
1494027 | 1494027 | 2021-07-07 | Klamath | Oregon | 41035 | 4823 | 78 |
1490780 | 1490780 | 2021-07-06 | Klamath | Oregon | 41035 | 4812 | 78 |
1487533 | 1487533 | 2021-07-05 | Klamath | Oregon | 41035 | 4811 | 78 |
1484286 | 1484286 | 2021-07-04 | Klamath | Oregon | 41035 | 4811 | 78 |
1481040 | 1481040 | 2021-07-03 | Klamath | Oregon | 41035 | 4811 | 78 |
1477793 | 1477793 | 2021-07-02 | Klamath | Oregon | 41035 | 4811 | 78 |
1474547 | 1474547 | 2021-07-01 | Klamath | Oregon | 41035 | 4804 | 78 |
1471301 | 1471301 | 2021-06-30 | Klamath | Oregon | 41035 | 4799 | 78 |
1468056 | 1468056 | 2021-06-29 | Klamath | Oregon | 41035 | 4794 | 78 |
1464811 | 1464811 | 2021-06-28 | Klamath | Oregon | 41035 | 4788 | 78 |
1461566 | 1461566 | 2021-06-27 | Klamath | Oregon | 41035 | 4788 | 78 |
1458321 | 1458321 | 2021-06-26 | Klamath | Oregon | 41035 | 4788 | 78 |
1455076 | 1455076 | 2021-06-25 | Klamath | Oregon | 41035 | 4787 | 78 |
1451831 | 1451831 | 2021-06-24 | Klamath | Oregon | 41035 | 4782 | 78 |
1448585 | 1448585 | 2021-06-23 | Klamath | Oregon | 41035 | 4778 | 78 |
1445340 | 1445340 | 2021-06-22 | Klamath | Oregon | 41035 | 4778 | 78 |
1442095 | 1442095 | 2021-06-21 | Klamath | Oregon | 41035 | 4776 | 78 |
1438850 | 1438850 | 2021-06-20 | Klamath | Oregon | 41035 | 4776 | 78 |
1435603 | 1435603 | 2021-06-19 | Klamath | Oregon | 41035 | 4775 | 78 |
1432356 | 1432356 | 2021-06-18 | Klamath | Oregon | 41035 | 4774 | 78 |
1429110 | 1429110 | 2021-06-17 | Klamath | Oregon | 41035 | 4768 | 78 |
1425865 | 1425865 | 2021-06-16 | Klamath | Oregon | 41035 | 4763 | 78 |
1422618 | 1422618 | 2021-06-15 | Klamath | Oregon | 41035 | 4760 | 78 |
1403149 | 1403149 | 2021-06-09 | Linn | Oregon | 41043 | 5463 | 78 |
1403163 | 1403163 | 2021-06-09 | Yamhill | Oregon | 41071 | 4729 | 78 |
1399918 | 1399918 | 2021-06-08 | Yamhill | Oregon | 41071 | 4720 | 78 |
1396647 | 1396647 | 2021-06-07 | Douglas | Oregon | 41019 | 3682 | 78 |
1396673 | 1396673 | 2021-06-07 | Yamhill | Oregon | 41071 | 4717 | 78 |
1393400 | 1393400 | 2021-06-06 | Douglas | Oregon | 41019 | 3677 | 78 |
1393426 | 1393426 | 2021-06-06 | Yamhill | Oregon | 41071 | 4707 | 78 |
1390155 | 1390155 | 2021-06-05 | Douglas | Oregon | 41019 | 3666 | 78 |
1390181 | 1390181 | 2021-06-05 | Yamhill | Oregon | 41071 | 4695 | 78 |
1386910 | 1386910 | 2021-06-04 | Douglas | Oregon | 41019 | 3648 | 78 |
1386936 | 1386936 | 2021-06-04 | Yamhill | Oregon | 41071 | 4667 | 78 |
1383665 | 1383665 | 2021-06-03 | Douglas | Oregon | 41019 | 3624 | 78 |
1383691 | 1383691 | 2021-06-03 | Yamhill | Oregon | 41071 | 4657 | 78 |
1380419 | 1380419 | 2021-06-02 | Douglas | Oregon | 41019 | 3588 | 78 |
1380445 | 1380445 | 2021-06-02 | Yamhill | Oregon | 41071 | 4657 | 78 |
1377200 | 1377200 | 2021-06-01 | Yamhill | Oregon | 41071 | 4652 | 78 |
1373954 | 1373954 | 2021-05-31 | Yamhill | Oregon | 41071 | 4652 | 78 |
1370709 | 1370709 | 2021-05-30 | Yamhill | Oregon | 41071 | 4649 | 78 |
1367463 | 1367463 | 2021-05-29 | Yamhill | Oregon | 41071 | 4639 | 78 |
1364217 | 1364217 | 2021-05-28 | Yamhill | Oregon | 41071 | 4624 | 78 |
1360971 | 1360971 | 2021-05-27 | Yamhill | Oregon | 41071 | 4617 | 78 |
1357698 | 1357698 | 2021-05-26 | Deschutes | Oregon | 41017 | 9525 | 78 |
1354452 | 1354452 | 2021-05-25 | Deschutes | Oregon | 41017 | 9490 | 78 |
1351206 | 1351206 | 2021-05-24 | Deschutes | Oregon | 41017 | 9443 | 78 |
1347960 | 1347960 | 2021-05-23 | Deschutes | Oregon | 41017 | 9433 | 78 |
1344712 | 1344712 | 2021-05-22 | Deschutes | Oregon | 41017 | 9390 | 78 |
1341464 | 1341464 | 2021-05-21 | Deschutes | Oregon | 41017 | 9346 | 78 |
838306 | 838306 | 2020-12-17 | Lane | Oregon | 41039 | 5900 | 78 |
763644 | 763644 | 2020-11-24 | Clackamas | Oregon | 41005 | 5574 | 78 |
760399 | 760399 | 2020-11-23 | Clackamas | Oregon | 41005 | 5472 | 78 |
685808 | 685808 | 2020-10-31 | Washington | Oregon | 41067 | 6170 | 78 |
682565 | 682565 | 2020-10-30 | Washington | Oregon | 41067 | 6082 | 78 |
679322 | 679322 | 2020-10-29 | Washington | Oregon | 41067 | 5991 | 78 |
676079 | 676079 | 2020-10-28 | Washington | Oregon | 41067 | 5885 | 78 |
478446 | 478446 | 2020-08-28 | Marion | Oregon | 41047 | 3706 | 78 |
362459 | 362459 | 2020-07-23 | Multnomah | Oregon | 41051 | 3748 | 78 |
359253 | 359253 | 2020-07-22 | Multnomah | Oregon | 41051 | 3683 | 78 |
356049 | 356049 | 2020-07-21 | Multnomah | Oregon | 41051 | 3636 | 78 |
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);