ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 42035 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176480 | 2176480 | 2022-02-02 | Clinton | Pennsylvania | 42035 | 8577 | 117 |
2173226 | 2173226 | 2022-02-01 | Clinton | Pennsylvania | 42035 | 8535 | 117 |
2169974 | 2169974 | 2022-01-31 | Clinton | Pennsylvania | 42035 | 8503 | 117 |
2166720 | 2166720 | 2022-01-30 | Clinton | Pennsylvania | 42035 | 8486 | 117 |
2163465 | 2163465 | 2022-01-29 | Clinton | Pennsylvania | 42035 | 8461 | 117 |
2160210 | 2160210 | 2022-01-28 | Clinton | Pennsylvania | 42035 | 8418 | 117 |
2156954 | 2156954 | 2022-01-27 | Clinton | Pennsylvania | 42035 | 8347 | 117 |
2153701 | 2153701 | 2022-01-26 | Clinton | Pennsylvania | 42035 | 8297 | 117 |
2150449 | 2150449 | 2022-01-25 | Clinton | Pennsylvania | 42035 | 8234 | 117 |
2147197 | 2147197 | 2022-01-24 | Clinton | Pennsylvania | 42035 | 8214 | 117 |
2143943 | 2143943 | 2022-01-23 | Clinton | Pennsylvania | 42035 | 8194 | 117 |
2140688 | 2140688 | 2022-01-22 | Clinton | Pennsylvania | 42035 | 8127 | 117 |
2137432 | 2137432 | 2022-01-21 | Clinton | Pennsylvania | 42035 | 8045 | 116 |
2134178 | 2134178 | 2022-01-20 | Clinton | Pennsylvania | 42035 | 7962 | 116 |
2130926 | 2130926 | 2022-01-19 | Clinton | Pennsylvania | 42035 | 7890 | 115 |
2127672 | 2127672 | 2022-01-18 | Clinton | Pennsylvania | 42035 | 7848 | 115 |
2124420 | 2124420 | 2022-01-17 | Clinton | Pennsylvania | 42035 | 7816 | 115 |
2121168 | 2121168 | 2022-01-16 | Clinton | Pennsylvania | 42035 | 7787 | 115 |
2117916 | 2117916 | 2022-01-15 | Clinton | Pennsylvania | 42035 | 7648 | 115 |
2114665 | 2114665 | 2022-01-14 | Clinton | Pennsylvania | 42035 | 7615 | 115 |
2111413 | 2111413 | 2022-01-13 | Clinton | Pennsylvania | 42035 | 7526 | 114 |
2108161 | 2108161 | 2022-01-12 | Clinton | Pennsylvania | 42035 | 7452 | 113 |
2104910 | 2104910 | 2022-01-11 | Clinton | Pennsylvania | 42035 | 7384 | 111 |
2101659 | 2101659 | 2022-01-10 | Clinton | Pennsylvania | 42035 | 7333 | 110 |
2098408 | 2098408 | 2022-01-09 | Clinton | Pennsylvania | 42035 | 7277 | 110 |
2095156 | 2095156 | 2022-01-08 | Clinton | Pennsylvania | 42035 | 7190 | 110 |
2091904 | 2091904 | 2022-01-07 | Clinton | Pennsylvania | 42035 | 7117 | 110 |
2088652 | 2088652 | 2022-01-06 | Clinton | Pennsylvania | 42035 | 7039 | 108 |
2085401 | 2085401 | 2022-01-05 | Clinton | Pennsylvania | 42035 | 6968 | 108 |
2082149 | 2082149 | 2022-01-04 | Clinton | Pennsylvania | 42035 | 6924 | 107 |
2078897 | 2078897 | 2022-01-03 | Clinton | Pennsylvania | 42035 | 6911 | 106 |
2075646 | 2075646 | 2022-01-02 | Clinton | Pennsylvania | 42035 | 6882 | 105 |
2072395 | 2072395 | 2022-01-01 | Clinton | Pennsylvania | 42035 | 6844 | 105 |
2069144 | 2069144 | 2021-12-31 | Clinton | Pennsylvania | 42035 | 6803 | 105 |
2065893 | 2065893 | 2021-12-30 | Clinton | Pennsylvania | 42035 | 6747 | 104 |
2062643 | 2062643 | 2021-12-29 | Clinton | Pennsylvania | 42035 | 6693 | 102 |
2059393 | 2059393 | 2021-12-28 | Clinton | Pennsylvania | 42035 | 6660 | 102 |
2056144 | 2056144 | 2021-12-27 | Clinton | Pennsylvania | 42035 | 6650 | 102 |
2052895 | 2052895 | 2021-12-26 | Clinton | Pennsylvania | 42035 | 6636 | 102 |
2049645 | 2049645 | 2021-12-25 | Clinton | Pennsylvania | 42035 | 6626 | 102 |
2046395 | 2046395 | 2021-12-24 | Clinton | Pennsylvania | 42035 | 6604 | 102 |
2043145 | 2043145 | 2021-12-23 | Clinton | Pennsylvania | 42035 | 6575 | 102 |
2039896 | 2039896 | 2021-12-22 | Clinton | Pennsylvania | 42035 | 6561 | 100 |
2036646 | 2036646 | 2021-12-21 | Clinton | Pennsylvania | 42035 | 6548 | 100 |
2033396 | 2033396 | 2021-12-20 | Clinton | Pennsylvania | 42035 | 6531 | 99 |
2030146 | 2030146 | 2021-12-19 | Clinton | Pennsylvania | 42035 | 6523 | 99 |
2026895 | 2026895 | 2021-12-18 | Clinton | Pennsylvania | 42035 | 6505 | 99 |
2023644 | 2023644 | 2021-12-17 | Clinton | Pennsylvania | 42035 | 6479 | 99 |
2020393 | 2020393 | 2021-12-16 | Clinton | Pennsylvania | 42035 | 6461 | 99 |
2017142 | 2017142 | 2021-12-15 | Clinton | Pennsylvania | 42035 | 6440 | 98 |
2013892 | 2013892 | 2021-12-14 | Clinton | Pennsylvania | 42035 | 6406 | 98 |
2010641 | 2010641 | 2021-12-13 | Clinton | Pennsylvania | 42035 | 6399 | 97 |
2007390 | 2007390 | 2021-12-12 | Clinton | Pennsylvania | 42035 | 6382 | 97 |
2004139 | 2004139 | 2021-12-11 | Clinton | Pennsylvania | 42035 | 6349 | 97 |
2000888 | 2000888 | 2021-12-10 | Clinton | Pennsylvania | 42035 | 6327 | 96 |
1997638 | 1997638 | 2021-12-09 | Clinton | Pennsylvania | 42035 | 6289 | 96 |
1994387 | 1994387 | 2021-12-08 | Clinton | Pennsylvania | 42035 | 6270 | 95 |
1991136 | 1991136 | 2021-12-07 | Clinton | Pennsylvania | 42035 | 6240 | 95 |
1987885 | 1987885 | 2021-12-06 | Clinton | Pennsylvania | 42035 | 6226 | 95 |
1984635 | 1984635 | 2021-12-05 | Clinton | Pennsylvania | 42035 | 6212 | 95 |
1981385 | 1981385 | 2021-12-04 | Clinton | Pennsylvania | 42035 | 6163 | 94 |
1978135 | 1978135 | 2021-12-03 | Clinton | Pennsylvania | 42035 | 6117 | 94 |
1974885 | 1974885 | 2021-12-02 | Clinton | Pennsylvania | 42035 | 6077 | 93 |
1971636 | 1971636 | 2021-12-01 | Clinton | Pennsylvania | 42035 | 6048 | 92 |
1968386 | 1968386 | 2021-11-30 | Clinton | Pennsylvania | 42035 | 6012 | 91 |
1965135 | 1965135 | 2021-11-29 | Clinton | Pennsylvania | 42035 | 5986 | 88 |
1961883 | 1961883 | 2021-11-28 | Clinton | Pennsylvania | 42035 | 5966 | 88 |
1958632 | 1958632 | 2021-11-27 | Clinton | Pennsylvania | 42035 | 5944 | 88 |
1955381 | 1955381 | 2021-11-26 | Clinton | Pennsylvania | 42035 | 5939 | 88 |
1952130 | 1952130 | 2021-11-25 | Clinton | Pennsylvania | 42035 | 5906 | 88 |
1948879 | 1948879 | 2021-11-24 | Clinton | Pennsylvania | 42035 | 5880 | 86 |
1945628 | 1945628 | 2021-11-23 | Clinton | Pennsylvania | 42035 | 5844 | 86 |
1942377 | 1942377 | 2021-11-22 | Clinton | Pennsylvania | 42035 | 5824 | 86 |
1939127 | 1939127 | 2021-11-21 | Clinton | Pennsylvania | 42035 | 5811 | 86 |
1935877 | 1935877 | 2021-11-20 | Clinton | Pennsylvania | 42035 | 5776 | 86 |
1932627 | 1932627 | 2021-11-19 | Clinton | Pennsylvania | 42035 | 5741 | 86 |
1929376 | 1929376 | 2021-11-18 | Clinton | Pennsylvania | 42035 | 5676 | 86 |
1926126 | 1926126 | 2021-11-17 | Clinton | Pennsylvania | 42035 | 5649 | 85 |
1922876 | 1922876 | 2021-11-16 | Clinton | Pennsylvania | 42035 | 5612 | 84 |
1919627 | 1919627 | 2021-11-15 | Clinton | Pennsylvania | 42035 | 5589 | 83 |
1916377 | 1916377 | 2021-11-14 | Clinton | Pennsylvania | 42035 | 5579 | 83 |
1913127 | 1913127 | 2021-11-13 | Clinton | Pennsylvania | 42035 | 5540 | 83 |
1909877 | 1909877 | 2021-11-12 | Clinton | Pennsylvania | 42035 | 5428 | 81 |
1906628 | 1906628 | 2021-11-11 | Clinton | Pennsylvania | 42035 | 5381 | 81 |
1903379 | 1903379 | 2021-11-10 | Clinton | Pennsylvania | 42035 | 5341 | 81 |
1900129 | 1900129 | 2021-11-09 | Clinton | Pennsylvania | 42035 | 5271 | 81 |
1896879 | 1896879 | 2021-11-08 | Clinton | Pennsylvania | 42035 | 5246 | 81 |
1893629 | 1893629 | 2021-11-07 | Clinton | Pennsylvania | 42035 | 5229 | 81 |
1890379 | 1890379 | 2021-11-06 | Clinton | Pennsylvania | 42035 | 5193 | 81 |
1887129 | 1887129 | 2021-11-05 | Clinton | Pennsylvania | 42035 | 5147 | 81 |
1883879 | 1883879 | 2021-11-04 | Clinton | Pennsylvania | 42035 | 5087 | 81 |
1880630 | 1880630 | 2021-11-03 | Clinton | Pennsylvania | 42035 | 5068 | 81 |
1877381 | 1877381 | 2021-11-02 | Clinton | Pennsylvania | 42035 | 5039 | 79 |
1874132 | 1874132 | 2021-11-01 | Clinton | Pennsylvania | 42035 | 5022 | 78 |
1870883 | 1870883 | 2021-10-31 | Clinton | Pennsylvania | 42035 | 5022 | 78 |
1867634 | 1867634 | 2021-10-30 | Clinton | Pennsylvania | 42035 | 5010 | 78 |
1864385 | 1864385 | 2021-10-29 | Clinton | Pennsylvania | 42035 | 4975 | 77 |
1861136 | 1861136 | 2021-10-28 | Clinton | Pennsylvania | 42035 | 4954 | 76 |
1857887 | 1857887 | 2021-10-27 | Clinton | Pennsylvania | 42035 | 4917 | 75 |
1854638 | 1854638 | 2021-10-26 | Clinton | Pennsylvania | 42035 | 4889 | 73 |
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);