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 2021-12-20 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2034268 | 2034268 | 2021-12-20 | Adams | Wisconsin | 55001 | 3265 | 37 |
2034269 | 2034269 | 2021-12-20 | Ashland | Wisconsin | 55003 | 2349 | 23 |
2034270 | 2034270 | 2021-12-20 | Barron | Wisconsin | 55005 | 10259 | 108 |
2034271 | 2034271 | 2021-12-20 | Bayfield | Wisconsin | 55007 | 2200 | 31 |
2034272 | 2034272 | 2021-12-20 | Brown | Wisconsin | 55009 | 56426 | 365 |
2034273 | 2034273 | 2021-12-20 | Buffalo | Wisconsin | 55011 | 2447 | 9 |
2034274 | 2034274 | 2021-12-20 | Burnett | Wisconsin | 55013 | 2946 | 36 |
2034275 | 2034275 | 2021-12-20 | Calumet | Wisconsin | 55015 | 10259 | 85 |
2034276 | 2034276 | 2021-12-20 | Chippewa | Wisconsin | 55017 | 13397 | 137 |
2034277 | 2034277 | 2021-12-20 | Clark | Wisconsin | 55019 | 5868 | 96 |
2034278 | 2034278 | 2021-12-20 | Columbia | Wisconsin | 55021 | 9790 | 100 |
2034279 | 2034279 | 2021-12-20 | Crawford | Wisconsin | 55023 | 2890 | 25 |
2034280 | 2034280 | 2021-12-20 | Dane | Wisconsin | 55025 | 68061 | 401 |
2034281 | 2034281 | 2021-12-20 | Dodge | Wisconsin | 55027 | 19420 | 250 |
2034282 | 2034282 | 2021-12-20 | Door | Wisconsin | 55029 | 4539 | 47 |
2034283 | 2034283 | 2021-12-20 | Douglas | Wisconsin | 55031 | 7915 | 71 |
2034284 | 2034284 | 2021-12-20 | Dunn | Wisconsin | 55033 | 9259 | 56 |
2034285 | 2034285 | 2021-12-20 | Eau Claire | Wisconsin | 55035 | 19966 | 158 |
2034286 | 2034286 | 2021-12-20 | Florence | Wisconsin | 55037 | 768 | 14 |
2034287 | 2034287 | 2021-12-20 | Fond du Lac | Wisconsin | 55039 | 21703 | 189 |
2034288 | 2034288 | 2021-12-20 | Forest | Wisconsin | 55041 | 1862 | 40 |
2034289 | 2034289 | 2021-12-20 | Grant | Wisconsin | 55043 | 9192 | 124 |
2034290 | 2034290 | 2021-12-20 | Green | Wisconsin | 55045 | 5995 | 40 |
2034291 | 2034291 | 2021-12-20 | Green Lake | Wisconsin | 55047 | 3656 | 44 |
2034292 | 2034292 | 2021-12-20 | Iowa | Wisconsin | 55049 | 3380 | 21 |
2034293 | 2034293 | 2021-12-20 | Iron | Wisconsin | 55051 | 1036 | 44 |
2034294 | 2034294 | 2021-12-20 | Jackson | Wisconsin | 55053 | 4144 | 37 |
2034295 | 2034295 | 2021-12-20 | Jefferson | Wisconsin | 55055 | 14762 | 181 |
2034296 | 2034296 | 2021-12-20 | Juneau | Wisconsin | 55057 | 5421 | 48 |
2034297 | 2034297 | 2021-12-20 | Kenosha | Wisconsin | 55059 | 29572 | 437 |
2034298 | 2034298 | 2021-12-20 | Kewaunee | Wisconsin | 55061 | 4351 | 49 |
2034299 | 2034299 | 2021-12-20 | La Crosse | Wisconsin | 55063 | 21191 | 139 |
2034300 | 2034300 | 2021-12-20 | Lafayette | Wisconsin | 55065 | 2601 | 16 |
2034301 | 2034301 | 2021-12-20 | Langlade | Wisconsin | 55067 | 3751 | 64 |
2034302 | 2034302 | 2021-12-20 | Lincoln | Wisconsin | 55069 | 5237 | 122 |
2034303 | 2034303 | 2021-12-20 | Manitowoc | Wisconsin | 55071 | 14684 | 132 |
2034304 | 2034304 | 2021-12-20 | Marathon | Wisconsin | 55073 | 27515 | 365 |
2034305 | 2034305 | 2021-12-20 | Marinette | Wisconsin | 55075 | 8617 | 93 |
2034306 | 2034306 | 2021-12-20 | Marquette | Wisconsin | 55077 | 2820 | 38 |
2034307 | 2034307 | 2021-12-20 | Menominee | Wisconsin | 55078 | 1023 | 11 |
2034308 | 2034308 | 2021-12-20 | Milwaukee | Wisconsin | 55079 | 171927 | 1770 |
2034309 | 2034309 | 2021-12-20 | Monroe | Wisconsin | 55081 | 8247 | 65 |
2034310 | 2034310 | 2021-12-20 | Oconto | Wisconsin | 55083 | 8469 | 84 |
2034311 | 2034311 | 2021-12-20 | Oneida | Wisconsin | 55085 | 6157 | 107 |
2034312 | 2034312 | 2021-12-20 | Outagamie | Wisconsin | 55087 | 37596 | 302 |
2034313 | 2034313 | 2021-12-20 | Ozaukee | Wisconsin | 55089 | 14779 | 131 |
2034314 | 2034314 | 2021-12-20 | Pepin | Wisconsin | 55091 | 1414 | 12 |
2034315 | 2034315 | 2021-12-20 | Pierce | Wisconsin | 55093 | 8229 | 59 |
2034316 | 2034316 | 2021-12-20 | Polk | Wisconsin | 55095 | 9173 | 105 |
2034317 | 2034317 | 2021-12-20 | Portage | Wisconsin | 55097 | 12066 | 125 |
2034318 | 2034318 | 2021-12-20 | Price | Wisconsin | 55099 | 2454 | 17 |
2034319 | 2034319 | 2021-12-20 | Racine | Wisconsin | 55101 | 37877 | 501 |
2034320 | 2034320 | 2021-12-20 | Richland | Wisconsin | 55103 | 2691 | 35 |
2034321 | 2034321 | 2021-12-20 | Rock | Wisconsin | 55105 | 27600 | 274 |
2034322 | 2034322 | 2021-12-20 | Rusk | Wisconsin | 55107 | 2631 | 39 |
2034323 | 2034323 | 2021-12-20 | Sauk | Wisconsin | 55111 | 10689 | 81 |
2034324 | 2034324 | 2021-12-20 | Sawyer | Wisconsin | 55113 | 3371 | 42 |
2034325 | 2034325 | 2021-12-20 | Shawano | Wisconsin | 55115 | 8438 | 103 |
2034326 | 2034326 | 2021-12-20 | Sheboygan | Wisconsin | 55117 | 22478 | 202 |
2034327 | 2034327 | 2021-12-20 | St. Croix | Wisconsin | 55109 | 17408 | 110 |
2034328 | 2034328 | 2021-12-20 | Taylor | Wisconsin | 55119 | 3692 | 58 |
2034329 | 2034329 | 2021-12-20 | Trempealeau | Wisconsin | 55121 | 5919 | 54 |
2034330 | 2034330 | 2021-12-20 | Vernon | Wisconsin | 55123 | 3925 | 73 |
2034331 | 2034331 | 2021-12-20 | Vilas | Wisconsin | 55125 | 3604 | 65 |
2034332 | 2034332 | 2021-12-20 | Walworth | Wisconsin | 55127 | 18778 | 209 |
2034333 | 2034333 | 2021-12-20 | Washburn | Wisconsin | 55129 | 3015 | 34 |
2034334 | 2034334 | 2021-12-20 | Washington | Wisconsin | 55131 | 27348 | 252 |
2034335 | 2034335 | 2021-12-20 | Waukesha | Wisconsin | 55133 | 74733 | 827 |
2034336 | 2034336 | 2021-12-20 | Waupaca | Wisconsin | 55135 | 9983 | 209 |
2034337 | 2034337 | 2021-12-20 | Waushara | Wisconsin | 55137 | 4400 | 68 |
2034338 | 2034338 | 2021-12-20 | Winnebago | Wisconsin | 55139 | 33802 | 304 |
2034339 | 2034339 | 2021-12-20 | Wood | Wisconsin | 55141 | 14243 | 163 |
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);