ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2022-04-27" 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 |
---|---|---|---|---|---|---|---|
2449736 | 2449736 | 2022-04-27 | Adams | Pennsylvania | 42001 | 24888 | 361 |
2449737 | 2449737 | 2022-04-27 | Allegheny | Pennsylvania | 42003 | 267012 | 3312 |
2449738 | 2449738 | 2022-04-27 | Armstrong | Pennsylvania | 42005 | 15312 | 343 |
2449739 | 2449739 | 2022-04-27 | Beaver | Pennsylvania | 42007 | 40370 | 742 |
2449740 | 2449740 | 2022-04-27 | Bedford | Pennsylvania | 42009 | 10986 | 275 |
2449741 | 2449741 | 2022-04-27 | Berks | Pennsylvania | 42011 | 102788 | 1594 |
2449742 | 2449742 | 2022-04-27 | Blair | Pennsylvania | 42013 | 29755 | 614 |
2449743 | 2449743 | 2022-04-27 | Bradford | Pennsylvania | 42015 | 15678 | 205 |
2449744 | 2449744 | 2022-04-27 | Bucks | Pennsylvania | 42017 | 124613 | 1892 |
2449745 | 2449745 | 2022-04-27 | Butler | Pennsylvania | 42019 | 44733 | 740 |
2449746 | 2449746 | 2022-04-27 | Cambria | Pennsylvania | 42021 | 34700 | 730 |
2449747 | 2449747 | 2022-04-27 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2449748 | 2449748 | 2022-04-27 | Carbon | Pennsylvania | 42025 | 15991 | 294 |
2449749 | 2449749 | 2022-04-27 | Centre | Pennsylvania | 42027 | 35552 | 348 |
2449750 | 2449750 | 2022-04-27 | Chester | Pennsylvania | 42029 | 93213 | 1152 |
2449751 | 2449751 | 2022-04-27 | Clarion | Pennsylvania | 42031 | 8252 | 202 |
2449752 | 2449752 | 2022-04-27 | Clearfield | Pennsylvania | 42033 | 19375 | 347 |
2449753 | 2449753 | 2022-04-27 | Clinton | Pennsylvania | 42035 | 9077 | 126 |
2449754 | 2449754 | 2022-04-27 | Columbia | Pennsylvania | 42037 | 15232 | 245 |
2449755 | 2449755 | 2022-04-27 | Crawford | Pennsylvania | 42039 | 19859 | 318 |
2449756 | 2449756 | 2022-04-27 | Cumberland | Pennsylvania | 42041 | 51202 | 891 |
2449757 | 2449757 | 2022-04-27 | Dauphin | Pennsylvania | 42043 | 59275 | 962 |
2449758 | 2449758 | 2022-04-27 | Delaware | Pennsylvania | 42045 | 111435 | 1872 |
2449759 | 2449759 | 2022-04-27 | Elk | Pennsylvania | 42047 | 7141 | 101 |
2449760 | 2449760 | 2022-04-27 | Erie | Pennsylvania | 42049 | 57477 | 759 |
2449761 | 2449761 | 2022-04-27 | Fayette | Pennsylvania | 42051 | 31144 | 670 |
2449762 | 2449762 | 2022-04-27 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2449763 | 2449763 | 2022-04-27 | Franklin | Pennsylvania | 42055 | 40469 | 693 |
2449764 | 2449764 | 2022-04-27 | Fulton | Pennsylvania | 42057 | 4132 | 65 |
2449765 | 2449765 | 2022-04-27 | Greene | Pennsylvania | 42059 | 8475 | 104 |
2449766 | 2449766 | 2022-04-27 | Huntingdon | Pennsylvania | 42061 | 11539 | 246 |
2449767 | 2449767 | 2022-04-27 | Indiana | Pennsylvania | 42063 | 17501 | 355 |
2449768 | 2449768 | 2022-04-27 | Jefferson | Pennsylvania | 42065 | 9055 | 233 |
2449769 | 2449769 | 2022-04-27 | Juniata | Pennsylvania | 42067 | 4772 | 176 |
2449770 | 2449770 | 2022-04-27 | Lackawanna | Pennsylvania | 42069 | 44136 | 771 |
2449771 | 2449771 | 2022-04-27 | Lancaster | Pennsylvania | 42071 | 121638 | 1885 |
2449772 | 2449772 | 2022-04-27 | Lawrence | Pennsylvania | 42073 | 19001 | 415 |
2449773 | 2449773 | 2022-04-27 | Lebanon | Pennsylvania | 42075 | 36708 | 518 |
2449774 | 2449774 | 2022-04-27 | Lehigh | Pennsylvania | 42077 | 90250 | 1239 |
2449775 | 2449775 | 2022-04-27 | Luzerne | Pennsylvania | 42079 | 74058 | 1357 |
2449776 | 2449776 | 2022-04-27 | Lycoming | Pennsylvania | 42081 | 28596 | 516 |
2449777 | 2449777 | 2022-04-27 | McKean | Pennsylvania | 42083 | 8221 | 140 |
2449778 | 2449778 | 2022-04-27 | Mercer | Pennsylvania | 42085 | 23424 | 496 |
2449779 | 2449779 | 2022-04-27 | Mifflin | Pennsylvania | 42087 | 12313 | 276 |
2449780 | 2449780 | 2022-04-27 | Monroe | Pennsylvania | 42089 | 37356 | 521 |
2449781 | 2449781 | 2022-04-27 | Montgomery | Pennsylvania | 42091 | 154866 | 2317 |
2449782 | 2449782 | 2022-04-27 | Montour | Pennsylvania | 42093 | 4559 | 93 |
2449783 | 2449783 | 2022-04-27 | Northampton | Pennsylvania | 42095 | 80408 | 1092 |
2449784 | 2449784 | 2022-04-27 | Northumberland | Pennsylvania | 42097 | 22919 | 533 |
2449785 | 2449785 | 2022-04-27 | Perry | Pennsylvania | 42099 | 8847 | 184 |
2449786 | 2449786 | 2022-04-27 | Philadelphia | Pennsylvania | 42101 | 312875 | 5092 |
2449787 | 2449787 | 2022-04-27 | Pike | Pennsylvania | 42103 | 10354 | 96 |
2449788 | 2449788 | 2022-04-27 | Potter | Pennsylvania | 42105 | 3213 | 92 |
2449789 | 2449789 | 2022-04-27 | Schuylkill | Pennsylvania | 42107 | 34564 | 674 |
2449790 | 2449790 | 2022-04-27 | Snyder | Pennsylvania | 42109 | 8112 | 157 |
2449791 | 2449791 | 2022-04-27 | Somerset | Pennsylvania | 42111 | 18761 | 406 |
2449792 | 2449792 | 2022-04-27 | Sullivan | Pennsylvania | 42113 | 1058 | 36 |
2449793 | 2449793 | 2022-04-27 | Susquehanna | Pennsylvania | 42115 | 7986 | 109 |
2449794 | 2449794 | 2022-04-27 | Tioga | Pennsylvania | 42117 | 8128 | 192 |
2449795 | 2449795 | 2022-04-27 | Union | Pennsylvania | 42119 | 11767 | 154 |
2449796 | 2449796 | 2022-04-27 | Venango | Pennsylvania | 42121 | 11285 | 238 |
2449797 | 2449797 | 2022-04-27 | Warren | Pennsylvania | 42123 | 7392 | 210 |
2449798 | 2449798 | 2022-04-27 | Washington | Pennsylvania | 42125 | 51185 | 652 |
2449799 | 2449799 | 2022-04-27 | Wayne | Pennsylvania | 42127 | 10276 | 170 |
2449800 | 2449800 | 2022-04-27 | Westmoreland | Pennsylvania | 42129 | 80236 | 1373 |
2449801 | 2449801 | 2022-04-27 | Wyoming | Pennsylvania | 42131 | 5150 | 106 |
2449802 | 2449802 | 2022-04-27 | York | Pennsylvania | 42133 | 119253 | 1497 |
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);