ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where date = "2020-03-31" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- 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
- Columbia 1
- Crawford 1
- Cumberland 1
- Dauphin 1
- Delaware 1
- Erie 1
- Fayette 1
- Franklin 1
- Greene 1
- Huntingdon 1
- Indiana 1
- Juniata 1
- Lackawanna 1
- …
state 1
- Pennsylvania · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23288 | 23288 | 2020-03-31 | Adams | Pennsylvania | 42001 | 9 | 0 |
23289 | 23289 | 2020-03-31 | Allegheny | Pennsylvania | 42003 | 325 | 2 |
23290 | 23290 | 2020-03-31 | Armstrong | Pennsylvania | 42005 | 5 | 0 |
23291 | 23291 | 2020-03-31 | Beaver | Pennsylvania | 42007 | 52 | 1 |
23292 | 23292 | 2020-03-31 | Bedford | Pennsylvania | 42009 | 2 | 0 |
23293 | 23293 | 2020-03-31 | Berks | Pennsylvania | 42011 | 110 | 0 |
23294 | 23294 | 2020-03-31 | Blair | Pennsylvania | 42013 | 6 | 0 |
23295 | 23295 | 2020-03-31 | Bradford | Pennsylvania | 42015 | 7 | 0 |
23296 | 23296 | 2020-03-31 | Bucks | Pennsylvania | 42017 | 319 | 6 |
23297 | 23297 | 2020-03-31 | Butler | Pennsylvania | 42019 | 60 | 2 |
23298 | 23298 | 2020-03-31 | Cambria | Pennsylvania | 42021 | 2 | 0 |
23299 | 23299 | 2020-03-31 | Cameron | Pennsylvania | 42023 | 1 | 0 |
23300 | 23300 | 2020-03-31 | Carbon | Pennsylvania | 42025 | 17 | 1 |
23301 | 23301 | 2020-03-31 | Centre | Pennsylvania | 42027 | 26 | 0 |
23302 | 23302 | 2020-03-31 | Chester | Pennsylvania | 42029 | 159 | 1 |
23303 | 23303 | 2020-03-31 | Clarion | Pennsylvania | 42031 | 3 | 0 |
23304 | 23304 | 2020-03-31 | Clearfield | Pennsylvania | 42033 | 4 | 0 |
23305 | 23305 | 2020-03-31 | Columbia | Pennsylvania | 42037 | 7 | 0 |
23306 | 23306 | 2020-03-31 | Crawford | Pennsylvania | 42039 | 4 | 0 |
23307 | 23307 | 2020-03-31 | Cumberland | Pennsylvania | 42041 | 36 | 1 |
23308 | 23308 | 2020-03-31 | Dauphin | Pennsylvania | 42043 | 45 | 1 |
23309 | 23309 | 2020-03-31 | Delaware | Pennsylvania | 42045 | 338 | 6 |
23310 | 23310 | 2020-03-31 | Erie | Pennsylvania | 42049 | 14 | 0 |
23311 | 23311 | 2020-03-31 | Fayette | Pennsylvania | 42051 | 14 | 0 |
23312 | 23312 | 2020-03-31 | Franklin | Pennsylvania | 42055 | 19 | 0 |
23313 | 23313 | 2020-03-31 | Greene | Pennsylvania | 42059 | 9 | 0 |
23314 | 23314 | 2020-03-31 | Huntingdon | Pennsylvania | 42061 | 1 | 0 |
23315 | 23315 | 2020-03-31 | Indiana | Pennsylvania | 42063 | 6 | 0 |
23316 | 23316 | 2020-03-31 | Juniata | Pennsylvania | 42067 | 3 | 0 |
23317 | 23317 | 2020-03-31 | Lackawanna | Pennsylvania | 42069 | 78 | 3 |
23318 | 23318 | 2020-03-31 | Lancaster | Pennsylvania | 42071 | 123 | 3 |
23319 | 23319 | 2020-03-31 | Lawrence | Pennsylvania | 42073 | 13 | 2 |
23320 | 23320 | 2020-03-31 | Lebanon | Pennsylvania | 42075 | 28 | 0 |
23321 | 23321 | 2020-03-31 | Lehigh | Pennsylvania | 42077 | 272 | 4 |
23322 | 23322 | 2020-03-31 | Luzerne | Pennsylvania | 42079 | 212 | 4 |
23323 | 23323 | 2020-03-31 | Lycoming | Pennsylvania | 42081 | 6 | 0 |
23324 | 23324 | 2020-03-31 | McKean | Pennsylvania | 42083 | 1 | 0 |
23325 | 23325 | 2020-03-31 | Mercer | Pennsylvania | 42085 | 8 | 0 |
23326 | 23326 | 2020-03-31 | Mifflin | Pennsylvania | 42087 | 2 | 0 |
23327 | 23327 | 2020-03-31 | Monroe | Pennsylvania | 42089 | 236 | 7 |
23328 | 23328 | 2020-03-31 | Montgomery | Pennsylvania | 42091 | 570 | 6 |
23329 | 23329 | 2020-03-31 | Montour | Pennsylvania | 42093 | 10 | 0 |
23330 | 23330 | 2020-03-31 | Northampton | Pennsylvania | 42095 | 245 | 5 |
23331 | 23331 | 2020-03-31 | Northumberland | Pennsylvania | 42097 | 1 | 0 |
23332 | 23332 | 2020-03-31 | Perry | Pennsylvania | 42099 | 1 | 0 |
23333 | 23333 | 2020-03-31 | Philadelphia | Pennsylvania | 42101 | 1315 | 14 |
23334 | 23334 | 2020-03-31 | Pike | Pennsylvania | 42103 | 48 | 1 |
23335 | 23335 | 2020-03-31 | Potter | Pennsylvania | 42105 | 2 | 0 |
23336 | 23336 | 2020-03-31 | Schuylkill | Pennsylvania | 42107 | 38 | 0 |
23337 | 23337 | 2020-03-31 | Snyder | Pennsylvania | 42109 | 2 | 1 |
23338 | 23338 | 2020-03-31 | Somerset | Pennsylvania | 42111 | 2 | 0 |
23339 | 23339 | 2020-03-31 | Susquehanna | Pennsylvania | 42115 | 1 | 0 |
23340 | 23340 | 2020-03-31 | Tioga | Pennsylvania | 42117 | 2 | 0 |
23341 | 23341 | 2020-03-31 | Union | Pennsylvania | 42119 | 4 | 0 |
23342 | 23342 | 2020-03-31 | Unknown | Pennsylvania | 0 | 1 | |
23343 | 23343 | 2020-03-31 | Venango | Pennsylvania | 42121 | 3 | 0 |
23344 | 23344 | 2020-03-31 | Warren | Pennsylvania | 42123 | 1 | 0 |
23345 | 23345 | 2020-03-31 | Washington | Pennsylvania | 42125 | 33 | 0 |
23346 | 23346 | 2020-03-31 | Wayne | Pennsylvania | 42127 | 10 | 0 |
23347 | 23347 | 2020-03-31 | Westmoreland | Pennsylvania | 42129 | 61 | 0 |
23348 | 23348 | 2020-03-31 | York | Pennsylvania | 42133 | 66 | 0 |
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);