ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where date = "2020-08-24" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
466417 | 466417 | 2020-08-24 | Adams | Wisconsin | 55001 | 99 | 2 |
466418 | 466418 | 2020-08-24 | Ashland | Wisconsin | 55003 | 31 | 1 |
466419 | 466419 | 2020-08-24 | Barron | Wisconsin | 55005 | 358 | 3 |
466420 | 466420 | 2020-08-24 | Bayfield | Wisconsin | 55007 | 41 | 1 |
466421 | 466421 | 2020-08-24 | Brown | Wisconsin | 55009 | 4969 | 57 |
466422 | 466422 | 2020-08-24 | Buffalo | Wisconsin | 55011 | 54 | 2 |
466423 | 466423 | 2020-08-24 | Burnett | Wisconsin | 55013 | 33 | 1 |
466424 | 466424 | 2020-08-24 | Calumet | Wisconsin | 55015 | 450 | 2 |
466425 | 466425 | 2020-08-24 | Chippewa | Wisconsin | 55017 | 302 | 0 |
466426 | 466426 | 2020-08-24 | Clark | Wisconsin | 55019 | 230 | 8 |
466427 | 466427 | 2020-08-24 | Columbia | Wisconsin | 55021 | 326 | 2 |
466428 | 466428 | 2020-08-24 | Crawford | Wisconsin | 55023 | 96 | 0 |
466429 | 466429 | 2020-08-24 | Dane | Wisconsin | 55025 | 5117 | 39 |
466430 | 466430 | 2020-08-24 | Dodge | Wisconsin | 55027 | 1034 | 5 |
466431 | 466431 | 2020-08-24 | Door | Wisconsin | 55029 | 126 | 3 |
466432 | 466432 | 2020-08-24 | Douglas | Wisconsin | 55031 | 241 | 0 |
466433 | 466433 | 2020-08-24 | Dunn | Wisconsin | 55033 | 155 | 0 |
466434 | 466434 | 2020-08-24 | Eau Claire | Wisconsin | 55035 | 728 | 6 |
466435 | 466435 | 2020-08-24 | Florence | Wisconsin | 55037 | 22 | 0 |
466436 | 466436 | 2020-08-24 | Fond du Lac | Wisconsin | 55039 | 974 | 9 |
466437 | 466437 | 2020-08-24 | Forest | Wisconsin | 55041 | 65 | 4 |
466438 | 466438 | 2020-08-24 | Grant | Wisconsin | 55043 | 421 | 16 |
466439 | 466439 | 2020-08-24 | Green | Wisconsin | 55045 | 250 | 1 |
466440 | 466440 | 2020-08-24 | Green Lake | Wisconsin | 55047 | 83 | 0 |
466441 | 466441 | 2020-08-24 | Iowa | Wisconsin | 55049 | 110 | 0 |
466442 | 466442 | 2020-08-24 | Iron | Wisconsin | 55051 | 110 | 1 |
466443 | 466443 | 2020-08-24 | Jackson | Wisconsin | 55053 | 71 | 1 |
466444 | 466444 | 2020-08-24 | Jefferson | Wisconsin | 55055 | 824 | 6 |
466445 | 466445 | 2020-08-24 | Juneau | Wisconsin | 55057 | 173 | 1 |
466446 | 466446 | 2020-08-24 | Kenosha | Wisconsin | 55059 | 2899 | 61 |
466447 | 466447 | 2020-08-24 | Kewaunee | Wisconsin | 55061 | 156 | 2 |
466448 | 466448 | 2020-08-24 | La Crosse | Wisconsin | 55063 | 1047 | 1 |
466449 | 466449 | 2020-08-24 | Lafayette | Wisconsin | 55065 | 182 | 0 |
466450 | 466450 | 2020-08-24 | Langlade | Wisconsin | 55067 | 76 | 2 |
466451 | 466451 | 2020-08-24 | Lincoln | Wisconsin | 55069 | 76 | 1 |
466452 | 466452 | 2020-08-24 | Manitowoc | Wisconsin | 55071 | 457 | 1 |
466453 | 466453 | 2020-08-24 | Marathon | Wisconsin | 55073 | 733 | 13 |
466454 | 466454 | 2020-08-24 | Marinette | Wisconsin | 55075 | 565 | 6 |
466455 | 466455 | 2020-08-24 | Marquette | Wisconsin | 55077 | 82 | 1 |
466456 | 466456 | 2020-08-24 | Menominee | Wisconsin | 55078 | 28 | 0 |
466457 | 466457 | 2020-08-24 | Milwaukee | Wisconsin | 55079 | 23281 | 479 |
466458 | 466458 | 2020-08-24 | Monroe | Wisconsin | 55081 | 266 | 2 |
466459 | 466459 | 2020-08-24 | Oconto | Wisconsin | 55083 | 372 | 1 |
466460 | 466460 | 2020-08-24 | Oneida | Wisconsin | 55085 | 193 | 0 |
466461 | 466461 | 2020-08-24 | Outagamie | Wisconsin | 55087 | 1576 | 17 |
466462 | 466462 | 2020-08-24 | Ozaukee | Wisconsin | 55089 | 882 | 19 |
466463 | 466463 | 2020-08-24 | Pepin | Wisconsin | 55091 | 47 | 0 |
466464 | 466464 | 2020-08-24 | Pierce | Wisconsin | 55093 | 271 | 4 |
466465 | 466465 | 2020-08-24 | Polk | Wisconsin | 55095 | 156 | 2 |
466466 | 466466 | 2020-08-24 | Portage | Wisconsin | 55097 | 512 | 0 |
466467 | 466467 | 2020-08-24 | Price | Wisconsin | 55099 | 33 | 0 |
466468 | 466468 | 2020-08-24 | Racine | Wisconsin | 55101 | 4271 | 85 |
466469 | 466469 | 2020-08-24 | Richland | Wisconsin | 55103 | 41 | 4 |
466470 | 466470 | 2020-08-24 | Rock | Wisconsin | 55105 | 1722 | 26 |
466471 | 466471 | 2020-08-24 | Rusk | Wisconsin | 55107 | 23 | 1 |
466472 | 466472 | 2020-08-24 | Sauk | Wisconsin | 55111 | 590 | 3 |
466473 | 466473 | 2020-08-24 | Sawyer | Wisconsin | 55113 | 143 | 0 |
466474 | 466474 | 2020-08-24 | Shawano | Wisconsin | 55115 | 234 | 0 |
466475 | 466475 | 2020-08-24 | Sheboygan | Wisconsin | 55117 | 962 | 8 |
466476 | 466476 | 2020-08-24 | St. Croix | Wisconsin | 55109 | 602 | 7 |
466477 | 466477 | 2020-08-24 | Taylor | Wisconsin | 55119 | 85 | 3 |
466478 | 466478 | 2020-08-24 | Trempealeau | Wisconsin | 55121 | 395 | 2 |
466479 | 466479 | 2020-08-24 | Unknown | Wisconsin | 4183 | 8 | |
466480 | 466480 | 2020-08-24 | Vernon | Wisconsin | 55123 | 86 | 0 |
466481 | 466481 | 2020-08-24 | Vilas | Wisconsin | 55125 | 93 | 0 |
466482 | 466482 | 2020-08-24 | Walworth | Wisconsin | 55127 | 1614 | 26 |
466483 | 466483 | 2020-08-24 | Washburn | Wisconsin | 55129 | 56 | 0 |
466484 | 466484 | 2020-08-24 | Washington | Wisconsin | 55131 | 1477 | 27 |
466485 | 466485 | 2020-08-24 | Waukesha | Wisconsin | 55133 | 5267 | 70 |
466486 | 466486 | 2020-08-24 | Waupaca | Wisconsin | 55135 | 604 | 17 |
466487 | 466487 | 2020-08-24 | Waushara | Wisconsin | 55137 | 135 | 1 |
466488 | 466488 | 2020-08-24 | Winnebago | Wisconsin | 55139 | 1371 | 20 |
466489 | 466489 | 2020-08-24 | Wood | Wisconsin | 55141 | 418 | 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);