ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Westmoreland" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718221 | 1718221 | 2021-09-14 | Westmoreland | Pennsylvania | 42129 | 38280 | 814 |
1714973 | 1714973 | 2021-09-13 | Westmoreland | Pennsylvania | 42129 | 38211 | 810 |
1711727 | 1711727 | 2021-09-12 | Westmoreland | Pennsylvania | 42129 | 38091 | 810 |
1708480 | 1708480 | 2021-09-11 | Westmoreland | Pennsylvania | 42129 | 37986 | 810 |
1705233 | 1705233 | 2021-09-10 | Westmoreland | Pennsylvania | 42129 | 37831 | 810 |
1701983 | 1701983 | 2021-09-09 | Westmoreland | Pennsylvania | 42129 | 37689 | 809 |
1698734 | 1698734 | 2021-09-08 | Westmoreland | Pennsylvania | 42129 | 37563 | 805 |
1695486 | 1695486 | 2021-09-07 | Westmoreland | Pennsylvania | 42129 | 37406 | 804 |
1692238 | 1692238 | 2021-09-06 | Westmoreland | Pennsylvania | 42129 | 37341 | 804 |
1688989 | 1688989 | 2021-09-05 | Westmoreland | Pennsylvania | 42129 | 37293 | 804 |
1685739 | 1685739 | 2021-09-04 | Westmoreland | Pennsylvania | 42129 | 37202 | 804 |
1682488 | 1682488 | 2021-09-03 | Westmoreland | Pennsylvania | 42129 | 37062 | 803 |
1679238 | 1679238 | 2021-09-02 | Westmoreland | Pennsylvania | 42129 | 36940 | 802 |
1675990 | 1675990 | 2021-09-01 | Westmoreland | Pennsylvania | 42129 | 36768 | 795 |
1672743 | 1672743 | 2021-08-31 | Westmoreland | Pennsylvania | 42129 | 36717 | 795 |
1669495 | 1669495 | 2021-08-30 | Westmoreland | Pennsylvania | 42129 | 36626 | 793 |
1666248 | 1666248 | 2021-08-29 | Westmoreland | Pennsylvania | 42129 | 36501 | 793 |
1663000 | 1663000 | 2021-08-28 | Westmoreland | Pennsylvania | 42129 | 36446 | 792 |
1659752 | 1659752 | 2021-08-27 | Westmoreland | Pennsylvania | 42129 | 36333 | 792 |
1656503 | 1656503 | 2021-08-26 | Westmoreland | Pennsylvania | 42129 | 36252 | 792 |
1653256 | 1653256 | 2021-08-25 | Westmoreland | Pennsylvania | 42129 | 36154 | 792 |
1650009 | 1650009 | 2021-08-24 | Westmoreland | Pennsylvania | 42129 | 36018 | 790 |
1646760 | 1646760 | 2021-08-23 | Westmoreland | Pennsylvania | 42129 | 35926 | 790 |
1643511 | 1643511 | 2021-08-22 | Westmoreland | Pennsylvania | 42129 | 35844 | 790 |
1640261 | 1640261 | 2021-08-21 | Westmoreland | Pennsylvania | 42129 | 35785 | 790 |
1637011 | 1637011 | 2021-08-20 | Westmoreland | Pennsylvania | 42129 | 35709 | 789 |
1633761 | 1633761 | 2021-08-19 | Westmoreland | Pennsylvania | 42129 | 35638 | 789 |
1630514 | 1630514 | 2021-08-18 | Westmoreland | Pennsylvania | 42129 | 35458 | 788 |
1627267 | 1627267 | 2021-08-17 | Westmoreland | Pennsylvania | 42129 | 35407 | 788 |
1624020 | 1624020 | 2021-08-16 | Westmoreland | Pennsylvania | 42129 | 35371 | 785 |
1620773 | 1620773 | 2021-08-15 | Westmoreland | Pennsylvania | 42129 | 35328 | 785 |
1617525 | 1617525 | 2021-08-14 | Westmoreland | Pennsylvania | 42129 | 35272 | 785 |
1614277 | 1614277 | 2021-08-13 | Westmoreland | Pennsylvania | 42129 | 35196 | 785 |
1611028 | 1611028 | 2021-08-12 | Westmoreland | Pennsylvania | 42129 | 35164 | 784 |
1607780 | 1607780 | 2021-08-11 | Westmoreland | Pennsylvania | 42129 | 35122 | 784 |
1604531 | 1604531 | 2021-08-10 | Westmoreland | Pennsylvania | 42129 | 35069 | 784 |
1601282 | 1601282 | 2021-08-09 | Westmoreland | Pennsylvania | 42129 | 34996 | 784 |
1598034 | 1598034 | 2021-08-08 | Westmoreland | Pennsylvania | 42129 | 34957 | 784 |
1594785 | 1594785 | 2021-08-07 | Westmoreland | Pennsylvania | 42129 | 34957 | 784 |
1591536 | 1591536 | 2021-08-06 | Westmoreland | Pennsylvania | 42129 | 34938 | 784 |
1588287 | 1588287 | 2021-08-05 | Westmoreland | Pennsylvania | 42129 | 34886 | 784 |
1585037 | 1585037 | 2021-08-04 | Westmoreland | Pennsylvania | 42129 | 34852 | 784 |
1581787 | 1581787 | 2021-08-03 | Westmoreland | Pennsylvania | 42129 | 34825 | 783 |
1578538 | 1578538 | 2021-08-02 | Westmoreland | Pennsylvania | 42129 | 34794 | 782 |
1575290 | 1575290 | 2021-08-01 | Westmoreland | Pennsylvania | 42129 | 34765 | 781 |
1572042 | 1572042 | 2021-07-31 | Westmoreland | Pennsylvania | 42129 | 34712 | 781 |
1568794 | 1568794 | 2021-07-30 | Westmoreland | Pennsylvania | 42129 | 34712 | 781 |
1565546 | 1565546 | 2021-07-29 | Westmoreland | Pennsylvania | 42129 | 34688 | 781 |
1562298 | 1562298 | 2021-07-28 | Westmoreland | Pennsylvania | 42129 | 34657 | 781 |
1559050 | 1559050 | 2021-07-27 | Westmoreland | Pennsylvania | 42129 | 34641 | 781 |
1555803 | 1555803 | 2021-07-26 | Westmoreland | Pennsylvania | 42129 | 34617 | 781 |
1552556 | 1552556 | 2021-07-25 | Westmoreland | Pennsylvania | 42129 | 34609 | 781 |
1549309 | 1549309 | 2021-07-24 | Westmoreland | Pennsylvania | 42129 | 34594 | 781 |
1546062 | 1546062 | 2021-07-23 | Westmoreland | Pennsylvania | 42129 | 34585 | 781 |
1542815 | 1542815 | 2021-07-22 | Westmoreland | Pennsylvania | 42129 | 34576 | 781 |
1539567 | 1539567 | 2021-07-21 | Westmoreland | Pennsylvania | 42129 | 34563 | 781 |
1536320 | 1536320 | 2021-07-20 | Westmoreland | Pennsylvania | 42129 | 34552 | 781 |
1533072 | 1533072 | 2021-07-19 | Westmoreland | Pennsylvania | 42129 | 34535 | 781 |
1529825 | 1529825 | 2021-07-18 | Westmoreland | Pennsylvania | 42129 | 34528 | 780 |
1526578 | 1526578 | 2021-07-17 | Westmoreland | Pennsylvania | 42129 | 34516 | 780 |
1523331 | 1523331 | 2021-07-16 | Westmoreland | Pennsylvania | 42129 | 34502 | 780 |
1520083 | 1520083 | 2021-07-15 | Westmoreland | Pennsylvania | 42129 | 34490 | 779 |
1516835 | 1516835 | 2021-07-14 | Westmoreland | Pennsylvania | 42129 | 34484 | 779 |
1513588 | 1513588 | 2021-07-13 | Westmoreland | Pennsylvania | 42129 | 34482 | 779 |
1510342 | 1510342 | 2021-07-12 | Westmoreland | Pennsylvania | 42129 | 34475 | 779 |
1507095 | 1507095 | 2021-07-11 | Westmoreland | Pennsylvania | 42129 | 34470 | 779 |
1503849 | 1503849 | 2021-07-10 | Westmoreland | Pennsylvania | 42129 | 34465 | 779 |
1500603 | 1500603 | 2021-07-09 | Westmoreland | Pennsylvania | 42129 | 34462 | 779 |
1497357 | 1497357 | 2021-07-08 | Westmoreland | Pennsylvania | 42129 | 34455 | 779 |
1494110 | 1494110 | 2021-07-07 | Westmoreland | Pennsylvania | 42129 | 34448 | 779 |
1490863 | 1490863 | 2021-07-06 | Westmoreland | Pennsylvania | 42129 | 34448 | 779 |
1487616 | 1487616 | 2021-07-05 | Westmoreland | Pennsylvania | 42129 | 34445 | 779 |
1484369 | 1484369 | 2021-07-04 | Westmoreland | Pennsylvania | 42129 | 34442 | 779 |
1481123 | 1481123 | 2021-07-03 | Westmoreland | Pennsylvania | 42129 | 34441 | 778 |
1477876 | 1477876 | 2021-07-02 | Westmoreland | Pennsylvania | 42129 | 34434 | 778 |
1474630 | 1474630 | 2021-07-01 | Westmoreland | Pennsylvania | 42129 | 34430 | 778 |
1471384 | 1471384 | 2021-06-30 | Westmoreland | Pennsylvania | 42129 | 34426 | 777 |
1468139 | 1468139 | 2021-06-29 | Westmoreland | Pennsylvania | 42129 | 34417 | 777 |
1464894 | 1464894 | 2021-06-28 | Westmoreland | Pennsylvania | 42129 | 34415 | 776 |
1461649 | 1461649 | 2021-06-27 | Westmoreland | Pennsylvania | 42129 | 34410 | 776 |
1458404 | 1458404 | 2021-06-26 | Westmoreland | Pennsylvania | 42129 | 34409 | 775 |
1455159 | 1455159 | 2021-06-25 | Westmoreland | Pennsylvania | 42129 | 34405 | 774 |
1451914 | 1451914 | 2021-06-24 | Westmoreland | Pennsylvania | 42129 | 34398 | 773 |
1448668 | 1448668 | 2021-06-23 | Westmoreland | Pennsylvania | 42129 | 34386 | 772 |
1445423 | 1445423 | 2021-06-22 | Westmoreland | Pennsylvania | 42129 | 34383 | 772 |
1442178 | 1442178 | 2021-06-21 | Westmoreland | Pennsylvania | 42129 | 34381 | 771 |
1438933 | 1438933 | 2021-06-20 | Westmoreland | Pennsylvania | 42129 | 34379 | 771 |
1435686 | 1435686 | 2021-06-19 | Westmoreland | Pennsylvania | 42129 | 34376 | 771 |
1432439 | 1432439 | 2021-06-18 | Westmoreland | Pennsylvania | 42129 | 34376 | 771 |
1429193 | 1429193 | 2021-06-17 | Westmoreland | Pennsylvania | 42129 | 34375 | 771 |
1425948 | 1425948 | 2021-06-16 | Westmoreland | Pennsylvania | 42129 | 34368 | 771 |
1422701 | 1422701 | 2021-06-15 | Westmoreland | Pennsylvania | 42129 | 34339 | 771 |
1419455 | 1419455 | 2021-06-14 | Westmoreland | Pennsylvania | 42129 | 34295 | 770 |
1416210 | 1416210 | 2021-06-13 | Westmoreland | Pennsylvania | 42129 | 34290 | 770 |
1412964 | 1412964 | 2021-06-12 | Westmoreland | Pennsylvania | 42129 | 34287 | 769 |
1409719 | 1409719 | 2021-06-11 | Westmoreland | Pennsylvania | 42129 | 34280 | 769 |
1406474 | 1406474 | 2021-06-10 | Westmoreland | Pennsylvania | 42129 | 34258 | 769 |
1403228 | 1403228 | 2021-06-09 | Westmoreland | Pennsylvania | 42129 | 34239 | 769 |
1399983 | 1399983 | 2021-06-08 | Westmoreland | Pennsylvania | 42129 | 34236 | 769 |
1396738 | 1396738 | 2021-06-07 | Westmoreland | Pennsylvania | 42129 | 34228 | 769 |
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);