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 131
- 42127 131
- 42091 130
- 42089 128
- 42101 127
- 42017 126
- 42095 125
- 42103 125
- 42029 124
- 42041 124
- 42125 124
- 42003 123
- 42077 122
- 42079 122
- 42007 120
- 42001 119
- 42011 119
- 42069 119
- 42133 119
- 42071 118
- 42075 118
- 42129 118
- 42027 117
- 42049 117
- 42055 117
- 42105 117
- 42019 116
- 42093 116
- 42037 115
- 42043 115
- …
county >30
- Delaware 131
- Wayne 131
- Montgomery 130
- Monroe 128
- Philadelphia 127
- Bucks 126
- Northampton 125
- Pike 125
- Chester 124
- Cumberland 124
- Washington 124
- Allegheny 123
- Lehigh 122
- Luzerne 122
- Beaver 120
- Adams 119
- Berks 119
- Lackawanna 119
- York 119
- Lancaster 118
- Lebanon 118
- Westmoreland 118
- Centre 117
- Erie 117
- Franklin 117
- Potter 117
- Butler 116
- Montour 116
- Columbia 115
- Dauphin 115
- …
state 1
- Pennsylvania · 7,685 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333664 | 333664 | 2020-07-14 | Adams | Pennsylvania | 42001 | 399 | 14 |
333665 | 333665 | 2020-07-14 | Allegheny | Pennsylvania | 42003 | 5364 | 199 |
333666 | 333666 | 2020-07-14 | Armstrong | Pennsylvania | 42005 | 88 | 6 |
333667 | 333667 | 2020-07-14 | Beaver | Pennsylvania | 42007 | 870 | 79 |
333668 | 333668 | 2020-07-14 | Bedford | Pennsylvania | 42009 | 93 | 4 |
333669 | 333669 | 2020-07-14 | Berks | Pennsylvania | 42011 | 4710 | 358 |
333670 | 333670 | 2020-07-14 | Blair | Pennsylvania | 42013 | 107 | 1 |
333671 | 333671 | 2020-07-14 | Bradford | Pennsylvania | 42015 | 59 | 3 |
333672 | 333672 | 2020-07-14 | Bucks | Pennsylvania | 42017 | 6137 | 572 |
333673 | 333673 | 2020-07-14 | Butler | Pennsylvania | 42019 | 444 | 13 |
333674 | 333674 | 2020-07-14 | Cambria | Pennsylvania | 42021 | 137 | 3 |
333675 | 333675 | 2020-07-14 | Cameron | Pennsylvania | 42023 | 4 | 0 |
333676 | 333676 | 2020-07-14 | Carbon | Pennsylvania | 42025 | 301 | 27 |
333677 | 333677 | 2020-07-14 | Centre | Pennsylvania | 42027 | 253 | 8 |
333678 | 333678 | 2020-07-14 | Chester | Pennsylvania | 42029 | 4103 | 335 |
333679 | 333679 | 2020-07-14 | Clarion | Pennsylvania | 42031 | 66 | 2 |
333680 | 333680 | 2020-07-14 | Clearfield | Pennsylvania | 42033 | 95 | 0 |
333681 | 333681 | 2020-07-14 | Clinton | Pennsylvania | 42035 | 96 | 5 |
333682 | 333682 | 2020-07-14 | Columbia | Pennsylvania | 42037 | 421 | 35 |
333683 | 333683 | 2020-07-14 | Crawford | Pennsylvania | 42039 | 80 | 1 |
333684 | 333684 | 2020-07-14 | Cumberland | Pennsylvania | 42041 | 961 | 66 |
333685 | 333685 | 2020-07-14 | Dauphin | Pennsylvania | 42043 | 2309 | 149 |
333686 | 333686 | 2020-07-14 | Delaware | Pennsylvania | 42045 | 7650 | 709 |
333687 | 333687 | 2020-07-14 | Elk | Pennsylvania | 42047 | 31 | 0 |
333688 | 333688 | 2020-07-14 | Erie | Pennsylvania | 42049 | 740 | 13 |
333689 | 333689 | 2020-07-14 | Fayette | Pennsylvania | 42051 | 213 | 4 |
333690 | 333690 | 2020-07-14 | Forest | Pennsylvania | 42053 | 7 | 0 |
333691 | 333691 | 2020-07-14 | Franklin | Pennsylvania | 42055 | 1016 | 46 |
333692 | 333692 | 2020-07-14 | Fulton | Pennsylvania | 42057 | 19 | 1 |
333693 | 333693 | 2020-07-14 | Greene | Pennsylvania | 42059 | 72 | 0 |
333694 | 333694 | 2020-07-14 | Huntingdon | Pennsylvania | 42061 | 260 | 4 |
333695 | 333695 | 2020-07-14 | Indiana | Pennsylvania | 42063 | 169 | 6 |
333696 | 333696 | 2020-07-14 | Jefferson | Pennsylvania | 42065 | 41 | 1 |
333697 | 333697 | 2020-07-14 | Juniata | Pennsylvania | 42067 | 116 | 6 |
333698 | 333698 | 2020-07-14 | Lackawanna | Pennsylvania | 42069 | 1770 | 211 |
333699 | 333699 | 2020-07-14 | Lancaster | Pennsylvania | 42071 | 4876 | 386 |
333700 | 333700 | 2020-07-14 | Lawrence | Pennsylvania | 42073 | 200 | 9 |
333701 | 333701 | 2020-07-14 | Lebanon | Pennsylvania | 42075 | 1474 | 50 |
333702 | 333702 | 2020-07-14 | Lehigh | Pennsylvania | 42077 | 4450 | 329 |
333703 | 333703 | 2020-07-14 | Luzerne | Pennsylvania | 42079 | 3025 | 181 |
333704 | 333704 | 2020-07-14 | Lycoming | Pennsylvania | 42081 | 249 | 20 |
333705 | 333705 | 2020-07-14 | McKean | Pennsylvania | 42083 | 20 | 1 |
333706 | 333706 | 2020-07-14 | Mercer | Pennsylvania | 42085 | 186 | 6 |
333707 | 333707 | 2020-07-14 | Mifflin | Pennsylvania | 42087 | 74 | 1 |
333708 | 333708 | 2020-07-14 | Monroe | Pennsylvania | 42089 | 1474 | 111 |
333709 | 333709 | 2020-07-14 | Montgomery | Pennsylvania | 42091 | 8907 | 829 |
333710 | 333710 | 2020-07-14 | Montour | Pennsylvania | 42093 | 80 | 2 |
333711 | 333711 | 2020-07-14 | Northampton | Pennsylvania | 42095 | 3558 | 281 |
333712 | 333712 | 2020-07-14 | Northumberland | Pennsylvania | 42097 | 351 | 10 |
333713 | 333713 | 2020-07-14 | Perry | Pennsylvania | 42099 | 95 | 5 |
333714 | 333714 | 2020-07-14 | Philadelphia | Pennsylvania | 42101 | 27723 | 1646 |
333715 | 333715 | 2020-07-14 | Pike | Pennsylvania | 42103 | 507 | 21 |
333716 | 333716 | 2020-07-14 | Potter | Pennsylvania | 42105 | 18 | 0 |
333717 | 333717 | 2020-07-14 | Schuylkill | Pennsylvania | 42107 | 779 | 48 |
333718 | 333718 | 2020-07-14 | Snyder | Pennsylvania | 42109 | 74 | 2 |
333719 | 333719 | 2020-07-14 | Somerset | Pennsylvania | 42111 | 84 | 1 |
333720 | 333720 | 2020-07-14 | Sullivan | Pennsylvania | 42113 | 10 | 0 |
333721 | 333721 | 2020-07-14 | Susquehanna | Pennsylvania | 42115 | 195 | 25 |
333722 | 333722 | 2020-07-14 | Tioga | Pennsylvania | 42117 | 30 | 2 |
333723 | 333723 | 2020-07-14 | Union | Pennsylvania | 42119 | 105 | 2 |
333724 | 333724 | 2020-07-14 | Venango | Pennsylvania | 42121 | 46 | 0 |
333725 | 333725 | 2020-07-14 | Warren | Pennsylvania | 42123 | 10 | 1 |
333726 | 333726 | 2020-07-14 | Washington | Pennsylvania | 42125 | 465 | 6 |
333727 | 333727 | 2020-07-14 | Wayne | Pennsylvania | 42127 | 141 | 8 |
333728 | 333728 | 2020-07-14 | Westmoreland | Pennsylvania | 42129 | 1033 | 39 |
333729 | 333729 | 2020-07-14 | Wyoming | Pennsylvania | 42131 | 48 | 7 |
333730 | 333730 | 2020-07-14 | York | Pennsylvania | 42133 | 1872 | 63 |
330472 | 330472 | 2020-07-13 | Adams | Pennsylvania | 42001 | 398 | 14 |
330473 | 330473 | 2020-07-13 | Allegheny | Pennsylvania | 42003 | 5033 | 198 |
330474 | 330474 | 2020-07-13 | Armstrong | Pennsylvania | 42005 | 86 | 6 |
330475 | 330475 | 2020-07-13 | Beaver | Pennsylvania | 42007 | 845 | 79 |
330476 | 330476 | 2020-07-13 | Bedford | Pennsylvania | 42009 | 92 | 4 |
330477 | 330477 | 2020-07-13 | Berks | Pennsylvania | 42011 | 4700 | 358 |
330478 | 330478 | 2020-07-13 | Blair | Pennsylvania | 42013 | 105 | 1 |
330479 | 330479 | 2020-07-13 | Bradford | Pennsylvania | 42015 | 59 | 3 |
330480 | 330480 | 2020-07-13 | Bucks | Pennsylvania | 42017 | 6105 | 572 |
330481 | 330481 | 2020-07-13 | Butler | Pennsylvania | 42019 | 429 | 13 |
330482 | 330482 | 2020-07-13 | Cambria | Pennsylvania | 42021 | 137 | 3 |
330483 | 330483 | 2020-07-13 | Cameron | Pennsylvania | 42023 | 4 | 0 |
330484 | 330484 | 2020-07-13 | Carbon | Pennsylvania | 42025 | 299 | 27 |
330485 | 330485 | 2020-07-13 | Centre | Pennsylvania | 42027 | 251 | 8 |
330486 | 330486 | 2020-07-13 | Chester | Pennsylvania | 42029 | 4064 | 335 |
330487 | 330487 | 2020-07-13 | Clarion | Pennsylvania | 42031 | 63 | 2 |
330488 | 330488 | 2020-07-13 | Clearfield | Pennsylvania | 42033 | 93 | 0 |
330489 | 330489 | 2020-07-13 | Clinton | Pennsylvania | 42035 | 96 | 5 |
330490 | 330490 | 2020-07-13 | Columbia | Pennsylvania | 42037 | 420 | 35 |
330491 | 330491 | 2020-07-13 | Crawford | Pennsylvania | 42039 | 78 | 1 |
330492 | 330492 | 2020-07-13 | Cumberland | Pennsylvania | 42041 | 951 | 66 |
330493 | 330493 | 2020-07-13 | Dauphin | Pennsylvania | 42043 | 2296 | 149 |
330494 | 330494 | 2020-07-13 | Delaware | Pennsylvania | 42045 | 7569 | 709 |
330495 | 330495 | 2020-07-13 | Elk | Pennsylvania | 42047 | 30 | 0 |
330496 | 330496 | 2020-07-13 | Erie | Pennsylvania | 42049 | 718 | 13 |
330497 | 330497 | 2020-07-13 | Fayette | Pennsylvania | 42051 | 202 | 4 |
330498 | 330498 | 2020-07-13 | Forest | Pennsylvania | 42053 | 7 | 0 |
330499 | 330499 | 2020-07-13 | Franklin | Pennsylvania | 42055 | 1006 | 46 |
330500 | 330500 | 2020-07-13 | Fulton | Pennsylvania | 42057 | 19 | 1 |
330501 | 330501 | 2020-07-13 | Greene | Pennsylvania | 42059 | 70 | 0 |
330502 | 330502 | 2020-07-13 | Huntingdon | Pennsylvania | 42061 | 260 | 4 |
330503 | 330503 | 2020-07-13 | Indiana | Pennsylvania | 42063 | 156 | 6 |
330504 | 330504 | 2020-07-13 | Jefferson | Pennsylvania | 42065 | 39 | 1 |
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);