ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 42129 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176527 | 2176527 | 2022-02-02 | Westmoreland | Pennsylvania | 42129 | 76026 | 1260 |
2173273 | 2173273 | 2022-02-01 | Westmoreland | Pennsylvania | 42129 | 75769 | 1249 |
2170021 | 2170021 | 2022-01-31 | Westmoreland | Pennsylvania | 42129 | 75550 | 1241 |
2166767 | 2166767 | 2022-01-30 | Westmoreland | Pennsylvania | 42129 | 75350 | 1239 |
2163512 | 2163512 | 2022-01-29 | Westmoreland | Pennsylvania | 42129 | 75040 | 1238 |
2160257 | 2160257 | 2022-01-28 | Westmoreland | Pennsylvania | 42129 | 74625 | 1234 |
2157001 | 2157001 | 2022-01-27 | Westmoreland | Pennsylvania | 42129 | 73973 | 1231 |
2153748 | 2153748 | 2022-01-26 | Westmoreland | Pennsylvania | 42129 | 73423 | 1219 |
2150496 | 2150496 | 2022-01-25 | Westmoreland | Pennsylvania | 42129 | 73082 | 1215 |
2147244 | 2147244 | 2022-01-24 | Westmoreland | Pennsylvania | 42129 | 72744 | 1213 |
2143990 | 2143990 | 2022-01-23 | Westmoreland | Pennsylvania | 42129 | 72100 | 1212 |
2140735 | 2140735 | 2022-01-22 | Westmoreland | Pennsylvania | 42129 | 71837 | 1209 |
2137479 | 2137479 | 2022-01-21 | Westmoreland | Pennsylvania | 42129 | 71312 | 1207 |
2134225 | 2134225 | 2022-01-20 | Westmoreland | Pennsylvania | 42129 | 70561 | 1198 |
2130973 | 2130973 | 2022-01-19 | Westmoreland | Pennsylvania | 42129 | 70126 | 1183 |
2127719 | 2127719 | 2022-01-18 | Westmoreland | Pennsylvania | 42129 | 69706 | 1180 |
2124467 | 2124467 | 2022-01-17 | Westmoreland | Pennsylvania | 42129 | 69220 | 1178 |
2121215 | 2121215 | 2022-01-16 | Westmoreland | Pennsylvania | 42129 | 68953 | 1178 |
2117963 | 2117963 | 2022-01-15 | Westmoreland | Pennsylvania | 42129 | 67953 | 1178 |
2114712 | 2114712 | 2022-01-14 | Westmoreland | Pennsylvania | 42129 | 67141 | 1173 |
2111460 | 2111460 | 2022-01-13 | Westmoreland | Pennsylvania | 42129 | 66502 | 1172 |
2108208 | 2108208 | 2022-01-12 | Westmoreland | Pennsylvania | 42129 | 65710 | 1170 |
2104957 | 2104957 | 2022-01-11 | Westmoreland | Pennsylvania | 42129 | 64784 | 1160 |
2101706 | 2101706 | 2022-01-10 | Westmoreland | Pennsylvania | 42129 | 64381 | 1153 |
2098455 | 2098455 | 2022-01-09 | Westmoreland | Pennsylvania | 42129 | 64047 | 1152 |
2095203 | 2095203 | 2022-01-08 | Westmoreland | Pennsylvania | 42129 | 63379 | 1152 |
2091951 | 2091951 | 2022-01-07 | Westmoreland | Pennsylvania | 42129 | 62736 | 1149 |
2088699 | 2088699 | 2022-01-06 | Westmoreland | Pennsylvania | 42129 | 62037 | 1143 |
2085448 | 2085448 | 2022-01-05 | Westmoreland | Pennsylvania | 42129 | 61579 | 1134 |
2082196 | 2082196 | 2022-01-04 | Westmoreland | Pennsylvania | 42129 | 60854 | 1128 |
2078944 | 2078944 | 2022-01-03 | Westmoreland | Pennsylvania | 42129 | 60488 | 1126 |
2075693 | 2075693 | 2022-01-02 | Westmoreland | Pennsylvania | 42129 | 60200 | 1121 |
2072442 | 2072442 | 2022-01-01 | Westmoreland | Pennsylvania | 42129 | 59832 | 1121 |
2069191 | 2069191 | 2021-12-31 | Westmoreland | Pennsylvania | 42129 | 59161 | 1121 |
2065940 | 2065940 | 2021-12-30 | Westmoreland | Pennsylvania | 42129 | 58808 | 1119 |
2062690 | 2062690 | 2021-12-29 | Westmoreland | Pennsylvania | 42129 | 58377 | 1115 |
2059440 | 2059440 | 2021-12-28 | Westmoreland | Pennsylvania | 42129 | 58125 | 1101 |
2056191 | 2056191 | 2021-12-27 | Westmoreland | Pennsylvania | 42129 | 57974 | 1092 |
2052942 | 2052942 | 2021-12-26 | Westmoreland | Pennsylvania | 42129 | 57907 | 1092 |
2049692 | 2049692 | 2021-12-25 | Westmoreland | Pennsylvania | 42129 | 57796 | 1092 |
2046442 | 2046442 | 2021-12-24 | Westmoreland | Pennsylvania | 42129 | 57529 | 1092 |
2043192 | 2043192 | 2021-12-23 | Westmoreland | Pennsylvania | 42129 | 57133 | 1085 |
2039943 | 2039943 | 2021-12-22 | Westmoreland | Pennsylvania | 42129 | 56959 | 1074 |
2036693 | 2036693 | 2021-12-21 | Westmoreland | Pennsylvania | 42129 | 56836 | 1063 |
2033443 | 2033443 | 2021-12-20 | Westmoreland | Pennsylvania | 42129 | 56620 | 1059 |
2030193 | 2030193 | 2021-12-19 | Westmoreland | Pennsylvania | 42129 | 56487 | 1056 |
2026942 | 2026942 | 2021-12-18 | Westmoreland | Pennsylvania | 42129 | 56317 | 1056 |
2023691 | 2023691 | 2021-12-17 | Westmoreland | Pennsylvania | 42129 | 56137 | 1044 |
2020440 | 2020440 | 2021-12-16 | Westmoreland | Pennsylvania | 42129 | 55847 | 1043 |
2017189 | 2017189 | 2021-12-15 | Westmoreland | Pennsylvania | 42129 | 55666 | 1037 |
2013939 | 2013939 | 2021-12-14 | Westmoreland | Pennsylvania | 42129 | 55435 | 1026 |
2010688 | 2010688 | 2021-12-13 | Westmoreland | Pennsylvania | 42129 | 55104 | 1021 |
2007437 | 2007437 | 2021-12-12 | Westmoreland | Pennsylvania | 42129 | 54988 | 1021 |
2004186 | 2004186 | 2021-12-11 | Westmoreland | Pennsylvania | 42129 | 54697 | 1021 |
2000935 | 2000935 | 2021-12-10 | Westmoreland | Pennsylvania | 42129 | 54315 | 1016 |
1997685 | 1997685 | 2021-12-09 | Westmoreland | Pennsylvania | 42129 | 54081 | 1011 |
1994434 | 1994434 | 2021-12-08 | Westmoreland | Pennsylvania | 42129 | 53845 | 1010 |
1991183 | 1991183 | 2021-12-07 | Westmoreland | Pennsylvania | 42129 | 53573 | 1007 |
1987932 | 1987932 | 2021-12-06 | Westmoreland | Pennsylvania | 42129 | 53182 | 1001 |
1984682 | 1984682 | 2021-12-05 | Westmoreland | Pennsylvania | 42129 | 53070 | 999 |
1981432 | 1981432 | 2021-12-04 | Westmoreland | Pennsylvania | 42129 | 52934 | 999 |
1978182 | 1978182 | 2021-12-03 | Westmoreland | Pennsylvania | 42129 | 52700 | 997 |
1974932 | 1974932 | 2021-12-02 | Westmoreland | Pennsylvania | 42129 | 52163 | 990 |
1971683 | 1971683 | 2021-12-01 | Westmoreland | Pennsylvania | 42129 | 51919 | 983 |
1968433 | 1968433 | 2021-11-30 | Westmoreland | Pennsylvania | 42129 | 51706 | 980 |
1965182 | 1965182 | 2021-11-29 | Westmoreland | Pennsylvania | 42129 | 51514 | 975 |
1961930 | 1961930 | 2021-11-28 | Westmoreland | Pennsylvania | 42129 | 51210 | 975 |
1958679 | 1958679 | 2021-11-27 | Westmoreland | Pennsylvania | 42129 | 51096 | 973 |
1955428 | 1955428 | 2021-11-26 | Westmoreland | Pennsylvania | 42129 | 50965 | 973 |
1952177 | 1952177 | 2021-11-25 | Westmoreland | Pennsylvania | 42129 | 50686 | 973 |
1948926 | 1948926 | 2021-11-24 | Westmoreland | Pennsylvania | 42129 | 50547 | 967 |
1945675 | 1945675 | 2021-11-23 | Westmoreland | Pennsylvania | 42129 | 50198 | 962 |
1942424 | 1942424 | 2021-11-22 | Westmoreland | Pennsylvania | 42129 | 50074 | 959 |
1939174 | 1939174 | 2021-11-21 | Westmoreland | Pennsylvania | 42129 | 49730 | 958 |
1935924 | 1935924 | 2021-11-20 | Westmoreland | Pennsylvania | 42129 | 49576 | 958 |
1932674 | 1932674 | 2021-11-19 | Westmoreland | Pennsylvania | 42129 | 49221 | 953 |
1929423 | 1929423 | 2021-11-18 | Westmoreland | Pennsylvania | 42129 | 48945 | 949 |
1926173 | 1926173 | 2021-11-17 | Westmoreland | Pennsylvania | 42129 | 48723 | 945 |
1922923 | 1922923 | 2021-11-16 | Westmoreland | Pennsylvania | 42129 | 48539 | 941 |
1919674 | 1919674 | 2021-11-15 | Westmoreland | Pennsylvania | 42129 | 48270 | 939 |
1916424 | 1916424 | 2021-11-14 | Westmoreland | Pennsylvania | 42129 | 48132 | 939 |
1913174 | 1913174 | 2021-11-13 | Westmoreland | Pennsylvania | 42129 | 47984 | 938 |
1909924 | 1909924 | 2021-11-12 | Westmoreland | Pennsylvania | 42129 | 47051 | 935 |
1906675 | 1906675 | 2021-11-11 | Westmoreland | Pennsylvania | 42129 | 46833 | 935 |
1903426 | 1903426 | 2021-11-10 | Westmoreland | Pennsylvania | 42129 | 46719 | 933 |
1900176 | 1900176 | 2021-11-09 | Westmoreland | Pennsylvania | 42129 | 46495 | 925 |
1896926 | 1896926 | 2021-11-08 | Westmoreland | Pennsylvania | 42129 | 46405 | 923 |
1893676 | 1893676 | 2021-11-07 | Westmoreland | Pennsylvania | 42129 | 46245 | 923 |
1890426 | 1890426 | 2021-11-06 | Westmoreland | Pennsylvania | 42129 | 46127 | 923 |
1887176 | 1887176 | 2021-11-05 | Westmoreland | Pennsylvania | 42129 | 45983 | 919 |
1883926 | 1883926 | 2021-11-04 | Westmoreland | Pennsylvania | 42129 | 45819 | 913 |
1880677 | 1880677 | 2021-11-03 | Westmoreland | Pennsylvania | 42129 | 45668 | 910 |
1877428 | 1877428 | 2021-11-02 | Westmoreland | Pennsylvania | 42129 | 45487 | 905 |
1874179 | 1874179 | 2021-11-01 | Westmoreland | Pennsylvania | 42129 | 45286 | 903 |
1870930 | 1870930 | 2021-10-31 | Westmoreland | Pennsylvania | 42129 | 45286 | 903 |
1867681 | 1867681 | 2021-10-30 | Westmoreland | Pennsylvania | 42129 | 45178 | 902 |
1864432 | 1864432 | 2021-10-29 | Westmoreland | Pennsylvania | 42129 | 45052 | 900 |
1861183 | 1861183 | 2021-10-28 | Westmoreland | Pennsylvania | 42129 | 44881 | 899 |
1857934 | 1857934 | 2021-10-27 | Westmoreland | Pennsylvania | 42129 | 44789 | 896 |
1854685 | 1854685 | 2021-10-26 | Westmoreland | Pennsylvania | 42129 | 44630 | 892 |
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);