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-01-06 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
903228 | 903228 | 2021-01-06 | Adams | Pennsylvania | 42001 | 4973 | 101 |
903229 | 903229 | 2021-01-06 | Allegheny | Pennsylvania | 42003 | 57708 | 1099 |
903230 | 903230 | 2021-01-06 | Armstrong | Pennsylvania | 42005 | 3738 | 75 |
903231 | 903231 | 2021-01-06 | Beaver | Pennsylvania | 42007 | 9069 | 266 |
903232 | 903232 | 2021-01-06 | Bedford | Pennsylvania | 42009 | 3095 | 98 |
903233 | 903233 | 2021-01-06 | Berks | Pennsylvania | 42011 | 25180 | 595 |
903234 | 903234 | 2021-01-06 | Blair | Pennsylvania | 42013 | 8419 | 183 |
903235 | 903235 | 2021-01-06 | Bradford | Pennsylvania | 42015 | 3256 | 58 |
903236 | 903236 | 2021-01-06 | Bucks | Pennsylvania | 42017 | 32484 | 919 |
903237 | 903237 | 2021-01-06 | Butler | Pennsylvania | 42019 | 10212 | 216 |
903238 | 903238 | 2021-01-06 | Cambria | Pennsylvania | 42021 | 9214 | 266 |
903239 | 903239 | 2021-01-06 | Cameron | Pennsylvania | 42023 | 173 | 4 |
903240 | 903240 | 2021-01-06 | Carbon | Pennsylvania | 42025 | 3085 | 94 |
903241 | 903241 | 2021-01-06 | Centre | Pennsylvania | 42027 | 9348 | 147 |
903242 | 903242 | 2021-01-06 | Chester | Pennsylvania | 42029 | 21796 | 544 |
903243 | 903243 | 2021-01-06 | Clarion | Pennsylvania | 42031 | 2155 | 50 |
903244 | 903244 | 2021-01-06 | Clearfield | Pennsylvania | 42033 | 4471 | 54 |
903245 | 903245 | 2021-01-06 | Clinton | Pennsylvania | 42035 | 2085 | 29 |
903246 | 903246 | 2021-01-06 | Columbia | Pennsylvania | 42037 | 3016 | 81 |
903247 | 903247 | 2021-01-06 | Crawford | Pennsylvania | 42039 | 5118 | 92 |
903248 | 903248 | 2021-01-06 | Cumberland | Pennsylvania | 42041 | 11087 | 323 |
903249 | 903249 | 2021-01-06 | Dauphin | Pennsylvania | 42043 | 14693 | 335 |
903250 | 903250 | 2021-01-06 | Delaware | Pennsylvania | 42045 | 31063 | 1016 |
903251 | 903251 | 2021-01-06 | Elk | Pennsylvania | 42047 | 1590 | 21 |
903252 | 903252 | 2021-01-06 | Erie | Pennsylvania | 42049 | 12431 | 240 |
903253 | 903253 | 2021-01-06 | Fayette | Pennsylvania | 42051 | 7993 | 130 |
903254 | 903254 | 2021-01-06 | Forest | Pennsylvania | 42053 | 351 | 4 |
903255 | 903255 | 2021-01-06 | Franklin | Pennsylvania | 42055 | 9404 | 250 |
903256 | 903256 | 2021-01-06 | Fulton | Pennsylvania | 42057 | 799 | 11 |
903257 | 903257 | 2021-01-06 | Greene | Pennsylvania | 42059 | 1858 | 19 |
903258 | 903258 | 2021-01-06 | Huntingdon | Pennsylvania | 42061 | 3255 | 89 |
903259 | 903259 | 2021-01-06 | Indiana | Pennsylvania | 42063 | 4203 | 130 |
903260 | 903260 | 2021-01-06 | Jefferson | Pennsylvania | 42065 | 2031 | 50 |
903261 | 903261 | 2021-01-06 | Juniata | Pennsylvania | 42067 | 1444 | 55 |
903262 | 903262 | 2021-01-06 | Lackawanna | Pennsylvania | 42069 | 9597 | 274 |
903263 | 903263 | 2021-01-06 | Lancaster | Pennsylvania | 42071 | 29935 | 759 |
903264 | 903264 | 2021-01-06 | Lawrence | Pennsylvania | 42073 | 4526 | 134 |
903265 | 903265 | 2021-01-06 | Lebanon | Pennsylvania | 42075 | 9504 | 163 |
903266 | 903266 | 2021-01-06 | Lehigh | Pennsylvania | 42077 | 22015 | 528 |
903267 | 903267 | 2021-01-06 | Luzerne | Pennsylvania | 42079 | 18378 | 484 |
903268 | 903268 | 2021-01-06 | Lycoming | Pennsylvania | 42081 | 6474 | 131 |
903269 | 903269 | 2021-01-06 | McKean | Pennsylvania | 42083 | 1904 | 25 |
903270 | 903270 | 2021-01-06 | Mercer | Pennsylvania | 42085 | 6323 | 152 |
903271 | 903271 | 2021-01-06 | Mifflin | Pennsylvania | 42087 | 3625 | 123 |
903272 | 903272 | 2021-01-06 | Monroe | Pennsylvania | 42089 | 6605 | 209 |
903273 | 903273 | 2021-01-06 | Montgomery | Pennsylvania | 42091 | 38549 | 1190 |
903274 | 903274 | 2021-01-06 | Montour | Pennsylvania | 42093 | 1212 | 28 |
903275 | 903275 | 2021-01-06 | Northampton | Pennsylvania | 42095 | 18017 | 460 |
903276 | 903276 | 2021-01-06 | Northumberland | Pennsylvania | 42097 | 5387 | 243 |
903277 | 903277 | 2021-01-06 | Perry | Pennsylvania | 42099 | 1860 | 44 |
903278 | 903278 | 2021-01-06 | Philadelphia | Pennsylvania | 42101 | 97099 | 2553 |
903279 | 903279 | 2021-01-06 | Pike | Pennsylvania | 42103 | 1576 | 34 |
903280 | 903280 | 2021-01-06 | Potter | Pennsylvania | 42105 | 659 | 15 |
903281 | 903281 | 2021-01-06 | Schuylkill | Pennsylvania | 42107 | 8808 | 258 |
903282 | 903282 | 2021-01-06 | Snyder | Pennsylvania | 42109 | 2033 | 47 |
903283 | 903283 | 2021-01-06 | Somerset | Pennsylvania | 42111 | 5208 | 95 |
903284 | 903284 | 2021-01-06 | Sullivan | Pennsylvania | 42113 | 170 | 3 |
903285 | 903285 | 2021-01-06 | Susquehanna | Pennsylvania | 42115 | 1109 | 39 |
903286 | 903286 | 2021-01-06 | Tioga | Pennsylvania | 42117 | 2016 | 69 |
903287 | 903287 | 2021-01-06 | Union | Pennsylvania | 42119 | 3102 | 47 |
903288 | 903288 | 2021-01-06 | Venango | Pennsylvania | 42121 | 2576 | 53 |
903289 | 903289 | 2021-01-06 | Warren | Pennsylvania | 42123 | 1661 | 45 |
903290 | 903290 | 2021-01-06 | Washington | Pennsylvania | 42125 | 9774 | 144 |
903291 | 903291 | 2021-01-06 | Wayne | Pennsylvania | 42127 | 2046 | 19 |
903292 | 903292 | 2021-01-06 | Westmoreland | Pennsylvania | 42129 | 20724 | 459 |
903293 | 903293 | 2021-01-06 | Wyoming | Pennsylvania | 42131 | 853 | 32 |
903294 | 903294 | 2021-01-06 | York | Pennsylvania | 42133 | 25040 | 457 |
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);