ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Potter" and fips = 42105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176515 | 2176515 | 2022-02-02 | Potter | Pennsylvania | 42105 | 2987 | 86 |
2173261 | 2173261 | 2022-02-01 | Potter | Pennsylvania | 42105 | 2982 | 86 |
2170009 | 2170009 | 2022-01-31 | Potter | Pennsylvania | 42105 | 2967 | 86 |
2166755 | 2166755 | 2022-01-30 | Potter | Pennsylvania | 42105 | 2956 | 86 |
2163500 | 2163500 | 2022-01-29 | Potter | Pennsylvania | 42105 | 2948 | 86 |
2160245 | 2160245 | 2022-01-28 | Potter | Pennsylvania | 42105 | 2933 | 86 |
2156989 | 2156989 | 2022-01-27 | Potter | Pennsylvania | 42105 | 2922 | 86 |
2153736 | 2153736 | 2022-01-26 | Potter | Pennsylvania | 42105 | 2884 | 84 |
2150484 | 2150484 | 2022-01-25 | Potter | Pennsylvania | 42105 | 2868 | 83 |
2147232 | 2147232 | 2022-01-24 | Potter | Pennsylvania | 42105 | 2861 | 83 |
2143978 | 2143978 | 2022-01-23 | Potter | Pennsylvania | 42105 | 2846 | 82 |
2140723 | 2140723 | 2022-01-22 | Potter | Pennsylvania | 42105 | 2840 | 82 |
2137467 | 2137467 | 2022-01-21 | Potter | Pennsylvania | 42105 | 2821 | 81 |
2134213 | 2134213 | 2022-01-20 | Potter | Pennsylvania | 42105 | 2796 | 81 |
2130961 | 2130961 | 2022-01-19 | Potter | Pennsylvania | 42105 | 2775 | 80 |
2127707 | 2127707 | 2022-01-18 | Potter | Pennsylvania | 42105 | 2766 | 80 |
2124455 | 2124455 | 2022-01-17 | Potter | Pennsylvania | 42105 | 2764 | 80 |
2121203 | 2121203 | 2022-01-16 | Potter | Pennsylvania | 42105 | 2760 | 80 |
2117951 | 2117951 | 2022-01-15 | Potter | Pennsylvania | 42105 | 2741 | 80 |
2114700 | 2114700 | 2022-01-14 | Potter | Pennsylvania | 42105 | 2724 | 80 |
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 |
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);