ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where "date" is on date 2020-04-04 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adams 1
- Allegheny 1
- Armstrong 1
- Beaver 1
- Bedford 1
- Berks 1
- Blair 1
- Bradford 1
- Bucks 1
- Butler 1
- Cambria 1
- Cameron 1
- Carbon 1
- Centre 1
- Chester 1
- Clarion 1
- Clearfield 1
- Clinton 1
- Columbia 1
- Crawford 1
- Cumberland 1
- Dauphin 1
- Delaware 1
- Erie 1
- Fayette 1
- Forest 1
- Franklin 1
- Greene 1
- Huntingdon 1
- Indiana 1
- …
state 1
- Pennsylvania · 64 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
32481 | 32481 | 2020-04-04 | Adams | Pennsylvania | 42001 | 21 | 0 |
32482 | 32482 | 2020-04-04 | Allegheny | Pennsylvania | 42003 | 552 | 3 |
32483 | 32483 | 2020-04-04 | Armstrong | Pennsylvania | 42005 | 12 | 0 |
32484 | 32484 | 2020-04-04 | Beaver | Pennsylvania | 42007 | 69 | 6 |
32485 | 32485 | 2020-04-04 | Bedford | Pennsylvania | 42009 | 4 | 0 |
32486 | 32486 | 2020-04-04 | Berks | Pennsylvania | 42011 | 235 | 2 |
32487 | 32487 | 2020-04-04 | Blair | Pennsylvania | 42013 | 6 | 0 |
32488 | 32488 | 2020-04-04 | Bradford | Pennsylvania | 42015 | 10 | 0 |
32489 | 32489 | 2020-04-04 | Bucks | Pennsylvania | 42017 | 580 | 14 |
32490 | 32490 | 2020-04-04 | Butler | Pennsylvania | 42019 | 84 | 2 |
32491 | 32491 | 2020-04-04 | Cambria | Pennsylvania | 42021 | 6 | 0 |
32492 | 32492 | 2020-04-04 | Cameron | Pennsylvania | 42023 | 1 | 0 |
32493 | 32493 | 2020-04-04 | Carbon | Pennsylvania | 42025 | 46 | 1 |
32494 | 32494 | 2020-04-04 | Centre | Pennsylvania | 42027 | 39 | 0 |
32495 | 32495 | 2020-04-04 | Chester | Pennsylvania | 42029 | 250 | 2 |
32496 | 32496 | 2020-04-04 | Clarion | Pennsylvania | 42031 | 4 | 0 |
32497 | 32497 | 2020-04-04 | Clearfield | Pennsylvania | 42033 | 7 | 0 |
32498 | 32498 | 2020-04-04 | Clinton | Pennsylvania | 42035 | 1 | 0 |
32499 | 32499 | 2020-04-04 | Columbia | Pennsylvania | 42037 | 20 | 0 |
32500 | 32500 | 2020-04-04 | Crawford | Pennsylvania | 42039 | 5 | 0 |
32501 | 32501 | 2020-04-04 | Cumberland | Pennsylvania | 42041 | 54 | 2 |
32502 | 32502 | 2020-04-04 | Dauphin | Pennsylvania | 42043 | 99 | 1 |
32503 | 32503 | 2020-04-04 | Delaware | Pennsylvania | 42045 | 616 | 13 |
32504 | 32504 | 2020-04-04 | Erie | Pennsylvania | 42049 | 19 | 1 |
32505 | 32505 | 2020-04-04 | Fayette | Pennsylvania | 42051 | 23 | 1 |
32506 | 32506 | 2020-04-04 | Forest | Pennsylvania | 42053 | 2 | 0 |
32507 | 32507 | 2020-04-04 | Franklin | Pennsylvania | 42055 | 27 | 0 |
32508 | 32508 | 2020-04-04 | Greene | Pennsylvania | 42059 | 12 | 0 |
32509 | 32509 | 2020-04-04 | Huntingdon | Pennsylvania | 42061 | 4 | 0 |
32510 | 32510 | 2020-04-04 | Indiana | Pennsylvania | 42063 | 9 | 0 |
32511 | 32511 | 2020-04-04 | Juniata | Pennsylvania | 42067 | 7 | 0 |
32512 | 32512 | 2020-04-04 | Lackawanna | Pennsylvania | 42069 | 146 | 6 |
32513 | 32513 | 2020-04-04 | Lancaster | Pennsylvania | 42071 | 291 | 5 |
32514 | 32514 | 2020-04-04 | Lawrence | Pennsylvania | 42073 | 22 | 2 |
32515 | 32515 | 2020-04-04 | Lebanon | Pennsylvania | 42075 | 87 | 0 |
32516 | 32516 | 2020-04-04 | Lehigh | Pennsylvania | 42077 | 804 | 7 |
32517 | 32517 | 2020-04-04 | Luzerne | Pennsylvania | 42079 | 648 | 5 |
32518 | 32518 | 2020-04-04 | Lycoming | Pennsylvania | 42081 | 10 | 0 |
32519 | 32519 | 2020-04-04 | McKean | Pennsylvania | 42083 | 1 | 0 |
32520 | 32520 | 2020-04-04 | Mercer | Pennsylvania | 42085 | 14 | 0 |
32521 | 32521 | 2020-04-04 | Mifflin | Pennsylvania | 42087 | 4 | 0 |
32522 | 32522 | 2020-04-04 | Monroe | Pennsylvania | 42089 | 484 | 11 |
32523 | 32523 | 2020-04-04 | Montgomery | Pennsylvania | 42091 | 982 | 17 |
32524 | 32524 | 2020-04-04 | Montour | Pennsylvania | 42093 | 19 | 0 |
32525 | 32525 | 2020-04-04 | Northampton | Pennsylvania | 42095 | 588 | 11 |
32526 | 32526 | 2020-04-04 | Northumberland | Pennsylvania | 42097 | 9 | 0 |
32527 | 32527 | 2020-04-04 | Perry | Pennsylvania | 42099 | 5 | 1 |
32528 | 32528 | 2020-04-04 | Philadelphia | Pennsylvania | 42101 | 2610 | 24 |
32529 | 32529 | 2020-04-04 | Pike | Pennsylvania | 42103 | 97 | 1 |
32530 | 32530 | 2020-04-04 | Potter | Pennsylvania | 42105 | 3 | 0 |
32531 | 32531 | 2020-04-04 | Schuylkill | Pennsylvania | 42107 | 77 | 0 |
32532 | 32532 | 2020-04-04 | Snyder | Pennsylvania | 42109 | 6 | 1 |
32533 | 32533 | 2020-04-04 | Somerset | Pennsylvania | 42111 | 3 | 0 |
32534 | 32534 | 2020-04-04 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
32535 | 32535 | 2020-04-04 | Susquehanna | Pennsylvania | 42115 | 5 | 0 |
32536 | 32536 | 2020-04-04 | Tioga | Pennsylvania | 42117 | 3 | 0 |
32537 | 32537 | 2020-04-04 | Union | Pennsylvania | 42119 | 5 | 0 |
32538 | 32538 | 2020-04-04 | Venango | Pennsylvania | 42121 | 3 | 0 |
32539 | 32539 | 2020-04-04 | Warren | Pennsylvania | 42123 | 1 | 0 |
32540 | 32540 | 2020-04-04 | Washington | Pennsylvania | 42125 | 46 | 0 |
32541 | 32541 | 2020-04-04 | Wayne | Pennsylvania | 42127 | 28 | 0 |
32542 | 32542 | 2020-04-04 | Westmoreland | Pennsylvania | 42129 | 135 | 0 |
32543 | 32543 | 2020-04-04 | Wyoming | Pennsylvania | 42131 | 5 | 0 |
32544 | 32544 | 2020-04-04 | York | Pennsylvania | 42133 | 144 | 1 |
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);