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 |
---|---|---|---|---|---|---|---|
2177365 | 2177365 | 2022-02-02 | Dodge | Wisconsin | 55027 | 26008 | 293 |
2174112 | 2174112 | 2022-02-01 | Dodge | Wisconsin | 55027 | 25891 | 292 |
2170860 | 2170860 | 2022-01-31 | Dodge | Wisconsin | 55027 | 25806 | 289 |
2167607 | 2167607 | 2022-01-30 | Dodge | Wisconsin | 55027 | 25604 | 289 |
2164352 | 2164352 | 2022-01-29 | Dodge | Wisconsin | 55027 | 25604 | 289 |
2161097 | 2161097 | 2022-01-28 | Dodge | Wisconsin | 55027 | 25604 | 289 |
2157841 | 2157841 | 2022-01-27 | Dodge | Wisconsin | 55027 | 25480 | 290 |
2154588 | 2154588 | 2022-01-26 | Dodge | Wisconsin | 55027 | 25291 | 290 |
2151335 | 2151335 | 2022-01-25 | Dodge | Wisconsin | 55027 | 25157 | 290 |
2148083 | 2148083 | 2022-01-24 | Dodge | Wisconsin | 55027 | 25062 | 290 |
2144831 | 2144831 | 2022-01-23 | Dodge | Wisconsin | 55027 | 24641 | 289 |
2141576 | 2141576 | 2022-01-22 | Dodge | Wisconsin | 55027 | 24641 | 289 |
2138320 | 2138320 | 2022-01-21 | Dodge | Wisconsin | 55027 | 24641 | 289 |
2135065 | 2135065 | 2022-01-20 | Dodge | Wisconsin | 55027 | 24372 | 288 |
2131813 | 2131813 | 2022-01-19 | Dodge | Wisconsin | 55027 | 24171 | 288 |
2128559 | 2128559 | 2022-01-18 | Dodge | Wisconsin | 55027 | 23964 | 288 |
2125306 | 2125306 | 2022-01-17 | Dodge | Wisconsin | 55027 | 23462 | 288 |
2122054 | 2122054 | 2022-01-16 | Dodge | Wisconsin | 55027 | 22579 | 281 |
2118802 | 2118802 | 2022-01-15 | Dodge | Wisconsin | 55027 | 22579 | 281 |
2115550 | 2115550 | 2022-01-14 | Dodge | Wisconsin | 55027 | 22579 | 281 |
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 |
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);