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 312
- 42127 312
- 42091 311
- 42089 309
- 42101 308
- 42017 307
- 42095 306
- 42103 306
- 42029 305
- 42041 305
- 42125 305
- 42003 304
- 42077 303
- 42079 303
- 42007 301
- 42001 300
- 42011 300
- 42069 300
- 42133 300
- 42071 299
- 42075 299
- 42129 299
- 42027 298
- 42049 298
- 42055 298
- 42105 298
- 42019 297
- 42093 297
- 42037 296
- 42043 296
- …
county >30
- Delaware 312
- Wayne 312
- Montgomery 311
- Monroe 309
- Philadelphia 308
- Bucks 307
- Northampton 306
- Pike 306
- Chester 305
- Cumberland 305
- Washington 305
- Allegheny 304
- Lehigh 303
- Luzerne 303
- Beaver 301
- Adams 300
- Berks 300
- Lackawanna 300
- York 300
- Lancaster 299
- Lebanon 299
- Westmoreland 299
- Centre 298
- Erie 298
- Franklin 298
- Potter 298
- Butler 297
- Montour 297
- Columbia 296
- Dauphin 296
- …
state 1
- Pennsylvania · 19,812 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919454 | 919454 | 2021-01-11 | Adams | Pennsylvania | 42001 | 5401 | 114 |
919455 | 919455 | 2021-01-11 | Allegheny | Pennsylvania | 42003 | 61075 | 1192 |
919456 | 919456 | 2021-01-11 | Armstrong | Pennsylvania | 42005 | 3997 | 84 |
919457 | 919457 | 2021-01-11 | Beaver | Pennsylvania | 42007 | 9621 | 276 |
919458 | 919458 | 2021-01-11 | Bedford | Pennsylvania | 42009 | 3233 | 100 |
919459 | 919459 | 2021-01-11 | Berks | Pennsylvania | 42011 | 26732 | 629 |
919460 | 919460 | 2021-01-11 | Blair | Pennsylvania | 42013 | 8862 | 192 |
919461 | 919461 | 2021-01-11 | Bradford | Pennsylvania | 42015 | 3414 | 60 |
919462 | 919462 | 2021-01-11 | Bucks | Pennsylvania | 42017 | 34438 | 942 |
919463 | 919463 | 2021-01-11 | Butler | Pennsylvania | 42019 | 10937 | 252 |
919464 | 919464 | 2021-01-11 | Cambria | Pennsylvania | 42021 | 9673 | 291 |
919465 | 919465 | 2021-01-11 | Cameron | Pennsylvania | 42023 | 187 | 4 |
919466 | 919466 | 2021-01-11 | Carbon | Pennsylvania | 42025 | 3486 | 97 |
919467 | 919467 | 2021-01-11 | Centre | Pennsylvania | 42027 | 9785 | 153 |
919468 | 919468 | 2021-01-11 | Chester | Pennsylvania | 42029 | 23366 | 579 |
919469 | 919469 | 2021-01-11 | Clarion | Pennsylvania | 42031 | 2249 | 51 |
919470 | 919470 | 2021-01-11 | Clearfield | Pennsylvania | 42033 | 4822 | 57 |
919471 | 919471 | 2021-01-11 | Clinton | Pennsylvania | 42035 | 2225 | 32 |
919472 | 919472 | 2021-01-11 | Columbia | Pennsylvania | 42037 | 3401 | 88 |
919473 | 919473 | 2021-01-11 | Crawford | Pennsylvania | 42039 | 5370 | 101 |
919474 | 919474 | 2021-01-11 | Cumberland | Pennsylvania | 42041 | 11998 | 346 |
919475 | 919475 | 2021-01-11 | Dauphin | Pennsylvania | 42043 | 15678 | 358 |
919476 | 919476 | 2021-01-11 | Delaware | Pennsylvania | 42045 | 32836 | 1024 |
919477 | 919477 | 2021-01-11 | Elk | Pennsylvania | 42047 | 1675 | 23 |
919478 | 919478 | 2021-01-11 | Erie | Pennsylvania | 42049 | 13330 | 264 |
919479 | 919479 | 2021-01-11 | Fayette | Pennsylvania | 42051 | 8514 | 147 |
919480 | 919480 | 2021-01-11 | Forest | Pennsylvania | 42053 | 422 | 6 |
919481 | 919481 | 2021-01-11 | Franklin | Pennsylvania | 42055 | 10035 | 261 |
919482 | 919482 | 2021-01-11 | Fulton | Pennsylvania | 42057 | 851 | 11 |
919483 | 919483 | 2021-01-11 | Greene | Pennsylvania | 42059 | 2022 | 22 |
919484 | 919484 | 2021-01-11 | Huntingdon | Pennsylvania | 42061 | 3454 | 92 |
919485 | 919485 | 2021-01-11 | Indiana | Pennsylvania | 42063 | 4363 | 132 |
919486 | 919486 | 2021-01-11 | Jefferson | Pennsylvania | 42065 | 2156 | 55 |
919487 | 919487 | 2021-01-11 | Juniata | Pennsylvania | 42067 | 1498 | 61 |
919488 | 919488 | 2021-01-11 | Lackawanna | Pennsylvania | 42069 | 10319 | 282 |
919489 | 919489 | 2021-01-11 | Lancaster | Pennsylvania | 42071 | 31951 | 791 |
919490 | 919490 | 2021-01-11 | Lawrence | Pennsylvania | 42073 | 4826 | 140 |
919491 | 919491 | 2021-01-11 | Lebanon | Pennsylvania | 42075 | 10150 | 173 |
919492 | 919492 | 2021-01-11 | Lehigh | Pennsylvania | 42077 | 23815 | 556 |
919493 | 919493 | 2021-01-11 | Luzerne | Pennsylvania | 42079 | 19608 | 500 |
919494 | 919494 | 2021-01-11 | Lycoming | Pennsylvania | 42081 | 6909 | 148 |
919495 | 919495 | 2021-01-11 | McKean | Pennsylvania | 42083 | 2090 | 33 |
919496 | 919496 | 2021-01-11 | Mercer | Pennsylvania | 42085 | 6672 | 172 |
919497 | 919497 | 2021-01-11 | Mifflin | Pennsylvania | 42087 | 3798 | 129 |
919498 | 919498 | 2021-01-11 | Monroe | Pennsylvania | 42089 | 7163 | 217 |
919499 | 919499 | 2021-01-11 | Montgomery | Pennsylvania | 42091 | 41270 | 1228 |
919500 | 919500 | 2021-01-11 | Montour | Pennsylvania | 42093 | 1422 | 31 |
919501 | 919501 | 2021-01-11 | Northampton | Pennsylvania | 42095 | 19334 | 481 |
919502 | 919502 | 2021-01-11 | Northumberland | Pennsylvania | 42097 | 5765 | 254 |
919503 | 919503 | 2021-01-11 | Perry | Pennsylvania | 42099 | 2038 | 52 |
919504 | 919504 | 2021-01-11 | Philadelphia | Pennsylvania | 42101 | 100092 | 2621 |
919505 | 919505 | 2021-01-11 | Pike | Pennsylvania | 42103 | 1720 | 36 |
919506 | 919506 | 2021-01-11 | Potter | Pennsylvania | 42105 | 708 | 15 |
919507 | 919507 | 2021-01-11 | Schuylkill | Pennsylvania | 42107 | 9485 | 273 |
919508 | 919508 | 2021-01-11 | Snyder | Pennsylvania | 42109 | 2168 | 50 |
919509 | 919509 | 2021-01-11 | Somerset | Pennsylvania | 42111 | 5656 | 111 |
919510 | 919510 | 2021-01-11 | Sullivan | Pennsylvania | 42113 | 186 | 3 |
919511 | 919511 | 2021-01-11 | Susquehanna | Pennsylvania | 42115 | 1212 | 41 |
919512 | 919512 | 2021-01-11 | Tioga | Pennsylvania | 42117 | 2089 | 77 |
919513 | 919513 | 2021-01-11 | Union | Pennsylvania | 42119 | 3416 | 52 |
919514 | 919514 | 2021-01-11 | Venango | Pennsylvania | 42121 | 2757 | 57 |
919515 | 919515 | 2021-01-11 | Warren | Pennsylvania | 42123 | 1773 | 53 |
919516 | 919516 | 2021-01-11 | Washington | Pennsylvania | 42125 | 10515 | 157 |
919517 | 919517 | 2021-01-11 | Wayne | Pennsylvania | 42127 | 2257 | 27 |
919518 | 919518 | 2021-01-11 | Westmoreland | Pennsylvania | 42129 | 22026 | 483 |
919519 | 919519 | 2021-01-11 | Wyoming | Pennsylvania | 42131 | 912 | 32 |
919520 | 919520 | 2021-01-11 | York | Pennsylvania | 42133 | 26759 | 490 |
916209 | 916209 | 2021-01-10 | Adams | Pennsylvania | 42001 | 5341 | 112 |
916210 | 916210 | 2021-01-10 | Allegheny | Pennsylvania | 42003 | 60707 | 1180 |
916211 | 916211 | 2021-01-10 | Armstrong | Pennsylvania | 42005 | 3992 | 82 |
916212 | 916212 | 2021-01-10 | Beaver | Pennsylvania | 42007 | 9560 | 275 |
916213 | 916213 | 2021-01-10 | Bedford | Pennsylvania | 42009 | 3224 | 100 |
916214 | 916214 | 2021-01-10 | Berks | Pennsylvania | 42011 | 26512 | 628 |
916215 | 916215 | 2021-01-10 | Blair | Pennsylvania | 42013 | 8797 | 192 |
916216 | 916216 | 2021-01-10 | Bradford | Pennsylvania | 42015 | 3394 | 60 |
916217 | 916217 | 2021-01-10 | Bucks | Pennsylvania | 42017 | 34178 | 940 |
916218 | 916218 | 2021-01-10 | Butler | Pennsylvania | 42019 | 10863 | 246 |
916219 | 916219 | 2021-01-10 | Cambria | Pennsylvania | 42021 | 9638 | 286 |
916220 | 916220 | 2021-01-10 | Cameron | Pennsylvania | 42023 | 186 | 4 |
916221 | 916221 | 2021-01-10 | Carbon | Pennsylvania | 42025 | 3456 | 97 |
916222 | 916222 | 2021-01-10 | Centre | Pennsylvania | 42027 | 9743 | 152 |
916223 | 916223 | 2021-01-10 | Chester | Pennsylvania | 42029 | 23197 | 577 |
916224 | 916224 | 2021-01-10 | Clarion | Pennsylvania | 42031 | 2242 | 51 |
916225 | 916225 | 2021-01-10 | Clearfield | Pennsylvania | 42033 | 4791 | 56 |
916226 | 916226 | 2021-01-10 | Clinton | Pennsylvania | 42035 | 2206 | 32 |
916227 | 916227 | 2021-01-10 | Columbia | Pennsylvania | 42037 | 3369 | 88 |
916228 | 916228 | 2021-01-10 | Crawford | Pennsylvania | 42039 | 5346 | 101 |
916229 | 916229 | 2021-01-10 | Cumberland | Pennsylvania | 42041 | 11883 | 344 |
916230 | 916230 | 2021-01-10 | Dauphin | Pennsylvania | 42043 | 15529 | 355 |
916231 | 916231 | 2021-01-10 | Delaware | Pennsylvania | 42045 | 32640 | 1023 |
916232 | 916232 | 2021-01-10 | Elk | Pennsylvania | 42047 | 1670 | 23 |
916233 | 916233 | 2021-01-10 | Erie | Pennsylvania | 42049 | 13120 | 262 |
916234 | 916234 | 2021-01-10 | Fayette | Pennsylvania | 42051 | 8472 | 146 |
916235 | 916235 | 2021-01-10 | Forest | Pennsylvania | 42053 | 415 | 6 |
916236 | 916236 | 2021-01-10 | Franklin | Pennsylvania | 42055 | 9952 | 261 |
916237 | 916237 | 2021-01-10 | Fulton | Pennsylvania | 42057 | 847 | 11 |
916238 | 916238 | 2021-01-10 | Greene | Pennsylvania | 42059 | 2004 | 22 |
916239 | 916239 | 2021-01-10 | Huntingdon | Pennsylvania | 42061 | 3429 | 92 |
916240 | 916240 | 2021-01-10 | Indiana | Pennsylvania | 42063 | 4341 | 132 |
916241 | 916241 | 2021-01-10 | Jefferson | Pennsylvania | 42065 | 2145 | 54 |
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);