ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42027 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812395 | 1812395 | 2021-10-13 | Centre | Pennsylvania | 42027 | 20002 | 241 |
1809146 | 1809146 | 2021-10-12 | Centre | Pennsylvania | 42027 | 19924 | 237 |
1805896 | 1805896 | 2021-10-11 | Centre | Pennsylvania | 42027 | 19903 | 237 |
1802646 | 1802646 | 2021-10-10 | Centre | Pennsylvania | 42027 | 19891 | 237 |
1799397 | 1799397 | 2021-10-09 | Centre | Pennsylvania | 42027 | 19848 | 237 |
1796148 | 1796148 | 2021-10-08 | Centre | Pennsylvania | 42027 | 19769 | 237 |
1792899 | 1792899 | 2021-10-07 | Centre | Pennsylvania | 42027 | 19705 | 237 |
1789650 | 1789650 | 2021-10-06 | Centre | Pennsylvania | 42027 | 19642 | 237 |
1786402 | 1786402 | 2021-10-05 | Centre | Pennsylvania | 42027 | 19578 | 236 |
1783153 | 1783153 | 2021-10-04 | Centre | Pennsylvania | 42027 | 19554 | 235 |
1779904 | 1779904 | 2021-10-03 | Centre | Pennsylvania | 42027 | 19522 | 235 |
1776654 | 1776654 | 2021-10-02 | Centre | Pennsylvania | 42027 | 19431 | 235 |
1773404 | 1773404 | 2021-10-01 | Centre | Pennsylvania | 42027 | 19389 | 235 |
1770154 | 1770154 | 2021-09-30 | Centre | Pennsylvania | 42027 | 19320 | 235 |
1766905 | 1766905 | 2021-09-29 | Centre | Pennsylvania | 42027 | 19287 | 235 |
1763656 | 1763656 | 2021-09-28 | Centre | Pennsylvania | 42027 | 19247 | 235 |
1760407 | 1760407 | 2021-09-27 | Centre | Pennsylvania | 42027 | 19189 | 235 |
1757159 | 1757159 | 2021-09-26 | Centre | Pennsylvania | 42027 | 19169 | 235 |
1753911 | 1753911 | 2021-09-25 | Centre | Pennsylvania | 42027 | 19104 | 235 |
1750663 | 1750663 | 2021-09-24 | Centre | Pennsylvania | 42027 | 19024 | 234 |
1747414 | 1747414 | 2021-09-23 | Centre | Pennsylvania | 42027 | 18951 | 234 |
1744164 | 1744164 | 2021-09-22 | Centre | Pennsylvania | 42027 | 18893 | 234 |
1740915 | 1740915 | 2021-09-21 | Centre | Pennsylvania | 42027 | 18831 | 233 |
1737666 | 1737666 | 2021-09-20 | Centre | Pennsylvania | 42027 | 18791 | 233 |
1734416 | 1734416 | 2021-09-19 | Centre | Pennsylvania | 42027 | 18765 | 233 |
1731166 | 1731166 | 2021-09-18 | Centre | Pennsylvania | 42027 | 18698 | 233 |
1727916 | 1727916 | 2021-09-17 | Centre | Pennsylvania | 42027 | 18626 | 232 |
1724667 | 1724667 | 2021-09-16 | Centre | Pennsylvania | 42027 | 18577 | 232 |
1721418 | 1721418 | 2021-09-15 | Centre | Pennsylvania | 42027 | 18522 | 232 |
1718170 | 1718170 | 2021-09-14 | Centre | Pennsylvania | 42027 | 18444 | 232 |
1714922 | 1714922 | 2021-09-13 | Centre | Pennsylvania | 42027 | 18410 | 232 |
1711676 | 1711676 | 2021-09-12 | Centre | Pennsylvania | 42027 | 18390 | 232 |
1708429 | 1708429 | 2021-09-11 | Centre | Pennsylvania | 42027 | 18316 | 232 |
1705182 | 1705182 | 2021-09-10 | Centre | Pennsylvania | 42027 | 18230 | 232 |
1701932 | 1701932 | 2021-09-09 | Centre | Pennsylvania | 42027 | 18162 | 232 |
1698683 | 1698683 | 2021-09-08 | Centre | Pennsylvania | 42027 | 18048 | 232 |
1695435 | 1695435 | 2021-09-07 | Centre | Pennsylvania | 42027 | 18032 | 232 |
1692187 | 1692187 | 2021-09-06 | Centre | Pennsylvania | 42027 | 17993 | 232 |
1688938 | 1688938 | 2021-09-05 | Centre | Pennsylvania | 42027 | 17976 | 232 |
1685688 | 1685688 | 2021-09-04 | Centre | Pennsylvania | 42027 | 17883 | 231 |
1682437 | 1682437 | 2021-09-03 | Centre | Pennsylvania | 42027 | 17814 | 231 |
1679187 | 1679187 | 2021-09-02 | Centre | Pennsylvania | 42027 | 17766 | 231 |
1675939 | 1675939 | 2021-09-01 | Centre | Pennsylvania | 42027 | 17709 | 231 |
1672692 | 1672692 | 2021-08-31 | Centre | Pennsylvania | 42027 | 17662 | 231 |
1669444 | 1669444 | 2021-08-30 | Centre | Pennsylvania | 42027 | 17638 | 230 |
1666197 | 1666197 | 2021-08-29 | Centre | Pennsylvania | 42027 | 17618 | 230 |
1662949 | 1662949 | 2021-08-28 | Centre | Pennsylvania | 42027 | 17594 | 230 |
1659701 | 1659701 | 2021-08-27 | Centre | Pennsylvania | 42027 | 17556 | 230 |
1656452 | 1656452 | 2021-08-26 | Centre | Pennsylvania | 42027 | 17516 | 230 |
1653205 | 1653205 | 2021-08-25 | Centre | Pennsylvania | 42027 | 17488 | 230 |
1649958 | 1649958 | 2021-08-24 | Centre | Pennsylvania | 42027 | 17455 | 230 |
1646709 | 1646709 | 2021-08-23 | Centre | Pennsylvania | 42027 | 17440 | 230 |
1643460 | 1643460 | 2021-08-22 | Centre | Pennsylvania | 42027 | 17419 | 230 |
1640210 | 1640210 | 2021-08-21 | Centre | Pennsylvania | 42027 | 17399 | 230 |
1636960 | 1636960 | 2021-08-20 | Centre | Pennsylvania | 42027 | 17376 | 230 |
1633710 | 1633710 | 2021-08-19 | Centre | Pennsylvania | 42027 | 17351 | 230 |
1630463 | 1630463 | 2021-08-18 | Centre | Pennsylvania | 42027 | 17329 | 230 |
1627216 | 1627216 | 2021-08-17 | Centre | Pennsylvania | 42027 | 17308 | 229 |
1623969 | 1623969 | 2021-08-16 | Centre | Pennsylvania | 42027 | 17294 | 229 |
1620722 | 1620722 | 2021-08-15 | Centre | Pennsylvania | 42027 | 17286 | 229 |
1617474 | 1617474 | 2021-08-14 | Centre | Pennsylvania | 42027 | 17256 | 229 |
1614226 | 1614226 | 2021-08-13 | Centre | Pennsylvania | 42027 | 17238 | 229 |
1610977 | 1610977 | 2021-08-12 | Centre | Pennsylvania | 42027 | 17230 | 228 |
1607729 | 1607729 | 2021-08-11 | Centre | Pennsylvania | 42027 | 17216 | 228 |
1604480 | 1604480 | 2021-08-10 | Centre | Pennsylvania | 42027 | 17189 | 228 |
1601231 | 1601231 | 2021-08-09 | Centre | Pennsylvania | 42027 | 17175 | 228 |
1597983 | 1597983 | 2021-08-08 | Centre | Pennsylvania | 42027 | 17153 | 228 |
1594734 | 1594734 | 2021-08-07 | Centre | Pennsylvania | 42027 | 17153 | 228 |
1591485 | 1591485 | 2021-08-06 | Centre | Pennsylvania | 42027 | 17136 | 228 |
1588236 | 1588236 | 2021-08-05 | Centre | Pennsylvania | 42027 | 17126 | 228 |
1584986 | 1584986 | 2021-08-04 | Centre | Pennsylvania | 42027 | 17112 | 228 |
1581736 | 1581736 | 2021-08-03 | Centre | Pennsylvania | 42027 | 17091 | 228 |
1578487 | 1578487 | 2021-08-02 | Centre | Pennsylvania | 42027 | 17081 | 228 |
1575239 | 1575239 | 2021-08-01 | Centre | Pennsylvania | 42027 | 17070 | 228 |
1571991 | 1571991 | 2021-07-31 | Centre | Pennsylvania | 42027 | 17053 | 228 |
1568743 | 1568743 | 2021-07-30 | Centre | Pennsylvania | 42027 | 17053 | 228 |
1565495 | 1565495 | 2021-07-29 | Centre | Pennsylvania | 42027 | 17045 | 228 |
1562247 | 1562247 | 2021-07-28 | Centre | Pennsylvania | 42027 | 17030 | 228 |
1558999 | 1558999 | 2021-07-27 | Centre | Pennsylvania | 42027 | 17020 | 228 |
1555752 | 1555752 | 2021-07-26 | Centre | Pennsylvania | 42027 | 17013 | 228 |
1552505 | 1552505 | 2021-07-25 | Centre | Pennsylvania | 42027 | 17010 | 228 |
1549258 | 1549258 | 2021-07-24 | Centre | Pennsylvania | 42027 | 17003 | 228 |
1546011 | 1546011 | 2021-07-23 | Centre | Pennsylvania | 42027 | 16996 | 228 |
1542764 | 1542764 | 2021-07-22 | Centre | Pennsylvania | 42027 | 16989 | 228 |
1539516 | 1539516 | 2021-07-21 | Centre | Pennsylvania | 42027 | 16981 | 228 |
1536269 | 1536269 | 2021-07-20 | Centre | Pennsylvania | 42027 | 16971 | 228 |
1533021 | 1533021 | 2021-07-19 | Centre | Pennsylvania | 42027 | 16963 | 228 |
1529774 | 1529774 | 2021-07-18 | Centre | Pennsylvania | 42027 | 16961 | 228 |
1526527 | 1526527 | 2021-07-17 | Centre | Pennsylvania | 42027 | 16959 | 228 |
1523280 | 1523280 | 2021-07-16 | Centre | Pennsylvania | 42027 | 16955 | 228 |
1520032 | 1520032 | 2021-07-15 | Centre | Pennsylvania | 42027 | 16950 | 228 |
1516784 | 1516784 | 2021-07-14 | Centre | Pennsylvania | 42027 | 16949 | 228 |
1513537 | 1513537 | 2021-07-13 | Centre | Pennsylvania | 42027 | 16944 | 228 |
1510291 | 1510291 | 2021-07-12 | Centre | Pennsylvania | 42027 | 16938 | 228 |
1507044 | 1507044 | 2021-07-11 | Centre | Pennsylvania | 42027 | 16938 | 228 |
1503798 | 1503798 | 2021-07-10 | Centre | Pennsylvania | 42027 | 16938 | 228 |
1500552 | 1500552 | 2021-07-09 | Centre | Pennsylvania | 42027 | 16936 | 228 |
1497306 | 1497306 | 2021-07-08 | Centre | Pennsylvania | 42027 | 16931 | 228 |
1494059 | 1494059 | 2021-07-07 | Centre | Pennsylvania | 42027 | 16931 | 228 |
1490812 | 1490812 | 2021-07-06 | Centre | Pennsylvania | 42027 | 16930 | 228 |
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);