ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-11-23" 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 |
---|---|---|---|---|---|---|---|
1945611 | 1945611 | 2021-11-23 | Adams | Pennsylvania | 42001 | 14405 | 241 |
1945612 | 1945612 | 2021-11-23 | Allegheny | Pennsylvania | 42003 | 145902 | 2462 |
1945613 | 1945613 | 2021-11-23 | Armstrong | Pennsylvania | 42005 | 10101 | 224 |
1945614 | 1945614 | 2021-11-23 | Beaver | Pennsylvania | 42007 | 25068 | 513 |
1945615 | 1945615 | 2021-11-23 | Bedford | Pennsylvania | 42009 | 7576 | 189 |
1945616 | 1945616 | 2021-11-23 | Berks | Pennsylvania | 42011 | 63248 | 1190 |
1945617 | 1945617 | 2021-11-23 | Blair | Pennsylvania | 42013 | 20119 | 422 |
1945618 | 1945618 | 2021-11-23 | Bradford | Pennsylvania | 42015 | 8973 | 135 |
1945619 | 1945619 | 2021-11-23 | Bucks | Pennsylvania | 42017 | 77767 | 1468 |
1945620 | 1945620 | 2021-11-23 | Butler | Pennsylvania | 42019 | 28064 | 543 |
1945621 | 1945621 | 2021-11-23 | Cambria | Pennsylvania | 42021 | 21957 | 554 |
1945622 | 1945622 | 2021-11-23 | Cameron | Pennsylvania | 42023 | 576 | 13 |
1945623 | 1945623 | 2021-11-23 | Carbon | Pennsylvania | 42025 | 9747 | 209 |
1945624 | 1945624 | 2021-11-23 | Centre | Pennsylvania | 42027 | 22296 | 255 |
1945625 | 1945625 | 2021-11-23 | Chester | Pennsylvania | 42029 | 54377 | 902 |
1945626 | 1945626 | 2021-11-23 | Clarion | Pennsylvania | 42031 | 5720 | 139 |
1945627 | 1945627 | 2021-11-23 | Clearfield | Pennsylvania | 42033 | 12426 | 224 |
1945628 | 1945628 | 2021-11-23 | Clinton | Pennsylvania | 42035 | 5844 | 86 |
1945629 | 1945629 | 2021-11-23 | Columbia | Pennsylvania | 42037 | 8902 | 164 |
1945630 | 1945630 | 2021-11-23 | Crawford | Pennsylvania | 42039 | 12855 | 216 |
1945631 | 1945631 | 2021-11-23 | Cumberland | Pennsylvania | 42041 | 30775 | 648 |
1945632 | 1945632 | 2021-11-23 | Dauphin | Pennsylvania | 42043 | 37477 | 684 |
1945633 | 1945633 | 2021-11-23 | Delaware | Pennsylvania | 42045 | 65302 | 1523 |
1945634 | 1945634 | 2021-11-23 | Elk | Pennsylvania | 42047 | 4696 | 65 |
1945635 | 1945635 | 2021-11-23 | Erie | Pennsylvania | 42049 | 34500 | 534 |
1945636 | 1945636 | 2021-11-23 | Fayette | Pennsylvania | 42051 | 20011 | 451 |
1945637 | 1945637 | 2021-11-23 | Forest | Pennsylvania | 42053 | 1724 | 28 |
1945638 | 1945638 | 2021-11-23 | Franklin | Pennsylvania | 42055 | 23537 | 483 |
1945639 | 1945639 | 2021-11-23 | Fulton | Pennsylvania | 42057 | 2567 | 38 |
1945640 | 1945640 | 2021-11-23 | Greene | Pennsylvania | 42059 | 5515 | 65 |
1945641 | 1945641 | 2021-11-23 | Huntingdon | Pennsylvania | 42061 | 7435 | 175 |
1945642 | 1945642 | 2021-11-23 | Indiana | Pennsylvania | 42063 | 10437 | 258 |
1945643 | 1945643 | 2021-11-23 | Jefferson | Pennsylvania | 42065 | 5924 | 141 |
1945644 | 1945644 | 2021-11-23 | Juniata | Pennsylvania | 42067 | 3210 | 122 |
1945645 | 1945645 | 2021-11-23 | Lackawanna | Pennsylvania | 42069 | 24791 | 539 |
1945646 | 1945646 | 2021-11-23 | Lancaster | Pennsylvania | 42071 | 76919 | 1393 |
1945647 | 1945647 | 2021-11-23 | Lawrence | Pennsylvania | 42073 | 12242 | 284 |
1945648 | 1945648 | 2021-11-23 | Lebanon | Pennsylvania | 42075 | 22427 | 352 |
1945649 | 1945649 | 2021-11-23 | Lehigh | Pennsylvania | 42077 | 51670 | 958 |
1945650 | 1945650 | 2021-11-23 | Luzerne | Pennsylvania | 42079 | 44769 | 972 |
1945651 | 1945651 | 2021-11-23 | Lycoming | Pennsylvania | 42081 | 18844 | 379 |
1945652 | 1945652 | 2021-11-23 | McKean | Pennsylvania | 42083 | 5726 | 101 |
1945653 | 1945653 | 2021-11-23 | Mercer | Pennsylvania | 42085 | 15402 | 364 |
1945654 | 1945654 | 2021-11-23 | Mifflin | Pennsylvania | 42087 | 7955 | 220 |
1945655 | 1945655 | 2021-11-23 | Monroe | Pennsylvania | 42089 | 21286 | 377 |
1945656 | 1945656 | 2021-11-23 | Montgomery | Pennsylvania | 42091 | 90959 | 1891 |
1945657 | 1945657 | 2021-11-23 | Montour | Pennsylvania | 42093 | 2796 | 75 |
1945658 | 1945658 | 2021-11-23 | Northampton | Pennsylvania | 42095 | 47586 | 809 |
1945659 | 1945659 | 2021-11-23 | Northumberland | Pennsylvania | 42097 | 14402 | 422 |
1945660 | 1945660 | 2021-11-23 | Perry | Pennsylvania | 42099 | 5771 | 132 |
1945661 | 1945661 | 2021-11-23 | Philadelphia | Pennsylvania | 42101 | 189142 | 4082 |
1945662 | 1945662 | 2021-11-23 | Pike | Pennsylvania | 42103 | 5884 | 69 |
1945663 | 1945663 | 2021-11-23 | Potter | Pennsylvania | 42105 | 2204 | 53 |
1945664 | 1945664 | 2021-11-23 | Schuylkill | Pennsylvania | 42107 | 21645 | 496 |
1945665 | 1945665 | 2021-11-23 | Snyder | Pennsylvania | 42109 | 5225 | 110 |
1945666 | 1945666 | 2021-11-23 | Somerset | Pennsylvania | 42111 | 11835 | 272 |
1945667 | 1945667 | 2021-11-23 | Sullivan | Pennsylvania | 42113 | 642 | 24 |
1945668 | 1945668 | 2021-11-23 | Susquehanna | Pennsylvania | 42115 | 4409 | 73 |
1945669 | 1945669 | 2021-11-23 | Tioga | Pennsylvania | 42117 | 5367 | 145 |
1945670 | 1945670 | 2021-11-23 | Union | Pennsylvania | 42119 | 7989 | 109 |
1945671 | 1945671 | 2021-11-23 | Venango | Pennsylvania | 42121 | 7730 | 162 |
1945672 | 1945672 | 2021-11-23 | Warren | Pennsylvania | 42123 | 4936 | 149 |
1945673 | 1945673 | 2021-11-23 | Washington | Pennsylvania | 42125 | 28981 | 420 |
1945674 | 1945674 | 2021-11-23 | Wayne | Pennsylvania | 42127 | 6335 | 123 |
1945675 | 1945675 | 2021-11-23 | Westmoreland | Pennsylvania | 42129 | 50198 | 962 |
1945676 | 1945676 | 2021-11-23 | Wyoming | Pennsylvania | 42131 | 3095 | 68 |
1945677 | 1945677 | 2021-11-23 | York | Pennsylvania | 42133 | 68764 | 1054 |
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);