ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2022-01-31 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2169957 | 2169957 | 2022-01-31 | Adams | Pennsylvania | 42001 | 23678 | 323 |
2169958 | 2169958 | 2022-01-31 | Allegheny | Pennsylvania | 42003 | 251318 | 2979 |
2169959 | 2169959 | 2022-01-31 | Armstrong | Pennsylvania | 42005 | 14593 | 299 |
2169960 | 2169960 | 2022-01-31 | Beaver | Pennsylvania | 42007 | 37867 | 673 |
2169961 | 2169961 | 2022-01-31 | Bedford | Pennsylvania | 42009 | 10393 | 249 |
2169962 | 2169962 | 2022-01-31 | Berks | Pennsylvania | 42011 | 99047 | 1486 |
2169963 | 2169963 | 2022-01-31 | Blair | Pennsylvania | 42013 | 27798 | 563 |
2169964 | 2169964 | 2022-01-31 | Bradford | Pennsylvania | 42015 | 14056 | 185 |
2169965 | 2169965 | 2022-01-31 | Bucks | Pennsylvania | 42017 | 118542 | 1733 |
2169966 | 2169966 | 2022-01-31 | Butler | Pennsylvania | 42019 | 42483 | 670 |
2169967 | 2169967 | 2022-01-31 | Cambria | Pennsylvania | 42021 | 32639 | 668 |
2169968 | 2169968 | 2022-01-31 | Cameron | Pennsylvania | 42023 | 766 | 18 |
2169969 | 2169969 | 2022-01-31 | Carbon | Pennsylvania | 42025 | 15304 | 259 |
2169970 | 2169970 | 2022-01-31 | Centre | Pennsylvania | 42027 | 33344 | 321 |
2169971 | 2169971 | 2022-01-31 | Chester | Pennsylvania | 42029 | 87448 | 1058 |
2169972 | 2169972 | 2022-01-31 | Clarion | Pennsylvania | 42031 | 7854 | 188 |
2169973 | 2169973 | 2022-01-31 | Clearfield | Pennsylvania | 42033 | 17977 | 296 |
2169974 | 2169974 | 2022-01-31 | Clinton | Pennsylvania | 42035 | 8503 | 117 |
2169975 | 2169975 | 2022-01-31 | Columbia | Pennsylvania | 42037 | 13983 | 214 |
2169976 | 2169976 | 2022-01-31 | Crawford | Pennsylvania | 42039 | 18931 | 278 |
2169977 | 2169977 | 2022-01-31 | Cumberland | Pennsylvania | 42041 | 48339 | 804 |
2169978 | 2169978 | 2022-01-31 | Dauphin | Pennsylvania | 42043 | 56744 | 863 |
2169979 | 2169979 | 2022-01-31 | Delaware | Pennsylvania | 42045 | 106126 | 1711 |
2169980 | 2169980 | 2022-01-31 | Elk | Pennsylvania | 42047 | 6719 | 84 |
2169981 | 2169981 | 2022-01-31 | Erie | Pennsylvania | 42049 | 54571 | 681 |
2169982 | 2169982 | 2022-01-31 | Fayette | Pennsylvania | 42051 | 28805 | 586 |
2169983 | 2169983 | 2022-01-31 | Forest | Pennsylvania | 42053 | 2137 | 34 |
2169984 | 2169984 | 2022-01-31 | Franklin | Pennsylvania | 42055 | 38474 | 617 |
2169985 | 2169985 | 2022-01-31 | Fulton | Pennsylvania | 42057 | 3868 | 58 |
2169986 | 2169986 | 2022-01-31 | Greene | Pennsylvania | 42059 | 7867 | 92 |
2169987 | 2169987 | 2022-01-31 | Huntingdon | Pennsylvania | 42061 | 10778 | 224 |
2169988 | 2169988 | 2022-01-31 | Indiana | Pennsylvania | 42063 | 16216 | 324 |
2169989 | 2169989 | 2022-01-31 | Jefferson | Pennsylvania | 42065 | 8384 | 204 |
2169990 | 2169990 | 2022-01-31 | Juniata | Pennsylvania | 42067 | 4503 | 165 |
2169991 | 2169991 | 2022-01-31 | Lackawanna | Pennsylvania | 42069 | 40571 | 664 |
2169992 | 2169992 | 2022-01-31 | Lancaster | Pennsylvania | 42071 | 116426 | 1725 |
2169993 | 2169993 | 2022-01-31 | Lawrence | Pennsylvania | 42073 | 18201 | 377 |
2169994 | 2169994 | 2022-01-31 | Lebanon | Pennsylvania | 42075 | 35374 | 464 |
2169995 | 2169995 | 2022-01-31 | Lehigh | Pennsylvania | 42077 | 86931 | 1161 |
2169996 | 2169996 | 2022-01-31 | Luzerne | Pennsylvania | 42079 | 70109 | 1197 |
2169997 | 2169997 | 2022-01-31 | Lycoming | Pennsylvania | 42081 | 26943 | 481 |
2169998 | 2169998 | 2022-01-31 | McKean | Pennsylvania | 42083 | 7680 | 124 |
2169999 | 2169999 | 2022-01-31 | Mercer | Pennsylvania | 42085 | 22533 | 460 |
2170000 | 2170000 | 2022-01-31 | Mifflin | Pennsylvania | 42087 | 11460 | 255 |
2170001 | 2170001 | 2022-01-31 | Monroe | Pennsylvania | 42089 | 35643 | 468 |
2170002 | 2170002 | 2022-01-31 | Montgomery | Pennsylvania | 42091 | 145001 | 2150 |
2170003 | 2170003 | 2022-01-31 | Montour | Pennsylvania | 42093 | 4251 | 84 |
2170004 | 2170004 | 2022-01-31 | Northampton | Pennsylvania | 42095 | 76968 | 1003 |
2170005 | 2170005 | 2022-01-31 | Northumberland | Pennsylvania | 42097 | 21624 | 495 |
2170006 | 2170006 | 2022-01-31 | Perry | Pennsylvania | 42099 | 8405 | 167 |
2170007 | 2170007 | 2022-01-31 | Philadelphia | Pennsylvania | 42101 | 296109 | 4664 |
2170008 | 2170008 | 2022-01-31 | Pike | Pennsylvania | 42103 | 9387 | 84 |
2170009 | 2170009 | 2022-01-31 | Potter | Pennsylvania | 42105 | 2967 | 86 |
2170010 | 2170010 | 2022-01-31 | Schuylkill | Pennsylvania | 42107 | 32871 | 628 |
2170011 | 2170011 | 2022-01-31 | Snyder | Pennsylvania | 42109 | 7687 | 145 |
2170012 | 2170012 | 2022-01-31 | Somerset | Pennsylvania | 42111 | 17756 | 370 |
2170013 | 2170013 | 2022-01-31 | Sullivan | Pennsylvania | 42113 | 1003 | 32 |
2170014 | 2170014 | 2022-01-31 | Susquehanna | Pennsylvania | 42115 | 7301 | 100 |
2170015 | 2170015 | 2022-01-31 | Tioga | Pennsylvania | 42117 | 7496 | 184 |
2170016 | 2170016 | 2022-01-31 | Union | Pennsylvania | 42119 | 11036 | 137 |
2170017 | 2170017 | 2022-01-31 | Venango | Pennsylvania | 42121 | 10790 | 218 |
2170018 | 2170018 | 2022-01-31 | Warren | Pennsylvania | 42123 | 6838 | 195 |
2170019 | 2170019 | 2022-01-31 | Washington | Pennsylvania | 42125 | 48271 | 582 |
2170020 | 2170020 | 2022-01-31 | Wayne | Pennsylvania | 42127 | 9565 | 154 |
2170021 | 2170021 | 2022-01-31 | Westmoreland | Pennsylvania | 42129 | 75550 | 1241 |
2170022 | 2170022 | 2022-01-31 | Wyoming | Pennsylvania | 42131 | 4775 | 96 |
2170023 | 2170023 | 2022-01-31 | York | Pennsylvania | 42133 | 113904 | 1366 |
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);