ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-06-01" 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 |
---|---|---|---|---|---|---|---|
1377201 | 1377201 | 2021-06-01 | Adams | Pennsylvania | 42001 | 9571 | 183 |
1377202 | 1377202 | 2021-06-01 | Allegheny | Pennsylvania | 42003 | 101336 | 1980 |
1377203 | 1377203 | 2021-06-01 | Armstrong | Pennsylvania | 42005 | 5980 | 144 |
1377204 | 1377204 | 2021-06-01 | Beaver | Pennsylvania | 42007 | 15422 | 383 |
1377205 | 1377205 | 2021-06-01 | Bedford | Pennsylvania | 42009 | 4644 | 138 |
1377206 | 1377206 | 2021-06-01 | Berks | Pennsylvania | 42011 | 48017 | 1031 |
1377207 | 1377207 | 2021-06-01 | Blair | Pennsylvania | 42013 | 13440 | 339 |
1377208 | 1377208 | 2021-06-01 | Bradford | Pennsylvania | 42015 | 6054 | 90 |
1377209 | 1377209 | 2021-06-01 | Bucks | Pennsylvania | 42017 | 60593 | 1301 |
1377210 | 1377210 | 2021-06-01 | Butler | Pennsylvania | 42019 | 17481 | 417 |
1377211 | 1377211 | 2021-06-01 | Cambria | Pennsylvania | 42021 | 14622 | 432 |
1377212 | 1377212 | 2021-06-01 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1377213 | 1377213 | 2021-06-01 | Carbon | Pennsylvania | 42025 | 6362 | 171 |
1377214 | 1377214 | 2021-06-01 | Centre | Pennsylvania | 42027 | 16857 | 224 |
1377215 | 1377215 | 2021-06-01 | Chester | Pennsylvania | 42029 | 40666 | 814 |
1377216 | 1377216 | 2021-06-01 | Clarion | Pennsylvania | 42031 | 3183 | 92 |
1377217 | 1377217 | 2021-06-01 | Clearfield | Pennsylvania | 42033 | 8587 | 147 |
1377218 | 1377218 | 2021-06-01 | Clinton | Pennsylvania | 42035 | 3682 | 66 |
1377219 | 1377219 | 2021-06-01 | Columbia | Pennsylvania | 42037 | 5850 | 133 |
1377220 | 1377220 | 2021-06-01 | Crawford | Pennsylvania | 42039 | 7457 | 151 |
1377221 | 1377221 | 2021-06-01 | Cumberland | Pennsylvania | 42041 | 20417 | 524 |
1377222 | 1377222 | 2021-06-01 | Dauphin | Pennsylvania | 42043 | 25951 | 549 |
1377223 | 1377223 | 2021-06-01 | Delaware | Pennsylvania | 42045 | 52164 | 1446 |
1377224 | 1377224 | 2021-06-01 | Elk | Pennsylvania | 42047 | 2861 | 39 |
1377225 | 1377225 | 2021-06-01 | Erie | Pennsylvania | 42049 | 21041 | 416 |
1377226 | 1377226 | 2021-06-01 | Fayette | Pennsylvania | 42051 | 13217 | 322 |
1377227 | 1377227 | 2021-06-01 | Forest | Pennsylvania | 42053 | 1431 | 21 |
1377228 | 1377228 | 2021-06-01 | Franklin | Pennsylvania | 42055 | 15312 | 370 |
1377229 | 1377229 | 2021-06-01 | Fulton | Pennsylvania | 42057 | 1355 | 15 |
1377230 | 1377230 | 2021-06-01 | Greene | Pennsylvania | 42059 | 3302 | 40 |
1377231 | 1377231 | 2021-06-01 | Huntingdon | Pennsylvania | 42061 | 5111 | 132 |
1377232 | 1377232 | 2021-06-01 | Indiana | Pennsylvania | 42063 | 6351 | 176 |
1377233 | 1377233 | 2021-06-01 | Jefferson | Pennsylvania | 42065 | 3329 | 98 |
1377234 | 1377234 | 2021-06-01 | Juniata | Pennsylvania | 42067 | 2131 | 87 |
1377235 | 1377235 | 2021-06-01 | Lackawanna | Pennsylvania | 42069 | 18443 | 473 |
1377236 | 1377236 | 2021-06-01 | Lancaster | Pennsylvania | 42071 | 55146 | 1154 |
1377237 | 1377237 | 2021-06-01 | Lawrence | Pennsylvania | 42073 | 7586 | 211 |
1377238 | 1377238 | 2021-06-01 | Lebanon | Pennsylvania | 42075 | 16118 | 289 |
1377239 | 1377239 | 2021-06-01 | Lehigh | Pennsylvania | 42077 | 39644 | 853 |
1377240 | 1377240 | 2021-06-01 | Luzerne | Pennsylvania | 42079 | 31811 | 812 |
1377241 | 1377241 | 2021-06-01 | Lycoming | Pennsylvania | 42081 | 11872 | 286 |
1377242 | 1377242 | 2021-06-01 | McKean | Pennsylvania | 42083 | 3771 | 72 |
1377243 | 1377243 | 2021-06-01 | Mercer | Pennsylvania | 42085 | 9612 | 258 |
1377244 | 1377244 | 2021-06-01 | Mifflin | Pennsylvania | 42087 | 5396 | 178 |
1377245 | 1377245 | 2021-06-01 | Monroe | Pennsylvania | 42089 | 14702 | 317 |
1377246 | 1377246 | 2021-06-01 | Montgomery | Pennsylvania | 42091 | 70086 | 1716 |
1377247 | 1377247 | 2021-06-01 | Montour | Pennsylvania | 42093 | 2011 | 66 |
1377248 | 1377248 | 2021-06-01 | Northampton | Pennsylvania | 42095 | 35702 | 711 |
1377249 | 1377249 | 2021-06-01 | Northumberland | Pennsylvania | 42097 | 9624 | 357 |
1377250 | 1377250 | 2021-06-01 | Perry | Pennsylvania | 42099 | 3828 | 100 |
1377251 | 1377251 | 2021-06-01 | Philadelphia | Pennsylvania | 42101 | 153308 | 3669 |
1377252 | 1377252 | 2021-06-01 | Pike | Pennsylvania | 42103 | 3992 | 54 |
1377253 | 1377253 | 2021-06-01 | Potter | Pennsylvania | 42105 | 1182 | 23 |
1377254 | 1377254 | 2021-06-01 | Schuylkill | Pennsylvania | 42107 | 14722 | 408 |
1377255 | 1377255 | 2021-06-01 | Snyder | Pennsylvania | 42109 | 3656 | 85 |
1377256 | 1377256 | 2021-06-01 | Somerset | Pennsylvania | 42111 | 7995 | 212 |
1377257 | 1377257 | 2021-06-01 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1377258 | 1377258 | 2021-06-01 | Susquehanna | Pennsylvania | 42115 | 2634 | 62 |
1377259 | 1377259 | 2021-06-01 | Tioga | Pennsylvania | 42117 | 3053 | 108 |
1377260 | 1377260 | 2021-06-01 | Union | Pennsylvania | 42119 | 6129 | 87 |
1377261 | 1377261 | 2021-06-01 | Venango | Pennsylvania | 42121 | 4057 | 96 |
1377262 | 1377262 | 2021-06-01 | Warren | Pennsylvania | 42123 | 2622 | 103 |
1377263 | 1377263 | 2021-06-01 | Washington | Pennsylvania | 42125 | 17779 | 300 |
1377264 | 1377264 | 2021-06-01 | Wayne | Pennsylvania | 42127 | 4104 | 80 |
1377265 | 1377265 | 2021-06-01 | Westmoreland | Pennsylvania | 42129 | 34129 | 766 |
1377266 | 1377266 | 2021-06-01 | Wyoming | Pennsylvania | 42131 | 1976 | 54 |
1377267 | 1377267 | 2021-06-01 | York | Pennsylvania | 42133 | 46392 | 812 |
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);