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-02-12 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2208993 | 2208993 | 2022-02-12 | Adams | Pennsylvania | 42001 | 24236 | 344 |
2208994 | 2208994 | 2022-02-12 | Allegheny | Pennsylvania | 42003 | 257052 | 3112 |
2208995 | 2208995 | 2022-02-12 | Armstrong | Pennsylvania | 42005 | 14893 | 319 |
2208996 | 2208996 | 2022-02-12 | Beaver | Pennsylvania | 42007 | 39146 | 692 |
2208997 | 2208997 | 2022-02-12 | Bedford | Pennsylvania | 42009 | 10697 | 258 |
2208998 | 2208998 | 2022-02-12 | Berks | Pennsylvania | 42011 | 100671 | 1538 |
2208999 | 2208999 | 2022-02-12 | Blair | Pennsylvania | 42013 | 28901 | 584 |
2209000 | 2209000 | 2022-02-12 | Bradford | Pennsylvania | 42015 | 14553 | 190 |
2209001 | 2209001 | 2022-02-12 | Bucks | Pennsylvania | 42017 | 120600 | 1789 |
2209002 | 2209002 | 2022-02-12 | Butler | Pennsylvania | 42019 | 43526 | 690 |
2209003 | 2209003 | 2022-02-12 | Cambria | Pennsylvania | 42021 | 33757 | 689 |
2209004 | 2209004 | 2022-02-12 | Cameron | Pennsylvania | 42023 | 801 | 19 |
2209005 | 2209005 | 2022-02-12 | Carbon | Pennsylvania | 42025 | 15580 | 275 |
2209006 | 2209006 | 2022-02-12 | Centre | Pennsylvania | 42027 | 34210 | 332 |
2209007 | 2209007 | 2022-02-12 | Chester | Pennsylvania | 42029 | 89152 | 1097 |
2209008 | 2209008 | 2022-02-12 | Clarion | Pennsylvania | 42031 | 8043 | 193 |
2209009 | 2209009 | 2022-02-12 | Clearfield | Pennsylvania | 42033 | 18658 | 312 |
2209010 | 2209010 | 2022-02-12 | Clinton | Pennsylvania | 42035 | 8810 | 120 |
2209011 | 2209011 | 2022-02-12 | Columbia | Pennsylvania | 42037 | 14561 | 227 |
2209012 | 2209012 | 2022-02-12 | Crawford | Pennsylvania | 42039 | 19396 | 295 |
2209013 | 2209013 | 2022-02-12 | Cumberland | Pennsylvania | 42041 | 49681 | 842 |
2209014 | 2209014 | 2022-02-12 | Dauphin | Pennsylvania | 42043 | 58070 | 899 |
2209015 | 2209015 | 2022-02-12 | Delaware | Pennsylvania | 42045 | 107890 | 1778 |
2209016 | 2209016 | 2022-02-12 | Elk | Pennsylvania | 42047 | 6957 | 93 |
2209017 | 2209017 | 2022-02-12 | Erie | Pennsylvania | 42049 | 55721 | 718 |
2209018 | 2209018 | 2022-02-12 | Fayette | Pennsylvania | 42051 | 29928 | 602 |
2209019 | 2209019 | 2022-02-12 | Forest | Pennsylvania | 42053 | 2191 | 34 |
2209020 | 2209020 | 2022-02-12 | Franklin | Pennsylvania | 42055 | 39563 | 648 |
2209021 | 2209021 | 2022-02-12 | Fulton | Pennsylvania | 42057 | 3988 | 62 |
2209022 | 2209022 | 2022-02-12 | Greene | Pennsylvania | 42059 | 8148 | 96 |
2209023 | 2209023 | 2022-02-12 | Huntingdon | Pennsylvania | 42061 | 11190 | 235 |
2209024 | 2209024 | 2022-02-12 | Indiana | Pennsylvania | 42063 | 16824 | 330 |
2209025 | 2209025 | 2022-02-12 | Jefferson | Pennsylvania | 42065 | 8700 | 210 |
2209026 | 2209026 | 2022-02-12 | Juniata | Pennsylvania | 42067 | 4659 | 169 |
2209027 | 2209027 | 2022-02-12 | Lackawanna | Pennsylvania | 42069 | 42018 | 700 |
2209028 | 2209028 | 2022-02-12 | Lancaster | Pennsylvania | 42071 | 118889 | 1797 |
2209029 | 2209029 | 2022-02-12 | Lawrence | Pennsylvania | 42073 | 18571 | 390 |
2209030 | 2209030 | 2022-02-12 | Lebanon | Pennsylvania | 42075 | 36013 | 483 |
2209031 | 2209031 | 2022-02-12 | Lehigh | Pennsylvania | 42077 | 88195 | 1196 |
2209032 | 2209032 | 2022-02-12 | Luzerne | Pennsylvania | 42079 | 71739 | 1259 |
2209033 | 2209033 | 2022-02-12 | Lycoming | Pennsylvania | 42081 | 27859 | 493 |
2209034 | 2209034 | 2022-02-12 | McKean | Pennsylvania | 42083 | 7921 | 131 |
2209035 | 2209035 | 2022-02-12 | Mercer | Pennsylvania | 42085 | 22932 | 478 |
2209036 | 2209036 | 2022-02-12 | Mifflin | Pennsylvania | 42087 | 11981 | 262 |
2209037 | 2209037 | 2022-02-12 | Monroe | Pennsylvania | 42089 | 36315 | 495 |
2209038 | 2209038 | 2022-02-12 | Montgomery | Pennsylvania | 42091 | 147932 | 2231 |
2209039 | 2209039 | 2022-02-12 | Montour | Pennsylvania | 42093 | 4368 | 87 |
2209040 | 2209040 | 2022-02-12 | Northampton | Pennsylvania | 42095 | 78160 | 1038 |
2209041 | 2209041 | 2022-02-12 | Northumberland | Pennsylvania | 42097 | 22325 | 504 |
2209042 | 2209042 | 2022-02-12 | Perry | Pennsylvania | 42099 | 8652 | 174 |
2209043 | 2209043 | 2022-02-12 | Philadelphia | Pennsylvania | 42101 | 300817 | 4868 |
2209044 | 2209044 | 2022-02-12 | Pike | Pennsylvania | 42103 | 9644 | 91 |
2209045 | 2209045 | 2022-02-12 | Potter | Pennsylvania | 42105 | 3066 | 89 |
2209046 | 2209046 | 2022-02-12 | Schuylkill | Pennsylvania | 42107 | 33715 | 647 |
2209047 | 2209047 | 2022-02-12 | Snyder | Pennsylvania | 42109 | 7939 | 148 |
2209048 | 2209048 | 2022-02-12 | Somerset | Pennsylvania | 42111 | 18325 | 387 |
2209049 | 2209049 | 2022-02-12 | Sullivan | Pennsylvania | 42113 | 1029 | 33 |
2209050 | 2209050 | 2022-02-12 | Susquehanna | Pennsylvania | 42115 | 7478 | 103 |
2209051 | 2209051 | 2022-02-12 | Tioga | Pennsylvania | 42117 | 7725 | 187 |
2209052 | 2209052 | 2022-02-12 | Union | Pennsylvania | 42119 | 11381 | 144 |
2209053 | 2209053 | 2022-02-12 | Venango | Pennsylvania | 42121 | 11037 | 227 |
2209054 | 2209054 | 2022-02-12 | Warren | Pennsylvania | 42123 | 7104 | 203 |
2209055 | 2209055 | 2022-02-12 | Washington | Pennsylvania | 42125 | 49567 | 606 |
2209056 | 2209056 | 2022-02-12 | Wayne | Pennsylvania | 42127 | 9804 | 159 |
2209057 | 2209057 | 2022-02-12 | Westmoreland | Pennsylvania | 42129 | 77791 | 1299 |
2209058 | 2209058 | 2022-02-12 | Wyoming | Pennsylvania | 42131 | 4925 | 97 |
2209059 | 2209059 | 2022-02-12 | York | Pennsylvania | 42133 | 116425 | 1406 |
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);