ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
834 rows where fips = 6085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174424 | 2174424 | 2022-02-02 | Santa Clara | California | 6085 | 297301 | 2071 |
2171171 | 2171171 | 2022-02-01 | Santa Clara | California | 6085 | 295754 | 2042 |
2167918 | 2167918 | 2022-01-31 | Santa Clara | California | 6085 | 294038 | 2036 |
2164663 | 2164663 | 2022-01-30 | Santa Clara | California | 6085 | 285071 | 2020 |
2161408 | 2161408 | 2022-01-29 | Santa Clara | California | 6085 | 285071 | 2020 |
2158152 | 2158152 | 2022-01-28 | Santa Clara | California | 6085 | 285071 | 2020 |
2154899 | 2154899 | 2022-01-27 | Santa Clara | California | 6085 | 281662 | 2016 |
2151646 | 2151646 | 2022-01-26 | Santa Clara | California | 6085 | 276820 | 2007 |
2148394 | 2148394 | 2022-01-25 | Santa Clara | California | 6085 | 274130 | 2007 |
2145142 | 2145142 | 2022-01-24 | Santa Clara | California | 6085 | 270780 | 2006 |
2141887 | 2141887 | 2022-01-23 | Santa Clara | California | 6085 | 257994 | 1994 |
2138632 | 2138632 | 2022-01-22 | Santa Clara | California | 6085 | 257994 | 1994 |
2135376 | 2135376 | 2022-01-21 | Santa Clara | California | 6085 | 257994 | 1994 |
2132124 | 2132124 | 2022-01-20 | Santa Clara | California | 6085 | 253711 | 1992 |
2128871 | 2128871 | 2022-01-19 | Santa Clara | California | 6085 | 245673 | 1987 |
2125617 | 2125617 | 2022-01-18 | Santa Clara | California | 6085 | 243326 | 1986 |
2122365 | 2122365 | 2022-01-17 | Santa Clara | California | 6085 | 239685 | 1985 |
2119113 | 2119113 | 2022-01-16 | Santa Clara | California | 6085 | 224378 | 1975 |
2115861 | 2115861 | 2022-01-15 | Santa Clara | California | 6085 | 224378 | 1975 |
2112610 | 2112610 | 2022-01-14 | Santa Clara | California | 6085 | 224378 | 1975 |
2109358 | 2109358 | 2022-01-13 | Santa Clara | California | 6085 | 218660 | 1972 |
2106107 | 2106107 | 2022-01-12 | Santa Clara | California | 6085 | 212940 | 1972 |
2102856 | 2102856 | 2022-01-11 | Santa Clara | California | 6085 | 208256 | 1972 |
2099605 | 2099605 | 2022-01-10 | Santa Clara | California | 6085 | 203430 | 1977 |
2096354 | 2096354 | 2022-01-09 | Santa Clara | California | 6085 | 188711 | 1967 |
2093102 | 2093102 | 2022-01-08 | Santa Clara | California | 6085 | 188711 | 1967 |
2089850 | 2089850 | 2022-01-07 | Santa Clara | California | 6085 | 188711 | 1967 |
2086599 | 2086599 | 2022-01-06 | Santa Clara | California | 6085 | 183551 | 1962 |
2083347 | 2083347 | 2022-01-05 | Santa Clara | California | 6085 | 178916 | 1965 |
2080095 | 2080095 | 2022-01-04 | Santa Clara | California | 6085 | 176928 | 1964 |
2076843 | 2076843 | 2022-01-03 | Santa Clara | California | 6085 | 174330 | 1970 |
2073592 | 2073592 | 2022-01-02 | Santa Clara | California | 6085 | 166609 | 1970 |
2070341 | 2070341 | 2022-01-01 | Santa Clara | California | 6085 | 166609 | 1970 |
2067090 | 2067090 | 2021-12-31 | Santa Clara | California | 6085 | 166609 | 1970 |
2063839 | 2063839 | 2021-12-30 | Santa Clara | California | 6085 | 164698 | 1963 |
2060589 | 2060589 | 2021-12-29 | Santa Clara | California | 6085 | 162666 | 1963 |
2057340 | 2057340 | 2021-12-28 | Santa Clara | California | 6085 | 161759 | 1962 |
2054091 | 2054091 | 2021-12-27 | Santa Clara | California | 6085 | 159974 | 1968 |
2050841 | 2050841 | 2021-12-26 | Santa Clara | California | 6085 | 158727 | 1968 |
2047591 | 2047591 | 2021-12-25 | Santa Clara | California | 6085 | 158727 | 1968 |
2044341 | 2044341 | 2021-12-24 | Santa Clara | California | 6085 | 158727 | 1968 |
2041092 | 2041092 | 2021-12-23 | Santa Clara | California | 6085 | 158113 | 1955 |
2037842 | 2037842 | 2021-12-22 | Santa Clara | California | 6085 | 157557 | 1952 |
2034592 | 2034592 | 2021-12-21 | Santa Clara | California | 6085 | 157215 | 1951 |
2031342 | 2031342 | 2021-12-20 | Santa Clara | California | 6085 | 156837 | 1951 |
2028091 | 2028091 | 2021-12-19 | Santa Clara | California | 6085 | 156031 | 1947 |
2024840 | 2024840 | 2021-12-18 | Santa Clara | California | 6085 | 156031 | 1947 |
2021589 | 2021589 | 2021-12-17 | Santa Clara | California | 6085 | 156031 | 1947 |
2018338 | 2018338 | 2021-12-16 | Santa Clara | California | 6085 | 155716 | 1945 |
2015088 | 2015088 | 2021-12-15 | Santa Clara | California | 6085 | 155504 | 1946 |
2011837 | 2011837 | 2021-12-14 | Santa Clara | California | 6085 | 155362 | 1945 |
2008586 | 2008586 | 2021-12-13 | Santa Clara | California | 6085 | 155142 | 1946 |
2005335 | 2005335 | 2021-12-12 | Santa Clara | California | 6085 | 154536 | 1942 |
2002084 | 2002084 | 2021-12-11 | Santa Clara | California | 6085 | 154536 | 1942 |
1998834 | 1998834 | 2021-12-10 | Santa Clara | California | 6085 | 154536 | 1942 |
1995583 | 1995583 | 2021-12-09 | Santa Clara | California | 6085 | 154364 | 1938 |
1992332 | 1992332 | 2021-12-08 | Santa Clara | California | 6085 | 154047 | 1942 |
1989081 | 1989081 | 2021-12-07 | Santa Clara | California | 6085 | 153892 | 1938 |
1985831 | 1985831 | 2021-12-06 | Santa Clara | California | 6085 | 153696 | 1934 |
1982581 | 1982581 | 2021-12-05 | Santa Clara | California | 6085 | 152857 | 1929 |
1979331 | 1979331 | 2021-12-04 | Santa Clara | California | 6085 | 152857 | 1929 |
1976081 | 1976081 | 2021-12-03 | Santa Clara | California | 6085 | 152857 | 1929 |
1972832 | 1972832 | 2021-12-02 | Santa Clara | California | 6085 | 152543 | 1926 |
1969582 | 1969582 | 2021-12-01 | Santa Clara | California | 6085 | 152268 | 1930 |
1966332 | 1966332 | 2021-11-30 | Santa Clara | California | 6085 | 152089 | 1926 |
1963080 | 1963080 | 2021-11-29 | Santa Clara | California | 6085 | 151905 | 1921 |
1959829 | 1959829 | 2021-11-28 | Santa Clara | California | 6085 | 151169 | 1923 |
1956578 | 1956578 | 2021-11-27 | Santa Clara | California | 6085 | 151169 | 1923 |
1953327 | 1953327 | 2021-11-26 | Santa Clara | California | 6085 | 151169 | 1923 |
1950076 | 1950076 | 2021-11-25 | Santa Clara | California | 6085 | 151169 | 1923 |
1946825 | 1946825 | 2021-11-24 | Santa Clara | California | 6085 | 151169 | 1923 |
1943574 | 1943574 | 2021-11-23 | Santa Clara | California | 6085 | 151010 | 1920 |
1940324 | 1940324 | 2021-11-22 | Santa Clara | California | 6085 | 150856 | 1919 |
1937074 | 1937074 | 2021-11-21 | Santa Clara | California | 6085 | 150298 | 1918 |
1933824 | 1933824 | 2021-11-20 | Santa Clara | California | 6085 | 150298 | 1918 |
1930572 | 1930572 | 2021-11-19 | Santa Clara | California | 6085 | 150298 | 1918 |
1927322 | 1927322 | 2021-11-18 | Santa Clara | California | 6085 | 150095 | 1916 |
1924072 | 1924072 | 2021-11-17 | Santa Clara | California | 6085 | 149882 | 1917 |
1920823 | 1920823 | 2021-11-16 | Santa Clara | California | 6085 | 149743 | 1915 |
1917573 | 1917573 | 2021-11-15 | Santa Clara | California | 6085 | 149582 | 1914 |
1914323 | 1914323 | 2021-11-14 | Santa Clara | California | 6085 | 149251 | 1906 |
1911073 | 1911073 | 2021-11-13 | Santa Clara | California | 6085 | 149251 | 1906 |
1907824 | 1907824 | 2021-11-12 | Santa Clara | California | 6085 | 148888 | 1902 |
1904575 | 1904575 | 2021-11-11 | Santa Clara | California | 6085 | 148888 | 1902 |
1901325 | 1901325 | 2021-11-10 | Santa Clara | California | 6085 | 148680 | 1902 |
1898075 | 1898075 | 2021-11-09 | Santa Clara | California | 6085 | 148582 | 1900 |
1894825 | 1894825 | 2021-11-08 | Santa Clara | California | 6085 | 148453 | 1899 |
1891575 | 1891575 | 2021-11-07 | Santa Clara | California | 6085 | 147918 | 1895 |
1888325 | 1888325 | 2021-11-06 | Santa Clara | California | 6085 | 147918 | 1895 |
1885075 | 1885075 | 2021-11-05 | Santa Clara | California | 6085 | 147918 | 1895 |
1881826 | 1881826 | 2021-11-04 | Santa Clara | California | 6085 | 147658 | 1898 |
1878577 | 1878577 | 2021-11-03 | Santa Clara | California | 6085 | 147412 | 1897 |
1875328 | 1875328 | 2021-11-02 | Santa Clara | California | 6085 | 147275 | 1908 |
1872079 | 1872079 | 2021-11-01 | Santa Clara | California | 6085 | 147126 | 1909 |
1868830 | 1868830 | 2021-10-31 | Santa Clara | California | 6085 | 146559 | 1904 |
1865581 | 1865581 | 2021-10-30 | Santa Clara | California | 6085 | 146559 | 1904 |
1862332 | 1862332 | 2021-10-29 | Santa Clara | California | 6085 | 146559 | 1904 |
1859083 | 1859083 | 2021-10-28 | Santa Clara | California | 6085 | 146378 | 1903 |
1855834 | 1855834 | 2021-10-27 | Santa Clara | California | 6085 | 146199 | 1904 |
1852585 | 1852585 | 2021-10-26 | Santa Clara | California | 6085 | 146162 | 1902 |
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);