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-05-12 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 |
---|---|---|---|---|---|---|---|
138301 | 138301 | 2020-05-12 | Adams | Pennsylvania | 42001 | 167 | 5 |
138302 | 138302 | 2020-05-12 | Allegheny | Pennsylvania | 42003 | 1526 | 127 |
138303 | 138303 | 2020-05-12 | Armstrong | Pennsylvania | 42005 | 55 | 5 |
138304 | 138304 | 2020-05-12 | Beaver | Pennsylvania | 42007 | 493 | 78 |
138305 | 138305 | 2020-05-12 | Bedford | Pennsylvania | 42009 | 29 | 1 |
138306 | 138306 | 2020-05-12 | Berks | Pennsylvania | 42011 | 3453 | 172 |
138307 | 138307 | 2020-05-12 | Blair | Pennsylvania | 42013 | 30 | 0 |
138308 | 138308 | 2020-05-12 | Bradford | Pennsylvania | 42015 | 37 | 5 |
138309 | 138309 | 2020-05-12 | Bucks | Pennsylvania | 42017 | 4116 | 364 |
138310 | 138310 | 2020-05-12 | Butler | Pennsylvania | 42019 | 198 | 6 |
138311 | 138311 | 2020-05-12 | Cambria | Pennsylvania | 42021 | 44 | 2 |
138312 | 138312 | 2020-05-12 | Cameron | Pennsylvania | 42023 | 2 | 0 |
138313 | 138313 | 2020-05-12 | Carbon | Pennsylvania | 42025 | 198 | 17 |
138314 | 138314 | 2020-05-12 | Centre | Pennsylvania | 42027 | 122 | 2 |
138315 | 138315 | 2020-05-12 | Chester | Pennsylvania | 42029 | 1973 | 189 |
138316 | 138316 | 2020-05-12 | Clarion | Pennsylvania | 42031 | 23 | 1 |
138317 | 138317 | 2020-05-12 | Clearfield | Pennsylvania | 42033 | 30 | 0 |
138318 | 138318 | 2020-05-12 | Clinton | Pennsylvania | 42035 | 41 | 0 |
138319 | 138319 | 2020-05-12 | Columbia | Pennsylvania | 42037 | 330 | 28 |
138320 | 138320 | 2020-05-12 | Crawford | Pennsylvania | 42039 | 21 | 0 |
138321 | 138321 | 2020-05-12 | Cumberland | Pennsylvania | 42041 | 461 | 33 |
138322 | 138322 | 2020-05-12 | Dauphin | Pennsylvania | 42043 | 851 | 38 |
138323 | 138323 | 2020-05-12 | Delaware | Pennsylvania | 42045 | 5136 | 405 |
138324 | 138324 | 2020-05-12 | Elk | Pennsylvania | 42047 | 5 | 1 |
138325 | 138325 | 2020-05-12 | Erie | Pennsylvania | 42049 | 124 | 2 |
138326 | 138326 | 2020-05-12 | Fayette | Pennsylvania | 42051 | 85 | 4 |
138327 | 138327 | 2020-05-12 | Forest | Pennsylvania | 42053 | 7 | 0 |
138328 | 138328 | 2020-05-12 | Franklin | Pennsylvania | 42055 | 522 | 12 |
138329 | 138329 | 2020-05-12 | Fulton | Pennsylvania | 42057 | 8 | 0 |
138330 | 138330 | 2020-05-12 | Greene | Pennsylvania | 42059 | 27 | 1 |
138331 | 138331 | 2020-05-12 | Huntingdon | Pennsylvania | 42061 | 190 | 0 |
138332 | 138332 | 2020-05-12 | Indiana | Pennsylvania | 42063 | 76 | 5 |
138333 | 138333 | 2020-05-12 | Jefferson | Pennsylvania | 42065 | 7 | 0 |
138334 | 138334 | 2020-05-12 | Juniata | Pennsylvania | 42067 | 94 | 1 |
138335 | 138335 | 2020-05-12 | Lackawanna | Pennsylvania | 42069 | 1211 | 124 |
138336 | 138336 | 2020-05-12 | Lancaster | Pennsylvania | 42071 | 2295 | 241 |
138337 | 138337 | 2020-05-12 | Lawrence | Pennsylvania | 42073 | 71 | 7 |
138338 | 138338 | 2020-05-12 | Lebanon | Pennsylvania | 42075 | 825 | 17 |
138339 | 138339 | 2020-05-12 | Lehigh | Pennsylvania | 42077 | 3286 | 123 |
138340 | 138340 | 2020-05-12 | Luzerne | Pennsylvania | 42079 | 2449 | 120 |
138341 | 138341 | 2020-05-12 | Lycoming | Pennsylvania | 42081 | 132 | 5 |
138342 | 138342 | 2020-05-12 | McKean | Pennsylvania | 42083 | 8 | 1 |
138343 | 138343 | 2020-05-12 | Mercer | Pennsylvania | 42085 | 77 | 2 |
138344 | 138344 | 2020-05-12 | Mifflin | Pennsylvania | 42087 | 52 | 0 |
138345 | 138345 | 2020-05-12 | Monroe | Pennsylvania | 42089 | 1229 | 64 |
138346 | 138346 | 2020-05-12 | Montgomery | Pennsylvania | 42091 | 5442 | 534 |
138347 | 138347 | 2020-05-12 | Montour | Pennsylvania | 42093 | 49 | 0 |
138348 | 138348 | 2020-05-12 | Northampton | Pennsylvania | 42095 | 2499 | 161 |
138349 | 138349 | 2020-05-12 | Northumberland | Pennsylvania | 42097 | 126 | 0 |
138350 | 138350 | 2020-05-12 | Perry | Pennsylvania | 42099 | 35 | 1 |
138351 | 138351 | 2020-05-12 | Philadelphia | Pennsylvania | 42101 | 18537 | 908 |
138352 | 138352 | 2020-05-12 | Pike | Pennsylvania | 42103 | 441 | 21 |
138353 | 138353 | 2020-05-12 | Potter | Pennsylvania | 42105 | 4 | 0 |
138354 | 138354 | 2020-05-12 | Schuylkill | Pennsylvania | 42107 | 459 | 14 |
138355 | 138355 | 2020-05-12 | Snyder | Pennsylvania | 42109 | 33 | 1 |
138356 | 138356 | 2020-05-12 | Somerset | Pennsylvania | 42111 | 32 | 1 |
138357 | 138357 | 2020-05-12 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
138358 | 138358 | 2020-05-12 | Susquehanna | Pennsylvania | 42115 | 82 | 13 |
138359 | 138359 | 2020-05-12 | Tioga | Pennsylvania | 42117 | 16 | 2 |
138360 | 138360 | 2020-05-12 | Union | Pennsylvania | 42119 | 41 | 1 |
138361 | 138361 | 2020-05-12 | Venango | Pennsylvania | 42121 | 7 | 0 |
138362 | 138362 | 2020-05-12 | Warren | Pennsylvania | 42123 | 1 | 1 |
138363 | 138363 | 2020-05-12 | Washington | Pennsylvania | 42125 | 126 | 4 |
138364 | 138364 | 2020-05-12 | Wayne | Pennsylvania | 42127 | 117 | 5 |
138365 | 138365 | 2020-05-12 | Westmoreland | Pennsylvania | 42129 | 419 | 32 |
138366 | 138366 | 2020-05-12 | Wyoming | Pennsylvania | 42131 | 31 | 3 |
138367 | 138367 | 2020-05-12 | York | Pennsylvania | 42133 | 793 | 14 |
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);