ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-05-28" 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 |
---|---|---|---|---|---|---|---|
186717 | 186717 | 2020-05-28 | Adams | Pennsylvania | 42001 | 240 | 7 |
186718 | 186718 | 2020-05-28 | Allegheny | Pennsylvania | 42003 | 1851 | 161 |
186719 | 186719 | 2020-05-28 | Armstrong | Pennsylvania | 42005 | 62 | 4 |
186720 | 186720 | 2020-05-28 | Beaver | Pennsylvania | 42007 | 579 | 72 |
186721 | 186721 | 2020-05-28 | Bedford | Pennsylvania | 42009 | 38 | 2 |
186722 | 186722 | 2020-05-28 | Berks | Pennsylvania | 42011 | 3973 | 308 |
186723 | 186723 | 2020-05-28 | Blair | Pennsylvania | 42013 | 49 | 1 |
186724 | 186724 | 2020-05-28 | Bradford | Pennsylvania | 42015 | 46 | 3 |
186725 | 186725 | 2020-05-28 | Bucks | Pennsylvania | 42017 | 4966 | 486 |
186726 | 186726 | 2020-05-28 | Butler | Pennsylvania | 42019 | 226 | 12 |
186727 | 186727 | 2020-05-28 | Cambria | Pennsylvania | 42021 | 57 | 2 |
186728 | 186728 | 2020-05-28 | Cameron | Pennsylvania | 42023 | 2 | 0 |
186729 | 186729 | 2020-05-28 | Carbon | Pennsylvania | 42025 | 232 | 22 |
186730 | 186730 | 2020-05-28 | Centre | Pennsylvania | 42027 | 150 | 6 |
186731 | 186731 | 2020-05-28 | Chester | Pennsylvania | 42029 | 2595 | 270 |
186732 | 186732 | 2020-05-28 | Clarion | Pennsylvania | 42031 | 25 | 2 |
186733 | 186733 | 2020-05-28 | Clearfield | Pennsylvania | 42033 | 37 | 0 |
186734 | 186734 | 2020-05-28 | Clinton | Pennsylvania | 42035 | 55 | 2 |
186735 | 186735 | 2020-05-28 | Columbia | Pennsylvania | 42037 | 346 | 31 |
186736 | 186736 | 2020-05-28 | Crawford | Pennsylvania | 42039 | 23 | 0 |
186737 | 186737 | 2020-05-28 | Cumberland | Pennsylvania | 42041 | 618 | 47 |
186738 | 186738 | 2020-05-28 | Dauphin | Pennsylvania | 42043 | 1212 | 71 |
186739 | 186739 | 2020-05-28 | Delaware | Pennsylvania | 42045 | 6389 | 544 |
186740 | 186740 | 2020-05-28 | Elk | Pennsylvania | 42047 | 6 | 0 |
186741 | 186741 | 2020-05-28 | Erie | Pennsylvania | 42049 | 242 | 4 |
186742 | 186742 | 2020-05-28 | Fayette | Pennsylvania | 42051 | 95 | 4 |
186743 | 186743 | 2020-05-28 | Forest | Pennsylvania | 42053 | 7 | 0 |
186744 | 186744 | 2020-05-28 | Franklin | Pennsylvania | 42055 | 759 | 31 |
186745 | 186745 | 2020-05-28 | Fulton | Pennsylvania | 42057 | 15 | 1 |
186746 | 186746 | 2020-05-28 | Greene | Pennsylvania | 42059 | 27 | 0 |
186747 | 186747 | 2020-05-28 | Huntingdon | Pennsylvania | 42061 | 228 | 2 |
186748 | 186748 | 2020-05-28 | Indiana | Pennsylvania | 42063 | 90 | 5 |
186749 | 186749 | 2020-05-28 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
186750 | 186750 | 2020-05-28 | Juniata | Pennsylvania | 42067 | 95 | 4 |
186751 | 186751 | 2020-05-28 | Lackawanna | Pennsylvania | 42069 | 1516 | 163 |
186752 | 186752 | 2020-05-28 | Lancaster | Pennsylvania | 42071 | 3056 | 291 |
186753 | 186753 | 2020-05-28 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
186754 | 186754 | 2020-05-28 | Lebanon | Pennsylvania | 42075 | 944 | 33 |
186755 | 186755 | 2020-05-28 | Lehigh | Pennsylvania | 42077 | 3719 | 218 |
186756 | 186756 | 2020-05-28 | Luzerne | Pennsylvania | 42079 | 2689 | 139 |
186757 | 186757 | 2020-05-28 | Lycoming | Pennsylvania | 42081 | 162 | 16 |
186758 | 186758 | 2020-05-28 | McKean | Pennsylvania | 42083 | 12 | 1 |
186759 | 186759 | 2020-05-28 | Mercer | Pennsylvania | 42085 | 106 | 4 |
186760 | 186760 | 2020-05-28 | Mifflin | Pennsylvania | 42087 | 58 | 1 |
186761 | 186761 | 2020-05-28 | Monroe | Pennsylvania | 42089 | 1311 | 101 |
186762 | 186762 | 2020-05-28 | Montgomery | Pennsylvania | 42091 | 6811 | 675 |
186763 | 186763 | 2020-05-28 | Montour | Pennsylvania | 42093 | 50 | 0 |
186764 | 186764 | 2020-05-28 | Northampton | Pennsylvania | 42095 | 3022 | 206 |
186765 | 186765 | 2020-05-28 | Northumberland | Pennsylvania | 42097 | 186 | 3 |
186766 | 186766 | 2020-05-28 | Perry | Pennsylvania | 42099 | 54 | 2 |
186767 | 186767 | 2020-05-28 | Philadelphia | Pennsylvania | 42101 | 22150 | 1282 |
186768 | 186768 | 2020-05-28 | Pike | Pennsylvania | 42103 | 476 | 18 |
186769 | 186769 | 2020-05-28 | Potter | Pennsylvania | 42105 | 4 | 0 |
186770 | 186770 | 2020-05-28 | Schuylkill | Pennsylvania | 42107 | 606 | 31 |
186771 | 186771 | 2020-05-28 | Snyder | Pennsylvania | 42109 | 39 | 1 |
186772 | 186772 | 2020-05-28 | Somerset | Pennsylvania | 42111 | 37 | 0 |
186773 | 186773 | 2020-05-28 | Sullivan | Pennsylvania | 42113 | 2 | 0 |
186774 | 186774 | 2020-05-28 | Susquehanna | Pennsylvania | 42115 | 99 | 15 |
186775 | 186775 | 2020-05-28 | Tioga | Pennsylvania | 42117 | 16 | 2 |
186776 | 186776 | 2020-05-28 | Union | Pennsylvania | 42119 | 56 | 1 |
186777 | 186777 | 2020-05-28 | Venango | Pennsylvania | 42121 | 8 | 0 |
186778 | 186778 | 2020-05-28 | Warren | Pennsylvania | 42123 | 3 | 0 |
186779 | 186779 | 2020-05-28 | Washington | Pennsylvania | 42125 | 139 | 5 |
186780 | 186780 | 2020-05-28 | Wayne | Pennsylvania | 42127 | 118 | 7 |
186781 | 186781 | 2020-05-28 | Westmoreland | Pennsylvania | 42129 | 443 | 38 |
186782 | 186782 | 2020-05-28 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
186783 | 186783 | 2020-05-28 | York | Pennsylvania | 42133 | 970 | 25 |
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);