ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 42029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176477 | 2176477 | 2022-02-02 | Chester | Pennsylvania | 42029 | 87863 | 1073 |
2173223 | 2173223 | 2022-02-01 | Chester | Pennsylvania | 42029 | 87658 | 1070 |
2169971 | 2169971 | 2022-01-31 | Chester | Pennsylvania | 42029 | 87448 | 1058 |
2166717 | 2166717 | 2022-01-30 | Chester | Pennsylvania | 42029 | 87343 | 1058 |
2163462 | 2163462 | 2022-01-29 | Chester | Pennsylvania | 42029 | 87147 | 1057 |
2160207 | 2160207 | 2022-01-28 | Chester | Pennsylvania | 42029 | 86923 | 1054 |
2156951 | 2156951 | 2022-01-27 | Chester | Pennsylvania | 42029 | 86490 | 1053 |
2153698 | 2153698 | 2022-01-26 | Chester | Pennsylvania | 42029 | 85999 | 1038 |
2150446 | 2150446 | 2022-01-25 | Chester | Pennsylvania | 42029 | 85615 | 1037 |
2147194 | 2147194 | 2022-01-24 | Chester | Pennsylvania | 42029 | 85307 | 1035 |
2143940 | 2143940 | 2022-01-23 | Chester | Pennsylvania | 42029 | 85030 | 1035 |
2140685 | 2140685 | 2022-01-22 | Chester | Pennsylvania | 42029 | 84628 | 1035 |
2137429 | 2137429 | 2022-01-21 | Chester | Pennsylvania | 42029 | 84183 | 1032 |
2134175 | 2134175 | 2022-01-20 | Chester | Pennsylvania | 42029 | 83698 | 1028 |
2130923 | 2130923 | 2022-01-19 | Chester | Pennsylvania | 42029 | 83005 | 1024 |
2127669 | 2127669 | 2022-01-18 | Chester | Pennsylvania | 42029 | 82556 | 1020 |
2124417 | 2124417 | 2022-01-17 | Chester | Pennsylvania | 42029 | 82080 | 1020 |
2121165 | 2121165 | 2022-01-16 | Chester | Pennsylvania | 42029 | 81471 | 1020 |
2117913 | 2117913 | 2022-01-15 | Chester | Pennsylvania | 42029 | 80208 | 1020 |
2114662 | 2114662 | 2022-01-14 | Chester | Pennsylvania | 42029 | 79292 | 1010 |
2111410 | 2111410 | 2022-01-13 | Chester | Pennsylvania | 42029 | 78535 | 1007 |
2108158 | 2108158 | 2022-01-12 | Chester | Pennsylvania | 42029 | 77666 | 1003 |
2104907 | 2104907 | 2022-01-11 | Chester | Pennsylvania | 42029 | 76863 | 998 |
2101656 | 2101656 | 2022-01-10 | Chester | Pennsylvania | 42029 | 76043 | 993 |
2098405 | 2098405 | 2022-01-09 | Chester | Pennsylvania | 42029 | 75216 | 993 |
2095153 | 2095153 | 2022-01-08 | Chester | Pennsylvania | 42029 | 74137 | 993 |
2091901 | 2091901 | 2022-01-07 | Chester | Pennsylvania | 42029 | 73168 | 990 |
2088649 | 2088649 | 2022-01-06 | Chester | Pennsylvania | 42029 | 72122 | 983 |
2085398 | 2085398 | 2022-01-05 | Chester | Pennsylvania | 42029 | 71223 | 976 |
2082146 | 2082146 | 2022-01-04 | Chester | Pennsylvania | 42029 | 70090 | 974 |
2078894 | 2078894 | 2022-01-03 | Chester | Pennsylvania | 42029 | 69335 | 970 |
2075643 | 2075643 | 2022-01-02 | Chester | Pennsylvania | 42029 | 68556 | 967 |
2072392 | 2072392 | 2022-01-01 | Chester | Pennsylvania | 42029 | 67755 | 967 |
2069141 | 2069141 | 2021-12-31 | Chester | Pennsylvania | 42029 | 66965 | 967 |
2065890 | 2065890 | 2021-12-30 | Chester | Pennsylvania | 42029 | 65963 | 962 |
2062640 | 2062640 | 2021-12-29 | Chester | Pennsylvania | 42029 | 65162 | 958 |
2059390 | 2059390 | 2021-12-28 | Chester | Pennsylvania | 42029 | 64499 | 954 |
2056141 | 2056141 | 2021-12-27 | Chester | Pennsylvania | 42029 | 63789 | 948 |
2052892 | 2052892 | 2021-12-26 | Chester | Pennsylvania | 42029 | 63518 | 948 |
2049642 | 2049642 | 2021-12-25 | Chester | Pennsylvania | 42029 | 63050 | 948 |
2046392 | 2046392 | 2021-12-24 | Chester | Pennsylvania | 42029 | 62638 | 948 |
2043142 | 2043142 | 2021-12-23 | Chester | Pennsylvania | 42029 | 62064 | 944 |
2039893 | 2039893 | 2021-12-22 | Chester | Pennsylvania | 42029 | 61651 | 938 |
2036643 | 2036643 | 2021-12-21 | Chester | Pennsylvania | 42029 | 61255 | 937 |
2033393 | 2033393 | 2021-12-20 | Chester | Pennsylvania | 42029 | 60935 | 937 |
2030143 | 2030143 | 2021-12-19 | Chester | Pennsylvania | 42029 | 60720 | 937 |
2026892 | 2026892 | 2021-12-18 | Chester | Pennsylvania | 42029 | 60414 | 934 |
2023641 | 2023641 | 2021-12-17 | Chester | Pennsylvania | 42029 | 60010 | 930 |
2020390 | 2020390 | 2021-12-16 | Chester | Pennsylvania | 42029 | 59688 | 929 |
2017139 | 2017139 | 2021-12-15 | Chester | Pennsylvania | 42029 | 59384 | 927 |
2013889 | 2013889 | 2021-12-14 | Chester | Pennsylvania | 42029 | 59056 | 923 |
2010638 | 2010638 | 2021-12-13 | Chester | Pennsylvania | 42029 | 58779 | 920 |
2007387 | 2007387 | 2021-12-12 | Chester | Pennsylvania | 42029 | 58556 | 920 |
2004136 | 2004136 | 2021-12-11 | Chester | Pennsylvania | 42029 | 58320 | 918 |
2000885 | 2000885 | 2021-12-10 | Chester | Pennsylvania | 42029 | 57893 | 916 |
1997635 | 1997635 | 2021-12-09 | Chester | Pennsylvania | 42029 | 57459 | 916 |
1994384 | 1994384 | 2021-12-08 | Chester | Pennsylvania | 42029 | 57225 | 916 |
1991133 | 1991133 | 2021-12-07 | Chester | Pennsylvania | 42029 | 56993 | 915 |
1987882 | 1987882 | 2021-12-06 | Chester | Pennsylvania | 42029 | 56761 | 914 |
1984632 | 1984632 | 2021-12-05 | Chester | Pennsylvania | 42029 | 56677 | 913 |
1981382 | 1981382 | 2021-12-04 | Chester | Pennsylvania | 42029 | 56515 | 912 |
1978132 | 1978132 | 2021-12-03 | Chester | Pennsylvania | 42029 | 56266 | 910 |
1974882 | 1974882 | 2021-12-02 | Chester | Pennsylvania | 42029 | 55993 | 909 |
1971633 | 1971633 | 2021-12-01 | Chester | Pennsylvania | 42029 | 55670 | 906 |
1968383 | 1968383 | 2021-11-30 | Chester | Pennsylvania | 42029 | 55423 | 905 |
1965132 | 1965132 | 2021-11-29 | Chester | Pennsylvania | 42029 | 55228 | 903 |
1961880 | 1961880 | 2021-11-28 | Chester | Pennsylvania | 42029 | 55089 | 903 |
1958629 | 1958629 | 2021-11-27 | Chester | Pennsylvania | 42029 | 54981 | 903 |
1955378 | 1955378 | 2021-11-26 | Chester | Pennsylvania | 42029 | 54840 | 903 |
1952127 | 1952127 | 2021-11-25 | Chester | Pennsylvania | 42029 | 54713 | 903 |
1948876 | 1948876 | 2021-11-24 | Chester | Pennsylvania | 42029 | 54518 | 902 |
1945625 | 1945625 | 2021-11-23 | Chester | Pennsylvania | 42029 | 54377 | 902 |
1942374 | 1942374 | 2021-11-22 | Chester | Pennsylvania | 42029 | 54218 | 901 |
1939124 | 1939124 | 2021-11-21 | Chester | Pennsylvania | 42029 | 54083 | 901 |
1935874 | 1935874 | 2021-11-20 | Chester | Pennsylvania | 42029 | 53944 | 901 |
1932624 | 1932624 | 2021-11-19 | Chester | Pennsylvania | 42029 | 53807 | 900 |
1929373 | 1929373 | 2021-11-18 | Chester | Pennsylvania | 42029 | 53655 | 899 |
1926123 | 1926123 | 2021-11-17 | Chester | Pennsylvania | 42029 | 53475 | 897 |
1922873 | 1922873 | 2021-11-16 | Chester | Pennsylvania | 42029 | 53278 | 895 |
1919624 | 1919624 | 2021-11-15 | Chester | Pennsylvania | 42029 | 53141 | 895 |
1916374 | 1916374 | 2021-11-14 | Chester | Pennsylvania | 42029 | 53031 | 895 |
1913124 | 1913124 | 2021-11-13 | Chester | Pennsylvania | 42029 | 52886 | 895 |
1909874 | 1909874 | 2021-11-12 | Chester | Pennsylvania | 42029 | 52331 | 893 |
1906625 | 1906625 | 2021-11-11 | Chester | Pennsylvania | 42029 | 52226 | 892 |
1903376 | 1903376 | 2021-11-10 | Chester | Pennsylvania | 42029 | 52084 | 892 |
1900126 | 1900126 | 2021-11-09 | Chester | Pennsylvania | 42029 | 51957 | 891 |
1896876 | 1896876 | 2021-11-08 | Chester | Pennsylvania | 42029 | 51826 | 888 |
1893626 | 1893626 | 2021-11-07 | Chester | Pennsylvania | 42029 | 51755 | 888 |
1890376 | 1890376 | 2021-11-06 | Chester | Pennsylvania | 42029 | 51647 | 888 |
1887126 | 1887126 | 2021-11-05 | Chester | Pennsylvania | 42029 | 51542 | 888 |
1883876 | 1883876 | 2021-11-04 | Chester | Pennsylvania | 42029 | 51421 | 885 |
1880627 | 1880627 | 2021-11-03 | Chester | Pennsylvania | 42029 | 51260 | 883 |
1877378 | 1877378 | 2021-11-02 | Chester | Pennsylvania | 42029 | 51199 | 881 |
1874129 | 1874129 | 2021-11-01 | Chester | Pennsylvania | 42029 | 51038 | 880 |
1870880 | 1870880 | 2021-10-31 | Chester | Pennsylvania | 42029 | 51038 | 880 |
1867631 | 1867631 | 2021-10-30 | Chester | Pennsylvania | 42029 | 50979 | 879 |
1864382 | 1864382 | 2021-10-29 | Chester | Pennsylvania | 42029 | 50851 | 879 |
1861133 | 1861133 | 2021-10-28 | Chester | Pennsylvania | 42029 | 50754 | 877 |
1857884 | 1857884 | 2021-10-27 | Chester | Pennsylvania | 42029 | 50649 | 875 |
1854635 | 1854635 | 2021-10-26 | Chester | Pennsylvania | 42029 | 50555 | 874 |
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);