ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
12 rows where deaths = 867 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
county 8
- Montgomery 3
- Chester 2
- Lehigh 2
- Allegheny 1
- Dauphin 1
- Delaware 1
- Westmoreland 1
- York 1
state 1
- Pennsylvania · 12 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2173230 | 2173230 | 2022-02-01 | Dauphin | Pennsylvania | 42043 | 56958 | 867 |
1831889 | 1831889 | 2021-10-19 | Chester | Pennsylvania | 42029 | 49843 | 867 |
1828640 | 1828640 | 2021-10-18 | Chester | Pennsylvania | 42029 | 49705 | 867 |
1812446 | 1812446 | 2021-10-13 | Westmoreland | Pennsylvania | 42129 | 42784 | 867 |
1718223 | 1718223 | 2021-09-14 | York | Pennsylvania | 42133 | 52906 | 867 |
1572016 | 1572016 | 2021-07-31 | Lehigh | Pennsylvania | 42077 | 40253 | 867 |
1568768 | 1568768 | 2021-07-30 | Lehigh | Pennsylvania | 42077 | 40253 | 867 |
857795 | 857795 | 2020-12-23 | Allegheny | Pennsylvania | 42003 | 48738 | 867 |
792906 | 792906 | 2020-12-03 | Delaware | Pennsylvania | 42045 | 21211 | 867 |
530251 | 530251 | 2020-09-13 | Montgomery | Pennsylvania | 42091 | 11578 | 867 |
527014 | 527014 | 2020-09-12 | Montgomery | Pennsylvania | 42091 | 11578 | 867 |
523778 | 523778 | 2020-09-11 | Montgomery | Pennsylvania | 42091 | 11537 | 867 |
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);