ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Kern" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174396 | 2174396 | 2022-02-02 | Kern | California | 6029 | 217169 | 2013 |
2171143 | 2171143 | 2022-02-01 | Kern | California | 6029 | 215929 | 2013 |
2167890 | 2167890 | 2022-01-31 | Kern | California | 6029 | 214959 | 2012 |
2164635 | 2164635 | 2022-01-30 | Kern | California | 6029 | 210736 | 2009 |
2161380 | 2161380 | 2022-01-29 | Kern | California | 6029 | 210736 | 2009 |
2158124 | 2158124 | 2022-01-28 | Kern | California | 6029 | 210736 | 2009 |
2154871 | 2154871 | 2022-01-27 | Kern | California | 6029 | 208859 | 2005 |
2151618 | 2151618 | 2022-01-26 | Kern | California | 6029 | 207114 | 1988 |
2148366 | 2148366 | 2022-01-25 | Kern | California | 6029 | 204686 | 1977 |
2145114 | 2145114 | 2022-01-24 | Kern | California | 6029 | 203066 | 1974 |
2141859 | 2141859 | 2022-01-23 | Kern | California | 6029 | 196125 | 1974 |
2138604 | 2138604 | 2022-01-22 | Kern | California | 6029 | 196125 | 1974 |
2135348 | 2135348 | 2022-01-21 | Kern | California | 6029 | 196125 | 1974 |
2132096 | 2132096 | 2022-01-20 | Kern | California | 6029 | 193774 | 1974 |
2128843 | 2128843 | 2022-01-19 | Kern | California | 6029 | 191741 | 1974 |
2125589 | 2125589 | 2022-01-18 | Kern | California | 6029 | 189849 | 1972 |
2122337 | 2122337 | 2022-01-17 | Kern | California | 6029 | 184362 | 1964 |
2119085 | 2119085 | 2022-01-16 | Kern | California | 6029 | 181112 | 1964 |
2115833 | 2115833 | 2022-01-15 | Kern | California | 6029 | 181112 | 1964 |
2112582 | 2112582 | 2022-01-14 | Kern | California | 6029 | 181112 | 1964 |
2109330 | 2109330 | 2022-01-13 | Kern | California | 6029 | 179110 | 1958 |
2106079 | 2106079 | 2022-01-12 | Kern | California | 6029 | 177220 | 1944 |
2102828 | 2102828 | 2022-01-11 | Kern | California | 6029 | 175585 | 1936 |
2099577 | 2099577 | 2022-01-10 | Kern | California | 6029 | 174442 | 1936 |
2096326 | 2096326 | 2022-01-09 | Kern | California | 6029 | 169213 | 1931 |
2093074 | 2093074 | 2022-01-08 | Kern | California | 6029 | 169213 | 1931 |
2089822 | 2089822 | 2022-01-07 | Kern | California | 6029 | 169213 | 1931 |
2086571 | 2086571 | 2022-01-06 | Kern | California | 6029 | 167686 | 1922 |
2083319 | 2083319 | 2022-01-05 | Kern | California | 6029 | 166790 | 1918 |
2080067 | 2080067 | 2022-01-04 | Kern | California | 6029 | 166183 | 1918 |
2076815 | 2076815 | 2022-01-03 | Kern | California | 6029 | 165859 | 1918 |
2073564 | 2073564 | 2022-01-02 | Kern | California | 6029 | 162767 | 1918 |
2070313 | 2070313 | 2022-01-01 | Kern | California | 6029 | 162767 | 1918 |
2067062 | 2067062 | 2021-12-31 | Kern | California | 6029 | 162767 | 1918 |
2063811 | 2063811 | 2021-12-30 | Kern | California | 6029 | 162767 | 1918 |
2060561 | 2060561 | 2021-12-29 | Kern | California | 6029 | 162767 | 1918 |
2057312 | 2057312 | 2021-12-28 | Kern | California | 6029 | 162767 | 1918 |
2054063 | 2054063 | 2021-12-27 | Kern | California | 6029 | 162767 | 1918 |
2050813 | 2050813 | 2021-12-26 | Kern | California | 6029 | 161987 | 1908 |
2047563 | 2047563 | 2021-12-25 | Kern | California | 6029 | 161987 | 1908 |
2044313 | 2044313 | 2021-12-24 | Kern | California | 6029 | 161987 | 1908 |
2041064 | 2041064 | 2021-12-23 | Kern | California | 6029 | 161987 | 1905 |
2037814 | 2037814 | 2021-12-22 | Kern | California | 6029 | 161987 | 1905 |
2034564 | 2034564 | 2021-12-21 | Kern | California | 6029 | 161760 | 1901 |
2031314 | 2031314 | 2021-12-20 | Kern | California | 6029 | 161540 | 1897 |
2028063 | 2028063 | 2021-12-19 | Kern | California | 6029 | 161083 | 1897 |
2024812 | 2024812 | 2021-12-18 | Kern | California | 6029 | 161083 | 1897 |
2021561 | 2021561 | 2021-12-17 | Kern | California | 6029 | 161083 | 1897 |
2018310 | 2018310 | 2021-12-16 | Kern | California | 6029 | 160825 | 1888 |
2015060 | 2015060 | 2021-12-15 | Kern | California | 6029 | 160699 | 1880 |
2011809 | 2011809 | 2021-12-14 | Kern | California | 6029 | 160477 | 1879 |
2008558 | 2008558 | 2021-12-13 | Kern | California | 6029 | 160199 | 1875 |
2005307 | 2005307 | 2021-12-12 | Kern | California | 6029 | 159721 | 1870 |
2002056 | 2002056 | 2021-12-11 | Kern | California | 6029 | 159721 | 1870 |
1998806 | 1998806 | 2021-12-10 | Kern | California | 6029 | 159721 | 1870 |
1995555 | 1995555 | 2021-12-09 | Kern | California | 6029 | 159493 | 1862 |
1992304 | 1992304 | 2021-12-08 | Kern | California | 6029 | 159336 | 1855 |
1989053 | 1989053 | 2021-12-07 | Kern | California | 6029 | 159023 | 1841 |
1985803 | 1985803 | 2021-12-06 | Kern | California | 6029 | 158834 | 1838 |
1982553 | 1982553 | 2021-12-05 | Kern | California | 6029 | 158270 | 1828 |
1979303 | 1979303 | 2021-12-04 | Kern | California | 6029 | 158270 | 1828 |
1976053 | 1976053 | 2021-12-03 | Kern | California | 6029 | 158270 | 1828 |
1972804 | 1972804 | 2021-12-02 | Kern | California | 6029 | 158009 | 1814 |
1969554 | 1969554 | 2021-12-01 | Kern | California | 6029 | 157875 | 1804 |
1966304 | 1966304 | 2021-11-30 | Kern | California | 6029 | 157662 | 1804 |
1963052 | 1963052 | 2021-11-29 | Kern | California | 6029 | 157525 | 1791 |
1959801 | 1959801 | 2021-11-28 | Kern | California | 6029 | 156517 | 1781 |
1956550 | 1956550 | 2021-11-27 | Kern | California | 6029 | 156517 | 1781 |
1953299 | 1953299 | 2021-11-26 | Kern | California | 6029 | 156517 | 1781 |
1950048 | 1950048 | 2021-11-25 | Kern | California | 6029 | 156517 | 1781 |
1946797 | 1946797 | 2021-11-24 | Kern | California | 6029 | 156517 | 1781 |
1943546 | 1943546 | 2021-11-23 | Kern | California | 6029 | 156264 | 1769 |
1940296 | 1940296 | 2021-11-22 | Kern | California | 6029 | 155990 | 1764 |
1937046 | 1937046 | 2021-11-21 | Kern | California | 6029 | 155451 | 1763 |
1933796 | 1933796 | 2021-11-20 | Kern | California | 6029 | 155451 | 1763 |
1930544 | 1930544 | 2021-11-19 | Kern | California | 6029 | 155451 | 1763 |
1927294 | 1927294 | 2021-11-18 | Kern | California | 6029 | 155118 | 1751 |
1924044 | 1924044 | 2021-11-17 | Kern | California | 6029 | 154896 | 1741 |
1920795 | 1920795 | 2021-11-16 | Kern | California | 6029 | 154583 | 1734 |
1917545 | 1917545 | 2021-11-15 | Kern | California | 6029 | 154185 | 1733 |
1914295 | 1914295 | 2021-11-14 | Kern | California | 6029 | 153681 | 1733 |
1911045 | 1911045 | 2021-11-13 | Kern | California | 6029 | 153681 | 1733 |
1907796 | 1907796 | 2021-11-12 | Kern | California | 6029 | 153681 | 1733 |
1904547 | 1904547 | 2021-11-11 | Kern | California | 6029 | 153048 | 1730 |
1901297 | 1901297 | 2021-11-10 | Kern | California | 6029 | 153048 | 1730 |
1898047 | 1898047 | 2021-11-09 | Kern | California | 6029 | 152732 | 1706 |
1894797 | 1894797 | 2021-11-08 | Kern | California | 6029 | 152418 | 1706 |
1891547 | 1891547 | 2021-11-07 | Kern | California | 6029 | 151432 | 1706 |
1888297 | 1888297 | 2021-11-06 | Kern | California | 6029 | 151432 | 1706 |
1885047 | 1885047 | 2021-11-05 | Kern | California | 6029 | 151432 | 1706 |
1881798 | 1881798 | 2021-11-04 | Kern | California | 6029 | 150971 | 1699 |
1878549 | 1878549 | 2021-11-03 | Kern | California | 6029 | 150632 | 1694 |
1875300 | 1875300 | 2021-11-02 | Kern | California | 6029 | 150230 | 1673 |
1872051 | 1872051 | 2021-11-01 | Kern | California | 6029 | 149959 | 1673 |
1868802 | 1868802 | 2021-10-31 | Kern | California | 6029 | 148990 | 1669 |
1865553 | 1865553 | 2021-10-30 | Kern | California | 6029 | 148990 | 1669 |
1862304 | 1862304 | 2021-10-29 | Kern | California | 6029 | 148990 | 1669 |
1859055 | 1859055 | 2021-10-28 | Kern | California | 6029 | 148507 | 1667 |
1855806 | 1855806 | 2021-10-27 | Kern | California | 6029 | 148261 | 1657 |
1852557 | 1852557 | 2021-10-26 | Kern | California | 6029 | 147784 | 1652 |
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);