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-04-19 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423688 | 2423688 | 2022-04-19 | Adams | Pennsylvania | 42001 | 24814 | 361 |
2423689 | 2423689 | 2022-04-19 | Allegheny | Pennsylvania | 42003 | 265302 | 3309 |
2423690 | 2423690 | 2022-04-19 | Armstrong | Pennsylvania | 42005 | 15277 | 342 |
2423691 | 2423691 | 2022-04-19 | Beaver | Pennsylvania | 42007 | 40227 | 740 |
2423692 | 2423692 | 2022-04-19 | Bedford | Pennsylvania | 42009 | 10975 | 275 |
2423693 | 2423693 | 2022-04-19 | Berks | Pennsylvania | 42011 | 102507 | 1591 |
2423694 | 2423694 | 2022-04-19 | Blair | Pennsylvania | 42013 | 29712 | 613 |
2423695 | 2423695 | 2022-04-19 | Bradford | Pennsylvania | 42015 | 15399 | 202 |
2423696 | 2423696 | 2022-04-19 | Bucks | Pennsylvania | 42017 | 123863 | 1890 |
2423697 | 2423697 | 2022-04-19 | Butler | Pennsylvania | 42019 | 44589 | 734 |
2423698 | 2423698 | 2022-04-19 | Cambria | Pennsylvania | 42021 | 34627 | 726 |
2423699 | 2423699 | 2022-04-19 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2423700 | 2423700 | 2022-04-19 | Carbon | Pennsylvania | 42025 | 15935 | 293 |
2423701 | 2423701 | 2022-04-19 | Centre | Pennsylvania | 42027 | 35388 | 348 |
2423702 | 2423702 | 2022-04-19 | Chester | Pennsylvania | 42029 | 92529 | 1148 |
2423703 | 2423703 | 2022-04-19 | Clarion | Pennsylvania | 42031 | 8241 | 202 |
2423704 | 2423704 | 2022-04-19 | Clearfield | Pennsylvania | 42033 | 19319 | 345 |
2423705 | 2423705 | 2022-04-19 | Clinton | Pennsylvania | 42035 | 9052 | 124 |
2423706 | 2423706 | 2022-04-19 | Columbia | Pennsylvania | 42037 | 15144 | 244 |
2423707 | 2423707 | 2022-04-19 | Crawford | Pennsylvania | 42039 | 19805 | 318 |
2423708 | 2423708 | 2022-04-19 | Cumberland | Pennsylvania | 42041 | 51049 | 891 |
2423709 | 2423709 | 2022-04-19 | Dauphin | Pennsylvania | 42043 | 59164 | 961 |
2423710 | 2423710 | 2022-04-19 | Delaware | Pennsylvania | 42045 | 110730 | 1870 |
2423711 | 2423711 | 2022-04-19 | Elk | Pennsylvania | 42047 | 7135 | 101 |
2423712 | 2423712 | 2022-04-19 | Erie | Pennsylvania | 42049 | 57242 | 758 |
2423713 | 2423713 | 2022-04-19 | Fayette | Pennsylvania | 42051 | 31076 | 670 |
2423714 | 2423714 | 2022-04-19 | Forest | Pennsylvania | 42053 | 2240 | 35 |
2423715 | 2423715 | 2022-04-19 | Franklin | Pennsylvania | 42055 | 40362 | 692 |
2423716 | 2423716 | 2022-04-19 | Fulton | Pennsylvania | 42057 | 4127 | 65 |
2423717 | 2423717 | 2022-04-19 | Greene | Pennsylvania | 42059 | 8461 | 104 |
2423718 | 2423718 | 2022-04-19 | Huntingdon | Pennsylvania | 42061 | 11516 | 244 |
2423719 | 2423719 | 2022-04-19 | Indiana | Pennsylvania | 42063 | 17444 | 354 |
2423720 | 2423720 | 2022-04-19 | Jefferson | Pennsylvania | 42065 | 9016 | 231 |
2423721 | 2423721 | 2022-04-19 | Juniata | Pennsylvania | 42067 | 4768 | 176 |
2423722 | 2423722 | 2022-04-19 | Lackawanna | Pennsylvania | 42069 | 43779 | 768 |
2423723 | 2423723 | 2022-04-19 | Lancaster | Pennsylvania | 42071 | 121270 | 1883 |
2423724 | 2423724 | 2022-04-19 | Lawrence | Pennsylvania | 42073 | 18964 | 414 |
2423725 | 2423725 | 2022-04-19 | Lebanon | Pennsylvania | 42075 | 36626 | 515 |
2423726 | 2423726 | 2022-04-19 | Lehigh | Pennsylvania | 42077 | 89820 | 1235 |
2423727 | 2423727 | 2022-04-19 | Luzerne | Pennsylvania | 42079 | 73729 | 1354 |
2423728 | 2423728 | 2022-04-19 | Lycoming | Pennsylvania | 42081 | 28506 | 514 |
2423729 | 2423729 | 2022-04-19 | McKean | Pennsylvania | 42083 | 8210 | 139 |
2423730 | 2423730 | 2022-04-19 | Mercer | Pennsylvania | 42085 | 23361 | 496 |
2423731 | 2423731 | 2022-04-19 | Mifflin | Pennsylvania | 42087 | 12296 | 276 |
2423732 | 2423732 | 2022-04-19 | Monroe | Pennsylvania | 42089 | 37162 | 519 |
2423733 | 2423733 | 2022-04-19 | Montgomery | Pennsylvania | 42091 | 153749 | 2313 |
2423734 | 2423734 | 2022-04-19 | Montour | Pennsylvania | 42093 | 4538 | 93 |
2423735 | 2423735 | 2022-04-19 | Northampton | Pennsylvania | 42095 | 79966 | 1089 |
2423736 | 2423736 | 2022-04-19 | Northumberland | Pennsylvania | 42097 | 22857 | 530 |
2423737 | 2423737 | 2022-04-19 | Perry | Pennsylvania | 42099 | 8836 | 184 |
2423738 | 2423738 | 2022-04-19 | Philadelphia | Pennsylvania | 42101 | 311553 | 5086 |
2423739 | 2423739 | 2022-04-19 | Pike | Pennsylvania | 42103 | 10269 | 95 |
2423740 | 2423740 | 2022-04-19 | Potter | Pennsylvania | 42105 | 3204 | 92 |
2423741 | 2423741 | 2022-04-19 | Schuylkill | Pennsylvania | 42107 | 34489 | 675 |
2423742 | 2423742 | 2022-04-19 | Snyder | Pennsylvania | 42109 | 8108 | 156 |
2423743 | 2423743 | 2022-04-19 | Somerset | Pennsylvania | 42111 | 18729 | 405 |
2423744 | 2423744 | 2022-04-19 | Sullivan | Pennsylvania | 42113 | 1052 | 36 |
2423745 | 2423745 | 2022-04-19 | Susquehanna | Pennsylvania | 42115 | 7903 | 108 |
2423746 | 2423746 | 2022-04-19 | Tioga | Pennsylvania | 42117 | 8077 | 192 |
2423747 | 2423747 | 2022-04-19 | Union | Pennsylvania | 42119 | 11708 | 154 |
2423748 | 2423748 | 2022-04-19 | Venango | Pennsylvania | 42121 | 11262 | 238 |
2423749 | 2423749 | 2022-04-19 | Warren | Pennsylvania | 42123 | 7347 | 210 |
2423750 | 2423750 | 2022-04-19 | Washington | Pennsylvania | 42125 | 50972 | 651 |
2423751 | 2423751 | 2022-04-19 | Wayne | Pennsylvania | 42127 | 10205 | 169 |
2423752 | 2423752 | 2022-04-19 | Westmoreland | Pennsylvania | 42129 | 79925 | 1372 |
2423753 | 2423753 | 2022-04-19 | Wyoming | Pennsylvania | 42131 | 5095 | 106 |
2423754 | 2423754 | 2022-04-19 | York | Pennsylvania | 42133 | 118900 | 1495 |
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);