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 194
- 42127 194
- 42091 193
- 42089 191
- 42101 190
- 42017 189
- 42095 188
- 42103 188
- 42029 187
- 42041 187
- 42125 187
- 42003 186
- 42077 185
- 42079 185
- 42007 183
- 42001 182
- 42011 182
- 42069 182
- 42133 182
- 42071 181
- 42075 181
- 42129 181
- 42027 180
- 42049 180
- 42055 180
- 42105 180
- 42019 179
- 42093 179
- 42037 178
- 42043 178
- …
county >30
- Delaware 194
- Wayne 194
- Montgomery 193
- Monroe 191
- Philadelphia 190
- Bucks 189
- Northampton 188
- Pike 188
- Chester 187
- Cumberland 187
- Washington 187
- Allegheny 186
- Lehigh 185
- Luzerne 185
- Beaver 183
- Adams 182
- Berks 182
- Lackawanna 182
- York 182
- Lancaster 181
- Lebanon 181
- Westmoreland 181
- Centre 180
- Erie 180
- Franklin 180
- Potter 180
- Butler 179
- Montour 179
- Columbia 178
- Dauphin 178
- …
state 1
- Pennsylvania · 11,906 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536677 | 536677 | 2020-09-15 | Adams | Pennsylvania | 42001 | 749 | 25 |
536678 | 536678 | 2020-09-15 | Allegheny | Pennsylvania | 42003 | 11358 | 363 |
536679 | 536679 | 2020-09-15 | Armstrong | Pennsylvania | 42005 | 386 | 13 |
536680 | 536680 | 2020-09-15 | Beaver | Pennsylvania | 42007 | 1796 | 110 |
536681 | 536681 | 2020-09-15 | Bedford | Pennsylvania | 42009 | 213 | 6 |
536682 | 536682 | 2020-09-15 | Berks | Pennsylvania | 42011 | 6641 | 386 |
536683 | 536683 | 2020-09-15 | Blair | Pennsylvania | 42013 | 536 | 13 |
536684 | 536684 | 2020-09-15 | Bradford | Pennsylvania | 42015 | 114 | 3 |
536685 | 536685 | 2020-09-15 | Bucks | Pennsylvania | 42017 | 8349 | 596 |
536686 | 536686 | 2020-09-15 | Butler | Pennsylvania | 42019 | 945 | 21 |
536687 | 536687 | 2020-09-15 | Cambria | Pennsylvania | 42021 | 527 | 7 |
536688 | 536688 | 2020-09-15 | Cameron | Pennsylvania | 42023 | 8 | 0 |
536689 | 536689 | 2020-09-15 | Carbon | Pennsylvania | 42025 | 439 | 28 |
536690 | 536690 | 2020-09-15 | Centre | Pennsylvania | 42027 | 1449 | 11 |
536691 | 536691 | 2020-09-15 | Chester | Pennsylvania | 42029 | 6357 | 362 |
536692 | 536692 | 2020-09-15 | Clarion | Pennsylvania | 42031 | 112 | 3 |
536693 | 536693 | 2020-09-15 | Clearfield | Pennsylvania | 42033 | 288 | 1 |
536694 | 536694 | 2020-09-15 | Clinton | Pennsylvania | 42035 | 176 | 5 |
536695 | 536695 | 2020-09-15 | Columbia | Pennsylvania | 42037 | 843 | 35 |
536696 | 536696 | 2020-09-15 | Crawford | Pennsylvania | 42039 | 257 | 3 |
536697 | 536697 | 2020-09-15 | Cumberland | Pennsylvania | 42041 | 1696 | 73 |
536698 | 536698 | 2020-09-15 | Dauphin | Pennsylvania | 42043 | 3597 | 169 |
536699 | 536699 | 2020-09-15 | Delaware | Pennsylvania | 42045 | 11004 | 780 |
536700 | 536700 | 2020-09-15 | Elk | Pennsylvania | 42047 | 66 | 2 |
536701 | 536701 | 2020-09-15 | Erie | Pennsylvania | 42049 | 1435 | 37 |
536702 | 536702 | 2020-09-15 | Fayette | Pennsylvania | 42051 | 750 | 7 |
536703 | 536703 | 2020-09-15 | Forest | Pennsylvania | 42053 | 14 | 0 |
536704 | 536704 | 2020-09-15 | Franklin | Pennsylvania | 42055 | 1677 | 49 |
536705 | 536705 | 2020-09-15 | Fulton | Pennsylvania | 42057 | 41 | 2 |
536706 | 536706 | 2020-09-15 | Greene | Pennsylvania | 42059 | 160 | 1 |
536707 | 536707 | 2020-09-15 | Huntingdon | Pennsylvania | 42061 | 393 | 6 |
536708 | 536708 | 2020-09-15 | Indiana | Pennsylvania | 42063 | 553 | 11 |
536709 | 536709 | 2020-09-15 | Jefferson | Pennsylvania | 42065 | 104 | 2 |
536710 | 536710 | 2020-09-15 | Juniata | Pennsylvania | 42067 | 169 | 6 |
536711 | 536711 | 2020-09-15 | Lackawanna | Pennsylvania | 42069 | 2329 | 215 |
536712 | 536712 | 2020-09-15 | Lancaster | Pennsylvania | 42071 | 7354 | 447 |
536713 | 536713 | 2020-09-15 | Lawrence | Pennsylvania | 42073 | 487 | 21 |
536714 | 536714 | 2020-09-15 | Lebanon | Pennsylvania | 42075 | 1857 | 58 |
536715 | 536715 | 2020-09-15 | Lehigh | Pennsylvania | 42077 | 5409 | 345 |
536716 | 536716 | 2020-09-15 | Luzerne | Pennsylvania | 42079 | 3966 | 189 |
536717 | 536717 | 2020-09-15 | Lycoming | Pennsylvania | 42081 | 596 | 23 |
536718 | 536718 | 2020-09-15 | McKean | Pennsylvania | 42083 | 51 | 2 |
536719 | 536719 | 2020-09-15 | Mercer | Pennsylvania | 42085 | 659 | 13 |
536720 | 536720 | 2020-09-15 | Mifflin | Pennsylvania | 42087 | 198 | 1 |
536721 | 536721 | 2020-09-15 | Monroe | Pennsylvania | 42089 | 1766 | 129 |
536722 | 536722 | 2020-09-15 | Montgomery | Pennsylvania | 42091 | 11710 | 868 |
536723 | 536723 | 2020-09-15 | Montour | Pennsylvania | 42093 | 161 | 5 |
536724 | 536724 | 2020-09-15 | Northampton | Pennsylvania | 42095 | 4277 | 304 |
536725 | 536725 | 2020-09-15 | Northumberland | Pennsylvania | 42097 | 811 | 44 |
536726 | 536726 | 2020-09-15 | Perry | Pennsylvania | 42099 | 190 | 6 |
536727 | 536727 | 2020-09-15 | Philadelphia | Pennsylvania | 42101 | 35344 | 1792 |
536728 | 536728 | 2020-09-15 | Pike | Pennsylvania | 42103 | 557 | 21 |
536729 | 536729 | 2020-09-15 | Potter | Pennsylvania | 42105 | 25 | 0 |
536730 | 536730 | 2020-09-15 | Schuylkill | Pennsylvania | 42107 | 1044 | 52 |
536731 | 536731 | 2020-09-15 | Snyder | Pennsylvania | 42109 | 224 | 3 |
536732 | 536732 | 2020-09-15 | Somerset | Pennsylvania | 42111 | 195 | 3 |
536733 | 536733 | 2020-09-15 | Sullivan | Pennsylvania | 42113 | 10 | 0 |
536734 | 536734 | 2020-09-15 | Susquehanna | Pennsylvania | 42115 | 288 | 28 |
536735 | 536735 | 2020-09-15 | Tioga | Pennsylvania | 42117 | 53 | 3 |
536736 | 536736 | 2020-09-15 | Union | Pennsylvania | 42119 | 439 | 6 |
536737 | 536737 | 2020-09-15 | Venango | Pennsylvania | 42121 | 77 | 1 |
536738 | 536738 | 2020-09-15 | Warren | Pennsylvania | 42123 | 43 | 1 |
536739 | 536739 | 2020-09-15 | Washington | Pennsylvania | 42125 | 1232 | 28 |
536740 | 536740 | 2020-09-15 | Wayne | Pennsylvania | 42127 | 204 | 10 |
536741 | 536741 | 2020-09-15 | Westmoreland | Pennsylvania | 42129 | 1993 | 49 |
536742 | 536742 | 2020-09-15 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
536743 | 536743 | 2020-09-15 | York | Pennsylvania | 42133 | 4258 | 134 |
533441 | 533441 | 2020-09-14 | Adams | Pennsylvania | 42001 | 742 | 25 |
533442 | 533442 | 2020-09-14 | Allegheny | Pennsylvania | 42003 | 11268 | 362 |
533443 | 533443 | 2020-09-14 | Armstrong | Pennsylvania | 42005 | 384 | 13 |
533444 | 533444 | 2020-09-14 | Beaver | Pennsylvania | 42007 | 1783 | 109 |
533445 | 533445 | 2020-09-14 | Bedford | Pennsylvania | 42009 | 212 | 6 |
533446 | 533446 | 2020-09-14 | Berks | Pennsylvania | 42011 | 6587 | 386 |
533447 | 533447 | 2020-09-14 | Blair | Pennsylvania | 42013 | 532 | 13 |
533448 | 533448 | 2020-09-14 | Bradford | Pennsylvania | 42015 | 108 | 3 |
533449 | 533449 | 2020-09-14 | Bucks | Pennsylvania | 42017 | 8294 | 595 |
533450 | 533450 | 2020-09-14 | Butler | Pennsylvania | 42019 | 938 | 21 |
533451 | 533451 | 2020-09-14 | Cambria | Pennsylvania | 42021 | 525 | 7 |
533452 | 533452 | 2020-09-14 | Cameron | Pennsylvania | 42023 | 8 | 0 |
533453 | 533453 | 2020-09-14 | Carbon | Pennsylvania | 42025 | 438 | 28 |
533454 | 533454 | 2020-09-14 | Centre | Pennsylvania | 42027 | 1237 | 11 |
533455 | 533455 | 2020-09-14 | Chester | Pennsylvania | 42029 | 6294 | 362 |
533456 | 533456 | 2020-09-14 | Clarion | Pennsylvania | 42031 | 112 | 3 |
533457 | 533457 | 2020-09-14 | Clearfield | Pennsylvania | 42033 | 286 | 1 |
533458 | 533458 | 2020-09-14 | Clinton | Pennsylvania | 42035 | 170 | 5 |
533459 | 533459 | 2020-09-14 | Columbia | Pennsylvania | 42037 | 842 | 35 |
533460 | 533460 | 2020-09-14 | Crawford | Pennsylvania | 42039 | 254 | 3 |
533461 | 533461 | 2020-09-14 | Cumberland | Pennsylvania | 42041 | 1685 | 73 |
533462 | 533462 | 2020-09-14 | Dauphin | Pennsylvania | 42043 | 3580 | 169 |
533463 | 533463 | 2020-09-14 | Delaware | Pennsylvania | 42045 | 10966 | 780 |
533464 | 533464 | 2020-09-14 | Elk | Pennsylvania | 42047 | 66 | 2 |
533465 | 533465 | 2020-09-14 | Erie | Pennsylvania | 42049 | 1423 | 37 |
533466 | 533466 | 2020-09-14 | Fayette | Pennsylvania | 42051 | 747 | 7 |
533467 | 533467 | 2020-09-14 | Forest | Pennsylvania | 42053 | 14 | 0 |
533468 | 533468 | 2020-09-14 | Franklin | Pennsylvania | 42055 | 1658 | 49 |
533469 | 533469 | 2020-09-14 | Fulton | Pennsylvania | 42057 | 40 | 2 |
533470 | 533470 | 2020-09-14 | Greene | Pennsylvania | 42059 | 159 | 1 |
533471 | 533471 | 2020-09-14 | Huntingdon | Pennsylvania | 42061 | 392 | 6 |
533472 | 533472 | 2020-09-14 | Indiana | Pennsylvania | 42063 | 534 | 11 |
533473 | 533473 | 2020-09-14 | Jefferson | Pennsylvania | 42065 | 101 | 2 |
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);