ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where deaths = 171 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469334 | 2469334 | 2022-05-03 | Wayne | Pennsylvania | 42127 | 10335 | 171 |
2466078 | 2466078 | 2022-05-02 | Wayne | Pennsylvania | 42127 | 10318 | 171 |
2462823 | 2462823 | 2022-05-01 | Wayne | Pennsylvania | 42127 | 10314 | 171 |
2459567 | 2459567 | 2022-04-30 | Wayne | Pennsylvania | 42127 | 10313 | 171 |
2456311 | 2456311 | 2022-04-29 | Wayne | Pennsylvania | 42127 | 10306 | 171 |
2222032 | 2222032 | 2022-02-16 | Juniata | Pennsylvania | 42067 | 4680 | 171 |
2218781 | 2218781 | 2022-02-15 | Juniata | Pennsylvania | 42067 | 4676 | 171 |
2108151 | 2108151 | 2022-01-12 | Bradford | Pennsylvania | 42015 | 11945 | 171 |
2078895 | 2078895 | 2022-01-03 | Clarion | Pennsylvania | 42031 | 6587 | 171 |
2075644 | 2075644 | 2022-01-02 | Clarion | Pennsylvania | 42031 | 6574 | 171 |
2072393 | 2072393 | 2022-01-01 | Clarion | Pennsylvania | 42031 | 6550 | 171 |
2069142 | 2069142 | 2021-12-31 | Clarion | Pennsylvania | 42031 | 6526 | 171 |
2065891 | 2065891 | 2021-12-30 | Clarion | Pennsylvania | 42031 | 6500 | 171 |
2062684 | 2062684 | 2021-12-29 | Tioga | Pennsylvania | 42117 | 6180 | 171 |
2059434 | 2059434 | 2021-12-28 | Tioga | Pennsylvania | 42117 | 6145 | 171 |
2023688 | 2023688 | 2021-12-17 | Warren | Pennsylvania | 42123 | 5453 | 171 |
2004140 | 2004140 | 2021-12-11 | Columbia | Pennsylvania | 42037 | 9934 | 171 |
2000889 | 2000889 | 2021-12-10 | Columbia | Pennsylvania | 42037 | 9857 | 171 |
1906641 | 1906641 | 2021-11-11 | Huntingdon | Pennsylvania | 42061 | 7037 | 171 |
1874119 | 1874119 | 2021-11-01 | Bedford | Pennsylvania | 42009 | 6856 | 171 |
1870870 | 1870870 | 2021-10-31 | Bedford | Pennsylvania | 42009 | 6856 | 171 |
1867621 | 1867621 | 2021-10-30 | Bedford | Pennsylvania | 42009 | 6828 | 171 |
1864372 | 1864372 | 2021-10-29 | Bedford | Pennsylvania | 42009 | 6800 | 171 |
1783159 | 1783159 | 2021-10-04 | Crawford | Pennsylvania | 42039 | 9712 | 171 |
1779910 | 1779910 | 2021-10-03 | Crawford | Pennsylvania | 42039 | 9700 | 171 |
1776643 | 1776643 | 2021-10-02 | Armstrong | Pennsylvania | 42005 | 7702 | 171 |
1776660 | 1776660 | 2021-10-02 | Crawford | Pennsylvania | 42039 | 9662 | 171 |
1773410 | 1773410 | 2021-10-01 | Crawford | Pennsylvania | 42039 | 9619 | 171 |
1770160 | 1770160 | 2021-09-30 | Crawford | Pennsylvania | 42039 | 9567 | 171 |
1766911 | 1766911 | 2021-09-29 | Crawford | Pennsylvania | 42039 | 9489 | 171 |
1727919 | 1727919 | 2021-09-17 | Clearfield | Pennsylvania | 42033 | 9726 | 171 |
1383704 | 1383704 | 2021-06-03 | Carbon | Pennsylvania | 42025 | 6368 | 171 |
1380458 | 1380458 | 2021-06-02 | Carbon | Pennsylvania | 42025 | 6367 | 171 |
1377213 | 1377213 | 2021-06-01 | Carbon | Pennsylvania | 42025 | 6362 | 171 |
1373967 | 1373967 | 2021-05-31 | Carbon | Pennsylvania | 42025 | 6360 | 171 |
1370722 | 1370722 | 2021-05-30 | Carbon | Pennsylvania | 42025 | 6357 | 171 |
1367476 | 1367476 | 2021-05-29 | Carbon | Pennsylvania | 42025 | 6356 | 171 |
1364230 | 1364230 | 2021-05-28 | Carbon | Pennsylvania | 42025 | 6350 | 171 |
1360984 | 1360984 | 2021-05-27 | Carbon | Pennsylvania | 42025 | 6345 | 171 |
1292823 | 1292823 | 2021-05-06 | Indiana | Pennsylvania | 42063 | 6045 | 171 |
1289577 | 1289577 | 2021-05-05 | Indiana | Pennsylvania | 42063 | 6015 | 171 |
1286331 | 1286331 | 2021-05-04 | Indiana | Pennsylvania | 42063 | 5989 | 171 |
1283054 | 1283054 | 2021-05-03 | Adams | Pennsylvania | 42001 | 9185 | 171 |
1283085 | 1283085 | 2021-05-03 | Indiana | Pennsylvania | 42063 | 5964 | 171 |
1279807 | 1279807 | 2021-05-02 | Adams | Pennsylvania | 42001 | 9168 | 171 |
1279838 | 1279838 | 2021-05-02 | Indiana | Pennsylvania | 42063 | 5953 | 171 |
1276560 | 1276560 | 2021-05-01 | Adams | Pennsylvania | 42001 | 9138 | 171 |
1276591 | 1276591 | 2021-05-01 | Indiana | Pennsylvania | 42063 | 5939 | 171 |
1273313 | 1273313 | 2021-04-30 | Adams | Pennsylvania | 42001 | 9113 | 171 |
1273344 | 1273344 | 2021-04-30 | Indiana | Pennsylvania | 42063 | 5925 | 171 |
1270066 | 1270066 | 2021-04-29 | Adams | Pennsylvania | 42001 | 9074 | 171 |
1266819 | 1266819 | 2021-04-28 | Adams | Pennsylvania | 42001 | 9050 | 171 |
971433 | 971433 | 2021-01-27 | Somerset | Pennsylvania | 42111 | 6232 | 171 |
942183 | 942183 | 2021-01-18 | Centre | Pennsylvania | 42027 | 10235 | 171 |
942232 | 942232 | 2021-01-18 | Washington | Pennsylvania | 42125 | 11448 | 171 |
938938 | 938938 | 2021-01-17 | Centre | Pennsylvania | 42027 | 10182 | 171 |
916251 | 916251 | 2021-01-10 | Mercer | Pennsylvania | 42085 | 6618 | 171 |
867538 | 867538 | 2020-12-26 | Butler | Pennsylvania | 42019 | 8635 | 171 |
604781 | 604781 | 2020-10-06 | York | Pennsylvania | 42133 | 5171 | 171 |
601539 | 601539 | 2020-10-05 | York | Pennsylvania | 42133 | 5125 | 171 |
546408 | 546408 | 2020-09-18 | Dauphin | Pennsylvania | 42043 | 3662 | 171 |
264169 | 264169 | 2020-06-22 | Luzerne | Pennsylvania | 42079 | 2870 | 171 |
261041 | 261041 | 2020-06-21 | Luzerne | Pennsylvania | 42079 | 2864 | 171 |
232973 | 232973 | 2020-06-12 | Allegheny | Pennsylvania | 42003 | 2065 | 171 |
229868 | 229868 | 2020-06-11 | Allegheny | Pennsylvania | 42003 | 2055 | 171 |
199019 | 199019 | 2020-06-01 | Lackawanna | Pennsylvania | 42069 | 1551 | 171 |
156376 | 156376 | 2020-05-18 | Northampton | Pennsylvania | 42095 | 2727 | 171 |
135316 | 135316 | 2020-05-11 | Berks | Pennsylvania | 42011 | 3417 | 171 |
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);