ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where deaths = 116 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2137432 | 2137432 | 2022-01-21 | Clinton | Pennsylvania | 42035 | 8045 | 116 |
2134178 | 2134178 | 2022-01-20 | Clinton | Pennsylvania | 42035 | 7962 | 116 |
2010678 | 2010678 | 2021-12-13 | Snyder | Pennsylvania | 42109 | 5722 | 116 |
2007427 | 2007427 | 2021-12-12 | Snyder | Pennsylvania | 42109 | 5708 | 116 |
2004176 | 2004176 | 2021-12-11 | Snyder | Pennsylvania | 42109 | 5681 | 116 |
2000925 | 2000925 | 2021-12-10 | Snyder | Pennsylvania | 42109 | 5650 | 116 |
1997675 | 1997675 | 2021-12-09 | Snyder | Pennsylvania | 42109 | 5606 | 116 |
1994424 | 1994424 | 2021-12-08 | Snyder | Pennsylvania | 42109 | 5586 | 116 |
1991173 | 1991173 | 2021-12-07 | Snyder | Pennsylvania | 42109 | 5553 | 116 |
1987922 | 1987922 | 2021-12-06 | Snyder | Pennsylvania | 42109 | 5519 | 116 |
1987927 | 1987927 | 2021-12-06 | Union | Pennsylvania | 42119 | 8295 | 116 |
1984672 | 1984672 | 2021-12-05 | Snyder | Pennsylvania | 42109 | 5509 | 116 |
1984677 | 1984677 | 2021-12-05 | Union | Pennsylvania | 42119 | 8287 | 116 |
1981422 | 1981422 | 2021-12-04 | Snyder | Pennsylvania | 42109 | 5492 | 116 |
1981427 | 1981427 | 2021-12-04 | Union | Pennsylvania | 42119 | 8264 | 116 |
1887145 | 1887145 | 2021-11-05 | Juniata | Pennsylvania | 42067 | 2966 | 116 |
1883895 | 1883895 | 2021-11-04 | Juniata | Pennsylvania | 42067 | 2960 | 116 |
1880646 | 1880646 | 2021-11-03 | Juniata | Pennsylvania | 42067 | 2941 | 116 |
1877397 | 1877397 | 2021-11-02 | Juniata | Pennsylvania | 42067 | 2929 | 116 |
1874148 | 1874148 | 2021-11-01 | Juniata | Pennsylvania | 42067 | 2919 | 116 |
1870899 | 1870899 | 2021-10-31 | Juniata | Pennsylvania | 42067 | 2919 | 116 |
1867650 | 1867650 | 2021-10-30 | Juniata | Pennsylvania | 42067 | 2912 | 116 |
1864401 | 1864401 | 2021-10-29 | Juniata | Pennsylvania | 42067 | 2906 | 116 |
1831924 | 1831924 | 2021-10-19 | Perry | Pennsylvania | 42099 | 5156 | 116 |
1828675 | 1828675 | 2021-10-18 | Perry | Pennsylvania | 42099 | 5130 | 116 |
1825426 | 1825426 | 2021-10-17 | Perry | Pennsylvania | 42099 | 5118 | 116 |
1822177 | 1822177 | 2021-10-16 | Perry | Pennsylvania | 42099 | 5109 | 116 |
1818928 | 1818928 | 2021-10-15 | Perry | Pennsylvania | 42099 | 5096 | 116 |
1815645 | 1815645 | 2021-10-14 | Clarion | Pennsylvania | 42031 | 4436 | 116 |
1812397 | 1812397 | 2021-10-13 | Clarion | Pennsylvania | 42031 | 4396 | 116 |
1783201 | 1783201 | 2021-10-04 | Warren | Pennsylvania | 42123 | 3424 | 116 |
1779952 | 1779952 | 2021-10-03 | Warren | Pennsylvania | 42123 | 3415 | 116 |
1776702 | 1776702 | 2021-10-02 | Warren | Pennsylvania | 42123 | 3395 | 116 |
1773452 | 1773452 | 2021-10-01 | Warren | Pennsylvania | 42123 | 3369 | 116 |
1770202 | 1770202 | 2021-09-30 | Warren | Pennsylvania | 42123 | 3345 | 116 |
1747459 | 1747459 | 2021-09-23 | Tioga | Pennsylvania | 42117 | 3808 | 116 |
1744209 | 1744209 | 2021-09-22 | Tioga | Pennsylvania | 42117 | 3796 | 116 |
1740960 | 1740960 | 2021-09-21 | Tioga | Pennsylvania | 42117 | 3733 | 116 |
1123935 | 1123935 | 2021-03-15 | Armstrong | Pennsylvania | 42005 | 4992 | 116 |
1120689 | 1120689 | 2021-03-14 | Armstrong | Pennsylvania | 42005 | 4989 | 116 |
1117442 | 1117442 | 2021-03-13 | Armstrong | Pennsylvania | 42005 | 4985 | 116 |
1114195 | 1114195 | 2021-03-12 | Armstrong | Pennsylvania | 42005 | 4978 | 116 |
1110949 | 1110949 | 2021-03-11 | Armstrong | Pennsylvania | 42005 | 4966 | 116 |
1107703 | 1107703 | 2021-03-10 | Armstrong | Pennsylvania | 42005 | 4958 | 116 |
1104457 | 1104457 | 2021-03-09 | Armstrong | Pennsylvania | 42005 | 4950 | 116 |
1101211 | 1101211 | 2021-03-08 | Armstrong | Pennsylvania | 42005 | 4948 | 116 |
1097965 | 1097965 | 2021-03-07 | Armstrong | Pennsylvania | 42005 | 4943 | 116 |
1097979 | 1097979 | 2021-03-07 | Clearfield | Pennsylvania | 42033 | 6434 | 116 |
1094717 | 1094717 | 2021-03-06 | Armstrong | Pennsylvania | 42005 | 4941 | 116 |
1094731 | 1094731 | 2021-03-06 | Clearfield | Pennsylvania | 42033 | 6412 | 116 |
1091471 | 1091471 | 2021-03-05 | Armstrong | Pennsylvania | 42005 | 4936 | 116 |
1088225 | 1088225 | 2021-03-04 | Armstrong | Pennsylvania | 42005 | 4923 | 116 |
1084980 | 1084980 | 2021-03-03 | Armstrong | Pennsylvania | 42005 | 4918 | 116 |
1081734 | 1081734 | 2021-03-02 | Armstrong | Pennsylvania | 42005 | 4914 | 116 |
1078488 | 1078488 | 2021-03-01 | Armstrong | Pennsylvania | 42005 | 4909 | 116 |
1075243 | 1075243 | 2021-02-28 | Armstrong | Pennsylvania | 42005 | 4906 | 116 |
1071997 | 1071997 | 2021-02-27 | Armstrong | Pennsylvania | 42005 | 4902 | 116 |
1068751 | 1068751 | 2021-02-26 | Armstrong | Pennsylvania | 42005 | 4891 | 116 |
1065506 | 1065506 | 2021-02-25 | Armstrong | Pennsylvania | 42005 | 4886 | 116 |
1062261 | 1062261 | 2021-02-24 | Armstrong | Pennsylvania | 42005 | 4876 | 116 |
1059016 | 1059016 | 2021-02-23 | Armstrong | Pennsylvania | 42005 | 4868 | 116 |
1055770 | 1055770 | 2021-02-22 | Armstrong | Pennsylvania | 42005 | 4859 | 116 |
1052524 | 1052524 | 2021-02-21 | Armstrong | Pennsylvania | 42005 | 4857 | 116 |
1049277 | 1049277 | 2021-02-20 | Armstrong | Pennsylvania | 42005 | 4851 | 116 |
1010360 | 1010360 | 2021-02-08 | Huntingdon | Pennsylvania | 42061 | 3965 | 116 |
1007114 | 1007114 | 2021-02-07 | Huntingdon | Pennsylvania | 42061 | 3963 | 116 |
1003868 | 1003868 | 2021-02-06 | Huntingdon | Pennsylvania | 42061 | 3936 | 116 |
987626 | 987626 | 2021-02-01 | Columbia | Pennsylvania | 42037 | 4175 | 116 |
984379 | 984379 | 2021-01-31 | Columbia | Pennsylvania | 42037 | 4163 | 116 |
981132 | 981132 | 2021-01-30 | Columbia | Pennsylvania | 42037 | 4142 | 116 |
925945 | 925945 | 2021-01-13 | Adams | Pennsylvania | 42001 | 5508 | 116 |
880552 | 880552 | 2020-12-30 | Mifflin | Pennsylvania | 42087 | 3389 | 116 |
877304 | 877304 | 2020-12-29 | Lycoming | Pennsylvania | 42081 | 5797 | 116 |
854611 | 854611 | 2020-12-22 | Washington | Pennsylvania | 42125 | 7824 | 116 |
831837 | 831837 | 2020-12-15 | Blair | Pennsylvania | 42013 | 6448 | 116 |
818869 | 818869 | 2020-12-11 | Erie | Pennsylvania | 42049 | 7901 | 116 |
812363 | 812363 | 2020-12-09 | Cambria | Pennsylvania | 42021 | 6278 | 116 |
786421 | 786421 | 2020-12-01 | Franklin | Pennsylvania | 42055 | 4662 | 116 |
728024 | 728024 | 2020-11-13 | Northumberland | Pennsylvania | 42097 | 1893 | 116 |
724780 | 724780 | 2020-11-12 | Northumberland | Pennsylvania | 42097 | 1856 | 116 |
715056 | 715056 | 2020-11-09 | Schuylkill | Pennsylvania | 42107 | 2506 | 116 |
552868 | 552868 | 2020-09-20 | Beaver | Pennsylvania | 42007 | 1836 | 116 |
549629 | 549629 | 2020-09-19 | Beaver | Pennsylvania | 42007 | 1834 | 116 |
472057 | 472057 | 2020-08-26 | York | Pennsylvania | 42133 | 3189 | 116 |
468825 | 468825 | 2020-08-25 | York | Pennsylvania | 42133 | 3158 | 116 |
346497 | 346497 | 2020-07-18 | Monroe | Pennsylvania | 42089 | 1494 | 116 |
251655 | 251655 | 2020-06-18 | Dauphin | Pennsylvania | 42043 | 1708 | 116 |
100205 | 100205 | 2020-04-29 | Berks | Pennsylvania | 42011 | 2637 | 116 |
77670 | 77670 | 2020-04-21 | Bucks | Pennsylvania | 42017 | 2067 | 116 |
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);