ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 42017 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176471 | 2176471 | 2022-02-02 | Bucks | Pennsylvania | 42017 | 119011 | 1751 |
2173217 | 2173217 | 2022-02-01 | Bucks | Pennsylvania | 42017 | 118690 | 1742 |
2169965 | 2169965 | 2022-01-31 | Bucks | Pennsylvania | 42017 | 118542 | 1733 |
2166711 | 2166711 | 2022-01-30 | Bucks | Pennsylvania | 42017 | 118387 | 1733 |
2163456 | 2163456 | 2022-01-29 | Bucks | Pennsylvania | 42017 | 118174 | 1732 |
2160201 | 2160201 | 2022-01-28 | Bucks | Pennsylvania | 42017 | 117858 | 1721 |
2156945 | 2156945 | 2022-01-27 | Bucks | Pennsylvania | 42017 | 117418 | 1711 |
2153692 | 2153692 | 2022-01-26 | Bucks | Pennsylvania | 42017 | 116780 | 1694 |
2150440 | 2150440 | 2022-01-25 | Bucks | Pennsylvania | 42017 | 116279 | 1686 |
2147188 | 2147188 | 2022-01-24 | Bucks | Pennsylvania | 42017 | 115922 | 1678 |
2143934 | 2143934 | 2022-01-23 | Bucks | Pennsylvania | 42017 | 115650 | 1676 |
2140679 | 2140679 | 2022-01-22 | Bucks | Pennsylvania | 42017 | 115193 | 1672 |
2137423 | 2137423 | 2022-01-21 | Bucks | Pennsylvania | 42017 | 114655 | 1667 |
2134169 | 2134169 | 2022-01-20 | Bucks | Pennsylvania | 42017 | 113785 | 1648 |
2130917 | 2130917 | 2022-01-19 | Bucks | Pennsylvania | 42017 | 113169 | 1628 |
2127663 | 2127663 | 2022-01-18 | Bucks | Pennsylvania | 42017 | 112536 | 1623 |
2124411 | 2124411 | 2022-01-17 | Bucks | Pennsylvania | 42017 | 112097 | 1622 |
2121159 | 2121159 | 2022-01-16 | Bucks | Pennsylvania | 42017 | 111624 | 1622 |
2117907 | 2117907 | 2022-01-15 | Bucks | Pennsylvania | 42017 | 110048 | 1622 |
2114656 | 2114656 | 2022-01-14 | Bucks | Pennsylvania | 42017 | 109215 | 1613 |
2111404 | 2111404 | 2022-01-13 | Bucks | Pennsylvania | 42017 | 108176 | 1605 |
2108152 | 2108152 | 2022-01-12 | Bucks | Pennsylvania | 42017 | 107249 | 1599 |
2104901 | 2104901 | 2022-01-11 | Bucks | Pennsylvania | 42017 | 105763 | 1594 |
2101650 | 2101650 | 2022-01-10 | Bucks | Pennsylvania | 42017 | 104758 | 1583 |
2098399 | 2098399 | 2022-01-09 | Bucks | Pennsylvania | 42017 | 103196 | 1583 |
2095147 | 2095147 | 2022-01-08 | Bucks | Pennsylvania | 42017 | 102042 | 1582 |
2091895 | 2091895 | 2022-01-07 | Bucks | Pennsylvania | 42017 | 100744 | 1575 |
2088643 | 2088643 | 2022-01-06 | Bucks | Pennsylvania | 42017 | 98415 | 1574 |
2085392 | 2085392 | 2022-01-05 | Bucks | Pennsylvania | 42017 | 96801 | 1566 |
2082140 | 2082140 | 2022-01-04 | Bucks | Pennsylvania | 42017 | 95825 | 1564 |
2078888 | 2078888 | 2022-01-03 | Bucks | Pennsylvania | 42017 | 94912 | 1556 |
2075637 | 2075637 | 2022-01-02 | Bucks | Pennsylvania | 42017 | 93942 | 1554 |
2072386 | 2072386 | 2022-01-01 | Bucks | Pennsylvania | 42017 | 92854 | 1554 |
2069135 | 2069135 | 2021-12-31 | Bucks | Pennsylvania | 42017 | 91995 | 1553 |
2065884 | 2065884 | 2021-12-30 | Bucks | Pennsylvania | 42017 | 90889 | 1552 |
2062634 | 2062634 | 2021-12-29 | Bucks | Pennsylvania | 42017 | 90050 | 1546 |
2059384 | 2059384 | 2021-12-28 | Bucks | Pennsylvania | 42017 | 89334 | 1537 |
2056135 | 2056135 | 2021-12-27 | Bucks | Pennsylvania | 42017 | 88402 | 1533 |
2052886 | 2052886 | 2021-12-26 | Bucks | Pennsylvania | 42017 | 88143 | 1532 |
2049636 | 2049636 | 2021-12-25 | Bucks | Pennsylvania | 42017 | 87802 | 1532 |
2046386 | 2046386 | 2021-12-24 | Bucks | Pennsylvania | 42017 | 87121 | 1532 |
2043136 | 2043136 | 2021-12-23 | Bucks | Pennsylvania | 42017 | 86640 | 1530 |
2039887 | 2039887 | 2021-12-22 | Bucks | Pennsylvania | 42017 | 86158 | 1528 |
2036637 | 2036637 | 2021-12-21 | Bucks | Pennsylvania | 42017 | 85758 | 1525 |
2033387 | 2033387 | 2021-12-20 | Bucks | Pennsylvania | 42017 | 85396 | 1521 |
2030137 | 2030137 | 2021-12-19 | Bucks | Pennsylvania | 42017 | 85199 | 1521 |
2026886 | 2026886 | 2021-12-18 | Bucks | Pennsylvania | 42017 | 84914 | 1519 |
2023635 | 2023635 | 2021-12-17 | Bucks | Pennsylvania | 42017 | 84459 | 1516 |
2020384 | 2020384 | 2021-12-16 | Bucks | Pennsylvania | 42017 | 84083 | 1514 |
2017133 | 2017133 | 2021-12-15 | Bucks | Pennsylvania | 42017 | 83735 | 1512 |
2013883 | 2013883 | 2021-12-14 | Bucks | Pennsylvania | 42017 | 83414 | 1509 |
2010632 | 2010632 | 2021-12-13 | Bucks | Pennsylvania | 42017 | 83124 | 1504 |
2007381 | 2007381 | 2021-12-12 | Bucks | Pennsylvania | 42017 | 82917 | 1504 |
2004130 | 2004130 | 2021-12-11 | Bucks | Pennsylvania | 42017 | 82569 | 1504 |
2000879 | 2000879 | 2021-12-10 | Bucks | Pennsylvania | 42017 | 81974 | 1499 |
1997629 | 1997629 | 2021-12-09 | Bucks | Pennsylvania | 42017 | 81450 | 1497 |
1994378 | 1994378 | 2021-12-08 | Bucks | Pennsylvania | 42017 | 81196 | 1495 |
1991127 | 1991127 | 2021-12-07 | Bucks | Pennsylvania | 42017 | 80844 | 1494 |
1987876 | 1987876 | 2021-12-06 | Bucks | Pennsylvania | 42017 | 80546 | 1491 |
1984626 | 1984626 | 2021-12-05 | Bucks | Pennsylvania | 42017 | 80414 | 1491 |
1981376 | 1981376 | 2021-12-04 | Bucks | Pennsylvania | 42017 | 80216 | 1490 |
1978126 | 1978126 | 2021-12-03 | Bucks | Pennsylvania | 42017 | 79888 | 1488 |
1974876 | 1974876 | 2021-12-02 | Bucks | Pennsylvania | 42017 | 79563 | 1485 |
1971627 | 1971627 | 2021-12-01 | Bucks | Pennsylvania | 42017 | 79277 | 1482 |
1968377 | 1968377 | 2021-11-30 | Bucks | Pennsylvania | 42017 | 78969 | 1481 |
1965126 | 1965126 | 2021-11-29 | Bucks | Pennsylvania | 42017 | 78779 | 1478 |
1961874 | 1961874 | 2021-11-28 | Bucks | Pennsylvania | 42017 | 78639 | 1477 |
1958623 | 1958623 | 2021-11-27 | Bucks | Pennsylvania | 42017 | 78514 | 1476 |
1955372 | 1955372 | 2021-11-26 | Bucks | Pennsylvania | 42017 | 78361 | 1476 |
1952121 | 1952121 | 2021-11-25 | Bucks | Pennsylvania | 42017 | 78182 | 1476 |
1948870 | 1948870 | 2021-11-24 | Bucks | Pennsylvania | 42017 | 77964 | 1474 |
1945619 | 1945619 | 2021-11-23 | Bucks | Pennsylvania | 42017 | 77767 | 1468 |
1942368 | 1942368 | 2021-11-22 | Bucks | Pennsylvania | 42017 | 77574 | 1467 |
1939118 | 1939118 | 2021-11-21 | Bucks | Pennsylvania | 42017 | 77424 | 1467 |
1935868 | 1935868 | 2021-11-20 | Bucks | Pennsylvania | 42017 | 77278 | 1467 |
1932618 | 1932618 | 2021-11-19 | Bucks | Pennsylvania | 42017 | 77104 | 1466 |
1929367 | 1929367 | 2021-11-18 | Bucks | Pennsylvania | 42017 | 76934 | 1463 |
1926117 | 1926117 | 2021-11-17 | Bucks | Pennsylvania | 42017 | 76698 | 1460 |
1922867 | 1922867 | 2021-11-16 | Bucks | Pennsylvania | 42017 | 76506 | 1454 |
1919618 | 1919618 | 2021-11-15 | Bucks | Pennsylvania | 42017 | 76364 | 1454 |
1916368 | 1916368 | 2021-11-14 | Bucks | Pennsylvania | 42017 | 76251 | 1454 |
1913118 | 1913118 | 2021-11-13 | Bucks | Pennsylvania | 42017 | 76115 | 1451 |
1909868 | 1909868 | 2021-11-12 | Bucks | Pennsylvania | 42017 | 75366 | 1450 |
1906619 | 1906619 | 2021-11-11 | Bucks | Pennsylvania | 42017 | 75231 | 1450 |
1903370 | 1903370 | 2021-11-10 | Bucks | Pennsylvania | 42017 | 75036 | 1448 |
1900120 | 1900120 | 2021-11-09 | Bucks | Pennsylvania | 42017 | 74859 | 1439 |
1896870 | 1896870 | 2021-11-08 | Bucks | Pennsylvania | 42017 | 74706 | 1438 |
1893620 | 1893620 | 2021-11-07 | Bucks | Pennsylvania | 42017 | 74606 | 1438 |
1890370 | 1890370 | 2021-11-06 | Bucks | Pennsylvania | 42017 | 74475 | 1438 |
1887120 | 1887120 | 2021-11-05 | Bucks | Pennsylvania | 42017 | 74298 | 1438 |
1883870 | 1883870 | 2021-11-04 | Bucks | Pennsylvania | 42017 | 74113 | 1436 |
1880621 | 1880621 | 2021-11-03 | Bucks | Pennsylvania | 42017 | 73918 | 1433 |
1877372 | 1877372 | 2021-11-02 | Bucks | Pennsylvania | 42017 | 73803 | 1429 |
1874123 | 1874123 | 2021-11-01 | Bucks | Pennsylvania | 42017 | 73566 | 1427 |
1870874 | 1870874 | 2021-10-31 | Bucks | Pennsylvania | 42017 | 73566 | 1427 |
1867625 | 1867625 | 2021-10-30 | Bucks | Pennsylvania | 42017 | 73475 | 1427 |
1864376 | 1864376 | 2021-10-29 | Bucks | Pennsylvania | 42017 | 73345 | 1426 |
1861127 | 1861127 | 2021-10-28 | Bucks | Pennsylvania | 42017 | 73188 | 1424 |
1857878 | 1857878 | 2021-10-27 | Bucks | Pennsylvania | 42017 | 73036 | 1423 |
1854629 | 1854629 | 2021-10-26 | Bucks | Pennsylvania | 42017 | 72930 | 1421 |
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);