ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42105 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111448 | 2111448 | 2022-01-13 | Potter | Pennsylvania | 42105 | 2702 | 80 |
2108196 | 2108196 | 2022-01-12 | Potter | Pennsylvania | 42105 | 2689 | 80 |
2104945 | 2104945 | 2022-01-11 | Potter | Pennsylvania | 42105 | 2673 | 80 |
2101694 | 2101694 | 2022-01-10 | Potter | Pennsylvania | 42105 | 2653 | 80 |
2098443 | 2098443 | 2022-01-09 | Potter | Pennsylvania | 42105 | 2652 | 80 |
2095191 | 2095191 | 2022-01-08 | Potter | Pennsylvania | 42105 | 2639 | 80 |
2091939 | 2091939 | 2022-01-07 | Potter | Pennsylvania | 42105 | 2629 | 80 |
2088687 | 2088687 | 2022-01-06 | Potter | Pennsylvania | 42105 | 2617 | 79 |
2085436 | 2085436 | 2022-01-05 | Potter | Pennsylvania | 42105 | 2611 | 79 |
2082184 | 2082184 | 2022-01-04 | Potter | Pennsylvania | 42105 | 2607 | 79 |
2078932 | 2078932 | 2022-01-03 | Potter | Pennsylvania | 42105 | 2597 | 79 |
2075681 | 2075681 | 2022-01-02 | Potter | Pennsylvania | 42105 | 2591 | 79 |
2072430 | 2072430 | 2022-01-01 | Potter | Pennsylvania | 42105 | 2581 | 79 |
2069179 | 2069179 | 2021-12-31 | Potter | Pennsylvania | 42105 | 2580 | 79 |
2065928 | 2065928 | 2021-12-30 | Potter | Pennsylvania | 42105 | 2574 | 78 |
2062678 | 2062678 | 2021-12-29 | Potter | Pennsylvania | 42105 | 2566 | 78 |
2059428 | 2059428 | 2021-12-28 | Potter | Pennsylvania | 42105 | 2560 | 78 |
2056179 | 2056179 | 2021-12-27 | Potter | Pennsylvania | 42105 | 2558 | 78 |
2052930 | 2052930 | 2021-12-26 | Potter | Pennsylvania | 42105 | 2555 | 78 |
2049680 | 2049680 | 2021-12-25 | Potter | Pennsylvania | 42105 | 2550 | 78 |
2046430 | 2046430 | 2021-12-24 | Potter | Pennsylvania | 42105 | 2549 | 78 |
2043180 | 2043180 | 2021-12-23 | Potter | Pennsylvania | 42105 | 2544 | 76 |
2039931 | 2039931 | 2021-12-22 | Potter | Pennsylvania | 42105 | 2543 | 76 |
2036681 | 2036681 | 2021-12-21 | Potter | Pennsylvania | 42105 | 2538 | 75 |
2033431 | 2033431 | 2021-12-20 | Potter | Pennsylvania | 42105 | 2532 | 73 |
2030181 | 2030181 | 2021-12-19 | Potter | Pennsylvania | 42105 | 2530 | 73 |
2026930 | 2026930 | 2021-12-18 | Potter | Pennsylvania | 42105 | 2523 | 73 |
2023679 | 2023679 | 2021-12-17 | Potter | Pennsylvania | 42105 | 2515 | 72 |
2020428 | 2020428 | 2021-12-16 | Potter | Pennsylvania | 42105 | 2512 | 72 |
2017177 | 2017177 | 2021-12-15 | Potter | Pennsylvania | 42105 | 2503 | 72 |
2013927 | 2013927 | 2021-12-14 | Potter | Pennsylvania | 42105 | 2491 | 70 |
2010676 | 2010676 | 2021-12-13 | Potter | Pennsylvania | 42105 | 2486 | 70 |
2007425 | 2007425 | 2021-12-12 | Potter | Pennsylvania | 42105 | 2478 | 70 |
2004174 | 2004174 | 2021-12-11 | Potter | Pennsylvania | 42105 | 2470 | 70 |
2000923 | 2000923 | 2021-12-10 | Potter | Pennsylvania | 42105 | 2437 | 69 |
1997673 | 1997673 | 2021-12-09 | Potter | Pennsylvania | 42105 | 2420 | 68 |
1994422 | 1994422 | 2021-12-08 | Potter | Pennsylvania | 42105 | 2414 | 67 |
1991171 | 1991171 | 2021-12-07 | Potter | Pennsylvania | 42105 | 2398 | 67 |
1987920 | 1987920 | 2021-12-06 | Potter | Pennsylvania | 42105 | 2386 | 65 |
1984670 | 1984670 | 2021-12-05 | Potter | Pennsylvania | 42105 | 2383 | 65 |
1981420 | 1981420 | 2021-12-04 | Potter | Pennsylvania | 42105 | 2371 | 65 |
1978170 | 1978170 | 2021-12-03 | Potter | Pennsylvania | 42105 | 2351 | 65 |
1974920 | 1974920 | 2021-12-02 | Potter | Pennsylvania | 42105 | 2340 | 65 |
1971671 | 1971671 | 2021-12-01 | Potter | Pennsylvania | 42105 | 2324 | 63 |
1968421 | 1968421 | 2021-11-30 | Potter | Pennsylvania | 42105 | 2307 | 62 |
1965170 | 1965170 | 2021-11-29 | Potter | Pennsylvania | 42105 | 2277 | 60 |
1961918 | 1961918 | 2021-11-28 | Potter | Pennsylvania | 42105 | 2270 | 59 |
1958667 | 1958667 | 2021-11-27 | Potter | Pennsylvania | 42105 | 2265 | 59 |
1955416 | 1955416 | 2021-11-26 | Potter | Pennsylvania | 42105 | 2245 | 59 |
1952165 | 1952165 | 2021-11-25 | Potter | Pennsylvania | 42105 | 2226 | 59 |
1948914 | 1948914 | 2021-11-24 | Potter | Pennsylvania | 42105 | 2220 | 54 |
1945663 | 1945663 | 2021-11-23 | Potter | Pennsylvania | 42105 | 2204 | 53 |
1942412 | 1942412 | 2021-11-22 | Potter | Pennsylvania | 42105 | 2197 | 53 |
1939162 | 1939162 | 2021-11-21 | Potter | Pennsylvania | 42105 | 2194 | 53 |
1935912 | 1935912 | 2021-11-20 | Potter | Pennsylvania | 42105 | 2177 | 53 |
1932662 | 1932662 | 2021-11-19 | Potter | Pennsylvania | 42105 | 2173 | 53 |
1929411 | 1929411 | 2021-11-18 | Potter | Pennsylvania | 42105 | 2144 | 53 |
1926161 | 1926161 | 2021-11-17 | Potter | Pennsylvania | 42105 | 2135 | 52 |
1922911 | 1922911 | 2021-11-16 | Potter | Pennsylvania | 42105 | 2118 | 52 |
1919662 | 1919662 | 2021-11-15 | Potter | Pennsylvania | 42105 | 2098 | 51 |
1916412 | 1916412 | 2021-11-14 | Potter | Pennsylvania | 42105 | 2096 | 51 |
1913162 | 1913162 | 2021-11-13 | Potter | Pennsylvania | 42105 | 2090 | 51 |
1909912 | 1909912 | 2021-11-12 | Potter | Pennsylvania | 42105 | 2047 | 51 |
1906663 | 1906663 | 2021-11-11 | Potter | Pennsylvania | 42105 | 2035 | 51 |
1903414 | 1903414 | 2021-11-10 | Potter | Pennsylvania | 42105 | 2017 | 51 |
1900164 | 1900164 | 2021-11-09 | Potter | Pennsylvania | 42105 | 2010 | 49 |
1896914 | 1896914 | 2021-11-08 | Potter | Pennsylvania | 42105 | 2001 | 49 |
1893664 | 1893664 | 2021-11-07 | Potter | Pennsylvania | 42105 | 1997 | 49 |
1890414 | 1890414 | 2021-11-06 | Potter | Pennsylvania | 42105 | 1994 | 49 |
1887164 | 1887164 | 2021-11-05 | Potter | Pennsylvania | 42105 | 1981 | 49 |
1883914 | 1883914 | 2021-11-04 | Potter | Pennsylvania | 42105 | 1963 | 49 |
1880665 | 1880665 | 2021-11-03 | Potter | Pennsylvania | 42105 | 1940 | 49 |
1877416 | 1877416 | 2021-11-02 | Potter | Pennsylvania | 42105 | 1925 | 47 |
1874167 | 1874167 | 2021-11-01 | Potter | Pennsylvania | 42105 | 1907 | 47 |
1870918 | 1870918 | 2021-10-31 | Potter | Pennsylvania | 42105 | 1907 | 47 |
1867669 | 1867669 | 2021-10-30 | Potter | Pennsylvania | 42105 | 1904 | 47 |
1864420 | 1864420 | 2021-10-29 | Potter | Pennsylvania | 42105 | 1893 | 47 |
1861171 | 1861171 | 2021-10-28 | Potter | Pennsylvania | 42105 | 1877 | 47 |
1857922 | 1857922 | 2021-10-27 | Potter | Pennsylvania | 42105 | 1866 | 45 |
1854673 | 1854673 | 2021-10-26 | Potter | Pennsylvania | 42105 | 1859 | 45 |
1851424 | 1851424 | 2021-10-25 | Potter | Pennsylvania | 42105 | 1851 | 45 |
1848174 | 1848174 | 2021-10-24 | Potter | Pennsylvania | 42105 | 1850 | 45 |
1844924 | 1844924 | 2021-10-23 | Potter | Pennsylvania | 42105 | 1849 | 44 |
1841674 | 1841674 | 2021-10-22 | Potter | Pennsylvania | 42105 | 1840 | 44 |
1838425 | 1838425 | 2021-10-21 | Potter | Pennsylvania | 42105 | 1831 | 44 |
1835176 | 1835176 | 2021-10-20 | Potter | Pennsylvania | 42105 | 1825 | 43 |
1831927 | 1831927 | 2021-10-19 | Potter | Pennsylvania | 42105 | 1815 | 41 |
1828678 | 1828678 | 2021-10-18 | Potter | Pennsylvania | 42105 | 1813 | 40 |
1825429 | 1825429 | 2021-10-17 | Potter | Pennsylvania | 42105 | 1810 | 38 |
1822180 | 1822180 | 2021-10-16 | Potter | Pennsylvania | 42105 | 1808 | 38 |
1818931 | 1818931 | 2021-10-15 | Potter | Pennsylvania | 42105 | 1797 | 38 |
1815682 | 1815682 | 2021-10-14 | Potter | Pennsylvania | 42105 | 1773 | 35 |
1812434 | 1812434 | 2021-10-13 | Potter | Pennsylvania | 42105 | 1756 | 34 |
1809185 | 1809185 | 2021-10-12 | Potter | Pennsylvania | 42105 | 1749 | 33 |
1805935 | 1805935 | 2021-10-11 | Potter | Pennsylvania | 42105 | 1729 | 32 |
1802685 | 1802685 | 2021-10-10 | Potter | Pennsylvania | 42105 | 1711 | 32 |
1799436 | 1799436 | 2021-10-09 | Potter | Pennsylvania | 42105 | 1681 | 32 |
1796187 | 1796187 | 2021-10-08 | Potter | Pennsylvania | 42105 | 1668 | 32 |
1792938 | 1792938 | 2021-10-07 | Potter | Pennsylvania | 42105 | 1653 | 32 |
1789689 | 1789689 | 2021-10-06 | Potter | Pennsylvania | 42105 | 1641 | 31 |
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);