ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 326 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 17
county 17
- Lawrence 6
- Franklin 5
- Centre 4
- Blair 3
- Armstrong 2
- Indiana 2
- Monroe 2
- Northumberland 2
- Adams 1
- Beaver 1
- Dauphin 1
- Delaware 1
- Lehigh 1
- Lycoming 1
- Northampton 1
- Schuylkill 1
- Westmoreland 1
state 1
- Pennsylvania · 35 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2222001 | 2222001 | 2022-02-16 | Armstrong | Pennsylvania | 42005 | 14974 | 326 |
2218750 | 2218750 | 2022-02-15 | Armstrong | Pennsylvania | 42005 | 14960 | 326 |
2189484 | 2189484 | 2022-02-06 | Centre | Pennsylvania | 42027 | 33859 | 326 |
2186231 | 2186231 | 2022-02-05 | Centre | Pennsylvania | 42027 | 33814 | 326 |
2182979 | 2182979 | 2022-02-04 | Centre | Pennsylvania | 42027 | 33689 | 326 |
2179727 | 2179727 | 2022-02-03 | Centre | Pennsylvania | 42027 | 33604 | 326 |
2179745 | 2179745 | 2022-02-03 | Indiana | Pennsylvania | 42063 | 16409 | 326 |
2176494 | 2176494 | 2022-02-02 | Indiana | Pennsylvania | 42063 | 16318 | 326 |
2173209 | 2173209 | 2022-02-01 | Adams | Pennsylvania | 42001 | 23750 | 326 |
2056163 | 2056163 | 2021-12-27 | Lawrence | Pennsylvania | 42073 | 14180 | 326 |
2052914 | 2052914 | 2021-12-26 | Lawrence | Pennsylvania | 42073 | 14154 | 326 |
2049664 | 2049664 | 2021-12-25 | Lawrence | Pennsylvania | 42073 | 14136 | 326 |
2046414 | 2046414 | 2021-12-24 | Lawrence | Pennsylvania | 42073 | 14082 | 326 |
2043164 | 2043164 | 2021-12-23 | Lawrence | Pennsylvania | 42073 | 14009 | 326 |
2039915 | 2039915 | 2021-12-22 | Lawrence | Pennsylvania | 42073 | 13957 | 326 |
1789677 | 1789677 | 2021-10-06 | Lycoming | Pennsylvania | 42081 | 14873 | 326 |
1662980 | 1662980 | 2021-08-28 | Monroe | Pennsylvania | 42089 | 16021 | 326 |
1659732 | 1659732 | 2021-08-27 | Monroe | Pennsylvania | 42089 | 15978 | 326 |
1296044 | 1296044 | 2021-05-07 | Blair | Pennsylvania | 42013 | 12826 | 326 |
1292798 | 1292798 | 2021-05-06 | Blair | Pennsylvania | 42013 | 12777 | 326 |
1289552 | 1289552 | 2021-05-05 | Blair | Pennsylvania | 42013 | 12743 | 326 |
1107749 | 1107749 | 2021-03-10 | Northumberland | Pennsylvania | 42097 | 8132 | 326 |
1104503 | 1104503 | 2021-03-09 | Northumberland | Pennsylvania | 42097 | 8114 | 326 |
1101236 | 1101236 | 2021-03-08 | Franklin | Pennsylvania | 42055 | 12688 | 326 |
1097990 | 1097990 | 2021-03-07 | Franklin | Pennsylvania | 42055 | 12679 | 326 |
1094742 | 1094742 | 2021-03-06 | Franklin | Pennsylvania | 42055 | 12662 | 326 |
1091496 | 1091496 | 2021-03-05 | Franklin | Pennsylvania | 42055 | 12645 | 326 |
1088250 | 1088250 | 2021-03-04 | Franklin | Pennsylvania | 42055 | 12620 | 326 |
997349 | 997349 | 2021-02-04 | Beaver | Pennsylvania | 42007 | 11181 | 326 |
971431 | 971431 | 2021-01-27 | Schuylkill | Pennsylvania | 42107 | 10925 | 326 |
900004 | 900004 | 2021-01-05 | Dauphin | Pennsylvania | 42043 | 14540 | 326 |
838387 | 838387 | 2020-12-17 | Westmoreland | Pennsylvania | 42129 | 15545 | 326 |
750742 | 750742 | 2020-11-20 | Northampton | Pennsylvania | 42095 | 7472 | 326 |
327324 | 327324 | 2020-07-12 | Lehigh | Pennsylvania | 42077 | 4430 | 326 |
120404 | 120404 | 2020-05-06 | Delaware | Pennsylvania | 42045 | 4430 | 326 |
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);