ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Cambria" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718167 | 1718167 | 2021-09-14 | Cambria | Pennsylvania | 42021 | 16134 | 454 |
1714919 | 1714919 | 2021-09-13 | Cambria | Pennsylvania | 42021 | 16079 | 453 |
1711673 | 1711673 | 2021-09-12 | Cambria | Pennsylvania | 42021 | 16038 | 453 |
1708426 | 1708426 | 2021-09-11 | Cambria | Pennsylvania | 42021 | 16016 | 453 |
1705179 | 1705179 | 2021-09-10 | Cambria | Pennsylvania | 42021 | 15923 | 452 |
1701929 | 1701929 | 2021-09-09 | Cambria | Pennsylvania | 42021 | 15860 | 451 |
1698680 | 1698680 | 2021-09-08 | Cambria | Pennsylvania | 42021 | 15790 | 451 |
1695432 | 1695432 | 2021-09-07 | Cambria | Pennsylvania | 42021 | 15722 | 451 |
1692184 | 1692184 | 2021-09-06 | Cambria | Pennsylvania | 42021 | 15708 | 451 |
1688935 | 1688935 | 2021-09-05 | Cambria | Pennsylvania | 42021 | 15685 | 451 |
1685685 | 1685685 | 2021-09-04 | Cambria | Pennsylvania | 42021 | 15654 | 450 |
1682434 | 1682434 | 2021-09-03 | Cambria | Pennsylvania | 42021 | 15602 | 450 |
1679184 | 1679184 | 2021-09-02 | Cambria | Pennsylvania | 42021 | 15570 | 449 |
1675936 | 1675936 | 2021-09-01 | Cambria | Pennsylvania | 42021 | 15544 | 449 |
1672689 | 1672689 | 2021-08-31 | Cambria | Pennsylvania | 42021 | 15507 | 449 |
1669441 | 1669441 | 2021-08-30 | Cambria | Pennsylvania | 42021 | 15470 | 448 |
1666194 | 1666194 | 2021-08-29 | Cambria | Pennsylvania | 42021 | 15458 | 448 |
1662946 | 1662946 | 2021-08-28 | Cambria | Pennsylvania | 42021 | 15424 | 448 |
1659698 | 1659698 | 2021-08-27 | Cambria | Pennsylvania | 42021 | 15383 | 448 |
1656449 | 1656449 | 2021-08-26 | Cambria | Pennsylvania | 42021 | 15361 | 448 |
1653202 | 1653202 | 2021-08-25 | Cambria | Pennsylvania | 42021 | 15328 | 447 |
1649955 | 1649955 | 2021-08-24 | Cambria | Pennsylvania | 42021 | 15260 | 446 |
1646706 | 1646706 | 2021-08-23 | Cambria | Pennsylvania | 42021 | 15229 | 446 |
1643457 | 1643457 | 2021-08-22 | Cambria | Pennsylvania | 42021 | 15220 | 446 |
1640207 | 1640207 | 2021-08-21 | Cambria | Pennsylvania | 42021 | 15213 | 446 |
1636957 | 1636957 | 2021-08-20 | Cambria | Pennsylvania | 42021 | 15198 | 445 |
1633707 | 1633707 | 2021-08-19 | Cambria | Pennsylvania | 42021 | 15174 | 444 |
1630460 | 1630460 | 2021-08-18 | Cambria | Pennsylvania | 42021 | 15149 | 443 |
1627213 | 1627213 | 2021-08-17 | Cambria | Pennsylvania | 42021 | 15121 | 442 |
1623966 | 1623966 | 2021-08-16 | Cambria | Pennsylvania | 42021 | 15101 | 442 |
1620719 | 1620719 | 2021-08-15 | Cambria | Pennsylvania | 42021 | 15091 | 442 |
1617471 | 1617471 | 2021-08-14 | Cambria | Pennsylvania | 42021 | 15081 | 442 |
1614223 | 1614223 | 2021-08-13 | Cambria | Pennsylvania | 42021 | 15069 | 442 |
1610974 | 1610974 | 2021-08-12 | Cambria | Pennsylvania | 42021 | 15058 | 442 |
1607726 | 1607726 | 2021-08-11 | Cambria | Pennsylvania | 42021 | 15047 | 442 |
1604477 | 1604477 | 2021-08-10 | Cambria | Pennsylvania | 42021 | 15036 | 442 |
1601228 | 1601228 | 2021-08-09 | Cambria | Pennsylvania | 42021 | 15015 | 441 |
1597980 | 1597980 | 2021-08-08 | Cambria | Pennsylvania | 42021 | 15004 | 441 |
1594731 | 1594731 | 2021-08-07 | Cambria | Pennsylvania | 42021 | 15004 | 441 |
1591482 | 1591482 | 2021-08-06 | Cambria | Pennsylvania | 42021 | 14991 | 441 |
1588233 | 1588233 | 2021-08-05 | Cambria | Pennsylvania | 42021 | 14981 | 441 |
1584983 | 1584983 | 2021-08-04 | Cambria | Pennsylvania | 42021 | 14971 | 441 |
1581733 | 1581733 | 2021-08-03 | Cambria | Pennsylvania | 42021 | 14957 | 441 |
1578484 | 1578484 | 2021-08-02 | Cambria | Pennsylvania | 42021 | 14937 | 441 |
1575236 | 1575236 | 2021-08-01 | Cambria | Pennsylvania | 42021 | 14931 | 441 |
1571988 | 1571988 | 2021-07-31 | Cambria | Pennsylvania | 42021 | 14919 | 441 |
1568740 | 1568740 | 2021-07-30 | Cambria | Pennsylvania | 42021 | 14919 | 441 |
1565492 | 1565492 | 2021-07-29 | Cambria | Pennsylvania | 42021 | 14906 | 441 |
1562244 | 1562244 | 2021-07-28 | Cambria | Pennsylvania | 42021 | 14900 | 441 |
1558996 | 1558996 | 2021-07-27 | Cambria | Pennsylvania | 42021 | 14890 | 441 |
1555749 | 1555749 | 2021-07-26 | Cambria | Pennsylvania | 42021 | 14881 | 441 |
1552502 | 1552502 | 2021-07-25 | Cambria | Pennsylvania | 42021 | 14879 | 441 |
1549255 | 1549255 | 2021-07-24 | Cambria | Pennsylvania | 42021 | 14875 | 441 |
1546008 | 1546008 | 2021-07-23 | Cambria | Pennsylvania | 42021 | 14867 | 441 |
1542761 | 1542761 | 2021-07-22 | Cambria | Pennsylvania | 42021 | 14863 | 441 |
1539513 | 1539513 | 2021-07-21 | Cambria | Pennsylvania | 42021 | 14860 | 441 |
1536266 | 1536266 | 2021-07-20 | Cambria | Pennsylvania | 42021 | 14858 | 441 |
1533018 | 1533018 | 2021-07-19 | Cambria | Pennsylvania | 42021 | 14853 | 441 |
1529771 | 1529771 | 2021-07-18 | Cambria | Pennsylvania | 42021 | 14852 | 441 |
1526524 | 1526524 | 2021-07-17 | Cambria | Pennsylvania | 42021 | 14852 | 441 |
1523277 | 1523277 | 2021-07-16 | Cambria | Pennsylvania | 42021 | 14852 | 441 |
1520029 | 1520029 | 2021-07-15 | Cambria | Pennsylvania | 42021 | 14849 | 441 |
1516781 | 1516781 | 2021-07-14 | Cambria | Pennsylvania | 42021 | 14844 | 441 |
1513534 | 1513534 | 2021-07-13 | Cambria | Pennsylvania | 42021 | 14842 | 441 |
1510288 | 1510288 | 2021-07-12 | Cambria | Pennsylvania | 42021 | 14837 | 441 |
1507041 | 1507041 | 2021-07-11 | Cambria | Pennsylvania | 42021 | 14837 | 441 |
1503795 | 1503795 | 2021-07-10 | Cambria | Pennsylvania | 42021 | 14836 | 441 |
1500549 | 1500549 | 2021-07-09 | Cambria | Pennsylvania | 42021 | 14836 | 441 |
1497303 | 1497303 | 2021-07-08 | Cambria | Pennsylvania | 42021 | 14834 | 441 |
1494056 | 1494056 | 2021-07-07 | Cambria | Pennsylvania | 42021 | 14834 | 441 |
1490809 | 1490809 | 2021-07-06 | Cambria | Pennsylvania | 42021 | 14833 | 441 |
1487562 | 1487562 | 2021-07-05 | Cambria | Pennsylvania | 42021 | 14831 | 441 |
1484315 | 1484315 | 2021-07-04 | Cambria | Pennsylvania | 42021 | 14831 | 441 |
1481069 | 1481069 | 2021-07-03 | Cambria | Pennsylvania | 42021 | 14831 | 441 |
1477822 | 1477822 | 2021-07-02 | Cambria | Pennsylvania | 42021 | 14829 | 441 |
1474576 | 1474576 | 2021-07-01 | Cambria | Pennsylvania | 42021 | 14828 | 441 |
1471330 | 1471330 | 2021-06-30 | Cambria | Pennsylvania | 42021 | 14828 | 440 |
1468085 | 1468085 | 2021-06-29 | Cambria | Pennsylvania | 42021 | 14825 | 440 |
1464840 | 1464840 | 2021-06-28 | Cambria | Pennsylvania | 42021 | 14822 | 440 |
1461595 | 1461595 | 2021-06-27 | Cambria | Pennsylvania | 42021 | 14822 | 440 |
1458350 | 1458350 | 2021-06-26 | Cambria | Pennsylvania | 42021 | 14821 | 440 |
1455105 | 1455105 | 2021-06-25 | Cambria | Pennsylvania | 42021 | 14820 | 440 |
1451860 | 1451860 | 2021-06-24 | Cambria | Pennsylvania | 42021 | 14818 | 439 |
1448614 | 1448614 | 2021-06-23 | Cambria | Pennsylvania | 42021 | 14816 | 438 |
1445369 | 1445369 | 2021-06-22 | Cambria | Pennsylvania | 42021 | 14815 | 438 |
1442124 | 1442124 | 2021-06-21 | Cambria | Pennsylvania | 42021 | 14809 | 438 |
1438879 | 1438879 | 2021-06-20 | Cambria | Pennsylvania | 42021 | 14808 | 438 |
1435632 | 1435632 | 2021-06-19 | Cambria | Pennsylvania | 42021 | 14807 | 438 |
1432385 | 1432385 | 2021-06-18 | Cambria | Pennsylvania | 42021 | 14804 | 438 |
1429139 | 1429139 | 2021-06-17 | Cambria | Pennsylvania | 42021 | 14801 | 437 |
1425894 | 1425894 | 2021-06-16 | Cambria | Pennsylvania | 42021 | 14797 | 437 |
1422647 | 1422647 | 2021-06-15 | Cambria | Pennsylvania | 42021 | 14790 | 437 |
1419401 | 1419401 | 2021-06-14 | Cambria | Pennsylvania | 42021 | 14768 | 437 |
1416156 | 1416156 | 2021-06-13 | Cambria | Pennsylvania | 42021 | 14754 | 436 |
1412910 | 1412910 | 2021-06-12 | Cambria | Pennsylvania | 42021 | 14750 | 435 |
1409665 | 1409665 | 2021-06-11 | Cambria | Pennsylvania | 42021 | 14741 | 435 |
1406420 | 1406420 | 2021-06-10 | Cambria | Pennsylvania | 42021 | 14729 | 435 |
1403174 | 1403174 | 2021-06-09 | Cambria | Pennsylvania | 42021 | 14713 | 434 |
1399929 | 1399929 | 2021-06-08 | Cambria | Pennsylvania | 42021 | 14703 | 434 |
1396684 | 1396684 | 2021-06-07 | Cambria | Pennsylvania | 42021 | 14696 | 434 |
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);