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 313
- 42127 313
- 42091 312
- 42089 310
- 42101 309
- 42017 308
- 42095 307
- 42103 307
- 42029 306
- 42041 306
- 42125 306
- 42003 305
- 42077 304
- 42079 304
- 42007 302
- 42001 301
- 42011 301
- 42069 301
- 42133 301
- 42071 300
- 42075 300
- 42129 300
- 42027 299
- 42049 299
- 42055 299
- 42105 299
- 42019 298
- 42093 298
- 42037 297
- 42043 297
- …
county >30
- Delaware 313
- Wayne 313
- Montgomery 312
- Monroe 310
- Philadelphia 309
- Bucks 308
- Northampton 307
- Pike 307
- Chester 306
- Cumberland 306
- Washington 306
- Allegheny 305
- Lehigh 304
- Luzerne 304
- Beaver 302
- Adams 301
- Berks 301
- Lackawanna 301
- York 301
- Lancaster 300
- Lebanon 300
- Westmoreland 300
- Centre 299
- Erie 299
- Franklin 299
- Potter 299
- Butler 298
- Montour 298
- Columbia 297
- Dauphin 297
- …
state 1
- Pennsylvania · 19,879 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922699 | 922699 | 2021-01-12 | Adams | Pennsylvania | 42001 | 5434 | 115 |
922700 | 922700 | 2021-01-12 | Allegheny | Pennsylvania | 42003 | 61769 | 1208 |
922701 | 922701 | 2021-01-12 | Armstrong | Pennsylvania | 42005 | 4052 | 84 |
922702 | 922702 | 2021-01-12 | Beaver | Pennsylvania | 42007 | 9749 | 281 |
922703 | 922703 | 2021-01-12 | Bedford | Pennsylvania | 42009 | 3272 | 100 |
922704 | 922704 | 2021-01-12 | Berks | Pennsylvania | 42011 | 27070 | 632 |
922705 | 922705 | 2021-01-12 | Blair | Pennsylvania | 42013 | 8925 | 194 |
922706 | 922706 | 2021-01-12 | Bradford | Pennsylvania | 42015 | 3449 | 60 |
922707 | 922707 | 2021-01-12 | Bucks | Pennsylvania | 42017 | 34847 | 945 |
922708 | 922708 | 2021-01-12 | Butler | Pennsylvania | 42019 | 11056 | 256 |
922709 | 922709 | 2021-01-12 | Cambria | Pennsylvania | 42021 | 9760 | 293 |
922710 | 922710 | 2021-01-12 | Cameron | Pennsylvania | 42023 | 194 | 5 |
922711 | 922711 | 2021-01-12 | Carbon | Pennsylvania | 42025 | 3553 | 97 |
922712 | 922712 | 2021-01-12 | Centre | Pennsylvania | 42027 | 9840 | 158 |
922713 | 922713 | 2021-01-12 | Chester | Pennsylvania | 42029 | 23631 | 587 |
922714 | 922714 | 2021-01-12 | Clarion | Pennsylvania | 42031 | 2253 | 53 |
922715 | 922715 | 2021-01-12 | Clearfield | Pennsylvania | 42033 | 4883 | 59 |
922716 | 922716 | 2021-01-12 | Clinton | Pennsylvania | 42035 | 2248 | 34 |
922717 | 922717 | 2021-01-12 | Columbia | Pennsylvania | 42037 | 3474 | 91 |
922718 | 922718 | 2021-01-12 | Crawford | Pennsylvania | 42039 | 5397 | 104 |
922719 | 922719 | 2021-01-12 | Cumberland | Pennsylvania | 42041 | 12081 | 352 |
922720 | 922720 | 2021-01-12 | Dauphin | Pennsylvania | 42043 | 15809 | 365 |
922721 | 922721 | 2021-01-12 | Delaware | Pennsylvania | 42045 | 33132 | 1024 |
922722 | 922722 | 2021-01-12 | Elk | Pennsylvania | 42047 | 1712 | 23 |
922723 | 922723 | 2021-01-12 | Erie | Pennsylvania | 42049 | 13462 | 266 |
922724 | 922724 | 2021-01-12 | Fayette | Pennsylvania | 42051 | 8590 | 152 |
922725 | 922725 | 2021-01-12 | Forest | Pennsylvania | 42053 | 430 | 8 |
922726 | 922726 | 2021-01-12 | Franklin | Pennsylvania | 42055 | 10180 | 261 |
922727 | 922727 | 2021-01-12 | Fulton | Pennsylvania | 42057 | 878 | 12 |
922728 | 922728 | 2021-01-12 | Greene | Pennsylvania | 42059 | 2050 | 23 |
922729 | 922729 | 2021-01-12 | Huntingdon | Pennsylvania | 42061 | 3490 | 93 |
922730 | 922730 | 2021-01-12 | Indiana | Pennsylvania | 42063 | 4386 | 133 |
922731 | 922731 | 2021-01-12 | Jefferson | Pennsylvania | 42065 | 2171 | 55 |
922732 | 922732 | 2021-01-12 | Juniata | Pennsylvania | 42067 | 1515 | 65 |
922733 | 922733 | 2021-01-12 | Lackawanna | Pennsylvania | 42069 | 10462 | 288 |
922734 | 922734 | 2021-01-12 | Lancaster | Pennsylvania | 42071 | 32231 | 800 |
922735 | 922735 | 2021-01-12 | Lawrence | Pennsylvania | 42073 | 4871 | 140 |
922736 | 922736 | 2021-01-12 | Lebanon | Pennsylvania | 42075 | 10248 | 176 |
922737 | 922737 | 2021-01-12 | Lehigh | Pennsylvania | 42077 | 24010 | 564 |
922738 | 922738 | 2021-01-12 | Luzerne | Pennsylvania | 42079 | 19723 | 506 |
922739 | 922739 | 2021-01-12 | Lycoming | Pennsylvania | 42081 | 7026 | 160 |
922740 | 922740 | 2021-01-12 | McKean | Pennsylvania | 42083 | 2118 | 37 |
922741 | 922741 | 2021-01-12 | Mercer | Pennsylvania | 42085 | 6720 | 174 |
922742 | 922742 | 2021-01-12 | Mifflin | Pennsylvania | 42087 | 3824 | 131 |
922743 | 922743 | 2021-01-12 | Monroe | Pennsylvania | 42089 | 7244 | 218 |
922744 | 922744 | 2021-01-12 | Montgomery | Pennsylvania | 42091 | 41651 | 1239 |
922745 | 922745 | 2021-01-12 | Montour | Pennsylvania | 42093 | 1407 | 33 |
922746 | 922746 | 2021-01-12 | Northampton | Pennsylvania | 42095 | 19508 | 485 |
922747 | 922747 | 2021-01-12 | Northumberland | Pennsylvania | 42097 | 5855 | 254 |
922748 | 922748 | 2021-01-12 | Perry | Pennsylvania | 42099 | 2067 | 53 |
922749 | 922749 | 2021-01-12 | Philadelphia | Pennsylvania | 42101 | 100910 | 2645 |
922750 | 922750 | 2021-01-12 | Pike | Pennsylvania | 42103 | 1756 | 36 |
922751 | 922751 | 2021-01-12 | Potter | Pennsylvania | 42105 | 716 | 16 |
922752 | 922752 | 2021-01-12 | Schuylkill | Pennsylvania | 42107 | 9603 | 275 |
922753 | 922753 | 2021-01-12 | Snyder | Pennsylvania | 42109 | 2196 | 53 |
922754 | 922754 | 2021-01-12 | Somerset | Pennsylvania | 42111 | 5702 | 113 |
922755 | 922755 | 2021-01-12 | Sullivan | Pennsylvania | 42113 | 188 | 3 |
922756 | 922756 | 2021-01-12 | Susquehanna | Pennsylvania | 42115 | 1227 | 41 |
922757 | 922757 | 2021-01-12 | Tioga | Pennsylvania | 42117 | 2103 | 77 |
922758 | 922758 | 2021-01-12 | Union | Pennsylvania | 42119 | 3452 | 53 |
922759 | 922759 | 2021-01-12 | Venango | Pennsylvania | 42121 | 2780 | 57 |
922760 | 922760 | 2021-01-12 | Warren | Pennsylvania | 42123 | 1787 | 56 |
922761 | 922761 | 2021-01-12 | Washington | Pennsylvania | 42125 | 10648 | 164 |
922762 | 922762 | 2021-01-12 | Wayne | Pennsylvania | 42127 | 2281 | 28 |
922763 | 922763 | 2021-01-12 | Westmoreland | Pennsylvania | 42129 | 22233 | 491 |
922764 | 922764 | 2021-01-12 | Wyoming | Pennsylvania | 42131 | 918 | 32 |
922765 | 922765 | 2021-01-12 | York | Pennsylvania | 42133 | 27005 | 505 |
919454 | 919454 | 2021-01-11 | Adams | Pennsylvania | 42001 | 5401 | 114 |
919455 | 919455 | 2021-01-11 | Allegheny | Pennsylvania | 42003 | 61075 | 1192 |
919456 | 919456 | 2021-01-11 | Armstrong | Pennsylvania | 42005 | 3997 | 84 |
919457 | 919457 | 2021-01-11 | Beaver | Pennsylvania | 42007 | 9621 | 276 |
919458 | 919458 | 2021-01-11 | Bedford | Pennsylvania | 42009 | 3233 | 100 |
919459 | 919459 | 2021-01-11 | Berks | Pennsylvania | 42011 | 26732 | 629 |
919460 | 919460 | 2021-01-11 | Blair | Pennsylvania | 42013 | 8862 | 192 |
919461 | 919461 | 2021-01-11 | Bradford | Pennsylvania | 42015 | 3414 | 60 |
919462 | 919462 | 2021-01-11 | Bucks | Pennsylvania | 42017 | 34438 | 942 |
919463 | 919463 | 2021-01-11 | Butler | Pennsylvania | 42019 | 10937 | 252 |
919464 | 919464 | 2021-01-11 | Cambria | Pennsylvania | 42021 | 9673 | 291 |
919465 | 919465 | 2021-01-11 | Cameron | Pennsylvania | 42023 | 187 | 4 |
919466 | 919466 | 2021-01-11 | Carbon | Pennsylvania | 42025 | 3486 | 97 |
919467 | 919467 | 2021-01-11 | Centre | Pennsylvania | 42027 | 9785 | 153 |
919468 | 919468 | 2021-01-11 | Chester | Pennsylvania | 42029 | 23366 | 579 |
919469 | 919469 | 2021-01-11 | Clarion | Pennsylvania | 42031 | 2249 | 51 |
919470 | 919470 | 2021-01-11 | Clearfield | Pennsylvania | 42033 | 4822 | 57 |
919471 | 919471 | 2021-01-11 | Clinton | Pennsylvania | 42035 | 2225 | 32 |
919472 | 919472 | 2021-01-11 | Columbia | Pennsylvania | 42037 | 3401 | 88 |
919473 | 919473 | 2021-01-11 | Crawford | Pennsylvania | 42039 | 5370 | 101 |
919474 | 919474 | 2021-01-11 | Cumberland | Pennsylvania | 42041 | 11998 | 346 |
919475 | 919475 | 2021-01-11 | Dauphin | Pennsylvania | 42043 | 15678 | 358 |
919476 | 919476 | 2021-01-11 | Delaware | Pennsylvania | 42045 | 32836 | 1024 |
919477 | 919477 | 2021-01-11 | Elk | Pennsylvania | 42047 | 1675 | 23 |
919478 | 919478 | 2021-01-11 | Erie | Pennsylvania | 42049 | 13330 | 264 |
919479 | 919479 | 2021-01-11 | Fayette | Pennsylvania | 42051 | 8514 | 147 |
919480 | 919480 | 2021-01-11 | Forest | Pennsylvania | 42053 | 422 | 6 |
919481 | 919481 | 2021-01-11 | Franklin | Pennsylvania | 42055 | 10035 | 261 |
919482 | 919482 | 2021-01-11 | Fulton | Pennsylvania | 42057 | 851 | 11 |
919483 | 919483 | 2021-01-11 | Greene | Pennsylvania | 42059 | 2022 | 22 |
919484 | 919484 | 2021-01-11 | Huntingdon | Pennsylvania | 42061 | 3454 | 92 |
919485 | 919485 | 2021-01-11 | Indiana | Pennsylvania | 42063 | 4363 | 132 |
919486 | 919486 | 2021-01-11 | Jefferson | Pennsylvania | 42065 | 2156 | 55 |
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);