ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 260 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 14
county 14
- Clearfield 3
- Crawford 3
- Fayette 3
- Lebanon 3
- Beaver 2
- Mercer 2
- York 2
- Adams 1
- Allegheny 1
- Centre 1
- Chester 1
- Lackawanna 1
- Monroe 1
- Washington 1
state 1
- Pennsylvania · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2075645 | 2075645 | 2022-01-02 | Clearfield | Pennsylvania | 42033 | 14600 | 260 |
2075648 | 2075648 | 2022-01-02 | Crawford | Pennsylvania | 42039 | 15413 | 260 |
2072394 | 2072394 | 2022-01-01 | Clearfield | Pennsylvania | 42033 | 14538 | 260 |
2072397 | 2072397 | 2022-01-01 | Crawford | Pennsylvania | 42039 | 15298 | 260 |
2069143 | 2069143 | 2021-12-31 | Clearfield | Pennsylvania | 42033 | 14487 | 260 |
2069146 | 2069146 | 2021-12-31 | Crawford | Pennsylvania | 42039 | 15155 | 260 |
2026878 | 2026878 | 2021-12-18 | Adams | Pennsylvania | 42001 | 16003 | 260 |
1974881 | 1974881 | 2021-12-02 | Centre | Pennsylvania | 42027 | 22997 | 260 |
1393469 | 1393469 | 2021-06-06 | Mercer | Pennsylvania | 42085 | 9642 | 260 |
1390224 | 1390224 | 2021-06-05 | Mercer | Pennsylvania | 42085 | 9638 | 260 |
1101246 | 1101246 | 2021-03-08 | Lebanon | Pennsylvania | 42075 | 13023 | 260 |
1098000 | 1098000 | 2021-03-07 | Lebanon | Pennsylvania | 42075 | 13008 | 260 |
1094752 | 1094752 | 2021-03-06 | Lebanon | Pennsylvania | 42075 | 12975 | 260 |
1085040 | 1085040 | 2021-03-03 | Washington | Pennsylvania | 42125 | 13795 | 260 |
1055793 | 1055793 | 2021-02-22 | Fayette | Pennsylvania | 42051 | 10311 | 260 |
1052547 | 1052547 | 2021-02-21 | Fayette | Pennsylvania | 42051 | 10306 | 260 |
1049300 | 1049300 | 2021-02-20 | Fayette | Pennsylvania | 42051 | 10283 | 260 |
1046072 | 1046072 | 2021-02-19 | Monroe | Pennsylvania | 42089 | 9353 | 260 |
896741 | 896741 | 2021-01-04 | Beaver | Pennsylvania | 42007 | 8813 | 260 |
893495 | 893495 | 2021-01-03 | Beaver | Pennsylvania | 42007 | 8751 | 260 |
857828 | 857828 | 2020-12-23 | Lackawanna | Pennsylvania | 42069 | 7740 | 260 |
796195 | 796195 | 2020-12-04 | York | Pennsylvania | 42133 | 12777 | 260 |
792950 | 792950 | 2020-12-03 | York | Pennsylvania | 42133 | 12388 | 260 |
423584 | 423584 | 2020-08-11 | Allegheny | Pennsylvania | 42003 | 9008 | 260 |
183674 | 183674 | 2020-05-27 | Chester | Pennsylvania | 42029 | 2545 | 260 |
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);