ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Union" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1828685 | 1828685 | 2021-10-18 | Union | Pennsylvania | 42119 | 7197 | 97 |
1825436 | 1825436 | 2021-10-17 | Union | Pennsylvania | 42119 | 7184 | 97 |
1822187 | 1822187 | 2021-10-16 | Union | Pennsylvania | 42119 | 7177 | 97 |
1818938 | 1818938 | 2021-10-15 | Union | Pennsylvania | 42119 | 7165 | 97 |
1815689 | 1815689 | 2021-10-14 | Union | Pennsylvania | 42119 | 7140 | 97 |
1812441 | 1812441 | 2021-10-13 | Union | Pennsylvania | 42119 | 7110 | 97 |
1809192 | 1809192 | 2021-10-12 | Union | Pennsylvania | 42119 | 7091 | 97 |
1805942 | 1805942 | 2021-10-11 | Union | Pennsylvania | 42119 | 7071 | 97 |
1802692 | 1802692 | 2021-10-10 | Union | Pennsylvania | 42119 | 7048 | 97 |
1799443 | 1799443 | 2021-10-09 | Union | Pennsylvania | 42119 | 7024 | 97 |
1796194 | 1796194 | 2021-10-08 | Union | Pennsylvania | 42119 | 7002 | 97 |
1792945 | 1792945 | 2021-10-07 | Union | Pennsylvania | 42119 | 6969 | 96 |
1789696 | 1789696 | 2021-10-06 | Union | Pennsylvania | 42119 | 6944 | 95 |
1786448 | 1786448 | 2021-10-05 | Union | Pennsylvania | 42119 | 6926 | 95 |
1783199 | 1783199 | 2021-10-04 | Union | Pennsylvania | 42119 | 6915 | 95 |
1779950 | 1779950 | 2021-10-03 | Union | Pennsylvania | 42119 | 6900 | 95 |
1776700 | 1776700 | 2021-10-02 | Union | Pennsylvania | 42119 | 6869 | 95 |
1773450 | 1773450 | 2021-10-01 | Union | Pennsylvania | 42119 | 6853 | 95 |
1770200 | 1770200 | 2021-09-30 | Union | Pennsylvania | 42119 | 6831 | 95 |
1766951 | 1766951 | 2021-09-29 | Union | Pennsylvania | 42119 | 6814 | 94 |
1763702 | 1763702 | 2021-09-28 | Union | Pennsylvania | 42119 | 6801 | 94 |
1760453 | 1760453 | 2021-09-27 | Union | Pennsylvania | 42119 | 6778 | 94 |
1757205 | 1757205 | 2021-09-26 | Union | Pennsylvania | 42119 | 6760 | 94 |
1753957 | 1753957 | 2021-09-25 | Union | Pennsylvania | 42119 | 6747 | 94 |
1750709 | 1750709 | 2021-09-24 | Union | Pennsylvania | 42119 | 6723 | 93 |
1747460 | 1747460 | 2021-09-23 | Union | Pennsylvania | 42119 | 6708 | 93 |
1744210 | 1744210 | 2021-09-22 | Union | Pennsylvania | 42119 | 6694 | 93 |
1740961 | 1740961 | 2021-09-21 | Union | Pennsylvania | 42119 | 6677 | 93 |
1737712 | 1737712 | 2021-09-20 | Union | Pennsylvania | 42119 | 6663 | 92 |
1734462 | 1734462 | 2021-09-19 | Union | Pennsylvania | 42119 | 6655 | 92 |
1731212 | 1731212 | 2021-09-18 | Union | Pennsylvania | 42119 | 6648 | 92 |
1727962 | 1727962 | 2021-09-17 | Union | Pennsylvania | 42119 | 6628 | 92 |
1724713 | 1724713 | 2021-09-16 | Union | Pennsylvania | 42119 | 6612 | 92 |
1721464 | 1721464 | 2021-09-15 | Union | Pennsylvania | 42119 | 6590 | 91 |
1718216 | 1718216 | 2021-09-14 | Union | Pennsylvania | 42119 | 6568 | 91 |
1714968 | 1714968 | 2021-09-13 | Union | Pennsylvania | 42119 | 6548 | 91 |
1711722 | 1711722 | 2021-09-12 | Union | Pennsylvania | 42119 | 6539 | 91 |
1708475 | 1708475 | 2021-09-11 | Union | Pennsylvania | 42119 | 6525 | 91 |
1705228 | 1705228 | 2021-09-10 | Union | Pennsylvania | 42119 | 6510 | 91 |
1701978 | 1701978 | 2021-09-09 | Union | Pennsylvania | 42119 | 6480 | 91 |
1698729 | 1698729 | 2021-09-08 | Union | Pennsylvania | 42119 | 6452 | 91 |
1695481 | 1695481 | 2021-09-07 | Union | Pennsylvania | 42119 | 6417 | 91 |
1692233 | 1692233 | 2021-09-06 | Union | Pennsylvania | 42119 | 6414 | 91 |
1688984 | 1688984 | 2021-09-05 | Union | Pennsylvania | 42119 | 6410 | 91 |
1685734 | 1685734 | 2021-09-04 | Union | Pennsylvania | 42119 | 6398 | 91 |
1682483 | 1682483 | 2021-09-03 | Union | Pennsylvania | 42119 | 6377 | 90 |
1679233 | 1679233 | 2021-09-02 | Union | Pennsylvania | 42119 | 6367 | 90 |
1675985 | 1675985 | 2021-09-01 | Union | Pennsylvania | 42119 | 6357 | 90 |
1672738 | 1672738 | 2021-08-31 | Union | Pennsylvania | 42119 | 6341 | 90 |
1669490 | 1669490 | 2021-08-30 | Union | Pennsylvania | 42119 | 6328 | 90 |
1666243 | 1666243 | 2021-08-29 | Union | Pennsylvania | 42119 | 6323 | 90 |
1662995 | 1662995 | 2021-08-28 | Union | Pennsylvania | 42119 | 6318 | 90 |
1659747 | 1659747 | 2021-08-27 | Union | Pennsylvania | 42119 | 6312 | 90 |
1656498 | 1656498 | 2021-08-26 | Union | Pennsylvania | 42119 | 6307 | 90 |
1653251 | 1653251 | 2021-08-25 | Union | Pennsylvania | 42119 | 6300 | 90 |
1650004 | 1650004 | 2021-08-24 | Union | Pennsylvania | 42119 | 6286 | 90 |
1646755 | 1646755 | 2021-08-23 | Union | Pennsylvania | 42119 | 6277 | 90 |
1643506 | 1643506 | 2021-08-22 | Union | Pennsylvania | 42119 | 6273 | 90 |
1640256 | 1640256 | 2021-08-21 | Union | Pennsylvania | 42119 | 6271 | 90 |
1637006 | 1637006 | 2021-08-20 | Union | Pennsylvania | 42119 | 6267 | 90 |
1633756 | 1633756 | 2021-08-19 | Union | Pennsylvania | 42119 | 6262 | 90 |
1630509 | 1630509 | 2021-08-18 | Union | Pennsylvania | 42119 | 6250 | 90 |
1627262 | 1627262 | 2021-08-17 | Union | Pennsylvania | 42119 | 6246 | 90 |
1624015 | 1624015 | 2021-08-16 | Union | Pennsylvania | 42119 | 6237 | 90 |
1620768 | 1620768 | 2021-08-15 | Union | Pennsylvania | 42119 | 6232 | 90 |
1617520 | 1617520 | 2021-08-14 | Union | Pennsylvania | 42119 | 6229 | 90 |
1614272 | 1614272 | 2021-08-13 | Union | Pennsylvania | 42119 | 6225 | 90 |
1611023 | 1611023 | 2021-08-12 | Union | Pennsylvania | 42119 | 6223 | 90 |
1607775 | 1607775 | 2021-08-11 | Union | Pennsylvania | 42119 | 6222 | 90 |
1604526 | 1604526 | 2021-08-10 | Union | Pennsylvania | 42119 | 6216 | 90 |
1601277 | 1601277 | 2021-08-09 | Union | Pennsylvania | 42119 | 6211 | 90 |
1598029 | 1598029 | 2021-08-08 | Union | Pennsylvania | 42119 | 6207 | 90 |
1594780 | 1594780 | 2021-08-07 | Union | Pennsylvania | 42119 | 6207 | 90 |
1591531 | 1591531 | 2021-08-06 | Union | Pennsylvania | 42119 | 6204 | 90 |
1588282 | 1588282 | 2021-08-05 | Union | Pennsylvania | 42119 | 6202 | 90 |
1585032 | 1585032 | 2021-08-04 | Union | Pennsylvania | 42119 | 6201 | 90 |
1581782 | 1581782 | 2021-08-03 | Union | Pennsylvania | 42119 | 6199 | 90 |
1578533 | 1578533 | 2021-08-02 | Union | Pennsylvania | 42119 | 6199 | 90 |
1575285 | 1575285 | 2021-08-01 | Union | Pennsylvania | 42119 | 6195 | 90 |
1572037 | 1572037 | 2021-07-31 | Union | Pennsylvania | 42119 | 6190 | 89 |
1568789 | 1568789 | 2021-07-30 | Union | Pennsylvania | 42119 | 6190 | 89 |
1565541 | 1565541 | 2021-07-29 | Union | Pennsylvania | 42119 | 6185 | 89 |
1562293 | 1562293 | 2021-07-28 | Union | Pennsylvania | 42119 | 6179 | 89 |
1559045 | 1559045 | 2021-07-27 | Union | Pennsylvania | 42119 | 6179 | 89 |
1555798 | 1555798 | 2021-07-26 | Union | Pennsylvania | 42119 | 6178 | 89 |
1552551 | 1552551 | 2021-07-25 | Union | Pennsylvania | 42119 | 6177 | 89 |
1549304 | 1549304 | 2021-07-24 | Union | Pennsylvania | 42119 | 6177 | 89 |
1546057 | 1546057 | 2021-07-23 | Union | Pennsylvania | 42119 | 6174 | 89 |
1542810 | 1542810 | 2021-07-22 | Union | Pennsylvania | 42119 | 6172 | 89 |
1539562 | 1539562 | 2021-07-21 | Union | Pennsylvania | 42119 | 6170 | 89 |
1536315 | 1536315 | 2021-07-20 | Union | Pennsylvania | 42119 | 6170 | 89 |
1533067 | 1533067 | 2021-07-19 | Union | Pennsylvania | 42119 | 6170 | 89 |
1529820 | 1529820 | 2021-07-18 | Union | Pennsylvania | 42119 | 6170 | 89 |
1526573 | 1526573 | 2021-07-17 | Union | Pennsylvania | 42119 | 6170 | 89 |
1523326 | 1523326 | 2021-07-16 | Union | Pennsylvania | 42119 | 6169 | 89 |
1520078 | 1520078 | 2021-07-15 | Union | Pennsylvania | 42119 | 6168 | 89 |
1516830 | 1516830 | 2021-07-14 | Union | Pennsylvania | 42119 | 6168 | 89 |
1513583 | 1513583 | 2021-07-13 | Union | Pennsylvania | 42119 | 6168 | 89 |
1510337 | 1510337 | 2021-07-12 | Union | Pennsylvania | 42119 | 6168 | 89 |
1507090 | 1507090 | 2021-07-11 | Union | Pennsylvania | 42119 | 6167 | 89 |
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);