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
county >30
- Delaware 115
- Wayne 115
- Montgomery 114
- Monroe 112
- Philadelphia 111
- Bucks 110
- Northampton 109
- Pike 109
- Chester 108
- Cumberland 108
- Washington 108
- Allegheny 107
- Lehigh 106
- Luzerne 106
- Beaver 104
- Adams 103
- Berks 103
- Lackawanna 103
- York 103
- Lancaster 102
- Lebanon 102
- Westmoreland 102
- Centre 101
- Erie 101
- Franklin 101
- Potter 101
- Butler 100
- Montour 100
- Columbia 99
- Dauphin 99
- …
state 1
- Pennsylvania · 6,613 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282972 | 282972 | 2020-06-28 | Adams | Pennsylvania | 42001 | 328 | 12 |
282973 | 282973 | 2020-06-28 | Allegheny | Pennsylvania | 42003 | 2568 | 186 |
282974 | 282974 | 2020-06-28 | Armstrong | Pennsylvania | 42005 | 73 | 6 |
282975 | 282975 | 2020-06-28 | Beaver | Pennsylvania | 42007 | 648 | 78 |
282976 | 282976 | 2020-06-28 | Bedford | Pennsylvania | 42009 | 81 | 3 |
282977 | 282977 | 2020-06-28 | Berks | Pennsylvania | 42011 | 4498 | 350 |
282978 | 282978 | 2020-06-28 | Blair | Pennsylvania | 42013 | 71 | 1 |
282979 | 282979 | 2020-06-28 | Bradford | Pennsylvania | 42015 | 56 | 3 |
282980 | 282980 | 2020-06-28 | Bucks | Pennsylvania | 42017 | 5718 | 564 |
282981 | 282981 | 2020-06-28 | Butler | Pennsylvania | 42019 | 295 | 13 |
282982 | 282982 | 2020-06-28 | Cambria | Pennsylvania | 42021 | 77 | 3 |
282983 | 282983 | 2020-06-28 | Cameron | Pennsylvania | 42023 | 3 | 0 |
282984 | 282984 | 2020-06-28 | Carbon | Pennsylvania | 42025 | 274 | 25 |
282985 | 282985 | 2020-06-28 | Centre | Pennsylvania | 42027 | 201 | 7 |
282986 | 282986 | 2020-06-28 | Chester | Pennsylvania | 42029 | 3658 | 323 |
282987 | 282987 | 2020-06-28 | Clarion | Pennsylvania | 42031 | 35 | 2 |
282988 | 282988 | 2020-06-28 | Clearfield | Pennsylvania | 42033 | 72 | 0 |
282989 | 282989 | 2020-06-28 | Clinton | Pennsylvania | 42035 | 75 | 4 |
282990 | 282990 | 2020-06-28 | Columbia | Pennsylvania | 42037 | 399 | 33 |
282991 | 282991 | 2020-06-28 | Crawford | Pennsylvania | 42039 | 53 | 0 |
282992 | 282992 | 2020-06-28 | Cumberland | Pennsylvania | 42041 | 840 | 63 |
282993 | 282993 | 2020-06-28 | Dauphin | Pennsylvania | 42043 | 1942 | 132 |
282994 | 282994 | 2020-06-28 | Delaware | Pennsylvania | 42045 | 7165 | 696 |
282995 | 282995 | 2020-06-28 | Elk | Pennsylvania | 42047 | 13 | 0 |
282996 | 282996 | 2020-06-28 | Erie | Pennsylvania | 42049 | 589 | 13 |
282997 | 282997 | 2020-06-28 | Fayette | Pennsylvania | 42051 | 111 | 4 |
282998 | 282998 | 2020-06-28 | Forest | Pennsylvania | 42053 | 7 | 0 |
282999 | 282999 | 2020-06-28 | Franklin | Pennsylvania | 42055 | 913 | 42 |
283000 | 283000 | 2020-06-28 | Fulton | Pennsylvania | 42057 | 18 | 1 |
283001 | 283001 | 2020-06-28 | Greene | Pennsylvania | 42059 | 39 | 0 |
283002 | 283002 | 2020-06-28 | Huntingdon | Pennsylvania | 42061 | 245 | 4 |
283003 | 283003 | 2020-06-28 | Indiana | Pennsylvania | 42063 | 102 | 6 |
283004 | 283004 | 2020-06-28 | Jefferson | Pennsylvania | 42065 | 21 | 1 |
283005 | 283005 | 2020-06-28 | Juniata | Pennsylvania | 42067 | 111 | 5 |
283006 | 283006 | 2020-06-28 | Lackawanna | Pennsylvania | 42069 | 1684 | 202 |
283007 | 283007 | 2020-06-28 | Lancaster | Pennsylvania | 42071 | 4388 | 356 |
283008 | 283008 | 2020-06-28 | Lawrence | Pennsylvania | 42073 | 102 | 9 |
283009 | 283009 | 2020-06-28 | Lebanon | Pennsylvania | 42075 | 1324 | 43 |
283010 | 283010 | 2020-06-28 | Lehigh | Pennsylvania | 42077 | 4214 | 292 |
283011 | 283011 | 2020-06-28 | Luzerne | Pennsylvania | 42079 | 2903 | 176 |
283012 | 283012 | 2020-06-28 | Lycoming | Pennsylvania | 42081 | 177 | 19 |
283013 | 283013 | 2020-06-28 | McKean | Pennsylvania | 42083 | 15 | 1 |
283014 | 283014 | 2020-06-28 | Mercer | Pennsylvania | 42085 | 135 | 6 |
283015 | 283015 | 2020-06-28 | Mifflin | Pennsylvania | 42087 | 62 | 1 |
283016 | 283016 | 2020-06-28 | Monroe | Pennsylvania | 42089 | 1405 | 108 |
283017 | 283017 | 2020-06-28 | Montgomery | Pennsylvania | 42091 | 8377 | 798 |
283018 | 283018 | 2020-06-28 | Montour | Pennsylvania | 42093 | 73 | 0 |
283019 | 283019 | 2020-06-28 | Northampton | Pennsylvania | 42095 | 3389 | 265 |
283020 | 283020 | 2020-06-28 | Northumberland | Pennsylvania | 42097 | 299 | 5 |
283021 | 283021 | 2020-06-28 | Perry | Pennsylvania | 42099 | 86 | 5 |
283022 | 283022 | 2020-06-28 | Philadelphia | Pennsylvania | 42101 | 25693 | 1592 |
283023 | 283023 | 2020-06-28 | Pike | Pennsylvania | 42103 | 493 | 20 |
283024 | 283024 | 2020-06-28 | Potter | Pennsylvania | 42105 | 15 | 0 |
283025 | 283025 | 2020-06-28 | Schuylkill | Pennsylvania | 42107 | 740 | 44 |
283026 | 283026 | 2020-06-28 | Snyder | Pennsylvania | 42109 | 65 | 2 |
283027 | 283027 | 2020-06-28 | Somerset | Pennsylvania | 42111 | 61 | 1 |
283028 | 283028 | 2020-06-28 | Sullivan | Pennsylvania | 42113 | 5 | 0 |
283029 | 283029 | 2020-06-28 | Susquehanna | Pennsylvania | 42115 | 181 | 22 |
283030 | 283030 | 2020-06-28 | Tioga | Pennsylvania | 42117 | 24 | 2 |
283031 | 283031 | 2020-06-28 | Union | Pennsylvania | 42119 | 90 | 2 |
283032 | 283032 | 2020-06-28 | Venango | Pennsylvania | 42121 | 18 | 0 |
283033 | 283033 | 2020-06-28 | Warren | Pennsylvania | 42123 | 5 | 0 |
283034 | 283034 | 2020-06-28 | Washington | Pennsylvania | 42125 | 211 | 6 |
283035 | 283035 | 2020-06-28 | Wayne | Pennsylvania | 42127 | 139 | 9 |
283036 | 283036 | 2020-06-28 | Westmoreland | Pennsylvania | 42129 | 620 | 38 |
283037 | 283037 | 2020-06-28 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
283038 | 283038 | 2020-06-28 | York | Pennsylvania | 42133 | 1456 | 44 |
279826 | 279826 | 2020-06-27 | Adams | Pennsylvania | 42001 | 327 | 12 |
279827 | 279827 | 2020-06-27 | Allegheny | Pennsylvania | 42003 | 2472 | 186 |
279828 | 279828 | 2020-06-27 | Armstrong | Pennsylvania | 42005 | 73 | 6 |
279829 | 279829 | 2020-06-27 | Beaver | Pennsylvania | 42007 | 642 | 78 |
279830 | 279830 | 2020-06-27 | Bedford | Pennsylvania | 42009 | 77 | 3 |
279831 | 279831 | 2020-06-27 | Berks | Pennsylvania | 42011 | 4487 | 350 |
279832 | 279832 | 2020-06-27 | Blair | Pennsylvania | 42013 | 71 | 1 |
279833 | 279833 | 2020-06-27 | Bradford | Pennsylvania | 42015 | 56 | 3 |
279834 | 279834 | 2020-06-27 | Bucks | Pennsylvania | 42017 | 5704 | 563 |
279835 | 279835 | 2020-06-27 | Butler | Pennsylvania | 42019 | 291 | 13 |
279836 | 279836 | 2020-06-27 | Cambria | Pennsylvania | 42021 | 73 | 3 |
279837 | 279837 | 2020-06-27 | Cameron | Pennsylvania | 42023 | 3 | 0 |
279838 | 279838 | 2020-06-27 | Carbon | Pennsylvania | 42025 | 273 | 25 |
279839 | 279839 | 2020-06-27 | Centre | Pennsylvania | 42027 | 200 | 7 |
279840 | 279840 | 2020-06-27 | Chester | Pennsylvania | 42029 | 3649 | 323 |
279841 | 279841 | 2020-06-27 | Clarion | Pennsylvania | 42031 | 33 | 2 |
279842 | 279842 | 2020-06-27 | Clearfield | Pennsylvania | 42033 | 72 | 0 |
279843 | 279843 | 2020-06-27 | Clinton | Pennsylvania | 42035 | 75 | 4 |
279844 | 279844 | 2020-06-27 | Columbia | Pennsylvania | 42037 | 399 | 33 |
279845 | 279845 | 2020-06-27 | Crawford | Pennsylvania | 42039 | 53 | 0 |
279846 | 279846 | 2020-06-27 | Cumberland | Pennsylvania | 42041 | 833 | 63 |
279847 | 279847 | 2020-06-27 | Dauphin | Pennsylvania | 42043 | 1932 | 132 |
279848 | 279848 | 2020-06-27 | Delaware | Pennsylvania | 42045 | 7165 | 696 |
279849 | 279849 | 2020-06-27 | Elk | Pennsylvania | 42047 | 12 | 0 |
279850 | 279850 | 2020-06-27 | Erie | Pennsylvania | 42049 | 582 | 13 |
279851 | 279851 | 2020-06-27 | Fayette | Pennsylvania | 42051 | 110 | 4 |
279852 | 279852 | 2020-06-27 | Forest | Pennsylvania | 42053 | 7 | 0 |
279853 | 279853 | 2020-06-27 | Franklin | Pennsylvania | 42055 | 912 | 42 |
279854 | 279854 | 2020-06-27 | Fulton | Pennsylvania | 42057 | 18 | 1 |
279855 | 279855 | 2020-06-27 | Greene | Pennsylvania | 42059 | 35 | 0 |
279856 | 279856 | 2020-06-27 | Huntingdon | Pennsylvania | 42061 | 245 | 4 |
279857 | 279857 | 2020-06-27 | Indiana | Pennsylvania | 42063 | 101 | 6 |
279858 | 279858 | 2020-06-27 | Jefferson | Pennsylvania | 42065 | 21 | 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);