ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2022-03-07 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2283777 | 2283777 | 2022-03-07 | Adams | Pennsylvania | 42001 | 24609 | 354 |
2283778 | 2283778 | 2022-03-07 | Allegheny | Pennsylvania | 42003 | 261495 | 3233 |
2283779 | 2283779 | 2022-03-07 | Armstrong | Pennsylvania | 42005 | 15159 | 334 |
2283780 | 2283780 | 2022-03-07 | Beaver | Pennsylvania | 42007 | 39881 | 712 |
2283781 | 2283781 | 2022-03-07 | Bedford | Pennsylvania | 42009 | 10905 | 271 |
2283782 | 2283782 | 2022-03-07 | Berks | Pennsylvania | 42011 | 101745 | 1576 |
2283783 | 2283783 | 2022-03-07 | Blair | Pennsylvania | 42013 | 29467 | 598 |
2283784 | 2283784 | 2022-03-07 | Bradford | Pennsylvania | 42015 | 14874 | 194 |
2283785 | 2283785 | 2022-03-07 | Bucks | Pennsylvania | 42017 | 122069 | 1847 |
2283786 | 2283786 | 2022-03-07 | Butler | Pennsylvania | 42019 | 44149 | 710 |
2283787 | 2283787 | 2022-03-07 | Cambria | Pennsylvania | 42021 | 34351 | 705 |
2283788 | 2283788 | 2022-03-07 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2283789 | 2283789 | 2022-03-07 | Carbon | Pennsylvania | 42025 | 15769 | 283 |
2283790 | 2283790 | 2022-03-07 | Centre | Pennsylvania | 42027 | 34850 | 344 |
2283791 | 2283791 | 2022-03-07 | Chester | Pennsylvania | 42029 | 90773 | 1122 |
2283792 | 2283792 | 2022-03-07 | Clarion | Pennsylvania | 42031 | 8175 | 198 |
2283793 | 2283793 | 2022-03-07 | Clearfield | Pennsylvania | 42033 | 19126 | 330 |
2283794 | 2283794 | 2022-03-07 | Clinton | Pennsylvania | 42035 | 8992 | 124 |
2283795 | 2283795 | 2022-03-07 | Columbia | Pennsylvania | 42037 | 14941 | 240 |
2283796 | 2283796 | 2022-03-07 | Crawford | Pennsylvania | 42039 | 19676 | 309 |
2283797 | 2283797 | 2022-03-07 | Cumberland | Pennsylvania | 42041 | 50595 | 865 |
2283798 | 2283798 | 2022-03-07 | Dauphin | Pennsylvania | 42043 | 58803 | 937 |
2283799 | 2283799 | 2022-03-07 | Delaware | Pennsylvania | 42045 | 109027 | 1831 |
2283800 | 2283800 | 2022-03-07 | Elk | Pennsylvania | 42047 | 7084 | 96 |
2283801 | 2283801 | 2022-03-07 | Erie | Pennsylvania | 42049 | 56640 | 739 |
2283802 | 2283802 | 2022-03-07 | Fayette | Pennsylvania | 42051 | 30764 | 646 |
2283803 | 2283803 | 2022-03-07 | Forest | Pennsylvania | 42053 | 2231 | 35 |
2283804 | 2283804 | 2022-03-07 | Franklin | Pennsylvania | 42055 | 40123 | 672 |
2283805 | 2283805 | 2022-03-07 | Fulton | Pennsylvania | 42057 | 4091 | 64 |
2283806 | 2283806 | 2022-03-07 | Greene | Pennsylvania | 42059 | 8365 | 100 |
2283807 | 2283807 | 2022-03-07 | Huntingdon | Pennsylvania | 42061 | 11435 | 240 |
2283808 | 2283808 | 2022-03-07 | Indiana | Pennsylvania | 42063 | 17259 | 346 |
2283809 | 2283809 | 2022-03-07 | Jefferson | Pennsylvania | 42065 | 8898 | 222 |
2283810 | 2283810 | 2022-03-07 | Juniata | Pennsylvania | 42067 | 4748 | 174 |
2283811 | 2283811 | 2022-03-07 | Lackawanna | Pennsylvania | 42069 | 42984 | 733 |
2283812 | 2283812 | 2022-03-07 | Lancaster | Pennsylvania | 42071 | 120295 | 1854 |
2283813 | 2283813 | 2022-03-07 | Lawrence | Pennsylvania | 42073 | 18793 | 407 |
2283814 | 2283814 | 2022-03-07 | Lebanon | Pennsylvania | 42075 | 36366 | 505 |
2283815 | 2283815 | 2022-03-07 | Lehigh | Pennsylvania | 42077 | 88899 | 1227 |
2283816 | 2283816 | 2022-03-07 | Luzerne | Pennsylvania | 42079 | 73016 | 1317 |
2283817 | 2283817 | 2022-03-07 | Lycoming | Pennsylvania | 42081 | 28264 | 506 |
2283818 | 2283818 | 2022-03-07 | McKean | Pennsylvania | 42083 | 8095 | 137 |
2283819 | 2283819 | 2022-03-07 | Mercer | Pennsylvania | 42085 | 23202 | 490 |
2283820 | 2283820 | 2022-03-07 | Mifflin | Pennsylvania | 42087 | 12218 | 274 |
2283821 | 2283821 | 2022-03-07 | Monroe | Pennsylvania | 42089 | 36692 | 511 |
2283822 | 2283822 | 2022-03-07 | Montgomery | Pennsylvania | 42091 | 150186 | 2278 |
2283823 | 2283823 | 2022-03-07 | Montour | Pennsylvania | 42093 | 4486 | 91 |
2283824 | 2283824 | 2022-03-07 | Northampton | Pennsylvania | 42095 | 78927 | 1071 |
2283825 | 2283825 | 2022-03-07 | Northumberland | Pennsylvania | 42097 | 22681 | 522 |
2283826 | 2283826 | 2022-03-07 | Perry | Pennsylvania | 42099 | 8787 | 180 |
2283827 | 2283827 | 2022-03-07 | Philadelphia | Pennsylvania | 42101 | 305303 | 5002 |
2283828 | 2283828 | 2022-03-07 | Pike | Pennsylvania | 42103 | 9912 | 92 |
2283829 | 2283829 | 2022-03-07 | Potter | Pennsylvania | 42105 | 3132 | 91 |
2283830 | 2283830 | 2022-03-07 | Schuylkill | Pennsylvania | 42107 | 34219 | 659 |
2283831 | 2283831 | 2022-03-07 | Snyder | Pennsylvania | 42109 | 8049 | 154 |
2283832 | 2283832 | 2022-03-07 | Somerset | Pennsylvania | 42111 | 18621 | 396 |
2283833 | 2283833 | 2022-03-07 | Sullivan | Pennsylvania | 42113 | 1045 | 36 |
2283834 | 2283834 | 2022-03-07 | Susquehanna | Pennsylvania | 42115 | 7647 | 105 |
2283835 | 2283835 | 2022-03-07 | Tioga | Pennsylvania | 42117 | 7888 | 189 |
2283836 | 2283836 | 2022-03-07 | Union | Pennsylvania | 42119 | 11616 | 151 |
2283837 | 2283837 | 2022-03-07 | Venango | Pennsylvania | 42121 | 11191 | 233 |
2283838 | 2283838 | 2022-03-07 | Warren | Pennsylvania | 42123 | 7244 | 207 |
2283839 | 2283839 | 2022-03-07 | Washington | Pennsylvania | 42125 | 50448 | 638 |
2283840 | 2283840 | 2022-03-07 | Wayne | Pennsylvania | 42127 | 10016 | 166 |
2283841 | 2283841 | 2022-03-07 | Westmoreland | Pennsylvania | 42129 | 79204 | 1347 |
2283842 | 2283842 | 2022-03-07 | Wyoming | Pennsylvania | 42131 | 5036 | 100 |
2283843 | 2283843 | 2022-03-07 | York | Pennsylvania | 42133 | 118023 | 1461 |
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);