ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where county = "Sagadahoc", deaths = 12, fips = 23023 and state = "Maine" 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 |
---|---|---|---|---|---|---|---|
1850305 | 1850305 | 2021-10-25 | Sagadahoc | Maine | 23023 | 1948 | 12 |
1847055 | 1847055 | 2021-10-24 | Sagadahoc | Maine | 23023 | 1948 | 12 |
1843805 | 1843805 | 2021-10-23 | Sagadahoc | Maine | 23023 | 1948 | 12 |
1840555 | 1840555 | 2021-10-22 | Sagadahoc | Maine | 23023 | 1940 | 12 |
1837306 | 1837306 | 2021-10-21 | Sagadahoc | Maine | 23023 | 1931 | 12 |
1834057 | 1834057 | 2021-10-20 | Sagadahoc | Maine | 23023 | 1918 | 12 |
1830808 | 1830808 | 2021-10-19 | Sagadahoc | Maine | 23023 | 1907 | 12 |
1827559 | 1827559 | 2021-10-18 | Sagadahoc | Maine | 23023 | 1889 | 12 |
1824310 | 1824310 | 2021-10-17 | Sagadahoc | Maine | 23023 | 1889 | 12 |
1821061 | 1821061 | 2021-10-16 | Sagadahoc | Maine | 23023 | 1889 | 12 |
1817812 | 1817812 | 2021-10-15 | Sagadahoc | Maine | 23023 | 1887 | 12 |
1814564 | 1814564 | 2021-10-14 | Sagadahoc | Maine | 23023 | 1879 | 12 |
1811315 | 1811315 | 2021-10-13 | Sagadahoc | Maine | 23023 | 1865 | 12 |
1808066 | 1808066 | 2021-10-12 | Sagadahoc | Maine | 23023 | 1840 | 12 |
1804815 | 1804815 | 2021-10-11 | Sagadahoc | Maine | 23023 | 1840 | 12 |
1801566 | 1801566 | 2021-10-10 | Sagadahoc | Maine | 23023 | 1840 | 12 |
1798317 | 1798317 | 2021-10-09 | Sagadahoc | Maine | 23023 | 1840 | 12 |
1795068 | 1795068 | 2021-10-08 | Sagadahoc | Maine | 23023 | 1832 | 12 |
1791820 | 1791820 | 2021-10-07 | Sagadahoc | Maine | 23023 | 1823 | 12 |
1788571 | 1788571 | 2021-10-06 | Sagadahoc | Maine | 23023 | 1805 | 12 |
1785322 | 1785322 | 2021-10-05 | Sagadahoc | Maine | 23023 | 1802 | 12 |
1782073 | 1782073 | 2021-10-04 | Sagadahoc | Maine | 23023 | 1771 | 12 |
1778823 | 1778823 | 2021-10-03 | Sagadahoc | Maine | 23023 | 1771 | 12 |
1775573 | 1775573 | 2021-10-02 | Sagadahoc | Maine | 23023 | 1771 | 12 |
1772323 | 1772323 | 2021-10-01 | Sagadahoc | Maine | 23023 | 1761 | 12 |
1769074 | 1769074 | 2021-09-30 | Sagadahoc | Maine | 23023 | 1755 | 12 |
1765825 | 1765825 | 2021-09-29 | Sagadahoc | Maine | 23023 | 1727 | 12 |
1762576 | 1762576 | 2021-09-28 | Sagadahoc | Maine | 23023 | 1696 | 12 |
1759328 | 1759328 | 2021-09-27 | Sagadahoc | Maine | 23023 | 1690 | 12 |
1756080 | 1756080 | 2021-09-26 | Sagadahoc | Maine | 23023 | 1690 | 12 |
1752832 | 1752832 | 2021-09-25 | Sagadahoc | Maine | 23023 | 1690 | 12 |
1749583 | 1749583 | 2021-09-24 | Sagadahoc | Maine | 23023 | 1690 | 12 |
1746333 | 1746333 | 2021-09-23 | Sagadahoc | Maine | 23023 | 1680 | 12 |
1743084 | 1743084 | 2021-09-22 | Sagadahoc | Maine | 23023 | 1660 | 12 |
1739835 | 1739835 | 2021-09-21 | Sagadahoc | Maine | 23023 | 1651 | 12 |
1736586 | 1736586 | 2021-09-20 | Sagadahoc | Maine | 23023 | 1649 | 12 |
1733336 | 1733336 | 2021-09-19 | Sagadahoc | Maine | 23023 | 1649 | 12 |
1730086 | 1730086 | 2021-09-18 | Sagadahoc | Maine | 23023 | 1649 | 12 |
1726836 | 1726836 | 2021-09-17 | Sagadahoc | Maine | 23023 | 1646 | 12 |
1723587 | 1723587 | 2021-09-16 | Sagadahoc | Maine | 23023 | 1638 | 12 |
1720338 | 1720338 | 2021-09-15 | Sagadahoc | Maine | 23023 | 1634 | 12 |
1717090 | 1717090 | 2021-09-14 | Sagadahoc | Maine | 23023 | 1626 | 12 |
1713843 | 1713843 | 2021-09-13 | Sagadahoc | Maine | 23023 | 1618 | 12 |
1710597 | 1710597 | 2021-09-12 | Sagadahoc | Maine | 23023 | 1619 | 12 |
1707350 | 1707350 | 2021-09-11 | Sagadahoc | Maine | 23023 | 1619 | 12 |
1704102 | 1704102 | 2021-09-10 | Sagadahoc | Maine | 23023 | 1615 | 12 |
1700852 | 1700852 | 2021-09-09 | Sagadahoc | Maine | 23023 | 1607 | 12 |
1697603 | 1697603 | 2021-09-08 | Sagadahoc | Maine | 23023 | 1599 | 12 |
1694355 | 1694355 | 2021-09-07 | Sagadahoc | Maine | 23023 | 1595 | 12 |
1691106 | 1691106 | 2021-09-06 | Sagadahoc | Maine | 23023 | 1595 | 12 |
1687856 | 1687856 | 2021-09-05 | Sagadahoc | Maine | 23023 | 1595 | 12 |
1684606 | 1684606 | 2021-09-04 | Sagadahoc | Maine | 23023 | 1595 | 12 |
1681355 | 1681355 | 2021-09-03 | Sagadahoc | Maine | 23023 | 1587 | 12 |
1678107 | 1678107 | 2021-09-02 | Sagadahoc | Maine | 23023 | 1583 | 12 |
1674860 | 1674860 | 2021-09-01 | Sagadahoc | Maine | 23023 | 1577 | 12 |
1671611 | 1671611 | 2021-08-31 | Sagadahoc | Maine | 23023 | 1569 | 12 |
1668364 | 1668364 | 2021-08-30 | Sagadahoc | Maine | 23023 | 1560 | 12 |
1665117 | 1665117 | 2021-08-29 | Sagadahoc | Maine | 23023 | 1560 | 12 |
1661869 | 1661869 | 2021-08-28 | Sagadahoc | Maine | 23023 | 1560 | 12 |
1658621 | 1658621 | 2021-08-27 | Sagadahoc | Maine | 23023 | 1550 | 12 |
1655373 | 1655373 | 2021-08-26 | Sagadahoc | Maine | 23023 | 1540 | 12 |
1652126 | 1652126 | 2021-08-25 | Sagadahoc | Maine | 23023 | 1534 | 12 |
1648877 | 1648877 | 2021-08-24 | Sagadahoc | Maine | 23023 | 1531 | 12 |
1645629 | 1645629 | 2021-08-23 | Sagadahoc | Maine | 23023 | 1527 | 12 |
1642380 | 1642380 | 2021-08-22 | Sagadahoc | Maine | 23023 | 1527 | 12 |
1639130 | 1639130 | 2021-08-21 | Sagadahoc | Maine | 23023 | 1527 | 12 |
1635880 | 1635880 | 2021-08-20 | Sagadahoc | Maine | 23023 | 1525 | 12 |
1632630 | 1632630 | 2021-08-19 | Sagadahoc | Maine | 23023 | 1525 | 12 |
1629383 | 1629383 | 2021-08-18 | Sagadahoc | Maine | 23023 | 1526 | 12 |
1626136 | 1626136 | 2021-08-17 | Sagadahoc | Maine | 23023 | 1523 | 12 |
1622889 | 1622889 | 2021-08-16 | Sagadahoc | Maine | 23023 | 1519 | 12 |
1619642 | 1619642 | 2021-08-15 | Sagadahoc | Maine | 23023 | 1519 | 12 |
1616394 | 1616394 | 2021-08-14 | Sagadahoc | Maine | 23023 | 1519 | 12 |
1613145 | 1613145 | 2021-08-13 | Sagadahoc | Maine | 23023 | 1514 | 12 |
1609897 | 1609897 | 2021-08-12 | Sagadahoc | Maine | 23023 | 1508 | 12 |
1606648 | 1606648 | 2021-08-11 | Sagadahoc | Maine | 23023 | 1506 | 12 |
1603399 | 1603399 | 2021-08-10 | Sagadahoc | Maine | 23023 | 1502 | 12 |
1600150 | 1600150 | 2021-08-09 | Sagadahoc | Maine | 23023 | 1491 | 12 |
1596902 | 1596902 | 2021-08-08 | Sagadahoc | Maine | 23023 | 1491 | 12 |
1593653 | 1593653 | 2021-08-07 | Sagadahoc | Maine | 23023 | 1491 | 12 |
1590404 | 1590404 | 2021-08-06 | Sagadahoc | Maine | 23023 | 1491 | 12 |
1587155 | 1587155 | 2021-08-05 | Sagadahoc | Maine | 23023 | 1491 | 12 |
1583905 | 1583905 | 2021-08-04 | Sagadahoc | Maine | 23023 | 1490 | 12 |
1580655 | 1580655 | 2021-08-03 | Sagadahoc | Maine | 23023 | 1488 | 12 |
1577406 | 1577406 | 2021-08-02 | Sagadahoc | Maine | 23023 | 1487 | 12 |
1574158 | 1574158 | 2021-08-01 | Sagadahoc | Maine | 23023 | 1487 | 12 |
1570910 | 1570910 | 2021-07-31 | Sagadahoc | Maine | 23023 | 1487 | 12 |
1567662 | 1567662 | 2021-07-30 | Sagadahoc | Maine | 23023 | 1487 | 12 |
1564414 | 1564414 | 2021-07-29 | Sagadahoc | Maine | 23023 | 1487 | 12 |
1561166 | 1561166 | 2021-07-28 | Sagadahoc | Maine | 23023 | 1487 | 12 |
1557919 | 1557919 | 2021-07-27 | Sagadahoc | Maine | 23023 | 1486 | 12 |
1554672 | 1554672 | 2021-07-26 | Sagadahoc | Maine | 23023 | 1482 | 12 |
1551425 | 1551425 | 2021-07-25 | Sagadahoc | Maine | 23023 | 1482 | 12 |
1548178 | 1548178 | 2021-07-24 | Sagadahoc | Maine | 23023 | 1482 | 12 |
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);