ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 6063 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174413 | 2174413 | 2022-02-02 | Plumas | California | 6063 | 2792 | 12 |
2171160 | 2171160 | 2022-02-01 | Plumas | California | 6063 | 2779 | 12 |
2167907 | 2167907 | 2022-01-31 | Plumas | California | 6063 | 2776 | 12 |
2164652 | 2164652 | 2022-01-30 | Plumas | California | 6063 | 2729 | 12 |
2161397 | 2161397 | 2022-01-29 | Plumas | California | 6063 | 2729 | 12 |
2158141 | 2158141 | 2022-01-28 | Plumas | California | 6063 | 2729 | 12 |
2154888 | 2154888 | 2022-01-27 | Plumas | California | 6063 | 2691 | 12 |
2151635 | 2151635 | 2022-01-26 | Plumas | California | 6063 | 2557 | 12 |
2148383 | 2148383 | 2022-01-25 | Plumas | California | 6063 | 2530 | 12 |
2145131 | 2145131 | 2022-01-24 | Plumas | California | 6063 | 2528 | 12 |
2141876 | 2141876 | 2022-01-23 | Plumas | California | 6063 | 2449 | 12 |
2138621 | 2138621 | 2022-01-22 | Plumas | California | 6063 | 2449 | 12 |
2135365 | 2135365 | 2022-01-21 | Plumas | California | 6063 | 2449 | 12 |
2132113 | 2132113 | 2022-01-20 | Plumas | California | 6063 | 2399 | 12 |
2128860 | 2128860 | 2022-01-19 | Plumas | California | 6063 | 2315 | 12 |
2125606 | 2125606 | 2022-01-18 | Plumas | California | 6063 | 2302 | 12 |
2122354 | 2122354 | 2022-01-17 | Plumas | California | 6063 | 2301 | 12 |
2119102 | 2119102 | 2022-01-16 | Plumas | California | 6063 | 2255 | 12 |
2115850 | 2115850 | 2022-01-15 | Plumas | California | 6063 | 2255 | 12 |
2112599 | 2112599 | 2022-01-14 | Plumas | California | 6063 | 2255 | 12 |
2109347 | 2109347 | 2022-01-13 | Plumas | California | 6063 | 2232 | 12 |
2106096 | 2106096 | 2022-01-12 | Plumas | California | 6063 | 2168 | 12 |
2102845 | 2102845 | 2022-01-11 | Plumas | California | 6063 | 2155 | 12 |
2099594 | 2099594 | 2022-01-10 | Plumas | California | 6063 | 2150 | 12 |
2096343 | 2096343 | 2022-01-09 | Plumas | California | 6063 | 2122 | 12 |
2093091 | 2093091 | 2022-01-08 | Plumas | California | 6063 | 2122 | 12 |
2089839 | 2089839 | 2022-01-07 | Plumas | California | 6063 | 2122 | 12 |
2086588 | 2086588 | 2022-01-06 | Plumas | California | 6063 | 2089 | 12 |
2083336 | 2083336 | 2022-01-05 | Plumas | California | 6063 | 2074 | 12 |
2080084 | 2080084 | 2022-01-04 | Plumas | California | 6063 | 2065 | 12 |
2076832 | 2076832 | 2022-01-03 | Plumas | California | 6063 | 2054 | 12 |
2073581 | 2073581 | 2022-01-02 | Plumas | California | 6063 | 2054 | 12 |
2070330 | 2070330 | 2022-01-01 | Plumas | California | 6063 | 2054 | 12 |
2067079 | 2067079 | 2021-12-31 | Plumas | California | 6063 | 2054 | 12 |
2063828 | 2063828 | 2021-12-30 | Plumas | California | 6063 | 2050 | 12 |
2060578 | 2060578 | 2021-12-29 | Plumas | California | 6063 | 2049 | 12 |
2057329 | 2057329 | 2021-12-28 | Plumas | California | 6063 | 2048 | 12 |
2054080 | 2054080 | 2021-12-27 | Plumas | California | 6063 | 2047 | 12 |
2050830 | 2050830 | 2021-12-26 | Plumas | California | 6063 | 2047 | 13 |
2047580 | 2047580 | 2021-12-25 | Plumas | California | 6063 | 2047 | 13 |
2044330 | 2044330 | 2021-12-24 | Plumas | California | 6063 | 2047 | 13 |
2041081 | 2041081 | 2021-12-23 | Plumas | California | 6063 | 2046 | 13 |
2037831 | 2037831 | 2021-12-22 | Plumas | California | 6063 | 2034 | 13 |
2034581 | 2034581 | 2021-12-21 | Plumas | California | 6063 | 2030 | 13 |
2031331 | 2031331 | 2021-12-20 | Plumas | California | 6063 | 2030 | 12 |
2028080 | 2028080 | 2021-12-19 | Plumas | California | 6063 | 2023 | 13 |
2024829 | 2024829 | 2021-12-18 | Plumas | California | 6063 | 2023 | 13 |
2021578 | 2021578 | 2021-12-17 | Plumas | California | 6063 | 2023 | 13 |
2018327 | 2018327 | 2021-12-16 | Plumas | California | 6063 | 2016 | 12 |
2015077 | 2015077 | 2021-12-15 | Plumas | California | 6063 | 2006 | 12 |
2011826 | 2011826 | 2021-12-14 | Plumas | California | 6063 | 1999 | 12 |
2008575 | 2008575 | 2021-12-13 | Plumas | California | 6063 | 1998 | 12 |
2005324 | 2005324 | 2021-12-12 | Plumas | California | 6063 | 1990 | 12 |
2002073 | 2002073 | 2021-12-11 | Plumas | California | 6063 | 1990 | 12 |
1998823 | 1998823 | 2021-12-10 | Plumas | California | 6063 | 1990 | 12 |
1995572 | 1995572 | 2021-12-09 | Plumas | California | 6063 | 1980 | 12 |
1992321 | 1992321 | 2021-12-08 | Plumas | California | 6063 | 1969 | 12 |
1989070 | 1989070 | 2021-12-07 | Plumas | California | 6063 | 1967 | 10 |
1985820 | 1985820 | 2021-12-06 | Plumas | California | 6063 | 1967 | 9 |
1982570 | 1982570 | 2021-12-05 | Plumas | California | 6063 | 1957 | 7 |
1979320 | 1979320 | 2021-12-04 | Plumas | California | 6063 | 1957 | 7 |
1976070 | 1976070 | 2021-12-03 | Plumas | California | 6063 | 1957 | 7 |
1972821 | 1972821 | 2021-12-02 | Plumas | California | 6063 | 1947 | 7 |
1969571 | 1969571 | 2021-12-01 | Plumas | California | 6063 | 1939 | 7 |
1966321 | 1966321 | 2021-11-30 | Plumas | California | 6063 | 1936 | 7 |
1963069 | 1963069 | 2021-11-29 | Plumas | California | 6063 | 1936 | 7 |
1959818 | 1959818 | 2021-11-28 | Plumas | California | 6063 | 1912 | 7 |
1956567 | 1956567 | 2021-11-27 | Plumas | California | 6063 | 1912 | 7 |
1953316 | 1953316 | 2021-11-26 | Plumas | California | 6063 | 1912 | 7 |
1950065 | 1950065 | 2021-11-25 | Plumas | California | 6063 | 1912 | 7 |
1946814 | 1946814 | 2021-11-24 | Plumas | California | 6063 | 1912 | 7 |
1943563 | 1943563 | 2021-11-23 | Plumas | California | 6063 | 1910 | 7 |
1940313 | 1940313 | 2021-11-22 | Plumas | California | 6063 | 1910 | 7 |
1937063 | 1937063 | 2021-11-21 | Plumas | California | 6063 | 1893 | 7 |
1933813 | 1933813 | 2021-11-20 | Plumas | California | 6063 | 1893 | 7 |
1930561 | 1930561 | 2021-11-19 | Plumas | California | 6063 | 1893 | 8 |
1927311 | 1927311 | 2021-11-18 | Plumas | California | 6063 | 1885 | 8 |
1924061 | 1924061 | 2021-11-17 | Plumas | California | 6063 | 1881 | 8 |
1920812 | 1920812 | 2021-11-16 | Plumas | California | 6063 | 1878 | 8 |
1917562 | 1917562 | 2021-11-15 | Plumas | California | 6063 | 1878 | 8 |
1914312 | 1914312 | 2021-11-14 | Plumas | California | 6063 | 1877 | 8 |
1911062 | 1911062 | 2021-11-13 | Plumas | California | 6063 | 1877 | 8 |
1907813 | 1907813 | 2021-11-12 | Plumas | California | 6063 | 1863 | 7 |
1904564 | 1904564 | 2021-11-11 | Plumas | California | 6063 | 1863 | 7 |
1901314 | 1901314 | 2021-11-10 | Plumas | California | 6063 | 1843 | 7 |
1898064 | 1898064 | 2021-11-09 | Plumas | California | 6063 | 1829 | 7 |
1894814 | 1894814 | 2021-11-08 | Plumas | California | 6063 | 1828 | 7 |
1891564 | 1891564 | 2021-11-07 | Plumas | California | 6063 | 1796 | 7 |
1888314 | 1888314 | 2021-11-06 | Plumas | California | 6063 | 1796 | 7 |
1885064 | 1885064 | 2021-11-05 | Plumas | California | 6063 | 1796 | 7 |
1881815 | 1881815 | 2021-11-04 | Plumas | California | 6063 | 1780 | 7 |
1878566 | 1878566 | 2021-11-03 | Plumas | California | 6063 | 1760 | 7 |
1875317 | 1875317 | 2021-11-02 | Plumas | California | 6063 | 1758 | 7 |
1872068 | 1872068 | 2021-11-01 | Plumas | California | 6063 | 1755 | 7 |
1868819 | 1868819 | 2021-10-31 | Plumas | California | 6063 | 1734 | 7 |
1865570 | 1865570 | 2021-10-30 | Plumas | California | 6063 | 1734 | 7 |
1862321 | 1862321 | 2021-10-29 | Plumas | California | 6063 | 1734 | 7 |
1859072 | 1859072 | 2021-10-28 | Plumas | California | 6063 | 1725 | 7 |
1855823 | 1855823 | 2021-10-27 | Plumas | California | 6063 | 1682 | 7 |
1852574 | 1852574 | 2021-10-26 | Plumas | California | 6063 | 1678 | 7 |
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);