ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42133 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176529 | 2176529 | 2022-02-02 | York | Pennsylvania | 42133 | 114429 | 1375 |
2173275 | 2173275 | 2022-02-01 | York | Pennsylvania | 42133 | 114183 | 1374 |
2170023 | 2170023 | 2022-01-31 | York | Pennsylvania | 42133 | 113904 | 1366 |
2166769 | 2166769 | 2022-01-30 | York | Pennsylvania | 42133 | 113620 | 1366 |
2163514 | 2163514 | 2022-01-29 | York | Pennsylvania | 42133 | 113100 | 1365 |
2160259 | 2160259 | 2022-01-28 | York | Pennsylvania | 42133 | 112762 | 1358 |
2157003 | 2157003 | 2022-01-27 | York | Pennsylvania | 42133 | 112082 | 1350 |
2153750 | 2153750 | 2022-01-26 | York | Pennsylvania | 42133 | 111392 | 1337 |
2150498 | 2150498 | 2022-01-25 | York | Pennsylvania | 42133 | 110891 | 1334 |
2147246 | 2147246 | 2022-01-24 | York | Pennsylvania | 42133 | 110402 | 1327 |
2143992 | 2143992 | 2022-01-23 | York | Pennsylvania | 42133 | 109889 | 1327 |
2140737 | 2140737 | 2022-01-22 | York | Pennsylvania | 42133 | 109201 | 1323 |
2137481 | 2137481 | 2022-01-21 | York | Pennsylvania | 42133 | 108394 | 1316 |
2134227 | 2134227 | 2022-01-20 | York | Pennsylvania | 42133 | 107537 | 1302 |
2130975 | 2130975 | 2022-01-19 | York | Pennsylvania | 42133 | 106721 | 1290 |
2127721 | 2127721 | 2022-01-18 | York | Pennsylvania | 42133 | 106101 | 1287 |
2124469 | 2124469 | 2022-01-17 | York | Pennsylvania | 42133 | 105307 | 1282 |
2121217 | 2121217 | 2022-01-16 | York | Pennsylvania | 42133 | 104182 | 1282 |
2117965 | 2117965 | 2022-01-15 | York | Pennsylvania | 42133 | 102239 | 1282 |
2114714 | 2114714 | 2022-01-14 | York | Pennsylvania | 42133 | 100851 | 1273 |
2111462 | 2111462 | 2022-01-13 | York | Pennsylvania | 42133 | 99967 | 1269 |
2108210 | 2108210 | 2022-01-12 | York | Pennsylvania | 42133 | 98796 | 1267 |
2104959 | 2104959 | 2022-01-11 | York | Pennsylvania | 42133 | 97888 | 1251 |
2101708 | 2101708 | 2022-01-10 | York | Pennsylvania | 42133 | 97191 | 1246 |
2098457 | 2098457 | 2022-01-09 | York | Pennsylvania | 42133 | 95186 | 1245 |
2095205 | 2095205 | 2022-01-08 | York | Pennsylvania | 42133 | 94303 | 1244 |
2091953 | 2091953 | 2022-01-07 | York | Pennsylvania | 42133 | 92838 | 1239 |
2088701 | 2088701 | 2022-01-06 | York | Pennsylvania | 42133 | 91847 | 1230 |
2085450 | 2085450 | 2022-01-05 | York | Pennsylvania | 42133 | 91095 | 1216 |
2082198 | 2082198 | 2022-01-04 | York | Pennsylvania | 42133 | 89981 | 1208 |
2078946 | 2078946 | 2022-01-03 | York | Pennsylvania | 42133 | 89051 | 1202 |
2075695 | 2075695 | 2022-01-02 | York | Pennsylvania | 42133 | 88124 | 1196 |
2072444 | 2072444 | 2022-01-01 | York | Pennsylvania | 42133 | 86890 | 1196 |
2069193 | 2069193 | 2021-12-31 | York | Pennsylvania | 42133 | 86112 | 1195 |
2065942 | 2065942 | 2021-12-30 | York | Pennsylvania | 42133 | 84916 | 1195 |
2062692 | 2062692 | 2021-12-29 | York | Pennsylvania | 42133 | 84121 | 1188 |
2059442 | 2059442 | 2021-12-28 | York | Pennsylvania | 42133 | 83474 | 1174 |
2056193 | 2056193 | 2021-12-27 | York | Pennsylvania | 42133 | 82924 | 1171 |
2052944 | 2052944 | 2021-12-26 | York | Pennsylvania | 42133 | 82434 | 1171 |
2049694 | 2049694 | 2021-12-25 | York | Pennsylvania | 42133 | 82094 | 1171 |
2046444 | 2046444 | 2021-12-24 | York | Pennsylvania | 42133 | 81411 | 1171 |
2043194 | 2043194 | 2021-12-23 | York | Pennsylvania | 42133 | 80756 | 1165 |
2039945 | 2039945 | 2021-12-22 | York | Pennsylvania | 42133 | 79983 | 1158 |
2036695 | 2036695 | 2021-12-21 | York | Pennsylvania | 42133 | 78696 | 1152 |
2033445 | 2033445 | 2021-12-20 | York | Pennsylvania | 42133 | 78153 | 1148 |
2030195 | 2030195 | 2021-12-19 | York | Pennsylvania | 42133 | 77823 | 1144 |
2026944 | 2026944 | 2021-12-18 | York | Pennsylvania | 42133 | 77358 | 1144 |
2023693 | 2023693 | 2021-12-17 | York | Pennsylvania | 42133 | 76873 | 1136 |
2020442 | 2020442 | 2021-12-16 | York | Pennsylvania | 42133 | 76480 | 1130 |
2017191 | 2017191 | 2021-12-15 | York | Pennsylvania | 42133 | 76049 | 1125 |
2013941 | 2013941 | 2021-12-14 | York | Pennsylvania | 42133 | 75757 | 1112 |
2010690 | 2010690 | 2021-12-13 | York | Pennsylvania | 42133 | 75451 | 1109 |
2007439 | 2007439 | 2021-12-12 | York | Pennsylvania | 42133 | 75136 | 1109 |
2004188 | 2004188 | 2021-12-11 | York | Pennsylvania | 42133 | 74629 | 1106 |
2000937 | 2000937 | 2021-12-10 | York | Pennsylvania | 42133 | 74081 | 1100 |
1997687 | 1997687 | 2021-12-09 | York | Pennsylvania | 42133 | 73728 | 1097 |
1994436 | 1994436 | 2021-12-08 | York | Pennsylvania | 42133 | 73282 | 1095 |
1991185 | 1991185 | 2021-12-07 | York | Pennsylvania | 42133 | 73026 | 1092 |
1987934 | 1987934 | 2021-12-06 | York | Pennsylvania | 42133 | 72719 | 1088 |
1984684 | 1984684 | 2021-12-05 | York | Pennsylvania | 42133 | 72448 | 1086 |
1981434 | 1981434 | 2021-12-04 | York | Pennsylvania | 42133 | 72146 | 1083 |
1978184 | 1978184 | 2021-12-03 | York | Pennsylvania | 42133 | 71617 | 1079 |
1974934 | 1974934 | 2021-12-02 | York | Pennsylvania | 42133 | 71342 | 1075 |
1971685 | 1971685 | 2021-12-01 | York | Pennsylvania | 42133 | 70896 | 1072 |
1968435 | 1968435 | 2021-11-30 | York | Pennsylvania | 42133 | 70599 | 1070 |
1965184 | 1965184 | 2021-11-29 | York | Pennsylvania | 42133 | 70372 | 1066 |
1961932 | 1961932 | 2021-11-28 | York | Pennsylvania | 42133 | 70099 | 1065 |
1958681 | 1958681 | 2021-11-27 | York | Pennsylvania | 42133 | 69910 | 1064 |
1955430 | 1955430 | 2021-11-26 | York | Pennsylvania | 42133 | 69678 | 1064 |
1952179 | 1952179 | 2021-11-25 | York | Pennsylvania | 42133 | 69383 | 1064 |
1948928 | 1948928 | 2021-11-24 | York | Pennsylvania | 42133 | 69066 | 1058 |
1945677 | 1945677 | 2021-11-23 | York | Pennsylvania | 42133 | 68764 | 1054 |
1942426 | 1942426 | 2021-11-22 | York | Pennsylvania | 42133 | 68544 | 1053 |
1939176 | 1939176 | 2021-11-21 | York | Pennsylvania | 42133 | 68294 | 1052 |
1935926 | 1935926 | 2021-11-20 | York | Pennsylvania | 42133 | 67957 | 1050 |
1932676 | 1932676 | 2021-11-19 | York | Pennsylvania | 42133 | 67776 | 1045 |
1929425 | 1929425 | 2021-11-18 | York | Pennsylvania | 42133 | 67519 | 1042 |
1926175 | 1926175 | 2021-11-17 | York | Pennsylvania | 42133 | 67238 | 1038 |
1922925 | 1922925 | 2021-11-16 | York | Pennsylvania | 42133 | 66993 | 1027 |
1919676 | 1919676 | 2021-11-15 | York | Pennsylvania | 42133 | 66754 | 1023 |
1916426 | 1916426 | 2021-11-14 | York | Pennsylvania | 42133 | 66586 | 1023 |
1913176 | 1913176 | 2021-11-13 | York | Pennsylvania | 42133 | 66404 | 1020 |
1909926 | 1909926 | 2021-11-12 | York | Pennsylvania | 42133 | 65235 | 1015 |
1906677 | 1906677 | 2021-11-11 | York | Pennsylvania | 42133 | 65028 | 1015 |
1903428 | 1903428 | 2021-11-10 | York | Pennsylvania | 42133 | 64760 | 1013 |
1900178 | 1900178 | 2021-11-09 | York | Pennsylvania | 42133 | 64570 | 1004 |
1896928 | 1896928 | 2021-11-08 | York | Pennsylvania | 42133 | 64425 | 1002 |
1893678 | 1893678 | 2021-11-07 | York | Pennsylvania | 42133 | 64259 | 999 |
1890428 | 1890428 | 2021-11-06 | York | Pennsylvania | 42133 | 64107 | 999 |
1887178 | 1887178 | 2021-11-05 | York | Pennsylvania | 42133 | 63889 | 998 |
1883928 | 1883928 | 2021-11-04 | York | Pennsylvania | 42133 | 63629 | 993 |
1880679 | 1880679 | 2021-11-03 | York | Pennsylvania | 42133 | 63354 | 990 |
1877430 | 1877430 | 2021-11-02 | York | Pennsylvania | 42133 | 63225 | 981 |
1874181 | 1874181 | 2021-11-01 | York | Pennsylvania | 42133 | 62909 | 979 |
1870932 | 1870932 | 2021-10-31 | York | Pennsylvania | 42133 | 62909 | 979 |
1867683 | 1867683 | 2021-10-30 | York | Pennsylvania | 42133 | 62751 | 977 |
1864434 | 1864434 | 2021-10-29 | York | Pennsylvania | 42133 | 62548 | 976 |
1861185 | 1861185 | 2021-10-28 | York | Pennsylvania | 42133 | 62358 | 971 |
1857936 | 1857936 | 2021-10-27 | York | Pennsylvania | 42133 | 62106 | 966 |
1854687 | 1854687 | 2021-10-26 | York | Pennsylvania | 42133 | 61846 | 957 |
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);