ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Union" and fips = 42119 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176522 | 2176522 | 2022-02-02 | Union | Pennsylvania | 42119 | 11090 | 139 |
2173268 | 2173268 | 2022-02-01 | Union | Pennsylvania | 42119 | 11062 | 139 |
2170016 | 2170016 | 2022-01-31 | Union | Pennsylvania | 42119 | 11036 | 137 |
2166762 | 2166762 | 2022-01-30 | Union | Pennsylvania | 42119 | 11015 | 137 |
2163507 | 2163507 | 2022-01-29 | Union | Pennsylvania | 42119 | 10982 | 137 |
2160252 | 2160252 | 2022-01-28 | Union | Pennsylvania | 42119 | 10914 | 137 |
2156996 | 2156996 | 2022-01-27 | Union | Pennsylvania | 42119 | 10829 | 137 |
2153743 | 2153743 | 2022-01-26 | Union | Pennsylvania | 42119 | 10736 | 137 |
2150491 | 2150491 | 2022-01-25 | Union | Pennsylvania | 42119 | 10688 | 137 |
2147239 | 2147239 | 2022-01-24 | Union | Pennsylvania | 42119 | 10642 | 137 |
2143985 | 2143985 | 2022-01-23 | Union | Pennsylvania | 42119 | 10589 | 136 |
2140730 | 2140730 | 2022-01-22 | Union | Pennsylvania | 42119 | 10553 | 136 |
2137474 | 2137474 | 2022-01-21 | Union | Pennsylvania | 42119 | 10481 | 136 |
2134220 | 2134220 | 2022-01-20 | Union | Pennsylvania | 42119 | 10402 | 136 |
2130968 | 2130968 | 2022-01-19 | Union | Pennsylvania | 42119 | 10310 | 135 |
2127714 | 2127714 | 2022-01-18 | Union | Pennsylvania | 42119 | 10230 | 135 |
2124462 | 2124462 | 2022-01-17 | Union | Pennsylvania | 42119 | 10022 | 135 |
2121210 | 2121210 | 2022-01-16 | Union | Pennsylvania | 42119 | 9975 | 135 |
2117958 | 2117958 | 2022-01-15 | Union | Pennsylvania | 42119 | 9844 | 135 |
2114707 | 2114707 | 2022-01-14 | Union | Pennsylvania | 42119 | 9752 | 135 |
2111455 | 2111455 | 2022-01-13 | Union | Pennsylvania | 42119 | 9658 | 135 |
2108203 | 2108203 | 2022-01-12 | Union | Pennsylvania | 42119 | 9599 | 135 |
2104952 | 2104952 | 2022-01-11 | Union | Pennsylvania | 42119 | 9545 | 135 |
2101701 | 2101701 | 2022-01-10 | Union | Pennsylvania | 42119 | 9499 | 135 |
2098450 | 2098450 | 2022-01-09 | Union | Pennsylvania | 42119 | 9412 | 135 |
2095198 | 2095198 | 2022-01-08 | Union | Pennsylvania | 42119 | 9363 | 135 |
2091946 | 2091946 | 2022-01-07 | Union | Pennsylvania | 42119 | 9293 | 135 |
2088694 | 2088694 | 2022-01-06 | Union | Pennsylvania | 42119 | 9211 | 135 |
2085443 | 2085443 | 2022-01-05 | Union | Pennsylvania | 42119 | 9166 | 134 |
2082191 | 2082191 | 2022-01-04 | Union | Pennsylvania | 42119 | 9113 | 134 |
2078939 | 2078939 | 2022-01-03 | Union | Pennsylvania | 42119 | 9085 | 133 |
2075688 | 2075688 | 2022-01-02 | Union | Pennsylvania | 42119 | 9048 | 133 |
2072437 | 2072437 | 2022-01-01 | Union | Pennsylvania | 42119 | 9011 | 133 |
2069186 | 2069186 | 2021-12-31 | Union | Pennsylvania | 42119 | 8991 | 133 |
2065935 | 2065935 | 2021-12-30 | Union | Pennsylvania | 42119 | 8948 | 133 |
2062685 | 2062685 | 2021-12-29 | Union | Pennsylvania | 42119 | 8922 | 133 |
2059435 | 2059435 | 2021-12-28 | Union | Pennsylvania | 42119 | 8885 | 129 |
2056186 | 2056186 | 2021-12-27 | Union | Pennsylvania | 42119 | 8855 | 129 |
2052937 | 2052937 | 2021-12-26 | Union | Pennsylvania | 42119 | 8851 | 129 |
2049687 | 2049687 | 2021-12-25 | Union | Pennsylvania | 42119 | 8827 | 129 |
2046437 | 2046437 | 2021-12-24 | Union | Pennsylvania | 42119 | 8816 | 129 |
2043187 | 2043187 | 2021-12-23 | Union | Pennsylvania | 42119 | 8782 | 128 |
2039938 | 2039938 | 2021-12-22 | Union | Pennsylvania | 42119 | 8736 | 127 |
2036688 | 2036688 | 2021-12-21 | Union | Pennsylvania | 42119 | 8711 | 127 |
2033438 | 2033438 | 2021-12-20 | Union | Pennsylvania | 42119 | 8677 | 126 |
2030188 | 2030188 | 2021-12-19 | Union | Pennsylvania | 42119 | 8666 | 126 |
2026937 | 2026937 | 2021-12-18 | Union | Pennsylvania | 42119 | 8645 | 126 |
2023686 | 2023686 | 2021-12-17 | Union | Pennsylvania | 42119 | 8623 | 126 |
2020435 | 2020435 | 2021-12-16 | Union | Pennsylvania | 42119 | 8606 | 126 |
2017184 | 2017184 | 2021-12-15 | Union | Pennsylvania | 42119 | 8575 | 126 |
2013934 | 2013934 | 2021-12-14 | Union | Pennsylvania | 42119 | 8560 | 123 |
2010683 | 2010683 | 2021-12-13 | Union | Pennsylvania | 42119 | 8519 | 122 |
2007432 | 2007432 | 2021-12-12 | Union | Pennsylvania | 42119 | 8501 | 122 |
2004181 | 2004181 | 2021-12-11 | Union | Pennsylvania | 42119 | 8467 | 122 |
2000930 | 2000930 | 2021-12-10 | Union | Pennsylvania | 42119 | 8439 | 119 |
1997680 | 1997680 | 2021-12-09 | Union | Pennsylvania | 42119 | 8395 | 117 |
1994429 | 1994429 | 2021-12-08 | Union | Pennsylvania | 42119 | 8358 | 117 |
1991178 | 1991178 | 2021-12-07 | Union | Pennsylvania | 42119 | 8320 | 117 |
1987927 | 1987927 | 2021-12-06 | Union | Pennsylvania | 42119 | 8295 | 116 |
1984677 | 1984677 | 2021-12-05 | Union | Pennsylvania | 42119 | 8287 | 116 |
1981427 | 1981427 | 2021-12-04 | Union | Pennsylvania | 42119 | 8264 | 116 |
1978177 | 1978177 | 2021-12-03 | Union | Pennsylvania | 42119 | 8228 | 114 |
1974927 | 1974927 | 2021-12-02 | Union | Pennsylvania | 42119 | 8194 | 112 |
1971678 | 1971678 | 2021-12-01 | Union | Pennsylvania | 42119 | 8155 | 112 |
1968428 | 1968428 | 2021-11-30 | Union | Pennsylvania | 42119 | 8139 | 112 |
1965177 | 1965177 | 2021-11-29 | Union | Pennsylvania | 42119 | 8121 | 112 |
1961925 | 1961925 | 2021-11-28 | Union | Pennsylvania | 42119 | 8110 | 112 |
1958674 | 1958674 | 2021-11-27 | Union | Pennsylvania | 42119 | 8105 | 112 |
1955423 | 1955423 | 2021-11-26 | Union | Pennsylvania | 42119 | 8080 | 112 |
1952172 | 1952172 | 2021-11-25 | Union | Pennsylvania | 42119 | 8036 | 112 |
1948921 | 1948921 | 2021-11-24 | Union | Pennsylvania | 42119 | 8020 | 109 |
1945670 | 1945670 | 2021-11-23 | Union | Pennsylvania | 42119 | 7989 | 109 |
1942419 | 1942419 | 2021-11-22 | Union | Pennsylvania | 42119 | 7969 | 109 |
1939169 | 1939169 | 2021-11-21 | Union | Pennsylvania | 42119 | 7949 | 108 |
1935919 | 1935919 | 2021-11-20 | Union | Pennsylvania | 42119 | 7933 | 108 |
1932669 | 1932669 | 2021-11-19 | Union | Pennsylvania | 42119 | 7913 | 108 |
1929418 | 1929418 | 2021-11-18 | Union | Pennsylvania | 42119 | 7894 | 107 |
1926168 | 1926168 | 2021-11-17 | Union | Pennsylvania | 42119 | 7882 | 107 |
1922918 | 1922918 | 2021-11-16 | Union | Pennsylvania | 42119 | 7861 | 107 |
1919669 | 1919669 | 2021-11-15 | Union | Pennsylvania | 42119 | 7850 | 106 |
1916419 | 1916419 | 2021-11-14 | Union | Pennsylvania | 42119 | 7837 | 106 |
1913169 | 1913169 | 2021-11-13 | Union | Pennsylvania | 42119 | 7814 | 106 |
1909919 | 1909919 | 2021-11-12 | Union | Pennsylvania | 42119 | 7710 | 106 |
1906670 | 1906670 | 2021-11-11 | Union | Pennsylvania | 42119 | 7700 | 106 |
1903421 | 1903421 | 2021-11-10 | Union | Pennsylvania | 42119 | 7686 | 105 |
1900171 | 1900171 | 2021-11-09 | Union | Pennsylvania | 42119 | 7674 | 104 |
1896921 | 1896921 | 2021-11-08 | Union | Pennsylvania | 42119 | 7651 | 104 |
1893671 | 1893671 | 2021-11-07 | Union | Pennsylvania | 42119 | 7636 | 104 |
1890421 | 1890421 | 2021-11-06 | Union | Pennsylvania | 42119 | 7625 | 104 |
1887171 | 1887171 | 2021-11-05 | Union | Pennsylvania | 42119 | 7612 | 104 |
1883921 | 1883921 | 2021-11-04 | Union | Pennsylvania | 42119 | 7584 | 104 |
1880672 | 1880672 | 2021-11-03 | Union | Pennsylvania | 42119 | 7569 | 104 |
1877423 | 1877423 | 2021-11-02 | Union | Pennsylvania | 42119 | 7552 | 102 |
1874174 | 1874174 | 2021-11-01 | Union | Pennsylvania | 42119 | 7518 | 102 |
1870925 | 1870925 | 2021-10-31 | Union | Pennsylvania | 42119 | 7518 | 102 |
1867676 | 1867676 | 2021-10-30 | Union | Pennsylvania | 42119 | 7514 | 102 |
1864427 | 1864427 | 2021-10-29 | Union | Pennsylvania | 42119 | 7469 | 102 |
1861178 | 1861178 | 2021-10-28 | Union | Pennsylvania | 42119 | 7457 | 101 |
1857929 | 1857929 | 2021-10-27 | Union | Pennsylvania | 42119 | 7429 | 99 |
1854680 | 1854680 | 2021-10-26 | Union | Pennsylvania | 42119 | 7400 | 99 |
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);