ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where deaths = 64 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2283805 | 2283805 | 2022-03-07 | Fulton | Pennsylvania | 42057 | 4091 | 64 |
2280553 | 2280553 | 2022-03-06 | Fulton | Pennsylvania | 42057 | 4089 | 64 |
2277300 | 2277300 | 2022-03-05 | Fulton | Pennsylvania | 42057 | 4089 | 64 |
2274047 | 2274047 | 2022-03-04 | Fulton | Pennsylvania | 42057 | 4089 | 64 |
2270794 | 2270794 | 2022-03-03 | Fulton | Pennsylvania | 42057 | 4085 | 64 |
2267542 | 2267542 | 2022-03-02 | Fulton | Pennsylvania | 42057 | 4084 | 64 |
2264289 | 2264289 | 2022-03-01 | Fulton | Pennsylvania | 42057 | 4082 | 64 |
2261039 | 2261039 | 2022-02-28 | Fulton | Pennsylvania | 42057 | 4080 | 64 |
2257788 | 2257788 | 2022-02-27 | Fulton | Pennsylvania | 42057 | 4077 | 64 |
2254537 | 2254537 | 2022-02-26 | Fulton | Pennsylvania | 42057 | 4077 | 64 |
2251286 | 2251286 | 2022-02-25 | Fulton | Pennsylvania | 42057 | 4070 | 64 |
2248035 | 2248035 | 2022-02-24 | Fulton | Pennsylvania | 42057 | 4067 | 64 |
2244784 | 2244784 | 2022-02-23 | Fulton | Pennsylvania | 42057 | 4066 | 64 |
2241533 | 2241533 | 2022-02-22 | Fulton | Pennsylvania | 42057 | 4059 | 64 |
2238282 | 2238282 | 2022-02-21 | Fulton | Pennsylvania | 42057 | 4051 | 64 |
2235031 | 2235031 | 2022-02-20 | Fulton | Pennsylvania | 42057 | 4051 | 64 |
2231780 | 2231780 | 2022-02-19 | Fulton | Pennsylvania | 42057 | 4044 | 64 |
2228529 | 2228529 | 2022-02-18 | Fulton | Pennsylvania | 42057 | 4023 | 64 |
2225278 | 2225278 | 2022-02-17 | Fulton | Pennsylvania | 42057 | 4017 | 64 |
1922882 | 1922882 | 2021-11-16 | Elk | Pennsylvania | 42047 | 4562 | 64 |
1919633 | 1919633 | 2021-11-15 | Elk | Pennsylvania | 42047 | 4538 | 64 |
1919661 | 1919661 | 2021-11-15 | Pike | Pennsylvania | 42103 | 5693 | 64 |
1916383 | 1916383 | 2021-11-14 | Elk | Pennsylvania | 42047 | 4519 | 64 |
1916411 | 1916411 | 2021-11-14 | Pike | Pennsylvania | 42103 | 5680 | 64 |
1913133 | 1913133 | 2021-11-13 | Elk | Pennsylvania | 42047 | 4480 | 64 |
1913161 | 1913161 | 2021-11-13 | Pike | Pennsylvania | 42103 | 5662 | 64 |
1909883 | 1909883 | 2021-11-12 | Elk | Pennsylvania | 42047 | 4411 | 64 |
1909911 | 1909911 | 2021-11-12 | Pike | Pennsylvania | 42103 | 5595 | 64 |
1906634 | 1906634 | 2021-11-11 | Elk | Pennsylvania | 42047 | 4367 | 64 |
1906662 | 1906662 | 2021-11-11 | Pike | Pennsylvania | 42103 | 5579 | 64 |
1906676 | 1906676 | 2021-11-11 | Wyoming | Pennsylvania | 42131 | 2886 | 64 |
1903413 | 1903413 | 2021-11-10 | Pike | Pennsylvania | 42103 | 5560 | 64 |
1903427 | 1903427 | 2021-11-10 | Wyoming | Pennsylvania | 42131 | 2868 | 64 |
1900177 | 1900177 | 2021-11-09 | Wyoming | Pennsylvania | 42131 | 2858 | 64 |
1896927 | 1896927 | 2021-11-08 | Wyoming | Pennsylvania | 42131 | 2847 | 64 |
1893677 | 1893677 | 2021-11-07 | Wyoming | Pennsylvania | 42131 | 2843 | 64 |
1890427 | 1890427 | 2021-11-06 | Wyoming | Pennsylvania | 42131 | 2830 | 64 |
1809190 | 1809190 | 2021-10-12 | Susquehanna | Pennsylvania | 42115 | 3405 | 64 |
1805940 | 1805940 | 2021-10-11 | Susquehanna | Pennsylvania | 42115 | 3388 | 64 |
1802690 | 1802690 | 2021-10-10 | Susquehanna | Pennsylvania | 42115 | 3381 | 64 |
1799441 | 1799441 | 2021-10-09 | Susquehanna | Pennsylvania | 42115 | 3368 | 64 |
1796192 | 1796192 | 2021-10-08 | Susquehanna | Pennsylvania | 42115 | 3349 | 64 |
1792943 | 1792943 | 2021-10-07 | Susquehanna | Pennsylvania | 42115 | 3313 | 64 |
1789694 | 1789694 | 2021-10-06 | Susquehanna | Pennsylvania | 42115 | 3295 | 64 |
1786446 | 1786446 | 2021-10-05 | Susquehanna | Pennsylvania | 42115 | 3274 | 64 |
1783197 | 1783197 | 2021-10-04 | Susquehanna | Pennsylvania | 42115 | 3261 | 64 |
1779948 | 1779948 | 2021-10-03 | Susquehanna | Pennsylvania | 42115 | 3255 | 64 |
1776698 | 1776698 | 2021-10-02 | Susquehanna | Pennsylvania | 42115 | 3246 | 64 |
1773448 | 1773448 | 2021-10-01 | Susquehanna | Pennsylvania | 42115 | 3237 | 64 |
1770198 | 1770198 | 2021-09-30 | Susquehanna | Pennsylvania | 42115 | 3212 | 64 |
1328520 | 1328520 | 2021-05-17 | Clinton | Pennsylvania | 42035 | 3638 | 64 |
1325274 | 1325274 | 2021-05-16 | Clinton | Pennsylvania | 42035 | 3635 | 64 |
1104496 | 1104496 | 2021-03-09 | McKean | Pennsylvania | 42083 | 3083 | 64 |
1101250 | 1101250 | 2021-03-08 | McKean | Pennsylvania | 42083 | 3077 | 64 |
1098004 | 1098004 | 2021-03-07 | McKean | Pennsylvania | 42083 | 3073 | 64 |
1094756 | 1094756 | 2021-03-06 | McKean | Pennsylvania | 42083 | 3067 | 64 |
1046091 | 1046091 | 2021-02-19 | Wayne | Pennsylvania | 42127 | 2948 | 64 |
1042846 | 1042846 | 2021-02-18 | Wayne | Pennsylvania | 42127 | 2925 | 64 |
948712 | 948712 | 2021-01-20 | Perry | Pennsylvania | 42099 | 2262 | 64 |
948723 | 948723 | 2021-01-20 | Venango | Pennsylvania | 42121 | 2944 | 64 |
945477 | 945477 | 2021-01-19 | Venango | Pennsylvania | 42121 | 2933 | 64 |
942230 | 942230 | 2021-01-18 | Venango | Pennsylvania | 42121 | 2922 | 64 |
932451 | 932451 | 2021-01-15 | Clearfield | Pennsylvania | 42033 | 5016 | 64 |
870776 | 870776 | 2020-12-27 | Armstrong | Pennsylvania | 42005 | 3209 | 64 |
867531 | 867531 | 2020-12-26 | Armstrong | Pennsylvania | 42005 | 3174 | 64 |
864286 | 864286 | 2020-12-25 | Armstrong | Pennsylvania | 42005 | 3155 | 64 |
861041 | 861041 | 2020-12-24 | Armstrong | Pennsylvania | 42005 | 3077 | 64 |
861094 | 861094 | 2020-12-24 | Somerset | Pennsylvania | 42111 | 4381 | 64 |
854568 | 854568 | 2020-12-22 | Crawford | Pennsylvania | 42039 | 4415 | 64 |
851304 | 851304 | 2020-12-21 | Adams | Pennsylvania | 42001 | 3697 | 64 |
848059 | 848059 | 2020-12-20 | Adams | Pennsylvania | 42001 | 3630 | 64 |
844814 | 844814 | 2020-12-19 | Adams | Pennsylvania | 42001 | 3569 | 64 |
825378 | 825378 | 2020-12-13 | Lycoming | Pennsylvania | 42081 | 3817 | 64 |
822131 | 822131 | 2020-12-12 | Lycoming | Pennsylvania | 42081 | 3655 | 64 |
812383 | 812383 | 2020-12-09 | Huntingdon | Pennsylvania | 42061 | 2035 | 64 |
786404 | 786404 | 2020-12-01 | Cambria | Pennsylvania | 42021 | 4706 | 64 |
763714 | 763714 | 2020-11-24 | Lawrence | Pennsylvania | 42073 | 1929 | 64 |
760469 | 760469 | 2020-11-23 | Lawrence | Pennsylvania | 42073 | 1872 | 64 |
757224 | 757224 | 2020-11-22 | Lawrence | Pennsylvania | 42073 | 1846 | 64 |
753977 | 753977 | 2020-11-21 | Lawrence | Pennsylvania | 42073 | 1818 | 64 |
715030 | 715030 | 2020-11-09 | Franklin | Pennsylvania | 42055 | 2681 | 64 |
711786 | 711786 | 2020-11-08 | Franklin | Pennsylvania | 42055 | 2640 | 64 |
708542 | 708542 | 2020-11-07 | Franklin | Pennsylvania | 42055 | 2599 | 64 |
630719 | 630719 | 2020-10-14 | Westmoreland | Pennsylvania | 42129 | 3053 | 64 |
627475 | 627475 | 2020-10-13 | Westmoreland | Pennsylvania | 42129 | 2993 | 64 |
624233 | 624233 | 2020-10-12 | Westmoreland | Pennsylvania | 42129 | 2904 | 64 |
617720 | 617720 | 2020-10-10 | Lebanon | Pennsylvania | 42075 | 2325 | 64 |
314590 | 314590 | 2020-07-08 | Cumberland | Pennsylvania | 42041 | 912 | 64 |
311418 | 311418 | 2020-07-07 | Cumberland | Pennsylvania | 42041 | 902 | 64 |
308249 | 308249 | 2020-07-06 | Cumberland | Pennsylvania | 42041 | 894 | 64 |
305082 | 305082 | 2020-07-05 | Cumberland | Pennsylvania | 42041 | 890 | 64 |
301919 | 301919 | 2020-07-04 | Cumberland | Pennsylvania | 42041 | 881 | 64 |
298755 | 298755 | 2020-07-03 | Cumberland | Pennsylvania | 42041 | 871 | 64 |
295596 | 295596 | 2020-07-02 | Cumberland | Pennsylvania | 42041 | 866 | 64 |
292440 | 292440 | 2020-07-01 | Cumberland | Pennsylvania | 42041 | 856 | 64 |
289288 | 289288 | 2020-06-30 | Cumberland | Pennsylvania | 42041 | 852 | 64 |
138345 | 138345 | 2020-05-12 | Monroe | Pennsylvania | 42089 | 1229 | 64 |
135355 | 135355 | 2020-05-11 | Monroe | Pennsylvania | 42089 | 1224 | 64 |
132364 | 132364 | 2020-05-10 | Monroe | Pennsylvania | 42089 | 1218 | 64 |
97389 | 97389 | 2020-04-28 | Lehigh | Pennsylvania | 42077 | 2685 | 64 |
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);