ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
314 rows where deaths = 48 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Trempealeau 48
- Richland 32
- Polk 26
- Green 17
- Dunn 16
- Monroe 16
- Kewaunee 15
- Vilas 14
- Adams 13
- Marquette 13
- Waushara 12
- Portage 7
- Sauk 7
- Jefferson 6
- Ozaukee 6
- Rock 6
- Taylor 6
- Clark 5
- Juneau 5
- Vernon 5
- Green Lake 4
- Pierce 4
- St. Croix 4
- Walworth 4
- Langlade 3
- Oconto 3
- Outagamie 3
- Dane 2
- Marathon 2
- Shawano 2
- …
state 1
- Wisconsin · 314 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502790 | 2502790 | 2022-05-13 | Richland | Wisconsin | 55103 | 3995 | 48 |
2499532 | 2499532 | 2022-05-12 | Richland | Wisconsin | 55103 | 3988 | 48 |
2496274 | 2496274 | 2022-05-11 | Richland | Wisconsin | 55103 | 3976 | 48 |
2493016 | 2493016 | 2022-05-10 | Richland | Wisconsin | 55103 | 3969 | 48 |
2489758 | 2489758 | 2022-05-09 | Richland | Wisconsin | 55103 | 3965 | 48 |
2486501 | 2486501 | 2022-05-08 | Richland | Wisconsin | 55103 | 3957 | 48 |
2483243 | 2483243 | 2022-05-07 | Richland | Wisconsin | 55103 | 3957 | 48 |
2479985 | 2479985 | 2022-05-06 | Richland | Wisconsin | 55103 | 3957 | 48 |
2476727 | 2476727 | 2022-05-05 | Richland | Wisconsin | 55103 | 3951 | 48 |
2473469 | 2473469 | 2022-05-04 | Richland | Wisconsin | 55103 | 3949 | 48 |
2470212 | 2470212 | 2022-05-03 | Richland | Wisconsin | 55103 | 3937 | 48 |
2466956 | 2466956 | 2022-05-02 | Richland | Wisconsin | 55103 | 3935 | 48 |
2463701 | 2463701 | 2022-05-01 | Richland | Wisconsin | 55103 | 3921 | 48 |
2460445 | 2460445 | 2022-04-30 | Richland | Wisconsin | 55103 | 3921 | 48 |
2457189 | 2457189 | 2022-04-29 | Richland | Wisconsin | 55103 | 3921 | 48 |
2453933 | 2453933 | 2022-04-28 | Richland | Wisconsin | 55103 | 3908 | 48 |
2450677 | 2450677 | 2022-04-27 | Richland | Wisconsin | 55103 | 3905 | 48 |
2447421 | 2447421 | 2022-04-26 | Richland | Wisconsin | 55103 | 3898 | 48 |
2444165 | 2444165 | 2022-04-25 | Richland | Wisconsin | 55103 | 3890 | 48 |
2440909 | 2440909 | 2022-04-24 | Richland | Wisconsin | 55103 | 3882 | 48 |
2437653 | 2437653 | 2022-04-23 | Richland | Wisconsin | 55103 | 3882 | 48 |
2434397 | 2434397 | 2022-04-22 | Richland | Wisconsin | 55103 | 3882 | 48 |
2431141 | 2431141 | 2022-04-21 | Richland | Wisconsin | 55103 | 3876 | 48 |
2427885 | 2427885 | 2022-04-20 | Richland | Wisconsin | 55103 | 3872 | 48 |
2424629 | 2424629 | 2022-04-19 | Richland | Wisconsin | 55103 | 3865 | 48 |
2421373 | 2421373 | 2022-04-18 | Richland | Wisconsin | 55103 | 3865 | 48 |
2418117 | 2418117 | 2022-04-17 | Richland | Wisconsin | 55103 | 3863 | 48 |
2414861 | 2414861 | 2022-04-16 | Richland | Wisconsin | 55103 | 3863 | 48 |
2411605 | 2411605 | 2022-04-15 | Richland | Wisconsin | 55103 | 3863 | 48 |
2408349 | 2408349 | 2022-04-14 | Richland | Wisconsin | 55103 | 3861 | 48 |
2405093 | 2405093 | 2022-04-13 | Richland | Wisconsin | 55103 | 3859 | 48 |
2401838 | 2401838 | 2022-04-12 | Richland | Wisconsin | 55103 | 3857 | 48 |
2222888 | 2222888 | 2022-02-16 | Adams | Wisconsin | 55001 | 4560 | 48 |
2222942 | 2222942 | 2022-02-16 | Rusk | Wisconsin | 55107 | 3382 | 48 |
2219637 | 2219637 | 2022-02-15 | Adams | Wisconsin | 55001 | 4551 | 48 |
2216387 | 2216387 | 2022-02-14 | Adams | Wisconsin | 55001 | 4548 | 48 |
2216425 | 2216425 | 2022-02-14 | Marquette | Wisconsin | 55077 | 3738 | 48 |
2213136 | 2213136 | 2022-02-13 | Adams | Wisconsin | 55001 | 4529 | 48 |
2213174 | 2213174 | 2022-02-13 | Marquette | Wisconsin | 55077 | 3728 | 48 |
2209883 | 2209883 | 2022-02-12 | Adams | Wisconsin | 55001 | 4529 | 48 |
2209921 | 2209921 | 2022-02-12 | Marquette | Wisconsin | 55077 | 3728 | 48 |
2206630 | 2206630 | 2022-02-11 | Adams | Wisconsin | 55001 | 4529 | 48 |
2206668 | 2206668 | 2022-02-11 | Marquette | Wisconsin | 55077 | 3728 | 48 |
2203377 | 2203377 | 2022-02-10 | Adams | Wisconsin | 55001 | 4525 | 48 |
2203415 | 2203415 | 2022-02-10 | Marquette | Wisconsin | 55077 | 3722 | 48 |
2200123 | 2200123 | 2022-02-09 | Adams | Wisconsin | 55001 | 4519 | 48 |
2200161 | 2200161 | 2022-02-09 | Marquette | Wisconsin | 55077 | 3717 | 48 |
2196869 | 2196869 | 2022-02-08 | Adams | Wisconsin | 55001 | 4503 | 48 |
2196907 | 2196907 | 2022-02-08 | Marquette | Wisconsin | 55077 | 3708 | 48 |
2193614 | 2193614 | 2022-02-07 | Adams | Wisconsin | 55001 | 4501 | 48 |
2193652 | 2193652 | 2022-02-07 | Marquette | Wisconsin | 55077 | 3705 | 48 |
2190361 | 2190361 | 2022-02-06 | Adams | Wisconsin | 55001 | 4482 | 48 |
2190399 | 2190399 | 2022-02-06 | Marquette | Wisconsin | 55077 | 3675 | 48 |
2187108 | 2187108 | 2022-02-05 | Adams | Wisconsin | 55001 | 4482 | 48 |
2187146 | 2187146 | 2022-02-05 | Marquette | Wisconsin | 55077 | 3675 | 48 |
2183855 | 2183855 | 2022-02-04 | Adams | Wisconsin | 55001 | 4482 | 48 |
2183893 | 2183893 | 2022-02-04 | Marquette | Wisconsin | 55077 | 3675 | 48 |
2180625 | 2180625 | 2022-02-03 | Green | Wisconsin | 55045 | 8554 | 48 |
2180641 | 2180641 | 2022-02-03 | Marquette | Wisconsin | 55077 | 3667 | 48 |
2177374 | 2177374 | 2022-02-02 | Green | Wisconsin | 55045 | 8510 | 48 |
2177390 | 2177390 | 2022-02-02 | Marquette | Wisconsin | 55077 | 3651 | 48 |
2174121 | 2174121 | 2022-02-01 | Green | Wisconsin | 55045 | 8469 | 48 |
2170869 | 2170869 | 2022-01-31 | Green | Wisconsin | 55045 | 8455 | 48 |
2167616 | 2167616 | 2022-01-30 | Green | Wisconsin | 55045 | 8354 | 48 |
2164361 | 2164361 | 2022-01-29 | Green | Wisconsin | 55045 | 8354 | 48 |
2161106 | 2161106 | 2022-01-28 | Green | Wisconsin | 55045 | 8354 | 48 |
2157850 | 2157850 | 2022-01-27 | Green | Wisconsin | 55045 | 8309 | 48 |
2154597 | 2154597 | 2022-01-26 | Green | Wisconsin | 55045 | 8243 | 48 |
2151344 | 2151344 | 2022-01-25 | Green | Wisconsin | 55045 | 8177 | 48 |
2148092 | 2148092 | 2022-01-24 | Green | Wisconsin | 55045 | 8130 | 48 |
2144840 | 2144840 | 2022-01-23 | Green | Wisconsin | 55045 | 7951 | 48 |
2141585 | 2141585 | 2022-01-22 | Green | Wisconsin | 55045 | 7951 | 48 |
2138329 | 2138329 | 2022-01-21 | Green | Wisconsin | 55045 | 7951 | 48 |
2135074 | 2135074 | 2022-01-20 | Green | Wisconsin | 55045 | 7840 | 48 |
2131822 | 2131822 | 2022-01-19 | Green | Wisconsin | 55045 | 7699 | 48 |
2128568 | 2128568 | 2022-01-18 | Green | Wisconsin | 55045 | 7598 | 48 |
2063571 | 2063571 | 2021-12-29 | Sawyer | Wisconsin | 55113 | 3441 | 48 |
2057039 | 2057039 | 2021-12-27 | Green Lake | Wisconsin | 55047 | 3722 | 48 |
2053790 | 2053790 | 2021-12-26 | Green Lake | Wisconsin | 55047 | 3722 | 48 |
2050540 | 2050540 | 2021-12-25 | Green Lake | Wisconsin | 55047 | 3722 | 48 |
2047290 | 2047290 | 2021-12-24 | Green Lake | Wisconsin | 55047 | 3722 | 48 |
2034296 | 2034296 | 2021-12-20 | Juneau | Wisconsin | 55057 | 5421 | 48 |
2031046 | 2031046 | 2021-12-19 | Juneau | Wisconsin | 55057 | 5389 | 48 |
2027795 | 2027795 | 2021-12-18 | Juneau | Wisconsin | 55057 | 5389 | 48 |
2024544 | 2024544 | 2021-12-17 | Juneau | Wisconsin | 55057 | 5389 | 48 |
2021293 | 2021293 | 2021-12-16 | Juneau | Wisconsin | 55057 | 5371 | 48 |
1969288 | 1969288 | 2021-11-30 | Kewaunee | Wisconsin | 55061 | 4060 | 48 |
1966038 | 1966038 | 2021-11-29 | Kewaunee | Wisconsin | 55061 | 4009 | 48 |
1966068 | 1966068 | 2021-11-29 | Taylor | Wisconsin | 55119 | 3456 | 48 |
1962786 | 1962786 | 2021-11-28 | Kewaunee | Wisconsin | 55061 | 3982 | 48 |
1962816 | 1962816 | 2021-11-28 | Taylor | Wisconsin | 55119 | 3418 | 48 |
1959535 | 1959535 | 2021-11-27 | Kewaunee | Wisconsin | 55061 | 3982 | 48 |
1959565 | 1959565 | 2021-11-27 | Taylor | Wisconsin | 55119 | 3418 | 48 |
1956284 | 1956284 | 2021-11-26 | Kewaunee | Wisconsin | 55061 | 3982 | 48 |
1956314 | 1956314 | 2021-11-26 | Taylor | Wisconsin | 55119 | 3418 | 48 |
1953033 | 1953033 | 2021-11-25 | Kewaunee | Wisconsin | 55061 | 3982 | 48 |
1953063 | 1953063 | 2021-11-25 | Taylor | Wisconsin | 55119 | 3418 | 48 |
1949782 | 1949782 | 2021-11-24 | Kewaunee | Wisconsin | 55061 | 3969 | 48 |
1949812 | 1949812 | 2021-11-24 | Taylor | Wisconsin | 55119 | 3399 | 48 |
1946517 | 1946517 | 2021-11-23 | Dunn | Wisconsin | 55033 | 8083 | 48 |
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);