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-05-14 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
144293 | 144293 | 2020-05-14 | Adams | Pennsylvania | 42001 | 174 | 5 |
144294 | 144294 | 2020-05-14 | Allegheny | Pennsylvania | 42003 | 1551 | 139 |
144295 | 144295 | 2020-05-14 | Armstrong | Pennsylvania | 42005 | 56 | 5 |
144296 | 144296 | 2020-05-14 | Beaver | Pennsylvania | 42007 | 512 | 82 |
144297 | 144297 | 2020-05-14 | Bedford | Pennsylvania | 42009 | 30 | 1 |
144298 | 144298 | 2020-05-14 | Berks | Pennsylvania | 42011 | 3530 | 196 |
144299 | 144299 | 2020-05-14 | Blair | Pennsylvania | 42013 | 32 | 0 |
144300 | 144300 | 2020-05-14 | Bradford | Pennsylvania | 42015 | 41 | 5 |
144301 | 144301 | 2020-05-14 | Bucks | Pennsylvania | 42017 | 4248 | 395 |
144302 | 144302 | 2020-05-14 | Butler | Pennsylvania | 42019 | 199 | 6 |
144303 | 144303 | 2020-05-14 | Cambria | Pennsylvania | 42021 | 45 | 2 |
144304 | 144304 | 2020-05-14 | Cameron | Pennsylvania | 42023 | 2 | 0 |
144305 | 144305 | 2020-05-14 | Carbon | Pennsylvania | 42025 | 206 | 17 |
144306 | 144306 | 2020-05-14 | Centre | Pennsylvania | 42027 | 128 | 6 |
144307 | 144307 | 2020-05-14 | Chester | Pennsylvania | 42029 | 2008 | 213 |
144308 | 144308 | 2020-05-14 | Clarion | Pennsylvania | 42031 | 24 | 1 |
144309 | 144309 | 2020-05-14 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
144310 | 144310 | 2020-05-14 | Clinton | Pennsylvania | 42035 | 43 | 0 |
144311 | 144311 | 2020-05-14 | Columbia | Pennsylvania | 42037 | 333 | 31 |
144312 | 144312 | 2020-05-14 | Crawford | Pennsylvania | 42039 | 21 | 0 |
144313 | 144313 | 2020-05-14 | Cumberland | Pennsylvania | 42041 | 477 | 37 |
144314 | 144314 | 2020-05-14 | Dauphin | Pennsylvania | 42043 | 895 | 40 |
144315 | 144315 | 2020-05-14 | Delaware | Pennsylvania | 42045 | 5305 | 448 |
144316 | 144316 | 2020-05-14 | Elk | Pennsylvania | 42047 | 6 | 1 |
144317 | 144317 | 2020-05-14 | Erie | Pennsylvania | 42049 | 127 | 3 |
144318 | 144318 | 2020-05-14 | Fayette | Pennsylvania | 42051 | 87 | 4 |
144319 | 144319 | 2020-05-14 | Forest | Pennsylvania | 42053 | 7 | 0 |
144320 | 144320 | 2020-05-14 | Franklin | Pennsylvania | 42055 | 563 | 15 |
144321 | 144321 | 2020-05-14 | Fulton | Pennsylvania | 42057 | 11 | 0 |
144322 | 144322 | 2020-05-14 | Greene | Pennsylvania | 42059 | 27 | 1 |
144323 | 144323 | 2020-05-14 | Huntingdon | Pennsylvania | 42061 | 200 | 0 |
144324 | 144324 | 2020-05-14 | Indiana | Pennsylvania | 42063 | 82 | 5 |
144325 | 144325 | 2020-05-14 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
144326 | 144326 | 2020-05-14 | Juniata | Pennsylvania | 42067 | 94 | 1 |
144327 | 144327 | 2020-05-14 | Lackawanna | Pennsylvania | 42069 | 1256 | 135 |
144328 | 144328 | 2020-05-14 | Lancaster | Pennsylvania | 42071 | 2364 | 249 |
144329 | 144329 | 2020-05-14 | Lawrence | Pennsylvania | 42073 | 71 | 7 |
144330 | 144330 | 2020-05-14 | Lebanon | Pennsylvania | 42075 | 856 | 19 |
144331 | 144331 | 2020-05-14 | Lehigh | Pennsylvania | 42077 | 3378 | 133 |
144332 | 144332 | 2020-05-14 | Luzerne | Pennsylvania | 42079 | 2477 | 124 |
144333 | 144333 | 2020-05-14 | Lycoming | Pennsylvania | 42081 | 139 | 7 |
144334 | 144334 | 2020-05-14 | McKean | Pennsylvania | 42083 | 8 | 1 |
144335 | 144335 | 2020-05-14 | Mercer | Pennsylvania | 42085 | 81 | 2 |
144336 | 144336 | 2020-05-14 | Mifflin | Pennsylvania | 42087 | 54 | 0 |
144337 | 144337 | 2020-05-14 | Monroe | Pennsylvania | 42089 | 1240 | 69 |
144338 | 144338 | 2020-05-14 | Montgomery | Pennsylvania | 42091 | 5583 | 587 |
144339 | 144339 | 2020-05-14 | Montour | Pennsylvania | 42093 | 50 | 0 |
144340 | 144340 | 2020-05-14 | Northampton | Pennsylvania | 42095 | 2566 | 182 |
144341 | 144341 | 2020-05-14 | Northumberland | Pennsylvania | 42097 | 132 | 0 |
144342 | 144342 | 2020-05-14 | Perry | Pennsylvania | 42099 | 36 | 1 |
144343 | 144343 | 2020-05-14 | Philadelphia | Pennsylvania | 42101 | 19093 | 1008 |
144344 | 144344 | 2020-05-14 | Pike | Pennsylvania | 42103 | 454 | 21 |
144345 | 144345 | 2020-05-14 | Potter | Pennsylvania | 42105 | 4 | 0 |
144346 | 144346 | 2020-05-14 | Schuylkill | Pennsylvania | 42107 | 490 | 14 |
144347 | 144347 | 2020-05-14 | Snyder | Pennsylvania | 42109 | 33 | 1 |
144348 | 144348 | 2020-05-14 | Somerset | Pennsylvania | 42111 | 32 | 1 |
144349 | 144349 | 2020-05-14 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
144350 | 144350 | 2020-05-14 | Susquehanna | Pennsylvania | 42115 | 82 | 14 |
144351 | 144351 | 2020-05-14 | Tioga | Pennsylvania | 42117 | 16 | 2 |
144352 | 144352 | 2020-05-14 | Union | Pennsylvania | 42119 | 43 | 1 |
144353 | 144353 | 2020-05-14 | Venango | Pennsylvania | 42121 | 7 | 0 |
144354 | 144354 | 2020-05-14 | Warren | Pennsylvania | 42123 | 2 | 1 |
144355 | 144355 | 2020-05-14 | Washington | Pennsylvania | 42125 | 129 | 4 |
144356 | 144356 | 2020-05-14 | Wayne | Pennsylvania | 42127 | 107 | 5 |
144357 | 144357 | 2020-05-14 | Westmoreland | Pennsylvania | 42129 | 422 | 32 |
144358 | 144358 | 2020-05-14 | Wyoming | Pennsylvania | 42131 | 31 | 4 |
144359 | 144359 | 2020-05-14 | York | Pennsylvania | 42133 | 817 | 15 |
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);