ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 42019 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718166 | 1718166 | 2021-09-14 | Butler | Pennsylvania | 42019 | 20467 | 434 |
1714918 | 1714918 | 2021-09-13 | Butler | Pennsylvania | 42019 | 20402 | 433 |
1711672 | 1711672 | 2021-09-12 | Butler | Pennsylvania | 42019 | 20321 | 433 |
1708425 | 1708425 | 2021-09-11 | Butler | Pennsylvania | 42019 | 20171 | 433 |
1705178 | 1705178 | 2021-09-10 | Butler | Pennsylvania | 42019 | 20023 | 433 |
1701928 | 1701928 | 2021-09-09 | Butler | Pennsylvania | 42019 | 19902 | 433 |
1698679 | 1698679 | 2021-09-08 | Butler | Pennsylvania | 42019 | 19790 | 433 |
1695431 | 1695431 | 2021-09-07 | Butler | Pennsylvania | 42019 | 19662 | 433 |
1692183 | 1692183 | 2021-09-06 | Butler | Pennsylvania | 42019 | 19602 | 433 |
1688934 | 1688934 | 2021-09-05 | Butler | Pennsylvania | 42019 | 19538 | 433 |
1685684 | 1685684 | 2021-09-04 | Butler | Pennsylvania | 42019 | 19464 | 433 |
1682433 | 1682433 | 2021-09-03 | Butler | Pennsylvania | 42019 | 19349 | 431 |
1679183 | 1679183 | 2021-09-02 | Butler | Pennsylvania | 42019 | 19248 | 430 |
1675935 | 1675935 | 2021-09-01 | Butler | Pennsylvania | 42019 | 19155 | 429 |
1672688 | 1672688 | 2021-08-31 | Butler | Pennsylvania | 42019 | 19080 | 429 |
1669440 | 1669440 | 2021-08-30 | Butler | Pennsylvania | 42019 | 19010 | 428 |
1666193 | 1666193 | 2021-08-29 | Butler | Pennsylvania | 42019 | 18949 | 428 |
1662945 | 1662945 | 2021-08-28 | Butler | Pennsylvania | 42019 | 18895 | 428 |
1659697 | 1659697 | 2021-08-27 | Butler | Pennsylvania | 42019 | 18801 | 428 |
1656448 | 1656448 | 2021-08-26 | Butler | Pennsylvania | 42019 | 18728 | 428 |
1653201 | 1653201 | 2021-08-25 | Butler | Pennsylvania | 42019 | 18664 | 428 |
1649954 | 1649954 | 2021-08-24 | Butler | Pennsylvania | 42019 | 18597 | 427 |
1646705 | 1646705 | 2021-08-23 | Butler | Pennsylvania | 42019 | 18537 | 426 |
1643456 | 1643456 | 2021-08-22 | Butler | Pennsylvania | 42019 | 18500 | 426 |
1640206 | 1640206 | 2021-08-21 | Butler | Pennsylvania | 42019 | 18445 | 426 |
1636956 | 1636956 | 2021-08-20 | Butler | Pennsylvania | 42019 | 18400 | 426 |
1633706 | 1633706 | 2021-08-19 | Butler | Pennsylvania | 42019 | 18364 | 425 |
1630459 | 1630459 | 2021-08-18 | Butler | Pennsylvania | 42019 | 18286 | 425 |
1627212 | 1627212 | 2021-08-17 | Butler | Pennsylvania | 42019 | 18245 | 425 |
1623965 | 1623965 | 2021-08-16 | Butler | Pennsylvania | 42019 | 18221 | 425 |
1620718 | 1620718 | 2021-08-15 | Butler | Pennsylvania | 42019 | 18193 | 425 |
1617470 | 1617470 | 2021-08-14 | Butler | Pennsylvania | 42019 | 18143 | 425 |
1614222 | 1614222 | 2021-08-13 | Butler | Pennsylvania | 42019 | 18108 | 425 |
1610973 | 1610973 | 2021-08-12 | Butler | Pennsylvania | 42019 | 18078 | 424 |
1607725 | 1607725 | 2021-08-11 | Butler | Pennsylvania | 42019 | 18044 | 424 |
1604476 | 1604476 | 2021-08-10 | Butler | Pennsylvania | 42019 | 18026 | 424 |
1601227 | 1601227 | 2021-08-09 | Butler | Pennsylvania | 42019 | 17999 | 424 |
1597979 | 1597979 | 2021-08-08 | Butler | Pennsylvania | 42019 | 17964 | 423 |
1594730 | 1594730 | 2021-08-07 | Butler | Pennsylvania | 42019 | 17964 | 423 |
1591481 | 1591481 | 2021-08-06 | Butler | Pennsylvania | 42019 | 17944 | 423 |
1588232 | 1588232 | 2021-08-05 | Butler | Pennsylvania | 42019 | 17906 | 423 |
1584982 | 1584982 | 2021-08-04 | Butler | Pennsylvania | 42019 | 17872 | 423 |
1581732 | 1581732 | 2021-08-03 | Butler | Pennsylvania | 42019 | 17845 | 423 |
1578483 | 1578483 | 2021-08-02 | Butler | Pennsylvania | 42019 | 17834 | 423 |
1575235 | 1575235 | 2021-08-01 | Butler | Pennsylvania | 42019 | 17818 | 423 |
1571987 | 1571987 | 2021-07-31 | Butler | Pennsylvania | 42019 | 17788 | 423 |
1568739 | 1568739 | 2021-07-30 | Butler | Pennsylvania | 42019 | 17788 | 423 |
1565491 | 1565491 | 2021-07-29 | Butler | Pennsylvania | 42019 | 17772 | 423 |
1562243 | 1562243 | 2021-07-28 | Butler | Pennsylvania | 42019 | 17752 | 423 |
1558995 | 1558995 | 2021-07-27 | Butler | Pennsylvania | 42019 | 17738 | 423 |
1555748 | 1555748 | 2021-07-26 | Butler | Pennsylvania | 42019 | 17728 | 423 |
1552501 | 1552501 | 2021-07-25 | Butler | Pennsylvania | 42019 | 17718 | 423 |
1549254 | 1549254 | 2021-07-24 | Butler | Pennsylvania | 42019 | 17714 | 423 |
1546007 | 1546007 | 2021-07-23 | Butler | Pennsylvania | 42019 | 17710 | 423 |
1542760 | 1542760 | 2021-07-22 | Butler | Pennsylvania | 42019 | 17706 | 423 |
1539512 | 1539512 | 2021-07-21 | Butler | Pennsylvania | 42019 | 17701 | 423 |
1536265 | 1536265 | 2021-07-20 | Butler | Pennsylvania | 42019 | 17693 | 423 |
1533017 | 1533017 | 2021-07-19 | Butler | Pennsylvania | 42019 | 17686 | 423 |
1529770 | 1529770 | 2021-07-18 | Butler | Pennsylvania | 42019 | 17681 | 423 |
1526523 | 1526523 | 2021-07-17 | Butler | Pennsylvania | 42019 | 17677 | 423 |
1523276 | 1523276 | 2021-07-16 | Butler | Pennsylvania | 42019 | 17667 | 423 |
1520028 | 1520028 | 2021-07-15 | Butler | Pennsylvania | 42019 | 17664 | 423 |
1516780 | 1516780 | 2021-07-14 | Butler | Pennsylvania | 42019 | 17660 | 420 |
1513533 | 1513533 | 2021-07-13 | Butler | Pennsylvania | 42019 | 17654 | 420 |
1510287 | 1510287 | 2021-07-12 | Butler | Pennsylvania | 42019 | 17649 | 419 |
1507040 | 1507040 | 2021-07-11 | Butler | Pennsylvania | 42019 | 17648 | 419 |
1503794 | 1503794 | 2021-07-10 | Butler | Pennsylvania | 42019 | 17645 | 419 |
1500548 | 1500548 | 2021-07-09 | Butler | Pennsylvania | 42019 | 17642 | 418 |
1497302 | 1497302 | 2021-07-08 | Butler | Pennsylvania | 42019 | 17640 | 418 |
1494055 | 1494055 | 2021-07-07 | Butler | Pennsylvania | 42019 | 17639 | 418 |
1490808 | 1490808 | 2021-07-06 | Butler | Pennsylvania | 42019 | 17636 | 418 |
1487561 | 1487561 | 2021-07-05 | Butler | Pennsylvania | 42019 | 17633 | 418 |
1484314 | 1484314 | 2021-07-04 | Butler | Pennsylvania | 42019 | 17628 | 418 |
1481068 | 1481068 | 2021-07-03 | Butler | Pennsylvania | 42019 | 17628 | 418 |
1477821 | 1477821 | 2021-07-02 | Butler | Pennsylvania | 42019 | 17626 | 418 |
1474575 | 1474575 | 2021-07-01 | Butler | Pennsylvania | 42019 | 17624 | 418 |
1471329 | 1471329 | 2021-06-30 | Butler | Pennsylvania | 42019 | 17623 | 418 |
1468084 | 1468084 | 2021-06-29 | Butler | Pennsylvania | 42019 | 17621 | 418 |
1464839 | 1464839 | 2021-06-28 | Butler | Pennsylvania | 42019 | 17617 | 418 |
1461594 | 1461594 | 2021-06-27 | Butler | Pennsylvania | 42019 | 17614 | 418 |
1458349 | 1458349 | 2021-06-26 | Butler | Pennsylvania | 42019 | 17611 | 418 |
1455104 | 1455104 | 2021-06-25 | Butler | Pennsylvania | 42019 | 17608 | 418 |
1451859 | 1451859 | 2021-06-24 | Butler | Pennsylvania | 42019 | 17607 | 418 |
1448613 | 1448613 | 2021-06-23 | Butler | Pennsylvania | 42019 | 17605 | 418 |
1445368 | 1445368 | 2021-06-22 | Butler | Pennsylvania | 42019 | 17602 | 418 |
1442123 | 1442123 | 2021-06-21 | Butler | Pennsylvania | 42019 | 17599 | 418 |
1438878 | 1438878 | 2021-06-20 | Butler | Pennsylvania | 42019 | 17599 | 418 |
1435631 | 1435631 | 2021-06-19 | Butler | Pennsylvania | 42019 | 17596 | 418 |
1432384 | 1432384 | 2021-06-18 | Butler | Pennsylvania | 42019 | 17592 | 418 |
1429138 | 1429138 | 2021-06-17 | Butler | Pennsylvania | 42019 | 17585 | 418 |
1425893 | 1425893 | 2021-06-16 | Butler | Pennsylvania | 42019 | 17583 | 418 |
1422646 | 1422646 | 2021-06-15 | Butler | Pennsylvania | 42019 | 17575 | 418 |
1419400 | 1419400 | 2021-06-14 | Butler | Pennsylvania | 42019 | 17565 | 418 |
1416155 | 1416155 | 2021-06-13 | Butler | Pennsylvania | 42019 | 17564 | 418 |
1412909 | 1412909 | 2021-06-12 | Butler | Pennsylvania | 42019 | 17558 | 418 |
1409664 | 1409664 | 2021-06-11 | Butler | Pennsylvania | 42019 | 17555 | 418 |
1406419 | 1406419 | 2021-06-10 | Butler | Pennsylvania | 42019 | 17553 | 418 |
1403173 | 1403173 | 2021-06-09 | Butler | Pennsylvania | 42019 | 17543 | 417 |
1399928 | 1399928 | 2021-06-08 | Butler | Pennsylvania | 42019 | 17535 | 417 |
1396683 | 1396683 | 2021-06-07 | Butler | Pennsylvania | 42019 | 17529 | 417 |
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);