ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where deaths = 190 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2313104 | 2313104 | 2022-03-16 | Tioga | Pennsylvania | 42117 | 7936 | 190 |
2309851 | 2309851 | 2022-03-15 | Tioga | Pennsylvania | 42117 | 7928 | 190 |
2306598 | 2306598 | 2022-03-14 | Tioga | Pennsylvania | 42117 | 7927 | 190 |
2303347 | 2303347 | 2022-03-13 | Tioga | Pennsylvania | 42117 | 7924 | 190 |
2300095 | 2300095 | 2022-03-12 | Tioga | Pennsylvania | 42117 | 7921 | 190 |
2296843 | 2296843 | 2022-03-11 | Tioga | Pennsylvania | 42117 | 7917 | 190 |
2293591 | 2293591 | 2022-03-10 | Tioga | Pennsylvania | 42117 | 7912 | 190 |
2290339 | 2290339 | 2022-03-09 | Tioga | Pennsylvania | 42117 | 7909 | 190 |
2287087 | 2287087 | 2022-03-08 | Tioga | Pennsylvania | 42117 | 7901 | 190 |
2231759 | 2231759 | 2022-02-19 | Bradford | Pennsylvania | 42015 | 14703 | 190 |
2228508 | 2228508 | 2022-02-18 | Bradford | Pennsylvania | 42015 | 14667 | 190 |
2225257 | 2225257 | 2022-02-17 | Bradford | Pennsylvania | 42015 | 14642 | 190 |
2222006 | 2222006 | 2022-02-16 | Bradford | Pennsylvania | 42015 | 14617 | 190 |
2218755 | 2218755 | 2022-02-15 | Bradford | Pennsylvania | 42015 | 14592 | 190 |
2215504 | 2215504 | 2022-02-14 | Bradford | Pennsylvania | 42015 | 14574 | 190 |
2212253 | 2212253 | 2022-02-13 | Bradford | Pennsylvania | 42015 | 14566 | 190 |
2209000 | 2209000 | 2022-02-12 | Bradford | Pennsylvania | 42015 | 14553 | 190 |
2205747 | 2205747 | 2022-02-11 | Bradford | Pennsylvania | 42015 | 14529 | 190 |
2192740 | 2192740 | 2022-02-07 | Clarion | Pennsylvania | 42031 | 8014 | 190 |
2189486 | 2189486 | 2022-02-06 | Clarion | Pennsylvania | 42031 | 7994 | 190 |
2186233 | 2186233 | 2022-02-05 | Clarion | Pennsylvania | 42031 | 7983 | 190 |
2182981 | 2182981 | 2022-02-04 | Clarion | Pennsylvania | 42031 | 7958 | 190 |
2179729 | 2179729 | 2022-02-03 | Clarion | Pennsylvania | 42031 | 7947 | 190 |
2176478 | 2176478 | 2022-02-02 | Clarion | Pennsylvania | 42031 | 7915 | 190 |
2130970 | 2130970 | 2022-01-19 | Warren | Pennsylvania | 42123 | 6349 | 190 |
2104925 | 2104925 | 2022-01-11 | Jefferson | Pennsylvania | 42065 | 7258 | 190 |
1877383 | 1877383 | 2021-11-02 | Crawford | Pennsylvania | 42039 | 11118 | 190 |
1874134 | 1874134 | 2021-11-01 | Crawford | Pennsylvania | 42039 | 11055 | 190 |
1870885 | 1870885 | 2021-10-31 | Crawford | Pennsylvania | 42039 | 11055 | 190 |
1867636 | 1867636 | 2021-10-30 | Crawford | Pennsylvania | 42039 | 11015 | 190 |
1864387 | 1864387 | 2021-10-29 | Crawford | Pennsylvania | 42039 | 10969 | 190 |
1861138 | 1861138 | 2021-10-28 | Crawford | Pennsylvania | 42039 | 10921 | 190 |
1835126 | 1835126 | 2021-10-20 | Armstrong | Pennsylvania | 42005 | 8532 | 190 |
1831877 | 1831877 | 2021-10-19 | Armstrong | Pennsylvania | 42005 | 8501 | 190 |
1831891 | 1831891 | 2021-10-19 | Clearfield | Pennsylvania | 42033 | 10867 | 190 |
1831918 | 1831918 | 2021-10-19 | Mifflin | Pennsylvania | 42087 | 6990 | 190 |
1828642 | 1828642 | 2021-10-18 | Clearfield | Pennsylvania | 42033 | 10825 | 190 |
1747432 | 1747432 | 2021-09-23 | Indiana | Pennsylvania | 42063 | 7716 | 190 |
1744182 | 1744182 | 2021-09-22 | Indiana | Pennsylvania | 42063 | 7668 | 190 |
1740933 | 1740933 | 2021-09-21 | Indiana | Pennsylvania | 42063 | 7636 | 190 |
1737684 | 1737684 | 2021-09-20 | Indiana | Pennsylvania | 42063 | 7585 | 190 |
1734434 | 1734434 | 2021-09-19 | Indiana | Pennsylvania | 42063 | 7559 | 190 |
1731184 | 1731184 | 2021-09-18 | Indiana | Pennsylvania | 42063 | 7519 | 190 |
1646696 | 1646696 | 2021-08-23 | Adams | Pennsylvania | 42001 | 10301 | 190 |
1643447 | 1643447 | 2021-08-22 | Adams | Pennsylvania | 42001 | 10273 | 190 |
1640197 | 1640197 | 2021-08-21 | Adams | Pennsylvania | 42001 | 10240 | 190 |
1636947 | 1636947 | 2021-08-20 | Adams | Pennsylvania | 42001 | 10223 | 190 |
1633697 | 1633697 | 2021-08-19 | Adams | Pennsylvania | 42001 | 10195 | 190 |
1630450 | 1630450 | 2021-08-18 | Adams | Pennsylvania | 42001 | 10165 | 190 |
1627203 | 1627203 | 2021-08-17 | Adams | Pennsylvania | 42001 | 10149 | 190 |
1623956 | 1623956 | 2021-08-16 | Adams | Pennsylvania | 42001 | 10118 | 190 |
1620709 | 1620709 | 2021-08-15 | Adams | Pennsylvania | 42001 | 10106 | 190 |
1617461 | 1617461 | 2021-08-14 | Adams | Pennsylvania | 42001 | 10082 | 190 |
1614213 | 1614213 | 2021-08-13 | Adams | Pennsylvania | 42001 | 10062 | 190 |
1610964 | 1610964 | 2021-08-12 | Adams | Pennsylvania | 42001 | 10035 | 190 |
1607716 | 1607716 | 2021-08-11 | Adams | Pennsylvania | 42001 | 10021 | 190 |
1604467 | 1604467 | 2021-08-10 | Adams | Pennsylvania | 42001 | 9994 | 190 |
1601218 | 1601218 | 2021-08-09 | Adams | Pennsylvania | 42001 | 9981 | 190 |
1597970 | 1597970 | 2021-08-08 | Adams | Pennsylvania | 42001 | 9956 | 190 |
1594721 | 1594721 | 2021-08-07 | Adams | Pennsylvania | 42001 | 9956 | 190 |
1591472 | 1591472 | 2021-08-06 | Adams | Pennsylvania | 42001 | 9932 | 190 |
1588223 | 1588223 | 2021-08-05 | Adams | Pennsylvania | 42001 | 9911 | 190 |
1584973 | 1584973 | 2021-08-04 | Adams | Pennsylvania | 42001 | 9893 | 190 |
1581723 | 1581723 | 2021-08-03 | Adams | Pennsylvania | 42001 | 9880 | 190 |
1578474 | 1578474 | 2021-08-02 | Adams | Pennsylvania | 42001 | 9867 | 190 |
1575226 | 1575226 | 2021-08-01 | Adams | Pennsylvania | 42001 | 9854 | 190 |
1571978 | 1571978 | 2021-07-31 | Adams | Pennsylvania | 42001 | 9833 | 190 |
1568730 | 1568730 | 2021-07-30 | Adams | Pennsylvania | 42001 | 9833 | 190 |
1565482 | 1565482 | 2021-07-29 | Adams | Pennsylvania | 42001 | 9821 | 190 |
1562234 | 1562234 | 2021-07-28 | Adams | Pennsylvania | 42001 | 9807 | 190 |
1558986 | 1558986 | 2021-07-27 | Adams | Pennsylvania | 42001 | 9794 | 190 |
1555739 | 1555739 | 2021-07-26 | Adams | Pennsylvania | 42001 | 9784 | 190 |
1552492 | 1552492 | 2021-07-25 | Adams | Pennsylvania | 42001 | 9779 | 190 |
1549245 | 1549245 | 2021-07-24 | Adams | Pennsylvania | 42001 | 9777 | 190 |
1545998 | 1545998 | 2021-07-23 | Adams | Pennsylvania | 42001 | 9769 | 190 |
1542751 | 1542751 | 2021-07-22 | Adams | Pennsylvania | 42001 | 9764 | 190 |
1195427 | 1195427 | 2021-04-06 | Somerset | Pennsylvania | 42111 | 7047 | 190 |
1192179 | 1192179 | 2021-04-05 | Somerset | Pennsylvania | 42111 | 7020 | 190 |
1188930 | 1188930 | 2021-04-04 | Somerset | Pennsylvania | 42111 | 7018 | 190 |
1185683 | 1185683 | 2021-04-03 | Somerset | Pennsylvania | 42111 | 7013 | 190 |
1182436 | 1182436 | 2021-04-02 | Somerset | Pennsylvania | 42111 | 6983 | 190 |
1179189 | 1179189 | 2021-04-01 | Somerset | Pennsylvania | 42111 | 6973 | 190 |
1130462 | 1130462 | 2021-03-17 | Lawrence | Pennsylvania | 42073 | 6316 | 190 |
1127215 | 1127215 | 2021-03-16 | Lawrence | Pennsylvania | 42073 | 6299 | 190 |
955215 | 955215 | 2021-01-22 | Washington | Pennsylvania | 42125 | 11822 | 190 |
867573 | 867573 | 2020-12-26 | Monroe | Pennsylvania | 42089 | 5687 | 190 |
864328 | 864328 | 2020-12-25 | Monroe | Pennsylvania | 42089 | 5611 | 190 |
825341 | 825341 | 2020-12-13 | Beaver | Pennsylvania | 42007 | 6171 | 190 |
653396 | 653396 | 2020-10-21 | Dauphin | Pennsylvania | 42043 | 4486 | 190 |
650169 | 650169 | 2020-10-20 | Luzerne | Pennsylvania | 42079 | 4781 | 190 |
646925 | 646925 | 2020-10-19 | Luzerne | Pennsylvania | 42079 | 4748 | 190 |
643679 | 643679 | 2020-10-18 | Luzerne | Pennsylvania | 42079 | 4703 | 190 |
640431 | 640431 | 2020-10-17 | Luzerne | Pennsylvania | 42079 | 4655 | 190 |
637185 | 637185 | 2020-10-16 | Luzerne | Pennsylvania | 42079 | 4594 | 190 |
633939 | 633939 | 2020-10-15 | Luzerne | Pennsylvania | 42079 | 4550 | 190 |
630694 | 630694 | 2020-10-14 | Luzerne | Pennsylvania | 42079 | 4496 | 190 |
627450 | 627450 | 2020-10-13 | Luzerne | Pennsylvania | 42079 | 4458 | 190 |
624208 | 624208 | 2020-10-12 | Luzerne | Pennsylvania | 42079 | 4426 | 190 |
620965 | 620965 | 2020-10-11 | Luzerne | Pennsylvania | 42079 | 4387 | 190 |
617722 | 617722 | 2020-10-10 | Luzerne | Pennsylvania | 42079 | 4346 | 190 |
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);