ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
438 rows where deaths = 7 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 |
---|---|---|---|---|---|---|---|
1666159 | 1666159 | 2021-08-29 | Grant | Oregon | 41023 | 635 | 7 |
1662911 | 1662911 | 2021-08-28 | Grant | Oregon | 41023 | 635 | 7 |
1659663 | 1659663 | 2021-08-27 | Grant | Oregon | 41023 | 635 | 7 |
1656414 | 1656414 | 2021-08-26 | Grant | Oregon | 41023 | 630 | 7 |
1653167 | 1653167 | 2021-08-25 | Grant | Oregon | 41023 | 601 | 7 |
1649920 | 1649920 | 2021-08-24 | Grant | Oregon | 41023 | 595 | 7 |
1646671 | 1646671 | 2021-08-23 | Grant | Oregon | 41023 | 591 | 7 |
1646688 | 1646688 | 2021-08-23 | Tillamook | Oregon | 41057 | 1226 | 7 |
1643422 | 1643422 | 2021-08-22 | Grant | Oregon | 41023 | 581 | 7 |
1640172 | 1640172 | 2021-08-21 | Grant | Oregon | 41023 | 581 | 7 |
1636922 | 1636922 | 2021-08-20 | Grant | Oregon | 41023 | 581 | 7 |
1633672 | 1633672 | 2021-08-19 | Grant | Oregon | 41023 | 577 | 7 |
1630425 | 1630425 | 2021-08-18 | Grant | Oregon | 41023 | 568 | 7 |
1627178 | 1627178 | 2021-08-17 | Grant | Oregon | 41023 | 567 | 7 |
1623931 | 1623931 | 2021-08-16 | Grant | Oregon | 41023 | 567 | 7 |
1620684 | 1620684 | 2021-08-15 | Grant | Oregon | 41023 | 567 | 7 |
1617436 | 1617436 | 2021-08-14 | Grant | Oregon | 41023 | 567 | 7 |
1614188 | 1614188 | 2021-08-13 | Grant | Oregon | 41023 | 567 | 7 |
1610939 | 1610939 | 2021-08-12 | Grant | Oregon | 41023 | 567 | 7 |
1607691 | 1607691 | 2021-08-11 | Grant | Oregon | 41023 | 567 | 7 |
1604442 | 1604442 | 2021-08-10 | Grant | Oregon | 41023 | 567 | 7 |
1601193 | 1601193 | 2021-08-09 | Grant | Oregon | 41023 | 567 | 7 |
1597945 | 1597945 | 2021-08-08 | Grant | Oregon | 41023 | 567 | 7 |
1594696 | 1594696 | 2021-08-07 | Grant | Oregon | 41023 | 567 | 7 |
1591447 | 1591447 | 2021-08-06 | Grant | Oregon | 41023 | 567 | 7 |
1588198 | 1588198 | 2021-08-05 | Grant | Oregon | 41023 | 567 | 7 |
1584948 | 1584948 | 2021-08-04 | Grant | Oregon | 41023 | 565 | 7 |
1581698 | 1581698 | 2021-08-03 | Grant | Oregon | 41023 | 565 | 7 |
1578449 | 1578449 | 2021-08-02 | Grant | Oregon | 41023 | 563 | 7 |
1575201 | 1575201 | 2021-08-01 | Grant | Oregon | 41023 | 563 | 7 |
1571953 | 1571953 | 2021-07-31 | Grant | Oregon | 41023 | 563 | 7 |
1568705 | 1568705 | 2021-07-30 | Grant | Oregon | 41023 | 563 | 7 |
1565457 | 1565457 | 2021-07-29 | Grant | Oregon | 41023 | 562 | 7 |
1562209 | 1562209 | 2021-07-28 | Grant | Oregon | 41023 | 559 | 7 |
1558961 | 1558961 | 2021-07-27 | Grant | Oregon | 41023 | 558 | 7 |
1555714 | 1555714 | 2021-07-26 | Grant | Oregon | 41023 | 557 | 7 |
1552467 | 1552467 | 2021-07-25 | Grant | Oregon | 41023 | 557 | 7 |
1549220 | 1549220 | 2021-07-24 | Grant | Oregon | 41023 | 557 | 7 |
1545973 | 1545973 | 2021-07-23 | Grant | Oregon | 41023 | 557 | 7 |
1542726 | 1542726 | 2021-07-22 | Grant | Oregon | 41023 | 557 | 7 |
1539478 | 1539478 | 2021-07-21 | Grant | Oregon | 41023 | 556 | 7 |
1536231 | 1536231 | 2021-07-20 | Grant | Oregon | 41023 | 556 | 7 |
1532983 | 1532983 | 2021-07-19 | Grant | Oregon | 41023 | 556 | 7 |
1529736 | 1529736 | 2021-07-18 | Grant | Oregon | 41023 | 556 | 7 |
1526489 | 1526489 | 2021-07-17 | Grant | Oregon | 41023 | 556 | 7 |
1523242 | 1523242 | 2021-07-16 | Grant | Oregon | 41023 | 556 | 7 |
1519994 | 1519994 | 2021-07-15 | Grant | Oregon | 41023 | 556 | 7 |
1516746 | 1516746 | 2021-07-14 | Grant | Oregon | 41023 | 556 | 7 |
1513499 | 1513499 | 2021-07-13 | Grant | Oregon | 41023 | 556 | 7 |
1510253 | 1510253 | 2021-07-12 | Grant | Oregon | 41023 | 556 | 7 |
1507006 | 1507006 | 2021-07-11 | Grant | Oregon | 41023 | 556 | 7 |
1503760 | 1503760 | 2021-07-10 | Grant | Oregon | 41023 | 556 | 7 |
1500514 | 1500514 | 2021-07-09 | Grant | Oregon | 41023 | 556 | 7 |
1497268 | 1497268 | 2021-07-08 | Grant | Oregon | 41023 | 553 | 7 |
1494021 | 1494021 | 2021-07-07 | Grant | Oregon | 41023 | 553 | 7 |
1490774 | 1490774 | 2021-07-06 | Grant | Oregon | 41023 | 552 | 7 |
1487527 | 1487527 | 2021-07-05 | Grant | Oregon | 41023 | 552 | 7 |
1484280 | 1484280 | 2021-07-04 | Grant | Oregon | 41023 | 552 | 7 |
1481034 | 1481034 | 2021-07-03 | Grant | Oregon | 41023 | 552 | 7 |
1477787 | 1477787 | 2021-07-02 | Grant | Oregon | 41023 | 552 | 7 |
1474541 | 1474541 | 2021-07-01 | Grant | Oregon | 41023 | 552 | 7 |
1471295 | 1471295 | 2021-06-30 | Grant | Oregon | 41023 | 552 | 7 |
1468050 | 1468050 | 2021-06-29 | Grant | Oregon | 41023 | 552 | 7 |
1464805 | 1464805 | 2021-06-28 | Grant | Oregon | 41023 | 552 | 7 |
1461560 | 1461560 | 2021-06-27 | Grant | Oregon | 41023 | 552 | 7 |
1458315 | 1458315 | 2021-06-26 | Grant | Oregon | 41023 | 552 | 7 |
1455070 | 1455070 | 2021-06-25 | Grant | Oregon | 41023 | 552 | 7 |
1451825 | 1451825 | 2021-06-24 | Grant | Oregon | 41023 | 552 | 7 |
1448579 | 1448579 | 2021-06-23 | Grant | Oregon | 41023 | 552 | 7 |
1445334 | 1445334 | 2021-06-22 | Grant | Oregon | 41023 | 551 | 7 |
1442089 | 1442089 | 2021-06-21 | Grant | Oregon | 41023 | 550 | 7 |
1438844 | 1438844 | 2021-06-20 | Grant | Oregon | 41023 | 550 | 7 |
1435597 | 1435597 | 2021-06-19 | Grant | Oregon | 41023 | 550 | 7 |
1432350 | 1432350 | 2021-06-18 | Grant | Oregon | 41023 | 548 | 7 |
1429104 | 1429104 | 2021-06-17 | Grant | Oregon | 41023 | 548 | 7 |
1425859 | 1425859 | 2021-06-16 | Grant | Oregon | 41023 | 548 | 7 |
1422612 | 1422612 | 2021-06-15 | Grant | Oregon | 41023 | 548 | 7 |
1419366 | 1419366 | 2021-06-14 | Grant | Oregon | 41023 | 548 | 7 |
1419373 | 1419373 | 2021-06-14 | Lake | Oregon | 41037 | 466 | 7 |
1416121 | 1416121 | 2021-06-13 | Grant | Oregon | 41023 | 547 | 7 |
1416128 | 1416128 | 2021-06-13 | Lake | Oregon | 41037 | 466 | 7 |
1412875 | 1412875 | 2021-06-12 | Grant | Oregon | 41023 | 547 | 7 |
1412882 | 1412882 | 2021-06-12 | Lake | Oregon | 41037 | 466 | 7 |
1409630 | 1409630 | 2021-06-11 | Grant | Oregon | 41023 | 547 | 7 |
1409637 | 1409637 | 2021-06-11 | Lake | Oregon | 41037 | 466 | 7 |
1406385 | 1406385 | 2021-06-10 | Grant | Oregon | 41023 | 545 | 7 |
1406392 | 1406392 | 2021-06-10 | Lake | Oregon | 41037 | 465 | 7 |
1403139 | 1403139 | 2021-06-09 | Grant | Oregon | 41023 | 545 | 7 |
1403146 | 1403146 | 2021-06-09 | Lake | Oregon | 41037 | 465 | 7 |
1399901 | 1399901 | 2021-06-08 | Lake | Oregon | 41037 | 464 | 7 |
1396656 | 1396656 | 2021-06-07 | Lake | Oregon | 41037 | 464 | 7 |
1393409 | 1393409 | 2021-06-06 | Lake | Oregon | 41037 | 464 | 7 |
1390164 | 1390164 | 2021-06-05 | Lake | Oregon | 41037 | 464 | 7 |
1386919 | 1386919 | 2021-06-04 | Lake | Oregon | 41037 | 463 | 7 |
1383674 | 1383674 | 2021-06-03 | Lake | Oregon | 41037 | 463 | 7 |
1380428 | 1380428 | 2021-06-02 | Lake | Oregon | 41037 | 463 | 7 |
1377183 | 1377183 | 2021-06-01 | Lake | Oregon | 41037 | 462 | 7 |
1373937 | 1373937 | 2021-05-31 | Lake | Oregon | 41037 | 462 | 7 |
1370692 | 1370692 | 2021-05-30 | Lake | Oregon | 41037 | 462 | 7 |
1367446 | 1367446 | 2021-05-29 | Lake | Oregon | 41037 | 462 | 7 |
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);