ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 42017 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1838381 | 1838381 | 2021-10-21 | Bucks | Pennsylvania | 42017 | 72352 | 1414 |
1835132 | 1835132 | 2021-10-20 | Bucks | Pennsylvania | 42017 | 72219 | 1413 |
1831883 | 1831883 | 2021-10-19 | Bucks | Pennsylvania | 42017 | 72108 | 1409 |
1828634 | 1828634 | 2021-10-18 | Bucks | Pennsylvania | 42017 | 71963 | 1409 |
1825385 | 1825385 | 2021-10-17 | Bucks | Pennsylvania | 42017 | 71862 | 1404 |
1822136 | 1822136 | 2021-10-16 | Bucks | Pennsylvania | 42017 | 71731 | 1404 |
1818887 | 1818887 | 2021-10-15 | Bucks | Pennsylvania | 42017 | 71590 | 1404 |
1815638 | 1815638 | 2021-10-14 | Bucks | Pennsylvania | 42017 | 71400 | 1403 |
1812390 | 1812390 | 2021-10-13 | Bucks | Pennsylvania | 42017 | 71205 | 1401 |
1809141 | 1809141 | 2021-10-12 | Bucks | Pennsylvania | 42017 | 71061 | 1393 |
1805891 | 1805891 | 2021-10-11 | Bucks | Pennsylvania | 42017 | 70895 | 1388 |
1802641 | 1802641 | 2021-10-10 | Bucks | Pennsylvania | 42017 | 70783 | 1388 |
1799392 | 1799392 | 2021-10-09 | Bucks | Pennsylvania | 42017 | 70612 | 1388 |
1796143 | 1796143 | 2021-10-08 | Bucks | Pennsylvania | 42017 | 70417 | 1388 |
1792894 | 1792894 | 2021-10-07 | Bucks | Pennsylvania | 42017 | 70266 | 1387 |
1789645 | 1789645 | 2021-10-06 | Bucks | Pennsylvania | 42017 | 70059 | 1382 |
1786397 | 1786397 | 2021-10-05 | Bucks | Pennsylvania | 42017 | 69908 | 1379 |
1783148 | 1783148 | 2021-10-04 | Bucks | Pennsylvania | 42017 | 69730 | 1378 |
1779899 | 1779899 | 2021-10-03 | Bucks | Pennsylvania | 42017 | 69502 | 1378 |
1776649 | 1776649 | 2021-10-02 | Bucks | Pennsylvania | 42017 | 69330 | 1378 |
1773399 | 1773399 | 2021-10-01 | Bucks | Pennsylvania | 42017 | 69230 | 1377 |
1770149 | 1770149 | 2021-09-30 | Bucks | Pennsylvania | 42017 | 69039 | 1375 |
1766900 | 1766900 | 2021-09-29 | Bucks | Pennsylvania | 42017 | 68881 | 1373 |
1763651 | 1763651 | 2021-09-28 | Bucks | Pennsylvania | 42017 | 68781 | 1371 |
1760402 | 1760402 | 2021-09-27 | Bucks | Pennsylvania | 42017 | 68647 | 1368 |
1757154 | 1757154 | 2021-09-26 | Bucks | Pennsylvania | 42017 | 68544 | 1368 |
1753906 | 1753906 | 2021-09-25 | Bucks | Pennsylvania | 42017 | 68410 | 1368 |
1750658 | 1750658 | 2021-09-24 | Bucks | Pennsylvania | 42017 | 68200 | 1367 |
1747409 | 1747409 | 2021-09-23 | Bucks | Pennsylvania | 42017 | 68042 | 1366 |
1744159 | 1744159 | 2021-09-22 | Bucks | Pennsylvania | 42017 | 67889 | 1364 |
1740910 | 1740910 | 2021-09-21 | Bucks | Pennsylvania | 42017 | 67732 | 1362 |
1737661 | 1737661 | 2021-09-20 | Bucks | Pennsylvania | 42017 | 67577 | 1359 |
1734411 | 1734411 | 2021-09-19 | Bucks | Pennsylvania | 42017 | 67503 | 1359 |
1731161 | 1731161 | 2021-09-18 | Bucks | Pennsylvania | 42017 | 67377 | 1358 |
1727911 | 1727911 | 2021-09-17 | Bucks | Pennsylvania | 42017 | 67247 | 1358 |
1724662 | 1724662 | 2021-09-16 | Bucks | Pennsylvania | 42017 | 67082 | 1357 |
1721413 | 1721413 | 2021-09-15 | Bucks | Pennsylvania | 42017 | 66903 | 1356 |
1718165 | 1718165 | 2021-09-14 | Bucks | Pennsylvania | 42017 | 66759 | 1355 |
1714917 | 1714917 | 2021-09-13 | Bucks | Pennsylvania | 42017 | 66642 | 1354 |
1711671 | 1711671 | 2021-09-12 | Bucks | Pennsylvania | 42017 | 66535 | 1354 |
1708424 | 1708424 | 2021-09-11 | Bucks | Pennsylvania | 42017 | 66399 | 1354 |
1705177 | 1705177 | 2021-09-10 | Bucks | Pennsylvania | 42017 | 66212 | 1354 |
1701927 | 1701927 | 2021-09-09 | Bucks | Pennsylvania | 42017 | 66059 | 1353 |
1698678 | 1698678 | 2021-09-08 | Bucks | Pennsylvania | 42017 | 65951 | 1349 |
1695430 | 1695430 | 2021-09-07 | Bucks | Pennsylvania | 42017 | 65813 | 1349 |
1692182 | 1692182 | 2021-09-06 | Bucks | Pennsylvania | 42017 | 65718 | 1348 |
1688933 | 1688933 | 2021-09-05 | Bucks | Pennsylvania | 42017 | 65599 | 1347 |
1685683 | 1685683 | 2021-09-04 | Bucks | Pennsylvania | 42017 | 65483 | 1347 |
1682432 | 1682432 | 2021-09-03 | Bucks | Pennsylvania | 42017 | 65322 | 1346 |
1679182 | 1679182 | 2021-09-02 | Bucks | Pennsylvania | 42017 | 65170 | 1345 |
1675934 | 1675934 | 2021-09-01 | Bucks | Pennsylvania | 42017 | 64998 | 1342 |
1672687 | 1672687 | 2021-08-31 | Bucks | Pennsylvania | 42017 | 64858 | 1342 |
1669439 | 1669439 | 2021-08-30 | Bucks | Pennsylvania | 42017 | 64733 | 1342 |
1666192 | 1666192 | 2021-08-29 | Bucks | Pennsylvania | 42017 | 64607 | 1342 |
1662944 | 1662944 | 2021-08-28 | Bucks | Pennsylvania | 42017 | 64429 | 1342 |
1659696 | 1659696 | 2021-08-27 | Bucks | Pennsylvania | 42017 | 64294 | 1342 |
1656447 | 1656447 | 2021-08-26 | Bucks | Pennsylvania | 42017 | 64111 | 1341 |
1653200 | 1653200 | 2021-08-25 | Bucks | Pennsylvania | 42017 | 63926 | 1339 |
1649953 | 1649953 | 2021-08-24 | Bucks | Pennsylvania | 42017 | 63794 | 1339 |
1646704 | 1646704 | 2021-08-23 | Bucks | Pennsylvania | 42017 | 63680 | 1339 |
1643455 | 1643455 | 2021-08-22 | Bucks | Pennsylvania | 42017 | 63591 | 1339 |
1640205 | 1640205 | 2021-08-21 | Bucks | Pennsylvania | 42017 | 63500 | 1339 |
1636955 | 1636955 | 2021-08-20 | Bucks | Pennsylvania | 42017 | 63343 | 1339 |
1633705 | 1633705 | 2021-08-19 | Bucks | Pennsylvania | 42017 | 63228 | 1339 |
1630458 | 1630458 | 2021-08-18 | Bucks | Pennsylvania | 42017 | 63107 | 1338 |
1627211 | 1627211 | 2021-08-17 | Bucks | Pennsylvania | 42017 | 62986 | 1338 |
1623964 | 1623964 | 2021-08-16 | Bucks | Pennsylvania | 42017 | 62895 | 1338 |
1620717 | 1620717 | 2021-08-15 | Bucks | Pennsylvania | 42017 | 62798 | 1338 |
1617469 | 1617469 | 2021-08-14 | Bucks | Pennsylvania | 42017 | 62662 | 1338 |
1614221 | 1614221 | 2021-08-13 | Bucks | Pennsylvania | 42017 | 62573 | 1336 |
1610972 | 1610972 | 2021-08-12 | Bucks | Pennsylvania | 42017 | 62482 | 1336 |
1607724 | 1607724 | 2021-08-11 | Bucks | Pennsylvania | 42017 | 62398 | 1336 |
1604475 | 1604475 | 2021-08-10 | Bucks | Pennsylvania | 42017 | 62335 | 1336 |
1601226 | 1601226 | 2021-08-09 | Bucks | Pennsylvania | 42017 | 62261 | 1336 |
1597978 | 1597978 | 2021-08-08 | Bucks | Pennsylvania | 42017 | 62105 | 1336 |
1594729 | 1594729 | 2021-08-07 | Bucks | Pennsylvania | 42017 | 62105 | 1336 |
1591480 | 1591480 | 2021-08-06 | Bucks | Pennsylvania | 42017 | 61992 | 1336 |
1588231 | 1588231 | 2021-08-05 | Bucks | Pennsylvania | 42017 | 61917 | 1336 |
1584981 | 1584981 | 2021-08-04 | Bucks | Pennsylvania | 42017 | 61835 | 1336 |
1581731 | 1581731 | 2021-08-03 | Bucks | Pennsylvania | 42017 | 61757 | 1336 |
1578482 | 1578482 | 2021-08-02 | Bucks | Pennsylvania | 42017 | 61687 | 1335 |
1575234 | 1575234 | 2021-08-01 | Bucks | Pennsylvania | 42017 | 61637 | 1335 |
1571986 | 1571986 | 2021-07-31 | Bucks | Pennsylvania | 42017 | 61517 | 1335 |
1568738 | 1568738 | 2021-07-30 | Bucks | Pennsylvania | 42017 | 61517 | 1335 |
1565490 | 1565490 | 2021-07-29 | Bucks | Pennsylvania | 42017 | 61457 | 1335 |
1562242 | 1562242 | 2021-07-28 | Bucks | Pennsylvania | 42017 | 61411 | 1335 |
1558994 | 1558994 | 2021-07-27 | Bucks | Pennsylvania | 42017 | 61377 | 1335 |
1555747 | 1555747 | 2021-07-26 | Bucks | Pennsylvania | 42017 | 61324 | 1335 |
1552500 | 1552500 | 2021-07-25 | Bucks | Pennsylvania | 42017 | 61284 | 1335 |
1549253 | 1549253 | 2021-07-24 | Bucks | Pennsylvania | 42017 | 61250 | 1335 |
1546006 | 1546006 | 2021-07-23 | Bucks | Pennsylvania | 42017 | 61211 | 1334 |
1542759 | 1542759 | 2021-07-22 | Bucks | Pennsylvania | 42017 | 61181 | 1334 |
1539511 | 1539511 | 2021-07-21 | Bucks | Pennsylvania | 42017 | 61148 | 1334 |
1536264 | 1536264 | 2021-07-20 | Bucks | Pennsylvania | 42017 | 61118 | 1333 |
1533016 | 1533016 | 2021-07-19 | Bucks | Pennsylvania | 42017 | 61091 | 1332 |
1529769 | 1529769 | 2021-07-18 | Bucks | Pennsylvania | 42017 | 61068 | 1332 |
1526522 | 1526522 | 2021-07-17 | Bucks | Pennsylvania | 42017 | 61042 | 1332 |
1523275 | 1523275 | 2021-07-16 | Bucks | Pennsylvania | 42017 | 61015 | 1331 |
1520027 | 1520027 | 2021-07-15 | Bucks | Pennsylvania | 42017 | 60986 | 1331 |
1516779 | 1516779 | 2021-07-14 | Bucks | Pennsylvania | 42017 | 60954 | 1331 |
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);