Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
This data as json, CSV (advanced)
Suggested facets: date (date)
fips
county
state
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 336596 | 336596 | 2020-07-15 | Adams | Pennsylvania | 42001 | 399 | 14 |
| 336597 | 336597 | 2020-07-15 | Allegheny | Pennsylvania | 42003 | 5610 | 204 |
| 336598 | 336598 | 2020-07-15 | Armstrong | Pennsylvania | 42005 | 94 | 6 |
| 336599 | 336599 | 2020-07-15 | Beaver | Pennsylvania | 42007 | 884 | 79 |
| 336600 | 336600 | 2020-07-15 | Bedford | Pennsylvania | 42009 | 94 | 4 |
| 336601 | 336601 | 2020-07-15 | Berks | Pennsylvania | 42011 | 4744 | 359 |
| 336602 | 336602 | 2020-07-15 | Blair | Pennsylvania | 42013 | 113 | 1 |
| 336603 | 336603 | 2020-07-15 | Bradford | Pennsylvania | 42015 | 61 | 3 |
| 336604 | 336604 | 2020-07-15 | Bucks | Pennsylvania | 42017 | 6189 | 572 |
| 336605 | 336605 | 2020-07-15 | Butler | Pennsylvania | 42019 | 444 | 13 |
| 336606 | 336606 | 2020-07-15 | Cambria | Pennsylvania | 42021 | 143 | 3 |
| 336607 | 336607 | 2020-07-15 | Cameron | Pennsylvania | 42023 | 5 | 0 |
| 336608 | 336608 | 2020-07-15 | Carbon | Pennsylvania | 42025 | 306 | 27 |
| 336609 | 336609 | 2020-07-15 | Centre | Pennsylvania | 42027 | 262 | 8 |
| 336610 | 336610 | 2020-07-15 | Chester | Pennsylvania | 42029 | 4153 | 337 |
| 336611 | 336611 | 2020-07-15 | Clarion | Pennsylvania | 42031 | 66 | 2 |
| 336612 | 336612 | 2020-07-15 | Clearfield | Pennsylvania | 42033 | 96 | 0 |
| 336613 | 336613 | 2020-07-15 | Clinton | Pennsylvania | 42035 | 100 | 5 |
| 336614 | 336614 | 2020-07-15 | Columbia | Pennsylvania | 42037 | 424 | 35 |
| 336615 | 336615 | 2020-07-15 | Crawford | Pennsylvania | 42039 | 101 | 1 |
| 336616 | 336616 | 2020-07-15 | Cumberland | Pennsylvania | 42041 | 982 | 66 |
| 336617 | 336617 | 2020-07-15 | Dauphin | Pennsylvania | 42043 | 2325 | 149 |
| 336618 | 336618 | 2020-07-15 | Delaware | Pennsylvania | 42045 | 7698 | 717 |
| 336619 | 336619 | 2020-07-15 | Elk | Pennsylvania | 42047 | 31 | 0 |
| 336620 | 336620 | 2020-07-15 | Erie | Pennsylvania | 42049 | 747 | 13 |
| 336621 | 336621 | 2020-07-15 | Fayette | Pennsylvania | 42051 | 220 | 4 |
| 336622 | 336622 | 2020-07-15 | Forest | Pennsylvania | 42053 | 7 | 0 |
| 336623 | 336623 | 2020-07-15 | Franklin | Pennsylvania | 42055 | 1019 | 46 |
| 336624 | 336624 | 2020-07-15 | Fulton | Pennsylvania | 42057 | 19 | 1 |
| 336625 | 336625 | 2020-07-15 | Greene | Pennsylvania | 42059 | 75 | 0 |
| 336626 | 336626 | 2020-07-15 | Huntingdon | Pennsylvania | 42061 | 263 | 4 |
| 336627 | 336627 | 2020-07-15 | Indiana | Pennsylvania | 42063 | 168 | 6 |
| 336628 | 336628 | 2020-07-15 | Jefferson | Pennsylvania | 42065 | 41 | 1 |
| 336629 | 336629 | 2020-07-15 | Juniata | Pennsylvania | 42067 | 116 | 6 |
| 336630 | 336630 | 2020-07-15 | Lackawanna | Pennsylvania | 42069 | 1771 | 211 |
| 336631 | 336631 | 2020-07-15 | Lancaster | Pennsylvania | 42071 | 4906 | 388 |
| 336632 | 336632 | 2020-07-15 | Lawrence | Pennsylvania | 42073 | 207 | 9 |
| 336633 | 336633 | 2020-07-15 | Lebanon | Pennsylvania | 42075 | 1476 | 51 |
| 336634 | 336634 | 2020-07-15 | Lehigh | Pennsylvania | 42077 | 4465 | 330 |
| 336635 | 336635 | 2020-07-15 | Luzerne | Pennsylvania | 42079 | 3036 | 181 |
| 336636 | 336636 | 2020-07-15 | Lycoming | Pennsylvania | 42081 | 252 | 20 |
| 336637 | 336637 | 2020-07-15 | McKean | Pennsylvania | 42083 | 20 | 1 |
| 336638 | 336638 | 2020-07-15 | Mercer | Pennsylvania | 42085 | 203 | 6 |
| 336639 | 336639 | 2020-07-15 | Mifflin | Pennsylvania | 42087 | 74 | 1 |
| 336640 | 336640 | 2020-07-15 | Monroe | Pennsylvania | 42089 | 1482 | 113 |
| 336641 | 336641 | 2020-07-15 | Montgomery | Pennsylvania | 42091 | 8972 | 832 |
| 336642 | 336642 | 2020-07-15 | Montour | Pennsylvania | 42093 | 81 | 2 |
| 336643 | 336643 | 2020-07-15 | Northampton | Pennsylvania | 42095 | 3582 | 283 |
| 336644 | 336644 | 2020-07-15 | Northumberland | Pennsylvania | 42097 | 352 | 10 |
| 336645 | 336645 | 2020-07-15 | Perry | Pennsylvania | 42099 | 96 | 5 |
| 336646 | 336646 | 2020-07-15 | Philadelphia | Pennsylvania | 42101 | 27867 | 1653 |
| 336647 | 336647 | 2020-07-15 | Pike | Pennsylvania | 42103 | 508 | 21 |
| 336648 | 336648 | 2020-07-15 | Potter | Pennsylvania | 42105 | 19 | 0 |
| 336649 | 336649 | 2020-07-15 | Schuylkill | Pennsylvania | 42107 | 782 | 48 |
| 336650 | 336650 | 2020-07-15 | Snyder | Pennsylvania | 42109 | 74 | 2 |
| 336651 | 336651 | 2020-07-15 | Somerset | Pennsylvania | 42111 | 86 | 1 |
| 336652 | 336652 | 2020-07-15 | Sullivan | Pennsylvania | 42113 | 10 | 0 |
| 336653 | 336653 | 2020-07-15 | Susquehanna | Pennsylvania | 42115 | 195 | 26 |
| 336654 | 336654 | 2020-07-15 | Tioga | Pennsylvania | 42117 | 31 | 2 |
| 336655 | 336655 | 2020-07-15 | Union | Pennsylvania | 42119 | 108 | 2 |
| 336656 | 336656 | 2020-07-15 | Venango | Pennsylvania | 42121 | 49 | 0 |
| 336657 | 336657 | 2020-07-15 | Warren | Pennsylvania | 42123 | 11 | 1 |
| 336658 | 336658 | 2020-07-15 | Washington | Pennsylvania | 42125 | 494 | 6 |
| 336659 | 336659 | 2020-07-15 | Wayne | Pennsylvania | 42127 | 143 | 8 |
| 336660 | 336660 | 2020-07-15 | Westmoreland | Pennsylvania | 42129 | 1054 | 39 |
| 336661 | 336661 | 2020-07-15 | Wyoming | Pennsylvania | 42131 | 48 | 7 |
| 336662 | 336662 | 2020-07-15 | York | Pennsylvania | 42133 | 1908 | 66 |
| 333404 | 333404 | 2020-07-14 | Adams | Pennsylvania | 42001 | 399 | 14 |
| 333405 | 333405 | 2020-07-14 | Allegheny | Pennsylvania | 42003 | 5364 | 199 |
| 333406 | 333406 | 2020-07-14 | Armstrong | Pennsylvania | 42005 | 88 | 6 |
| 333407 | 333407 | 2020-07-14 | Beaver | Pennsylvania | 42007 | 870 | 79 |
| 333408 | 333408 | 2020-07-14 | Bedford | Pennsylvania | 42009 | 93 | 4 |
| 333409 | 333409 | 2020-07-14 | Berks | Pennsylvania | 42011 | 4710 | 358 |
| 333410 | 333410 | 2020-07-14 | Blair | Pennsylvania | 42013 | 107 | 1 |
| 333411 | 333411 | 2020-07-14 | Bradford | Pennsylvania | 42015 | 59 | 3 |
| 333412 | 333412 | 2020-07-14 | Bucks | Pennsylvania | 42017 | 6137 | 572 |
| 333413 | 333413 | 2020-07-14 | Butler | Pennsylvania | 42019 | 444 | 13 |
| 333414 | 333414 | 2020-07-14 | Cambria | Pennsylvania | 42021 | 137 | 3 |
| 333415 | 333415 | 2020-07-14 | Cameron | Pennsylvania | 42023 | 4 | 0 |
| 333416 | 333416 | 2020-07-14 | Carbon | Pennsylvania | 42025 | 301 | 27 |
| 333417 | 333417 | 2020-07-14 | Centre | Pennsylvania | 42027 | 253 | 8 |
| 333418 | 333418 | 2020-07-14 | Chester | Pennsylvania | 42029 | 4103 | 335 |
| 333419 | 333419 | 2020-07-14 | Clarion | Pennsylvania | 42031 | 66 | 2 |
| 333420 | 333420 | 2020-07-14 | Clearfield | Pennsylvania | 42033 | 95 | 0 |
| 333421 | 333421 | 2020-07-14 | Clinton | Pennsylvania | 42035 | 96 | 5 |
| 333422 | 333422 | 2020-07-14 | Columbia | Pennsylvania | 42037 | 421 | 35 |
| 333423 | 333423 | 2020-07-14 | Crawford | Pennsylvania | 42039 | 80 | 1 |
| 333424 | 333424 | 2020-07-14 | Cumberland | Pennsylvania | 42041 | 961 | 66 |
| 333425 | 333425 | 2020-07-14 | Dauphin | Pennsylvania | 42043 | 2309 | 149 |
| 333426 | 333426 | 2020-07-14 | Delaware | Pennsylvania | 42045 | 7650 | 709 |
| 333427 | 333427 | 2020-07-14 | Elk | Pennsylvania | 42047 | 31 | 0 |
| 333428 | 333428 | 2020-07-14 | Erie | Pennsylvania | 42049 | 740 | 13 |
| 333429 | 333429 | 2020-07-14 | Fayette | Pennsylvania | 42051 | 213 | 4 |
| 333430 | 333430 | 2020-07-14 | Forest | Pennsylvania | 42053 | 7 | 0 |
| 333431 | 333431 | 2020-07-14 | Franklin | Pennsylvania | 42055 | 1016 | 46 |
| 333432 | 333432 | 2020-07-14 | Fulton | Pennsylvania | 42057 | 19 | 1 |
| 333433 | 333433 | 2020-07-14 | Greene | Pennsylvania | 42059 | 72 | 0 |
| 333434 | 333434 | 2020-07-14 | Huntingdon | Pennsylvania | 42061 | 260 | 4 |
| 333435 | 333435 | 2020-07-14 | Indiana | Pennsylvania | 42063 | 169 | 6 |
| 333436 | 333436 | 2020-07-14 | Jefferson | Pennsylvania | 42065 | 41 | 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );