ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2021-08-29" 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 |
---|---|---|---|---|---|---|---|
1667073 | 1667073 | 2021-08-29 | Adams | Wisconsin | 55001 | 2157 | 21 |
1667074 | 1667074 | 2021-08-29 | Ashland | Wisconsin | 55003 | 1469 | 15 |
1667075 | 1667075 | 2021-08-29 | Barron | Wisconsin | 55005 | 6382 | 86 |
1667076 | 1667076 | 2021-08-29 | Bayfield | Wisconsin | 55007 | 1362 | 21 |
1667077 | 1667077 | 2021-08-29 | Brown | Wisconsin | 55009 | 37797 | 311 |
1667078 | 1667078 | 2021-08-29 | Buffalo | Wisconsin | 55011 | 1519 | 7 |
1667079 | 1667079 | 2021-08-29 | Burnett | Wisconsin | 55013 | 1681 | 29 |
1667080 | 1667080 | 2021-08-29 | Calumet | Wisconsin | 55015 | 6980 | 56 |
1667081 | 1667081 | 2021-08-29 | Chippewa | Wisconsin | 55017 | 8343 | 100 |
1667082 | 1667082 | 2021-08-29 | Clark | Wisconsin | 55019 | 3997 | 66 |
1667083 | 1667083 | 2021-08-29 | Columbia | Wisconsin | 55021 | 6277 | 75 |
1667084 | 1667084 | 2021-08-29 | Crawford | Wisconsin | 55023 | 1874 | 20 |
1667085 | 1667085 | 2021-08-29 | Dane | Wisconsin | 55025 | 50217 | 343 |
1667086 | 1667086 | 2021-08-29 | Dodge | Wisconsin | 55027 | 13676 | 202 |
1667087 | 1667087 | 2021-08-29 | Door | Wisconsin | 55029 | 3011 | 37 |
1667088 | 1667088 | 2021-08-29 | Douglas | Wisconsin | 55031 | 5175 | 66 |
1667089 | 1667089 | 2021-08-29 | Dunn | Wisconsin | 55033 | 5528 | 37 |
1667090 | 1667090 | 2021-08-29 | Eau Claire | Wisconsin | 55035 | 12999 | 126 |
1667091 | 1667091 | 2021-08-29 | Florence | Wisconsin | 55037 | 521 | 13 |
1667092 | 1667092 | 2021-08-29 | Fond du Lac | Wisconsin | 55039 | 14637 | 147 |
1667093 | 1667093 | 2021-08-29 | Forest | Wisconsin | 55041 | 1137 | 28 |
1667094 | 1667094 | 2021-08-29 | Grant | Wisconsin | 55043 | 5996 | 98 |
1667095 | 1667095 | 2021-08-29 | Green | Wisconsin | 55045 | 3857 | 26 |
1667096 | 1667096 | 2021-08-29 | Green Lake | Wisconsin | 55047 | 2243 | 26 |
1667097 | 1667097 | 2021-08-29 | Iowa | Wisconsin | 55049 | 2296 | 14 |
1667098 | 1667098 | 2021-08-29 | Iron | Wisconsin | 55051 | 735 | 42 |
1667099 | 1667099 | 2021-08-29 | Jackson | Wisconsin | 55053 | 2857 | 29 |
1667100 | 1667100 | 2021-08-29 | Jefferson | Wisconsin | 55055 | 10235 | 139 |
1667101 | 1667101 | 2021-08-29 | Juneau | Wisconsin | 55057 | 3531 | 32 |
1667102 | 1667102 | 2021-08-29 | Kenosha | Wisconsin | 55059 | 20186 | 342 |
1667103 | 1667103 | 2021-08-29 | Kewaunee | Wisconsin | 55061 | 2877 | 37 |
1667104 | 1667104 | 2021-08-29 | La Crosse | Wisconsin | 55063 | 14494 | 94 |
1667105 | 1667105 | 2021-08-29 | Lafayette | Wisconsin | 55065 | 1783 | 10 |
1667106 | 1667106 | 2021-08-29 | Langlade | Wisconsin | 55067 | 2379 | 51 |
1667107 | 1667107 | 2021-08-29 | Lincoln | Wisconsin | 55069 | 3484 | 100 |
1667108 | 1667108 | 2021-08-29 | Manitowoc | Wisconsin | 55071 | 9440 | 99 |
1667109 | 1667109 | 2021-08-29 | Marathon | Wisconsin | 55073 | 17358 | 234 |
1667110 | 1667110 | 2021-08-29 | Marinette | Wisconsin | 55075 | 5006 | 75 |
1667111 | 1667111 | 2021-08-29 | Marquette | Wisconsin | 55077 | 1701 | 29 |
1667112 | 1667112 | 2021-08-29 | Menominee | Wisconsin | 55078 | 853 | 11 |
1667113 | 1667113 | 2021-08-29 | Milwaukee | Wisconsin | 55079 | 129744 | 1478 |
1667114 | 1667114 | 2021-08-29 | Monroe | Wisconsin | 55081 | 5165 | 52 |
1667115 | 1667115 | 2021-08-29 | Oconto | Wisconsin | 55083 | 5489 | 74 |
1667116 | 1667116 | 2021-08-29 | Oneida | Wisconsin | 55085 | 4015 | 82 |
1667117 | 1667117 | 2021-08-29 | Outagamie | Wisconsin | 55087 | 25338 | 252 |
1667118 | 1667118 | 2021-08-29 | Ozaukee | Wisconsin | 55089 | 10230 | 111 |
1667119 | 1667119 | 2021-08-29 | Pepin | Wisconsin | 55091 | 951 | 7 |
1667120 | 1667120 | 2021-08-29 | Pierce | Wisconsin | 55093 | 5201 | 44 |
1667121 | 1667121 | 2021-08-29 | Polk | Wisconsin | 55095 | 5123 | 69 |
1667122 | 1667122 | 2021-08-29 | Portage | Wisconsin | 55097 | 7939 | 81 |
1667123 | 1667123 | 2021-08-29 | Price | Wisconsin | 55099 | 1419 | 8 |
1667124 | 1667124 | 2021-08-29 | Racine | Wisconsin | 55101 | 27342 | 408 |
1667125 | 1667125 | 2021-08-29 | Richland | Wisconsin | 55103 | 1504 | 17 |
1667126 | 1667126 | 2021-08-29 | Rock | Wisconsin | 55105 | 19602 | 216 |
1667127 | 1667127 | 2021-08-29 | Rusk | Wisconsin | 55107 | 1562 | 25 |
1667128 | 1667128 | 2021-08-29 | Sauk | Wisconsin | 55111 | 6740 | 59 |
1667129 | 1667129 | 2021-08-29 | Sawyer | Wisconsin | 55113 | 1970 | 29 |
1667130 | 1667130 | 2021-08-29 | Shawano | Wisconsin | 55115 | 5658 | 85 |
1667131 | 1667131 | 2021-08-29 | Sheboygan | Wisconsin | 55117 | 15764 | 174 |
1667132 | 1667132 | 2021-08-29 | St. Croix | Wisconsin | 55109 | 10464 | 73 |
1667133 | 1667133 | 2021-08-29 | Taylor | Wisconsin | 55119 | 2324 | 41 |
1667134 | 1667134 | 2021-08-29 | Trempealeau | Wisconsin | 55121 | 3932 | 49 |
1667135 | 1667135 | 2021-08-29 | Vernon | Wisconsin | 55123 | 2204 | 47 |
1667136 | 1667136 | 2021-08-29 | Vilas | Wisconsin | 55125 | 2524 | 46 |
1667137 | 1667137 | 2021-08-29 | Walworth | Wisconsin | 55127 | 13465 | 172 |
1667138 | 1667138 | 2021-08-29 | Washburn | Wisconsin | 55129 | 1675 | 24 |
1667139 | 1667139 | 2021-08-29 | Washington | Wisconsin | 55131 | 18232 | 206 |
1667140 | 1667140 | 2021-08-29 | Waukesha | Wisconsin | 55133 | 53504 | 661 |
1667141 | 1667141 | 2021-08-29 | Waupaca | Wisconsin | 55135 | 6511 | 169 |
1667142 | 1667142 | 2021-08-29 | Waushara | Wisconsin | 55137 | 2730 | 39 |
1667143 | 1667143 | 2021-08-29 | Winnebago | Wisconsin | 55139 | 22852 | 231 |
1667144 | 1667144 | 2021-08-29 | Wood | Wisconsin | 55141 | 8292 | 115 |
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);