ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 384 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 13
county 13
- Beaver 8
- Butler 4
- Chester 4
- Erie 3
- Northampton 2
- Cambria 1
- Fayette 1
- Franklin 1
- Lawrence 1
- Mercer 1
- Northumberland 1
- Schuylkill 1
- Washington 1
state 1
- Pennsylvania · 29 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2199269 | 2199269 | 2022-02-09 | Lawrence | Pennsylvania | 42073 | 18483 | 384 |
2004164 | 2004164 | 2021-12-11 | Mercer | Pennsylvania | 42085 | 16828 | 384 |
1841684 | 1841684 | 2021-10-22 | Washington | Pennsylvania | 42125 | 25057 | 384 |
1831900 | 1831900 | 2021-10-19 | Fayette | Pennsylvania | 42051 | 17196 | 384 |
1763691 | 1763691 | 2021-09-28 | Northumberland | Pennsylvania | 42097 | 11336 | 384 |
1698697 | 1698697 | 2021-09-08 | Franklin | Pennsylvania | 42055 | 17481 | 384 |
1403167 | 1403167 | 2021-06-09 | Beaver | Pennsylvania | 42007 | 15489 | 384 |
1399922 | 1399922 | 2021-06-08 | Beaver | Pennsylvania | 42007 | 15485 | 384 |
1396677 | 1396677 | 2021-06-07 | Beaver | Pennsylvania | 42007 | 15477 | 384 |
1393430 | 1393430 | 2021-06-06 | Beaver | Pennsylvania | 42007 | 15475 | 384 |
1390185 | 1390185 | 2021-06-05 | Beaver | Pennsylvania | 42007 | 15468 | 384 |
1386940 | 1386940 | 2021-06-04 | Beaver | Pennsylvania | 42007 | 15453 | 384 |
1383695 | 1383695 | 2021-06-03 | Beaver | Pennsylvania | 42007 | 15444 | 384 |
1380449 | 1380449 | 2021-06-02 | Beaver | Pennsylvania | 42007 | 15433 | 384 |
1198674 | 1198674 | 2021-04-07 | Schuylkill | Pennsylvania | 42107 | 13148 | 384 |
1169402 | 1169402 | 2021-03-29 | Butler | Pennsylvania | 42019 | 15108 | 384 |
1166154 | 1166154 | 2021-03-28 | Butler | Pennsylvania | 42019 | 15067 | 384 |
1162906 | 1162906 | 2021-03-27 | Butler | Pennsylvania | 42019 | 15028 | 384 |
1159657 | 1159657 | 2021-03-26 | Butler | Pennsylvania | 42019 | 14976 | 384 |
1110971 | 1110971 | 2021-03-11 | Erie | Pennsylvania | 42049 | 17991 | 384 |
1107725 | 1107725 | 2021-03-10 | Erie | Pennsylvania | 42049 | 17875 | 384 |
1104479 | 1104479 | 2021-03-09 | Erie | Pennsylvania | 42049 | 17696 | 384 |
1036303 | 1036303 | 2021-02-16 | Cambria | Pennsylvania | 42021 | 11357 | 384 |
851351 | 851351 | 2020-12-21 | Northampton | Pennsylvania | 42095 | 14443 | 384 |
848106 | 848106 | 2020-12-20 | Northampton | Pennsylvania | 42095 | 14123 | 384 |
737724 | 737724 | 2020-11-16 | Chester | Pennsylvania | 42029 | 9895 | 384 |
734480 | 734480 | 2020-11-15 | Chester | Pennsylvania | 42029 | 9774 | 384 |
731234 | 731234 | 2020-11-14 | Chester | Pennsylvania | 42029 | 9601 | 384 |
727990 | 727990 | 2020-11-13 | Chester | Pennsylvania | 42029 | 9440 | 384 |
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);