ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
143 rows where deaths = 26 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Adams 20
- Susquehanna 20
- Fulton 17
- Potter 16
- Lycoming 10
- Carbon 7
- Greene 5
- York 5
- Armstrong 3
- Forest 3
- Jefferson 3
- Perry 3
- Butler 2
- Clinton 2
- Fayette 2
- Juniata 2
- Pike 2
- Schuylkill 2
- Sullivan 2
- Union 2
- Wyoming 2
- Allegheny 1
- Blair 1
- Clearfield 1
- Cumberland 1
- Delaware 1
- Indiana 1
- Lackawanna 1
- Lawrence 1
- Luzerne 1
- …
state 1
- Pennsylvania · 143 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2020432 | 2020432 | 2021-12-16 | Sullivan | Pennsylvania | 42113 | 751 | 26 |
2017181 | 2017181 | 2021-12-15 | Sullivan | Pennsylvania | 42113 | 747 | 26 |
1929385 | 1929385 | 2021-11-18 | Forest | Pennsylvania | 42053 | 1671 | 26 |
1926135 | 1926135 | 2021-11-17 | Forest | Pennsylvania | 42053 | 1666 | 26 |
1922885 | 1922885 | 2021-11-16 | Forest | Pennsylvania | 42053 | 1663 | 26 |
1828654 | 1828654 | 2021-10-18 | Fulton | Pennsylvania | 42057 | 2130 | 26 |
1825405 | 1825405 | 2021-10-17 | Fulton | Pennsylvania | 42057 | 2123 | 26 |
1822156 | 1822156 | 2021-10-16 | Fulton | Pennsylvania | 42057 | 2117 | 26 |
1818907 | 1818907 | 2021-10-15 | Fulton | Pennsylvania | 42057 | 2108 | 26 |
1815658 | 1815658 | 2021-10-14 | Fulton | Pennsylvania | 42057 | 2096 | 26 |
1812410 | 1812410 | 2021-10-13 | Fulton | Pennsylvania | 42057 | 2086 | 26 |
1809161 | 1809161 | 2021-10-12 | Fulton | Pennsylvania | 42057 | 2078 | 26 |
1805911 | 1805911 | 2021-10-11 | Fulton | Pennsylvania | 42057 | 2052 | 26 |
1802661 | 1802661 | 2021-10-10 | Fulton | Pennsylvania | 42057 | 2048 | 26 |
1799412 | 1799412 | 2021-10-09 | Fulton | Pennsylvania | 42057 | 2041 | 26 |
1796163 | 1796163 | 2021-10-08 | Fulton | Pennsylvania | 42057 | 2032 | 26 |
1792914 | 1792914 | 2021-10-07 | Fulton | Pennsylvania | 42057 | 2022 | 26 |
1789665 | 1789665 | 2021-10-06 | Fulton | Pennsylvania | 42057 | 2013 | 26 |
1786417 | 1786417 | 2021-10-05 | Fulton | Pennsylvania | 42057 | 1998 | 26 |
1783168 | 1783168 | 2021-10-04 | Fulton | Pennsylvania | 42057 | 1977 | 26 |
1779919 | 1779919 | 2021-10-03 | Fulton | Pennsylvania | 42057 | 1961 | 26 |
1776669 | 1776669 | 2021-10-02 | Fulton | Pennsylvania | 42057 | 1953 | 26 |
1685727 | 1685727 | 2021-09-04 | Potter | Pennsylvania | 42105 | 1326 | 26 |
1682476 | 1682476 | 2021-09-03 | Potter | Pennsylvania | 42105 | 1320 | 26 |
1679226 | 1679226 | 2021-09-02 | Potter | Pennsylvania | 42105 | 1315 | 26 |
1675978 | 1675978 | 2021-09-01 | Potter | Pennsylvania | 42105 | 1314 | 26 |
1672731 | 1672731 | 2021-08-31 | Potter | Pennsylvania | 42105 | 1310 | 26 |
1669483 | 1669483 | 2021-08-30 | Potter | Pennsylvania | 42105 | 1308 | 26 |
1666236 | 1666236 | 2021-08-29 | Potter | Pennsylvania | 42105 | 1307 | 26 |
1662988 | 1662988 | 2021-08-28 | Potter | Pennsylvania | 42105 | 1302 | 26 |
1659740 | 1659740 | 2021-08-27 | Potter | Pennsylvania | 42105 | 1298 | 26 |
1656491 | 1656491 | 2021-08-26 | Potter | Pennsylvania | 42105 | 1296 | 26 |
1653244 | 1653244 | 2021-08-25 | Potter | Pennsylvania | 42105 | 1293 | 26 |
1649997 | 1649997 | 2021-08-24 | Potter | Pennsylvania | 42105 | 1290 | 26 |
1646748 | 1646748 | 2021-08-23 | Potter | Pennsylvania | 42105 | 1281 | 26 |
1643499 | 1643499 | 2021-08-22 | Potter | Pennsylvania | 42105 | 1280 | 26 |
1640249 | 1640249 | 2021-08-21 | Potter | Pennsylvania | 42105 | 1280 | 26 |
1636999 | 1636999 | 2021-08-20 | Potter | Pennsylvania | 42105 | 1279 | 26 |
948692 | 948692 | 2021-01-20 | Greene | Pennsylvania | 42059 | 2247 | 26 |
945446 | 945446 | 2021-01-19 | Greene | Pennsylvania | 42059 | 2223 | 26 |
942199 | 942199 | 2021-01-18 | Greene | Pennsylvania | 42059 | 2193 | 26 |
938954 | 938954 | 2021-01-17 | Greene | Pennsylvania | 42059 | 2178 | 26 |
935709 | 935709 | 2021-01-16 | Greene | Pennsylvania | 42059 | 2162 | 26 |
906515 | 906515 | 2021-01-07 | McKean | Pennsylvania | 42083 | 1930 | 26 |
900000 | 900000 | 2021-01-05 | Clinton | Pennsylvania | 42035 | 2066 | 26 |
896755 | 896755 | 2021-01-04 | Clinton | Pennsylvania | 42035 | 2054 | 26 |
880570 | 880570 | 2020-12-30 | Warren | Pennsylvania | 42123 | 1460 | 26 |
867578 | 867578 | 2020-12-26 | Perry | Pennsylvania | 42099 | 1582 | 26 |
864333 | 864333 | 2020-12-25 | Perry | Pennsylvania | 42099 | 1542 | 26 |
861088 | 861088 | 2020-12-24 | Perry | Pennsylvania | 42099 | 1521 | 26 |
851336 | 851336 | 2020-12-21 | Jefferson | Pennsylvania | 42065 | 1649 | 26 |
848091 | 848091 | 2020-12-20 | Jefferson | Pennsylvania | 42065 | 1618 | 26 |
848118 | 848118 | 2020-12-20 | Union | Pennsylvania | 42119 | 2453 | 26 |
844846 | 844846 | 2020-12-19 | Jefferson | Pennsylvania | 42065 | 1593 | 26 |
844873 | 844873 | 2020-12-19 | Union | Pennsylvania | 42119 | 2423 | 26 |
828600 | 828600 | 2020-12-14 | Clearfield | Pennsylvania | 42033 | 2861 | 26 |
825371 | 825371 | 2020-12-13 | Juniata | Pennsylvania | 42067 | 1018 | 26 |
822124 | 822124 | 2020-12-12 | Juniata | Pennsylvania | 42067 | 985 | 26 |
799399 | 799399 | 2020-12-05 | Fayette | Pennsylvania | 42051 | 2796 | 26 |
796154 | 796154 | 2020-12-04 | Fayette | Pennsylvania | 42051 | 2567 | 26 |
796194 | 796194 | 2020-12-04 | Wyoming | Pennsylvania | 42131 | 502 | 26 |
792949 | 792949 | 2020-12-03 | Wyoming | Pennsylvania | 42131 | 489 | 26 |
789690 | 789690 | 2020-12-02 | Pike | Pennsylvania | 42103 | 883 | 26 |
786445 | 786445 | 2020-12-01 | Pike | Pennsylvania | 42103 | 867 | 26 |
740987 | 740987 | 2020-11-17 | Indiana | Pennsylvania | 42063 | 1861 | 26 |
715005 | 715005 | 2020-11-09 | Armstrong | Pennsylvania | 42005 | 977 | 26 |
711761 | 711761 | 2020-11-08 | Armstrong | Pennsylvania | 42005 | 948 | 26 |
708517 | 708517 | 2020-11-07 | Armstrong | Pennsylvania | 42005 | 928 | 26 |
676124 | 676124 | 2020-10-28 | Mercer | Pennsylvania | 42085 | 1052 | 26 |
653381 | 653381 | 2020-10-21 | Blair | Pennsylvania | 42013 | 1077 | 26 |
650166 | 650166 | 2020-10-20 | Lawrence | Pennsylvania | 42073 | 741 | 26 |
640401 | 640401 | 2020-10-17 | Butler | Pennsylvania | 42019 | 1388 | 26 |
637155 | 637155 | 2020-10-16 | Butler | Pennsylvania | 42019 | 1365 | 26 |
627411 | 627411 | 2020-10-13 | Adams | Pennsylvania | 42001 | 945 | 26 |
624169 | 624169 | 2020-10-12 | Adams | Pennsylvania | 42001 | 939 | 26 |
620926 | 620926 | 2020-10-11 | Adams | Pennsylvania | 42001 | 935 | 26 |
617683 | 617683 | 2020-10-10 | Adams | Pennsylvania | 42001 | 929 | 26 |
614441 | 614441 | 2020-10-09 | Adams | Pennsylvania | 42001 | 916 | 26 |
614481 | 614481 | 2020-10-09 | Lycoming | Pennsylvania | 42081 | 807 | 26 |
611200 | 611200 | 2020-10-08 | Adams | Pennsylvania | 42001 | 910 | 26 |
611240 | 611240 | 2020-10-08 | Lycoming | Pennsylvania | 42081 | 795 | 26 |
607958 | 607958 | 2020-10-07 | Adams | Pennsylvania | 42001 | 897 | 26 |
607998 | 607998 | 2020-10-07 | Lycoming | Pennsylvania | 42081 | 771 | 26 |
604715 | 604715 | 2020-10-06 | Adams | Pennsylvania | 42001 | 891 | 26 |
604755 | 604755 | 2020-10-06 | Lycoming | Pennsylvania | 42081 | 753 | 26 |
601473 | 601473 | 2020-10-05 | Adams | Pennsylvania | 42001 | 885 | 26 |
601513 | 601513 | 2020-10-05 | Lycoming | Pennsylvania | 42081 | 751 | 26 |
598230 | 598230 | 2020-10-04 | Adams | Pennsylvania | 42001 | 880 | 26 |
598270 | 598270 | 2020-10-04 | Lycoming | Pennsylvania | 42081 | 744 | 26 |
594987 | 594987 | 2020-10-03 | Adams | Pennsylvania | 42001 | 864 | 26 |
595027 | 595027 | 2020-10-03 | Lycoming | Pennsylvania | 42081 | 724 | 26 |
591746 | 591746 | 2020-10-02 | Adams | Pennsylvania | 42001 | 864 | 26 |
591786 | 591786 | 2020-10-02 | Lycoming | Pennsylvania | 42081 | 724 | 26 |
588505 | 588505 | 2020-10-01 | Adams | Pennsylvania | 42001 | 854 | 26 |
588545 | 588545 | 2020-10-01 | Lycoming | Pennsylvania | 42081 | 718 | 26 |
585265 | 585265 | 2020-09-30 | Adams | Pennsylvania | 42001 | 852 | 26 |
585305 | 585305 | 2020-09-30 | Lycoming | Pennsylvania | 42081 | 709 | 26 |
582025 | 582025 | 2020-09-29 | Adams | Pennsylvania | 42001 | 837 | 26 |
578785 | 578785 | 2020-09-28 | Adams | Pennsylvania | 42001 | 835 | 26 |
575544 | 575544 | 2020-09-27 | Adams | Pennsylvania | 42001 | 833 | 26 |
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);