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-10-01 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
588505 | 588505 | 2020-10-01 | Adams | Pennsylvania | 42001 | 854 | 26 |
588506 | 588506 | 2020-10-01 | Allegheny | Pennsylvania | 42003 | 12454 | 382 |
588507 | 588507 | 2020-10-01 | Armstrong | Pennsylvania | 42005 | 452 | 18 |
588508 | 588508 | 2020-10-01 | Beaver | Pennsylvania | 42007 | 1940 | 123 |
588509 | 588509 | 2020-10-01 | Bedford | Pennsylvania | 42009 | 250 | 6 |
588510 | 588510 | 2020-10-01 | Berks | Pennsylvania | 42011 | 7215 | 395 |
588511 | 588511 | 2020-10-01 | Blair | Pennsylvania | 42013 | 728 | 18 |
588512 | 588512 | 2020-10-01 | Bradford | Pennsylvania | 42015 | 176 | 5 |
588513 | 588513 | 2020-10-01 | Bucks | Pennsylvania | 42017 | 8929 | 610 |
588514 | 588514 | 2020-10-01 | Butler | Pennsylvania | 42019 | 1082 | 25 |
588515 | 588515 | 2020-10-01 | Cambria | Pennsylvania | 42021 | 617 | 7 |
588516 | 588516 | 2020-10-01 | Cameron | Pennsylvania | 42023 | 8 | 0 |
588517 | 588517 | 2020-10-01 | Carbon | Pennsylvania | 42025 | 471 | 28 |
588518 | 588518 | 2020-10-01 | Centre | Pennsylvania | 42027 | 2755 | 11 |
588519 | 588519 | 2020-10-01 | Chester | Pennsylvania | 42029 | 7002 | 369 |
588520 | 588520 | 2020-10-01 | Clarion | Pennsylvania | 42031 | 129 | 3 |
588521 | 588521 | 2020-10-01 | Clearfield | Pennsylvania | 42033 | 334 | 6 |
588522 | 588522 | 2020-10-01 | Clinton | Pennsylvania | 42035 | 208 | 6 |
588523 | 588523 | 2020-10-01 | Columbia | Pennsylvania | 42037 | 926 | 35 |
588524 | 588524 | 2020-10-01 | Crawford | Pennsylvania | 42039 | 317 | 3 |
588525 | 588525 | 2020-10-01 | Cumberland | Pennsylvania | 42041 | 1918 | 77 |
588526 | 588526 | 2020-10-01 | Dauphin | Pennsylvania | 42043 | 3879 | 181 |
588527 | 588527 | 2020-10-01 | Delaware | Pennsylvania | 42045 | 11612 | 796 |
588528 | 588528 | 2020-10-01 | Elk | Pennsylvania | 42047 | 73 | 2 |
588529 | 588529 | 2020-10-01 | Erie | Pennsylvania | 42049 | 1579 | 48 |
588530 | 588530 | 2020-10-01 | Fayette | Pennsylvania | 42051 | 815 | 7 |
588531 | 588531 | 2020-10-01 | Forest | Pennsylvania | 42053 | 15 | 0 |
588532 | 588532 | 2020-10-01 | Franklin | Pennsylvania | 42055 | 1798 | 51 |
588533 | 588533 | 2020-10-01 | Fulton | Pennsylvania | 42057 | 52 | 2 |
588534 | 588534 | 2020-10-01 | Greene | Pennsylvania | 42059 | 190 | 1 |
588535 | 588535 | 2020-10-01 | Huntingdon | Pennsylvania | 42061 | 422 | 6 |
588536 | 588536 | 2020-10-01 | Indiana | Pennsylvania | 42063 | 740 | 12 |
588537 | 588537 | 2020-10-01 | Jefferson | Pennsylvania | 42065 | 116 | 3 |
588538 | 588538 | 2020-10-01 | Juniata | Pennsylvania | 42067 | 194 | 7 |
588539 | 588539 | 2020-10-01 | Lackawanna | Pennsylvania | 42069 | 2619 | 217 |
588540 | 588540 | 2020-10-01 | Lancaster | Pennsylvania | 42071 | 8052 | 459 |
588541 | 588541 | 2020-10-01 | Lawrence | Pennsylvania | 42073 | 540 | 23 |
588542 | 588542 | 2020-10-01 | Lebanon | Pennsylvania | 42075 | 2091 | 60 |
588543 | 588543 | 2020-10-01 | Lehigh | Pennsylvania | 42077 | 5704 | 353 |
588544 | 588544 | 2020-10-01 | Luzerne | Pennsylvania | 42079 | 4147 | 190 |
588545 | 588545 | 2020-10-01 | Lycoming | Pennsylvania | 42081 | 718 | 26 |
588546 | 588546 | 2020-10-01 | McKean | Pennsylvania | 42083 | 60 | 2 |
588547 | 588547 | 2020-10-01 | Mercer | Pennsylvania | 42085 | 747 | 20 |
588548 | 588548 | 2020-10-01 | Mifflin | Pennsylvania | 42087 | 231 | 2 |
588549 | 588549 | 2020-10-01 | Monroe | Pennsylvania | 42089 | 1809 | 134 |
588550 | 588550 | 2020-10-01 | Montgomery | Pennsylvania | 42091 | 12325 | 881 |
588551 | 588551 | 2020-10-01 | Montour | Pennsylvania | 42093 | 195 | 5 |
588552 | 588552 | 2020-10-01 | Northampton | Pennsylvania | 42095 | 4532 | 305 |
588553 | 588553 | 2020-10-01 | Northumberland | Pennsylvania | 42097 | 1083 | 63 |
588554 | 588554 | 2020-10-01 | Perry | Pennsylvania | 42099 | 237 | 6 |
588555 | 588555 | 2020-10-01 | Philadelphia | Pennsylvania | 42101 | 37361 | 1832 |
588556 | 588556 | 2020-10-01 | Pike | Pennsylvania | 42103 | 585 | 22 |
588557 | 588557 | 2020-10-01 | Potter | Pennsylvania | 42105 | 30 | 0 |
588558 | 588558 | 2020-10-01 | Schuylkill | Pennsylvania | 42107 | 1204 | 53 |
588559 | 588559 | 2020-10-01 | Snyder | Pennsylvania | 42109 | 347 | 7 |
588560 | 588560 | 2020-10-01 | Somerset | Pennsylvania | 42111 | 225 | 3 |
588561 | 588561 | 2020-10-01 | Sullivan | Pennsylvania | 42113 | 13 | 0 |
588562 | 588562 | 2020-10-01 | Susquehanna | Pennsylvania | 42115 | 297 | 28 |
588563 | 588563 | 2020-10-01 | Tioga | Pennsylvania | 42117 | 81 | 3 |
588564 | 588564 | 2020-10-01 | Union | Pennsylvania | 42119 | 477 | 6 |
588565 | 588565 | 2020-10-01 | Venango | Pennsylvania | 42121 | 93 | 1 |
588566 | 588566 | 2020-10-01 | Warren | Pennsylvania | 42123 | 44 | 1 |
588567 | 588567 | 2020-10-01 | Washington | Pennsylvania | 42125 | 1388 | 30 |
588568 | 588568 | 2020-10-01 | Wayne | Pennsylvania | 42127 | 245 | 10 |
588569 | 588569 | 2020-10-01 | Westmoreland | Pennsylvania | 42129 | 2299 | 56 |
588570 | 588570 | 2020-10-01 | Wyoming | Pennsylvania | 42131 | 78 | 8 |
588571 | 588571 | 2020-10-01 | York | Pennsylvania | 42133 | 4971 | 159 |
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);