ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
414 rows where deaths = 18 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502784 | 2502784 | 2022-05-13 | Pepin | Wisconsin | 55091 | 2001 | 18 |
2499526 | 2499526 | 2022-05-12 | Pepin | Wisconsin | 55091 | 1999 | 18 |
2496268 | 2496268 | 2022-05-11 | Pepin | Wisconsin | 55091 | 1996 | 18 |
2493010 | 2493010 | 2022-05-10 | Pepin | Wisconsin | 55091 | 1994 | 18 |
2489752 | 2489752 | 2022-05-09 | Pepin | Wisconsin | 55091 | 1991 | 18 |
2486495 | 2486495 | 2022-05-08 | Pepin | Wisconsin | 55091 | 1987 | 18 |
2483237 | 2483237 | 2022-05-07 | Pepin | Wisconsin | 55091 | 1987 | 18 |
2479979 | 2479979 | 2022-05-06 | Pepin | Wisconsin | 55091 | 1987 | 18 |
2476721 | 2476721 | 2022-05-05 | Pepin | Wisconsin | 55091 | 1987 | 18 |
2473463 | 2473463 | 2022-05-04 | Pepin | Wisconsin | 55091 | 1986 | 18 |
2470206 | 2470206 | 2022-05-03 | Pepin | Wisconsin | 55091 | 1984 | 18 |
2466950 | 2466950 | 2022-05-02 | Pepin | Wisconsin | 55091 | 1983 | 18 |
2463695 | 2463695 | 2022-05-01 | Pepin | Wisconsin | 55091 | 1979 | 18 |
2460439 | 2460439 | 2022-04-30 | Pepin | Wisconsin | 55091 | 1979 | 18 |
2457183 | 2457183 | 2022-04-29 | Pepin | Wisconsin | 55091 | 1979 | 18 |
2453927 | 2453927 | 2022-04-28 | Pepin | Wisconsin | 55091 | 1977 | 18 |
2450671 | 2450671 | 2022-04-27 | Pepin | Wisconsin | 55091 | 1977 | 18 |
2447415 | 2447415 | 2022-04-26 | Pepin | Wisconsin | 55091 | 1972 | 18 |
2444159 | 2444159 | 2022-04-25 | Pepin | Wisconsin | 55091 | 1972 | 18 |
2440903 | 2440903 | 2022-04-24 | Pepin | Wisconsin | 55091 | 1970 | 18 |
2437647 | 2437647 | 2022-04-23 | Pepin | Wisconsin | 55091 | 1970 | 18 |
2434391 | 2434391 | 2022-04-22 | Pepin | Wisconsin | 55091 | 1970 | 18 |
2431135 | 2431135 | 2022-04-21 | Pepin | Wisconsin | 55091 | 1970 | 18 |
2427879 | 2427879 | 2022-04-20 | Pepin | Wisconsin | 55091 | 1970 | 18 |
2424623 | 2424623 | 2022-04-19 | Pepin | Wisconsin | 55091 | 1968 | 18 |
2421367 | 2421367 | 2022-04-18 | Pepin | Wisconsin | 55091 | 1968 | 18 |
2418111 | 2418111 | 2022-04-17 | Pepin | Wisconsin | 55091 | 1968 | 18 |
2414855 | 2414855 | 2022-04-16 | Pepin | Wisconsin | 55091 | 1968 | 18 |
2411599 | 2411599 | 2022-04-15 | Pepin | Wisconsin | 55091 | 1968 | 18 |
2408343 | 2408343 | 2022-04-14 | Pepin | Wisconsin | 55091 | 1968 | 18 |
2405087 | 2405087 | 2022-04-13 | Pepin | Wisconsin | 55091 | 1967 | 18 |
2401832 | 2401832 | 2022-04-12 | Pepin | Wisconsin | 55091 | 1967 | 18 |
2398577 | 2398577 | 2022-04-11 | Pepin | Wisconsin | 55091 | 1967 | 18 |
2395322 | 2395322 | 2022-04-10 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2392066 | 2392066 | 2022-04-09 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2388810 | 2388810 | 2022-04-08 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2385555 | 2385555 | 2022-04-07 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2382300 | 2382300 | 2022-04-06 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2379045 | 2379045 | 2022-04-05 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2375791 | 2375791 | 2022-04-04 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2372539 | 2372539 | 2022-04-03 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2369286 | 2369286 | 2022-04-02 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2366033 | 2366033 | 2022-04-01 | Pepin | Wisconsin | 55091 | 1963 | 18 |
2362780 | 2362780 | 2022-03-31 | Pepin | Wisconsin | 55091 | 1962 | 18 |
2359526 | 2359526 | 2022-03-30 | Pepin | Wisconsin | 55091 | 1962 | 18 |
2356272 | 2356272 | 2022-03-29 | Pepin | Wisconsin | 55091 | 1962 | 18 |
2353019 | 2353019 | 2022-03-28 | Pepin | Wisconsin | 55091 | 1959 | 18 |
2349767 | 2349767 | 2022-03-27 | Pepin | Wisconsin | 55091 | 1954 | 18 |
2346514 | 2346514 | 2022-03-26 | Pepin | Wisconsin | 55091 | 1954 | 18 |
2343261 | 2343261 | 2022-03-25 | Pepin | Wisconsin | 55091 | 1954 | 18 |
2340008 | 2340008 | 2022-03-24 | Pepin | Wisconsin | 55091 | 1954 | 18 |
2336755 | 2336755 | 2022-03-23 | Pepin | Wisconsin | 55091 | 1953 | 18 |
2333501 | 2333501 | 2022-03-22 | Pepin | Wisconsin | 55091 | 1953 | 18 |
2330247 | 2330247 | 2022-03-21 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2326995 | 2326995 | 2022-03-20 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2323742 | 2323742 | 2022-03-19 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2320488 | 2320488 | 2022-03-18 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2317234 | 2317234 | 2022-03-17 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2313981 | 2313981 | 2022-03-16 | Pepin | Wisconsin | 55091 | 1949 | 18 |
2310728 | 2310728 | 2022-03-15 | Pepin | Wisconsin | 55091 | 1948 | 18 |
2307475 | 2307475 | 2022-03-14 | Pepin | Wisconsin | 55091 | 1948 | 18 |
2304224 | 2304224 | 2022-03-13 | Pepin | Wisconsin | 55091 | 1947 | 18 |
2300972 | 2300972 | 2022-03-12 | Pepin | Wisconsin | 55091 | 1947 | 18 |
2297720 | 2297720 | 2022-03-11 | Pepin | Wisconsin | 55091 | 1947 | 18 |
2294468 | 2294468 | 2022-03-10 | Pepin | Wisconsin | 55091 | 1947 | 18 |
2291216 | 2291216 | 2022-03-09 | Pepin | Wisconsin | 55091 | 1945 | 18 |
2287964 | 2287964 | 2022-03-08 | Pepin | Wisconsin | 55091 | 1945 | 18 |
2284712 | 2284712 | 2022-03-07 | Pepin | Wisconsin | 55091 | 1942 | 18 |
2281460 | 2281460 | 2022-03-06 | Pepin | Wisconsin | 55091 | 1942 | 18 |
2278207 | 2278207 | 2022-03-05 | Pepin | Wisconsin | 55091 | 1942 | 18 |
2274954 | 2274954 | 2022-03-04 | Pepin | Wisconsin | 55091 | 1942 | 18 |
2271701 | 2271701 | 2022-03-03 | Pepin | Wisconsin | 55091 | 1941 | 18 |
2268449 | 2268449 | 2022-03-02 | Pepin | Wisconsin | 55091 | 1940 | 18 |
2265196 | 2265196 | 2022-03-01 | Pepin | Wisconsin | 55091 | 1940 | 18 |
2261946 | 2261946 | 2022-02-28 | Pepin | Wisconsin | 55091 | 1940 | 18 |
2258695 | 2258695 | 2022-02-27 | Pepin | Wisconsin | 55091 | 1936 | 18 |
2255444 | 2255444 | 2022-02-26 | Pepin | Wisconsin | 55091 | 1936 | 18 |
2252193 | 2252193 | 2022-02-25 | Pepin | Wisconsin | 55091 | 1936 | 18 |
2248942 | 2248942 | 2022-02-24 | Pepin | Wisconsin | 55091 | 1935 | 18 |
2151354 | 2151354 | 2022-01-25 | Lafayette | Wisconsin | 55065 | 3360 | 18 |
2148102 | 2148102 | 2022-01-24 | Lafayette | Wisconsin | 55065 | 3333 | 18 |
2144850 | 2144850 | 2022-01-23 | Lafayette | Wisconsin | 55065 | 3279 | 18 |
2141595 | 2141595 | 2022-01-22 | Lafayette | Wisconsin | 55065 | 3279 | 18 |
2138339 | 2138339 | 2022-01-21 | Lafayette | Wisconsin | 55065 | 3279 | 18 |
2135084 | 2135084 | 2022-01-20 | Lafayette | Wisconsin | 55065 | 3246 | 18 |
2131832 | 2131832 | 2022-01-19 | Lafayette | Wisconsin | 55065 | 3198 | 18 |
2128578 | 2128578 | 2022-01-18 | Lafayette | Wisconsin | 55065 | 3170 | 18 |
2125325 | 2125325 | 2022-01-17 | Lafayette | Wisconsin | 55065 | 3131 | 18 |
2122073 | 2122073 | 2022-01-16 | Lafayette | Wisconsin | 55065 | 3063 | 18 |
2118821 | 2118821 | 2022-01-15 | Lafayette | Wisconsin | 55065 | 3063 | 18 |
2115569 | 2115569 | 2022-01-14 | Lafayette | Wisconsin | 55065 | 3063 | 18 |
2112317 | 2112317 | 2022-01-13 | Lafayette | Wisconsin | 55065 | 3001 | 18 |
2109065 | 2109065 | 2022-01-12 | Lafayette | Wisconsin | 55065 | 2961 | 18 |
2105814 | 2105814 | 2022-01-11 | Lafayette | Wisconsin | 55065 | 2909 | 18 |
2102563 | 2102563 | 2022-01-10 | Lafayette | Wisconsin | 55065 | 2883 | 18 |
2099312 | 2099312 | 2022-01-09 | Lafayette | Wisconsin | 55065 | 2815 | 18 |
2096061 | 2096061 | 2022-01-08 | Lafayette | Wisconsin | 55065 | 2815 | 18 |
2092809 | 2092809 | 2022-01-07 | Lafayette | Wisconsin | 55065 | 2815 | 18 |
2089557 | 2089557 | 2022-01-06 | Lafayette | Wisconsin | 55065 | 2788 | 18 |
2086306 | 2086306 | 2022-01-05 | Lafayette | Wisconsin | 55065 | 2763 | 18 |
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);