ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-07-25" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
368884 | 368884 | 2020-07-25 | Adams | Pennsylvania | 42001 | 442 | 17 |
368885 | 368885 | 2020-07-25 | Allegheny | Pennsylvania | 42003 | 7161 | 222 |
368886 | 368886 | 2020-07-25 | Armstrong | Pennsylvania | 42005 | 151 | 6 |
368887 | 368887 | 2020-07-25 | Beaver | Pennsylvania | 42007 | 1101 | 82 |
368888 | 368888 | 2020-07-25 | Bedford | Pennsylvania | 42009 | 113 | 4 |
368889 | 368889 | 2020-07-25 | Berks | Pennsylvania | 42011 | 5008 | 362 |
368890 | 368890 | 2020-07-25 | Blair | Pennsylvania | 42013 | 171 | 2 |
368891 | 368891 | 2020-07-25 | Bradford | Pennsylvania | 42015 | 75 | 3 |
368892 | 368892 | 2020-07-25 | Bucks | Pennsylvania | 42017 | 6664 | 574 |
368893 | 368893 | 2020-07-25 | Butler | Pennsylvania | 42019 | 544 | 14 |
368894 | 368894 | 2020-07-25 | Cambria | Pennsylvania | 42021 | 215 | 3 |
368895 | 368895 | 2020-07-25 | Cameron | Pennsylvania | 42023 | 5 | 0 |
368896 | 368896 | 2020-07-25 | Carbon | Pennsylvania | 42025 | 345 | 28 |
368897 | 368897 | 2020-07-25 | Centre | Pennsylvania | 42027 | 313 | 9 |
368898 | 368898 | 2020-07-25 | Chester | Pennsylvania | 42029 | 4586 | 343 |
368899 | 368899 | 2020-07-25 | Clarion | Pennsylvania | 42031 | 72 | 2 |
368900 | 368900 | 2020-07-25 | Clearfield | Pennsylvania | 42033 | 114 | 0 |
368901 | 368901 | 2020-07-25 | Clinton | Pennsylvania | 42035 | 107 | 5 |
368902 | 368902 | 2020-07-25 | Columbia | Pennsylvania | 42037 | 446 | 35 |
368903 | 368903 | 2020-07-25 | Crawford | Pennsylvania | 42039 | 118 | 1 |
368904 | 368904 | 2020-07-25 | Cumberland | Pennsylvania | 42041 | 1106 | 70 |
368905 | 368905 | 2020-07-25 | Dauphin | Pennsylvania | 42043 | 2526 | 152 |
368906 | 368906 | 2020-07-25 | Delaware | Pennsylvania | 42045 | 8250 | 720 |
368907 | 368907 | 2020-07-25 | Elk | Pennsylvania | 42047 | 39 | 2 |
368908 | 368908 | 2020-07-25 | Erie | Pennsylvania | 42049 | 847 | 15 |
368909 | 368909 | 2020-07-25 | Fayette | Pennsylvania | 42051 | 307 | 4 |
368910 | 368910 | 2020-07-25 | Forest | Pennsylvania | 42053 | 7 | 0 |
368911 | 368911 | 2020-07-25 | Franklin | Pennsylvania | 42055 | 1186 | 46 |
368912 | 368912 | 2020-07-25 | Fulton | Pennsylvania | 42057 | 21 | 2 |
368913 | 368913 | 2020-07-25 | Greene | Pennsylvania | 42059 | 97 | 0 |
368914 | 368914 | 2020-07-25 | Huntingdon | Pennsylvania | 42061 | 279 | 4 |
368915 | 368915 | 2020-07-25 | Indiana | Pennsylvania | 42063 | 206 | 6 |
368916 | 368916 | 2020-07-25 | Jefferson | Pennsylvania | 42065 | 49 | 1 |
368917 | 368917 | 2020-07-25 | Juniata | Pennsylvania | 42067 | 122 | 6 |
368918 | 368918 | 2020-07-25 | Lackawanna | Pennsylvania | 42069 | 1851 | 212 |
368919 | 368919 | 2020-07-25 | Lancaster | Pennsylvania | 42071 | 5263 | 401 |
368920 | 368920 | 2020-07-25 | Lawrence | Pennsylvania | 42073 | 280 | 11 |
368921 | 368921 | 2020-07-25 | Lebanon | Pennsylvania | 42075 | 1541 | 54 |
368922 | 368922 | 2020-07-25 | Lehigh | Pennsylvania | 42077 | 4667 | 334 |
368923 | 368923 | 2020-07-25 | Luzerne | Pennsylvania | 42079 | 3130 | 183 |
368924 | 368924 | 2020-07-25 | Lycoming | Pennsylvania | 42081 | 292 | 20 |
368925 | 368925 | 2020-07-25 | McKean | Pennsylvania | 42083 | 26 | 1 |
368926 | 368926 | 2020-07-25 | Mercer | Pennsylvania | 42085 | 293 | 9 |
368927 | 368927 | 2020-07-25 | Mifflin | Pennsylvania | 42087 | 89 | 1 |
368928 | 368928 | 2020-07-25 | Monroe | Pennsylvania | 42089 | 1551 | 120 |
368929 | 368929 | 2020-07-25 | Montgomery | Pennsylvania | 42091 | 9444 | 844 |
368930 | 368930 | 2020-07-25 | Montour | Pennsylvania | 42093 | 89 | 3 |
368931 | 368931 | 2020-07-25 | Northampton | Pennsylvania | 42095 | 3727 | 289 |
368932 | 368932 | 2020-07-25 | Northumberland | Pennsylvania | 42097 | 379 | 11 |
368933 | 368933 | 2020-07-25 | Perry | Pennsylvania | 42099 | 106 | 5 |
368934 | 368934 | 2020-07-25 | Philadelphia | Pennsylvania | 42101 | 29303 | 1676 |
368935 | 368935 | 2020-07-25 | Pike | Pennsylvania | 42103 | 521 | 21 |
368936 | 368936 | 2020-07-25 | Potter | Pennsylvania | 42105 | 20 | 0 |
368937 | 368937 | 2020-07-25 | Schuylkill | Pennsylvania | 42107 | 843 | 49 |
368938 | 368938 | 2020-07-25 | Snyder | Pennsylvania | 42109 | 87 | 2 |
368939 | 368939 | 2020-07-25 | Somerset | Pennsylvania | 42111 | 106 | 2 |
368940 | 368940 | 2020-07-25 | Sullivan | Pennsylvania | 42113 | 10 | 0 |
368941 | 368941 | 2020-07-25 | Susquehanna | Pennsylvania | 42115 | 204 | 26 |
368942 | 368942 | 2020-07-25 | Tioga | Pennsylvania | 42117 | 35 | 2 |
368943 | 368943 | 2020-07-25 | Union | Pennsylvania | 42119 | 119 | 2 |
368944 | 368944 | 2020-07-25 | Venango | Pennsylvania | 42121 | 53 | 0 |
368945 | 368945 | 2020-07-25 | Warren | Pennsylvania | 42123 | 14 | 1 |
368946 | 368946 | 2020-07-25 | Washington | Pennsylvania | 42125 | 654 | 10 |
368947 | 368947 | 2020-07-25 | Wayne | Pennsylvania | 42127 | 152 | 8 |
368948 | 368948 | 2020-07-25 | Westmoreland | Pennsylvania | 42129 | 1271 | 43 |
368949 | 368949 | 2020-07-25 | Wyoming | Pennsylvania | 42131 | 56 | 7 |
368950 | 368950 | 2020-07-25 | York | Pennsylvania | 42133 | 2152 | 80 |
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);