ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Clay" and fips = 12019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174527 | 2174527 | 2022-02-02 | Clay | Florida | 12019 | 48940 | 729 |
2171274 | 2171274 | 2022-02-01 | Clay | Florida | 12019 | 48940 | 718 |
2168021 | 2168021 | 2022-01-31 | Clay | Florida | 12019 | 48940 | 718 |
2164766 | 2164766 | 2022-01-30 | Clay | Florida | 12019 | 48940 | 718 |
2161511 | 2161511 | 2022-01-29 | Clay | Florida | 12019 | 48940 | 718 |
2158255 | 2158255 | 2022-01-28 | Clay | Florida | 12019 | 48940 | 718 |
2155002 | 2155002 | 2022-01-27 | Clay | Florida | 12019 | 45746 | 718 |
2151749 | 2151749 | 2022-01-26 | Clay | Florida | 12019 | 45746 | 718 |
2148497 | 2148497 | 2022-01-25 | Clay | Florida | 12019 | 45746 | 710 |
2145245 | 2145245 | 2022-01-24 | Clay | Florida | 12019 | 45746 | 710 |
2141990 | 2141990 | 2022-01-23 | Clay | Florida | 12019 | 45746 | 710 |
2138735 | 2138735 | 2022-01-22 | Clay | Florida | 12019 | 45746 | 710 |
2135479 | 2135479 | 2022-01-21 | Clay | Florida | 12019 | 45746 | 710 |
2132227 | 2132227 | 2022-01-20 | Clay | Florida | 12019 | 42193 | 710 |
2128974 | 2128974 | 2022-01-19 | Clay | Florida | 12019 | 42193 | 710 |
2125720 | 2125720 | 2022-01-18 | Clay | Florida | 12019 | 42193 | 707 |
2122468 | 2122468 | 2022-01-17 | Clay | Florida | 12019 | 42193 | 707 |
2119216 | 2119216 | 2022-01-16 | Clay | Florida | 12019 | 42193 | 707 |
2115964 | 2115964 | 2022-01-15 | Clay | Florida | 12019 | 42193 | 707 |
2112713 | 2112713 | 2022-01-14 | Clay | Florida | 12019 | 42193 | 707 |
2109461 | 2109461 | 2022-01-13 | Clay | Florida | 12019 | 38296 | 707 |
2106210 | 2106210 | 2022-01-12 | Clay | Florida | 12019 | 38296 | 707 |
2102959 | 2102959 | 2022-01-11 | Clay | Florida | 12019 | 38296 | 708 |
2099708 | 2099708 | 2022-01-10 | Clay | Florida | 12019 | 38296 | 708 |
2096457 | 2096457 | 2022-01-09 | Clay | Florida | 12019 | 38296 | 708 |
2093205 | 2093205 | 2022-01-08 | Clay | Florida | 12019 | 38296 | 708 |
2089953 | 2089953 | 2022-01-07 | Clay | Florida | 12019 | 38296 | 708 |
2086702 | 2086702 | 2022-01-06 | Clay | Florida | 12019 | 35827 | 708 |
2083450 | 2083450 | 2022-01-05 | Clay | Florida | 12019 | 35827 | 708 |
2080198 | 2080198 | 2022-01-04 | Clay | Florida | 12019 | 35827 | 703 |
2076946 | 2076946 | 2022-01-03 | Clay | Florida | 12019 | 35827 | 703 |
2073695 | 2073695 | 2022-01-02 | Clay | Florida | 12019 | 35827 | 703 |
2070444 | 2070444 | 2022-01-01 | Clay | Florida | 12019 | 35827 | 703 |
2067193 | 2067193 | 2021-12-31 | Clay | Florida | 12019 | 35827 | 703 |
2063942 | 2063942 | 2021-12-30 | Clay | Florida | 12019 | 34622 | 703 |
2060692 | 2060692 | 2021-12-29 | Clay | Florida | 12019 | 34622 | 703 |
2057443 | 2057443 | 2021-12-28 | Clay | Florida | 12019 | 34622 | 703 |
2054194 | 2054194 | 2021-12-27 | Clay | Florida | 12019 | 34622 | 703 |
2050944 | 2050944 | 2021-12-26 | Clay | Florida | 12019 | 34622 | 703 |
2047694 | 2047694 | 2021-12-25 | Clay | Florida | 12019 | 34622 | 703 |
2044444 | 2044444 | 2021-12-24 | Clay | Florida | 12019 | 34622 | 703 |
2041195 | 2041195 | 2021-12-23 | Clay | Florida | 12019 | 34315 | 703 |
2037945 | 2037945 | 2021-12-22 | Clay | Florida | 12019 | 34315 | 703 |
2034695 | 2034695 | 2021-12-21 | Clay | Florida | 12019 | 34315 | 703 |
2031445 | 2031445 | 2021-12-20 | Clay | Florida | 12019 | 34315 | 703 |
2028194 | 2028194 | 2021-12-19 | Clay | Florida | 12019 | 34315 | 703 |
2024943 | 2024943 | 2021-12-18 | Clay | Florida | 12019 | 34315 | 703 |
2021692 | 2021692 | 2021-12-17 | Clay | Florida | 12019 | 34315 | 703 |
2018441 | 2018441 | 2021-12-16 | Clay | Florida | 12019 | 34204 | 703 |
2015191 | 2015191 | 2021-12-15 | Clay | Florida | 12019 | 34204 | 703 |
2011940 | 2011940 | 2021-12-14 | Clay | Florida | 12019 | 34204 | 703 |
2008689 | 2008689 | 2021-12-13 | Clay | Florida | 12019 | 34204 | 704 |
2005438 | 2005438 | 2021-12-12 | Clay | Florida | 12019 | 34204 | 704 |
2002187 | 2002187 | 2021-12-11 | Clay | Florida | 12019 | 34204 | 704 |
1998937 | 1998937 | 2021-12-10 | Clay | Florida | 12019 | 34204 | 704 |
1995686 | 1995686 | 2021-12-09 | Clay | Florida | 12019 | 34113 | 704 |
1992435 | 1992435 | 2021-12-08 | Clay | Florida | 12019 | 34113 | 704 |
1989184 | 1989184 | 2021-12-07 | Clay | Florida | 12019 | 34113 | 701 |
1985934 | 1985934 | 2021-12-06 | Clay | Florida | 12019 | 34113 | 701 |
1982684 | 1982684 | 2021-12-05 | Clay | Florida | 12019 | 34113 | 701 |
1979434 | 1979434 | 2021-12-04 | Clay | Florida | 12019 | 34113 | 701 |
1976184 | 1976184 | 2021-12-03 | Clay | Florida | 12019 | 34113 | 701 |
1972935 | 1972935 | 2021-12-02 | Clay | Florida | 12019 | 34033 | 701 |
1969685 | 1969685 | 2021-12-01 | Clay | Florida | 12019 | 34033 | 701 |
1966435 | 1966435 | 2021-11-30 | Clay | Florida | 12019 | 34033 | 701 |
1963183 | 1963183 | 2021-11-29 | Clay | Florida | 12019 | 33974 | 701 |
1959932 | 1959932 | 2021-11-28 | Clay | Florida | 12019 | 33974 | 701 |
1956681 | 1956681 | 2021-11-27 | Clay | Florida | 12019 | 33974 | 701 |
1953430 | 1953430 | 2021-11-26 | Clay | Florida | 12019 | 33974 | 701 |
1950179 | 1950179 | 2021-11-25 | Clay | Florida | 12019 | 33974 | 701 |
1946928 | 1946928 | 2021-11-24 | Clay | Florida | 12019 | 33974 | 701 |
1943677 | 1943677 | 2021-11-23 | Clay | Florida | 12019 | 33974 | 701 |
1940427 | 1940427 | 2021-11-22 | Clay | Florida | 12019 | 33974 | 701 |
1937177 | 1937177 | 2021-11-21 | Clay | Florida | 12019 | 33974 | 701 |
1933927 | 1933927 | 2021-11-20 | Clay | Florida | 12019 | 33974 | 701 |
1930675 | 1930675 | 2021-11-19 | Clay | Florida | 12019 | 33974 | 701 |
1927425 | 1927425 | 2021-11-18 | Clay | Florida | 12019 | 33925 | 701 |
1924175 | 1924175 | 2021-11-17 | Clay | Florida | 12019 | 33925 | 701 |
1920926 | 1920926 | 2021-11-16 | Clay | Florida | 12019 | 33925 | 701 |
1917676 | 1917676 | 2021-11-15 | Clay | Florida | 12019 | 33925 | 701 |
1914426 | 1914426 | 2021-11-14 | Clay | Florida | 12019 | 33925 | 698 |
1911176 | 1911176 | 2021-11-13 | Clay | Florida | 12019 | 33925 | 698 |
1907927 | 1907927 | 2021-11-12 | Clay | Florida | 12019 | 33925 | 698 |
1904678 | 1904678 | 2021-11-11 | Clay | Florida | 12019 | 33858 | 698 |
1901428 | 1901428 | 2021-11-10 | Clay | Florida | 12019 | 33858 | 698 |
1898178 | 1898178 | 2021-11-09 | Clay | Florida | 12019 | 33858 | 698 |
1894928 | 1894928 | 2021-11-08 | Clay | Florida | 12019 | 33858 | 698 |
1891678 | 1891678 | 2021-11-07 | Clay | Florida | 12019 | 33858 | 694 |
1888428 | 1888428 | 2021-11-06 | Clay | Florida | 12019 | 33858 | 694 |
1885178 | 1885178 | 2021-11-05 | Clay | Florida | 12019 | 33858 | 694 |
1881929 | 1881929 | 2021-11-04 | Clay | Florida | 12019 | 33810 | 694 |
1878680 | 1878680 | 2021-11-03 | Clay | Florida | 12019 | 33810 | 694 |
1875431 | 1875431 | 2021-11-02 | Clay | Florida | 12019 | 33810 | 694 |
1872182 | 1872182 | 2021-11-01 | Clay | Florida | 12019 | 33810 | 694 |
1868933 | 1868933 | 2021-10-31 | Clay | Florida | 12019 | 33810 | 694 |
1865684 | 1865684 | 2021-10-30 | Clay | Florida | 12019 | 33810 | 691 |
1862435 | 1862435 | 2021-10-29 | Clay | Florida | 12019 | 33810 | 691 |
1859186 | 1859186 | 2021-10-28 | Clay | Florida | 12019 | 33738 | 691 |
1855937 | 1855937 | 2021-10-27 | Clay | Florida | 12019 | 33738 | 691 |
1852688 | 1852688 | 2021-10-26 | Clay | Florida | 12019 | 33738 | 691 |
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);