ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 304 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 17
county 17
- Washington 10
- Northampton 7
- Chester 2
- Crawford 2
- Indiana 2
- Lebanon 2
- Lycoming 2
- Adams 1
- Allegheny 1
- Beaver 1
- Bucks 1
- Centre 1
- Clearfield 1
- Franklin 1
- Lawrence 1
- Luzerne 1
- Westmoreland 1
state 1
- Pennsylvania · 37 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2251277 | 2251277 | 2022-02-25 | Crawford | Pennsylvania | 42039 | 19608 | 304 |
2248026 | 2248026 | 2022-02-24 | Crawford | Pennsylvania | 42039 | 19599 | 304 |
2182982 | 2182982 | 2022-02-04 | Clearfield | Pennsylvania | 42033 | 18309 | 304 |
2134161 | 2134161 | 2022-01-20 | Adams | Pennsylvania | 42001 | 22277 | 304 |
2114661 | 2114661 | 2022-01-14 | Centre | Pennsylvania | 42027 | 29909 | 304 |
2091918 | 2091918 | 2022-01-07 | Indiana | Pennsylvania | 42063 | 13192 | 304 |
2088666 | 2088666 | 2022-01-06 | Indiana | Pennsylvania | 42063 | 13050 | 304 |
1981404 | 1981404 | 2021-12-04 | Lawrence | Pennsylvania | 42073 | 12969 | 304 |
1682464 | 1682464 | 2021-09-03 | Lycoming | Pennsylvania | 42081 | 12779 | 304 |
1679214 | 1679214 | 2021-09-02 | Lycoming | Pennsylvania | 42081 | 12745 | 304 |
1675963 | 1675963 | 2021-09-01 | Lebanon | Pennsylvania | 42075 | 17213 | 304 |
1672716 | 1672716 | 2021-08-31 | Lebanon | Pennsylvania | 42075 | 17181 | 304 |
1448666 | 1448666 | 2021-06-23 | Washington | Pennsylvania | 42125 | 17908 | 304 |
1445421 | 1445421 | 2021-06-22 | Washington | Pennsylvania | 42125 | 17908 | 304 |
1442176 | 1442176 | 2021-06-21 | Washington | Pennsylvania | 42125 | 17906 | 304 |
1438931 | 1438931 | 2021-06-20 | Washington | Pennsylvania | 42125 | 17905 | 304 |
1435684 | 1435684 | 2021-06-19 | Washington | Pennsylvania | 42125 | 17902 | 304 |
1432437 | 1432437 | 2021-06-18 | Washington | Pennsylvania | 42125 | 17901 | 304 |
1429191 | 1429191 | 2021-06-17 | Washington | Pennsylvania | 42125 | 17890 | 304 |
1425946 | 1425946 | 2021-06-16 | Washington | Pennsylvania | 42125 | 17888 | 304 |
1422699 | 1422699 | 2021-06-15 | Washington | Pennsylvania | 42125 | 17885 | 304 |
1419453 | 1419453 | 2021-06-14 | Washington | Pennsylvania | 42125 | 17869 | 304 |
1000619 | 1000619 | 2021-02-05 | Franklin | Pennsylvania | 42055 | 11683 | 304 |
955156 | 955156 | 2021-01-22 | Beaver | Pennsylvania | 42007 | 10531 | 304 |
831895 | 831895 | 2020-12-15 | Westmoreland | Pennsylvania | 42129 | 14802 | 304 |
792923 | 792923 | 2020-12-03 | Luzerne | Pennsylvania | 42079 | 10460 | 304 |
552912 | 552912 | 2020-09-20 | Northampton | Pennsylvania | 42095 | 4390 | 304 |
549673 | 549673 | 2020-09-19 | Northampton | Pennsylvania | 42095 | 4364 | 304 |
546434 | 546434 | 2020-09-18 | Northampton | Pennsylvania | 42095 | 4349 | 304 |
543197 | 543197 | 2020-09-17 | Northampton | Pennsylvania | 42095 | 4329 | 304 |
539961 | 539961 | 2020-09-16 | Northampton | Pennsylvania | 42095 | 4301 | 304 |
536724 | 536724 | 2020-09-15 | Northampton | Pennsylvania | 42095 | 4277 | 304 |
533488 | 533488 | 2020-09-14 | Northampton | Pennsylvania | 42095 | 4258 | 304 |
455847 | 455847 | 2020-08-21 | Allegheny | Pennsylvania | 42003 | 9756 | 304 |
229881 | 229881 | 2020-06-11 | Chester | Pennsylvania | 42029 | 3227 | 304 |
226777 | 226777 | 2020-06-10 | Chester | Pennsylvania | 42029 | 3198 | 304 |
120390 | 120390 | 2020-05-06 | Bucks | Pennsylvania | 42017 | 3599 | 304 |
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);