ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 55027 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112298 | 2112298 | 2022-01-13 | Dodge | Wisconsin | 55027 | 22309 | 280 |
2109046 | 2109046 | 2022-01-12 | Dodge | Wisconsin | 55027 | 22027 | 280 |
2105795 | 2105795 | 2022-01-11 | Dodge | Wisconsin | 55027 | 21712 | 280 |
2102544 | 2102544 | 2022-01-10 | Dodge | Wisconsin | 55027 | 21453 | 280 |
2099293 | 2099293 | 2022-01-09 | Dodge | Wisconsin | 55027 | 21223 | 279 |
2096042 | 2096042 | 2022-01-08 | Dodge | Wisconsin | 55027 | 21223 | 279 |
2092790 | 2092790 | 2022-01-07 | Dodge | Wisconsin | 55027 | 21223 | 279 |
2089538 | 2089538 | 2022-01-06 | Dodge | Wisconsin | 55027 | 20969 | 277 |
2086287 | 2086287 | 2022-01-05 | Dodge | Wisconsin | 55027 | 20648 | 277 |
2083035 | 2083035 | 2022-01-04 | Dodge | Wisconsin | 55027 | 20477 | 276 |
2079783 | 2079783 | 2022-01-03 | Dodge | Wisconsin | 55027 | 20370 | 276 |
2076531 | 2076531 | 2022-01-02 | Dodge | Wisconsin | 55027 | 20362 | 276 |
2073280 | 2073280 | 2022-01-01 | Dodge | Wisconsin | 55027 | 20362 | 276 |
2070029 | 2070029 | 2021-12-31 | Dodge | Wisconsin | 55027 | 20362 | 276 |
2066778 | 2066778 | 2021-12-30 | Dodge | Wisconsin | 55027 | 20260 | 276 |
2063528 | 2063528 | 2021-12-29 | Dodge | Wisconsin | 55027 | 20130 | 276 |
2060278 | 2060278 | 2021-12-28 | Dodge | Wisconsin | 55027 | 19972 | 276 |
2057029 | 2057029 | 2021-12-27 | Dodge | Wisconsin | 55027 | 19792 | 276 |
2053780 | 2053780 | 2021-12-26 | Dodge | Wisconsin | 55027 | 19788 | 276 |
2050530 | 2050530 | 2021-12-25 | Dodge | Wisconsin | 55027 | 19788 | 276 |
2047280 | 2047280 | 2021-12-24 | Dodge | Wisconsin | 55027 | 19788 | 276 |
2044030 | 2044030 | 2021-12-23 | Dodge | Wisconsin | 55027 | 19668 | 263 |
2040781 | 2040781 | 2021-12-22 | Dodge | Wisconsin | 55027 | 19559 | 250 |
2037531 | 2037531 | 2021-12-21 | Dodge | Wisconsin | 55027 | 19466 | 250 |
2034281 | 2034281 | 2021-12-20 | Dodge | Wisconsin | 55027 | 19420 | 250 |
2031031 | 2031031 | 2021-12-19 | Dodge | Wisconsin | 55027 | 19244 | 248 |
2027780 | 2027780 | 2021-12-18 | Dodge | Wisconsin | 55027 | 19244 | 248 |
2024529 | 2024529 | 2021-12-17 | Dodge | Wisconsin | 55027 | 19244 | 248 |
2021278 | 2021278 | 2021-12-16 | Dodge | Wisconsin | 55027 | 19167 | 246 |
2018027 | 2018027 | 2021-12-15 | Dodge | Wisconsin | 55027 | 19086 | 246 |
2014777 | 2014777 | 2021-12-14 | Dodge | Wisconsin | 55027 | 19034 | 246 |
2011526 | 2011526 | 2021-12-13 | Dodge | Wisconsin | 55027 | 18988 | 245 |
2008275 | 2008275 | 2021-12-12 | Dodge | Wisconsin | 55027 | 18792 | 244 |
2005024 | 2005024 | 2021-12-11 | Dodge | Wisconsin | 55027 | 18792 | 244 |
2001773 | 2001773 | 2021-12-10 | Dodge | Wisconsin | 55027 | 18792 | 244 |
1998523 | 1998523 | 2021-12-09 | Dodge | Wisconsin | 55027 | 18611 | 244 |
1995272 | 1995272 | 2021-12-08 | Dodge | Wisconsin | 55027 | 18519 | 244 |
1992021 | 1992021 | 2021-12-07 | Dodge | Wisconsin | 55027 | 18275 | 241 |
1988770 | 1988770 | 2021-12-06 | Dodge | Wisconsin | 55027 | 18275 | 241 |
1985520 | 1985520 | 2021-12-05 | Dodge | Wisconsin | 55027 | 18275 | 241 |
1982270 | 1982270 | 2021-12-04 | Dodge | Wisconsin | 55027 | 18275 | 241 |
1979020 | 1979020 | 2021-12-03 | Dodge | Wisconsin | 55027 | 18275 | 241 |
1975770 | 1975770 | 2021-12-02 | Dodge | Wisconsin | 55027 | 18185 | 239 |
1972521 | 1972521 | 2021-12-01 | Dodge | Wisconsin | 55027 | 18097 | 239 |
1969271 | 1969271 | 2021-11-30 | Dodge | Wisconsin | 55027 | 18005 | 239 |
1966021 | 1966021 | 2021-11-29 | Dodge | Wisconsin | 55027 | 17951 | 239 |
1962769 | 1962769 | 2021-11-28 | Dodge | Wisconsin | 55027 | 17766 | 239 |
1959518 | 1959518 | 2021-11-27 | Dodge | Wisconsin | 55027 | 17766 | 239 |
1956267 | 1956267 | 2021-11-26 | Dodge | Wisconsin | 55027 | 17766 | 239 |
1953016 | 1953016 | 2021-11-25 | Dodge | Wisconsin | 55027 | 17766 | 239 |
1949765 | 1949765 | 2021-11-24 | Dodge | Wisconsin | 55027 | 17689 | 239 |
1946514 | 1946514 | 2021-11-23 | Dodge | Wisconsin | 55027 | 17594 | 238 |
1943263 | 1943263 | 2021-11-22 | Dodge | Wisconsin | 55027 | 17538 | 238 |
1940013 | 1940013 | 2021-11-21 | Dodge | Wisconsin | 55027 | 17338 | 236 |
1936763 | 1936763 | 2021-11-20 | Dodge | Wisconsin | 55027 | 17338 | 236 |
1933513 | 1933513 | 2021-11-19 | Dodge | Wisconsin | 55027 | 17338 | 236 |
1930261 | 1930261 | 2021-11-18 | Dodge | Wisconsin | 55027 | 17265 | 236 |
1927011 | 1927011 | 2021-11-17 | Dodge | Wisconsin | 55027 | 17191 | 236 |
1923761 | 1923761 | 2021-11-16 | Dodge | Wisconsin | 55027 | 17114 | 236 |
1920512 | 1920512 | 2021-11-15 | Dodge | Wisconsin | 55027 | 17037 | 235 |
1917262 | 1917262 | 2021-11-14 | Dodge | Wisconsin | 55027 | 16831 | 234 |
1914012 | 1914012 | 2021-11-13 | Dodge | Wisconsin | 55027 | 16831 | 234 |
1910762 | 1910762 | 2021-11-12 | Dodge | Wisconsin | 55027 | 16831 | 234 |
1907513 | 1907513 | 2021-11-11 | Dodge | Wisconsin | 55027 | 16751 | 233 |
1904264 | 1904264 | 2021-11-10 | Dodge | Wisconsin | 55027 | 16663 | 233 |
1901014 | 1901014 | 2021-11-09 | Dodge | Wisconsin | 55027 | 16608 | 230 |
1897764 | 1897764 | 2021-11-08 | Dodge | Wisconsin | 55027 | 16568 | 230 |
1894514 | 1894514 | 2021-11-07 | Dodge | Wisconsin | 55027 | 16433 | 229 |
1891264 | 1891264 | 2021-11-06 | Dodge | Wisconsin | 55027 | 16433 | 229 |
1888014 | 1888014 | 2021-11-05 | Dodge | Wisconsin | 55027 | 16433 | 229 |
1884764 | 1884764 | 2021-11-04 | Dodge | Wisconsin | 55027 | 16355 | 229 |
1881515 | 1881515 | 2021-11-03 | Dodge | Wisconsin | 55027 | 16318 | 228 |
1878266 | 1878266 | 2021-11-02 | Dodge | Wisconsin | 55027 | 16289 | 229 |
1875017 | 1875017 | 2021-11-01 | Dodge | Wisconsin | 55027 | 16256 | 229 |
1871768 | 1871768 | 2021-10-31 | Dodge | Wisconsin | 55027 | 16181 | 229 |
1868519 | 1868519 | 2021-10-30 | Dodge | Wisconsin | 55027 | 16181 | 229 |
1865270 | 1865270 | 2021-10-29 | Dodge | Wisconsin | 55027 | 16181 | 229 |
1862021 | 1862021 | 2021-10-28 | Dodge | Wisconsin | 55027 | 16132 | 228 |
1858772 | 1858772 | 2021-10-27 | Dodge | Wisconsin | 55027 | 16092 | 228 |
1855523 | 1855523 | 2021-10-26 | Dodge | Wisconsin | 55027 | 16043 | 227 |
1852274 | 1852274 | 2021-10-25 | Dodge | Wisconsin | 55027 | 16019 | 227 |
1849024 | 1849024 | 2021-10-24 | Dodge | Wisconsin | 55027 | 15955 | 227 |
1845774 | 1845774 | 2021-10-23 | Dodge | Wisconsin | 55027 | 15955 | 227 |
1842524 | 1842524 | 2021-10-22 | Dodge | Wisconsin | 55027 | 15955 | 227 |
1839275 | 1839275 | 2021-10-21 | Dodge | Wisconsin | 55027 | 15915 | 226 |
1836026 | 1836026 | 2021-10-20 | Dodge | Wisconsin | 55027 | 15873 | 226 |
1832777 | 1832777 | 2021-10-19 | Dodge | Wisconsin | 55027 | 15820 | 225 |
1829528 | 1829528 | 2021-10-18 | Dodge | Wisconsin | 55027 | 15797 | 224 |
1826279 | 1826279 | 2021-10-17 | Dodge | Wisconsin | 55027 | 15741 | 224 |
1823030 | 1823030 | 2021-10-16 | Dodge | Wisconsin | 55027 | 15671 | 223 |
1819781 | 1819781 | 2021-10-15 | Dodge | Wisconsin | 55027 | 15671 | 223 |
1816532 | 1816532 | 2021-10-14 | Dodge | Wisconsin | 55027 | 15671 | 223 |
1813284 | 1813284 | 2021-10-13 | Dodge | Wisconsin | 55027 | 15615 | 223 |
1810035 | 1810035 | 2021-10-12 | Dodge | Wisconsin | 55027 | 15591 | 223 |
1806786 | 1806786 | 2021-10-11 | Dodge | Wisconsin | 55027 | 15548 | 223 |
1803535 | 1803535 | 2021-10-10 | Dodge | Wisconsin | 55027 | 15458 | 223 |
1800286 | 1800286 | 2021-10-09 | Dodge | Wisconsin | 55027 | 15458 | 223 |
1797037 | 1797037 | 2021-10-08 | Dodge | Wisconsin | 55027 | 15458 | 223 |
1793788 | 1793788 | 2021-10-07 | Dodge | Wisconsin | 55027 | 15388 | 219 |
1790539 | 1790539 | 2021-10-06 | Dodge | Wisconsin | 55027 | 15344 | 219 |
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);