ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
219 rows where deaths = 34 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2245646 | 2245646 | 2022-02-23 | Ashland | Wisconsin | 55003 | 3215 | 34 |
2109036 | 2109036 | 2022-01-12 | Bayfield | Wisconsin | 55007 | 2477 | 34 |
2105785 | 2105785 | 2022-01-11 | Bayfield | Wisconsin | 55007 | 2450 | 34 |
2102534 | 2102534 | 2022-01-10 | Bayfield | Wisconsin | 55007 | 2414 | 34 |
2099283 | 2099283 | 2022-01-09 | Bayfield | Wisconsin | 55007 | 2347 | 34 |
2096032 | 2096032 | 2022-01-08 | Bayfield | Wisconsin | 55007 | 2347 | 34 |
2092780 | 2092780 | 2022-01-07 | Bayfield | Wisconsin | 55007 | 2347 | 34 |
2089528 | 2089528 | 2022-01-06 | Bayfield | Wisconsin | 55007 | 2331 | 34 |
2083087 | 2083087 | 2022-01-04 | Washburn | Wisconsin | 55129 | 3154 | 34 |
2079835 | 2079835 | 2022-01-03 | Washburn | Wisconsin | 55129 | 3138 | 34 |
2076583 | 2076583 | 2022-01-02 | Washburn | Wisconsin | 55129 | 3099 | 34 |
2073332 | 2073332 | 2022-01-01 | Washburn | Wisconsin | 55129 | 3099 | 34 |
2070081 | 2070081 | 2021-12-31 | Washburn | Wisconsin | 55129 | 3099 | 34 |
2066830 | 2066830 | 2021-12-30 | Washburn | Wisconsin | 55129 | 3089 | 34 |
2063580 | 2063580 | 2021-12-29 | Washburn | Wisconsin | 55129 | 3076 | 34 |
2060330 | 2060330 | 2021-12-28 | Washburn | Wisconsin | 55129 | 3063 | 34 |
2057081 | 2057081 | 2021-12-27 | Washburn | Wisconsin | 55129 | 3049 | 34 |
2053832 | 2053832 | 2021-12-26 | Washburn | Wisconsin | 55129 | 3044 | 34 |
2050582 | 2050582 | 2021-12-25 | Washburn | Wisconsin | 55129 | 3044 | 34 |
2047332 | 2047332 | 2021-12-24 | Washburn | Wisconsin | 55129 | 3044 | 34 |
2044082 | 2044082 | 2021-12-23 | Washburn | Wisconsin | 55129 | 3040 | 34 |
2040833 | 2040833 | 2021-12-22 | Washburn | Wisconsin | 55129 | 3029 | 34 |
2037583 | 2037583 | 2021-12-21 | Washburn | Wisconsin | 55129 | 3023 | 34 |
2034333 | 2034333 | 2021-12-20 | Washburn | Wisconsin | 55129 | 3015 | 34 |
2031083 | 2031083 | 2021-12-19 | Washburn | Wisconsin | 55129 | 2997 | 34 |
2027832 | 2027832 | 2021-12-18 | Washburn | Wisconsin | 55129 | 2997 | 34 |
2024581 | 2024581 | 2021-12-17 | Washburn | Wisconsin | 55129 | 2997 | 34 |
2021317 | 2021317 | 2021-12-16 | Richland | Wisconsin | 55103 | 2674 | 34 |
2021330 | 2021330 | 2021-12-16 | Washburn | Wisconsin | 55129 | 2988 | 34 |
2018066 | 2018066 | 2021-12-15 | Richland | Wisconsin | 55103 | 2656 | 34 |
2018079 | 2018079 | 2021-12-15 | Washburn | Wisconsin | 55129 | 2977 | 34 |
2014829 | 2014829 | 2021-12-14 | Washburn | Wisconsin | 55129 | 2968 | 34 |
1998530 | 1998530 | 2021-12-09 | Forest | Wisconsin | 55041 | 1807 | 34 |
1972534 | 1972534 | 2021-12-01 | Jackson | Wisconsin | 55053 | 3821 | 34 |
1969284 | 1969284 | 2021-11-30 | Jackson | Wisconsin | 55053 | 3807 | 34 |
1966034 | 1966034 | 2021-11-29 | Jackson | Wisconsin | 55053 | 3794 | 34 |
1962782 | 1962782 | 2021-11-28 | Jackson | Wisconsin | 55053 | 3762 | 34 |
1959531 | 1959531 | 2021-11-27 | Jackson | Wisconsin | 55053 | 3762 | 34 |
1956280 | 1956280 | 2021-11-26 | Jackson | Wisconsin | 55053 | 3762 | 34 |
1953029 | 1953029 | 2021-11-25 | Jackson | Wisconsin | 55053 | 3762 | 34 |
1949778 | 1949778 | 2021-11-24 | Jackson | Wisconsin | 55053 | 3738 | 34 |
1946527 | 1946527 | 2021-11-23 | Jackson | Wisconsin | 55053 | 3715 | 34 |
1943276 | 1943276 | 2021-11-22 | Jackson | Wisconsin | 55053 | 3700 | 34 |
1940026 | 1940026 | 2021-11-21 | Jackson | Wisconsin | 55053 | 3665 | 34 |
1936776 | 1936776 | 2021-11-20 | Jackson | Wisconsin | 55053 | 3665 | 34 |
1933526 | 1933526 | 2021-11-19 | Jackson | Wisconsin | 55053 | 3665 | 34 |
1930274 | 1930274 | 2021-11-18 | Jackson | Wisconsin | 55053 | 3653 | 34 |
1927024 | 1927024 | 2021-11-17 | Jackson | Wisconsin | 55053 | 3639 | 34 |
1923774 | 1923774 | 2021-11-16 | Jackson | Wisconsin | 55053 | 3619 | 34 |
1920499 | 1920499 | 2021-11-15 | Adams | Wisconsin | 55001 | 2936 | 34 |
1920525 | 1920525 | 2021-11-15 | Jackson | Wisconsin | 55053 | 3607 | 34 |
1917271 | 1917271 | 2021-11-14 | Green | Wisconsin | 55045 | 4959 | 34 |
1917275 | 1917275 | 2021-11-14 | Jackson | Wisconsin | 55053 | 3584 | 34 |
1914021 | 1914021 | 2021-11-13 | Green | Wisconsin | 55045 | 4959 | 34 |
1914025 | 1914025 | 2021-11-13 | Jackson | Wisconsin | 55053 | 3584 | 34 |
1910771 | 1910771 | 2021-11-12 | Green | Wisconsin | 55045 | 4959 | 34 |
1910775 | 1910775 | 2021-11-12 | Jackson | Wisconsin | 55053 | 3584 | 34 |
1907522 | 1907522 | 2021-11-11 | Green | Wisconsin | 55045 | 4943 | 34 |
1907526 | 1907526 | 2021-11-11 | Jackson | Wisconsin | 55053 | 3571 | 34 |
1904273 | 1904273 | 2021-11-10 | Green | Wisconsin | 55045 | 4907 | 34 |
1904277 | 1904277 | 2021-11-10 | Jackson | Wisconsin | 55053 | 3550 | 34 |
1901023 | 1901023 | 2021-11-09 | Green | Wisconsin | 55045 | 4875 | 34 |
1901027 | 1901027 | 2021-11-09 | Jackson | Wisconsin | 55053 | 3529 | 34 |
1897773 | 1897773 | 2021-11-08 | Green | Wisconsin | 55045 | 4858 | 34 |
1897777 | 1897777 | 2021-11-08 | Jackson | Wisconsin | 55053 | 3520 | 34 |
1894523 | 1894523 | 2021-11-07 | Green | Wisconsin | 55045 | 4785 | 34 |
1894527 | 1894527 | 2021-11-07 | Jackson | Wisconsin | 55053 | 3503 | 34 |
1891273 | 1891273 | 2021-11-06 | Green | Wisconsin | 55045 | 4785 | 34 |
1891277 | 1891277 | 2021-11-06 | Jackson | Wisconsin | 55053 | 3503 | 34 |
1888023 | 1888023 | 2021-11-05 | Green | Wisconsin | 55045 | 4785 | 34 |
1888027 | 1888027 | 2021-11-05 | Jackson | Wisconsin | 55053 | 3503 | 34 |
1884773 | 1884773 | 2021-11-04 | Green | Wisconsin | 55045 | 4757 | 34 |
1881524 | 1881524 | 2021-11-03 | Green | Wisconsin | 55045 | 4728 | 34 |
1858797 | 1858797 | 2021-10-27 | Marquette | Wisconsin | 55077 | 2318 | 34 |
1852315 | 1852315 | 2021-10-25 | Rusk | Wisconsin | 55107 | 2202 | 34 |
1849065 | 1849065 | 2021-10-24 | Rusk | Wisconsin | 55107 | 2189 | 34 |
1845815 | 1845815 | 2021-10-23 | Rusk | Wisconsin | 55107 | 2189 | 34 |
1842565 | 1842565 | 2021-10-22 | Rusk | Wisconsin | 55107 | 2189 | 34 |
1839290 | 1839290 | 2021-10-21 | Juneau | Wisconsin | 55057 | 4158 | 34 |
1836041 | 1836041 | 2021-10-20 | Juneau | Wisconsin | 55057 | 4149 | 34 |
1832792 | 1832792 | 2021-10-19 | Juneau | Wisconsin | 55057 | 4142 | 34 |
1829543 | 1829543 | 2021-10-18 | Juneau | Wisconsin | 55057 | 4138 | 34 |
1826294 | 1826294 | 2021-10-17 | Juneau | Wisconsin | 55057 | 4122 | 34 |
1823045 | 1823045 | 2021-10-16 | Juneau | Wisconsin | 55057 | 4089 | 34 |
1819796 | 1819796 | 2021-10-15 | Juneau | Wisconsin | 55057 | 4089 | 34 |
1816547 | 1816547 | 2021-10-14 | Juneau | Wisconsin | 55057 | 4089 | 34 |
1813299 | 1813299 | 2021-10-13 | Juneau | Wisconsin | 55057 | 4078 | 34 |
1810050 | 1810050 | 2021-10-12 | Juneau | Wisconsin | 55057 | 4071 | 34 |
1806801 | 1806801 | 2021-10-11 | Juneau | Wisconsin | 55057 | 4065 | 34 |
1803550 | 1803550 | 2021-10-10 | Juneau | Wisconsin | 55057 | 4043 | 34 |
1800301 | 1800301 | 2021-10-09 | Juneau | Wisconsin | 55057 | 4043 | 34 |
1797052 | 1797052 | 2021-10-08 | Juneau | Wisconsin | 55057 | 4043 | 34 |
1793803 | 1793803 | 2021-10-07 | Juneau | Wisconsin | 55057 | 4017 | 34 |
1553395 | 1553395 | 2021-07-25 | Door | Wisconsin | 55029 | 2860 | 34 |
1550148 | 1550148 | 2021-07-24 | Door | Wisconsin | 55029 | 2860 | 34 |
1546901 | 1546901 | 2021-07-23 | Door | Wisconsin | 55029 | 2860 | 34 |
1543654 | 1543654 | 2021-07-22 | Door | Wisconsin | 55029 | 2860 | 34 |
1540406 | 1540406 | 2021-07-21 | Door | Wisconsin | 55029 | 2860 | 34 |
1537159 | 1537159 | 2021-07-20 | Door | Wisconsin | 55029 | 2858 | 34 |
1404113 | 1404113 | 2021-06-09 | Taylor | Wisconsin | 55119 | 2134 | 34 |
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);