ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 382 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 17
county 17
- Beaver 5
- Lehigh 5
- Berks 4
- Butler 3
- Allegheny 2
- Washington 2
- Blair 1
- Cambria 1
- Dauphin 1
- Delaware 1
- Franklin 1
- Lancaster 1
- Lebanon 1
- Lycoming 1
- Montgomery 1
- Northumberland 1
- Schuylkill 1
state 1
- Pennsylvania · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2039916 | 2039916 | 2021-12-22 | Lebanon | Pennsylvania | 42075 | 25688 | 382 |
1948902 | 1948902 | 2021-11-24 | Lycoming | Pennsylvania | 42081 | 18947 | 382 |
1857876 | 1857876 | 2021-10-27 | Blair | Pennsylvania | 42013 | 17304 | 382 |
1838435 | 1838435 | 2021-10-21 | Washington | Pennsylvania | 42125 | 24995 | 382 |
1835186 | 1835186 | 2021-10-20 | Washington | Pennsylvania | 42125 | 24825 | 382 |
1753946 | 1753946 | 2021-09-25 | Northumberland | Pennsylvania | 42097 | 11253 | 382 |
1685702 | 1685702 | 2021-09-04 | Franklin | Pennsylvania | 42055 | 17096 | 382 |
1354483 | 1354483 | 2021-05-25 | Beaver | Pennsylvania | 42007 | 15362 | 382 |
1351237 | 1351237 | 2021-05-24 | Beaver | Pennsylvania | 42007 | 15347 | 382 |
1347991 | 1347991 | 2021-05-23 | Beaver | Pennsylvania | 42007 | 15340 | 382 |
1344743 | 1344743 | 2021-05-22 | Beaver | Pennsylvania | 42007 | 15322 | 382 |
1341495 | 1341495 | 2021-05-21 | Beaver | Pennsylvania | 42007 | 15322 | 382 |
1172693 | 1172693 | 2021-03-30 | Schuylkill | Pennsylvania | 42107 | 12794 | 382 |
1146669 | 1146669 | 2021-03-22 | Butler | Pennsylvania | 42019 | 14730 | 382 |
1143422 | 1143422 | 2021-03-21 | Butler | Pennsylvania | 42019 | 14708 | 382 |
1140175 | 1140175 | 2021-03-20 | Butler | Pennsylvania | 42019 | 14684 | 382 |
1029812 | 1029812 | 2021-02-14 | Cambria | Pennsylvania | 42021 | 11317 | 382 |
932456 | 932456 | 2021-01-15 | Dauphin | Pennsylvania | 42043 | 16186 | 382 |
783188 | 783188 | 2020-11-30 | Lehigh | Pennsylvania | 42077 | 11512 | 382 |
779943 | 779943 | 2020-11-29 | Lehigh | Pennsylvania | 42077 | 11412 | 382 |
776697 | 776697 | 2020-11-28 | Lehigh | Pennsylvania | 42077 | 11279 | 382 |
773452 | 773452 | 2020-11-27 | Lehigh | Pennsylvania | 42077 | 10981 | 382 |
770207 | 770207 | 2020-11-26 | Lehigh | Pennsylvania | 42077 | 10666 | 382 |
588506 | 588506 | 2020-10-01 | Allegheny | Pennsylvania | 42003 | 12454 | 382 |
585266 | 585266 | 2020-09-30 | Allegheny | Pennsylvania | 42003 | 12348 | 382 |
501099 | 501099 | 2020-09-04 | Berks | Pennsylvania | 42011 | 6214 | 382 |
497865 | 497865 | 2020-09-03 | Berks | Pennsylvania | 42011 | 6174 | 382 |
494632 | 494632 | 2020-09-02 | Berks | Pennsylvania | 42011 | 6129 | 382 |
491398 | 491398 | 2020-09-01 | Berks | Pennsylvania | 42011 | 6095 | 382 |
320956 | 320956 | 2020-07-10 | Lancaster | Pennsylvania | 42071 | 4783 | 382 |
126364 | 126364 | 2020-05-08 | Delaware | Pennsylvania | 42045 | 4739 | 382 |
114584 | 114584 | 2020-05-04 | Montgomery | Pennsylvania | 42091 | 4645 | 382 |
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);