ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where deaths = 140 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469312 | 2469312 | 2022-05-03 | McKean | Pennsylvania | 42083 | 8242 | 140 |
2466056 | 2466056 | 2022-05-02 | McKean | Pennsylvania | 42083 | 8238 | 140 |
2462801 | 2462801 | 2022-05-01 | McKean | Pennsylvania | 42083 | 8237 | 140 |
2459545 | 2459545 | 2022-04-30 | McKean | Pennsylvania | 42083 | 8235 | 140 |
2456289 | 2456289 | 2022-04-29 | McKean | Pennsylvania | 42083 | 8228 | 140 |
2453033 | 2453033 | 2022-04-28 | McKean | Pennsylvania | 42083 | 8223 | 140 |
2449777 | 2449777 | 2022-04-27 | McKean | Pennsylvania | 42083 | 8221 | 140 |
2446520 | 2446520 | 2022-04-26 | McKean | Pennsylvania | 42083 | 8219 | 140 |
2443265 | 2443265 | 2022-04-25 | McKean | Pennsylvania | 42083 | 8217 | 140 |
2440009 | 2440009 | 2022-04-24 | McKean | Pennsylvania | 42083 | 8212 | 140 |
2436753 | 2436753 | 2022-04-23 | McKean | Pennsylvania | 42083 | 8212 | 140 |
2433497 | 2433497 | 2022-04-22 | McKean | Pennsylvania | 42083 | 8212 | 140 |
2183025 | 2183025 | 2022-02-04 | Union | Pennsylvania | 42119 | 11157 | 140 |
2082195 | 2082195 | 2022-01-04 | Wayne | Pennsylvania | 42127 | 7838 | 140 |
2078943 | 2078943 | 2022-01-03 | Wayne | Pennsylvania | 42127 | 7766 | 140 |
2075692 | 2075692 | 2022-01-02 | Wayne | Pennsylvania | 42127 | 7715 | 140 |
2072441 | 2072441 | 2022-01-01 | Wayne | Pennsylvania | 42127 | 7661 | 140 |
2069190 | 2069190 | 2021-12-31 | Wayne | Pennsylvania | 42127 | 7603 | 140 |
2065939 | 2065939 | 2021-12-30 | Wayne | Pennsylvania | 42127 | 7543 | 140 |
2062689 | 2062689 | 2021-12-29 | Wayne | Pennsylvania | 42127 | 7456 | 140 |
2017174 | 2017174 | 2021-12-15 | Perry | Pennsylvania | 42099 | 6423 | 140 |
1948877 | 1948877 | 2021-11-24 | Clarion | Pennsylvania | 42031 | 5777 | 140 |
1942392 | 1942392 | 2021-11-22 | Jefferson | Pennsylvania | 42065 | 5899 | 140 |
1939142 | 1939142 | 2021-11-21 | Jefferson | Pennsylvania | 42065 | 5879 | 140 |
1935892 | 1935892 | 2021-11-20 | Jefferson | Pennsylvania | 42065 | 5852 | 140 |
1926167 | 1926167 | 2021-11-17 | Tioga | Pennsylvania | 42117 | 5162 | 140 |
1744169 | 1744169 | 2021-09-22 | Columbia | Pennsylvania | 42037 | 6795 | 140 |
1740920 | 1740920 | 2021-09-21 | Columbia | Pennsylvania | 42037 | 6770 | 140 |
1737671 | 1737671 | 2021-09-20 | Columbia | Pennsylvania | 42037 | 6746 | 140 |
1734421 | 1734421 | 2021-09-19 | Columbia | Pennsylvania | 42037 | 6729 | 140 |
1731171 | 1731171 | 2021-09-18 | Columbia | Pennsylvania | 42037 | 6692 | 140 |
1727921 | 1727921 | 2021-09-17 | Columbia | Pennsylvania | 42037 | 6658 | 140 |
1724672 | 1724672 | 2021-09-16 | Columbia | Pennsylvania | 42037 | 6609 | 140 |
1701949 | 1701949 | 2021-09-09 | Huntingdon | Pennsylvania | 42061 | 5631 | 140 |
1422641 | 1422641 | 2021-06-15 | Bedford | Pennsylvania | 42009 | 4697 | 140 |
1419395 | 1419395 | 2021-06-14 | Bedford | Pennsylvania | 42009 | 4697 | 140 |
1416150 | 1416150 | 2021-06-13 | Bedford | Pennsylvania | 42009 | 4696 | 140 |
1412904 | 1412904 | 2021-06-12 | Bedford | Pennsylvania | 42009 | 4694 | 140 |
1409659 | 1409659 | 2021-06-11 | Bedford | Pennsylvania | 42009 | 4694 | 140 |
1406414 | 1406414 | 2021-06-10 | Bedford | Pennsylvania | 42009 | 4689 | 140 |
1403168 | 1403168 | 2021-06-09 | Bedford | Pennsylvania | 42009 | 4674 | 140 |
1354482 | 1354482 | 2021-05-25 | Armstrong | Pennsylvania | 42005 | 5956 | 140 |
1286316 | 1286316 | 2021-05-04 | Clearfield | Pennsylvania | 42033 | 8254 | 140 |
1136939 | 1136939 | 2021-03-19 | Crawford | Pennsylvania | 42039 | 6580 | 140 |
1133693 | 1133693 | 2021-03-18 | Crawford | Pennsylvania | 42039 | 6567 | 140 |
1127198 | 1127198 | 2021-03-16 | Crawford | Pennsylvania | 42039 | 6550 | 140 |
1123952 | 1123952 | 2021-03-15 | Crawford | Pennsylvania | 42039 | 6537 | 140 |
1036305 | 1036305 | 2021-02-16 | Carbon | Pennsylvania | 42025 | 4713 | 140 |
974623 | 974623 | 2021-01-28 | Adams | Pennsylvania | 42001 | 6446 | 140 |
971378 | 971378 | 2021-01-27 | Adams | Pennsylvania | 42001 | 6400 | 140 |
942201 | 942201 | 2021-01-18 | Indiana | Pennsylvania | 42063 | 4519 | 140 |
938956 | 938956 | 2021-01-17 | Indiana | Pennsylvania | 42063 | 4496 | 140 |
935711 | 935711 | 2021-01-16 | Indiana | Pennsylvania | 42063 | 4473 | 140 |
922735 | 922735 | 2021-01-12 | Lawrence | Pennsylvania | 42073 | 4871 | 140 |
919490 | 919490 | 2021-01-11 | Lawrence | Pennsylvania | 42073 | 4826 | 140 |
909759 | 909759 | 2021-01-08 | Lycoming | Pennsylvania | 42081 | 6700 | 140 |
835101 | 835101 | 2020-12-16 | Erie | Pennsylvania | 42049 | 9026 | 140 |
689059 | 689059 | 2020-11-01 | Beaver | Pennsylvania | 42007 | 2343 | 140 |
685814 | 685814 | 2020-10-31 | Beaver | Pennsylvania | 42007 | 2325 | 140 |
682571 | 682571 | 2020-10-30 | Beaver | Pennsylvania | 42007 | 2302 | 140 |
679328 | 679328 | 2020-10-29 | Beaver | Pennsylvania | 42007 | 2283 | 140 |
676085 | 676085 | 2020-10-28 | Beaver | Pennsylvania | 42007 | 2270 | 140 |
672842 | 672842 | 2020-10-27 | Beaver | Pennsylvania | 42007 | 2255 | 140 |
669600 | 669600 | 2020-10-26 | Beaver | Pennsylvania | 42007 | 2246 | 140 |
666356 | 666356 | 2020-10-25 | Beaver | Pennsylvania | 42007 | 2241 | 140 |
663111 | 663111 | 2020-10-24 | Beaver | Pennsylvania | 42007 | 2236 | 140 |
308250 | 308250 | 2020-07-06 | Dauphin | Pennsylvania | 42043 | 2198 | 140 |
305083 | 305083 | 2020-07-05 | Dauphin | Pennsylvania | 42043 | 2194 | 140 |
301920 | 301920 | 2020-07-04 | Dauphin | Pennsylvania | 42043 | 2174 | 140 |
298756 | 298756 | 2020-07-03 | Dauphin | Pennsylvania | 42043 | 2161 | 140 |
88904 | 88904 | 2020-04-25 | Lancaster | Pennsylvania | 42071 | 1501 | 140 |
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);