ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where deaths = 698 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- Cambria 3
- Butler 2
- Chester 2
- Lancaster 2
- Westmoreland 2
- Cumberland 1
- Dauphin 1
- Erie 1
- Lackawanna 1
- Luzerne 1
- York 1
state 1
- Pennsylvania · 17 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2251267 | 2251267 | 2022-02-25 | Butler | Pennsylvania | 42019 | 43982 | 698 |
2248016 | 2248016 | 2022-02-24 | Butler | Pennsylvania | 42019 | 43963 | 698 |
2241515 | 2241515 | 2022-02-22 | Cambria | Pennsylvania | 42021 | 34141 | 698 |
2238264 | 2238264 | 2022-02-21 | Cambria | Pennsylvania | 42021 | 34080 | 698 |
2235013 | 2235013 | 2022-02-20 | Cambria | Pennsylvania | 42021 | 34080 | 698 |
2202521 | 2202521 | 2022-02-10 | Lackawanna | Pennsylvania | 42069 | 41787 | 698 |
2186242 | 2186242 | 2022-02-05 | Erie | Pennsylvania | 42049 | 55204 | 698 |
2036649 | 2036649 | 2021-12-21 | Cumberland | Pennsylvania | 42041 | 34694 | 698 |
1974889 | 1974889 | 2021-12-02 | Dauphin | Pennsylvania | 42043 | 38443 | 698 |
1146724 | 1146724 | 2021-03-22 | Westmoreland | Pennsylvania | 42129 | 28221 | 698 |
1143477 | 1143477 | 2021-03-21 | Westmoreland | Pennsylvania | 42129 | 28171 | 698 |
1039604 | 1039604 | 2021-02-17 | York | Pennsylvania | 42133 | 34721 | 698 |
1036307 | 1036307 | 2021-02-16 | Chester | Pennsylvania | 42029 | 29416 | 698 |
1036332 | 1036332 | 2021-02-16 | Luzerne | Pennsylvania | 42079 | 24185 | 698 |
1033062 | 1033062 | 2021-02-15 | Chester | Pennsylvania | 42029 | 29325 | 698 |
867564 | 867564 | 2020-12-26 | Lancaster | Pennsylvania | 42071 | 26557 | 698 |
864319 | 864319 | 2020-12-25 | Lancaster | Pennsylvania | 42071 | 26307 | 698 |
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);