ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-06-24" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
270392 | 270392 | 2020-06-24 | Adams | Pennsylvania | 42001 | 321 | 12 |
270393 | 270393 | 2020-06-24 | Allegheny | Pennsylvania | 42003 | 2284 | 180 |
270394 | 270394 | 2020-06-24 | Armstrong | Pennsylvania | 42005 | 70 | 6 |
270395 | 270395 | 2020-06-24 | Beaver | Pennsylvania | 42007 | 634 | 78 |
270396 | 270396 | 2020-06-24 | Bedford | Pennsylvania | 42009 | 71 | 2 |
270397 | 270397 | 2020-06-24 | Berks | Pennsylvania | 42011 | 4453 | 347 |
270398 | 270398 | 2020-06-24 | Blair | Pennsylvania | 42013 | 69 | 1 |
270399 | 270399 | 2020-06-24 | Bradford | Pennsylvania | 42015 | 51 | 3 |
270400 | 270400 | 2020-06-24 | Bucks | Pennsylvania | 42017 | 5619 | 559 |
270401 | 270401 | 2020-06-24 | Butler | Pennsylvania | 42019 | 277 | 13 |
270402 | 270402 | 2020-06-24 | Cambria | Pennsylvania | 42021 | 62 | 3 |
270403 | 270403 | 2020-06-24 | Cameron | Pennsylvania | 42023 | 2 | 0 |
270404 | 270404 | 2020-06-24 | Carbon | Pennsylvania | 42025 | 271 | 25 |
270405 | 270405 | 2020-06-24 | Centre | Pennsylvania | 42027 | 196 | 6 |
270406 | 270406 | 2020-06-24 | Chester | Pennsylvania | 42029 | 3601 | 319 |
270407 | 270407 | 2020-06-24 | Clarion | Pennsylvania | 42031 | 33 | 2 |
270408 | 270408 | 2020-06-24 | Clearfield | Pennsylvania | 42033 | 70 | 0 |
270409 | 270409 | 2020-06-24 | Clinton | Pennsylvania | 42035 | 73 | 3 |
270410 | 270410 | 2020-06-24 | Columbia | Pennsylvania | 42037 | 398 | 33 |
270411 | 270411 | 2020-06-24 | Crawford | Pennsylvania | 42039 | 48 | 0 |
270412 | 270412 | 2020-06-24 | Cumberland | Pennsylvania | 42041 | 809 | 61 |
270413 | 270413 | 2020-06-24 | Dauphin | Pennsylvania | 42043 | 1864 | 127 |
270414 | 270414 | 2020-06-24 | Delaware | Pennsylvania | 42045 | 7127 | 693 |
270415 | 270415 | 2020-06-24 | Elk | Pennsylvania | 42047 | 10 | 0 |
270416 | 270416 | 2020-06-24 | Erie | Pennsylvania | 42049 | 551 | 9 |
270417 | 270417 | 2020-06-24 | Fayette | Pennsylvania | 42051 | 104 | 4 |
270418 | 270418 | 2020-06-24 | Forest | Pennsylvania | 42053 | 7 | 0 |
270419 | 270419 | 2020-06-24 | Franklin | Pennsylvania | 42055 | 896 | 42 |
270420 | 270420 | 2020-06-24 | Fulton | Pennsylvania | 42057 | 18 | 1 |
270421 | 270421 | 2020-06-24 | Greene | Pennsylvania | 42059 | 35 | 0 |
270422 | 270422 | 2020-06-24 | Huntingdon | Pennsylvania | 42061 | 242 | 4 |
270423 | 270423 | 2020-06-24 | Indiana | Pennsylvania | 42063 | 98 | 6 |
270424 | 270424 | 2020-06-24 | Jefferson | Pennsylvania | 42065 | 21 | 1 |
270425 | 270425 | 2020-06-24 | Juniata | Pennsylvania | 42067 | 109 | 5 |
270426 | 270426 | 2020-06-24 | Lackawanna | Pennsylvania | 42069 | 1638 | 201 |
270427 | 270427 | 2020-06-24 | Lancaster | Pennsylvania | 42071 | 4152 | 352 |
270428 | 270428 | 2020-06-24 | Lawrence | Pennsylvania | 42073 | 94 | 9 |
270429 | 270429 | 2020-06-24 | Lebanon | Pennsylvania | 42075 | 1278 | 42 |
270430 | 270430 | 2020-06-24 | Lehigh | Pennsylvania | 42077 | 4130 | 284 |
270431 | 270431 | 2020-06-24 | Luzerne | Pennsylvania | 42079 | 2874 | 173 |
270432 | 270432 | 2020-06-24 | Lycoming | Pennsylvania | 42081 | 175 | 19 |
270433 | 270433 | 2020-06-24 | McKean | Pennsylvania | 42083 | 15 | 1 |
270434 | 270434 | 2020-06-24 | Mercer | Pennsylvania | 42085 | 120 | 6 |
270435 | 270435 | 2020-06-24 | Mifflin | Pennsylvania | 42087 | 61 | 1 |
270436 | 270436 | 2020-06-24 | Monroe | Pennsylvania | 42089 | 1384 | 108 |
270437 | 270437 | 2020-06-24 | Montgomery | Pennsylvania | 42091 | 8188 | 791 |
270438 | 270438 | 2020-06-24 | Montour | Pennsylvania | 42093 | 68 | 0 |
270439 | 270439 | 2020-06-24 | Northampton | Pennsylvania | 42095 | 3339 | 259 |
270440 | 270440 | 2020-06-24 | Northumberland | Pennsylvania | 42097 | 281 | 5 |
270441 | 270441 | 2020-06-24 | Perry | Pennsylvania | 42099 | 85 | 5 |
270442 | 270442 | 2020-06-24 | Philadelphia | Pennsylvania | 42101 | 25443 | 1576 |
270443 | 270443 | 2020-06-24 | Pike | Pennsylvania | 42103 | 489 | 20 |
270444 | 270444 | 2020-06-24 | Potter | Pennsylvania | 42105 | 14 | 0 |
270445 | 270445 | 2020-06-24 | Schuylkill | Pennsylvania | 42107 | 721 | 43 |
270446 | 270446 | 2020-06-24 | Snyder | Pennsylvania | 42109 | 61 | 2 |
270447 | 270447 | 2020-06-24 | Somerset | Pennsylvania | 42111 | 49 | 1 |
270448 | 270448 | 2020-06-24 | Sullivan | Pennsylvania | 42113 | 3 | 0 |
270449 | 270449 | 2020-06-24 | Susquehanna | Pennsylvania | 42115 | 178 | 21 |
270450 | 270450 | 2020-06-24 | Tioga | Pennsylvania | 42117 | 23 | 2 |
270451 | 270451 | 2020-06-24 | Union | Pennsylvania | 42119 | 89 | 2 |
270452 | 270452 | 2020-06-24 | Venango | Pennsylvania | 42121 | 17 | 0 |
270453 | 270453 | 2020-06-24 | Warren | Pennsylvania | 42123 | 5 | 0 |
270454 | 270454 | 2020-06-24 | Washington | Pennsylvania | 42125 | 176 | 6 |
270455 | 270455 | 2020-06-24 | Wayne | Pennsylvania | 42127 | 131 | 9 |
270456 | 270456 | 2020-06-24 | Westmoreland | Pennsylvania | 42129 | 563 | 38 |
270457 | 270457 | 2020-06-24 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
270458 | 270458 | 2020-06-24 | York | Pennsylvania | 42133 | 1400 | 40 |
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);