ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-12-20" 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 |
---|---|---|---|---|---|---|---|
848059 | 848059 | 2020-12-20 | Adams | Pennsylvania | 42001 | 3630 | 64 |
848060 | 848060 | 2020-12-20 | Allegheny | Pennsylvania | 42003 | 46330 | 823 |
848061 | 848061 | 2020-12-20 | Armstrong | Pennsylvania | 42005 | 2853 | 63 |
848062 | 848062 | 2020-12-20 | Beaver | Pennsylvania | 42007 | 7294 | 217 |
848063 | 848063 | 2020-12-20 | Bedford | Pennsylvania | 42009 | 2677 | 79 |
848064 | 848064 | 2020-12-20 | Berks | Pennsylvania | 42011 | 20259 | 516 |
848065 | 848065 | 2020-12-20 | Blair | Pennsylvania | 42013 | 6988 | 142 |
848066 | 848066 | 2020-12-20 | Bradford | Pennsylvania | 42015 | 2721 | 50 |
848067 | 848067 | 2020-12-20 | Bucks | Pennsylvania | 42017 | 26706 | 836 |
848068 | 848068 | 2020-12-20 | Butler | Pennsylvania | 42019 | 7709 | 146 |
848069 | 848069 | 2020-12-20 | Cambria | Pennsylvania | 42021 | 7958 | 198 |
848070 | 848070 | 2020-12-20 | Cameron | Pennsylvania | 42023 | 110 | 1 |
848071 | 848071 | 2020-12-20 | Carbon | Pennsylvania | 42025 | 2212 | 86 |
848072 | 848072 | 2020-12-20 | Centre | Pennsylvania | 42027 | 8289 | 124 |
848073 | 848073 | 2020-12-20 | Chester | Pennsylvania | 42029 | 17798 | 459 |
848074 | 848074 | 2020-12-20 | Clarion | Pennsylvania | 42031 | 1769 | 30 |
848075 | 848075 | 2020-12-20 | Clearfield | Pennsylvania | 42033 | 3278 | 32 |
848076 | 848076 | 2020-12-20 | Clinton | Pennsylvania | 42035 | 1541 | 18 |
848077 | 848077 | 2020-12-20 | Columbia | Pennsylvania | 42037 | 2219 | 57 |
848078 | 848078 | 2020-12-20 | Crawford | Pennsylvania | 42039 | 4281 | 61 |
848079 | 848079 | 2020-12-20 | Cumberland | Pennsylvania | 42041 | 8924 | 252 |
848080 | 848080 | 2020-12-20 | Dauphin | Pennsylvania | 42043 | 12134 | 273 |
848081 | 848081 | 2020-12-20 | Delaware | Pennsylvania | 42045 | 26299 | 925 |
848082 | 848082 | 2020-12-20 | Elk | Pennsylvania | 42047 | 1075 | 13 |
848083 | 848083 | 2020-12-20 | Erie | Pennsylvania | 42049 | 9899 | 162 |
848084 | 848084 | 2020-12-20 | Fayette | Pennsylvania | 42051 | 5684 | 60 |
848085 | 848085 | 2020-12-20 | Forest | Pennsylvania | 42053 | 214 | 2 |
848086 | 848086 | 2020-12-20 | Franklin | Pennsylvania | 42055 | 7547 | 187 |
848087 | 848087 | 2020-12-20 | Fulton | Pennsylvania | 42057 | 586 | 7 |
848088 | 848088 | 2020-12-20 | Greene | Pennsylvania | 42059 | 1332 | 9 |
848089 | 848089 | 2020-12-20 | Huntingdon | Pennsylvania | 42061 | 2550 | 76 |
848090 | 848090 | 2020-12-20 | Indiana | Pennsylvania | 42063 | 3655 | 97 |
848091 | 848091 | 2020-12-20 | Jefferson | Pennsylvania | 42065 | 1618 | 26 |
848092 | 848092 | 2020-12-20 | Juniata | Pennsylvania | 42067 | 1174 | 34 |
848093 | 848093 | 2020-12-20 | Lackawanna | Pennsylvania | 42069 | 7386 | 256 |
848094 | 848094 | 2020-12-20 | Lancaster | Pennsylvania | 42071 | 24613 | 658 |
848095 | 848095 | 2020-12-20 | Lawrence | Pennsylvania | 42073 | 3697 | 107 |
848096 | 848096 | 2020-12-20 | Lebanon | Pennsylvania | 42075 | 7693 | 141 |
848097 | 848097 | 2020-12-20 | Lehigh | Pennsylvania | 42077 | 17286 | 444 |
848098 | 848098 | 2020-12-20 | Luzerne | Pennsylvania | 42079 | 15135 | 404 |
848099 | 848099 | 2020-12-20 | Lycoming | Pennsylvania | 42081 | 4746 | 93 |
848100 | 848100 | 2020-12-20 | McKean | Pennsylvania | 42083 | 1323 | 12 |
848101 | 848101 | 2020-12-20 | Mercer | Pennsylvania | 42085 | 5166 | 104 |
848102 | 848102 | 2020-12-20 | Mifflin | Pennsylvania | 42087 | 3034 | 92 |
848103 | 848103 | 2020-12-20 | Monroe | Pennsylvania | 42089 | 5206 | 186 |
848104 | 848104 | 2020-12-20 | Montgomery | Pennsylvania | 42091 | 31421 | 1062 |
848105 | 848105 | 2020-12-20 | Montour | Pennsylvania | 42093 | 939 | 19 |
848106 | 848106 | 2020-12-20 | Northampton | Pennsylvania | 42095 | 14123 | 384 |
848107 | 848107 | 2020-12-20 | Northumberland | Pennsylvania | 42097 | 4151 | 196 |
848108 | 848108 | 2020-12-20 | Perry | Pennsylvania | 42099 | 1364 | 24 |
848109 | 848109 | 2020-12-20 | Philadelphia | Pennsylvania | 42101 | 85733 | 2310 |
848110 | 848110 | 2020-12-20 | Pike | Pennsylvania | 42103 | 1214 | 29 |
848111 | 848111 | 2020-12-20 | Potter | Pennsylvania | 42105 | 492 | 10 |
848112 | 848112 | 2020-12-20 | Schuylkill | Pennsylvania | 42107 | 6453 | 224 |
848113 | 848113 | 2020-12-20 | Snyder | Pennsylvania | 42109 | 1651 | 33 |
848114 | 848114 | 2020-12-20 | Somerset | Pennsylvania | 42111 | 4024 | 52 |
848115 | 848115 | 2020-12-20 | Sullivan | Pennsylvania | 42113 | 120 | 2 |
848116 | 848116 | 2020-12-20 | Susquehanna | Pennsylvania | 42115 | 868 | 37 |
848117 | 848117 | 2020-12-20 | Tioga | Pennsylvania | 42117 | 1748 | 45 |
848118 | 848118 | 2020-12-20 | Union | Pennsylvania | 42119 | 2453 | 26 |
848119 | 848119 | 2020-12-20 | Venango | Pennsylvania | 42121 | 1967 | 31 |
848120 | 848120 | 2020-12-20 | Warren | Pennsylvania | 42123 | 1037 | 15 |
848121 | 848121 | 2020-12-20 | Washington | Pennsylvania | 42125 | 7522 | 110 |
848122 | 848122 | 2020-12-20 | Wayne | Pennsylvania | 42127 | 1288 | 15 |
848123 | 848123 | 2020-12-20 | Westmoreland | Pennsylvania | 42129 | 16416 | 348 |
848124 | 848124 | 2020-12-20 | Wyoming | Pennsylvania | 42131 | 660 | 29 |
848125 | 848125 | 2020-12-20 | York | Pennsylvania | 42133 | 19760 | 341 |
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);