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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 42011 787
- 42017 787
- 42029 787
- 42041 787
- 42045 787
- 42069 787
- 42077 787
- 42079 787
- 42089 787
- 42091 787
- 42095 787
- 42101 787
- 42103 787
- 42125 787
- 42127 787
- 42133 787
- 42001 786
- 42003 786
- 42007 786
- 42071 786
- 42075 786
- 42129 786
- 42027 785
- 42049 785
- 42055 785
- 42105 785
- 42019 784
- 42093 784
- 42037 783
- 42043 783
- …
county >30
- Berks 787
- Bucks 787
- Chester 787
- Cumberland 787
- Delaware 787
- Lackawanna 787
- Lehigh 787
- Luzerne 787
- Monroe 787
- Montgomery 787
- Northampton 787
- Philadelphia 787
- Pike 787
- Washington 787
- Wayne 787
- York 787
- Adams 786
- Allegheny 786
- Beaver 786
- 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,341 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4241 | 4241 | 2020-03-18 | Berks | Pennsylvania | 42011 | 1 | 0 |
4242 | 4242 | 2020-03-18 | Bucks | Pennsylvania | 42017 | 10 | 0 |
4243 | 4243 | 2020-03-18 | Chester | Pennsylvania | 42029 | 9 | 0 |
4244 | 4244 | 2020-03-18 | Cumberland | Pennsylvania | 42041 | 10 | 0 |
4245 | 4245 | 2020-03-18 | Delaware | Pennsylvania | 42045 | 14 | 0 |
4246 | 4246 | 2020-03-18 | Lackawanna | Pennsylvania | 42069 | 2 | 0 |
4247 | 4247 | 2020-03-18 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
4248 | 4248 | 2020-03-18 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
4249 | 4249 | 2020-03-18 | Monroe | Pennsylvania | 42089 | 9 | 0 |
4250 | 4250 | 2020-03-18 | Montgomery | Pennsylvania | 42091 | 42 | 0 |
4251 | 4251 | 2020-03-18 | Northampton | Pennsylvania | 42095 | 1 | 1 |
4252 | 4252 | 2020-03-18 | Philadelphia | Pennsylvania | 42101 | 17 | 0 |
4253 | 4253 | 2020-03-18 | Pike | Pennsylvania | 42103 | 2 | 0 |
4254 | 4254 | 2020-03-18 | Washington | Pennsylvania | 42125 | 2 | 0 |
4255 | 4255 | 2020-03-18 | Wayne | Pennsylvania | 42127 | 1 | 0 |
4256 | 4256 | 2020-03-18 | York | Pennsylvania | 42133 | 2 | 0 |
4977 | 4977 | 2020-03-19 | Adams | Pennsylvania | 42001 | 2 | 0 |
4978 | 4978 | 2020-03-19 | Allegheny | Pennsylvania | 42003 | 18 | 0 |
4979 | 4979 | 2020-03-19 | Beaver | Pennsylvania | 42007 | 2 | 0 |
4980 | 4980 | 2020-03-19 | Berks | Pennsylvania | 42011 | 1 | 0 |
4981 | 4981 | 2020-03-19 | Bucks | Pennsylvania | 42017 | 10 | 0 |
4982 | 4982 | 2020-03-19 | Chester | Pennsylvania | 42029 | 10 | 0 |
4983 | 4983 | 2020-03-19 | Cumberland | Pennsylvania | 42041 | 11 | 0 |
4984 | 4984 | 2020-03-19 | Delaware | Pennsylvania | 42045 | 14 | 0 |
4985 | 4985 | 2020-03-19 | Lackawanna | Pennsylvania | 42069 | 3 | 0 |
4986 | 4986 | 2020-03-19 | Lancaster | Pennsylvania | 42071 | 2 | 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 |
4990 | 4990 | 2020-03-19 | Monroe | Pennsylvania | 42089 | 15 | 0 |
4991 | 4991 | 2020-03-19 | Montgomery | Pennsylvania | 42091 | 47 | 0 |
4992 | 4992 | 2020-03-19 | Northampton | Pennsylvania | 42095 | 5 | 1 |
4993 | 4993 | 2020-03-19 | Philadelphia | Pennsylvania | 42101 | 33 | 0 |
4994 | 4994 | 2020-03-19 | Pike | Pennsylvania | 42103 | 3 | 0 |
4995 | 4995 | 2020-03-19 | Washington | Pennsylvania | 42125 | 3 | 0 |
4996 | 4996 | 2020-03-19 | Wayne | Pennsylvania | 42127 | 1 | 0 |
4997 | 4997 | 2020-03-19 | Westmoreland | Pennsylvania | 42129 | 2 | 0 |
4998 | 4998 | 2020-03-19 | York | Pennsylvania | 42133 | 2 | 0 |
5846 | 5846 | 2020-03-20 | Adams | Pennsylvania | 42001 | 5 | 0 |
5847 | 5847 | 2020-03-20 | Allegheny | Pennsylvania | 42003 | 28 | 0 |
5848 | 5848 | 2020-03-20 | Beaver | Pennsylvania | 42007 | 3 | 0 |
5849 | 5849 | 2020-03-20 | Berks | Pennsylvania | 42011 | 5 | 0 |
5850 | 5850 | 2020-03-20 | Bucks | Pennsylvania | 42017 | 14 | 0 |
5851 | 5851 | 2020-03-20 | Centre | Pennsylvania | 42027 | 1 | 0 |
5852 | 5852 | 2020-03-20 | Chester | Pennsylvania | 42029 | 17 | 0 |
5853 | 5853 | 2020-03-20 | Cumberland | Pennsylvania | 42041 | 11 | 0 |
5854 | 5854 | 2020-03-20 | Delaware | Pennsylvania | 42045 | 23 | 0 |
5855 | 5855 | 2020-03-20 | Erie | Pennsylvania | 42049 | 1 | 0 |
5856 | 5856 | 2020-03-20 | Franklin | Pennsylvania | 42055 | 1 | 0 |
5857 | 5857 | 2020-03-20 | Lackawanna | Pennsylvania | 42069 | 5 | 0 |
5858 | 5858 | 2020-03-20 | Lancaster | Pennsylvania | 42071 | 2 | 0 |
5859 | 5859 | 2020-03-20 | Lebanon | Pennsylvania | 42075 | 1 | 0 |
5860 | 5860 | 2020-03-20 | Lehigh | Pennsylvania | 42077 | 2 | 0 |
5861 | 5861 | 2020-03-20 | Luzerne | Pennsylvania | 42079 | 2 | 0 |
5862 | 5862 | 2020-03-20 | Monroe | Pennsylvania | 42089 | 19 | 0 |
5863 | 5863 | 2020-03-20 | Montgomery | Pennsylvania | 42091 | 59 | 0 |
5864 | 5864 | 2020-03-20 | Northampton | Pennsylvania | 42095 | 10 | 1 |
5865 | 5865 | 2020-03-20 | Philadelphia | Pennsylvania | 42101 | 42 | 0 |
5866 | 5866 | 2020-03-20 | Pike | Pennsylvania | 42103 | 3 | 0 |
5867 | 5867 | 2020-03-20 | Potter | Pennsylvania | 42105 | 1 | 0 |
5868 | 5868 | 2020-03-20 | Washington | Pennsylvania | 42125 | 3 | 0 |
5869 | 5869 | 2020-03-20 | Wayne | Pennsylvania | 42127 | 1 | 0 |
5870 | 5870 | 2020-03-20 | Westmoreland | Pennsylvania | 42129 | 4 | 0 |
5871 | 5871 | 2020-03-20 | York | Pennsylvania | 42133 | 6 | 0 |
6848 | 6848 | 2020-03-21 | Adams | Pennsylvania | 42001 | 5 | 0 |
6849 | 6849 | 2020-03-21 | Allegheny | Pennsylvania | 42003 | 31 | 1 |
6850 | 6850 | 2020-03-21 | Beaver | Pennsylvania | 42007 | 3 | 0 |
6851 | 6851 | 2020-03-21 | Berks | Pennsylvania | 42011 | 7 | 0 |
6852 | 6852 | 2020-03-21 | Bucks | Pennsylvania | 42017 | 32 | 0 |
6853 | 6853 | 2020-03-21 | Butler | Pennsylvania | 42019 | 1 | 0 |
6854 | 6854 | 2020-03-21 | Centre | Pennsylvania | 42027 | 1 | 0 |
6855 | 6855 | 2020-03-21 | Chester | Pennsylvania | 42029 | 19 | 0 |
6856 | 6856 | 2020-03-21 | Cumberland | Pennsylvania | 42041 | 11 | 0 |
6857 | 6857 | 2020-03-21 | Delaware | Pennsylvania | 42045 | 33 | 0 |
6858 | 6858 | 2020-03-21 | Erie | Pennsylvania | 42049 | 1 | 0 |
6859 | 6859 | 2020-03-21 | Franklin | Pennsylvania | 42055 | 1 | 0 |
6860 | 6860 | 2020-03-21 | Lackawanna | Pennsylvania | 42069 | 6 | 0 |
6861 | 6861 | 2020-03-21 | Lancaster | Pennsylvania | 42071 | 4 | 0 |
6862 | 6862 | 2020-03-21 | Lebanon | Pennsylvania | 42075 | 2 | 0 |
6863 | 6863 | 2020-03-21 | Lehigh | Pennsylvania | 42077 | 13 | 0 |
6864 | 6864 | 2020-03-21 | Luzerne | Pennsylvania | 42079 | 6 | 0 |
6865 | 6865 | 2020-03-21 | Monroe | Pennsylvania | 42089 | 25 | 0 |
6866 | 6866 | 2020-03-21 | Montgomery | Pennsylvania | 42091 | 77 | 0 |
6867 | 6867 | 2020-03-21 | Montour | Pennsylvania | 42093 | 1 | 0 |
6868 | 6868 | 2020-03-21 | Northampton | Pennsylvania | 42095 | 17 | 1 |
6869 | 6869 | 2020-03-21 | Philadelphia | Pennsylvania | 42101 | 69 | 0 |
6870 | 6870 | 2020-03-21 | Pike | Pennsylvania | 42103 | 3 | 0 |
6871 | 6871 | 2020-03-21 | Potter | Pennsylvania | 42105 | 1 | 0 |
6872 | 6872 | 2020-03-21 | Washington | Pennsylvania | 42125 | 5 | 0 |
6873 | 6873 | 2020-03-21 | Wayne | Pennsylvania | 42127 | 1 | 0 |
6874 | 6874 | 2020-03-21 | Westmoreland | Pennsylvania | 42129 | 4 | 0 |
6875 | 6875 | 2020-03-21 | York | Pennsylvania | 42133 | 9 | 0 |
7963 | 7963 | 2020-03-22 | Adams | Pennsylvania | 42001 | 5 | 0 |
7964 | 7964 | 2020-03-22 | Allegheny | Pennsylvania | 42003 | 40 | 1 |
7965 | 7965 | 2020-03-22 | Beaver | Pennsylvania | 42007 | 3 | 0 |
7966 | 7966 | 2020-03-22 | Berks | Pennsylvania | 42011 | 13 | 0 |
7967 | 7967 | 2020-03-22 | Bucks | Pennsylvania | 42017 | 34 | 0 |
7968 | 7968 | 2020-03-22 | Butler | Pennsylvania | 42019 | 1 | 0 |
7969 | 7969 | 2020-03-22 | Centre | Pennsylvania | 42027 | 1 | 0 |
7970 | 7970 | 2020-03-22 | Chester | Pennsylvania | 42029 | 23 | 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);