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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 42127 147
- 42045 146
- 42091 146
- 42089 144
- 42101 143
- 42017 141
- 42095 141
- 42103 141
- 42125 140
- 42029 139
- 42041 139
- 42003 138
- 42077 138
- 42079 138
- 42007 135
- 42069 135
- 42133 135
- 42001 134
- 42011 134
- 42071 134
- 42075 134
- 42129 134
- 42105 133
- 42027 132
- 42049 132
- 42055 132
- 42093 132
- 42019 131
- 42085 131
- 42107 131
- …
county >30
- Wayne 147
- Delaware 146
- Montgomery 146
- Monroe 144
- Philadelphia 143
- Bucks 141
- Northampton 141
- Pike 141
- Washington 140
- Chester 139
- Cumberland 139
- Allegheny 138
- Lehigh 138
- Luzerne 138
- Beaver 135
- Lackawanna 135
- York 135
- Adams 134
- Berks 134
- Lancaster 134
- Lebanon 134
- Westmoreland 134
- Potter 133
- Centre 132
- Erie 132
- Franklin 132
- Montour 132
- Butler 131
- Mercer 131
- Schuylkill 131
- …
state 1
- Pennsylvania · 8,724 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
384993 | 384993 | 2020-07-30 | Juniata | Pennsylvania | 42067 | 125 | 6 |
384994 | 384994 | 2020-07-30 | Lackawanna | Pennsylvania | 42069 | 1885 | 212 |
384995 | 384995 | 2020-07-30 | Lancaster | Pennsylvania | 42071 | 5488 | 406 |
384996 | 384996 | 2020-07-30 | Lawrence | Pennsylvania | 42073 | 324 | 11 |
384997 | 384997 | 2020-07-30 | Lebanon | Pennsylvania | 42075 | 1562 | 54 |
384998 | 384998 | 2020-07-30 | Lehigh | Pennsylvania | 42077 | 4795 | 335 |
384999 | 384999 | 2020-07-30 | Luzerne | Pennsylvania | 42079 | 3239 | 183 |
385000 | 385000 | 2020-07-30 | Lycoming | Pennsylvania | 42081 | 314 | 20 |
385001 | 385001 | 2020-07-30 | McKean | Pennsylvania | 42083 | 26 | 1 |
385002 | 385002 | 2020-07-30 | Mercer | Pennsylvania | 42085 | 318 | 9 |
385003 | 385003 | 2020-07-30 | Mifflin | Pennsylvania | 42087 | 98 | 1 |
385004 | 385004 | 2020-07-30 | Monroe | Pennsylvania | 42089 | 1573 | 123 |
385005 | 385005 | 2020-07-30 | Montgomery | Pennsylvania | 42091 | 9723 | 847 |
385006 | 385006 | 2020-07-30 | Montour | Pennsylvania | 42093 | 93 | 3 |
385007 | 385007 | 2020-07-30 | Northampton | Pennsylvania | 42095 | 3816 | 289 |
385008 | 385008 | 2020-07-30 | Northumberland | Pennsylvania | 42097 | 400 | 11 |
385009 | 385009 | 2020-07-30 | Perry | Pennsylvania | 42099 | 111 | 5 |
385010 | 385010 | 2020-07-30 | Philadelphia | Pennsylvania | 42101 | 30213 | 1691 |
385011 | 385011 | 2020-07-30 | Pike | Pennsylvania | 42103 | 524 | 21 |
385012 | 385012 | 2020-07-30 | Potter | Pennsylvania | 42105 | 20 | 0 |
385013 | 385013 | 2020-07-30 | Schuylkill | Pennsylvania | 42107 | 875 | 49 |
385014 | 385014 | 2020-07-30 | Snyder | Pennsylvania | 42109 | 92 | 2 |
385015 | 385015 | 2020-07-30 | Somerset | Pennsylvania | 42111 | 117 | 2 |
385016 | 385016 | 2020-07-30 | Sullivan | Pennsylvania | 42113 | 10 | 0 |
385017 | 385017 | 2020-07-30 | Susquehanna | Pennsylvania | 42115 | 208 | 26 |
385018 | 385018 | 2020-07-30 | Tioga | Pennsylvania | 42117 | 34 | 2 |
385019 | 385019 | 2020-07-30 | Union | Pennsylvania | 42119 | 135 | 2 |
385020 | 385020 | 2020-07-30 | Venango | Pennsylvania | 42121 | 60 | 0 |
385021 | 385021 | 2020-07-30 | Warren | Pennsylvania | 42123 | 15 | 1 |
385022 | 385022 | 2020-07-30 | Washington | Pennsylvania | 42125 | 723 | 11 |
385023 | 385023 | 2020-07-30 | Wayne | Pennsylvania | 42127 | 157 | 8 |
385024 | 385024 | 2020-07-30 | Westmoreland | Pennsylvania | 42129 | 1382 | 45 |
385025 | 385025 | 2020-07-30 | Wyoming | Pennsylvania | 42131 | 57 | 8 |
385026 | 385026 | 2020-07-30 | York | Pennsylvania | 42133 | 2243 | 85 |
381742 | 381742 | 2020-07-29 | Adams | Pennsylvania | 42001 | 454 | 18 |
381743 | 381743 | 2020-07-29 | Allegheny | Pennsylvania | 42003 | 7718 | 234 |
381744 | 381744 | 2020-07-29 | Armstrong | Pennsylvania | 42005 | 174 | 6 |
381745 | 381745 | 2020-07-29 | Beaver | Pennsylvania | 42007 | 1176 | 85 |
381746 | 381746 | 2020-07-29 | Bedford | Pennsylvania | 42009 | 124 | 4 |
381747 | 381747 | 2020-07-29 | Berks | Pennsylvania | 42011 | 5100 | 364 |
381748 | 381748 | 2020-07-29 | Blair | Pennsylvania | 42013 | 199 | 2 |
381749 | 381749 | 2020-07-29 | Bradford | Pennsylvania | 42015 | 80 | 3 |
381750 | 381750 | 2020-07-29 | Bucks | Pennsylvania | 42017 | 6796 | 574 |
381751 | 381751 | 2020-07-29 | Butler | Pennsylvania | 42019 | 586 | 15 |
381752 | 381752 | 2020-07-29 | Cambria | Pennsylvania | 42021 | 235 | 3 |
381753 | 381753 | 2020-07-29 | Cameron | Pennsylvania | 42023 | 5 | 0 |
381754 | 381754 | 2020-07-29 | Carbon | Pennsylvania | 42025 | 356 | 28 |
381755 | 381755 | 2020-07-29 | Centre | Pennsylvania | 42027 | 370 | 10 |
381756 | 381756 | 2020-07-29 | Chester | Pennsylvania | 42029 | 4796 | 346 |
381757 | 381757 | 2020-07-29 | Clarion | Pennsylvania | 42031 | 72 | 2 |
381758 | 381758 | 2020-07-29 | Clearfield | Pennsylvania | 42033 | 120 | 0 |
381759 | 381759 | 2020-07-29 | Clinton | Pennsylvania | 42035 | 112 | 5 |
381760 | 381760 | 2020-07-29 | Columbia | Pennsylvania | 42037 | 453 | 35 |
381761 | 381761 | 2020-07-29 | Crawford | Pennsylvania | 42039 | 120 | 1 |
381762 | 381762 | 2020-07-29 | Cumberland | Pennsylvania | 42041 | 1180 | 70 |
381763 | 381763 | 2020-07-29 | Dauphin | Pennsylvania | 42043 | 2604 | 155 |
381764 | 381764 | 2020-07-29 | Delaware | Pennsylvania | 42045 | 8596 | 725 |
381765 | 381765 | 2020-07-29 | Elk | Pennsylvania | 42047 | 42 | 2 |
381766 | 381766 | 2020-07-29 | Erie | Pennsylvania | 42049 | 891 | 15 |
381767 | 381767 | 2020-07-29 | Fayette | Pennsylvania | 42051 | 352 | 4 |
381768 | 381768 | 2020-07-29 | Forest | Pennsylvania | 42053 | 9 | 0 |
381769 | 381769 | 2020-07-29 | Franklin | Pennsylvania | 42055 | 1231 | 46 |
381770 | 381770 | 2020-07-29 | Fulton | Pennsylvania | 42057 | 22 | 2 |
381771 | 381771 | 2020-07-29 | Greene | Pennsylvania | 42059 | 103 | 0 |
381772 | 381772 | 2020-07-29 | Huntingdon | Pennsylvania | 42061 | 287 | 4 |
381773 | 381773 | 2020-07-29 | Indiana | Pennsylvania | 42063 | 241 | 6 |
381774 | 381774 | 2020-07-29 | Jefferson | Pennsylvania | 42065 | 57 | 1 |
381775 | 381775 | 2020-07-29 | Juniata | Pennsylvania | 42067 | 125 | 6 |
381776 | 381776 | 2020-07-29 | Lackawanna | Pennsylvania | 42069 | 1878 | 212 |
381777 | 381777 | 2020-07-29 | Lancaster | Pennsylvania | 42071 | 5414 | 405 |
381778 | 381778 | 2020-07-29 | Lawrence | Pennsylvania | 42073 | 319 | 11 |
381779 | 381779 | 2020-07-29 | Lebanon | Pennsylvania | 42075 | 1559 | 54 |
381780 | 381780 | 2020-07-29 | Lehigh | Pennsylvania | 42077 | 4775 | 335 |
381781 | 381781 | 2020-07-29 | Luzerne | Pennsylvania | 42079 | 3225 | 183 |
381782 | 381782 | 2020-07-29 | Lycoming | Pennsylvania | 42081 | 306 | 20 |
381783 | 381783 | 2020-07-29 | McKean | Pennsylvania | 42083 | 26 | 1 |
381784 | 381784 | 2020-07-29 | Mercer | Pennsylvania | 42085 | 308 | 9 |
381785 | 381785 | 2020-07-29 | Mifflin | Pennsylvania | 42087 | 93 | 1 |
381786 | 381786 | 2020-07-29 | Monroe | Pennsylvania | 42089 | 1570 | 123 |
381787 | 381787 | 2020-07-29 | Montgomery | Pennsylvania | 42091 | 9673 | 846 |
381788 | 381788 | 2020-07-29 | Montour | Pennsylvania | 42093 | 92 | 3 |
381789 | 381789 | 2020-07-29 | Northampton | Pennsylvania | 42095 | 3806 | 289 |
381790 | 381790 | 2020-07-29 | Northumberland | Pennsylvania | 42097 | 398 | 11 |
381791 | 381791 | 2020-07-29 | Perry | Pennsylvania | 42099 | 111 | 5 |
381792 | 381792 | 2020-07-29 | Philadelphia | Pennsylvania | 42101 | 30077 | 1680 |
381793 | 381793 | 2020-07-29 | Pike | Pennsylvania | 42103 | 524 | 21 |
381794 | 381794 | 2020-07-29 | Potter | Pennsylvania | 42105 | 20 | 0 |
381795 | 381795 | 2020-07-29 | Schuylkill | Pennsylvania | 42107 | 867 | 49 |
381796 | 381796 | 2020-07-29 | Snyder | Pennsylvania | 42109 | 92 | 2 |
381797 | 381797 | 2020-07-29 | Somerset | Pennsylvania | 42111 | 114 | 2 |
381798 | 381798 | 2020-07-29 | Sullivan | Pennsylvania | 42113 | 10 | 0 |
381799 | 381799 | 2020-07-29 | Susquehanna | Pennsylvania | 42115 | 206 | 26 |
381800 | 381800 | 2020-07-29 | Tioga | Pennsylvania | 42117 | 34 | 2 |
381801 | 381801 | 2020-07-29 | Union | Pennsylvania | 42119 | 129 | 2 |
381802 | 381802 | 2020-07-29 | Venango | Pennsylvania | 42121 | 60 | 0 |
381803 | 381803 | 2020-07-29 | Warren | Pennsylvania | 42123 | 15 | 1 |
381804 | 381804 | 2020-07-29 | Washington | Pennsylvania | 42125 | 710 | 10 |
381805 | 381805 | 2020-07-29 | Wayne | Pennsylvania | 42127 | 156 | 8 |
381806 | 381806 | 2020-07-29 | Westmoreland | Pennsylvania | 42129 | 1351 | 45 |
381807 | 381807 | 2020-07-29 | Wyoming | Pennsylvania | 42131 | 57 | 8 |
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);