ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 42003 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419392 | 1419392 | 2021-06-14 | Allegheny | Pennsylvania | 42003 | 101650 | 1999 |
1416147 | 1416147 | 2021-06-13 | Allegheny | Pennsylvania | 42003 | 101646 | 1999 |
1412901 | 1412901 | 2021-06-12 | Allegheny | Pennsylvania | 42003 | 101639 | 1997 |
1409656 | 1409656 | 2021-06-11 | Allegheny | Pennsylvania | 42003 | 101624 | 1996 |
1406411 | 1406411 | 2021-06-10 | Allegheny | Pennsylvania | 42003 | 101605 | 1994 |
1403165 | 1403165 | 2021-06-09 | Allegheny | Pennsylvania | 42003 | 101561 | 1991 |
1399920 | 1399920 | 2021-06-08 | Allegheny | Pennsylvania | 42003 | 101546 | 1990 |
1396675 | 1396675 | 2021-06-07 | Allegheny | Pennsylvania | 42003 | 101522 | 1989 |
1393428 | 1393428 | 2021-06-06 | Allegheny | Pennsylvania | 42003 | 101492 | 1989 |
1390183 | 1390183 | 2021-06-05 | Allegheny | Pennsylvania | 42003 | 101471 | 1988 |
1386938 | 1386938 | 2021-06-04 | Allegheny | Pennsylvania | 42003 | 101446 | 1986 |
1383693 | 1383693 | 2021-06-03 | Allegheny | Pennsylvania | 42003 | 101411 | 1985 |
1380447 | 1380447 | 2021-06-02 | Allegheny | Pennsylvania | 42003 | 101378 | 1984 |
1377202 | 1377202 | 2021-06-01 | Allegheny | Pennsylvania | 42003 | 101336 | 1980 |
1373956 | 1373956 | 2021-05-31 | Allegheny | Pennsylvania | 42003 | 101287 | 1980 |
1370711 | 1370711 | 2021-05-30 | Allegheny | Pennsylvania | 42003 | 101262 | 1979 |
1367465 | 1367465 | 2021-05-29 | Allegheny | Pennsylvania | 42003 | 101223 | 1979 |
1364219 | 1364219 | 2021-05-28 | Allegheny | Pennsylvania | 42003 | 101175 | 1976 |
1360973 | 1360973 | 2021-05-27 | Allegheny | Pennsylvania | 42003 | 101103 | 1971 |
1357727 | 1357727 | 2021-05-26 | Allegheny | Pennsylvania | 42003 | 101056 | 1969 |
1354481 | 1354481 | 2021-05-25 | Allegheny | Pennsylvania | 42003 | 100984 | 1965 |
1351235 | 1351235 | 2021-05-24 | Allegheny | Pennsylvania | 42003 | 100922 | 1964 |
1347989 | 1347989 | 2021-05-23 | Allegheny | Pennsylvania | 42003 | 100870 | 1964 |
1344741 | 1344741 | 2021-05-22 | Allegheny | Pennsylvania | 42003 | 100719 | 1964 |
1341493 | 1341493 | 2021-05-21 | Allegheny | Pennsylvania | 42003 | 100719 | 1958 |
1338245 | 1338245 | 2021-05-20 | Allegheny | Pennsylvania | 42003 | 100600 | 1957 |
1334998 | 1334998 | 2021-05-19 | Allegheny | Pennsylvania | 42003 | 100460 | 1956 |
1331751 | 1331751 | 2021-05-18 | Allegheny | Pennsylvania | 42003 | 100367 | 1949 |
1328504 | 1328504 | 2021-05-17 | Allegheny | Pennsylvania | 42003 | 100201 | 1947 |
1325258 | 1325258 | 2021-05-16 | Allegheny | Pennsylvania | 42003 | 100130 | 1944 |
1322012 | 1322012 | 2021-05-15 | Allegheny | Pennsylvania | 42003 | 100039 | 1940 |
1318766 | 1318766 | 2021-05-14 | Allegheny | Pennsylvania | 42003 | 99853 | 1938 |
1315518 | 1315518 | 2021-05-13 | Allegheny | Pennsylvania | 42003 | 99709 | 1934 |
1312272 | 1312272 | 2021-05-12 | Allegheny | Pennsylvania | 42003 | 99567 | 1931 |
1309025 | 1309025 | 2021-05-11 | Allegheny | Pennsylvania | 42003 | 99384 | 1927 |
1305779 | 1305779 | 2021-05-10 | Allegheny | Pennsylvania | 42003 | 99160 | 1923 |
1302533 | 1302533 | 2021-05-09 | Allegheny | Pennsylvania | 42003 | 99089 | 1922 |
1299286 | 1299286 | 2021-05-08 | Allegheny | Pennsylvania | 42003 | 98969 | 1922 |
1296039 | 1296039 | 2021-05-07 | Allegheny | Pennsylvania | 42003 | 98723 | 1919 |
1292793 | 1292793 | 2021-05-06 | Allegheny | Pennsylvania | 42003 | 98532 | 1915 |
1289547 | 1289547 | 2021-05-05 | Allegheny | Pennsylvania | 42003 | 98355 | 1913 |
1286301 | 1286301 | 2021-05-04 | Allegheny | Pennsylvania | 42003 | 98197 | 1909 |
1283055 | 1283055 | 2021-05-03 | Allegheny | Pennsylvania | 42003 | 97975 | 1901 |
1279808 | 1279808 | 2021-05-02 | Allegheny | Pennsylvania | 42003 | 97760 | 1901 |
1276561 | 1276561 | 2021-05-01 | Allegheny | Pennsylvania | 42003 | 97521 | 1899 |
1273314 | 1273314 | 2021-04-30 | Allegheny | Pennsylvania | 42003 | 97250 | 1897 |
1270067 | 1270067 | 2021-04-29 | Allegheny | Pennsylvania | 42003 | 96884 | 1894 |
1266820 | 1266820 | 2021-04-28 | Allegheny | Pennsylvania | 42003 | 96670 | 1891 |
1263573 | 1263573 | 2021-04-27 | Allegheny | Pennsylvania | 42003 | 96428 | 1886 |
1260326 | 1260326 | 2021-04-26 | Allegheny | Pennsylvania | 42003 | 96168 | 1885 |
1257079 | 1257079 | 2021-04-25 | Allegheny | Pennsylvania | 42003 | 96074 | 1885 |
1253832 | 1253832 | 2021-04-24 | Allegheny | Pennsylvania | 42003 | 95857 | 1883 |
1250585 | 1250585 | 2021-04-23 | Allegheny | Pennsylvania | 42003 | 95490 | 1882 |
1247338 | 1247338 | 2021-04-22 | Allegheny | Pennsylvania | 42003 | 95140 | 1879 |
1244091 | 1244091 | 2021-04-21 | Allegheny | Pennsylvania | 42003 | 94841 | 1879 |
1240844 | 1240844 | 2021-04-20 | Allegheny | Pennsylvania | 42003 | 94501 | 1878 |
1237597 | 1237597 | 2021-04-19 | Allegheny | Pennsylvania | 42003 | 94112 | 1870 |
1234350 | 1234350 | 2021-04-18 | Allegheny | Pennsylvania | 42003 | 93909 | 1870 |
1231102 | 1231102 | 2021-04-17 | Allegheny | Pennsylvania | 42003 | 93684 | 1869 |
1227854 | 1227854 | 2021-04-16 | Allegheny | Pennsylvania | 42003 | 93279 | 1866 |
1224606 | 1224606 | 2021-04-15 | Allegheny | Pennsylvania | 42003 | 92788 | 1860 |
1221359 | 1221359 | 2021-04-14 | Allegheny | Pennsylvania | 42003 | 92385 | 1860 |
1218111 | 1218111 | 2021-04-13 | Allegheny | Pennsylvania | 42003 | 91064 | 1853 |
1214863 | 1214863 | 2021-04-12 | Allegheny | Pennsylvania | 42003 | 90634 | 1842 |
1211616 | 1211616 | 2021-04-11 | Allegheny | Pennsylvania | 42003 | 90386 | 1841 |
1208367 | 1208367 | 2021-04-10 | Allegheny | Pennsylvania | 42003 | 89917 | 1840 |
1205119 | 1205119 | 2021-04-09 | Allegheny | Pennsylvania | 42003 | 89545 | 1838 |
1201871 | 1201871 | 2021-04-08 | Allegheny | Pennsylvania | 42003 | 88952 | 1832 |
1198622 | 1198622 | 2021-04-07 | Allegheny | Pennsylvania | 42003 | 88573 | 1826 |
1195373 | 1195373 | 2021-04-06 | Allegheny | Pennsylvania | 42003 | 88155 | 1824 |
1192125 | 1192125 | 2021-04-05 | Allegheny | Pennsylvania | 42003 | 87623 | 1823 |
1188876 | 1188876 | 2021-04-04 | Allegheny | Pennsylvania | 42003 | 87403 | 1821 |
1185629 | 1185629 | 2021-04-03 | Allegheny | Pennsylvania | 42003 | 87101 | 1821 |
1182382 | 1182382 | 2021-04-02 | Allegheny | Pennsylvania | 42003 | 86448 | 1820 |
1179135 | 1179135 | 2021-04-01 | Allegheny | Pennsylvania | 42003 | 86007 | 1817 |
1175888 | 1175888 | 2021-03-31 | Allegheny | Pennsylvania | 42003 | 85680 | 1814 |
1172641 | 1172641 | 2021-03-30 | Allegheny | Pennsylvania | 42003 | 85262 | 1807 |
1169394 | 1169394 | 2021-03-29 | Allegheny | Pennsylvania | 42003 | 84850 | 1802 |
1166146 | 1166146 | 2021-03-28 | Allegheny | Pennsylvania | 42003 | 84522 | 1801 |
1162898 | 1162898 | 2021-03-27 | Allegheny | Pennsylvania | 42003 | 84210 | 1800 |
1159649 | 1159649 | 2021-03-26 | Allegheny | Pennsylvania | 42003 | 83811 | 1797 |
1156402 | 1156402 | 2021-03-25 | Allegheny | Pennsylvania | 42003 | 83225 | 1793 |
1153155 | 1153155 | 2021-03-24 | Allegheny | Pennsylvania | 42003 | 82942 | 1790 |
1149908 | 1149908 | 2021-03-23 | Allegheny | Pennsylvania | 42003 | 82444 | 1783 |
1146661 | 1146661 | 2021-03-22 | Allegheny | Pennsylvania | 42003 | 82080 | 1780 |
1143414 | 1143414 | 2021-03-21 | Allegheny | Pennsylvania | 42003 | 81912 | 1780 |
1140167 | 1140167 | 2021-03-20 | Allegheny | Pennsylvania | 42003 | 81655 | 1779 |
1136921 | 1136921 | 2021-03-19 | Allegheny | Pennsylvania | 42003 | 81287 | 1777 |
1133675 | 1133675 | 2021-03-18 | Allegheny | Pennsylvania | 42003 | 80941 | 1774 |
1130427 | 1130427 | 2021-03-17 | Allegheny | Pennsylvania | 42003 | 80645 | 1774 |
1127180 | 1127180 | 2021-03-16 | Allegheny | Pennsylvania | 42003 | 80360 | 1770 |
1123934 | 1123934 | 2021-03-15 | Allegheny | Pennsylvania | 42003 | 80054 | 1769 |
1120688 | 1120688 | 2021-03-14 | Allegheny | Pennsylvania | 42003 | 79930 | 1767 |
1117441 | 1117441 | 2021-03-13 | Allegheny | Pennsylvania | 42003 | 79779 | 1767 |
1114194 | 1114194 | 2021-03-12 | Allegheny | Pennsylvania | 42003 | 79450 | 1767 |
1110948 | 1110948 | 2021-03-11 | Allegheny | Pennsylvania | 42003 | 79154 | 1764 |
1107702 | 1107702 | 2021-03-10 | Allegheny | Pennsylvania | 42003 | 78914 | 1762 |
1104456 | 1104456 | 2021-03-09 | Allegheny | Pennsylvania | 42003 | 78705 | 1760 |
1101210 | 1101210 | 2021-03-08 | Allegheny | Pennsylvania | 42003 | 78357 | 1755 |
1097964 | 1097964 | 2021-03-07 | Allegheny | Pennsylvania | 42003 | 78220 | 1755 |
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);