ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 346 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 20
county 20
- Blair 26
- Centre 17
- Indiana 4
- Chester 2
- Erie 2
- Lancaster 2
- Lebanon 2
- Lehigh 2
- Northumberland 2
- Beaver 1
- Butler 1
- Cambria 1
- Cumberland 1
- Fayette 1
- Franklin 1
- Lawrence 1
- Lycoming 1
- Monroe 1
- Northampton 1
- Washington 1
state 1
- Pennsylvania · 70 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2374869 | 2374869 | 2022-04-04 | Centre | Pennsylvania | 42027 | 35105 | 346 |
2371617 | 2371617 | 2022-04-03 | Centre | Pennsylvania | 42027 | 35097 | 346 |
2368364 | 2368364 | 2022-04-02 | Centre | Pennsylvania | 42027 | 35097 | 346 |
2365111 | 2365111 | 2022-04-01 | Centre | Pennsylvania | 42027 | 35093 | 346 |
2361858 | 2361858 | 2022-03-31 | Centre | Pennsylvania | 42027 | 35087 | 346 |
2358604 | 2358604 | 2022-03-30 | Centre | Pennsylvania | 42027 | 35073 | 346 |
2355350 | 2355350 | 2022-03-29 | Centre | Pennsylvania | 42027 | 35063 | 346 |
2339086 | 2339086 | 2022-03-24 | Centre | Pennsylvania | 42027 | 35019 | 346 |
2335832 | 2335832 | 2022-03-23 | Centre | Pennsylvania | 42027 | 35011 | 346 |
2332578 | 2332578 | 2022-03-22 | Centre | Pennsylvania | 42027 | 34996 | 346 |
2329325 | 2329325 | 2022-03-21 | Centre | Pennsylvania | 42027 | 34992 | 346 |
2326073 | 2326073 | 2022-03-20 | Centre | Pennsylvania | 42027 | 34985 | 346 |
2322820 | 2322820 | 2022-03-19 | Centre | Pennsylvania | 42027 | 34984 | 346 |
2319566 | 2319566 | 2022-03-18 | Centre | Pennsylvania | 42027 | 34966 | 346 |
2316312 | 2316312 | 2022-03-17 | Centre | Pennsylvania | 42027 | 34956 | 346 |
2313059 | 2313059 | 2022-03-16 | Centre | Pennsylvania | 42027 | 34944 | 346 |
2309806 | 2309806 | 2022-03-15 | Centre | Pennsylvania | 42027 | 34928 | 346 |
2290312 | 2290312 | 2022-03-09 | Indiana | Pennsylvania | 42063 | 17284 | 346 |
2287060 | 2287060 | 2022-03-08 | Indiana | Pennsylvania | 42063 | 17269 | 346 |
2283808 | 2283808 | 2022-03-07 | Indiana | Pennsylvania | 42063 | 17259 | 346 |
2280556 | 2280556 | 2022-03-06 | Indiana | Pennsylvania | 42063 | 17250 | 346 |
2095175 | 2095175 | 2022-01-08 | Lawrence | Pennsylvania | 42073 | 15637 | 346 |
1919647 | 1919647 | 2021-11-15 | Lebanon | Pennsylvania | 42075 | 21818 | 346 |
1916397 | 1916397 | 2021-11-14 | Lebanon | Pennsylvania | 42075 | 21769 | 346 |
1838413 | 1838413 | 2021-10-21 | Lycoming | Pennsylvania | 42081 | 15852 | 346 |
1766954 | 1766954 | 2021-09-29 | Washington | Pennsylvania | 42125 | 22563 | 346 |
1763687 | 1763687 | 2021-09-28 | Monroe | Pennsylvania | 42089 | 18063 | 346 |
1744176 | 1744176 | 2021-09-22 | Fayette | Pennsylvania | 42051 | 15180 | 346 |
1698676 | 1698676 | 2021-09-08 | Blair | Pennsylvania | 42013 | 14341 | 346 |
1695428 | 1695428 | 2021-09-07 | Blair | Pennsylvania | 42013 | 14294 | 346 |
1692180 | 1692180 | 2021-09-06 | Blair | Pennsylvania | 42013 | 14271 | 346 |
1688931 | 1688931 | 2021-09-05 | Blair | Pennsylvania | 42013 | 14243 | 346 |
1685681 | 1685681 | 2021-09-04 | Blair | Pennsylvania | 42013 | 14214 | 346 |
1682430 | 1682430 | 2021-09-03 | Blair | Pennsylvania | 42013 | 14170 | 346 |
1679180 | 1679180 | 2021-09-02 | Blair | Pennsylvania | 42013 | 14126 | 346 |
1675932 | 1675932 | 2021-09-01 | Blair | Pennsylvania | 42013 | 14091 | 346 |
1672685 | 1672685 | 2021-08-31 | Blair | Pennsylvania | 42013 | 14064 | 346 |
1669437 | 1669437 | 2021-08-30 | Blair | Pennsylvania | 42013 | 14038 | 346 |
1666190 | 1666190 | 2021-08-29 | Blair | Pennsylvania | 42013 | 14014 | 346 |
1662942 | 1662942 | 2021-08-28 | Blair | Pennsylvania | 42013 | 13983 | 346 |
1659694 | 1659694 | 2021-08-27 | Blair | Pennsylvania | 42013 | 13945 | 346 |
1656445 | 1656445 | 2021-08-26 | Blair | Pennsylvania | 42013 | 13937 | 346 |
1653198 | 1653198 | 2021-08-25 | Blair | Pennsylvania | 42013 | 13913 | 346 |
1649951 | 1649951 | 2021-08-24 | Blair | Pennsylvania | 42013 | 13892 | 346 |
1646702 | 1646702 | 2021-08-23 | Blair | Pennsylvania | 42013 | 13876 | 346 |
1643453 | 1643453 | 2021-08-22 | Blair | Pennsylvania | 42013 | 13853 | 346 |
1640203 | 1640203 | 2021-08-21 | Blair | Pennsylvania | 42013 | 13834 | 346 |
1636953 | 1636953 | 2021-08-20 | Blair | Pennsylvania | 42013 | 13808 | 346 |
1633703 | 1633703 | 2021-08-19 | Blair | Pennsylvania | 42013 | 13779 | 346 |
1630456 | 1630456 | 2021-08-18 | Blair | Pennsylvania | 42013 | 13748 | 346 |
1627209 | 1627209 | 2021-08-17 | Blair | Pennsylvania | 42013 | 13739 | 346 |
1623962 | 1623962 | 2021-08-16 | Blair | Pennsylvania | 42013 | 13725 | 346 |
1620715 | 1620715 | 2021-08-15 | Blair | Pennsylvania | 42013 | 13720 | 346 |
1617467 | 1617467 | 2021-08-14 | Blair | Pennsylvania | 42013 | 13697 | 346 |
1270114 | 1270114 | 2021-04-29 | Northumberland | Pennsylvania | 42097 | 9205 | 346 |
1266867 | 1266867 | 2021-04-28 | Northumberland | Pennsylvania | 42097 | 9187 | 346 |
1218137 | 1218137 | 2021-04-13 | Franklin | Pennsylvania | 42055 | 14044 | 346 |
1065507 | 1065507 | 2021-02-25 | Beaver | Pennsylvania | 42007 | 12140 | 346 |
1013584 | 1013584 | 2021-02-09 | Butler | Pennsylvania | 42019 | 13215 | 346 |
994124 | 994124 | 2021-02-03 | Erie | Pennsylvania | 42049 | 15783 | 346 |
990878 | 990878 | 2021-02-02 | Erie | Pennsylvania | 42049 | 15684 | 346 |
948673 | 948673 | 2021-01-20 | Cambria | Pennsylvania | 42021 | 10293 | 346 |
919474 | 919474 | 2021-01-11 | Cumberland | Pennsylvania | 42041 | 11998 | 346 |
805911 | 805911 | 2020-12-07 | Northampton | Pennsylvania | 42095 | 10767 | 346 |
549664 | 549664 | 2020-09-19 | Lehigh | Pennsylvania | 42077 | 5469 | 346 |
546425 | 546425 | 2020-09-18 | Lehigh | Pennsylvania | 42077 | 5464 | 346 |
384974 | 384974 | 2020-07-30 | Chester | Pennsylvania | 42029 | 4836 | 346 |
381756 | 381756 | 2020-07-29 | Chester | Pennsylvania | 42029 | 4796 | 346 |
261037 | 261037 | 2020-06-21 | Lancaster | Pennsylvania | 42071 | 3999 | 346 |
257910 | 257910 | 2020-06-20 | Lancaster | Pennsylvania | 42071 | 3949 | 346 |
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);