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 827
- 55093 794
- 55039 792
- 55133 792
- 55079 790
- 55101 790
- 55117 790
- 55139 789
- 55087 787
- 55141 787
- 55059 786
- 55009 785
- 55063 785
- 55131 785
- 55007 784
- 55015 784
- 55021 784
- 55035 784
- 55089 784
- 55111 784
- 55127 784
- 55017 783
- 55031 783
- 55033 783
- 55045 783
- 55055 783
- 55073 783
- 55105 783
- 55109 783
- 55027 780
- …
county >30
- Dane 827
- Pierce 794
- Fond du Lac 792
- Waukesha 792
- Milwaukee 790
- Racine 790
- Sheboygan 790
- Winnebago 789
- Outagamie 787
- Wood 787
- Kenosha 786
- Brown 785
- La Crosse 785
- Washington 785
- Bayfield 784
- Calumet 784
- Columbia 784
- Eau Claire 784
- Ozaukee 784
- Sauk 784
- Walworth 784
- Chippewa 783
- Douglas 783
- Dunn 783
- Green 783
- Jefferson 783
- Marathon 783
- Rock 783
- St. Croix 783
- Dodge 780
- …
state 1
- Wisconsin · 55,849 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496222 | 2496222 | 2022-05-11 | Adams | Wisconsin | 55001 | 4717 | 61 |
2496223 | 2496223 | 2022-05-11 | Ashland | Wisconsin | 55003 | 3348 | 36 |
2496224 | 2496224 | 2022-05-11 | Barron | Wisconsin | 55005 | 13722 | 144 |
2496225 | 2496225 | 2022-05-11 | Bayfield | Wisconsin | 55007 | 3409 | 41 |
2496226 | 2496226 | 2022-05-11 | Brown | Wisconsin | 55009 | 85472 | 556 |
2496227 | 2496227 | 2022-05-11 | Buffalo | Wisconsin | 55011 | 3598 | 12 |
2496228 | 2496228 | 2022-05-11 | Burnett | Wisconsin | 55013 | 4047 | 43 |
2496229 | 2496229 | 2022-05-11 | Calumet | Wisconsin | 55015 | 14723 | 121 |
2496230 | 2496230 | 2022-05-11 | Chippewa | Wisconsin | 55017 | 19057 | 187 |
2496231 | 2496231 | 2022-05-11 | Clark | Wisconsin | 55019 | 7680 | 122 |
2496232 | 2496232 | 2022-05-11 | Columbia | Wisconsin | 55021 | 15753 | 127 |
2496233 | 2496233 | 2022-05-11 | Crawford | Wisconsin | 55023 | 4286 | 28 |
2496234 | 2496234 | 2022-05-11 | Dane | Wisconsin | 55025 | 133471 | 515 |
2496235 | 2496235 | 2022-05-11 | Dodge | Wisconsin | 55027 | 27516 | 339 |
2496236 | 2496236 | 2022-05-11 | Door | Wisconsin | 55029 | 7072 | 71 |
2496237 | 2496237 | 2022-05-11 | Douglas | Wisconsin | 55031 | 11930 | 79 |
2496238 | 2496238 | 2022-05-11 | Dunn | Wisconsin | 55033 | 13583 | 75 |
2496239 | 2496239 | 2022-05-11 | Eau Claire | Wisconsin | 55035 | 31192 | 187 |
2496240 | 2496240 | 2022-05-11 | Florence | Wisconsin | 55037 | 1090 | 17 |
2496241 | 2496241 | 2022-05-11 | Fond du Lac | Wisconsin | 55039 | 32418 | 277 |
2496242 | 2496242 | 2022-05-11 | Forest | Wisconsin | 55041 | 2688 | 52 |
2496243 | 2496243 | 2022-05-11 | Grant | Wisconsin | 55043 | 12913 | 146 |
2496244 | 2496244 | 2022-05-11 | Green | Wisconsin | 55045 | 9483 | 54 |
2496245 | 2496245 | 2022-05-11 | Green Lake | Wisconsin | 55047 | 5248 | 64 |
2496246 | 2496246 | 2022-05-11 | Iowa | Wisconsin | 55049 | 5406 | 29 |
2496247 | 2496247 | 2022-05-11 | Iron | Wisconsin | 55051 | 1480 | 47 |
2496248 | 2496248 | 2022-05-11 | Jackson | Wisconsin | 55053 | 5726 | 43 |
2496249 | 2496249 | 2022-05-11 | Jefferson | Wisconsin | 55055 | 21943 | 243 |
2496250 | 2496250 | 2022-05-11 | Juneau | Wisconsin | 55057 | 7823 | 68 |
2496251 | 2496251 | 2022-05-11 | Kenosha | Wisconsin | 55059 | 45128 | 631 |
2496252 | 2496252 | 2022-05-11 | Kewaunee | Wisconsin | 55061 | 5921 | 59 |
2496253 | 2496253 | 2022-05-11 | La Crosse | Wisconsin | 55063 | 35861 | 186 |
2496254 | 2496254 | 2022-05-11 | Lafayette | Wisconsin | 55065 | 3720 | 26 |
2496255 | 2496255 | 2022-05-11 | Langlade | Wisconsin | 55067 | 5279 | 92 |
2496256 | 2496256 | 2022-05-11 | Lincoln | Wisconsin | 55069 | 7156 | 148 |
2496257 | 2496257 | 2022-05-11 | Manitowoc | Wisconsin | 55071 | 20754 | 189 |
2496258 | 2496258 | 2022-05-11 | Marathon | Wisconsin | 55073 | 40201 | 491 |
2496259 | 2496259 | 2022-05-11 | Marinette | Wisconsin | 55075 | 11731 | 126 |
2496260 | 2496260 | 2022-05-11 | Marquette | Wisconsin | 55077 | 3863 | 61 |
2496261 | 2496261 | 2022-05-11 | Menominee | Wisconsin | 55078 | 1976 | 14 |
2496262 | 2496262 | 2022-05-11 | Milwaukee | Wisconsin | 55079 | 276490 | 2290 |
2496263 | 2496263 | 2022-05-11 | Monroe | Wisconsin | 55081 | 12271 | 91 |
2496264 | 2496264 | 2022-05-11 | Oconto | Wisconsin | 55083 | 11506 | 120 |
2496265 | 2496265 | 2022-05-11 | Oneida | Wisconsin | 55085 | 8591 | 139 |
2496266 | 2496266 | 2022-05-11 | Outagamie | Wisconsin | 55087 | 55191 | 406 |
2496267 | 2496267 | 2022-05-11 | Ozaukee | Wisconsin | 55089 | 23042 | 186 |
2496268 | 2496268 | 2022-05-11 | Pepin | Wisconsin | 55091 | 1996 | 18 |
2496269 | 2496269 | 2022-05-11 | Pierce | Wisconsin | 55093 | 11842 | 73 |
2496270 | 2496270 | 2022-05-11 | Polk | Wisconsin | 55095 | 12659 | 122 |
2496271 | 2496271 | 2022-05-11 | Portage | Wisconsin | 55097 | 18415 | 161 |
2496272 | 2496272 | 2022-05-11 | Price | Wisconsin | 55099 | 3279 | 33 |
2496273 | 2496273 | 2022-05-11 | Racine | Wisconsin | 55101 | 57484 | 690 |
2496274 | 2496274 | 2022-05-11 | Richland | Wisconsin | 55103 | 3976 | 48 |
2496275 | 2496275 | 2022-05-11 | Rock | Wisconsin | 55105 | 44131 | 395 |
2496276 | 2496276 | 2022-05-11 | Rusk | Wisconsin | 55107 | 3460 | 55 |
2496277 | 2496277 | 2022-05-11 | Sauk | Wisconsin | 55111 | 16421 | 136 |
2496278 | 2496278 | 2022-05-11 | Sawyer | Wisconsin | 55113 | 4621 | 62 |
2496279 | 2496279 | 2022-05-11 | Shawano | Wisconsin | 55115 | 11950 | 152 |
2496280 | 2496280 | 2022-05-11 | Sheboygan | Wisconsin | 55117 | 33000 | 320 |
2496281 | 2496281 | 2022-05-11 | St. Croix | Wisconsin | 55109 | 25553 | 149 |
2496282 | 2496282 | 2022-05-11 | Taylor | Wisconsin | 55119 | 4879 | 72 |
2496283 | 2496283 | 2022-05-11 | Trempealeau | Wisconsin | 55121 | 8532 | 65 |
2496284 | 2496284 | 2022-05-11 | Vernon | Wisconsin | 55123 | 6231 | 98 |
2496285 | 2496285 | 2022-05-11 | Vilas | Wisconsin | 55125 | 5262 | 89 |
2496286 | 2496286 | 2022-05-11 | Walworth | Wisconsin | 55127 | 27254 | 280 |
2496287 | 2496287 | 2022-05-11 | Washburn | Wisconsin | 55129 | 4068 | 46 |
2496288 | 2496288 | 2022-05-11 | Washington | Wisconsin | 55131 | 38864 | 342 |
2496289 | 2496289 | 2022-05-11 | Waukesha | Wisconsin | 55133 | 115411 | 1093 |
2496290 | 2496290 | 2022-05-11 | Waupaca | Wisconsin | 55135 | 13786 | 252 |
2496291 | 2496291 | 2022-05-11 | Waushara | Wisconsin | 55137 | 6499 | 87 |
2496292 | 2496292 | 2022-05-11 | Winnebago | Wisconsin | 55139 | 52898 | 381 |
2496293 | 2496293 | 2022-05-11 | Wood | Wisconsin | 55141 | 21401 | 233 |
2492964 | 2492964 | 2022-05-10 | Adams | Wisconsin | 55001 | 4706 | 61 |
2492965 | 2492965 | 2022-05-10 | Ashland | Wisconsin | 55003 | 3340 | 36 |
2492966 | 2492966 | 2022-05-10 | Barron | Wisconsin | 55005 | 13704 | 144 |
2492967 | 2492967 | 2022-05-10 | Bayfield | Wisconsin | 55007 | 3402 | 41 |
2492968 | 2492968 | 2022-05-10 | Brown | Wisconsin | 55009 | 85368 | 556 |
2492969 | 2492969 | 2022-05-10 | Buffalo | Wisconsin | 55011 | 3592 | 12 |
2492970 | 2492970 | 2022-05-10 | Burnett | Wisconsin | 55013 | 4038 | 43 |
2492971 | 2492971 | 2022-05-10 | Calumet | Wisconsin | 55015 | 14717 | 121 |
2492972 | 2492972 | 2022-05-10 | Chippewa | Wisconsin | 55017 | 19035 | 187 |
2492973 | 2492973 | 2022-05-10 | Clark | Wisconsin | 55019 | 7678 | 122 |
2492974 | 2492974 | 2022-05-10 | Columbia | Wisconsin | 55021 | 15722 | 128 |
2492975 | 2492975 | 2022-05-10 | Crawford | Wisconsin | 55023 | 4281 | 28 |
2492976 | 2492976 | 2022-05-10 | Dane | Wisconsin | 55025 | 133070 | 515 |
2492977 | 2492977 | 2022-05-10 | Dodge | Wisconsin | 55027 | 27493 | 339 |
2492978 | 2492978 | 2022-05-10 | Door | Wisconsin | 55029 | 7064 | 71 |
2492979 | 2492979 | 2022-05-10 | Douglas | Wisconsin | 55031 | 11891 | 79 |
2492980 | 2492980 | 2022-05-10 | Dunn | Wisconsin | 55033 | 13570 | 75 |
2492981 | 2492981 | 2022-05-10 | Eau Claire | Wisconsin | 55035 | 31132 | 187 |
2492982 | 2492982 | 2022-05-10 | Florence | Wisconsin | 55037 | 1090 | 17 |
2492983 | 2492983 | 2022-05-10 | Fond du Lac | Wisconsin | 55039 | 32372 | 277 |
2492984 | 2492984 | 2022-05-10 | Forest | Wisconsin | 55041 | 2686 | 52 |
2492985 | 2492985 | 2022-05-10 | Grant | Wisconsin | 55043 | 12896 | 145 |
2492986 | 2492986 | 2022-05-10 | Green | Wisconsin | 55045 | 9469 | 54 |
2492987 | 2492987 | 2022-05-10 | Green Lake | Wisconsin | 55047 | 5236 | 63 |
2492988 | 2492988 | 2022-05-10 | Iowa | Wisconsin | 55049 | 5394 | 28 |
2492989 | 2492989 | 2022-05-10 | Iron | Wisconsin | 55051 | 1481 | 47 |
2492990 | 2492990 | 2022-05-10 | Jackson | Wisconsin | 55053 | 5719 | 43 |
2492991 | 2492991 | 2022-05-10 | Jefferson | Wisconsin | 55055 | 21923 | 242 |
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);