ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 426 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
fips 12
county 12
- Erie 6
- Franklin 5
- Schuylkill 5
- Butler 4
- Lackawanna 4
- Allegheny 1
- Blair 1
- Bucks 1
- Fayette 1
- Lebanon 1
- Northumberland 1
- Washington 1
state 1
- Pennsylvania · 31 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2117936 | 2117936 | 2022-01-15 | Lebanon | Pennsylvania | 42075 | 32197 | 426 |
1968417 | 1968417 | 2021-11-30 | Northumberland | Pennsylvania | 42097 | 14803 | 426 |
1961928 | 1961928 | 2021-11-28 | Washington | Pennsylvania | 42125 | 29645 | 426 |
1948868 | 1948868 | 2021-11-24 | Blair | Pennsylvania | 42013 | 20222 | 426 |
1900137 | 1900137 | 2021-11-09 | Fayette | Pennsylvania | 42051 | 18571 | 426 |
1805910 | 1805910 | 2021-10-11 | Franklin | Pennsylvania | 42055 | 20690 | 426 |
1802660 | 1802660 | 2021-10-10 | Franklin | Pennsylvania | 42055 | 20660 | 426 |
1799411 | 1799411 | 2021-10-09 | Franklin | Pennsylvania | 42055 | 20611 | 426 |
1796162 | 1796162 | 2021-10-08 | Franklin | Pennsylvania | 42055 | 20540 | 426 |
1792913 | 1792913 | 2021-10-07 | Franklin | Pennsylvania | 42055 | 20448 | 426 |
1737706 | 1737706 | 2021-09-20 | Schuylkill | Pennsylvania | 42107 | 16691 | 426 |
1734456 | 1734456 | 2021-09-19 | Schuylkill | Pennsylvania | 42107 | 16657 | 426 |
1731206 | 1731206 | 2021-09-18 | Schuylkill | Pennsylvania | 42107 | 16586 | 426 |
1727956 | 1727956 | 2021-09-17 | Schuylkill | Pennsylvania | 42107 | 16513 | 426 |
1724707 | 1724707 | 2021-09-16 | Schuylkill | Pennsylvania | 42107 | 16438 | 426 |
1656463 | 1656463 | 2021-08-26 | Erie | Pennsylvania | 42049 | 22358 | 426 |
1653216 | 1653216 | 2021-08-25 | Erie | Pennsylvania | 42049 | 22276 | 426 |
1649969 | 1649969 | 2021-08-24 | Erie | Pennsylvania | 42049 | 22190 | 426 |
1646705 | 1646705 | 2021-08-23 | Butler | Pennsylvania | 42019 | 18537 | 426 |
1646720 | 1646720 | 2021-08-23 | Erie | Pennsylvania | 42049 | 22147 | 426 |
1643456 | 1643456 | 2021-08-22 | Butler | Pennsylvania | 42019 | 18500 | 426 |
1643471 | 1643471 | 2021-08-22 | Erie | Pennsylvania | 42049 | 22112 | 426 |
1640206 | 1640206 | 2021-08-21 | Butler | Pennsylvania | 42019 | 18445 | 426 |
1640221 | 1640221 | 2021-08-21 | Erie | Pennsylvania | 42049 | 22075 | 426 |
1636956 | 1636956 | 2021-08-20 | Butler | Pennsylvania | 42019 | 18400 | 426 |
1101243 | 1101243 | 2021-03-08 | Lackawanna | Pennsylvania | 42069 | 14265 | 426 |
1097997 | 1097997 | 2021-03-07 | Lackawanna | Pennsylvania | 42069 | 14228 | 426 |
1094749 | 1094749 | 2021-03-06 | Lackawanna | Pennsylvania | 42069 | 14205 | 426 |
1091503 | 1091503 | 2021-03-05 | Lackawanna | Pennsylvania | 42069 | 14157 | 426 |
676083 | 676083 | 2020-10-28 | Allegheny | Pennsylvania | 42003 | 15300 | 426 |
159358 | 159358 | 2020-05-19 | Bucks | Pennsylvania | 42017 | 4573 | 426 |
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);