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-04-12 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 |
---|---|---|---|---|---|---|---|
2400897 | 2400897 | 2022-04-12 | Adams | Pennsylvania | 42001 | 24774 | 360 |
2400898 | 2400898 | 2022-04-12 | Allegheny | Pennsylvania | 42003 | 264143 | 3295 |
2400899 | 2400899 | 2022-04-12 | Armstrong | Pennsylvania | 42005 | 15265 | 341 |
2400900 | 2400900 | 2022-04-12 | Beaver | Pennsylvania | 42007 | 40163 | 738 |
2400901 | 2400901 | 2022-04-12 | Bedford | Pennsylvania | 42009 | 10970 | 275 |
2400902 | 2400902 | 2022-04-12 | Berks | Pennsylvania | 42011 | 102326 | 1591 |
2400903 | 2400903 | 2022-04-12 | Blair | Pennsylvania | 42013 | 29665 | 611 |
2400904 | 2400904 | 2022-04-12 | Bradford | Pennsylvania | 42015 | 15239 | 200 |
2400905 | 2400905 | 2022-04-12 | Bucks | Pennsylvania | 42017 | 123401 | 1882 |
2400906 | 2400906 | 2022-04-12 | Butler | Pennsylvania | 42019 | 44473 | 732 |
2400907 | 2400907 | 2022-04-12 | Cambria | Pennsylvania | 42021 | 34574 | 723 |
2400908 | 2400908 | 2022-04-12 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2400909 | 2400909 | 2022-04-12 | Carbon | Pennsylvania | 42025 | 15897 | 293 |
2400910 | 2400910 | 2022-04-12 | Centre | Pennsylvania | 42027 | 35245 | 348 |
2400911 | 2400911 | 2022-04-12 | Chester | Pennsylvania | 42029 | 92032 | 1144 |
2400912 | 2400912 | 2022-04-12 | Clarion | Pennsylvania | 42031 | 8232 | 202 |
2400913 | 2400913 | 2022-04-12 | Clearfield | Pennsylvania | 42033 | 19287 | 345 |
2400914 | 2400914 | 2022-04-12 | Clinton | Pennsylvania | 42035 | 9036 | 124 |
2400915 | 2400915 | 2022-04-12 | Columbia | Pennsylvania | 42037 | 15110 | 243 |
2400916 | 2400916 | 2022-04-12 | Crawford | Pennsylvania | 42039 | 19776 | 315 |
2400917 | 2400917 | 2022-04-12 | Cumberland | Pennsylvania | 42041 | 50953 | 891 |
2400918 | 2400918 | 2022-04-12 | Dauphin | Pennsylvania | 42043 | 59078 | 960 |
2400919 | 2400919 | 2022-04-12 | Delaware | Pennsylvania | 42045 | 110242 | 1868 |
2400920 | 2400920 | 2022-04-12 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2400921 | 2400921 | 2022-04-12 | Erie | Pennsylvania | 42049 | 57138 | 755 |
2400922 | 2400922 | 2022-04-12 | Fayette | Pennsylvania | 42051 | 31037 | 667 |
2400923 | 2400923 | 2022-04-12 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2400924 | 2400924 | 2022-04-12 | Franklin | Pennsylvania | 42055 | 40325 | 692 |
2400925 | 2400925 | 2022-04-12 | Fulton | Pennsylvania | 42057 | 4122 | 65 |
2400926 | 2400926 | 2022-04-12 | Greene | Pennsylvania | 42059 | 8456 | 104 |
2400927 | 2400927 | 2022-04-12 | Huntingdon | Pennsylvania | 42061 | 11507 | 244 |
2400928 | 2400928 | 2022-04-12 | Indiana | Pennsylvania | 42063 | 17415 | 354 |
2400929 | 2400929 | 2022-04-12 | Jefferson | Pennsylvania | 42065 | 9007 | 231 |
2400930 | 2400930 | 2022-04-12 | Juniata | Pennsylvania | 42067 | 4766 | 175 |
2400931 | 2400931 | 2022-04-12 | Lackawanna | Pennsylvania | 42069 | 43548 | 764 |
2400932 | 2400932 | 2022-04-12 | Lancaster | Pennsylvania | 42071 | 121018 | 1880 |
2400933 | 2400933 | 2022-04-12 | Lawrence | Pennsylvania | 42073 | 18945 | 413 |
2400934 | 2400934 | 2022-04-12 | Lebanon | Pennsylvania | 42075 | 36566 | 514 |
2400935 | 2400935 | 2022-04-12 | Lehigh | Pennsylvania | 42077 | 89551 | 1235 |
2400936 | 2400936 | 2022-04-12 | Luzerne | Pennsylvania | 42079 | 73536 | 1346 |
2400937 | 2400937 | 2022-04-12 | Lycoming | Pennsylvania | 42081 | 28446 | 513 |
2400938 | 2400938 | 2022-04-12 | McKean | Pennsylvania | 42083 | 8196 | 138 |
2400939 | 2400939 | 2022-04-12 | Mercer | Pennsylvania | 42085 | 23328 | 496 |
2400940 | 2400940 | 2022-04-12 | Mifflin | Pennsylvania | 42087 | 12279 | 276 |
2400941 | 2400941 | 2022-04-12 | Monroe | Pennsylvania | 42089 | 37024 | 518 |
2400942 | 2400942 | 2022-04-12 | Montgomery | Pennsylvania | 42091 | 152897 | 2310 |
2400943 | 2400943 | 2022-04-12 | Montour | Pennsylvania | 42093 | 4523 | 93 |
2400944 | 2400944 | 2022-04-12 | Northampton | Pennsylvania | 42095 | 79660 | 1086 |
2400945 | 2400945 | 2022-04-12 | Northumberland | Pennsylvania | 42097 | 22829 | 530 |
2400946 | 2400946 | 2022-04-12 | Perry | Pennsylvania | 42099 | 8829 | 184 |
2400947 | 2400947 | 2022-04-12 | Philadelphia | Pennsylvania | 42101 | 309642 | 5080 |
2400948 | 2400948 | 2022-04-12 | Pike | Pennsylvania | 42103 | 10213 | 95 |
2400949 | 2400949 | 2022-04-12 | Potter | Pennsylvania | 42105 | 3194 | 92 |
2400950 | 2400950 | 2022-04-12 | Schuylkill | Pennsylvania | 42107 | 34435 | 674 |
2400951 | 2400951 | 2022-04-12 | Snyder | Pennsylvania | 42109 | 8102 | 156 |
2400952 | 2400952 | 2022-04-12 | Somerset | Pennsylvania | 42111 | 18712 | 405 |
2400953 | 2400953 | 2022-04-12 | Sullivan | Pennsylvania | 42113 | 1050 | 36 |
2400954 | 2400954 | 2022-04-12 | Susquehanna | Pennsylvania | 42115 | 7837 | 108 |
2400955 | 2400955 | 2022-04-12 | Tioga | Pennsylvania | 42117 | 8027 | 192 |
2400956 | 2400956 | 2022-04-12 | Union | Pennsylvania | 42119 | 11691 | 153 |
2400957 | 2400957 | 2022-04-12 | Venango | Pennsylvania | 42121 | 11243 | 238 |
2400958 | 2400958 | 2022-04-12 | Warren | Pennsylvania | 42123 | 7338 | 210 |
2400959 | 2400959 | 2022-04-12 | Washington | Pennsylvania | 42125 | 50872 | 651 |
2400960 | 2400960 | 2022-04-12 | Wayne | Pennsylvania | 42127 | 10151 | 169 |
2400961 | 2400961 | 2022-04-12 | Westmoreland | Pennsylvania | 42129 | 79759 | 1369 |
2400962 | 2400962 | 2022-04-12 | Wyoming | Pennsylvania | 42131 | 5081 | 104 |
2400963 | 2400963 | 2022-04-12 | York | Pennsylvania | 42133 | 118656 | 1491 |
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);