ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55,993 rows where state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 55025 617
- 55093 584
- 55039 582
- 55133 582
- 55079 580
- 55101 580
- 55117 580
- 55139 579
- 55087 577
- 55141 577
- 55059 576
- 55009 575
- 55063 575
- 55131 575
- 55007 574
- 55015 574
- 55021 574
- 55035 574
- 55089 574
- 55111 574
- 55127 574
- 55017 573
- 55031 573
- 55033 573
- 55045 573
- 55055 573
- 55073 573
- 55105 573
- 55109 573
- 55027 570
- …
county >30
- Dane 617
- Pierce 584
- Fond du Lac 582
- Waukesha 582
- Milwaukee 580
- Racine 580
- Sheboygan 580
- Winnebago 579
- Outagamie 577
- Wood 577
- Kenosha 576
- Brown 575
- La Crosse 575
- Washington 575
- Bayfield 574
- Calumet 574
- Columbia 574
- Eau Claire 574
- Ozaukee 574
- Sauk 574
- Walworth 574
- Chippewa 573
- Douglas 573
- Dunn 573
- Green 573
- Jefferson 573
- Marathon 573
- Rock 573
- St. Croix 573
- Dodge 570
- …
state 1
- Wisconsin · 40,729 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813271 | 1813271 | 2021-10-13 | Adams | Wisconsin | 55001 | 2672 | 33 |
1813272 | 1813272 | 2021-10-13 | Ashland | Wisconsin | 55003 | 1770 | 16 |
1813273 | 1813273 | 2021-10-13 | Barron | Wisconsin | 55005 | 8097 | 91 |
1813274 | 1813274 | 2021-10-13 | Bayfield | Wisconsin | 55007 | 1577 | 24 |
1813275 | 1813275 | 2021-10-13 | Brown | Wisconsin | 55009 | 44073 | 315 |
1813276 | 1813276 | 2021-10-13 | Buffalo | Wisconsin | 55011 | 1875 | 8 |
1813277 | 1813277 | 2021-10-13 | Burnett | Wisconsin | 55013 | 2106 | 30 |
1813278 | 1813278 | 2021-10-13 | Calumet | Wisconsin | 55015 | 8012 | 59 |
1813279 | 1813279 | 2021-10-13 | Chippewa | Wisconsin | 55017 | 10527 | 114 |
1813280 | 1813280 | 2021-10-13 | Clark | Wisconsin | 55019 | 4651 | 76 |
1813281 | 1813281 | 2021-10-13 | Columbia | Wisconsin | 55021 | 7668 | 78 |
1813282 | 1813282 | 2021-10-13 | Crawford | Wisconsin | 55023 | 2218 | 22 |
1813283 | 1813283 | 2021-10-13 | Dane | Wisconsin | 55025 | 56459 | 363 |
1813284 | 1813284 | 2021-10-13 | Dodge | Wisconsin | 55027 | 15615 | 223 |
1813285 | 1813285 | 2021-10-13 | Door | Wisconsin | 55029 | 3626 | 38 |
1813286 | 1813286 | 2021-10-13 | Douglas | Wisconsin | 55031 | 5766 | 66 |
1813287 | 1813287 | 2021-10-13 | Dunn | Wisconsin | 55033 | 6781 | 44 |
1813288 | 1813288 | 2021-10-13 | Eau Claire | Wisconsin | 55035 | 15602 | 136 |
1813289 | 1813289 | 2021-10-13 | Florence | Wisconsin | 55037 | 600 | 13 |
1813290 | 1813290 | 2021-10-13 | Fond du Lac | Wisconsin | 55039 | 17482 | 155 |
1813291 | 1813291 | 2021-10-13 | Forest | Wisconsin | 55041 | 1465 | 31 |
1813292 | 1813292 | 2021-10-13 | Grant | Wisconsin | 55043 | 7333 | 111 |
1813293 | 1813293 | 2021-10-13 | Green | Wisconsin | 55045 | 4418 | 29 |
1813294 | 1813294 | 2021-10-13 | Green Lake | Wisconsin | 55047 | 2940 | 30 |
1813295 | 1813295 | 2021-10-13 | Iowa | Wisconsin | 55049 | 2662 | 16 |
1813296 | 1813296 | 2021-10-13 | Iron | Wisconsin | 55051 | 845 | 42 |
1813297 | 1813297 | 2021-10-13 | Jackson | Wisconsin | 55053 | 3255 | 31 |
1813298 | 1813298 | 2021-10-13 | Jefferson | Wisconsin | 55055 | 11545 | 148 |
1813299 | 1813299 | 2021-10-13 | Juneau | Wisconsin | 55057 | 4078 | 34 |
1813300 | 1813300 | 2021-10-13 | Kenosha | Wisconsin | 55059 | 23438 | 372 |
1813301 | 1813301 | 2021-10-13 | Kewaunee | Wisconsin | 55061 | 3460 | 41 |
1813302 | 1813302 | 2021-10-13 | La Crosse | Wisconsin | 55063 | 16838 | 109 |
1813303 | 1813303 | 2021-10-13 | Lafayette | Wisconsin | 55065 | 2043 | 12 |
1813304 | 1813304 | 2021-10-13 | Langlade | Wisconsin | 55067 | 3024 | 54 |
1813305 | 1813305 | 2021-10-13 | Lincoln | Wisconsin | 55069 | 4169 | 106 |
1813306 | 1813306 | 2021-10-13 | Manitowoc | Wisconsin | 55071 | 11147 | 105 |
1813307 | 1813307 | 2021-10-13 | Marathon | Wisconsin | 55073 | 20269 | 258 |
1813308 | 1813308 | 2021-10-13 | Marinette | Wisconsin | 55075 | 6353 | 78 |
1813309 | 1813309 | 2021-10-13 | Marquette | Wisconsin | 55077 | 2173 | 32 |
1813310 | 1813310 | 2021-10-13 | Menominee | Wisconsin | 55078 | 928 | 11 |
1813311 | 1813311 | 2021-10-13 | Milwaukee | Wisconsin | 55079 | 147759 | 1587 |
1813312 | 1813312 | 2021-10-13 | Monroe | Wisconsin | 55081 | 6161 | 54 |
1813313 | 1813313 | 2021-10-13 | Oconto | Wisconsin | 55083 | 6946 | 76 |
1813314 | 1813314 | 2021-10-13 | Oneida | Wisconsin | 55085 | 4751 | 87 |
1813315 | 1813315 | 2021-10-13 | Outagamie | Wisconsin | 55087 | 29390 | 267 |
1813316 | 1813316 | 2021-10-13 | Ozaukee | Wisconsin | 55089 | 11995 | 114 |
1813317 | 1813317 | 2021-10-13 | Pepin | Wisconsin | 55091 | 1135 | 10 |
1813318 | 1813318 | 2021-10-13 | Pierce | Wisconsin | 55093 | 6094 | 45 |
1813319 | 1813319 | 2021-10-13 | Polk | Wisconsin | 55095 | 6533 | 79 |
1813320 | 1813320 | 2021-10-13 | Portage | Wisconsin | 55097 | 9230 | 93 |
1813321 | 1813321 | 2021-10-13 | Price | Wisconsin | 55099 | 1731 | 9 |
1813322 | 1813322 | 2021-10-13 | Racine | Wisconsin | 55101 | 30981 | 443 |
1813323 | 1813323 | 2021-10-13 | Richland | Wisconsin | 55103 | 2043 | 22 |
1813324 | 1813324 | 2021-10-13 | Rock | Wisconsin | 55105 | 21806 | 242 |
1813325 | 1813325 | 2021-10-13 | Rusk | Wisconsin | 55107 | 2111 | 33 |
1813326 | 1813326 | 2021-10-13 | Sauk | Wisconsin | 55111 | 8059 | 64 |
1813327 | 1813327 | 2021-10-13 | Sawyer | Wisconsin | 55113 | 2406 | 31 |
1813328 | 1813328 | 2021-10-13 | Shawano | Wisconsin | 55115 | 6794 | 90 |
1813329 | 1813329 | 2021-10-13 | Sheboygan | Wisconsin | 55117 | 17644 | 186 |
1813330 | 1813330 | 2021-10-13 | St. Croix | Wisconsin | 55109 | 12386 | 83 |
1813331 | 1813331 | 2021-10-13 | Taylor | Wisconsin | 55119 | 2867 | 44 |
1813332 | 1813332 | 2021-10-13 | Trempealeau | Wisconsin | 55121 | 4786 | 52 |
1813333 | 1813333 | 2021-10-13 | Vernon | Wisconsin | 55123 | 2766 | 55 |
1813334 | 1813334 | 2021-10-13 | Vilas | Wisconsin | 55125 | 2962 | 52 |
1813335 | 1813335 | 2021-10-13 | Walworth | Wisconsin | 55127 | 15289 | 187 |
1813336 | 1813336 | 2021-10-13 | Washburn | Wisconsin | 55129 | 2108 | 26 |
1813337 | 1813337 | 2021-10-13 | Washington | Wisconsin | 55131 | 21726 | 218 |
1813338 | 1813338 | 2021-10-13 | Waukesha | Wisconsin | 55133 | 60947 | 706 |
1813339 | 1813339 | 2021-10-13 | Waupaca | Wisconsin | 55135 | 7888 | 181 |
1813340 | 1813340 | 2021-10-13 | Waushara | Wisconsin | 55137 | 3532 | 50 |
1813341 | 1813341 | 2021-10-13 | Winnebago | Wisconsin | 55139 | 26589 | 252 |
1813342 | 1813342 | 2021-10-13 | Wood | Wisconsin | 55141 | 10205 | 132 |
1810022 | 1810022 | 2021-10-12 | Adams | Wisconsin | 55001 | 2661 | 33 |
1810023 | 1810023 | 2021-10-12 | Ashland | Wisconsin | 55003 | 1769 | 16 |
1810024 | 1810024 | 2021-10-12 | Barron | Wisconsin | 55005 | 8061 | 91 |
1810025 | 1810025 | 2021-10-12 | Bayfield | Wisconsin | 55007 | 1568 | 24 |
1810026 | 1810026 | 2021-10-12 | Brown | Wisconsin | 55009 | 43753 | 315 |
1810027 | 1810027 | 2021-10-12 | Buffalo | Wisconsin | 55011 | 1870 | 7 |
1810028 | 1810028 | 2021-10-12 | Burnett | Wisconsin | 55013 | 2094 | 30 |
1810029 | 1810029 | 2021-10-12 | Calumet | Wisconsin | 55015 | 7985 | 59 |
1810030 | 1810030 | 2021-10-12 | Chippewa | Wisconsin | 55017 | 10488 | 114 |
1810031 | 1810031 | 2021-10-12 | Clark | Wisconsin | 55019 | 4636 | 76 |
1810032 | 1810032 | 2021-10-12 | Columbia | Wisconsin | 55021 | 7645 | 78 |
1810033 | 1810033 | 2021-10-12 | Crawford | Wisconsin | 55023 | 2201 | 22 |
1810034 | 1810034 | 2021-10-12 | Dane | Wisconsin | 55025 | 56343 | 363 |
1810035 | 1810035 | 2021-10-12 | Dodge | Wisconsin | 55027 | 15591 | 223 |
1810036 | 1810036 | 2021-10-12 | Door | Wisconsin | 55029 | 3617 | 38 |
1810037 | 1810037 | 2021-10-12 | Douglas | Wisconsin | 55031 | 5737 | 66 |
1810038 | 1810038 | 2021-10-12 | Dunn | Wisconsin | 55033 | 6734 | 44 |
1810039 | 1810039 | 2021-10-12 | Eau Claire | Wisconsin | 55035 | 15547 | 136 |
1810040 | 1810040 | 2021-10-12 | Florence | Wisconsin | 55037 | 592 | 13 |
1810041 | 1810041 | 2021-10-12 | Fond du Lac | Wisconsin | 55039 | 17397 | 155 |
1810042 | 1810042 | 2021-10-12 | Forest | Wisconsin | 55041 | 1458 | 31 |
1810043 | 1810043 | 2021-10-12 | Grant | Wisconsin | 55043 | 7295 | 109 |
1810044 | 1810044 | 2021-10-12 | Green | Wisconsin | 55045 | 4402 | 29 |
1810045 | 1810045 | 2021-10-12 | Green Lake | Wisconsin | 55047 | 2929 | 30 |
1810046 | 1810046 | 2021-10-12 | Iowa | Wisconsin | 55049 | 2655 | 16 |
1810047 | 1810047 | 2021-10-12 | Iron | Wisconsin | 55051 | 844 | 42 |
1810048 | 1810048 | 2021-10-12 | Jackson | Wisconsin | 55053 | 3249 | 31 |
1810049 | 1810049 | 2021-10-12 | Jefferson | Wisconsin | 55055 | 11502 | 148 |
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);