ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Ashland" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177353 | 2177353 | 2022-02-02 | Ashland | Wisconsin | 55003 | 3052 | 30 |
2174100 | 2174100 | 2022-02-01 | Ashland | Wisconsin | 55003 | 3035 | 30 |
2170848 | 2170848 | 2022-01-31 | Ashland | Wisconsin | 55003 | 3029 | 30 |
2167595 | 2167595 | 2022-01-30 | Ashland | Wisconsin | 55003 | 2978 | 30 |
2164340 | 2164340 | 2022-01-29 | Ashland | Wisconsin | 55003 | 2978 | 30 |
2161085 | 2161085 | 2022-01-28 | Ashland | Wisconsin | 55003 | 2978 | 30 |
2157829 | 2157829 | 2022-01-27 | Ashland | Wisconsin | 55003 | 2952 | 29 |
2154576 | 2154576 | 2022-01-26 | Ashland | Wisconsin | 55003 | 2932 | 29 |
2151323 | 2151323 | 2022-01-25 | Ashland | Wisconsin | 55003 | 2903 | 29 |
2148071 | 2148071 | 2022-01-24 | Ashland | Wisconsin | 55003 | 2884 | 29 |
2144819 | 2144819 | 2022-01-23 | Ashland | Wisconsin | 55003 | 2820 | 29 |
2141564 | 2141564 | 2022-01-22 | Ashland | Wisconsin | 55003 | 2820 | 29 |
2138308 | 2138308 | 2022-01-21 | Ashland | Wisconsin | 55003 | 2820 | 29 |
2135053 | 2135053 | 2022-01-20 | Ashland | Wisconsin | 55003 | 2779 | 28 |
2131801 | 2131801 | 2022-01-19 | Ashland | Wisconsin | 55003 | 2751 | 28 |
2128547 | 2128547 | 2022-01-18 | Ashland | Wisconsin | 55003 | 2720 | 28 |
2125294 | 2125294 | 2022-01-17 | Ashland | Wisconsin | 55003 | 2699 | 28 |
2122042 | 2122042 | 2022-01-16 | Ashland | Wisconsin | 55003 | 2648 | 28 |
2118790 | 2118790 | 2022-01-15 | Ashland | Wisconsin | 55003 | 2648 | 28 |
2115538 | 2115538 | 2022-01-14 | Ashland | Wisconsin | 55003 | 2648 | 28 |
2112286 | 2112286 | 2022-01-13 | Ashland | Wisconsin | 55003 | 2610 | 28 |
2109034 | 2109034 | 2022-01-12 | Ashland | Wisconsin | 55003 | 2584 | 28 |
2105783 | 2105783 | 2022-01-11 | Ashland | Wisconsin | 55003 | 2553 | 28 |
2102532 | 2102532 | 2022-01-10 | Ashland | Wisconsin | 55003 | 2520 | 28 |
2099281 | 2099281 | 2022-01-09 | Ashland | Wisconsin | 55003 | 2497 | 28 |
2096030 | 2096030 | 2022-01-08 | Ashland | Wisconsin | 55003 | 2497 | 28 |
2092778 | 2092778 | 2022-01-07 | Ashland | Wisconsin | 55003 | 2497 | 28 |
2089526 | 2089526 | 2022-01-06 | Ashland | Wisconsin | 55003 | 2471 | 28 |
2086275 | 2086275 | 2022-01-05 | Ashland | Wisconsin | 55003 | 2464 | 28 |
2083023 | 2083023 | 2022-01-04 | Ashland | Wisconsin | 55003 | 2424 | 27 |
2079771 | 2079771 | 2022-01-03 | Ashland | Wisconsin | 55003 | 2416 | 27 |
2076519 | 2076519 | 2022-01-02 | Ashland | Wisconsin | 55003 | 2412 | 26 |
2073268 | 2073268 | 2022-01-01 | Ashland | Wisconsin | 55003 | 2412 | 26 |
2070017 | 2070017 | 2021-12-31 | Ashland | Wisconsin | 55003 | 2412 | 26 |
2066766 | 2066766 | 2021-12-30 | Ashland | Wisconsin | 55003 | 2408 | 25 |
2063516 | 2063516 | 2021-12-29 | Ashland | Wisconsin | 55003 | 2399 | 24 |
2060266 | 2060266 | 2021-12-28 | Ashland | Wisconsin | 55003 | 2397 | 24 |
2057017 | 2057017 | 2021-12-27 | Ashland | Wisconsin | 55003 | 2381 | 24 |
2053768 | 2053768 | 2021-12-26 | Ashland | Wisconsin | 55003 | 2381 | 24 |
2050518 | 2050518 | 2021-12-25 | Ashland | Wisconsin | 55003 | 2381 | 24 |
2047268 | 2047268 | 2021-12-24 | Ashland | Wisconsin | 55003 | 2381 | 24 |
2044018 | 2044018 | 2021-12-23 | Ashland | Wisconsin | 55003 | 2378 | 24 |
2040769 | 2040769 | 2021-12-22 | Ashland | Wisconsin | 55003 | 2373 | 24 |
2037519 | 2037519 | 2021-12-21 | Ashland | Wisconsin | 55003 | 2364 | 24 |
2034269 | 2034269 | 2021-12-20 | Ashland | Wisconsin | 55003 | 2349 | 23 |
2031019 | 2031019 | 2021-12-19 | Ashland | Wisconsin | 55003 | 2342 | 23 |
2027768 | 2027768 | 2021-12-18 | Ashland | Wisconsin | 55003 | 2342 | 23 |
2024517 | 2024517 | 2021-12-17 | Ashland | Wisconsin | 55003 | 2342 | 23 |
2021266 | 2021266 | 2021-12-16 | Ashland | Wisconsin | 55003 | 2336 | 23 |
2018015 | 2018015 | 2021-12-15 | Ashland | Wisconsin | 55003 | 2335 | 23 |
2014765 | 2014765 | 2021-12-14 | Ashland | Wisconsin | 55003 | 2311 | 23 |
2011514 | 2011514 | 2021-12-13 | Ashland | Wisconsin | 55003 | 2302 | 23 |
2008263 | 2008263 | 2021-12-12 | Ashland | Wisconsin | 55003 | 2290 | 23 |
2005012 | 2005012 | 2021-12-11 | Ashland | Wisconsin | 55003 | 2290 | 23 |
2001761 | 2001761 | 2021-12-10 | Ashland | Wisconsin | 55003 | 2290 | 23 |
1998511 | 1998511 | 2021-12-09 | Ashland | Wisconsin | 55003 | 2267 | 23 |
1995260 | 1995260 | 2021-12-08 | Ashland | Wisconsin | 55003 | 2242 | 23 |
1992009 | 1992009 | 2021-12-07 | Ashland | Wisconsin | 55003 | 2198 | 23 |
1988758 | 1988758 | 2021-12-06 | Ashland | Wisconsin | 55003 | 2198 | 23 |
1985508 | 1985508 | 2021-12-05 | Ashland | Wisconsin | 55003 | 2198 | 23 |
1982258 | 1982258 | 2021-12-04 | Ashland | Wisconsin | 55003 | 2198 | 23 |
1979008 | 1979008 | 2021-12-03 | Ashland | Wisconsin | 55003 | 2198 | 23 |
1975758 | 1975758 | 2021-12-02 | Ashland | Wisconsin | 55003 | 2142 | 22 |
1972509 | 1972509 | 2021-12-01 | Ashland | Wisconsin | 55003 | 2125 | 22 |
1969259 | 1969259 | 2021-11-30 | Ashland | Wisconsin | 55003 | 2097 | 22 |
1966009 | 1966009 | 2021-11-29 | Ashland | Wisconsin | 55003 | 2091 | 22 |
1962757 | 1962757 | 2021-11-28 | Ashland | Wisconsin | 55003 | 2073 | 21 |
1959506 | 1959506 | 2021-11-27 | Ashland | Wisconsin | 55003 | 2073 | 21 |
1956255 | 1956255 | 2021-11-26 | Ashland | Wisconsin | 55003 | 2073 | 21 |
1953004 | 1953004 | 2021-11-25 | Ashland | Wisconsin | 55003 | 2073 | 21 |
1949753 | 1949753 | 2021-11-24 | Ashland | Wisconsin | 55003 | 2067 | 21 |
1946502 | 1946502 | 2021-11-23 | Ashland | Wisconsin | 55003 | 2056 | 21 |
1943251 | 1943251 | 2021-11-22 | Ashland | Wisconsin | 55003 | 2040 | 21 |
1940001 | 1940001 | 2021-11-21 | Ashland | Wisconsin | 55003 | 2003 | 19 |
1936751 | 1936751 | 2021-11-20 | Ashland | Wisconsin | 55003 | 2003 | 19 |
1933501 | 1933501 | 2021-11-19 | Ashland | Wisconsin | 55003 | 2003 | 19 |
1930249 | 1930249 | 2021-11-18 | Ashland | Wisconsin | 55003 | 1989 | 19 |
1926999 | 1926999 | 2021-11-17 | Ashland | Wisconsin | 55003 | 1980 | 19 |
1923749 | 1923749 | 2021-11-16 | Ashland | Wisconsin | 55003 | 1974 | 19 |
1920500 | 1920500 | 2021-11-15 | Ashland | Wisconsin | 55003 | 1951 | 19 |
1917250 | 1917250 | 2021-11-14 | Ashland | Wisconsin | 55003 | 1938 | 18 |
1914000 | 1914000 | 2021-11-13 | Ashland | Wisconsin | 55003 | 1938 | 18 |
1910750 | 1910750 | 2021-11-12 | Ashland | Wisconsin | 55003 | 1938 | 18 |
1907501 | 1907501 | 2021-11-11 | Ashland | Wisconsin | 55003 | 1931 | 18 |
1904252 | 1904252 | 2021-11-10 | Ashland | Wisconsin | 55003 | 1928 | 18 |
1901002 | 1901002 | 2021-11-09 | Ashland | Wisconsin | 55003 | 1922 | 17 |
1897752 | 1897752 | 2021-11-08 | Ashland | Wisconsin | 55003 | 1911 | 17 |
1894502 | 1894502 | 2021-11-07 | Ashland | Wisconsin | 55003 | 1903 | 17 |
1891252 | 1891252 | 2021-11-06 | Ashland | Wisconsin | 55003 | 1903 | 17 |
1888002 | 1888002 | 2021-11-05 | Ashland | Wisconsin | 55003 | 1903 | 17 |
1884752 | 1884752 | 2021-11-04 | Ashland | Wisconsin | 55003 | 1901 | 17 |
1881503 | 1881503 | 2021-11-03 | Ashland | Wisconsin | 55003 | 1886 | 17 |
1878254 | 1878254 | 2021-11-02 | Ashland | Wisconsin | 55003 | 1873 | 17 |
1875005 | 1875005 | 2021-11-01 | Ashland | Wisconsin | 55003 | 1865 | 17 |
1871756 | 1871756 | 2021-10-31 | Ashland | Wisconsin | 55003 | 1853 | 17 |
1868507 | 1868507 | 2021-10-30 | Ashland | Wisconsin | 55003 | 1853 | 17 |
1865258 | 1865258 | 2021-10-29 | Ashland | Wisconsin | 55003 | 1853 | 17 |
1862009 | 1862009 | 2021-10-28 | Ashland | Wisconsin | 55003 | 1849 | 17 |
1858760 | 1858760 | 2021-10-27 | Ashland | Wisconsin | 55003 | 1843 | 17 |
1855511 | 1855511 | 2021-10-26 | Ashland | Wisconsin | 55003 | 1836 | 16 |
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);