ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Carbon" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718169 | 1718169 | 2021-09-14 | Carbon | Pennsylvania | 42025 | 7224 | 181 |
1714921 | 1714921 | 2021-09-13 | Carbon | Pennsylvania | 42025 | 7183 | 180 |
1711675 | 1711675 | 2021-09-12 | Carbon | Pennsylvania | 42025 | 7177 | 180 |
1708428 | 1708428 | 2021-09-11 | Carbon | Pennsylvania | 42025 | 7164 | 180 |
1705181 | 1705181 | 2021-09-10 | Carbon | Pennsylvania | 42025 | 7104 | 179 |
1701931 | 1701931 | 2021-09-09 | Carbon | Pennsylvania | 42025 | 7034 | 178 |
1698682 | 1698682 | 2021-09-08 | Carbon | Pennsylvania | 42025 | 7002 | 178 |
1695434 | 1695434 | 2021-09-07 | Carbon | Pennsylvania | 42025 | 6972 | 178 |
1692186 | 1692186 | 2021-09-06 | Carbon | Pennsylvania | 42025 | 6958 | 178 |
1688937 | 1688937 | 2021-09-05 | Carbon | Pennsylvania | 42025 | 6946 | 178 |
1685687 | 1685687 | 2021-09-04 | Carbon | Pennsylvania | 42025 | 6932 | 177 |
1682436 | 1682436 | 2021-09-03 | Carbon | Pennsylvania | 42025 | 6906 | 177 |
1679186 | 1679186 | 2021-09-02 | Carbon | Pennsylvania | 42025 | 6873 | 177 |
1675938 | 1675938 | 2021-09-01 | Carbon | Pennsylvania | 42025 | 6840 | 176 |
1672691 | 1672691 | 2021-08-31 | Carbon | Pennsylvania | 42025 | 6808 | 176 |
1669443 | 1669443 | 2021-08-30 | Carbon | Pennsylvania | 42025 | 6796 | 176 |
1666196 | 1666196 | 2021-08-29 | Carbon | Pennsylvania | 42025 | 6789 | 176 |
1662948 | 1662948 | 2021-08-28 | Carbon | Pennsylvania | 42025 | 6776 | 176 |
1659700 | 1659700 | 2021-08-27 | Carbon | Pennsylvania | 42025 | 6759 | 176 |
1656451 | 1656451 | 2021-08-26 | Carbon | Pennsylvania | 42025 | 6733 | 176 |
1653204 | 1653204 | 2021-08-25 | Carbon | Pennsylvania | 42025 | 6724 | 176 |
1649957 | 1649957 | 2021-08-24 | Carbon | Pennsylvania | 42025 | 6703 | 176 |
1646708 | 1646708 | 2021-08-23 | Carbon | Pennsylvania | 42025 | 6674 | 176 |
1643459 | 1643459 | 2021-08-22 | Carbon | Pennsylvania | 42025 | 6665 | 176 |
1640209 | 1640209 | 2021-08-21 | Carbon | Pennsylvania | 42025 | 6656 | 176 |
1636959 | 1636959 | 2021-08-20 | Carbon | Pennsylvania | 42025 | 6644 | 176 |
1633709 | 1633709 | 2021-08-19 | Carbon | Pennsylvania | 42025 | 6632 | 176 |
1630462 | 1630462 | 2021-08-18 | Carbon | Pennsylvania | 42025 | 6620 | 176 |
1627215 | 1627215 | 2021-08-17 | Carbon | Pennsylvania | 42025 | 6610 | 176 |
1623968 | 1623968 | 2021-08-16 | Carbon | Pennsylvania | 42025 | 6591 | 176 |
1620721 | 1620721 | 2021-08-15 | Carbon | Pennsylvania | 42025 | 6585 | 176 |
1617473 | 1617473 | 2021-08-14 | Carbon | Pennsylvania | 42025 | 6573 | 176 |
1614225 | 1614225 | 2021-08-13 | Carbon | Pennsylvania | 42025 | 6557 | 176 |
1610976 | 1610976 | 2021-08-12 | Carbon | Pennsylvania | 42025 | 6546 | 176 |
1607728 | 1607728 | 2021-08-11 | Carbon | Pennsylvania | 42025 | 6533 | 176 |
1604479 | 1604479 | 2021-08-10 | Carbon | Pennsylvania | 42025 | 6525 | 176 |
1601230 | 1601230 | 2021-08-09 | Carbon | Pennsylvania | 42025 | 6513 | 176 |
1597982 | 1597982 | 2021-08-08 | Carbon | Pennsylvania | 42025 | 6511 | 176 |
1594733 | 1594733 | 2021-08-07 | Carbon | Pennsylvania | 42025 | 6511 | 176 |
1591484 | 1591484 | 2021-08-06 | Carbon | Pennsylvania | 42025 | 6499 | 176 |
1588235 | 1588235 | 2021-08-05 | Carbon | Pennsylvania | 42025 | 6488 | 176 |
1584985 | 1584985 | 2021-08-04 | Carbon | Pennsylvania | 42025 | 6482 | 176 |
1581735 | 1581735 | 2021-08-03 | Carbon | Pennsylvania | 42025 | 6473 | 176 |
1578486 | 1578486 | 2021-08-02 | Carbon | Pennsylvania | 42025 | 6465 | 176 |
1575238 | 1575238 | 2021-08-01 | Carbon | Pennsylvania | 42025 | 6464 | 176 |
1571990 | 1571990 | 2021-07-31 | Carbon | Pennsylvania | 42025 | 6455 | 176 |
1568742 | 1568742 | 2021-07-30 | Carbon | Pennsylvania | 42025 | 6455 | 176 |
1565494 | 1565494 | 2021-07-29 | Carbon | Pennsylvania | 42025 | 6454 | 176 |
1562246 | 1562246 | 2021-07-28 | Carbon | Pennsylvania | 42025 | 6448 | 176 |
1558998 | 1558998 | 2021-07-27 | Carbon | Pennsylvania | 42025 | 6446 | 176 |
1555751 | 1555751 | 2021-07-26 | Carbon | Pennsylvania | 42025 | 6443 | 176 |
1552504 | 1552504 | 2021-07-25 | Carbon | Pennsylvania | 42025 | 6440 | 176 |
1549257 | 1549257 | 2021-07-24 | Carbon | Pennsylvania | 42025 | 6439 | 176 |
1546010 | 1546010 | 2021-07-23 | Carbon | Pennsylvania | 42025 | 6432 | 176 |
1542763 | 1542763 | 2021-07-22 | Carbon | Pennsylvania | 42025 | 6429 | 176 |
1539515 | 1539515 | 2021-07-21 | Carbon | Pennsylvania | 42025 | 6427 | 176 |
1536268 | 1536268 | 2021-07-20 | Carbon | Pennsylvania | 42025 | 6423 | 176 |
1533020 | 1533020 | 2021-07-19 | Carbon | Pennsylvania | 42025 | 6415 | 176 |
1529773 | 1529773 | 2021-07-18 | Carbon | Pennsylvania | 42025 | 6412 | 176 |
1526526 | 1526526 | 2021-07-17 | Carbon | Pennsylvania | 42025 | 6412 | 176 |
1523279 | 1523279 | 2021-07-16 | Carbon | Pennsylvania | 42025 | 6411 | 176 |
1520031 | 1520031 | 2021-07-15 | Carbon | Pennsylvania | 42025 | 6410 | 176 |
1516783 | 1516783 | 2021-07-14 | Carbon | Pennsylvania | 42025 | 6408 | 176 |
1513536 | 1513536 | 2021-07-13 | Carbon | Pennsylvania | 42025 | 6407 | 176 |
1510290 | 1510290 | 2021-07-12 | Carbon | Pennsylvania | 42025 | 6405 | 176 |
1507043 | 1507043 | 2021-07-11 | Carbon | Pennsylvania | 42025 | 6404 | 176 |
1503797 | 1503797 | 2021-07-10 | Carbon | Pennsylvania | 42025 | 6404 | 176 |
1500551 | 1500551 | 2021-07-09 | Carbon | Pennsylvania | 42025 | 6403 | 176 |
1497305 | 1497305 | 2021-07-08 | Carbon | Pennsylvania | 42025 | 6403 | 176 |
1494058 | 1494058 | 2021-07-07 | Carbon | Pennsylvania | 42025 | 6402 | 176 |
1490811 | 1490811 | 2021-07-06 | Carbon | Pennsylvania | 42025 | 6402 | 176 |
1487564 | 1487564 | 2021-07-05 | Carbon | Pennsylvania | 42025 | 6402 | 176 |
1484317 | 1484317 | 2021-07-04 | Carbon | Pennsylvania | 42025 | 6402 | 176 |
1481071 | 1481071 | 2021-07-03 | Carbon | Pennsylvania | 42025 | 6402 | 176 |
1477824 | 1477824 | 2021-07-02 | Carbon | Pennsylvania | 42025 | 6402 | 176 |
1474578 | 1474578 | 2021-07-01 | Carbon | Pennsylvania | 42025 | 6401 | 176 |
1471332 | 1471332 | 2021-06-30 | Carbon | Pennsylvania | 42025 | 6401 | 176 |
1468087 | 1468087 | 2021-06-29 | Carbon | Pennsylvania | 42025 | 6401 | 176 |
1464842 | 1464842 | 2021-06-28 | Carbon | Pennsylvania | 42025 | 6399 | 176 |
1461597 | 1461597 | 2021-06-27 | Carbon | Pennsylvania | 42025 | 6398 | 176 |
1458352 | 1458352 | 2021-06-26 | Carbon | Pennsylvania | 42025 | 6398 | 176 |
1455107 | 1455107 | 2021-06-25 | Carbon | Pennsylvania | 42025 | 6396 | 176 |
1451862 | 1451862 | 2021-06-24 | Carbon | Pennsylvania | 42025 | 6396 | 176 |
1448616 | 1448616 | 2021-06-23 | Carbon | Pennsylvania | 42025 | 6394 | 175 |
1445371 | 1445371 | 2021-06-22 | Carbon | Pennsylvania | 42025 | 6393 | 175 |
1442126 | 1442126 | 2021-06-21 | Carbon | Pennsylvania | 42025 | 6392 | 175 |
1438881 | 1438881 | 2021-06-20 | Carbon | Pennsylvania | 42025 | 6391 | 175 |
1435634 | 1435634 | 2021-06-19 | Carbon | Pennsylvania | 42025 | 6391 | 175 |
1432387 | 1432387 | 2021-06-18 | Carbon | Pennsylvania | 42025 | 6390 | 175 |
1429141 | 1429141 | 2021-06-17 | Carbon | Pennsylvania | 42025 | 6389 | 175 |
1425896 | 1425896 | 2021-06-16 | Carbon | Pennsylvania | 42025 | 6388 | 174 |
1422649 | 1422649 | 2021-06-15 | Carbon | Pennsylvania | 42025 | 6387 | 174 |
1419403 | 1419403 | 2021-06-14 | Carbon | Pennsylvania | 42025 | 6387 | 174 |
1416158 | 1416158 | 2021-06-13 | Carbon | Pennsylvania | 42025 | 6387 | 174 |
1412912 | 1412912 | 2021-06-12 | Carbon | Pennsylvania | 42025 | 6386 | 174 |
1409667 | 1409667 | 2021-06-11 | Carbon | Pennsylvania | 42025 | 6385 | 174 |
1406422 | 1406422 | 2021-06-10 | Carbon | Pennsylvania | 42025 | 6384 | 173 |
1403176 | 1403176 | 2021-06-09 | Carbon | Pennsylvania | 42025 | 6377 | 173 |
1399931 | 1399931 | 2021-06-08 | Carbon | Pennsylvania | 42025 | 6376 | 173 |
1396686 | 1396686 | 2021-06-07 | Carbon | Pennsylvania | 42025 | 6372 | 172 |
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);