ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 42071 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176498 | 2176498 | 2022-02-02 | Lancaster | Pennsylvania | 42071 | 117032 | 1746 |
2173244 | 2173244 | 2022-02-01 | Lancaster | Pennsylvania | 42071 | 116699 | 1728 |
2169992 | 2169992 | 2022-01-31 | Lancaster | Pennsylvania | 42071 | 116426 | 1725 |
2166738 | 2166738 | 2022-01-30 | Lancaster | Pennsylvania | 42071 | 116228 | 1722 |
2163483 | 2163483 | 2022-01-29 | Lancaster | Pennsylvania | 42071 | 115969 | 1720 |
2160228 | 2160228 | 2022-01-28 | Lancaster | Pennsylvania | 42071 | 115670 | 1715 |
2156972 | 2156972 | 2022-01-27 | Lancaster | Pennsylvania | 42071 | 114997 | 1705 |
2153719 | 2153719 | 2022-01-26 | Lancaster | Pennsylvania | 42071 | 114383 | 1694 |
2150467 | 2150467 | 2022-01-25 | Lancaster | Pennsylvania | 42071 | 114058 | 1687 |
2147215 | 2147215 | 2022-01-24 | Lancaster | Pennsylvania | 42071 | 113629 | 1679 |
2143961 | 2143961 | 2022-01-23 | Lancaster | Pennsylvania | 42071 | 113233 | 1677 |
2140706 | 2140706 | 2022-01-22 | Lancaster | Pennsylvania | 42071 | 112792 | 1672 |
2137450 | 2137450 | 2022-01-21 | Lancaster | Pennsylvania | 42071 | 112108 | 1666 |
2134196 | 2134196 | 2022-01-20 | Lancaster | Pennsylvania | 42071 | 111284 | 1654 |
2130944 | 2130944 | 2022-01-19 | Lancaster | Pennsylvania | 42071 | 110532 | 1645 |
2127690 | 2127690 | 2022-01-18 | Lancaster | Pennsylvania | 42071 | 109890 | 1643 |
2124438 | 2124438 | 2022-01-17 | Lancaster | Pennsylvania | 42071 | 109284 | 1640 |
2121186 | 2121186 | 2022-01-16 | Lancaster | Pennsylvania | 42071 | 108759 | 1640 |
2117934 | 2117934 | 2022-01-15 | Lancaster | Pennsylvania | 42071 | 107154 | 1639 |
2114683 | 2114683 | 2022-01-14 | Lancaster | Pennsylvania | 42071 | 106386 | 1627 |
2111431 | 2111431 | 2022-01-13 | Lancaster | Pennsylvania | 42071 | 105474 | 1618 |
2108179 | 2108179 | 2022-01-12 | Lancaster | Pennsylvania | 42071 | 104297 | 1612 |
2104928 | 2104928 | 2022-01-11 | Lancaster | Pennsylvania | 42071 | 103273 | 1605 |
2101677 | 2101677 | 2022-01-10 | Lancaster | Pennsylvania | 42071 | 102154 | 1596 |
2098426 | 2098426 | 2022-01-09 | Lancaster | Pennsylvania | 42071 | 100833 | 1596 |
2095174 | 2095174 | 2022-01-08 | Lancaster | Pennsylvania | 42071 | 99490 | 1592 |
2091922 | 2091922 | 2022-01-07 | Lancaster | Pennsylvania | 42071 | 98090 | 1587 |
2088670 | 2088670 | 2022-01-06 | Lancaster | Pennsylvania | 42071 | 97017 | 1579 |
2085419 | 2085419 | 2022-01-05 | Lancaster | Pennsylvania | 42071 | 96121 | 1567 |
2082167 | 2082167 | 2022-01-04 | Lancaster | Pennsylvania | 42071 | 95034 | 1564 |
2078915 | 2078915 | 2022-01-03 | Lancaster | Pennsylvania | 42071 | 94029 | 1561 |
2075664 | 2075664 | 2022-01-02 | Lancaster | Pennsylvania | 42071 | 93158 | 1555 |
2072413 | 2072413 | 2022-01-01 | Lancaster | Pennsylvania | 42071 | 92356 | 1555 |
2069162 | 2069162 | 2021-12-31 | Lancaster | Pennsylvania | 42071 | 91511 | 1554 |
2065911 | 2065911 | 2021-12-30 | Lancaster | Pennsylvania | 42071 | 90442 | 1552 |
2062661 | 2062661 | 2021-12-29 | Lancaster | Pennsylvania | 42071 | 89423 | 1545 |
2059411 | 2059411 | 2021-12-28 | Lancaster | Pennsylvania | 42071 | 88840 | 1531 |
2056162 | 2056162 | 2021-12-27 | Lancaster | Pennsylvania | 42071 | 88314 | 1521 |
2052913 | 2052913 | 2021-12-26 | Lancaster | Pennsylvania | 42071 | 87975 | 1521 |
2049663 | 2049663 | 2021-12-25 | Lancaster | Pennsylvania | 42071 | 87649 | 1521 |
2046413 | 2046413 | 2021-12-24 | Lancaster | Pennsylvania | 42071 | 87198 | 1521 |
2043163 | 2043163 | 2021-12-23 | Lancaster | Pennsylvania | 42071 | 86711 | 1518 |
2039914 | 2039914 | 2021-12-22 | Lancaster | Pennsylvania | 42071 | 86200 | 1513 |
2036664 | 2036664 | 2021-12-21 | Lancaster | Pennsylvania | 42071 | 85753 | 1506 |
2033414 | 2033414 | 2021-12-20 | Lancaster | Pennsylvania | 42071 | 85385 | 1498 |
2030164 | 2030164 | 2021-12-19 | Lancaster | Pennsylvania | 42071 | 85229 | 1496 |
2026913 | 2026913 | 2021-12-18 | Lancaster | Pennsylvania | 42071 | 84775 | 1494 |
2023662 | 2023662 | 2021-12-17 | Lancaster | Pennsylvania | 42071 | 84477 | 1486 |
2020411 | 2020411 | 2021-12-16 | Lancaster | Pennsylvania | 42071 | 84155 | 1482 |
2017160 | 2017160 | 2021-12-15 | Lancaster | Pennsylvania | 42071 | 83789 | 1478 |
2013910 | 2013910 | 2021-12-14 | Lancaster | Pennsylvania | 42071 | 83431 | 1471 |
2010659 | 2010659 | 2021-12-13 | Lancaster | Pennsylvania | 42071 | 83158 | 1461 |
2007408 | 2007408 | 2021-12-12 | Lancaster | Pennsylvania | 42071 | 82858 | 1461 |
2004157 | 2004157 | 2021-12-11 | Lancaster | Pennsylvania | 42071 | 82430 | 1456 |
2000906 | 2000906 | 2021-12-10 | Lancaster | Pennsylvania | 42071 | 81990 | 1449 |
1997656 | 1997656 | 2021-12-09 | Lancaster | Pennsylvania | 42071 | 81606 | 1443 |
1994405 | 1994405 | 2021-12-08 | Lancaster | Pennsylvania | 42071 | 81245 | 1440 |
1991154 | 1991154 | 2021-12-07 | Lancaster | Pennsylvania | 42071 | 80932 | 1435 |
1987903 | 1987903 | 2021-12-06 | Lancaster | Pennsylvania | 42071 | 80638 | 1428 |
1984653 | 1984653 | 2021-12-05 | Lancaster | Pennsylvania | 42071 | 80410 | 1424 |
1981403 | 1981403 | 2021-12-04 | Lancaster | Pennsylvania | 42071 | 80052 | 1422 |
1978153 | 1978153 | 2021-12-03 | Lancaster | Pennsylvania | 42071 | 79542 | 1417 |
1974903 | 1974903 | 2021-12-02 | Lancaster | Pennsylvania | 42071 | 79198 | 1416 |
1971654 | 1971654 | 2021-12-01 | Lancaster | Pennsylvania | 42071 | 78794 | 1407 |
1968404 | 1968404 | 2021-11-30 | Lancaster | Pennsylvania | 42071 | 78458 | 1404 |
1965153 | 1965153 | 2021-11-29 | Lancaster | Pennsylvania | 42071 | 78228 | 1402 |
1961901 | 1961901 | 2021-11-28 | Lancaster | Pennsylvania | 42071 | 78035 | 1401 |
1958650 | 1958650 | 2021-11-27 | Lancaster | Pennsylvania | 42071 | 77845 | 1400 |
1955399 | 1955399 | 2021-11-26 | Lancaster | Pennsylvania | 42071 | 77605 | 1399 |
1952148 | 1952148 | 2021-11-25 | Lancaster | Pennsylvania | 42071 | 77391 | 1399 |
1948897 | 1948897 | 2021-11-24 | Lancaster | Pennsylvania | 42071 | 77149 | 1397 |
1945646 | 1945646 | 2021-11-23 | Lancaster | Pennsylvania | 42071 | 76919 | 1393 |
1942395 | 1942395 | 2021-11-22 | Lancaster | Pennsylvania | 42071 | 76751 | 1390 |
1939145 | 1939145 | 2021-11-21 | Lancaster | Pennsylvania | 42071 | 76495 | 1390 |
1935895 | 1935895 | 2021-11-20 | Lancaster | Pennsylvania | 42071 | 76288 | 1389 |
1932645 | 1932645 | 2021-11-19 | Lancaster | Pennsylvania | 42071 | 76092 | 1386 |
1929394 | 1929394 | 2021-11-18 | Lancaster | Pennsylvania | 42071 | 75754 | 1381 |
1926144 | 1926144 | 2021-11-17 | Lancaster | Pennsylvania | 42071 | 75530 | 1376 |
1922894 | 1922894 | 2021-11-16 | Lancaster | Pennsylvania | 42071 | 75290 | 1373 |
1919645 | 1919645 | 2021-11-15 | Lancaster | Pennsylvania | 42071 | 75125 | 1370 |
1916395 | 1916395 | 2021-11-14 | Lancaster | Pennsylvania | 42071 | 74966 | 1370 |
1913145 | 1913145 | 2021-11-13 | Lancaster | Pennsylvania | 42071 | 74799 | 1370 |
1909895 | 1909895 | 2021-11-12 | Lancaster | Pennsylvania | 42071 | 73806 | 1363 |
1906646 | 1906646 | 2021-11-11 | Lancaster | Pennsylvania | 42071 | 73645 | 1363 |
1903397 | 1903397 | 2021-11-10 | Lancaster | Pennsylvania | 42071 | 73439 | 1359 |
1900147 | 1900147 | 2021-11-09 | Lancaster | Pennsylvania | 42071 | 73260 | 1350 |
1896897 | 1896897 | 2021-11-08 | Lancaster | Pennsylvania | 42071 | 73117 | 1349 |
1893647 | 1893647 | 2021-11-07 | Lancaster | Pennsylvania | 42071 | 72989 | 1348 |
1890397 | 1890397 | 2021-11-06 | Lancaster | Pennsylvania | 42071 | 72814 | 1348 |
1887147 | 1887147 | 2021-11-05 | Lancaster | Pennsylvania | 42071 | 72597 | 1345 |
1883897 | 1883897 | 2021-11-04 | Lancaster | Pennsylvania | 42071 | 72429 | 1343 |
1880648 | 1880648 | 2021-11-03 | Lancaster | Pennsylvania | 42071 | 72216 | 1340 |
1877399 | 1877399 | 2021-11-02 | Lancaster | Pennsylvania | 42071 | 72061 | 1331 |
1874150 | 1874150 | 2021-11-01 | Lancaster | Pennsylvania | 42071 | 71858 | 1330 |
1870901 | 1870901 | 2021-10-31 | Lancaster | Pennsylvania | 42071 | 71858 | 1330 |
1867652 | 1867652 | 2021-10-30 | Lancaster | Pennsylvania | 42071 | 71663 | 1328 |
1864403 | 1864403 | 2021-10-29 | Lancaster | Pennsylvania | 42071 | 71489 | 1327 |
1861154 | 1861154 | 2021-10-28 | Lancaster | Pennsylvania | 42071 | 71295 | 1321 |
1857905 | 1857905 | 2021-10-27 | Lancaster | Pennsylvania | 42071 | 71125 | 1315 |
1854656 | 1854656 | 2021-10-26 | Lancaster | Pennsylvania | 42071 | 70932 | 1304 |
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);