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)
Suggested facets: date (date)
fips >30
- 42045 799
- 42127 799
- 42091 798
- 42089 796
- 42101 795
- 42017 794
- 42095 793
- 42103 793
- 42029 792
- 42041 792
- 42125 792
- 42003 791
- 42077 790
- 42079 790
- 42007 788
- 42001 787
- 42011 787
- 42069 787
- 42133 787
- 42071 786
- 42075 786
- 42129 786
- 42027 785
- 42049 785
- 42055 785
- 42105 785
- 42019 784
- 42093 784
- 42037 783
- 42043 783
- …
county >30
- Delaware 799
- Wayne 799
- Montgomery 798
- Monroe 796
- Philadelphia 795
- Bucks 794
- Northampton 793
- Pike 793
- Chester 792
- Cumberland 792
- Washington 792
- Allegheny 791
- Lehigh 790
- Luzerne 790
- Beaver 788
- Adams 787
- Berks 787
- Lackawanna 787
- York 787
- 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,441 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 2501847 | 2501847 | 2022-05-13 | Adams | Pennsylvania | 42001 | 25114 | 364 |
| 2501848 | 2501848 | 2022-05-13 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 |
| 2501849 | 2501849 | 2022-05-13 | Armstrong | Pennsylvania | 42005 | 15397 | 343 |
| 2501850 | 2501850 | 2022-05-13 | Beaver | Pennsylvania | 42007 | 40744 | 745 |
| 2501851 | 2501851 | 2022-05-13 | Bedford | Pennsylvania | 42009 | 11044 | 275 |
| 2501852 | 2501852 | 2022-05-13 | Berks | Pennsylvania | 42011 | 103652 | 1595 |
| 2501853 | 2501853 | 2022-05-13 | Blair | Pennsylvania | 42013 | 29924 | 616 |
| 2501854 | 2501854 | 2022-05-13 | Bradford | Pennsylvania | 42015 | 16219 | 207 |
| 2501855 | 2501855 | 2022-05-13 | Bucks | Pennsylvania | 42017 | 126504 | 1905 |
| 2501856 | 2501856 | 2022-05-13 | Butler | Pennsylvania | 42019 | 45173 | 743 |
| 2501857 | 2501857 | 2022-05-13 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
| 2501858 | 2501858 | 2022-05-13 | Cameron | Pennsylvania | 42023 | 822 | 21 |
| 2501859 | 2501859 | 2022-05-13 | Carbon | Pennsylvania | 42025 | 16188 | 294 |
| 2501860 | 2501860 | 2022-05-13 | Centre | Pennsylvania | 42027 | 36016 | 351 |
| 2501861 | 2501861 | 2022-05-13 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
| 2501862 | 2501862 | 2022-05-13 | Clarion | Pennsylvania | 42031 | 8323 | 202 |
| 2501863 | 2501863 | 2022-05-13 | Clearfield | Pennsylvania | 42033 | 19533 | 348 |
| 2501864 | 2501864 | 2022-05-13 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
| 2501865 | 2501865 | 2022-05-13 | Columbia | Pennsylvania | 42037 | 15476 | 246 |
| 2501866 | 2501866 | 2022-05-13 | Crawford | Pennsylvania | 42039 | 20080 | 320 |
| 2501867 | 2501867 | 2022-05-13 | Cumberland | Pennsylvania | 42041 | 51754 | 892 |
| 2501868 | 2501868 | 2022-05-13 | Dauphin | Pennsylvania | 42043 | 59830 | 964 |
| 2501869 | 2501869 | 2022-05-13 | Delaware | Pennsylvania | 42045 | 113339 | 1875 |
| 2501870 | 2501870 | 2022-05-13 | Elk | Pennsylvania | 42047 | 7193 | 101 |
| 2501871 | 2501871 | 2022-05-13 | Erie | Pennsylvania | 42049 | 58218 | 760 |
| 2501872 | 2501872 | 2022-05-13 | Fayette | Pennsylvania | 42051 | 31332 | 674 |
| 2501873 | 2501873 | 2022-05-13 | Forest | Pennsylvania | 42053 | 2250 | 35 |
| 2501874 | 2501874 | 2022-05-13 | Franklin | Pennsylvania | 42055 | 40694 | 695 |
| 2501875 | 2501875 | 2022-05-13 | Fulton | Pennsylvania | 42057 | 4153 | 65 |
| 2501876 | 2501876 | 2022-05-13 | Greene | Pennsylvania | 42059 | 8513 | 104 |
| 2501877 | 2501877 | 2022-05-13 | Huntingdon | Pennsylvania | 42061 | 11594 | 249 |
| 2501878 | 2501878 | 2022-05-13 | Indiana | Pennsylvania | 42063 | 17690 | 356 |
| 2501879 | 2501879 | 2022-05-13 | Jefferson | Pennsylvania | 42065 | 9121 | 235 |
| 2501880 | 2501880 | 2022-05-13 | Juniata | Pennsylvania | 42067 | 4797 | 176 |
| 2501881 | 2501881 | 2022-05-13 | Lackawanna | Pennsylvania | 42069 | 45137 | 776 |
| 2501882 | 2501882 | 2022-05-13 | Lancaster | Pennsylvania | 42071 | 122794 | 1890 |
| 2501883 | 2501883 | 2022-05-13 | Lawrence | Pennsylvania | 42073 | 19109 | 418 |
| 2501884 | 2501884 | 2022-05-13 | Lebanon | Pennsylvania | 42075 | 37011 | 518 |
| 2501885 | 2501885 | 2022-05-13 | Lehigh | Pennsylvania | 42077 | 91539 | 1246 |
| 2501886 | 2501886 | 2022-05-13 | Luzerne | Pennsylvania | 42079 | 75379 | 1366 |
| 2501887 | 2501887 | 2022-05-13 | Lycoming | Pennsylvania | 42081 | 28894 | 522 |
| 2501888 | 2501888 | 2022-05-13 | McKean | Pennsylvania | 42083 | 8298 | 141 |
| 2501889 | 2501889 | 2022-05-13 | Mercer | Pennsylvania | 42085 | 23612 | 498 |
| 2501890 | 2501890 | 2022-05-13 | Mifflin | Pennsylvania | 42087 | 12348 | 276 |
| 2501891 | 2501891 | 2022-05-13 | Monroe | Pennsylvania | 42089 | 37881 | 524 |
| 2501892 | 2501892 | 2022-05-13 | Montgomery | Pennsylvania | 42091 | 158154 | 2329 |
| 2501893 | 2501893 | 2022-05-13 | Montour | Pennsylvania | 42093 | 4637 | 93 |
| 2501894 | 2501894 | 2022-05-13 | Northampton | Pennsylvania | 42095 | 81732 | 1097 |
| 2501895 | 2501895 | 2022-05-13 | Northumberland | Pennsylvania | 42097 | 23172 | 534 |
| 2501896 | 2501896 | 2022-05-13 | Perry | Pennsylvania | 42099 | 8873 | 185 |
| 2501897 | 2501897 | 2022-05-13 | Philadelphia | Pennsylvania | 42101 | 317808 | 5110 |
| 2501898 | 2501898 | 2022-05-13 | Pike | Pennsylvania | 42103 | 10557 | 98 |
| 2501899 | 2501899 | 2022-05-13 | Potter | Pennsylvania | 42105 | 3256 | 92 |
| 2501900 | 2501900 | 2022-05-13 | Schuylkill | Pennsylvania | 42107 | 34853 | 675 |
| 2501901 | 2501901 | 2022-05-13 | Snyder | Pennsylvania | 42109 | 8149 | 158 |
| 2501902 | 2501902 | 2022-05-13 | Somerset | Pennsylvania | 42111 | 18829 | 408 |
| 2501903 | 2501903 | 2022-05-13 | Sullivan | Pennsylvania | 42113 | 1092 | 36 |
| 2501904 | 2501904 | 2022-05-13 | Susquehanna | Pennsylvania | 42115 | 8188 | 110 |
| 2501905 | 2501905 | 2022-05-13 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
| 2501906 | 2501906 | 2022-05-13 | Union | Pennsylvania | 42119 | 11842 | 154 |
| 2501907 | 2501907 | 2022-05-13 | Venango | Pennsylvania | 42121 | 11406 | 241 |
| 2501908 | 2501908 | 2022-05-13 | Warren | Pennsylvania | 42123 | 7506 | 212 |
| 2501909 | 2501909 | 2022-05-13 | Washington | Pennsylvania | 42125 | 51747 | 654 |
| 2501910 | 2501910 | 2022-05-13 | Wayne | Pennsylvania | 42127 | 10460 | 172 |
| 2501911 | 2501911 | 2022-05-13 | Westmoreland | Pennsylvania | 42129 | 81006 | 1378 |
| 2501912 | 2501912 | 2022-05-13 | Wyoming | Pennsylvania | 42131 | 5257 | 106 |
| 2501913 | 2501913 | 2022-05-13 | York | Pennsylvania | 42133 | 120372 | 1502 |
| 2498589 | 2498589 | 2022-05-12 | Adams | Pennsylvania | 42001 | 25114 | 364 |
| 2498590 | 2498590 | 2022-05-12 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 |
| 2498591 | 2498591 | 2022-05-12 | Armstrong | Pennsylvania | 42005 | 15397 | 343 |
| 2498592 | 2498592 | 2022-05-12 | Beaver | Pennsylvania | 42007 | 40744 | 745 |
| 2498593 | 2498593 | 2022-05-12 | Bedford | Pennsylvania | 42009 | 11044 | 275 |
| 2498594 | 2498594 | 2022-05-12 | Berks | Pennsylvania | 42011 | 103652 | 1595 |
| 2498595 | 2498595 | 2022-05-12 | Blair | Pennsylvania | 42013 | 29924 | 616 |
| 2498596 | 2498596 | 2022-05-12 | Bradford | Pennsylvania | 42015 | 16219 | 207 |
| 2498597 | 2498597 | 2022-05-12 | Bucks | Pennsylvania | 42017 | 126504 | 1905 |
| 2498598 | 2498598 | 2022-05-12 | Butler | Pennsylvania | 42019 | 45173 | 743 |
| 2498599 | 2498599 | 2022-05-12 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
| 2498600 | 2498600 | 2022-05-12 | Cameron | Pennsylvania | 42023 | 822 | 21 |
| 2498601 | 2498601 | 2022-05-12 | Carbon | Pennsylvania | 42025 | 16188 | 294 |
| 2498602 | 2498602 | 2022-05-12 | Centre | Pennsylvania | 42027 | 36016 | 351 |
| 2498603 | 2498603 | 2022-05-12 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
| 2498604 | 2498604 | 2022-05-12 | Clarion | Pennsylvania | 42031 | 8323 | 202 |
| 2498605 | 2498605 | 2022-05-12 | Clearfield | Pennsylvania | 42033 | 19533 | 348 |
| 2498606 | 2498606 | 2022-05-12 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
| 2498607 | 2498607 | 2022-05-12 | Columbia | Pennsylvania | 42037 | 15476 | 246 |
| 2498608 | 2498608 | 2022-05-12 | Crawford | Pennsylvania | 42039 | 20080 | 320 |
| 2498609 | 2498609 | 2022-05-12 | Cumberland | Pennsylvania | 42041 | 51754 | 892 |
| 2498610 | 2498610 | 2022-05-12 | Dauphin | Pennsylvania | 42043 | 59830 | 964 |
| 2498611 | 2498611 | 2022-05-12 | Delaware | Pennsylvania | 42045 | 113339 | 1875 |
| 2498612 | 2498612 | 2022-05-12 | Elk | Pennsylvania | 42047 | 7193 | 101 |
| 2498613 | 2498613 | 2022-05-12 | Erie | Pennsylvania | 42049 | 58218 | 760 |
| 2498614 | 2498614 | 2022-05-12 | Fayette | Pennsylvania | 42051 | 31332 | 674 |
| 2498615 | 2498615 | 2022-05-12 | Forest | Pennsylvania | 42053 | 2250 | 35 |
| 2498616 | 2498616 | 2022-05-12 | Franklin | Pennsylvania | 42055 | 40694 | 695 |
| 2498617 | 2498617 | 2022-05-12 | Fulton | Pennsylvania | 42057 | 4153 | 65 |
| 2498618 | 2498618 | 2022-05-12 | Greene | Pennsylvania | 42059 | 8513 | 104 |
| 2498619 | 2498619 | 2022-05-12 | Huntingdon | Pennsylvania | 42061 | 11594 | 249 |
| 2498620 | 2498620 | 2022-05-12 | Indiana | Pennsylvania | 42063 | 17690 | 356 |
| 2498621 | 2498621 | 2022-05-12 | Jefferson | Pennsylvania | 42065 | 9121 | 235 |
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);