ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-06-09" 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 |
---|---|---|---|---|---|---|---|
223663 | 223663 | 2020-06-09 | Adams | Pennsylvania | 42001 | 275 | 9 |
223664 | 223664 | 2020-06-09 | Allegheny | Pennsylvania | 42003 | 2027 | 169 |
223665 | 223665 | 2020-06-09 | Armstrong | Pennsylvania | 42005 | 65 | 5 |
223666 | 223666 | 2020-06-09 | Beaver | Pennsylvania | 42007 | 608 | 74 |
223667 | 223667 | 2020-06-09 | Bedford | Pennsylvania | 42009 | 45 | 2 |
223668 | 223668 | 2020-06-09 | Berks | Pennsylvania | 42011 | 4236 | 334 |
223669 | 223669 | 2020-06-09 | Blair | Pennsylvania | 42013 | 53 | 1 |
223670 | 223670 | 2020-06-09 | Bradford | Pennsylvania | 42015 | 46 | 3 |
223671 | 223671 | 2020-06-09 | Bucks | Pennsylvania | 42017 | 5304 | 532 |
223672 | 223672 | 2020-06-09 | Butler | Pennsylvania | 42019 | 249 | 12 |
223673 | 223673 | 2020-06-09 | Cambria | Pennsylvania | 42021 | 60 | 2 |
223674 | 223674 | 2020-06-09 | Cameron | Pennsylvania | 42023 | 2 | 0 |
223675 | 223675 | 2020-06-09 | Carbon | Pennsylvania | 42025 | 253 | 24 |
223676 | 223676 | 2020-06-09 | Centre | Pennsylvania | 42027 | 157 | 7 |
223677 | 223677 | 2020-06-09 | Chester | Pennsylvania | 42029 | 3172 | 303 |
223678 | 223678 | 2020-06-09 | Clarion | Pennsylvania | 42031 | 29 | 2 |
223679 | 223679 | 2020-06-09 | Clearfield | Pennsylvania | 42033 | 48 | 0 |
223680 | 223680 | 2020-06-09 | Clinton | Pennsylvania | 42035 | 61 | 3 |
223681 | 223681 | 2020-06-09 | Columbia | Pennsylvania | 42037 | 367 | 31 |
223682 | 223682 | 2020-06-09 | Crawford | Pennsylvania | 42039 | 31 | 0 |
223683 | 223683 | 2020-06-09 | Cumberland | Pennsylvania | 42041 | 683 | 58 |
223684 | 223684 | 2020-06-09 | Dauphin | Pennsylvania | 42043 | 1525 | 96 |
223685 | 223685 | 2020-06-09 | Delaware | Pennsylvania | 42045 | 6789 | 652 |
223686 | 223686 | 2020-06-09 | Elk | Pennsylvania | 42047 | 6 | 0 |
223687 | 223687 | 2020-06-09 | Erie | Pennsylvania | 42049 | 396 | 7 |
223688 | 223688 | 2020-06-09 | Fayette | Pennsylvania | 42051 | 95 | 4 |
223689 | 223689 | 2020-06-09 | Forest | Pennsylvania | 42053 | 7 | 0 |
223690 | 223690 | 2020-06-09 | Franklin | Pennsylvania | 42055 | 800 | 39 |
223691 | 223691 | 2020-06-09 | Fulton | Pennsylvania | 42057 | 16 | 1 |
223692 | 223692 | 2020-06-09 | Greene | Pennsylvania | 42059 | 28 | 0 |
223693 | 223693 | 2020-06-09 | Huntingdon | Pennsylvania | 42061 | 236 | 4 |
223694 | 223694 | 2020-06-09 | Indiana | Pennsylvania | 42063 | 92 | 5 |
223695 | 223695 | 2020-06-09 | Jefferson | Pennsylvania | 42065 | 16 | 0 |
223696 | 223696 | 2020-06-09 | Juniata | Pennsylvania | 42067 | 101 | 5 |
223697 | 223697 | 2020-06-09 | Lackawanna | Pennsylvania | 42069 | 1587 | 189 |
223698 | 223698 | 2020-06-09 | Lancaster | Pennsylvania | 42071 | 3554 | 320 |
223699 | 223699 | 2020-06-09 | Lawrence | Pennsylvania | 42073 | 85 | 8 |
223700 | 223700 | 2020-06-09 | Lebanon | Pennsylvania | 42075 | 1086 | 38 |
223701 | 223701 | 2020-06-09 | Lehigh | Pennsylvania | 42077 | 3890 | 253 |
223702 | 223702 | 2020-06-09 | Luzerne | Pennsylvania | 42079 | 2798 | 160 |
223703 | 223703 | 2020-06-09 | Lycoming | Pennsylvania | 42081 | 168 | 17 |
223704 | 223704 | 2020-06-09 | McKean | Pennsylvania | 42083 | 13 | 1 |
223705 | 223705 | 2020-06-09 | Mercer | Pennsylvania | 42085 | 113 | 6 |
223706 | 223706 | 2020-06-09 | Mifflin | Pennsylvania | 42087 | 59 | 1 |
223707 | 223707 | 2020-06-09 | Monroe | Pennsylvania | 42089 | 1342 | 102 |
223708 | 223708 | 2020-06-09 | Montgomery | Pennsylvania | 42091 | 7672 | 740 |
223709 | 223709 | 2020-06-09 | Montour | Pennsylvania | 42093 | 53 | 0 |
223710 | 223710 | 2020-06-09 | Northampton | Pennsylvania | 42095 | 3175 | 236 |
223711 | 223711 | 2020-06-09 | Northumberland | Pennsylvania | 42097 | 211 | 3 |
223712 | 223712 | 2020-06-09 | Perry | Pennsylvania | 42099 | 68 | 3 |
223713 | 223713 | 2020-06-09 | Philadelphia | Pennsylvania | 42101 | 23822 | 1436 |
223714 | 223714 | 2020-06-09 | Pike | Pennsylvania | 42103 | 482 | 20 |
223715 | 223715 | 2020-06-09 | Potter | Pennsylvania | 42105 | 11 | 0 |
223716 | 223716 | 2020-06-09 | Schuylkill | Pennsylvania | 42107 | 659 | 41 |
223717 | 223717 | 2020-06-09 | Snyder | Pennsylvania | 42109 | 57 | 1 |
223718 | 223718 | 2020-06-09 | Somerset | Pennsylvania | 42111 | 39 | 1 |
223719 | 223719 | 2020-06-09 | Sullivan | Pennsylvania | 42113 | 3 | 0 |
223720 | 223720 | 2020-06-09 | Susquehanna | Pennsylvania | 42115 | 154 | 16 |
223721 | 223721 | 2020-06-09 | Tioga | Pennsylvania | 42117 | 19 | 2 |
223722 | 223722 | 2020-06-09 | Union | Pennsylvania | 42119 | 74 | 2 |
223723 | 223723 | 2020-06-09 | Venango | Pennsylvania | 42121 | 16 | 0 |
223724 | 223724 | 2020-06-09 | Warren | Pennsylvania | 42123 | 5 | 0 |
223725 | 223725 | 2020-06-09 | Washington | Pennsylvania | 42125 | 150 | 6 |
223726 | 223726 | 2020-06-09 | Wayne | Pennsylvania | 42127 | 124 | 9 |
223727 | 223727 | 2020-06-09 | Westmoreland | Pennsylvania | 42129 | 467 | 38 |
223728 | 223728 | 2020-06-09 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
223729 | 223729 | 2020-06-09 | York | Pennsylvania | 42133 | 1094 | 30 |
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);