ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-07-22" 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 |
---|---|---|---|---|---|---|---|
359263 | 359263 | 2020-07-22 | Adams | Pennsylvania | 42001 | 424 | 15 |
359264 | 359264 | 2020-07-22 | Allegheny | Pennsylvania | 42003 | 6670 | 217 |
359265 | 359265 | 2020-07-22 | Armstrong | Pennsylvania | 42005 | 129 | 6 |
359266 | 359266 | 2020-07-22 | Beaver | Pennsylvania | 42007 | 1046 | 82 |
359267 | 359267 | 2020-07-22 | Bedford | Pennsylvania | 42009 | 109 | 4 |
359268 | 359268 | 2020-07-22 | Berks | Pennsylvania | 42011 | 4889 | 362 |
359269 | 359269 | 2020-07-22 | Blair | Pennsylvania | 42013 | 159 | 1 |
359270 | 359270 | 2020-07-22 | Bradford | Pennsylvania | 42015 | 69 | 3 |
359271 | 359271 | 2020-07-22 | Bucks | Pennsylvania | 42017 | 6513 | 573 |
359272 | 359272 | 2020-07-22 | Butler | Pennsylvania | 42019 | 513 | 14 |
359273 | 359273 | 2020-07-22 | Cambria | Pennsylvania | 42021 | 182 | 3 |
359274 | 359274 | 2020-07-22 | Cameron | Pennsylvania | 42023 | 5 | 0 |
359275 | 359275 | 2020-07-22 | Carbon | Pennsylvania | 42025 | 335 | 28 |
359276 | 359276 | 2020-07-22 | Centre | Pennsylvania | 42027 | 299 | 9 |
359277 | 359277 | 2020-07-22 | Chester | Pennsylvania | 42029 | 4459 | 342 |
359278 | 359278 | 2020-07-22 | Clarion | Pennsylvania | 42031 | 70 | 2 |
359279 | 359279 | 2020-07-22 | Clearfield | Pennsylvania | 42033 | 105 | 0 |
359280 | 359280 | 2020-07-22 | Clinton | Pennsylvania | 42035 | 105 | 5 |
359281 | 359281 | 2020-07-22 | Columbia | Pennsylvania | 42037 | 438 | 35 |
359282 | 359282 | 2020-07-22 | Crawford | Pennsylvania | 42039 | 114 | 1 |
359283 | 359283 | 2020-07-22 | Cumberland | Pennsylvania | 42041 | 1058 | 69 |
359284 | 359284 | 2020-07-22 | Dauphin | Pennsylvania | 42043 | 2466 | 152 |
359285 | 359285 | 2020-07-22 | Delaware | Pennsylvania | 42045 | 8047 | 720 |
359286 | 359286 | 2020-07-22 | Elk | Pennsylvania | 42047 | 38 | 2 |
359287 | 359287 | 2020-07-22 | Erie | Pennsylvania | 42049 | 813 | 13 |
359288 | 359288 | 2020-07-22 | Fayette | Pennsylvania | 42051 | 288 | 4 |
359289 | 359289 | 2020-07-22 | Forest | Pennsylvania | 42053 | 7 | 0 |
359290 | 359290 | 2020-07-22 | Franklin | Pennsylvania | 42055 | 1109 | 46 |
359291 | 359291 | 2020-07-22 | Fulton | Pennsylvania | 42057 | 19 | 1 |
359292 | 359292 | 2020-07-22 | Greene | Pennsylvania | 42059 | 91 | 0 |
359293 | 359293 | 2020-07-22 | Huntingdon | Pennsylvania | 42061 | 272 | 4 |
359294 | 359294 | 2020-07-22 | Indiana | Pennsylvania | 42063 | 185 | 6 |
359295 | 359295 | 2020-07-22 | Jefferson | Pennsylvania | 42065 | 48 | 1 |
359296 | 359296 | 2020-07-22 | Juniata | Pennsylvania | 42067 | 120 | 6 |
359297 | 359297 | 2020-07-22 | Lackawanna | Pennsylvania | 42069 | 1823 | 212 |
359298 | 359298 | 2020-07-22 | Lancaster | Pennsylvania | 42071 | 5158 | 393 |
359299 | 359299 | 2020-07-22 | Lawrence | Pennsylvania | 42073 | 257 | 9 |
359300 | 359300 | 2020-07-22 | Lebanon | Pennsylvania | 42075 | 1518 | 52 |
359301 | 359301 | 2020-07-22 | Lehigh | Pennsylvania | 42077 | 4600 | 334 |
359302 | 359302 | 2020-07-22 | Luzerne | Pennsylvania | 42079 | 3085 | 183 |
359303 | 359303 | 2020-07-22 | Lycoming | Pennsylvania | 42081 | 279 | 20 |
359304 | 359304 | 2020-07-22 | McKean | Pennsylvania | 42083 | 26 | 1 |
359305 | 359305 | 2020-07-22 | Mercer | Pennsylvania | 42085 | 276 | 9 |
359306 | 359306 | 2020-07-22 | Mifflin | Pennsylvania | 42087 | 82 | 1 |
359307 | 359307 | 2020-07-22 | Monroe | Pennsylvania | 42089 | 1534 | 120 |
359308 | 359308 | 2020-07-22 | Montgomery | Pennsylvania | 42091 | 9282 | 839 |
359309 | 359309 | 2020-07-22 | Montour | Pennsylvania | 42093 | 86 | 3 |
359310 | 359310 | 2020-07-22 | Northampton | Pennsylvania | 42095 | 3669 | 288 |
359311 | 359311 | 2020-07-22 | Northumberland | Pennsylvania | 42097 | 366 | 11 |
359312 | 359312 | 2020-07-22 | Perry | Pennsylvania | 42099 | 98 | 5 |
359313 | 359313 | 2020-07-22 | Philadelphia | Pennsylvania | 42101 | 28874 | 1673 |
359314 | 359314 | 2020-07-22 | Pike | Pennsylvania | 42103 | 517 | 21 |
359315 | 359315 | 2020-07-22 | Potter | Pennsylvania | 42105 | 20 | 0 |
359316 | 359316 | 2020-07-22 | Schuylkill | Pennsylvania | 42107 | 828 | 49 |
359317 | 359317 | 2020-07-22 | Snyder | Pennsylvania | 42109 | 85 | 2 |
359318 | 359318 | 2020-07-22 | Somerset | Pennsylvania | 42111 | 100 | 1 |
359319 | 359319 | 2020-07-22 | Sullivan | Pennsylvania | 42113 | 10 | 0 |
359320 | 359320 | 2020-07-22 | Susquehanna | Pennsylvania | 42115 | 202 | 26 |
359321 | 359321 | 2020-07-22 | Tioga | Pennsylvania | 42117 | 33 | 2 |
359322 | 359322 | 2020-07-22 | Union | Pennsylvania | 42119 | 113 | 2 |
359323 | 359323 | 2020-07-22 | Venango | Pennsylvania | 42121 | 53 | 0 |
359324 | 359324 | 2020-07-22 | Warren | Pennsylvania | 42123 | 14 | 1 |
359325 | 359325 | 2020-07-22 | Washington | Pennsylvania | 42125 | 603 | 10 |
359326 | 359326 | 2020-07-22 | Wayne | Pennsylvania | 42127 | 148 | 8 |
359327 | 359327 | 2020-07-22 | Westmoreland | Pennsylvania | 42129 | 1214 | 41 |
359328 | 359328 | 2020-07-22 | Wyoming | Pennsylvania | 42131 | 53 | 7 |
359329 | 359329 | 2020-07-22 | York | Pennsylvania | 42133 | 2067 | 76 |
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);