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-05-09 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1303421 | 1303421 | 2021-05-09 | Adams | Wisconsin | 55001 | 1931 | 17 |
1303422 | 1303422 | 2021-05-09 | Ashland | Wisconsin | 55003 | 1358 | 15 |
1303423 | 1303423 | 2021-05-09 | Barron | Wisconsin | 55005 | 5952 | 83 |
1303424 | 1303424 | 2021-05-09 | Bayfield | Wisconsin | 55007 | 1266 | 19 |
1303425 | 1303425 | 2021-05-09 | Brown | Wisconsin | 55009 | 35124 | 289 |
1303426 | 1303426 | 2021-05-09 | Buffalo | Wisconsin | 55011 | 1388 | 7 |
1303427 | 1303427 | 2021-05-09 | Burnett | Wisconsin | 55013 | 1513 | 22 |
1303428 | 1303428 | 2021-05-09 | Calumet | Wisconsin | 55015 | 6447 | 55 |
1303429 | 1303429 | 2021-05-09 | Chippewa | Wisconsin | 55017 | 7562 | 96 |
1303430 | 1303430 | 2021-05-09 | Clark | Wisconsin | 55019 | 3655 | 62 |
1303431 | 1303431 | 2021-05-09 | Columbia | Wisconsin | 55021 | 5819 | 69 |
1303432 | 1303432 | 2021-05-09 | Crawford | Wisconsin | 55023 | 1776 | 17 |
1303433 | 1303433 | 2021-05-09 | Dane | Wisconsin | 55025 | 46091 | 327 |
1303434 | 1303434 | 2021-05-09 | Dodge | Wisconsin | 55027 | 12771 | 185 |
1303435 | 1303435 | 2021-05-09 | Door | Wisconsin | 55029 | 2824 | 28 |
1303436 | 1303436 | 2021-05-09 | Douglas | Wisconsin | 55031 | 4822 | 54 |
1303437 | 1303437 | 2021-05-09 | Dunn | Wisconsin | 55033 | 5051 | 32 |
1303438 | 1303438 | 2021-05-09 | Eau Claire | Wisconsin | 55035 | 11868 | 119 |
1303439 | 1303439 | 2021-05-09 | Florence | Wisconsin | 55037 | 501 | 12 |
1303440 | 1303440 | 2021-05-09 | Fond du Lac | Wisconsin | 55039 | 13621 | 121 |
1303441 | 1303441 | 2021-05-09 | Forest | Wisconsin | 55041 | 1039 | 26 |
1303442 | 1303442 | 2021-05-09 | Grant | Wisconsin | 55043 | 5682 | 92 |
1303443 | 1303443 | 2021-05-09 | Green | Wisconsin | 55045 | 3620 | 24 |
1303444 | 1303444 | 2021-05-09 | Green Lake | Wisconsin | 55047 | 2011 | 22 |
1303445 | 1303445 | 2021-05-09 | Iowa | Wisconsin | 55049 | 2112 | 11 |
1303446 | 1303446 | 2021-05-09 | Iron | Wisconsin | 55051 | 696 | 40 |
1303447 | 1303447 | 2021-05-09 | Jackson | Wisconsin | 55053 | 2692 | 28 |
1303448 | 1303448 | 2021-05-09 | Jefferson | Wisconsin | 55055 | 9571 | 132 |
1303449 | 1303449 | 2021-05-09 | Juneau | Wisconsin | 55057 | 3284 | 27 |
1303450 | 1303450 | 2021-05-09 | Kenosha | Wisconsin | 55059 | 18338 | 324 |
1303451 | 1303451 | 2021-05-09 | Kewaunee | Wisconsin | 55061 | 2688 | 35 |
1303452 | 1303452 | 2021-05-09 | La Crosse | Wisconsin | 55063 | 13537 | 87 |
1303453 | 1303453 | 2021-05-09 | Lafayette | Wisconsin | 55065 | 1713 | 9 |
1303454 | 1303454 | 2021-05-09 | Langlade | Wisconsin | 55067 | 2165 | 46 |
1303455 | 1303455 | 2021-05-09 | Lincoln | Wisconsin | 55069 | 3274 | 92 |
1303456 | 1303456 | 2021-05-09 | Manitowoc | Wisconsin | 55071 | 8789 | 88 |
1303457 | 1303457 | 2021-05-09 | Marathon | Wisconsin | 55073 | 16185 | 225 |
1303458 | 1303458 | 2021-05-09 | Marinette | Wisconsin | 55075 | 4600 | 70 |
1303459 | 1303459 | 2021-05-09 | Marquette | Wisconsin | 55077 | 1562 | 28 |
1303460 | 1303460 | 2021-05-09 | Menominee | Wisconsin | 55078 | 811 | 11 |
1303461 | 1303461 | 2021-05-09 | Milwaukee | Wisconsin | 55079 | 115852 | 1351 |
1303462 | 1303462 | 2021-05-09 | Monroe | Wisconsin | 55081 | 4643 | 38 |
1303463 | 1303463 | 2021-05-09 | Oconto | Wisconsin | 55083 | 5003 | 64 |
1303464 | 1303464 | 2021-05-09 | Oneida | Wisconsin | 55085 | 3790 | 77 |
1303465 | 1303465 | 2021-05-09 | Outagamie | Wisconsin | 55087 | 23575 | 222 |
1303466 | 1303466 | 2021-05-09 | Ozaukee | Wisconsin | 55089 | 9165 | 94 |
1303467 | 1303467 | 2021-05-09 | Pepin | Wisconsin | 55091 | 880 | 7 |
1303468 | 1303468 | 2021-05-09 | Pierce | Wisconsin | 55093 | 4931 | 43 |
1303469 | 1303469 | 2021-05-09 | Polk | Wisconsin | 55095 | 4620 | 56 |
1303470 | 1303470 | 2021-05-09 | Portage | Wisconsin | 55097 | 7319 | 72 |
1303471 | 1303471 | 2021-05-09 | Price | Wisconsin | 55099 | 1336 | 7 |
1303472 | 1303472 | 2021-05-09 | Racine | Wisconsin | 55101 | 24790 | 375 |
1303473 | 1303473 | 2021-05-09 | Richland | Wisconsin | 55103 | 1377 | 15 |
1303474 | 1303474 | 2021-05-09 | Rock | Wisconsin | 55105 | 17907 | 193 |
1303475 | 1303475 | 2021-05-09 | Rusk | Wisconsin | 55107 | 1369 | 18 |
1303476 | 1303476 | 2021-05-09 | Sauk | Wisconsin | 55111 | 6100 | 54 |
1303477 | 1303477 | 2021-05-09 | Sawyer | Wisconsin | 55113 | 1742 | 26 |
1303478 | 1303478 | 2021-05-09 | Shawano | Wisconsin | 55115 | 5275 | 83 |
1303479 | 1303479 | 2021-05-09 | Sheboygan | Wisconsin | 55117 | 14645 | 153 |
1303480 | 1303480 | 2021-05-09 | St. Croix | Wisconsin | 55109 | 9521 | 60 |
1303481 | 1303481 | 2021-05-09 | Taylor | Wisconsin | 55119 | 2105 | 32 |
1303482 | 1303482 | 2021-05-09 | Trempealeau | Wisconsin | 55121 | 3643 | 45 |
1303483 | 1303483 | 2021-05-09 | Vernon | Wisconsin | 55123 | 1992 | 42 |
1303484 | 1303484 | 2021-05-09 | Vilas | Wisconsin | 55125 | 2395 | 41 |
1303485 | 1303485 | 2021-05-09 | Walworth | Wisconsin | 55127 | 12487 | 159 |
1303486 | 1303486 | 2021-05-09 | Washburn | Wisconsin | 55129 | 1546 | 21 |
1303487 | 1303487 | 2021-05-09 | Washington | Wisconsin | 55131 | 16719 | 167 |
1303488 | 1303488 | 2021-05-09 | Waukesha | Wisconsin | 55133 | 48672 | 578 |
1303489 | 1303489 | 2021-05-09 | Waupaca | Wisconsin | 55135 | 6015 | 164 |
1303490 | 1303490 | 2021-05-09 | Waushara | Wisconsin | 55137 | 2497 | 37 |
1303491 | 1303491 | 2021-05-09 | Winnebago | Wisconsin | 55139 | 21220 | 219 |
1303492 | 1303492 | 2021-05-09 | Wood | Wisconsin | 55141 | 7541 | 93 |
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);