ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where deaths = 73 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Bradford 13
- Montour 13
- Cumberland 10
- Clinton 7
- Beaver 5
- Pike 5
- Greene 4
- Susquehanna 4
- Wyoming 4
- Elk 3
- Lebanon 3
- Potter 3
- Allegheny 2
- Clarion 2
- Columbia 2
- Dauphin 2
- Perry 2
- Snyder 2
- Warren 2
- Washington 2
- Blair 1
- Carbon 1
- Centre 1
- Huntingdon 1
- Indiana 1
- Jefferson 1
- Juniata 1
- Lycoming 1
- Mercer 1
- Mifflin 1
- …
state 1
- Pennsylvania · 105 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2075680 | 2075680 | 2022-01-02 | Pike | Pennsylvania | 42103 | 7287 | 73 |
2072429 | 2072429 | 2022-01-01 | Pike | Pennsylvania | 42103 | 7211 | 73 |
2069178 | 2069178 | 2021-12-31 | Pike | Pennsylvania | 42103 | 7168 | 73 |
2065927 | 2065927 | 2021-12-30 | Pike | Pennsylvania | 42103 | 7101 | 73 |
2062677 | 2062677 | 2021-12-29 | Pike | Pennsylvania | 42103 | 7046 | 73 |
2043151 | 2043151 | 2021-12-23 | Elk | Pennsylvania | 42047 | 5223 | 73 |
2039902 | 2039902 | 2021-12-22 | Elk | Pennsylvania | 42047 | 5208 | 73 |
2036652 | 2036652 | 2021-12-21 | Elk | Pennsylvania | 42047 | 5195 | 73 |
2033431 | 2033431 | 2021-12-20 | Potter | Pennsylvania | 42105 | 2532 | 73 |
2030181 | 2030181 | 2021-12-19 | Potter | Pennsylvania | 42105 | 2530 | 73 |
2026930 | 2026930 | 2021-12-18 | Potter | Pennsylvania | 42105 | 2523 | 73 |
2013904 | 2013904 | 2021-12-14 | Greene | Pennsylvania | 42059 | 6028 | 73 |
2013940 | 2013940 | 2021-12-14 | Wyoming | Pennsylvania | 42131 | 3521 | 73 |
2010653 | 2010653 | 2021-12-13 | Greene | Pennsylvania | 42059 | 6010 | 73 |
2010689 | 2010689 | 2021-12-13 | Wyoming | Pennsylvania | 42131 | 3506 | 73 |
2007402 | 2007402 | 2021-12-12 | Greene | Pennsylvania | 42059 | 6006 | 73 |
2007438 | 2007438 | 2021-12-12 | Wyoming | Pennsylvania | 42131 | 3483 | 73 |
2004151 | 2004151 | 2021-12-11 | Greene | Pennsylvania | 42059 | 5992 | 73 |
2004187 | 2004187 | 2021-12-11 | Wyoming | Pennsylvania | 42131 | 3465 | 73 |
1945668 | 1945668 | 2021-11-23 | Susquehanna | Pennsylvania | 42115 | 4409 | 73 |
1942417 | 1942417 | 2021-11-22 | Susquehanna | Pennsylvania | 42115 | 4369 | 73 |
1939167 | 1939167 | 2021-11-21 | Susquehanna | Pennsylvania | 42115 | 4355 | 73 |
1935917 | 1935917 | 2021-11-20 | Susquehanna | Pennsylvania | 42115 | 4332 | 73 |
1919656 | 1919656 | 2021-11-15 | Montour | Pennsylvania | 42093 | 2701 | 73 |
1916406 | 1916406 | 2021-11-14 | Montour | Pennsylvania | 42093 | 2701 | 73 |
1913156 | 1913156 | 2021-11-13 | Montour | Pennsylvania | 42093 | 2685 | 73 |
1909906 | 1909906 | 2021-11-12 | Montour | Pennsylvania | 42093 | 2614 | 73 |
1906657 | 1906657 | 2021-11-11 | Montour | Pennsylvania | 42093 | 2609 | 73 |
1903408 | 1903408 | 2021-11-10 | Montour | Pennsylvania | 42093 | 2599 | 73 |
1900158 | 1900158 | 2021-11-09 | Montour | Pennsylvania | 42093 | 2591 | 73 |
1896908 | 1896908 | 2021-11-08 | Montour | Pennsylvania | 42093 | 2587 | 73 |
1893658 | 1893658 | 2021-11-07 | Montour | Pennsylvania | 42093 | 2587 | 73 |
1890408 | 1890408 | 2021-11-06 | Montour | Pennsylvania | 42093 | 2585 | 73 |
1887158 | 1887158 | 2021-11-05 | Montour | Pennsylvania | 42093 | 2566 | 73 |
1883908 | 1883908 | 2021-11-04 | Montour | Pennsylvania | 42093 | 2561 | 73 |
1880659 | 1880659 | 2021-11-03 | Montour | Pennsylvania | 42093 | 2553 | 73 |
1854638 | 1854638 | 2021-10-26 | Clinton | Pennsylvania | 42035 | 4889 | 73 |
1851389 | 1851389 | 2021-10-25 | Clinton | Pennsylvania | 42035 | 4875 | 73 |
1848139 | 1848139 | 2021-10-24 | Clinton | Pennsylvania | 42035 | 4857 | 73 |
1844889 | 1844889 | 2021-10-23 | Clinton | Pennsylvania | 42035 | 4839 | 73 |
1841639 | 1841639 | 2021-10-22 | Clinton | Pennsylvania | 42035 | 4809 | 73 |
1838390 | 1838390 | 2021-10-21 | Clinton | Pennsylvania | 42035 | 4789 | 73 |
1835141 | 1835141 | 2021-10-20 | Clinton | Pennsylvania | 42035 | 4763 | 73 |
1195435 | 1195435 | 2021-04-06 | Wayne | Pennsylvania | 42127 | 3482 | 73 |
1039545 | 1039545 | 2021-02-17 | Bradford | Pennsylvania | 42015 | 4189 | 73 |
1036300 | 1036300 | 2021-02-16 | Bradford | Pennsylvania | 42015 | 4178 | 73 |
1033055 | 1033055 | 2021-02-15 | Bradford | Pennsylvania | 42015 | 4166 | 73 |
1029809 | 1029809 | 2021-02-14 | Bradford | Pennsylvania | 42015 | 4158 | 73 |
1026562 | 1026562 | 2021-02-13 | Bradford | Pennsylvania | 42015 | 4155 | 73 |
1023317 | 1023317 | 2021-02-12 | Bradford | Pennsylvania | 42015 | 4133 | 73 |
1023364 | 1023364 | 2021-02-12 | Snyder | Pennsylvania | 42109 | 2890 | 73 |
1020072 | 1020072 | 2021-02-11 | Bradford | Pennsylvania | 42015 | 4128 | 73 |
1020119 | 1020119 | 2021-02-11 | Snyder | Pennsylvania | 42109 | 2879 | 73 |
1016827 | 1016827 | 2021-02-10 | Bradford | Pennsylvania | 42015 | 4117 | 73 |
1013582 | 1013582 | 2021-02-09 | Bradford | Pennsylvania | 42015 | 4102 | 73 |
1010337 | 1010337 | 2021-02-08 | Bradford | Pennsylvania | 42015 | 4073 | 73 |
1007091 | 1007091 | 2021-02-07 | Bradford | Pennsylvania | 42015 | 4060 | 73 |
1003845 | 1003845 | 2021-02-06 | Bradford | Pennsylvania | 42015 | 4038 | 73 |
1000599 | 1000599 | 2021-02-05 | Bradford | Pennsylvania | 42015 | 4019 | 73 |
981163 | 981163 | 2021-01-30 | Perry | Pennsylvania | 42099 | 2548 | 73 |
977883 | 977883 | 2021-01-29 | Clarion | Pennsylvania | 42031 | 2453 | 73 |
977917 | 977917 | 2021-01-29 | Perry | Pennsylvania | 42099 | 2524 | 73 |
974638 | 974638 | 2021-01-28 | Clarion | Pennsylvania | 42031 | 2443 | 73 |
974655 | 974655 | 2021-01-28 | Jefferson | Pennsylvania | 42065 | 2479 | 73 |
951941 | 951941 | 2021-01-21 | Juniata | Pennsylvania | 42067 | 1623 | 73 |
945478 | 945478 | 2021-01-19 | Warren | Pennsylvania | 42123 | 1872 | 73 |
942231 | 942231 | 2021-01-18 | Warren | Pennsylvania | 42123 | 1869 | 73 |
909777 | 909777 | 2021-01-08 | Tioga | Pennsylvania | 42117 | 2043 | 73 |
890264 | 890264 | 2021-01-02 | Columbia | Pennsylvania | 42037 | 2860 | 73 |
887017 | 887017 | 2021-01-01 | Columbia | Pennsylvania | 42037 | 2818 | 73 |
877319 | 877319 | 2020-12-29 | Somerset | Pennsylvania | 42111 | 4697 | 73 |
838353 | 838353 | 2020-12-17 | Huntingdon | Pennsylvania | 42061 | 2409 | 73 |
831871 | 831871 | 2020-12-15 | Lycoming | Pennsylvania | 42081 | 4108 | 73 |
822122 | 822122 | 2020-12-12 | Indiana | Pennsylvania | 42063 | 3277 | 73 |
822133 | 822133 | 2020-12-12 | Mercer | Pennsylvania | 42085 | 4292 | 73 |
822134 | 822134 | 2020-12-12 | Mifflin | Pennsylvania | 42087 | 2655 | 73 |
818857 | 818857 | 2020-12-11 | Carbon | Pennsylvania | 42025 | 1875 | 73 |
796142 | 796142 | 2020-12-04 | Centre | Pennsylvania | 42027 | 6657 | 73 |
792890 | 792890 | 2020-12-03 | Blair | Pennsylvania | 42013 | 4607 | 73 |
792946 | 792946 | 2020-12-03 | Washington | Pennsylvania | 42125 | 4987 | 73 |
789701 | 789701 | 2020-12-02 | Washington | Pennsylvania | 42125 | 4802 | 73 |
715040 | 715040 | 2020-11-09 | Lebanon | Pennsylvania | 42075 | 3664 | 73 |
711796 | 711796 | 2020-11-08 | Lebanon | Pennsylvania | 42075 | 3622 | 73 |
708552 | 708552 | 2020-11-07 | Lebanon | Pennsylvania | 42075 | 3569 | 73 |
646939 | 646939 | 2020-10-19 | Schuylkill | Pennsylvania | 42107 | 1632 | 73 |
611248 | 611248 | 2020-10-08 | Northumberland | Pennsylvania | 42097 | 1227 | 73 |
539934 | 539934 | 2020-09-16 | Cumberland | Pennsylvania | 42041 | 1701 | 73 |
536697 | 536697 | 2020-09-15 | Cumberland | Pennsylvania | 42041 | 1696 | 73 |
533461 | 533461 | 2020-09-14 | Cumberland | Pennsylvania | 42041 | 1685 | 73 |
530226 | 530226 | 2020-09-13 | Cumberland | Pennsylvania | 42041 | 1661 | 73 |
526989 | 526989 | 2020-09-12 | Cumberland | Pennsylvania | 42041 | 1661 | 73 |
523753 | 523753 | 2020-09-11 | Cumberland | Pennsylvania | 42041 | 1649 | 73 |
520517 | 520517 | 2020-09-10 | Cumberland | Pennsylvania | 42041 | 1638 | 73 |
517281 | 517281 | 2020-09-09 | Cumberland | Pennsylvania | 42041 | 1634 | 73 |
514046 | 514046 | 2020-09-08 | Cumberland | Pennsylvania | 42041 | 1619 | 73 |
510813 | 510813 | 2020-09-07 | Cumberland | Pennsylvania | 42041 | 1608 | 73 |
198988 | 198988 | 2020-06-01 | Beaver | Pennsylvania | 42007 | 590 | 73 |
195915 | 195915 | 2020-05-31 | Beaver | Pennsylvania | 42007 | 590 | 73 |
195933 | 195933 | 2020-05-31 | Dauphin | Pennsylvania | 42043 | 1277 | 73 |
192846 | 192846 | 2020-05-30 | Beaver | Pennsylvania | 42007 | 589 | 73 |
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);