ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where deaths = 365 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 17
county 17
- Northumberland 28
- Lehigh 6
- Fayette 5
- Berks 4
- Lycoming 3
- Beaver 2
- Butler 2
- Cumberland 2
- Lancaster 2
- Schuylkill 2
- Dauphin 1
- Franklin 1
- Lackawanna 1
- Lawrence 1
- Mercer 1
- Philadelphia 1
- Westmoreland 1
state 1
- Pennsylvania · 63 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2137451 | 2137451 | 2022-01-21 | Lawrence | Pennsylvania | 42073 | 17338 | 365 |
1948904 | 1948904 | 2021-11-24 | Mercer | Pennsylvania | 42085 | 15474 | 365 |
1893652 | 1893652 | 2021-11-07 | Lycoming | Pennsylvania | 42081 | 17016 | 365 |
1890402 | 1890402 | 2021-11-06 | Lycoming | Pennsylvania | 42081 | 16967 | 365 |
1887152 | 1887152 | 2021-11-05 | Lycoming | Pennsylvania | 42081 | 16901 | 365 |
1805908 | 1805908 | 2021-10-11 | Fayette | Pennsylvania | 42051 | 16569 | 365 |
1802658 | 1802658 | 2021-10-10 | Fayette | Pennsylvania | 42051 | 16534 | 365 |
1799409 | 1799409 | 2021-10-09 | Fayette | Pennsylvania | 42051 | 16481 | 365 |
1796160 | 1796160 | 2021-10-08 | Fayette | Pennsylvania | 42051 | 16384 | 365 |
1792911 | 1792911 | 2021-10-07 | Fayette | Pennsylvania | 42051 | 16253 | 365 |
1627251 | 1627251 | 2021-08-17 | Northumberland | Pennsylvania | 42097 | 9910 | 365 |
1624004 | 1624004 | 2021-08-16 | Northumberland | Pennsylvania | 42097 | 9888 | 365 |
1620757 | 1620757 | 2021-08-15 | Northumberland | Pennsylvania | 42097 | 9884 | 365 |
1617509 | 1617509 | 2021-08-14 | Northumberland | Pennsylvania | 42097 | 9881 | 365 |
1614261 | 1614261 | 2021-08-13 | Northumberland | Pennsylvania | 42097 | 9867 | 365 |
1611012 | 1611012 | 2021-08-12 | Northumberland | Pennsylvania | 42097 | 9856 | 365 |
1607764 | 1607764 | 2021-08-11 | Northumberland | Pennsylvania | 42097 | 9845 | 365 |
1604515 | 1604515 | 2021-08-10 | Northumberland | Pennsylvania | 42097 | 9833 | 365 |
1601266 | 1601266 | 2021-08-09 | Northumberland | Pennsylvania | 42097 | 9826 | 365 |
1598018 | 1598018 | 2021-08-08 | Northumberland | Pennsylvania | 42097 | 9813 | 365 |
1594769 | 1594769 | 2021-08-07 | Northumberland | Pennsylvania | 42097 | 9813 | 365 |
1591520 | 1591520 | 2021-08-06 | Northumberland | Pennsylvania | 42097 | 9803 | 365 |
1588271 | 1588271 | 2021-08-05 | Northumberland | Pennsylvania | 42097 | 9796 | 365 |
1585021 | 1585021 | 2021-08-04 | Northumberland | Pennsylvania | 42097 | 9789 | 365 |
1581771 | 1581771 | 2021-08-03 | Northumberland | Pennsylvania | 42097 | 9783 | 365 |
1578522 | 1578522 | 2021-08-02 | Northumberland | Pennsylvania | 42097 | 9778 | 365 |
1575274 | 1575274 | 2021-08-01 | Northumberland | Pennsylvania | 42097 | 9776 | 365 |
1572026 | 1572026 | 2021-07-31 | Northumberland | Pennsylvania | 42097 | 9760 | 365 |
1568778 | 1568778 | 2021-07-30 | Northumberland | Pennsylvania | 42097 | 9760 | 365 |
1565530 | 1565530 | 2021-07-29 | Northumberland | Pennsylvania | 42097 | 9754 | 365 |
1562282 | 1562282 | 2021-07-28 | Northumberland | Pennsylvania | 42097 | 9747 | 365 |
1559034 | 1559034 | 2021-07-27 | Northumberland | Pennsylvania | 42097 | 9746 | 365 |
1555787 | 1555787 | 2021-07-26 | Northumberland | Pennsylvania | 42097 | 9741 | 365 |
1552540 | 1552540 | 2021-07-25 | Northumberland | Pennsylvania | 42097 | 9739 | 365 |
1549293 | 1549293 | 2021-07-24 | Northumberland | Pennsylvania | 42097 | 9738 | 365 |
1546046 | 1546046 | 2021-07-23 | Northumberland | Pennsylvania | 42097 | 9739 | 365 |
1542799 | 1542799 | 2021-07-22 | Northumberland | Pennsylvania | 42097 | 9738 | 365 |
1539551 | 1539551 | 2021-07-21 | Northumberland | Pennsylvania | 42097 | 9736 | 365 |
1309051 | 1309051 | 2021-05-11 | Franklin | Pennsylvania | 42055 | 14971 | 365 |
1231104 | 1231104 | 2021-04-17 | Beaver | Pennsylvania | 42007 | 14185 | 365 |
1227856 | 1227856 | 2021-04-16 | Beaver | Pennsylvania | 42007 | 14137 | 365 |
1062268 | 1062268 | 2021-02-24 | Butler | Pennsylvania | 42019 | 13789 | 365 |
1059023 | 1059023 | 2021-02-23 | Butler | Pennsylvania | 42019 | 13741 | 365 |
1055821 | 1055821 | 2021-02-22 | Schuylkill | Pennsylvania | 42107 | 11902 | 365 |
1052575 | 1052575 | 2021-02-21 | Schuylkill | Pennsylvania | 42107 | 11880 | 365 |
997380 | 997380 | 2021-02-04 | Lackawanna | Pennsylvania | 42069 | 12590 | 365 |
932455 | 932455 | 2021-01-15 | Cumberland | Pennsylvania | 42041 | 12420 | 365 |
929210 | 929210 | 2021-01-14 | Cumberland | Pennsylvania | 42041 | 12353 | 365 |
922720 | 922720 | 2021-01-12 | Dauphin | Pennsylvania | 42043 | 15809 | 365 |
857858 | 857858 | 2020-12-23 | Westmoreland | Pennsylvania | 42129 | 17406 | 365 |
679363 | 679363 | 2020-10-29 | Lehigh | Pennsylvania | 42077 | 6643 | 365 |
676120 | 676120 | 2020-10-28 | Lehigh | Pennsylvania | 42077 | 6593 | 365 |
672877 | 672877 | 2020-10-27 | Lehigh | Pennsylvania | 42077 | 6541 | 365 |
669635 | 669635 | 2020-10-26 | Lehigh | Pennsylvania | 42077 | 6496 | 365 |
666391 | 666391 | 2020-10-25 | Lehigh | Pennsylvania | 42077 | 6411 | 365 |
663146 | 663146 | 2020-10-24 | Lehigh | Pennsylvania | 42077 | 6376 | 365 |
397832 | 397832 | 2020-08-03 | Berks | Pennsylvania | 42011 | 5218 | 365 |
394615 | 394615 | 2020-08-02 | Berks | Pennsylvania | 42011 | 5190 | 365 |
391399 | 391399 | 2020-08-01 | Berks | Pennsylvania | 42011 | 5168 | 365 |
388182 | 388182 | 2020-07-31 | Berks | Pennsylvania | 42011 | 5152 | 365 |
298770 | 298770 | 2020-07-03 | Lancaster | Pennsylvania | 42071 | 4530 | 365 |
295611 | 295611 | 2020-07-02 | Lancaster | Pennsylvania | 42071 | 4504 | 365 |
72155 | 72155 | 2020-04-19 | Philadelphia | Pennsylvania | 42101 | 9214 | 365 |
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);