ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-09-02" 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 |
---|---|---|---|---|---|---|---|
1679174 | 1679174 | 2021-09-02 | Adams | Pennsylvania | 42001 | 10645 | 191 |
1679175 | 1679175 | 2021-09-02 | Allegheny | Pennsylvania | 42003 | 110456 | 2076 |
1679176 | 1679176 | 2021-09-02 | Armstrong | Pennsylvania | 42005 | 6434 | 151 |
1679177 | 1679177 | 2021-09-02 | Beaver | Pennsylvania | 42007 | 17059 | 406 |
1679178 | 1679178 | 2021-09-02 | Bedford | Pennsylvania | 42009 | 5045 | 144 |
1679179 | 1679179 | 2021-09-02 | Berks | Pennsylvania | 42011 | 51205 | 1051 |
1679180 | 1679180 | 2021-09-02 | Blair | Pennsylvania | 42013 | 14126 | 346 |
1679181 | 1679181 | 2021-09-02 | Bradford | Pennsylvania | 42015 | 6357 | 100 |
1679182 | 1679182 | 2021-09-02 | Bucks | Pennsylvania | 42017 | 65170 | 1345 |
1679183 | 1679183 | 2021-09-02 | Butler | Pennsylvania | 42019 | 19248 | 430 |
1679184 | 1679184 | 2021-09-02 | Cambria | Pennsylvania | 42021 | 15570 | 449 |
1679185 | 1679185 | 2021-09-02 | Cameron | Pennsylvania | 42023 | 336 | 10 |
1679186 | 1679186 | 2021-09-02 | Carbon | Pennsylvania | 42025 | 6873 | 177 |
1679187 | 1679187 | 2021-09-02 | Centre | Pennsylvania | 42027 | 17766 | 231 |
1679188 | 1679188 | 2021-09-02 | Chester | Pennsylvania | 42029 | 44100 | 838 |
1679189 | 1679189 | 2021-09-02 | Clarion | Pennsylvania | 42031 | 3419 | 99 |
1679190 | 1679190 | 2021-09-02 | Clearfield | Pennsylvania | 42033 | 9264 | 166 |
1679191 | 1679191 | 2021-09-02 | Clinton | Pennsylvania | 42035 | 3927 | 69 |
1679192 | 1679192 | 2021-09-02 | Columbia | Pennsylvania | 42037 | 6323 | 138 |
1679193 | 1679193 | 2021-09-02 | Crawford | Pennsylvania | 42039 | 8156 | 162 |
1679194 | 1679194 | 2021-09-02 | Cumberland | Pennsylvania | 42041 | 22497 | 546 |
1679195 | 1679195 | 2021-09-02 | Dauphin | Pennsylvania | 42043 | 28499 | 578 |
1679196 | 1679196 | 2021-09-02 | Delaware | Pennsylvania | 42045 | 56048 | 1440 |
1679197 | 1679197 | 2021-09-02 | Elk | Pennsylvania | 42047 | 3056 | 43 |
1679198 | 1679198 | 2021-09-02 | Erie | Pennsylvania | 42049 | 22790 | 433 |
1679199 | 1679199 | 2021-09-02 | Fayette | Pennsylvania | 42051 | 14231 | 335 |
1679200 | 1679200 | 2021-09-02 | Forest | Pennsylvania | 42053 | 1468 | 21 |
1679201 | 1679201 | 2021-09-02 | Franklin | Pennsylvania | 42055 | 16925 | 381 |
1679202 | 1679202 | 2021-09-02 | Fulton | Pennsylvania | 42057 | 1529 | 19 |
1679203 | 1679203 | 2021-09-02 | Greene | Pennsylvania | 42059 | 3643 | 43 |
1679204 | 1679204 | 2021-09-02 | Huntingdon | Pennsylvania | 42061 | 5502 | 137 |
1679205 | 1679205 | 2021-09-02 | Indiana | Pennsylvania | 42063 | 6928 | 184 |
1679206 | 1679206 | 2021-09-02 | Jefferson | Pennsylvania | 42065 | 3586 | 100 |
1679207 | 1679207 | 2021-09-02 | Juniata | Pennsylvania | 42067 | 2313 | 90 |
1679208 | 1679208 | 2021-09-02 | Lackawanna | Pennsylvania | 42069 | 19584 | 491 |
1679209 | 1679209 | 2021-09-02 | Lancaster | Pennsylvania | 42071 | 59796 | 1195 |
1679210 | 1679210 | 2021-09-02 | Lawrence | Pennsylvania | 42073 | 8500 | 230 |
1679211 | 1679211 | 2021-09-02 | Lebanon | Pennsylvania | 42075 | 17261 | 305 |
1679212 | 1679212 | 2021-09-02 | Lehigh | Pennsylvania | 42077 | 42925 | 883 |
1679213 | 1679213 | 2021-09-02 | Luzerne | Pennsylvania | 42079 | 34193 | 843 |
1679214 | 1679214 | 2021-09-02 | Lycoming | Pennsylvania | 42081 | 12745 | 304 |
1679215 | 1679215 | 2021-09-02 | McKean | Pennsylvania | 42083 | 3980 | 75 |
1679216 | 1679216 | 2021-09-02 | Mercer | Pennsylvania | 42085 | 10490 | 273 |
1679217 | 1679217 | 2021-09-02 | Mifflin | Pennsylvania | 42087 | 5679 | 183 |
1679218 | 1679218 | 2021-09-02 | Monroe | Pennsylvania | 42089 | 16265 | 330 |
1679219 | 1679219 | 2021-09-02 | Montgomery | Pennsylvania | 42091 | 75981 | 1758 |
1679220 | 1679220 | 2021-09-02 | Montour | Pennsylvania | 42093 | 2096 | 67 |
1679221 | 1679221 | 2021-09-02 | Northampton | Pennsylvania | 42095 | 38982 | 735 |
1679222 | 1679222 | 2021-09-02 | Northumberland | Pennsylvania | 42097 | 10308 | 367 |
1679223 | 1679223 | 2021-09-02 | Perry | Pennsylvania | 42099 | 4159 | 102 |
1679224 | 1679224 | 2021-09-02 | Philadelphia | Pennsylvania | 42101 | 166713 | 3834 |
1679225 | 1679225 | 2021-09-02 | Pike | Pennsylvania | 42103 | 4409 | 55 |
1679226 | 1679226 | 2021-09-02 | Potter | Pennsylvania | 42105 | 1315 | 26 |
1679227 | 1679227 | 2021-09-02 | Schuylkill | Pennsylvania | 42107 | 15696 | 421 |
1679228 | 1679228 | 2021-09-02 | Snyder | Pennsylvania | 42109 | 3883 | 87 |
1679229 | 1679229 | 2021-09-02 | Somerset | Pennsylvania | 42111 | 8561 | 220 |
1679230 | 1679230 | 2021-09-02 | Sullivan | Pennsylvania | 42113 | 470 | 21 |
1679231 | 1679231 | 2021-09-02 | Susquehanna | Pennsylvania | 42115 | 2859 | 62 |
1679232 | 1679232 | 2021-09-02 | Tioga | Pennsylvania | 42117 | 3318 | 114 |
1679233 | 1679233 | 2021-09-02 | Union | Pennsylvania | 42119 | 6367 | 90 |
1679234 | 1679234 | 2021-09-02 | Venango | Pennsylvania | 42121 | 4455 | 106 |
1679235 | 1679235 | 2021-09-02 | Warren | Pennsylvania | 42123 | 2852 | 107 |
1679236 | 1679236 | 2021-09-02 | Washington | Pennsylvania | 42125 | 19576 | 320 |
1679237 | 1679237 | 2021-09-02 | Wayne | Pennsylvania | 42127 | 4549 | 84 |
1679238 | 1679238 | 2021-09-02 | Westmoreland | Pennsylvania | 42129 | 36940 | 802 |
1679239 | 1679239 | 2021-09-02 | Wyoming | Pennsylvania | 42131 | 2156 | 54 |
1679240 | 1679240 | 2021-09-02 | York | Pennsylvania | 42133 | 50727 | 852 |
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);