ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,441 rows where state = "Pennsylvania" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 42045 799
- 42127 799
- 42091 798
- 42089 796
- 42101 795
- 42017 794
- 42095 793
- 42103 793
- 42029 792
- 42041 792
- 42125 792
- 42003 791
- 42077 790
- 42079 790
- 42007 788
- 42001 787
- 42011 787
- 42069 787
- 42133 787
- 42071 786
- 42075 786
- 42129 786
- 42027 785
- 42049 785
- 42055 785
- 42105 785
- 42019 784
- 42093 784
- 42037 783
- 42043 783
- …
county >30
- Delaware 799
- Wayne 799
- Montgomery 798
- Monroe 796
- Philadelphia 795
- Bucks 794
- Northampton 793
- Pike 793
- Chester 792
- Cumberland 792
- Washington 792
- Allegheny 791
- Lehigh 790
- Luzerne 790
- Beaver 788
- Adams 787
- Berks 787
- Lackawanna 787
- York 787
- Lancaster 786
- Lebanon 786
- Westmoreland 786
- Centre 785
- Erie 785
- Franklin 785
- Potter 785
- Butler 784
- Montour 784
- Columbia 783
- Dauphin 783
- …
state 1
- Pennsylvania · 52,441 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
23342 | 23342 | 2020-03-31 | Unknown | Pennsylvania | 0 | 1 | |
635 | 635 | 2020-03-06 | Delaware | Pennsylvania | 42045 | 1 | 0 |
636 | 636 | 2020-03-06 | Wayne | Pennsylvania | 42127 | 1 | 0 |
726 | 726 | 2020-03-07 | Delaware | Pennsylvania | 42045 | 1 | 0 |
728 | 728 | 2020-03-07 | Wayne | Pennsylvania | 42127 | 1 | 0 |
835 | 835 | 2020-03-08 | Delaware | Pennsylvania | 42045 | 1 | 0 |
837 | 837 | 2020-03-08 | Wayne | Pennsylvania | 42127 | 1 | 0 |
963 | 963 | 2020-03-09 | Delaware | Pennsylvania | 42045 | 1 | 0 |
964 | 964 | 2020-03-09 | Monroe | Pennsylvania | 42089 | 1 | 0 |
966 | 966 | 2020-03-09 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1115 | 1115 | 2020-03-10 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1116 | 1116 | 2020-03-10 | Monroe | Pennsylvania | 42089 | 1 | 0 |
1118 | 1118 | 2020-03-10 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1119 | 1119 | 2020-03-10 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1309 | 1309 | 2020-03-11 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1312 | 1312 | 2020-03-11 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1313 | 1313 | 2020-03-11 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1553 | 1553 | 2020-03-12 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1556 | 1556 | 2020-03-12 | Northampton | Pennsylvania | 42095 | 1 | 0 |
1557 | 1557 | 2020-03-12 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1558 | 1558 | 2020-03-12 | Pike | Pennsylvania | 42103 | 1 | 0 |
1559 | 1559 | 2020-03-12 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1849 | 1849 | 2020-03-13 | Chester | Pennsylvania | 42029 | 1 | 0 |
1854 | 1854 | 2020-03-13 | Northampton | Pennsylvania | 42095 | 1 | 0 |
1856 | 1856 | 2020-03-13 | Pike | Pennsylvania | 42103 | 1 | 0 |
1857 | 1857 | 2020-03-13 | Washington | Pennsylvania | 42125 | 1 | 0 |
1858 | 1858 | 2020-03-13 | Wayne | Pennsylvania | 42127 | 1 | 0 |
2209 | 2209 | 2020-03-14 | Allegheny | Pennsylvania | 42003 | 1 | 0 |
2216 | 2216 | 2020-03-14 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2218 | 2218 | 2020-03-14 | Pike | Pennsylvania | 42103 | 1 | 0 |
2219 | 2219 | 2020-03-14 | Washington | Pennsylvania | 42125 | 1 | 0 |
2220 | 2220 | 2020-03-14 | Wayne | Pennsylvania | 42127 | 1 | 0 |
2634 | 2634 | 2020-03-15 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
2635 | 2635 | 2020-03-15 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
2638 | 2638 | 2020-03-15 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2640 | 2640 | 2020-03-15 | Pike | Pennsylvania | 42103 | 1 | 0 |
2641 | 2641 | 2020-03-15 | Washington | Pennsylvania | 42125 | 1 | 0 |
2642 | 2642 | 2020-03-15 | Wayne | Pennsylvania | 42127 | 1 | 0 |
3099 | 3099 | 2020-03-16 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
3100 | 3100 | 2020-03-16 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
3103 | 3103 | 2020-03-16 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3105 | 3105 | 2020-03-16 | Pike | Pennsylvania | 42103 | 1 | 0 |
3106 | 3106 | 2020-03-16 | Washington | Pennsylvania | 42125 | 1 | 0 |
3107 | 3107 | 2020-03-16 | Wayne | Pennsylvania | 42127 | 1 | 0 |
3624 | 3624 | 2020-03-17 | Beaver | Pennsylvania | 42007 | 1 | 0 |
3629 | 3629 | 2020-03-17 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
3630 | 3630 | 2020-03-17 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
3633 | 3633 | 2020-03-17 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3635 | 3635 | 2020-03-17 | Pike | Pennsylvania | 42103 | 1 | 0 |
3637 | 3637 | 2020-03-17 | Wayne | Pennsylvania | 42127 | 1 | 0 |
4238 | 4238 | 2020-03-18 | Adams | Pennsylvania | 42001 | 1 | 0 |
4241 | 4241 | 2020-03-18 | Berks | Pennsylvania | 42011 | 1 | 0 |
4247 | 4247 | 2020-03-18 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
4248 | 4248 | 2020-03-18 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
4251 | 4251 | 2020-03-18 | Northampton | Pennsylvania | 42095 | 1 | 1 |
4255 | 4255 | 2020-03-18 | Wayne | Pennsylvania | 42127 | 1 | 0 |
4980 | 4980 | 2020-03-19 | Berks | Pennsylvania | 42011 | 1 | 0 |
4987 | 4987 | 2020-03-19 | Lebanon | Pennsylvania | 42075 | 1 | 0 |
4988 | 4988 | 2020-03-19 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
4989 | 4989 | 2020-03-19 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
4996 | 4996 | 2020-03-19 | Wayne | Pennsylvania | 42127 | 1 | 0 |
5851 | 5851 | 2020-03-20 | Centre | Pennsylvania | 42027 | 1 | 0 |
5855 | 5855 | 2020-03-20 | Erie | Pennsylvania | 42049 | 1 | 0 |
5856 | 5856 | 2020-03-20 | Franklin | Pennsylvania | 42055 | 1 | 0 |
5859 | 5859 | 2020-03-20 | Lebanon | Pennsylvania | 42075 | 1 | 0 |
5867 | 5867 | 2020-03-20 | Potter | Pennsylvania | 42105 | 1 | 0 |
5869 | 5869 | 2020-03-20 | Wayne | Pennsylvania | 42127 | 1 | 0 |
6853 | 6853 | 2020-03-21 | Butler | Pennsylvania | 42019 | 1 | 0 |
6854 | 6854 | 2020-03-21 | Centre | Pennsylvania | 42027 | 1 | 0 |
6858 | 6858 | 2020-03-21 | Erie | Pennsylvania | 42049 | 1 | 0 |
6859 | 6859 | 2020-03-21 | Franklin | Pennsylvania | 42055 | 1 | 0 |
6867 | 6867 | 2020-03-21 | Montour | Pennsylvania | 42093 | 1 | 0 |
6871 | 6871 | 2020-03-21 | Potter | Pennsylvania | 42105 | 1 | 0 |
6873 | 6873 | 2020-03-21 | Wayne | Pennsylvania | 42127 | 1 | 0 |
7968 | 7968 | 2020-03-22 | Butler | Pennsylvania | 42019 | 1 | 0 |
7969 | 7969 | 2020-03-22 | Centre | Pennsylvania | 42027 | 1 | 0 |
7971 | 7971 | 2020-03-22 | Columbia | Pennsylvania | 42037 | 1 | 0 |
7973 | 7973 | 2020-03-22 | Dauphin | Pennsylvania | 42043 | 1 | 0 |
7976 | 7976 | 2020-03-22 | Fayette | Pennsylvania | 42051 | 1 | 0 |
7977 | 7977 | 2020-03-22 | Franklin | Pennsylvania | 42055 | 1 | 0 |
7983 | 7983 | 2020-03-22 | Mercer | Pennsylvania | 42085 | 1 | 0 |
7986 | 7986 | 2020-03-22 | Montour | Pennsylvania | 42093 | 1 | 0 |
7990 | 7990 | 2020-03-22 | Potter | Pennsylvania | 42105 | 1 | 0 |
7991 | 7991 | 2020-03-22 | Schuylkill | Pennsylvania | 42107 | 1 | 0 |
9179 | 9179 | 2020-03-23 | Cambria | Pennsylvania | 42021 | 1 | 0 |
9182 | 9182 | 2020-03-23 | Columbia | Pennsylvania | 42037 | 1 | 0 |
9184 | 9184 | 2020-03-23 | Dauphin | Pennsylvania | 42043 | 1 | 0 |
9187 | 9187 | 2020-03-23 | Fayette | Pennsylvania | 42051 | 1 | 0 |
9188 | 9188 | 2020-03-23 | Franklin | Pennsylvania | 42055 | 1 | 0 |
9194 | 9194 | 2020-03-23 | Mercer | Pennsylvania | 42085 | 1 | 0 |
9197 | 9197 | 2020-03-23 | Montour | Pennsylvania | 42093 | 1 | 0 |
9201 | 9201 | 2020-03-23 | Potter | Pennsylvania | 42105 | 1 | 0 |
10494 | 10494 | 2020-03-24 | Armstrong | Pennsylvania | 42005 | 1 | 0 |
10497 | 10497 | 2020-03-24 | Bradford | Pennsylvania | 42015 | 1 | 0 |
10500 | 10500 | 2020-03-24 | Cambria | Pennsylvania | 42021 | 1 | 0 |
10501 | 10501 | 2020-03-24 | Carbon | Pennsylvania | 42025 | 1 | 0 |
10504 | 10504 | 2020-03-24 | Clearfield | Pennsylvania | 42033 | 1 | 0 |
10505 | 10505 | 2020-03-24 | Columbia | Pennsylvania | 42037 | 1 | 0 |
10512 | 10512 | 2020-03-24 | Juniata | Pennsylvania | 42067 | 1 | 0 |
10525 | 10525 | 2020-03-24 | Potter | Pennsylvania | 42105 | 1 | 0 |
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);