ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 42077 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176501 | 2176501 | 2022-02-02 | Lehigh | Pennsylvania | 42077 | 87174 | 1170 |
2173247 | 2173247 | 2022-02-01 | Lehigh | Pennsylvania | 42077 | 87011 | 1166 |
2169995 | 2169995 | 2022-01-31 | Lehigh | Pennsylvania | 42077 | 86931 | 1161 |
2166741 | 2166741 | 2022-01-30 | Lehigh | Pennsylvania | 42077 | 86820 | 1161 |
2163486 | 2163486 | 2022-01-29 | Lehigh | Pennsylvania | 42077 | 86662 | 1160 |
2160231 | 2160231 | 2022-01-28 | Lehigh | Pennsylvania | 42077 | 86489 | 1155 |
2156975 | 2156975 | 2022-01-27 | Lehigh | Pennsylvania | 42077 | 86118 | 1152 |
2153722 | 2153722 | 2022-01-26 | Lehigh | Pennsylvania | 42077 | 85673 | 1143 |
2150470 | 2150470 | 2022-01-25 | Lehigh | Pennsylvania | 42077 | 85361 | 1141 |
2147218 | 2147218 | 2022-01-24 | Lehigh | Pennsylvania | 42077 | 85096 | 1139 |
2143964 | 2143964 | 2022-01-23 | Lehigh | Pennsylvania | 42077 | 84946 | 1139 |
2140709 | 2140709 | 2022-01-22 | Lehigh | Pennsylvania | 42077 | 84612 | 1137 |
2137453 | 2137453 | 2022-01-21 | Lehigh | Pennsylvania | 42077 | 84113 | 1133 |
2134199 | 2134199 | 2022-01-20 | Lehigh | Pennsylvania | 42077 | 83616 | 1126 |
2130947 | 2130947 | 2022-01-19 | Lehigh | Pennsylvania | 42077 | 83194 | 1109 |
2127693 | 2127693 | 2022-01-18 | Lehigh | Pennsylvania | 42077 | 82766 | 1109 |
2124441 | 2124441 | 2022-01-17 | Lehigh | Pennsylvania | 42077 | 82488 | 1108 |
2121189 | 2121189 | 2022-01-16 | Lehigh | Pennsylvania | 42077 | 82120 | 1108 |
2117937 | 2117937 | 2022-01-15 | Lehigh | Pennsylvania | 42077 | 80779 | 1108 |
2114686 | 2114686 | 2022-01-14 | Lehigh | Pennsylvania | 42077 | 80215 | 1101 |
2111434 | 2111434 | 2022-01-13 | Lehigh | Pennsylvania | 42077 | 79301 | 1097 |
2108182 | 2108182 | 2022-01-12 | Lehigh | Pennsylvania | 42077 | 78188 | 1092 |
2104931 | 2104931 | 2022-01-11 | Lehigh | Pennsylvania | 42077 | 76767 | 1083 |
2101680 | 2101680 | 2022-01-10 | Lehigh | Pennsylvania | 42077 | 75139 | 1077 |
2098429 | 2098429 | 2022-01-09 | Lehigh | Pennsylvania | 42077 | 73591 | 1076 |
2095177 | 2095177 | 2022-01-08 | Lehigh | Pennsylvania | 42077 | 72327 | 1075 |
2091925 | 2091925 | 2022-01-07 | Lehigh | Pennsylvania | 42077 | 70687 | 1071 |
2088673 | 2088673 | 2022-01-06 | Lehigh | Pennsylvania | 42077 | 69438 | 1066 |
2085422 | 2085422 | 2022-01-05 | Lehigh | Pennsylvania | 42077 | 68397 | 1055 |
2082170 | 2082170 | 2022-01-04 | Lehigh | Pennsylvania | 42077 | 67438 | 1054 |
2078918 | 2078918 | 2022-01-03 | Lehigh | Pennsylvania | 42077 | 66613 | 1049 |
2075667 | 2075667 | 2022-01-02 | Lehigh | Pennsylvania | 42077 | 65466 | 1047 |
2072416 | 2072416 | 2022-01-01 | Lehigh | Pennsylvania | 42077 | 64637 | 1047 |
2069165 | 2069165 | 2021-12-31 | Lehigh | Pennsylvania | 42077 | 63964 | 1047 |
2065914 | 2065914 | 2021-12-30 | Lehigh | Pennsylvania | 42077 | 62899 | 1047 |
2062664 | 2062664 | 2021-12-29 | Lehigh | Pennsylvania | 42077 | 62360 | 1045 |
2059414 | 2059414 | 2021-12-28 | Lehigh | Pennsylvania | 42077 | 61824 | 1033 |
2056165 | 2056165 | 2021-12-27 | Lehigh | Pennsylvania | 42077 | 61129 | 1032 |
2052916 | 2052916 | 2021-12-26 | Lehigh | Pennsylvania | 42077 | 60848 | 1032 |
2049666 | 2049666 | 2021-12-25 | Lehigh | Pennsylvania | 42077 | 60424 | 1032 |
2046416 | 2046416 | 2021-12-24 | Lehigh | Pennsylvania | 42077 | 60027 | 1032 |
2043166 | 2043166 | 2021-12-23 | Lehigh | Pennsylvania | 42077 | 59662 | 1029 |
2039917 | 2039917 | 2021-12-22 | Lehigh | Pennsylvania | 42077 | 59271 | 1021 |
2036667 | 2036667 | 2021-12-21 | Lehigh | Pennsylvania | 42077 | 58993 | 1012 |
2033417 | 2033417 | 2021-12-20 | Lehigh | Pennsylvania | 42077 | 58738 | 1010 |
2030167 | 2030167 | 2021-12-19 | Lehigh | Pennsylvania | 42077 | 58502 | 1010 |
2026916 | 2026916 | 2021-12-18 | Lehigh | Pennsylvania | 42077 | 58253 | 1009 |
2023665 | 2023665 | 2021-12-17 | Lehigh | Pennsylvania | 42077 | 57909 | 1002 |
2020414 | 2020414 | 2021-12-16 | Lehigh | Pennsylvania | 42077 | 57650 | 1002 |
2017163 | 2017163 | 2021-12-15 | Lehigh | Pennsylvania | 42077 | 57358 | 998 |
2013913 | 2013913 | 2021-12-14 | Lehigh | Pennsylvania | 42077 | 57085 | 994 |
2010662 | 2010662 | 2021-12-13 | Lehigh | Pennsylvania | 42077 | 56795 | 991 |
2007411 | 2007411 | 2021-12-12 | Lehigh | Pennsylvania | 42077 | 56526 | 991 |
2004160 | 2004160 | 2021-12-11 | Lehigh | Pennsylvania | 42077 | 56202 | 991 |
2000909 | 2000909 | 2021-12-10 | Lehigh | Pennsylvania | 42077 | 55725 | 985 |
1997659 | 1997659 | 2021-12-09 | Lehigh | Pennsylvania | 42077 | 55238 | 982 |
1994408 | 1994408 | 2021-12-08 | Lehigh | Pennsylvania | 42077 | 55038 | 982 |
1991157 | 1991157 | 2021-12-07 | Lehigh | Pennsylvania | 42077 | 54835 | 981 |
1987906 | 1987906 | 2021-12-06 | Lehigh | Pennsylvania | 42077 | 54625 | 976 |
1984656 | 1984656 | 2021-12-05 | Lehigh | Pennsylvania | 42077 | 54391 | 972 |
1981406 | 1981406 | 2021-12-04 | Lehigh | Pennsylvania | 42077 | 54159 | 971 |
1978156 | 1978156 | 2021-12-03 | Lehigh | Pennsylvania | 42077 | 53771 | 968 |
1974906 | 1974906 | 2021-12-02 | Lehigh | Pennsylvania | 42077 | 53487 | 967 |
1971657 | 1971657 | 2021-12-01 | Lehigh | Pennsylvania | 42077 | 53173 | 963 |
1968407 | 1968407 | 2021-11-30 | Lehigh | Pennsylvania | 42077 | 52965 | 963 |
1965156 | 1965156 | 2021-11-29 | Lehigh | Pennsylvania | 42077 | 52782 | 961 |
1961904 | 1961904 | 2021-11-28 | Lehigh | Pennsylvania | 42077 | 52620 | 961 |
1958653 | 1958653 | 2021-11-27 | Lehigh | Pennsylvania | 42077 | 52411 | 961 |
1955402 | 1955402 | 2021-11-26 | Lehigh | Pennsylvania | 42077 | 52272 | 961 |
1952151 | 1952151 | 2021-11-25 | Lehigh | Pennsylvania | 42077 | 52025 | 961 |
1948900 | 1948900 | 2021-11-24 | Lehigh | Pennsylvania | 42077 | 51852 | 958 |
1945649 | 1945649 | 2021-11-23 | Lehigh | Pennsylvania | 42077 | 51670 | 958 |
1942398 | 1942398 | 2021-11-22 | Lehigh | Pennsylvania | 42077 | 51454 | 957 |
1939148 | 1939148 | 2021-11-21 | Lehigh | Pennsylvania | 42077 | 51318 | 957 |
1935898 | 1935898 | 2021-11-20 | Lehigh | Pennsylvania | 42077 | 51176 | 957 |
1932648 | 1932648 | 2021-11-19 | Lehigh | Pennsylvania | 42077 | 51023 | 957 |
1929397 | 1929397 | 2021-11-18 | Lehigh | Pennsylvania | 42077 | 50839 | 957 |
1926147 | 1926147 | 2021-11-17 | Lehigh | Pennsylvania | 42077 | 50662 | 955 |
1922897 | 1922897 | 2021-11-16 | Lehigh | Pennsylvania | 42077 | 50486 | 953 |
1919648 | 1919648 | 2021-11-15 | Lehigh | Pennsylvania | 42077 | 50329 | 953 |
1916398 | 1916398 | 2021-11-14 | Lehigh | Pennsylvania | 42077 | 50254 | 953 |
1913148 | 1913148 | 2021-11-13 | Lehigh | Pennsylvania | 42077 | 50148 | 953 |
1909898 | 1909898 | 2021-11-12 | Lehigh | Pennsylvania | 42077 | 49611 | 951 |
1906649 | 1906649 | 2021-11-11 | Lehigh | Pennsylvania | 42077 | 49519 | 951 |
1903400 | 1903400 | 2021-11-10 | Lehigh | Pennsylvania | 42077 | 49391 | 950 |
1900150 | 1900150 | 2021-11-09 | Lehigh | Pennsylvania | 42077 | 49300 | 947 |
1896900 | 1896900 | 2021-11-08 | Lehigh | Pennsylvania | 42077 | 49207 | 947 |
1893650 | 1893650 | 2021-11-07 | Lehigh | Pennsylvania | 42077 | 49157 | 946 |
1890400 | 1890400 | 2021-11-06 | Lehigh | Pennsylvania | 42077 | 49078 | 946 |
1887150 | 1887150 | 2021-11-05 | Lehigh | Pennsylvania | 42077 | 48991 | 945 |
1883900 | 1883900 | 2021-11-04 | Lehigh | Pennsylvania | 42077 | 48932 | 944 |
1880651 | 1880651 | 2021-11-03 | Lehigh | Pennsylvania | 42077 | 48818 | 943 |
1877402 | 1877402 | 2021-11-02 | Lehigh | Pennsylvania | 42077 | 48768 | 939 |
1874153 | 1874153 | 2021-11-01 | Lehigh | Pennsylvania | 42077 | 48618 | 939 |
1870904 | 1870904 | 2021-10-31 | Lehigh | Pennsylvania | 42077 | 48618 | 939 |
1867655 | 1867655 | 2021-10-30 | Lehigh | Pennsylvania | 42077 | 48544 | 938 |
1864406 | 1864406 | 2021-10-29 | Lehigh | Pennsylvania | 42077 | 48482 | 938 |
1861157 | 1861157 | 2021-10-28 | Lehigh | Pennsylvania | 42077 | 48369 | 937 |
1857908 | 1857908 | 2021-10-27 | Lehigh | Pennsylvania | 42077 | 48278 | 937 |
1854659 | 1854659 | 2021-10-26 | Lehigh | Pennsylvania | 42077 | 48225 | 936 |
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);