ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 42103 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176514 | 2176514 | 2022-02-02 | Pike | Pennsylvania | 42103 | 9444 | 85 |
2173260 | 2173260 | 2022-02-01 | Pike | Pennsylvania | 42103 | 9409 | 85 |
2170008 | 2170008 | 2022-01-31 | Pike | Pennsylvania | 42103 | 9387 | 84 |
2166754 | 2166754 | 2022-01-30 | Pike | Pennsylvania | 42103 | 9376 | 84 |
2163499 | 2163499 | 2022-01-29 | Pike | Pennsylvania | 42103 | 9357 | 84 |
2160244 | 2160244 | 2022-01-28 | Pike | Pennsylvania | 42103 | 9319 | 84 |
2156988 | 2156988 | 2022-01-27 | Pike | Pennsylvania | 42103 | 9272 | 84 |
2153735 | 2153735 | 2022-01-26 | Pike | Pennsylvania | 42103 | 9203 | 84 |
2150483 | 2150483 | 2022-01-25 | Pike | Pennsylvania | 42103 | 9155 | 83 |
2147231 | 2147231 | 2022-01-24 | Pike | Pennsylvania | 42103 | 9111 | 82 |
2143977 | 2143977 | 2022-01-23 | Pike | Pennsylvania | 42103 | 9084 | 82 |
2140722 | 2140722 | 2022-01-22 | Pike | Pennsylvania | 42103 | 9042 | 82 |
2137466 | 2137466 | 2022-01-21 | Pike | Pennsylvania | 42103 | 8984 | 81 |
2134212 | 2134212 | 2022-01-20 | Pike | Pennsylvania | 42103 | 8919 | 79 |
2130960 | 2130960 | 2022-01-19 | Pike | Pennsylvania | 42103 | 8852 | 79 |
2127706 | 2127706 | 2022-01-18 | Pike | Pennsylvania | 42103 | 8821 | 77 |
2124454 | 2124454 | 2022-01-17 | Pike | Pennsylvania | 42103 | 8767 | 77 |
2121202 | 2121202 | 2022-01-16 | Pike | Pennsylvania | 42103 | 8718 | 77 |
2117950 | 2117950 | 2022-01-15 | Pike | Pennsylvania | 42103 | 8617 | 77 |
2114699 | 2114699 | 2022-01-14 | Pike | Pennsylvania | 42103 | 8486 | 77 |
2111447 | 2111447 | 2022-01-13 | Pike | Pennsylvania | 42103 | 8353 | 76 |
2108195 | 2108195 | 2022-01-12 | Pike | Pennsylvania | 42103 | 8295 | 76 |
2104944 | 2104944 | 2022-01-11 | Pike | Pennsylvania | 42103 | 8210 | 76 |
2101693 | 2101693 | 2022-01-10 | Pike | Pennsylvania | 42103 | 8100 | 76 |
2098442 | 2098442 | 2022-01-09 | Pike | Pennsylvania | 42103 | 7993 | 76 |
2095190 | 2095190 | 2022-01-08 | Pike | Pennsylvania | 42103 | 7901 | 76 |
2091938 | 2091938 | 2022-01-07 | Pike | Pennsylvania | 42103 | 7714 | 75 |
2088686 | 2088686 | 2022-01-06 | Pike | Pennsylvania | 42103 | 7575 | 75 |
2085435 | 2085435 | 2022-01-05 | Pike | Pennsylvania | 42103 | 7498 | 75 |
2082183 | 2082183 | 2022-01-04 | Pike | Pennsylvania | 42103 | 7380 | 74 |
2078931 | 2078931 | 2022-01-03 | Pike | Pennsylvania | 42103 | 7330 | 74 |
2075680 | 2075680 | 2022-01-02 | Pike | Pennsylvania | 42103 | 7287 | 73 |
2072429 | 2072429 | 2022-01-01 | Pike | Pennsylvania | 42103 | 7211 | 73 |
2069178 | 2069178 | 2021-12-31 | Pike | Pennsylvania | 42103 | 7168 | 73 |
2065927 | 2065927 | 2021-12-30 | Pike | Pennsylvania | 42103 | 7101 | 73 |
2062677 | 2062677 | 2021-12-29 | Pike | Pennsylvania | 42103 | 7046 | 73 |
2059427 | 2059427 | 2021-12-28 | Pike | Pennsylvania | 42103 | 7012 | 71 |
2056178 | 2056178 | 2021-12-27 | Pike | Pennsylvania | 42103 | 6970 | 71 |
2052929 | 2052929 | 2021-12-26 | Pike | Pennsylvania | 42103 | 6940 | 71 |
2049679 | 2049679 | 2021-12-25 | Pike | Pennsylvania | 42103 | 6917 | 71 |
2046429 | 2046429 | 2021-12-24 | Pike | Pennsylvania | 42103 | 6861 | 71 |
2043179 | 2043179 | 2021-12-23 | Pike | Pennsylvania | 42103 | 6820 | 71 |
2039930 | 2039930 | 2021-12-22 | Pike | Pennsylvania | 42103 | 6784 | 71 |
2036680 | 2036680 | 2021-12-21 | Pike | Pennsylvania | 42103 | 6754 | 71 |
2033430 | 2033430 | 2021-12-20 | Pike | Pennsylvania | 42103 | 6716 | 71 |
2030180 | 2030180 | 2021-12-19 | Pike | Pennsylvania | 42103 | 6690 | 71 |
2026929 | 2026929 | 2021-12-18 | Pike | Pennsylvania | 42103 | 6663 | 71 |
2023678 | 2023678 | 2021-12-17 | Pike | Pennsylvania | 42103 | 6623 | 71 |
2020427 | 2020427 | 2021-12-16 | Pike | Pennsylvania | 42103 | 6583 | 71 |
2017176 | 2017176 | 2021-12-15 | Pike | Pennsylvania | 42103 | 6541 | 71 |
2013926 | 2013926 | 2021-12-14 | Pike | Pennsylvania | 42103 | 6519 | 71 |
2010675 | 2010675 | 2021-12-13 | Pike | Pennsylvania | 42103 | 6455 | 70 |
2007424 | 2007424 | 2021-12-12 | Pike | Pennsylvania | 42103 | 6437 | 70 |
2004173 | 2004173 | 2021-12-11 | Pike | Pennsylvania | 42103 | 6403 | 70 |
2000922 | 2000922 | 2021-12-10 | Pike | Pennsylvania | 42103 | 6351 | 70 |
1997672 | 1997672 | 2021-12-09 | Pike | Pennsylvania | 42103 | 6304 | 70 |
1994421 | 1994421 | 2021-12-08 | Pike | Pennsylvania | 42103 | 6274 | 70 |
1991170 | 1991170 | 2021-12-07 | Pike | Pennsylvania | 42103 | 6234 | 70 |
1987919 | 1987919 | 2021-12-06 | Pike | Pennsylvania | 42103 | 6200 | 70 |
1984669 | 1984669 | 2021-12-05 | Pike | Pennsylvania | 42103 | 6188 | 70 |
1981419 | 1981419 | 2021-12-04 | Pike | Pennsylvania | 42103 | 6177 | 70 |
1978169 | 1978169 | 2021-12-03 | Pike | Pennsylvania | 42103 | 6154 | 70 |
1974919 | 1974919 | 2021-12-02 | Pike | Pennsylvania | 42103 | 6122 | 70 |
1971670 | 1971670 | 2021-12-01 | Pike | Pennsylvania | 42103 | 6082 | 70 |
1968420 | 1968420 | 2021-11-30 | Pike | Pennsylvania | 42103 | 6046 | 70 |
1965169 | 1965169 | 2021-11-29 | Pike | Pennsylvania | 42103 | 6027 | 69 |
1961917 | 1961917 | 2021-11-28 | Pike | Pennsylvania | 42103 | 5991 | 69 |
1958666 | 1958666 | 2021-11-27 | Pike | Pennsylvania | 42103 | 5981 | 69 |
1955415 | 1955415 | 2021-11-26 | Pike | Pennsylvania | 42103 | 5967 | 69 |
1952164 | 1952164 | 2021-11-25 | Pike | Pennsylvania | 42103 | 5942 | 69 |
1948913 | 1948913 | 2021-11-24 | Pike | Pennsylvania | 42103 | 5901 | 69 |
1945662 | 1945662 | 2021-11-23 | Pike | Pennsylvania | 42103 | 5884 | 69 |
1942411 | 1942411 | 2021-11-22 | Pike | Pennsylvania | 42103 | 5850 | 69 |
1939161 | 1939161 | 2021-11-21 | Pike | Pennsylvania | 42103 | 5837 | 69 |
1935911 | 1935911 | 2021-11-20 | Pike | Pennsylvania | 42103 | 5819 | 69 |
1932661 | 1932661 | 2021-11-19 | Pike | Pennsylvania | 42103 | 5786 | 68 |
1929410 | 1929410 | 2021-11-18 | Pike | Pennsylvania | 42103 | 5757 | 67 |
1926160 | 1926160 | 2021-11-17 | Pike | Pennsylvania | 42103 | 5735 | 66 |
1922910 | 1922910 | 2021-11-16 | Pike | Pennsylvania | 42103 | 5716 | 65 |
1919661 | 1919661 | 2021-11-15 | Pike | Pennsylvania | 42103 | 5693 | 64 |
1916411 | 1916411 | 2021-11-14 | Pike | Pennsylvania | 42103 | 5680 | 64 |
1913161 | 1913161 | 2021-11-13 | Pike | Pennsylvania | 42103 | 5662 | 64 |
1909911 | 1909911 | 2021-11-12 | Pike | Pennsylvania | 42103 | 5595 | 64 |
1906662 | 1906662 | 2021-11-11 | Pike | Pennsylvania | 42103 | 5579 | 64 |
1903413 | 1903413 | 2021-11-10 | Pike | Pennsylvania | 42103 | 5560 | 64 |
1900163 | 1900163 | 2021-11-09 | Pike | Pennsylvania | 42103 | 5543 | 63 |
1896913 | 1896913 | 2021-11-08 | Pike | Pennsylvania | 42103 | 5532 | 63 |
1893663 | 1893663 | 2021-11-07 | Pike | Pennsylvania | 42103 | 5524 | 63 |
1890413 | 1890413 | 2021-11-06 | Pike | Pennsylvania | 42103 | 5516 | 63 |
1887163 | 1887163 | 2021-11-05 | Pike | Pennsylvania | 42103 | 5503 | 63 |
1883913 | 1883913 | 2021-11-04 | Pike | Pennsylvania | 42103 | 5489 | 63 |
1880664 | 1880664 | 2021-11-03 | Pike | Pennsylvania | 42103 | 5472 | 63 |
1877415 | 1877415 | 2021-11-02 | Pike | Pennsylvania | 42103 | 5461 | 63 |
1874166 | 1874166 | 2021-11-01 | Pike | Pennsylvania | 42103 | 5433 | 62 |
1870917 | 1870917 | 2021-10-31 | Pike | Pennsylvania | 42103 | 5433 | 62 |
1867668 | 1867668 | 2021-10-30 | Pike | Pennsylvania | 42103 | 5426 | 62 |
1864419 | 1864419 | 2021-10-29 | Pike | Pennsylvania | 42103 | 5398 | 62 |
1861170 | 1861170 | 2021-10-28 | Pike | Pennsylvania | 42103 | 5383 | 62 |
1857921 | 1857921 | 2021-10-27 | Pike | Pennsylvania | 42103 | 5364 | 62 |
1854672 | 1854672 | 2021-10-26 | Pike | Pennsylvania | 42103 | 5354 | 61 |
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);