ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2022-03-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 |
---|---|---|---|---|---|---|---|
2349721 | 2349721 | 2022-03-27 | Adams | Wisconsin | 55001 | 4624 | 60 |
2349722 | 2349722 | 2022-03-27 | Ashland | Wisconsin | 55003 | 3273 | 36 |
2349723 | 2349723 | 2022-03-27 | Barron | Wisconsin | 55005 | 13427 | 141 |
2349724 | 2349724 | 2022-03-27 | Bayfield | Wisconsin | 55007 | 3266 | 39 |
2349725 | 2349725 | 2022-03-27 | Brown | Wisconsin | 55009 | 83784 | 534 |
2349726 | 2349726 | 2022-03-27 | Buffalo | Wisconsin | 55011 | 3446 | 12 |
2349727 | 2349727 | 2022-03-27 | Burnett | Wisconsin | 55013 | 3960 | 43 |
2349728 | 2349728 | 2022-03-27 | Calumet | Wisconsin | 55015 | 14454 | 119 |
2349729 | 2349729 | 2022-03-27 | Chippewa | Wisconsin | 55017 | 18597 | 179 |
2349730 | 2349730 | 2022-03-27 | Clark | Wisconsin | 55019 | 7584 | 120 |
2349731 | 2349731 | 2022-03-27 | Columbia | Wisconsin | 55021 | 15167 | 127 |
2349732 | 2349732 | 2022-03-27 | Crawford | Wisconsin | 55023 | 4223 | 28 |
2349733 | 2349733 | 2022-03-27 | Dane | Wisconsin | 55025 | 123753 | 502 |
2349734 | 2349734 | 2022-03-27 | Dodge | Wisconsin | 55027 | 27031 | 330 |
2349735 | 2349735 | 2022-03-27 | Door | Wisconsin | 55029 | 6933 | 69 |
2349736 | 2349736 | 2022-03-27 | Douglas | Wisconsin | 55031 | 11500 | 76 |
2349737 | 2349737 | 2022-03-27 | Dunn | Wisconsin | 55033 | 13248 | 73 |
2349738 | 2349738 | 2022-03-27 | Eau Claire | Wisconsin | 55035 | 30022 | 183 |
2349739 | 2349739 | 2022-03-27 | Florence | Wisconsin | 55037 | 1078 | 16 |
2349740 | 2349740 | 2022-03-27 | Fond du Lac | Wisconsin | 55039 | 31650 | 267 |
2349741 | 2349741 | 2022-03-27 | Forest | Wisconsin | 55041 | 2667 | 51 |
2349742 | 2349742 | 2022-03-27 | Grant | Wisconsin | 55043 | 12636 | 143 |
2349743 | 2349743 | 2022-03-27 | Green | Wisconsin | 55045 | 9079 | 53 |
2349744 | 2349744 | 2022-03-27 | Green Lake | Wisconsin | 55047 | 5066 | 62 |
2349745 | 2349745 | 2022-03-27 | Iowa | Wisconsin | 55049 | 5211 | 27 |
2349746 | 2349746 | 2022-03-27 | Iron | Wisconsin | 55051 | 1464 | 47 |
2349747 | 2349747 | 2022-03-27 | Jackson | Wisconsin | 55053 | 5637 | 42 |
2349748 | 2349748 | 2022-03-27 | Jefferson | Wisconsin | 55055 | 21405 | 236 |
2349749 | 2349749 | 2022-03-27 | Juneau | Wisconsin | 55057 | 7663 | 67 |
2349750 | 2349750 | 2022-03-27 | Kenosha | Wisconsin | 55059 | 43868 | 621 |
2349751 | 2349751 | 2022-03-27 | Kewaunee | Wisconsin | 55061 | 5825 | 59 |
2349752 | 2349752 | 2022-03-27 | La Crosse | Wisconsin | 55063 | 34589 | 179 |
2349753 | 2349753 | 2022-03-27 | Lafayette | Wisconsin | 55065 | 3625 | 22 |
2349754 | 2349754 | 2022-03-27 | Langlade | Wisconsin | 55067 | 5191 | 88 |
2349755 | 2349755 | 2022-03-27 | Lincoln | Wisconsin | 55069 | 6996 | 147 |
2349756 | 2349756 | 2022-03-27 | Manitowoc | Wisconsin | 55071 | 20363 | 187 |
2349757 | 2349757 | 2022-03-27 | Marathon | Wisconsin | 55073 | 39139 | 483 |
2349758 | 2349758 | 2022-03-27 | Marinette | Wisconsin | 55075 | 11568 | 120 |
2349759 | 2349759 | 2022-03-27 | Marquette | Wisconsin | 55077 | 3793 | 60 |
2349760 | 2349760 | 2022-03-27 | Menominee | Wisconsin | 55078 | 1900 | 14 |
2349761 | 2349761 | 2022-03-27 | Milwaukee | Wisconsin | 55079 | 267771 | 2258 |
2349762 | 2349762 | 2022-03-27 | Monroe | Wisconsin | 55081 | 11901 | 89 |
2349763 | 2349763 | 2022-03-27 | Oconto | Wisconsin | 55083 | 11368 | 117 |
2349764 | 2349764 | 2022-03-27 | Oneida | Wisconsin | 55085 | 8461 | 135 |
2349765 | 2349765 | 2022-03-27 | Outagamie | Wisconsin | 55087 | 54143 | 400 |
2349766 | 2349766 | 2022-03-27 | Ozaukee | Wisconsin | 55089 | 22080 | 180 |
2349767 | 2349767 | 2022-03-27 | Pepin | Wisconsin | 55091 | 1954 | 18 |
2349768 | 2349768 | 2022-03-27 | Pierce | Wisconsin | 55093 | 11488 | 72 |
2349769 | 2349769 | 2022-03-27 | Polk | Wisconsin | 55095 | 12262 | 122 |
2349770 | 2349770 | 2022-03-27 | Portage | Wisconsin | 55097 | 17895 | 160 |
2349771 | 2349771 | 2022-03-27 | Price | Wisconsin | 55099 | 3248 | 32 |
2349772 | 2349772 | 2022-03-27 | Racine | Wisconsin | 55101 | 56087 | 680 |
2349773 | 2349773 | 2022-03-27 | Richland | Wisconsin | 55103 | 3831 | 46 |
2349774 | 2349774 | 2022-03-27 | Rock | Wisconsin | 55105 | 42650 | 383 |
2349775 | 2349775 | 2022-03-27 | Rusk | Wisconsin | 55107 | 3405 | 54 |
2349776 | 2349776 | 2022-03-27 | Sauk | Wisconsin | 55111 | 15805 | 129 |
2349777 | 2349777 | 2022-03-27 | Sawyer | Wisconsin | 55113 | 4535 | 61 |
2349778 | 2349778 | 2022-03-27 | Shawano | Wisconsin | 55115 | 11631 | 148 |
2349779 | 2349779 | 2022-03-27 | Sheboygan | Wisconsin | 55117 | 32354 | 310 |
2349780 | 2349780 | 2022-03-27 | St. Croix | Wisconsin | 55109 | 24482 | 146 |
2349781 | 2349781 | 2022-03-27 | Taylor | Wisconsin | 55119 | 4813 | 72 |
2349782 | 2349782 | 2022-03-27 | Trempealeau | Wisconsin | 55121 | 8354 | 63 |
2349783 | 2349783 | 2022-03-27 | Vernon | Wisconsin | 55123 | 5992 | 93 |
2349784 | 2349784 | 2022-03-27 | Vilas | Wisconsin | 55125 | 5201 | 88 |
2349785 | 2349785 | 2022-03-27 | Walworth | Wisconsin | 55127 | 26828 | 276 |
2349786 | 2349786 | 2022-03-27 | Washburn | Wisconsin | 55129 | 3959 | 47 |
2349787 | 2349787 | 2022-03-27 | Washington | Wisconsin | 55131 | 37893 | 335 |
2349788 | 2349788 | 2022-03-27 | Waukesha | Wisconsin | 55133 | 111755 | 1081 |
2349789 | 2349789 | 2022-03-27 | Waupaca | Wisconsin | 55135 | 13594 | 250 |
2349790 | 2349790 | 2022-03-27 | Waushara | Wisconsin | 55137 | 6362 | 87 |
2349791 | 2349791 | 2022-03-27 | Winnebago | Wisconsin | 55139 | 51406 | 378 |
2349792 | 2349792 | 2022-03-27 | Wood | Wisconsin | 55141 | 20833 | 229 |
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);