ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where "date" is on date 2020-03-22 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adams 1
- Allegheny 1
- Beaver 1
- Berks 1
- Bucks 1
- Butler 1
- Centre 1
- Chester 1
- Columbia 1
- Cumberland 1
- Dauphin 1
- Delaware 1
- Erie 1
- Fayette 1
- Franklin 1
- Lackawanna 1
- Lancaster 1
- Lebanon 1
- Lehigh 1
- Luzerne 1
- Mercer 1
- Monroe 1
- Montgomery 1
- Montour 1
- Northampton 1
- Philadelphia 1
- Pike 1
- Potter 1
- Schuylkill 1
- Washington 1
- …
state 1
- Pennsylvania · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7963 | 7963 | 2020-03-22 | Adams | Pennsylvania | 42001 | 5 | 0 |
7964 | 7964 | 2020-03-22 | Allegheny | Pennsylvania | 42003 | 40 | 1 |
7965 | 7965 | 2020-03-22 | Beaver | Pennsylvania | 42007 | 3 | 0 |
7966 | 7966 | 2020-03-22 | Berks | Pennsylvania | 42011 | 13 | 0 |
7967 | 7967 | 2020-03-22 | Bucks | Pennsylvania | 42017 | 34 | 0 |
7968 | 7968 | 2020-03-22 | Butler | Pennsylvania | 42019 | 1 | 0 |
7969 | 7969 | 2020-03-22 | Centre | Pennsylvania | 42027 | 1 | 0 |
7970 | 7970 | 2020-03-22 | Chester | Pennsylvania | 42029 | 23 | 0 |
7971 | 7971 | 2020-03-22 | Columbia | Pennsylvania | 42037 | 1 | 0 |
7972 | 7972 | 2020-03-22 | Cumberland | Pennsylvania | 42041 | 11 | 0 |
7973 | 7973 | 2020-03-22 | Dauphin | Pennsylvania | 42043 | 1 | 0 |
7974 | 7974 | 2020-03-22 | Delaware | Pennsylvania | 42045 | 43 | 0 |
7975 | 7975 | 2020-03-22 | Erie | Pennsylvania | 42049 | 2 | 0 |
7976 | 7976 | 2020-03-22 | Fayette | Pennsylvania | 42051 | 1 | 0 |
7977 | 7977 | 2020-03-22 | Franklin | Pennsylvania | 42055 | 1 | 0 |
7978 | 7978 | 2020-03-22 | Lackawanna | Pennsylvania | 42069 | 6 | 0 |
7979 | 7979 | 2020-03-22 | Lancaster | Pennsylvania | 42071 | 5 | 0 |
7980 | 7980 | 2020-03-22 | Lebanon | Pennsylvania | 42075 | 3 | 0 |
7981 | 7981 | 2020-03-22 | Lehigh | Pennsylvania | 42077 | 19 | 0 |
7982 | 7982 | 2020-03-22 | Luzerne | Pennsylvania | 42079 | 7 | 0 |
7983 | 7983 | 2020-03-22 | Mercer | Pennsylvania | 42085 | 1 | 0 |
7984 | 7984 | 2020-03-22 | Monroe | Pennsylvania | 42089 | 31 | 0 |
7985 | 7985 | 2020-03-22 | Montgomery | Pennsylvania | 42091 | 110 | 1 |
7986 | 7986 | 2020-03-22 | Montour | Pennsylvania | 42093 | 1 | 0 |
7987 | 7987 | 2020-03-22 | Northampton | Pennsylvania | 42095 | 21 | 1 |
7988 | 7988 | 2020-03-22 | Philadelphia | Pennsylvania | 42101 | 91 | 0 |
7989 | 7989 | 2020-03-22 | Pike | Pennsylvania | 42103 | 3 | 0 |
7990 | 7990 | 2020-03-22 | Potter | Pennsylvania | 42105 | 1 | 0 |
7991 | 7991 | 2020-03-22 | Schuylkill | Pennsylvania | 42107 | 1 | 0 |
7992 | 7992 | 2020-03-22 | Washington | Pennsylvania | 42125 | 7 | 0 |
7993 | 7993 | 2020-03-22 | Wayne | Pennsylvania | 42127 | 2 | 0 |
7994 | 7994 | 2020-03-22 | Westmoreland | Pennsylvania | 42129 | 5 | 0 |
7995 | 7995 | 2020-03-22 | York | Pennsylvania | 42133 | 10 | 0 |
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);