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 397
- 42127 397
- 42091 396
- 42089 394
- 42101 393
- 42017 392
- 42095 391
- 42103 391
- 42029 390
- 42041 390
- 42125 390
- 42003 389
- 42077 388
- 42079 388
- 42007 386
- 42001 385
- 42011 385
- 42069 385
- 42133 385
- 42071 384
- 42075 384
- 42129 384
- 42027 383
- 42049 383
- 42055 383
- 42105 383
- 42019 382
- 42093 382
- 42037 381
- 42043 381
- …
county >30
- Delaware 397
- Wayne 397
- Montgomery 396
- Monroe 394
- Philadelphia 393
- Bucks 392
- Northampton 391
- Pike 391
- Chester 390
- Cumberland 390
- Washington 390
- Allegheny 389
- Lehigh 388
- Luzerne 388
- Beaver 386
- Adams 385
- Berks 385
- Lackawanna 385
- York 385
- Lancaster 384
- Lebanon 384
- Westmoreland 384
- Centre 383
- Erie 383
- Franklin 383
- Potter 383
- Butler 382
- Montour 382
- Columbia 381
- Dauphin 381
- …
state 1
- Pennsylvania · 25,507 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195372 | 1195372 | 2021-04-06 | Adams | Pennsylvania | 42001 | 8302 | 161 |
1195373 | 1195373 | 2021-04-06 | Allegheny | Pennsylvania | 42003 | 88155 | 1824 |
1195374 | 1195374 | 2021-04-06 | Armstrong | Pennsylvania | 42005 | 5261 | 120 |
1195375 | 1195375 | 2021-04-06 | Beaver | Pennsylvania | 42007 | 13500 | 361 |
1195376 | 1195376 | 2021-04-06 | Bedford | Pennsylvania | 42009 | 4008 | 130 |
1195377 | 1195377 | 2021-04-06 | Berks | Pennsylvania | 42011 | 41042 | 932 |
1195378 | 1195378 | 2021-04-06 | Blair | Pennsylvania | 42013 | 11356 | 315 |
1195379 | 1195379 | 2021-04-06 | Bradford | Pennsylvania | 42015 | 4980 | 84 |
1195380 | 1195380 | 2021-04-06 | Bucks | Pennsylvania | 42017 | 52661 | 1183 |
1195381 | 1195381 | 2021-04-06 | Butler | Pennsylvania | 42019 | 15568 | 388 |
1195382 | 1195382 | 2021-04-06 | Cambria | Pennsylvania | 42021 | 12473 | 406 |
1195383 | 1195383 | 2021-04-06 | Cameron | Pennsylvania | 42023 | 281 | 6 |
1195384 | 1195384 | 2021-04-06 | Carbon | Pennsylvania | 42025 | 5540 | 158 |
1195385 | 1195385 | 2021-04-06 | Centre | Pennsylvania | 42027 | 14925 | 213 |
1195386 | 1195386 | 2021-04-06 | Chester | Pennsylvania | 42029 | 35229 | 756 |
1195387 | 1195387 | 2021-04-06 | Clarion | Pennsylvania | 42031 | 2857 | 88 |
1195388 | 1195388 | 2021-04-06 | Clearfield | Pennsylvania | 42033 | 7395 | 130 |
1195389 | 1195389 | 2021-04-06 | Clinton | Pennsylvania | 42035 | 3182 | 59 |
1195390 | 1195390 | 2021-04-06 | Columbia | Pennsylvania | 42037 | 5016 | 129 |
1195391 | 1195391 | 2021-04-06 | Crawford | Pennsylvania | 42039 | 6720 | 144 |
1195392 | 1195392 | 2021-04-06 | Cumberland | Pennsylvania | 42041 | 18248 | 499 |
1195393 | 1195393 | 2021-04-06 | Dauphin | Pennsylvania | 42043 | 22795 | 526 |
1195394 | 1195394 | 2021-04-06 | Delaware | Pennsylvania | 42045 | 45953 | 1346 |
1195395 | 1195395 | 2021-04-06 | Elk | Pennsylvania | 42047 | 2612 | 37 |
1195396 | 1195396 | 2021-04-06 | Erie | Pennsylvania | 42049 | 18926 | 396 |
1195397 | 1195397 | 2021-04-06 | Fayette | Pennsylvania | 42051 | 11461 | 291 |
1195398 | 1195398 | 2021-04-06 | Forest | Pennsylvania | 42053 | 1396 | 21 |
1195399 | 1195399 | 2021-04-06 | Franklin | Pennsylvania | 42055 | 13744 | 343 |
1195400 | 1195400 | 2021-04-06 | Fulton | Pennsylvania | 42057 | 1211 | 15 |
1195401 | 1195401 | 2021-04-06 | Greene | Pennsylvania | 42059 | 2942 | 37 |
1195402 | 1195402 | 2021-04-06 | Huntingdon | Pennsylvania | 42061 | 4614 | 127 |
1195403 | 1195403 | 2021-04-06 | Indiana | Pennsylvania | 42063 | 5452 | 163 |
1195404 | 1195404 | 2021-04-06 | Jefferson | Pennsylvania | 42065 | 3023 | 91 |
1195405 | 1195405 | 2021-04-06 | Juniata | Pennsylvania | 42067 | 1949 | 82 |
1195406 | 1195406 | 2021-04-06 | Lackawanna | Pennsylvania | 42069 | 16038 | 440 |
1195407 | 1195407 | 2021-04-06 | Lancaster | Pennsylvania | 42071 | 48920 | 1082 |
1195408 | 1195408 | 2021-04-06 | Lawrence | Pennsylvania | 42073 | 6759 | 195 |
1195409 | 1195409 | 2021-04-06 | Lebanon | Pennsylvania | 42075 | 14055 | 265 |
1195410 | 1195410 | 2021-04-06 | Lehigh | Pennsylvania | 42077 | 34969 | 811 |
1195411 | 1195411 | 2021-04-06 | Luzerne | Pennsylvania | 42079 | 27701 | 769 |
1195412 | 1195412 | 2021-04-06 | Lycoming | Pennsylvania | 42081 | 10478 | 265 |
1195413 | 1195413 | 2021-04-06 | McKean | Pennsylvania | 42083 | 3208 | 65 |
1195414 | 1195414 | 2021-04-06 | Mercer | Pennsylvania | 42085 | 8621 | 249 |
1195415 | 1195415 | 2021-04-06 | Mifflin | Pennsylvania | 42087 | 4833 | 175 |
1195416 | 1195416 | 2021-04-06 | Monroe | Pennsylvania | 42089 | 11977 | 289 |
1195417 | 1195417 | 2021-04-06 | Montgomery | Pennsylvania | 42091 | 61499 | 1617 |
1195418 | 1195418 | 2021-04-06 | Montour | Pennsylvania | 42093 | 1863 | 60 |
1195419 | 1195419 | 2021-04-06 | Northampton | Pennsylvania | 42095 | 31389 | 681 |
1195420 | 1195420 | 2021-04-06 | Northumberland | Pennsylvania | 42097 | 8667 | 337 |
1195421 | 1195421 | 2021-04-06 | Perry | Pennsylvania | 42099 | 3299 | 90 |
1195422 | 1195422 | 2021-04-06 | Philadelphia | Pennsylvania | 42101 | 133485 | 3306 |
1195423 | 1195423 | 2021-04-06 | Pike | Pennsylvania | 42103 | 3273 | 51 |
1195424 | 1195424 | 2021-04-06 | Potter | Pennsylvania | 42105 | 994 | 22 |
1195425 | 1195425 | 2021-04-06 | Schuylkill | Pennsylvania | 42107 | 13098 | 383 |
1195426 | 1195426 | 2021-04-06 | Snyder | Pennsylvania | 42109 | 3330 | 82 |
1195427 | 1195427 | 2021-04-06 | Somerset | Pennsylvania | 42111 | 7047 | 190 |
1195428 | 1195428 | 2021-04-06 | Sullivan | Pennsylvania | 42113 | 350 | 20 |
1195429 | 1195429 | 2021-04-06 | Susquehanna | Pennsylvania | 42115 | 2083 | 57 |
1195430 | 1195430 | 2021-04-06 | Tioga | Pennsylvania | 42117 | 2679 | 100 |
1195431 | 1195431 | 2021-04-06 | Union | Pennsylvania | 42119 | 5484 | 86 |
1195432 | 1195432 | 2021-04-06 | Venango | Pennsylvania | 42121 | 3575 | 90 |
1195433 | 1195433 | 2021-04-06 | Warren | Pennsylvania | 42123 | 2321 | 99 |
1195434 | 1195434 | 2021-04-06 | Washington | Pennsylvania | 42125 | 15502 | 276 |
1195435 | 1195435 | 2021-04-06 | Wayne | Pennsylvania | 42127 | 3482 | 73 |
1195436 | 1195436 | 2021-04-06 | Westmoreland | Pennsylvania | 42129 | 29886 | 709 |
1195437 | 1195437 | 2021-04-06 | Wyoming | Pennsylvania | 42131 | 1534 | 44 |
1195438 | 1195438 | 2021-04-06 | York | Pennsylvania | 42133 | 40322 | 752 |
1192124 | 1192124 | 2021-04-05 | Adams | Pennsylvania | 42001 | 8275 | 161 |
1192125 | 1192125 | 2021-04-05 | Allegheny | Pennsylvania | 42003 | 87623 | 1823 |
1192126 | 1192126 | 2021-04-05 | Armstrong | Pennsylvania | 42005 | 5241 | 120 |
1192127 | 1192127 | 2021-04-05 | Beaver | Pennsylvania | 42007 | 13414 | 360 |
1192128 | 1192128 | 2021-04-05 | Bedford | Pennsylvania | 42009 | 3999 | 130 |
1192129 | 1192129 | 2021-04-05 | Berks | Pennsylvania | 42011 | 40836 | 932 |
1192130 | 1192130 | 2021-04-05 | Blair | Pennsylvania | 42013 | 11294 | 314 |
1192131 | 1192131 | 2021-04-05 | Bradford | Pennsylvania | 42015 | 4955 | 84 |
1192132 | 1192132 | 2021-04-05 | Bucks | Pennsylvania | 42017 | 52418 | 1183 |
1192133 | 1192133 | 2021-04-05 | Butler | Pennsylvania | 42019 | 15513 | 386 |
1192134 | 1192134 | 2021-04-05 | Cambria | Pennsylvania | 42021 | 12433 | 406 |
1192135 | 1192135 | 2021-04-05 | Cameron | Pennsylvania | 42023 | 279 | 6 |
1192136 | 1192136 | 2021-04-05 | Carbon | Pennsylvania | 42025 | 5508 | 158 |
1192137 | 1192137 | 2021-04-05 | Centre | Pennsylvania | 42027 | 14873 | 213 |
1192138 | 1192138 | 2021-04-05 | Chester | Pennsylvania | 42029 | 35102 | 754 |
1192139 | 1192139 | 2021-04-05 | Clarion | Pennsylvania | 42031 | 2853 | 88 |
1192140 | 1192140 | 2021-04-05 | Clearfield | Pennsylvania | 42033 | 7366 | 130 |
1192141 | 1192141 | 2021-04-05 | Clinton | Pennsylvania | 42035 | 3174 | 59 |
1192142 | 1192142 | 2021-04-05 | Columbia | Pennsylvania | 42037 | 5009 | 128 |
1192143 | 1192143 | 2021-04-05 | Crawford | Pennsylvania | 42039 | 6708 | 144 |
1192144 | 1192144 | 2021-04-05 | Cumberland | Pennsylvania | 42041 | 18218 | 498 |
1192145 | 1192145 | 2021-04-05 | Dauphin | Pennsylvania | 42043 | 22744 | 524 |
1192146 | 1192146 | 2021-04-05 | Delaware | Pennsylvania | 42045 | 45808 | 1346 |
1192147 | 1192147 | 2021-04-05 | Elk | Pennsylvania | 42047 | 2604 | 37 |
1192148 | 1192148 | 2021-04-05 | Erie | Pennsylvania | 42049 | 18870 | 396 |
1192149 | 1192149 | 2021-04-05 | Fayette | Pennsylvania | 42051 | 11396 | 290 |
1192150 | 1192150 | 2021-04-05 | Forest | Pennsylvania | 42053 | 1396 | 21 |
1192151 | 1192151 | 2021-04-05 | Franklin | Pennsylvania | 42055 | 13669 | 341 |
1192152 | 1192152 | 2021-04-05 | Fulton | Pennsylvania | 42057 | 1204 | 15 |
1192153 | 1192153 | 2021-04-05 | Greene | Pennsylvania | 42059 | 2913 | 37 |
1192154 | 1192154 | 2021-04-05 | Huntingdon | Pennsylvania | 42061 | 4606 | 127 |
1192155 | 1192155 | 2021-04-05 | Indiana | Pennsylvania | 42063 | 5435 | 163 |
1192156 | 1192156 | 2021-04-05 | Jefferson | Pennsylvania | 42065 | 3012 | 91 |
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);