ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
576 rows where deaths = 15 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Ashland 140
- Richland 84
- Florence 79
- Adams 70
- Rusk 16
- Pepin 14
- Marquette 13
- Burnett 12
- Ozaukee 12
- Waupaca 12
- Waushara 12
- Crawford 6
- Grant 6
- Lafayette 6
- Trempealeau 6
- Vernon 6
- Door 5
- Green 5
- Kewaunee 5
- Monroe 5
- Taylor 5
- Fond du Lac 4
- Iron 4
- Lincoln 4
- Oconto 4
- Portage 4
- Sheboygan 4
- Kenosha 3
- La Crosse 3
- Langlade 3
- …
state 1
- Wisconsin · 576 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2294440 | 2294440 | 2022-03-10 | Florence | Wisconsin | 55037 | 1077 | 15 |
2291188 | 2291188 | 2022-03-09 | Florence | Wisconsin | 55037 | 1076 | 15 |
2287936 | 2287936 | 2022-03-08 | Florence | Wisconsin | 55037 | 1076 | 15 |
2284684 | 2284684 | 2022-03-07 | Florence | Wisconsin | 55037 | 1075 | 15 |
2281432 | 2281432 | 2022-03-06 | Florence | Wisconsin | 55037 | 1075 | 15 |
2278179 | 2278179 | 2022-03-05 | Florence | Wisconsin | 55037 | 1075 | 15 |
2274926 | 2274926 | 2022-03-04 | Florence | Wisconsin | 55037 | 1075 | 15 |
2271673 | 2271673 | 2022-03-03 | Florence | Wisconsin | 55037 | 1075 | 15 |
2268421 | 2268421 | 2022-03-02 | Florence | Wisconsin | 55037 | 1075 | 15 |
2265168 | 2265168 | 2022-03-01 | Florence | Wisconsin | 55037 | 1074 | 15 |
2261918 | 2261918 | 2022-02-28 | Florence | Wisconsin | 55037 | 1074 | 15 |
2258667 | 2258667 | 2022-02-27 | Florence | Wisconsin | 55037 | 1073 | 15 |
2255416 | 2255416 | 2022-02-26 | Florence | Wisconsin | 55037 | 1073 | 15 |
2252165 | 2252165 | 2022-02-25 | Florence | Wisconsin | 55037 | 1073 | 15 |
2248914 | 2248914 | 2022-02-24 | Florence | Wisconsin | 55037 | 1073 | 15 |
2245663 | 2245663 | 2022-02-23 | Florence | Wisconsin | 55037 | 1072 | 15 |
2242412 | 2242412 | 2022-02-22 | Florence | Wisconsin | 55037 | 1068 | 15 |
2239161 | 2239161 | 2022-02-21 | Florence | Wisconsin | 55037 | 1068 | 15 |
2235910 | 2235910 | 2022-02-20 | Florence | Wisconsin | 55037 | 1067 | 15 |
2232659 | 2232659 | 2022-02-19 | Florence | Wisconsin | 55037 | 1067 | 15 |
2229408 | 2229408 | 2022-02-18 | Florence | Wisconsin | 55037 | 1067 | 15 |
2226157 | 2226157 | 2022-02-17 | Florence | Wisconsin | 55037 | 1066 | 15 |
2222906 | 2222906 | 2022-02-16 | Florence | Wisconsin | 55037 | 1063 | 15 |
2219655 | 2219655 | 2022-02-15 | Florence | Wisconsin | 55037 | 1062 | 15 |
2216405 | 2216405 | 2022-02-14 | Florence | Wisconsin | 55037 | 1060 | 15 |
2213154 | 2213154 | 2022-02-13 | Florence | Wisconsin | 55037 | 1057 | 15 |
2209901 | 2209901 | 2022-02-12 | Florence | Wisconsin | 55037 | 1057 | 15 |
2206648 | 2206648 | 2022-02-11 | Florence | Wisconsin | 55037 | 1057 | 15 |
2203395 | 2203395 | 2022-02-10 | Florence | Wisconsin | 55037 | 1054 | 15 |
2200141 | 2200141 | 2022-02-09 | Florence | Wisconsin | 55037 | 1043 | 15 |
2196887 | 2196887 | 2022-02-08 | Florence | Wisconsin | 55037 | 1041 | 15 |
2193632 | 2193632 | 2022-02-07 | Florence | Wisconsin | 55037 | 1036 | 15 |
2190379 | 2190379 | 2022-02-06 | Florence | Wisconsin | 55037 | 1033 | 15 |
2187126 | 2187126 | 2022-02-05 | Florence | Wisconsin | 55037 | 1033 | 15 |
2183873 | 2183873 | 2022-02-04 | Florence | Wisconsin | 55037 | 1033 | 15 |
2180621 | 2180621 | 2022-02-03 | Florence | Wisconsin | 55037 | 1029 | 15 |
2177370 | 2177370 | 2022-02-02 | Florence | Wisconsin | 55037 | 1023 | 15 |
2174117 | 2174117 | 2022-02-01 | Florence | Wisconsin | 55037 | 1015 | 15 |
2170865 | 2170865 | 2022-01-31 | Florence | Wisconsin | 55037 | 1005 | 15 |
2167612 | 2167612 | 2022-01-30 | Florence | Wisconsin | 55037 | 998 | 15 |
2164357 | 2164357 | 2022-01-29 | Florence | Wisconsin | 55037 | 998 | 15 |
2161102 | 2161102 | 2022-01-28 | Florence | Wisconsin | 55037 | 998 | 15 |
2157846 | 2157846 | 2022-01-27 | Florence | Wisconsin | 55037 | 991 | 15 |
2154593 | 2154593 | 2022-01-26 | Florence | Wisconsin | 55037 | 976 | 15 |
2151340 | 2151340 | 2022-01-25 | Florence | Wisconsin | 55037 | 963 | 15 |
2148088 | 2148088 | 2022-01-24 | Florence | Wisconsin | 55037 | 955 | 15 |
2144836 | 2144836 | 2022-01-23 | Florence | Wisconsin | 55037 | 931 | 15 |
2141581 | 2141581 | 2022-01-22 | Florence | Wisconsin | 55037 | 931 | 15 |
2138325 | 2138325 | 2022-01-21 | Florence | Wisconsin | 55037 | 931 | 15 |
2135070 | 2135070 | 2022-01-20 | Florence | Wisconsin | 55037 | 920 | 15 |
2131818 | 2131818 | 2022-01-19 | Florence | Wisconsin | 55037 | 909 | 15 |
2128564 | 2128564 | 2022-01-18 | Florence | Wisconsin | 55037 | 899 | 15 |
2125311 | 2125311 | 2022-01-17 | Florence | Wisconsin | 55037 | 884 | 15 |
2122059 | 2122059 | 2022-01-16 | Florence | Wisconsin | 55037 | 867 | 15 |
2118807 | 2118807 | 2022-01-15 | Florence | Wisconsin | 55037 | 867 | 15 |
2115555 | 2115555 | 2022-01-14 | Florence | Wisconsin | 55037 | 867 | 15 |
2112303 | 2112303 | 2022-01-13 | Florence | Wisconsin | 55037 | 856 | 15 |
2109051 | 2109051 | 2022-01-12 | Florence | Wisconsin | 55037 | 850 | 15 |
2105800 | 2105800 | 2022-01-11 | Florence | Wisconsin | 55037 | 844 | 15 |
2105828 | 2105828 | 2022-01-11 | Pepin | Wisconsin | 55091 | 1592 | 15 |
2102549 | 2102549 | 2022-01-10 | Florence | Wisconsin | 55037 | 829 | 15 |
2102577 | 2102577 | 2022-01-10 | Pepin | Wisconsin | 55091 | 1576 | 15 |
2099298 | 2099298 | 2022-01-09 | Florence | Wisconsin | 55037 | 829 | 15 |
2099326 | 2099326 | 2022-01-09 | Pepin | Wisconsin | 55091 | 1555 | 15 |
2096047 | 2096047 | 2022-01-08 | Florence | Wisconsin | 55037 | 829 | 15 |
2096075 | 2096075 | 2022-01-08 | Pepin | Wisconsin | 55091 | 1555 | 15 |
2092795 | 2092795 | 2022-01-07 | Florence | Wisconsin | 55037 | 829 | 15 |
2092823 | 2092823 | 2022-01-07 | Pepin | Wisconsin | 55091 | 1555 | 15 |
2089543 | 2089543 | 2022-01-06 | Florence | Wisconsin | 55037 | 822 | 15 |
2089571 | 2089571 | 2022-01-06 | Pepin | Wisconsin | 55091 | 1544 | 15 |
2086292 | 2086292 | 2022-01-05 | Florence | Wisconsin | 55037 | 814 | 15 |
2086320 | 2086320 | 2022-01-05 | Pepin | Wisconsin | 55091 | 1526 | 15 |
2083040 | 2083040 | 2022-01-04 | Florence | Wisconsin | 55037 | 806 | 15 |
2083068 | 2083068 | 2022-01-04 | Pepin | Wisconsin | 55091 | 1511 | 15 |
2079788 | 2079788 | 2022-01-03 | Florence | Wisconsin | 55037 | 796 | 15 |
2079816 | 2079816 | 2022-01-03 | Pepin | Wisconsin | 55091 | 1494 | 15 |
2076536 | 2076536 | 2022-01-02 | Florence | Wisconsin | 55037 | 796 | 15 |
2076564 | 2076564 | 2022-01-02 | Pepin | Wisconsin | 55091 | 1488 | 15 |
2073285 | 2073285 | 2022-01-01 | Florence | Wisconsin | 55037 | 796 | 15 |
2073313 | 2073313 | 2022-01-01 | Pepin | Wisconsin | 55091 | 1488 | 15 |
2070034 | 2070034 | 2021-12-31 | Florence | Wisconsin | 55037 | 796 | 15 |
2070062 | 2070062 | 2021-12-31 | Pepin | Wisconsin | 55091 | 1488 | 15 |
2066783 | 2066783 | 2021-12-30 | Florence | Wisconsin | 55037 | 796 | 15 |
2066811 | 2066811 | 2021-12-30 | Pepin | Wisconsin | 55091 | 1473 | 15 |
2063533 | 2063533 | 2021-12-29 | Florence | Wisconsin | 55037 | 792 | 15 |
2063561 | 2063561 | 2021-12-29 | Pepin | Wisconsin | 55091 | 1461 | 15 |
2060283 | 2060283 | 2021-12-28 | Florence | Wisconsin | 55037 | 787 | 15 |
2057034 | 2057034 | 2021-12-27 | Florence | Wisconsin | 55037 | 781 | 15 |
2053785 | 2053785 | 2021-12-26 | Florence | Wisconsin | 55037 | 781 | 15 |
2050535 | 2050535 | 2021-12-25 | Florence | Wisconsin | 55037 | 781 | 15 |
2047285 | 2047285 | 2021-12-24 | Florence | Wisconsin | 55037 | 781 | 15 |
2044035 | 2044035 | 2021-12-23 | Florence | Wisconsin | 55037 | 781 | 15 |
2040786 | 2040786 | 2021-12-22 | Florence | Wisconsin | 55037 | 780 | 15 |
2011545 | 2011545 | 2021-12-13 | Lafayette | Wisconsin | 55065 | 2550 | 15 |
2008294 | 2008294 | 2021-12-12 | Lafayette | Wisconsin | 55065 | 2526 | 15 |
2005043 | 2005043 | 2021-12-11 | Lafayette | Wisconsin | 55065 | 2526 | 15 |
2001792 | 2001792 | 2021-12-10 | Lafayette | Wisconsin | 55065 | 2526 | 15 |
1998542 | 1998542 | 2021-12-09 | Lafayette | Wisconsin | 55065 | 2508 | 15 |
1995291 | 1995291 | 2021-12-08 | Lafayette | Wisconsin | 55065 | 2487 | 15 |
1946551 | 1946551 | 2021-11-23 | Price | Wisconsin | 55099 | 2137 | 15 |
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);