ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2270766 | 2270766 | 2022-03-03 | Adams | Pennsylvania | 42001 | 24592 | 353 |
2270767 | 2270767 | 2022-03-03 | Allegheny | Pennsylvania | 42003 | 261102 | 3220 |
2270768 | 2270768 | 2022-03-03 | Armstrong | Pennsylvania | 42005 | 15139 | 333 |
2270769 | 2270769 | 2022-03-03 | Beaver | Pennsylvania | 42007 | 39828 | 712 |
2270770 | 2270770 | 2022-03-03 | Bedford | Pennsylvania | 42009 | 10890 | 271 |
2270771 | 2270771 | 2022-03-03 | Berks | Pennsylvania | 42011 | 101645 | 1571 |
2270772 | 2270772 | 2022-03-03 | Blair | Pennsylvania | 42013 | 29429 | 597 |
2270773 | 2270773 | 2022-03-03 | Bradford | Pennsylvania | 42015 | 14846 | 193 |
2270774 | 2270774 | 2022-03-03 | Bucks | Pennsylvania | 42017 | 121952 | 1844 |
2270775 | 2270775 | 2022-03-03 | Butler | Pennsylvania | 42019 | 44079 | 702 |
2270776 | 2270776 | 2022-03-03 | Cambria | Pennsylvania | 42021 | 34314 | 704 |
2270777 | 2270777 | 2022-03-03 | Cameron | Pennsylvania | 42023 | 812 | 19 |
2270778 | 2270778 | 2022-03-03 | Carbon | Pennsylvania | 42025 | 15755 | 283 |
2270779 | 2270779 | 2022-03-03 | Centre | Pennsylvania | 42027 | 34794 | 343 |
2270780 | 2270780 | 2022-03-03 | Chester | Pennsylvania | 42029 | 90651 | 1118 |
2270781 | 2270781 | 2022-03-03 | Clarion | Pennsylvania | 42031 | 8169 | 197 |
2270782 | 2270782 | 2022-03-03 | Clearfield | Pennsylvania | 42033 | 19082 | 329 |
2270783 | 2270783 | 2022-03-03 | Clinton | Pennsylvania | 42035 | 8981 | 124 |
2270784 | 2270784 | 2022-03-03 | Columbia | Pennsylvania | 42037 | 14911 | 239 |
2270785 | 2270785 | 2022-03-03 | Crawford | Pennsylvania | 42039 | 19657 | 309 |
2270786 | 2270786 | 2022-03-03 | Cumberland | Pennsylvania | 42041 | 50516 | 865 |
2270787 | 2270787 | 2022-03-03 | Dauphin | Pennsylvania | 42043 | 58745 | 935 |
2270788 | 2270788 | 2022-03-03 | Delaware | Pennsylvania | 42045 | 108915 | 1826 |
2270789 | 2270789 | 2022-03-03 | Elk | Pennsylvania | 42047 | 7076 | 96 |
2270790 | 2270790 | 2022-03-03 | Erie | Pennsylvania | 42049 | 56557 | 739 |
2270791 | 2270791 | 2022-03-03 | Fayette | Pennsylvania | 42051 | 30717 | 643 |
2270792 | 2270792 | 2022-03-03 | Forest | Pennsylvania | 42053 | 2230 | 35 |
2270793 | 2270793 | 2022-03-03 | Franklin | Pennsylvania | 42055 | 40104 | 669 |
2270794 | 2270794 | 2022-03-03 | Fulton | Pennsylvania | 42057 | 4085 | 64 |
2270795 | 2270795 | 2022-03-03 | Greene | Pennsylvania | 42059 | 8337 | 98 |
2270796 | 2270796 | 2022-03-03 | Huntingdon | Pennsylvania | 42061 | 11416 | 240 |
2270797 | 2270797 | 2022-03-03 | Indiana | Pennsylvania | 42063 | 17225 | 344 |
2270798 | 2270798 | 2022-03-03 | Jefferson | Pennsylvania | 42065 | 8874 | 221 |
2270799 | 2270799 | 2022-03-03 | Juniata | Pennsylvania | 42067 | 4742 | 174 |
2270800 | 2270800 | 2022-03-03 | Lackawanna | Pennsylvania | 42069 | 42896 | 731 |
2270801 | 2270801 | 2022-03-03 | Lancaster | Pennsylvania | 42071 | 120201 | 1847 |
2270802 | 2270802 | 2022-03-03 | Lawrence | Pennsylvania | 42073 | 18771 | 406 |
2270803 | 2270803 | 2022-03-03 | Lebanon | Pennsylvania | 42075 | 36346 | 503 |
2270804 | 2270804 | 2022-03-03 | Lehigh | Pennsylvania | 42077 | 88836 | 1227 |
2270805 | 2270805 | 2022-03-03 | Luzerne | Pennsylvania | 42079 | 72894 | 1313 |
2270806 | 2270806 | 2022-03-03 | Lycoming | Pennsylvania | 42081 | 28240 | 505 |
2270807 | 2270807 | 2022-03-03 | McKean | Pennsylvania | 42083 | 8086 | 137 |
2270808 | 2270808 | 2022-03-03 | Mercer | Pennsylvania | 42085 | 23184 | 487 |
2270809 | 2270809 | 2022-03-03 | Mifflin | Pennsylvania | 42087 | 12200 | 274 |
2270810 | 2270810 | 2022-03-03 | Monroe | Pennsylvania | 42089 | 36666 | 510 |
2270811 | 2270811 | 2022-03-03 | Montgomery | Pennsylvania | 42091 | 149950 | 2273 |
2270812 | 2270812 | 2022-03-03 | Montour | Pennsylvania | 42093 | 4477 | 91 |
2270813 | 2270813 | 2022-03-03 | Northampton | Pennsylvania | 42095 | 78875 | 1068 |
2270814 | 2270814 | 2022-03-03 | Northumberland | Pennsylvania | 42097 | 22663 | 521 |
2270815 | 2270815 | 2022-03-03 | Perry | Pennsylvania | 42099 | 8773 | 180 |
2270816 | 2270816 | 2022-03-03 | Philadelphia | Pennsylvania | 42101 | 304910 | 4993 |
2270817 | 2270817 | 2022-03-03 | Pike | Pennsylvania | 42103 | 9898 | 92 |
2270818 | 2270818 | 2022-03-03 | Potter | Pennsylvania | 42105 | 3127 | 91 |
2270819 | 2270819 | 2022-03-03 | Schuylkill | Pennsylvania | 42107 | 34164 | 658 |
2270820 | 2270820 | 2022-03-03 | Snyder | Pennsylvania | 42109 | 8038 | 151 |
2270821 | 2270821 | 2022-03-03 | Somerset | Pennsylvania | 42111 | 18609 | 396 |
2270822 | 2270822 | 2022-03-03 | Sullivan | Pennsylvania | 42113 | 1044 | 36 |
2270823 | 2270823 | 2022-03-03 | Susquehanna | Pennsylvania | 42115 | 7629 | 105 |
2270824 | 2270824 | 2022-03-03 | Tioga | Pennsylvania | 42117 | 7880 | 189 |
2270825 | 2270825 | 2022-03-03 | Union | Pennsylvania | 42119 | 11581 | 151 |
2270826 | 2270826 | 2022-03-03 | Venango | Pennsylvania | 42121 | 11175 | 231 |
2270827 | 2270827 | 2022-03-03 | Warren | Pennsylvania | 42123 | 7234 | 207 |
2270828 | 2270828 | 2022-03-03 | Washington | Pennsylvania | 42125 | 50385 | 637 |
2270829 | 2270829 | 2022-03-03 | Wayne | Pennsylvania | 42127 | 9998 | 165 |
2270830 | 2270830 | 2022-03-03 | Westmoreland | Pennsylvania | 42129 | 79112 | 1342 |
2270831 | 2270831 | 2022-03-03 | Wyoming | Pennsylvania | 42131 | 5032 | 100 |
2270832 | 2270832 | 2022-03-03 | York | Pennsylvania | 42133 | 117911 | 1459 |
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);