ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where deaths = 47 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Franklin 8
- Potter 6
- Schuylkill 6
- Greene 5
- Pike 5
- Adams 4
- Armstrong 4
- Venango 4
- Westmoreland 4
- Wyoming 4
- Clarion 3
- Clinton 3
- Cumberland 2
- Elk 2
- Huntingdon 2
- Lycoming 2
- McKean 2
- Wayne 2
- Allegheny 1
- Beaver 1
- Bradford 1
- Clearfield 1
- Columbia 1
- Fulton 1
- Indiana 1
- Jefferson 1
- Lawrence 1
- Lebanon 1
- Mercer 1
- Mifflin 1
- …
state 1
- Pennsylvania · 86 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2062654 | 2062654 | 2021-12-29 | Fulton | Pennsylvania | 42057 | 3106 | 47 |
1877416 | 1877416 | 2021-11-02 | Potter | Pennsylvania | 42105 | 1925 | 47 |
1874167 | 1874167 | 2021-11-01 | Potter | Pennsylvania | 42105 | 1907 | 47 |
1870918 | 1870918 | 2021-10-31 | Potter | Pennsylvania | 42105 | 1907 | 47 |
1867669 | 1867669 | 2021-10-30 | Potter | Pennsylvania | 42105 | 1904 | 47 |
1864420 | 1864420 | 2021-10-29 | Potter | Pennsylvania | 42105 | 1893 | 47 |
1861171 | 1861171 | 2021-10-28 | Potter | Pennsylvania | 42105 | 1877 | 47 |
1744174 | 1744174 | 2021-09-22 | Elk | Pennsylvania | 42047 | 3438 | 47 |
1740925 | 1740925 | 2021-09-21 | Elk | Pennsylvania | 42047 | 3431 | 47 |
1740931 | 1740931 | 2021-09-21 | Greene | Pennsylvania | 42059 | 4033 | 47 |
1737682 | 1737682 | 2021-09-20 | Greene | Pennsylvania | 42059 | 4001 | 47 |
1734432 | 1734432 | 2021-09-19 | Greene | Pennsylvania | 42059 | 3990 | 47 |
1731182 | 1731182 | 2021-09-18 | Greene | Pennsylvania | 42059 | 3975 | 47 |
1727932 | 1727932 | 2021-09-17 | Greene | Pennsylvania | 42059 | 3943 | 47 |
1283119 | 1283119 | 2021-05-03 | Wyoming | Pennsylvania | 42131 | 1844 | 47 |
1279872 | 1279872 | 2021-05-02 | Wyoming | Pennsylvania | 42131 | 1838 | 47 |
1276625 | 1276625 | 2021-05-01 | Wyoming | Pennsylvania | 42131 | 1834 | 47 |
1273378 | 1273378 | 2021-04-30 | Wyoming | Pennsylvania | 42131 | 1824 | 47 |
1072046 | 1072046 | 2021-02-27 | Pike | Pennsylvania | 42103 | 2514 | 47 |
1068800 | 1068800 | 2021-02-26 | Pike | Pennsylvania | 42103 | 2496 | 47 |
1065555 | 1065555 | 2021-02-25 | Pike | Pennsylvania | 42103 | 2477 | 47 |
1062310 | 1062310 | 2021-02-24 | Pike | Pennsylvania | 42103 | 2461 | 47 |
1059065 | 1059065 | 2021-02-23 | Pike | Pennsylvania | 42103 | 2450 | 47 |
987671 | 987671 | 2021-02-01 | Wayne | Pennsylvania | 42127 | 2714 | 47 |
984424 | 984424 | 2021-01-31 | Wayne | Pennsylvania | 42127 | 2676 | 47 |
968150 | 968150 | 2021-01-26 | Clinton | Pennsylvania | 42035 | 2445 | 47 |
964906 | 964906 | 2021-01-25 | Clinton | Pennsylvania | 42035 | 2437 | 47 |
961661 | 961661 | 2021-01-24 | Clinton | Pennsylvania | 42035 | 2426 | 47 |
961701 | 961701 | 2021-01-24 | Susquehanna | Pennsylvania | 42115 | 1430 | 47 |
942211 | 942211 | 2021-01-18 | McKean | Pennsylvania | 42083 | 2292 | 47 |
938966 | 938966 | 2021-01-17 | McKean | Pennsylvania | 42083 | 2267 | 47 |
909768 | 909768 | 2021-01-08 | Perry | Pennsylvania | 42099 | 1926 | 47 |
903282 | 903282 | 2021-01-06 | Snyder | Pennsylvania | 42109 | 2033 | 47 |
903287 | 903287 | 2021-01-06 | Union | Pennsylvania | 42119 | 3102 | 47 |
899998 | 899998 | 2021-01-05 | Clarion | Pennsylvania | 42031 | 2118 | 47 |
900015 | 900015 | 2021-01-05 | Jefferson | Pennsylvania | 42065 | 1990 | 47 |
896753 | 896753 | 2021-01-04 | Clarion | Pennsylvania | 42031 | 2098 | 47 |
893507 | 893507 | 2021-01-03 | Clarion | Pennsylvania | 42031 | 2095 | 47 |
890306 | 890306 | 2021-01-02 | Venango | Pennsylvania | 42121 | 2457 | 47 |
887059 | 887059 | 2021-01-01 | Venango | Pennsylvania | 42121 | 2410 | 47 |
883814 | 883814 | 2020-12-31 | Venango | Pennsylvania | 42121 | 2354 | 47 |
880525 | 880525 | 2020-12-30 | Clearfield | Pennsylvania | 42033 | 3956 | 47 |
880569 | 880569 | 2020-12-30 | Venango | Pennsylvania | 42121 | 2332 | 47 |
854607 | 854607 | 2020-12-22 | Tioga | Pennsylvania | 42117 | 1792 | 47 |
828591 | 828591 | 2020-12-14 | Bradford | Pennsylvania | 42015 | 2442 | 47 |
809111 | 809111 | 2020-12-08 | Armstrong | Pennsylvania | 42005 | 2180 | 47 |
805866 | 805866 | 2020-12-07 | Armstrong | Pennsylvania | 42005 | 2134 | 47 |
802621 | 802621 | 2020-12-06 | Armstrong | Pennsylvania | 42005 | 2084 | 47 |
799376 | 799376 | 2020-12-05 | Armstrong | Pennsylvania | 42005 | 2057 | 47 |
799414 | 799414 | 2020-12-05 | Lycoming | Pennsylvania | 42081 | 2751 | 47 |
796169 | 796169 | 2020-12-04 | Lycoming | Pennsylvania | 42081 | 2600 | 47 |
796172 | 796172 | 2020-12-04 | Mifflin | Pennsylvania | 42087 | 2054 | 47 |
789670 | 789670 | 2020-12-02 | Indiana | Pennsylvania | 42063 | 2657 | 47 |
786394 | 786394 | 2020-12-01 | Adams | Pennsylvania | 42001 | 2047 | 47 |
783150 | 783150 | 2020-11-30 | Adams | Pennsylvania | 42001 | 2028 | 47 |
779905 | 779905 | 2020-11-29 | Adams | Pennsylvania | 42001 | 2003 | 47 |
776659 | 776659 | 2020-11-28 | Adams | Pennsylvania | 42001 | 1973 | 47 |
770211 | 770211 | 2020-11-26 | Mercer | Pennsylvania | 42085 | 2617 | 47 |
763696 | 763696 | 2020-11-24 | Columbia | Pennsylvania | 42037 | 1372 | 47 |
760463 | 760463 | 2020-11-23 | Huntingdon | Pennsylvania | 42061 | 1575 | 47 |
757218 | 757218 | 2020-11-22 | Huntingdon | Pennsylvania | 42061 | 1550 | 47 |
724768 | 724768 | 2020-11-12 | Lawrence | Pennsylvania | 42073 | 1450 | 47 |
546435 | 546435 | 2020-09-18 | Northumberland | Pennsylvania | 42097 | 848 | 47 |
514053 | 514053 | 2020-09-08 | Franklin | Pennsylvania | 42055 | 1583 | 47 |
510820 | 510820 | 2020-09-07 | Franklin | Pennsylvania | 42055 | 1576 | 47 |
507587 | 507587 | 2020-09-06 | Franklin | Pennsylvania | 42055 | 1572 | 47 |
504355 | 504355 | 2020-09-05 | Franklin | Pennsylvania | 42055 | 1572 | 47 |
501121 | 501121 | 2020-09-04 | Franklin | Pennsylvania | 42055 | 1559 | 47 |
497887 | 497887 | 2020-09-03 | Franklin | Pennsylvania | 42055 | 1550 | 47 |
494654 | 494654 | 2020-09-02 | Franklin | Pennsylvania | 42055 | 1540 | 47 |
491420 | 491420 | 2020-09-01 | Franklin | Pennsylvania | 42055 | 1525 | 47 |
433321 | 433321 | 2020-08-14 | Westmoreland | Pennsylvania | 42129 | 1593 | 47 |
430095 | 430095 | 2020-08-13 | Westmoreland | Pennsylvania | 42129 | 1586 | 47 |
426870 | 426870 | 2020-08-12 | Westmoreland | Pennsylvania | 42129 | 1573 | 47 |
423647 | 423647 | 2020-08-11 | Westmoreland | Pennsylvania | 42129 | 1555 | 47 |
330525 | 330525 | 2020-07-13 | Schuylkill | Pennsylvania | 42107 | 776 | 47 |
327339 | 327339 | 2020-07-12 | Schuylkill | Pennsylvania | 42107 | 776 | 47 |
324154 | 324154 | 2020-07-11 | Schuylkill | Pennsylvania | 42107 | 773 | 47 |
320974 | 320974 | 2020-07-10 | Schuylkill | Pennsylvania | 42107 | 769 | 47 |
317780 | 317780 | 2020-07-09 | Lebanon | Pennsylvania | 42075 | 1404 | 47 |
317796 | 317796 | 2020-07-09 | Schuylkill | Pennsylvania | 42107 | 765 | 47 |
314623 | 314623 | 2020-07-08 | Schuylkill | Pennsylvania | 42107 | 761 | 47 |
186737 | 186737 | 2020-05-28 | Cumberland | Pennsylvania | 42041 | 618 | 47 |
183680 | 183680 | 2020-05-27 | Cumberland | Pennsylvania | 42041 | 611 | 47 |
80455 | 80455 | 2020-04-22 | Beaver | Pennsylvania | 42007 | 317 | 47 |
69339 | 69339 | 2020-04-18 | Allegheny | Pennsylvania | 42003 | 1009 | 47 |
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);