ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-10-05" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
601473 | 601473 | 2020-10-05 | Adams | Pennsylvania | 42001 | 885 | 26 |
601474 | 601474 | 2020-10-05 | Allegheny | Pennsylvania | 42003 | 12777 | 386 |
601475 | 601475 | 2020-10-05 | Armstrong | Pennsylvania | 42005 | 471 | 18 |
601476 | 601476 | 2020-10-05 | Beaver | Pennsylvania | 42007 | 1973 | 129 |
601477 | 601477 | 2020-10-05 | Bedford | Pennsylvania | 42009 | 262 | 6 |
601478 | 601478 | 2020-10-05 | Berks | Pennsylvania | 42011 | 7378 | 399 |
601479 | 601479 | 2020-10-05 | Blair | Pennsylvania | 42013 | 795 | 19 |
601480 | 601480 | 2020-10-05 | Bradford | Pennsylvania | 42015 | 240 | 5 |
601481 | 601481 | 2020-10-05 | Bucks | Pennsylvania | 42017 | 9066 | 617 |
601482 | 601482 | 2020-10-05 | Butler | Pennsylvania | 42019 | 1136 | 25 |
601483 | 601483 | 2020-10-05 | Cambria | Pennsylvania | 42021 | 655 | 7 |
601484 | 601484 | 2020-10-05 | Cameron | Pennsylvania | 42023 | 8 | 0 |
601485 | 601485 | 2020-10-05 | Carbon | Pennsylvania | 42025 | 478 | 28 |
601486 | 601486 | 2020-10-05 | Centre | Pennsylvania | 42027 | 3044 | 11 |
601487 | 601487 | 2020-10-05 | Chester | Pennsylvania | 42029 | 7135 | 370 |
601488 | 601488 | 2020-10-05 | Clarion | Pennsylvania | 42031 | 139 | 3 |
601489 | 601489 | 2020-10-05 | Clearfield | Pennsylvania | 42033 | 345 | 6 |
601490 | 601490 | 2020-10-05 | Clinton | Pennsylvania | 42035 | 217 | 6 |
601491 | 601491 | 2020-10-05 | Columbia | Pennsylvania | 42037 | 963 | 36 |
601492 | 601492 | 2020-10-05 | Crawford | Pennsylvania | 42039 | 330 | 3 |
601493 | 601493 | 2020-10-05 | Cumberland | Pennsylvania | 42041 | 1978 | 77 |
601494 | 601494 | 2020-10-05 | Dauphin | Pennsylvania | 42043 | 3966 | 182 |
601495 | 601495 | 2020-10-05 | Delaware | Pennsylvania | 42045 | 11771 | 797 |
601496 | 601496 | 2020-10-05 | Elk | Pennsylvania | 42047 | 78 | 2 |
601497 | 601497 | 2020-10-05 | Erie | Pennsylvania | 42049 | 1656 | 48 |
601498 | 601498 | 2020-10-05 | Fayette | Pennsylvania | 42051 | 831 | 7 |
601499 | 601499 | 2020-10-05 | Forest | Pennsylvania | 42053 | 15 | 0 |
601500 | 601500 | 2020-10-05 | Franklin | Pennsylvania | 42055 | 1835 | 52 |
601501 | 601501 | 2020-10-05 | Fulton | Pennsylvania | 42057 | 52 | 2 |
601502 | 601502 | 2020-10-05 | Greene | Pennsylvania | 42059 | 194 | 1 |
601503 | 601503 | 2020-10-05 | Huntingdon | Pennsylvania | 42061 | 446 | 6 |
601504 | 601504 | 2020-10-05 | Indiana | Pennsylvania | 42063 | 791 | 12 |
601505 | 601505 | 2020-10-05 | Jefferson | Pennsylvania | 42065 | 120 | 3 |
601506 | 601506 | 2020-10-05 | Juniata | Pennsylvania | 42067 | 199 | 7 |
601507 | 601507 | 2020-10-05 | Lackawanna | Pennsylvania | 42069 | 2731 | 216 |
601508 | 601508 | 2020-10-05 | Lancaster | Pennsylvania | 42071 | 8218 | 459 |
601509 | 601509 | 2020-10-05 | Lawrence | Pennsylvania | 42073 | 562 | 22 |
601510 | 601510 | 2020-10-05 | Lebanon | Pennsylvania | 42075 | 2164 | 62 |
601511 | 601511 | 2020-10-05 | Lehigh | Pennsylvania | 42077 | 5781 | 355 |
601512 | 601512 | 2020-10-05 | Luzerne | Pennsylvania | 42079 | 4209 | 190 |
601513 | 601513 | 2020-10-05 | Lycoming | Pennsylvania | 42081 | 751 | 26 |
601514 | 601514 | 2020-10-05 | McKean | Pennsylvania | 42083 | 62 | 2 |
601515 | 601515 | 2020-10-05 | Mercer | Pennsylvania | 42085 | 778 | 21 |
601516 | 601516 | 2020-10-05 | Mifflin | Pennsylvania | 42087 | 241 | 2 |
601517 | 601517 | 2020-10-05 | Monroe | Pennsylvania | 42089 | 1829 | 134 |
601518 | 601518 | 2020-10-05 | Montgomery | Pennsylvania | 42091 | 12517 | 883 |
601519 | 601519 | 2020-10-05 | Montour | Pennsylvania | 42093 | 216 | 5 |
601520 | 601520 | 2020-10-05 | Northampton | Pennsylvania | 42095 | 4606 | 305 |
601521 | 601521 | 2020-10-05 | Northumberland | Pennsylvania | 42097 | 1144 | 69 |
601522 | 601522 | 2020-10-05 | Perry | Pennsylvania | 42099 | 246 | 6 |
601523 | 601523 | 2020-10-05 | Philadelphia | Pennsylvania | 42101 | 37807 | 1839 |
601524 | 601524 | 2020-10-05 | Pike | Pennsylvania | 42103 | 595 | 22 |
601525 | 601525 | 2020-10-05 | Potter | Pennsylvania | 42105 | 30 | 0 |
601526 | 601526 | 2020-10-05 | Schuylkill | Pennsylvania | 42107 | 1277 | 58 |
601527 | 601527 | 2020-10-05 | Snyder | Pennsylvania | 42109 | 396 | 8 |
601528 | 601528 | 2020-10-05 | Somerset | Pennsylvania | 42111 | 238 | 3 |
601529 | 601529 | 2020-10-05 | Sullivan | Pennsylvania | 42113 | 15 | 0 |
601530 | 601530 | 2020-10-05 | Susquehanna | Pennsylvania | 42115 | 308 | 28 |
601531 | 601531 | 2020-10-05 | Tioga | Pennsylvania | 42117 | 95 | 3 |
601532 | 601532 | 2020-10-05 | Union | Pennsylvania | 42119 | 568 | 7 |
601533 | 601533 | 2020-10-05 | Venango | Pennsylvania | 42121 | 97 | 1 |
601534 | 601534 | 2020-10-05 | Warren | Pennsylvania | 42123 | 45 | 1 |
601535 | 601535 | 2020-10-05 | Washington | Pennsylvania | 42125 | 1449 | 30 |
601536 | 601536 | 2020-10-05 | Wayne | Pennsylvania | 42127 | 256 | 11 |
601537 | 601537 | 2020-10-05 | Westmoreland | Pennsylvania | 42129 | 2461 | 57 |
601538 | 601538 | 2020-10-05 | Wyoming | Pennsylvania | 42131 | 80 | 8 |
601539 | 601539 | 2020-10-05 | York | Pennsylvania | 42133 | 5125 | 171 |
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);