ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 42127 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176526 | 2176526 | 2022-02-02 | Wayne | Pennsylvania | 42127 | 9615 | 154 |
2173272 | 2173272 | 2022-02-01 | Wayne | Pennsylvania | 42127 | 9593 | 154 |
2170020 | 2170020 | 2022-01-31 | Wayne | Pennsylvania | 42127 | 9565 | 154 |
2166766 | 2166766 | 2022-01-30 | Wayne | Pennsylvania | 42127 | 9542 | 154 |
2163511 | 2163511 | 2022-01-29 | Wayne | Pennsylvania | 42127 | 9529 | 154 |
2160256 | 2160256 | 2022-01-28 | Wayne | Pennsylvania | 42127 | 9508 | 154 |
2157000 | 2157000 | 2022-01-27 | Wayne | Pennsylvania | 42127 | 9446 | 154 |
2153747 | 2153747 | 2022-01-26 | Wayne | Pennsylvania | 42127 | 9372 | 153 |
2150495 | 2150495 | 2022-01-25 | Wayne | Pennsylvania | 42127 | 9315 | 150 |
2147243 | 2147243 | 2022-01-24 | Wayne | Pennsylvania | 42127 | 9264 | 148 |
2143989 | 2143989 | 2022-01-23 | Wayne | Pennsylvania | 42127 | 9248 | 148 |
2140734 | 2140734 | 2022-01-22 | Wayne | Pennsylvania | 42127 | 9229 | 148 |
2137478 | 2137478 | 2022-01-21 | Wayne | Pennsylvania | 42127 | 9159 | 148 |
2134224 | 2134224 | 2022-01-20 | Wayne | Pennsylvania | 42127 | 9097 | 148 |
2130972 | 2130972 | 2022-01-19 | Wayne | Pennsylvania | 42127 | 9046 | 147 |
2127718 | 2127718 | 2022-01-18 | Wayne | Pennsylvania | 42127 | 8975 | 147 |
2124466 | 2124466 | 2022-01-17 | Wayne | Pennsylvania | 42127 | 8918 | 147 |
2121214 | 2121214 | 2022-01-16 | Wayne | Pennsylvania | 42127 | 8867 | 147 |
2117962 | 2117962 | 2022-01-15 | Wayne | Pennsylvania | 42127 | 8745 | 147 |
2114711 | 2114711 | 2022-01-14 | Wayne | Pennsylvania | 42127 | 8689 | 146 |
2111459 | 2111459 | 2022-01-13 | Wayne | Pennsylvania | 42127 | 8594 | 145 |
2108207 | 2108207 | 2022-01-12 | Wayne | Pennsylvania | 42127 | 8557 | 144 |
2104956 | 2104956 | 2022-01-11 | Wayne | Pennsylvania | 42127 | 8491 | 144 |
2101705 | 2101705 | 2022-01-10 | Wayne | Pennsylvania | 42127 | 8369 | 144 |
2098454 | 2098454 | 2022-01-09 | Wayne | Pennsylvania | 42127 | 8310 | 144 |
2095202 | 2095202 | 2022-01-08 | Wayne | Pennsylvania | 42127 | 8234 | 144 |
2091950 | 2091950 | 2022-01-07 | Wayne | Pennsylvania | 42127 | 8102 | 144 |
2088698 | 2088698 | 2022-01-06 | Wayne | Pennsylvania | 42127 | 8045 | 144 |
2085447 | 2085447 | 2022-01-05 | Wayne | Pennsylvania | 42127 | 7916 | 142 |
2082195 | 2082195 | 2022-01-04 | Wayne | Pennsylvania | 42127 | 7838 | 140 |
2078943 | 2078943 | 2022-01-03 | Wayne | Pennsylvania | 42127 | 7766 | 140 |
2075692 | 2075692 | 2022-01-02 | Wayne | Pennsylvania | 42127 | 7715 | 140 |
2072441 | 2072441 | 2022-01-01 | Wayne | Pennsylvania | 42127 | 7661 | 140 |
2069190 | 2069190 | 2021-12-31 | Wayne | Pennsylvania | 42127 | 7603 | 140 |
2065939 | 2065939 | 2021-12-30 | Wayne | Pennsylvania | 42127 | 7543 | 140 |
2062689 | 2062689 | 2021-12-29 | Wayne | Pennsylvania | 42127 | 7456 | 140 |
2059439 | 2059439 | 2021-12-28 | Wayne | Pennsylvania | 42127 | 7417 | 138 |
2056190 | 2056190 | 2021-12-27 | Wayne | Pennsylvania | 42127 | 7381 | 138 |
2052941 | 2052941 | 2021-12-26 | Wayne | Pennsylvania | 42127 | 7354 | 138 |
2049691 | 2049691 | 2021-12-25 | Wayne | Pennsylvania | 42127 | 7345 | 138 |
2046441 | 2046441 | 2021-12-24 | Wayne | Pennsylvania | 42127 | 7305 | 138 |
2043191 | 2043191 | 2021-12-23 | Wayne | Pennsylvania | 42127 | 7250 | 138 |
2039942 | 2039942 | 2021-12-22 | Wayne | Pennsylvania | 42127 | 7232 | 136 |
2036692 | 2036692 | 2021-12-21 | Wayne | Pennsylvania | 42127 | 7207 | 135 |
2033442 | 2033442 | 2021-12-20 | Wayne | Pennsylvania | 42127 | 7151 | 133 |
2030192 | 2030192 | 2021-12-19 | Wayne | Pennsylvania | 42127 | 7130 | 133 |
2026941 | 2026941 | 2021-12-18 | Wayne | Pennsylvania | 42127 | 7111 | 133 |
2023690 | 2023690 | 2021-12-17 | Wayne | Pennsylvania | 42127 | 7075 | 132 |
2020439 | 2020439 | 2021-12-16 | Wayne | Pennsylvania | 42127 | 7048 | 131 |
2017188 | 2017188 | 2021-12-15 | Wayne | Pennsylvania | 42127 | 7029 | 130 |
2013938 | 2013938 | 2021-12-14 | Wayne | Pennsylvania | 42127 | 7008 | 129 |
2010687 | 2010687 | 2021-12-13 | Wayne | Pennsylvania | 42127 | 6948 | 129 |
2007436 | 2007436 | 2021-12-12 | Wayne | Pennsylvania | 42127 | 6929 | 129 |
2004185 | 2004185 | 2021-12-11 | Wayne | Pennsylvania | 42127 | 6893 | 129 |
2000934 | 2000934 | 2021-12-10 | Wayne | Pennsylvania | 42127 | 6856 | 129 |
1997684 | 1997684 | 2021-12-09 | Wayne | Pennsylvania | 42127 | 6814 | 128 |
1994433 | 1994433 | 2021-12-08 | Wayne | Pennsylvania | 42127 | 6794 | 127 |
1991182 | 1991182 | 2021-12-07 | Wayne | Pennsylvania | 42127 | 6728 | 126 |
1987931 | 1987931 | 2021-12-06 | Wayne | Pennsylvania | 42127 | 6697 | 124 |
1984681 | 1984681 | 2021-12-05 | Wayne | Pennsylvania | 42127 | 6686 | 124 |
1981431 | 1981431 | 2021-12-04 | Wayne | Pennsylvania | 42127 | 6675 | 124 |
1978181 | 1978181 | 2021-12-03 | Wayne | Pennsylvania | 42127 | 6659 | 124 |
1974931 | 1974931 | 2021-12-02 | Wayne | Pennsylvania | 42127 | 6630 | 124 |
1971682 | 1971682 | 2021-12-01 | Wayne | Pennsylvania | 42127 | 6596 | 124 |
1968432 | 1968432 | 2021-11-30 | Wayne | Pennsylvania | 42127 | 6558 | 124 |
1965181 | 1965181 | 2021-11-29 | Wayne | Pennsylvania | 42127 | 6532 | 124 |
1961929 | 1961929 | 2021-11-28 | Wayne | Pennsylvania | 42127 | 6473 | 124 |
1958678 | 1958678 | 2021-11-27 | Wayne | Pennsylvania | 42127 | 6463 | 124 |
1955427 | 1955427 | 2021-11-26 | Wayne | Pennsylvania | 42127 | 6425 | 124 |
1952176 | 1952176 | 2021-11-25 | Wayne | Pennsylvania | 42127 | 6396 | 124 |
1948925 | 1948925 | 2021-11-24 | Wayne | Pennsylvania | 42127 | 6364 | 123 |
1945674 | 1945674 | 2021-11-23 | Wayne | Pennsylvania | 42127 | 6335 | 123 |
1942423 | 1942423 | 2021-11-22 | Wayne | Pennsylvania | 42127 | 6282 | 120 |
1939173 | 1939173 | 2021-11-21 | Wayne | Pennsylvania | 42127 | 6258 | 120 |
1935923 | 1935923 | 2021-11-20 | Wayne | Pennsylvania | 42127 | 6242 | 120 |
1932673 | 1932673 | 2021-11-19 | Wayne | Pennsylvania | 42127 | 6220 | 119 |
1929422 | 1929422 | 2021-11-18 | Wayne | Pennsylvania | 42127 | 6179 | 119 |
1926172 | 1926172 | 2021-11-17 | Wayne | Pennsylvania | 42127 | 6146 | 119 |
1922922 | 1922922 | 2021-11-16 | Wayne | Pennsylvania | 42127 | 6128 | 119 |
1919673 | 1919673 | 2021-11-15 | Wayne | Pennsylvania | 42127 | 6100 | 119 |
1916423 | 1916423 | 2021-11-14 | Wayne | Pennsylvania | 42127 | 6084 | 118 |
1913173 | 1913173 | 2021-11-13 | Wayne | Pennsylvania | 42127 | 6068 | 118 |
1909923 | 1909923 | 2021-11-12 | Wayne | Pennsylvania | 42127 | 6002 | 117 |
1906674 | 1906674 | 2021-11-11 | Wayne | Pennsylvania | 42127 | 5978 | 117 |
1903425 | 1903425 | 2021-11-10 | Wayne | Pennsylvania | 42127 | 5951 | 115 |
1900175 | 1900175 | 2021-11-09 | Wayne | Pennsylvania | 42127 | 5931 | 115 |
1896925 | 1896925 | 2021-11-08 | Wayne | Pennsylvania | 42127 | 5893 | 114 |
1893675 | 1893675 | 2021-11-07 | Wayne | Pennsylvania | 42127 | 5882 | 114 |
1890425 | 1890425 | 2021-11-06 | Wayne | Pennsylvania | 42127 | 5872 | 114 |
1887175 | 1887175 | 2021-11-05 | Wayne | Pennsylvania | 42127 | 5853 | 113 |
1883925 | 1883925 | 2021-11-04 | Wayne | Pennsylvania | 42127 | 5825 | 112 |
1880676 | 1880676 | 2021-11-03 | Wayne | Pennsylvania | 42127 | 5803 | 111 |
1877427 | 1877427 | 2021-11-02 | Wayne | Pennsylvania | 42127 | 5785 | 109 |
1874178 | 1874178 | 2021-11-01 | Wayne | Pennsylvania | 42127 | 5758 | 109 |
1870929 | 1870929 | 2021-10-31 | Wayne | Pennsylvania | 42127 | 5758 | 109 |
1867680 | 1867680 | 2021-10-30 | Wayne | Pennsylvania | 42127 | 5745 | 109 |
1864431 | 1864431 | 2021-10-29 | Wayne | Pennsylvania | 42127 | 5731 | 109 |
1861182 | 1861182 | 2021-10-28 | Wayne | Pennsylvania | 42127 | 5702 | 108 |
1857933 | 1857933 | 2021-10-27 | Wayne | Pennsylvania | 42127 | 5683 | 107 |
1854684 | 1854684 | 2021-10-26 | Wayne | Pennsylvania | 42127 | 5656 | 107 |
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);