ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Northumberland" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718205 | 1718205 | 2021-09-14 | Northumberland | Pennsylvania | 42097 | 10722 | 374 |
1714957 | 1714957 | 2021-09-13 | Northumberland | Pennsylvania | 42097 | 10689 | 374 |
1711711 | 1711711 | 2021-09-12 | Northumberland | Pennsylvania | 42097 | 10664 | 374 |
1708464 | 1708464 | 2021-09-11 | Northumberland | Pennsylvania | 42097 | 10630 | 374 |
1705217 | 1705217 | 2021-09-10 | Northumberland | Pennsylvania | 42097 | 10585 | 373 |
1701967 | 1701967 | 2021-09-09 | Northumberland | Pennsylvania | 42097 | 10533 | 373 |
1698718 | 1698718 | 2021-09-08 | Northumberland | Pennsylvania | 42097 | 10502 | 372 |
1695470 | 1695470 | 2021-09-07 | Northumberland | Pennsylvania | 42097 | 10473 | 372 |
1692222 | 1692222 | 2021-09-06 | Northumberland | Pennsylvania | 42097 | 10448 | 371 |
1688973 | 1688973 | 2021-09-05 | Northumberland | Pennsylvania | 42097 | 10433 | 371 |
1685723 | 1685723 | 2021-09-04 | Northumberland | Pennsylvania | 42097 | 10406 | 370 |
1682472 | 1682472 | 2021-09-03 | Northumberland | Pennsylvania | 42097 | 10359 | 368 |
1679222 | 1679222 | 2021-09-02 | Northumberland | Pennsylvania | 42097 | 10308 | 367 |
1675974 | 1675974 | 2021-09-01 | Northumberland | Pennsylvania | 42097 | 10280 | 367 |
1672727 | 1672727 | 2021-08-31 | Northumberland | Pennsylvania | 42097 | 10233 | 367 |
1669479 | 1669479 | 2021-08-30 | Northumberland | Pennsylvania | 42097 | 10203 | 367 |
1666232 | 1666232 | 2021-08-29 | Northumberland | Pennsylvania | 42097 | 10177 | 367 |
1662984 | 1662984 | 2021-08-28 | Northumberland | Pennsylvania | 42097 | 10145 | 367 |
1659736 | 1659736 | 2021-08-27 | Northumberland | Pennsylvania | 42097 | 10121 | 367 |
1656487 | 1656487 | 2021-08-26 | Northumberland | Pennsylvania | 42097 | 10092 | 367 |
1653240 | 1653240 | 2021-08-25 | Northumberland | Pennsylvania | 42097 | 10059 | 366 |
1649993 | 1649993 | 2021-08-24 | Northumberland | Pennsylvania | 42097 | 10029 | 366 |
1646744 | 1646744 | 2021-08-23 | Northumberland | Pennsylvania | 42097 | 10009 | 366 |
1643495 | 1643495 | 2021-08-22 | Northumberland | Pennsylvania | 42097 | 9994 | 366 |
1640245 | 1640245 | 2021-08-21 | Northumberland | Pennsylvania | 42097 | 9984 | 366 |
1636995 | 1636995 | 2021-08-20 | Northumberland | Pennsylvania | 42097 | 9967 | 366 |
1633745 | 1633745 | 2021-08-19 | Northumberland | Pennsylvania | 42097 | 9953 | 366 |
1630498 | 1630498 | 2021-08-18 | Northumberland | Pennsylvania | 42097 | 9933 | 366 |
1627251 | 1627251 | 2021-08-17 | Northumberland | Pennsylvania | 42097 | 9910 | 365 |
1624004 | 1624004 | 2021-08-16 | Northumberland | Pennsylvania | 42097 | 9888 | 365 |
1620757 | 1620757 | 2021-08-15 | Northumberland | Pennsylvania | 42097 | 9884 | 365 |
1617509 | 1617509 | 2021-08-14 | Northumberland | Pennsylvania | 42097 | 9881 | 365 |
1614261 | 1614261 | 2021-08-13 | Northumberland | Pennsylvania | 42097 | 9867 | 365 |
1611012 | 1611012 | 2021-08-12 | Northumberland | Pennsylvania | 42097 | 9856 | 365 |
1607764 | 1607764 | 2021-08-11 | Northumberland | Pennsylvania | 42097 | 9845 | 365 |
1604515 | 1604515 | 2021-08-10 | Northumberland | Pennsylvania | 42097 | 9833 | 365 |
1601266 | 1601266 | 2021-08-09 | Northumberland | Pennsylvania | 42097 | 9826 | 365 |
1598018 | 1598018 | 2021-08-08 | Northumberland | Pennsylvania | 42097 | 9813 | 365 |
1594769 | 1594769 | 2021-08-07 | Northumberland | Pennsylvania | 42097 | 9813 | 365 |
1591520 | 1591520 | 2021-08-06 | Northumberland | Pennsylvania | 42097 | 9803 | 365 |
1588271 | 1588271 | 2021-08-05 | Northumberland | Pennsylvania | 42097 | 9796 | 365 |
1585021 | 1585021 | 2021-08-04 | Northumberland | Pennsylvania | 42097 | 9789 | 365 |
1581771 | 1581771 | 2021-08-03 | Northumberland | Pennsylvania | 42097 | 9783 | 365 |
1578522 | 1578522 | 2021-08-02 | Northumberland | Pennsylvania | 42097 | 9778 | 365 |
1575274 | 1575274 | 2021-08-01 | Northumberland | Pennsylvania | 42097 | 9776 | 365 |
1572026 | 1572026 | 2021-07-31 | Northumberland | Pennsylvania | 42097 | 9760 | 365 |
1568778 | 1568778 | 2021-07-30 | Northumberland | Pennsylvania | 42097 | 9760 | 365 |
1565530 | 1565530 | 2021-07-29 | Northumberland | Pennsylvania | 42097 | 9754 | 365 |
1562282 | 1562282 | 2021-07-28 | Northumberland | Pennsylvania | 42097 | 9747 | 365 |
1559034 | 1559034 | 2021-07-27 | Northumberland | Pennsylvania | 42097 | 9746 | 365 |
1555787 | 1555787 | 2021-07-26 | Northumberland | Pennsylvania | 42097 | 9741 | 365 |
1552540 | 1552540 | 2021-07-25 | Northumberland | Pennsylvania | 42097 | 9739 | 365 |
1549293 | 1549293 | 2021-07-24 | Northumberland | Pennsylvania | 42097 | 9738 | 365 |
1546046 | 1546046 | 2021-07-23 | Northumberland | Pennsylvania | 42097 | 9739 | 365 |
1542799 | 1542799 | 2021-07-22 | Northumberland | Pennsylvania | 42097 | 9738 | 365 |
1539551 | 1539551 | 2021-07-21 | Northumberland | Pennsylvania | 42097 | 9736 | 365 |
1536304 | 1536304 | 2021-07-20 | Northumberland | Pennsylvania | 42097 | 9734 | 364 |
1533056 | 1533056 | 2021-07-19 | Northumberland | Pennsylvania | 42097 | 9733 | 364 |
1529809 | 1529809 | 2021-07-18 | Northumberland | Pennsylvania | 42097 | 9732 | 364 |
1526562 | 1526562 | 2021-07-17 | Northumberland | Pennsylvania | 42097 | 9731 | 364 |
1523315 | 1523315 | 2021-07-16 | Northumberland | Pennsylvania | 42097 | 9732 | 364 |
1520067 | 1520067 | 2021-07-15 | Northumberland | Pennsylvania | 42097 | 9729 | 364 |
1516819 | 1516819 | 2021-07-14 | Northumberland | Pennsylvania | 42097 | 9729 | 363 |
1513572 | 1513572 | 2021-07-13 | Northumberland | Pennsylvania | 42097 | 9728 | 362 |
1510326 | 1510326 | 2021-07-12 | Northumberland | Pennsylvania | 42097 | 9728 | 362 |
1507079 | 1507079 | 2021-07-11 | Northumberland | Pennsylvania | 42097 | 9727 | 362 |
1503833 | 1503833 | 2021-07-10 | Northumberland | Pennsylvania | 42097 | 9726 | 362 |
1500587 | 1500587 | 2021-07-09 | Northumberland | Pennsylvania | 42097 | 9726 | 362 |
1497341 | 1497341 | 2021-07-08 | Northumberland | Pennsylvania | 42097 | 9726 | 362 |
1494094 | 1494094 | 2021-07-07 | Northumberland | Pennsylvania | 42097 | 9723 | 361 |
1490847 | 1490847 | 2021-07-06 | Northumberland | Pennsylvania | 42097 | 9721 | 360 |
1487600 | 1487600 | 2021-07-05 | Northumberland | Pennsylvania | 42097 | 9721 | 360 |
1484353 | 1484353 | 2021-07-04 | Northumberland | Pennsylvania | 42097 | 9720 | 360 |
1481107 | 1481107 | 2021-07-03 | Northumberland | Pennsylvania | 42097 | 9720 | 360 |
1477860 | 1477860 | 2021-07-02 | Northumberland | Pennsylvania | 42097 | 9718 | 360 |
1474614 | 1474614 | 2021-07-01 | Northumberland | Pennsylvania | 42097 | 9717 | 360 |
1471368 | 1471368 | 2021-06-30 | Northumberland | Pennsylvania | 42097 | 9714 | 360 |
1468123 | 1468123 | 2021-06-29 | Northumberland | Pennsylvania | 42097 | 9712 | 360 |
1464878 | 1464878 | 2021-06-28 | Northumberland | Pennsylvania | 42097 | 9711 | 360 |
1461633 | 1461633 | 2021-06-27 | Northumberland | Pennsylvania | 42097 | 9711 | 360 |
1458388 | 1458388 | 2021-06-26 | Northumberland | Pennsylvania | 42097 | 9711 | 360 |
1455143 | 1455143 | 2021-06-25 | Northumberland | Pennsylvania | 42097 | 9712 | 360 |
1451898 | 1451898 | 2021-06-24 | Northumberland | Pennsylvania | 42097 | 9711 | 360 |
1448652 | 1448652 | 2021-06-23 | Northumberland | Pennsylvania | 42097 | 9711 | 360 |
1445407 | 1445407 | 2021-06-22 | Northumberland | Pennsylvania | 42097 | 9708 | 360 |
1442162 | 1442162 | 2021-06-21 | Northumberland | Pennsylvania | 42097 | 9706 | 358 |
1438917 | 1438917 | 2021-06-20 | Northumberland | Pennsylvania | 42097 | 9705 | 357 |
1435670 | 1435670 | 2021-06-19 | Northumberland | Pennsylvania | 42097 | 9704 | 357 |
1432423 | 1432423 | 2021-06-18 | Northumberland | Pennsylvania | 42097 | 9704 | 357 |
1429177 | 1429177 | 2021-06-17 | Northumberland | Pennsylvania | 42097 | 9699 | 357 |
1425932 | 1425932 | 2021-06-16 | Northumberland | Pennsylvania | 42097 | 9695 | 357 |
1422685 | 1422685 | 2021-06-15 | Northumberland | Pennsylvania | 42097 | 9693 | 357 |
1419439 | 1419439 | 2021-06-14 | Northumberland | Pennsylvania | 42097 | 9692 | 356 |
1416194 | 1416194 | 2021-06-13 | Northumberland | Pennsylvania | 42097 | 9691 | 356 |
1412948 | 1412948 | 2021-06-12 | Northumberland | Pennsylvania | 42097 | 9691 | 356 |
1409703 | 1409703 | 2021-06-11 | Northumberland | Pennsylvania | 42097 | 9689 | 356 |
1406458 | 1406458 | 2021-06-10 | Northumberland | Pennsylvania | 42097 | 9688 | 356 |
1403212 | 1403212 | 2021-06-09 | Northumberland | Pennsylvania | 42097 | 9683 | 356 |
1399967 | 1399967 | 2021-06-08 | Northumberland | Pennsylvania | 42097 | 9680 | 357 |
1396722 | 1396722 | 2021-06-07 | Northumberland | Pennsylvania | 42097 | 9671 | 357 |
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);