ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-05-10" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
132320 | 132320 | 2020-05-10 | Adams | Pennsylvania | 42001 | 159 | 5 |
132321 | 132321 | 2020-05-10 | Allegheny | Pennsylvania | 42003 | 1503 | 122 |
132322 | 132322 | 2020-05-10 | Armstrong | Pennsylvania | 42005 | 55 | 4 |
132323 | 132323 | 2020-05-10 | Beaver | Pennsylvania | 42007 | 491 | 78 |
132324 | 132324 | 2020-05-10 | Bedford | Pennsylvania | 42009 | 29 | 1 |
132325 | 132325 | 2020-05-10 | Berks | Pennsylvania | 42011 | 3371 | 170 |
132326 | 132326 | 2020-05-10 | Blair | Pennsylvania | 42013 | 28 | 0 |
132327 | 132327 | 2020-05-10 | Bradford | Pennsylvania | 42015 | 38 | 5 |
132328 | 132328 | 2020-05-10 | Bucks | Pennsylvania | 42017 | 3966 | 341 |
132329 | 132329 | 2020-05-10 | Butler | Pennsylvania | 42019 | 195 | 6 |
132330 | 132330 | 2020-05-10 | Cambria | Pennsylvania | 42021 | 44 | 2 |
132331 | 132331 | 2020-05-10 | Cameron | Pennsylvania | 42023 | 2 | 0 |
132332 | 132332 | 2020-05-10 | Carbon | Pennsylvania | 42025 | 198 | 17 |
132333 | 132333 | 2020-05-10 | Centre | Pennsylvania | 42027 | 119 | 2 |
132334 | 132334 | 2020-05-10 | Chester | Pennsylvania | 42029 | 1906 | 184 |
132335 | 132335 | 2020-05-10 | Clarion | Pennsylvania | 42031 | 23 | 1 |
132336 | 132336 | 2020-05-10 | Clearfield | Pennsylvania | 42033 | 25 | 0 |
132337 | 132337 | 2020-05-10 | Clinton | Pennsylvania | 42035 | 41 | 0 |
132338 | 132338 | 2020-05-10 | Columbia | Pennsylvania | 42037 | 324 | 28 |
132339 | 132339 | 2020-05-10 | Crawford | Pennsylvania | 42039 | 20 | 0 |
132340 | 132340 | 2020-05-10 | Cumberland | Pennsylvania | 42041 | 434 | 33 |
132341 | 132341 | 2020-05-10 | Dauphin | Pennsylvania | 42043 | 823 | 36 |
132342 | 132342 | 2020-05-10 | Delaware | Pennsylvania | 42045 | 5032 | 395 |
132343 | 132343 | 2020-05-10 | Elk | Pennsylvania | 42047 | 5 | 1 |
132344 | 132344 | 2020-05-10 | Erie | Pennsylvania | 42049 | 124 | 2 |
132345 | 132345 | 2020-05-10 | Fayette | Pennsylvania | 42051 | 85 | 4 |
132346 | 132346 | 2020-05-10 | Forest | Pennsylvania | 42053 | 7 | 0 |
132347 | 132347 | 2020-05-10 | Franklin | Pennsylvania | 42055 | 493 | 12 |
132348 | 132348 | 2020-05-10 | Fulton | Pennsylvania | 42057 | 8 | 0 |
132349 | 132349 | 2020-05-10 | Greene | Pennsylvania | 42059 | 27 | 1 |
132350 | 132350 | 2020-05-10 | Huntingdon | Pennsylvania | 42061 | 181 | 0 |
132351 | 132351 | 2020-05-10 | Indiana | Pennsylvania | 42063 | 76 | 5 |
132352 | 132352 | 2020-05-10 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
132353 | 132353 | 2020-05-10 | Juniata | Pennsylvania | 42067 | 93 | 1 |
132354 | 132354 | 2020-05-10 | Lackawanna | Pennsylvania | 42069 | 1172 | 117 |
132355 | 132355 | 2020-05-10 | Lancaster | Pennsylvania | 42071 | 2223 | 233 |
132356 | 132356 | 2020-05-10 | Lawrence | Pennsylvania | 42073 | 70 | 7 |
132357 | 132357 | 2020-05-10 | Lebanon | Pennsylvania | 42075 | 811 | 16 |
132358 | 132358 | 2020-05-10 | Lehigh | Pennsylvania | 42077 | 3241 | 121 |
132359 | 132359 | 2020-05-10 | Luzerne | Pennsylvania | 42079 | 2416 | 111 |
132360 | 132360 | 2020-05-10 | Lycoming | Pennsylvania | 42081 | 131 | 4 |
132361 | 132361 | 2020-05-10 | McKean | Pennsylvania | 42083 | 6 | 1 |
132362 | 132362 | 2020-05-10 | Mercer | Pennsylvania | 42085 | 73 | 2 |
132363 | 132363 | 2020-05-10 | Mifflin | Pennsylvania | 42087 | 52 | 0 |
132364 | 132364 | 2020-05-10 | Monroe | Pennsylvania | 42089 | 1218 | 64 |
132365 | 132365 | 2020-05-10 | Montgomery | Pennsylvania | 42091 | 5260 | 525 |
132366 | 132366 | 2020-05-10 | Montour | Pennsylvania | 42093 | 49 | 0 |
132367 | 132367 | 2020-05-10 | Northampton | Pennsylvania | 42095 | 2453 | 158 |
132368 | 132368 | 2020-05-10 | Northumberland | Pennsylvania | 42097 | 124 | 0 |
132369 | 132369 | 2020-05-10 | Perry | Pennsylvania | 42099 | 35 | 1 |
132370 | 132370 | 2020-05-10 | Philadelphia | Pennsylvania | 42101 | 18211 | 894 |
132371 | 132371 | 2020-05-10 | Pike | Pennsylvania | 42103 | 432 | 21 |
132372 | 132372 | 2020-05-10 | Potter | Pennsylvania | 42105 | 4 | 0 |
132373 | 132373 | 2020-05-10 | Schuylkill | Pennsylvania | 42107 | 451 | 13 |
132374 | 132374 | 2020-05-10 | Snyder | Pennsylvania | 42109 | 33 | 1 |
132375 | 132375 | 2020-05-10 | Somerset | Pennsylvania | 42111 | 32 | 1 |
132376 | 132376 | 2020-05-10 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
132377 | 132377 | 2020-05-10 | Susquehanna | Pennsylvania | 42115 | 82 | 13 |
132378 | 132378 | 2020-05-10 | Tioga | Pennsylvania | 42117 | 16 | 2 |
132379 | 132379 | 2020-05-10 | Union | Pennsylvania | 42119 | 40 | 1 |
132380 | 132380 | 2020-05-10 | Venango | Pennsylvania | 42121 | 7 | 0 |
132381 | 132381 | 2020-05-10 | Warren | Pennsylvania | 42123 | 1 | 1 |
132382 | 132382 | 2020-05-10 | Washington | Pennsylvania | 42125 | 124 | 4 |
132383 | 132383 | 2020-05-10 | Wayne | Pennsylvania | 42127 | 117 | 5 |
132384 | 132384 | 2020-05-10 | Westmoreland | Pennsylvania | 42129 | 417 | 32 |
132385 | 132385 | 2020-05-10 | Wyoming | Pennsylvania | 42131 | 30 | 2 |
132386 | 132386 | 2020-05-10 | York | Pennsylvania | 42133 | 773 | 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);