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 558
- 42127 558
- 42091 557
- 42089 555
- 42101 554
- 42017 553
- 42095 552
- 42103 552
- 42029 551
- 42041 551
- 42125 551
- 42003 550
- 42077 549
- 42079 549
- 42007 547
- 42001 546
- 42011 546
- 42069 546
- 42133 546
- 42071 545
- 42075 545
- 42129 545
- 42027 544
- 42049 544
- 42055 544
- 42105 544
- 42019 543
- 42093 543
- 42037 542
- 42043 542
- …
county >30
- Delaware 558
- Wayne 558
- Montgomery 557
- Monroe 555
- Philadelphia 554
- Bucks 553
- Northampton 552
- Pike 552
- Chester 551
- Cumberland 551
- Washington 551
- Allegheny 550
- Lehigh 549
- Luzerne 549
- Beaver 547
- Adams 546
- Berks 546
- Lackawanna 546
- York 546
- Lancaster 545
- Lebanon 545
- Westmoreland 545
- Centre 544
- Erie 544
- Franklin 544
- Potter 544
- Butler 543
- Montour 543
- Columbia 542
- Dauphin 542
- …
state 1
- Pennsylvania · 36,294 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718157 | 1718157 | 2021-09-14 | Adams | Pennsylvania | 42001 | 11203 | 193 |
1718158 | 1718158 | 2021-09-14 | Allegheny | Pennsylvania | 42003 | 114358 | 2101 |
1718159 | 1718159 | 2021-09-14 | Armstrong | Pennsylvania | 42005 | 6903 | 155 |
1718160 | 1718160 | 2021-09-14 | Beaver | Pennsylvania | 42007 | 18000 | 417 |
1718161 | 1718161 | 2021-09-14 | Bedford | Pennsylvania | 42009 | 5332 | 145 |
1718162 | 1718162 | 2021-09-14 | Berks | Pennsylvania | 42011 | 52578 | 1064 |
1718163 | 1718163 | 2021-09-14 | Blair | Pennsylvania | 42013 | 14608 | 348 |
1718164 | 1718164 | 2021-09-14 | Bradford | Pennsylvania | 42015 | 6541 | 102 |
1718165 | 1718165 | 2021-09-14 | Bucks | Pennsylvania | 42017 | 66759 | 1355 |
1718166 | 1718166 | 2021-09-14 | Butler | Pennsylvania | 42019 | 20467 | 434 |
1718167 | 1718167 | 2021-09-14 | Cambria | Pennsylvania | 42021 | 16134 | 454 |
1718168 | 1718168 | 2021-09-14 | Cameron | Pennsylvania | 42023 | 362 | 10 |
1718169 | 1718169 | 2021-09-14 | Carbon | Pennsylvania | 42025 | 7224 | 181 |
1718170 | 1718170 | 2021-09-14 | Centre | Pennsylvania | 42027 | 18444 | 232 |
1718171 | 1718171 | 2021-09-14 | Chester | Pennsylvania | 42029 | 45499 | 842 |
1718172 | 1718172 | 2021-09-14 | Clarion | Pennsylvania | 42031 | 3573 | 100 |
1718173 | 1718173 | 2021-09-14 | Clearfield | Pennsylvania | 42033 | 9594 | 168 |
1718174 | 1718174 | 2021-09-14 | Clinton | Pennsylvania | 42035 | 4031 | 69 |
1718175 | 1718175 | 2021-09-14 | Columbia | Pennsylvania | 42037 | 6556 | 139 |
1718176 | 1718176 | 2021-09-14 | Crawford | Pennsylvania | 42039 | 8681 | 166 |
1718177 | 1718177 | 2021-09-14 | Cumberland | Pennsylvania | 42041 | 23492 | 548 |
1718178 | 1718178 | 2021-09-14 | Dauphin | Pennsylvania | 42043 | 29704 | 581 |
1718179 | 1718179 | 2021-09-14 | Delaware | Pennsylvania | 42045 | 57430 | 1446 |
1718180 | 1718180 | 2021-09-14 | Elk | Pennsylvania | 42047 | 3273 | 44 |
1718181 | 1718181 | 2021-09-14 | Erie | Pennsylvania | 42049 | 23753 | 442 |
1718182 | 1718182 | 2021-09-14 | Fayette | Pennsylvania | 42051 | 14686 | 340 |
1718183 | 1718183 | 2021-09-14 | Forest | Pennsylvania | 42053 | 1483 | 21 |
1718184 | 1718184 | 2021-09-14 | Franklin | Pennsylvania | 42055 | 18137 | 392 |
1718185 | 1718185 | 2021-09-14 | Fulton | Pennsylvania | 42057 | 1701 | 20 |
1718186 | 1718186 | 2021-09-14 | Greene | Pennsylvania | 42059 | 3873 | 46 |
1718187 | 1718187 | 2021-09-14 | Huntingdon | Pennsylvania | 42061 | 5723 | 142 |
1718188 | 1718188 | 2021-09-14 | Indiana | Pennsylvania | 42063 | 7330 | 188 |
1718189 | 1718189 | 2021-09-14 | Jefferson | Pennsylvania | 42065 | 3783 | 103 |
1718190 | 1718190 | 2021-09-14 | Juniata | Pennsylvania | 42067 | 2418 | 99 |
1718191 | 1718191 | 2021-09-14 | Lackawanna | Pennsylvania | 42069 | 20145 | 494 |
1718192 | 1718192 | 2021-09-14 | Lancaster | Pennsylvania | 42071 | 62128 | 1208 |
1718193 | 1718193 | 2021-09-14 | Lawrence | Pennsylvania | 42073 | 8976 | 234 |
1718194 | 1718194 | 2021-09-14 | Lebanon | Pennsylvania | 42075 | 18031 | 309 |
1718195 | 1718195 | 2021-09-14 | Lehigh | Pennsylvania | 42077 | 44257 | 889 |
1718196 | 1718196 | 2021-09-14 | Luzerne | Pennsylvania | 42079 | 35263 | 853 |
1718197 | 1718197 | 2021-09-14 | Lycoming | Pennsylvania | 42081 | 13307 | 310 |
1718198 | 1718198 | 2021-09-14 | McKean | Pennsylvania | 42083 | 4102 | 76 |
1718199 | 1718199 | 2021-09-14 | Mercer | Pennsylvania | 42085 | 11084 | 279 |
1718200 | 1718200 | 2021-09-14 | Mifflin | Pennsylvania | 42087 | 5870 | 184 |
1718201 | 1718201 | 2021-09-14 | Monroe | Pennsylvania | 42089 | 17062 | 337 |
1718202 | 1718202 | 2021-09-14 | Montgomery | Pennsylvania | 42091 | 77947 | 1765 |
1718203 | 1718203 | 2021-09-14 | Montour | Pennsylvania | 42093 | 2162 | 67 |
1718204 | 1718204 | 2021-09-14 | Northampton | Pennsylvania | 42095 | 40326 | 743 |
1718205 | 1718205 | 2021-09-14 | Northumberland | Pennsylvania | 42097 | 10722 | 374 |
1718206 | 1718206 | 2021-09-14 | Perry | Pennsylvania | 42099 | 4386 | 102 |
1718207 | 1718207 | 2021-09-14 | Philadelphia | Pennsylvania | 42101 | 169565 | 3859 |
1718208 | 1718208 | 2021-09-14 | Pike | Pennsylvania | 42103 | 4577 | 56 |
1718209 | 1718209 | 2021-09-14 | Potter | Pennsylvania | 42105 | 1361 | 27 |
1718210 | 1718210 | 2021-09-14 | Schuylkill | Pennsylvania | 42107 | 16290 | 424 |
1718211 | 1718211 | 2021-09-14 | Snyder | Pennsylvania | 42109 | 4015 | 90 |
1718212 | 1718212 | 2021-09-14 | Somerset | Pennsylvania | 42111 | 8917 | 222 |
1718213 | 1718213 | 2021-09-14 | Sullivan | Pennsylvania | 42113 | 504 | 22 |
1718214 | 1718214 | 2021-09-14 | Susquehanna | Pennsylvania | 42115 | 3006 | 62 |
1718215 | 1718215 | 2021-09-14 | Tioga | Pennsylvania | 42117 | 3548 | 115 |
1718216 | 1718216 | 2021-09-14 | Union | Pennsylvania | 42119 | 6568 | 91 |
1718217 | 1718217 | 2021-09-14 | Venango | Pennsylvania | 42121 | 4730 | 109 |
1718218 | 1718218 | 2021-09-14 | Warren | Pennsylvania | 42123 | 3035 | 111 |
1718219 | 1718219 | 2021-09-14 | Washington | Pennsylvania | 42125 | 20686 | 331 |
1718220 | 1718220 | 2021-09-14 | Wayne | Pennsylvania | 42127 | 4787 | 85 |
1718221 | 1718221 | 2021-09-14 | Westmoreland | Pennsylvania | 42129 | 38280 | 814 |
1718222 | 1718222 | 2021-09-14 | Wyoming | Pennsylvania | 42131 | 2275 | 55 |
1718223 | 1718223 | 2021-09-14 | York | Pennsylvania | 42133 | 52906 | 867 |
1714909 | 1714909 | 2021-09-13 | Adams | Pennsylvania | 42001 | 11166 | 192 |
1714910 | 1714910 | 2021-09-13 | Allegheny | Pennsylvania | 42003 | 114110 | 2094 |
1714911 | 1714911 | 2021-09-13 | Armstrong | Pennsylvania | 42005 | 6840 | 153 |
1714912 | 1714912 | 2021-09-13 | Beaver | Pennsylvania | 42007 | 17911 | 415 |
1714913 | 1714913 | 2021-09-13 | Bedford | Pennsylvania | 42009 | 5311 | 145 |
1714914 | 1714914 | 2021-09-13 | Berks | Pennsylvania | 42011 | 52464 | 1062 |
1714915 | 1714915 | 2021-09-13 | Blair | Pennsylvania | 42013 | 14583 | 347 |
1714916 | 1714916 | 2021-09-13 | Bradford | Pennsylvania | 42015 | 6529 | 101 |
1714917 | 1714917 | 2021-09-13 | Bucks | Pennsylvania | 42017 | 66642 | 1354 |
1714918 | 1714918 | 2021-09-13 | Butler | Pennsylvania | 42019 | 20402 | 433 |
1714919 | 1714919 | 2021-09-13 | Cambria | Pennsylvania | 42021 | 16079 | 453 |
1714920 | 1714920 | 2021-09-13 | Cameron | Pennsylvania | 42023 | 355 | 10 |
1714921 | 1714921 | 2021-09-13 | Carbon | Pennsylvania | 42025 | 7183 | 180 |
1714922 | 1714922 | 2021-09-13 | Centre | Pennsylvania | 42027 | 18410 | 232 |
1714923 | 1714923 | 2021-09-13 | Chester | Pennsylvania | 42029 | 45384 | 841 |
1714924 | 1714924 | 2021-09-13 | Clarion | Pennsylvania | 42031 | 3565 | 100 |
1714925 | 1714925 | 2021-09-13 | Clearfield | Pennsylvania | 42033 | 9564 | 167 |
1714926 | 1714926 | 2021-09-13 | Clinton | Pennsylvania | 42035 | 4030 | 69 |
1714927 | 1714927 | 2021-09-13 | Columbia | Pennsylvania | 42037 | 6545 | 139 |
1714928 | 1714928 | 2021-09-13 | Crawford | Pennsylvania | 42039 | 8621 | 165 |
1714929 | 1714929 | 2021-09-13 | Cumberland | Pennsylvania | 42041 | 23411 | 548 |
1714930 | 1714930 | 2021-09-13 | Dauphin | Pennsylvania | 42043 | 29567 | 579 |
1714931 | 1714931 | 2021-09-13 | Delaware | Pennsylvania | 42045 | 57349 | 1444 |
1714932 | 1714932 | 2021-09-13 | Elk | Pennsylvania | 42047 | 3236 | 44 |
1714933 | 1714933 | 2021-09-13 | Erie | Pennsylvania | 42049 | 23671 | 440 |
1714934 | 1714934 | 2021-09-13 | Fayette | Pennsylvania | 42051 | 14658 | 339 |
1714935 | 1714935 | 2021-09-13 | Forest | Pennsylvania | 42053 | 1479 | 21 |
1714936 | 1714936 | 2021-09-13 | Franklin | Pennsylvania | 42055 | 17954 | 391 |
1714937 | 1714937 | 2021-09-13 | Fulton | Pennsylvania | 42057 | 1683 | 20 |
1714938 | 1714938 | 2021-09-13 | Greene | Pennsylvania | 42059 | 3842 | 44 |
1714939 | 1714939 | 2021-09-13 | Huntingdon | Pennsylvania | 42061 | 5708 | 141 |
1714940 | 1714940 | 2021-09-13 | Indiana | Pennsylvania | 42063 | 7290 | 185 |
1714941 | 1714941 | 2021-09-13 | Jefferson | Pennsylvania | 42065 | 3762 | 101 |
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);