ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 42101 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812432 | 1812432 | 2021-10-13 | Philadelphia | Pennsylvania | 42101 | 177989 | 3955 |
1809183 | 1809183 | 2021-10-12 | Philadelphia | Pennsylvania | 42101 | 177651 | 3950 |
1805933 | 1805933 | 2021-10-11 | Philadelphia | Pennsylvania | 42101 | 177651 | 3936 |
1802683 | 1802683 | 2021-10-10 | Philadelphia | Pennsylvania | 42101 | 177453 | 3936 |
1799434 | 1799434 | 2021-10-09 | Philadelphia | Pennsylvania | 42101 | 177237 | 3936 |
1796185 | 1796185 | 2021-10-08 | Philadelphia | Pennsylvania | 42101 | 176753 | 3936 |
1792936 | 1792936 | 2021-10-07 | Philadelphia | Pennsylvania | 42101 | 176497 | 3933 |
1789687 | 1789687 | 2021-10-06 | Philadelphia | Pennsylvania | 42101 | 176202 | 3927 |
1786439 | 1786439 | 2021-10-05 | Philadelphia | Pennsylvania | 42101 | 175804 | 3923 |
1783190 | 1783190 | 2021-10-04 | Philadelphia | Pennsylvania | 42101 | 175486 | 3919 |
1779941 | 1779941 | 2021-10-03 | Philadelphia | Pennsylvania | 42101 | 175486 | 3919 |
1776691 | 1776691 | 2021-10-02 | Philadelphia | Pennsylvania | 42101 | 175217 | 3917 |
1773441 | 1773441 | 2021-10-01 | Philadelphia | Pennsylvania | 42101 | 174860 | 3916 |
1770191 | 1770191 | 2021-09-30 | Philadelphia | Pennsylvania | 42101 | 174478 | 3915 |
1766942 | 1766942 | 2021-09-29 | Philadelphia | Pennsylvania | 42101 | 174141 | 3911 |
1763693 | 1763693 | 2021-09-28 | Philadelphia | Pennsylvania | 42101 | 173871 | 3901 |
1760444 | 1760444 | 2021-09-27 | Philadelphia | Pennsylvania | 42101 | 173451 | 3901 |
1757196 | 1757196 | 2021-09-26 | Philadelphia | Pennsylvania | 42101 | 173451 | 3900 |
1753948 | 1753948 | 2021-09-25 | Philadelphia | Pennsylvania | 42101 | 173214 | 3899 |
1750700 | 1750700 | 2021-09-24 | Philadelphia | Pennsylvania | 42101 | 172892 | 3892 |
1747451 | 1747451 | 2021-09-23 | Philadelphia | Pennsylvania | 42101 | 172505 | 3889 |
1744201 | 1744201 | 2021-09-22 | Philadelphia | Pennsylvania | 42101 | 172132 | 3886 |
1740952 | 1740952 | 2021-09-21 | Philadelphia | Pennsylvania | 42101 | 171729 | 3882 |
1737703 | 1737703 | 2021-09-20 | Philadelphia | Pennsylvania | 42101 | 171356 | 3877 |
1734453 | 1734453 | 2021-09-19 | Philadelphia | Pennsylvania | 42101 | 171356 | 3877 |
1731203 | 1731203 | 2021-09-18 | Philadelphia | Pennsylvania | 42101 | 171029 | 3876 |
1727953 | 1727953 | 2021-09-17 | Philadelphia | Pennsylvania | 42101 | 170703 | 3873 |
1724704 | 1724704 | 2021-09-16 | Philadelphia | Pennsylvania | 42101 | 170332 | 3871 |
1721455 | 1721455 | 2021-09-15 | Philadelphia | Pennsylvania | 42101 | 169984 | 3865 |
1718207 | 1718207 | 2021-09-14 | Philadelphia | Pennsylvania | 42101 | 169565 | 3859 |
1714959 | 1714959 | 2021-09-13 | Philadelphia | Pennsylvania | 42101 | 169382 | 3852 |
1711713 | 1711713 | 2021-09-12 | Philadelphia | Pennsylvania | 42101 | 169211 | 3851 |
1708466 | 1708466 | 2021-09-11 | Philadelphia | Pennsylvania | 42101 | 168902 | 3851 |
1705219 | 1705219 | 2021-09-10 | Philadelphia | Pennsylvania | 42101 | 168549 | 3849 |
1701969 | 1701969 | 2021-09-09 | Philadelphia | Pennsylvania | 42101 | 168223 | 3845 |
1698720 | 1698720 | 2021-09-08 | Philadelphia | Pennsylvania | 42101 | 168121 | 3844 |
1695472 | 1695472 | 2021-09-07 | Philadelphia | Pennsylvania | 42101 | 167965 | 3840 |
1692224 | 1692224 | 2021-09-06 | Philadelphia | Pennsylvania | 42101 | 167757 | 3839 |
1688975 | 1688975 | 2021-09-05 | Philadelphia | Pennsylvania | 42101 | 167598 | 3839 |
1685725 | 1685725 | 2021-09-04 | Philadelphia | Pennsylvania | 42101 | 167348 | 3839 |
1682474 | 1682474 | 2021-09-03 | Philadelphia | Pennsylvania | 42101 | 166713 | 3838 |
1679224 | 1679224 | 2021-09-02 | Philadelphia | Pennsylvania | 42101 | 166713 | 3834 |
1675976 | 1675976 | 2021-09-01 | Philadelphia | Pennsylvania | 42101 | 165992 | 3822 |
1672729 | 1672729 | 2021-08-31 | Philadelphia | Pennsylvania | 42101 | 165761 | 3822 |
1669481 | 1669481 | 2021-08-30 | Philadelphia | Pennsylvania | 42101 | 165476 | 3820 |
1666234 | 1666234 | 2021-08-29 | Philadelphia | Pennsylvania | 42101 | 165476 | 3820 |
1662986 | 1662986 | 2021-08-28 | Philadelphia | Pennsylvania | 42101 | 165127 | 3819 |
1659738 | 1659738 | 2021-08-27 | Philadelphia | Pennsylvania | 42101 | 164729 | 3816 |
1656489 | 1656489 | 2021-08-26 | Philadelphia | Pennsylvania | 42101 | 164447 | 3813 |
1653242 | 1653242 | 2021-08-25 | Philadelphia | Pennsylvania | 42101 | 164044 | 3813 |
1649995 | 1649995 | 2021-08-24 | Philadelphia | Pennsylvania | 42101 | 163322 | 3809 |
1646746 | 1646746 | 2021-08-23 | Philadelphia | Pennsylvania | 42101 | 163018 | 3807 |
1643497 | 1643497 | 2021-08-22 | Philadelphia | Pennsylvania | 42101 | 162279 | 3807 |
1640247 | 1640247 | 2021-08-21 | Philadelphia | Pennsylvania | 42101 | 162279 | 3807 |
1636997 | 1636997 | 2021-08-20 | Philadelphia | Pennsylvania | 42101 | 162279 | 3806 |
1633747 | 1633747 | 2021-08-19 | Philadelphia | Pennsylvania | 42101 | 161863 | 3805 |
1630500 | 1630500 | 2021-08-18 | Philadelphia | Pennsylvania | 42101 | 161040 | 3802 |
1627253 | 1627253 | 2021-08-17 | Philadelphia | Pennsylvania | 42101 | 160676 | 3801 |
1624006 | 1624006 | 2021-08-16 | Philadelphia | Pennsylvania | 42101 | 160366 | 3798 |
1620759 | 1620759 | 2021-08-15 | Philadelphia | Pennsylvania | 42101 | 159822 | 3798 |
1617511 | 1617511 | 2021-08-14 | Philadelphia | Pennsylvania | 42101 | 159822 | 3798 |
1614263 | 1614263 | 2021-08-13 | Philadelphia | Pennsylvania | 42101 | 159822 | 3798 |
1611014 | 1611014 | 2021-08-12 | Philadelphia | Pennsylvania | 42101 | 159434 | 3794 |
1607766 | 1607766 | 2021-08-11 | Philadelphia | Pennsylvania | 42101 | 159070 | 3794 |
1604517 | 1604517 | 2021-08-10 | Philadelphia | Pennsylvania | 42101 | 158877 | 3793 |
1601268 | 1601268 | 2021-08-09 | Philadelphia | Pennsylvania | 42101 | 158648 | 3793 |
1598020 | 1598020 | 2021-08-08 | Philadelphia | Pennsylvania | 42101 | 158129 | 3793 |
1594771 | 1594771 | 2021-08-07 | Philadelphia | Pennsylvania | 42101 | 158129 | 3793 |
1591522 | 1591522 | 2021-08-06 | Philadelphia | Pennsylvania | 42101 | 158129 | 3791 |
1588273 | 1588273 | 2021-08-05 | Philadelphia | Pennsylvania | 42101 | 157951 | 3789 |
1585023 | 1585023 | 2021-08-04 | Philadelphia | Pennsylvania | 42101 | 157749 | 3788 |
1581773 | 1581773 | 2021-08-03 | Philadelphia | Pennsylvania | 42101 | 157274 | 3784 |
1578524 | 1578524 | 2021-08-02 | Philadelphia | Pennsylvania | 42101 | 157274 | 3784 |
1575276 | 1575276 | 2021-08-01 | Philadelphia | Pennsylvania | 42101 | 156688 | 3784 |
1572028 | 1572028 | 2021-07-31 | Philadelphia | Pennsylvania | 42101 | 156688 | 3785 |
1568780 | 1568780 | 2021-07-30 | Philadelphia | Pennsylvania | 42101 | 156688 | 3785 |
1565532 | 1565532 | 2021-07-29 | Philadelphia | Pennsylvania | 42101 | 156688 | 3784 |
1562284 | 1562284 | 2021-07-28 | Philadelphia | Pennsylvania | 42101 | 156240 | 3783 |
1559036 | 1559036 | 2021-07-27 | Philadelphia | Pennsylvania | 42101 | 156240 | 3780 |
1555789 | 1555789 | 2021-07-26 | Philadelphia | Pennsylvania | 42101 | 156240 | 3780 |
1552542 | 1552542 | 2021-07-25 | Philadelphia | Pennsylvania | 42101 | 155859 | 3780 |
1549295 | 1549295 | 2021-07-24 | Philadelphia | Pennsylvania | 42101 | 155859 | 3780 |
1546048 | 1546048 | 2021-07-23 | Philadelphia | Pennsylvania | 42101 | 155859 | 3779 |
1542801 | 1542801 | 2021-07-22 | Philadelphia | Pennsylvania | 42101 | 155859 | 3778 |
1539553 | 1539553 | 2021-07-21 | Philadelphia | Pennsylvania | 42101 | 155608 | 3776 |
1536306 | 1536306 | 2021-07-20 | Philadelphia | Pennsylvania | 42101 | 155608 | 3776 |
1533058 | 1533058 | 2021-07-19 | Philadelphia | Pennsylvania | 42101 | 155608 | 3774 |
1529811 | 1529811 | 2021-07-18 | Philadelphia | Pennsylvania | 42101 | 155134 | 3774 |
1526564 | 1526564 | 2021-07-17 | Philadelphia | Pennsylvania | 42101 | 155134 | 3774 |
1523317 | 1523317 | 2021-07-16 | Philadelphia | Pennsylvania | 42101 | 155134 | 3774 |
1520069 | 1520069 | 2021-07-15 | Philadelphia | Pennsylvania | 42101 | 155134 | 3774 |
1516821 | 1516821 | 2021-07-14 | Philadelphia | Pennsylvania | 42101 | 155134 | 3773 |
1513574 | 1513574 | 2021-07-13 | Philadelphia | Pennsylvania | 42101 | 155134 | 3773 |
1510328 | 1510328 | 2021-07-12 | Philadelphia | Pennsylvania | 42101 | 155134 | 3770 |
1507081 | 1507081 | 2021-07-11 | Philadelphia | Pennsylvania | 42101 | 154993 | 3769 |
1503835 | 1503835 | 2021-07-10 | Philadelphia | Pennsylvania | 42101 | 154993 | 3768 |
1500589 | 1500589 | 2021-07-09 | Philadelphia | Pennsylvania | 42101 | 154993 | 3768 |
1497343 | 1497343 | 2021-07-08 | Philadelphia | Pennsylvania | 42101 | 154993 | 3767 |
1494096 | 1494096 | 2021-07-07 | Philadelphia | Pennsylvania | 42101 | 154800 | 3764 |
1490849 | 1490849 | 2021-07-06 | Philadelphia | Pennsylvania | 42101 | 154800 | 3763 |
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);