ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-12-19" 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 |
---|---|---|---|---|---|---|---|
2030129 | 2030129 | 2021-12-19 | Adams | Pennsylvania | 42001 | 16087 | 261 |
2030130 | 2030130 | 2021-12-19 | Allegheny | Pennsylvania | 42003 | 163022 | 2646 |
2030131 | 2030131 | 2021-12-19 | Armstrong | Pennsylvania | 42005 | 11412 | 259 |
2030132 | 2030132 | 2021-12-19 | Beaver | Pennsylvania | 42007 | 28516 | 572 |
2030133 | 2030133 | 2021-12-19 | Bedford | Pennsylvania | 42009 | 8425 | 212 |
2030134 | 2030134 | 2021-12-19 | Berks | Pennsylvania | 42011 | 71245 | 1266 |
2030135 | 2030135 | 2021-12-19 | Blair | Pennsylvania | 42013 | 22376 | 474 |
2030136 | 2030136 | 2021-12-19 | Bradford | Pennsylvania | 42015 | 10205 | 147 |
2030137 | 2030137 | 2021-12-19 | Bucks | Pennsylvania | 42017 | 85199 | 1521 |
2030138 | 2030138 | 2021-12-19 | Butler | Pennsylvania | 42019 | 31248 | 590 |
2030139 | 2030139 | 2021-12-19 | Cambria | Pennsylvania | 42021 | 24406 | 598 |
2030140 | 2030140 | 2021-12-19 | Cameron | Pennsylvania | 42023 | 633 | 13 |
2030141 | 2030141 | 2021-12-19 | Carbon | Pennsylvania | 42025 | 11095 | 225 |
2030142 | 2030142 | 2021-12-19 | Centre | Pennsylvania | 42027 | 24540 | 275 |
2030143 | 2030143 | 2021-12-19 | Chester | Pennsylvania | 42029 | 60720 | 937 |
2030144 | 2030144 | 2021-12-19 | Clarion | Pennsylvania | 42031 | 6365 | 167 |
2030145 | 2030145 | 2021-12-19 | Clearfield | Pennsylvania | 42033 | 13913 | 249 |
2030146 | 2030146 | 2021-12-19 | Clinton | Pennsylvania | 42035 | 6523 | 99 |
2030147 | 2030147 | 2021-12-19 | Columbia | Pennsylvania | 42037 | 10396 | 181 |
2030148 | 2030148 | 2021-12-19 | Crawford | Pennsylvania | 42039 | 14558 | 245 |
2030149 | 2030149 | 2021-12-19 | Cumberland | Pennsylvania | 42041 | 34436 | 691 |
2030150 | 2030150 | 2021-12-19 | Dauphin | Pennsylvania | 42043 | 41154 | 738 |
2030151 | 2030151 | 2021-12-19 | Delaware | Pennsylvania | 42045 | 70858 | 1556 |
2030152 | 2030152 | 2021-12-19 | Elk | Pennsylvania | 42047 | 5171 | 72 |
2030153 | 2030153 | 2021-12-19 | Erie | Pennsylvania | 42049 | 39401 | 599 |
2030154 | 2030154 | 2021-12-19 | Fayette | Pennsylvania | 42051 | 22159 | 510 |
2030155 | 2030155 | 2021-12-19 | Forest | Pennsylvania | 42053 | 1833 | 31 |
2030156 | 2030156 | 2021-12-19 | Franklin | Pennsylvania | 42055 | 26349 | 522 |
2030157 | 2030157 | 2021-12-19 | Fulton | Pennsylvania | 42057 | 2971 | 42 |
2030158 | 2030158 | 2021-12-19 | Greene | Pennsylvania | 42059 | 6137 | 77 |
2030159 | 2030159 | 2021-12-19 | Huntingdon | Pennsylvania | 42061 | 8191 | 194 |
2030160 | 2030160 | 2021-12-19 | Indiana | Pennsylvania | 42063 | 11936 | 286 |
2030161 | 2030161 | 2021-12-19 | Jefferson | Pennsylvania | 42065 | 6669 | 177 |
2030162 | 2030162 | 2021-12-19 | Juniata | Pennsylvania | 42067 | 3682 | 141 |
2030163 | 2030163 | 2021-12-19 | Lackawanna | Pennsylvania | 42069 | 27781 | 575 |
2030164 | 2030164 | 2021-12-19 | Lancaster | Pennsylvania | 42071 | 85229 | 1496 |
2030165 | 2030165 | 2021-12-19 | Lawrence | Pennsylvania | 42073 | 13815 | 323 |
2030166 | 2030166 | 2021-12-19 | Lebanon | Pennsylvania | 42075 | 25195 | 377 |
2030167 | 2030167 | 2021-12-19 | Lehigh | Pennsylvania | 42077 | 58502 | 1010 |
2030168 | 2030168 | 2021-12-19 | Luzerne | Pennsylvania | 42079 | 50240 | 1036 |
2030169 | 2030169 | 2021-12-19 | Lycoming | Pennsylvania | 42081 | 21025 | 433 |
2030170 | 2030170 | 2021-12-19 | McKean | Pennsylvania | 42083 | 6185 | 111 |
2030171 | 2030171 | 2021-12-19 | Mercer | Pennsylvania | 42085 | 17388 | 398 |
2030172 | 2030172 | 2021-12-19 | Mifflin | Pennsylvania | 42087 | 8888 | 234 |
2030173 | 2030173 | 2021-12-19 | Monroe | Pennsylvania | 42089 | 23979 | 400 |
2030174 | 2030174 | 2021-12-19 | Montgomery | Pennsylvania | 42091 | 100565 | 1957 |
2030175 | 2030175 | 2021-12-19 | Montour | Pennsylvania | 42093 | 3113 | 81 |
2030176 | 2030176 | 2021-12-19 | Northampton | Pennsylvania | 42095 | 53806 | 852 |
2030177 | 2030177 | 2021-12-19 | Northumberland | Pennsylvania | 42097 | 16346 | 455 |
2030178 | 2030178 | 2021-12-19 | Perry | Pennsylvania | 42099 | 6526 | 145 |
2030179 | 2030179 | 2021-12-19 | Philadelphia | Pennsylvania | 42101 | 203281 | 4185 |
2030180 | 2030180 | 2021-12-19 | Pike | Pennsylvania | 42103 | 6690 | 71 |
2030181 | 2030181 | 2021-12-19 | Potter | Pennsylvania | 42105 | 2530 | 73 |
2030182 | 2030182 | 2021-12-19 | Schuylkill | Pennsylvania | 42107 | 24891 | 533 |
2030183 | 2030183 | 2021-12-19 | Snyder | Pennsylvania | 42109 | 5940 | 121 |
2030184 | 2030184 | 2021-12-19 | Somerset | Pennsylvania | 42111 | 13426 | 303 |
2030185 | 2030185 | 2021-12-19 | Sullivan | Pennsylvania | 42113 | 763 | 27 |
2030186 | 2030186 | 2021-12-19 | Susquehanna | Pennsylvania | 42115 | 5325 | 80 |
2030187 | 2030187 | 2021-12-19 | Tioga | Pennsylvania | 42117 | 6011 | 165 |
2030188 | 2030188 | 2021-12-19 | Union | Pennsylvania | 42119 | 8666 | 126 |
2030189 | 2030189 | 2021-12-19 | Venango | Pennsylvania | 42121 | 8776 | 189 |
2030190 | 2030190 | 2021-12-19 | Warren | Pennsylvania | 42123 | 5471 | 173 |
2030191 | 2030191 | 2021-12-19 | Washington | Pennsylvania | 42125 | 33026 | 484 |
2030192 | 2030192 | 2021-12-19 | Wayne | Pennsylvania | 42127 | 7130 | 133 |
2030193 | 2030193 | 2021-12-19 | Westmoreland | Pennsylvania | 42129 | 56487 | 1056 |
2030194 | 2030194 | 2021-12-19 | Wyoming | Pennsylvania | 42131 | 3609 | 79 |
2030195 | 2030195 | 2021-12-19 | York | Pennsylvania | 42133 | 77823 | 1144 |
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);