ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Mendocino" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174404 | 2174404 | 2022-02-02 | Mendocino | California | 6045 | 14067 | 109 |
2171151 | 2171151 | 2022-02-01 | Mendocino | California | 6045 | 13985 | 109 |
2167898 | 2167898 | 2022-01-31 | Mendocino | California | 6045 | 13949 | 113 |
2164643 | 2164643 | 2022-01-30 | Mendocino | California | 6045 | 13680 | 113 |
2161388 | 2161388 | 2022-01-29 | Mendocino | California | 6045 | 13680 | 113 |
2158132 | 2158132 | 2022-01-28 | Mendocino | California | 6045 | 13680 | 113 |
2154879 | 2154879 | 2022-01-27 | Mendocino | California | 6045 | 13542 | 113 |
2151626 | 2151626 | 2022-01-26 | Mendocino | California | 6045 | 12828 | 109 |
2148374 | 2148374 | 2022-01-25 | Mendocino | California | 6045 | 12550 | 109 |
2145122 | 2145122 | 2022-01-24 | Mendocino | California | 6045 | 12437 | 109 |
2141867 | 2141867 | 2022-01-23 | Mendocino | California | 6045 | 11943 | 109 |
2138612 | 2138612 | 2022-01-22 | Mendocino | California | 6045 | 11943 | 109 |
2135356 | 2135356 | 2022-01-21 | Mendocino | California | 6045 | 11943 | 109 |
2132104 | 2132104 | 2022-01-20 | Mendocino | California | 6045 | 11800 | 109 |
2128851 | 2128851 | 2022-01-19 | Mendocino | California | 6045 | 11152 | 109 |
2125597 | 2125597 | 2022-01-18 | Mendocino | California | 6045 | 11068 | 109 |
2122345 | 2122345 | 2022-01-17 | Mendocino | California | 6045 | 11030 | 109 |
2119093 | 2119093 | 2022-01-16 | Mendocino | California | 6045 | 10572 | 109 |
2115841 | 2115841 | 2022-01-15 | Mendocino | California | 6045 | 10572 | 109 |
2112590 | 2112590 | 2022-01-14 | Mendocino | California | 6045 | 10572 | 109 |
2109338 | 2109338 | 2022-01-13 | Mendocino | California | 6045 | 10417 | 109 |
2106087 | 2106087 | 2022-01-12 | Mendocino | California | 6045 | 10061 | 109 |
2102836 | 2102836 | 2022-01-11 | Mendocino | California | 6045 | 9923 | 109 |
2099585 | 2099585 | 2022-01-10 | Mendocino | California | 6045 | 9857 | 106 |
2096334 | 2096334 | 2022-01-09 | Mendocino | California | 6045 | 9552 | 106 |
2093082 | 2093082 | 2022-01-08 | Mendocino | California | 6045 | 9552 | 106 |
2089830 | 2089830 | 2022-01-07 | Mendocino | California | 6045 | 9552 | 106 |
2086579 | 2086579 | 2022-01-06 | Mendocino | California | 6045 | 9385 | 105 |
2083327 | 2083327 | 2022-01-05 | Mendocino | California | 6045 | 9335 | 105 |
2080075 | 2080075 | 2022-01-04 | Mendocino | California | 6045 | 9272 | 105 |
2076823 | 2076823 | 2022-01-03 | Mendocino | California | 6045 | 9121 | 105 |
2073572 | 2073572 | 2022-01-02 | Mendocino | California | 6045 | 9121 | 105 |
2070321 | 2070321 | 2022-01-01 | Mendocino | California | 6045 | 9121 | 105 |
2067070 | 2067070 | 2021-12-31 | Mendocino | California | 6045 | 9121 | 105 |
2063819 | 2063819 | 2021-12-30 | Mendocino | California | 6045 | 9085 | 105 |
2060569 | 2060569 | 2021-12-29 | Mendocino | California | 6045 | 9062 | 105 |
2057320 | 2057320 | 2021-12-28 | Mendocino | California | 6045 | 9047 | 105 |
2054071 | 2054071 | 2021-12-27 | Mendocino | California | 6045 | 9010 | 105 |
2050821 | 2050821 | 2021-12-26 | Mendocino | California | 6045 | 9010 | 105 |
2047571 | 2047571 | 2021-12-25 | Mendocino | California | 6045 | 9010 | 105 |
2044321 | 2044321 | 2021-12-24 | Mendocino | California | 6045 | 9010 | 105 |
2041072 | 2041072 | 2021-12-23 | Mendocino | California | 6045 | 8995 | 105 |
2037822 | 2037822 | 2021-12-22 | Mendocino | California | 6045 | 8973 | 103 |
2034572 | 2034572 | 2021-12-21 | Mendocino | California | 6045 | 8955 | 103 |
2031322 | 2031322 | 2021-12-20 | Mendocino | California | 6045 | 8948 | 103 |
2028071 | 2028071 | 2021-12-19 | Mendocino | California | 6045 | 8910 | 103 |
2024820 | 2024820 | 2021-12-18 | Mendocino | California | 6045 | 8910 | 103 |
2021569 | 2021569 | 2021-12-17 | Mendocino | California | 6045 | 8910 | 103 |
2018318 | 2018318 | 2021-12-16 | Mendocino | California | 6045 | 8900 | 103 |
2015068 | 2015068 | 2021-12-15 | Mendocino | California | 6045 | 8893 | 103 |
2011817 | 2011817 | 2021-12-14 | Mendocino | California | 6045 | 8883 | 100 |
2008566 | 2008566 | 2021-12-13 | Mendocino | California | 6045 | 8877 | 100 |
2005315 | 2005315 | 2021-12-12 | Mendocino | California | 6045 | 8817 | 100 |
2002064 | 2002064 | 2021-12-11 | Mendocino | California | 6045 | 8817 | 100 |
1998814 | 1998814 | 2021-12-10 | Mendocino | California | 6045 | 8817 | 100 |
1995563 | 1995563 | 2021-12-09 | Mendocino | California | 6045 | 8805 | 99 |
1992312 | 1992312 | 2021-12-08 | Mendocino | California | 6045 | 8775 | 99 |
1989061 | 1989061 | 2021-12-07 | Mendocino | California | 6045 | 8747 | 99 |
1985811 | 1985811 | 2021-12-06 | Mendocino | California | 6045 | 8737 | 99 |
1982561 | 1982561 | 2021-12-05 | Mendocino | California | 6045 | 8649 | 99 |
1979311 | 1979311 | 2021-12-04 | Mendocino | California | 6045 | 8649 | 99 |
1976061 | 1976061 | 2021-12-03 | Mendocino | California | 6045 | 8649 | 99 |
1972812 | 1972812 | 2021-12-02 | Mendocino | California | 6045 | 8634 | 99 |
1969562 | 1969562 | 2021-12-01 | Mendocino | California | 6045 | 8577 | 99 |
1966312 | 1966312 | 2021-11-30 | Mendocino | California | 6045 | 8571 | 97 |
1963060 | 1963060 | 2021-11-29 | Mendocino | California | 6045 | 8560 | 97 |
1959809 | 1959809 | 2021-11-28 | Mendocino | California | 6045 | 8488 | 94 |
1956558 | 1956558 | 2021-11-27 | Mendocino | California | 6045 | 8488 | 94 |
1953307 | 1953307 | 2021-11-26 | Mendocino | California | 6045 | 8488 | 94 |
1950056 | 1950056 | 2021-11-25 | Mendocino | California | 6045 | 8488 | 94 |
1946805 | 1946805 | 2021-11-24 | Mendocino | California | 6045 | 8488 | 94 |
1943554 | 1943554 | 2021-11-23 | Mendocino | California | 6045 | 8476 | 94 |
1940304 | 1940304 | 2021-11-22 | Mendocino | California | 6045 | 8463 | 94 |
1937054 | 1937054 | 2021-11-21 | Mendocino | California | 6045 | 8390 | 94 |
1933804 | 1933804 | 2021-11-20 | Mendocino | California | 6045 | 8390 | 94 |
1930552 | 1930552 | 2021-11-19 | Mendocino | California | 6045 | 8390 | 94 |
1927302 | 1927302 | 2021-11-18 | Mendocino | California | 6045 | 8352 | 94 |
1924052 | 1924052 | 2021-11-17 | Mendocino | California | 6045 | 8312 | 94 |
1920803 | 1920803 | 2021-11-16 | Mendocino | California | 6045 | 8283 | 94 |
1917553 | 1917553 | 2021-11-15 | Mendocino | California | 6045 | 8273 | 94 |
1914303 | 1914303 | 2021-11-14 | Mendocino | California | 6045 | 8241 | 94 |
1911053 | 1911053 | 2021-11-13 | Mendocino | California | 6045 | 8241 | 94 |
1907804 | 1907804 | 2021-11-12 | Mendocino | California | 6045 | 8201 | 94 |
1904555 | 1904555 | 2021-11-11 | Mendocino | California | 6045 | 8201 | 94 |
1901305 | 1901305 | 2021-11-10 | Mendocino | California | 6045 | 8144 | 94 |
1898055 | 1898055 | 2021-11-09 | Mendocino | California | 6045 | 8127 | 92 |
1894805 | 1894805 | 2021-11-08 | Mendocino | California | 6045 | 8113 | 90 |
1891555 | 1891555 | 2021-11-07 | Mendocino | California | 6045 | 8032 | 90 |
1888305 | 1888305 | 2021-11-06 | Mendocino | California | 6045 | 8032 | 90 |
1885055 | 1885055 | 2021-11-05 | Mendocino | California | 6045 | 8032 | 90 |
1881806 | 1881806 | 2021-11-04 | Mendocino | California | 6045 | 8003 | 89 |
1878557 | 1878557 | 2021-11-03 | Mendocino | California | 6045 | 7933 | 89 |
1875308 | 1875308 | 2021-11-02 | Mendocino | California | 6045 | 7908 | 89 |
1872059 | 1872059 | 2021-11-01 | Mendocino | California | 6045 | 7889 | 88 |
1868810 | 1868810 | 2021-10-31 | Mendocino | California | 6045 | 7824 | 88 |
1865561 | 1865561 | 2021-10-30 | Mendocino | California | 6045 | 7824 | 88 |
1862312 | 1862312 | 2021-10-29 | Mendocino | California | 6045 | 7824 | 88 |
1859063 | 1859063 | 2021-10-28 | Mendocino | California | 6045 | 7807 | 88 |
1855814 | 1855814 | 2021-10-27 | Mendocino | California | 6045 | 7755 | 88 |
1852565 | 1852565 | 2021-10-26 | Mendocino | California | 6045 | 7743 | 88 |
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);