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-09-11 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
524620 | 524620 | 2020-09-11 | Adams | Wisconsin | 55001 | 166 | 3 |
524621 | 524621 | 2020-09-11 | Ashland | Wisconsin | 55003 | 44 | 1 |
524622 | 524622 | 2020-09-11 | Barron | Wisconsin | 55005 | 414 | 4 |
524623 | 524623 | 2020-09-11 | Bayfield | Wisconsin | 55007 | 74 | 1 |
524624 | 524624 | 2020-09-11 | Brown | Wisconsin | 55009 | 6407 | 58 |
524625 | 524625 | 2020-09-11 | Buffalo | Wisconsin | 55011 | 103 | 2 |
524626 | 524626 | 2020-09-11 | Burnett | Wisconsin | 55013 | 67 | 2 |
524627 | 524627 | 2020-09-11 | Calumet | Wisconsin | 55015 | 675 | 2 |
524628 | 524628 | 2020-09-11 | Chippewa | Wisconsin | 55017 | 427 | 0 |
524629 | 524629 | 2020-09-11 | Clark | Wisconsin | 55019 | 296 | 8 |
524630 | 524630 | 2020-09-11 | Columbia | Wisconsin | 55021 | 455 | 2 |
524631 | 524631 | 2020-09-11 | Crawford | Wisconsin | 55023 | 129 | 0 |
524632 | 524632 | 2020-09-11 | Dane | Wisconsin | 55025 | 7678 | 41 |
524633 | 524633 | 2020-09-11 | Dodge | Wisconsin | 55027 | 1392 | 8 |
524634 | 524634 | 2020-09-11 | Door | Wisconsin | 55029 | 184 | 3 |
524635 | 524635 | 2020-09-11 | Douglas | Wisconsin | 55031 | 309 | 0 |
524636 | 524636 | 2020-09-11 | Dunn | Wisconsin | 55033 | 240 | 0 |
524637 | 524637 | 2020-09-11 | Eau Claire | Wisconsin | 55035 | 1118 | 6 |
524638 | 524638 | 2020-09-11 | Florence | Wisconsin | 55037 | 37 | 0 |
524639 | 524639 | 2020-09-11 | Fond du Lac | Wisconsin | 55039 | 1426 | 12 |
524640 | 524640 | 2020-09-11 | Forest | Wisconsin | 55041 | 131 | 4 |
524641 | 524641 | 2020-09-11 | Grant | Wisconsin | 55043 | 583 | 19 |
524642 | 524642 | 2020-09-11 | Green | Wisconsin | 55045 | 352 | 2 |
524643 | 524643 | 2020-09-11 | Green Lake | Wisconsin | 55047 | 154 | 0 |
524644 | 524644 | 2020-09-11 | Iowa | Wisconsin | 55049 | 153 | 0 |
524645 | 524645 | 2020-09-11 | Iron | Wisconsin | 55051 | 139 | 1 |
524646 | 524646 | 2020-09-11 | Jackson | Wisconsin | 55053 | 90 | 1 |
524647 | 524647 | 2020-09-11 | Jefferson | Wisconsin | 55055 | 1101 | 7 |
524648 | 524648 | 2020-09-11 | Juneau | Wisconsin | 55057 | 264 | 1 |
524649 | 524649 | 2020-09-11 | Kenosha | Wisconsin | 55059 | 3460 | 64 |
524650 | 524650 | 2020-09-11 | Kewaunee | Wisconsin | 55061 | 245 | 2 |
524651 | 524651 | 2020-09-11 | La Crosse | Wisconsin | 55063 | 1574 | 2 |
524652 | 524652 | 2020-09-11 | Lafayette | Wisconsin | 55065 | 194 | 0 |
524653 | 524653 | 2020-09-11 | Langlade | Wisconsin | 55067 | 94 | 2 |
524654 | 524654 | 2020-09-11 | Lincoln | Wisconsin | 55069 | 106 | 1 |
524655 | 524655 | 2020-09-11 | Manitowoc | Wisconsin | 55071 | 692 | 2 |
524656 | 524656 | 2020-09-11 | Marathon | Wisconsin | 55073 | 928 | 14 |
524657 | 524657 | 2020-09-11 | Marinette | Wisconsin | 55075 | 673 | 7 |
524658 | 524658 | 2020-09-11 | Marquette | Wisconsin | 55077 | 136 | 1 |
524659 | 524659 | 2020-09-11 | Menominee | Wisconsin | 55078 | 31 | 0 |
524660 | 524660 | 2020-09-11 | Milwaukee | Wisconsin | 55079 | 26807 | 510 |
524661 | 524661 | 2020-09-11 | Monroe | Wisconsin | 55081 | 324 | 2 |
524662 | 524662 | 2020-09-11 | Oconto | Wisconsin | 55083 | 553 | 4 |
524663 | 524663 | 2020-09-11 | Oneida | Wisconsin | 55085 | 260 | 1 |
524664 | 524664 | 2020-09-11 | Outagamie | Wisconsin | 55087 | 2740 | 24 |
524665 | 524665 | 2020-09-11 | Ozaukee | Wisconsin | 55089 | 1136 | 19 |
524666 | 524666 | 2020-09-11 | Pepin | Wisconsin | 55091 | 53 | 0 |
524667 | 524667 | 2020-09-11 | Pierce | Wisconsin | 55093 | 401 | 6 |
524668 | 524668 | 2020-09-11 | Polk | Wisconsin | 55095 | 206 | 2 |
524669 | 524669 | 2020-09-11 | Portage | Wisconsin | 55097 | 872 | 3 |
524670 | 524670 | 2020-09-11 | Price | Wisconsin | 55099 | 39 | 0 |
524671 | 524671 | 2020-09-11 | Racine | Wisconsin | 55101 | 4661 | 92 |
524672 | 524672 | 2020-09-11 | Richland | Wisconsin | 55103 | 76 | 4 |
524673 | 524673 | 2020-09-11 | Rock | Wisconsin | 55105 | 2131 | 29 |
524674 | 524674 | 2020-09-11 | Rusk | Wisconsin | 55107 | 40 | 1 |
524675 | 524675 | 2020-09-11 | Sauk | Wisconsin | 55111 | 755 | 3 |
524676 | 524676 | 2020-09-11 | Sawyer | Wisconsin | 55113 | 170 | 1 |
524677 | 524677 | 2020-09-11 | Shawano | Wisconsin | 55115 | 374 | 0 |
524678 | 524678 | 2020-09-11 | Sheboygan | Wisconsin | 55117 | 1259 | 10 |
524679 | 524679 | 2020-09-11 | St. Croix | Wisconsin | 55109 | 766 | 7 |
524680 | 524680 | 2020-09-11 | Taylor | Wisconsin | 55119 | 131 | 3 |
524681 | 524681 | 2020-09-11 | Trempealeau | Wisconsin | 55121 | 469 | 2 |
524682 | 524682 | 2020-09-11 | Unknown | Wisconsin | 0 | 8 | |
524683 | 524683 | 2020-09-11 | Vernon | Wisconsin | 55123 | 136 | 0 |
524684 | 524684 | 2020-09-11 | Vilas | Wisconsin | 55125 | 139 | 1 |
524685 | 524685 | 2020-09-11 | Walworth | Wisconsin | 55127 | 2143 | 32 |
524686 | 524686 | 2020-09-11 | Washburn | Wisconsin | 55129 | 82 | 1 |
524687 | 524687 | 2020-09-11 | Washington | Wisconsin | 55131 | 1946 | 31 |
524688 | 524688 | 2020-09-11 | Waukesha | Wisconsin | 55133 | 6590 | 81 |
524689 | 524689 | 2020-09-11 | Waupaca | Wisconsin | 55135 | 897 | 19 |
524690 | 524690 | 2020-09-11 | Waushara | Wisconsin | 55137 | 226 | 2 |
524691 | 524691 | 2020-09-11 | Winnebago | Wisconsin | 55139 | 1964 | 22 |
524692 | 524692 | 2020-09-11 | Wood | Wisconsin | 55141 | 585 | 3 |
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);