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 2021-04-19 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1237596 | 1237596 | 2021-04-19 | Adams | Pennsylvania | 42001 | 8770 | 168 |
1237597 | 1237597 | 2021-04-19 | Allegheny | Pennsylvania | 42003 | 94112 | 1870 |
1237598 | 1237598 | 2021-04-19 | Armstrong | Pennsylvania | 42005 | 5529 | 123 |
1237599 | 1237599 | 2021-04-19 | Beaver | Pennsylvania | 42007 | 14217 | 367 |
1237600 | 1237600 | 2021-04-19 | Bedford | Pennsylvania | 42009 | 4175 | 131 |
1237601 | 1237601 | 2021-04-19 | Berks | Pennsylvania | 42011 | 43516 | 961 |
1237602 | 1237602 | 2021-04-19 | Blair | Pennsylvania | 42013 | 11957 | 318 |
1237603 | 1237603 | 2021-04-19 | Bradford | Pennsylvania | 42015 | 5416 | 86 |
1237604 | 1237604 | 2021-04-19 | Bucks | Pennsylvania | 42017 | 56123 | 1212 |
1237605 | 1237605 | 2021-04-19 | Butler | Pennsylvania | 42019 | 16290 | 400 |
1237606 | 1237606 | 2021-04-19 | Cambria | Pennsylvania | 42021 | 13134 | 412 |
1237607 | 1237607 | 2021-04-19 | Cameron | Pennsylvania | 42023 | 286 | 7 |
1237608 | 1237608 | 2021-04-19 | Carbon | Pennsylvania | 42025 | 5842 | 163 |
1237609 | 1237609 | 2021-04-19 | Centre | Pennsylvania | 42027 | 15744 | 215 |
1237610 | 1237610 | 2021-04-19 | Chester | Pennsylvania | 42029 | 37555 | 764 |
1237611 | 1237611 | 2021-04-19 | Clarion | Pennsylvania | 42031 | 2962 | 89 |
1237612 | 1237612 | 2021-04-19 | Clearfield | Pennsylvania | 42033 | 7854 | 133 |
1237613 | 1237613 | 2021-04-19 | Clinton | Pennsylvania | 42035 | 3378 | 60 |
1237614 | 1237614 | 2021-04-19 | Columbia | Pennsylvania | 42037 | 5247 | 130 |
1237615 | 1237615 | 2021-04-19 | Crawford | Pennsylvania | 42039 | 6879 | 146 |
1237616 | 1237616 | 2021-04-19 | Cumberland | Pennsylvania | 42041 | 19013 | 503 |
1237617 | 1237617 | 2021-04-19 | Dauphin | Pennsylvania | 42043 | 23850 | 530 |
1237618 | 1237618 | 2021-04-19 | Delaware | Pennsylvania | 42045 | 48757 | 1365 |
1237619 | 1237619 | 2021-04-19 | Elk | Pennsylvania | 42047 | 2743 | 38 |
1237620 | 1237620 | 2021-04-19 | Erie | Pennsylvania | 42049 | 19551 | 402 |
1237621 | 1237621 | 2021-04-19 | Fayette | Pennsylvania | 42051 | 12018 | 298 |
1237622 | 1237622 | 2021-04-19 | Forest | Pennsylvania | 42053 | 1400 | 21 |
1237623 | 1237623 | 2021-04-19 | Franklin | Pennsylvania | 42055 | 14288 | 348 |
1237624 | 1237624 | 2021-04-19 | Fulton | Pennsylvania | 42057 | 1253 | 15 |
1237625 | 1237625 | 2021-04-19 | Greene | Pennsylvania | 42059 | 3082 | 38 |
1237626 | 1237626 | 2021-04-19 | Huntingdon | Pennsylvania | 42061 | 4761 | 128 |
1237627 | 1237627 | 2021-04-19 | Indiana | Pennsylvania | 42063 | 5743 | 165 |
1237628 | 1237628 | 2021-04-19 | Jefferson | Pennsylvania | 42065 | 3155 | 94 |
1237629 | 1237629 | 2021-04-19 | Juniata | Pennsylvania | 42067 | 2009 | 82 |
1237630 | 1237630 | 2021-04-19 | Lackawanna | Pennsylvania | 42069 | 16978 | 447 |
1237631 | 1237631 | 2021-04-19 | Lancaster | Pennsylvania | 42071 | 51426 | 1094 |
1237632 | 1237632 | 2021-04-19 | Lawrence | Pennsylvania | 42073 | 7046 | 200 |
1237633 | 1237633 | 2021-04-19 | Lebanon | Pennsylvania | 42075 | 14729 | 270 |
1237634 | 1237634 | 2021-04-19 | Lehigh | Pennsylvania | 42077 | 36758 | 820 |
1237635 | 1237635 | 2021-04-19 | Luzerne | Pennsylvania | 42079 | 29136 | 780 |
1237636 | 1237636 | 2021-04-19 | Lycoming | Pennsylvania | 42081 | 10952 | 270 |
1237637 | 1237637 | 2021-04-19 | McKean | Pennsylvania | 42083 | 3360 | 66 |
1237638 | 1237638 | 2021-04-19 | Mercer | Pennsylvania | 42085 | 8913 | 253 |
1237639 | 1237639 | 2021-04-19 | Mifflin | Pennsylvania | 42087 | 4976 | 175 |
1237640 | 1237640 | 2021-04-19 | Monroe | Pennsylvania | 42089 | 13064 | 296 |
1237641 | 1237641 | 2021-04-19 | Montgomery | Pennsylvania | 42091 | 65352 | 1632 |
1237642 | 1237642 | 2021-04-19 | Montour | Pennsylvania | 42093 | 1911 | 62 |
1237643 | 1237643 | 2021-04-19 | Northampton | Pennsylvania | 42095 | 33225 | 687 |
1237644 | 1237644 | 2021-04-19 | Northumberland | Pennsylvania | 42097 | 8976 | 342 |
1237645 | 1237645 | 2021-04-19 | Perry | Pennsylvania | 42099 | 3489 | 95 |
1237646 | 1237646 | 2021-04-19 | Philadelphia | Pennsylvania | 42101 | 141551 | 3390 |
1237647 | 1237647 | 2021-04-19 | Pike | Pennsylvania | 42103 | 3549 | 52 |
1237648 | 1237648 | 2021-04-19 | Potter | Pennsylvania | 42105 | 1024 | 23 |
1237649 | 1237649 | 2021-04-19 | Schuylkill | Pennsylvania | 42107 | 13635 | 387 |
1237650 | 1237650 | 2021-04-19 | Snyder | Pennsylvania | 42109 | 3446 | 82 |
1237651 | 1237651 | 2021-04-19 | Somerset | Pennsylvania | 42111 | 7288 | 193 |
1237652 | 1237652 | 2021-04-19 | Sullivan | Pennsylvania | 42113 | 376 | 20 |
1237653 | 1237653 | 2021-04-19 | Susquehanna | Pennsylvania | 42115 | 2262 | 57 |
1237654 | 1237654 | 2021-04-19 | Tioga | Pennsylvania | 42117 | 2778 | 102 |
1237655 | 1237655 | 2021-04-19 | Union | Pennsylvania | 42119 | 5740 | 86 |
1237656 | 1237656 | 2021-04-19 | Venango | Pennsylvania | 42121 | 3659 | 91 |
1237657 | 1237657 | 2021-04-19 | Warren | Pennsylvania | 42123 | 2438 | 99 |
1237658 | 1237658 | 2021-04-19 | Washington | Pennsylvania | 42125 | 16348 | 284 |
1237659 | 1237659 | 2021-04-19 | Wayne | Pennsylvania | 42127 | 3684 | 76 |
1237660 | 1237660 | 2021-04-19 | Westmoreland | Pennsylvania | 42129 | 31535 | 724 |
1237661 | 1237661 | 2021-04-19 | Wyoming | Pennsylvania | 42131 | 1727 | 44 |
1237662 | 1237662 | 2021-04-19 | York | Pennsylvania | 42133 | 42532 | 763 |
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);