ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 42091 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176508 | 2176508 | 2022-02-02 | Montgomery | Pennsylvania | 42091 | 145568 | 2170 |
2173254 | 2173254 | 2022-02-01 | Montgomery | Pennsylvania | 42091 | 145247 | 2164 |
2170002 | 2170002 | 2022-01-31 | Montgomery | Pennsylvania | 42091 | 145001 | 2150 |
2166748 | 2166748 | 2022-01-30 | Montgomery | Pennsylvania | 42091 | 144767 | 2149 |
2163493 | 2163493 | 2022-01-29 | Montgomery | Pennsylvania | 42091 | 144458 | 2148 |
2160238 | 2160238 | 2022-01-28 | Montgomery | Pennsylvania | 42091 | 143989 | 2143 |
2156982 | 2156982 | 2022-01-27 | Montgomery | Pennsylvania | 42091 | 143308 | 2136 |
2153729 | 2153729 | 2022-01-26 | Montgomery | Pennsylvania | 42091 | 142373 | 2122 |
2150477 | 2150477 | 2022-01-25 | Montgomery | Pennsylvania | 42091 | 141785 | 2113 |
2147225 | 2147225 | 2022-01-24 | Montgomery | Pennsylvania | 42091 | 141158 | 2107 |
2143971 | 2143971 | 2022-01-23 | Montgomery | Pennsylvania | 42091 | 140802 | 2107 |
2140716 | 2140716 | 2022-01-22 | Montgomery | Pennsylvania | 42091 | 140065 | 2106 |
2137460 | 2137460 | 2022-01-21 | Montgomery | Pennsylvania | 42091 | 139224 | 2101 |
2134206 | 2134206 | 2022-01-20 | Montgomery | Pennsylvania | 42091 | 138469 | 2088 |
2130954 | 2130954 | 2022-01-19 | Montgomery | Pennsylvania | 42091 | 137628 | 2070 |
2127700 | 2127700 | 2022-01-18 | Montgomery | Pennsylvania | 42091 | 136689 | 2067 |
2124448 | 2124448 | 2022-01-17 | Montgomery | Pennsylvania | 42091 | 135713 | 2066 |
2121196 | 2121196 | 2022-01-16 | Montgomery | Pennsylvania | 42091 | 134794 | 2066 |
2117944 | 2117944 | 2022-01-15 | Montgomery | Pennsylvania | 42091 | 132830 | 2066 |
2114693 | 2114693 | 2022-01-14 | Montgomery | Pennsylvania | 42091 | 131609 | 2056 |
2111441 | 2111441 | 2022-01-13 | Montgomery | Pennsylvania | 42091 | 130027 | 2052 |
2108189 | 2108189 | 2022-01-12 | Montgomery | Pennsylvania | 42091 | 128804 | 2046 |
2104938 | 2104938 | 2022-01-11 | Montgomery | Pennsylvania | 42091 | 127060 | 2037 |
2101687 | 2101687 | 2022-01-10 | Montgomery | Pennsylvania | 42091 | 125898 | 2029 |
2098436 | 2098436 | 2022-01-09 | Montgomery | Pennsylvania | 42091 | 124417 | 2028 |
2095184 | 2095184 | 2022-01-08 | Montgomery | Pennsylvania | 42091 | 122773 | 2027 |
2091932 | 2091932 | 2022-01-07 | Montgomery | Pennsylvania | 42091 | 121302 | 2023 |
2088680 | 2088680 | 2022-01-06 | Montgomery | Pennsylvania | 42091 | 119662 | 2016 |
2085429 | 2085429 | 2022-01-05 | Montgomery | Pennsylvania | 42091 | 118199 | 2006 |
2082177 | 2082177 | 2022-01-04 | Montgomery | Pennsylvania | 42091 | 116669 | 2003 |
2078925 | 2078925 | 2022-01-03 | Montgomery | Pennsylvania | 42091 | 115440 | 1999 |
2075674 | 2075674 | 2022-01-02 | Montgomery | Pennsylvania | 42091 | 113906 | 1996 |
2072423 | 2072423 | 2022-01-01 | Montgomery | Pennsylvania | 42091 | 112007 | 1996 |
2069172 | 2069172 | 2021-12-31 | Montgomery | Pennsylvania | 42091 | 110575 | 1996 |
2065921 | 2065921 | 2021-12-30 | Montgomery | Pennsylvania | 42091 | 108900 | 1993 |
2062671 | 2062671 | 2021-12-29 | Montgomery | Pennsylvania | 42091 | 107409 | 1991 |
2059421 | 2059421 | 2021-12-28 | Montgomery | Pennsylvania | 42091 | 106352 | 1979 |
2056172 | 2056172 | 2021-12-27 | Montgomery | Pennsylvania | 42091 | 105104 | 1975 |
2052923 | 2052923 | 2021-12-26 | Montgomery | Pennsylvania | 42091 | 104720 | 1971 |
2049673 | 2049673 | 2021-12-25 | Montgomery | Pennsylvania | 42091 | 104007 | 1971 |
2046423 | 2046423 | 2021-12-24 | Montgomery | Pennsylvania | 42091 | 103271 | 1971 |
2043173 | 2043173 | 2021-12-23 | Montgomery | Pennsylvania | 42091 | 102516 | 1969 |
2039924 | 2039924 | 2021-12-22 | Montgomery | Pennsylvania | 42091 | 101842 | 1964 |
2036674 | 2036674 | 2021-12-21 | Montgomery | Pennsylvania | 42091 | 101346 | 1962 |
2033424 | 2033424 | 2021-12-20 | Montgomery | Pennsylvania | 42091 | 100920 | 1957 |
2030174 | 2030174 | 2021-12-19 | Montgomery | Pennsylvania | 42091 | 100565 | 1957 |
2026923 | 2026923 | 2021-12-18 | Montgomery | Pennsylvania | 42091 | 100093 | 1957 |
2023672 | 2023672 | 2021-12-17 | Montgomery | Pennsylvania | 42091 | 99609 | 1953 |
2020421 | 2020421 | 2021-12-16 | Montgomery | Pennsylvania | 42091 | 99151 | 1950 |
2017170 | 2017170 | 2021-12-15 | Montgomery | Pennsylvania | 42091 | 98650 | 1946 |
2013920 | 2013920 | 2021-12-14 | Montgomery | Pennsylvania | 42091 | 98316 | 1938 |
2010669 | 2010669 | 2021-12-13 | Montgomery | Pennsylvania | 42091 | 97996 | 1937 |
2007418 | 2007418 | 2021-12-12 | Montgomery | Pennsylvania | 42091 | 97641 | 1937 |
2004167 | 2004167 | 2021-12-11 | Montgomery | Pennsylvania | 42091 | 97164 | 1937 |
2000916 | 2000916 | 2021-12-10 | Montgomery | Pennsylvania | 42091 | 96653 | 1934 |
1997666 | 1997666 | 2021-12-09 | Montgomery | Pennsylvania | 42091 | 95838 | 1930 |
1994415 | 1994415 | 2021-12-08 | Montgomery | Pennsylvania | 42091 | 95511 | 1927 |
1991164 | 1991164 | 2021-12-07 | Montgomery | Pennsylvania | 42091 | 94973 | 1923 |
1987913 | 1987913 | 2021-12-06 | Montgomery | Pennsylvania | 42091 | 94677 | 1920 |
1984663 | 1984663 | 2021-12-05 | Montgomery | Pennsylvania | 42091 | 94510 | 1919 |
1981413 | 1981413 | 2021-12-04 | Montgomery | Pennsylvania | 42091 | 94227 | 1916 |
1978163 | 1978163 | 2021-12-03 | Montgomery | Pennsylvania | 42091 | 93799 | 1914 |
1974913 | 1974913 | 2021-12-02 | Montgomery | Pennsylvania | 42091 | 93446 | 1911 |
1971664 | 1971664 | 2021-12-01 | Montgomery | Pennsylvania | 42091 | 92939 | 1909 |
1968414 | 1968414 | 2021-11-30 | Montgomery | Pennsylvania | 42091 | 92586 | 1905 |
1965163 | 1965163 | 2021-11-29 | Montgomery | Pennsylvania | 42091 | 92358 | 1904 |
1961911 | 1961911 | 2021-11-28 | Montgomery | Pennsylvania | 42091 | 92082 | 1903 |
1958660 | 1958660 | 2021-11-27 | Montgomery | Pennsylvania | 42091 | 91936 | 1903 |
1955409 | 1955409 | 2021-11-26 | Montgomery | Pennsylvania | 42091 | 91691 | 1903 |
1952158 | 1952158 | 2021-11-25 | Montgomery | Pennsylvania | 42091 | 91453 | 1903 |
1948907 | 1948907 | 2021-11-24 | Montgomery | Pennsylvania | 42091 | 91175 | 1895 |
1945656 | 1945656 | 2021-11-23 | Montgomery | Pennsylvania | 42091 | 90959 | 1891 |
1942405 | 1942405 | 2021-11-22 | Montgomery | Pennsylvania | 42091 | 90742 | 1890 |
1939155 | 1939155 | 2021-11-21 | Montgomery | Pennsylvania | 42091 | 90520 | 1890 |
1935905 | 1935905 | 2021-11-20 | Montgomery | Pennsylvania | 42091 | 90260 | 1890 |
1932655 | 1932655 | 2021-11-19 | Montgomery | Pennsylvania | 42091 | 90075 | 1886 |
1929404 | 1929404 | 2021-11-18 | Montgomery | Pennsylvania | 42091 | 89848 | 1884 |
1926154 | 1926154 | 2021-11-17 | Montgomery | Pennsylvania | 42091 | 89560 | 1881 |
1922904 | 1922904 | 2021-11-16 | Montgomery | Pennsylvania | 42091 | 89346 | 1880 |
1919655 | 1919655 | 2021-11-15 | Montgomery | Pennsylvania | 42091 | 89124 | 1879 |
1916405 | 1916405 | 2021-11-14 | Montgomery | Pennsylvania | 42091 | 88947 | 1878 |
1913155 | 1913155 | 2021-11-13 | Montgomery | Pennsylvania | 42091 | 88743 | 1876 |
1909905 | 1909905 | 2021-11-12 | Montgomery | Pennsylvania | 42091 | 87962 | 1874 |
1906656 | 1906656 | 2021-11-11 | Montgomery | Pennsylvania | 42091 | 87770 | 1872 |
1903407 | 1903407 | 2021-11-10 | Montgomery | Pennsylvania | 42091 | 87524 | 1871 |
1900157 | 1900157 | 2021-11-09 | Montgomery | Pennsylvania | 42091 | 87342 | 1867 |
1896907 | 1896907 | 2021-11-08 | Montgomery | Pennsylvania | 42091 | 87155 | 1864 |
1893657 | 1893657 | 2021-11-07 | Montgomery | Pennsylvania | 42091 | 87019 | 1864 |
1890407 | 1890407 | 2021-11-06 | Montgomery | Pennsylvania | 42091 | 86853 | 1864 |
1887157 | 1887157 | 2021-11-05 | Montgomery | Pennsylvania | 42091 | 86694 | 1864 |
1883907 | 1883907 | 2021-11-04 | Montgomery | Pennsylvania | 42091 | 86545 | 1861 |
1880658 | 1880658 | 2021-11-03 | Montgomery | Pennsylvania | 42091 | 86297 | 1857 |
1877409 | 1877409 | 2021-11-02 | Montgomery | Pennsylvania | 42091 | 86180 | 1854 |
1874160 | 1874160 | 2021-11-01 | Montgomery | Pennsylvania | 42091 | 85922 | 1851 |
1870911 | 1870911 | 2021-10-31 | Montgomery | Pennsylvania | 42091 | 85922 | 1851 |
1867662 | 1867662 | 2021-10-30 | Montgomery | Pennsylvania | 42091 | 85832 | 1851 |
1864413 | 1864413 | 2021-10-29 | Montgomery | Pennsylvania | 42091 | 85673 | 1851 |
1861164 | 1861164 | 2021-10-28 | Montgomery | Pennsylvania | 42091 | 85529 | 1847 |
1857915 | 1857915 | 2021-10-27 | Montgomery | Pennsylvania | 42091 | 85367 | 1843 |
1854666 | 1854666 | 2021-10-26 | Montgomery | Pennsylvania | 42091 | 85240 | 1843 |
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);