ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Allegheny" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718158 | 1718158 | 2021-09-14 | Allegheny | Pennsylvania | 42003 | 114358 | 2101 |
1714910 | 1714910 | 2021-09-13 | Allegheny | Pennsylvania | 42003 | 114110 | 2094 |
1711664 | 1711664 | 2021-09-12 | Allegheny | Pennsylvania | 42003 | 113782 | 2094 |
1708417 | 1708417 | 2021-09-11 | Allegheny | Pennsylvania | 42003 | 113472 | 2094 |
1705170 | 1705170 | 2021-09-10 | Allegheny | Pennsylvania | 42003 | 113063 | 2091 |
1701920 | 1701920 | 2021-09-09 | Allegheny | Pennsylvania | 42003 | 112702 | 2089 |
1698671 | 1698671 | 2021-09-08 | Allegheny | Pennsylvania | 42003 | 112368 | 2086 |
1695423 | 1695423 | 2021-09-07 | Allegheny | Pennsylvania | 42003 | 111918 | 2084 |
1692175 | 1692175 | 2021-09-06 | Allegheny | Pennsylvania | 42003 | 111673 | 2083 |
1688926 | 1688926 | 2021-09-05 | Allegheny | Pennsylvania | 42003 | 111452 | 2083 |
1685676 | 1685676 | 2021-09-04 | Allegheny | Pennsylvania | 42003 | 111145 | 2082 |
1682425 | 1682425 | 2021-09-03 | Allegheny | Pennsylvania | 42003 | 110761 | 2081 |
1679175 | 1679175 | 2021-09-02 | Allegheny | Pennsylvania | 42003 | 110456 | 2076 |
1675927 | 1675927 | 2021-09-01 | Allegheny | Pennsylvania | 42003 | 109996 | 2066 |
1672680 | 1672680 | 2021-08-31 | Allegheny | Pennsylvania | 42003 | 109797 | 2066 |
1669432 | 1669432 | 2021-08-30 | Allegheny | Pennsylvania | 42003 | 109534 | 2065 |
1666185 | 1666185 | 2021-08-29 | Allegheny | Pennsylvania | 42003 | 109226 | 2065 |
1662937 | 1662937 | 2021-08-28 | Allegheny | Pennsylvania | 42003 | 108989 | 2065 |
1659689 | 1659689 | 2021-08-27 | Allegheny | Pennsylvania | 42003 | 108589 | 2063 |
1656440 | 1656440 | 2021-08-26 | Allegheny | Pennsylvania | 42003 | 108318 | 2062 |
1653193 | 1653193 | 2021-08-25 | Allegheny | Pennsylvania | 42003 | 108052 | 2060 |
1649946 | 1649946 | 2021-08-24 | Allegheny | Pennsylvania | 42003 | 107734 | 2057 |
1646697 | 1646697 | 2021-08-23 | Allegheny | Pennsylvania | 42003 | 107471 | 2054 |
1643448 | 1643448 | 2021-08-22 | Allegheny | Pennsylvania | 42003 | 107284 | 2054 |
1640198 | 1640198 | 2021-08-21 | Allegheny | Pennsylvania | 42003 | 107058 | 2054 |
1636948 | 1636948 | 2021-08-20 | Allegheny | Pennsylvania | 42003 | 106770 | 2052 |
1633698 | 1633698 | 2021-08-19 | Allegheny | Pennsylvania | 42003 | 106560 | 2051 |
1630451 | 1630451 | 2021-08-18 | Allegheny | Pennsylvania | 42003 | 106150 | 2047 |
1627204 | 1627204 | 2021-08-17 | Allegheny | Pennsylvania | 42003 | 105979 | 2042 |
1623957 | 1623957 | 2021-08-16 | Allegheny | Pennsylvania | 42003 | 105805 | 2038 |
1620710 | 1620710 | 2021-08-15 | Allegheny | Pennsylvania | 42003 | 105664 | 2038 |
1617462 | 1617462 | 2021-08-14 | Allegheny | Pennsylvania | 42003 | 105447 | 2038 |
1614214 | 1614214 | 2021-08-13 | Allegheny | Pennsylvania | 42003 | 105207 | 2037 |
1610965 | 1610965 | 2021-08-12 | Allegheny | Pennsylvania | 42003 | 105045 | 2035 |
1607717 | 1607717 | 2021-08-11 | Allegheny | Pennsylvania | 42003 | 104807 | 2032 |
1604468 | 1604468 | 2021-08-10 | Allegheny | Pennsylvania | 42003 | 104658 | 2032 |
1601219 | 1601219 | 2021-08-09 | Allegheny | Pennsylvania | 42003 | 104430 | 2030 |
1597971 | 1597971 | 2021-08-08 | Allegheny | Pennsylvania | 42003 | 104185 | 2030 |
1594722 | 1594722 | 2021-08-07 | Allegheny | Pennsylvania | 42003 | 104185 | 2030 |
1591473 | 1591473 | 2021-08-06 | Allegheny | Pennsylvania | 42003 | 104042 | 2030 |
1588224 | 1588224 | 2021-08-05 | Allegheny | Pennsylvania | 42003 | 103866 | 2030 |
1584974 | 1584974 | 2021-08-04 | Allegheny | Pennsylvania | 42003 | 103646 | 2030 |
1581724 | 1581724 | 2021-08-03 | Allegheny | Pennsylvania | 42003 | 103529 | 2029 |
1578475 | 1578475 | 2021-08-02 | Allegheny | Pennsylvania | 42003 | 103378 | 2028 |
1575227 | 1575227 | 2021-08-01 | Allegheny | Pennsylvania | 42003 | 103287 | 2028 |
1571979 | 1571979 | 2021-07-31 | Allegheny | Pennsylvania | 42003 | 103058 | 2027 |
1568731 | 1568731 | 2021-07-30 | Allegheny | Pennsylvania | 42003 | 103058 | 2027 |
1565483 | 1565483 | 2021-07-29 | Allegheny | Pennsylvania | 42003 | 102933 | 2027 |
1562235 | 1562235 | 2021-07-28 | Allegheny | Pennsylvania | 42003 | 102811 | 2026 |
1558987 | 1558987 | 2021-07-27 | Allegheny | Pennsylvania | 42003 | 102760 | 2026 |
1555740 | 1555740 | 2021-07-26 | Allegheny | Pennsylvania | 42003 | 102664 | 2025 |
1552493 | 1552493 | 2021-07-25 | Allegheny | Pennsylvania | 42003 | 102576 | 2025 |
1549246 | 1549246 | 2021-07-24 | Allegheny | Pennsylvania | 42003 | 102547 | 2025 |
1545999 | 1545999 | 2021-07-23 | Allegheny | Pennsylvania | 42003 | 102488 | 2025 |
1542752 | 1542752 | 2021-07-22 | Allegheny | Pennsylvania | 42003 | 102449 | 2025 |
1539504 | 1539504 | 2021-07-21 | Allegheny | Pennsylvania | 42003 | 102398 | 2025 |
1536257 | 1536257 | 2021-07-20 | Allegheny | Pennsylvania | 42003 | 102344 | 2025 |
1533009 | 1533009 | 2021-07-19 | Allegheny | Pennsylvania | 42003 | 102273 | 2025 |
1529762 | 1529762 | 2021-07-18 | Allegheny | Pennsylvania | 42003 | 102258 | 2024 |
1526515 | 1526515 | 2021-07-17 | Allegheny | Pennsylvania | 42003 | 102223 | 2024 |
1523268 | 1523268 | 2021-07-16 | Allegheny | Pennsylvania | 42003 | 102192 | 2023 |
1520020 | 1520020 | 2021-07-15 | Allegheny | Pennsylvania | 42003 | 102150 | 2023 |
1516772 | 1516772 | 2021-07-14 | Allegheny | Pennsylvania | 42003 | 102114 | 2021 |
1513525 | 1513525 | 2021-07-13 | Allegheny | Pennsylvania | 42003 | 102089 | 2017 |
1510279 | 1510279 | 2021-07-12 | Allegheny | Pennsylvania | 42003 | 102059 | 2017 |
1507032 | 1507032 | 2021-07-11 | Allegheny | Pennsylvania | 42003 | 102050 | 2017 |
1503786 | 1503786 | 2021-07-10 | Allegheny | Pennsylvania | 42003 | 102036 | 2017 |
1500540 | 1500540 | 2021-07-09 | Allegheny | Pennsylvania | 42003 | 102018 | 2016 |
1497294 | 1497294 | 2021-07-08 | Allegheny | Pennsylvania | 42003 | 101997 | 2016 |
1494047 | 1494047 | 2021-07-07 | Allegheny | Pennsylvania | 42003 | 101980 | 2016 |
1490800 | 1490800 | 2021-07-06 | Allegheny | Pennsylvania | 42003 | 101962 | 2016 |
1487553 | 1487553 | 2021-07-05 | Allegheny | Pennsylvania | 42003 | 101959 | 2016 |
1484306 | 1484306 | 2021-07-04 | Allegheny | Pennsylvania | 42003 | 101942 | 2016 |
1481060 | 1481060 | 2021-07-03 | Allegheny | Pennsylvania | 42003 | 101936 | 2016 |
1477813 | 1477813 | 2021-07-02 | Allegheny | Pennsylvania | 42003 | 101919 | 2016 |
1474567 | 1474567 | 2021-07-01 | Allegheny | Pennsylvania | 42003 | 101909 | 2016 |
1471321 | 1471321 | 2021-06-30 | Allegheny | Pennsylvania | 42003 | 101898 | 2015 |
1468076 | 1468076 | 2021-06-29 | Allegheny | Pennsylvania | 42003 | 101886 | 2014 |
1464831 | 1464831 | 2021-06-28 | Allegheny | Pennsylvania | 42003 | 101871 | 2013 |
1461586 | 1461586 | 2021-06-27 | Allegheny | Pennsylvania | 42003 | 101864 | 2013 |
1458341 | 1458341 | 2021-06-26 | Allegheny | Pennsylvania | 42003 | 101854 | 2011 |
1455096 | 1455096 | 2021-06-25 | Allegheny | Pennsylvania | 42003 | 101837 | 2011 |
1451851 | 1451851 | 2021-06-24 | Allegheny | Pennsylvania | 42003 | 101821 | 2010 |
1448605 | 1448605 | 2021-06-23 | Allegheny | Pennsylvania | 42003 | 101801 | 2009 |
1445360 | 1445360 | 2021-06-22 | Allegheny | Pennsylvania | 42003 | 101795 | 2009 |
1442115 | 1442115 | 2021-06-21 | Allegheny | Pennsylvania | 42003 | 101780 | 2008 |
1438870 | 1438870 | 2021-06-20 | Allegheny | Pennsylvania | 42003 | 101776 | 2008 |
1435623 | 1435623 | 2021-06-19 | Allegheny | Pennsylvania | 42003 | 101764 | 2008 |
1432376 | 1432376 | 2021-06-18 | Allegheny | Pennsylvania | 42003 | 101749 | 2008 |
1429130 | 1429130 | 2021-06-17 | Allegheny | Pennsylvania | 42003 | 101725 | 2006 |
1425885 | 1425885 | 2021-06-16 | Allegheny | Pennsylvania | 42003 | 101715 | 2004 |
1422638 | 1422638 | 2021-06-15 | Allegheny | Pennsylvania | 42003 | 101690 | 2003 |
1419392 | 1419392 | 2021-06-14 | Allegheny | Pennsylvania | 42003 | 101650 | 1999 |
1416147 | 1416147 | 2021-06-13 | Allegheny | Pennsylvania | 42003 | 101646 | 1999 |
1412901 | 1412901 | 2021-06-12 | Allegheny | Pennsylvania | 42003 | 101639 | 1997 |
1409656 | 1409656 | 2021-06-11 | Allegheny | Pennsylvania | 42003 | 101624 | 1996 |
1406411 | 1406411 | 2021-06-10 | Allegheny | Pennsylvania | 42003 | 101605 | 1994 |
1403165 | 1403165 | 2021-06-09 | Allegheny | Pennsylvania | 42003 | 101561 | 1991 |
1399920 | 1399920 | 2021-06-08 | Allegheny | Pennsylvania | 42003 | 101546 | 1990 |
1396675 | 1396675 | 2021-06-07 | Allegheny | Pennsylvania | 42003 | 101522 | 1989 |
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);