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 2022-01-08 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2095139 | 2095139 | 2022-01-08 | Adams | Pennsylvania | 42001 | 19762 | 289 |
2095140 | 2095140 | 2022-01-08 | Allegheny | Pennsylvania | 42003 | 202490 | 2784 |
2095141 | 2095141 | 2022-01-08 | Armstrong | Pennsylvania | 42005 | 12624 | 281 |
2095142 | 2095142 | 2022-01-08 | Beaver | Pennsylvania | 42007 | 31616 | 624 |
2095143 | 2095143 | 2022-01-08 | Bedford | Pennsylvania | 42009 | 9111 | 233 |
2095144 | 2095144 | 2022-01-08 | Berks | Pennsylvania | 42011 | 84067 | 1366 |
2095145 | 2095145 | 2022-01-08 | Blair | Pennsylvania | 42013 | 23855 | 514 |
2095146 | 2095146 | 2022-01-08 | Bradford | Pennsylvania | 42015 | 11532 | 165 |
2095147 | 2095147 | 2022-01-08 | Bucks | Pennsylvania | 42017 | 102042 | 1582 |
2095148 | 2095148 | 2022-01-08 | Butler | Pennsylvania | 42019 | 35671 | 633 |
2095149 | 2095149 | 2022-01-08 | Cambria | Pennsylvania | 42021 | 26978 | 634 |
2095150 | 2095150 | 2022-01-08 | Cameron | Pennsylvania | 42023 | 670 | 13 |
2095151 | 2095151 | 2022-01-08 | Carbon | Pennsylvania | 42025 | 12805 | 238 |
2095152 | 2095152 | 2022-01-08 | Centre | Pennsylvania | 42027 | 28106 | 298 |
2095153 | 2095153 | 2022-01-08 | Chester | Pennsylvania | 42029 | 74137 | 993 |
2095154 | 2095154 | 2022-01-08 | Clarion | Pennsylvania | 42031 | 6811 | 178 |
2095155 | 2095155 | 2022-01-08 | Clearfield | Pennsylvania | 42033 | 15116 | 268 |
2095156 | 2095156 | 2022-01-08 | Clinton | Pennsylvania | 42035 | 7190 | 110 |
2095157 | 2095157 | 2022-01-08 | Columbia | Pennsylvania | 42037 | 11695 | 196 |
2095158 | 2095158 | 2022-01-08 | Crawford | Pennsylvania | 42039 | 16182 | 264 |
2095159 | 2095159 | 2022-01-08 | Cumberland | Pennsylvania | 42041 | 39720 | 743 |
2095160 | 2095160 | 2022-01-08 | Dauphin | Pennsylvania | 42043 | 48019 | 782 |
2095161 | 2095161 | 2022-01-08 | Delaware | Pennsylvania | 42045 | 90745 | 1604 |
2095162 | 2095162 | 2022-01-08 | Elk | Pennsylvania | 42047 | 5634 | 79 |
2095163 | 2095163 | 2022-01-08 | Erie | Pennsylvania | 42049 | 45638 | 643 |
2095164 | 2095164 | 2022-01-08 | Fayette | Pennsylvania | 42051 | 24309 | 548 |
2095165 | 2095165 | 2022-01-08 | Forest | Pennsylvania | 42053 | 1892 | 33 |
2095166 | 2095166 | 2022-01-08 | Franklin | Pennsylvania | 42055 | 31987 | 571 |
2095167 | 2095167 | 2022-01-08 | Fulton | Pennsylvania | 42057 | 3290 | 51 |
2095168 | 2095168 | 2022-01-08 | Greene | Pennsylvania | 42059 | 6683 | 82 |
2095169 | 2095169 | 2022-01-08 | Huntingdon | Pennsylvania | 42061 | 8876 | 205 |
2095170 | 2095170 | 2022-01-08 | Indiana | Pennsylvania | 42063 | 13346 | 306 |
2095171 | 2095171 | 2022-01-08 | Jefferson | Pennsylvania | 42065 | 7166 | 187 |
2095172 | 2095172 | 2022-01-08 | Juniata | Pennsylvania | 42067 | 3953 | 151 |
2095173 | 2095173 | 2022-01-08 | Lackawanna | Pennsylvania | 42069 | 32861 | 607 |
2095174 | 2095174 | 2022-01-08 | Lancaster | Pennsylvania | 42071 | 99490 | 1592 |
2095175 | 2095175 | 2022-01-08 | Lawrence | Pennsylvania | 42073 | 15637 | 346 |
2095176 | 2095176 | 2022-01-08 | Lebanon | Pennsylvania | 42075 | 29768 | 413 |
2095177 | 2095177 | 2022-01-08 | Lehigh | Pennsylvania | 42077 | 72327 | 1075 |
2095178 | 2095178 | 2022-01-08 | Luzerne | Pennsylvania | 42079 | 58408 | 1105 |
2095179 | 2095179 | 2022-01-08 | Lycoming | Pennsylvania | 42081 | 22856 | 456 |
2095180 | 2095180 | 2022-01-08 | McKean | Pennsylvania | 42083 | 6569 | 118 |
2095181 | 2095181 | 2022-01-08 | Mercer | Pennsylvania | 42085 | 19428 | 437 |
2095182 | 2095182 | 2022-01-08 | Mifflin | Pennsylvania | 42087 | 9626 | 245 |
2095183 | 2095183 | 2022-01-08 | Monroe | Pennsylvania | 42089 | 29517 | 428 |
2095184 | 2095184 | 2022-01-08 | Montgomery | Pennsylvania | 42091 | 122773 | 2027 |
2095185 | 2095185 | 2022-01-08 | Montour | Pennsylvania | 42093 | 3502 | 82 |
2095186 | 2095186 | 2022-01-08 | Northampton | Pennsylvania | 42095 | 65337 | 906 |
2095187 | 2095187 | 2022-01-08 | Northumberland | Pennsylvania | 42097 | 18086 | 479 |
2095188 | 2095188 | 2022-01-08 | Perry | Pennsylvania | 42099 | 7195 | 158 |
2095189 | 2095189 | 2022-01-08 | Philadelphia | Pennsylvania | 42101 | 256404 | 4325 |
2095190 | 2095190 | 2022-01-08 | Pike | Pennsylvania | 42103 | 7901 | 76 |
2095191 | 2095191 | 2022-01-08 | Potter | Pennsylvania | 42105 | 2639 | 80 |
2095192 | 2095192 | 2022-01-08 | Schuylkill | Pennsylvania | 42107 | 27736 | 571 |
2095193 | 2095193 | 2022-01-08 | Snyder | Pennsylvania | 42109 | 6583 | 132 |
2095194 | 2095194 | 2022-01-08 | Somerset | Pennsylvania | 42111 | 14747 | 345 |
2095195 | 2095195 | 2022-01-08 | Sullivan | Pennsylvania | 42113 | 840 | 32 |
2095196 | 2095196 | 2022-01-08 | Susquehanna | Pennsylvania | 42115 | 6324 | 93 |
2095197 | 2095197 | 2022-01-08 | Tioga | Pennsylvania | 42117 | 6506 | 173 |
2095198 | 2095198 | 2022-01-08 | Union | Pennsylvania | 42119 | 9363 | 135 |
2095199 | 2095199 | 2022-01-08 | Venango | Pennsylvania | 42121 | 9322 | 207 |
2095200 | 2095200 | 2022-01-08 | Warren | Pennsylvania | 42123 | 5903 | 184 |
2095201 | 2095201 | 2022-01-08 | Washington | Pennsylvania | 42125 | 39174 | 535 |
2095202 | 2095202 | 2022-01-08 | Wayne | Pennsylvania | 42127 | 8234 | 144 |
2095203 | 2095203 | 2022-01-08 | Westmoreland | Pennsylvania | 42129 | 63379 | 1152 |
2095204 | 2095204 | 2022-01-08 | Wyoming | Pennsylvania | 42131 | 4093 | 92 |
2095205 | 2095205 | 2022-01-08 | York | Pennsylvania | 42133 | 94303 | 1244 |
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);