ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
166 rows where deaths = 32 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Sullivan 34
- Lycoming 19
- Susquehanna 13
- Westmoreland 13
- Fulton 11
- Wyoming 9
- Carbon 8
- Greene 5
- Potter 5
- Washington 5
- Blair 4
- Bradford 4
- Armstrong 3
- Butler 3
- Clearfield 3
- Mifflin 3
- Clinton 2
- York 2
- Adams 1
- Beaver 1
- Bucks 1
- Cambria 1
- Clarion 1
- Columbia 1
- Elk 1
- Erie 1
- Jefferson 1
- Juniata 1
- Lehigh 1
- Luzerne 1
- …
state 1
- Pennsylvania · 166 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2199289 | 2199289 | 2022-02-09 | Sullivan | Pennsylvania | 42113 | 1028 | 32 |
2196035 | 2196035 | 2022-02-08 | Sullivan | Pennsylvania | 42113 | 1027 | 32 |
2192781 | 2192781 | 2022-02-07 | Sullivan | Pennsylvania | 42113 | 1027 | 32 |
2189527 | 2189527 | 2022-02-06 | Sullivan | Pennsylvania | 42113 | 1027 | 32 |
2186274 | 2186274 | 2022-02-05 | Sullivan | Pennsylvania | 42113 | 1026 | 32 |
2183022 | 2183022 | 2022-02-04 | Sullivan | Pennsylvania | 42113 | 1022 | 32 |
2179770 | 2179770 | 2022-02-03 | Sullivan | Pennsylvania | 42113 | 1019 | 32 |
2176519 | 2176519 | 2022-02-02 | Sullivan | Pennsylvania | 42113 | 1013 | 32 |
2173265 | 2173265 | 2022-02-01 | Sullivan | Pennsylvania | 42113 | 1007 | 32 |
2170013 | 2170013 | 2022-01-31 | Sullivan | Pennsylvania | 42113 | 1003 | 32 |
2166759 | 2166759 | 2022-01-30 | Sullivan | Pennsylvania | 42113 | 1001 | 32 |
2163504 | 2163504 | 2022-01-29 | Sullivan | Pennsylvania | 42113 | 997 | 32 |
2160249 | 2160249 | 2022-01-28 | Sullivan | Pennsylvania | 42113 | 993 | 32 |
2156993 | 2156993 | 2022-01-27 | Sullivan | Pennsylvania | 42113 | 985 | 32 |
2153740 | 2153740 | 2022-01-26 | Sullivan | Pennsylvania | 42113 | 976 | 32 |
2150488 | 2150488 | 2022-01-25 | Sullivan | Pennsylvania | 42113 | 969 | 32 |
2147236 | 2147236 | 2022-01-24 | Sullivan | Pennsylvania | 42113 | 964 | 32 |
2143982 | 2143982 | 2022-01-23 | Sullivan | Pennsylvania | 42113 | 964 | 32 |
2140727 | 2140727 | 2022-01-22 | Sullivan | Pennsylvania | 42113 | 955 | 32 |
2137471 | 2137471 | 2022-01-21 | Sullivan | Pennsylvania | 42113 | 950 | 32 |
2134217 | 2134217 | 2022-01-20 | Sullivan | Pennsylvania | 42113 | 944 | 32 |
2130965 | 2130965 | 2022-01-19 | Sullivan | Pennsylvania | 42113 | 934 | 32 |
2127711 | 2127711 | 2022-01-18 | Sullivan | Pennsylvania | 42113 | 924 | 32 |
2124459 | 2124459 | 2022-01-17 | Sullivan | Pennsylvania | 42113 | 922 | 32 |
2121207 | 2121207 | 2022-01-16 | Sullivan | Pennsylvania | 42113 | 921 | 32 |
2117955 | 2117955 | 2022-01-15 | Sullivan | Pennsylvania | 42113 | 899 | 32 |
2114704 | 2114704 | 2022-01-14 | Sullivan | Pennsylvania | 42113 | 894 | 32 |
2111452 | 2111452 | 2022-01-13 | Sullivan | Pennsylvania | 42113 | 873 | 32 |
2108200 | 2108200 | 2022-01-12 | Sullivan | Pennsylvania | 42113 | 868 | 32 |
2104949 | 2104949 | 2022-01-11 | Sullivan | Pennsylvania | 42113 | 857 | 32 |
2101698 | 2101698 | 2022-01-10 | Sullivan | Pennsylvania | 42113 | 852 | 32 |
2098447 | 2098447 | 2022-01-09 | Sullivan | Pennsylvania | 42113 | 847 | 32 |
2095195 | 2095195 | 2022-01-08 | Sullivan | Pennsylvania | 42113 | 840 | 32 |
2091943 | 2091943 | 2022-01-07 | Sullivan | Pennsylvania | 42113 | 836 | 32 |
1900140 | 1900140 | 2021-11-09 | Fulton | Pennsylvania | 42057 | 2343 | 32 |
1896890 | 1896890 | 2021-11-08 | Fulton | Pennsylvania | 42057 | 2334 | 32 |
1893640 | 1893640 | 2021-11-07 | Fulton | Pennsylvania | 42057 | 2330 | 32 |
1890390 | 1890390 | 2021-11-06 | Fulton | Pennsylvania | 42057 | 2328 | 32 |
1887140 | 1887140 | 2021-11-05 | Fulton | Pennsylvania | 42057 | 2312 | 32 |
1883890 | 1883890 | 2021-11-04 | Fulton | Pennsylvania | 42057 | 2305 | 32 |
1880641 | 1880641 | 2021-11-03 | Fulton | Pennsylvania | 42057 | 2293 | 32 |
1877392 | 1877392 | 2021-11-02 | Fulton | Pennsylvania | 42057 | 2284 | 32 |
1874143 | 1874143 | 2021-11-01 | Fulton | Pennsylvania | 42057 | 2266 | 32 |
1870894 | 1870894 | 2021-10-31 | Fulton | Pennsylvania | 42057 | 2266 | 32 |
1867645 | 1867645 | 2021-10-30 | Fulton | Pennsylvania | 42057 | 2260 | 32 |
1805935 | 1805935 | 2021-10-11 | Potter | Pennsylvania | 42105 | 1729 | 32 |
1802685 | 1802685 | 2021-10-10 | Potter | Pennsylvania | 42105 | 1711 | 32 |
1799436 | 1799436 | 2021-10-09 | Potter | Pennsylvania | 42105 | 1681 | 32 |
1796187 | 1796187 | 2021-10-08 | Potter | Pennsylvania | 42105 | 1668 | 32 |
1792938 | 1792938 | 2021-10-07 | Potter | Pennsylvania | 42105 | 1653 | 32 |
1062288 | 1062288 | 2021-02-24 | Greene | Pennsylvania | 42059 | 2648 | 32 |
1059043 | 1059043 | 2021-02-23 | Greene | Pennsylvania | 42059 | 2638 | 32 |
1055797 | 1055797 | 2021-02-22 | Greene | Pennsylvania | 42059 | 2622 | 32 |
1052551 | 1052551 | 2021-02-21 | Greene | Pennsylvania | 42059 | 2620 | 32 |
1049304 | 1049304 | 2021-02-20 | Greene | Pennsylvania | 42059 | 2614 | 32 |
968156 | 968156 | 2021-01-26 | Elk | Pennsylvania | 42047 | 2067 | 32 |
929255 | 929255 | 2021-01-14 | Wyoming | Pennsylvania | 42131 | 936 | 32 |
926010 | 926010 | 2021-01-13 | Wyoming | Pennsylvania | 42131 | 925 | 32 |
922764 | 922764 | 2021-01-12 | Wyoming | Pennsylvania | 42131 | 918 | 32 |
919471 | 919471 | 2021-01-11 | Clinton | Pennsylvania | 42035 | 2225 | 32 |
919519 | 919519 | 2021-01-11 | Wyoming | Pennsylvania | 42131 | 912 | 32 |
916226 | 916226 | 2021-01-10 | Clinton | Pennsylvania | 42035 | 2206 | 32 |
916250 | 916250 | 2021-01-10 | McKean | Pennsylvania | 42083 | 2079 | 32 |
916274 | 916274 | 2021-01-10 | Wyoming | Pennsylvania | 42131 | 907 | 32 |
913029 | 913029 | 2021-01-09 | Wyoming | Pennsylvania | 42131 | 896 | 32 |
909784 | 909784 | 2021-01-08 | Wyoming | Pennsylvania | 42131 | 882 | 32 |
906539 | 906539 | 2021-01-07 | Wyoming | Pennsylvania | 42131 | 862 | 32 |
903293 | 903293 | 2021-01-06 | Wyoming | Pennsylvania | 42131 | 853 | 32 |
874070 | 874070 | 2020-12-28 | Pike | Pennsylvania | 42103 | 1365 | 32 |
861071 | 861071 | 2020-12-24 | Jefferson | Pennsylvania | 42065 | 1760 | 32 |
854564 | 854564 | 2020-12-22 | Clarion | Pennsylvania | 42031 | 1819 | 32 |
851320 | 851320 | 2020-12-21 | Clearfield | Pennsylvania | 42033 | 3341 | 32 |
848075 | 848075 | 2020-12-20 | Clearfield | Pennsylvania | 42033 | 3278 | 32 |
844830 | 844830 | 2020-12-19 | Clearfield | Pennsylvania | 42033 | 3232 | 32 |
838377 | 838377 | 2020-12-17 | Snyder | Pennsylvania | 42109 | 1559 | 32 |
835110 | 835110 | 2020-12-16 | Juniata | Pennsylvania | 42067 | 1072 | 32 |
822146 | 822146 | 2020-12-12 | Somerset | Pennsylvania | 42111 | 3059 | 32 |
809167 | 809167 | 2020-12-08 | Tioga | Pennsylvania | 42117 | 1269 | 32 |
789696 | 789696 | 2020-12-02 | Susquehanna | Pennsylvania | 42115 | 636 | 32 |
786451 | 786451 | 2020-12-01 | Susquehanna | Pennsylvania | 42115 | 628 | 32 |
783157 | 783157 | 2020-11-30 | Bradford | Pennsylvania | 42015 | 1859 | 32 |
783207 | 783207 | 2020-11-30 | Susquehanna | Pennsylvania | 42115 | 621 | 32 |
779912 | 779912 | 2020-11-29 | Bradford | Pennsylvania | 42015 | 1860 | 32 |
779948 | 779948 | 2020-11-29 | Mifflin | Pennsylvania | 42087 | 1757 | 32 |
779962 | 779962 | 2020-11-29 | Susquehanna | Pennsylvania | 42115 | 617 | 32 |
776666 | 776666 | 2020-11-28 | Bradford | Pennsylvania | 42015 | 1842 | 32 |
776702 | 776702 | 2020-11-28 | Mifflin | Pennsylvania | 42087 | 1707 | 32 |
776716 | 776716 | 2020-11-28 | Susquehanna | Pennsylvania | 42115 | 610 | 32 |
773421 | 773421 | 2020-11-27 | Bradford | Pennsylvania | 42015 | 1809 | 32 |
773457 | 773457 | 2020-11-27 | Mifflin | Pennsylvania | 42087 | 1646 | 32 |
773471 | 773471 | 2020-11-27 | Susquehanna | Pennsylvania | 42115 | 596 | 32 |
770226 | 770226 | 2020-11-26 | Susquehanna | Pennsylvania | 42115 | 594 | 32 |
766980 | 766980 | 2020-11-25 | Susquehanna | Pennsylvania | 42115 | 587 | 32 |
763735 | 763735 | 2020-11-24 | Susquehanna | Pennsylvania | 42115 | 578 | 32 |
760490 | 760490 | 2020-11-23 | Susquehanna | Pennsylvania | 42115 | 560 | 32 |
757245 | 757245 | 2020-11-22 | Susquehanna | Pennsylvania | 42115 | 554 | 32 |
753998 | 753998 | 2020-11-21 | Susquehanna | Pennsylvania | 42115 | 548 | 32 |
750697 | 750697 | 2020-11-20 | Armstrong | Pennsylvania | 42005 | 1441 | 32 |
750705 | 750705 | 2020-11-20 | Cambria | Pennsylvania | 42021 | 2877 | 32 |
750752 | 750752 | 2020-11-20 | Susquehanna | Pennsylvania | 42115 | 535 | 32 |
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);