ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-09-29" 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 |
---|---|---|---|---|---|---|---|
1766892 | 1766892 | 2021-09-29 | Adams | Pennsylvania | 42001 | 11953 | 197 |
1766893 | 1766893 | 2021-09-29 | Allegheny | Pennsylvania | 42003 | 120573 | 2160 |
1766894 | 1766894 | 2021-09-29 | Armstrong | Pennsylvania | 42005 | 7597 | 167 |
1766895 | 1766895 | 2021-09-29 | Beaver | Pennsylvania | 42007 | 19516 | 431 |
1766896 | 1766896 | 2021-09-29 | Bedford | Pennsylvania | 42009 | 5937 | 150 |
1766897 | 1766897 | 2021-09-29 | Berks | Pennsylvania | 42011 | 54514 | 1089 |
1766898 | 1766898 | 2021-09-29 | Blair | Pennsylvania | 42013 | 15433 | 356 |
1766899 | 1766899 | 2021-09-29 | Bradford | Pennsylvania | 42015 | 6915 | 107 |
1766900 | 1766900 | 2021-09-29 | Bucks | Pennsylvania | 42017 | 68881 | 1373 |
1766901 | 1766901 | 2021-09-29 | Butler | Pennsylvania | 42019 | 22254 | 454 |
1766902 | 1766902 | 2021-09-29 | Cambria | Pennsylvania | 42021 | 17266 | 468 |
1766903 | 1766903 | 2021-09-29 | Cameron | Pennsylvania | 42023 | 420 | 10 |
1766904 | 1766904 | 2021-09-29 | Carbon | Pennsylvania | 42025 | 7820 | 186 |
1766905 | 1766905 | 2021-09-29 | Centre | Pennsylvania | 42027 | 19287 | 235 |
1766906 | 1766906 | 2021-09-29 | Chester | Pennsylvania | 42029 | 47387 | 850 |
1766907 | 1766907 | 2021-09-29 | Clarion | Pennsylvania | 42031 | 3989 | 102 |
1766908 | 1766908 | 2021-09-29 | Clearfield | Pennsylvania | 42033 | 10103 | 178 |
1766909 | 1766909 | 2021-09-29 | Clinton | Pennsylvania | 42035 | 4320 | 71 |
1766910 | 1766910 | 2021-09-29 | Columbia | Pennsylvania | 42037 | 6972 | 142 |
1766911 | 1766911 | 2021-09-29 | Crawford | Pennsylvania | 42039 | 9489 | 171 |
1766912 | 1766912 | 2021-09-29 | Cumberland | Pennsylvania | 42041 | 25165 | 566 |
1766913 | 1766913 | 2021-09-29 | Dauphin | Pennsylvania | 42043 | 31496 | 592 |
1766914 | 1766914 | 2021-09-29 | Delaware | Pennsylvania | 42045 | 59037 | 1458 |
1766915 | 1766915 | 2021-09-29 | Elk | Pennsylvania | 42047 | 3593 | 49 |
1766916 | 1766916 | 2021-09-29 | Erie | Pennsylvania | 42049 | 25419 | 452 |
1766917 | 1766917 | 2021-09-29 | Fayette | Pennsylvania | 42051 | 15681 | 351 |
1766918 | 1766918 | 2021-09-29 | Forest | Pennsylvania | 42053 | 1522 | 22 |
1766919 | 1766919 | 2021-09-29 | Franklin | Pennsylvania | 42055 | 19707 | 412 |
1766920 | 1766920 | 2021-09-29 | Fulton | Pennsylvania | 42057 | 1917 | 25 |
1766921 | 1766921 | 2021-09-29 | Greene | Pennsylvania | 42059 | 4230 | 48 |
1766922 | 1766922 | 2021-09-29 | Huntingdon | Pennsylvania | 42061 | 6149 | 144 |
1766923 | 1766923 | 2021-09-29 | Indiana | Pennsylvania | 42063 | 7954 | 194 |
1766924 | 1766924 | 2021-09-29 | Jefferson | Pennsylvania | 42065 | 4139 | 105 |
1766925 | 1766925 | 2021-09-29 | Juniata | Pennsylvania | 42067 | 2605 | 104 |
1766926 | 1766926 | 2021-09-29 | Lackawanna | Pennsylvania | 42069 | 21078 | 501 |
1766927 | 1766927 | 2021-09-29 | Lancaster | Pennsylvania | 42071 | 65403 | 1236 |
1766928 | 1766928 | 2021-09-29 | Lawrence | Pennsylvania | 42073 | 9659 | 241 |
1766929 | 1766929 | 2021-09-29 | Lebanon | Pennsylvania | 42075 | 18923 | 312 |
1766930 | 1766930 | 2021-09-29 | Lehigh | Pennsylvania | 42077 | 45914 | 905 |
1766931 | 1766931 | 2021-09-29 | Luzerne | Pennsylvania | 42079 | 37061 | 869 |
1766932 | 1766932 | 2021-09-29 | Lycoming | Pennsylvania | 42081 | 14311 | 322 |
1766933 | 1766933 | 2021-09-29 | McKean | Pennsylvania | 42083 | 4401 | 76 |
1766934 | 1766934 | 2021-09-29 | Mercer | Pennsylvania | 42085 | 12043 | 294 |
1766935 | 1766935 | 2021-09-29 | Mifflin | Pennsylvania | 42087 | 6312 | 185 |
1766936 | 1766936 | 2021-09-29 | Monroe | Pennsylvania | 42089 | 18118 | 347 |
1766937 | 1766937 | 2021-09-29 | Montgomery | Pennsylvania | 42091 | 80576 | 1788 |
1766938 | 1766938 | 2021-09-29 | Montour | Pennsylvania | 42093 | 2258 | 68 |
1766939 | 1766939 | 2021-09-29 | Northampton | Pennsylvania | 42095 | 42017 | 758 |
1766940 | 1766940 | 2021-09-29 | Northumberland | Pennsylvania | 42097 | 11376 | 385 |
1766941 | 1766941 | 2021-09-29 | Perry | Pennsylvania | 42099 | 4743 | 106 |
1766942 | 1766942 | 2021-09-29 | Philadelphia | Pennsylvania | 42101 | 174141 | 3911 |
1766943 | 1766943 | 2021-09-29 | Pike | Pennsylvania | 42103 | 4858 | 57 |
1766944 | 1766944 | 2021-09-29 | Potter | Pennsylvania | 42105 | 1538 | 29 |
1766945 | 1766945 | 2021-09-29 | Schuylkill | Pennsylvania | 42107 | 17301 | 434 |
1766946 | 1766946 | 2021-09-29 | Snyder | Pennsylvania | 42109 | 4301 | 92 |
1766947 | 1766947 | 2021-09-29 | Somerset | Pennsylvania | 42111 | 9601 | 227 |
1766948 | 1766948 | 2021-09-29 | Sullivan | Pennsylvania | 42113 | 542 | 24 |
1766949 | 1766949 | 2021-09-29 | Susquehanna | Pennsylvania | 42115 | 3196 | 63 |
1766950 | 1766950 | 2021-09-29 | Tioga | Pennsylvania | 42117 | 3933 | 118 |
1766951 | 1766951 | 2021-09-29 | Union | Pennsylvania | 42119 | 6814 | 94 |
1766952 | 1766952 | 2021-09-29 | Venango | Pennsylvania | 42121 | 5238 | 112 |
1766953 | 1766953 | 2021-09-29 | Warren | Pennsylvania | 42123 | 3314 | 115 |
1766954 | 1766954 | 2021-09-29 | Washington | Pennsylvania | 42125 | 22563 | 346 |
1766955 | 1766955 | 2021-09-29 | Wayne | Pennsylvania | 42127 | 5074 | 96 |
1766956 | 1766956 | 2021-09-29 | Westmoreland | Pennsylvania | 42129 | 40668 | 836 |
1766957 | 1766957 | 2021-09-29 | Wyoming | Pennsylvania | 42131 | 2454 | 56 |
1766958 | 1766958 | 2021-09-29 | York | Pennsylvania | 42133 | 56079 | 901 |
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);