ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2022-01-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 |
---|---|---|---|---|---|---|---|
2072378 | 2072378 | 2022-01-01 | Adams | Pennsylvania | 42001 | 18458 | 274 |
2072379 | 2072379 | 2022-01-01 | Allegheny | Pennsylvania | 42003 | 179776 | 2725 |
2072380 | 2072380 | 2022-01-01 | Armstrong | Pennsylvania | 42005 | 11982 | 275 |
2072381 | 2072381 | 2022-01-01 | Beaver | Pennsylvania | 42007 | 29879 | 604 |
2072382 | 2072382 | 2022-01-01 | Bedford | Pennsylvania | 42009 | 8797 | 226 |
2072383 | 2072383 | 2022-01-01 | Berks | Pennsylvania | 42011 | 77311 | 1320 |
2072384 | 2072384 | 2022-01-01 | Blair | Pennsylvania | 42013 | 23099 | 499 |
2072385 | 2072385 | 2022-01-01 | Bradford | Pennsylvania | 42015 | 10890 | 154 |
2072386 | 2072386 | 2022-01-01 | Bucks | Pennsylvania | 42017 | 92854 | 1554 |
2072387 | 2072387 | 2022-01-01 | Butler | Pennsylvania | 42019 | 33197 | 614 |
2072388 | 2072388 | 2022-01-01 | Cambria | Pennsylvania | 42021 | 25591 | 621 |
2072389 | 2072389 | 2022-01-01 | Cameron | Pennsylvania | 42023 | 649 | 13 |
2072390 | 2072390 | 2022-01-01 | Carbon | Pennsylvania | 42025 | 11953 | 232 |
2072391 | 2072391 | 2022-01-01 | Centre | Pennsylvania | 42027 | 26495 | 289 |
2072392 | 2072392 | 2022-01-01 | Chester | Pennsylvania | 42029 | 67755 | 967 |
2072393 | 2072393 | 2022-01-01 | Clarion | Pennsylvania | 42031 | 6550 | 171 |
2072394 | 2072394 | 2022-01-01 | Clearfield | Pennsylvania | 42033 | 14538 | 260 |
2072395 | 2072395 | 2022-01-01 | Clinton | Pennsylvania | 42035 | 6844 | 105 |
2072396 | 2072396 | 2022-01-01 | Columbia | Pennsylvania | 42037 | 11061 | 191 |
2072397 | 2072397 | 2022-01-01 | Crawford | Pennsylvania | 42039 | 15298 | 260 |
2072398 | 2072398 | 2022-01-01 | Cumberland | Pennsylvania | 42041 | 37155 | 721 |
2072399 | 2072399 | 2022-01-01 | Dauphin | Pennsylvania | 42043 | 44362 | 758 |
2072400 | 2072400 | 2022-01-01 | Delaware | Pennsylvania | 42045 | 80991 | 1582 |
2072401 | 2072401 | 2022-01-01 | Elk | Pennsylvania | 42047 | 5369 | 76 |
2072402 | 2072402 | 2022-01-01 | Erie | Pennsylvania | 42049 | 42106 | 630 |
2072403 | 2072403 | 2022-01-01 | Fayette | Pennsylvania | 42051 | 23163 | 539 |
2072404 | 2072404 | 2022-01-01 | Forest | Pennsylvania | 42053 | 1857 | 31 |
2072405 | 2072405 | 2022-01-01 | Franklin | Pennsylvania | 42055 | 29845 | 550 |
2072406 | 2072406 | 2022-01-01 | Fulton | Pennsylvania | 42057 | 3151 | 49 |
2072407 | 2072407 | 2022-01-01 | Greene | Pennsylvania | 42059 | 6386 | 80 |
2072408 | 2072408 | 2022-01-01 | Huntingdon | Pennsylvania | 42061 | 8519 | 203 |
2072409 | 2072409 | 2022-01-01 | Indiana | Pennsylvania | 42063 | 12592 | 298 |
2072410 | 2072410 | 2022-01-01 | Jefferson | Pennsylvania | 42065 | 6897 | 185 |
2072411 | 2072411 | 2022-01-01 | Juniata | Pennsylvania | 42067 | 3826 | 147 |
2072412 | 2072412 | 2022-01-01 | Lackawanna | Pennsylvania | 42069 | 30022 | 599 |
2072413 | 2072413 | 2022-01-01 | Lancaster | Pennsylvania | 42071 | 92356 | 1555 |
2072414 | 2072414 | 2022-01-01 | Lawrence | Pennsylvania | 42073 | 14697 | 334 |
2072415 | 2072415 | 2022-01-01 | Lebanon | Pennsylvania | 42075 | 27560 | 400 |
2072416 | 2072416 | 2022-01-01 | Lehigh | Pennsylvania | 42077 | 64637 | 1047 |
2072417 | 2072417 | 2022-01-01 | Luzerne | Pennsylvania | 42079 | 53983 | 1071 |
2072418 | 2072418 | 2022-01-01 | Lycoming | Pennsylvania | 42081 | 21841 | 443 |
2072419 | 2072419 | 2022-01-01 | McKean | Pennsylvania | 42083 | 6340 | 114 |
2072420 | 2072420 | 2022-01-01 | Mercer | Pennsylvania | 42085 | 18306 | 430 |
2072421 | 2072421 | 2022-01-01 | Mifflin | Pennsylvania | 42087 | 9288 | 238 |
2072422 | 2072422 | 2022-01-01 | Monroe | Pennsylvania | 42089 | 26409 | 417 |
2072423 | 2072423 | 2022-01-01 | Montgomery | Pennsylvania | 42091 | 112007 | 1996 |
2072424 | 2072424 | 2022-01-01 | Montour | Pennsylvania | 42093 | 3311 | 81 |
2072425 | 2072425 | 2022-01-01 | Northampton | Pennsylvania | 42095 | 59540 | 882 |
2072426 | 2072426 | 2022-01-01 | Northumberland | Pennsylvania | 42097 | 17173 | 471 |
2072427 | 2072427 | 2022-01-01 | Perry | Pennsylvania | 42099 | 6871 | 154 |
2072428 | 2072428 | 2022-01-01 | Philadelphia | Pennsylvania | 42101 | 228936 | 4258 |
2072429 | 2072429 | 2022-01-01 | Pike | Pennsylvania | 42103 | 7211 | 73 |
2072430 | 2072430 | 2022-01-01 | Potter | Pennsylvania | 42105 | 2581 | 79 |
2072431 | 2072431 | 2022-01-01 | Schuylkill | Pennsylvania | 42107 | 26330 | 554 |
2072432 | 2072432 | 2022-01-01 | Snyder | Pennsylvania | 42109 | 6303 | 127 |
2072433 | 2072433 | 2022-01-01 | Somerset | Pennsylvania | 42111 | 14142 | 330 |
2072434 | 2072434 | 2022-01-01 | Sullivan | Pennsylvania | 42113 | 803 | 28 |
2072435 | 2072435 | 2022-01-01 | Susquehanna | Pennsylvania | 42115 | 5831 | 86 |
2072436 | 2072436 | 2022-01-01 | Tioga | Pennsylvania | 42117 | 6246 | 172 |
2072437 | 2072437 | 2022-01-01 | Union | Pennsylvania | 42119 | 9011 | 133 |
2072438 | 2072438 | 2022-01-01 | Venango | Pennsylvania | 42121 | 8971 | 200 |
2072439 | 2072439 | 2022-01-01 | Warren | Pennsylvania | 42123 | 5612 | 180 |
2072440 | 2072440 | 2022-01-01 | Washington | Pennsylvania | 42125 | 35875 | 513 |
2072441 | 2072441 | 2022-01-01 | Wayne | Pennsylvania | 42127 | 7661 | 140 |
2072442 | 2072442 | 2022-01-01 | Westmoreland | Pennsylvania | 42129 | 59832 | 1121 |
2072443 | 2072443 | 2022-01-01 | Wyoming | Pennsylvania | 42131 | 3841 | 89 |
2072444 | 2072444 | 2022-01-01 | York | Pennsylvania | 42133 | 86890 | 1196 |
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);