ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Armstrong" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718159 | 1718159 | 2021-09-14 | Armstrong | Pennsylvania | 42005 | 6903 | 155 |
1714911 | 1714911 | 2021-09-13 | Armstrong | Pennsylvania | 42005 | 6840 | 153 |
1711665 | 1711665 | 2021-09-12 | Armstrong | Pennsylvania | 42005 | 6818 | 153 |
1708418 | 1708418 | 2021-09-11 | Armstrong | Pennsylvania | 42005 | 6781 | 153 |
1705171 | 1705171 | 2021-09-10 | Armstrong | Pennsylvania | 42005 | 6720 | 153 |
1701921 | 1701921 | 2021-09-09 | Armstrong | Pennsylvania | 42005 | 6667 | 153 |
1698672 | 1698672 | 2021-09-08 | Armstrong | Pennsylvania | 42005 | 6614 | 152 |
1695424 | 1695424 | 2021-09-07 | Armstrong | Pennsylvania | 42005 | 6566 | 151 |
1692176 | 1692176 | 2021-09-06 | Armstrong | Pennsylvania | 42005 | 6550 | 151 |
1688927 | 1688927 | 2021-09-05 | Armstrong | Pennsylvania | 42005 | 6534 | 151 |
1685677 | 1685677 | 2021-09-04 | Armstrong | Pennsylvania | 42005 | 6509 | 151 |
1682426 | 1682426 | 2021-09-03 | Armstrong | Pennsylvania | 42005 | 6456 | 151 |
1679176 | 1679176 | 2021-09-02 | Armstrong | Pennsylvania | 42005 | 6434 | 151 |
1675928 | 1675928 | 2021-09-01 | Armstrong | Pennsylvania | 42005 | 6408 | 151 |
1672681 | 1672681 | 2021-08-31 | Armstrong | Pennsylvania | 42005 | 6389 | 151 |
1669433 | 1669433 | 2021-08-30 | Armstrong | Pennsylvania | 42005 | 6361 | 151 |
1666186 | 1666186 | 2021-08-29 | Armstrong | Pennsylvania | 42005 | 6351 | 151 |
1662938 | 1662938 | 2021-08-28 | Armstrong | Pennsylvania | 42005 | 6337 | 151 |
1659690 | 1659690 | 2021-08-27 | Armstrong | Pennsylvania | 42005 | 6321 | 150 |
1656441 | 1656441 | 2021-08-26 | Armstrong | Pennsylvania | 42005 | 6293 | 150 |
1653194 | 1653194 | 2021-08-25 | Armstrong | Pennsylvania | 42005 | 6278 | 149 |
1649947 | 1649947 | 2021-08-24 | Armstrong | Pennsylvania | 42005 | 6256 | 148 |
1646698 | 1646698 | 2021-08-23 | Armstrong | Pennsylvania | 42005 | 6242 | 148 |
1643449 | 1643449 | 2021-08-22 | Armstrong | Pennsylvania | 42005 | 6227 | 148 |
1640199 | 1640199 | 2021-08-21 | Armstrong | Pennsylvania | 42005 | 6213 | 148 |
1636949 | 1636949 | 2021-08-20 | Armstrong | Pennsylvania | 42005 | 6199 | 148 |
1633699 | 1633699 | 2021-08-19 | Armstrong | Pennsylvania | 42005 | 6187 | 148 |
1630452 | 1630452 | 2021-08-18 | Armstrong | Pennsylvania | 42005 | 6166 | 148 |
1627205 | 1627205 | 2021-08-17 | Armstrong | Pennsylvania | 42005 | 6148 | 148 |
1623958 | 1623958 | 2021-08-16 | Armstrong | Pennsylvania | 42005 | 6143 | 148 |
1620711 | 1620711 | 2021-08-15 | Armstrong | Pennsylvania | 42005 | 6136 | 148 |
1617463 | 1617463 | 2021-08-14 | Armstrong | Pennsylvania | 42005 | 6127 | 148 |
1614215 | 1614215 | 2021-08-13 | Armstrong | Pennsylvania | 42005 | 6114 | 148 |
1610966 | 1610966 | 2021-08-12 | Armstrong | Pennsylvania | 42005 | 6099 | 148 |
1607718 | 1607718 | 2021-08-11 | Armstrong | Pennsylvania | 42005 | 6090 | 148 |
1604469 | 1604469 | 2021-08-10 | Armstrong | Pennsylvania | 42005 | 6085 | 148 |
1601220 | 1601220 | 2021-08-09 | Armstrong | Pennsylvania | 42005 | 6075 | 148 |
1597972 | 1597972 | 2021-08-08 | Armstrong | Pennsylvania | 42005 | 6069 | 148 |
1594723 | 1594723 | 2021-08-07 | Armstrong | Pennsylvania | 42005 | 6069 | 148 |
1591474 | 1591474 | 2021-08-06 | Armstrong | Pennsylvania | 42005 | 6067 | 148 |
1588225 | 1588225 | 2021-08-05 | Armstrong | Pennsylvania | 42005 | 6063 | 148 |
1584975 | 1584975 | 2021-08-04 | Armstrong | Pennsylvania | 42005 | 6061 | 148 |
1581725 | 1581725 | 2021-08-03 | Armstrong | Pennsylvania | 42005 | 6056 | 148 |
1578476 | 1578476 | 2021-08-02 | Armstrong | Pennsylvania | 42005 | 6055 | 148 |
1575228 | 1575228 | 2021-08-01 | Armstrong | Pennsylvania | 42005 | 6053 | 148 |
1571980 | 1571980 | 2021-07-31 | Armstrong | Pennsylvania | 42005 | 6050 | 148 |
1568732 | 1568732 | 2021-07-30 | Armstrong | Pennsylvania | 42005 | 6050 | 148 |
1565484 | 1565484 | 2021-07-29 | Armstrong | Pennsylvania | 42005 | 6047 | 148 |
1562236 | 1562236 | 2021-07-28 | Armstrong | Pennsylvania | 42005 | 6040 | 148 |
1558988 | 1558988 | 2021-07-27 | Armstrong | Pennsylvania | 42005 | 6039 | 148 |
1555741 | 1555741 | 2021-07-26 | Armstrong | Pennsylvania | 42005 | 6035 | 148 |
1552494 | 1552494 | 2021-07-25 | Armstrong | Pennsylvania | 42005 | 6033 | 148 |
1549247 | 1549247 | 2021-07-24 | Armstrong | Pennsylvania | 42005 | 6028 | 148 |
1546000 | 1546000 | 2021-07-23 | Armstrong | Pennsylvania | 42005 | 6025 | 148 |
1542753 | 1542753 | 2021-07-22 | Armstrong | Pennsylvania | 42005 | 6020 | 148 |
1539505 | 1539505 | 2021-07-21 | Armstrong | Pennsylvania | 42005 | 6019 | 148 |
1536258 | 1536258 | 2021-07-20 | Armstrong | Pennsylvania | 42005 | 6016 | 148 |
1533010 | 1533010 | 2021-07-19 | Armstrong | Pennsylvania | 42005 | 6016 | 148 |
1529763 | 1529763 | 2021-07-18 | Armstrong | Pennsylvania | 42005 | 6016 | 148 |
1526516 | 1526516 | 2021-07-17 | Armstrong | Pennsylvania | 42005 | 6016 | 148 |
1523269 | 1523269 | 2021-07-16 | Armstrong | Pennsylvania | 42005 | 6016 | 148 |
1520021 | 1520021 | 2021-07-15 | Armstrong | Pennsylvania | 42005 | 6016 | 148 |
1516773 | 1516773 | 2021-07-14 | Armstrong | Pennsylvania | 42005 | 6015 | 148 |
1513526 | 1513526 | 2021-07-13 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1510280 | 1510280 | 2021-07-12 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1507033 | 1507033 | 2021-07-11 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1503787 | 1503787 | 2021-07-10 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1500541 | 1500541 | 2021-07-09 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1497295 | 1497295 | 2021-07-08 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1494048 | 1494048 | 2021-07-07 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1490801 | 1490801 | 2021-07-06 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1487554 | 1487554 | 2021-07-05 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1484307 | 1484307 | 2021-07-04 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1481061 | 1481061 | 2021-07-03 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1477814 | 1477814 | 2021-07-02 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1474568 | 1474568 | 2021-07-01 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1471322 | 1471322 | 2021-06-30 | Armstrong | Pennsylvania | 42005 | 6014 | 148 |
1468077 | 1468077 | 2021-06-29 | Armstrong | Pennsylvania | 42005 | 6013 | 148 |
1464832 | 1464832 | 2021-06-28 | Armstrong | Pennsylvania | 42005 | 6013 | 148 |
1461587 | 1461587 | 2021-06-27 | Armstrong | Pennsylvania | 42005 | 6013 | 148 |
1458342 | 1458342 | 2021-06-26 | Armstrong | Pennsylvania | 42005 | 6013 | 148 |
1455097 | 1455097 | 2021-06-25 | Armstrong | Pennsylvania | 42005 | 6013 | 148 |
1451852 | 1451852 | 2021-06-24 | Armstrong | Pennsylvania | 42005 | 6013 | 148 |
1448606 | 1448606 | 2021-06-23 | Armstrong | Pennsylvania | 42005 | 6013 | 148 |
1445361 | 1445361 | 2021-06-22 | Armstrong | Pennsylvania | 42005 | 6013 | 148 |
1442116 | 1442116 | 2021-06-21 | Armstrong | Pennsylvania | 42005 | 6013 | 148 |
1438871 | 1438871 | 2021-06-20 | Armstrong | Pennsylvania | 42005 | 6012 | 148 |
1435624 | 1435624 | 2021-06-19 | Armstrong | Pennsylvania | 42005 | 6012 | 148 |
1432377 | 1432377 | 2021-06-18 | Armstrong | Pennsylvania | 42005 | 6012 | 148 |
1429131 | 1429131 | 2021-06-17 | Armstrong | Pennsylvania | 42005 | 6010 | 148 |
1425886 | 1425886 | 2021-06-16 | Armstrong | Pennsylvania | 42005 | 6010 | 148 |
1422639 | 1422639 | 2021-06-15 | Armstrong | Pennsylvania | 42005 | 6008 | 148 |
1419393 | 1419393 | 2021-06-14 | Armstrong | Pennsylvania | 42005 | 6005 | 148 |
1416148 | 1416148 | 2021-06-13 | Armstrong | Pennsylvania | 42005 | 6005 | 148 |
1412902 | 1412902 | 2021-06-12 | Armstrong | Pennsylvania | 42005 | 6005 | 148 |
1409657 | 1409657 | 2021-06-11 | Armstrong | Pennsylvania | 42005 | 6004 | 148 |
1406412 | 1406412 | 2021-06-10 | Armstrong | Pennsylvania | 42005 | 5996 | 148 |
1403166 | 1403166 | 2021-06-09 | Armstrong | Pennsylvania | 42005 | 5993 | 148 |
1399921 | 1399921 | 2021-06-08 | Armstrong | Pennsylvania | 42005 | 5989 | 147 |
1396676 | 1396676 | 2021-06-07 | Armstrong | Pennsylvania | 42005 | 5988 | 146 |
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);