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-10-24 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1848122 | 1848122 | 2021-10-24 | Adams | Pennsylvania | 42001 | 13108 | 219 |
1848123 | 1848123 | 2021-10-24 | Allegheny | Pennsylvania | 42003 | 129997 | 2303 |
1848124 | 1848124 | 2021-10-24 | Armstrong | Pennsylvania | 42005 | 8663 | 196 |
1848125 | 1848125 | 2021-10-24 | Beaver | Pennsylvania | 42007 | 21839 | 466 |
1848126 | 1848126 | 2021-10-24 | Bedford | Pennsylvania | 42009 | 6704 | 169 |
1848127 | 1848127 | 2021-10-24 | Berks | Pennsylvania | 42011 | 57978 | 1136 |
1848128 | 1848128 | 2021-10-24 | Blair | Pennsylvania | 42013 | 17104 | 379 |
1848129 | 1848129 | 2021-10-24 | Bradford | Pennsylvania | 42015 | 7598 | 121 |
1848130 | 1848130 | 2021-10-24 | Bucks | Pennsylvania | 42017 | 72754 | 1419 |
1848131 | 1848131 | 2021-10-24 | Butler | Pennsylvania | 42019 | 24753 | 495 |
1848132 | 1848132 | 2021-10-24 | Cambria | Pennsylvania | 42021 | 19111 | 500 |
1848133 | 1848133 | 2021-10-24 | Cameron | Pennsylvania | 42023 | 490 | 11 |
1848134 | 1848134 | 2021-10-24 | Carbon | Pennsylvania | 42025 | 8777 | 200 |
1848135 | 1848135 | 2021-10-24 | Centre | Pennsylvania | 42027 | 20429 | 243 |
1848136 | 1848136 | 2021-10-24 | Chester | Pennsylvania | 42029 | 50406 | 871 |
1848137 | 1848137 | 2021-10-24 | Clarion | Pennsylvania | 42031 | 4732 | 121 |
1848138 | 1848138 | 2021-10-24 | Clearfield | Pennsylvania | 42033 | 11056 | 192 |
1848139 | 1848139 | 2021-10-24 | Clinton | Pennsylvania | 42035 | 4857 | 73 |
1848140 | 1848140 | 2021-10-24 | Columbia | Pennsylvania | 42037 | 7776 | 151 |
1848141 | 1848141 | 2021-10-24 | Crawford | Pennsylvania | 42039 | 10764 | 187 |
1848142 | 1848142 | 2021-10-24 | Cumberland | Pennsylvania | 42041 | 27863 | 611 |
1848143 | 1848143 | 2021-10-24 | Dauphin | Pennsylvania | 42043 | 34421 | 636 |
1848144 | 1848144 | 2021-10-24 | Delaware | Pennsylvania | 42045 | 61759 | 1495 |
1848145 | 1848145 | 2021-10-24 | Elk | Pennsylvania | 42047 | 4060 | 56 |
1848146 | 1848146 | 2021-10-24 | Erie | Pennsylvania | 42049 | 28792 | 482 |
1848147 | 1848147 | 2021-10-24 | Fayette | Pennsylvania | 42051 | 17525 | 396 |
1848148 | 1848148 | 2021-10-24 | Forest | Pennsylvania | 42053 | 1581 | 24 |
1848149 | 1848149 | 2021-10-24 | Franklin | Pennsylvania | 42055 | 21516 | 450 |
1848150 | 1848150 | 2021-10-24 | Fulton | Pennsylvania | 42057 | 2201 | 28 |
1848151 | 1848151 | 2021-10-24 | Greene | Pennsylvania | 42059 | 4779 | 53 |
1848152 | 1848152 | 2021-10-24 | Huntingdon | Pennsylvania | 42061 | 6750 | 156 |
1848153 | 1848153 | 2021-10-24 | Indiana | Pennsylvania | 42063 | 8838 | 223 |
1848154 | 1848154 | 2021-10-24 | Jefferson | Pennsylvania | 42065 | 4875 | 118 |
1848155 | 1848155 | 2021-10-24 | Juniata | Pennsylvania | 42067 | 2848 | 115 |
1848156 | 1848156 | 2021-10-24 | Lackawanna | Pennsylvania | 42069 | 22549 | 515 |
1848157 | 1848157 | 2021-10-24 | Lancaster | Pennsylvania | 42071 | 70666 | 1302 |
1848158 | 1848158 | 2021-10-24 | Lawrence | Pennsylvania | 42073 | 10653 | 261 |
1848159 | 1848159 | 2021-10-24 | Lebanon | Pennsylvania | 42075 | 20397 | 327 |
1848160 | 1848160 | 2021-10-24 | Lehigh | Pennsylvania | 42077 | 48121 | 933 |
1848161 | 1848161 | 2021-10-24 | Luzerne | Pennsylvania | 42079 | 40464 | 916 |
1848162 | 1848162 | 2021-10-24 | Lycoming | Pennsylvania | 42081 | 16098 | 352 |
1848163 | 1848163 | 2021-10-24 | McKean | Pennsylvania | 42083 | 5071 | 87 |
1848164 | 1848164 | 2021-10-24 | Mercer | Pennsylvania | 42085 | 13472 | 322 |
1848165 | 1848165 | 2021-10-24 | Mifflin | Pennsylvania | 42087 | 7159 | 192 |
1848166 | 1848166 | 2021-10-24 | Monroe | Pennsylvania | 42089 | 19472 | 360 |
1848167 | 1848167 | 2021-10-24 | Montgomery | Pennsylvania | 42091 | 85018 | 1840 |
1848168 | 1848168 | 2021-10-24 | Montour | Pennsylvania | 42093 | 2495 | 71 |
1848169 | 1848169 | 2021-10-24 | Northampton | Pennsylvania | 42095 | 44191 | 790 |
1848170 | 1848170 | 2021-10-24 | Northumberland | Pennsylvania | 42097 | 12556 | 399 |
1848171 | 1848171 | 2021-10-24 | Perry | Pennsylvania | 42099 | 5236 | 119 |
1848172 | 1848172 | 2021-10-24 | Philadelphia | Pennsylvania | 42101 | 181075 | 3996 |
1848173 | 1848173 | 2021-10-24 | Pike | Pennsylvania | 42103 | 5340 | 61 |
1848174 | 1848174 | 2021-10-24 | Potter | Pennsylvania | 42105 | 1850 | 45 |
1848175 | 1848175 | 2021-10-24 | Schuylkill | Pennsylvania | 42107 | 18903 | 468 |
1848176 | 1848176 | 2021-10-24 | Snyder | Pennsylvania | 42109 | 4673 | 103 |
1848177 | 1848177 | 2021-10-24 | Somerset | Pennsylvania | 42111 | 10451 | 248 |
1848178 | 1848178 | 2021-10-24 | Sullivan | Pennsylvania | 42113 | 582 | 24 |
1848179 | 1848179 | 2021-10-24 | Susquehanna | Pennsylvania | 42115 | 3615 | 66 |
1848180 | 1848180 | 2021-10-24 | Tioga | Pennsylvania | 42117 | 4450 | 129 |
1848181 | 1848181 | 2021-10-24 | Union | Pennsylvania | 42119 | 7357 | 98 |
1848182 | 1848182 | 2021-10-24 | Venango | Pennsylvania | 42121 | 6236 | 132 |
1848183 | 1848183 | 2021-10-24 | Warren | Pennsylvania | 42123 | 3936 | 123 |
1848184 | 1848184 | 2021-10-24 | Washington | Pennsylvania | 42125 | 25218 | 386 |
1848185 | 1848185 | 2021-10-24 | Wayne | Pennsylvania | 42127 | 5627 | 106 |
1848186 | 1848186 | 2021-10-24 | Westmoreland | Pennsylvania | 42129 | 44363 | 889 |
1848187 | 1848187 | 2021-10-24 | Wyoming | Pennsylvania | 42131 | 2724 | 63 |
1848188 | 1848188 | 2021-10-24 | York | Pennsylvania | 42133 | 61574 | 954 |
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);