ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where deaths = 42 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 30
county 30
- Greene 55
- Wyoming 24
- Franklin 18
- Elk 14
- Pike 7
- Susquehanna 4
- Fulton 3
- Lawrence 3
- Armstrong 2
- Clinton 2
- Columbia 2
- Montour 2
- Schuylkill 2
- Snyder 2
- Adams 1
- Bradford 1
- Carbon 1
- Centre 1
- Chester 1
- Clearfield 1
- Cumberland 1
- Indiana 1
- Jefferson 1
- Lebanon 1
- Somerset 1
- Union 1
- Venango 1
- Washington 1
- Wayne 1
- Westmoreland 1
state 1
- Pennsylvania · 156 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2033407 | 2033407 | 2021-12-20 | Fulton | Pennsylvania | 42057 | 2978 | 42 |
2030157 | 2030157 | 2021-12-19 | Fulton | Pennsylvania | 42057 | 2971 | 42 |
2026906 | 2026906 | 2021-12-18 | Fulton | Pennsylvania | 42057 | 2951 | 42 |
1675949 | 1675949 | 2021-09-01 | Elk | Pennsylvania | 42047 | 3042 | 42 |
1672702 | 1672702 | 2021-08-31 | Elk | Pennsylvania | 42047 | 3029 | 42 |
1669454 | 1669454 | 2021-08-30 | Elk | Pennsylvania | 42047 | 3019 | 42 |
1666207 | 1666207 | 2021-08-29 | Elk | Pennsylvania | 42047 | 3009 | 42 |
1662959 | 1662959 | 2021-08-28 | Elk | Pennsylvania | 42047 | 3001 | 42 |
1659711 | 1659711 | 2021-08-27 | Elk | Pennsylvania | 42047 | 2994 | 42 |
1656462 | 1656462 | 2021-08-26 | Elk | Pennsylvania | 42047 | 2985 | 42 |
1656468 | 1656468 | 2021-08-26 | Greene | Pennsylvania | 42059 | 3564 | 42 |
1653215 | 1653215 | 2021-08-25 | Elk | Pennsylvania | 42047 | 2976 | 42 |
1653221 | 1653221 | 2021-08-25 | Greene | Pennsylvania | 42059 | 3555 | 42 |
1649968 | 1649968 | 2021-08-24 | Elk | Pennsylvania | 42047 | 2968 | 42 |
1649974 | 1649974 | 2021-08-24 | Greene | Pennsylvania | 42059 | 3544 | 42 |
1646719 | 1646719 | 2021-08-23 | Elk | Pennsylvania | 42047 | 2963 | 42 |
1646725 | 1646725 | 2021-08-23 | Greene | Pennsylvania | 42059 | 3523 | 42 |
1643470 | 1643470 | 2021-08-22 | Elk | Pennsylvania | 42047 | 2959 | 42 |
1643476 | 1643476 | 2021-08-22 | Greene | Pennsylvania | 42059 | 3520 | 42 |
1640220 | 1640220 | 2021-08-21 | Elk | Pennsylvania | 42047 | 2958 | 42 |
1640226 | 1640226 | 2021-08-21 | Greene | Pennsylvania | 42059 | 3517 | 42 |
1636970 | 1636970 | 2021-08-20 | Elk | Pennsylvania | 42047 | 2955 | 42 |
1636976 | 1636976 | 2021-08-20 | Greene | Pennsylvania | 42059 | 3510 | 42 |
1633720 | 1633720 | 2021-08-19 | Elk | Pennsylvania | 42047 | 2946 | 42 |
1633726 | 1633726 | 2021-08-19 | Greene | Pennsylvania | 42059 | 3503 | 42 |
1630479 | 1630479 | 2021-08-18 | Greene | Pennsylvania | 42059 | 3471 | 42 |
1627232 | 1627232 | 2021-08-17 | Greene | Pennsylvania | 42059 | 3466 | 42 |
1623985 | 1623985 | 2021-08-16 | Greene | Pennsylvania | 42059 | 3463 | 42 |
1620738 | 1620738 | 2021-08-15 | Greene | Pennsylvania | 42059 | 3463 | 42 |
1617490 | 1617490 | 2021-08-14 | Greene | Pennsylvania | 42059 | 3463 | 42 |
1614242 | 1614242 | 2021-08-13 | Greene | Pennsylvania | 42059 | 3453 | 42 |
1610993 | 1610993 | 2021-08-12 | Greene | Pennsylvania | 42059 | 3448 | 42 |
1607745 | 1607745 | 2021-08-11 | Greene | Pennsylvania | 42059 | 3436 | 42 |
1604496 | 1604496 | 2021-08-10 | Greene | Pennsylvania | 42059 | 3429 | 42 |
1601247 | 1601247 | 2021-08-09 | Greene | Pennsylvania | 42059 | 3419 | 42 |
1597999 | 1597999 | 2021-08-08 | Greene | Pennsylvania | 42059 | 3411 | 42 |
1594750 | 1594750 | 2021-08-07 | Greene | Pennsylvania | 42059 | 3411 | 42 |
1591501 | 1591501 | 2021-08-06 | Greene | Pennsylvania | 42059 | 3408 | 42 |
1588252 | 1588252 | 2021-08-05 | Greene | Pennsylvania | 42059 | 3407 | 42 |
1585002 | 1585002 | 2021-08-04 | Greene | Pennsylvania | 42059 | 3402 | 42 |
1581752 | 1581752 | 2021-08-03 | Greene | Pennsylvania | 42059 | 3399 | 42 |
1578503 | 1578503 | 2021-08-02 | Greene | Pennsylvania | 42059 | 3393 | 42 |
1575255 | 1575255 | 2021-08-01 | Greene | Pennsylvania | 42059 | 3388 | 42 |
1572007 | 1572007 | 2021-07-31 | Greene | Pennsylvania | 42059 | 3385 | 42 |
1568759 | 1568759 | 2021-07-30 | Greene | Pennsylvania | 42059 | 3385 | 42 |
1565511 | 1565511 | 2021-07-29 | Greene | Pennsylvania | 42059 | 3385 | 42 |
1562263 | 1562263 | 2021-07-28 | Greene | Pennsylvania | 42059 | 3383 | 42 |
1559015 | 1559015 | 2021-07-27 | Greene | Pennsylvania | 42059 | 3382 | 42 |
1555768 | 1555768 | 2021-07-26 | Greene | Pennsylvania | 42059 | 3378 | 42 |
1552521 | 1552521 | 2021-07-25 | Greene | Pennsylvania | 42059 | 3376 | 42 |
1549274 | 1549274 | 2021-07-24 | Greene | Pennsylvania | 42059 | 3376 | 42 |
1546027 | 1546027 | 2021-07-23 | Greene | Pennsylvania | 42059 | 3377 | 42 |
1542780 | 1542780 | 2021-07-22 | Greene | Pennsylvania | 42059 | 3376 | 42 |
1539532 | 1539532 | 2021-07-21 | Greene | Pennsylvania | 42059 | 3374 | 42 |
1536285 | 1536285 | 2021-07-20 | Greene | Pennsylvania | 42059 | 3372 | 42 |
1533037 | 1533037 | 2021-07-19 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1529790 | 1529790 | 2021-07-18 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1526543 | 1526543 | 2021-07-17 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1523296 | 1523296 | 2021-07-16 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1520048 | 1520048 | 2021-07-15 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1516800 | 1516800 | 2021-07-14 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1513553 | 1513553 | 2021-07-13 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1510307 | 1510307 | 2021-07-12 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1507060 | 1507060 | 2021-07-11 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1503814 | 1503814 | 2021-07-10 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1500568 | 1500568 | 2021-07-09 | Greene | Pennsylvania | 42059 | 3368 | 42 |
1497322 | 1497322 | 2021-07-08 | Greene | Pennsylvania | 42059 | 3366 | 42 |
1494075 | 1494075 | 2021-07-07 | Greene | Pennsylvania | 42059 | 3363 | 42 |
1490828 | 1490828 | 2021-07-06 | Greene | Pennsylvania | 42059 | 3361 | 42 |
1487581 | 1487581 | 2021-07-05 | Greene | Pennsylvania | 42059 | 3361 | 42 |
1484334 | 1484334 | 2021-07-04 | Greene | Pennsylvania | 42059 | 3361 | 42 |
1481088 | 1481088 | 2021-07-03 | Greene | Pennsylvania | 42059 | 3360 | 42 |
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 |
1094780 | 1094780 | 2021-03-06 | Wyoming | Pennsylvania | 42131 | 1188 | 42 |
1091534 | 1091534 | 2021-03-05 | Wyoming | Pennsylvania | 42131 | 1183 | 42 |
1088288 | 1088288 | 2021-03-04 | Wyoming | Pennsylvania | 42131 | 1180 | 42 |
1085043 | 1085043 | 2021-03-03 | Wyoming | Pennsylvania | 42131 | 1171 | 42 |
971441 | 971441 | 2021-01-27 | Wayne | Pennsylvania | 42127 | 2600 | 42 |
968184 | 968184 | 2021-01-26 | Pike | Pennsylvania | 42103 | 2042 | 42 |
964940 | 964940 | 2021-01-25 | Pike | Pennsylvania | 42103 | 2024 | 42 |
961695 | 961695 | 2021-01-24 | Pike | Pennsylvania | 42103 | 2006 | 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);