ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 42093 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176509 | 2176509 | 2022-02-02 | Montour | Pennsylvania | 42093 | 4268 | 85 |
2173255 | 2173255 | 2022-02-01 | Montour | Pennsylvania | 42093 | 4259 | 84 |
2170003 | 2170003 | 2022-01-31 | Montour | Pennsylvania | 42093 | 4251 | 84 |
2166749 | 2166749 | 2022-01-30 | Montour | Pennsylvania | 42093 | 4232 | 84 |
2163494 | 2163494 | 2022-01-29 | Montour | Pennsylvania | 42093 | 4224 | 84 |
2160239 | 2160239 | 2022-01-28 | Montour | Pennsylvania | 42093 | 4205 | 84 |
2156983 | 2156983 | 2022-01-27 | Montour | Pennsylvania | 42093 | 4160 | 84 |
2153730 | 2153730 | 2022-01-26 | Montour | Pennsylvania | 42093 | 4131 | 83 |
2150478 | 2150478 | 2022-01-25 | Montour | Pennsylvania | 42093 | 4112 | 83 |
2147226 | 2147226 | 2022-01-24 | Montour | Pennsylvania | 42093 | 4072 | 83 |
2143972 | 2143972 | 2022-01-23 | Montour | Pennsylvania | 42093 | 4052 | 83 |
2140717 | 2140717 | 2022-01-22 | Montour | Pennsylvania | 42093 | 4015 | 83 |
2137461 | 2137461 | 2022-01-21 | Montour | Pennsylvania | 42093 | 3974 | 83 |
2134207 | 2134207 | 2022-01-20 | Montour | Pennsylvania | 42093 | 3936 | 83 |
2130955 | 2130955 | 2022-01-19 | Montour | Pennsylvania | 42093 | 3889 | 83 |
2127701 | 2127701 | 2022-01-18 | Montour | Pennsylvania | 42093 | 3853 | 83 |
2124449 | 2124449 | 2022-01-17 | Montour | Pennsylvania | 42093 | 3827 | 83 |
2121197 | 2121197 | 2022-01-16 | Montour | Pennsylvania | 42093 | 3810 | 83 |
2117945 | 2117945 | 2022-01-15 | Montour | Pennsylvania | 42093 | 3748 | 83 |
2114694 | 2114694 | 2022-01-14 | Montour | Pennsylvania | 42093 | 3719 | 83 |
2111442 | 2111442 | 2022-01-13 | Montour | Pennsylvania | 42093 | 3677 | 83 |
2108190 | 2108190 | 2022-01-12 | Montour | Pennsylvania | 42093 | 3624 | 82 |
2104939 | 2104939 | 2022-01-11 | Montour | Pennsylvania | 42093 | 3600 | 82 |
2101688 | 2101688 | 2022-01-10 | Montour | Pennsylvania | 42093 | 3570 | 82 |
2098437 | 2098437 | 2022-01-09 | Montour | Pennsylvania | 42093 | 3534 | 82 |
2095185 | 2095185 | 2022-01-08 | Montour | Pennsylvania | 42093 | 3502 | 82 |
2091933 | 2091933 | 2022-01-07 | Montour | Pennsylvania | 42093 | 3460 | 81 |
2088681 | 2088681 | 2022-01-06 | Montour | Pennsylvania | 42093 | 3426 | 81 |
2085430 | 2085430 | 2022-01-05 | Montour | Pennsylvania | 42093 | 3405 | 81 |
2082178 | 2082178 | 2022-01-04 | Montour | Pennsylvania | 42093 | 3365 | 81 |
2078926 | 2078926 | 2022-01-03 | Montour | Pennsylvania | 42093 | 3349 | 81 |
2075675 | 2075675 | 2022-01-02 | Montour | Pennsylvania | 42093 | 3330 | 81 |
2072424 | 2072424 | 2022-01-01 | Montour | Pennsylvania | 42093 | 3311 | 81 |
2069173 | 2069173 | 2021-12-31 | Montour | Pennsylvania | 42093 | 3280 | 81 |
2065922 | 2065922 | 2021-12-30 | Montour | Pennsylvania | 42093 | 3269 | 81 |
2062672 | 2062672 | 2021-12-29 | Montour | Pennsylvania | 42093 | 3244 | 81 |
2059422 | 2059422 | 2021-12-28 | Montour | Pennsylvania | 42093 | 3213 | 81 |
2056173 | 2056173 | 2021-12-27 | Montour | Pennsylvania | 42093 | 3198 | 81 |
2052924 | 2052924 | 2021-12-26 | Montour | Pennsylvania | 42093 | 3193 | 81 |
2049674 | 2049674 | 2021-12-25 | Montour | Pennsylvania | 42093 | 3191 | 81 |
2046424 | 2046424 | 2021-12-24 | Montour | Pennsylvania | 42093 | 3174 | 81 |
2043174 | 2043174 | 2021-12-23 | Montour | Pennsylvania | 42093 | 3161 | 81 |
2039925 | 2039925 | 2021-12-22 | Montour | Pennsylvania | 42093 | 3150 | 81 |
2036675 | 2036675 | 2021-12-21 | Montour | Pennsylvania | 42093 | 3139 | 81 |
2033425 | 2033425 | 2021-12-20 | Montour | Pennsylvania | 42093 | 3119 | 81 |
2030175 | 2030175 | 2021-12-19 | Montour | Pennsylvania | 42093 | 3113 | 81 |
2026924 | 2026924 | 2021-12-18 | Montour | Pennsylvania | 42093 | 3084 | 81 |
2023673 | 2023673 | 2021-12-17 | Montour | Pennsylvania | 42093 | 3075 | 79 |
2020422 | 2020422 | 2021-12-16 | Montour | Pennsylvania | 42093 | 3055 | 79 |
2017171 | 2017171 | 2021-12-15 | Montour | Pennsylvania | 42093 | 3035 | 79 |
2013921 | 2013921 | 2021-12-14 | Montour | Pennsylvania | 42093 | 3030 | 78 |
2010670 | 2010670 | 2021-12-13 | Montour | Pennsylvania | 42093 | 3024 | 78 |
2007419 | 2007419 | 2021-12-12 | Montour | Pennsylvania | 42093 | 3016 | 78 |
2004168 | 2004168 | 2021-12-11 | Montour | Pennsylvania | 42093 | 2998 | 76 |
2000917 | 2000917 | 2021-12-10 | Montour | Pennsylvania | 42093 | 2986 | 75 |
1997667 | 1997667 | 2021-12-09 | Montour | Pennsylvania | 42093 | 2971 | 75 |
1994416 | 1994416 | 2021-12-08 | Montour | Pennsylvania | 42093 | 2960 | 75 |
1991165 | 1991165 | 2021-12-07 | Montour | Pennsylvania | 42093 | 2953 | 75 |
1987914 | 1987914 | 2021-12-06 | Montour | Pennsylvania | 42093 | 2949 | 75 |
1984664 | 1984664 | 2021-12-05 | Montour | Pennsylvania | 42093 | 2945 | 75 |
1981414 | 1981414 | 2021-12-04 | Montour | Pennsylvania | 42093 | 2934 | 75 |
1978164 | 1978164 | 2021-12-03 | Montour | Pennsylvania | 42093 | 2917 | 75 |
1974914 | 1974914 | 2021-12-02 | Montour | Pennsylvania | 42093 | 2906 | 75 |
1971665 | 1971665 | 2021-12-01 | Montour | Pennsylvania | 42093 | 2898 | 75 |
1968415 | 1968415 | 2021-11-30 | Montour | Pennsylvania | 42093 | 2884 | 75 |
1965164 | 1965164 | 2021-11-29 | Montour | Pennsylvania | 42093 | 2869 | 75 |
1961912 | 1961912 | 2021-11-28 | Montour | Pennsylvania | 42093 | 2858 | 75 |
1958661 | 1958661 | 2021-11-27 | Montour | Pennsylvania | 42093 | 2852 | 75 |
1955410 | 1955410 | 2021-11-26 | Montour | Pennsylvania | 42093 | 2838 | 75 |
1952159 | 1952159 | 2021-11-25 | Montour | Pennsylvania | 42093 | 2825 | 75 |
1948908 | 1948908 | 2021-11-24 | Montour | Pennsylvania | 42093 | 2813 | 75 |
1945657 | 1945657 | 2021-11-23 | Montour | Pennsylvania | 42093 | 2796 | 75 |
1942406 | 1942406 | 2021-11-22 | Montour | Pennsylvania | 42093 | 2784 | 75 |
1939156 | 1939156 | 2021-11-21 | Montour | Pennsylvania | 42093 | 2774 | 75 |
1935906 | 1935906 | 2021-11-20 | Montour | Pennsylvania | 42093 | 2763 | 75 |
1932656 | 1932656 | 2021-11-19 | Montour | Pennsylvania | 42093 | 2750 | 75 |
1929405 | 1929405 | 2021-11-18 | Montour | Pennsylvania | 42093 | 2733 | 75 |
1926155 | 1926155 | 2021-11-17 | Montour | Pennsylvania | 42093 | 2724 | 74 |
1922905 | 1922905 | 2021-11-16 | Montour | Pennsylvania | 42093 | 2708 | 74 |
1919656 | 1919656 | 2021-11-15 | Montour | Pennsylvania | 42093 | 2701 | 73 |
1916406 | 1916406 | 2021-11-14 | Montour | Pennsylvania | 42093 | 2701 | 73 |
1913156 | 1913156 | 2021-11-13 | Montour | Pennsylvania | 42093 | 2685 | 73 |
1909906 | 1909906 | 2021-11-12 | Montour | Pennsylvania | 42093 | 2614 | 73 |
1906657 | 1906657 | 2021-11-11 | Montour | Pennsylvania | 42093 | 2609 | 73 |
1903408 | 1903408 | 2021-11-10 | Montour | Pennsylvania | 42093 | 2599 | 73 |
1900158 | 1900158 | 2021-11-09 | Montour | Pennsylvania | 42093 | 2591 | 73 |
1896908 | 1896908 | 2021-11-08 | Montour | Pennsylvania | 42093 | 2587 | 73 |
1893658 | 1893658 | 2021-11-07 | Montour | Pennsylvania | 42093 | 2587 | 73 |
1890408 | 1890408 | 2021-11-06 | Montour | Pennsylvania | 42093 | 2585 | 73 |
1887158 | 1887158 | 2021-11-05 | Montour | Pennsylvania | 42093 | 2566 | 73 |
1883908 | 1883908 | 2021-11-04 | Montour | Pennsylvania | 42093 | 2561 | 73 |
1880659 | 1880659 | 2021-11-03 | Montour | Pennsylvania | 42093 | 2553 | 73 |
1877410 | 1877410 | 2021-11-02 | Montour | Pennsylvania | 42093 | 2543 | 71 |
1874161 | 1874161 | 2021-11-01 | Montour | Pennsylvania | 42093 | 2538 | 71 |
1870912 | 1870912 | 2021-10-31 | Montour | Pennsylvania | 42093 | 2538 | 71 |
1867663 | 1867663 | 2021-10-30 | Montour | Pennsylvania | 42093 | 2532 | 71 |
1864414 | 1864414 | 2021-10-29 | Montour | Pennsylvania | 42093 | 2526 | 71 |
1861165 | 1861165 | 2021-10-28 | Montour | Pennsylvania | 42093 | 2518 | 71 |
1857916 | 1857916 | 2021-10-27 | Montour | Pennsylvania | 42093 | 2509 | 71 |
1854667 | 1854667 | 2021-10-26 | Montour | Pennsylvania | 42093 | 2502 | 71 |
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);