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 2020-09-17 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
543150 | 543150 | 2020-09-17 | Adams | Pennsylvania | 42001 | 765 | 25 |
543151 | 543151 | 2020-09-17 | Allegheny | Pennsylvania | 42003 | 11510 | 366 |
543152 | 543152 | 2020-09-17 | Armstrong | Pennsylvania | 42005 | 399 | 15 |
543153 | 543153 | 2020-09-17 | Beaver | Pennsylvania | 42007 | 1814 | 111 |
543154 | 543154 | 2020-09-17 | Bedford | Pennsylvania | 42009 | 222 | 6 |
543155 | 543155 | 2020-09-17 | Berks | Pennsylvania | 42011 | 6741 | 387 |
543156 | 543156 | 2020-09-17 | Blair | Pennsylvania | 42013 | 540 | 13 |
543157 | 543157 | 2020-09-17 | Bradford | Pennsylvania | 42015 | 118 | 3 |
543158 | 543158 | 2020-09-17 | Bucks | Pennsylvania | 42017 | 8415 | 597 |
543159 | 543159 | 2020-09-17 | Butler | Pennsylvania | 42019 | 966 | 22 |
543160 | 543160 | 2020-09-17 | Cambria | Pennsylvania | 42021 | 528 | 7 |
543161 | 543161 | 2020-09-17 | Cameron | Pennsylvania | 42023 | 8 | 0 |
543162 | 543162 | 2020-09-17 | Carbon | Pennsylvania | 42025 | 440 | 28 |
543163 | 543163 | 2020-09-17 | Centre | Pennsylvania | 42027 | 1600 | 11 |
543164 | 543164 | 2020-09-17 | Chester | Pennsylvania | 42029 | 6462 | 362 |
543165 | 543165 | 2020-09-17 | Clarion | Pennsylvania | 42031 | 113 | 3 |
543166 | 543166 | 2020-09-17 | Clearfield | Pennsylvania | 42033 | 293 | 1 |
543167 | 543167 | 2020-09-17 | Clinton | Pennsylvania | 42035 | 185 | 5 |
543168 | 543168 | 2020-09-17 | Columbia | Pennsylvania | 42037 | 848 | 35 |
543169 | 543169 | 2020-09-17 | Crawford | Pennsylvania | 42039 | 283 | 3 |
543170 | 543170 | 2020-09-17 | Cumberland | Pennsylvania | 42041 | 1716 | 74 |
543171 | 543171 | 2020-09-17 | Dauphin | Pennsylvania | 42043 | 3644 | 170 |
543172 | 543172 | 2020-09-17 | Delaware | Pennsylvania | 42045 | 11082 | 784 |
543173 | 543173 | 2020-09-17 | Elk | Pennsylvania | 42047 | 67 | 2 |
543174 | 543174 | 2020-09-17 | Erie | Pennsylvania | 42049 | 1446 | 37 |
543175 | 543175 | 2020-09-17 | Fayette | Pennsylvania | 42051 | 759 | 7 |
543176 | 543176 | 2020-09-17 | Forest | Pennsylvania | 42053 | 14 | 0 |
543177 | 543177 | 2020-09-17 | Franklin | Pennsylvania | 42055 | 1691 | 49 |
543178 | 543178 | 2020-09-17 | Fulton | Pennsylvania | 42057 | 42 | 2 |
543179 | 543179 | 2020-09-17 | Greene | Pennsylvania | 42059 | 165 | 1 |
543180 | 543180 | 2020-09-17 | Huntingdon | Pennsylvania | 42061 | 393 | 6 |
543181 | 543181 | 2020-09-17 | Indiana | Pennsylvania | 42063 | 596 | 12 |
543182 | 543182 | 2020-09-17 | Jefferson | Pennsylvania | 42065 | 107 | 2 |
543183 | 543183 | 2020-09-17 | Juniata | Pennsylvania | 42067 | 172 | 7 |
543184 | 543184 | 2020-09-17 | Lackawanna | Pennsylvania | 42069 | 2337 | 215 |
543185 | 543185 | 2020-09-17 | Lancaster | Pennsylvania | 42071 | 7436 | 449 |
543186 | 543186 | 2020-09-17 | Lawrence | Pennsylvania | 42073 | 492 | 22 |
543187 | 543187 | 2020-09-17 | Lebanon | Pennsylvania | 42075 | 1900 | 58 |
543188 | 543188 | 2020-09-17 | Lehigh | Pennsylvania | 42077 | 5451 | 345 |
543189 | 543189 | 2020-09-17 | Luzerne | Pennsylvania | 42079 | 3989 | 189 |
543190 | 543190 | 2020-09-17 | Lycoming | Pennsylvania | 42081 | 610 | 23 |
543191 | 543191 | 2020-09-17 | McKean | Pennsylvania | 42083 | 51 | 2 |
543192 | 543192 | 2020-09-17 | Mercer | Pennsylvania | 42085 | 663 | 13 |
543193 | 543193 | 2020-09-17 | Mifflin | Pennsylvania | 42087 | 207 | 2 |
543194 | 543194 | 2020-09-17 | Monroe | Pennsylvania | 42089 | 1770 | 129 |
543195 | 543195 | 2020-09-17 | Montgomery | Pennsylvania | 42091 | 11800 | 869 |
543196 | 543196 | 2020-09-17 | Montour | Pennsylvania | 42093 | 162 | 5 |
543197 | 543197 | 2020-09-17 | Northampton | Pennsylvania | 42095 | 4329 | 304 |
543198 | 543198 | 2020-09-17 | Northumberland | Pennsylvania | 42097 | 832 | 46 |
543199 | 543199 | 2020-09-17 | Perry | Pennsylvania | 42099 | 198 | 6 |
543200 | 543200 | 2020-09-17 | Philadelphia | Pennsylvania | 42101 | 35529 | 1798 |
543201 | 543201 | 2020-09-17 | Pike | Pennsylvania | 42103 | 561 | 21 |
543202 | 543202 | 2020-09-17 | Potter | Pennsylvania | 42105 | 25 | 0 |
543203 | 543203 | 2020-09-17 | Schuylkill | Pennsylvania | 42107 | 1051 | 52 |
543204 | 543204 | 2020-09-17 | Snyder | Pennsylvania | 42109 | 243 | 3 |
543205 | 543205 | 2020-09-17 | Somerset | Pennsylvania | 42111 | 197 | 3 |
543206 | 543206 | 2020-09-17 | Sullivan | Pennsylvania | 42113 | 11 | 0 |
543207 | 543207 | 2020-09-17 | Susquehanna | Pennsylvania | 42115 | 291 | 28 |
543208 | 543208 | 2020-09-17 | Tioga | Pennsylvania | 42117 | 52 | 3 |
543209 | 543209 | 2020-09-17 | Union | Pennsylvania | 42119 | 448 | 6 |
543210 | 543210 | 2020-09-17 | Venango | Pennsylvania | 42121 | 80 | 1 |
543211 | 543211 | 2020-09-17 | Warren | Pennsylvania | 42123 | 42 | 1 |
543212 | 543212 | 2020-09-17 | Washington | Pennsylvania | 42125 | 1250 | 28 |
543213 | 543213 | 2020-09-17 | Wayne | Pennsylvania | 42127 | 208 | 10 |
543214 | 543214 | 2020-09-17 | Westmoreland | Pennsylvania | 42129 | 2021 | 50 |
543215 | 543215 | 2020-09-17 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
543216 | 543216 | 2020-09-17 | York | Pennsylvania | 42133 | 4361 | 136 |
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);