ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2021-04-27" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1264461 | 1264461 | 2021-04-27 | Adams | Wisconsin | 55001 | 1878 | 17 |
1264462 | 1264462 | 2021-04-27 | Ashland | Wisconsin | 55003 | 1323 | 15 |
1264463 | 1264463 | 2021-04-27 | Barron | Wisconsin | 55005 | 5844 | 78 |
1264464 | 1264464 | 2021-04-27 | Bayfield | Wisconsin | 55007 | 1241 | 19 |
1264465 | 1264465 | 2021-04-27 | Brown | Wisconsin | 55009 | 34740 | 276 |
1264466 | 1264466 | 2021-04-27 | Buffalo | Wisconsin | 55011 | 1380 | 7 |
1264467 | 1264467 | 2021-04-27 | Burnett | Wisconsin | 55013 | 1481 | 22 |
1264468 | 1264468 | 2021-04-27 | Calumet | Wisconsin | 55015 | 6387 | 50 |
1264469 | 1264469 | 2021-04-27 | Chippewa | Wisconsin | 55017 | 7486 | 96 |
1264470 | 1264470 | 2021-04-27 | Clark | Wisconsin | 55019 | 3618 | 62 |
1264471 | 1264471 | 2021-04-27 | Columbia | Wisconsin | 55021 | 5729 | 69 |
1264472 | 1264472 | 2021-04-27 | Crawford | Wisconsin | 55023 | 1767 | 17 |
1264473 | 1264473 | 2021-04-27 | Dane | Wisconsin | 55025 | 45494 | 318 |
1264474 | 1264474 | 2021-04-27 | Dodge | Wisconsin | 55027 | 12676 | 183 |
1264475 | 1264475 | 2021-04-27 | Door | Wisconsin | 55029 | 2797 | 28 |
1264476 | 1264476 | 2021-04-27 | Douglas | Wisconsin | 55031 | 4708 | 51 |
1264477 | 1264477 | 2021-04-27 | Dunn | Wisconsin | 55033 | 5004 | 32 |
1264478 | 1264478 | 2021-04-27 | Eau Claire | Wisconsin | 55035 | 11787 | 119 |
1264479 | 1264479 | 2021-04-27 | Florence | Wisconsin | 55037 | 497 | 12 |
1264480 | 1264480 | 2021-04-27 | Fond du Lac | Wisconsin | 55039 | 13489 | 115 |
1264481 | 1264481 | 2021-04-27 | Forest | Wisconsin | 55041 | 1026 | 26 |
1264482 | 1264482 | 2021-04-27 | Grant | Wisconsin | 55043 | 5643 | 90 |
1264483 | 1264483 | 2021-04-27 | Green | Wisconsin | 55045 | 3583 | 24 |
1264484 | 1264484 | 2021-04-27 | Green Lake | Wisconsin | 55047 | 2002 | 22 |
1264485 | 1264485 | 2021-04-27 | Iowa | Wisconsin | 55049 | 2093 | 11 |
1264486 | 1264486 | 2021-04-27 | Iron | Wisconsin | 55051 | 691 | 40 |
1264487 | 1264487 | 2021-04-27 | Jackson | Wisconsin | 55053 | 2675 | 28 |
1264488 | 1264488 | 2021-04-27 | Jefferson | Wisconsin | 55055 | 9466 | 132 |
1264489 | 1264489 | 2021-04-27 | Juneau | Wisconsin | 55057 | 3220 | 26 |
1264490 | 1264490 | 2021-04-27 | Kenosha | Wisconsin | 55059 | 18096 | 321 |
1264491 | 1264491 | 2021-04-27 | Kewaunee | Wisconsin | 55061 | 2658 | 34 |
1264492 | 1264492 | 2021-04-27 | La Crosse | Wisconsin | 55063 | 13423 | 82 |
1264493 | 1264493 | 2021-04-27 | Lafayette | Wisconsin | 55065 | 1696 | 8 |
1264494 | 1264494 | 2021-04-27 | Langlade | Wisconsin | 55067 | 2151 | 46 |
1264495 | 1264495 | 2021-04-27 | Lincoln | Wisconsin | 55069 | 3253 | 89 |
1264496 | 1264496 | 2021-04-27 | Manitowoc | Wisconsin | 55071 | 8701 | 88 |
1264497 | 1264497 | 2021-04-27 | Marathon | Wisconsin | 55073 | 15934 | 219 |
1264498 | 1264498 | 2021-04-27 | Marinette | Wisconsin | 55075 | 4531 | 69 |
1264499 | 1264499 | 2021-04-27 | Marquette | Wisconsin | 55077 | 1552 | 27 |
1264500 | 1264500 | 2021-04-27 | Menominee | Wisconsin | 55078 | 801 | 11 |
1264501 | 1264501 | 2021-04-27 | Milwaukee | Wisconsin | 55079 | 114324 | 1339 |
1264502 | 1264502 | 2021-04-27 | Monroe | Wisconsin | 55081 | 4579 | 38 |
1264503 | 1264503 | 2021-04-27 | Oconto | Wisconsin | 55083 | 4920 | 59 |
1264504 | 1264504 | 2021-04-27 | Oneida | Wisconsin | 55085 | 3765 | 75 |
1264505 | 1264505 | 2021-04-27 | Outagamie | Wisconsin | 55087 | 23401 | 218 |
1264506 | 1264506 | 2021-04-27 | Ozaukee | Wisconsin | 55089 | 9083 | 91 |
1264507 | 1264507 | 2021-04-27 | Pepin | Wisconsin | 55091 | 868 | 7 |
1264508 | 1264508 | 2021-04-27 | Pierce | Wisconsin | 55093 | 4830 | 42 |
1264509 | 1264509 | 2021-04-27 | Polk | Wisconsin | 55095 | 4460 | 49 |
1264510 | 1264510 | 2021-04-27 | Portage | Wisconsin | 55097 | 7241 | 71 |
1264511 | 1264511 | 2021-04-27 | Price | Wisconsin | 55099 | 1331 | 7 |
1264512 | 1264512 | 2021-04-27 | Racine | Wisconsin | 55101 | 24366 | 367 |
1264513 | 1264513 | 2021-04-27 | Richland | Wisconsin | 55103 | 1373 | 15 |
1264514 | 1264514 | 2021-04-27 | Rock | Wisconsin | 55105 | 17454 | 188 |
1264515 | 1264515 | 2021-04-27 | Rusk | Wisconsin | 55107 | 1336 | 18 |
1264516 | 1264516 | 2021-04-27 | Sauk | Wisconsin | 55111 | 5991 | 53 |
1264517 | 1264517 | 2021-04-27 | Sawyer | Wisconsin | 55113 | 1697 | 25 |
1264518 | 1264518 | 2021-04-27 | Shawano | Wisconsin | 55115 | 5246 | 82 |
1264519 | 1264519 | 2021-04-27 | Sheboygan | Wisconsin | 55117 | 14539 | 147 |
1264520 | 1264520 | 2021-04-27 | St. Croix | Wisconsin | 55109 | 9212 | 57 |
1264521 | 1264521 | 2021-04-27 | Taylor | Wisconsin | 55119 | 2089 | 32 |
1264522 | 1264522 | 2021-04-27 | Trempealeau | Wisconsin | 55121 | 3622 | 44 |
1264523 | 1264523 | 2021-04-27 | Vernon | Wisconsin | 55123 | 1973 | 42 |
1264524 | 1264524 | 2021-04-27 | Vilas | Wisconsin | 55125 | 2369 | 42 |
1264525 | 1264525 | 2021-04-27 | Walworth | Wisconsin | 55127 | 12345 | 157 |
1264526 | 1264526 | 2021-04-27 | Washburn | Wisconsin | 55129 | 1509 | 20 |
1264527 | 1264527 | 2021-04-27 | Washington | Wisconsin | 55131 | 16520 | 158 |
1264528 | 1264528 | 2021-04-27 | Waukesha | Wisconsin | 55133 | 48255 | 571 |
1264529 | 1264529 | 2021-04-27 | Waupaca | Wisconsin | 55135 | 5974 | 161 |
1264530 | 1264530 | 2021-04-27 | Waushara | Wisconsin | 55137 | 2477 | 36 |
1264531 | 1264531 | 2021-04-27 | Winnebago | Wisconsin | 55139 | 21004 | 214 |
1264532 | 1264532 | 2021-04-27 | Wood | Wisconsin | 55141 | 7410 | 90 |
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);