ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where deaths = 55 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Pike 20
- Wyoming 14
- Clinton 13
- Fulton 11
- Lebanon 10
- Franklin 5
- Montour 4
- Clearfield 3
- Columbia 3
- Greene 3
- Monroe 3
- Snyder 3
- Wayne 3
- Elk 2
- Jefferson 2
- Juniata 2
- Northumberland 2
- Perry 2
- Schuylkill 2
- Allegheny 1
- Armstrong 1
- Bedford 1
- Bradford 1
- Butler 1
- Clarion 1
- Huntingdon 1
- Indiana 1
- McKean 1
- Mifflin 1
- Northampton 1
- …
state 1
- Pennsylvania · 123 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2140699 | 2140699 | 2022-01-22 | Fulton | Pennsylvania | 42057 | 3700 | 55 |
2137443 | 2137443 | 2022-01-21 | Fulton | Pennsylvania | 42057 | 3672 | 55 |
2134189 | 2134189 | 2022-01-20 | Fulton | Pennsylvania | 42057 | 3637 | 55 |
2130937 | 2130937 | 2022-01-19 | Fulton | Pennsylvania | 42057 | 3611 | 55 |
2127683 | 2127683 | 2022-01-18 | Fulton | Pennsylvania | 42057 | 3575 | 55 |
2124431 | 2124431 | 2022-01-17 | Fulton | Pennsylvania | 42057 | 3556 | 55 |
2121179 | 2121179 | 2022-01-16 | Fulton | Pennsylvania | 42057 | 3534 | 55 |
2117927 | 2117927 | 2022-01-15 | Fulton | Pennsylvania | 42057 | 3487 | 55 |
2114676 | 2114676 | 2022-01-14 | Fulton | Pennsylvania | 42057 | 3467 | 55 |
2111424 | 2111424 | 2022-01-13 | Fulton | Pennsylvania | 42057 | 3433 | 55 |
2108172 | 2108172 | 2022-01-12 | Fulton | Pennsylvania | 42057 | 3404 | 55 |
1867646 | 1867646 | 2021-10-30 | Greene | Pennsylvania | 42059 | 4940 | 55 |
1864397 | 1864397 | 2021-10-29 | Greene | Pennsylvania | 42059 | 4916 | 55 |
1861148 | 1861148 | 2021-10-28 | Greene | Pennsylvania | 42059 | 4877 | 55 |
1835147 | 1835147 | 2021-10-20 | Elk | Pennsylvania | 42047 | 3999 | 55 |
1831898 | 1831898 | 2021-10-19 | Elk | Pennsylvania | 42047 | 3961 | 55 |
1760459 | 1760459 | 2021-09-27 | Wyoming | Pennsylvania | 42131 | 2439 | 55 |
1757211 | 1757211 | 2021-09-26 | Wyoming | Pennsylvania | 42131 | 2433 | 55 |
1753963 | 1753963 | 2021-09-25 | Wyoming | Pennsylvania | 42131 | 2423 | 55 |
1750715 | 1750715 | 2021-09-24 | Wyoming | Pennsylvania | 42131 | 2416 | 55 |
1747466 | 1747466 | 2021-09-23 | Wyoming | Pennsylvania | 42131 | 2402 | 55 |
1744216 | 1744216 | 2021-09-22 | Wyoming | Pennsylvania | 42131 | 2396 | 55 |
1740967 | 1740967 | 2021-09-21 | Wyoming | Pennsylvania | 42131 | 2386 | 55 |
1737718 | 1737718 | 2021-09-20 | Wyoming | Pennsylvania | 42131 | 2371 | 55 |
1734468 | 1734468 | 2021-09-19 | Wyoming | Pennsylvania | 42131 | 2365 | 55 |
1731218 | 1731218 | 2021-09-18 | Wyoming | Pennsylvania | 42131 | 2356 | 55 |
1727968 | 1727968 | 2021-09-17 | Wyoming | Pennsylvania | 42131 | 2341 | 55 |
1724719 | 1724719 | 2021-09-16 | Wyoming | Pennsylvania | 42131 | 2320 | 55 |
1721470 | 1721470 | 2021-09-15 | Wyoming | Pennsylvania | 42131 | 2300 | 55 |
1718222 | 1718222 | 2021-09-14 | Wyoming | Pennsylvania | 42131 | 2275 | 55 |
1705220 | 1705220 | 2021-09-10 | Pike | Pennsylvania | 42103 | 4510 | 55 |
1701970 | 1701970 | 2021-09-09 | Pike | Pennsylvania | 42103 | 4491 | 55 |
1698721 | 1698721 | 2021-09-08 | Pike | Pennsylvania | 42103 | 4473 | 55 |
1695473 | 1695473 | 2021-09-07 | Pike | Pennsylvania | 42103 | 4459 | 55 |
1692225 | 1692225 | 2021-09-06 | Pike | Pennsylvania | 42103 | 4450 | 55 |
1688976 | 1688976 | 2021-09-05 | Pike | Pennsylvania | 42103 | 4438 | 55 |
1685726 | 1685726 | 2021-09-04 | Pike | Pennsylvania | 42103 | 4431 | 55 |
1682475 | 1682475 | 2021-09-03 | Pike | Pennsylvania | 42103 | 4426 | 55 |
1679225 | 1679225 | 2021-09-02 | Pike | Pennsylvania | 42103 | 4409 | 55 |
1675977 | 1675977 | 2021-09-01 | Pike | Pennsylvania | 42103 | 4393 | 55 |
1672730 | 1672730 | 2021-08-31 | Pike | Pennsylvania | 42103 | 4375 | 55 |
1669482 | 1669482 | 2021-08-30 | Pike | Pennsylvania | 42103 | 4365 | 55 |
1666235 | 1666235 | 2021-08-29 | Pike | Pennsylvania | 42103 | 4352 | 55 |
1662987 | 1662987 | 2021-08-28 | Pike | Pennsylvania | 42103 | 4343 | 55 |
1659739 | 1659739 | 2021-08-27 | Pike | Pennsylvania | 42103 | 4324 | 55 |
1656490 | 1656490 | 2021-08-26 | Pike | Pennsylvania | 42103 | 4306 | 55 |
1653243 | 1653243 | 2021-08-25 | Pike | Pennsylvania | 42103 | 4294 | 55 |
1649996 | 1649996 | 2021-08-24 | Pike | Pennsylvania | 42103 | 4299 | 55 |
1646747 | 1646747 | 2021-08-23 | Pike | Pennsylvania | 42103 | 4292 | 55 |
1643498 | 1643498 | 2021-08-22 | Pike | Pennsylvania | 42103 | 4290 | 55 |
1182438 | 1182438 | 2021-04-02 | Susquehanna | Pennsylvania | 42115 | 2032 | 55 |
1078503 | 1078503 | 2021-03-01 | Clinton | Pennsylvania | 42035 | 2803 | 55 |
1075258 | 1075258 | 2021-02-28 | Clinton | Pennsylvania | 42035 | 2798 | 55 |
1072012 | 1072012 | 2021-02-27 | Clinton | Pennsylvania | 42035 | 2777 | 55 |
1068766 | 1068766 | 2021-02-26 | Clinton | Pennsylvania | 42035 | 2765 | 55 |
1065521 | 1065521 | 2021-02-25 | Clinton | Pennsylvania | 42035 | 2746 | 55 |
1062276 | 1062276 | 2021-02-24 | Clinton | Pennsylvania | 42035 | 2734 | 55 |
1059031 | 1059031 | 2021-02-23 | Clinton | Pennsylvania | 42035 | 2716 | 55 |
1055785 | 1055785 | 2021-02-22 | Clinton | Pennsylvania | 42035 | 2710 | 55 |
1052539 | 1052539 | 2021-02-21 | Clinton | Pennsylvania | 42035 | 2701 | 55 |
1049292 | 1049292 | 2021-02-20 | Clinton | Pennsylvania | 42035 | 2691 | 55 |
1046045 | 1046045 | 2021-02-19 | Clinton | Pennsylvania | 42035 | 2681 | 55 |
1042800 | 1042800 | 2021-02-18 | Clinton | Pennsylvania | 42035 | 2671 | 55 |
1039555 | 1039555 | 2021-02-17 | Clinton | Pennsylvania | 42035 | 2660 | 55 |
1020111 | 1020111 | 2021-02-11 | Montour | Pennsylvania | 42093 | 1689 | 55 |
1016866 | 1016866 | 2021-02-10 | Montour | Pennsylvania | 42093 | 1686 | 55 |
1013621 | 1013621 | 2021-02-09 | Montour | Pennsylvania | 42093 | 1683 | 55 |
1010376 | 1010376 | 2021-02-08 | Montour | Pennsylvania | 42093 | 1680 | 55 |
1010393 | 1010393 | 2021-02-08 | Wayne | Pennsylvania | 42127 | 2818 | 55 |
1007147 | 1007147 | 2021-02-07 | Wayne | Pennsylvania | 42127 | 2810 | 55 |
1003901 | 1003901 | 2021-02-06 | Wayne | Pennsylvania | 42127 | 2787 | 55 |
968174 | 968174 | 2021-01-26 | McKean | Pennsylvania | 42083 | 2612 | 55 |
932484 | 932484 | 2021-01-15 | Perry | Pennsylvania | 42099 | 2163 | 55 |
932489 | 932489 | 2021-01-15 | Snyder | Pennsylvania | 42109 | 2277 | 55 |
929205 | 929205 | 2021-01-14 | Clarion | Pennsylvania | 42031 | 2300 | 55 |
929239 | 929239 | 2021-01-14 | Perry | Pennsylvania | 42099 | 2150 | 55 |
929244 | 929244 | 2021-01-14 | Snyder | Pennsylvania | 42109 | 2263 | 55 |
929249 | 929249 | 2021-01-14 | Union | Pennsylvania | 42119 | 3589 | 55 |
925999 | 925999 | 2021-01-13 | Snyder | Pennsylvania | 42109 | 2249 | 55 |
922731 | 922731 | 2021-01-12 | Jefferson | Pennsylvania | 42065 | 2171 | 55 |
919486 | 919486 | 2021-01-11 | Jefferson | Pennsylvania | 42065 | 2156 | 55 |
912980 | 912980 | 2021-01-09 | Clearfield | Pennsylvania | 42033 | 4735 | 55 |
909735 | 909735 | 2021-01-08 | Clearfield | Pennsylvania | 42033 | 4648 | 55 |
906490 | 906490 | 2021-01-07 | Clearfield | Pennsylvania | 42033 | 4559 | 55 |
906507 | 906507 | 2021-01-07 | Juniata | Pennsylvania | 42067 | 1457 | 55 |
906534 | 906534 | 2021-01-07 | Venango | Pennsylvania | 42121 | 2609 | 55 |
903261 | 903261 | 2021-01-06 | Juniata | Pennsylvania | 42067 | 1444 | 55 |
880516 | 880516 | 2020-12-30 | Bradford | Pennsylvania | 42015 | 3021 | 55 |
828602 | 828602 | 2020-12-14 | Columbia | Pennsylvania | 42037 | 2014 | 55 |
825356 | 825356 | 2020-12-13 | Columbia | Pennsylvania | 42037 | 1980 | 55 |
822093 | 822093 | 2020-12-12 | Armstrong | Pennsylvania | 42005 | 2417 | 55 |
822109 | 822109 | 2020-12-12 | Columbia | Pennsylvania | 42037 | 1946 | 55 |
812357 | 812357 | 2020-12-09 | Bedford | Pennsylvania | 42009 | 2061 | 55 |
805907 | 805907 | 2020-12-07 | Mifflin | Pennsylvania | 42087 | 2325 | 55 |
799405 | 799405 | 2020-12-05 | Indiana | Pennsylvania | 42063 | 2893 | 55 |
786424 | 786424 | 2020-12-01 | Huntingdon | Pennsylvania | 42061 | 1767 | 55 |
753950 | 753950 | 2020-11-21 | Butler | Pennsylvania | 42019 | 3536 | 55 |
692327 | 692327 | 2020-11-02 | Franklin | Pennsylvania | 42055 | 2346 | 55 |
689083 | 689083 | 2020-11-01 | Franklin | Pennsylvania | 42055 | 2329 | 55 |
685838 | 685838 | 2020-10-31 | Franklin | Pennsylvania | 42055 | 2306 | 55 |
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);