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 2021-02-16 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1036293 | 1036293 | 2021-02-16 | Adams | Pennsylvania | 42001 | 7002 | 147 |
1036294 | 1036294 | 2021-02-16 | Allegheny | Pennsylvania | 42003 | 73598 | 1647 |
1036295 | 1036295 | 2021-02-16 | Armstrong | Pennsylvania | 42005 | 4807 | 115 |
1036296 | 1036296 | 2021-02-16 | Beaver | Pennsylvania | 42007 | 11719 | 340 |
1036297 | 1036297 | 2021-02-16 | Bedford | Pennsylvania | 42009 | 3751 | 127 |
1036298 | 1036298 | 2021-02-16 | Berks | Pennsylvania | 42011 | 34506 | 868 |
1036299 | 1036299 | 2021-02-16 | Blair | Pennsylvania | 42013 | 10417 | 287 |
1036300 | 1036300 | 2021-02-16 | Bradford | Pennsylvania | 42015 | 4178 | 73 |
1036301 | 1036301 | 2021-02-16 | Bucks | Pennsylvania | 42017 | 43224 | 1085 |
1036302 | 1036302 | 2021-02-16 | Butler | Pennsylvania | 42019 | 13489 | 354 |
1036303 | 1036303 | 2021-02-16 | Cambria | Pennsylvania | 42021 | 11357 | 384 |
1036304 | 1036304 | 2021-02-16 | Cameron | Pennsylvania | 42023 | 252 | 7 |
1036305 | 1036305 | 2021-02-16 | Carbon | Pennsylvania | 42025 | 4713 | 140 |
1036306 | 1036306 | 2021-02-16 | Centre | Pennsylvania | 42027 | 12321 | 206 |
1036307 | 1036307 | 2021-02-16 | Chester | Pennsylvania | 42029 | 29416 | 698 |
1036308 | 1036308 | 2021-02-16 | Clarion | Pennsylvania | 42031 | 2595 | 79 |
1036309 | 1036309 | 2021-02-16 | Clearfield | Pennsylvania | 42033 | 6038 | 111 |
1036310 | 1036310 | 2021-02-16 | Clinton | Pennsylvania | 42035 | 2646 | 54 |
1036311 | 1036311 | 2021-02-16 | Columbia | Pennsylvania | 42037 | 4486 | 122 |
1036312 | 1036312 | 2021-02-16 | Crawford | Pennsylvania | 42039 | 6208 | 135 |
1036313 | 1036313 | 2021-02-16 | Cumberland | Pennsylvania | 42041 | 15521 | 465 |
1036314 | 1036314 | 2021-02-16 | Dauphin | Pennsylvania | 42043 | 19863 | 474 |
1036315 | 1036315 | 2021-02-16 | Delaware | Pennsylvania | 42045 | 39479 | 1238 |
1036316 | 1036316 | 2021-02-16 | Elk | Pennsylvania | 42047 | 2267 | 35 |
1036317 | 1036317 | 2021-02-16 | Erie | Pennsylvania | 42049 | 16650 | 364 |
1036318 | 1036318 | 2021-02-16 | Fayette | Pennsylvania | 42051 | 10156 | 251 |
1036319 | 1036319 | 2021-02-16 | Forest | Pennsylvania | 42053 | 1367 | 19 |
1036320 | 1036320 | 2021-02-16 | Franklin | Pennsylvania | 42055 | 12182 | 314 |
1036321 | 1036321 | 2021-02-16 | Fulton | Pennsylvania | 42057 | 1109 | 14 |
1036322 | 1036322 | 2021-02-16 | Greene | Pennsylvania | 42059 | 2579 | 30 |
1036323 | 1036323 | 2021-02-16 | Huntingdon | Pennsylvania | 42061 | 4080 | 118 |
1036324 | 1036324 | 2021-02-16 | Indiana | Pennsylvania | 42063 | 4972 | 154 |
1036325 | 1036325 | 2021-02-16 | Jefferson | Pennsylvania | 42065 | 2711 | 83 |
1036326 | 1036326 | 2021-02-16 | Juniata | Pennsylvania | 42067 | 1773 | 80 |
1036327 | 1036327 | 2021-02-16 | Lackawanna | Pennsylvania | 42069 | 13314 | 399 |
1036328 | 1036328 | 2021-02-16 | Lancaster | Pennsylvania | 42071 | 41955 | 980 |
1036329 | 1036329 | 2021-02-16 | Lawrence | Pennsylvania | 42073 | 5831 | 177 |
1036330 | 1036330 | 2021-02-16 | Lebanon | Pennsylvania | 42075 | 12493 | 252 |
1036331 | 1036331 | 2021-02-16 | Lehigh | Pennsylvania | 42077 | 29773 | 733 |
1036332 | 1036332 | 2021-02-16 | Luzerne | Pennsylvania | 42079 | 24185 | 698 |
1036333 | 1036333 | 2021-02-16 | Lycoming | Pennsylvania | 42081 | 8883 | 234 |
1036334 | 1036334 | 2021-02-16 | McKean | Pennsylvania | 42083 | 2972 | 60 |
1036335 | 1036335 | 2021-02-16 | Mercer | Pennsylvania | 42085 | 7853 | 236 |
1036336 | 1036336 | 2021-02-16 | Mifflin | Pennsylvania | 42087 | 4493 | 165 |
1036337 | 1036337 | 2021-02-16 | Monroe | Pennsylvania | 42089 | 9238 | 256 |
1036338 | 1036338 | 2021-02-16 | Montgomery | Pennsylvania | 42091 | 51803 | 1480 |
1036339 | 1036339 | 2021-02-16 | Montour | Pennsylvania | 42093 | 1731 | 56 |
1036340 | 1036340 | 2021-02-16 | Northampton | Pennsylvania | 42095 | 25546 | 611 |
1036341 | 1036341 | 2021-02-16 | Northumberland | Pennsylvania | 42097 | 7701 | 312 |
1036342 | 1036342 | 2021-02-16 | Perry | Pennsylvania | 42099 | 2790 | 80 |
1036343 | 1036343 | 2021-02-16 | Philadelphia | Pennsylvania | 42101 | 115018 | 3029 |
1036344 | 1036344 | 2021-02-16 | Pike | Pennsylvania | 42103 | 2372 | 46 |
1036345 | 1036345 | 2021-02-16 | Potter | Pennsylvania | 42105 | 889 | 20 |
1036346 | 1036346 | 2021-02-16 | Schuylkill | Pennsylvania | 42107 | 11745 | 356 |
1036347 | 1036347 | 2021-02-16 | Snyder | Pennsylvania | 42109 | 2913 | 76 |
1036348 | 1036348 | 2021-02-16 | Somerset | Pennsylvania | 42111 | 6561 | 187 |
1036349 | 1036349 | 2021-02-16 | Sullivan | Pennsylvania | 42113 | 305 | 14 |
1036350 | 1036350 | 2021-02-16 | Susquehanna | Pennsylvania | 42115 | 1645 | 53 |
1036351 | 1036351 | 2021-02-16 | Tioga | Pennsylvania | 42117 | 2381 | 93 |
1036352 | 1036352 | 2021-02-16 | Union | Pennsylvania | 42119 | 5059 | 80 |
1036353 | 1036353 | 2021-02-16 | Venango | Pennsylvania | 42121 | 3255 | 78 |
1036354 | 1036354 | 2021-02-16 | Warren | Pennsylvania | 42123 | 2110 | 95 |
1036355 | 1036355 | 2021-02-16 | Washington | Pennsylvania | 42125 | 13362 | 246 |
1036356 | 1036356 | 2021-02-16 | Wayne | Pennsylvania | 42127 | 2902 | 63 |
1036357 | 1036357 | 2021-02-16 | Westmoreland | Pennsylvania | 42129 | 25993 | 648 |
1036358 | 1036358 | 2021-02-16 | Wyoming | Pennsylvania | 42131 | 1118 | 40 |
1036359 | 1036359 | 2021-02-16 | York | Pennsylvania | 42133 | 34582 | 695 |
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);