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 2020-05-29 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
190620 | 190620 | 2020-05-29 | Adams | Wisconsin | 55001 | 4 | 1 |
190621 | 190621 | 2020-05-29 | Ashland | Wisconsin | 55003 | 2 | 0 |
190622 | 190622 | 2020-05-29 | Barron | Wisconsin | 55005 | 15 | 0 |
190623 | 190623 | 2020-05-29 | Bayfield | Wisconsin | 55007 | 3 | 1 |
190624 | 190624 | 2020-05-29 | Brown | Wisconsin | 55009 | 2308 | 35 |
190625 | 190625 | 2020-05-29 | Buffalo | Wisconsin | 55011 | 5 | 1 |
190626 | 190626 | 2020-05-29 | Burnett | Wisconsin | 55013 | 1 | 1 |
190627 | 190627 | 2020-05-29 | Calumet | Wisconsin | 55015 | 75 | 1 |
190628 | 190628 | 2020-05-29 | Chippewa | Wisconsin | 55017 | 55 | 0 |
190629 | 190629 | 2020-05-29 | Clark | Wisconsin | 55019 | 32 | 4 |
190630 | 190630 | 2020-05-29 | Columbia | Wisconsin | 55021 | 43 | 1 |
190631 | 190631 | 2020-05-29 | Crawford | Wisconsin | 55023 | 26 | 0 |
190632 | 190632 | 2020-05-29 | Dane | Wisconsin | 55025 | 713 | 28 |
190633 | 190633 | 2020-05-29 | Dodge | Wisconsin | 55027 | 180 | 1 |
190634 | 190634 | 2020-05-29 | Door | Wisconsin | 55029 | 38 | 3 |
190635 | 190635 | 2020-05-29 | Douglas | Wisconsin | 55031 | 19 | 0 |
190636 | 190636 | 2020-05-29 | Dunn | Wisconsin | 55033 | 24 | 0 |
190637 | 190637 | 2020-05-29 | Eau Claire | Wisconsin | 55035 | 107 | 0 |
190638 | 190638 | 2020-05-29 | Florence | Wisconsin | 55037 | 2 | 0 |
190639 | 190639 | 2020-05-29 | Fond du Lac | Wisconsin | 55039 | 194 | 5 |
190640 | 190640 | 2020-05-29 | Forest | Wisconsin | 55041 | 28 | 1 |
190641 | 190641 | 2020-05-29 | Grant | Wisconsin | 55043 | 94 | 12 |
190642 | 190642 | 2020-05-29 | Green | Wisconsin | 55045 | 65 | 0 |
190643 | 190643 | 2020-05-29 | Green Lake | Wisconsin | 55047 | 18 | 0 |
190644 | 190644 | 2020-05-29 | Iowa | Wisconsin | 55049 | 15 | 0 |
190645 | 190645 | 2020-05-29 | Iron | Wisconsin | 55051 | 2 | 1 |
190646 | 190646 | 2020-05-29 | Jackson | Wisconsin | 55053 | 16 | 1 |
190647 | 190647 | 2020-05-29 | Jefferson | Wisconsin | 55055 | 101 | 3 |
190648 | 190648 | 2020-05-29 | Juneau | Wisconsin | 55057 | 23 | 1 |
190649 | 190649 | 2020-05-29 | Kenosha | Wisconsin | 55059 | 1131 | 27 |
190650 | 190650 | 2020-05-29 | Kewaunee | Wisconsin | 55061 | 34 | 1 |
190651 | 190651 | 2020-05-29 | La Crosse | Wisconsin | 55063 | 53 | 0 |
190652 | 190652 | 2020-05-29 | Lafayette | Wisconsin | 55065 | 27 | 0 |
190653 | 190653 | 2020-05-29 | Langlade | Wisconsin | 55067 | 2 | 0 |
190654 | 190654 | 2020-05-29 | Lincoln | Wisconsin | 55069 | 7 | 0 |
190655 | 190655 | 2020-05-29 | Manitowoc | Wisconsin | 55071 | 36 | 1 |
190656 | 190656 | 2020-05-29 | Marathon | Wisconsin | 55073 | 46 | 1 |
190657 | 190657 | 2020-05-29 | Marinette | Wisconsin | 55075 | 33 | 2 |
190658 | 190658 | 2020-05-29 | Marquette | Wisconsin | 55077 | 3 | 1 |
190659 | 190659 | 2020-05-29 | Menominee | Wisconsin | 55078 | 3 | 0 |
190660 | 190660 | 2020-05-29 | Milwaukee | Wisconsin | 55079 | 7498 | 294 |
190661 | 190661 | 2020-05-29 | Monroe | Wisconsin | 55081 | 16 | 1 |
190662 | 190662 | 2020-05-29 | Oconto | Wisconsin | 55083 | 35 | 0 |
190663 | 190663 | 2020-05-29 | Oneida | Wisconsin | 55085 | 9 | 0 |
190664 | 190664 | 2020-05-29 | Outagamie | Wisconsin | 55087 | 213 | 8 |
190665 | 190665 | 2020-05-29 | Ozaukee | Wisconsin | 55089 | 159 | 11 |
190666 | 190666 | 2020-05-29 | Pepin | Wisconsin | 55091 | 1 | 0 |
190667 | 190667 | 2020-05-29 | Pierce | Wisconsin | 55093 | 45 | 0 |
190668 | 190668 | 2020-05-29 | Polk | Wisconsin | 55095 | 18 | 1 |
190669 | 190669 | 2020-05-29 | Portage | Wisconsin | 55097 | 11 | 0 |
190670 | 190670 | 2020-05-29 | Price | Wisconsin | 55099 | 2 | 0 |
190671 | 190671 | 2020-05-29 | Racine | Wisconsin | 55101 | 1918 | 35 |
190672 | 190672 | 2020-05-29 | Richland | Wisconsin | 55103 | 14 | 4 |
190673 | 190673 | 2020-05-29 | Rock | Wisconsin | 55105 | 620 | 18 |
190674 | 190674 | 2020-05-29 | Rusk | Wisconsin | 55107 | 5 | 0 |
190675 | 190675 | 2020-05-29 | Sauk | Wisconsin | 55111 | 78 | 3 |
190676 | 190676 | 2020-05-29 | Sawyer | Wisconsin | 55113 | 8 | 0 |
190677 | 190677 | 2020-05-29 | Shawano | Wisconsin | 55115 | 45 | 0 |
190678 | 190678 | 2020-05-29 | Sheboygan | Wisconsin | 55117 | 87 | 3 |
190679 | 190679 | 2020-05-29 | St. Croix | Wisconsin | 55109 | 77 | 0 |
190680 | 190680 | 2020-05-29 | Taylor | Wisconsin | 55119 | 2 | 0 |
190681 | 190681 | 2020-05-29 | Trempealeau | Wisconsin | 55121 | 24 | 0 |
190682 | 190682 | 2020-05-29 | Vernon | Wisconsin | 55123 | 21 | 0 |
190683 | 190683 | 2020-05-29 | Vilas | Wisconsin | 55125 | 6 | 0 |
190684 | 190684 | 2020-05-29 | Walworth | Wisconsin | 55127 | 379 | 17 |
190685 | 190685 | 2020-05-29 | Washburn | Wisconsin | 55129 | 2 | 0 |
190686 | 190686 | 2020-05-29 | Washington | Wisconsin | 55131 | 238 | 6 |
190687 | 190687 | 2020-05-29 | Waukesha | Wisconsin | 55133 | 665 | 28 |
190688 | 190688 | 2020-05-29 | Waupaca | Wisconsin | 55135 | 29 | 1 |
190689 | 190689 | 2020-05-29 | Waushara | Wisconsin | 55137 | 8 | 0 |
190690 | 190690 | 2020-05-29 | Winnebago | Wisconsin | 55139 | 224 | 4 |
190691 | 190691 | 2020-05-29 | Wood | Wisconsin | 55141 | 10 | 1 |
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);