ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-04-26" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
91685 | 91685 | 2020-04-26 | Adams | Pennsylvania | 42001 | 117 | 2 |
91686 | 91686 | 2020-04-26 | Allegheny | Pennsylvania | 42003 | 1211 | 73 |
91687 | 91687 | 2020-04-26 | Armstrong | Pennsylvania | 42005 | 46 | 2 |
91688 | 91688 | 2020-04-26 | Beaver | Pennsylvania | 42007 | 366 | 46 |
91689 | 91689 | 2020-04-26 | Bedford | Pennsylvania | 42009 | 21 | 1 |
91690 | 91690 | 2020-04-26 | Berks | Pennsylvania | 42011 | 2491 | 88 |
91691 | 91691 | 2020-04-26 | Blair | Pennsylvania | 42013 | 21 | 0 |
91692 | 91692 | 2020-04-26 | Bradford | Pennsylvania | 42015 | 28 | 5 |
91693 | 91693 | 2020-04-26 | Bucks | Pennsylvania | 42017 | 2541 | 151 |
91694 | 91694 | 2020-04-26 | Butler | Pennsylvania | 42019 | 170 | 6 |
91695 | 91695 | 2020-04-26 | Cambria | Pennsylvania | 42021 | 21 | 2 |
91696 | 91696 | 2020-04-26 | Cameron | Pennsylvania | 42023 | 1 | 0 |
91697 | 91697 | 2020-04-26 | Carbon | Pennsylvania | 42025 | 163 | 12 |
91698 | 91698 | 2020-04-26 | Centre | Pennsylvania | 42027 | 81 | 2 |
91699 | 91699 | 2020-04-26 | Chester | Pennsylvania | 42029 | 1217 | 82 |
91700 | 91700 | 2020-04-26 | Clarion | Pennsylvania | 42031 | 22 | 1 |
91701 | 91701 | 2020-04-26 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
91702 | 91702 | 2020-04-26 | Clinton | Pennsylvania | 42035 | 21 | 0 |
91703 | 91703 | 2020-04-26 | Columbia | Pennsylvania | 42037 | 269 | 8 |
91704 | 91704 | 2020-04-26 | Crawford | Pennsylvania | 42039 | 19 | 0 |
91705 | 91705 | 2020-04-26 | Cumberland | Pennsylvania | 42041 | 267 | 8 |
91706 | 91706 | 2020-04-26 | Dauphin | Pennsylvania | 42043 | 519 | 18 |
91707 | 91707 | 2020-04-26 | Delaware | Pennsylvania | 42045 | 3333 | 143 |
91708 | 91708 | 2020-04-26 | Elk | Pennsylvania | 42047 | 3 | 0 |
91709 | 91709 | 2020-04-26 | Erie | Pennsylvania | 42049 | 77 | 1 |
91710 | 91710 | 2020-04-26 | Fayette | Pennsylvania | 42051 | 79 | 4 |
91711 | 91711 | 2020-04-26 | Forest | Pennsylvania | 42053 | 7 | 0 |
91712 | 91712 | 2020-04-26 | Franklin | Pennsylvania | 42055 | 205 | 10 |
91713 | 91713 | 2020-04-26 | Fulton | Pennsylvania | 42057 | 3 | 0 |
91714 | 91714 | 2020-04-26 | Greene | Pennsylvania | 42059 | 25 | 0 |
91715 | 91715 | 2020-04-26 | Huntingdon | Pennsylvania | 42061 | 22 | 0 |
91716 | 91716 | 2020-04-26 | Indiana | Pennsylvania | 42063 | 63 | 4 |
91717 | 91717 | 2020-04-26 | Jefferson | Pennsylvania | 42065 | 4 | 0 |
91718 | 91718 | 2020-04-26 | Juniata | Pennsylvania | 42067 | 78 | 0 |
91719 | 91719 | 2020-04-26 | Lackawanna | Pennsylvania | 42069 | 793 | 63 |
91720 | 91720 | 2020-04-26 | Lancaster | Pennsylvania | 42071 | 1577 | 145 |
91721 | 91721 | 2020-04-26 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
91722 | 91722 | 2020-04-26 | Lebanon | Pennsylvania | 42075 | 612 | 8 |
91723 | 91723 | 2020-04-26 | Lehigh | Pennsylvania | 42077 | 2601 | 51 |
91724 | 91724 | 2020-04-26 | Luzerne | Pennsylvania | 42079 | 2008 | 67 |
91725 | 91725 | 2020-04-26 | Lycoming | Pennsylvania | 42081 | 55 | 2 |
91726 | 91726 | 2020-04-26 | McKean | Pennsylvania | 42083 | 5 | 0 |
91727 | 91727 | 2020-04-26 | Mercer | Pennsylvania | 42085 | 65 | 1 |
91728 | 91728 | 2020-04-26 | Mifflin | Pennsylvania | 42087 | 27 | 0 |
91729 | 91729 | 2020-04-26 | Monroe | Pennsylvania | 42089 | 1065 | 46 |
91730 | 91730 | 2020-04-26 | Montgomery | Pennsylvania | 42091 | 3733 | 217 |
91731 | 91731 | 2020-04-26 | Montour | Pennsylvania | 42093 | 48 | 0 |
91732 | 91732 | 2020-04-26 | Northampton | Pennsylvania | 42095 | 1813 | 49 |
91733 | 91733 | 2020-04-26 | Northumberland | Pennsylvania | 42097 | 90 | 0 |
91734 | 91734 | 2020-04-26 | Perry | Pennsylvania | 42099 | 26 | 1 |
91735 | 91735 | 2020-04-26 | Philadelphia | Pennsylvania | 42101 | 12566 | 472 |
91736 | 91736 | 2020-04-26 | Pike | Pennsylvania | 42103 | 349 | 12 |
91737 | 91737 | 2020-04-26 | Potter | Pennsylvania | 42105 | 4 | 0 |
91738 | 91738 | 2020-04-26 | Schuylkill | Pennsylvania | 42107 | 321 | 7 |
91739 | 91739 | 2020-04-26 | Snyder | Pennsylvania | 42109 | 33 | 1 |
91740 | 91740 | 2020-04-26 | Somerset | Pennsylvania | 42111 | 25 | 0 |
91741 | 91741 | 2020-04-26 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
91742 | 91742 | 2020-04-26 | Susquehanna | Pennsylvania | 42115 | 79 | 4 |
91743 | 91743 | 2020-04-26 | Tioga | Pennsylvania | 42117 | 14 | 2 |
91744 | 91744 | 2020-04-26 | Union | Pennsylvania | 42119 | 31 | 0 |
91745 | 91745 | 2020-04-26 | Venango | Pennsylvania | 42121 | 7 | 0 |
91746 | 91746 | 2020-04-26 | Warren | Pennsylvania | 42123 | 1 | 1 |
91747 | 91747 | 2020-04-26 | Washington | Pennsylvania | 42125 | 101 | 2 |
91748 | 91748 | 2020-04-26 | Wayne | Pennsylvania | 42127 | 92 | 3 |
91749 | 91749 | 2020-04-26 | Westmoreland | Pennsylvania | 42129 | 374 | 27 |
91750 | 91750 | 2020-04-26 | Wyoming | Pennsylvania | 42131 | 17 | 2 |
91751 | 91751 | 2020-04-26 | York | Pennsylvania | 42133 | 593 | 13 |
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);