ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42055 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1838400 | 1838400 | 2021-10-21 | Franklin | Pennsylvania | 42055 | 21375 | 447 |
1835151 | 1835151 | 2021-10-20 | Franklin | Pennsylvania | 42055 | 21328 | 444 |
1831902 | 1831902 | 2021-10-19 | Franklin | Pennsylvania | 42055 | 21284 | 438 |
1828653 | 1828653 | 2021-10-18 | Franklin | Pennsylvania | 42055 | 21165 | 436 |
1825404 | 1825404 | 2021-10-17 | Franklin | Pennsylvania | 42055 | 21138 | 432 |
1822155 | 1822155 | 2021-10-16 | Franklin | Pennsylvania | 42055 | 21081 | 432 |
1818906 | 1818906 | 2021-10-15 | Franklin | Pennsylvania | 42055 | 21028 | 432 |
1815657 | 1815657 | 2021-10-14 | Franklin | Pennsylvania | 42055 | 20902 | 431 |
1812409 | 1812409 | 2021-10-13 | Franklin | Pennsylvania | 42055 | 20843 | 430 |
1809160 | 1809160 | 2021-10-12 | Franklin | Pennsylvania | 42055 | 20785 | 427 |
1805910 | 1805910 | 2021-10-11 | Franklin | Pennsylvania | 42055 | 20690 | 426 |
1802660 | 1802660 | 2021-10-10 | Franklin | Pennsylvania | 42055 | 20660 | 426 |
1799411 | 1799411 | 2021-10-09 | Franklin | Pennsylvania | 42055 | 20611 | 426 |
1796162 | 1796162 | 2021-10-08 | Franklin | Pennsylvania | 42055 | 20540 | 426 |
1792913 | 1792913 | 2021-10-07 | Franklin | Pennsylvania | 42055 | 20448 | 426 |
1789664 | 1789664 | 2021-10-06 | Franklin | Pennsylvania | 42055 | 20341 | 423 |
1786416 | 1786416 | 2021-10-05 | Franklin | Pennsylvania | 42055 | 20214 | 421 |
1783167 | 1783167 | 2021-10-04 | Franklin | Pennsylvania | 42055 | 20104 | 420 |
1779918 | 1779918 | 2021-10-03 | Franklin | Pennsylvania | 42055 | 20041 | 420 |
1776668 | 1776668 | 2021-10-02 | Franklin | Pennsylvania | 42055 | 19966 | 418 |
1773418 | 1773418 | 2021-10-01 | Franklin | Pennsylvania | 42055 | 19922 | 415 |
1770168 | 1770168 | 2021-09-30 | Franklin | Pennsylvania | 42055 | 19782 | 414 |
1766919 | 1766919 | 2021-09-29 | Franklin | Pennsylvania | 42055 | 19707 | 412 |
1763670 | 1763670 | 2021-09-28 | Franklin | Pennsylvania | 42055 | 19612 | 410 |
1760421 | 1760421 | 2021-09-27 | Franklin | Pennsylvania | 42055 | 19403 | 409 |
1757173 | 1757173 | 2021-09-26 | Franklin | Pennsylvania | 42055 | 19341 | 407 |
1753925 | 1753925 | 2021-09-25 | Franklin | Pennsylvania | 42055 | 19272 | 407 |
1750677 | 1750677 | 2021-09-24 | Franklin | Pennsylvania | 42055 | 19192 | 406 |
1747428 | 1747428 | 2021-09-23 | Franklin | Pennsylvania | 42055 | 19092 | 405 |
1744178 | 1744178 | 2021-09-22 | Franklin | Pennsylvania | 42055 | 18951 | 404 |
1740929 | 1740929 | 2021-09-21 | Franklin | Pennsylvania | 42055 | 18891 | 401 |
1737680 | 1737680 | 2021-09-20 | Franklin | Pennsylvania | 42055 | 18747 | 398 |
1734430 | 1734430 | 2021-09-19 | Franklin | Pennsylvania | 42055 | 18707 | 398 |
1731180 | 1731180 | 2021-09-18 | Franklin | Pennsylvania | 42055 | 18621 | 397 |
1727930 | 1727930 | 2021-09-17 | Franklin | Pennsylvania | 42055 | 18479 | 396 |
1724681 | 1724681 | 2021-09-16 | Franklin | Pennsylvania | 42055 | 18337 | 395 |
1721432 | 1721432 | 2021-09-15 | Franklin | Pennsylvania | 42055 | 18200 | 394 |
1718184 | 1718184 | 2021-09-14 | Franklin | Pennsylvania | 42055 | 18137 | 392 |
1714936 | 1714936 | 2021-09-13 | Franklin | Pennsylvania | 42055 | 17954 | 391 |
1711690 | 1711690 | 2021-09-12 | Franklin | Pennsylvania | 42055 | 17929 | 391 |
1708443 | 1708443 | 2021-09-11 | Franklin | Pennsylvania | 42055 | 17858 | 391 |
1705196 | 1705196 | 2021-09-10 | Franklin | Pennsylvania | 42055 | 17731 | 388 |
1701946 | 1701946 | 2021-09-09 | Franklin | Pennsylvania | 42055 | 17621 | 386 |
1698697 | 1698697 | 2021-09-08 | Franklin | Pennsylvania | 42055 | 17481 | 384 |
1695449 | 1695449 | 2021-09-07 | Franklin | Pennsylvania | 42055 | 17272 | 383 |
1692201 | 1692201 | 2021-09-06 | Franklin | Pennsylvania | 42055 | 17195 | 383 |
1688952 | 1688952 | 2021-09-05 | Franklin | Pennsylvania | 42055 | 17166 | 383 |
1685702 | 1685702 | 2021-09-04 | Franklin | Pennsylvania | 42055 | 17096 | 382 |
1682451 | 1682451 | 2021-09-03 | Franklin | Pennsylvania | 42055 | 17007 | 381 |
1679201 | 1679201 | 2021-09-02 | Franklin | Pennsylvania | 42055 | 16925 | 381 |
1675953 | 1675953 | 2021-09-01 | Franklin | Pennsylvania | 42055 | 16823 | 380 |
1672706 | 1672706 | 2021-08-31 | Franklin | Pennsylvania | 42055 | 16733 | 380 |
1669458 | 1669458 | 2021-08-30 | Franklin | Pennsylvania | 42055 | 16641 | 380 |
1666211 | 1666211 | 2021-08-29 | Franklin | Pennsylvania | 42055 | 16584 | 380 |
1662963 | 1662963 | 2021-08-28 | Franklin | Pennsylvania | 42055 | 16552 | 380 |
1659715 | 1659715 | 2021-08-27 | Franklin | Pennsylvania | 42055 | 16485 | 380 |
1656466 | 1656466 | 2021-08-26 | Franklin | Pennsylvania | 42055 | 16422 | 380 |
1653219 | 1653219 | 2021-08-25 | Franklin | Pennsylvania | 42055 | 16369 | 379 |
1649972 | 1649972 | 2021-08-24 | Franklin | Pennsylvania | 42055 | 16333 | 379 |
1646723 | 1646723 | 2021-08-23 | Franklin | Pennsylvania | 42055 | 16247 | 379 |
1643474 | 1643474 | 2021-08-22 | Franklin | Pennsylvania | 42055 | 16214 | 379 |
1640224 | 1640224 | 2021-08-21 | Franklin | Pennsylvania | 42055 | 16177 | 379 |
1636974 | 1636974 | 2021-08-20 | Franklin | Pennsylvania | 42055 | 16127 | 379 |
1633724 | 1633724 | 2021-08-19 | Franklin | Pennsylvania | 42055 | 16095 | 378 |
1630477 | 1630477 | 2021-08-18 | Franklin | Pennsylvania | 42055 | 16029 | 378 |
1627230 | 1627230 | 2021-08-17 | Franklin | Pennsylvania | 42055 | 16001 | 377 |
1623983 | 1623983 | 2021-08-16 | Franklin | Pennsylvania | 42055 | 15947 | 377 |
1620736 | 1620736 | 2021-08-15 | Franklin | Pennsylvania | 42055 | 15922 | 377 |
1617488 | 1617488 | 2021-08-14 | Franklin | Pennsylvania | 42055 | 15902 | 377 |
1614240 | 1614240 | 2021-08-13 | Franklin | Pennsylvania | 42055 | 15878 | 377 |
1610991 | 1610991 | 2021-08-12 | Franklin | Pennsylvania | 42055 | 15864 | 377 |
1607743 | 1607743 | 2021-08-11 | Franklin | Pennsylvania | 42055 | 15827 | 377 |
1604494 | 1604494 | 2021-08-10 | Franklin | Pennsylvania | 42055 | 15804 | 377 |
1601245 | 1601245 | 2021-08-09 | Franklin | Pennsylvania | 42055 | 15757 | 377 |
1597997 | 1597997 | 2021-08-08 | Franklin | Pennsylvania | 42055 | 15731 | 377 |
1594748 | 1594748 | 2021-08-07 | Franklin | Pennsylvania | 42055 | 15731 | 377 |
1591499 | 1591499 | 2021-08-06 | Franklin | Pennsylvania | 42055 | 15705 | 377 |
1588250 | 1588250 | 2021-08-05 | Franklin | Pennsylvania | 42055 | 15688 | 377 |
1585000 | 1585000 | 2021-08-04 | Franklin | Pennsylvania | 42055 | 15664 | 377 |
1581750 | 1581750 | 2021-08-03 | Franklin | Pennsylvania | 42055 | 15643 | 377 |
1578501 | 1578501 | 2021-08-02 | Franklin | Pennsylvania | 42055 | 15614 | 377 |
1575253 | 1575253 | 2021-08-01 | Franklin | Pennsylvania | 42055 | 15607 | 377 |
1572005 | 1572005 | 2021-07-31 | Franklin | Pennsylvania | 42055 | 15584 | 377 |
1568757 | 1568757 | 2021-07-30 | Franklin | Pennsylvania | 42055 | 15584 | 377 |
1565509 | 1565509 | 2021-07-29 | Franklin | Pennsylvania | 42055 | 15574 | 377 |
1562261 | 1562261 | 2021-07-28 | Franklin | Pennsylvania | 42055 | 15566 | 377 |
1559013 | 1559013 | 2021-07-27 | Franklin | Pennsylvania | 42055 | 15559 | 377 |
1555766 | 1555766 | 2021-07-26 | Franklin | Pennsylvania | 42055 | 15542 | 377 |
1552519 | 1552519 | 2021-07-25 | Franklin | Pennsylvania | 42055 | 15540 | 377 |
1549272 | 1549272 | 2021-07-24 | Franklin | Pennsylvania | 42055 | 15537 | 377 |
1546025 | 1546025 | 2021-07-23 | Franklin | Pennsylvania | 42055 | 15534 | 377 |
1542778 | 1542778 | 2021-07-22 | Franklin | Pennsylvania | 42055 | 15533 | 377 |
1539530 | 1539530 | 2021-07-21 | Franklin | Pennsylvania | 42055 | 15531 | 376 |
1536283 | 1536283 | 2021-07-20 | Franklin | Pennsylvania | 42055 | 15528 | 376 |
1533035 | 1533035 | 2021-07-19 | Franklin | Pennsylvania | 42055 | 15521 | 376 |
1529788 | 1529788 | 2021-07-18 | Franklin | Pennsylvania | 42055 | 15520 | 376 |
1526541 | 1526541 | 2021-07-17 | Franklin | Pennsylvania | 42055 | 15519 | 376 |
1523294 | 1523294 | 2021-07-16 | Franklin | Pennsylvania | 42055 | 15514 | 376 |
1520046 | 1520046 | 2021-07-15 | Franklin | Pennsylvania | 42055 | 15514 | 376 |
1516798 | 1516798 | 2021-07-14 | Franklin | Pennsylvania | 42055 | 15512 | 376 |
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);