ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Greene" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176492 | 2176492 | 2022-02-02 | Greene | Pennsylvania | 42059 | 7917 | 92 |
2173238 | 2173238 | 2022-02-01 | Greene | Pennsylvania | 42059 | 7899 | 92 |
2169986 | 2169986 | 2022-01-31 | Greene | Pennsylvania | 42059 | 7867 | 92 |
2166732 | 2166732 | 2022-01-30 | Greene | Pennsylvania | 42059 | 7847 | 92 |
2163477 | 2163477 | 2022-01-29 | Greene | Pennsylvania | 42059 | 7819 | 92 |
2160222 | 2160222 | 2022-01-28 | Greene | Pennsylvania | 42059 | 7776 | 92 |
2156966 | 2156966 | 2022-01-27 | Greene | Pennsylvania | 42059 | 7706 | 92 |
2153713 | 2153713 | 2022-01-26 | Greene | Pennsylvania | 42059 | 7632 | 92 |
2150461 | 2150461 | 2022-01-25 | Greene | Pennsylvania | 42059 | 7591 | 92 |
2147209 | 2147209 | 2022-01-24 | Greene | Pennsylvania | 42059 | 7540 | 91 |
2143955 | 2143955 | 2022-01-23 | Greene | Pennsylvania | 42059 | 7505 | 91 |
2140700 | 2140700 | 2022-01-22 | Greene | Pennsylvania | 42059 | 7477 | 91 |
2137444 | 2137444 | 2022-01-21 | Greene | Pennsylvania | 42059 | 7383 | 91 |
2134190 | 2134190 | 2022-01-20 | Greene | Pennsylvania | 42059 | 7300 | 90 |
2130938 | 2130938 | 2022-01-19 | Greene | Pennsylvania | 42059 | 7254 | 85 |
2127684 | 2127684 | 2022-01-18 | Greene | Pennsylvania | 42059 | 7157 | 85 |
2124432 | 2124432 | 2022-01-17 | Greene | Pennsylvania | 42059 | 7095 | 85 |
2121180 | 2121180 | 2022-01-16 | Greene | Pennsylvania | 42059 | 7073 | 85 |
2117928 | 2117928 | 2022-01-15 | Greene | Pennsylvania | 42059 | 7026 | 85 |
2114677 | 2114677 | 2022-01-14 | Greene | Pennsylvania | 42059 | 6945 | 85 |
2111425 | 2111425 | 2022-01-13 | Greene | Pennsylvania | 42059 | 6888 | 85 |
2108173 | 2108173 | 2022-01-12 | Greene | Pennsylvania | 42059 | 6833 | 85 |
2104922 | 2104922 | 2022-01-11 | Greene | Pennsylvania | 42059 | 6787 | 85 |
2101671 | 2101671 | 2022-01-10 | Greene | Pennsylvania | 42059 | 6734 | 82 |
2098420 | 2098420 | 2022-01-09 | Greene | Pennsylvania | 42059 | 6721 | 82 |
2095168 | 2095168 | 2022-01-08 | Greene | Pennsylvania | 42059 | 6683 | 82 |
2091916 | 2091916 | 2022-01-07 | Greene | Pennsylvania | 42059 | 6611 | 82 |
2088664 | 2088664 | 2022-01-06 | Greene | Pennsylvania | 42059 | 6556 | 82 |
2085413 | 2085413 | 2022-01-05 | Greene | Pennsylvania | 42059 | 6513 | 82 |
2082161 | 2082161 | 2022-01-04 | Greene | Pennsylvania | 42059 | 6424 | 82 |
2078909 | 2078909 | 2022-01-03 | Greene | Pennsylvania | 42059 | 6406 | 80 |
2075658 | 2075658 | 2022-01-02 | Greene | Pennsylvania | 42059 | 6395 | 80 |
2072407 | 2072407 | 2022-01-01 | Greene | Pennsylvania | 42059 | 6386 | 80 |
2069156 | 2069156 | 2021-12-31 | Greene | Pennsylvania | 42059 | 6341 | 80 |
2065905 | 2065905 | 2021-12-30 | Greene | Pennsylvania | 42059 | 6327 | 79 |
2062655 | 2062655 | 2021-12-29 | Greene | Pennsylvania | 42059 | 6278 | 79 |
2059405 | 2059405 | 2021-12-28 | Greene | Pennsylvania | 42059 | 6260 | 79 |
2056156 | 2056156 | 2021-12-27 | Greene | Pennsylvania | 42059 | 6241 | 78 |
2052907 | 2052907 | 2021-12-26 | Greene | Pennsylvania | 42059 | 6238 | 78 |
2049657 | 2049657 | 2021-12-25 | Greene | Pennsylvania | 42059 | 6231 | 78 |
2046407 | 2046407 | 2021-12-24 | Greene | Pennsylvania | 42059 | 6212 | 78 |
2043157 | 2043157 | 2021-12-23 | Greene | Pennsylvania | 42059 | 6189 | 78 |
2039908 | 2039908 | 2021-12-22 | Greene | Pennsylvania | 42059 | 6182 | 78 |
2036658 | 2036658 | 2021-12-21 | Greene | Pennsylvania | 42059 | 6169 | 77 |
2033408 | 2033408 | 2021-12-20 | Greene | Pennsylvania | 42059 | 6141 | 77 |
2030158 | 2030158 | 2021-12-19 | Greene | Pennsylvania | 42059 | 6137 | 77 |
2026907 | 2026907 | 2021-12-18 | Greene | Pennsylvania | 42059 | 6132 | 77 |
2023656 | 2023656 | 2021-12-17 | Greene | Pennsylvania | 42059 | 6115 | 77 |
2020405 | 2020405 | 2021-12-16 | Greene | Pennsylvania | 42059 | 6082 | 77 |
2017154 | 2017154 | 2021-12-15 | Greene | Pennsylvania | 42059 | 6075 | 74 |
2013904 | 2013904 | 2021-12-14 | Greene | Pennsylvania | 42059 | 6028 | 73 |
2010653 | 2010653 | 2021-12-13 | Greene | Pennsylvania | 42059 | 6010 | 73 |
2007402 | 2007402 | 2021-12-12 | Greene | Pennsylvania | 42059 | 6006 | 73 |
2004151 | 2004151 | 2021-12-11 | Greene | Pennsylvania | 42059 | 5992 | 73 |
2000900 | 2000900 | 2021-12-10 | Greene | Pennsylvania | 42059 | 5968 | 72 |
1997650 | 1997650 | 2021-12-09 | Greene | Pennsylvania | 42059 | 5953 | 71 |
1994399 | 1994399 | 2021-12-08 | Greene | Pennsylvania | 42059 | 5907 | 71 |
1991148 | 1991148 | 2021-12-07 | Greene | Pennsylvania | 42059 | 5863 | 70 |
1987897 | 1987897 | 2021-12-06 | Greene | Pennsylvania | 42059 | 5817 | 69 |
1984647 | 1984647 | 2021-12-05 | Greene | Pennsylvania | 42059 | 5816 | 69 |
1981397 | 1981397 | 2021-12-04 | Greene | Pennsylvania | 42059 | 5804 | 69 |
1978147 | 1978147 | 2021-12-03 | Greene | Pennsylvania | 42059 | 5781 | 67 |
1974897 | 1974897 | 2021-12-02 | Greene | Pennsylvania | 42059 | 5725 | 66 |
1971648 | 1971648 | 2021-12-01 | Greene | Pennsylvania | 42059 | 5700 | 65 |
1968398 | 1968398 | 2021-11-30 | Greene | Pennsylvania | 42059 | 5670 | 65 |
1965147 | 1965147 | 2021-11-29 | Greene | Pennsylvania | 42059 | 5656 | 65 |
1961895 | 1961895 | 2021-11-28 | Greene | Pennsylvania | 42059 | 5613 | 65 |
1958644 | 1958644 | 2021-11-27 | Greene | Pennsylvania | 42059 | 5611 | 65 |
1955393 | 1955393 | 2021-11-26 | Greene | Pennsylvania | 42059 | 5591 | 65 |
1952142 | 1952142 | 2021-11-25 | Greene | Pennsylvania | 42059 | 5577 | 65 |
1948891 | 1948891 | 2021-11-24 | Greene | Pennsylvania | 42059 | 5550 | 65 |
1945640 | 1945640 | 2021-11-23 | Greene | Pennsylvania | 42059 | 5515 | 65 |
1942389 | 1942389 | 2021-11-22 | Greene | Pennsylvania | 42059 | 5479 | 65 |
1939139 | 1939139 | 2021-11-21 | Greene | Pennsylvania | 42059 | 5461 | 65 |
1935889 | 1935889 | 2021-11-20 | Greene | Pennsylvania | 42059 | 5456 | 65 |
1932639 | 1932639 | 2021-11-19 | Greene | Pennsylvania | 42059 | 5434 | 65 |
1929388 | 1929388 | 2021-11-18 | Greene | Pennsylvania | 42059 | 5403 | 65 |
1926138 | 1926138 | 2021-11-17 | Greene | Pennsylvania | 42059 | 5376 | 61 |
1922888 | 1922888 | 2021-11-16 | Greene | Pennsylvania | 42059 | 5351 | 59 |
1919639 | 1919639 | 2021-11-15 | Greene | Pennsylvania | 42059 | 5313 | 59 |
1916389 | 1916389 | 2021-11-14 | Greene | Pennsylvania | 42059 | 5308 | 59 |
1913139 | 1913139 | 2021-11-13 | Greene | Pennsylvania | 42059 | 5302 | 59 |
1909889 | 1909889 | 2021-11-12 | Greene | Pennsylvania | 42059 | 5214 | 58 |
1906640 | 1906640 | 2021-11-11 | Greene | Pennsylvania | 42059 | 5179 | 58 |
1903391 | 1903391 | 2021-11-10 | Greene | Pennsylvania | 42059 | 5152 | 58 |
1900141 | 1900141 | 2021-11-09 | Greene | Pennsylvania | 42059 | 5133 | 58 |
1896891 | 1896891 | 2021-11-08 | Greene | Pennsylvania | 42059 | 5106 | 57 |
1893641 | 1893641 | 2021-11-07 | Greene | Pennsylvania | 42059 | 5095 | 57 |
1890391 | 1890391 | 2021-11-06 | Greene | Pennsylvania | 42059 | 5089 | 57 |
1887141 | 1887141 | 2021-11-05 | Greene | Pennsylvania | 42059 | 5075 | 57 |
1883891 | 1883891 | 2021-11-04 | Greene | Pennsylvania | 42059 | 5057 | 57 |
1880642 | 1880642 | 2021-11-03 | Greene | Pennsylvania | 42059 | 5011 | 57 |
1877393 | 1877393 | 2021-11-02 | Greene | Pennsylvania | 42059 | 4991 | 56 |
1874144 | 1874144 | 2021-11-01 | Greene | Pennsylvania | 42059 | 4952 | 56 |
1870895 | 1870895 | 2021-10-31 | Greene | Pennsylvania | 42059 | 4952 | 56 |
1867646 | 1867646 | 2021-10-30 | Greene | Pennsylvania | 42059 | 4940 | 55 |
1864397 | 1864397 | 2021-10-29 | Greene | Pennsylvania | 42059 | 4916 | 55 |
1861148 | 1861148 | 2021-10-28 | Greene | Pennsylvania | 42059 | 4877 | 55 |
1857899 | 1857899 | 2021-10-27 | Greene | Pennsylvania | 42059 | 4850 | 54 |
1854650 | 1854650 | 2021-10-26 | Greene | Pennsylvania | 42059 | 4820 | 54 |
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);