ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where "date" is on date 2022-03-29 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2356226 | 2356226 | 2022-03-29 | Adams | Wisconsin | 55001 | 4626 | 61 |
2356227 | 2356227 | 2022-03-29 | Ashland | Wisconsin | 55003 | 3274 | 36 |
2356228 | 2356228 | 2022-03-29 | Barron | Wisconsin | 55005 | 13428 | 142 |
2356229 | 2356229 | 2022-03-29 | Bayfield | Wisconsin | 55007 | 3270 | 39 |
2356230 | 2356230 | 2022-03-29 | Brown | Wisconsin | 55009 | 83812 | 543 |
2356231 | 2356231 | 2022-03-29 | Buffalo | Wisconsin | 55011 | 3452 | 12 |
2356232 | 2356232 | 2022-03-29 | Burnett | Wisconsin | 55013 | 3960 | 43 |
2356233 | 2356233 | 2022-03-29 | Calumet | Wisconsin | 55015 | 14459 | 121 |
2356234 | 2356234 | 2022-03-29 | Chippewa | Wisconsin | 55017 | 18606 | 179 |
2356235 | 2356235 | 2022-03-29 | Clark | Wisconsin | 55019 | 7586 | 121 |
2356236 | 2356236 | 2022-03-29 | Columbia | Wisconsin | 55021 | 15179 | 127 |
2356237 | 2356237 | 2022-03-29 | Crawford | Wisconsin | 55023 | 4224 | 28 |
2356238 | 2356238 | 2022-03-29 | Dane | Wisconsin | 55025 | 124034 | 502 |
2356239 | 2356239 | 2022-03-29 | Dodge | Wisconsin | 55027 | 27049 | 335 |
2356240 | 2356240 | 2022-03-29 | Door | Wisconsin | 55029 | 6935 | 71 |
2356241 | 2356241 | 2022-03-29 | Douglas | Wisconsin | 55031 | 11514 | 76 |
2356242 | 2356242 | 2022-03-29 | Dunn | Wisconsin | 55033 | 13251 | 74 |
2356243 | 2356243 | 2022-03-29 | Eau Claire | Wisconsin | 55035 | 30055 | 185 |
2356244 | 2356244 | 2022-03-29 | Florence | Wisconsin | 55037 | 1079 | 16 |
2356245 | 2356245 | 2022-03-29 | Fond du Lac | Wisconsin | 55039 | 31671 | 271 |
2356246 | 2356246 | 2022-03-29 | Forest | Wisconsin | 55041 | 2667 | 51 |
2356247 | 2356247 | 2022-03-29 | Grant | Wisconsin | 55043 | 12642 | 143 |
2356248 | 2356248 | 2022-03-29 | Green | Wisconsin | 55045 | 9087 | 53 |
2356249 | 2356249 | 2022-03-29 | Green Lake | Wisconsin | 55047 | 5067 | 63 |
2356250 | 2356250 | 2022-03-29 | Iowa | Wisconsin | 55049 | 5221 | 27 |
2356251 | 2356251 | 2022-03-29 | Iron | Wisconsin | 55051 | 1464 | 47 |
2356252 | 2356252 | 2022-03-29 | Jackson | Wisconsin | 55053 | 5643 | 43 |
2356253 | 2356253 | 2022-03-29 | Jefferson | Wisconsin | 55055 | 21427 | 240 |
2356254 | 2356254 | 2022-03-29 | Juneau | Wisconsin | 55057 | 7666 | 69 |
2356255 | 2356255 | 2022-03-29 | Kenosha | Wisconsin | 55059 | 43909 | 623 |
2356256 | 2356256 | 2022-03-29 | Kewaunee | Wisconsin | 55061 | 5825 | 59 |
2356257 | 2356257 | 2022-03-29 | La Crosse | Wisconsin | 55063 | 34628 | 181 |
2356258 | 2356258 | 2022-03-29 | Lafayette | Wisconsin | 55065 | 3628 | 22 |
2356259 | 2356259 | 2022-03-29 | Langlade | Wisconsin | 55067 | 5192 | 88 |
2356260 | 2356260 | 2022-03-29 | Lincoln | Wisconsin | 55069 | 6999 | 148 |
2356261 | 2356261 | 2022-03-29 | Manitowoc | Wisconsin | 55071 | 20372 | 187 |
2356262 | 2356262 | 2022-03-29 | Marathon | Wisconsin | 55073 | 39161 | 485 |
2356263 | 2356263 | 2022-03-29 | Marinette | Wisconsin | 55075 | 11572 | 122 |
2356264 | 2356264 | 2022-03-29 | Marquette | Wisconsin | 55077 | 3803 | 60 |
2356265 | 2356265 | 2022-03-29 | Menominee | Wisconsin | 55078 | 1900 | 14 |
2356266 | 2356266 | 2022-03-29 | Milwaukee | Wisconsin | 55079 | 267994 | 2271 |
2356267 | 2356267 | 2022-03-29 | Monroe | Wisconsin | 55081 | 11918 | 89 |
2356268 | 2356268 | 2022-03-29 | Oconto | Wisconsin | 55083 | 11372 | 118 |
2356269 | 2356269 | 2022-03-29 | Oneida | Wisconsin | 55085 | 8467 | 135 |
2356270 | 2356270 | 2022-03-29 | Outagamie | Wisconsin | 55087 | 54173 | 402 |
2356271 | 2356271 | 2022-03-29 | Ozaukee | Wisconsin | 55089 | 22095 | 183 |
2356272 | 2356272 | 2022-03-29 | Pepin | Wisconsin | 55091 | 1962 | 18 |
2356273 | 2356273 | 2022-03-29 | Pierce | Wisconsin | 55093 | 11500 | 72 |
2356274 | 2356274 | 2022-03-29 | Polk | Wisconsin | 55095 | 12265 | 122 |
2356275 | 2356275 | 2022-03-29 | Portage | Wisconsin | 55097 | 17911 | 160 |
2356276 | 2356276 | 2022-03-29 | Price | Wisconsin | 55099 | 3247 | 33 |
2356277 | 2356277 | 2022-03-29 | Racine | Wisconsin | 55101 | 56119 | 683 |
2356278 | 2356278 | 2022-03-29 | Richland | Wisconsin | 55103 | 3837 | 47 |
2356279 | 2356279 | 2022-03-29 | Rock | Wisconsin | 55105 | 42727 | 385 |
2356280 | 2356280 | 2022-03-29 | Rusk | Wisconsin | 55107 | 3405 | 54 |
2356281 | 2356281 | 2022-03-29 | Sauk | Wisconsin | 55111 | 15816 | 131 |
2356282 | 2356282 | 2022-03-29 | Sawyer | Wisconsin | 55113 | 4537 | 61 |
2356283 | 2356283 | 2022-03-29 | Shawano | Wisconsin | 55115 | 11632 | 150 |
2356284 | 2356284 | 2022-03-29 | Sheboygan | Wisconsin | 55117 | 32372 | 311 |
2356285 | 2356285 | 2022-03-29 | St. Croix | Wisconsin | 55109 | 24515 | 146 |
2356286 | 2356286 | 2022-03-29 | Taylor | Wisconsin | 55119 | 4817 | 72 |
2356287 | 2356287 | 2022-03-29 | Trempealeau | Wisconsin | 55121 | 8359 | 63 |
2356288 | 2356288 | 2022-03-29 | Vernon | Wisconsin | 55123 | 5999 | 96 |
2356289 | 2356289 | 2022-03-29 | Vilas | Wisconsin | 55125 | 5205 | 89 |
2356290 | 2356290 | 2022-03-29 | Walworth | Wisconsin | 55127 | 26848 | 278 |
2356291 | 2356291 | 2022-03-29 | Washburn | Wisconsin | 55129 | 3965 | 46 |
2356292 | 2356292 | 2022-03-29 | Washington | Wisconsin | 55131 | 37921 | 337 |
2356293 | 2356293 | 2022-03-29 | Waukesha | Wisconsin | 55133 | 111827 | 1086 |
2356294 | 2356294 | 2022-03-29 | Waupaca | Wisconsin | 55135 | 13600 | 250 |
2356295 | 2356295 | 2022-03-29 | Waushara | Wisconsin | 55137 | 6369 | 87 |
2356296 | 2356296 | 2022-03-29 | Winnebago | Wisconsin | 55139 | 51433 | 380 |
2356297 | 2356297 | 2022-03-29 | Wood | Wisconsin | 55141 | 20848 | 229 |
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);