ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 134 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2261052 | 2261052 | 2022-02-28 | McKean | Pennsylvania | 42083 | 8064 | 134 |
2257801 | 2257801 | 2022-02-27 | McKean | Pennsylvania | 42083 | 8062 | 134 |
2254550 | 2254550 | 2022-02-26 | McKean | Pennsylvania | 42083 | 8062 | 134 |
2085443 | 2085443 | 2022-01-05 | Union | Pennsylvania | 42119 | 9166 | 134 |
2082191 | 2082191 | 2022-01-04 | Union | Pennsylvania | 42119 | 9113 | 134 |
2000904 | 2000904 | 2021-12-10 | Juniata | Pennsylvania | 42067 | 3533 | 134 |
1997654 | 1997654 | 2021-12-09 | Juniata | Pennsylvania | 42067 | 3503 | 134 |
1994403 | 1994403 | 2021-12-08 | Juniata | Pennsylvania | 42067 | 3489 | 134 |
1991152 | 1991152 | 2021-12-07 | Juniata | Pennsylvania | 42067 | 3474 | 134 |
1974917 | 1974917 | 2021-12-02 | Perry | Pennsylvania | 42099 | 6017 | 134 |
1971668 | 1971668 | 2021-12-01 | Perry | Pennsylvania | 42099 | 5969 | 134 |
1926141 | 1926141 | 2021-11-17 | Jefferson | Pennsylvania | 42065 | 5719 | 134 |
1900170 | 1900170 | 2021-11-09 | Tioga | Pennsylvania | 42117 | 4788 | 134 |
1896920 | 1896920 | 2021-11-08 | Tioga | Pennsylvania | 42117 | 4774 | 134 |
1893670 | 1893670 | 2021-11-07 | Tioga | Pennsylvania | 42117 | 4759 | 134 |
1890420 | 1890420 | 2021-11-06 | Tioga | Pennsylvania | 42117 | 4752 | 134 |
1887170 | 1887170 | 2021-11-05 | Tioga | Pennsylvania | 42117 | 4732 | 134 |
1883920 | 1883920 | 2021-11-04 | Tioga | Pennsylvania | 42117 | 4697 | 134 |
1429147 | 1429147 | 2021-06-17 | Columbia | Pennsylvania | 42037 | 5891 | 134 |
1425902 | 1425902 | 2021-06-16 | Columbia | Pennsylvania | 42037 | 5890 | 134 |
1422655 | 1422655 | 2021-06-15 | Columbia | Pennsylvania | 42037 | 5890 | 134 |
1419409 | 1419409 | 2021-06-14 | Columbia | Pennsylvania | 42037 | 5889 | 134 |
1416164 | 1416164 | 2021-06-13 | Columbia | Pennsylvania | 42037 | 5887 | 134 |
1412918 | 1412918 | 2021-06-12 | Columbia | Pennsylvania | 42037 | 5884 | 134 |
1412930 | 1412930 | 2021-06-12 | Huntingdon | Pennsylvania | 42061 | 5139 | 134 |
1409673 | 1409673 | 2021-06-11 | Columbia | Pennsylvania | 42037 | 5882 | 134 |
1409685 | 1409685 | 2021-06-11 | Huntingdon | Pennsylvania | 42061 | 5135 | 134 |
1406440 | 1406440 | 2021-06-10 | Huntingdon | Pennsylvania | 42061 | 5131 | 134 |
1403194 | 1403194 | 2021-06-09 | Huntingdon | Pennsylvania | 42061 | 5126 | 134 |
1399949 | 1399949 | 2021-06-08 | Huntingdon | Pennsylvania | 42061 | 5124 | 134 |
1312273 | 1312273 | 2021-05-12 | Armstrong | Pennsylvania | 42005 | 5877 | 134 |
1309026 | 1309026 | 2021-05-11 | Armstrong | Pennsylvania | 42005 | 5867 | 134 |
1283058 | 1283058 | 2021-05-03 | Bedford | Pennsylvania | 42009 | 4373 | 134 |
1279811 | 1279811 | 2021-05-02 | Bedford | Pennsylvania | 42009 | 4364 | 134 |
1276564 | 1276564 | 2021-05-01 | Bedford | Pennsylvania | 42009 | 4356 | 134 |
1273317 | 1273317 | 2021-04-30 | Bedford | Pennsylvania | 42009 | 4346 | 134 |
1270070 | 1270070 | 2021-04-29 | Bedford | Pennsylvania | 42009 | 4321 | 134 |
1250600 | 1250600 | 2021-04-23 | Clearfield | Pennsylvania | 42033 | 7989 | 134 |
1247353 | 1247353 | 2021-04-22 | Clearfield | Pennsylvania | 42033 | 7956 | 134 |
1244106 | 1244106 | 2021-04-21 | Clearfield | Pennsylvania | 42033 | 7932 | 134 |
1026574 | 1026574 | 2021-02-13 | Crawford | Pennsylvania | 42039 | 6168 | 134 |
1013587 | 1013587 | 2021-02-09 | Carbon | Pennsylvania | 42025 | 4607 | 134 |
932478 | 932478 | 2021-01-15 | Mifflin | Pennsylvania | 42087 | 3911 | 134 |
903264 | 903264 | 2021-01-06 | Lawrence | Pennsylvania | 42073 | 4526 | 134 |
880551 | 880551 | 2020-12-30 | Mercer | Pennsylvania | 42085 | 5863 | 134 |
802646 | 802646 | 2020-12-06 | Franklin | Pennsylvania | 42055 | 5496 | 134 |
783170 | 783170 | 2020-11-30 | Cumberland | Pennsylvania | 42041 | 5172 | 134 |
779925 | 779925 | 2020-11-29 | Cumberland | Pennsylvania | 42041 | 5089 | 134 |
737763 | 737763 | 2020-11-16 | Schuylkill | Pennsylvania | 42107 | 2955 | 134 |
734519 | 734519 | 2020-11-15 | Schuylkill | Pennsylvania | 42107 | 2898 | 134 |
656664 | 656664 | 2020-10-22 | Monroe | Pennsylvania | 42089 | 1961 | 134 |
653419 | 653419 | 2020-10-21 | Monroe | Pennsylvania | 42089 | 1944 | 134 |
650174 | 650174 | 2020-10-20 | Monroe | Pennsylvania | 42089 | 1940 | 134 |
646930 | 646930 | 2020-10-19 | Monroe | Pennsylvania | 42089 | 1938 | 134 |
643684 | 643684 | 2020-10-18 | Monroe | Pennsylvania | 42089 | 1923 | 134 |
640436 | 640436 | 2020-10-17 | Monroe | Pennsylvania | 42089 | 1913 | 134 |
637190 | 637190 | 2020-10-16 | Monroe | Pennsylvania | 42089 | 1904 | 134 |
633944 | 633944 | 2020-10-15 | Monroe | Pennsylvania | 42089 | 1898 | 134 |
630699 | 630699 | 2020-10-14 | Monroe | Pennsylvania | 42089 | 1893 | 134 |
627455 | 627455 | 2020-10-13 | Monroe | Pennsylvania | 42089 | 1884 | 134 |
624213 | 624213 | 2020-10-12 | Monroe | Pennsylvania | 42089 | 1875 | 134 |
620970 | 620970 | 2020-10-11 | Monroe | Pennsylvania | 42089 | 1866 | 134 |
617727 | 617727 | 2020-10-10 | Monroe | Pennsylvania | 42089 | 1858 | 134 |
614485 | 614485 | 2020-10-09 | Monroe | Pennsylvania | 42089 | 1852 | 134 |
611244 | 611244 | 2020-10-08 | Monroe | Pennsylvania | 42089 | 1848 | 134 |
608002 | 608002 | 2020-10-07 | Monroe | Pennsylvania | 42089 | 1846 | 134 |
604759 | 604759 | 2020-10-06 | Monroe | Pennsylvania | 42089 | 1831 | 134 |
601517 | 601517 | 2020-10-05 | Monroe | Pennsylvania | 42089 | 1829 | 134 |
598274 | 598274 | 2020-10-04 | Monroe | Pennsylvania | 42089 | 1826 | 134 |
595031 | 595031 | 2020-10-03 | Monroe | Pennsylvania | 42089 | 1816 | 134 |
591790 | 591790 | 2020-10-02 | Monroe | Pennsylvania | 42089 | 1816 | 134 |
588549 | 588549 | 2020-10-01 | Monroe | Pennsylvania | 42089 | 1809 | 134 |
536743 | 536743 | 2020-09-15 | York | Pennsylvania | 42133 | 4258 | 134 |
533507 | 533507 | 2020-09-14 | York | Pennsylvania | 42133 | 4216 | 134 |
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);