ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42105 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1786441 | 1786441 | 2021-10-05 | Potter | Pennsylvania | 42105 | 1633 | 31 |
1783192 | 1783192 | 2021-10-04 | Potter | Pennsylvania | 42105 | 1603 | 30 |
1779943 | 1779943 | 2021-10-03 | Potter | Pennsylvania | 42105 | 1598 | 30 |
1776693 | 1776693 | 2021-10-02 | Potter | Pennsylvania | 42105 | 1574 | 30 |
1773443 | 1773443 | 2021-10-01 | Potter | Pennsylvania | 42105 | 1557 | 29 |
1770193 | 1770193 | 2021-09-30 | Potter | Pennsylvania | 42105 | 1549 | 29 |
1766944 | 1766944 | 2021-09-29 | Potter | Pennsylvania | 42105 | 1538 | 29 |
1763695 | 1763695 | 2021-09-28 | Potter | Pennsylvania | 42105 | 1526 | 29 |
1760446 | 1760446 | 2021-09-27 | Potter | Pennsylvania | 42105 | 1497 | 29 |
1757198 | 1757198 | 2021-09-26 | Potter | Pennsylvania | 42105 | 1483 | 29 |
1753950 | 1753950 | 2021-09-25 | Potter | Pennsylvania | 42105 | 1479 | 29 |
1750702 | 1750702 | 2021-09-24 | Potter | Pennsylvania | 42105 | 1472 | 29 |
1747453 | 1747453 | 2021-09-23 | Potter | Pennsylvania | 42105 | 1467 | 29 |
1744203 | 1744203 | 2021-09-22 | Potter | Pennsylvania | 42105 | 1449 | 29 |
1740954 | 1740954 | 2021-09-21 | Potter | Pennsylvania | 42105 | 1441 | 29 |
1737705 | 1737705 | 2021-09-20 | Potter | Pennsylvania | 42105 | 1439 | 29 |
1734455 | 1734455 | 2021-09-19 | Potter | Pennsylvania | 42105 | 1437 | 29 |
1731205 | 1731205 | 2021-09-18 | Potter | Pennsylvania | 42105 | 1417 | 29 |
1727955 | 1727955 | 2021-09-17 | Potter | Pennsylvania | 42105 | 1406 | 29 |
1724706 | 1724706 | 2021-09-16 | Potter | Pennsylvania | 42105 | 1390 | 29 |
1721457 | 1721457 | 2021-09-15 | Potter | Pennsylvania | 42105 | 1370 | 27 |
1718209 | 1718209 | 2021-09-14 | Potter | Pennsylvania | 42105 | 1361 | 27 |
1714961 | 1714961 | 2021-09-13 | Potter | Pennsylvania | 42105 | 1356 | 27 |
1711715 | 1711715 | 2021-09-12 | Potter | Pennsylvania | 42105 | 1353 | 27 |
1708468 | 1708468 | 2021-09-11 | Potter | Pennsylvania | 42105 | 1348 | 27 |
1705221 | 1705221 | 2021-09-10 | Potter | Pennsylvania | 42105 | 1342 | 27 |
1701971 | 1701971 | 2021-09-09 | Potter | Pennsylvania | 42105 | 1339 | 27 |
1698722 | 1698722 | 2021-09-08 | Potter | Pennsylvania | 42105 | 1335 | 27 |
1695474 | 1695474 | 2021-09-07 | Potter | Pennsylvania | 42105 | 1331 | 27 |
1692226 | 1692226 | 2021-09-06 | Potter | Pennsylvania | 42105 | 1329 | 27 |
1688977 | 1688977 | 2021-09-05 | Potter | Pennsylvania | 42105 | 1328 | 27 |
1685727 | 1685727 | 2021-09-04 | Potter | Pennsylvania | 42105 | 1326 | 26 |
1682476 | 1682476 | 2021-09-03 | Potter | Pennsylvania | 42105 | 1320 | 26 |
1679226 | 1679226 | 2021-09-02 | Potter | Pennsylvania | 42105 | 1315 | 26 |
1675978 | 1675978 | 2021-09-01 | Potter | Pennsylvania | 42105 | 1314 | 26 |
1672731 | 1672731 | 2021-08-31 | Potter | Pennsylvania | 42105 | 1310 | 26 |
1669483 | 1669483 | 2021-08-30 | Potter | Pennsylvania | 42105 | 1308 | 26 |
1666236 | 1666236 | 2021-08-29 | Potter | Pennsylvania | 42105 | 1307 | 26 |
1662988 | 1662988 | 2021-08-28 | Potter | Pennsylvania | 42105 | 1302 | 26 |
1659740 | 1659740 | 2021-08-27 | Potter | Pennsylvania | 42105 | 1298 | 26 |
1656491 | 1656491 | 2021-08-26 | Potter | Pennsylvania | 42105 | 1296 | 26 |
1653244 | 1653244 | 2021-08-25 | Potter | Pennsylvania | 42105 | 1293 | 26 |
1649997 | 1649997 | 2021-08-24 | Potter | Pennsylvania | 42105 | 1290 | 26 |
1646748 | 1646748 | 2021-08-23 | Potter | Pennsylvania | 42105 | 1281 | 26 |
1643499 | 1643499 | 2021-08-22 | Potter | Pennsylvania | 42105 | 1280 | 26 |
1640249 | 1640249 | 2021-08-21 | Potter | Pennsylvania | 42105 | 1280 | 26 |
1636999 | 1636999 | 2021-08-20 | Potter | Pennsylvania | 42105 | 1279 | 26 |
1633749 | 1633749 | 2021-08-19 | Potter | Pennsylvania | 42105 | 1276 | 25 |
1630502 | 1630502 | 2021-08-18 | Potter | Pennsylvania | 42105 | 1274 | 25 |
1627255 | 1627255 | 2021-08-17 | Potter | Pennsylvania | 42105 | 1272 | 25 |
1624008 | 1624008 | 2021-08-16 | Potter | Pennsylvania | 42105 | 1271 | 25 |
1620761 | 1620761 | 2021-08-15 | Potter | Pennsylvania | 42105 | 1271 | 25 |
1617513 | 1617513 | 2021-08-14 | Potter | Pennsylvania | 42105 | 1268 | 25 |
1614265 | 1614265 | 2021-08-13 | Potter | Pennsylvania | 42105 | 1264 | 25 |
1611016 | 1611016 | 2021-08-12 | Potter | Pennsylvania | 42105 | 1263 | 25 |
1607768 | 1607768 | 2021-08-11 | Potter | Pennsylvania | 42105 | 1261 | 25 |
1604519 | 1604519 | 2021-08-10 | Potter | Pennsylvania | 42105 | 1258 | 25 |
1601270 | 1601270 | 2021-08-09 | Potter | Pennsylvania | 42105 | 1258 | 25 |
1598022 | 1598022 | 2021-08-08 | Potter | Pennsylvania | 42105 | 1257 | 25 |
1594773 | 1594773 | 2021-08-07 | Potter | Pennsylvania | 42105 | 1257 | 25 |
1591524 | 1591524 | 2021-08-06 | Potter | Pennsylvania | 42105 | 1253 | 25 |
1588275 | 1588275 | 2021-08-05 | Potter | Pennsylvania | 42105 | 1252 | 25 |
1585025 | 1585025 | 2021-08-04 | Potter | Pennsylvania | 42105 | 1243 | 25 |
1581775 | 1581775 | 2021-08-03 | Potter | Pennsylvania | 42105 | 1240 | 25 |
1578526 | 1578526 | 2021-08-02 | Potter | Pennsylvania | 42105 | 1239 | 25 |
1575278 | 1575278 | 2021-08-01 | Potter | Pennsylvania | 42105 | 1239 | 25 |
1572030 | 1572030 | 2021-07-31 | Potter | Pennsylvania | 42105 | 1236 | 25 |
1568782 | 1568782 | 2021-07-30 | Potter | Pennsylvania | 42105 | 1236 | 25 |
1565534 | 1565534 | 2021-07-29 | Potter | Pennsylvania | 42105 | 1235 | 25 |
1562286 | 1562286 | 2021-07-28 | Potter | Pennsylvania | 42105 | 1235 | 25 |
1559038 | 1559038 | 2021-07-27 | Potter | Pennsylvania | 42105 | 1234 | 25 |
1555791 | 1555791 | 2021-07-26 | Potter | Pennsylvania | 42105 | 1234 | 25 |
1552544 | 1552544 | 2021-07-25 | Potter | Pennsylvania | 42105 | 1234 | 25 |
1549297 | 1549297 | 2021-07-24 | Potter | Pennsylvania | 42105 | 1233 | 25 |
1546050 | 1546050 | 2021-07-23 | Potter | Pennsylvania | 42105 | 1232 | 25 |
1542803 | 1542803 | 2021-07-22 | Potter | Pennsylvania | 42105 | 1232 | 25 |
1539555 | 1539555 | 2021-07-21 | Potter | Pennsylvania | 42105 | 1232 | 25 |
1536308 | 1536308 | 2021-07-20 | Potter | Pennsylvania | 42105 | 1231 | 25 |
1533060 | 1533060 | 2021-07-19 | Potter | Pennsylvania | 42105 | 1231 | 25 |
1529813 | 1529813 | 2021-07-18 | Potter | Pennsylvania | 42105 | 1231 | 25 |
1526566 | 1526566 | 2021-07-17 | Potter | Pennsylvania | 42105 | 1231 | 25 |
1523319 | 1523319 | 2021-07-16 | Potter | Pennsylvania | 42105 | 1231 | 25 |
1520071 | 1520071 | 2021-07-15 | Potter | Pennsylvania | 42105 | 1229 | 25 |
1516823 | 1516823 | 2021-07-14 | Potter | Pennsylvania | 42105 | 1226 | 25 |
1513576 | 1513576 | 2021-07-13 | Potter | Pennsylvania | 42105 | 1226 | 25 |
1510330 | 1510330 | 2021-07-12 | Potter | Pennsylvania | 42105 | 1226 | 25 |
1507083 | 1507083 | 2021-07-11 | Potter | Pennsylvania | 42105 | 1226 | 25 |
1503837 | 1503837 | 2021-07-10 | Potter | Pennsylvania | 42105 | 1226 | 25 |
1500591 | 1500591 | 2021-07-09 | Potter | Pennsylvania | 42105 | 1226 | 25 |
1497345 | 1497345 | 2021-07-08 | Potter | Pennsylvania | 42105 | 1223 | 25 |
1494098 | 1494098 | 2021-07-07 | Potter | Pennsylvania | 42105 | 1223 | 25 |
1490851 | 1490851 | 2021-07-06 | Potter | Pennsylvania | 42105 | 1223 | 25 |
1487604 | 1487604 | 2021-07-05 | Potter | Pennsylvania | 42105 | 1223 | 25 |
1484357 | 1484357 | 2021-07-04 | Potter | Pennsylvania | 42105 | 1222 | 25 |
1481111 | 1481111 | 2021-07-03 | Potter | Pennsylvania | 42105 | 1222 | 25 |
1477864 | 1477864 | 2021-07-02 | Potter | Pennsylvania | 42105 | 1221 | 25 |
1474618 | 1474618 | 2021-07-01 | Potter | Pennsylvania | 42105 | 1221 | 25 |
1471372 | 1471372 | 2021-06-30 | Potter | Pennsylvania | 42105 | 1221 | 25 |
1468127 | 1468127 | 2021-06-29 | Potter | Pennsylvania | 42105 | 1221 | 25 |
1464882 | 1464882 | 2021-06-28 | Potter | Pennsylvania | 42105 | 1219 | 25 |
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);