ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-10-15" 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 |
---|---|---|---|---|---|---|---|
633900 | 633900 | 2020-10-15 | Adams | Pennsylvania | 42001 | 962 | 27 |
633901 | 633901 | 2020-10-15 | Allegheny | Pennsylvania | 42003 | 13672 | 397 |
633902 | 633902 | 2020-10-15 | Armstrong | Pennsylvania | 42005 | 539 | 19 |
633903 | 633903 | 2020-10-15 | Beaver | Pennsylvania | 42007 | 2102 | 136 |
633904 | 633904 | 2020-10-15 | Bedford | Pennsylvania | 42009 | 315 | 6 |
633905 | 633905 | 2020-10-15 | Berks | Pennsylvania | 42011 | 8035 | 410 |
633906 | 633906 | 2020-10-15 | Blair | Pennsylvania | 42013 | 950 | 23 |
633907 | 633907 | 2020-10-15 | Bradford | Pennsylvania | 42015 | 415 | 6 |
633908 | 633908 | 2020-10-15 | Bucks | Pennsylvania | 42017 | 9485 | 622 |
633909 | 633909 | 2020-10-15 | Butler | Pennsylvania | 42019 | 1346 | 25 |
633910 | 633910 | 2020-10-15 | Cambria | Pennsylvania | 42021 | 801 | 7 |
633911 | 633911 | 2020-10-15 | Cameron | Pennsylvania | 42023 | 8 | 0 |
633912 | 633912 | 2020-10-15 | Carbon | Pennsylvania | 42025 | 526 | 29 |
633913 | 633913 | 2020-10-15 | Centre | Pennsylvania | 42027 | 3614 | 14 |
633914 | 633914 | 2020-10-15 | Chester | Pennsylvania | 42029 | 7534 | 375 |
633915 | 633915 | 2020-10-15 | Clarion | Pennsylvania | 42031 | 171 | 3 |
633916 | 633916 | 2020-10-15 | Clearfield | Pennsylvania | 42033 | 380 | 7 |
633917 | 633917 | 2020-10-15 | Clinton | Pennsylvania | 42035 | 233 | 6 |
633918 | 633918 | 2020-10-15 | Columbia | Pennsylvania | 42037 | 1013 | 39 |
633919 | 633919 | 2020-10-15 | Crawford | Pennsylvania | 42039 | 366 | 3 |
633920 | 633920 | 2020-10-15 | Cumberland | Pennsylvania | 42041 | 2174 | 77 |
633921 | 633921 | 2020-10-15 | Dauphin | Pennsylvania | 42043 | 4290 | 185 |
633922 | 633922 | 2020-10-15 | Delaware | Pennsylvania | 42045 | 12365 | 800 |
633923 | 633923 | 2020-10-15 | Elk | Pennsylvania | 42047 | 93 | 2 |
633924 | 633924 | 2020-10-15 | Erie | Pennsylvania | 42049 | 1835 | 48 |
633925 | 633925 | 2020-10-15 | Fayette | Pennsylvania | 42051 | 899 | 10 |
633926 | 633926 | 2020-10-15 | Forest | Pennsylvania | 42053 | 17 | 1 |
633927 | 633927 | 2020-10-15 | Franklin | Pennsylvania | 42055 | 1957 | 53 |
633928 | 633928 | 2020-10-15 | Fulton | Pennsylvania | 42057 | 62 | 2 |
633929 | 633929 | 2020-10-15 | Greene | Pennsylvania | 42059 | 208 | 1 |
633930 | 633930 | 2020-10-15 | Huntingdon | Pennsylvania | 42061 | 623 | 8 |
633931 | 633931 | 2020-10-15 | Indiana | Pennsylvania | 42063 | 906 | 14 |
633932 | 633932 | 2020-10-15 | Jefferson | Pennsylvania | 42065 | 141 | 3 |
633933 | 633933 | 2020-10-15 | Juniata | Pennsylvania | 42067 | 205 | 8 |
633934 | 633934 | 2020-10-15 | Lackawanna | Pennsylvania | 42069 | 3125 | 217 |
633935 | 633935 | 2020-10-15 | Lancaster | Pennsylvania | 42071 | 8751 | 467 |
633936 | 633936 | 2020-10-15 | Lawrence | Pennsylvania | 42073 | 681 | 24 |
633937 | 633937 | 2020-10-15 | Lebanon | Pennsylvania | 42075 | 2460 | 65 |
633938 | 633938 | 2020-10-15 | Lehigh | Pennsylvania | 42077 | 6053 | 361 |
633939 | 633939 | 2020-10-15 | Luzerne | Pennsylvania | 42079 | 4550 | 190 |
633940 | 633940 | 2020-10-15 | Lycoming | Pennsylvania | 42081 | 858 | 29 |
633941 | 633941 | 2020-10-15 | McKean | Pennsylvania | 42083 | 84 | 2 |
633942 | 633942 | 2020-10-15 | Mercer | Pennsylvania | 42085 | 862 | 25 |
633943 | 633943 | 2020-10-15 | Mifflin | Pennsylvania | 42087 | 292 | 3 |
633944 | 633944 | 2020-10-15 | Monroe | Pennsylvania | 42089 | 1898 | 134 |
633945 | 633945 | 2020-10-15 | Montgomery | Pennsylvania | 42091 | 12999 | 890 |
633946 | 633946 | 2020-10-15 | Montour | Pennsylvania | 42093 | 254 | 5 |
633947 | 633947 | 2020-10-15 | Northampton | Pennsylvania | 42095 | 4929 | 309 |
633948 | 633948 | 2020-10-15 | Northumberland | Pennsylvania | 42097 | 1302 | 92 |
633949 | 633949 | 2020-10-15 | Perry | Pennsylvania | 42099 | 297 | 6 |
633950 | 633950 | 2020-10-15 | Philadelphia | Pennsylvania | 42101 | 39870 | 1861 |
633951 | 633951 | 2020-10-15 | Pike | Pennsylvania | 42103 | 608 | 23 |
633952 | 633952 | 2020-10-15 | Potter | Pennsylvania | 42105 | 37 | 1 |
633953 | 633953 | 2020-10-15 | Schuylkill | Pennsylvania | 42107 | 1495 | 69 |
633954 | 633954 | 2020-10-15 | Snyder | Pennsylvania | 42109 | 434 | 12 |
633955 | 633955 | 2020-10-15 | Somerset | Pennsylvania | 42111 | 284 | 3 |
633956 | 633956 | 2020-10-15 | Sullivan | Pennsylvania | 42113 | 15 | 1 |
633957 | 633957 | 2020-10-15 | Susquehanna | Pennsylvania | 42115 | 359 | 28 |
633958 | 633958 | 2020-10-15 | Tioga | Pennsylvania | 42117 | 126 | 3 |
633959 | 633959 | 2020-10-15 | Union | Pennsylvania | 42119 | 637 | 7 |
633960 | 633960 | 2020-10-15 | Venango | Pennsylvania | 42121 | 149 | 1 |
633961 | 633961 | 2020-10-15 | Warren | Pennsylvania | 42123 | 58 | 1 |
633962 | 633962 | 2020-10-15 | Washington | Pennsylvania | 42125 | 1577 | 31 |
633963 | 633963 | 2020-10-15 | Wayne | Pennsylvania | 42127 | 273 | 12 |
633964 | 633964 | 2020-10-15 | Westmoreland | Pennsylvania | 42129 | 3201 | 65 |
633965 | 633965 | 2020-10-15 | Wyoming | Pennsylvania | 42131 | 93 | 8 |
633966 | 633966 | 2020-10-15 | York | Pennsylvania | 42133 | 5649 | 185 |
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);