ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
157 rows where deaths = 48 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 30
county 30
- Erie 60
- Pike 19
- Wyoming 9
- Greene 8
- Schuylkill 8
- Centre 4
- Juniata 4
- Westmoreland 4
- Columbia 3
- Cumberland 3
- Northumberland 3
- Snyder 3
- Venango 3
- Carbon 2
- Elk 2
- Lawrence 2
- Lycoming 2
- Monroe 2
- Montour 2
- Tioga 2
- Wayne 2
- York 2
- Adams 1
- Butler 1
- Fayette 1
- Franklin 1
- Indiana 1
- Lebanon 1
- Perry 1
- Susquehanna 1
state 1
- Pennsylvania · 157 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1766921 | 1766921 | 2021-09-29 | Greene | Pennsylvania | 42059 | 4230 | 48 |
1763672 | 1763672 | 2021-09-28 | Greene | Pennsylvania | 42059 | 4217 | 48 |
1760423 | 1760423 | 2021-09-27 | Greene | Pennsylvania | 42059 | 4169 | 48 |
1757175 | 1757175 | 2021-09-26 | Greene | Pennsylvania | 42059 | 4167 | 48 |
1753927 | 1753927 | 2021-09-25 | Greene | Pennsylvania | 42059 | 4151 | 48 |
1750673 | 1750673 | 2021-09-24 | Elk | Pennsylvania | 42047 | 3482 | 48 |
1750679 | 1750679 | 2021-09-24 | Greene | Pennsylvania | 42059 | 4120 | 48 |
1747424 | 1747424 | 2021-09-23 | Elk | Pennsylvania | 42047 | 3461 | 48 |
1747430 | 1747430 | 2021-09-23 | Greene | Pennsylvania | 42059 | 4090 | 48 |
1744180 | 1744180 | 2021-09-22 | Greene | Pennsylvania | 42059 | 4046 | 48 |
1312336 | 1312336 | 2021-05-12 | Wyoming | Pennsylvania | 42131 | 1882 | 48 |
1309089 | 1309089 | 2021-05-11 | Wyoming | Pennsylvania | 42131 | 1878 | 48 |
1305843 | 1305843 | 2021-05-10 | Wyoming | Pennsylvania | 42131 | 1875 | 48 |
1302597 | 1302597 | 2021-05-09 | Wyoming | Pennsylvania | 42131 | 1873 | 48 |
1299350 | 1299350 | 2021-05-08 | Wyoming | Pennsylvania | 42131 | 1868 | 48 |
1296103 | 1296103 | 2021-05-07 | Wyoming | Pennsylvania | 42131 | 1863 | 48 |
1292857 | 1292857 | 2021-05-06 | Wyoming | Pennsylvania | 42131 | 1859 | 48 |
1289611 | 1289611 | 2021-05-05 | Wyoming | Pennsylvania | 42131 | 1854 | 48 |
1286365 | 1286365 | 2021-05-04 | Wyoming | Pennsylvania | 42131 | 1851 | 48 |
1133725 | 1133725 | 2021-03-18 | Pike | Pennsylvania | 42103 | 2835 | 48 |
1130477 | 1130477 | 2021-03-17 | Pike | Pennsylvania | 42103 | 2805 | 48 |
1127230 | 1127230 | 2021-03-16 | Pike | Pennsylvania | 42103 | 2771 | 48 |
1123984 | 1123984 | 2021-03-15 | Pike | Pennsylvania | 42103 | 2753 | 48 |
1120738 | 1120738 | 2021-03-14 | Pike | Pennsylvania | 42103 | 2742 | 48 |
1117491 | 1117491 | 2021-03-13 | Pike | Pennsylvania | 42103 | 2735 | 48 |
1114244 | 1114244 | 2021-03-12 | Pike | Pennsylvania | 42103 | 2722 | 48 |
1110998 | 1110998 | 2021-03-11 | Pike | Pennsylvania | 42103 | 2706 | 48 |
1107752 | 1107752 | 2021-03-10 | Pike | Pennsylvania | 42103 | 2677 | 48 |
1104506 | 1104506 | 2021-03-09 | Pike | Pennsylvania | 42103 | 2659 | 48 |
1101260 | 1101260 | 2021-03-08 | Pike | Pennsylvania | 42103 | 2644 | 48 |
1098014 | 1098014 | 2021-03-07 | Pike | Pennsylvania | 42103 | 2639 | 48 |
1094766 | 1094766 | 2021-03-06 | Pike | Pennsylvania | 42103 | 2629 | 48 |
1091520 | 1091520 | 2021-03-05 | Pike | Pennsylvania | 42103 | 2620 | 48 |
1088274 | 1088274 | 2021-03-04 | Pike | Pennsylvania | 42103 | 2593 | 48 |
1085029 | 1085029 | 2021-03-03 | Pike | Pennsylvania | 42103 | 2568 | 48 |
1081783 | 1081783 | 2021-03-02 | Pike | Pennsylvania | 42103 | 2535 | 48 |
1078537 | 1078537 | 2021-03-01 | Pike | Pennsylvania | 42103 | 2527 | 48 |
1075292 | 1075292 | 2021-02-28 | Pike | Pennsylvania | 42103 | 2519 | 48 |
994163 | 994163 | 2021-02-03 | Wayne | Pennsylvania | 42127 | 2746 | 48 |
990917 | 990917 | 2021-02-02 | Wayne | Pennsylvania | 42127 | 2740 | 48 |
974669 | 974669 | 2021-01-28 | Montour | Pennsylvania | 42093 | 1567 | 48 |
971424 | 971424 | 2021-01-27 | Montour | Pennsylvania | 42093 | 1556 | 48 |
964946 | 964946 | 2021-01-25 | Susquehanna | Pennsylvania | 42115 | 1437 | 48 |
913013 | 913013 | 2021-01-09 | Perry | Pennsylvania | 42099 | 1976 | 48 |
913018 | 913018 | 2021-01-09 | Snyder | Pennsylvania | 42109 | 2150 | 48 |
909773 | 909773 | 2021-01-08 | Snyder | Pennsylvania | 42109 | 2107 | 48 |
906528 | 906528 | 2021-01-07 | Snyder | Pennsylvania | 42109 | 2076 | 48 |
900043 | 900043 | 2021-01-05 | Venango | Pennsylvania | 42121 | 2541 | 48 |
896798 | 896798 | 2021-01-04 | Venango | Pennsylvania | 42121 | 2507 | 48 |
893525 | 893525 | 2021-01-03 | Juniata | Pennsylvania | 42067 | 1416 | 48 |
893552 | 893552 | 2021-01-03 | Venango | Pennsylvania | 42121 | 2491 | 48 |
890279 | 890279 | 2021-01-02 | Juniata | Pennsylvania | 42067 | 1399 | 48 |
887032 | 887032 | 2021-01-01 | Juniata | Pennsylvania | 42067 | 1361 | 48 |
883787 | 883787 | 2020-12-31 | Juniata | Pennsylvania | 42067 | 1351 | 48 |
861097 | 861097 | 2020-12-24 | Tioga | Pennsylvania | 42117 | 1814 | 48 |
857852 | 857852 | 2020-12-23 | Tioga | Pennsylvania | 42117 | 1801 | 48 |
831856 | 831856 | 2020-12-15 | Fayette | Pennsylvania | 42051 | 4725 | 48 |
805904 | 805904 | 2020-12-07 | Lycoming | Pennsylvania | 42081 | 2913 | 48 |
802659 | 802659 | 2020-12-06 | Lycoming | Pennsylvania | 42081 | 2849 | 48 |
792915 | 792915 | 2020-12-03 | Indiana | Pennsylvania | 42063 | 2709 | 48 |
789639 | 789639 | 2020-12-02 | Adams | Pennsylvania | 42001 | 2096 | 48 |
783163 | 783163 | 2020-11-30 | Centre | Pennsylvania | 42027 | 6387 | 48 |
779918 | 779918 | 2020-11-29 | Centre | Pennsylvania | 42027 | 6357 | 48 |
776672 | 776672 | 2020-11-28 | Centre | Pennsylvania | 42027 | 6296 | 48 |
773426 | 773426 | 2020-11-27 | Carbon | Pennsylvania | 42025 | 1252 | 48 |
773427 | 773427 | 2020-11-27 | Centre | Pennsylvania | 42027 | 6142 | 48 |
773432 | 773432 | 2020-11-27 | Columbia | Pennsylvania | 42037 | 1441 | 48 |
770181 | 770181 | 2020-11-26 | Carbon | Pennsylvania | 42025 | 1190 | 48 |
770187 | 770187 | 2020-11-26 | Columbia | Pennsylvania | 42037 | 1414 | 48 |
766941 | 766941 | 2020-11-25 | Columbia | Pennsylvania | 42037 | 1394 | 48 |
747473 | 747473 | 2020-11-19 | Erie | Pennsylvania | 42049 | 3899 | 48 |
744212 | 744212 | 2020-11-18 | Butler | Pennsylvania | 42019 | 3218 | 48 |
744227 | 744227 | 2020-11-18 | Erie | Pennsylvania | 42049 | 3764 | 48 |
740980 | 740980 | 2020-11-17 | Erie | Pennsylvania | 42049 | 3630 | 48 |
737734 | 737734 | 2020-11-16 | Erie | Pennsylvania | 42049 | 3463 | 48 |
734490 | 734490 | 2020-11-15 | Erie | Pennsylvania | 42049 | 3362 | 48 |
731244 | 731244 | 2020-11-14 | Erie | Pennsylvania | 42049 | 3227 | 48 |
731256 | 731256 | 2020-11-14 | Lawrence | Pennsylvania | 42073 | 1525 | 48 |
728000 | 728000 | 2020-11-13 | Erie | Pennsylvania | 42049 | 3078 | 48 |
728012 | 728012 | 2020-11-13 | Lawrence | Pennsylvania | 42073 | 1480 | 48 |
724756 | 724756 | 2020-11-12 | Erie | Pennsylvania | 42049 | 2970 | 48 |
721513 | 721513 | 2020-11-11 | Erie | Pennsylvania | 42049 | 2846 | 48 |
718270 | 718270 | 2020-11-10 | Erie | Pennsylvania | 42049 | 2747 | 48 |
715027 | 715027 | 2020-11-09 | Erie | Pennsylvania | 42049 | 2675 | 48 |
711783 | 711783 | 2020-11-08 | Erie | Pennsylvania | 42049 | 2596 | 48 |
708539 | 708539 | 2020-11-07 | Erie | Pennsylvania | 42049 | 2542 | 48 |
705296 | 705296 | 2020-11-06 | Erie | Pennsylvania | 42049 | 2493 | 48 |
702053 | 702053 | 2020-11-05 | Erie | Pennsylvania | 42049 | 2434 | 48 |
698809 | 698809 | 2020-11-04 | Erie | Pennsylvania | 42049 | 2385 | 48 |
695566 | 695566 | 2020-11-03 | Erie | Pennsylvania | 42049 | 2352 | 48 |
692324 | 692324 | 2020-11-02 | Erie | Pennsylvania | 42049 | 2302 | 48 |
689080 | 689080 | 2020-11-01 | Erie | Pennsylvania | 42049 | 2261 | 48 |
685835 | 685835 | 2020-10-31 | Erie | Pennsylvania | 42049 | 2223 | 48 |
682592 | 682592 | 2020-10-30 | Erie | Pennsylvania | 42049 | 2181 | 48 |
679349 | 679349 | 2020-10-29 | Erie | Pennsylvania | 42049 | 2128 | 48 |
676106 | 676106 | 2020-10-28 | Erie | Pennsylvania | 42049 | 2087 | 48 |
672863 | 672863 | 2020-10-27 | Erie | Pennsylvania | 42049 | 2054 | 48 |
669621 | 669621 | 2020-10-26 | Erie | Pennsylvania | 42049 | 2013 | 48 |
666377 | 666377 | 2020-10-25 | Erie | Pennsylvania | 42049 | 1994 | 48 |
663132 | 663132 | 2020-10-24 | Erie | Pennsylvania | 42049 | 1981 | 48 |
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);