ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 42095 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1841669 | 1841669 | 2021-10-22 | Northampton | Pennsylvania | 42095 | 44049 | 786 |
1838420 | 1838420 | 2021-10-21 | Northampton | Pennsylvania | 42095 | 43966 | 783 |
1835171 | 1835171 | 2021-10-20 | Northampton | Pennsylvania | 42095 | 43861 | 783 |
1831922 | 1831922 | 2021-10-19 | Northampton | Pennsylvania | 42095 | 43804 | 781 |
1828673 | 1828673 | 2021-10-18 | Northampton | Pennsylvania | 42095 | 43715 | 779 |
1825424 | 1825424 | 2021-10-17 | Northampton | Pennsylvania | 42095 | 43670 | 778 |
1822175 | 1822175 | 2021-10-16 | Northampton | Pennsylvania | 42095 | 43591 | 778 |
1818926 | 1818926 | 2021-10-15 | Northampton | Pennsylvania | 42095 | 43507 | 778 |
1815677 | 1815677 | 2021-10-14 | Northampton | Pennsylvania | 42095 | 43443 | 778 |
1812429 | 1812429 | 2021-10-13 | Northampton | Pennsylvania | 42095 | 43318 | 776 |
1809180 | 1809180 | 2021-10-12 | Northampton | Pennsylvania | 42095 | 43262 | 774 |
1805930 | 1805930 | 2021-10-11 | Northampton | Pennsylvania | 42095 | 43156 | 768 |
1802680 | 1802680 | 2021-10-10 | Northampton | Pennsylvania | 42095 | 43098 | 768 |
1799431 | 1799431 | 2021-10-09 | Northampton | Pennsylvania | 42095 | 43050 | 768 |
1796182 | 1796182 | 2021-10-08 | Northampton | Pennsylvania | 42095 | 42961 | 768 |
1792933 | 1792933 | 2021-10-07 | Northampton | Pennsylvania | 42095 | 42818 | 766 |
1789684 | 1789684 | 2021-10-06 | Northampton | Pennsylvania | 42095 | 42700 | 765 |
1786436 | 1786436 | 2021-10-05 | Northampton | Pennsylvania | 42095 | 42640 | 764 |
1783187 | 1783187 | 2021-10-04 | Northampton | Pennsylvania | 42095 | 42552 | 763 |
1779938 | 1779938 | 2021-10-03 | Northampton | Pennsylvania | 42095 | 42417 | 763 |
1776688 | 1776688 | 2021-10-02 | Northampton | Pennsylvania | 42095 | 42266 | 762 |
1773438 | 1773438 | 2021-10-01 | Northampton | Pennsylvania | 42095 | 42209 | 761 |
1770188 | 1770188 | 2021-09-30 | Northampton | Pennsylvania | 42095 | 42137 | 759 |
1766939 | 1766939 | 2021-09-29 | Northampton | Pennsylvania | 42095 | 42017 | 758 |
1763690 | 1763690 | 2021-09-28 | Northampton | Pennsylvania | 42095 | 41922 | 756 |
1760441 | 1760441 | 2021-09-27 | Northampton | Pennsylvania | 42095 | 41791 | 753 |
1757193 | 1757193 | 2021-09-26 | Northampton | Pennsylvania | 42095 | 41716 | 753 |
1753945 | 1753945 | 2021-09-25 | Northampton | Pennsylvania | 42095 | 41640 | 753 |
1750697 | 1750697 | 2021-09-24 | Northampton | Pennsylvania | 42095 | 41499 | 751 |
1747448 | 1747448 | 2021-09-23 | Northampton | Pennsylvania | 42095 | 41353 | 749 |
1744198 | 1744198 | 2021-09-22 | Northampton | Pennsylvania | 42095 | 41208 | 749 |
1740949 | 1740949 | 2021-09-21 | Northampton | Pennsylvania | 42095 | 41093 | 748 |
1737700 | 1737700 | 2021-09-20 | Northampton | Pennsylvania | 42095 | 40972 | 745 |
1734450 | 1734450 | 2021-09-19 | Northampton | Pennsylvania | 42095 | 40926 | 745 |
1731200 | 1731200 | 2021-09-18 | Northampton | Pennsylvania | 42095 | 40812 | 745 |
1727950 | 1727950 | 2021-09-17 | Northampton | Pennsylvania | 42095 | 40741 | 744 |
1724701 | 1724701 | 2021-09-16 | Northampton | Pennsylvania | 42095 | 40580 | 744 |
1721452 | 1721452 | 2021-09-15 | Northampton | Pennsylvania | 42095 | 40452 | 743 |
1718204 | 1718204 | 2021-09-14 | Northampton | Pennsylvania | 42095 | 40326 | 743 |
1714956 | 1714956 | 2021-09-13 | Northampton | Pennsylvania | 42095 | 40223 | 741 |
1711710 | 1711710 | 2021-09-12 | Northampton | Pennsylvania | 42095 | 40149 | 741 |
1708463 | 1708463 | 2021-09-11 | Northampton | Pennsylvania | 42095 | 40078 | 741 |
1705216 | 1705216 | 2021-09-10 | Northampton | Pennsylvania | 42095 | 39923 | 740 |
1701966 | 1701966 | 2021-09-09 | Northampton | Pennsylvania | 42095 | 39700 | 739 |
1698717 | 1698717 | 2021-09-08 | Northampton | Pennsylvania | 42095 | 39564 | 737 |
1695469 | 1695469 | 2021-09-07 | Northampton | Pennsylvania | 42095 | 39457 | 735 |
1692221 | 1692221 | 2021-09-06 | Northampton | Pennsylvania | 42095 | 39402 | 735 |
1688972 | 1688972 | 2021-09-05 | Northampton | Pennsylvania | 42095 | 39330 | 735 |
1685722 | 1685722 | 2021-09-04 | Northampton | Pennsylvania | 42095 | 39208 | 735 |
1682471 | 1682471 | 2021-09-03 | Northampton | Pennsylvania | 42095 | 39093 | 735 |
1679221 | 1679221 | 2021-09-02 | Northampton | Pennsylvania | 42095 | 38982 | 735 |
1675973 | 1675973 | 2021-09-01 | Northampton | Pennsylvania | 42095 | 38829 | 733 |
1672726 | 1672726 | 2021-08-31 | Northampton | Pennsylvania | 42095 | 38707 | 733 |
1669478 | 1669478 | 2021-08-30 | Northampton | Pennsylvania | 42095 | 38639 | 733 |
1666231 | 1666231 | 2021-08-29 | Northampton | Pennsylvania | 42095 | 38584 | 733 |
1662983 | 1662983 | 2021-08-28 | Northampton | Pennsylvania | 42095 | 38511 | 733 |
1659735 | 1659735 | 2021-08-27 | Northampton | Pennsylvania | 42095 | 38418 | 732 |
1656486 | 1656486 | 2021-08-26 | Northampton | Pennsylvania | 42095 | 38323 | 732 |
1653239 | 1653239 | 2021-08-25 | Northampton | Pennsylvania | 42095 | 38255 | 731 |
1649992 | 1649992 | 2021-08-24 | Northampton | Pennsylvania | 42095 | 38122 | 729 |
1646743 | 1646743 | 2021-08-23 | Northampton | Pennsylvania | 42095 | 38017 | 728 |
1643494 | 1643494 | 2021-08-22 | Northampton | Pennsylvania | 42095 | 37963 | 728 |
1640244 | 1640244 | 2021-08-21 | Northampton | Pennsylvania | 42095 | 37877 | 728 |
1636994 | 1636994 | 2021-08-20 | Northampton | Pennsylvania | 42095 | 37807 | 728 |
1633744 | 1633744 | 2021-08-19 | Northampton | Pennsylvania | 42095 | 37739 | 727 |
1630497 | 1630497 | 2021-08-18 | Northampton | Pennsylvania | 42095 | 37604 | 725 |
1627250 | 1627250 | 2021-08-17 | Northampton | Pennsylvania | 42095 | 37516 | 724 |
1624003 | 1624003 | 2021-08-16 | Northampton | Pennsylvania | 42095 | 37422 | 723 |
1620756 | 1620756 | 2021-08-15 | Northampton | Pennsylvania | 42095 | 37359 | 723 |
1617508 | 1617508 | 2021-08-14 | Northampton | Pennsylvania | 42095 | 37290 | 723 |
1614260 | 1614260 | 2021-08-13 | Northampton | Pennsylvania | 42095 | 37211 | 723 |
1611011 | 1611011 | 2021-08-12 | Northampton | Pennsylvania | 42095 | 37126 | 723 |
1607763 | 1607763 | 2021-08-11 | Northampton | Pennsylvania | 42095 | 37040 | 722 |
1604514 | 1604514 | 2021-08-10 | Northampton | Pennsylvania | 42095 | 36961 | 721 |
1601265 | 1601265 | 2021-08-09 | Northampton | Pennsylvania | 42095 | 36890 | 720 |
1598017 | 1598017 | 2021-08-08 | Northampton | Pennsylvania | 42095 | 36806 | 720 |
1594768 | 1594768 | 2021-08-07 | Northampton | Pennsylvania | 42095 | 36806 | 720 |
1591519 | 1591519 | 2021-08-06 | Northampton | Pennsylvania | 42095 | 36725 | 720 |
1588270 | 1588270 | 2021-08-05 | Northampton | Pennsylvania | 42095 | 36657 | 720 |
1585020 | 1585020 | 2021-08-04 | Northampton | Pennsylvania | 42095 | 36609 | 720 |
1581770 | 1581770 | 2021-08-03 | Northampton | Pennsylvania | 42095 | 36535 | 720 |
1578521 | 1578521 | 2021-08-02 | Northampton | Pennsylvania | 42095 | 36459 | 720 |
1575273 | 1575273 | 2021-08-01 | Northampton | Pennsylvania | 42095 | 36413 | 720 |
1572025 | 1572025 | 2021-07-31 | Northampton | Pennsylvania | 42095 | 36328 | 720 |
1568777 | 1568777 | 2021-07-30 | Northampton | Pennsylvania | 42095 | 36328 | 720 |
1565529 | 1565529 | 2021-07-29 | Northampton | Pennsylvania | 42095 | 36290 | 720 |
1562281 | 1562281 | 2021-07-28 | Northampton | Pennsylvania | 42095 | 36245 | 720 |
1559033 | 1559033 | 2021-07-27 | Northampton | Pennsylvania | 42095 | 36224 | 719 |
1555786 | 1555786 | 2021-07-26 | Northampton | Pennsylvania | 42095 | 36188 | 719 |
1552539 | 1552539 | 2021-07-25 | Northampton | Pennsylvania | 42095 | 36171 | 719 |
1549292 | 1549292 | 2021-07-24 | Northampton | Pennsylvania | 42095 | 36152 | 719 |
1546045 | 1546045 | 2021-07-23 | Northampton | Pennsylvania | 42095 | 36123 | 719 |
1542798 | 1542798 | 2021-07-22 | Northampton | Pennsylvania | 42095 | 36099 | 719 |
1539550 | 1539550 | 2021-07-21 | Northampton | Pennsylvania | 42095 | 36080 | 719 |
1536303 | 1536303 | 2021-07-20 | Northampton | Pennsylvania | 42095 | 36056 | 719 |
1533055 | 1533055 | 2021-07-19 | Northampton | Pennsylvania | 42095 | 36021 | 719 |
1529808 | 1529808 | 2021-07-18 | Northampton | Pennsylvania | 42095 | 36012 | 719 |
1526561 | 1526561 | 2021-07-17 | Northampton | Pennsylvania | 42095 | 36002 | 718 |
1523314 | 1523314 | 2021-07-16 | Northampton | Pennsylvania | 42095 | 35993 | 718 |
1520066 | 1520066 | 2021-07-15 | Northampton | Pennsylvania | 42095 | 35978 | 718 |
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);