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 2020-04-25 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
88869 | 88869 | 2020-04-25 | Adams | Pennsylvania | 42001 | 113 | 2 |
88870 | 88870 | 2020-04-25 | Allegheny | Pennsylvania | 42003 | 1198 | 73 |
88871 | 88871 | 2020-04-25 | Armstrong | Pennsylvania | 42005 | 46 | 2 |
88872 | 88872 | 2020-04-25 | Beaver | Pennsylvania | 42007 | 359 | 46 |
88873 | 88873 | 2020-04-25 | Bedford | Pennsylvania | 42009 | 21 | 1 |
88874 | 88874 | 2020-04-25 | Berks | Pennsylvania | 42011 | 2406 | 88 |
88875 | 88875 | 2020-04-25 | Blair | Pennsylvania | 42013 | 21 | 0 |
88876 | 88876 | 2020-04-25 | Bradford | Pennsylvania | 42015 | 28 | 5 |
88877 | 88877 | 2020-04-25 | Bucks | Pennsylvania | 42017 | 2469 | 139 |
88878 | 88878 | 2020-04-25 | Butler | Pennsylvania | 42019 | 168 | 6 |
88879 | 88879 | 2020-04-25 | Cambria | Pennsylvania | 42021 | 21 | 2 |
88880 | 88880 | 2020-04-25 | Cameron | Pennsylvania | 42023 | 1 | 0 |
88881 | 88881 | 2020-04-25 | Carbon | Pennsylvania | 42025 | 162 | 12 |
88882 | 88882 | 2020-04-25 | Centre | Pennsylvania | 42027 | 81 | 2 |
88883 | 88883 | 2020-04-25 | Chester | Pennsylvania | 42029 | 1174 | 82 |
88884 | 88884 | 2020-04-25 | Clarion | Pennsylvania | 42031 | 22 | 1 |
88885 | 88885 | 2020-04-25 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
88886 | 88886 | 2020-04-25 | Clinton | Pennsylvania | 42035 | 18 | 0 |
88887 | 88887 | 2020-04-25 | Columbia | Pennsylvania | 42037 | 257 | 8 |
88888 | 88888 | 2020-04-25 | Crawford | Pennsylvania | 42039 | 19 | 0 |
88889 | 88889 | 2020-04-25 | Cumberland | Pennsylvania | 42041 | 250 | 8 |
88890 | 88890 | 2020-04-25 | Dauphin | Pennsylvania | 42043 | 492 | 18 |
88891 | 88891 | 2020-04-25 | Delaware | Pennsylvania | 42045 | 3213 | 142 |
88892 | 88892 | 2020-04-25 | Elk | Pennsylvania | 42047 | 2 | 0 |
88893 | 88893 | 2020-04-25 | Erie | Pennsylvania | 42049 | 79 | 1 |
88894 | 88894 | 2020-04-25 | Fayette | Pennsylvania | 42051 | 79 | 4 |
88895 | 88895 | 2020-04-25 | Forest | Pennsylvania | 42053 | 7 | 0 |
88896 | 88896 | 2020-04-25 | Franklin | Pennsylvania | 42055 | 181 | 10 |
88897 | 88897 | 2020-04-25 | Fulton | Pennsylvania | 42057 | 3 | 0 |
88898 | 88898 | 2020-04-25 | Greene | Pennsylvania | 42059 | 25 | 0 |
88899 | 88899 | 2020-04-25 | Huntingdon | Pennsylvania | 42061 | 22 | 0 |
88900 | 88900 | 2020-04-25 | Indiana | Pennsylvania | 42063 | 63 | 4 |
88901 | 88901 | 2020-04-25 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
88902 | 88902 | 2020-04-25 | Juniata | Pennsylvania | 42067 | 77 | 0 |
88903 | 88903 | 2020-04-25 | Lackawanna | Pennsylvania | 42069 | 772 | 63 |
88904 | 88904 | 2020-04-25 | Lancaster | Pennsylvania | 42071 | 1501 | 140 |
88905 | 88905 | 2020-04-25 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
88906 | 88906 | 2020-04-25 | Lebanon | Pennsylvania | 42075 | 592 | 8 |
88907 | 88907 | 2020-04-25 | Lehigh | Pennsylvania | 42077 | 2551 | 50 |
88908 | 88908 | 2020-04-25 | Luzerne | Pennsylvania | 42079 | 1962 | 66 |
88909 | 88909 | 2020-04-25 | Lycoming | Pennsylvania | 42081 | 53 | 2 |
88910 | 88910 | 2020-04-25 | McKean | Pennsylvania | 42083 | 5 | 0 |
88911 | 88911 | 2020-04-25 | Mercer | Pennsylvania | 42085 | 64 | 1 |
88912 | 88912 | 2020-04-25 | Mifflin | Pennsylvania | 42087 | 26 | 0 |
88913 | 88913 | 2020-04-25 | Monroe | Pennsylvania | 42089 | 1054 | 46 |
88914 | 88914 | 2020-04-25 | Montgomery | Pennsylvania | 42091 | 3627 | 214 |
88915 | 88915 | 2020-04-25 | Montour | Pennsylvania | 42093 | 48 | 0 |
88916 | 88916 | 2020-04-25 | Northampton | Pennsylvania | 42095 | 1780 | 49 |
88917 | 88917 | 2020-04-25 | Northumberland | Pennsylvania | 42097 | 87 | 0 |
88918 | 88918 | 2020-04-25 | Perry | Pennsylvania | 42099 | 26 | 1 |
88919 | 88919 | 2020-04-25 | Philadelphia | Pennsylvania | 42101 | 12329 | 466 |
88920 | 88920 | 2020-04-25 | Pike | Pennsylvania | 42103 | 347 | 12 |
88921 | 88921 | 2020-04-25 | Potter | Pennsylvania | 42105 | 4 | 0 |
88922 | 88922 | 2020-04-25 | Schuylkill | Pennsylvania | 42107 | 311 | 7 |
88923 | 88923 | 2020-04-25 | Snyder | Pennsylvania | 42109 | 32 | 1 |
88924 | 88924 | 2020-04-25 | Somerset | Pennsylvania | 42111 | 25 | 0 |
88925 | 88925 | 2020-04-25 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
88926 | 88926 | 2020-04-25 | Susquehanna | Pennsylvania | 42115 | 77 | 4 |
88927 | 88927 | 2020-04-25 | Tioga | Pennsylvania | 42117 | 14 | 2 |
88928 | 88928 | 2020-04-25 | Union | Pennsylvania | 42119 | 31 | 0 |
88929 | 88929 | 2020-04-25 | Venango | Pennsylvania | 42121 | 7 | 0 |
88930 | 88930 | 2020-04-25 | Warren | Pennsylvania | 42123 | 1 | 1 |
88931 | 88931 | 2020-04-25 | Washington | Pennsylvania | 42125 | 99 | 2 |
88932 | 88932 | 2020-04-25 | Wayne | Pennsylvania | 42127 | 92 | 3 |
88933 | 88933 | 2020-04-25 | Westmoreland | Pennsylvania | 42129 | 360 | 27 |
88934 | 88934 | 2020-04-25 | Wyoming | Pennsylvania | 42131 | 17 | 2 |
88935 | 88935 | 2020-04-25 | York | Pennsylvania | 42133 | 578 | 13 |
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);