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 68
- 42045 466
- 42127 466
- 42091 465
- 42089 463
- 42101 462
- 42017 461
- 42095 460
- 42103 460
- 42029 459
- 42041 459
- 42125 459
- 42003 458
- 42077 457
- 42079 457
- 42007 455
- 42001 454
- 42011 454
- 42069 454
- 42133 454
- 42071 453
- 42075 453
- 42129 453
- 42027 452
- 42049 452
- 42055 452
- 42105 452
- 42019 451
- 42093 451
- 42037 450
- 42043 450
- 42051 450
- 42085 450
- 42107 450
- 42021 449
- 42005 448
- 42015 448
- 42025 448
- 42033 448
- 42067 448
- 42111 448
- 42059 447
- 42073 447
- 42081 447
- 42123 447
- 42013 446
- 42039 446
- 42063 446
- 42115 446
- 42097 445
- 42023 444
- 42031 444
- 42061 444
- 42083 444
- 42099 444
- 42109 444
- 42117 444
- 42087 443
- 42121 443
- 42119 442
- 42009 441
- 42053 439
- 42035 438
- 42113 437
- 42131 437
- 42057 436
- 42047 434
- 42065 434
- - 2
county 68
- Delaware 466
- Wayne 466
- Montgomery 465
- Monroe 463
- Philadelphia 462
- Bucks 461
- Northampton 460
- Pike 460
- Chester 459
- Cumberland 459
- Washington 459
- Allegheny 458
- Lehigh 457
- Luzerne 457
- Beaver 455
- Adams 454
- Berks 454
- Lackawanna 454
- York 454
- Lancaster 453
- Lebanon 453
- Westmoreland 453
- Centre 452
- Erie 452
- Franklin 452
- Potter 452
- Butler 451
- Montour 451
- Columbia 450
- Dauphin 450
- Fayette 450
- Mercer 450
- Schuylkill 450
- Cambria 449
- Armstrong 448
- Bradford 448
- Carbon 448
- Clearfield 448
- Juniata 448
- Somerset 448
- Greene 447
- Lawrence 447
- Lycoming 447
- Warren 447
- Blair 446
- Crawford 446
- Indiana 446
- Susquehanna 446
- Northumberland 445
- Cameron 444
- Clarion 444
- Huntingdon 444
- McKean 444
- Perry 444
- Snyder 444
- Tioga 444
- Mifflin 443
- Venango 443
- Union 442
- Bedford 441
- Forest 439
- Clinton 438
- Sullivan 437
- Wyoming 437
- Fulton 436
- Elk 434
- Jefferson 434
- Unknown 2
state 1
- Pennsylvania · 30,130 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419391 | 1419391 | 2021-06-14 | Adams | Pennsylvania | 42001 | 9633 | 186 |
1419392 | 1419392 | 2021-06-14 | Allegheny | Pennsylvania | 42003 | 101650 | 1999 |
1419393 | 1419393 | 2021-06-14 | Armstrong | Pennsylvania | 42005 | 6005 | 148 |
1419394 | 1419394 | 2021-06-14 | Beaver | Pennsylvania | 42007 | 15504 | 387 |
1419395 | 1419395 | 2021-06-14 | Bedford | Pennsylvania | 42009 | 4697 | 140 |
1419396 | 1419396 | 2021-06-14 | Berks | Pennsylvania | 42011 | 48309 | 1035 |
1419397 | 1419397 | 2021-06-14 | Blair | Pennsylvania | 42013 | 13508 | 340 |
1419398 | 1419398 | 2021-06-14 | Bradford | Pennsylvania | 42015 | 6105 | 93 |
1419399 | 1419399 | 2021-06-14 | Bucks | Pennsylvania | 42017 | 60741 | 1315 |
1419400 | 1419400 | 2021-06-14 | Butler | Pennsylvania | 42019 | 17565 | 418 |
1419401 | 1419401 | 2021-06-14 | Cambria | Pennsylvania | 42021 | 14768 | 437 |
1419402 | 1419402 | 2021-06-14 | Cameron | Pennsylvania | 42023 | 307 | 7 |
1419403 | 1419403 | 2021-06-14 | Carbon | Pennsylvania | 42025 | 6387 | 174 |
1419404 | 1419404 | 2021-06-14 | Centre | Pennsylvania | 42027 | 16894 | 224 |
1419405 | 1419405 | 2021-06-14 | Chester | Pennsylvania | 42029 | 40725 | 821 |
1419406 | 1419406 | 2021-06-14 | Clarion | Pennsylvania | 42031 | 3203 | 95 |
1419407 | 1419407 | 2021-06-14 | Clearfield | Pennsylvania | 42033 | 8635 | 150 |
1419408 | 1419408 | 2021-06-14 | Clinton | Pennsylvania | 42035 | 3707 | 66 |
1419409 | 1419409 | 2021-06-14 | Columbia | Pennsylvania | 42037 | 5889 | 134 |
1419410 | 1419410 | 2021-06-14 | Crawford | Pennsylvania | 42039 | 7525 | 153 |
1419411 | 1419411 | 2021-06-14 | Cumberland | Pennsylvania | 42041 | 20549 | 525 |
1419412 | 1419412 | 2021-06-14 | Dauphin | Pennsylvania | 42043 | 26069 | 556 |
1419413 | 1419413 | 2021-06-14 | Delaware | Pennsylvania | 42045 | 52338 | 1455 |
1419414 | 1419414 | 2021-06-14 | Elk | Pennsylvania | 42047 | 2868 | 41 |
1419415 | 1419415 | 2021-06-14 | Erie | Pennsylvania | 42049 | 21173 | 416 |
1419416 | 1419416 | 2021-06-14 | Fayette | Pennsylvania | 42051 | 13341 | 328 |
1419417 | 1419417 | 2021-06-14 | Forest | Pennsylvania | 42053 | 1433 | 21 |
1419418 | 1419418 | 2021-06-14 | Franklin | Pennsylvania | 42055 | 15415 | 371 |
1419419 | 1419419 | 2021-06-14 | Fulton | Pennsylvania | 42057 | 1364 | 15 |
1419420 | 1419420 | 2021-06-14 | Greene | Pennsylvania | 42059 | 3339 | 40 |
1419421 | 1419421 | 2021-06-14 | Huntingdon | Pennsylvania | 42061 | 5141 | 135 |
1419422 | 1419422 | 2021-06-14 | Indiana | Pennsylvania | 42063 | 6400 | 177 |
1419423 | 1419423 | 2021-06-14 | Jefferson | Pennsylvania | 42065 | 3340 | 99 |
1419424 | 1419424 | 2021-06-14 | Juniata | Pennsylvania | 42067 | 2136 | 87 |
1419425 | 1419425 | 2021-06-14 | Lackawanna | Pennsylvania | 42069 | 18500 | 480 |
1419426 | 1419426 | 2021-06-14 | Lancaster | Pennsylvania | 42071 | 55318 | 1158 |
1419427 | 1419427 | 2021-06-14 | Lawrence | Pennsylvania | 42073 | 7640 | 212 |
1419428 | 1419428 | 2021-06-14 | Lebanon | Pennsylvania | 42075 | 16171 | 293 |
1419429 | 1419429 | 2021-06-14 | Lehigh | Pennsylvania | 42077 | 39782 | 861 |
1419430 | 1419430 | 2021-06-14 | Luzerne | Pennsylvania | 42079 | 32012 | 821 |
1419431 | 1419431 | 2021-06-14 | Lycoming | Pennsylvania | 42081 | 11922 | 291 |
1419432 | 1419432 | 2021-06-14 | McKean | Pennsylvania | 42083 | 3805 | 72 |
1419433 | 1419433 | 2021-06-14 | Mercer | Pennsylvania | 42085 | 9673 | 261 |
1419434 | 1419434 | 2021-06-14 | Mifflin | Pennsylvania | 42087 | 5424 | 179 |
1419435 | 1419435 | 2021-06-14 | Monroe | Pennsylvania | 42089 | 14777 | 321 |
1419436 | 1419436 | 2021-06-14 | Montgomery | Pennsylvania | 42091 | 70295 | 1729 |
1419437 | 1419437 | 2021-06-14 | Montour | Pennsylvania | 42093 | 2024 | 67 |
1419438 | 1419438 | 2021-06-14 | Northampton | Pennsylvania | 42095 | 35801 | 715 |
1419439 | 1419439 | 2021-06-14 | Northumberland | Pennsylvania | 42097 | 9692 | 356 |
1419440 | 1419440 | 2021-06-14 | Perry | Pennsylvania | 42099 | 3846 | 100 |
1419441 | 1419441 | 2021-06-14 | Philadelphia | Pennsylvania | 42101 | 154094 | 3734 |
1419442 | 1419442 | 2021-06-14 | Pike | Pennsylvania | 42103 | 4018 | 54 |
1419443 | 1419443 | 2021-06-14 | Potter | Pennsylvania | 42105 | 1203 | 25 |
1419444 | 1419444 | 2021-06-14 | Schuylkill | Pennsylvania | 42107 | 14771 | 411 |
1419445 | 1419445 | 2021-06-14 | Snyder | Pennsylvania | 42109 | 3672 | 85 |
1419446 | 1419446 | 2021-06-14 | Somerset | Pennsylvania | 42111 | 8035 | 216 |
1419447 | 1419447 | 2021-06-14 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1419448 | 1419448 | 2021-06-14 | Susquehanna | Pennsylvania | 42115 | 2654 | 62 |
1419449 | 1419449 | 2021-06-14 | Tioga | Pennsylvania | 42117 | 3099 | 110 |
1419450 | 1419450 | 2021-06-14 | Union | Pennsylvania | 42119 | 6151 | 89 |
1419451 | 1419451 | 2021-06-14 | Venango | Pennsylvania | 42121 | 4084 | 99 |
1419452 | 1419452 | 2021-06-14 | Warren | Pennsylvania | 42123 | 2637 | 103 |
1419453 | 1419453 | 2021-06-14 | Washington | Pennsylvania | 42125 | 17869 | 304 |
1419454 | 1419454 | 2021-06-14 | Wayne | Pennsylvania | 42127 | 4128 | 82 |
1419455 | 1419455 | 2021-06-14 | Westmoreland | Pennsylvania | 42129 | 34295 | 770 |
1419456 | 1419456 | 2021-06-14 | Wyoming | Pennsylvania | 42131 | 1993 | 54 |
1419457 | 1419457 | 2021-06-14 | York | Pennsylvania | 42133 | 46863 | 821 |
1416146 | 1416146 | 2021-06-13 | Adams | Pennsylvania | 42001 | 9633 | 186 |
1416147 | 1416147 | 2021-06-13 | Allegheny | Pennsylvania | 42003 | 101646 | 1999 |
1416148 | 1416148 | 2021-06-13 | Armstrong | Pennsylvania | 42005 | 6005 | 148 |
1416149 | 1416149 | 2021-06-13 | Beaver | Pennsylvania | 42007 | 15504 | 387 |
1416150 | 1416150 | 2021-06-13 | Bedford | Pennsylvania | 42009 | 4696 | 140 |
1416151 | 1416151 | 2021-06-13 | Berks | Pennsylvania | 42011 | 48293 | 1035 |
1416152 | 1416152 | 2021-06-13 | Blair | Pennsylvania | 42013 | 13507 | 340 |
1416153 | 1416153 | 2021-06-13 | Bradford | Pennsylvania | 42015 | 6105 | 93 |
1416154 | 1416154 | 2021-06-13 | Bucks | Pennsylvania | 42017 | 60736 | 1315 |
1416155 | 1416155 | 2021-06-13 | Butler | Pennsylvania | 42019 | 17564 | 418 |
1416156 | 1416156 | 2021-06-13 | Cambria | Pennsylvania | 42021 | 14754 | 436 |
1416157 | 1416157 | 2021-06-13 | Cameron | Pennsylvania | 42023 | 307 | 7 |
1416158 | 1416158 | 2021-06-13 | Carbon | Pennsylvania | 42025 | 6387 | 174 |
1416159 | 1416159 | 2021-06-13 | Centre | Pennsylvania | 42027 | 16891 | 224 |
1416160 | 1416160 | 2021-06-13 | Chester | Pennsylvania | 42029 | 40723 | 821 |
1416161 | 1416161 | 2021-06-13 | Clarion | Pennsylvania | 42031 | 3202 | 95 |
1416162 | 1416162 | 2021-06-13 | Clearfield | Pennsylvania | 42033 | 8635 | 150 |
1416163 | 1416163 | 2021-06-13 | Clinton | Pennsylvania | 42035 | 3706 | 66 |
1416164 | 1416164 | 2021-06-13 | Columbia | Pennsylvania | 42037 | 5887 | 134 |
1416165 | 1416165 | 2021-06-13 | Crawford | Pennsylvania | 42039 | 7524 | 153 |
1416166 | 1416166 | 2021-06-13 | Cumberland | Pennsylvania | 42041 | 20548 | 525 |
1416167 | 1416167 | 2021-06-13 | Dauphin | Pennsylvania | 42043 | 26066 | 556 |
1416168 | 1416168 | 2021-06-13 | Delaware | Pennsylvania | 42045 | 52335 | 1454 |
1416169 | 1416169 | 2021-06-13 | Elk | Pennsylvania | 42047 | 2868 | 41 |
1416170 | 1416170 | 2021-06-13 | Erie | Pennsylvania | 42049 | 21171 | 416 |
1416171 | 1416171 | 2021-06-13 | Fayette | Pennsylvania | 42051 | 13337 | 328 |
1416172 | 1416172 | 2021-06-13 | Forest | Pennsylvania | 42053 | 1433 | 21 |
1416173 | 1416173 | 2021-06-13 | Franklin | Pennsylvania | 42055 | 15414 | 371 |
1416174 | 1416174 | 2021-06-13 | Fulton | Pennsylvania | 42057 | 1364 | 15 |
1416175 | 1416175 | 2021-06-13 | Greene | Pennsylvania | 42059 | 3338 | 40 |
1416176 | 1416176 | 2021-06-13 | Huntingdon | Pennsylvania | 42061 | 5141 | 135 |
1416177 | 1416177 | 2021-06-13 | Indiana | Pennsylvania | 42063 | 6393 | 177 |
1416178 | 1416178 | 2021-06-13 | Jefferson | Pennsylvania | 42065 | 3340 | 99 |
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);