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-07-27 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
375309 | 375309 | 2020-07-27 | Adams | Pennsylvania | 42001 | 442 | 17 |
375310 | 375310 | 2020-07-27 | Allegheny | Pennsylvania | 42003 | 7474 | 222 |
375311 | 375311 | 2020-07-27 | Armstrong | Pennsylvania | 42005 | 166 | 6 |
375312 | 375312 | 2020-07-27 | Beaver | Pennsylvania | 42007 | 1127 | 82 |
375313 | 375313 | 2020-07-27 | Bedford | Pennsylvania | 42009 | 123 | 4 |
375314 | 375314 | 2020-07-27 | Berks | Pennsylvania | 42011 | 5044 | 362 |
375315 | 375315 | 2020-07-27 | Blair | Pennsylvania | 42013 | 176 | 2 |
375316 | 375316 | 2020-07-27 | Bradford | Pennsylvania | 42015 | 75 | 3 |
375317 | 375317 | 2020-07-27 | Bucks | Pennsylvania | 42017 | 6718 | 574 |
375318 | 375318 | 2020-07-27 | Butler | Pennsylvania | 42019 | 562 | 14 |
375319 | 375319 | 2020-07-27 | Cambria | Pennsylvania | 42021 | 221 | 3 |
375320 | 375320 | 2020-07-27 | Cameron | Pennsylvania | 42023 | 5 | 0 |
375321 | 375321 | 2020-07-27 | Carbon | Pennsylvania | 42025 | 352 | 28 |
375322 | 375322 | 2020-07-27 | Centre | Pennsylvania | 42027 | 357 | 9 |
375323 | 375323 | 2020-07-27 | Chester | Pennsylvania | 42029 | 4709 | 343 |
375324 | 375324 | 2020-07-27 | Clarion | Pennsylvania | 42031 | 72 | 2 |
375325 | 375325 | 2020-07-27 | Clearfield | Pennsylvania | 42033 | 116 | 0 |
375326 | 375326 | 2020-07-27 | Clinton | Pennsylvania | 42035 | 110 | 5 |
375327 | 375327 | 2020-07-27 | Columbia | Pennsylvania | 42037 | 452 | 35 |
375328 | 375328 | 2020-07-27 | Crawford | Pennsylvania | 42039 | 118 | 1 |
375329 | 375329 | 2020-07-27 | Cumberland | Pennsylvania | 42041 | 1142 | 70 |
375330 | 375330 | 2020-07-27 | Dauphin | Pennsylvania | 42043 | 2559 | 153 |
375331 | 375331 | 2020-07-27 | Delaware | Pennsylvania | 42045 | 8371 | 720 |
375332 | 375332 | 2020-07-27 | Elk | Pennsylvania | 42047 | 39 | 2 |
375333 | 375333 | 2020-07-27 | Erie | Pennsylvania | 42049 | 865 | 15 |
375334 | 375334 | 2020-07-27 | Fayette | Pennsylvania | 42051 | 314 | 4 |
375335 | 375335 | 2020-07-27 | Forest | Pennsylvania | 42053 | 7 | 0 |
375336 | 375336 | 2020-07-27 | Franklin | Pennsylvania | 42055 | 1201 | 46 |
375337 | 375337 | 2020-07-27 | Fulton | Pennsylvania | 42057 | 21 | 2 |
375338 | 375338 | 2020-07-27 | Greene | Pennsylvania | 42059 | 99 | 0 |
375339 | 375339 | 2020-07-27 | Huntingdon | Pennsylvania | 42061 | 286 | 4 |
375340 | 375340 | 2020-07-27 | Indiana | Pennsylvania | 42063 | 223 | 6 |
375341 | 375341 | 2020-07-27 | Jefferson | Pennsylvania | 42065 | 51 | 1 |
375342 | 375342 | 2020-07-27 | Juniata | Pennsylvania | 42067 | 125 | 6 |
375343 | 375343 | 2020-07-27 | Lackawanna | Pennsylvania | 42069 | 1860 | 212 |
375344 | 375344 | 2020-07-27 | Lancaster | Pennsylvania | 42071 | 5328 | 401 |
375345 | 375345 | 2020-07-27 | Lawrence | Pennsylvania | 42073 | 291 | 11 |
375346 | 375346 | 2020-07-27 | Lebanon | Pennsylvania | 42075 | 1548 | 54 |
375347 | 375347 | 2020-07-27 | Lehigh | Pennsylvania | 42077 | 4703 | 335 |
375348 | 375348 | 2020-07-27 | Luzerne | Pennsylvania | 42079 | 3156 | 183 |
375349 | 375349 | 2020-07-27 | Lycoming | Pennsylvania | 42081 | 299 | 20 |
375350 | 375350 | 2020-07-27 | McKean | Pennsylvania | 42083 | 26 | 1 |
375351 | 375351 | 2020-07-27 | Mercer | Pennsylvania | 42085 | 300 | 9 |
375352 | 375352 | 2020-07-27 | Mifflin | Pennsylvania | 42087 | 91 | 1 |
375353 | 375353 | 2020-07-27 | Monroe | Pennsylvania | 42089 | 1557 | 122 |
375354 | 375354 | 2020-07-27 | Montgomery | Pennsylvania | 42091 | 9555 | 844 |
375355 | 375355 | 2020-07-27 | Montour | Pennsylvania | 42093 | 91 | 3 |
375356 | 375356 | 2020-07-27 | Northampton | Pennsylvania | 42095 | 3758 | 289 |
375357 | 375357 | 2020-07-27 | Northumberland | Pennsylvania | 42097 | 381 | 11 |
375358 | 375358 | 2020-07-27 | Perry | Pennsylvania | 42099 | 108 | 5 |
375359 | 375359 | 2020-07-27 | Philadelphia | Pennsylvania | 42101 | 29803 | 1678 |
375360 | 375360 | 2020-07-27 | Pike | Pennsylvania | 42103 | 523 | 21 |
375361 | 375361 | 2020-07-27 | Potter | Pennsylvania | 42105 | 20 | 0 |
375362 | 375362 | 2020-07-27 | Schuylkill | Pennsylvania | 42107 | 849 | 49 |
375363 | 375363 | 2020-07-27 | Snyder | Pennsylvania | 42109 | 87 | 2 |
375364 | 375364 | 2020-07-27 | Somerset | Pennsylvania | 42111 | 112 | 2 |
375365 | 375365 | 2020-07-27 | Sullivan | Pennsylvania | 42113 | 10 | 0 |
375366 | 375366 | 2020-07-27 | Susquehanna | Pennsylvania | 42115 | 204 | 26 |
375367 | 375367 | 2020-07-27 | Tioga | Pennsylvania | 42117 | 34 | 2 |
375368 | 375368 | 2020-07-27 | Union | Pennsylvania | 42119 | 124 | 2 |
375369 | 375369 | 2020-07-27 | Venango | Pennsylvania | 42121 | 55 | 0 |
375370 | 375370 | 2020-07-27 | Warren | Pennsylvania | 42123 | 14 | 1 |
375371 | 375371 | 2020-07-27 | Washington | Pennsylvania | 42125 | 681 | 10 |
375372 | 375372 | 2020-07-27 | Wayne | Pennsylvania | 42127 | 154 | 8 |
375373 | 375373 | 2020-07-27 | Westmoreland | Pennsylvania | 42129 | 1313 | 43 |
375374 | 375374 | 2020-07-27 | Wyoming | Pennsylvania | 42131 | 56 | 7 |
375375 | 375375 | 2020-07-27 | York | Pennsylvania | 42133 | 2182 | 81 |
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);