ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where deaths = 117 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2192742 | 2192742 | 2022-02-07 | Clinton | Pennsylvania | 42035 | 8704 | 117 |
2189488 | 2189488 | 2022-02-06 | Clinton | Pennsylvania | 42035 | 8692 | 117 |
2186235 | 2186235 | 2022-02-05 | Clinton | Pennsylvania | 42035 | 8677 | 117 |
2182983 | 2182983 | 2022-02-04 | Clinton | Pennsylvania | 42035 | 8647 | 117 |
2179731 | 2179731 | 2022-02-03 | Clinton | Pennsylvania | 42035 | 8615 | 117 |
2176480 | 2176480 | 2022-02-02 | Clinton | Pennsylvania | 42035 | 8577 | 117 |
2173226 | 2173226 | 2022-02-01 | Clinton | Pennsylvania | 42035 | 8535 | 117 |
2169974 | 2169974 | 2022-01-31 | Clinton | Pennsylvania | 42035 | 8503 | 117 |
2166720 | 2166720 | 2022-01-30 | Clinton | Pennsylvania | 42035 | 8486 | 117 |
2163465 | 2163465 | 2022-01-29 | Clinton | Pennsylvania | 42035 | 8461 | 117 |
2160210 | 2160210 | 2022-01-28 | Clinton | Pennsylvania | 42035 | 8418 | 117 |
2156954 | 2156954 | 2022-01-27 | Clinton | Pennsylvania | 42035 | 8347 | 117 |
2153701 | 2153701 | 2022-01-26 | Clinton | Pennsylvania | 42035 | 8297 | 117 |
2150449 | 2150449 | 2022-01-25 | Clinton | Pennsylvania | 42035 | 8234 | 117 |
2147197 | 2147197 | 2022-01-24 | Clinton | Pennsylvania | 42035 | 8214 | 117 |
2143943 | 2143943 | 2022-01-23 | Clinton | Pennsylvania | 42035 | 8194 | 117 |
2140688 | 2140688 | 2022-01-22 | Clinton | Pennsylvania | 42035 | 8127 | 117 |
2013929 | 2013929 | 2021-12-14 | Snyder | Pennsylvania | 42109 | 5773 | 117 |
1997680 | 1997680 | 2021-12-09 | Union | Pennsylvania | 42119 | 8395 | 117 |
1994429 | 1994429 | 2021-12-08 | Union | Pennsylvania | 42119 | 8358 | 117 |
1991178 | 1991178 | 2021-12-07 | Union | Pennsylvania | 42119 | 8320 | 117 |
1909923 | 1909923 | 2021-11-12 | Wayne | Pennsylvania | 42127 | 6002 | 117 |
1906674 | 1906674 | 2021-11-11 | Wayne | Pennsylvania | 42127 | 5978 | 117 |
1900145 | 1900145 | 2021-11-09 | Juniata | Pennsylvania | 42067 | 2995 | 117 |
1896895 | 1896895 | 2021-11-08 | Juniata | Pennsylvania | 42067 | 2987 | 117 |
1893645 | 1893645 | 2021-11-07 | Juniata | Pennsylvania | 42067 | 2981 | 117 |
1890395 | 1890395 | 2021-11-06 | Juniata | Pennsylvania | 42067 | 2977 | 117 |
1835131 | 1835131 | 2021-10-20 | Bradford | Pennsylvania | 42015 | 7503 | 117 |
1835173 | 1835173 | 2021-10-20 | Perry | Pennsylvania | 42099 | 5167 | 117 |
1825438 | 1825438 | 2021-10-17 | Warren | Pennsylvania | 42123 | 3759 | 117 |
1822189 | 1822189 | 2021-10-16 | Warren | Pennsylvania | 42123 | 3749 | 117 |
1818940 | 1818940 | 2021-10-15 | Warren | Pennsylvania | 42123 | 3725 | 117 |
1815691 | 1815691 | 2021-10-14 | Warren | Pennsylvania | 42123 | 3688 | 117 |
1812443 | 1812443 | 2021-10-13 | Warren | Pennsylvania | 42123 | 3649 | 117 |
1809194 | 1809194 | 2021-10-12 | Warren | Pennsylvania | 42123 | 3615 | 117 |
1805944 | 1805944 | 2021-10-11 | Warren | Pennsylvania | 42123 | 3580 | 117 |
1802694 | 1802694 | 2021-10-10 | Warren | Pennsylvania | 42123 | 3574 | 117 |
1799445 | 1799445 | 2021-10-09 | Warren | Pennsylvania | 42123 | 3553 | 117 |
1796196 | 1796196 | 2021-10-08 | Warren | Pennsylvania | 42123 | 3534 | 117 |
1792947 | 1792947 | 2021-10-07 | Warren | Pennsylvania | 42123 | 3502 | 117 |
1789698 | 1789698 | 2021-10-06 | Warren | Pennsylvania | 42123 | 3480 | 117 |
1786450 | 1786450 | 2021-10-05 | Warren | Pennsylvania | 42123 | 3449 | 117 |
1760452 | 1760452 | 2021-09-27 | Tioga | Pennsylvania | 42117 | 3888 | 117 |
1757204 | 1757204 | 2021-09-26 | Tioga | Pennsylvania | 42117 | 3880 | 117 |
1753956 | 1753956 | 2021-09-25 | Tioga | Pennsylvania | 42117 | 3860 | 117 |
1750708 | 1750708 | 2021-09-24 | Tioga | Pennsylvania | 42117 | 3839 | 117 |
1127181 | 1127181 | 2021-03-16 | Armstrong | Pennsylvania | 42005 | 5008 | 117 |
1104471 | 1104471 | 2021-03-09 | Clearfield | Pennsylvania | 42033 | 6495 | 117 |
1101225 | 1101225 | 2021-03-08 | Clearfield | Pennsylvania | 42033 | 6450 | 117 |
1023340 | 1023340 | 2021-02-12 | Huntingdon | Pennsylvania | 42061 | 4045 | 117 |
1020095 | 1020095 | 2021-02-11 | Huntingdon | Pennsylvania | 42061 | 4025 | 117 |
1016850 | 1016850 | 2021-02-10 | Huntingdon | Pennsylvania | 42061 | 4014 | 117 |
1013605 | 1013605 | 2021-02-09 | Huntingdon | Pennsylvania | 42061 | 3976 | 117 |
990872 | 990872 | 2021-02-02 | Columbia | Pennsylvania | 42037 | 4194 | 117 |
964893 | 964893 | 2021-01-25 | Bedford | Pennsylvania | 42009 | 3519 | 117 |
961648 | 961648 | 2021-01-24 | Bedford | Pennsylvania | 42009 | 3503 | 117 |
961656 | 961656 | 2021-01-24 | Carbon | Pennsylvania | 42025 | 4137 | 117 |
958403 | 958403 | 2021-01-23 | Bedford | Pennsylvania | 42009 | 3487 | 117 |
958411 | 958411 | 2021-01-23 | Carbon | Pennsylvania | 42025 | 4108 | 117 |
955157 | 955157 | 2021-01-22 | Bedford | Pennsylvania | 42009 | 3468 | 117 |
951912 | 951912 | 2021-01-21 | Bedford | Pennsylvania | 42009 | 3457 | 117 |
951927 | 951927 | 2021-01-21 | Crawford | Pennsylvania | 42039 | 5664 | 117 |
926000 | 926000 | 2021-01-13 | Somerset | Pennsylvania | 42111 | 5762 | 117 |
896763 | 896763 | 2021-01-04 | Fayette | Pennsylvania | 42051 | 7621 | 117 |
880540 | 880540 | 2020-12-30 | Indiana | Pennsylvania | 42063 | 3911 | 117 |
818854 | 818854 | 2020-12-11 | Butler | Pennsylvania | 42019 | 6150 | 117 |
731268 | 731268 | 2020-11-14 | Northumberland | Pennsylvania | 42097 | 1925 | 117 |
475291 | 475291 | 2020-08-27 | York | Pennsylvania | 42133 | 3232 | 117 |
352900 | 352900 | 2020-07-20 | Monroe | Pennsylvania | 42089 | 1503 | 117 |
349697 | 349697 | 2020-07-19 | Monroe | Pennsylvania | 42089 | 1499 | 117 |
135345 | 135345 | 2020-05-11 | Lackawanna | Pennsylvania | 42069 | 1187 | 117 |
132354 | 132354 | 2020-05-10 | Lackawanna | Pennsylvania | 42069 | 1172 | 117 |
123360 | 123360 | 2020-05-07 | Allegheny | Pennsylvania | 42003 | 1439 | 117 |
117467 | 117467 | 2020-05-05 | Northampton | Pennsylvania | 42095 | 2279 | 117 |
111671 | 111671 | 2020-05-03 | Chester | Pennsylvania | 42029 | 1546 | 117 |
108797 | 108797 | 2020-05-02 | Chester | Pennsylvania | 42029 | 1514 | 117 |
105921 | 105921 | 2020-05-01 | Berks | Pennsylvania | 42011 | 2748 | 117 |
103058 | 103058 | 2020-04-30 | Berks | Pennsylvania | 42011 | 2698 | 117 |
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);