ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,441 rows where state = "Pennsylvania" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 42093 699
- 42095 699
- 42097 699
- 42099 699
- 42101 699
- 42103 699
- 42105 699
- 42107 699
- 42109 699
- 42111 699
- 42113 699
- 42115 699
- 42117 699
- 42119 699
- 42121 699
- 42123 699
- 42125 699
- 42127 699
- 42129 699
- 42131 699
- 42133 699
- 42001 698
- 42003 698
- 42005 698
- 42007 698
- 42009 698
- 42011 698
- 42013 698
- 42015 698
- 42017 698
- …
county >30
- Montour 699
- Northampton 699
- Northumberland 699
- Perry 699
- Philadelphia 699
- Pike 699
- Potter 699
- Schuylkill 699
- Snyder 699
- Somerset 699
- Sullivan 699
- Susquehanna 699
- Tioga 699
- Union 699
- Venango 699
- Warren 699
- Washington 699
- Wayne 699
- Westmoreland 699
- Wyoming 699
- York 699
- Adams 698
- Allegheny 698
- Armstrong 698
- Beaver 698
- Bedford 698
- Berks 698
- Blair 698
- Bradford 698
- Bucks 698
- …
state 1
- Pennsylvania · 46,787 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
239231 | 239231 | 2020-06-14 | Montour | Pennsylvania | 42093 | 64 | 0 |
239232 | 239232 | 2020-06-14 | Northampton | Pennsylvania | 42095 | 3240 | 241 |
239233 | 239233 | 2020-06-14 | Northumberland | Pennsylvania | 42097 | 224 | 4 |
239234 | 239234 | 2020-06-14 | Perry | Pennsylvania | 42099 | 72 | 5 |
239235 | 239235 | 2020-06-14 | Philadelphia | Pennsylvania | 42101 | 24338 | 1505 |
239236 | 239236 | 2020-06-14 | Pike | Pennsylvania | 42103 | 482 | 20 |
239237 | 239237 | 2020-06-14 | Potter | Pennsylvania | 42105 | 13 | 0 |
239238 | 239238 | 2020-06-14 | Schuylkill | Pennsylvania | 42107 | 685 | 43 |
239239 | 239239 | 2020-06-14 | Snyder | Pennsylvania | 42109 | 59 | 1 |
239240 | 239240 | 2020-06-14 | Somerset | Pennsylvania | 42111 | 40 | 1 |
239241 | 239241 | 2020-06-14 | Sullivan | Pennsylvania | 42113 | 3 | 0 |
239242 | 239242 | 2020-06-14 | Susquehanna | Pennsylvania | 42115 | 170 | 17 |
239243 | 239243 | 2020-06-14 | Tioga | Pennsylvania | 42117 | 20 | 2 |
239244 | 239244 | 2020-06-14 | Union | Pennsylvania | 42119 | 83 | 2 |
239245 | 239245 | 2020-06-14 | Venango | Pennsylvania | 42121 | 17 | 0 |
239246 | 239246 | 2020-06-14 | Warren | Pennsylvania | 42123 | 5 | 0 |
239247 | 239247 | 2020-06-14 | Washington | Pennsylvania | 42125 | 155 | 6 |
239248 | 239248 | 2020-06-14 | Wayne | Pennsylvania | 42127 | 126 | 9 |
239249 | 239249 | 2020-06-14 | Westmoreland | Pennsylvania | 42129 | 490 | 38 |
239250 | 239250 | 2020-06-14 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
239251 | 239251 | 2020-06-14 | York | Pennsylvania | 42133 | 1162 | 31 |
242294 | 242294 | 2020-06-15 | Adams | Pennsylvania | 42001 | 296 | 9 |
242295 | 242295 | 2020-06-15 | Allegheny | Pennsylvania | 42003 | 2086 | 174 |
242296 | 242296 | 2020-06-15 | Armstrong | Pennsylvania | 42005 | 66 | 5 |
242297 | 242297 | 2020-06-15 | Beaver | Pennsylvania | 42007 | 613 | 77 |
242298 | 242298 | 2020-06-15 | Bedford | Pennsylvania | 42009 | 52 | 2 |
242299 | 242299 | 2020-06-15 | Berks | Pennsylvania | 42011 | 4324 | 338 |
242300 | 242300 | 2020-06-15 | Blair | Pennsylvania | 42013 | 55 | 1 |
242301 | 242301 | 2020-06-15 | Bradford | Pennsylvania | 42015 | 47 | 3 |
242302 | 242302 | 2020-06-15 | Bucks | Pennsylvania | 42017 | 5439 | 542 |
242303 | 242303 | 2020-06-15 | Butler | Pennsylvania | 42019 | 257 | 12 |
242304 | 242304 | 2020-06-15 | Cambria | Pennsylvania | 42021 | 61 | 3 |
242305 | 242305 | 2020-06-15 | Cameron | Pennsylvania | 42023 | 2 | 0 |
242306 | 242306 | 2020-06-15 | Carbon | Pennsylvania | 42025 | 259 | 24 |
242307 | 242307 | 2020-06-15 | Centre | Pennsylvania | 42027 | 171 | 6 |
242308 | 242308 | 2020-06-15 | Chester | Pennsylvania | 42029 | 3356 | 307 |
242309 | 242309 | 2020-06-15 | Clarion | Pennsylvania | 42031 | 31 | 2 |
242310 | 242310 | 2020-06-15 | Clearfield | Pennsylvania | 42033 | 55 | 0 |
242311 | 242311 | 2020-06-15 | Clinton | Pennsylvania | 42035 | 64 | 3 |
242312 | 242312 | 2020-06-15 | Columbia | Pennsylvania | 42037 | 380 | 33 |
242313 | 242313 | 2020-06-15 | Crawford | Pennsylvania | 42039 | 36 | 0 |
242314 | 242314 | 2020-06-15 | Cumberland | Pennsylvania | 42041 | 738 | 60 |
242315 | 242315 | 2020-06-15 | Dauphin | Pennsylvania | 42043 | 1655 | 107 |
242316 | 242316 | 2020-06-15 | Delaware | Pennsylvania | 42045 | 6978 | 671 |
242317 | 242317 | 2020-06-15 | Elk | Pennsylvania | 42047 | 6 | 0 |
242318 | 242318 | 2020-06-15 | Erie | Pennsylvania | 42049 | 468 | 8 |
242319 | 242319 | 2020-06-15 | Fayette | Pennsylvania | 42051 | 95 | 4 |
242320 | 242320 | 2020-06-15 | Forest | Pennsylvania | 42053 | 7 | 0 |
242321 | 242321 | 2020-06-15 | Franklin | Pennsylvania | 42055 | 843 | 42 |
242322 | 242322 | 2020-06-15 | Fulton | Pennsylvania | 42057 | 16 | 1 |
242323 | 242323 | 2020-06-15 | Greene | Pennsylvania | 42059 | 30 | 0 |
242324 | 242324 | 2020-06-15 | Huntingdon | Pennsylvania | 42061 | 239 | 4 |
242325 | 242325 | 2020-06-15 | Indiana | Pennsylvania | 42063 | 93 | 5 |
242326 | 242326 | 2020-06-15 | Jefferson | Pennsylvania | 42065 | 19 | 1 |
242327 | 242327 | 2020-06-15 | Juniata | Pennsylvania | 42067 | 108 | 5 |
242328 | 242328 | 2020-06-15 | Lackawanna | Pennsylvania | 42069 | 1602 | 196 |
242329 | 242329 | 2020-06-15 | Lancaster | Pennsylvania | 42071 | 3777 | 331 |
242330 | 242330 | 2020-06-15 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
242331 | 242331 | 2020-06-15 | Lebanon | Pennsylvania | 42075 | 1190 | 40 |
242332 | 242332 | 2020-06-15 | Lehigh | Pennsylvania | 42077 | 3957 | 269 |
242333 | 242333 | 2020-06-15 | Luzerne | Pennsylvania | 42079 | 2835 | 168 |
242334 | 242334 | 2020-06-15 | Lycoming | Pennsylvania | 42081 | 171 | 17 |
242335 | 242335 | 2020-06-15 | McKean | Pennsylvania | 42083 | 13 | 1 |
242336 | 242336 | 2020-06-15 | Mercer | Pennsylvania | 42085 | 115 | 6 |
242337 | 242337 | 2020-06-15 | Mifflin | Pennsylvania | 42087 | 59 | 1 |
242338 | 242338 | 2020-06-15 | Monroe | Pennsylvania | 42089 | 1350 | 105 |
242339 | 242339 | 2020-06-15 | Montgomery | Pennsylvania | 42091 | 7930 | 777 |
242340 | 242340 | 2020-06-15 | Montour | Pennsylvania | 42093 | 65 | 0 |
242341 | 242341 | 2020-06-15 | Northampton | Pennsylvania | 42095 | 3246 | 243 |
242342 | 242342 | 2020-06-15 | Northumberland | Pennsylvania | 42097 | 228 | 4 |
242343 | 242343 | 2020-06-15 | Perry | Pennsylvania | 42099 | 72 | 5 |
242344 | 242344 | 2020-06-15 | Philadelphia | Pennsylvania | 42101 | 24475 | 1509 |
242345 | 242345 | 2020-06-15 | Pike | Pennsylvania | 42103 | 482 | 20 |
242346 | 242346 | 2020-06-15 | Potter | Pennsylvania | 42105 | 13 | 0 |
242347 | 242347 | 2020-06-15 | Schuylkill | Pennsylvania | 42107 | 691 | 43 |
242348 | 242348 | 2020-06-15 | Snyder | Pennsylvania | 42109 | 60 | 1 |
242349 | 242349 | 2020-06-15 | Somerset | Pennsylvania | 42111 | 41 | 1 |
242350 | 242350 | 2020-06-15 | Sullivan | Pennsylvania | 42113 | 3 | 0 |
242351 | 242351 | 2020-06-15 | Susquehanna | Pennsylvania | 42115 | 171 | 17 |
242352 | 242352 | 2020-06-15 | Tioga | Pennsylvania | 42117 | 20 | 2 |
242353 | 242353 | 2020-06-15 | Union | Pennsylvania | 42119 | 88 | 2 |
242354 | 242354 | 2020-06-15 | Venango | Pennsylvania | 42121 | 17 | 0 |
242355 | 242355 | 2020-06-15 | Warren | Pennsylvania | 42123 | 5 | 0 |
242356 | 242356 | 2020-06-15 | Washington | Pennsylvania | 42125 | 156 | 6 |
242357 | 242357 | 2020-06-15 | Wayne | Pennsylvania | 42127 | 126 | 9 |
242358 | 242358 | 2020-06-15 | Westmoreland | Pennsylvania | 42129 | 492 | 38 |
242359 | 242359 | 2020-06-15 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
242360 | 242360 | 2020-06-15 | York | Pennsylvania | 42133 | 1169 | 32 |
245406 | 245406 | 2020-06-16 | Adams | Pennsylvania | 42001 | 298 | 10 |
245407 | 245407 | 2020-06-16 | Allegheny | Pennsylvania | 42003 | 2113 | 177 |
245408 | 245408 | 2020-06-16 | Armstrong | Pennsylvania | 42005 | 68 | 5 |
245409 | 245409 | 2020-06-16 | Beaver | Pennsylvania | 42007 | 613 | 77 |
245410 | 245410 | 2020-06-16 | Bedford | Pennsylvania | 42009 | 53 | 2 |
245411 | 245411 | 2020-06-16 | Berks | Pennsylvania | 42011 | 4341 | 338 |
245412 | 245412 | 2020-06-16 | Blair | Pennsylvania | 42013 | 55 | 1 |
245413 | 245413 | 2020-06-16 | Bradford | Pennsylvania | 42015 | 47 | 3 |
245414 | 245414 | 2020-06-16 | Bucks | Pennsylvania | 42017 | 5452 | 544 |
245415 | 245415 | 2020-06-16 | Butler | Pennsylvania | 42019 | 260 | 12 |
245416 | 245416 | 2020-06-16 | Cambria | Pennsylvania | 42021 | 61 | 3 |
245417 | 245417 | 2020-06-16 | Cameron | Pennsylvania | 42023 | 2 | 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);