ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Cumberland" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812402 | 1812402 | 2021-10-13 | Cumberland | Pennsylvania | 42041 | 26792 | 591 |
1809153 | 1809153 | 2021-10-12 | Cumberland | Pennsylvania | 42041 | 26666 | 587 |
1805903 | 1805903 | 2021-10-11 | Cumberland | Pennsylvania | 42041 | 26585 | 582 |
1802653 | 1802653 | 2021-10-10 | Cumberland | Pennsylvania | 42041 | 26514 | 582 |
1799404 | 1799404 | 2021-10-09 | Cumberland | Pennsylvania | 42041 | 26430 | 582 |
1796155 | 1796155 | 2021-10-08 | Cumberland | Pennsylvania | 42041 | 26298 | 582 |
1792906 | 1792906 | 2021-10-07 | Cumberland | Pennsylvania | 42041 | 26153 | 580 |
1789657 | 1789657 | 2021-10-06 | Cumberland | Pennsylvania | 42041 | 26041 | 574 |
1786409 | 1786409 | 2021-10-05 | Cumberland | Pennsylvania | 42041 | 25945 | 568 |
1783160 | 1783160 | 2021-10-04 | Cumberland | Pennsylvania | 42041 | 25795 | 567 |
1779911 | 1779911 | 2021-10-03 | Cumberland | Pennsylvania | 42041 | 25646 | 567 |
1776661 | 1776661 | 2021-10-02 | Cumberland | Pennsylvania | 42041 | 25482 | 567 |
1773411 | 1773411 | 2021-10-01 | Cumberland | Pennsylvania | 42041 | 25380 | 567 |
1770161 | 1770161 | 2021-09-30 | Cumberland | Pennsylvania | 42041 | 25273 | 567 |
1766912 | 1766912 | 2021-09-29 | Cumberland | Pennsylvania | 42041 | 25165 | 566 |
1763663 | 1763663 | 2021-09-28 | Cumberland | Pennsylvania | 42041 | 25060 | 560 |
1760414 | 1760414 | 2021-09-27 | Cumberland | Pennsylvania | 42041 | 24951 | 559 |
1757166 | 1757166 | 2021-09-26 | Cumberland | Pennsylvania | 42041 | 24856 | 559 |
1753918 | 1753918 | 2021-09-25 | Cumberland | Pennsylvania | 42041 | 24752 | 557 |
1750670 | 1750670 | 2021-09-24 | Cumberland | Pennsylvania | 42041 | 24565 | 556 |
1747421 | 1747421 | 2021-09-23 | Cumberland | Pennsylvania | 42041 | 24449 | 556 |
1744171 | 1744171 | 2021-09-22 | Cumberland | Pennsylvania | 42041 | 24343 | 556 |
1740922 | 1740922 | 2021-09-21 | Cumberland | Pennsylvania | 42041 | 24229 | 555 |
1737673 | 1737673 | 2021-09-20 | Cumberland | Pennsylvania | 42041 | 24140 | 553 |
1734423 | 1734423 | 2021-09-19 | Cumberland | Pennsylvania | 42041 | 24081 | 553 |
1731173 | 1731173 | 2021-09-18 | Cumberland | Pennsylvania | 42041 | 23990 | 553 |
1727923 | 1727923 | 2021-09-17 | Cumberland | Pennsylvania | 42041 | 23860 | 552 |
1724674 | 1724674 | 2021-09-16 | Cumberland | Pennsylvania | 42041 | 23705 | 550 |
1721425 | 1721425 | 2021-09-15 | Cumberland | Pennsylvania | 42041 | 23601 | 550 |
1718177 | 1718177 | 2021-09-14 | Cumberland | Pennsylvania | 42041 | 23492 | 548 |
1714929 | 1714929 | 2021-09-13 | Cumberland | Pennsylvania | 42041 | 23411 | 548 |
1711683 | 1711683 | 2021-09-12 | Cumberland | Pennsylvania | 42041 | 23356 | 548 |
1708436 | 1708436 | 2021-09-11 | Cumberland | Pennsylvania | 42041 | 23256 | 548 |
1705189 | 1705189 | 2021-09-10 | Cumberland | Pennsylvania | 42041 | 23152 | 548 |
1701939 | 1701939 | 2021-09-09 | Cumberland | Pennsylvania | 42041 | 23055 | 548 |
1698690 | 1698690 | 2021-09-08 | Cumberland | Pennsylvania | 42041 | 22958 | 548 |
1695442 | 1695442 | 2021-09-07 | Cumberland | Pennsylvania | 42041 | 22877 | 547 |
1692194 | 1692194 | 2021-09-06 | Cumberland | Pennsylvania | 42041 | 22801 | 547 |
1688945 | 1688945 | 2021-09-05 | Cumberland | Pennsylvania | 42041 | 22735 | 547 |
1685695 | 1685695 | 2021-09-04 | Cumberland | Pennsylvania | 42041 | 22659 | 547 |
1682444 | 1682444 | 2021-09-03 | Cumberland | Pennsylvania | 42041 | 22558 | 547 |
1679194 | 1679194 | 2021-09-02 | Cumberland | Pennsylvania | 42041 | 22497 | 546 |
1675946 | 1675946 | 2021-09-01 | Cumberland | Pennsylvania | 42041 | 22423 | 543 |
1672699 | 1672699 | 2021-08-31 | Cumberland | Pennsylvania | 42041 | 22331 | 543 |
1669451 | 1669451 | 2021-08-30 | Cumberland | Pennsylvania | 42041 | 22284 | 542 |
1666204 | 1666204 | 2021-08-29 | Cumberland | Pennsylvania | 42041 | 22239 | 542 |
1662956 | 1662956 | 2021-08-28 | Cumberland | Pennsylvania | 42041 | 22138 | 542 |
1659708 | 1659708 | 2021-08-27 | Cumberland | Pennsylvania | 42041 | 22055 | 540 |
1656459 | 1656459 | 2021-08-26 | Cumberland | Pennsylvania | 42041 | 21951 | 540 |
1653212 | 1653212 | 2021-08-25 | Cumberland | Pennsylvania | 42041 | 21885 | 538 |
1649965 | 1649965 | 2021-08-24 | Cumberland | Pennsylvania | 42041 | 21824 | 536 |
1646716 | 1646716 | 2021-08-23 | Cumberland | Pennsylvania | 42041 | 21775 | 535 |
1643467 | 1643467 | 2021-08-22 | Cumberland | Pennsylvania | 42041 | 21738 | 535 |
1640217 | 1640217 | 2021-08-21 | Cumberland | Pennsylvania | 42041 | 21694 | 535 |
1636967 | 1636967 | 2021-08-20 | Cumberland | Pennsylvania | 42041 | 21640 | 535 |
1633717 | 1633717 | 2021-08-19 | Cumberland | Pennsylvania | 42041 | 21587 | 535 |
1630470 | 1630470 | 2021-08-18 | Cumberland | Pennsylvania | 42041 | 21539 | 535 |
1627223 | 1627223 | 2021-08-17 | Cumberland | Pennsylvania | 42041 | 21495 | 533 |
1623976 | 1623976 | 2021-08-16 | Cumberland | Pennsylvania | 42041 | 21441 | 532 |
1620729 | 1620729 | 2021-08-15 | Cumberland | Pennsylvania | 42041 | 21418 | 532 |
1617481 | 1617481 | 2021-08-14 | Cumberland | Pennsylvania | 42041 | 21355 | 532 |
1614233 | 1614233 | 2021-08-13 | Cumberland | Pennsylvania | 42041 | 21312 | 532 |
1610984 | 1610984 | 2021-08-12 | Cumberland | Pennsylvania | 42041 | 21275 | 532 |
1607736 | 1607736 | 2021-08-11 | Cumberland | Pennsylvania | 42041 | 21236 | 531 |
1604487 | 1604487 | 2021-08-10 | Cumberland | Pennsylvania | 42041 | 21202 | 531 |
1601238 | 1601238 | 2021-08-09 | Cumberland | Pennsylvania | 42041 | 21165 | 531 |
1597990 | 1597990 | 2021-08-08 | Cumberland | Pennsylvania | 42041 | 21108 | 531 |
1594741 | 1594741 | 2021-08-07 | Cumberland | Pennsylvania | 42041 | 21108 | 531 |
1591492 | 1591492 | 2021-08-06 | Cumberland | Pennsylvania | 42041 | 21065 | 531 |
1588243 | 1588243 | 2021-08-05 | Cumberland | Pennsylvania | 42041 | 21021 | 531 |
1584993 | 1584993 | 2021-08-04 | Cumberland | Pennsylvania | 42041 | 20982 | 531 |
1581743 | 1581743 | 2021-08-03 | Cumberland | Pennsylvania | 42041 | 20951 | 531 |
1578494 | 1578494 | 2021-08-02 | Cumberland | Pennsylvania | 42041 | 20920 | 529 |
1575246 | 1575246 | 2021-08-01 | Cumberland | Pennsylvania | 42041 | 20900 | 529 |
1571998 | 1571998 | 2021-07-31 | Cumberland | Pennsylvania | 42041 | 20853 | 529 |
1568750 | 1568750 | 2021-07-30 | Cumberland | Pennsylvania | 42041 | 20853 | 529 |
1565502 | 1565502 | 2021-07-29 | Cumberland | Pennsylvania | 42041 | 20843 | 528 |
1562254 | 1562254 | 2021-07-28 | Cumberland | Pennsylvania | 42041 | 20815 | 528 |
1559006 | 1559006 | 2021-07-27 | Cumberland | Pennsylvania | 42041 | 20801 | 528 |
1555759 | 1555759 | 2021-07-26 | Cumberland | Pennsylvania | 42041 | 20790 | 528 |
1552512 | 1552512 | 2021-07-25 | Cumberland | Pennsylvania | 42041 | 20778 | 528 |
1549265 | 1549265 | 2021-07-24 | Cumberland | Pennsylvania | 42041 | 20761 | 528 |
1546018 | 1546018 | 2021-07-23 | Cumberland | Pennsylvania | 42041 | 20748 | 528 |
1542771 | 1542771 | 2021-07-22 | Cumberland | Pennsylvania | 42041 | 20736 | 528 |
1539523 | 1539523 | 2021-07-21 | Cumberland | Pennsylvania | 42041 | 20721 | 527 |
1536276 | 1536276 | 2021-07-20 | Cumberland | Pennsylvania | 42041 | 20706 | 527 |
1533028 | 1533028 | 2021-07-19 | Cumberland | Pennsylvania | 42041 | 20698 | 527 |
1529781 | 1529781 | 2021-07-18 | Cumberland | Pennsylvania | 42041 | 20696 | 527 |
1526534 | 1526534 | 2021-07-17 | Cumberland | Pennsylvania | 42041 | 20693 | 527 |
1523287 | 1523287 | 2021-07-16 | Cumberland | Pennsylvania | 42041 | 20688 | 527 |
1520039 | 1520039 | 2021-07-15 | Cumberland | Pennsylvania | 42041 | 20680 | 527 |
1516791 | 1516791 | 2021-07-14 | Cumberland | Pennsylvania | 42041 | 20671 | 526 |
1513544 | 1513544 | 2021-07-13 | Cumberland | Pennsylvania | 42041 | 20668 | 526 |
1510298 | 1510298 | 2021-07-12 | Cumberland | Pennsylvania | 42041 | 20655 | 526 |
1507051 | 1507051 | 2021-07-11 | Cumberland | Pennsylvania | 42041 | 20650 | 526 |
1503805 | 1503805 | 2021-07-10 | Cumberland | Pennsylvania | 42041 | 20646 | 526 |
1500559 | 1500559 | 2021-07-09 | Cumberland | Pennsylvania | 42041 | 20640 | 526 |
1497313 | 1497313 | 2021-07-08 | Cumberland | Pennsylvania | 42041 | 20640 | 526 |
1494066 | 1494066 | 2021-07-07 | Cumberland | Pennsylvania | 42041 | 20636 | 526 |
1490819 | 1490819 | 2021-07-06 | Cumberland | Pennsylvania | 42041 | 20633 | 526 |
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);