ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
721 rows where fips = 6035 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174399 | 2174399 | 2022-02-02 | Lassen | California | 6035 | 9823 | 62 |
2171146 | 2171146 | 2022-02-01 | Lassen | California | 6035 | 9801 | 62 |
2167893 | 2167893 | 2022-01-31 | Lassen | California | 6035 | 9710 | 61 |
2164638 | 2164638 | 2022-01-30 | Lassen | California | 6035 | 9664 | 61 |
2161383 | 2161383 | 2022-01-29 | Lassen | California | 6035 | 9664 | 61 |
2158127 | 2158127 | 2022-01-28 | Lassen | California | 6035 | 9664 | 61 |
2154874 | 2154874 | 2022-01-27 | Lassen | California | 6035 | 9558 | 61 |
2151621 | 2151621 | 2022-01-26 | Lassen | California | 6035 | 9531 | 61 |
2148369 | 2148369 | 2022-01-25 | Lassen | California | 6035 | 9327 | 61 |
2145117 | 2145117 | 2022-01-24 | Lassen | California | 6035 | 9085 | 61 |
2141862 | 2141862 | 2022-01-23 | Lassen | California | 6035 | 9085 | 61 |
2138607 | 2138607 | 2022-01-22 | Lassen | California | 6035 | 9085 | 61 |
2135351 | 2135351 | 2022-01-21 | Lassen | California | 6035 | 9085 | 61 |
2132099 | 2132099 | 2022-01-20 | Lassen | California | 6035 | 8876 | 61 |
2128846 | 2128846 | 2022-01-19 | Lassen | California | 6035 | 8876 | 61 |
2125592 | 2125592 | 2022-01-18 | Lassen | California | 6035 | 8687 | 61 |
2122340 | 2122340 | 2022-01-17 | Lassen | California | 6035 | 8606 | 61 |
2119088 | 2119088 | 2022-01-16 | Lassen | California | 6035 | 8606 | 61 |
2115836 | 2115836 | 2022-01-15 | Lassen | California | 6035 | 8606 | 61 |
2112585 | 2112585 | 2022-01-14 | Lassen | California | 6035 | 8606 | 61 |
2109333 | 2109333 | 2022-01-13 | Lassen | California | 6035 | 8535 | 61 |
2106082 | 2106082 | 2022-01-12 | Lassen | California | 6035 | 8281 | 61 |
2102831 | 2102831 | 2022-01-11 | Lassen | California | 6035 | 8244 | 61 |
2099580 | 2099580 | 2022-01-10 | Lassen | California | 6035 | 8191 | 61 |
2096329 | 2096329 | 2022-01-09 | Lassen | California | 6035 | 8191 | 61 |
2093077 | 2093077 | 2022-01-08 | Lassen | California | 6035 | 8191 | 61 |
2089825 | 2089825 | 2022-01-07 | Lassen | California | 6035 | 8159 | 61 |
2086574 | 2086574 | 2022-01-06 | Lassen | California | 6035 | 8127 | 61 |
2083322 | 2083322 | 2022-01-05 | Lassen | California | 6035 | 8114 | 61 |
2080070 | 2080070 | 2022-01-04 | Lassen | California | 6035 | 8110 | 61 |
2076818 | 2076818 | 2022-01-03 | Lassen | California | 6035 | 8090 | 61 |
2073567 | 2073567 | 2022-01-02 | Lassen | California | 6035 | 8090 | 61 |
2070316 | 2070316 | 2022-01-01 | Lassen | California | 6035 | 8090 | 61 |
2067065 | 2067065 | 2021-12-31 | Lassen | California | 6035 | 8090 | 61 |
2063814 | 2063814 | 2021-12-30 | Lassen | California | 6035 | 8083 | 61 |
2060564 | 2060564 | 2021-12-29 | Lassen | California | 6035 | 8061 | 61 |
2057315 | 2057315 | 2021-12-28 | Lassen | California | 6035 | 8061 | 61 |
2054066 | 2054066 | 2021-12-27 | Lassen | California | 6035 | 8061 | 61 |
2050816 | 2050816 | 2021-12-26 | Lassen | California | 6035 | 8061 | 61 |
2047566 | 2047566 | 2021-12-25 | Lassen | California | 6035 | 8061 | 61 |
2044316 | 2044316 | 2021-12-24 | Lassen | California | 6035 | 8061 | 61 |
2041067 | 2041067 | 2021-12-23 | Lassen | California | 6035 | 8055 | 61 |
2037817 | 2037817 | 2021-12-22 | Lassen | California | 6035 | 8055 | 61 |
2034567 | 2034567 | 2021-12-21 | Lassen | California | 6035 | 8055 | 61 |
2031317 | 2031317 | 2021-12-20 | Lassen | California | 6035 | 8044 | 61 |
2028066 | 2028066 | 2021-12-19 | Lassen | California | 6035 | 8043 | 61 |
2024815 | 2024815 | 2021-12-18 | Lassen | California | 6035 | 8043 | 61 |
2021564 | 2021564 | 2021-12-17 | Lassen | California | 6035 | 8043 | 61 |
2018313 | 2018313 | 2021-12-16 | Lassen | California | 6035 | 8039 | 61 |
2015063 | 2015063 | 2021-12-15 | Lassen | California | 6035 | 8039 | 61 |
2011812 | 2011812 | 2021-12-14 | Lassen | California | 6035 | 8039 | 61 |
2008561 | 2008561 | 2021-12-13 | Lassen | California | 6035 | 8029 | 61 |
2005310 | 2005310 | 2021-12-12 | Lassen | California | 6035 | 8029 | 61 |
2002059 | 2002059 | 2021-12-11 | Lassen | California | 6035 | 8029 | 61 |
1998809 | 1998809 | 2021-12-10 | Lassen | California | 6035 | 8019 | 61 |
1995558 | 1995558 | 2021-12-09 | Lassen | California | 6035 | 8019 | 61 |
1992307 | 1992307 | 2021-12-08 | Lassen | California | 6035 | 8012 | 61 |
1989056 | 1989056 | 2021-12-07 | Lassen | California | 6035 | 8012 | 61 |
1985806 | 1985806 | 2021-12-06 | Lassen | California | 6035 | 7987 | 58 |
1982556 | 1982556 | 2021-12-05 | Lassen | California | 6035 | 7987 | 58 |
1979306 | 1979306 | 2021-12-04 | Lassen | California | 6035 | 7987 | 58 |
1976056 | 1976056 | 2021-12-03 | Lassen | California | 6035 | 7987 | 58 |
1972807 | 1972807 | 2021-12-02 | Lassen | California | 6035 | 7976 | 58 |
1969557 | 1969557 | 2021-12-01 | Lassen | California | 6035 | 7967 | 58 |
1966307 | 1966307 | 2021-11-30 | Lassen | California | 6035 | 7962 | 58 |
1963055 | 1963055 | 2021-11-29 | Lassen | California | 6035 | 7923 | 57 |
1959804 | 1959804 | 2021-11-28 | Lassen | California | 6035 | 7923 | 57 |
1956553 | 1956553 | 2021-11-27 | Lassen | California | 6035 | 7923 | 57 |
1953302 | 1953302 | 2021-11-26 | Lassen | California | 6035 | 7923 | 57 |
1950051 | 1950051 | 2021-11-25 | Lassen | California | 6035 | 7923 | 57 |
1946800 | 1946800 | 2021-11-24 | Lassen | California | 6035 | 7923 | 57 |
1943549 | 1943549 | 2021-11-23 | Lassen | California | 6035 | 7912 | 54 |
1940299 | 1940299 | 2021-11-22 | Lassen | California | 6035 | 7908 | 54 |
1937049 | 1937049 | 2021-11-21 | Lassen | California | 6035 | 7894 | 54 |
1933799 | 1933799 | 2021-11-20 | Lassen | California | 6035 | 7894 | 54 |
1930547 | 1930547 | 2021-11-19 | Lassen | California | 6035 | 7883 | 54 |
1927297 | 1927297 | 2021-11-18 | Lassen | California | 6035 | 7883 | 54 |
1924047 | 1924047 | 2021-11-17 | Lassen | California | 6035 | 7875 | 54 |
1920798 | 1920798 | 2021-11-16 | Lassen | California | 6035 | 7862 | 54 |
1917548 | 1917548 | 2021-11-15 | Lassen | California | 6035 | 7857 | 54 |
1914298 | 1914298 | 2021-11-14 | Lassen | California | 6035 | 7843 | 54 |
1911048 | 1911048 | 2021-11-13 | Lassen | California | 6035 | 7843 | 54 |
1907799 | 1907799 | 2021-11-12 | Lassen | California | 6035 | 7843 | 54 |
1904550 | 1904550 | 2021-11-11 | Lassen | California | 6035 | 7843 | 54 |
1901300 | 1901300 | 2021-11-10 | Lassen | California | 6035 | 7821 | 53 |
1898050 | 1898050 | 2021-11-09 | Lassen | California | 6035 | 7812 | 53 |
1894800 | 1894800 | 2021-11-08 | Lassen | California | 6035 | 7748 | 52 |
1891550 | 1891550 | 2021-11-07 | Lassen | California | 6035 | 7748 | 52 |
1888300 | 1888300 | 2021-11-06 | Lassen | California | 6035 | 7748 | 52 |
1885050 | 1885050 | 2021-11-05 | Lassen | California | 6035 | 7748 | 52 |
1881801 | 1881801 | 2021-11-04 | Lassen | California | 6035 | 7732 | 52 |
1878552 | 1878552 | 2021-11-03 | Lassen | California | 6035 | 7716 | 52 |
1875303 | 1875303 | 2021-11-02 | Lassen | California | 6035 | 7712 | 52 |
1872054 | 1872054 | 2021-11-01 | Lassen | California | 6035 | 7671 | 51 |
1868805 | 1868805 | 2021-10-31 | Lassen | California | 6035 | 7671 | 51 |
1865556 | 1865556 | 2021-10-30 | Lassen | California | 6035 | 7671 | 51 |
1862307 | 1862307 | 2021-10-29 | Lassen | California | 6035 | 7671 | 51 |
1859058 | 1859058 | 2021-10-28 | Lassen | California | 6035 | 7650 | 51 |
1855809 | 1855809 | 2021-10-27 | Lassen | California | 6035 | 7634 | 51 |
1852560 | 1852560 | 2021-10-26 | Lassen | California | 6035 | 7543 | 50 |
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);