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-01-16 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
935680 | 935680 | 2021-01-16 | Adams | Pennsylvania | 42001 | 5749 | 123 |
935681 | 935681 | 2021-01-16 | Allegheny | Pennsylvania | 42003 | 63884 | 1322 |
935682 | 935682 | 2021-01-16 | Armstrong | Pennsylvania | 42005 | 4257 | 90 |
935683 | 935683 | 2021-01-16 | Beaver | Pennsylvania | 42007 | 10171 | 291 |
935684 | 935684 | 2021-01-16 | Bedford | Pennsylvania | 42009 | 3390 | 110 |
935685 | 935685 | 2021-01-16 | Berks | Pennsylvania | 42011 | 28373 | 685 |
935686 | 935686 | 2021-01-16 | Blair | Pennsylvania | 42013 | 9234 | 208 |
935687 | 935687 | 2021-01-16 | Bradford | Pennsylvania | 42015 | 3577 | 63 |
935688 | 935688 | 2021-01-16 | Bucks | Pennsylvania | 42017 | 36061 | 968 |
935689 | 935689 | 2021-01-16 | Butler | Pennsylvania | 42019 | 11596 | 288 |
935690 | 935690 | 2021-01-16 | Cambria | Pennsylvania | 42021 | 10090 | 324 |
935691 | 935691 | 2021-01-16 | Cameron | Pennsylvania | 42023 | 211 | 6 |
935692 | 935692 | 2021-01-16 | Carbon | Pennsylvania | 42025 | 3815 | 106 |
935693 | 935693 | 2021-01-16 | Centre | Pennsylvania | 42027 | 10112 | 169 |
935694 | 935694 | 2021-01-16 | Chester | Pennsylvania | 42029 | 24645 | 616 |
935695 | 935695 | 2021-01-16 | Clarion | Pennsylvania | 42031 | 2326 | 56 |
935696 | 935696 | 2021-01-16 | Clearfield | Pennsylvania | 42033 | 5068 | 68 |
935697 | 935697 | 2021-01-16 | Clinton | Pennsylvania | 42035 | 2326 | 42 |
935698 | 935698 | 2021-01-16 | Columbia | Pennsylvania | 42037 | 3697 | 97 |
935699 | 935699 | 2021-01-16 | Crawford | Pennsylvania | 42039 | 5539 | 111 |
935700 | 935700 | 2021-01-16 | Cumberland | Pennsylvania | 42041 | 12548 | 367 |
935701 | 935701 | 2021-01-16 | Dauphin | Pennsylvania | 42043 | 16320 | 388 |
935702 | 935702 | 2021-01-16 | Delaware | Pennsylvania | 42045 | 34188 | 1053 |
935703 | 935703 | 2021-01-16 | Elk | Pennsylvania | 42047 | 1924 | 27 |
935704 | 935704 | 2021-01-16 | Erie | Pennsylvania | 42049 | 14009 | 295 |
935705 | 935705 | 2021-01-16 | Fayette | Pennsylvania | 42051 | 8962 | 179 |
935706 | 935706 | 2021-01-16 | Forest | Pennsylvania | 42053 | 585 | 9 |
935707 | 935707 | 2021-01-16 | Franklin | Pennsylvania | 42055 | 10535 | 276 |
935708 | 935708 | 2021-01-16 | Fulton | Pennsylvania | 42057 | 917 | 12 |
935709 | 935709 | 2021-01-16 | Greene | Pennsylvania | 42059 | 2162 | 26 |
935710 | 935710 | 2021-01-16 | Huntingdon | Pennsylvania | 42061 | 3565 | 95 |
935711 | 935711 | 2021-01-16 | Indiana | Pennsylvania | 42063 | 4473 | 140 |
935712 | 935712 | 2021-01-16 | Jefferson | Pennsylvania | 42065 | 2261 | 60 |
935713 | 935713 | 2021-01-16 | Juniata | Pennsylvania | 42067 | 1567 | 70 |
935714 | 935714 | 2021-01-16 | Lackawanna | Pennsylvania | 42069 | 10990 | 301 |
935715 | 935715 | 2021-01-16 | Lancaster | Pennsylvania | 42071 | 33686 | 831 |
935716 | 935716 | 2021-01-16 | Lawrence | Pennsylvania | 42073 | 5032 | 147 |
935717 | 935717 | 2021-01-16 | Lebanon | Pennsylvania | 42075 | 10623 | 193 |
935718 | 935718 | 2021-01-16 | Lehigh | Pennsylvania | 42077 | 25209 | 603 |
935719 | 935719 | 2021-01-16 | Luzerne | Pennsylvania | 42079 | 20438 | 535 |
935720 | 935720 | 2021-01-16 | Lycoming | Pennsylvania | 42081 | 7312 | 175 |
935721 | 935721 | 2021-01-16 | McKean | Pennsylvania | 42083 | 2218 | 46 |
935722 | 935722 | 2021-01-16 | Mercer | Pennsylvania | 42085 | 6960 | 191 |
935723 | 935723 | 2021-01-16 | Mifflin | Pennsylvania | 42087 | 3924 | 135 |
935724 | 935724 | 2021-01-16 | Monroe | Pennsylvania | 42089 | 7616 | 229 |
935725 | 935725 | 2021-01-16 | Montgomery | Pennsylvania | 42091 | 43270 | 1292 |
935726 | 935726 | 2021-01-16 | Montour | Pennsylvania | 42093 | 1392 | 37 |
935727 | 935727 | 2021-01-16 | Northampton | Pennsylvania | 42095 | 20432 | 506 |
935728 | 935728 | 2021-01-16 | Northumberland | Pennsylvania | 42097 | 6090 | 267 |
935729 | 935729 | 2021-01-16 | Perry | Pennsylvania | 42099 | 2183 | 57 |
935730 | 935730 | 2021-01-16 | Philadelphia | Pennsylvania | 42101 | 102837 | 2723 |
935731 | 935731 | 2021-01-16 | Pike | Pennsylvania | 42103 | 1841 | 38 |
935732 | 935732 | 2021-01-16 | Potter | Pennsylvania | 42105 | 756 | 17 |
935733 | 935733 | 2021-01-16 | Schuylkill | Pennsylvania | 42107 | 10098 | 296 |
935734 | 935734 | 2021-01-16 | Snyder | Pennsylvania | 42109 | 2295 | 57 |
935735 | 935735 | 2021-01-16 | Somerset | Pennsylvania | 42111 | 5928 | 142 |
935736 | 935736 | 2021-01-16 | Sullivan | Pennsylvania | 42113 | 200 | 7 |
935737 | 935737 | 2021-01-16 | Susquehanna | Pennsylvania | 42115 | 1306 | 42 |
935738 | 935738 | 2021-01-16 | Tioga | Pennsylvania | 42117 | 2139 | 85 |
935739 | 935739 | 2021-01-16 | Union | Pennsylvania | 42119 | 3647 | 60 |
935740 | 935740 | 2021-01-16 | Venango | Pennsylvania | 42121 | 2877 | 62 |
935741 | 935741 | 2021-01-16 | Warren | Pennsylvania | 42123 | 1845 | 69 |
935742 | 935742 | 2021-01-16 | Washington | Pennsylvania | 42125 | 11260 | 168 |
935743 | 935743 | 2021-01-16 | Wayne | Pennsylvania | 42127 | 2414 | 35 |
935744 | 935744 | 2021-01-16 | Westmoreland | Pennsylvania | 42129 | 23039 | 526 |
935745 | 935745 | 2021-01-16 | Wyoming | Pennsylvania | 42131 | 955 | 34 |
935746 | 935746 | 2021-01-16 | York | Pennsylvania | 42133 | 28125 | 542 |
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);