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 2021-06-04 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1386937 | 1386937 | 2021-06-04 | Adams | Pennsylvania | 42001 | 9591 | 185 |
1386938 | 1386938 | 2021-06-04 | Allegheny | Pennsylvania | 42003 | 101446 | 1986 |
1386939 | 1386939 | 2021-06-04 | Armstrong | Pennsylvania | 42005 | 5984 | 145 |
1386940 | 1386940 | 2021-06-04 | Beaver | Pennsylvania | 42007 | 15453 | 384 |
1386941 | 1386941 | 2021-06-04 | Bedford | Pennsylvania | 42009 | 4658 | 138 |
1386942 | 1386942 | 2021-06-04 | Berks | Pennsylvania | 42011 | 48101 | 1035 |
1386943 | 1386943 | 2021-06-04 | Blair | Pennsylvania | 42013 | 13468 | 339 |
1386944 | 1386944 | 2021-06-04 | Bradford | Pennsylvania | 42015 | 6079 | 91 |
1386945 | 1386945 | 2021-06-04 | Bucks | Pennsylvania | 42017 | 60640 | 1306 |
1386946 | 1386946 | 2021-06-04 | Butler | Pennsylvania | 42019 | 17515 | 417 |
1386947 | 1386947 | 2021-06-04 | Cambria | Pennsylvania | 42021 | 14670 | 432 |
1386948 | 1386948 | 2021-06-04 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1386949 | 1386949 | 2021-06-04 | Carbon | Pennsylvania | 42025 | 6369 | 172 |
1386950 | 1386950 | 2021-06-04 | Centre | Pennsylvania | 42027 | 16869 | 224 |
1386951 | 1386951 | 2021-06-04 | Chester | Pennsylvania | 42029 | 40698 | 818 |
1386952 | 1386952 | 2021-06-04 | Clarion | Pennsylvania | 42031 | 3186 | 93 |
1386953 | 1386953 | 2021-06-04 | Clearfield | Pennsylvania | 42033 | 8601 | 148 |
1386954 | 1386954 | 2021-06-04 | Clinton | Pennsylvania | 42035 | 3686 | 66 |
1386955 | 1386955 | 2021-06-04 | Columbia | Pennsylvania | 42037 | 5860 | 133 |
1386956 | 1386956 | 2021-06-04 | Crawford | Pennsylvania | 42039 | 7476 | 153 |
1386957 | 1386957 | 2021-06-04 | Cumberland | Pennsylvania | 42041 | 20461 | 524 |
1386958 | 1386958 | 2021-06-04 | Dauphin | Pennsylvania | 42043 | 26002 | 552 |
1386959 | 1386959 | 2021-06-04 | Delaware | Pennsylvania | 42045 | 52210 | 1449 |
1386960 | 1386960 | 2021-06-04 | Elk | Pennsylvania | 42047 | 2865 | 40 |
1386961 | 1386961 | 2021-06-04 | Erie | Pennsylvania | 42049 | 21093 | 416 |
1386962 | 1386962 | 2021-06-04 | Fayette | Pennsylvania | 42051 | 13252 | 323 |
1386963 | 1386963 | 2021-06-04 | Forest | Pennsylvania | 42053 | 1433 | 21 |
1386964 | 1386964 | 2021-06-04 | Franklin | Pennsylvania | 42055 | 15357 | 371 |
1386965 | 1386965 | 2021-06-04 | Fulton | Pennsylvania | 42057 | 1359 | 15 |
1386966 | 1386966 | 2021-06-04 | Greene | Pennsylvania | 42059 | 3315 | 40 |
1386967 | 1386967 | 2021-06-04 | Huntingdon | Pennsylvania | 42061 | 5115 | 132 |
1386968 | 1386968 | 2021-06-04 | Indiana | Pennsylvania | 42063 | 6375 | 177 |
1386969 | 1386969 | 2021-06-04 | Jefferson | Pennsylvania | 42065 | 3334 | 99 |
1386970 | 1386970 | 2021-06-04 | Juniata | Pennsylvania | 42067 | 2134 | 87 |
1386971 | 1386971 | 2021-06-04 | Lackawanna | Pennsylvania | 42069 | 18461 | 474 |
1386972 | 1386972 | 2021-06-04 | Lancaster | Pennsylvania | 42071 | 55206 | 1155 |
1386973 | 1386973 | 2021-06-04 | Lawrence | Pennsylvania | 42073 | 7603 | 212 |
1386974 | 1386974 | 2021-06-04 | Lebanon | Pennsylvania | 42075 | 16135 | 291 |
1386975 | 1386975 | 2021-06-04 | Lehigh | Pennsylvania | 42077 | 39674 | 858 |
1386976 | 1386976 | 2021-06-04 | Luzerne | Pennsylvania | 42079 | 31886 | 815 |
1386977 | 1386977 | 2021-06-04 | Lycoming | Pennsylvania | 42081 | 11891 | 288 |
1386978 | 1386978 | 2021-06-04 | McKean | Pennsylvania | 42083 | 3795 | 72 |
1386979 | 1386979 | 2021-06-04 | Mercer | Pennsylvania | 42085 | 9635 | 259 |
1386980 | 1386980 | 2021-06-04 | Mifflin | Pennsylvania | 42087 | 5403 | 178 |
1386981 | 1386981 | 2021-06-04 | Monroe | Pennsylvania | 42089 | 14718 | 319 |
1386982 | 1386982 | 2021-06-04 | Montgomery | Pennsylvania | 42091 | 70163 | 1720 |
1386983 | 1386983 | 2021-06-04 | Montour | Pennsylvania | 42093 | 2016 | 67 |
1386984 | 1386984 | 2021-06-04 | Northampton | Pennsylvania | 42095 | 35722 | 713 |
1386985 | 1386985 | 2021-06-04 | Northumberland | Pennsylvania | 42097 | 9658 | 357 |
1386986 | 1386986 | 2021-06-04 | Perry | Pennsylvania | 42099 | 3838 | 100 |
1386987 | 1386987 | 2021-06-04 | Philadelphia | Pennsylvania | 42101 | 153521 | 3701 |
1386988 | 1386988 | 2021-06-04 | Pike | Pennsylvania | 42103 | 3999 | 54 |
1386989 | 1386989 | 2021-06-04 | Potter | Pennsylvania | 42105 | 1187 | 24 |
1386990 | 1386990 | 2021-06-04 | Schuylkill | Pennsylvania | 42107 | 14741 | 408 |
1386991 | 1386991 | 2021-06-04 | Snyder | Pennsylvania | 42109 | 3669 | 85 |
1386992 | 1386992 | 2021-06-04 | Somerset | Pennsylvania | 42111 | 8012 | 213 |
1386993 | 1386993 | 2021-06-04 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1386994 | 1386994 | 2021-06-04 | Susquehanna | Pennsylvania | 42115 | 2642 | 62 |
1386995 | 1386995 | 2021-06-04 | Tioga | Pennsylvania | 42117 | 3075 | 109 |
1386996 | 1386996 | 2021-06-04 | Union | Pennsylvania | 42119 | 6136 | 88 |
1386997 | 1386997 | 2021-06-04 | Venango | Pennsylvania | 42121 | 4073 | 97 |
1386998 | 1386998 | 2021-06-04 | Warren | Pennsylvania | 42123 | 2628 | 103 |
1386999 | 1386999 | 2021-06-04 | Washington | Pennsylvania | 42125 | 17809 | 302 |
1387000 | 1387000 | 2021-06-04 | Wayne | Pennsylvania | 42127 | 4115 | 80 |
1387001 | 1387001 | 2021-06-04 | Westmoreland | Pennsylvania | 42129 | 34191 | 769 |
1387002 | 1387002 | 2021-06-04 | Wyoming | Pennsylvania | 42131 | 1981 | 54 |
1387003 | 1387003 | 2021-06-04 | York | Pennsylvania | 42133 | 46516 | 815 |
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);