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 354
- 42127 354
- 42091 353
- 42089 351
- 42101 350
- 42017 349
- 42095 348
- 42103 348
- 42029 347
- 42041 347
- 42125 347
- 42003 346
- 42077 345
- 42079 345
- 42007 343
- 42001 342
- 42011 342
- 42069 342
- 42133 342
- 42071 341
- 42075 341
- 42129 341
- 42027 340
- 42049 340
- 42055 340
- 42105 340
- 42019 339
- 42093 339
- 42037 338
- 42043 338
- …
county >30
- Delaware 354
- Wayne 354
- Montgomery 353
- Monroe 351
- Philadelphia 350
- Bucks 349
- Northampton 348
- Pike 348
- Chester 347
- Cumberland 347
- Washington 347
- Allegheny 346
- Lehigh 345
- Luzerne 345
- Beaver 343
- Adams 342
- Berks 342
- Lackawanna 342
- York 342
- Lancaster 341
- Lebanon 341
- Westmoreland 341
- Centre 340
- Erie 340
- Franklin 340
- Potter 340
- Butler 339
- Montour 339
- Columbia 338
- Dauphin 338
- …
state 1
- Pennsylvania · 22,626 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055768 | 1055768 | 2021-02-22 | Adams | Pennsylvania | 42001 | 7136 | 148 |
1055769 | 1055769 | 2021-02-22 | Allegheny | Pennsylvania | 42003 | 74976 | 1689 |
1055770 | 1055770 | 2021-02-22 | Armstrong | Pennsylvania | 42005 | 4859 | 116 |
1055771 | 1055771 | 2021-02-22 | Beaver | Pennsylvania | 42007 | 11997 | 342 |
1055772 | 1055772 | 2021-02-22 | Bedford | Pennsylvania | 42009 | 3780 | 128 |
1055773 | 1055773 | 2021-02-22 | Berks | Pennsylvania | 42011 | 35105 | 880 |
1055774 | 1055774 | 2021-02-22 | Blair | Pennsylvania | 42013 | 10528 | 294 |
1055775 | 1055775 | 2021-02-22 | Bradford | Pennsylvania | 42015 | 4270 | 75 |
1055776 | 1055776 | 2021-02-22 | Bucks | Pennsylvania | 42017 | 44105 | 1114 |
1055777 | 1055777 | 2021-02-22 | Butler | Pennsylvania | 42019 | 13705 | 363 |
1055778 | 1055778 | 2021-02-22 | Cambria | Pennsylvania | 42021 | 11547 | 388 |
1055779 | 1055779 | 2021-02-22 | Cameron | Pennsylvania | 42023 | 256 | 7 |
1055780 | 1055780 | 2021-02-22 | Carbon | Pennsylvania | 42025 | 4800 | 146 |
1055781 | 1055781 | 2021-02-22 | Centre | Pennsylvania | 42027 | 12642 | 208 |
1055782 | 1055782 | 2021-02-22 | Chester | Pennsylvania | 42029 | 30004 | 714 |
1055783 | 1055783 | 2021-02-22 | Clarion | Pennsylvania | 42031 | 2653 | 81 |
1055784 | 1055784 | 2021-02-22 | Clearfield | Pennsylvania | 42033 | 6149 | 113 |
1055785 | 1055785 | 2021-02-22 | Clinton | Pennsylvania | 42035 | 2710 | 55 |
1055786 | 1055786 | 2021-02-22 | Columbia | Pennsylvania | 42037 | 4544 | 123 |
1055787 | 1055787 | 2021-02-22 | Crawford | Pennsylvania | 42039 | 6282 | 136 |
1055788 | 1055788 | 2021-02-22 | Cumberland | Pennsylvania | 42041 | 15869 | 476 |
1055789 | 1055789 | 2021-02-22 | Dauphin | Pennsylvania | 42043 | 20188 | 483 |
1055790 | 1055790 | 2021-02-22 | Delaware | Pennsylvania | 42045 | 40132 | 1261 |
1055791 | 1055791 | 2021-02-22 | Elk | Pennsylvania | 42047 | 2300 | 35 |
1055792 | 1055792 | 2021-02-22 | Erie | Pennsylvania | 42049 | 16971 | 376 |
1055793 | 1055793 | 2021-02-22 | Fayette | Pennsylvania | 42051 | 10311 | 260 |
1055794 | 1055794 | 2021-02-22 | Forest | Pennsylvania | 42053 | 1377 | 20 |
1055795 | 1055795 | 2021-02-22 | Franklin | Pennsylvania | 42055 | 12309 | 317 |
1055796 | 1055796 | 2021-02-22 | Fulton | Pennsylvania | 42057 | 1117 | 14 |
1055797 | 1055797 | 2021-02-22 | Greene | Pennsylvania | 42059 | 2622 | 32 |
1055798 | 1055798 | 2021-02-22 | Huntingdon | Pennsylvania | 42061 | 4149 | 119 |
1055799 | 1055799 | 2021-02-22 | Indiana | Pennsylvania | 42063 | 5018 | 157 |
1055800 | 1055800 | 2021-02-22 | Jefferson | Pennsylvania | 42065 | 2757 | 86 |
1055801 | 1055801 | 2021-02-22 | Juniata | Pennsylvania | 42067 | 1797 | 80 |
1055802 | 1055802 | 2021-02-22 | Lackawanna | Pennsylvania | 42069 | 13629 | 410 |
1055803 | 1055803 | 2021-02-22 | Lancaster | Pennsylvania | 42071 | 42843 | 1004 |
1055804 | 1055804 | 2021-02-22 | Lawrence | Pennsylvania | 42073 | 5929 | 180 |
1055805 | 1055805 | 2021-02-22 | Lebanon | Pennsylvania | 42075 | 12651 | 256 |
1055806 | 1055806 | 2021-02-22 | Lehigh | Pennsylvania | 42077 | 30230 | 746 |
1055807 | 1055807 | 2021-02-22 | Luzerne | Pennsylvania | 42079 | 24543 | 714 |
1055808 | 1055808 | 2021-02-22 | Lycoming | Pennsylvania | 42081 | 9057 | 240 |
1055809 | 1055809 | 2021-02-22 | McKean | Pennsylvania | 42083 | 3010 | 61 |
1055810 | 1055810 | 2021-02-22 | Mercer | Pennsylvania | 42085 | 7935 | 237 |
1055811 | 1055811 | 2021-02-22 | Mifflin | Pennsylvania | 42087 | 4537 | 166 |
1055812 | 1055812 | 2021-02-22 | Monroe | Pennsylvania | 42089 | 9435 | 262 |
1055813 | 1055813 | 2021-02-22 | Montgomery | Pennsylvania | 42091 | 52898 | 1518 |
1055814 | 1055814 | 2021-02-22 | Montour | Pennsylvania | 42093 | 1751 | 58 |
1055815 | 1055815 | 2021-02-22 | Northampton | Pennsylvania | 42095 | 26208 | 631 |
1055816 | 1055816 | 2021-02-22 | Northumberland | Pennsylvania | 42097 | 7868 | 320 |
1055817 | 1055817 | 2021-02-22 | Perry | Pennsylvania | 42099 | 2841 | 82 |
1055818 | 1055818 | 2021-02-22 | Philadelphia | Pennsylvania | 42101 | 116726 | 3089 |
1055819 | 1055819 | 2021-02-22 | Pike | Pennsylvania | 42103 | 2437 | 46 |
1055820 | 1055820 | 2021-02-22 | Potter | Pennsylvania | 42105 | 904 | 21 |
1055821 | 1055821 | 2021-02-22 | Schuylkill | Pennsylvania | 42107 | 11902 | 365 |
1055822 | 1055822 | 2021-02-22 | Snyder | Pennsylvania | 42109 | 2958 | 78 |
1055823 | 1055823 | 2021-02-22 | Somerset | Pennsylvania | 42111 | 6622 | 187 |
1055824 | 1055824 | 2021-02-22 | Sullivan | Pennsylvania | 42113 | 305 | 14 |
1055825 | 1055825 | 2021-02-22 | Susquehanna | Pennsylvania | 42115 | 1667 | 53 |
1055826 | 1055826 | 2021-02-22 | Tioga | Pennsylvania | 42117 | 2412 | 94 |
1055827 | 1055827 | 2021-02-22 | Union | Pennsylvania | 42119 | 5093 | 80 |
1055828 | 1055828 | 2021-02-22 | Venango | Pennsylvania | 42121 | 3295 | 80 |
1055829 | 1055829 | 2021-02-22 | Warren | Pennsylvania | 42123 | 2135 | 96 |
1055830 | 1055830 | 2021-02-22 | Washington | Pennsylvania | 42125 | 13544 | 257 |
1055831 | 1055831 | 2021-02-22 | Wayne | Pennsylvania | 42127 | 2967 | 65 |
1055832 | 1055832 | 2021-02-22 | Westmoreland | Pennsylvania | 42129 | 26351 | 664 |
1055833 | 1055833 | 2021-02-22 | Wyoming | Pennsylvania | 42131 | 1146 | 40 |
1055834 | 1055834 | 2021-02-22 | York | Pennsylvania | 42133 | 35231 | 707 |
1052522 | 1052522 | 2021-02-21 | Adams | Pennsylvania | 42001 | 7120 | 148 |
1052523 | 1052523 | 2021-02-21 | Allegheny | Pennsylvania | 42003 | 74866 | 1685 |
1052524 | 1052524 | 2021-02-21 | Armstrong | Pennsylvania | 42005 | 4857 | 116 |
1052525 | 1052525 | 2021-02-21 | Beaver | Pennsylvania | 42007 | 11981 | 342 |
1052526 | 1052526 | 2021-02-21 | Bedford | Pennsylvania | 42009 | 3774 | 128 |
1052527 | 1052527 | 2021-02-21 | Berks | Pennsylvania | 42011 | 35025 | 879 |
1052528 | 1052528 | 2021-02-21 | Blair | Pennsylvania | 42013 | 10520 | 294 |
1052529 | 1052529 | 2021-02-21 | Bradford | Pennsylvania | 42015 | 4266 | 74 |
1052530 | 1052530 | 2021-02-21 | Bucks | Pennsylvania | 42017 | 43996 | 1113 |
1052531 | 1052531 | 2021-02-21 | Butler | Pennsylvania | 42019 | 13693 | 363 |
1052532 | 1052532 | 2021-02-21 | Cambria | Pennsylvania | 42021 | 11537 | 388 |
1052533 | 1052533 | 2021-02-21 | Cameron | Pennsylvania | 42023 | 256 | 7 |
1052534 | 1052534 | 2021-02-21 | Carbon | Pennsylvania | 42025 | 4796 | 146 |
1052535 | 1052535 | 2021-02-21 | Centre | Pennsylvania | 42027 | 12629 | 208 |
1052536 | 1052536 | 2021-02-21 | Chester | Pennsylvania | 42029 | 29912 | 713 |
1052537 | 1052537 | 2021-02-21 | Clarion | Pennsylvania | 42031 | 2650 | 81 |
1052538 | 1052538 | 2021-02-21 | Clearfield | Pennsylvania | 42033 | 6136 | 113 |
1052539 | 1052539 | 2021-02-21 | Clinton | Pennsylvania | 42035 | 2701 | 55 |
1052540 | 1052540 | 2021-02-21 | Columbia | Pennsylvania | 42037 | 4537 | 123 |
1052541 | 1052541 | 2021-02-21 | Crawford | Pennsylvania | 42039 | 6273 | 136 |
1052542 | 1052542 | 2021-02-21 | Cumberland | Pennsylvania | 42041 | 15831 | 476 |
1052543 | 1052543 | 2021-02-21 | Dauphin | Pennsylvania | 42043 | 20152 | 483 |
1052544 | 1052544 | 2021-02-21 | Delaware | Pennsylvania | 42045 | 40052 | 1261 |
1052545 | 1052545 | 2021-02-21 | Elk | Pennsylvania | 42047 | 2296 | 35 |
1052546 | 1052546 | 2021-02-21 | Erie | Pennsylvania | 42049 | 16941 | 375 |
1052547 | 1052547 | 2021-02-21 | Fayette | Pennsylvania | 42051 | 10306 | 260 |
1052548 | 1052548 | 2021-02-21 | Forest | Pennsylvania | 42053 | 1377 | 20 |
1052549 | 1052549 | 2021-02-21 | Franklin | Pennsylvania | 42055 | 12308 | 317 |
1052550 | 1052550 | 2021-02-21 | Fulton | Pennsylvania | 42057 | 1117 | 14 |
1052551 | 1052551 | 2021-02-21 | Greene | Pennsylvania | 42059 | 2620 | 32 |
1052552 | 1052552 | 2021-02-21 | Huntingdon | Pennsylvania | 42061 | 4147 | 119 |
1052553 | 1052553 | 2021-02-21 | Indiana | Pennsylvania | 42063 | 5015 | 157 |
1052554 | 1052554 | 2021-02-21 | Jefferson | Pennsylvania | 42065 | 2755 | 86 |
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);