ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 211 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2153702 | 2153702 | 2022-01-26 | Columbia | Pennsylvania | 42037 | 13579 | 211 |
2130969 | 2130969 | 2022-01-19 | Venango | Pennsylvania | 42121 | 10046 | 211 |
2127715 | 2127715 | 2022-01-18 | Venango | Pennsylvania | 42121 | 9998 | 211 |
2124463 | 2124463 | 2022-01-17 | Venango | Pennsylvania | 42121 | 9955 | 211 |
2121211 | 2121211 | 2022-01-16 | Venango | Pennsylvania | 42121 | 9882 | 211 |
2117959 | 2117959 | 2022-01-15 | Venango | Pennsylvania | 42121 | 9785 | 211 |
1965130 | 1965130 | 2021-11-29 | Carbon | Pennsylvania | 42025 | 9990 | 211 |
1961878 | 1961878 | 2021-11-28 | Carbon | Pennsylvania | 42025 | 9928 | 211 |
1958627 | 1958627 | 2021-11-27 | Carbon | Pennsylvania | 42025 | 9877 | 211 |
1955376 | 1955376 | 2021-11-26 | Carbon | Pennsylvania | 42025 | 9851 | 211 |
1952125 | 1952125 | 2021-11-25 | Carbon | Pennsylvania | 42025 | 9804 | 211 |
1932629 | 1932629 | 2021-11-19 | Crawford | Pennsylvania | 42039 | 12510 | 211 |
1922875 | 1922875 | 2021-11-16 | Clearfield | Pennsylvania | 42033 | 12090 | 211 |
1828626 | 1828626 | 2021-10-18 | Adams | Pennsylvania | 42001 | 12842 | 211 |
1825377 | 1825377 | 2021-10-17 | Adams | Pennsylvania | 42001 | 12818 | 211 |
1822128 | 1822128 | 2021-10-16 | Adams | Pennsylvania | 42001 | 12772 | 211 |
1818879 | 1818879 | 2021-10-15 | Adams | Pennsylvania | 42001 | 12709 | 211 |
1812413 | 1812413 | 2021-10-13 | Indiana | Pennsylvania | 42063 | 8450 | 211 |
1383728 | 1383728 | 2021-06-03 | Lawrence | Pennsylvania | 42073 | 7597 | 211 |
1380482 | 1380482 | 2021-06-02 | Lawrence | Pennsylvania | 42073 | 7593 | 211 |
1377237 | 1377237 | 2021-06-01 | Lawrence | Pennsylvania | 42073 | 7586 | 211 |
1373991 | 1373991 | 2021-05-31 | Lawrence | Pennsylvania | 42073 | 7580 | 211 |
1370746 | 1370746 | 2021-05-30 | Lawrence | Pennsylvania | 42073 | 7579 | 211 |
1367500 | 1367500 | 2021-05-29 | Lawrence | Pennsylvania | 42073 | 7576 | 211 |
1364254 | 1364254 | 2021-05-28 | Lawrence | Pennsylvania | 42073 | 7574 | 211 |
1361008 | 1361008 | 2021-05-27 | Lawrence | Pennsylvania | 42073 | 7562 | 211 |
1357762 | 1357762 | 2021-05-26 | Lawrence | Pennsylvania | 42073 | 7551 | 211 |
1357781 | 1357781 | 2021-05-26 | Somerset | Pennsylvania | 42111 | 7951 | 211 |
1091482 | 1091482 | 2021-03-05 | Centre | Pennsylvania | 42027 | 13093 | 211 |
1088236 | 1088236 | 2021-03-04 | Centre | Pennsylvania | 42027 | 13050 | 211 |
1084991 | 1084991 | 2021-03-03 | Centre | Pennsylvania | 42027 | 13000 | 211 |
961686 | 961686 | 2021-01-24 | Mercer | Pennsylvania | 42085 | 7271 | 211 |
874046 | 874046 | 2020-12-28 | Franklin | Pennsylvania | 42055 | 8294 | 211 |
854559 | 854559 | 2020-12-22 | Cambria | Pennsylvania | 42021 | 8131 | 211 |
831884 | 831884 | 2020-12-15 | Schuylkill | Pennsylvania | 42107 | 5786 | 211 |
753962 | 753962 | 2020-11-21 | Dauphin | Pennsylvania | 42043 | 6756 | 211 |
750716 | 750716 | 2020-11-20 | Dauphin | Pennsylvania | 42043 | 6637 | 211 |
705311 | 705311 | 2020-11-06 | Luzerne | Pennsylvania | 42079 | 5948 | 211 |
705338 | 705338 | 2020-11-06 | York | Pennsylvania | 42133 | 7072 | 211 |
356060 | 356060 | 2020-07-21 | Allegheny | Pennsylvania | 42003 | 6574 | 211 |
336892 | 336892 | 2020-07-15 | Lackawanna | Pennsylvania | 42069 | 1771 | 211 |
333698 | 333698 | 2020-07-14 | Lackawanna | Pennsylvania | 42069 | 1770 | 211 |
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);