ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 127 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501864 | 2501864 | 2022-05-13 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2498606 | 2498606 | 2022-05-12 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2495348 | 2495348 | 2022-05-11 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2492090 | 2492090 | 2022-05-10 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2488832 | 2488832 | 2022-05-09 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2485575 | 2485575 | 2022-05-08 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2482317 | 2482317 | 2022-05-07 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2479059 | 2479059 | 2022-05-06 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2475801 | 2475801 | 2022-05-05 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2472544 | 2472544 | 2022-05-04 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2179755 | 2179755 | 2022-02-03 | McKean | Pennsylvania | 42083 | 7744 | 127 |
2176504 | 2176504 | 2022-02-02 | McKean | Pennsylvania | 42083 | 7723 | 127 |
2075683 | 2075683 | 2022-01-02 | Snyder | Pennsylvania | 42109 | 6313 | 127 |
2072432 | 2072432 | 2022-01-01 | Snyder | Pennsylvania | 42109 | 6303 | 127 |
2069181 | 2069181 | 2021-12-31 | Snyder | Pennsylvania | 42109 | 6283 | 127 |
2065930 | 2065930 | 2021-12-30 | Snyder | Pennsylvania | 42109 | 6239 | 127 |
2039938 | 2039938 | 2021-12-22 | Union | Pennsylvania | 42119 | 8736 | 127 |
2036688 | 2036688 | 2021-12-21 | Union | Pennsylvania | 42119 | 8711 | 127 |
1994433 | 1994433 | 2021-12-08 | Wayne | Pennsylvania | 42127 | 6794 | 127 |
1913117 | 1913117 | 2021-11-13 | Bradford | Pennsylvania | 42015 | 8488 | 127 |
1896911 | 1896911 | 2021-11-08 | Perry | Pennsylvania | 42099 | 5427 | 127 |
1893661 | 1893661 | 2021-11-07 | Perry | Pennsylvania | 42099 | 5416 | 127 |
1890411 | 1890411 | 2021-11-06 | Perry | Pennsylvania | 42099 | 5407 | 127 |
1887161 | 1887161 | 2021-11-05 | Perry | Pennsylvania | 42099 | 5387 | 127 |
1880628 | 1880628 | 2021-11-03 | Clarion | Pennsylvania | 42031 | 4951 | 127 |
1198651 | 1198651 | 2021-04-07 | Huntingdon | Pennsylvania | 42061 | 4629 | 127 |
1195402 | 1195402 | 2021-04-06 | Huntingdon | Pennsylvania | 42061 | 4614 | 127 |
1192154 | 1192154 | 2021-04-05 | Huntingdon | Pennsylvania | 42061 | 4606 | 127 |
1188905 | 1188905 | 2021-04-04 | Huntingdon | Pennsylvania | 42061 | 4603 | 127 |
1169411 | 1169411 | 2021-03-29 | Columbia | Pennsylvania | 42037 | 4912 | 127 |
1042787 | 1042787 | 2021-02-18 | Bedford | Pennsylvania | 42009 | 3760 | 127 |
1039542 | 1039542 | 2021-02-17 | Bedford | Pennsylvania | 42009 | 3758 | 127 |
1036297 | 1036297 | 2021-02-16 | Bedford | Pennsylvania | 42009 | 3751 | 127 |
1033052 | 1033052 | 2021-02-15 | Bedford | Pennsylvania | 42009 | 3741 | 127 |
1029806 | 1029806 | 2021-02-14 | Bedford | Pennsylvania | 42009 | 3735 | 127 |
1026559 | 1026559 | 2021-02-13 | Bedford | Pennsylvania | 42009 | 3736 | 127 |
1023314 | 1023314 | 2021-02-12 | Bedford | Pennsylvania | 42009 | 3729 | 127 |
994112 | 994112 | 2021-02-03 | Carbon | Pennsylvania | 42025 | 4456 | 127 |
990866 | 990866 | 2021-02-02 | Carbon | Pennsylvania | 42025 | 4440 | 127 |
974642 | 974642 | 2021-01-28 | Crawford | Pennsylvania | 42039 | 5846 | 127 |
900023 | 900023 | 2021-01-05 | Lycoming | Pennsylvania | 42081 | 6373 | 127 |
893523 | 893523 | 2021-01-03 | Indiana | Pennsylvania | 42063 | 4035 | 127 |
874061 | 874061 | 2020-12-28 | Mercer | Pennsylvania | 42085 | 5721 | 127 |
870816 | 870816 | 2020-12-27 | Mercer | Pennsylvania | 42085 | 5698 | 127 |
857807 | 857807 | 2020-12-23 | Centre | Pennsylvania | 42027 | 8450 | 127 |
838329 | 838329 | 2020-12-17 | Blair | Pennsylvania | 42013 | 6644 | 127 |
721542 | 721542 | 2020-11-11 | Schuylkill | Pennsylvania | 42107 | 2643 | 127 |
594990 | 594990 | 2020-10-03 | Beaver | Pennsylvania | 42007 | 1953 | 127 |
501160 | 501160 | 2020-09-04 | York | Pennsylvania | 42133 | 3667 | 127 |
497926 | 497926 | 2020-09-03 | York | Pennsylvania | 42133 | 3618 | 127 |
494693 | 494693 | 2020-09-02 | York | Pennsylvania | 42133 | 3490 | 127 |
491437 | 491437 | 2020-09-01 | Monroe | Pennsylvania | 42089 | 1716 | 127 |
488204 | 488204 | 2020-08-31 | Monroe | Pennsylvania | 42089 | 1714 | 127 |
484971 | 484971 | 2020-08-30 | Monroe | Pennsylvania | 42089 | 1712 | 127 |
481736 | 481736 | 2020-08-29 | Monroe | Pennsylvania | 42089 | 1713 | 127 |
478502 | 478502 | 2020-08-28 | Monroe | Pennsylvania | 42089 | 1711 | 127 |
475269 | 475269 | 2020-08-27 | Monroe | Pennsylvania | 42089 | 1704 | 127 |
472035 | 472035 | 2020-08-26 | Monroe | Pennsylvania | 42089 | 1700 | 127 |
468803 | 468803 | 2020-08-25 | Monroe | Pennsylvania | 42089 | 1701 | 127 |
465575 | 465575 | 2020-08-24 | Monroe | Pennsylvania | 42089 | 1694 | 127 |
462346 | 462346 | 2020-08-23 | Monroe | Pennsylvania | 42089 | 1690 | 127 |
459118 | 459118 | 2020-08-22 | Monroe | Pennsylvania | 42089 | 1688 | 127 |
455890 | 455890 | 2020-08-21 | Monroe | Pennsylvania | 42089 | 1686 | 127 |
270413 | 270413 | 2020-06-24 | Dauphin | Pennsylvania | 42043 | 1864 | 127 |
159384 | 159384 | 2020-05-19 | Lackawanna | Pennsylvania | 42069 | 1374 | 127 |
153351 | 153351 | 2020-05-17 | Luzerne | Pennsylvania | 42079 | 2526 | 127 |
150340 | 150340 | 2020-05-16 | Luzerne | Pennsylvania | 42079 | 2513 | 127 |
147333 | 147333 | 2020-05-15 | Luzerne | Pennsylvania | 42079 | 2491 | 127 |
138302 | 138302 | 2020-05-12 | Allegheny | Pennsylvania | 42003 | 1526 | 127 |
55740 | 55740 | 2020-04-13 | Philadelphia | Pennsylvania | 42101 | 6810 | 127 |
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);