ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Clearfield" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718173 | 1718173 | 2021-09-14 | Clearfield | Pennsylvania | 42033 | 9594 | 168 |
1714925 | 1714925 | 2021-09-13 | Clearfield | Pennsylvania | 42033 | 9564 | 167 |
1711679 | 1711679 | 2021-09-12 | Clearfield | Pennsylvania | 42033 | 9547 | 167 |
1708432 | 1708432 | 2021-09-11 | Clearfield | Pennsylvania | 42033 | 9520 | 167 |
1705185 | 1705185 | 2021-09-10 | Clearfield | Pennsylvania | 42033 | 9490 | 166 |
1701935 | 1701935 | 2021-09-09 | Clearfield | Pennsylvania | 42033 | 9449 | 166 |
1698686 | 1698686 | 2021-09-08 | Clearfield | Pennsylvania | 42033 | 9412 | 166 |
1695438 | 1695438 | 2021-09-07 | Clearfield | Pennsylvania | 42033 | 9393 | 166 |
1692190 | 1692190 | 2021-09-06 | Clearfield | Pennsylvania | 42033 | 9379 | 166 |
1688941 | 1688941 | 2021-09-05 | Clearfield | Pennsylvania | 42033 | 9365 | 166 |
1685691 | 1685691 | 2021-09-04 | Clearfield | Pennsylvania | 42033 | 9337 | 166 |
1682440 | 1682440 | 2021-09-03 | Clearfield | Pennsylvania | 42033 | 9297 | 166 |
1679190 | 1679190 | 2021-09-02 | Clearfield | Pennsylvania | 42033 | 9264 | 166 |
1675942 | 1675942 | 2021-09-01 | Clearfield | Pennsylvania | 42033 | 9254 | 165 |
1672695 | 1672695 | 2021-08-31 | Clearfield | Pennsylvania | 42033 | 9226 | 165 |
1669447 | 1669447 | 2021-08-30 | Clearfield | Pennsylvania | 42033 | 9208 | 164 |
1666200 | 1666200 | 2021-08-29 | Clearfield | Pennsylvania | 42033 | 9192 | 164 |
1662952 | 1662952 | 2021-08-28 | Clearfield | Pennsylvania | 42033 | 9180 | 164 |
1659704 | 1659704 | 2021-08-27 | Clearfield | Pennsylvania | 42033 | 9162 | 164 |
1656455 | 1656455 | 2021-08-26 | Clearfield | Pennsylvania | 42033 | 9139 | 164 |
1653208 | 1653208 | 2021-08-25 | Clearfield | Pennsylvania | 42033 | 9123 | 163 |
1649961 | 1649961 | 2021-08-24 | Clearfield | Pennsylvania | 42033 | 9100 | 163 |
1646712 | 1646712 | 2021-08-23 | Clearfield | Pennsylvania | 42033 | 9078 | 163 |
1643463 | 1643463 | 2021-08-22 | Clearfield | Pennsylvania | 42033 | 9061 | 163 |
1640213 | 1640213 | 2021-08-21 | Clearfield | Pennsylvania | 42033 | 9049 | 163 |
1636963 | 1636963 | 2021-08-20 | Clearfield | Pennsylvania | 42033 | 9031 | 162 |
1633713 | 1633713 | 2021-08-19 | Clearfield | Pennsylvania | 42033 | 9003 | 162 |
1630466 | 1630466 | 2021-08-18 | Clearfield | Pennsylvania | 42033 | 8972 | 162 |
1627219 | 1627219 | 2021-08-17 | Clearfield | Pennsylvania | 42033 | 8948 | 161 |
1623972 | 1623972 | 2021-08-16 | Clearfield | Pennsylvania | 42033 | 8935 | 160 |
1620725 | 1620725 | 2021-08-15 | Clearfield | Pennsylvania | 42033 | 8924 | 160 |
1617477 | 1617477 | 2021-08-14 | Clearfield | Pennsylvania | 42033 | 8916 | 160 |
1614229 | 1614229 | 2021-08-13 | Clearfield | Pennsylvania | 42033 | 8902 | 160 |
1610980 | 1610980 | 2021-08-12 | Clearfield | Pennsylvania | 42033 | 8883 | 160 |
1607732 | 1607732 | 2021-08-11 | Clearfield | Pennsylvania | 42033 | 8857 | 159 |
1604483 | 1604483 | 2021-08-10 | Clearfield | Pennsylvania | 42033 | 8837 | 158 |
1601234 | 1601234 | 2021-08-09 | Clearfield | Pennsylvania | 42033 | 8820 | 157 |
1597986 | 1597986 | 2021-08-08 | Clearfield | Pennsylvania | 42033 | 8803 | 157 |
1594737 | 1594737 | 2021-08-07 | Clearfield | Pennsylvania | 42033 | 8803 | 157 |
1591488 | 1591488 | 2021-08-06 | Clearfield | Pennsylvania | 42033 | 8791 | 157 |
1588239 | 1588239 | 2021-08-05 | Clearfield | Pennsylvania | 42033 | 8780 | 157 |
1584989 | 1584989 | 2021-08-04 | Clearfield | Pennsylvania | 42033 | 8769 | 157 |
1581739 | 1581739 | 2021-08-03 | Clearfield | Pennsylvania | 42033 | 8757 | 156 |
1578490 | 1578490 | 2021-08-02 | Clearfield | Pennsylvania | 42033 | 8745 | 156 |
1575242 | 1575242 | 2021-08-01 | Clearfield | Pennsylvania | 42033 | 8741 | 156 |
1571994 | 1571994 | 2021-07-31 | Clearfield | Pennsylvania | 42033 | 8729 | 156 |
1568746 | 1568746 | 2021-07-30 | Clearfield | Pennsylvania | 42033 | 8729 | 156 |
1565498 | 1565498 | 2021-07-29 | Clearfield | Pennsylvania | 42033 | 8720 | 156 |
1562250 | 1562250 | 2021-07-28 | Clearfield | Pennsylvania | 42033 | 8717 | 156 |
1559002 | 1559002 | 2021-07-27 | Clearfield | Pennsylvania | 42033 | 8710 | 156 |
1555755 | 1555755 | 2021-07-26 | Clearfield | Pennsylvania | 42033 | 8697 | 156 |
1552508 | 1552508 | 2021-07-25 | Clearfield | Pennsylvania | 42033 | 8693 | 156 |
1549261 | 1549261 | 2021-07-24 | Clearfield | Pennsylvania | 42033 | 8690 | 156 |
1546014 | 1546014 | 2021-07-23 | Clearfield | Pennsylvania | 42033 | 8684 | 156 |
1542767 | 1542767 | 2021-07-22 | Clearfield | Pennsylvania | 42033 | 8682 | 156 |
1539519 | 1539519 | 2021-07-21 | Clearfield | Pennsylvania | 42033 | 8679 | 156 |
1536272 | 1536272 | 2021-07-20 | Clearfield | Pennsylvania | 42033 | 8676 | 156 |
1533024 | 1533024 | 2021-07-19 | Clearfield | Pennsylvania | 42033 | 8672 | 156 |
1529777 | 1529777 | 2021-07-18 | Clearfield | Pennsylvania | 42033 | 8670 | 156 |
1526530 | 1526530 | 2021-07-17 | Clearfield | Pennsylvania | 42033 | 8670 | 156 |
1523283 | 1523283 | 2021-07-16 | Clearfield | Pennsylvania | 42033 | 8667 | 156 |
1520035 | 1520035 | 2021-07-15 | Clearfield | Pennsylvania | 42033 | 8666 | 156 |
1516787 | 1516787 | 2021-07-14 | Clearfield | Pennsylvania | 42033 | 8663 | 156 |
1513540 | 1513540 | 2021-07-13 | Clearfield | Pennsylvania | 42033 | 8663 | 156 |
1510294 | 1510294 | 2021-07-12 | Clearfield | Pennsylvania | 42033 | 8660 | 156 |
1507047 | 1507047 | 2021-07-11 | Clearfield | Pennsylvania | 42033 | 8659 | 156 |
1503801 | 1503801 | 2021-07-10 | Clearfield | Pennsylvania | 42033 | 8658 | 156 |
1500555 | 1500555 | 2021-07-09 | Clearfield | Pennsylvania | 42033 | 8658 | 156 |
1497309 | 1497309 | 2021-07-08 | Clearfield | Pennsylvania | 42033 | 8657 | 156 |
1494062 | 1494062 | 2021-07-07 | Clearfield | Pennsylvania | 42033 | 8656 | 156 |
1490815 | 1490815 | 2021-07-06 | Clearfield | Pennsylvania | 42033 | 8653 | 156 |
1487568 | 1487568 | 2021-07-05 | Clearfield | Pennsylvania | 42033 | 8653 | 156 |
1484321 | 1484321 | 2021-07-04 | Clearfield | Pennsylvania | 42033 | 8652 | 156 |
1481075 | 1481075 | 2021-07-03 | Clearfield | Pennsylvania | 42033 | 8651 | 156 |
1477828 | 1477828 | 2021-07-02 | Clearfield | Pennsylvania | 42033 | 8650 | 156 |
1474582 | 1474582 | 2021-07-01 | Clearfield | Pennsylvania | 42033 | 8648 | 155 |
1471336 | 1471336 | 2021-06-30 | Clearfield | Pennsylvania | 42033 | 8648 | 155 |
1468091 | 1468091 | 2021-06-29 | Clearfield | Pennsylvania | 42033 | 8647 | 154 |
1464846 | 1464846 | 2021-06-28 | Clearfield | Pennsylvania | 42033 | 8647 | 154 |
1461601 | 1461601 | 2021-06-27 | Clearfield | Pennsylvania | 42033 | 8646 | 154 |
1458356 | 1458356 | 2021-06-26 | Clearfield | Pennsylvania | 42033 | 8644 | 154 |
1455111 | 1455111 | 2021-06-25 | Clearfield | Pennsylvania | 42033 | 8644 | 153 |
1451866 | 1451866 | 2021-06-24 | Clearfield | Pennsylvania | 42033 | 8643 | 153 |
1448620 | 1448620 | 2021-06-23 | Clearfield | Pennsylvania | 42033 | 8642 | 153 |
1445375 | 1445375 | 2021-06-22 | Clearfield | Pennsylvania | 42033 | 8642 | 153 |
1442130 | 1442130 | 2021-06-21 | Clearfield | Pennsylvania | 42033 | 8640 | 152 |
1438885 | 1438885 | 2021-06-20 | Clearfield | Pennsylvania | 42033 | 8640 | 152 |
1435638 | 1435638 | 2021-06-19 | Clearfield | Pennsylvania | 42033 | 8639 | 151 |
1432391 | 1432391 | 2021-06-18 | Clearfield | Pennsylvania | 42033 | 8639 | 151 |
1429145 | 1429145 | 2021-06-17 | Clearfield | Pennsylvania | 42033 | 8638 | 151 |
1425900 | 1425900 | 2021-06-16 | Clearfield | Pennsylvania | 42033 | 8638 | 151 |
1422653 | 1422653 | 2021-06-15 | Clearfield | Pennsylvania | 42033 | 8637 | 151 |
1419407 | 1419407 | 2021-06-14 | Clearfield | Pennsylvania | 42033 | 8635 | 150 |
1416162 | 1416162 | 2021-06-13 | Clearfield | Pennsylvania | 42033 | 8635 | 150 |
1412916 | 1412916 | 2021-06-12 | Clearfield | Pennsylvania | 42033 | 8633 | 150 |
1409671 | 1409671 | 2021-06-11 | Clearfield | Pennsylvania | 42033 | 8633 | 150 |
1406426 | 1406426 | 2021-06-10 | Clearfield | Pennsylvania | 42033 | 8630 | 150 |
1403180 | 1403180 | 2021-06-09 | Clearfield | Pennsylvania | 42033 | 8626 | 150 |
1399935 | 1399935 | 2021-06-08 | Clearfield | Pennsylvania | 42033 | 8623 | 150 |
1396690 | 1396690 | 2021-06-07 | Clearfield | Pennsylvania | 42033 | 8617 | 148 |
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);