ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Montgomery" and fips = 42091 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1802678 | 1802678 | 2021-10-10 | Montgomery | Pennsylvania | 42091 | 82527 | 1805 |
1799429 | 1799429 | 2021-10-09 | Montgomery | Pennsylvania | 42091 | 82342 | 1805 |
1796180 | 1796180 | 2021-10-08 | Montgomery | Pennsylvania | 42091 | 82184 | 1805 |
1792931 | 1792931 | 2021-10-07 | Montgomery | Pennsylvania | 42091 | 81997 | 1802 |
1789682 | 1789682 | 2021-10-06 | Montgomery | Pennsylvania | 42091 | 81784 | 1799 |
1786434 | 1786434 | 2021-10-05 | Montgomery | Pennsylvania | 42091 | 81632 | 1797 |
1783185 | 1783185 | 2021-10-04 | Montgomery | Pennsylvania | 42091 | 81411 | 1794 |
1779936 | 1779936 | 2021-10-03 | Montgomery | Pennsylvania | 42091 | 81195 | 1794 |
1776686 | 1776686 | 2021-10-02 | Montgomery | Pennsylvania | 42091 | 81012 | 1793 |
1773436 | 1773436 | 2021-10-01 | Montgomery | Pennsylvania | 42091 | 80896 | 1791 |
1770186 | 1770186 | 2021-09-30 | Montgomery | Pennsylvania | 42091 | 80719 | 1788 |
1766937 | 1766937 | 2021-09-29 | Montgomery | Pennsylvania | 42091 | 80576 | 1788 |
1763688 | 1763688 | 2021-09-28 | Montgomery | Pennsylvania | 42091 | 80435 | 1786 |
1760439 | 1760439 | 2021-09-27 | Montgomery | Pennsylvania | 42091 | 80275 | 1782 |
1757191 | 1757191 | 2021-09-26 | Montgomery | Pennsylvania | 42091 | 80138 | 1782 |
1753943 | 1753943 | 2021-09-25 | Montgomery | Pennsylvania | 42091 | 79954 | 1782 |
1750695 | 1750695 | 2021-09-24 | Montgomery | Pennsylvania | 42091 | 79729 | 1780 |
1747446 | 1747446 | 2021-09-23 | Montgomery | Pennsylvania | 42091 | 79577 | 1779 |
1744196 | 1744196 | 2021-09-22 | Montgomery | Pennsylvania | 42091 | 79386 | 1777 |
1740947 | 1740947 | 2021-09-21 | Montgomery | Pennsylvania | 42091 | 79239 | 1776 |
1737698 | 1737698 | 2021-09-20 | Montgomery | Pennsylvania | 42091 | 79075 | 1775 |
1734448 | 1734448 | 2021-09-19 | Montgomery | Pennsylvania | 42091 | 78972 | 1775 |
1731198 | 1731198 | 2021-09-18 | Montgomery | Pennsylvania | 42091 | 78767 | 1775 |
1727948 | 1727948 | 2021-09-17 | Montgomery | Pennsylvania | 42091 | 78602 | 1775 |
1724699 | 1724699 | 2021-09-16 | Montgomery | Pennsylvania | 42091 | 78351 | 1770 |
1721450 | 1721450 | 2021-09-15 | Montgomery | Pennsylvania | 42091 | 78184 | 1768 |
1718202 | 1718202 | 2021-09-14 | Montgomery | Pennsylvania | 42091 | 77947 | 1765 |
1714954 | 1714954 | 2021-09-13 | Montgomery | Pennsylvania | 42091 | 77812 | 1764 |
1711708 | 1711708 | 2021-09-12 | Montgomery | Pennsylvania | 42091 | 77664 | 1764 |
1708461 | 1708461 | 2021-09-11 | Montgomery | Pennsylvania | 42091 | 77426 | 1764 |
1705214 | 1705214 | 2021-09-10 | Montgomery | Pennsylvania | 42091 | 77220 | 1764 |
1701964 | 1701964 | 2021-09-09 | Montgomery | Pennsylvania | 42091 | 77028 | 1763 |
1698715 | 1698715 | 2021-09-08 | Montgomery | Pennsylvania | 42091 | 76912 | 1761 |
1695467 | 1695467 | 2021-09-07 | Montgomery | Pennsylvania | 42091 | 76751 | 1760 |
1692219 | 1692219 | 2021-09-06 | Montgomery | Pennsylvania | 42091 | 76629 | 1759 |
1688970 | 1688970 | 2021-09-05 | Montgomery | Pennsylvania | 42091 | 76473 | 1758 |
1685720 | 1685720 | 2021-09-04 | Montgomery | Pennsylvania | 42091 | 76312 | 1758 |
1682469 | 1682469 | 2021-09-03 | Montgomery | Pennsylvania | 42091 | 76132 | 1758 |
1679219 | 1679219 | 2021-09-02 | Montgomery | Pennsylvania | 42091 | 75981 | 1758 |
1675971 | 1675971 | 2021-09-01 | Montgomery | Pennsylvania | 42091 | 75770 | 1755 |
1672724 | 1672724 | 2021-08-31 | Montgomery | Pennsylvania | 42091 | 75596 | 1755 |
1669476 | 1669476 | 2021-08-30 | Montgomery | Pennsylvania | 42091 | 75459 | 1754 |
1666229 | 1666229 | 2021-08-29 | Montgomery | Pennsylvania | 42091 | 75293 | 1754 |
1662981 | 1662981 | 2021-08-28 | Montgomery | Pennsylvania | 42091 | 75103 | 1753 |
1659733 | 1659733 | 2021-08-27 | Montgomery | Pennsylvania | 42091 | 74913 | 1752 |
1656484 | 1656484 | 2021-08-26 | Montgomery | Pennsylvania | 42091 | 74699 | 1752 |
1653237 | 1653237 | 2021-08-25 | Montgomery | Pennsylvania | 42091 | 74466 | 1751 |
1649990 | 1649990 | 2021-08-24 | Montgomery | Pennsylvania | 42091 | 74191 | 1751 |
1646741 | 1646741 | 2021-08-23 | Montgomery | Pennsylvania | 42091 | 74052 | 1751 |
1643492 | 1643492 | 2021-08-22 | Montgomery | Pennsylvania | 42091 | 73947 | 1751 |
1640242 | 1640242 | 2021-08-21 | Montgomery | Pennsylvania | 42091 | 73844 | 1751 |
1636992 | 1636992 | 2021-08-20 | Montgomery | Pennsylvania | 42091 | 73708 | 1750 |
1633742 | 1633742 | 2021-08-19 | Montgomery | Pennsylvania | 42091 | 73597 | 1748 |
1630495 | 1630495 | 2021-08-18 | Montgomery | Pennsylvania | 42091 | 73441 | 1747 |
1627248 | 1627248 | 2021-08-17 | Montgomery | Pennsylvania | 42091 | 73321 | 1747 |
1624001 | 1624001 | 2021-08-16 | Montgomery | Pennsylvania | 42091 | 73209 | 1746 |
1620754 | 1620754 | 2021-08-15 | Montgomery | Pennsylvania | 42091 | 73118 | 1746 |
1617506 | 1617506 | 2021-08-14 | Montgomery | Pennsylvania | 42091 | 72969 | 1746 |
1614258 | 1614258 | 2021-08-13 | Montgomery | Pennsylvania | 42091 | 72826 | 1746 |
1611009 | 1611009 | 2021-08-12 | Montgomery | Pennsylvania | 42091 | 72653 | 1746 |
1607761 | 1607761 | 2021-08-11 | Montgomery | Pennsylvania | 42091 | 72528 | 1742 |
1604512 | 1604512 | 2021-08-10 | Montgomery | Pennsylvania | 42091 | 72435 | 1742 |
1601263 | 1601263 | 2021-08-09 | Montgomery | Pennsylvania | 42091 | 72313 | 1742 |
1598015 | 1598015 | 2021-08-08 | Montgomery | Pennsylvania | 42091 | 72101 | 1742 |
1594766 | 1594766 | 2021-08-07 | Montgomery | Pennsylvania | 42091 | 72101 | 1742 |
1591517 | 1591517 | 2021-08-06 | Montgomery | Pennsylvania | 42091 | 71983 | 1742 |
1588268 | 1588268 | 2021-08-05 | Montgomery | Pennsylvania | 42091 | 71880 | 1742 |
1585018 | 1585018 | 2021-08-04 | Montgomery | Pennsylvania | 42091 | 71759 | 1742 |
1581768 | 1581768 | 2021-08-03 | Montgomery | Pennsylvania | 42091 | 71657 | 1741 |
1578519 | 1578519 | 2021-08-02 | Montgomery | Pennsylvania | 42091 | 71588 | 1741 |
1575271 | 1575271 | 2021-08-01 | Montgomery | Pennsylvania | 42091 | 71506 | 1741 |
1572023 | 1572023 | 2021-07-31 | Montgomery | Pennsylvania | 42091 | 71325 | 1741 |
1568775 | 1568775 | 2021-07-30 | Montgomery | Pennsylvania | 42091 | 71325 | 1741 |
1565527 | 1565527 | 2021-07-29 | Montgomery | Pennsylvania | 42091 | 71238 | 1740 |
1562279 | 1562279 | 2021-07-28 | Montgomery | Pennsylvania | 42091 | 71176 | 1740 |
1559031 | 1559031 | 2021-07-27 | Montgomery | Pennsylvania | 42091 | 71129 | 1740 |
1555784 | 1555784 | 2021-07-26 | Montgomery | Pennsylvania | 42091 | 71056 | 1739 |
1552537 | 1552537 | 2021-07-25 | Montgomery | Pennsylvania | 42091 | 71008 | 1739 |
1549290 | 1549290 | 2021-07-24 | Montgomery | Pennsylvania | 42091 | 70950 | 1739 |
1546043 | 1546043 | 2021-07-23 | Montgomery | Pennsylvania | 42091 | 70892 | 1739 |
1542796 | 1542796 | 2021-07-22 | Montgomery | Pennsylvania | 42091 | 70844 | 1739 |
1539548 | 1539548 | 2021-07-21 | Montgomery | Pennsylvania | 42091 | 70790 | 1739 |
1536301 | 1536301 | 2021-07-20 | Montgomery | Pennsylvania | 42091 | 70747 | 1739 |
1533053 | 1533053 | 2021-07-19 | Montgomery | Pennsylvania | 42091 | 70716 | 1739 |
1529806 | 1529806 | 2021-07-18 | Montgomery | Pennsylvania | 42091 | 70701 | 1739 |
1526559 | 1526559 | 2021-07-17 | Montgomery | Pennsylvania | 42091 | 70678 | 1739 |
1523312 | 1523312 | 2021-07-16 | Montgomery | Pennsylvania | 42091 | 70646 | 1739 |
1520064 | 1520064 | 2021-07-15 | Montgomery | Pennsylvania | 42091 | 70607 | 1739 |
1516816 | 1516816 | 2021-07-14 | Montgomery | Pennsylvania | 42091 | 70573 | 1739 |
1513569 | 1513569 | 2021-07-13 | Montgomery | Pennsylvania | 42091 | 70549 | 1739 |
1510323 | 1510323 | 2021-07-12 | Montgomery | Pennsylvania | 42091 | 70531 | 1739 |
1507076 | 1507076 | 2021-07-11 | Montgomery | Pennsylvania | 42091 | 70525 | 1739 |
1503830 | 1503830 | 2021-07-10 | Montgomery | Pennsylvania | 42091 | 70513 | 1738 |
1500584 | 1500584 | 2021-07-09 | Montgomery | Pennsylvania | 42091 | 70495 | 1738 |
1497338 | 1497338 | 2021-07-08 | Montgomery | Pennsylvania | 42091 | 70482 | 1738 |
1494091 | 1494091 | 2021-07-07 | Montgomery | Pennsylvania | 42091 | 70464 | 1738 |
1490844 | 1490844 | 2021-07-06 | Montgomery | Pennsylvania | 42091 | 70455 | 1736 |
1487597 | 1487597 | 2021-07-05 | Montgomery | Pennsylvania | 42091 | 70451 | 1736 |
1484350 | 1484350 | 2021-07-04 | Montgomery | Pennsylvania | 42091 | 70442 | 1736 |
1481104 | 1481104 | 2021-07-03 | Montgomery | Pennsylvania | 42091 | 70430 | 1736 |
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);