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-04-11 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
50332 | 50332 | 2020-04-11 | Adams | Pennsylvania | 42001 | 44 | 1 |
50333 | 50333 | 2020-04-11 | Allegheny | Pennsylvania | 42003 | 836 | 19 |
50334 | 50334 | 2020-04-11 | Armstrong | Pennsylvania | 42005 | 26 | 1 |
50335 | 50335 | 2020-04-11 | Beaver | Pennsylvania | 42007 | 143 | 13 |
50336 | 50336 | 2020-04-11 | Bedford | Pennsylvania | 42009 | 5 | 1 |
50337 | 50337 | 2020-04-11 | Berks | Pennsylvania | 42011 | 930 | 19 |
50338 | 50338 | 2020-04-11 | Blair | Pennsylvania | 42013 | 10 | 0 |
50339 | 50339 | 2020-04-11 | Bradford | Pennsylvania | 42015 | 18 | 0 |
50340 | 50340 | 2020-04-11 | Bucks | Pennsylvania | 42017 | 1170 | 35 |
50341 | 50341 | 2020-04-11 | Butler | Pennsylvania | 42019 | 128 | 3 |
50342 | 50342 | 2020-04-11 | Cambria | Pennsylvania | 42021 | 13 | 1 |
50343 | 50343 | 2020-04-11 | Cameron | Pennsylvania | 42023 | 1 | 0 |
50344 | 50344 | 2020-04-11 | Carbon | Pennsylvania | 42025 | 98 | 3 |
50345 | 50345 | 2020-04-11 | Centre | Pennsylvania | 42027 | 69 | 0 |
50346 | 50346 | 2020-04-11 | Chester | Pennsylvania | 42029 | 532 | 15 |
50347 | 50347 | 2020-04-11 | Clarion | Pennsylvania | 42031 | 15 | 0 |
50348 | 50348 | 2020-04-11 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
50349 | 50349 | 2020-04-11 | Clinton | Pennsylvania | 42035 | 7 | 0 |
50350 | 50350 | 2020-04-11 | Columbia | Pennsylvania | 42037 | 99 | 2 |
50351 | 50351 | 2020-04-11 | Crawford | Pennsylvania | 42039 | 15 | 0 |
50352 | 50352 | 2020-04-11 | Cumberland | Pennsylvania | 42041 | 105 | 3 |
50353 | 50353 | 2020-04-11 | Dauphin | Pennsylvania | 42043 | 213 | 3 |
50354 | 50354 | 2020-04-11 | Delaware | Pennsylvania | 42045 | 1510 | 39 |
50355 | 50355 | 2020-04-11 | Elk | Pennsylvania | 42047 | 2 | 0 |
50356 | 50356 | 2020-04-11 | Erie | Pennsylvania | 42049 | 39 | 1 |
50357 | 50357 | 2020-04-11 | Fayette | Pennsylvania | 42051 | 50 | 3 |
50358 | 50358 | 2020-04-11 | Forest | Pennsylvania | 42053 | 5 | 0 |
50359 | 50359 | 2020-04-11 | Franklin | Pennsylvania | 42055 | 59 | 0 |
50360 | 50360 | 2020-04-11 | Fulton | Pennsylvania | 42057 | 1 | 0 |
50361 | 50361 | 2020-04-11 | Greene | Pennsylvania | 42059 | 23 | 0 |
50362 | 50362 | 2020-04-11 | Huntingdon | Pennsylvania | 42061 | 10 | 0 |
50363 | 50363 | 2020-04-11 | Indiana | Pennsylvania | 42063 | 40 | 0 |
50364 | 50364 | 2020-04-11 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
50365 | 50365 | 2020-04-11 | Juniata | Pennsylvania | 42067 | 38 | 0 |
50366 | 50366 | 2020-04-11 | Lackawanna | Pennsylvania | 42069 | 392 | 20 |
50367 | 50367 | 2020-04-11 | Lancaster | Pennsylvania | 42071 | 698 | 23 |
50368 | 50368 | 2020-04-11 | Lawrence | Pennsylvania | 42073 | 46 | 4 |
50369 | 50369 | 2020-04-11 | Lebanon | Pennsylvania | 42075 | 232 | 1 |
50370 | 50370 | 2020-04-11 | Lehigh | Pennsylvania | 42077 | 1620 | 16 |
50371 | 50371 | 2020-04-11 | Luzerne | Pennsylvania | 42079 | 1372 | 17 |
50372 | 50372 | 2020-04-11 | Lycoming | Pennsylvania | 42081 | 20 | 0 |
50373 | 50373 | 2020-04-11 | McKean | Pennsylvania | 42083 | 2 | 0 |
50374 | 50374 | 2020-04-11 | Mercer | Pennsylvania | 42085 | 38 | 0 |
50375 | 50375 | 2020-04-11 | Mifflin | Pennsylvania | 42087 | 10 | 0 |
50376 | 50376 | 2020-04-11 | Monroe | Pennsylvania | 42089 | 774 | 22 |
50377 | 50377 | 2020-04-11 | Montgomery | Pennsylvania | 42091 | 2053 | 68 |
50378 | 50378 | 2020-04-11 | Montour | Pennsylvania | 42093 | 29 | 0 |
50379 | 50379 | 2020-04-11 | Northampton | Pennsylvania | 42095 | 1039 | 23 |
50380 | 50380 | 2020-04-11 | Northumberland | Pennsylvania | 42097 | 31 | 0 |
50381 | 50381 | 2020-04-11 | Perry | Pennsylvania | 42099 | 16 | 1 |
50382 | 50382 | 2020-04-11 | Philadelphia | Pennsylvania | 42101 | 6022 | 130 |
50383 | 50383 | 2020-04-11 | Pike | Pennsylvania | 42103 | 208 | 6 |
50384 | 50384 | 2020-04-11 | Potter | Pennsylvania | 42105 | 4 | 0 |
50385 | 50385 | 2020-04-11 | Schuylkill | Pennsylvania | 42107 | 179 | 2 |
50386 | 50386 | 2020-04-11 | Snyder | Pennsylvania | 42109 | 16 | 1 |
50387 | 50387 | 2020-04-11 | Somerset | Pennsylvania | 42111 | 10 | 0 |
50388 | 50388 | 2020-04-11 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
50389 | 50389 | 2020-04-11 | Susquehanna | Pennsylvania | 42115 | 23 | 2 |
50390 | 50390 | 2020-04-11 | Tioga | Pennsylvania | 42117 | 12 | 1 |
50391 | 50391 | 2020-04-11 | Union | Pennsylvania | 42119 | 14 | 0 |
50392 | 50392 | 2020-04-11 | Venango | Pennsylvania | 42121 | 6 | 0 |
50393 | 50393 | 2020-04-11 | Warren | Pennsylvania | 42123 | 1 | 0 |
50394 | 50394 | 2020-04-11 | Washington | Pennsylvania | 42125 | 66 | 0 |
50395 | 50395 | 2020-04-11 | Wayne | Pennsylvania | 42127 | 57 | 1 |
50396 | 50396 | 2020-04-11 | Westmoreland | Pennsylvania | 42129 | 218 | 12 |
50397 | 50397 | 2020-04-11 | Wyoming | Pennsylvania | 42131 | 8 | 0 |
50398 | 50398 | 2020-04-11 | York | Pennsylvania | 42133 | 293 | 3 |
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);