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
- 42045 225
- 42127 225
- 42091 224
- 42089 222
- 42101 221
- 42017 220
- 42095 219
- 42103 219
- 42029 218
- 42041 218
- 42125 218
- 42003 217
- 42077 216
- 42079 216
- 42007 214
- 42001 213
- 42011 213
- 42069 213
- 42133 213
- 42071 212
- 42075 212
- 42129 212
- 42027 211
- 42049 211
- 42055 211
- 42105 211
- 42019 210
- 42093 210
- 42037 209
- 42043 209
- …
county >30
- Delaware 225
- Wayne 225
- Montgomery 224
- Monroe 222
- Philadelphia 221
- Bucks 220
- Northampton 219
- Pike 219
- Chester 218
- Cumberland 218
- Washington 218
- Allegheny 217
- Lehigh 216
- Luzerne 216
- Beaver 214
- Adams 213
- Berks 213
- Lackawanna 213
- York 213
- Lancaster 212
- Lebanon 212
- Westmoreland 212
- Centre 211
- Erie 211
- Franklin 211
- Potter 211
- Butler 210
- Montour 210
- Columbia 209
- Dauphin 209
- …
state 1
- Pennsylvania · 13,983 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637146 | 637146 | 2020-10-16 | Adams | Pennsylvania | 42001 | 971 | 27 |
637147 | 637147 | 2020-10-16 | Allegheny | Pennsylvania | 42003 | 13821 | 403 |
637148 | 637148 | 2020-10-16 | Armstrong | Pennsylvania | 42005 | 549 | 19 |
637149 | 637149 | 2020-10-16 | Beaver | Pennsylvania | 42007 | 2117 | 136 |
637150 | 637150 | 2020-10-16 | Bedford | Pennsylvania | 42009 | 323 | 6 |
637151 | 637151 | 2020-10-16 | Berks | Pennsylvania | 42011 | 8102 | 411 |
637152 | 637152 | 2020-10-16 | Blair | Pennsylvania | 42013 | 980 | 23 |
637153 | 637153 | 2020-10-16 | Bradford | Pennsylvania | 42015 | 435 | 6 |
637154 | 637154 | 2020-10-16 | Bucks | Pennsylvania | 42017 | 9527 | 622 |
637155 | 637155 | 2020-10-16 | Butler | Pennsylvania | 42019 | 1365 | 26 |
637156 | 637156 | 2020-10-16 | Cambria | Pennsylvania | 42021 | 831 | 7 |
637157 | 637157 | 2020-10-16 | Cameron | Pennsylvania | 42023 | 8 | 0 |
637158 | 637158 | 2020-10-16 | Carbon | Pennsylvania | 42025 | 533 | 29 |
637159 | 637159 | 2020-10-16 | Centre | Pennsylvania | 42027 | 3650 | 15 |
637160 | 637160 | 2020-10-16 | Chester | Pennsylvania | 42029 | 7575 | 374 |
637161 | 637161 | 2020-10-16 | Clarion | Pennsylvania | 42031 | 174 | 3 |
637162 | 637162 | 2020-10-16 | Clearfield | Pennsylvania | 42033 | 385 | 7 |
637163 | 637163 | 2020-10-16 | Clinton | Pennsylvania | 42035 | 235 | 6 |
637164 | 637164 | 2020-10-16 | Columbia | Pennsylvania | 42037 | 1015 | 39 |
637165 | 637165 | 2020-10-16 | Crawford | Pennsylvania | 42039 | 374 | 3 |
637166 | 637166 | 2020-10-16 | Cumberland | Pennsylvania | 42041 | 2195 | 78 |
637167 | 637167 | 2020-10-16 | Dauphin | Pennsylvania | 42043 | 4340 | 185 |
637168 | 637168 | 2020-10-16 | Delaware | Pennsylvania | 42045 | 12430 | 804 |
637169 | 637169 | 2020-10-16 | Elk | Pennsylvania | 42047 | 99 | 2 |
637170 | 637170 | 2020-10-16 | Erie | Pennsylvania | 42049 | 1844 | 48 |
637171 | 637171 | 2020-10-16 | Fayette | Pennsylvania | 42051 | 911 | 10 |
637172 | 637172 | 2020-10-16 | Forest | Pennsylvania | 42053 | 17 | 1 |
637173 | 637173 | 2020-10-16 | Franklin | Pennsylvania | 42055 | 1975 | 53 |
637174 | 637174 | 2020-10-16 | Fulton | Pennsylvania | 42057 | 62 | 2 |
637175 | 637175 | 2020-10-16 | Greene | Pennsylvania | 42059 | 209 | 1 |
637176 | 637176 | 2020-10-16 | Huntingdon | Pennsylvania | 42061 | 640 | 8 |
637177 | 637177 | 2020-10-16 | Indiana | Pennsylvania | 42063 | 928 | 14 |
637178 | 637178 | 2020-10-16 | Jefferson | Pennsylvania | 42065 | 143 | 3 |
637179 | 637179 | 2020-10-16 | Juniata | Pennsylvania | 42067 | 207 | 8 |
637180 | 637180 | 2020-10-16 | Lackawanna | Pennsylvania | 42069 | 3197 | 217 |
637181 | 637181 | 2020-10-16 | Lancaster | Pennsylvania | 42071 | 8812 | 467 |
637182 | 637182 | 2020-10-16 | Lawrence | Pennsylvania | 42073 | 685 | 24 |
637183 | 637183 | 2020-10-16 | Lebanon | Pennsylvania | 42075 | 2495 | 65 |
637184 | 637184 | 2020-10-16 | Lehigh | Pennsylvania | 42077 | 6078 | 361 |
637185 | 637185 | 2020-10-16 | Luzerne | Pennsylvania | 42079 | 4594 | 190 |
637186 | 637186 | 2020-10-16 | Lycoming | Pennsylvania | 42081 | 866 | 29 |
637187 | 637187 | 2020-10-16 | McKean | Pennsylvania | 42083 | 90 | 2 |
637188 | 637188 | 2020-10-16 | Mercer | Pennsylvania | 42085 | 867 | 25 |
637189 | 637189 | 2020-10-16 | Mifflin | Pennsylvania | 42087 | 301 | 3 |
637190 | 637190 | 2020-10-16 | Monroe | Pennsylvania | 42089 | 1904 | 134 |
637191 | 637191 | 2020-10-16 | Montgomery | Pennsylvania | 42091 | 13050 | 889 |
637192 | 637192 | 2020-10-16 | Montour | Pennsylvania | 42093 | 261 | 7 |
637193 | 637193 | 2020-10-16 | Northampton | Pennsylvania | 42095 | 4972 | 309 |
637194 | 637194 | 2020-10-16 | Northumberland | Pennsylvania | 42097 | 1317 | 96 |
637195 | 637195 | 2020-10-16 | Perry | Pennsylvania | 42099 | 300 | 6 |
637196 | 637196 | 2020-10-16 | Philadelphia | Pennsylvania | 42101 | 40179 | 1865 |
637197 | 637197 | 2020-10-16 | Pike | Pennsylvania | 42103 | 609 | 23 |
637198 | 637198 | 2020-10-16 | Potter | Pennsylvania | 42105 | 38 | 1 |
637199 | 637199 | 2020-10-16 | Schuylkill | Pennsylvania | 42107 | 1511 | 71 |
637200 | 637200 | 2020-10-16 | Snyder | Pennsylvania | 42109 | 438 | 12 |
637201 | 637201 | 2020-10-16 | Somerset | Pennsylvania | 42111 | 308 | 3 |
637202 | 637202 | 2020-10-16 | Sullivan | Pennsylvania | 42113 | 15 | 1 |
637203 | 637203 | 2020-10-16 | Susquehanna | Pennsylvania | 42115 | 363 | 28 |
637204 | 637204 | 2020-10-16 | Tioga | Pennsylvania | 42117 | 133 | 3 |
637205 | 637205 | 2020-10-16 | Union | Pennsylvania | 42119 | 634 | 7 |
637206 | 637206 | 2020-10-16 | Venango | Pennsylvania | 42121 | 154 | 1 |
637207 | 637207 | 2020-10-16 | Warren | Pennsylvania | 42123 | 59 | 1 |
637208 | 637208 | 2020-10-16 | Washington | Pennsylvania | 42125 | 1594 | 32 |
637209 | 637209 | 2020-10-16 | Wayne | Pennsylvania | 42127 | 277 | 12 |
637210 | 637210 | 2020-10-16 | Westmoreland | Pennsylvania | 42129 | 3310 | 66 |
637211 | 637211 | 2020-10-16 | Wyoming | Pennsylvania | 42131 | 96 | 8 |
637212 | 637212 | 2020-10-16 | York | Pennsylvania | 42133 | 5708 | 187 |
633900 | 633900 | 2020-10-15 | Adams | Pennsylvania | 42001 | 962 | 27 |
633901 | 633901 | 2020-10-15 | Allegheny | Pennsylvania | 42003 | 13672 | 397 |
633902 | 633902 | 2020-10-15 | Armstrong | Pennsylvania | 42005 | 539 | 19 |
633903 | 633903 | 2020-10-15 | Beaver | Pennsylvania | 42007 | 2102 | 136 |
633904 | 633904 | 2020-10-15 | Bedford | Pennsylvania | 42009 | 315 | 6 |
633905 | 633905 | 2020-10-15 | Berks | Pennsylvania | 42011 | 8035 | 410 |
633906 | 633906 | 2020-10-15 | Blair | Pennsylvania | 42013 | 950 | 23 |
633907 | 633907 | 2020-10-15 | Bradford | Pennsylvania | 42015 | 415 | 6 |
633908 | 633908 | 2020-10-15 | Bucks | Pennsylvania | 42017 | 9485 | 622 |
633909 | 633909 | 2020-10-15 | Butler | Pennsylvania | 42019 | 1346 | 25 |
633910 | 633910 | 2020-10-15 | Cambria | Pennsylvania | 42021 | 801 | 7 |
633911 | 633911 | 2020-10-15 | Cameron | Pennsylvania | 42023 | 8 | 0 |
633912 | 633912 | 2020-10-15 | Carbon | Pennsylvania | 42025 | 526 | 29 |
633913 | 633913 | 2020-10-15 | Centre | Pennsylvania | 42027 | 3614 | 14 |
633914 | 633914 | 2020-10-15 | Chester | Pennsylvania | 42029 | 7534 | 375 |
633915 | 633915 | 2020-10-15 | Clarion | Pennsylvania | 42031 | 171 | 3 |
633916 | 633916 | 2020-10-15 | Clearfield | Pennsylvania | 42033 | 380 | 7 |
633917 | 633917 | 2020-10-15 | Clinton | Pennsylvania | 42035 | 233 | 6 |
633918 | 633918 | 2020-10-15 | Columbia | Pennsylvania | 42037 | 1013 | 39 |
633919 | 633919 | 2020-10-15 | Crawford | Pennsylvania | 42039 | 366 | 3 |
633920 | 633920 | 2020-10-15 | Cumberland | Pennsylvania | 42041 | 2174 | 77 |
633921 | 633921 | 2020-10-15 | Dauphin | Pennsylvania | 42043 | 4290 | 185 |
633922 | 633922 | 2020-10-15 | Delaware | Pennsylvania | 42045 | 12365 | 800 |
633923 | 633923 | 2020-10-15 | Elk | Pennsylvania | 42047 | 93 | 2 |
633924 | 633924 | 2020-10-15 | Erie | Pennsylvania | 42049 | 1835 | 48 |
633925 | 633925 | 2020-10-15 | Fayette | Pennsylvania | 42051 | 899 | 10 |
633926 | 633926 | 2020-10-15 | Forest | Pennsylvania | 42053 | 17 | 1 |
633927 | 633927 | 2020-10-15 | Franklin | Pennsylvania | 42055 | 1957 | 53 |
633928 | 633928 | 2020-10-15 | Fulton | Pennsylvania | 42057 | 62 | 2 |
633929 | 633929 | 2020-10-15 | Greene | Pennsylvania | 42059 | 208 | 1 |
633930 | 633930 | 2020-10-15 | Huntingdon | Pennsylvania | 42061 | 623 | 8 |
633931 | 633931 | 2020-10-15 | Indiana | Pennsylvania | 42063 | 906 | 14 |
633932 | 633932 | 2020-10-15 | Jefferson | Pennsylvania | 42065 | 141 | 3 |
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);