ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where "date" is on date 2020-08-28 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
479344 | 479344 | 2020-08-28 | Adams | Wisconsin | 55001 | 106 | 3 |
479345 | 479345 | 2020-08-28 | Ashland | Wisconsin | 55003 | 34 | 1 |
479346 | 479346 | 2020-08-28 | Barron | Wisconsin | 55005 | 367 | 3 |
479347 | 479347 | 2020-08-28 | Bayfield | Wisconsin | 55007 | 43 | 1 |
479348 | 479348 | 2020-08-28 | Brown | Wisconsin | 55009 | 5262 | 58 |
479349 | 479349 | 2020-08-28 | Buffalo | Wisconsin | 55011 | 58 | 2 |
479350 | 479350 | 2020-08-28 | Burnett | Wisconsin | 55013 | 38 | 2 |
479351 | 479351 | 2020-08-28 | Calumet | Wisconsin | 55015 | 484 | 2 |
479352 | 479352 | 2020-08-28 | Chippewa | Wisconsin | 55017 | 331 | 0 |
479353 | 479353 | 2020-08-28 | Clark | Wisconsin | 55019 | 236 | 8 |
479354 | 479354 | 2020-08-28 | Columbia | Wisconsin | 55021 | 344 | 2 |
479355 | 479355 | 2020-08-28 | Crawford | Wisconsin | 55023 | 99 | 0 |
479356 | 479356 | 2020-08-28 | Dane | Wisconsin | 55025 | 5330 | 40 |
479357 | 479357 | 2020-08-28 | Dodge | Wisconsin | 55027 | 1102 | 5 |
479358 | 479358 | 2020-08-28 | Door | Wisconsin | 55029 | 128 | 3 |
479359 | 479359 | 2020-08-28 | Douglas | Wisconsin | 55031 | 244 | 0 |
479360 | 479360 | 2020-08-28 | Dunn | Wisconsin | 55033 | 169 | 0 |
479361 | 479361 | 2020-08-28 | Eau Claire | Wisconsin | 55035 | 780 | 6 |
479362 | 479362 | 2020-08-28 | Florence | Wisconsin | 55037 | 23 | 0 |
479363 | 479363 | 2020-08-28 | Fond du Lac | Wisconsin | 55039 | 1068 | 10 |
479364 | 479364 | 2020-08-28 | Forest | Wisconsin | 55041 | 70 | 4 |
479365 | 479365 | 2020-08-28 | Grant | Wisconsin | 55043 | 426 | 17 |
479366 | 479366 | 2020-08-28 | Green | Wisconsin | 55045 | 262 | 1 |
479367 | 479367 | 2020-08-28 | Green Lake | Wisconsin | 55047 | 88 | 0 |
479368 | 479368 | 2020-08-28 | Iowa | Wisconsin | 55049 | 115 | 0 |
479369 | 479369 | 2020-08-28 | Iron | Wisconsin | 55051 | 119 | 1 |
479370 | 479370 | 2020-08-28 | Jackson | Wisconsin | 55053 | 75 | 1 |
479371 | 479371 | 2020-08-28 | Jefferson | Wisconsin | 55055 | 870 | 6 |
479372 | 479372 | 2020-08-28 | Juneau | Wisconsin | 55057 | 189 | 1 |
479373 | 479373 | 2020-08-28 | Kenosha | Wisconsin | 55059 | 2932 | 62 |
479374 | 479374 | 2020-08-28 | Kewaunee | Wisconsin | 55061 | 165 | 2 |
479375 | 479375 | 2020-08-28 | La Crosse | Wisconsin | 55063 | 1133 | 1 |
479376 | 479376 | 2020-08-28 | Lafayette | Wisconsin | 55065 | 185 | 0 |
479377 | 479377 | 2020-08-28 | Langlade | Wisconsin | 55067 | 80 | 2 |
479378 | 479378 | 2020-08-28 | Lincoln | Wisconsin | 55069 | 81 | 1 |
479379 | 479379 | 2020-08-28 | Manitowoc | Wisconsin | 55071 | 505 | 1 |
479380 | 479380 | 2020-08-28 | Marathon | Wisconsin | 55073 | 764 | 13 |
479381 | 479381 | 2020-08-28 | Marinette | Wisconsin | 55075 | 594 | 6 |
479382 | 479382 | 2020-08-28 | Marquette | Wisconsin | 55077 | 89 | 1 |
479383 | 479383 | 2020-08-28 | Menominee | Wisconsin | 55078 | 28 | 0 |
479384 | 479384 | 2020-08-28 | Milwaukee | Wisconsin | 55079 | 23841 | 485 |
479385 | 479385 | 2020-08-28 | Monroe | Wisconsin | 55081 | 276 | 2 |
479386 | 479386 | 2020-08-28 | Oconto | Wisconsin | 55083 | 412 | 2 |
479387 | 479387 | 2020-08-28 | Oneida | Wisconsin | 55085 | 205 | 0 |
479388 | 479388 | 2020-08-28 | Outagamie | Wisconsin | 55087 | 1741 | 19 |
479389 | 479389 | 2020-08-28 | Ozaukee | Wisconsin | 55089 | 915 | 19 |
479390 | 479390 | 2020-08-28 | Pepin | Wisconsin | 55091 | 46 | 0 |
479391 | 479391 | 2020-08-28 | Pierce | Wisconsin | 55093 | 285 | 5 |
479392 | 479392 | 2020-08-28 | Polk | Wisconsin | 55095 | 171 | 2 |
479393 | 479393 | 2020-08-28 | Portage | Wisconsin | 55097 | 569 | 1 |
479394 | 479394 | 2020-08-28 | Price | Wisconsin | 55099 | 36 | 0 |
479395 | 479395 | 2020-08-28 | Racine | Wisconsin | 55101 | 4391 | 89 |
479396 | 479396 | 2020-08-28 | Richland | Wisconsin | 55103 | 46 | 4 |
479397 | 479397 | 2020-08-28 | Rock | Wisconsin | 55105 | 1792 | 26 |
479398 | 479398 | 2020-08-28 | Rusk | Wisconsin | 55107 | 24 | 1 |
479399 | 479399 | 2020-08-28 | Sauk | Wisconsin | 55111 | 627 | 3 |
479400 | 479400 | 2020-08-28 | Sawyer | Wisconsin | 55113 | 157 | 0 |
479401 | 479401 | 2020-08-28 | Shawano | Wisconsin | 55115 | 258 | 0 |
479402 | 479402 | 2020-08-28 | Sheboygan | Wisconsin | 55117 | 1016 | 8 |
479403 | 479403 | 2020-08-28 | St. Croix | Wisconsin | 55109 | 640 | 7 |
479404 | 479404 | 2020-08-28 | Taylor | Wisconsin | 55119 | 93 | 3 |
479405 | 479405 | 2020-08-28 | Trempealeau | Wisconsin | 55121 | 411 | 2 |
479406 | 479406 | 2020-08-28 | Unknown | Wisconsin | 4305 | 8 | |
479407 | 479407 | 2020-08-28 | Vernon | Wisconsin | 55123 | 94 | 0 |
479408 | 479408 | 2020-08-28 | Vilas | Wisconsin | 55125 | 98 | 0 |
479409 | 479409 | 2020-08-28 | Walworth | Wisconsin | 55127 | 1684 | 27 |
479410 | 479410 | 2020-08-28 | Washburn | Wisconsin | 55129 | 60 | 0 |
479411 | 479411 | 2020-08-28 | Washington | Wisconsin | 55131 | 1590 | 29 |
479412 | 479412 | 2020-08-28 | Waukesha | Wisconsin | 55133 | 5475 | 73 |
479413 | 479413 | 2020-08-28 | Waupaca | Wisconsin | 55135 | 662 | 17 |
479414 | 479414 | 2020-08-28 | Waushara | Wisconsin | 55137 | 147 | 2 |
479415 | 479415 | 2020-08-28 | Winnebago | Wisconsin | 55139 | 1461 | 21 |
479416 | 479416 | 2020-08-28 | Wood | Wisconsin | 55141 | 440 | 2 |
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);