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-23 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
83251 | 83251 | 2020-04-23 | Adams | Pennsylvania | 42001 | 95 | 2 |
83252 | 83252 | 2020-04-23 | Allegheny | Pennsylvania | 42003 | 1149 | 69 |
83253 | 83253 | 2020-04-23 | Armstrong | Pennsylvania | 42005 | 32 | 2 |
83254 | 83254 | 2020-04-23 | Beaver | Pennsylvania | 42007 | 319 | 46 |
83255 | 83255 | 2020-04-23 | Bedford | Pennsylvania | 42009 | 20 | 1 |
83256 | 83256 | 2020-04-23 | Berks | Pennsylvania | 42011 | 2212 | 86 |
83257 | 83257 | 2020-04-23 | Blair | Pennsylvania | 42013 | 15 | 0 |
83258 | 83258 | 2020-04-23 | Bradford | Pennsylvania | 42015 | 28 | 5 |
83259 | 83259 | 2020-04-23 | Bucks | Pennsylvania | 42017 | 2197 | 128 |
83260 | 83260 | 2020-04-23 | Butler | Pennsylvania | 42019 | 164 | 6 |
83261 | 83261 | 2020-04-23 | Cambria | Pennsylvania | 42021 | 20 | 2 |
83262 | 83262 | 2020-04-23 | Cameron | Pennsylvania | 42023 | 1 | 0 |
83263 | 83263 | 2020-04-23 | Carbon | Pennsylvania | 42025 | 155 | 11 |
83264 | 83264 | 2020-04-23 | Centre | Pennsylvania | 42027 | 76 | 2 |
83265 | 83265 | 2020-04-23 | Chester | Pennsylvania | 42029 | 1017 | 64 |
83266 | 83266 | 2020-04-23 | Clarion | Pennsylvania | 42031 | 20 | 1 |
83267 | 83267 | 2020-04-23 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
83268 | 83268 | 2020-04-23 | Clinton | Pennsylvania | 42035 | 14 | 0 |
83269 | 83269 | 2020-04-23 | Columbia | Pennsylvania | 42037 | 245 | 8 |
83270 | 83270 | 2020-04-23 | Crawford | Pennsylvania | 42039 | 19 | 0 |
83271 | 83271 | 2020-04-23 | Cumberland | Pennsylvania | 42041 | 229 | 7 |
83272 | 83272 | 2020-04-23 | Dauphin | Pennsylvania | 42043 | 445 | 16 |
83273 | 83273 | 2020-04-23 | Delaware | Pennsylvania | 42045 | 2963 | 124 |
83274 | 83274 | 2020-04-23 | Elk | Pennsylvania | 42047 | 2 | 0 |
83275 | 83275 | 2020-04-23 | Erie | Pennsylvania | 42049 | 68 | 1 |
83276 | 83276 | 2020-04-23 | Fayette | Pennsylvania | 42051 | 71 | 3 |
83277 | 83277 | 2020-04-23 | Forest | Pennsylvania | 42053 | 7 | 0 |
83278 | 83278 | 2020-04-23 | Franklin | Pennsylvania | 42055 | 151 | 10 |
83279 | 83279 | 2020-04-23 | Fulton | Pennsylvania | 42057 | 2 | 0 |
83280 | 83280 | 2020-04-23 | Greene | Pennsylvania | 42059 | 25 | 0 |
83281 | 83281 | 2020-04-23 | Huntingdon | Pennsylvania | 42061 | 20 | 0 |
83282 | 83282 | 2020-04-23 | Indiana | Pennsylvania | 42063 | 59 | 4 |
83283 | 83283 | 2020-04-23 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
83284 | 83284 | 2020-04-23 | Juniata | Pennsylvania | 42067 | 77 | 0 |
83285 | 83285 | 2020-04-23 | Lackawanna | Pennsylvania | 42069 | 707 | 58 |
83286 | 83286 | 2020-04-23 | Lancaster | Pennsylvania | 42071 | 1359 | 131 |
83287 | 83287 | 2020-04-23 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
83288 | 83288 | 2020-04-23 | Lebanon | Pennsylvania | 42075 | 544 | 8 |
83289 | 83289 | 2020-04-23 | Lehigh | Pennsylvania | 42077 | 2418 | 49 |
83290 | 83290 | 2020-04-23 | Luzerne | Pennsylvania | 42079 | 1880 | 58 |
83291 | 83291 | 2020-04-23 | Lycoming | Pennsylvania | 42081 | 44 | 2 |
83292 | 83292 | 2020-04-23 | McKean | Pennsylvania | 42083 | 5 | 0 |
83293 | 83293 | 2020-04-23 | Mercer | Pennsylvania | 42085 | 60 | 1 |
83294 | 83294 | 2020-04-23 | Mifflin | Pennsylvania | 42087 | 24 | 0 |
83295 | 83295 | 2020-04-23 | Monroe | Pennsylvania | 42089 | 1024 | 46 |
83296 | 83296 | 2020-04-23 | Montgomery | Pennsylvania | 42091 | 3395 | 204 |
83297 | 83297 | 2020-04-23 | Montour | Pennsylvania | 42093 | 48 | 0 |
83298 | 83298 | 2020-04-23 | Northampton | Pennsylvania | 42095 | 1656 | 45 |
83299 | 83299 | 2020-04-23 | Northumberland | Pennsylvania | 42097 | 82 | 0 |
83300 | 83300 | 2020-04-23 | Perry | Pennsylvania | 42099 | 23 | 1 |
83301 | 83301 | 2020-04-23 | Philadelphia | Pennsylvania | 42101 | 11226 | 443 |
83302 | 83302 | 2020-04-23 | Pike | Pennsylvania | 42103 | 327 | 12 |
83303 | 83303 | 2020-04-23 | Potter | Pennsylvania | 42105 | 4 | 0 |
83304 | 83304 | 2020-04-23 | Schuylkill | Pennsylvania | 42107 | 290 | 7 |
83305 | 83305 | 2020-04-23 | Snyder | Pennsylvania | 42109 | 31 | 1 |
83306 | 83306 | 2020-04-23 | Somerset | Pennsylvania | 42111 | 20 | 0 |
83307 | 83307 | 2020-04-23 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
83308 | 83308 | 2020-04-23 | Susquehanna | Pennsylvania | 42115 | 72 | 4 |
83309 | 83309 | 2020-04-23 | Tioga | Pennsylvania | 42117 | 14 | 2 |
83310 | 83310 | 2020-04-23 | Union | Pennsylvania | 42119 | 30 | 0 |
83311 | 83311 | 2020-04-23 | Venango | Pennsylvania | 42121 | 7 | 0 |
83312 | 83312 | 2020-04-23 | Warren | Pennsylvania | 42123 | 1 | 1 |
83313 | 83313 | 2020-04-23 | Washington | Pennsylvania | 42125 | 92 | 2 |
83314 | 83314 | 2020-04-23 | Wayne | Pennsylvania | 42127 | 87 | 3 |
83315 | 83315 | 2020-04-23 | Westmoreland | Pennsylvania | 42129 | 307 | 27 |
83316 | 83316 | 2020-04-23 | Wyoming | Pennsylvania | 42131 | 17 | 1 |
83317 | 83317 | 2020-04-23 | York | Pennsylvania | 42133 | 546 | 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);