ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where deaths = 444 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 13
county 13
- Lackawanna 5
- Erie 4
- Dauphin 2
- Lehigh 2
- Beaver 1
- Blair 1
- Cambria 1
- Chester 1
- Cumberland 1
- Fayette 1
- Franklin 1
- Lebanon 1
- Washington 1
state 1
- Pennsylvania · 22 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2143963 | 2143963 | 2022-01-23 | Lebanon | Pennsylvania | 42075 | 34285 | 444 |
1987874 | 1987874 | 2021-12-06 | Blair | Pennsylvania | 42013 | 21257 | 444 |
1981430 | 1981430 | 2021-12-04 | Washington | Pennsylvania | 42125 | 30790 | 444 |
1929384 | 1929384 | 2021-11-18 | Fayette | Pennsylvania | 42051 | 19543 | 444 |
1835151 | 1835151 | 2021-10-20 | Franklin | Pennsylvania | 42055 | 21328 | 444 |
1809136 | 1809136 | 2021-10-12 | Beaver | Pennsylvania | 42007 | 20724 | 444 |
1737677 | 1737677 | 2021-09-20 | Erie | Pennsylvania | 42049 | 24417 | 444 |
1734427 | 1734427 | 2021-09-19 | Erie | Pennsylvania | 42049 | 24328 | 444 |
1731177 | 1731177 | 2021-09-18 | Erie | Pennsylvania | 42049 | 24225 | 444 |
1727927 | 1727927 | 2021-09-17 | Erie | Pennsylvania | 42049 | 24091 | 444 |
1633707 | 1633707 | 2021-08-19 | Cambria | Pennsylvania | 42021 | 15174 | 444 |
1214896 | 1214896 | 2021-04-12 | Lackawanna | Pennsylvania | 42069 | 16406 | 444 |
1211649 | 1211649 | 2021-04-11 | Lackawanna | Pennsylvania | 42069 | 16375 | 444 |
1208400 | 1208400 | 2021-04-10 | Lackawanna | Pennsylvania | 42069 | 16329 | 444 |
1205152 | 1205152 | 2021-04-09 | Lackawanna | Pennsylvania | 42069 | 16245 | 444 |
1201904 | 1201904 | 2021-04-08 | Lackawanna | Pennsylvania | 42069 | 16174 | 444 |
994120 | 994120 | 2021-02-03 | Cumberland | Pennsylvania | 42041 | 14705 | 444 |
987629 | 987629 | 2021-02-01 | Dauphin | Pennsylvania | 42043 | 18614 | 444 |
984382 | 984382 | 2021-01-31 | Dauphin | Pennsylvania | 42043 | 18518 | 444 |
851342 | 851342 | 2020-12-21 | Lehigh | Pennsylvania | 42077 | 17668 | 444 |
848097 | 848097 | 2020-12-20 | Lehigh | Pennsylvania | 42077 | 17286 | 444 |
835091 | 835091 | 2020-12-16 | Chester | Pennsylvania | 42029 | 16696 | 444 |
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);