ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
376 rows where deaths = 42 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Iron 133
- Vernon 57
- Pierce 20
- Brown 13
- Trempealeau 13
- Jackson 12
- Vilas 11
- Door 8
- Dunn 8
- Oconto 8
- Marinette 7
- Waushara 7
- Manitowoc 6
- Taylor 6
- Kewaunee 5
- Langlade 5
- Monroe 5
- Sauk 5
- Burnett 4
- Green 4
- La Crosse 4
- Shawano 4
- Waukesha 4
- Marquette 3
- Calumet 2
- Douglas 2
- Jefferson 2
- Richland 2
- Walworth 2
- Adams 1
- …
state 1
- Wisconsin · 376 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2349747 | 2349747 | 2022-03-27 | Jackson | Wisconsin | 55053 | 5637 | 42 |
2346494 | 2346494 | 2022-03-26 | Jackson | Wisconsin | 55053 | 5637 | 42 |
2343241 | 2343241 | 2022-03-25 | Jackson | Wisconsin | 55053 | 5637 | 42 |
2339988 | 2339988 | 2022-03-24 | Jackson | Wisconsin | 55053 | 5637 | 42 |
2336735 | 2336735 | 2022-03-23 | Jackson | Wisconsin | 55053 | 5636 | 42 |
2333481 | 2333481 | 2022-03-22 | Jackson | Wisconsin | 55053 | 5636 | 42 |
2330227 | 2330227 | 2022-03-21 | Jackson | Wisconsin | 55053 | 5634 | 42 |
2326975 | 2326975 | 2022-03-20 | Jackson | Wisconsin | 55053 | 5633 | 42 |
2323722 | 2323722 | 2022-03-19 | Jackson | Wisconsin | 55053 | 5633 | 42 |
2320468 | 2320468 | 2022-03-18 | Jackson | Wisconsin | 55053 | 5633 | 42 |
2317194 | 2317194 | 2022-03-17 | Burnett | Wisconsin | 55013 | 3950 | 42 |
2317214 | 2317214 | 2022-03-17 | Jackson | Wisconsin | 55053 | 5633 | 42 |
2313941 | 2313941 | 2022-03-16 | Burnett | Wisconsin | 55013 | 3947 | 42 |
2313961 | 2313961 | 2022-03-16 | Jackson | Wisconsin | 55053 | 5633 | 42 |
2310688 | 2310688 | 2022-03-15 | Burnett | Wisconsin | 55013 | 3947 | 42 |
2307435 | 2307435 | 2022-03-14 | Burnett | Wisconsin | 55013 | 3946 | 42 |
2248948 | 2248948 | 2022-02-24 | Richland | Wisconsin | 55103 | 3784 | 42 |
2245697 | 2245697 | 2022-02-23 | Richland | Wisconsin | 55103 | 3783 | 42 |
2203442 | 2203442 | 2022-02-10 | Washburn | Wisconsin | 55129 | 3858 | 42 |
2122079 | 2122079 | 2022-01-16 | Marquette | Wisconsin | 55077 | 3251 | 42 |
2118827 | 2118827 | 2022-01-15 | Marquette | Wisconsin | 55077 | 3251 | 42 |
2115575 | 2115575 | 2022-01-14 | Marquette | Wisconsin | 55077 | 3251 | 42 |
2083022 | 2083022 | 2022-01-04 | Adams | Wisconsin | 55001 | 3437 | 42 |
2053789 | 2053789 | 2021-12-26 | Green | Wisconsin | 55045 | 6107 | 42 |
2050539 | 2050539 | 2021-12-25 | Green | Wisconsin | 55045 | 6107 | 42 |
2047289 | 2047289 | 2021-12-24 | Green | Wisconsin | 55045 | 6107 | 42 |
2044039 | 2044039 | 2021-12-23 | Green | Wisconsin | 55045 | 6086 | 42 |
2034324 | 2034324 | 2021-12-20 | Sawyer | Wisconsin | 55113 | 3371 | 42 |
1995273 | 1995273 | 2021-12-08 | Door | Wisconsin | 55029 | 4303 | 42 |
1995282 | 1995282 | 2021-12-08 | Green Lake | Wisconsin | 55047 | 3492 | 42 |
1992022 | 1992022 | 2021-12-07 | Door | Wisconsin | 55029 | 4263 | 42 |
1988771 | 1988771 | 2021-12-06 | Door | Wisconsin | 55029 | 4263 | 42 |
1985521 | 1985521 | 2021-12-05 | Door | Wisconsin | 55029 | 4263 | 42 |
1982271 | 1982271 | 2021-12-04 | Door | Wisconsin | 55029 | 4263 | 42 |
1979021 | 1979021 | 2021-12-03 | Door | Wisconsin | 55029 | 4263 | 42 |
1975771 | 1975771 | 2021-12-02 | Door | Wisconsin | 55029 | 4237 | 42 |
1972522 | 1972522 | 2021-12-01 | Door | Wisconsin | 55029 | 4204 | 42 |
1966033 | 1966033 | 2021-11-29 | Iron | Wisconsin | 55051 | 960 | 42 |
1962781 | 1962781 | 2021-11-28 | Iron | Wisconsin | 55051 | 955 | 42 |
1959530 | 1959530 | 2021-11-27 | Iron | Wisconsin | 55051 | 955 | 42 |
1956279 | 1956279 | 2021-11-26 | Iron | Wisconsin | 55051 | 955 | 42 |
1953028 | 1953028 | 2021-11-25 | Iron | Wisconsin | 55051 | 955 | 42 |
1949777 | 1949777 | 2021-11-24 | Iron | Wisconsin | 55051 | 951 | 42 |
1946526 | 1946526 | 2021-11-23 | Iron | Wisconsin | 55051 | 942 | 42 |
1943275 | 1943275 | 2021-11-22 | Iron | Wisconsin | 55051 | 940 | 42 |
1940025 | 1940025 | 2021-11-21 | Iron | Wisconsin | 55051 | 934 | 42 |
1936775 | 1936775 | 2021-11-20 | Iron | Wisconsin | 55051 | 934 | 42 |
1933525 | 1933525 | 2021-11-19 | Iron | Wisconsin | 55051 | 934 | 42 |
1930273 | 1930273 | 2021-11-18 | Iron | Wisconsin | 55051 | 934 | 42 |
1927023 | 1927023 | 2021-11-17 | Iron | Wisconsin | 55051 | 934 | 42 |
1923773 | 1923773 | 2021-11-16 | Iron | Wisconsin | 55051 | 934 | 42 |
1920524 | 1920524 | 2021-11-15 | Iron | Wisconsin | 55051 | 930 | 42 |
1917274 | 1917274 | 2021-11-14 | Iron | Wisconsin | 55051 | 930 | 42 |
1914024 | 1914024 | 2021-11-13 | Iron | Wisconsin | 55051 | 930 | 42 |
1910774 | 1910774 | 2021-11-12 | Iron | Wisconsin | 55051 | 930 | 42 |
1907525 | 1907525 | 2021-11-11 | Iron | Wisconsin | 55051 | 929 | 42 |
1904276 | 1904276 | 2021-11-10 | Iron | Wisconsin | 55051 | 927 | 42 |
1901026 | 1901026 | 2021-11-09 | Iron | Wisconsin | 55051 | 922 | 42 |
1897776 | 1897776 | 2021-11-08 | Iron | Wisconsin | 55051 | 920 | 42 |
1894526 | 1894526 | 2021-11-07 | Iron | Wisconsin | 55051 | 917 | 42 |
1891276 | 1891276 | 2021-11-06 | Iron | Wisconsin | 55051 | 917 | 42 |
1888026 | 1888026 | 2021-11-05 | Iron | Wisconsin | 55051 | 917 | 42 |
1884776 | 1884776 | 2021-11-04 | Iron | Wisconsin | 55051 | 913 | 42 |
1881527 | 1881527 | 2021-11-03 | Iron | Wisconsin | 55051 | 913 | 42 |
1878278 | 1878278 | 2021-11-02 | Iron | Wisconsin | 55051 | 911 | 42 |
1878283 | 1878283 | 2021-11-02 | Kewaunee | Wisconsin | 55061 | 3670 | 42 |
1875029 | 1875029 | 2021-11-01 | Iron | Wisconsin | 55051 | 907 | 42 |
1875034 | 1875034 | 2021-11-01 | Kewaunee | Wisconsin | 55061 | 3645 | 42 |
1871780 | 1871780 | 2021-10-31 | Iron | Wisconsin | 55051 | 902 | 42 |
1871785 | 1871785 | 2021-10-31 | Kewaunee | Wisconsin | 55061 | 3636 | 42 |
1868531 | 1868531 | 2021-10-30 | Iron | Wisconsin | 55051 | 902 | 42 |
1868536 | 1868536 | 2021-10-30 | Kewaunee | Wisconsin | 55061 | 3636 | 42 |
1865282 | 1865282 | 2021-10-29 | Iron | Wisconsin | 55051 | 902 | 42 |
1865287 | 1865287 | 2021-10-29 | Kewaunee | Wisconsin | 55061 | 3636 | 42 |
1862033 | 1862033 | 2021-10-28 | Iron | Wisconsin | 55051 | 899 | 42 |
1858784 | 1858784 | 2021-10-27 | Iron | Wisconsin | 55051 | 895 | 42 |
1855535 | 1855535 | 2021-10-26 | Iron | Wisconsin | 55051 | 895 | 42 |
1852286 | 1852286 | 2021-10-25 | Iron | Wisconsin | 55051 | 894 | 42 |
1849036 | 1849036 | 2021-10-24 | Iron | Wisconsin | 55051 | 887 | 42 |
1845786 | 1845786 | 2021-10-23 | Iron | Wisconsin | 55051 | 887 | 42 |
1842536 | 1842536 | 2021-10-22 | Iron | Wisconsin | 55051 | 887 | 42 |
1839287 | 1839287 | 2021-10-21 | Iron | Wisconsin | 55051 | 886 | 42 |
1836038 | 1836038 | 2021-10-20 | Iron | Wisconsin | 55051 | 871 | 42 |
1832789 | 1832789 | 2021-10-19 | Iron | Wisconsin | 55051 | 865 | 42 |
1829540 | 1829540 | 2021-10-18 | Iron | Wisconsin | 55051 | 853 | 42 |
1826291 | 1826291 | 2021-10-17 | Iron | Wisconsin | 55051 | 853 | 42 |
1823042 | 1823042 | 2021-10-16 | Iron | Wisconsin | 55051 | 847 | 42 |
1819793 | 1819793 | 2021-10-15 | Iron | Wisconsin | 55051 | 847 | 42 |
1816544 | 1816544 | 2021-10-14 | Iron | Wisconsin | 55051 | 847 | 42 |
1813296 | 1813296 | 2021-10-13 | Iron | Wisconsin | 55051 | 845 | 42 |
1810047 | 1810047 | 2021-10-12 | Iron | Wisconsin | 55051 | 844 | 42 |
1806798 | 1806798 | 2021-10-11 | Iron | Wisconsin | 55051 | 840 | 42 |
1803547 | 1803547 | 2021-10-10 | Iron | Wisconsin | 55051 | 836 | 42 |
1800298 | 1800298 | 2021-10-09 | Iron | Wisconsin | 55051 | 836 | 42 |
1797049 | 1797049 | 2021-10-08 | Iron | Wisconsin | 55051 | 836 | 42 |
1793800 | 1793800 | 2021-10-07 | Iron | Wisconsin | 55051 | 836 | 42 |
1790551 | 1790551 | 2021-10-06 | Iron | Wisconsin | 55051 | 831 | 42 |
1787303 | 1787303 | 2021-10-05 | Iron | Wisconsin | 55051 | 826 | 42 |
1784045 | 1784045 | 2021-10-04 | Dunn | Wisconsin | 55033 | 6524 | 42 |
1784054 | 1784054 | 2021-10-04 | Iron | Wisconsin | 55051 | 819 | 42 |
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);