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-03-28 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1166145 | 1166145 | 2021-03-28 | Adams | Pennsylvania | 42001 | 7988 | 159 |
1166146 | 1166146 | 2021-03-28 | Allegheny | Pennsylvania | 42003 | 84522 | 1801 |
1166147 | 1166147 | 2021-03-28 | Armstrong | Pennsylvania | 42005 | 5126 | 120 |
1166148 | 1166148 | 2021-03-28 | Beaver | Pennsylvania | 42007 | 13063 | 356 |
1166149 | 1166149 | 2021-03-28 | Bedford | Pennsylvania | 42009 | 3942 | 130 |
1166150 | 1166150 | 2021-03-28 | Berks | Pennsylvania | 42011 | 39328 | 927 |
1166151 | 1166151 | 2021-03-28 | Blair | Pennsylvania | 42013 | 11066 | 312 |
1166152 | 1166152 | 2021-03-28 | Bradford | Pennsylvania | 42015 | 4750 | 83 |
1166153 | 1166153 | 2021-03-28 | Bucks | Pennsylvania | 42017 | 50185 | 1177 |
1166154 | 1166154 | 2021-03-28 | Butler | Pennsylvania | 42019 | 15067 | 384 |
1166155 | 1166155 | 2021-03-28 | Cambria | Pennsylvania | 42021 | 12203 | 403 |
1166156 | 1166156 | 2021-03-28 | Cameron | Pennsylvania | 42023 | 277 | 6 |
1166157 | 1166157 | 2021-03-28 | Carbon | Pennsylvania | 42025 | 5325 | 157 |
1166158 | 1166158 | 2021-03-28 | Centre | Pennsylvania | 42027 | 14393 | 213 |
1166159 | 1166159 | 2021-03-28 | Chester | Pennsylvania | 42029 | 33631 | 753 |
1166160 | 1166160 | 2021-03-28 | Clarion | Pennsylvania | 42031 | 2815 | 88 |
1166161 | 1166161 | 2021-03-28 | Clearfield | Pennsylvania | 42033 | 7052 | 128 |
1166162 | 1166162 | 2021-03-28 | Clinton | Pennsylvania | 42035 | 3061 | 57 |
1166163 | 1166163 | 2021-03-28 | Columbia | Pennsylvania | 42037 | 4896 | 126 |
1166164 | 1166164 | 2021-03-28 | Crawford | Pennsylvania | 42039 | 6648 | 143 |
1166165 | 1166165 | 2021-03-28 | Cumberland | Pennsylvania | 42041 | 17779 | 495 |
1166166 | 1166166 | 2021-03-28 | Dauphin | Pennsylvania | 42043 | 22112 | 517 |
1166167 | 1166167 | 2021-03-28 | Delaware | Pennsylvania | 42045 | 44208 | 1338 |
1166168 | 1166168 | 2021-03-28 | Elk | Pennsylvania | 42047 | 2511 | 37 |
1166169 | 1166169 | 2021-03-28 | Erie | Pennsylvania | 42049 | 18542 | 392 |
1166170 | 1166170 | 2021-03-28 | Fayette | Pennsylvania | 42051 | 11108 | 286 |
1166171 | 1166171 | 2021-03-28 | Forest | Pennsylvania | 42053 | 1393 | 21 |
1166172 | 1166172 | 2021-03-28 | Franklin | Pennsylvania | 42055 | 13348 | 338 |
1166173 | 1166173 | 2021-03-28 | Fulton | Pennsylvania | 42057 | 1183 | 15 |
1166174 | 1166174 | 2021-03-28 | Greene | Pennsylvania | 42059 | 2820 | 37 |
1166175 | 1166175 | 2021-03-28 | Huntingdon | Pennsylvania | 42061 | 4540 | 126 |
1166176 | 1166176 | 2021-03-28 | Indiana | Pennsylvania | 42063 | 5319 | 161 |
1166177 | 1166177 | 2021-03-28 | Jefferson | Pennsylvania | 42065 | 2958 | 91 |
1166178 | 1166178 | 2021-03-28 | Juniata | Pennsylvania | 42067 | 1897 | 81 |
1166179 | 1166179 | 2021-03-28 | Lackawanna | Pennsylvania | 42069 | 15336 | 433 |
1166180 | 1166180 | 2021-03-28 | Lancaster | Pennsylvania | 42071 | 47271 | 1077 |
1166181 | 1166181 | 2021-03-28 | Lawrence | Pennsylvania | 42073 | 6546 | 194 |
1166182 | 1166182 | 2021-03-28 | Lebanon | Pennsylvania | 42075 | 13703 | 264 |
1166183 | 1166183 | 2021-03-28 | Lehigh | Pennsylvania | 42077 | 33614 | 804 |
1166184 | 1166184 | 2021-03-28 | Luzerne | Pennsylvania | 42079 | 26788 | 760 |
1166185 | 1166185 | 2021-03-28 | Lycoming | Pennsylvania | 42081 | 10080 | 261 |
1166186 | 1166186 | 2021-03-28 | McKean | Pennsylvania | 42083 | 3157 | 65 |
1166187 | 1166187 | 2021-03-28 | Mercer | Pennsylvania | 42085 | 8489 | 248 |
1166188 | 1166188 | 2021-03-28 | Mifflin | Pennsylvania | 42087 | 4765 | 175 |
1166189 | 1166189 | 2021-03-28 | Monroe | Pennsylvania | 42089 | 11192 | 286 |
1166190 | 1166190 | 2021-03-28 | Montgomery | Pennsylvania | 42091 | 59046 | 1604 |
1166191 | 1166191 | 2021-03-28 | Montour | Pennsylvania | 42093 | 1821 | 60 |
1166192 | 1166192 | 2021-03-28 | Northampton | Pennsylvania | 42095 | 29974 | 675 |
1166193 | 1166193 | 2021-03-28 | Northumberland | Pennsylvania | 42097 | 8482 | 334 |
1166194 | 1166194 | 2021-03-28 | Perry | Pennsylvania | 42099 | 3166 | 88 |
1166195 | 1166195 | 2021-03-28 | Philadelphia | Pennsylvania | 42101 | 127770 | 3268 |
1166196 | 1166196 | 2021-03-28 | Pike | Pennsylvania | 42103 | 3083 | 51 |
1166197 | 1166197 | 2021-03-28 | Potter | Pennsylvania | 42105 | 976 | 22 |
1166198 | 1166198 | 2021-03-28 | Schuylkill | Pennsylvania | 42107 | 12732 | 381 |
1166199 | 1166199 | 2021-03-28 | Snyder | Pennsylvania | 42109 | 3269 | 82 |
1166200 | 1166200 | 2021-03-28 | Somerset | Pennsylvania | 42111 | 6933 | 187 |
1166201 | 1166201 | 2021-03-28 | Sullivan | Pennsylvania | 42113 | 340 | 20 |
1166202 | 1166202 | 2021-03-28 | Susquehanna | Pennsylvania | 42115 | 1940 | 53 |
1166203 | 1166203 | 2021-03-28 | Tioga | Pennsylvania | 42117 | 2596 | 97 |
1166204 | 1166204 | 2021-03-28 | Union | Pennsylvania | 42119 | 5403 | 85 |
1166205 | 1166205 | 2021-03-28 | Venango | Pennsylvania | 42121 | 3506 | 90 |
1166206 | 1166206 | 2021-03-28 | Warren | Pennsylvania | 42123 | 2267 | 99 |
1166207 | 1166207 | 2021-03-28 | Washington | Pennsylvania | 42125 | 14876 | 274 |
1166208 | 1166208 | 2021-03-28 | Wayne | Pennsylvania | 42127 | 3333 | 70 |
1166209 | 1166209 | 2021-03-28 | Westmoreland | Pennsylvania | 42129 | 28816 | 703 |
1166210 | 1166210 | 2021-03-28 | Wyoming | Pennsylvania | 42131 | 1360 | 44 |
1166211 | 1166211 | 2021-03-28 | York | Pennsylvania | 42133 | 39027 | 746 |
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);