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-01-19 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2130909 | 2130909 | 2022-01-19 | Adams | Pennsylvania | 42001 | 22126 | 301 |
2130910 | 2130910 | 2022-01-19 | Allegheny | Pennsylvania | 42003 | 233419 | 2848 |
2130911 | 2130911 | 2022-01-19 | Armstrong | Pennsylvania | 42005 | 13762 | 290 |
2130912 | 2130912 | 2022-01-19 | Beaver | Pennsylvania | 42007 | 35004 | 645 |
2130913 | 2130913 | 2022-01-19 | Bedford | Pennsylvania | 42009 | 9701 | 238 |
2130914 | 2130914 | 2022-01-19 | Berks | Pennsylvania | 42011 | 94342 | 1415 |
2130915 | 2130915 | 2022-01-19 | Blair | Pennsylvania | 42013 | 25795 | 537 |
2130916 | 2130916 | 2022-01-19 | Bradford | Pennsylvania | 42015 | 12863 | 176 |
2130917 | 2130917 | 2022-01-19 | Bucks | Pennsylvania | 42017 | 113169 | 1628 |
2130918 | 2130918 | 2022-01-19 | Butler | Pennsylvania | 42019 | 39669 | 647 |
2130919 | 2130919 | 2022-01-19 | Cambria | Pennsylvania | 42021 | 30240 | 646 |
2130920 | 2130920 | 2022-01-19 | Cameron | Pennsylvania | 42023 | 702 | 16 |
2130921 | 2130921 | 2022-01-19 | Carbon | Pennsylvania | 42025 | 14527 | 248 |
2130922 | 2130922 | 2022-01-19 | Centre | Pennsylvania | 42027 | 31031 | 306 |
2130923 | 2130923 | 2022-01-19 | Chester | Pennsylvania | 42029 | 83005 | 1024 |
2130924 | 2130924 | 2022-01-19 | Clarion | Pennsylvania | 42031 | 7365 | 182 |
2130925 | 2130925 | 2022-01-19 | Clearfield | Pennsylvania | 42033 | 16579 | 288 |
2130926 | 2130926 | 2022-01-19 | Clinton | Pennsylvania | 42035 | 7890 | 115 |
2130927 | 2130927 | 2022-01-19 | Columbia | Pennsylvania | 42037 | 12913 | 204 |
2130928 | 2130928 | 2022-01-19 | Crawford | Pennsylvania | 42039 | 17709 | 270 |
2130929 | 2130929 | 2022-01-19 | Cumberland | Pennsylvania | 42041 | 44594 | 760 |
2130930 | 2130930 | 2022-01-19 | Dauphin | Pennsylvania | 42043 | 53531 | 815 |
2130931 | 2130931 | 2022-01-19 | Delaware | Pennsylvania | 42045 | 101525 | 1636 |
2130932 | 2130932 | 2022-01-19 | Elk | Pennsylvania | 42047 | 6237 | 83 |
2130933 | 2130933 | 2022-01-19 | Erie | Pennsylvania | 42049 | 51351 | 654 |
2130934 | 2130934 | 2022-01-19 | Fayette | Pennsylvania | 42051 | 26415 | 564 |
2130935 | 2130935 | 2022-01-19 | Forest | Pennsylvania | 42053 | 2006 | 33 |
2130936 | 2130936 | 2022-01-19 | Franklin | Pennsylvania | 42055 | 35907 | 592 |
2130937 | 2130937 | 2022-01-19 | Fulton | Pennsylvania | 42057 | 3611 | 55 |
2130938 | 2130938 | 2022-01-19 | Greene | Pennsylvania | 42059 | 7254 | 85 |
2130939 | 2130939 | 2022-01-19 | Huntingdon | Pennsylvania | 42061 | 9730 | 213 |
2130940 | 2130940 | 2022-01-19 | Indiana | Pennsylvania | 42063 | 14807 | 316 |
2130941 | 2130941 | 2022-01-19 | Jefferson | Pennsylvania | 42065 | 7741 | 199 |
2130942 | 2130942 | 2022-01-19 | Juniata | Pennsylvania | 42067 | 4207 | 156 |
2130943 | 2130943 | 2022-01-19 | Lackawanna | Pennsylvania | 42069 | 37381 | 630 |
2130944 | 2130944 | 2022-01-19 | Lancaster | Pennsylvania | 42071 | 110532 | 1645 |
2130945 | 2130945 | 2022-01-19 | Lawrence | Pennsylvania | 42073 | 17130 | 358 |
2130946 | 2130946 | 2022-01-19 | Lebanon | Pennsylvania | 42075 | 33446 | 429 |
2130947 | 2130947 | 2022-01-19 | Lehigh | Pennsylvania | 42077 | 83194 | 1109 |
2130948 | 2130948 | 2022-01-19 | Luzerne | Pennsylvania | 42079 | 65931 | 1142 |
2130949 | 2130949 | 2022-01-19 | Lycoming | Pennsylvania | 42081 | 25072 | 469 |
2130950 | 2130950 | 2022-01-19 | McKean | Pennsylvania | 42083 | 7117 | 121 |
2130951 | 2130951 | 2022-01-19 | Mercer | Pennsylvania | 42085 | 21282 | 447 |
2130952 | 2130952 | 2022-01-19 | Mifflin | Pennsylvania | 42087 | 10466 | 249 |
2130953 | 2130953 | 2022-01-19 | Monroe | Pennsylvania | 42089 | 33929 | 446 |
2130954 | 2130954 | 2022-01-19 | Montgomery | Pennsylvania | 42091 | 137628 | 2070 |
2130955 | 2130955 | 2022-01-19 | Montour | Pennsylvania | 42093 | 3889 | 83 |
2130956 | 2130956 | 2022-01-19 | Northampton | Pennsylvania | 42095 | 73679 | 939 |
2130957 | 2130957 | 2022-01-19 | Northumberland | Pennsylvania | 42097 | 19999 | 485 |
2130958 | 2130958 | 2022-01-19 | Perry | Pennsylvania | 42099 | 7813 | 163 |
2130959 | 2130959 | 2022-01-19 | Philadelphia | Pennsylvania | 42101 | 285140 | 4449 |
2130960 | 2130960 | 2022-01-19 | Pike | Pennsylvania | 42103 | 8852 | 79 |
2130961 | 2130961 | 2022-01-19 | Potter | Pennsylvania | 42105 | 2775 | 80 |
2130962 | 2130962 | 2022-01-19 | Schuylkill | Pennsylvania | 42107 | 30646 | 592 |
2130963 | 2130963 | 2022-01-19 | Snyder | Pennsylvania | 42109 | 7119 | 135 |
2130964 | 2130964 | 2022-01-19 | Somerset | Pennsylvania | 42111 | 16375 | 356 |
2130965 | 2130965 | 2022-01-19 | Sullivan | Pennsylvania | 42113 | 934 | 32 |
2130966 | 2130966 | 2022-01-19 | Susquehanna | Pennsylvania | 42115 | 6845 | 96 |
2130967 | 2130967 | 2022-01-19 | Tioga | Pennsylvania | 42117 | 7009 | 177 |
2130968 | 2130968 | 2022-01-19 | Union | Pennsylvania | 42119 | 10310 | 135 |
2130969 | 2130969 | 2022-01-19 | Venango | Pennsylvania | 42121 | 10046 | 211 |
2130970 | 2130970 | 2022-01-19 | Warren | Pennsylvania | 42123 | 6349 | 190 |
2130971 | 2130971 | 2022-01-19 | Washington | Pennsylvania | 42125 | 44612 | 553 |
2130972 | 2130972 | 2022-01-19 | Wayne | Pennsylvania | 42127 | 9046 | 147 |
2130973 | 2130973 | 2022-01-19 | Westmoreland | Pennsylvania | 42129 | 70126 | 1183 |
2130974 | 2130974 | 2022-01-19 | Wyoming | Pennsylvania | 42131 | 4482 | 92 |
2130975 | 2130975 | 2022-01-19 | York | Pennsylvania | 42133 | 106721 | 1290 |
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);