ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-10-06" 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 |
---|---|---|---|---|---|---|---|
1789637 | 1789637 | 2021-10-06 | Adams | Pennsylvania | 42001 | 12302 | 205 |
1789638 | 1789638 | 2021-10-06 | Allegheny | Pennsylvania | 42003 | 123164 | 2196 |
1789639 | 1789639 | 2021-10-06 | Armstrong | Pennsylvania | 42005 | 7932 | 176 |
1789640 | 1789640 | 2021-10-06 | Beaver | Pennsylvania | 42007 | 20184 | 437 |
1789641 | 1789641 | 2021-10-06 | Bedford | Pennsylvania | 42009 | 6203 | 155 |
1789642 | 1789642 | 2021-10-06 | Berks | Pennsylvania | 42011 | 55550 | 1099 |
1789643 | 1789643 | 2021-10-06 | Blair | Pennsylvania | 42013 | 15847 | 359 |
1789644 | 1789644 | 2021-10-06 | Bradford | Pennsylvania | 42015 | 7111 | 108 |
1789645 | 1789645 | 2021-10-06 | Bucks | Pennsylvania | 42017 | 70059 | 1382 |
1789646 | 1789646 | 2021-10-06 | Butler | Pennsylvania | 42019 | 23130 | 467 |
1789647 | 1789647 | 2021-10-06 | Cambria | Pennsylvania | 42021 | 17798 | 472 |
1789648 | 1789648 | 2021-10-06 | Cameron | Pennsylvania | 42023 | 429 | 10 |
1789649 | 1789649 | 2021-10-06 | Carbon | Pennsylvania | 42025 | 8112 | 191 |
1789650 | 1789650 | 2021-10-06 | Centre | Pennsylvania | 42027 | 19642 | 237 |
1789651 | 1789651 | 2021-10-06 | Chester | Pennsylvania | 42029 | 48321 | 853 |
1789652 | 1789652 | 2021-10-06 | Clarion | Pennsylvania | 42031 | 4206 | 109 |
1789653 | 1789653 | 2021-10-06 | Clearfield | Pennsylvania | 42033 | 10341 | 180 |
1789654 | 1789654 | 2021-10-06 | Clinton | Pennsylvania | 42035 | 4462 | 71 |
1789655 | 1789655 | 2021-10-06 | Columbia | Pennsylvania | 42037 | 7172 | 143 |
1789656 | 1789656 | 2021-10-06 | Crawford | Pennsylvania | 42039 | 9882 | 172 |
1789657 | 1789657 | 2021-10-06 | Cumberland | Pennsylvania | 42041 | 26041 | 574 |
1789658 | 1789658 | 2021-10-06 | Dauphin | Pennsylvania | 42043 | 32546 | 599 |
1789659 | 1789659 | 2021-10-06 | Delaware | Pennsylvania | 42045 | 59850 | 1466 |
1789660 | 1789660 | 2021-10-06 | Elk | Pennsylvania | 42047 | 3724 | 49 |
1789661 | 1789661 | 2021-10-06 | Erie | Pennsylvania | 42049 | 26436 | 455 |
1789662 | 1789662 | 2021-10-06 | Fayette | Pennsylvania | 42051 | 16140 | 364 |
1789663 | 1789663 | 2021-10-06 | Forest | Pennsylvania | 42053 | 1542 | 23 |
1789664 | 1789664 | 2021-10-06 | Franklin | Pennsylvania | 42055 | 20341 | 423 |
1789665 | 1789665 | 2021-10-06 | Fulton | Pennsylvania | 42057 | 2013 | 26 |
1789666 | 1789666 | 2021-10-06 | Greene | Pennsylvania | 42059 | 4366 | 49 |
1789667 | 1789667 | 2021-10-06 | Huntingdon | Pennsylvania | 42061 | 6320 | 149 |
1789668 | 1789668 | 2021-10-06 | Indiana | Pennsylvania | 42063 | 8184 | 205 |
1789669 | 1789669 | 2021-10-06 | Jefferson | Pennsylvania | 42065 | 4355 | 109 |
1789670 | 1789670 | 2021-10-06 | Juniata | Pennsylvania | 42067 | 2677 | 110 |
1789671 | 1789671 | 2021-10-06 | Lackawanna | Pennsylvania | 42069 | 21535 | 507 |
1789672 | 1789672 | 2021-10-06 | Lancaster | Pennsylvania | 42071 | 66977 | 1255 |
1789673 | 1789673 | 2021-10-06 | Lawrence | Pennsylvania | 42073 | 9954 | 246 |
1789674 | 1789674 | 2021-10-06 | Lebanon | Pennsylvania | 42075 | 19383 | 315 |
1789675 | 1789675 | 2021-10-06 | Lehigh | Pennsylvania | 42077 | 46615 | 914 |
1789676 | 1789676 | 2021-10-06 | Luzerne | Pennsylvania | 42079 | 38103 | 880 |
1789677 | 1789677 | 2021-10-06 | Lycoming | Pennsylvania | 42081 | 14873 | 326 |
1789678 | 1789678 | 2021-10-06 | McKean | Pennsylvania | 42083 | 4607 | 78 |
1789679 | 1789679 | 2021-10-06 | Mercer | Pennsylvania | 42085 | 12479 | 301 |
1789680 | 1789680 | 2021-10-06 | Mifflin | Pennsylvania | 42087 | 6551 | 185 |
1789681 | 1789681 | 2021-10-06 | Monroe | Pennsylvania | 42089 | 18500 | 352 |
1789682 | 1789682 | 2021-10-06 | Montgomery | Pennsylvania | 42091 | 81784 | 1799 |
1789683 | 1789683 | 2021-10-06 | Montour | Pennsylvania | 42093 | 2313 | 69 |
1789684 | 1789684 | 2021-10-06 | Northampton | Pennsylvania | 42095 | 42700 | 765 |
1789685 | 1789685 | 2021-10-06 | Northumberland | Pennsylvania | 42097 | 11696 | 394 |
1789686 | 1789686 | 2021-10-06 | Perry | Pennsylvania | 42099 | 4892 | 110 |
1789687 | 1789687 | 2021-10-06 | Philadelphia | Pennsylvania | 42101 | 176202 | 3927 |
1789688 | 1789688 | 2021-10-06 | Pike | Pennsylvania | 42103 | 4986 | 58 |
1789689 | 1789689 | 2021-10-06 | Potter | Pennsylvania | 42105 | 1641 | 31 |
1789690 | 1789690 | 2021-10-06 | Schuylkill | Pennsylvania | 42107 | 17750 | 440 |
1789691 | 1789691 | 2021-10-06 | Snyder | Pennsylvania | 42109 | 4422 | 94 |
1789692 | 1789692 | 2021-10-06 | Somerset | Pennsylvania | 42111 | 9839 | 233 |
1789693 | 1789693 | 2021-10-06 | Sullivan | Pennsylvania | 42113 | 551 | 24 |
1789694 | 1789694 | 2021-10-06 | Susquehanna | Pennsylvania | 42115 | 3295 | 64 |
1789695 | 1789695 | 2021-10-06 | Tioga | Pennsylvania | 42117 | 4074 | 122 |
1789696 | 1789696 | 2021-10-06 | Union | Pennsylvania | 42119 | 6944 | 95 |
1789697 | 1789697 | 2021-10-06 | Venango | Pennsylvania | 42121 | 5537 | 118 |
1789698 | 1789698 | 2021-10-06 | Warren | Pennsylvania | 42123 | 3480 | 117 |
1789699 | 1789699 | 2021-10-06 | Washington | Pennsylvania | 42125 | 23319 | 358 |
1789700 | 1789700 | 2021-10-06 | Wayne | Pennsylvania | 42127 | 5241 | 100 |
1789701 | 1789701 | 2021-10-06 | Westmoreland | Pennsylvania | 42129 | 41693 | 850 |
1789702 | 1789702 | 2021-10-06 | Wyoming | Pennsylvania | 42131 | 2540 | 57 |
1789703 | 1789703 | 2021-10-06 | York | Pennsylvania | 42133 | 57587 | 915 |
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);