ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-12-14" 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 |
---|---|---|---|---|---|---|---|
2013875 | 2013875 | 2021-12-14 | Adams | Pennsylvania | 42001 | 15642 | 254 |
2013876 | 2013876 | 2021-12-14 | Allegheny | Pennsylvania | 42003 | 160084 | 2583 |
2013877 | 2013877 | 2021-12-14 | Armstrong | Pennsylvania | 42005 | 11196 | 250 |
2013878 | 2013878 | 2021-12-14 | Beaver | Pennsylvania | 42007 | 27995 | 555 |
2013879 | 2013879 | 2021-12-14 | Bedford | Pennsylvania | 42009 | 8227 | 202 |
2013880 | 2013880 | 2021-12-14 | Berks | Pennsylvania | 42011 | 69550 | 1244 |
2013881 | 2013881 | 2021-12-14 | Blair | Pennsylvania | 42013 | 22047 | 459 |
2013882 | 2013882 | 2021-12-14 | Bradford | Pennsylvania | 42015 | 9948 | 145 |
2013883 | 2013883 | 2021-12-14 | Bucks | Pennsylvania | 42017 | 83414 | 1509 |
2013884 | 2013884 | 2021-12-14 | Butler | Pennsylvania | 42019 | 30799 | 582 |
2013885 | 2013885 | 2021-12-14 | Cambria | Pennsylvania | 42021 | 24046 | 588 |
2013886 | 2013886 | 2021-12-14 | Cameron | Pennsylvania | 42023 | 618 | 13 |
2013887 | 2013887 | 2021-12-14 | Carbon | Pennsylvania | 42025 | 10816 | 222 |
2013888 | 2013888 | 2021-12-14 | Centre | Pennsylvania | 42027 | 24025 | 270 |
2013889 | 2013889 | 2021-12-14 | Chester | Pennsylvania | 42029 | 59056 | 923 |
2013890 | 2013890 | 2021-12-14 | Clarion | Pennsylvania | 42031 | 6295 | 161 |
2013891 | 2013891 | 2021-12-14 | Clearfield | Pennsylvania | 42033 | 13598 | 241 |
2013892 | 2013892 | 2021-12-14 | Clinton | Pennsylvania | 42035 | 6406 | 98 |
2013893 | 2013893 | 2021-12-14 | Columbia | Pennsylvania | 42037 | 10074 | 172 |
2013894 | 2013894 | 2021-12-14 | Crawford | Pennsylvania | 42039 | 14326 | 235 |
2013895 | 2013895 | 2021-12-14 | Cumberland | Pennsylvania | 42041 | 33647 | 681 |
2013896 | 2013896 | 2021-12-14 | Dauphin | Pennsylvania | 42043 | 40332 | 724 |
2013897 | 2013897 | 2021-12-14 | Delaware | Pennsylvania | 42045 | 69378 | 1541 |
2013898 | 2013898 | 2021-12-14 | Elk | Pennsylvania | 42047 | 5093 | 68 |
2013899 | 2013899 | 2021-12-14 | Erie | Pennsylvania | 42049 | 38694 | 584 |
2013900 | 2013900 | 2021-12-14 | Fayette | Pennsylvania | 42051 | 21796 | 500 |
2013901 | 2013901 | 2021-12-14 | Forest | Pennsylvania | 42053 | 1814 | 30 |
2013902 | 2013902 | 2021-12-14 | Franklin | Pennsylvania | 42055 | 25691 | 511 |
2013903 | 2013903 | 2021-12-14 | Fulton | Pennsylvania | 42057 | 2896 | 40 |
2013904 | 2013904 | 2021-12-14 | Greene | Pennsylvania | 42059 | 6028 | 73 |
2013905 | 2013905 | 2021-12-14 | Huntingdon | Pennsylvania | 42061 | 8068 | 191 |
2013906 | 2013906 | 2021-12-14 | Indiana | Pennsylvania | 42063 | 11743 | 277 |
2013907 | 2013907 | 2021-12-14 | Jefferson | Pennsylvania | 42065 | 6557 | 165 |
2013908 | 2013908 | 2021-12-14 | Juniata | Pennsylvania | 42067 | 3596 | 137 |
2013909 | 2013909 | 2021-12-14 | Lackawanna | Pennsylvania | 42069 | 27095 | 568 |
2013910 | 2013910 | 2021-12-14 | Lancaster | Pennsylvania | 42071 | 83431 | 1471 |
2013911 | 2013911 | 2021-12-14 | Lawrence | Pennsylvania | 42073 | 13563 | 318 |
2013912 | 2013912 | 2021-12-14 | Lebanon | Pennsylvania | 42075 | 24615 | 369 |
2013913 | 2013913 | 2021-12-14 | Lehigh | Pennsylvania | 42077 | 57085 | 994 |
2013914 | 2013914 | 2021-12-14 | Luzerne | Pennsylvania | 42079 | 49135 | 1018 |
2013915 | 2013915 | 2021-12-14 | Lycoming | Pennsylvania | 42081 | 20711 | 424 |
2013916 | 2013916 | 2021-12-14 | McKean | Pennsylvania | 42083 | 6120 | 109 |
2013917 | 2013917 | 2021-12-14 | Mercer | Pennsylvania | 42085 | 17057 | 388 |
2013918 | 2013918 | 2021-12-14 | Mifflin | Pennsylvania | 42087 | 8680 | 231 |
2013919 | 2013919 | 2021-12-14 | Monroe | Pennsylvania | 42089 | 23447 | 396 |
2013920 | 2013920 | 2021-12-14 | Montgomery | Pennsylvania | 42091 | 98316 | 1938 |
2013921 | 2013921 | 2021-12-14 | Montour | Pennsylvania | 42093 | 3030 | 78 |
2013922 | 2013922 | 2021-12-14 | Northampton | Pennsylvania | 42095 | 52376 | 838 |
2013923 | 2013923 | 2021-12-14 | Northumberland | Pennsylvania | 42097 | 15963 | 441 |
2013924 | 2013924 | 2021-12-14 | Perry | Pennsylvania | 42099 | 6407 | 139 |
2013925 | 2013925 | 2021-12-14 | Philadelphia | Pennsylvania | 42101 | 199369 | 4158 |
2013926 | 2013926 | 2021-12-14 | Pike | Pennsylvania | 42103 | 6519 | 71 |
2013927 | 2013927 | 2021-12-14 | Potter | Pennsylvania | 42105 | 2491 | 70 |
2013928 | 2013928 | 2021-12-14 | Schuylkill | Pennsylvania | 42107 | 24267 | 524 |
2013929 | 2013929 | 2021-12-14 | Snyder | Pennsylvania | 42109 | 5773 | 117 |
2013930 | 2013930 | 2021-12-14 | Somerset | Pennsylvania | 42111 | 13170 | 293 |
2013931 | 2013931 | 2021-12-14 | Sullivan | Pennsylvania | 42113 | 742 | 25 |
2013932 | 2013932 | 2021-12-14 | Susquehanna | Pennsylvania | 42115 | 5177 | 79 |
2013933 | 2013933 | 2021-12-14 | Tioga | Pennsylvania | 42117 | 5890 | 162 |
2013934 | 2013934 | 2021-12-14 | Union | Pennsylvania | 42119 | 8560 | 123 |
2013935 | 2013935 | 2021-12-14 | Venango | Pennsylvania | 42121 | 8651 | 184 |
2013936 | 2013936 | 2021-12-14 | Warren | Pennsylvania | 42123 | 5400 | 168 |
2013937 | 2013937 | 2021-12-14 | Washington | Pennsylvania | 42125 | 32322 | 469 |
2013938 | 2013938 | 2021-12-14 | Wayne | Pennsylvania | 42127 | 7008 | 129 |
2013939 | 2013939 | 2021-12-14 | Westmoreland | Pennsylvania | 42129 | 55435 | 1026 |
2013940 | 2013940 | 2021-12-14 | Wyoming | Pennsylvania | 42131 | 3521 | 73 |
2013941 | 2013941 | 2021-12-14 | York | Pennsylvania | 42133 | 75757 | 1112 |
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);