ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 42043 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176484 | 2176484 | 2022-02-02 | Dauphin | Pennsylvania | 42043 | 57092 | 870 |
2173230 | 2173230 | 2022-02-01 | Dauphin | Pennsylvania | 42043 | 56958 | 867 |
2169978 | 2169978 | 2022-01-31 | Dauphin | Pennsylvania | 42043 | 56744 | 863 |
2166724 | 2166724 | 2022-01-30 | Dauphin | Pennsylvania | 42043 | 56645 | 863 |
2163469 | 2163469 | 2022-01-29 | Dauphin | Pennsylvania | 42043 | 56500 | 863 |
2160214 | 2160214 | 2022-01-28 | Dauphin | Pennsylvania | 42043 | 56327 | 857 |
2156958 | 2156958 | 2022-01-27 | Dauphin | Pennsylvania | 42043 | 56038 | 855 |
2153705 | 2153705 | 2022-01-26 | Dauphin | Pennsylvania | 42043 | 55720 | 844 |
2150453 | 2150453 | 2022-01-25 | Dauphin | Pennsylvania | 42043 | 55392 | 840 |
2147201 | 2147201 | 2022-01-24 | Dauphin | Pennsylvania | 42043 | 55111 | 837 |
2143947 | 2143947 | 2022-01-23 | Dauphin | Pennsylvania | 42043 | 54925 | 837 |
2140692 | 2140692 | 2022-01-22 | Dauphin | Pennsylvania | 42043 | 54687 | 834 |
2137436 | 2137436 | 2022-01-21 | Dauphin | Pennsylvania | 42043 | 54304 | 830 |
2134182 | 2134182 | 2022-01-20 | Dauphin | Pennsylvania | 42043 | 53936 | 824 |
2130930 | 2130930 | 2022-01-19 | Dauphin | Pennsylvania | 42043 | 53531 | 815 |
2127676 | 2127676 | 2022-01-18 | Dauphin | Pennsylvania | 42043 | 53200 | 812 |
2124424 | 2124424 | 2022-01-17 | Dauphin | Pennsylvania | 42043 | 52768 | 811 |
2121172 | 2121172 | 2022-01-16 | Dauphin | Pennsylvania | 42043 | 52472 | 811 |
2117920 | 2117920 | 2022-01-15 | Dauphin | Pennsylvania | 42043 | 51825 | 809 |
2114669 | 2114669 | 2022-01-14 | Dauphin | Pennsylvania | 42043 | 51399 | 804 |
2111417 | 2111417 | 2022-01-13 | Dauphin | Pennsylvania | 42043 | 50725 | 798 |
2108165 | 2108165 | 2022-01-12 | Dauphin | Pennsylvania | 42043 | 50236 | 791 |
2104914 | 2104914 | 2022-01-11 | Dauphin | Pennsylvania | 42043 | 49757 | 786 |
2101663 | 2101663 | 2022-01-10 | Dauphin | Pennsylvania | 42043 | 49125 | 784 |
2098412 | 2098412 | 2022-01-09 | Dauphin | Pennsylvania | 42043 | 48629 | 783 |
2095160 | 2095160 | 2022-01-08 | Dauphin | Pennsylvania | 42043 | 48019 | 782 |
2091908 | 2091908 | 2022-01-07 | Dauphin | Pennsylvania | 42043 | 47350 | 780 |
2088656 | 2088656 | 2022-01-06 | Dauphin | Pennsylvania | 42043 | 46790 | 776 |
2085405 | 2085405 | 2022-01-05 | Dauphin | Pennsylvania | 42043 | 46186 | 772 |
2082153 | 2082153 | 2022-01-04 | Dauphin | Pennsylvania | 42043 | 45633 | 766 |
2078901 | 2078901 | 2022-01-03 | Dauphin | Pennsylvania | 42043 | 45084 | 762 |
2075650 | 2075650 | 2022-01-02 | Dauphin | Pennsylvania | 42043 | 44721 | 758 |
2072399 | 2072399 | 2022-01-01 | Dauphin | Pennsylvania | 42043 | 44362 | 758 |
2069148 | 2069148 | 2021-12-31 | Dauphin | Pennsylvania | 42043 | 43920 | 758 |
2065897 | 2065897 | 2021-12-30 | Dauphin | Pennsylvania | 42043 | 43415 | 756 |
2062647 | 2062647 | 2021-12-29 | Dauphin | Pennsylvania | 42043 | 42991 | 754 |
2059397 | 2059397 | 2021-12-28 | Dauphin | Pennsylvania | 42043 | 42751 | 747 |
2056148 | 2056148 | 2021-12-27 | Dauphin | Pennsylvania | 42043 | 42332 | 745 |
2052899 | 2052899 | 2021-12-26 | Dauphin | Pennsylvania | 42043 | 42237 | 745 |
2049649 | 2049649 | 2021-12-25 | Dauphin | Pennsylvania | 42043 | 42144 | 745 |
2046399 | 2046399 | 2021-12-24 | Dauphin | Pennsylvania | 42043 | 41975 | 745 |
2043149 | 2043149 | 2021-12-23 | Dauphin | Pennsylvania | 42043 | 41756 | 744 |
2039900 | 2039900 | 2021-12-22 | Dauphin | Pennsylvania | 42043 | 41579 | 743 |
2036650 | 2036650 | 2021-12-21 | Dauphin | Pennsylvania | 42043 | 41427 | 739 |
2033400 | 2033400 | 2021-12-20 | Dauphin | Pennsylvania | 42043 | 41236 | 739 |
2030150 | 2030150 | 2021-12-19 | Dauphin | Pennsylvania | 42043 | 41154 | 738 |
2026899 | 2026899 | 2021-12-18 | Dauphin | Pennsylvania | 42043 | 40982 | 738 |
2023648 | 2023648 | 2021-12-17 | Dauphin | Pennsylvania | 42043 | 40798 | 731 |
2020397 | 2020397 | 2021-12-16 | Dauphin | Pennsylvania | 42043 | 40645 | 727 |
2017146 | 2017146 | 2021-12-15 | Dauphin | Pennsylvania | 42043 | 40478 | 726 |
2013896 | 2013896 | 2021-12-14 | Dauphin | Pennsylvania | 42043 | 40332 | 724 |
2010645 | 2010645 | 2021-12-13 | Dauphin | Pennsylvania | 42043 | 40166 | 721 |
2007394 | 2007394 | 2021-12-12 | Dauphin | Pennsylvania | 42043 | 40031 | 721 |
2004143 | 2004143 | 2021-12-11 | Dauphin | Pennsylvania | 42043 | 39890 | 721 |
2000892 | 2000892 | 2021-12-10 | Dauphin | Pennsylvania | 42043 | 39635 | 716 |
1997642 | 1997642 | 2021-12-09 | Dauphin | Pennsylvania | 42043 | 39403 | 712 |
1994391 | 1994391 | 2021-12-08 | Dauphin | Pennsylvania | 42043 | 39266 | 711 |
1991140 | 1991140 | 2021-12-07 | Dauphin | Pennsylvania | 42043 | 39125 | 710 |
1987889 | 1987889 | 2021-12-06 | Dauphin | Pennsylvania | 42043 | 38950 | 707 |
1984639 | 1984639 | 2021-12-05 | Dauphin | Pennsylvania | 42043 | 38871 | 707 |
1981389 | 1981389 | 2021-12-04 | Dauphin | Pennsylvania | 42043 | 38756 | 706 |
1978139 | 1978139 | 2021-12-03 | Dauphin | Pennsylvania | 42043 | 38598 | 700 |
1974889 | 1974889 | 2021-12-02 | Dauphin | Pennsylvania | 42043 | 38443 | 698 |
1971640 | 1971640 | 2021-12-01 | Dauphin | Pennsylvania | 42043 | 38271 | 694 |
1968390 | 1968390 | 2021-11-30 | Dauphin | Pennsylvania | 42043 | 38151 | 694 |
1965139 | 1965139 | 2021-11-29 | Dauphin | Pennsylvania | 42043 | 38043 | 694 |
1961887 | 1961887 | 2021-11-28 | Dauphin | Pennsylvania | 42043 | 37990 | 691 |
1958636 | 1958636 | 2021-11-27 | Dauphin | Pennsylvania | 42043 | 37924 | 691 |
1955385 | 1955385 | 2021-11-26 | Dauphin | Pennsylvania | 42043 | 37807 | 691 |
1952134 | 1952134 | 2021-11-25 | Dauphin | Pennsylvania | 42043 | 37721 | 691 |
1948883 | 1948883 | 2021-11-24 | Dauphin | Pennsylvania | 42043 | 37612 | 685 |
1945632 | 1945632 | 2021-11-23 | Dauphin | Pennsylvania | 42043 | 37477 | 684 |
1942381 | 1942381 | 2021-11-22 | Dauphin | Pennsylvania | 42043 | 37356 | 684 |
1939131 | 1939131 | 2021-11-21 | Dauphin | Pennsylvania | 42043 | 37274 | 684 |
1935881 | 1935881 | 2021-11-20 | Dauphin | Pennsylvania | 42043 | 37175 | 682 |
1932631 | 1932631 | 2021-11-19 | Dauphin | Pennsylvania | 42043 | 37082 | 677 |
1929380 | 1929380 | 2021-11-18 | Dauphin | Pennsylvania | 42043 | 36977 | 673 |
1926130 | 1926130 | 2021-11-17 | Dauphin | Pennsylvania | 42043 | 36831 | 673 |
1922880 | 1922880 | 2021-11-16 | Dauphin | Pennsylvania | 42043 | 36684 | 673 |
1919631 | 1919631 | 2021-11-15 | Dauphin | Pennsylvania | 42043 | 36559 | 673 |
1916381 | 1916381 | 2021-11-14 | Dauphin | Pennsylvania | 42043 | 36483 | 673 |
1913131 | 1913131 | 2021-11-13 | Dauphin | Pennsylvania | 42043 | 36407 | 671 |
1909881 | 1909881 | 2021-11-12 | Dauphin | Pennsylvania | 42043 | 35913 | 671 |
1906632 | 1906632 | 2021-11-11 | Dauphin | Pennsylvania | 42043 | 35843 | 671 |
1903383 | 1903383 | 2021-11-10 | Dauphin | Pennsylvania | 42043 | 35738 | 670 |
1900133 | 1900133 | 2021-11-09 | Dauphin | Pennsylvania | 42043 | 35644 | 662 |
1896883 | 1896883 | 2021-11-08 | Dauphin | Pennsylvania | 42043 | 35538 | 660 |
1893633 | 1893633 | 2021-11-07 | Dauphin | Pennsylvania | 42043 | 35485 | 659 |
1890383 | 1890383 | 2021-11-06 | Dauphin | Pennsylvania | 42043 | 35428 | 659 |
1887133 | 1887133 | 2021-11-05 | Dauphin | Pennsylvania | 42043 | 35342 | 659 |
1883883 | 1883883 | 2021-11-04 | Dauphin | Pennsylvania | 42043 | 35254 | 656 |
1880634 | 1880634 | 2021-11-03 | Dauphin | Pennsylvania | 42043 | 35157 | 656 |
1877385 | 1877385 | 2021-11-02 | Dauphin | Pennsylvania | 42043 | 35081 | 653 |
1874136 | 1874136 | 2021-11-01 | Dauphin | Pennsylvania | 42043 | 34955 | 651 |
1870887 | 1870887 | 2021-10-31 | Dauphin | Pennsylvania | 42043 | 34955 | 651 |
1867638 | 1867638 | 2021-10-30 | Dauphin | Pennsylvania | 42043 | 34903 | 650 |
1864389 | 1864389 | 2021-10-29 | Dauphin | Pennsylvania | 42043 | 34800 | 650 |
1861140 | 1861140 | 2021-10-28 | Dauphin | Pennsylvania | 42043 | 34746 | 645 |
1857891 | 1857891 | 2021-10-27 | Dauphin | Pennsylvania | 42043 | 34666 | 642 |
1854642 | 1854642 | 2021-10-26 | Dauphin | Pennsylvania | 42043 | 34571 | 639 |
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);