ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where deaths = 159 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2218811 | 2218811 | 2022-02-15 | Wayne | Pennsylvania | 42127 | 9826 | 159 |
2215560 | 2215560 | 2022-02-14 | Wayne | Pennsylvania | 42127 | 9815 | 159 |
2212309 | 2212309 | 2022-02-13 | Wayne | Pennsylvania | 42127 | 9810 | 159 |
2209056 | 2209056 | 2022-02-12 | Wayne | Pennsylvania | 42127 | 9804 | 159 |
2147213 | 2147213 | 2022-01-24 | Juniata | Pennsylvania | 42067 | 4309 | 159 |
2143959 | 2143959 | 2022-01-23 | Juniata | Pennsylvania | 42067 | 4303 | 159 |
2140704 | 2140704 | 2022-01-22 | Juniata | Pennsylvania | 42067 | 4279 | 159 |
2137448 | 2137448 | 2022-01-21 | Juniata | Pennsylvania | 42067 | 4258 | 159 |
2111445 | 2111445 | 2022-01-13 | Perry | Pennsylvania | 42099 | 7452 | 159 |
2108193 | 2108193 | 2022-01-12 | Perry | Pennsylvania | 42099 | 7407 | 159 |
2000929 | 2000929 | 2021-12-10 | Tioga | Pennsylvania | 42117 | 5789 | 159 |
1974929 | 1974929 | 2021-12-02 | Warren | Pennsylvania | 42123 | 5138 | 159 |
1932670 | 1932670 | 2021-11-19 | Venango | Pennsylvania | 42121 | 7540 | 159 |
1919628 | 1919628 | 2021-11-15 | Columbia | Pennsylvania | 42037 | 8582 | 159 |
1916378 | 1916378 | 2021-11-14 | Columbia | Pennsylvania | 42037 | 8567 | 159 |
1656458 | 1656458 | 2021-08-26 | Crawford | Pennsylvania | 42039 | 7952 | 159 |
1653211 | 1653211 | 2021-08-25 | Crawford | Pennsylvania | 42039 | 7931 | 159 |
1649964 | 1649964 | 2021-08-24 | Crawford | Pennsylvania | 42039 | 7889 | 159 |
1646715 | 1646715 | 2021-08-23 | Crawford | Pennsylvania | 42039 | 7862 | 159 |
1643466 | 1643466 | 2021-08-22 | Crawford | Pennsylvania | 42039 | 7860 | 159 |
1640216 | 1640216 | 2021-08-21 | Crawford | Pennsylvania | 42039 | 7855 | 159 |
1636966 | 1636966 | 2021-08-20 | Crawford | Pennsylvania | 42039 | 7842 | 159 |
1607732 | 1607732 | 2021-08-11 | Clearfield | Pennsylvania | 42033 | 8857 | 159 |
1221370 | 1221370 | 2021-04-14 | Carbon | Pennsylvania | 42025 | 5749 | 159 |
1218122 | 1218122 | 2021-04-13 | Carbon | Pennsylvania | 42025 | 5717 | 159 |
1214874 | 1214874 | 2021-04-12 | Carbon | Pennsylvania | 42025 | 5670 | 159 |
1211627 | 1211627 | 2021-04-11 | Carbon | Pennsylvania | 42025 | 5660 | 159 |
1208378 | 1208378 | 2021-04-10 | Carbon | Pennsylvania | 42025 | 5652 | 159 |
1205130 | 1205130 | 2021-04-09 | Carbon | Pennsylvania | 42025 | 5620 | 159 |
1201882 | 1201882 | 2021-04-08 | Carbon | Pennsylvania | 42025 | 5587 | 159 |
1172640 | 1172640 | 2021-03-30 | Adams | Pennsylvania | 42001 | 8062 | 159 |
1169393 | 1169393 | 2021-03-29 | Adams | Pennsylvania | 42001 | 8008 | 159 |
1166145 | 1166145 | 2021-03-28 | Adams | Pennsylvania | 42001 | 7988 | 159 |
1162897 | 1162897 | 2021-03-27 | Adams | Pennsylvania | 42001 | 7955 | 159 |
1078517 | 1078517 | 2021-03-01 | Indiana | Pennsylvania | 42063 | 5094 | 159 |
1075272 | 1075272 | 2021-02-28 | Indiana | Pennsylvania | 42063 | 5081 | 159 |
1000635 | 1000635 | 2021-02-05 | Mifflin | Pennsylvania | 42087 | 4380 | 159 |
997389 | 997389 | 2021-02-04 | Mifflin | Pennsylvania | 42087 | 4370 | 159 |
994143 | 994143 | 2021-02-03 | Mifflin | Pennsylvania | 42087 | 4335 | 159 |
964925 | 964925 | 2021-01-25 | Lawrence | Pennsylvania | 42073 | 5326 | 159 |
961680 | 961680 | 2021-01-24 | Lawrence | Pennsylvania | 42073 | 5300 | 159 |
958435 | 958435 | 2021-01-23 | Lawrence | Pennsylvania | 42073 | 5272 | 159 |
958454 | 958454 | 2021-01-23 | Somerset | Pennsylvania | 42111 | 6132 | 159 |
844838 | 844838 | 2020-12-19 | Erie | Pennsylvania | 42049 | 9686 | 159 |
805908 | 805908 | 2020-12-07 | Monroe | Pennsylvania | 42089 | 4072 | 159 |
802663 | 802663 | 2020-12-06 | Monroe | Pennsylvania | 42089 | 4010 | 159 |
799418 | 799418 | 2020-12-05 | Monroe | Pennsylvania | 42089 | 3918 | 159 |
763731 | 763731 | 2020-11-24 | Schuylkill | Pennsylvania | 42107 | 3551 | 159 |
760486 | 760486 | 2020-11-23 | Schuylkill | Pennsylvania | 42107 | 3474 | 159 |
757241 | 757241 | 2020-11-22 | Schuylkill | Pennsylvania | 42107 | 3410 | 159 |
588571 | 588571 | 2020-10-01 | York | Pennsylvania | 42133 | 4971 | 159 |
585331 | 585331 | 2020-09-30 | York | Pennsylvania | 42133 | 4941 | 159 |
426827 | 426827 | 2020-08-12 | Dauphin | Pennsylvania | 42043 | 2873 | 159 |
423604 | 423604 | 2020-08-11 | Dauphin | Pennsylvania | 42043 | 2850 | 159 |
420381 | 420381 | 2020-08-10 | Dauphin | Pennsylvania | 42043 | 2829 | 159 |
417161 | 417161 | 2020-08-09 | Dauphin | Pennsylvania | 42043 | 2801 | 159 |
413940 | 413940 | 2020-08-08 | Dauphin | Pennsylvania | 42043 | 2774 | 159 |
183694 | 183694 | 2020-05-27 | Lackawanna | Pennsylvania | 42069 | 1511 | 159 |
174524 | 174524 | 2020-05-24 | Allegheny | Pennsylvania | 42003 | 1777 | 159 |
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);