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-09-06 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1692174 | 1692174 | 2021-09-06 | Adams | Pennsylvania | 42001 | 10799 | 192 |
1692175 | 1692175 | 2021-09-06 | Allegheny | Pennsylvania | 42003 | 111673 | 2083 |
1692176 | 1692176 | 2021-09-06 | Armstrong | Pennsylvania | 42005 | 6550 | 151 |
1692177 | 1692177 | 2021-09-06 | Beaver | Pennsylvania | 42007 | 17278 | 408 |
1692178 | 1692178 | 2021-09-06 | Bedford | Pennsylvania | 42009 | 5106 | 145 |
1692179 | 1692179 | 2021-09-06 | Berks | Pennsylvania | 42011 | 51639 | 1056 |
1692180 | 1692180 | 2021-09-06 | Blair | Pennsylvania | 42013 | 14271 | 346 |
1692181 | 1692181 | 2021-09-06 | Bradford | Pennsylvania | 42015 | 6404 | 100 |
1692182 | 1692182 | 2021-09-06 | Bucks | Pennsylvania | 42017 | 65718 | 1348 |
1692183 | 1692183 | 2021-09-06 | Butler | Pennsylvania | 42019 | 19602 | 433 |
1692184 | 1692184 | 2021-09-06 | Cambria | Pennsylvania | 42021 | 15708 | 451 |
1692185 | 1692185 | 2021-09-06 | Cameron | Pennsylvania | 42023 | 344 | 10 |
1692186 | 1692186 | 2021-09-06 | Carbon | Pennsylvania | 42025 | 6958 | 178 |
1692187 | 1692187 | 2021-09-06 | Centre | Pennsylvania | 42027 | 17993 | 232 |
1692188 | 1692188 | 2021-09-06 | Chester | Pennsylvania | 42029 | 44495 | 839 |
1692189 | 1692189 | 2021-09-06 | Clarion | Pennsylvania | 42031 | 3473 | 99 |
1692190 | 1692190 | 2021-09-06 | Clearfield | Pennsylvania | 42033 | 9379 | 166 |
1692191 | 1692191 | 2021-09-06 | Clinton | Pennsylvania | 42035 | 3959 | 69 |
1692192 | 1692192 | 2021-09-06 | Columbia | Pennsylvania | 42037 | 6405 | 138 |
1692193 | 1692193 | 2021-09-06 | Crawford | Pennsylvania | 42039 | 8273 | 164 |
1692194 | 1692194 | 2021-09-06 | Cumberland | Pennsylvania | 42041 | 22801 | 547 |
1692195 | 1692195 | 2021-09-06 | Dauphin | Pennsylvania | 42043 | 28902 | 578 |
1692196 | 1692196 | 2021-09-06 | Delaware | Pennsylvania | 42045 | 56505 | 1441 |
1692197 | 1692197 | 2021-09-06 | Elk | Pennsylvania | 42047 | 3117 | 43 |
1692198 | 1692198 | 2021-09-06 | Erie | Pennsylvania | 42049 | 23087 | 434 |
1692199 | 1692199 | 2021-09-06 | Fayette | Pennsylvania | 42051 | 14332 | 336 |
1692200 | 1692200 | 2021-09-06 | Forest | Pennsylvania | 42053 | 1470 | 21 |
1692201 | 1692201 | 2021-09-06 | Franklin | Pennsylvania | 42055 | 17195 | 383 |
1692202 | 1692202 | 2021-09-06 | Fulton | Pennsylvania | 42057 | 1572 | 20 |
1692203 | 1692203 | 2021-09-06 | Greene | Pennsylvania | 42059 | 3682 | 44 |
1692204 | 1692204 | 2021-09-06 | Huntingdon | Pennsylvania | 42061 | 5570 | 139 |
1692205 | 1692205 | 2021-09-06 | Indiana | Pennsylvania | 42063 | 7024 | 185 |
1692206 | 1692206 | 2021-09-06 | Jefferson | Pennsylvania | 42065 | 3646 | 100 |
1692207 | 1692207 | 2021-09-06 | Juniata | Pennsylvania | 42067 | 2349 | 90 |
1692208 | 1692208 | 2021-09-06 | Lackawanna | Pennsylvania | 42069 | 19749 | 491 |
1692209 | 1692209 | 2021-09-06 | Lancaster | Pennsylvania | 42071 | 60572 | 1197 |
1692210 | 1692210 | 2021-09-06 | Lawrence | Pennsylvania | 42073 | 8654 | 231 |
1692211 | 1692211 | 2021-09-06 | Lebanon | Pennsylvania | 42075 | 17483 | 305 |
1692212 | 1692212 | 2021-09-06 | Lehigh | Pennsylvania | 42077 | 43344 | 883 |
1692213 | 1692213 | 2021-09-06 | Luzerne | Pennsylvania | 42079 | 34500 | 846 |
1692214 | 1692214 | 2021-09-06 | Lycoming | Pennsylvania | 42081 | 12898 | 306 |
1692215 | 1692215 | 2021-09-06 | McKean | Pennsylvania | 42083 | 4016 | 76 |
1692216 | 1692216 | 2021-09-06 | Mercer | Pennsylvania | 42085 | 10667 | 274 |
1692217 | 1692217 | 2021-09-06 | Mifflin | Pennsylvania | 42087 | 5728 | 183 |
1692218 | 1692218 | 2021-09-06 | Monroe | Pennsylvania | 42089 | 16483 | 332 |
1692219 | 1692219 | 2021-09-06 | Montgomery | Pennsylvania | 42091 | 76629 | 1759 |
1692220 | 1692220 | 2021-09-06 | Montour | Pennsylvania | 42093 | 2120 | 67 |
1692221 | 1692221 | 2021-09-06 | Northampton | Pennsylvania | 42095 | 39402 | 735 |
1692222 | 1692222 | 2021-09-06 | Northumberland | Pennsylvania | 42097 | 10448 | 371 |
1692223 | 1692223 | 2021-09-06 | Perry | Pennsylvania | 42099 | 4240 | 102 |
1692224 | 1692224 | 2021-09-06 | Philadelphia | Pennsylvania | 42101 | 167757 | 3839 |
1692225 | 1692225 | 2021-09-06 | Pike | Pennsylvania | 42103 | 4450 | 55 |
1692226 | 1692226 | 2021-09-06 | Potter | Pennsylvania | 42105 | 1329 | 27 |
1692227 | 1692227 | 2021-09-06 | Schuylkill | Pennsylvania | 42107 | 15875 | 421 |
1692228 | 1692228 | 2021-09-06 | Snyder | Pennsylvania | 42109 | 3915 | 87 |
1692229 | 1692229 | 2021-09-06 | Somerset | Pennsylvania | 42111 | 8645 | 220 |
1692230 | 1692230 | 2021-09-06 | Sullivan | Pennsylvania | 42113 | 482 | 22 |
1692231 | 1692231 | 2021-09-06 | Susquehanna | Pennsylvania | 42115 | 2893 | 62 |
1692232 | 1692232 | 2021-09-06 | Tioga | Pennsylvania | 42117 | 3405 | 114 |
1692233 | 1692233 | 2021-09-06 | Union | Pennsylvania | 42119 | 6414 | 91 |
1692234 | 1692234 | 2021-09-06 | Venango | Pennsylvania | 42121 | 4527 | 106 |
1692235 | 1692235 | 2021-09-06 | Warren | Pennsylvania | 42123 | 2900 | 109 |
1692236 | 1692236 | 2021-09-06 | Washington | Pennsylvania | 42125 | 19843 | 321 |
1692237 | 1692237 | 2021-09-06 | Wayne | Pennsylvania | 42127 | 4605 | 84 |
1692238 | 1692238 | 2021-09-06 | Westmoreland | Pennsylvania | 42129 | 37341 | 804 |
1692239 | 1692239 | 2021-09-06 | Wyoming | Pennsylvania | 42131 | 2185 | 54 |
1692240 | 1692240 | 2021-09-06 | York | Pennsylvania | 42133 | 51406 | 855 |
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);