ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55021 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112295 | 2112295 | 2022-01-13 | Columbia | Wisconsin | 55021 | 11976 | 106 |
2109043 | 2109043 | 2022-01-12 | Columbia | Wisconsin | 55021 | 11704 | 105 |
2105792 | 2105792 | 2022-01-11 | Columbia | Wisconsin | 55021 | 11477 | 105 |
2102541 | 2102541 | 2022-01-10 | Columbia | Wisconsin | 55021 | 11367 | 103 |
2099290 | 2099290 | 2022-01-09 | Columbia | Wisconsin | 55021 | 10979 | 103 |
2096039 | 2096039 | 2022-01-08 | Columbia | Wisconsin | 55021 | 10979 | 103 |
2092787 | 2092787 | 2022-01-07 | Columbia | Wisconsin | 55021 | 10979 | 103 |
2089535 | 2089535 | 2022-01-06 | Columbia | Wisconsin | 55021 | 10754 | 103 |
2086284 | 2086284 | 2022-01-05 | Columbia | Wisconsin | 55021 | 10652 | 103 |
2083032 | 2083032 | 2022-01-04 | Columbia | Wisconsin | 55021 | 10551 | 103 |
2079780 | 2079780 | 2022-01-03 | Columbia | Wisconsin | 55021 | 10489 | 103 |
2076528 | 2076528 | 2022-01-02 | Columbia | Wisconsin | 55021 | 10307 | 103 |
2073277 | 2073277 | 2022-01-01 | Columbia | Wisconsin | 55021 | 10307 | 103 |
2070026 | 2070026 | 2021-12-31 | Columbia | Wisconsin | 55021 | 10307 | 103 |
2066775 | 2066775 | 2021-12-30 | Columbia | Wisconsin | 55021 | 10219 | 103 |
2063525 | 2063525 | 2021-12-29 | Columbia | Wisconsin | 55021 | 10104 | 103 |
2060275 | 2060275 | 2021-12-28 | Columbia | Wisconsin | 55021 | 10087 | 102 |
2057026 | 2057026 | 2021-12-27 | Columbia | Wisconsin | 55021 | 10061 | 102 |
2053777 | 2053777 | 2021-12-26 | Columbia | Wisconsin | 55021 | 9944 | 102 |
2050527 | 2050527 | 2021-12-25 | Columbia | Wisconsin | 55021 | 9944 | 102 |
2047277 | 2047277 | 2021-12-24 | Columbia | Wisconsin | 55021 | 9944 | 102 |
2044027 | 2044027 | 2021-12-23 | Columbia | Wisconsin | 55021 | 9900 | 101 |
2040778 | 2040778 | 2021-12-22 | Columbia | Wisconsin | 55021 | 9838 | 100 |
2037528 | 2037528 | 2021-12-21 | Columbia | Wisconsin | 55021 | 9806 | 100 |
2034278 | 2034278 | 2021-12-20 | Columbia | Wisconsin | 55021 | 9790 | 100 |
2031028 | 2031028 | 2021-12-19 | Columbia | Wisconsin | 55021 | 9681 | 100 |
2027777 | 2027777 | 2021-12-18 | Columbia | Wisconsin | 55021 | 9681 | 100 |
2024526 | 2024526 | 2021-12-17 | Columbia | Wisconsin | 55021 | 9681 | 100 |
2021275 | 2021275 | 2021-12-16 | Columbia | Wisconsin | 55021 | 9635 | 99 |
2018024 | 2018024 | 2021-12-15 | Columbia | Wisconsin | 55021 | 9561 | 99 |
2014774 | 2014774 | 2021-12-14 | Columbia | Wisconsin | 55021 | 9529 | 98 |
2011523 | 2011523 | 2021-12-13 | Columbia | Wisconsin | 55021 | 9503 | 97 |
2008272 | 2008272 | 2021-12-12 | Columbia | Wisconsin | 55021 | 9368 | 97 |
2005021 | 2005021 | 2021-12-11 | Columbia | Wisconsin | 55021 | 9368 | 97 |
2001770 | 2001770 | 2021-12-10 | Columbia | Wisconsin | 55021 | 9368 | 97 |
1998520 | 1998520 | 2021-12-09 | Columbia | Wisconsin | 55021 | 9298 | 96 |
1995269 | 1995269 | 2021-12-08 | Columbia | Wisconsin | 55021 | 9215 | 96 |
1992018 | 1992018 | 2021-12-07 | Columbia | Wisconsin | 55021 | 9056 | 94 |
1988767 | 1988767 | 2021-12-06 | Columbia | Wisconsin | 55021 | 9056 | 94 |
1985517 | 1985517 | 2021-12-05 | Columbia | Wisconsin | 55021 | 9056 | 94 |
1982267 | 1982267 | 2021-12-04 | Columbia | Wisconsin | 55021 | 9056 | 94 |
1979017 | 1979017 | 2021-12-03 | Columbia | Wisconsin | 55021 | 9056 | 94 |
1975767 | 1975767 | 2021-12-02 | Columbia | Wisconsin | 55021 | 9020 | 94 |
1972518 | 1972518 | 2021-12-01 | Columbia | Wisconsin | 55021 | 8951 | 94 |
1969268 | 1969268 | 2021-11-30 | Columbia | Wisconsin | 55021 | 8894 | 93 |
1966018 | 1966018 | 2021-11-29 | Columbia | Wisconsin | 55021 | 8856 | 93 |
1962766 | 1962766 | 2021-11-28 | Columbia | Wisconsin | 55021 | 8806 | 93 |
1959515 | 1959515 | 2021-11-27 | Columbia | Wisconsin | 55021 | 8806 | 93 |
1956264 | 1956264 | 2021-11-26 | Columbia | Wisconsin | 55021 | 8806 | 93 |
1953013 | 1953013 | 2021-11-25 | Columbia | Wisconsin | 55021 | 8773 | 93 |
1949762 | 1949762 | 2021-11-24 | Columbia | Wisconsin | 55021 | 8719 | 93 |
1946511 | 1946511 | 2021-11-23 | Columbia | Wisconsin | 55021 | 8681 | 85 |
1943260 | 1943260 | 2021-11-22 | Columbia | Wisconsin | 55021 | 8658 | 85 |
1940010 | 1940010 | 2021-11-21 | Columbia | Wisconsin | 55021 | 8561 | 85 |
1936760 | 1936760 | 2021-11-20 | Columbia | Wisconsin | 55021 | 8561 | 85 |
1933510 | 1933510 | 2021-11-19 | Columbia | Wisconsin | 55021 | 8561 | 85 |
1930258 | 1930258 | 2021-11-18 | Columbia | Wisconsin | 55021 | 8530 | 85 |
1927008 | 1927008 | 2021-11-17 | Columbia | Wisconsin | 55021 | 8494 | 85 |
1923758 | 1923758 | 2021-11-16 | Columbia | Wisconsin | 55021 | 8458 | 85 |
1920509 | 1920509 | 2021-11-15 | Columbia | Wisconsin | 55021 | 8444 | 85 |
1917259 | 1917259 | 2021-11-14 | Columbia | Wisconsin | 55021 | 8372 | 85 |
1914009 | 1914009 | 2021-11-13 | Columbia | Wisconsin | 55021 | 8372 | 85 |
1910759 | 1910759 | 2021-11-12 | Columbia | Wisconsin | 55021 | 8372 | 85 |
1907510 | 1907510 | 2021-11-11 | Columbia | Wisconsin | 55021 | 8347 | 84 |
1904261 | 1904261 | 2021-11-10 | Columbia | Wisconsin | 55021 | 8289 | 84 |
1901011 | 1901011 | 2021-11-09 | Columbia | Wisconsin | 55021 | 8260 | 84 |
1897761 | 1897761 | 2021-11-08 | Columbia | Wisconsin | 55021 | 8237 | 82 |
1894511 | 1894511 | 2021-11-07 | Columbia | Wisconsin | 55021 | 8177 | 82 |
1891261 | 1891261 | 2021-11-06 | Columbia | Wisconsin | 55021 | 8177 | 82 |
1888011 | 1888011 | 2021-11-05 | Columbia | Wisconsin | 55021 | 8177 | 82 |
1884761 | 1884761 | 2021-11-04 | Columbia | Wisconsin | 55021 | 8159 | 82 |
1881512 | 1881512 | 2021-11-03 | Columbia | Wisconsin | 55021 | 8125 | 81 |
1878263 | 1878263 | 2021-11-02 | Columbia | Wisconsin | 55021 | 8111 | 80 |
1875014 | 1875014 | 2021-11-01 | Columbia | Wisconsin | 55021 | 8095 | 80 |
1871765 | 1871765 | 2021-10-31 | Columbia | Wisconsin | 55021 | 8046 | 80 |
1868516 | 1868516 | 2021-10-30 | Columbia | Wisconsin | 55021 | 8046 | 80 |
1865267 | 1865267 | 2021-10-29 | Columbia | Wisconsin | 55021 | 8046 | 80 |
1862018 | 1862018 | 2021-10-28 | Columbia | Wisconsin | 55021 | 8011 | 80 |
1858769 | 1858769 | 2021-10-27 | Columbia | Wisconsin | 55021 | 7974 | 79 |
1855520 | 1855520 | 2021-10-26 | Columbia | Wisconsin | 55021 | 7964 | 79 |
1852271 | 1852271 | 2021-10-25 | Columbia | Wisconsin | 55021 | 7949 | 79 |
1849021 | 1849021 | 2021-10-24 | Columbia | Wisconsin | 55021 | 7885 | 78 |
1845771 | 1845771 | 2021-10-23 | Columbia | Wisconsin | 55021 | 7885 | 78 |
1842521 | 1842521 | 2021-10-22 | Columbia | Wisconsin | 55021 | 7885 | 78 |
1839272 | 1839272 | 2021-10-21 | Columbia | Wisconsin | 55021 | 7858 | 78 |
1836023 | 1836023 | 2021-10-20 | Columbia | Wisconsin | 55021 | 7832 | 78 |
1832774 | 1832774 | 2021-10-19 | Columbia | Wisconsin | 55021 | 7814 | 78 |
1829525 | 1829525 | 2021-10-18 | Columbia | Wisconsin | 55021 | 7799 | 78 |
1826276 | 1826276 | 2021-10-17 | Columbia | Wisconsin | 55021 | 7758 | 78 |
1823027 | 1823027 | 2021-10-16 | Columbia | Wisconsin | 55021 | 7698 | 78 |
1819778 | 1819778 | 2021-10-15 | Columbia | Wisconsin | 55021 | 7698 | 78 |
1816529 | 1816529 | 2021-10-14 | Columbia | Wisconsin | 55021 | 7698 | 78 |
1813281 | 1813281 | 2021-10-13 | Columbia | Wisconsin | 55021 | 7668 | 78 |
1810032 | 1810032 | 2021-10-12 | Columbia | Wisconsin | 55021 | 7645 | 78 |
1806783 | 1806783 | 2021-10-11 | Columbia | Wisconsin | 55021 | 7619 | 78 |
1803532 | 1803532 | 2021-10-10 | Columbia | Wisconsin | 55021 | 7529 | 78 |
1800283 | 1800283 | 2021-10-09 | Columbia | Wisconsin | 55021 | 7529 | 78 |
1797034 | 1797034 | 2021-10-08 | Columbia | Wisconsin | 55021 | 7529 | 78 |
1793785 | 1793785 | 2021-10-07 | Columbia | Wisconsin | 55021 | 7493 | 78 |
1790536 | 1790536 | 2021-10-06 | Columbia | Wisconsin | 55021 | 7458 | 78 |
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);