ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Wyoming" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419456 | 1419456 | 2021-06-14 | Wyoming | Pennsylvania | 42131 | 1993 | 54 |
1416211 | 1416211 | 2021-06-13 | Wyoming | Pennsylvania | 42131 | 1992 | 54 |
1412965 | 1412965 | 2021-06-12 | Wyoming | Pennsylvania | 42131 | 1991 | 54 |
1409720 | 1409720 | 2021-06-11 | Wyoming | Pennsylvania | 42131 | 1990 | 54 |
1406475 | 1406475 | 2021-06-10 | Wyoming | Pennsylvania | 42131 | 1986 | 54 |
1403229 | 1403229 | 2021-06-09 | Wyoming | Pennsylvania | 42131 | 1986 | 54 |
1399984 | 1399984 | 2021-06-08 | Wyoming | Pennsylvania | 42131 | 1985 | 54 |
1396739 | 1396739 | 2021-06-07 | Wyoming | Pennsylvania | 42131 | 1984 | 54 |
1393492 | 1393492 | 2021-06-06 | Wyoming | Pennsylvania | 42131 | 1984 | 54 |
1390247 | 1390247 | 2021-06-05 | Wyoming | Pennsylvania | 42131 | 1983 | 54 |
1387002 | 1387002 | 2021-06-04 | Wyoming | Pennsylvania | 42131 | 1981 | 54 |
1383757 | 1383757 | 2021-06-03 | Wyoming | Pennsylvania | 42131 | 1980 | 54 |
1380511 | 1380511 | 2021-06-02 | Wyoming | Pennsylvania | 42131 | 1979 | 54 |
1377266 | 1377266 | 2021-06-01 | Wyoming | Pennsylvania | 42131 | 1976 | 54 |
1374020 | 1374020 | 2021-05-31 | Wyoming | Pennsylvania | 42131 | 1973 | 54 |
1370775 | 1370775 | 2021-05-30 | Wyoming | Pennsylvania | 42131 | 1971 | 54 |
1367529 | 1367529 | 2021-05-29 | Wyoming | Pennsylvania | 42131 | 1968 | 54 |
1364283 | 1364283 | 2021-05-28 | Wyoming | Pennsylvania | 42131 | 1965 | 54 |
1361037 | 1361037 | 2021-05-27 | Wyoming | Pennsylvania | 42131 | 1959 | 54 |
1357791 | 1357791 | 2021-05-26 | Wyoming | Pennsylvania | 42131 | 1957 | 53 |
1354545 | 1354545 | 2021-05-25 | Wyoming | Pennsylvania | 42131 | 1950 | 53 |
1351299 | 1351299 | 2021-05-24 | Wyoming | Pennsylvania | 42131 | 1940 | 53 |
1348053 | 1348053 | 2021-05-23 | Wyoming | Pennsylvania | 42131 | 1939 | 53 |
1344805 | 1344805 | 2021-05-22 | Wyoming | Pennsylvania | 42131 | 1919 | 53 |
1341557 | 1341557 | 2021-05-21 | Wyoming | Pennsylvania | 42131 | 1919 | 52 |
1338309 | 1338309 | 2021-05-20 | Wyoming | Pennsylvania | 42131 | 1912 | 52 |
1335062 | 1335062 | 2021-05-19 | Wyoming | Pennsylvania | 42131 | 1911 | 51 |
1331815 | 1331815 | 2021-05-18 | Wyoming | Pennsylvania | 42131 | 1907 | 51 |
1328568 | 1328568 | 2021-05-17 | Wyoming | Pennsylvania | 42131 | 1903 | 51 |
1325322 | 1325322 | 2021-05-16 | Wyoming | Pennsylvania | 42131 | 1899 | 51 |
1322076 | 1322076 | 2021-05-15 | Wyoming | Pennsylvania | 42131 | 1895 | 50 |
1318830 | 1318830 | 2021-05-14 | Wyoming | Pennsylvania | 42131 | 1891 | 50 |
1315582 | 1315582 | 2021-05-13 | Wyoming | Pennsylvania | 42131 | 1885 | 49 |
1312336 | 1312336 | 2021-05-12 | Wyoming | Pennsylvania | 42131 | 1882 | 48 |
1309089 | 1309089 | 2021-05-11 | Wyoming | Pennsylvania | 42131 | 1878 | 48 |
1305843 | 1305843 | 2021-05-10 | Wyoming | Pennsylvania | 42131 | 1875 | 48 |
1302597 | 1302597 | 2021-05-09 | Wyoming | Pennsylvania | 42131 | 1873 | 48 |
1299350 | 1299350 | 2021-05-08 | Wyoming | Pennsylvania | 42131 | 1868 | 48 |
1296103 | 1296103 | 2021-05-07 | Wyoming | Pennsylvania | 42131 | 1863 | 48 |
1292857 | 1292857 | 2021-05-06 | Wyoming | Pennsylvania | 42131 | 1859 | 48 |
1289611 | 1289611 | 2021-05-05 | Wyoming | Pennsylvania | 42131 | 1854 | 48 |
1286365 | 1286365 | 2021-05-04 | Wyoming | Pennsylvania | 42131 | 1851 | 48 |
1283119 | 1283119 | 2021-05-03 | Wyoming | Pennsylvania | 42131 | 1844 | 47 |
1279872 | 1279872 | 2021-05-02 | Wyoming | Pennsylvania | 42131 | 1838 | 47 |
1276625 | 1276625 | 2021-05-01 | Wyoming | Pennsylvania | 42131 | 1834 | 47 |
1273378 | 1273378 | 2021-04-30 | Wyoming | Pennsylvania | 42131 | 1824 | 47 |
1270131 | 1270131 | 2021-04-29 | Wyoming | Pennsylvania | 42131 | 1815 | 46 |
1266884 | 1266884 | 2021-04-28 | Wyoming | Pennsylvania | 42131 | 1807 | 46 |
1263637 | 1263637 | 2021-04-27 | Wyoming | Pennsylvania | 42131 | 1801 | 46 |
1260390 | 1260390 | 2021-04-26 | Wyoming | Pennsylvania | 42131 | 1795 | 46 |
1257143 | 1257143 | 2021-04-25 | Wyoming | Pennsylvania | 42131 | 1792 | 46 |
1253896 | 1253896 | 2021-04-24 | Wyoming | Pennsylvania | 42131 | 1786 | 46 |
1250649 | 1250649 | 2021-04-23 | Wyoming | Pennsylvania | 42131 | 1768 | 44 |
1247402 | 1247402 | 2021-04-22 | Wyoming | Pennsylvania | 42131 | 1754 | 44 |
1244155 | 1244155 | 2021-04-21 | Wyoming | Pennsylvania | 42131 | 1744 | 44 |
1240908 | 1240908 | 2021-04-20 | Wyoming | Pennsylvania | 42131 | 1732 | 44 |
1237661 | 1237661 | 2021-04-19 | Wyoming | Pennsylvania | 42131 | 1727 | 44 |
1234414 | 1234414 | 2021-04-18 | Wyoming | Pennsylvania | 42131 | 1723 | 44 |
1231166 | 1231166 | 2021-04-17 | Wyoming | Pennsylvania | 42131 | 1716 | 44 |
1227918 | 1227918 | 2021-04-16 | Wyoming | Pennsylvania | 42131 | 1701 | 44 |
1224670 | 1224670 | 2021-04-15 | Wyoming | Pennsylvania | 42131 | 1688 | 44 |
1221423 | 1221423 | 2021-04-14 | Wyoming | Pennsylvania | 42131 | 1672 | 44 |
1218175 | 1218175 | 2021-04-13 | Wyoming | Pennsylvania | 42131 | 1652 | 44 |
1214927 | 1214927 | 2021-04-12 | Wyoming | Pennsylvania | 42131 | 1628 | 44 |
1211680 | 1211680 | 2021-04-11 | Wyoming | Pennsylvania | 42131 | 1621 | 44 |
1208431 | 1208431 | 2021-04-10 | Wyoming | Pennsylvania | 42131 | 1612 | 44 |
1205183 | 1205183 | 2021-04-09 | Wyoming | Pennsylvania | 42131 | 1594 | 44 |
1201935 | 1201935 | 2021-04-08 | Wyoming | Pennsylvania | 42131 | 1575 | 44 |
1198686 | 1198686 | 2021-04-07 | Wyoming | Pennsylvania | 42131 | 1557 | 44 |
1195437 | 1195437 | 2021-04-06 | Wyoming | Pennsylvania | 42131 | 1534 | 44 |
1192189 | 1192189 | 2021-04-05 | Wyoming | Pennsylvania | 42131 | 1515 | 44 |
1188940 | 1188940 | 2021-04-04 | Wyoming | Pennsylvania | 42131 | 1505 | 44 |
1185693 | 1185693 | 2021-04-03 | Wyoming | Pennsylvania | 42131 | 1477 | 44 |
1182446 | 1182446 | 2021-04-02 | Wyoming | Pennsylvania | 42131 | 1458 | 44 |
1179199 | 1179199 | 2021-04-01 | Wyoming | Pennsylvania | 42131 | 1436 | 44 |
1175952 | 1175952 | 2021-03-31 | Wyoming | Pennsylvania | 42131 | 1415 | 44 |
1172705 | 1172705 | 2021-03-30 | Wyoming | Pennsylvania | 42131 | 1396 | 44 |
1169458 | 1169458 | 2021-03-29 | Wyoming | Pennsylvania | 42131 | 1376 | 44 |
1166210 | 1166210 | 2021-03-28 | Wyoming | Pennsylvania | 42131 | 1360 | 44 |
1162962 | 1162962 | 2021-03-27 | Wyoming | Pennsylvania | 42131 | 1353 | 44 |
1159713 | 1159713 | 2021-03-26 | Wyoming | Pennsylvania | 42131 | 1338 | 42 |
1156466 | 1156466 | 2021-03-25 | Wyoming | Pennsylvania | 42131 | 1323 | 42 |
1153219 | 1153219 | 2021-03-24 | Wyoming | Pennsylvania | 42131 | 1310 | 42 |
1149972 | 1149972 | 2021-03-23 | Wyoming | Pennsylvania | 42131 | 1297 | 42 |
1146725 | 1146725 | 2021-03-22 | Wyoming | Pennsylvania | 42131 | 1286 | 42 |
1143478 | 1143478 | 2021-03-21 | Wyoming | Pennsylvania | 42131 | 1282 | 42 |
1140231 | 1140231 | 2021-03-20 | Wyoming | Pennsylvania | 42131 | 1275 | 42 |
1136985 | 1136985 | 2021-03-19 | Wyoming | Pennsylvania | 42131 | 1261 | 42 |
1133739 | 1133739 | 2021-03-18 | Wyoming | Pennsylvania | 42131 | 1249 | 42 |
1130491 | 1130491 | 2021-03-17 | Wyoming | Pennsylvania | 42131 | 1233 | 42 |
1127244 | 1127244 | 2021-03-16 | Wyoming | Pennsylvania | 42131 | 1220 | 42 |
1123998 | 1123998 | 2021-03-15 | Wyoming | Pennsylvania | 42131 | 1214 | 42 |
1120752 | 1120752 | 2021-03-14 | Wyoming | Pennsylvania | 42131 | 1211 | 42 |
1117505 | 1117505 | 2021-03-13 | Wyoming | Pennsylvania | 42131 | 1207 | 42 |
1114258 | 1114258 | 2021-03-12 | Wyoming | Pennsylvania | 42131 | 1203 | 42 |
1111012 | 1111012 | 2021-03-11 | Wyoming | Pennsylvania | 42131 | 1197 | 42 |
1107766 | 1107766 | 2021-03-10 | Wyoming | Pennsylvania | 42131 | 1194 | 42 |
1104520 | 1104520 | 2021-03-09 | Wyoming | Pennsylvania | 42131 | 1193 | 42 |
1101274 | 1101274 | 2021-03-08 | Wyoming | Pennsylvania | 42131 | 1192 | 42 |
1098028 | 1098028 | 2021-03-07 | Wyoming | Pennsylvania | 42131 | 1188 | 42 |
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);