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 2021-02-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 |
---|---|---|---|---|---|---|---|
1046028 | 1046028 | 2021-02-19 | Adams | Pennsylvania | 42001 | 7074 | 148 |
1046029 | 1046029 | 2021-02-19 | Allegheny | Pennsylvania | 42003 | 74317 | 1675 |
1046030 | 1046030 | 2021-02-19 | Armstrong | Pennsylvania | 42005 | 4841 | 115 |
1046031 | 1046031 | 2021-02-19 | Beaver | Pennsylvania | 42007 | 11884 | 342 |
1046032 | 1046032 | 2021-02-19 | Bedford | Pennsylvania | 42009 | 3768 | 128 |
1046033 | 1046033 | 2021-02-19 | Berks | Pennsylvania | 42011 | 34859 | 877 |
1046034 | 1046034 | 2021-02-19 | Blair | Pennsylvania | 42013 | 10483 | 292 |
1046035 | 1046035 | 2021-02-19 | Bradford | Pennsylvania | 42015 | 4221 | 74 |
1046036 | 1046036 | 2021-02-19 | Bucks | Pennsylvania | 42017 | 43785 | 1107 |
1046037 | 1046037 | 2021-02-19 | Butler | Pennsylvania | 42019 | 13616 | 360 |
1046038 | 1046038 | 2021-02-19 | Cambria | Pennsylvania | 42021 | 11460 | 387 |
1046039 | 1046039 | 2021-02-19 | Cameron | Pennsylvania | 42023 | 254 | 7 |
1046040 | 1046040 | 2021-02-19 | Carbon | Pennsylvania | 42025 | 4781 | 145 |
1046041 | 1046041 | 2021-02-19 | Centre | Pennsylvania | 42027 | 12519 | 206 |
1046042 | 1046042 | 2021-02-19 | Chester | Pennsylvania | 42029 | 29781 | 711 |
1046043 | 1046043 | 2021-02-19 | Clarion | Pennsylvania | 42031 | 2621 | 81 |
1046044 | 1046044 | 2021-02-19 | Clearfield | Pennsylvania | 42033 | 6106 | 113 |
1046045 | 1046045 | 2021-02-19 | Clinton | Pennsylvania | 42035 | 2681 | 55 |
1046046 | 1046046 | 2021-02-19 | Columbia | Pennsylvania | 42037 | 4520 | 121 |
1046047 | 1046047 | 2021-02-19 | Crawford | Pennsylvania | 42039 | 6257 | 136 |
1046048 | 1046048 | 2021-02-19 | Cumberland | Pennsylvania | 42041 | 15733 | 473 |
1046049 | 1046049 | 2021-02-19 | Dauphin | Pennsylvania | 42043 | 20051 | 483 |
1046050 | 1046050 | 2021-02-19 | Delaware | Pennsylvania | 42045 | 39905 | 1261 |
1046051 | 1046051 | 2021-02-19 | Elk | Pennsylvania | 42047 | 2284 | 35 |
1046052 | 1046052 | 2021-02-19 | Erie | Pennsylvania | 42049 | 16830 | 373 |
1046053 | 1046053 | 2021-02-19 | Fayette | Pennsylvania | 42051 | 10253 | 259 |
1046054 | 1046054 | 2021-02-19 | Forest | Pennsylvania | 42053 | 1372 | 20 |
1046055 | 1046055 | 2021-02-19 | Franklin | Pennsylvania | 42055 | 12275 | 317 |
1046056 | 1046056 | 2021-02-19 | Fulton | Pennsylvania | 42057 | 1113 | 14 |
1046057 | 1046057 | 2021-02-19 | Greene | Pennsylvania | 42059 | 2608 | 30 |
1046058 | 1046058 | 2021-02-19 | Huntingdon | Pennsylvania | 42061 | 4135 | 119 |
1046059 | 1046059 | 2021-02-19 | Indiana | Pennsylvania | 42063 | 5004 | 156 |
1046060 | 1046060 | 2021-02-19 | Jefferson | Pennsylvania | 42065 | 2740 | 85 |
1046061 | 1046061 | 2021-02-19 | Juniata | Pennsylvania | 42067 | 1789 | 80 |
1046062 | 1046062 | 2021-02-19 | Lackawanna | Pennsylvania | 42069 | 13507 | 406 |
1046063 | 1046063 | 2021-02-19 | Lancaster | Pennsylvania | 42071 | 42502 | 998 |
1046064 | 1046064 | 2021-02-19 | Lawrence | Pennsylvania | 42073 | 5895 | 179 |
1046065 | 1046065 | 2021-02-19 | Lebanon | Pennsylvania | 42075 | 12584 | 255 |
1046066 | 1046066 | 2021-02-19 | Lehigh | Pennsylvania | 42077 | 30045 | 743 |
1046067 | 1046067 | 2021-02-19 | Luzerne | Pennsylvania | 42079 | 24386 | 710 |
1046068 | 1046068 | 2021-02-19 | Lycoming | Pennsylvania | 42081 | 8977 | 240 |
1046069 | 1046069 | 2021-02-19 | McKean | Pennsylvania | 42083 | 2994 | 60 |
1046070 | 1046070 | 2021-02-19 | Mercer | Pennsylvania | 42085 | 7908 | 237 |
1046071 | 1046071 | 2021-02-19 | Mifflin | Pennsylvania | 42087 | 4519 | 166 |
1046072 | 1046072 | 2021-02-19 | Monroe | Pennsylvania | 42089 | 9353 | 260 |
1046073 | 1046073 | 2021-02-19 | Montgomery | Pennsylvania | 42091 | 52427 | 1509 |
1046074 | 1046074 | 2021-02-19 | Montour | Pennsylvania | 42093 | 1742 | 57 |
1046075 | 1046075 | 2021-02-19 | Northampton | Pennsylvania | 42095 | 25960 | 626 |
1046076 | 1046076 | 2021-02-19 | Northumberland | Pennsylvania | 42097 | 7834 | 319 |
1046077 | 1046077 | 2021-02-19 | Perry | Pennsylvania | 42099 | 2825 | 82 |
1046078 | 1046078 | 2021-02-19 | Philadelphia | Pennsylvania | 42101 | 116242 | 3071 |
1046079 | 1046079 | 2021-02-19 | Pike | Pennsylvania | 42103 | 2412 | 46 |
1046080 | 1046080 | 2021-02-19 | Potter | Pennsylvania | 42105 | 894 | 21 |
1046081 | 1046081 | 2021-02-19 | Schuylkill | Pennsylvania | 42107 | 11828 | 361 |
1046082 | 1046082 | 2021-02-19 | Snyder | Pennsylvania | 42109 | 2946 | 78 |
1046083 | 1046083 | 2021-02-19 | Somerset | Pennsylvania | 42111 | 6592 | 187 |
1046084 | 1046084 | 2021-02-19 | Sullivan | Pennsylvania | 42113 | 301 | 14 |
1046085 | 1046085 | 2021-02-19 | Susquehanna | Pennsylvania | 42115 | 1663 | 53 |
1046086 | 1046086 | 2021-02-19 | Tioga | Pennsylvania | 42117 | 2403 | 94 |
1046087 | 1046087 | 2021-02-19 | Union | Pennsylvania | 42119 | 5068 | 80 |
1046088 | 1046088 | 2021-02-19 | Venango | Pennsylvania | 42121 | 3281 | 79 |
1046089 | 1046089 | 2021-02-19 | Warren | Pennsylvania | 42123 | 2122 | 96 |
1046090 | 1046090 | 2021-02-19 | Washington | Pennsylvania | 42125 | 13462 | 250 |
1046091 | 1046091 | 2021-02-19 | Wayne | Pennsylvania | 42127 | 2948 | 64 |
1046092 | 1046092 | 2021-02-19 | Westmoreland | Pennsylvania | 42129 | 26177 | 660 |
1046093 | 1046093 | 2021-02-19 | Wyoming | Pennsylvania | 42131 | 1132 | 40 |
1046094 | 1046094 | 2021-02-19 | York | Pennsylvania | 42133 | 34976 | 703 |
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);