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-18 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
69338 | 69338 | 2020-04-18 | Adams | Pennsylvania | 42001 | 74 | 1 |
69339 | 69339 | 2020-04-18 | Allegheny | Pennsylvania | 42003 | 1009 | 47 |
69340 | 69340 | 2020-04-18 | Armstrong | Pennsylvania | 42005 | 36 | 2 |
69341 | 69341 | 2020-04-18 | Beaver | Pennsylvania | 42007 | 278 | 31 |
69342 | 69342 | 2020-04-18 | Bedford | Pennsylvania | 42009 | 14 | 1 |
69343 | 69343 | 2020-04-18 | Berks | Pennsylvania | 42011 | 1748 | 40 |
69344 | 69344 | 2020-04-18 | Blair | Pennsylvania | 42013 | 14 | 0 |
69345 | 69345 | 2020-04-18 | Bradford | Pennsylvania | 42015 | 24 | 0 |
69346 | 69346 | 2020-04-18 | Bucks | Pennsylvania | 42017 | 1689 | 77 |
69347 | 69347 | 2020-04-18 | Butler | Pennsylvania | 42019 | 160 | 5 |
69348 | 69348 | 2020-04-18 | Cambria | Pennsylvania | 42021 | 17 | 1 |
69349 | 69349 | 2020-04-18 | Cameron | Pennsylvania | 42023 | 1 | 0 |
69350 | 69350 | 2020-04-18 | Carbon | Pennsylvania | 42025 | 136 | 8 |
69351 | 69351 | 2020-04-18 | Centre | Pennsylvania | 42027 | 73 | 1 |
69352 | 69352 | 2020-04-18 | Chester | Pennsylvania | 42029 | 831 | 36 |
69353 | 69353 | 2020-04-18 | Clarion | Pennsylvania | 42031 | 18 | 1 |
69354 | 69354 | 2020-04-18 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
69355 | 69355 | 2020-04-18 | Clinton | Pennsylvania | 42035 | 11 | 0 |
69356 | 69356 | 2020-04-18 | Columbia | Pennsylvania | 42037 | 184 | 4 |
69357 | 69357 | 2020-04-18 | Crawford | Pennsylvania | 42039 | 16 | 0 |
69358 | 69358 | 2020-04-18 | Cumberland | Pennsylvania | 42041 | 176 | 4 |
69359 | 69359 | 2020-04-18 | Dauphin | Pennsylvania | 42043 | 343 | 9 |
69360 | 69360 | 2020-04-18 | Delaware | Pennsylvania | 42045 | 2372 | 78 |
69361 | 69361 | 2020-04-18 | Elk | Pennsylvania | 42047 | 2 | 0 |
69362 | 69362 | 2020-04-18 | Erie | Pennsylvania | 42049 | 58 | 1 |
69363 | 69363 | 2020-04-18 | Fayette | Pennsylvania | 42051 | 66 | 3 |
69364 | 69364 | 2020-04-18 | Forest | Pennsylvania | 42053 | 7 | 0 |
69365 | 69365 | 2020-04-18 | Franklin | Pennsylvania | 42055 | 106 | 0 |
69366 | 69366 | 2020-04-18 | Fulton | Pennsylvania | 42057 | 2 | 0 |
69367 | 69367 | 2020-04-18 | Greene | Pennsylvania | 42059 | 24 | 0 |
69368 | 69368 | 2020-04-18 | Huntingdon | Pennsylvania | 42061 | 12 | 0 |
69369 | 69369 | 2020-04-18 | Indiana | Pennsylvania | 42063 | 47 | 4 |
69370 | 69370 | 2020-04-18 | Jefferson | Pennsylvania | 42065 | 2 | 0 |
69371 | 69371 | 2020-04-18 | Juniata | Pennsylvania | 42067 | 66 | 0 |
69372 | 69372 | 2020-04-18 | Lackawanna | Pennsylvania | 42069 | 620 | 35 |
69373 | 69373 | 2020-04-18 | Lancaster | Pennsylvania | 42071 | 1113 | 93 |
69374 | 69374 | 2020-04-18 | Lawrence | Pennsylvania | 42073 | 60 | 5 |
69375 | 69375 | 2020-04-18 | Lebanon | Pennsylvania | 42075 | 458 | 4 |
69376 | 69376 | 2020-04-18 | Lehigh | Pennsylvania | 42077 | 2141 | 29 |
69377 | 69377 | 2020-04-18 | Luzerne | Pennsylvania | 42079 | 1712 | 32 |
69378 | 69378 | 2020-04-18 | Lycoming | Pennsylvania | 42081 | 36 | 0 |
69379 | 69379 | 2020-04-18 | McKean | Pennsylvania | 42083 | 4 | 0 |
69380 | 69380 | 2020-04-18 | Mercer | Pennsylvania | 42085 | 57 | 1 |
69381 | 69381 | 2020-04-18 | Mifflin | Pennsylvania | 42087 | 19 | 0 |
69382 | 69382 | 2020-04-18 | Monroe | Pennsylvania | 42089 | 943 | 34 |
69383 | 69383 | 2020-04-18 | Montgomery | Pennsylvania | 42091 | 2781 | 147 |
69384 | 69384 | 2020-04-18 | Montour | Pennsylvania | 42093 | 49 | 0 |
69385 | 69385 | 2020-04-18 | Northampton | Pennsylvania | 42095 | 1396 | 29 |
69386 | 69386 | 2020-04-18 | Northumberland | Pennsylvania | 42097 | 67 | 0 |
69387 | 69387 | 2020-04-18 | Perry | Pennsylvania | 42099 | 20 | 1 |
69388 | 69388 | 2020-04-18 | Philadelphia | Pennsylvania | 42101 | 9014 | 342 |
69389 | 69389 | 2020-04-18 | Pike | Pennsylvania | 42103 | 295 | 8 |
69390 | 69390 | 2020-04-18 | Potter | Pennsylvania | 42105 | 4 | 0 |
69391 | 69391 | 2020-04-18 | Schuylkill | Pennsylvania | 42107 | 254 | 5 |
69392 | 69392 | 2020-04-18 | Snyder | Pennsylvania | 42109 | 27 | 1 |
69393 | 69393 | 2020-04-18 | Somerset | Pennsylvania | 42111 | 17 | 0 |
69394 | 69394 | 2020-04-18 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
69395 | 69395 | 2020-04-18 | Susquehanna | Pennsylvania | 42115 | 59 | 1 |
69396 | 69396 | 2020-04-18 | Tioga | Pennsylvania | 42117 | 14 | 1 |
69397 | 69397 | 2020-04-18 | Union | Pennsylvania | 42119 | 27 | 0 |
69398 | 69398 | 2020-04-18 | Venango | Pennsylvania | 42121 | 6 | 0 |
69399 | 69399 | 2020-04-18 | Warren | Pennsylvania | 42123 | 1 | 0 |
69400 | 69400 | 2020-04-18 | Washington | Pennsylvania | 42125 | 79 | 2 |
69401 | 69401 | 2020-04-18 | Wayne | Pennsylvania | 42127 | 84 | 2 |
69402 | 69402 | 2020-04-18 | Westmoreland | Pennsylvania | 42129 | 280 | 19 |
69403 | 69403 | 2020-04-18 | Wyoming | Pennsylvania | 42131 | 16 | 1 |
69404 | 69404 | 2020-04-18 | York | Pennsylvania | 42133 | 463 | 4 |
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);