ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 42089 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1809177 | 1809177 | 2021-10-12 | Monroe | Pennsylvania | 42089 | 18891 | 352 |
1805927 | 1805927 | 2021-10-11 | Monroe | Pennsylvania | 42089 | 18818 | 352 |
1802677 | 1802677 | 2021-10-10 | Monroe | Pennsylvania | 42089 | 18790 | 352 |
1799428 | 1799428 | 2021-10-09 | Monroe | Pennsylvania | 42089 | 18727 | 352 |
1796179 | 1796179 | 2021-10-08 | Monroe | Pennsylvania | 42089 | 18663 | 352 |
1792930 | 1792930 | 2021-10-07 | Monroe | Pennsylvania | 42089 | 18566 | 352 |
1789681 | 1789681 | 2021-10-06 | Monroe | Pennsylvania | 42089 | 18500 | 352 |
1786433 | 1786433 | 2021-10-05 | Monroe | Pennsylvania | 42089 | 18447 | 351 |
1783184 | 1783184 | 2021-10-04 | Monroe | Pennsylvania | 42089 | 18401 | 351 |
1779935 | 1779935 | 2021-10-03 | Monroe | Pennsylvania | 42089 | 18350 | 350 |
1776685 | 1776685 | 2021-10-02 | Monroe | Pennsylvania | 42089 | 18283 | 347 |
1773435 | 1773435 | 2021-10-01 | Monroe | Pennsylvania | 42089 | 18256 | 347 |
1770185 | 1770185 | 2021-09-30 | Monroe | Pennsylvania | 42089 | 18202 | 347 |
1766936 | 1766936 | 2021-09-29 | Monroe | Pennsylvania | 42089 | 18118 | 347 |
1763687 | 1763687 | 2021-09-28 | Monroe | Pennsylvania | 42089 | 18063 | 346 |
1760438 | 1760438 | 2021-09-27 | Monroe | Pennsylvania | 42089 | 17985 | 345 |
1757190 | 1757190 | 2021-09-26 | Monroe | Pennsylvania | 42089 | 17933 | 345 |
1753942 | 1753942 | 2021-09-25 | Monroe | Pennsylvania | 42089 | 17883 | 345 |
1750694 | 1750694 | 2021-09-24 | Monroe | Pennsylvania | 42089 | 17800 | 345 |
1747445 | 1747445 | 2021-09-23 | Monroe | Pennsylvania | 42089 | 17739 | 345 |
1744195 | 1744195 | 2021-09-22 | Monroe | Pennsylvania | 42089 | 17638 | 345 |
1740946 | 1740946 | 2021-09-21 | Monroe | Pennsylvania | 42089 | 17565 | 343 |
1737697 | 1737697 | 2021-09-20 | Monroe | Pennsylvania | 42089 | 17499 | 342 |
1734447 | 1734447 | 2021-09-19 | Monroe | Pennsylvania | 42089 | 17469 | 342 |
1731197 | 1731197 | 2021-09-18 | Monroe | Pennsylvania | 42089 | 17383 | 342 |
1727947 | 1727947 | 2021-09-17 | Monroe | Pennsylvania | 42089 | 17313 | 342 |
1724698 | 1724698 | 2021-09-16 | Monroe | Pennsylvania | 42089 | 17224 | 341 |
1721449 | 1721449 | 2021-09-15 | Monroe | Pennsylvania | 42089 | 17129 | 341 |
1718201 | 1718201 | 2021-09-14 | Monroe | Pennsylvania | 42089 | 17062 | 337 |
1714953 | 1714953 | 2021-09-13 | Monroe | Pennsylvania | 42089 | 16999 | 336 |
1711707 | 1711707 | 2021-09-12 | Monroe | Pennsylvania | 42089 | 16965 | 336 |
1708460 | 1708460 | 2021-09-11 | Monroe | Pennsylvania | 42089 | 16915 | 336 |
1705213 | 1705213 | 2021-09-10 | Monroe | Pennsylvania | 42089 | 16797 | 336 |
1701963 | 1701963 | 2021-09-09 | Monroe | Pennsylvania | 42089 | 16671 | 334 |
1698714 | 1698714 | 2021-09-08 | Monroe | Pennsylvania | 42089 | 16570 | 333 |
1695466 | 1695466 | 2021-09-07 | Monroe | Pennsylvania | 42089 | 16526 | 332 |
1692218 | 1692218 | 2021-09-06 | Monroe | Pennsylvania | 42089 | 16483 | 332 |
1688969 | 1688969 | 2021-09-05 | Monroe | Pennsylvania | 42089 | 16455 | 332 |
1685719 | 1685719 | 2021-09-04 | Monroe | Pennsylvania | 42089 | 16414 | 332 |
1682468 | 1682468 | 2021-09-03 | Monroe | Pennsylvania | 42089 | 16334 | 332 |
1679218 | 1679218 | 2021-09-02 | Monroe | Pennsylvania | 42089 | 16265 | 330 |
1675970 | 1675970 | 2021-09-01 | Monroe | Pennsylvania | 42089 | 16191 | 327 |
1672723 | 1672723 | 2021-08-31 | Monroe | Pennsylvania | 42089 | 16115 | 327 |
1669475 | 1669475 | 2021-08-30 | Monroe | Pennsylvania | 42089 | 16072 | 327 |
1666228 | 1666228 | 2021-08-29 | Monroe | Pennsylvania | 42089 | 16040 | 327 |
1662980 | 1662980 | 2021-08-28 | Monroe | Pennsylvania | 42089 | 16021 | 326 |
1659732 | 1659732 | 2021-08-27 | Monroe | Pennsylvania | 42089 | 15978 | 326 |
1656483 | 1656483 | 2021-08-26 | Monroe | Pennsylvania | 42089 | 15919 | 325 |
1653236 | 1653236 | 2021-08-25 | Monroe | Pennsylvania | 42089 | 15880 | 324 |
1649989 | 1649989 | 2021-08-24 | Monroe | Pennsylvania | 42089 | 15836 | 323 |
1646740 | 1646740 | 2021-08-23 | Monroe | Pennsylvania | 42089 | 15793 | 323 |
1643491 | 1643491 | 2021-08-22 | Monroe | Pennsylvania | 42089 | 15764 | 323 |
1640241 | 1640241 | 2021-08-21 | Monroe | Pennsylvania | 42089 | 15734 | 323 |
1636991 | 1636991 | 2021-08-20 | Monroe | Pennsylvania | 42089 | 15689 | 323 |
1633741 | 1633741 | 2021-08-19 | Monroe | Pennsylvania | 42089 | 15661 | 323 |
1630494 | 1630494 | 2021-08-18 | Monroe | Pennsylvania | 42089 | 15622 | 323 |
1627247 | 1627247 | 2021-08-17 | Monroe | Pennsylvania | 42089 | 15595 | 323 |
1624000 | 1624000 | 2021-08-16 | Monroe | Pennsylvania | 42089 | 15557 | 323 |
1620753 | 1620753 | 2021-08-15 | Monroe | Pennsylvania | 42089 | 15528 | 323 |
1617505 | 1617505 | 2021-08-14 | Monroe | Pennsylvania | 42089 | 15479 | 323 |
1614257 | 1614257 | 2021-08-13 | Monroe | Pennsylvania | 42089 | 15433 | 323 |
1611008 | 1611008 | 2021-08-12 | Monroe | Pennsylvania | 42089 | 15409 | 323 |
1607760 | 1607760 | 2021-08-11 | Monroe | Pennsylvania | 42089 | 15379 | 323 |
1604511 | 1604511 | 2021-08-10 | Monroe | Pennsylvania | 42089 | 15349 | 323 |
1601262 | 1601262 | 2021-08-09 | Monroe | Pennsylvania | 42089 | 15313 | 322 |
1598014 | 1598014 | 2021-08-08 | Monroe | Pennsylvania | 42089 | 15275 | 322 |
1594765 | 1594765 | 2021-08-07 | Monroe | Pennsylvania | 42089 | 15275 | 322 |
1591516 | 1591516 | 2021-08-06 | Monroe | Pennsylvania | 42089 | 15234 | 322 |
1588267 | 1588267 | 2021-08-05 | Monroe | Pennsylvania | 42089 | 15203 | 322 |
1585017 | 1585017 | 2021-08-04 | Monroe | Pennsylvania | 42089 | 15191 | 322 |
1581767 | 1581767 | 2021-08-03 | Monroe | Pennsylvania | 42089 | 15161 | 322 |
1578518 | 1578518 | 2021-08-02 | Monroe | Pennsylvania | 42089 | 15120 | 321 |
1575270 | 1575270 | 2021-08-01 | Monroe | Pennsylvania | 42089 | 15101 | 321 |
1572022 | 1572022 | 2021-07-31 | Monroe | Pennsylvania | 42089 | 15068 | 321 |
1568774 | 1568774 | 2021-07-30 | Monroe | Pennsylvania | 42089 | 15068 | 321 |
1565526 | 1565526 | 2021-07-29 | Monroe | Pennsylvania | 42089 | 15052 | 321 |
1562278 | 1562278 | 2021-07-28 | Monroe | Pennsylvania | 42089 | 15037 | 321 |
1559030 | 1559030 | 2021-07-27 | Monroe | Pennsylvania | 42089 | 15023 | 321 |
1555783 | 1555783 | 2021-07-26 | Monroe | Pennsylvania | 42089 | 15006 | 321 |
1552536 | 1552536 | 2021-07-25 | Monroe | Pennsylvania | 42089 | 14997 | 321 |
1549289 | 1549289 | 2021-07-24 | Monroe | Pennsylvania | 42089 | 14991 | 321 |
1546042 | 1546042 | 2021-07-23 | Monroe | Pennsylvania | 42089 | 14976 | 322 |
1542795 | 1542795 | 2021-07-22 | Monroe | Pennsylvania | 42089 | 14964 | 322 |
1539547 | 1539547 | 2021-07-21 | Monroe | Pennsylvania | 42089 | 14948 | 322 |
1536300 | 1536300 | 2021-07-20 | Monroe | Pennsylvania | 42089 | 14939 | 322 |
1533052 | 1533052 | 2021-07-19 | Monroe | Pennsylvania | 42089 | 14923 | 322 |
1529805 | 1529805 | 2021-07-18 | Monroe | Pennsylvania | 42089 | 14909 | 322 |
1526558 | 1526558 | 2021-07-17 | Monroe | Pennsylvania | 42089 | 14903 | 322 |
1523311 | 1523311 | 2021-07-16 | Monroe | Pennsylvania | 42089 | 14889 | 322 |
1520063 | 1520063 | 2021-07-15 | Monroe | Pennsylvania | 42089 | 14882 | 322 |
1516815 | 1516815 | 2021-07-14 | Monroe | Pennsylvania | 42089 | 14875 | 322 |
1513568 | 1513568 | 2021-07-13 | Monroe | Pennsylvania | 42089 | 14872 | 322 |
1510322 | 1510322 | 2021-07-12 | Monroe | Pennsylvania | 42089 | 14866 | 321 |
1507075 | 1507075 | 2021-07-11 | Monroe | Pennsylvania | 42089 | 14865 | 321 |
1503829 | 1503829 | 2021-07-10 | Monroe | Pennsylvania | 42089 | 14855 | 321 |
1500583 | 1500583 | 2021-07-09 | Monroe | Pennsylvania | 42089 | 14852 | 321 |
1497337 | 1497337 | 2021-07-08 | Monroe | Pennsylvania | 42089 | 14848 | 321 |
1494090 | 1494090 | 2021-07-07 | Monroe | Pennsylvania | 42089 | 14843 | 321 |
1490843 | 1490843 | 2021-07-06 | Monroe | Pennsylvania | 42089 | 14841 | 321 |
1487596 | 1487596 | 2021-07-05 | Monroe | Pennsylvania | 42089 | 14839 | 321 |
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);