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-05-16 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 67
- 42001 1
- 42003 1
- 42005 1
- 42007 1
- 42009 1
- 42011 1
- 42013 1
- 42015 1
- 42017 1
- 42019 1
- 42021 1
- 42023 1
- 42025 1
- 42027 1
- 42029 1
- 42031 1
- 42033 1
- 42035 1
- 42037 1
- 42039 1
- 42041 1
- 42043 1
- 42045 1
- 42047 1
- 42049 1
- 42051 1
- 42053 1
- 42055 1
- 42057 1
- 42059 1
- 42061 1
- 42063 1
- 42065 1
- 42067 1
- 42069 1
- 42071 1
- 42073 1
- 42075 1
- 42077 1
- 42079 1
- 42081 1
- 42083 1
- 42085 1
- 42087 1
- 42089 1
- 42091 1
- 42093 1
- 42095 1
- 42097 1
- 42099 1
- 42101 1
- 42103 1
- 42105 1
- 42107 1
- 42109 1
- 42111 1
- 42113 1
- 42115 1
- 42117 1
- 42119 1
- 42121 1
- 42123 1
- 42125 1
- 42127 1
- 42129 1
- 42131 1
- 42133 1
county 67
- Adams 1
- Allegheny 1
- Armstrong 1
- Beaver 1
- Bedford 1
- Berks 1
- Blair 1
- Bradford 1
- Bucks 1
- Butler 1
- Cambria 1
- Cameron 1
- Carbon 1
- Centre 1
- Chester 1
- Clarion 1
- Clearfield 1
- Clinton 1
- Columbia 1
- Crawford 1
- Cumberland 1
- Dauphin 1
- Delaware 1
- Elk 1
- Erie 1
- Fayette 1
- Forest 1
- Franklin 1
- Fulton 1
- Greene 1
- Huntingdon 1
- Indiana 1
- Jefferson 1
- Juniata 1
- Lackawanna 1
- Lancaster 1
- Lawrence 1
- Lebanon 1
- Lehigh 1
- Luzerne 1
- Lycoming 1
- McKean 1
- Mercer 1
- Mifflin 1
- Monroe 1
- Montgomery 1
- Montour 1
- Northampton 1
- Northumberland 1
- Perry 1
- Philadelphia 1
- Pike 1
- Potter 1
- Schuylkill 1
- Snyder 1
- Somerset 1
- Sullivan 1
- Susquehanna 1
- Tioga 1
- Union 1
- Venango 1
- Warren 1
- Washington 1
- Wayne 1
- Westmoreland 1
- Wyoming 1
- York 1
state 1
- Pennsylvania · 67 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1325257 | 1325257 | 2021-05-16 | Adams | Pennsylvania | 42001 | 9422 | 181 |
1325258 | 1325258 | 2021-05-16 | Allegheny | Pennsylvania | 42003 | 100130 | 1944 |
1325259 | 1325259 | 2021-05-16 | Armstrong | Pennsylvania | 42005 | 5908 | 137 |
1325260 | 1325260 | 2021-05-16 | Beaver | Pennsylvania | 42007 | 15204 | 380 |
1325261 | 1325261 | 2021-05-16 | Bedford | Pennsylvania | 42009 | 4514 | 137 |
1325262 | 1325262 | 2021-05-16 | Berks | Pennsylvania | 42011 | 47277 | 1016 |
1325263 | 1325263 | 2021-05-16 | Blair | Pennsylvania | 42013 | 13114 | 332 |
1325264 | 1325264 | 2021-05-16 | Bradford | Pennsylvania | 42015 | 5928 | 89 |
1325265 | 1325265 | 2021-05-16 | Bucks | Pennsylvania | 42017 | 60053 | 1281 |
1325266 | 1325266 | 2021-05-16 | Butler | Pennsylvania | 42019 | 17214 | 412 |
1325267 | 1325267 | 2021-05-16 | Cambria | Pennsylvania | 42021 | 14296 | 428 |
1325268 | 1325268 | 2021-05-16 | Cameron | Pennsylvania | 42023 | 300 | 6 |
1325269 | 1325269 | 2021-05-16 | Carbon | Pennsylvania | 42025 | 6253 | 169 |
1325270 | 1325270 | 2021-05-16 | Centre | Pennsylvania | 42027 | 16687 | 222 |
1325271 | 1325271 | 2021-05-16 | Chester | Pennsylvania | 42029 | 40219 | 800 |
1325272 | 1325272 | 2021-05-16 | Clarion | Pennsylvania | 42031 | 3147 | 92 |
1325273 | 1325273 | 2021-05-16 | Clearfield | Pennsylvania | 42033 | 8459 | 143 |
1325274 | 1325274 | 2021-05-16 | Clinton | Pennsylvania | 42035 | 3635 | 64 |
1325275 | 1325275 | 2021-05-16 | Columbia | Pennsylvania | 42037 | 5745 | 133 |
1325276 | 1325276 | 2021-05-16 | Crawford | Pennsylvania | 42039 | 7268 | 149 |
1325277 | 1325277 | 2021-05-16 | Cumberland | Pennsylvania | 42041 | 20165 | 519 |
1325278 | 1325278 | 2021-05-16 | Dauphin | Pennsylvania | 42043 | 25586 | 546 |
1325279 | 1325279 | 2021-05-16 | Delaware | Pennsylvania | 42045 | 51650 | 1424 |
1325280 | 1325280 | 2021-05-16 | Elk | Pennsylvania | 42047 | 2847 | 39 |
1325281 | 1325281 | 2021-05-16 | Erie | Pennsylvania | 42049 | 20711 | 408 |
1325282 | 1325282 | 2021-05-16 | Fayette | Pennsylvania | 42051 | 12903 | 312 |
1325283 | 1325283 | 2021-05-16 | Forest | Pennsylvania | 42053 | 1424 | 21 |
1325284 | 1325284 | 2021-05-16 | Franklin | Pennsylvania | 42055 | 15066 | 367 |
1325285 | 1325285 | 2021-05-16 | Fulton | Pennsylvania | 42057 | 1325 | 15 |
1325286 | 1325286 | 2021-05-16 | Greene | Pennsylvania | 42059 | 3223 | 39 |
1325287 | 1325287 | 2021-05-16 | Huntingdon | Pennsylvania | 42061 | 5054 | 130 |
1325288 | 1325288 | 2021-05-16 | Indiana | Pennsylvania | 42063 | 6190 | 173 |
1325289 | 1325289 | 2021-05-16 | Jefferson | Pennsylvania | 42065 | 3277 | 98 |
1325290 | 1325290 | 2021-05-16 | Juniata | Pennsylvania | 42067 | 2102 | 86 |
1325291 | 1325291 | 2021-05-16 | Lackawanna | Pennsylvania | 42069 | 18188 | 470 |
1325292 | 1325292 | 2021-05-16 | Lancaster | Pennsylvania | 42071 | 54577 | 1133 |
1325293 | 1325293 | 2021-05-16 | Lawrence | Pennsylvania | 42073 | 7453 | 207 |
1325294 | 1325294 | 2021-05-16 | Lebanon | Pennsylvania | 42075 | 15877 | 285 |
1325295 | 1325295 | 2021-05-16 | Lehigh | Pennsylvania | 42077 | 39139 | 850 |
1325296 | 1325296 | 2021-05-16 | Luzerne | Pennsylvania | 42079 | 31307 | 803 |
1325297 | 1325297 | 2021-05-16 | Lycoming | Pennsylvania | 42081 | 11682 | 282 |
1325298 | 1325298 | 2021-05-16 | McKean | Pennsylvania | 42083 | 3699 | 69 |
1325299 | 1325299 | 2021-05-16 | Mercer | Pennsylvania | 42085 | 9438 | 256 |
1325300 | 1325300 | 2021-05-16 | Mifflin | Pennsylvania | 42087 | 5324 | 178 |
1325301 | 1325301 | 2021-05-16 | Monroe | Pennsylvania | 42089 | 14511 | 310 |
1325302 | 1325302 | 2021-05-16 | Montgomery | Pennsylvania | 42091 | 69499 | 1693 |
1325303 | 1325303 | 2021-05-16 | Montour | Pennsylvania | 42093 | 1990 | 66 |
1325304 | 1325304 | 2021-05-16 | Northampton | Pennsylvania | 42095 | 35342 | 704 |
1325305 | 1325305 | 2021-05-16 | Northumberland | Pennsylvania | 42097 | 9467 | 352 |
1325306 | 1325306 | 2021-05-16 | Perry | Pennsylvania | 42099 | 3765 | 100 |
1325307 | 1325307 | 2021-05-16 | Philadelphia | Pennsylvania | 42101 | 150796 | 3597 |
1325308 | 1325308 | 2021-05-16 | Pike | Pennsylvania | 42103 | 3915 | 54 |
1325309 | 1325309 | 2021-05-16 | Potter | Pennsylvania | 42105 | 1140 | 23 |
1325310 | 1325310 | 2021-05-16 | Schuylkill | Pennsylvania | 42107 | 14538 | 400 |
1325311 | 1325311 | 2021-05-16 | Snyder | Pennsylvania | 42109 | 3619 | 84 |
1325312 | 1325312 | 2021-05-16 | Somerset | Pennsylvania | 42111 | 7809 | 207 |
1325313 | 1325313 | 2021-05-16 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1325314 | 1325314 | 2021-05-16 | Susquehanna | Pennsylvania | 42115 | 2570 | 62 |
1325315 | 1325315 | 2021-05-16 | Tioga | Pennsylvania | 42117 | 2962 | 106 |
1325316 | 1325316 | 2021-05-16 | Union | Pennsylvania | 42119 | 6057 | 86 |
1325317 | 1325317 | 2021-05-16 | Venango | Pennsylvania | 42121 | 3948 | 93 |
1325318 | 1325318 | 2021-05-16 | Warren | Pennsylvania | 42123 | 2588 | 102 |
1325319 | 1325319 | 2021-05-16 | Washington | Pennsylvania | 42125 | 17471 | 297 |
1325320 | 1325320 | 2021-05-16 | Wayne | Pennsylvania | 42127 | 4027 | 80 |
1325321 | 1325321 | 2021-05-16 | Westmoreland | Pennsylvania | 42129 | 33645 | 756 |
1325322 | 1325322 | 2021-05-16 | Wyoming | Pennsylvania | 42131 | 1899 | 51 |
1325323 | 1325323 | 2021-05-16 | York | Pennsylvania | 42133 | 45610 | 801 |
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);