ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 42127 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1841685 | 1841685 | 2021-10-22 | Wayne | Pennsylvania | 42127 | 5583 | 105 |
1838436 | 1838436 | 2021-10-21 | Wayne | Pennsylvania | 42127 | 5571 | 105 |
1835187 | 1835187 | 2021-10-20 | Wayne | Pennsylvania | 42127 | 5552 | 104 |
1831938 | 1831938 | 2021-10-19 | Wayne | Pennsylvania | 42127 | 5530 | 104 |
1828689 | 1828689 | 2021-10-18 | Wayne | Pennsylvania | 42127 | 5511 | 104 |
1825440 | 1825440 | 2021-10-17 | Wayne | Pennsylvania | 42127 | 5504 | 103 |
1822191 | 1822191 | 2021-10-16 | Wayne | Pennsylvania | 42127 | 5493 | 103 |
1818942 | 1818942 | 2021-10-15 | Wayne | Pennsylvania | 42127 | 5459 | 103 |
1815693 | 1815693 | 2021-10-14 | Wayne | Pennsylvania | 42127 | 5438 | 103 |
1812445 | 1812445 | 2021-10-13 | Wayne | Pennsylvania | 42127 | 5413 | 103 |
1809196 | 1809196 | 2021-10-12 | Wayne | Pennsylvania | 42127 | 5402 | 102 |
1805946 | 1805946 | 2021-10-11 | Wayne | Pennsylvania | 42127 | 5371 | 101 |
1802696 | 1802696 | 2021-10-10 | Wayne | Pennsylvania | 42127 | 5361 | 101 |
1799447 | 1799447 | 2021-10-09 | Wayne | Pennsylvania | 42127 | 5342 | 101 |
1796198 | 1796198 | 2021-10-08 | Wayne | Pennsylvania | 42127 | 5305 | 101 |
1792949 | 1792949 | 2021-10-07 | Wayne | Pennsylvania | 42127 | 5278 | 100 |
1789700 | 1789700 | 2021-10-06 | Wayne | Pennsylvania | 42127 | 5241 | 100 |
1786452 | 1786452 | 2021-10-05 | Wayne | Pennsylvania | 42127 | 5205 | 100 |
1783203 | 1783203 | 2021-10-04 | Wayne | Pennsylvania | 42127 | 5180 | 100 |
1779954 | 1779954 | 2021-10-03 | Wayne | Pennsylvania | 42127 | 5164 | 100 |
1776704 | 1776704 | 2021-10-02 | Wayne | Pennsylvania | 42127 | 5137 | 100 |
1773454 | 1773454 | 2021-10-01 | Wayne | Pennsylvania | 42127 | 5118 | 99 |
1770204 | 1770204 | 2021-09-30 | Wayne | Pennsylvania | 42127 | 5101 | 99 |
1766955 | 1766955 | 2021-09-29 | Wayne | Pennsylvania | 42127 | 5074 | 96 |
1763706 | 1763706 | 2021-09-28 | Wayne | Pennsylvania | 42127 | 5049 | 94 |
1760457 | 1760457 | 2021-09-27 | Wayne | Pennsylvania | 42127 | 5028 | 94 |
1757209 | 1757209 | 2021-09-26 | Wayne | Pennsylvania | 42127 | 5023 | 94 |
1753961 | 1753961 | 2021-09-25 | Wayne | Pennsylvania | 42127 | 5019 | 94 |
1750713 | 1750713 | 2021-09-24 | Wayne | Pennsylvania | 42127 | 5000 | 93 |
1747464 | 1747464 | 2021-09-23 | Wayne | Pennsylvania | 42127 | 4979 | 94 |
1744214 | 1744214 | 2021-09-22 | Wayne | Pennsylvania | 42127 | 4953 | 94 |
1740965 | 1740965 | 2021-09-21 | Wayne | Pennsylvania | 42127 | 4925 | 93 |
1737716 | 1737716 | 2021-09-20 | Wayne | Pennsylvania | 42127 | 4909 | 89 |
1734466 | 1734466 | 2021-09-19 | Wayne | Pennsylvania | 42127 | 4903 | 89 |
1731216 | 1731216 | 2021-09-18 | Wayne | Pennsylvania | 42127 | 4887 | 89 |
1727966 | 1727966 | 2021-09-17 | Wayne | Pennsylvania | 42127 | 4862 | 89 |
1724717 | 1724717 | 2021-09-16 | Wayne | Pennsylvania | 42127 | 4817 | 86 |
1721468 | 1721468 | 2021-09-15 | Wayne | Pennsylvania | 42127 | 4809 | 85 |
1718220 | 1718220 | 2021-09-14 | Wayne | Pennsylvania | 42127 | 4787 | 85 |
1714972 | 1714972 | 2021-09-13 | Wayne | Pennsylvania | 42127 | 4750 | 85 |
1711726 | 1711726 | 2021-09-12 | Wayne | Pennsylvania | 42127 | 4744 | 85 |
1708479 | 1708479 | 2021-09-11 | Wayne | Pennsylvania | 42127 | 4730 | 85 |
1705232 | 1705232 | 2021-09-10 | Wayne | Pennsylvania | 42127 | 4698 | 85 |
1701982 | 1701982 | 2021-09-09 | Wayne | Pennsylvania | 42127 | 4669 | 85 |
1698733 | 1698733 | 2021-09-08 | Wayne | Pennsylvania | 42127 | 4653 | 85 |
1695485 | 1695485 | 2021-09-07 | Wayne | Pennsylvania | 42127 | 4612 | 84 |
1692237 | 1692237 | 2021-09-06 | Wayne | Pennsylvania | 42127 | 4605 | 84 |
1688988 | 1688988 | 2021-09-05 | Wayne | Pennsylvania | 42127 | 4603 | 84 |
1685738 | 1685738 | 2021-09-04 | Wayne | Pennsylvania | 42127 | 4594 | 84 |
1682487 | 1682487 | 2021-09-03 | Wayne | Pennsylvania | 42127 | 4580 | 84 |
1679237 | 1679237 | 2021-09-02 | Wayne | Pennsylvania | 42127 | 4549 | 84 |
1675989 | 1675989 | 2021-09-01 | Wayne | Pennsylvania | 42127 | 4537 | 84 |
1672742 | 1672742 | 2021-08-31 | Wayne | Pennsylvania | 42127 | 4513 | 84 |
1669494 | 1669494 | 2021-08-30 | Wayne | Pennsylvania | 42127 | 4481 | 84 |
1666247 | 1666247 | 2021-08-29 | Wayne | Pennsylvania | 42127 | 4478 | 84 |
1662999 | 1662999 | 2021-08-28 | Wayne | Pennsylvania | 42127 | 4468 | 84 |
1659751 | 1659751 | 2021-08-27 | Wayne | Pennsylvania | 42127 | 4456 | 84 |
1656502 | 1656502 | 2021-08-26 | Wayne | Pennsylvania | 42127 | 4438 | 84 |
1653255 | 1653255 | 2021-08-25 | Wayne | Pennsylvania | 42127 | 4420 | 84 |
1650008 | 1650008 | 2021-08-24 | Wayne | Pennsylvania | 42127 | 4400 | 84 |
1646759 | 1646759 | 2021-08-23 | Wayne | Pennsylvania | 42127 | 4387 | 84 |
1643510 | 1643510 | 2021-08-22 | Wayne | Pennsylvania | 42127 | 4385 | 84 |
1640260 | 1640260 | 2021-08-21 | Wayne | Pennsylvania | 42127 | 4382 | 84 |
1637010 | 1637010 | 2021-08-20 | Wayne | Pennsylvania | 42127 | 4362 | 84 |
1633760 | 1633760 | 2021-08-19 | Wayne | Pennsylvania | 42127 | 4360 | 84 |
1630513 | 1630513 | 2021-08-18 | Wayne | Pennsylvania | 42127 | 4351 | 84 |
1627266 | 1627266 | 2021-08-17 | Wayne | Pennsylvania | 42127 | 4334 | 84 |
1624019 | 1624019 | 2021-08-16 | Wayne | Pennsylvania | 42127 | 4317 | 84 |
1620772 | 1620772 | 2021-08-15 | Wayne | Pennsylvania | 42127 | 4314 | 84 |
1617524 | 1617524 | 2021-08-14 | Wayne | Pennsylvania | 42127 | 4307 | 84 |
1614276 | 1614276 | 2021-08-13 | Wayne | Pennsylvania | 42127 | 4298 | 84 |
1611027 | 1611027 | 2021-08-12 | Wayne | Pennsylvania | 42127 | 4288 | 84 |
1607779 | 1607779 | 2021-08-11 | Wayne | Pennsylvania | 42127 | 4280 | 84 |
1604530 | 1604530 | 2021-08-10 | Wayne | Pennsylvania | 42127 | 4264 | 84 |
1601281 | 1601281 | 2021-08-09 | Wayne | Pennsylvania | 42127 | 4258 | 84 |
1598033 | 1598033 | 2021-08-08 | Wayne | Pennsylvania | 42127 | 4249 | 84 |
1594784 | 1594784 | 2021-08-07 | Wayne | Pennsylvania | 42127 | 4249 | 84 |
1591535 | 1591535 | 2021-08-06 | Wayne | Pennsylvania | 42127 | 4242 | 84 |
1588286 | 1588286 | 2021-08-05 | Wayne | Pennsylvania | 42127 | 4231 | 84 |
1585036 | 1585036 | 2021-08-04 | Wayne | Pennsylvania | 42127 | 4223 | 84 |
1581786 | 1581786 | 2021-08-03 | Wayne | Pennsylvania | 42127 | 4218 | 84 |
1578537 | 1578537 | 2021-08-02 | Wayne | Pennsylvania | 42127 | 4207 | 84 |
1575289 | 1575289 | 2021-08-01 | Wayne | Pennsylvania | 42127 | 4206 | 84 |
1572041 | 1572041 | 2021-07-31 | Wayne | Pennsylvania | 42127 | 4198 | 84 |
1568793 | 1568793 | 2021-07-30 | Wayne | Pennsylvania | 42127 | 4198 | 84 |
1565545 | 1565545 | 2021-07-29 | Wayne | Pennsylvania | 42127 | 4194 | 84 |
1562297 | 1562297 | 2021-07-28 | Wayne | Pennsylvania | 42127 | 4193 | 84 |
1559049 | 1559049 | 2021-07-27 | Wayne | Pennsylvania | 42127 | 4191 | 84 |
1555802 | 1555802 | 2021-07-26 | Wayne | Pennsylvania | 42127 | 4184 | 84 |
1552555 | 1552555 | 2021-07-25 | Wayne | Pennsylvania | 42127 | 4183 | 84 |
1549308 | 1549308 | 2021-07-24 | Wayne | Pennsylvania | 42127 | 4182 | 84 |
1546061 | 1546061 | 2021-07-23 | Wayne | Pennsylvania | 42127 | 4181 | 84 |
1542814 | 1542814 | 2021-07-22 | Wayne | Pennsylvania | 42127 | 4180 | 84 |
1539566 | 1539566 | 2021-07-21 | Wayne | Pennsylvania | 42127 | 4178 | 84 |
1536319 | 1536319 | 2021-07-20 | Wayne | Pennsylvania | 42127 | 4178 | 84 |
1533071 | 1533071 | 2021-07-19 | Wayne | Pennsylvania | 42127 | 4177 | 84 |
1529824 | 1529824 | 2021-07-18 | Wayne | Pennsylvania | 42127 | 4177 | 84 |
1526577 | 1526577 | 2021-07-17 | Wayne | Pennsylvania | 42127 | 4176 | 84 |
1523330 | 1523330 | 2021-07-16 | Wayne | Pennsylvania | 42127 | 4173 | 84 |
1520082 | 1520082 | 2021-07-15 | Wayne | Pennsylvania | 42127 | 4171 | 84 |
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);