ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2022-04-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 |
---|---|---|---|---|---|---|---|
2457137 | 2457137 | 2022-04-29 | Adams | Wisconsin | 55001 | 4656 | 61 |
2457138 | 2457138 | 2022-04-29 | Ashland | Wisconsin | 55003 | 3310 | 36 |
2457139 | 2457139 | 2022-04-29 | Barron | Wisconsin | 55005 | 13601 | 143 |
2457140 | 2457140 | 2022-04-29 | Bayfield | Wisconsin | 55007 | 3356 | 40 |
2457141 | 2457141 | 2022-04-29 | Brown | Wisconsin | 55009 | 84667 | 552 |
2457142 | 2457142 | 2022-04-29 | Buffalo | Wisconsin | 55011 | 3555 | 12 |
2457143 | 2457143 | 2022-04-29 | Burnett | Wisconsin | 55013 | 4011 | 43 |
2457144 | 2457144 | 2022-04-29 | Calumet | Wisconsin | 55015 | 14596 | 121 |
2457145 | 2457145 | 2022-04-29 | Chippewa | Wisconsin | 55017 | 18858 | 184 |
2457146 | 2457146 | 2022-04-29 | Clark | Wisconsin | 55019 | 7643 | 122 |
2457147 | 2457147 | 2022-04-29 | Columbia | Wisconsin | 55021 | 15491 | 127 |
2457148 | 2457148 | 2022-04-29 | Crawford | Wisconsin | 55023 | 4257 | 28 |
2457149 | 2457149 | 2022-04-29 | Dane | Wisconsin | 55025 | 129500 | 509 |
2457150 | 2457150 | 2022-04-29 | Dodge | Wisconsin | 55027 | 27326 | 339 |
2457151 | 2457151 | 2022-04-29 | Door | Wisconsin | 55029 | 6999 | 71 |
2457152 | 2457152 | 2022-04-29 | Douglas | Wisconsin | 55031 | 11738 | 79 |
2457153 | 2457153 | 2022-04-29 | Dunn | Wisconsin | 55033 | 13413 | 75 |
2457154 | 2457154 | 2022-04-29 | Eau Claire | Wisconsin | 55035 | 30643 | 185 |
2457155 | 2457155 | 2022-04-29 | Florence | Wisconsin | 55037 | 1086 | 16 |
2457156 | 2457156 | 2022-04-29 | Fond du Lac | Wisconsin | 55039 | 32048 | 273 |
2457157 | 2457157 | 2022-04-29 | Forest | Wisconsin | 55041 | 2681 | 52 |
2457158 | 2457158 | 2022-04-29 | Grant | Wisconsin | 55043 | 12789 | 145 |
2457159 | 2457159 | 2022-04-29 | Green | Wisconsin | 55045 | 9335 | 53 |
2457160 | 2457160 | 2022-04-29 | Green Lake | Wisconsin | 55047 | 5178 | 63 |
2457161 | 2457161 | 2022-04-29 | Iowa | Wisconsin | 55049 | 5315 | 28 |
2457162 | 2457162 | 2022-04-29 | Iron | Wisconsin | 55051 | 1473 | 47 |
2457163 | 2457163 | 2022-04-29 | Jackson | Wisconsin | 55053 | 5684 | 43 |
2457164 | 2457164 | 2022-04-29 | Jefferson | Wisconsin | 55055 | 21727 | 241 |
2457165 | 2457165 | 2022-04-29 | Juneau | Wisconsin | 55057 | 7739 | 68 |
2457166 | 2457166 | 2022-04-29 | Kenosha | Wisconsin | 55059 | 44577 | 627 |
2457167 | 2457167 | 2022-04-29 | Kewaunee | Wisconsin | 55061 | 5865 | 59 |
2457168 | 2457168 | 2022-04-29 | La Crosse | Wisconsin | 55063 | 35296 | 182 |
2457169 | 2457169 | 2022-04-29 | Lafayette | Wisconsin | 55065 | 3688 | 24 |
2457170 | 2457170 | 2022-04-29 | Langlade | Wisconsin | 55067 | 5222 | 90 |
2457171 | 2457171 | 2022-04-29 | Lincoln | Wisconsin | 55069 | 7069 | 148 |
2457172 | 2457172 | 2022-04-29 | Manitowoc | Wisconsin | 55071 | 20583 | 187 |
2457173 | 2457173 | 2022-04-29 | Marathon | Wisconsin | 55073 | 39582 | 490 |
2457174 | 2457174 | 2022-04-29 | Marinette | Wisconsin | 55075 | 11645 | 124 |
2457175 | 2457175 | 2022-04-29 | Marquette | Wisconsin | 55077 | 3830 | 61 |
2457176 | 2457176 | 2022-04-29 | Menominee | Wisconsin | 55078 | 1903 | 14 |
2457177 | 2457177 | 2022-04-29 | Milwaukee | Wisconsin | 55079 | 272470 | 2286 |
2457178 | 2457178 | 2022-04-29 | Monroe | Wisconsin | 55081 | 12122 | 89 |
2457179 | 2457179 | 2022-04-29 | Oconto | Wisconsin | 55083 | 11444 | 119 |
2457180 | 2457180 | 2022-04-29 | Oneida | Wisconsin | 55085 | 8527 | 138 |
2457181 | 2457181 | 2022-04-29 | Outagamie | Wisconsin | 55087 | 54779 | 405 |
2457182 | 2457182 | 2022-04-29 | Ozaukee | Wisconsin | 55089 | 22606 | 186 |
2457183 | 2457183 | 2022-04-29 | Pepin | Wisconsin | 55091 | 1979 | 18 |
2457184 | 2457184 | 2022-04-29 | Pierce | Wisconsin | 55093 | 11672 | 73 |
2457185 | 2457185 | 2022-04-29 | Polk | Wisconsin | 55095 | 12507 | 122 |
2457186 | 2457186 | 2022-04-29 | Portage | Wisconsin | 55097 | 18180 | 160 |
2457187 | 2457187 | 2022-04-29 | Price | Wisconsin | 55099 | 3259 | 33 |
2457188 | 2457188 | 2022-04-29 | Racine | Wisconsin | 55101 | 56801 | 688 |
2457189 | 2457189 | 2022-04-29 | Richland | Wisconsin | 55103 | 3921 | 48 |
2457190 | 2457190 | 2022-04-29 | Rock | Wisconsin | 55105 | 43480 | 391 |
2457191 | 2457191 | 2022-04-29 | Rusk | Wisconsin | 55107 | 3434 | 55 |
2457192 | 2457192 | 2022-04-29 | Sauk | Wisconsin | 55111 | 16108 | 133 |
2457193 | 2457193 | 2022-04-29 | Sawyer | Wisconsin | 55113 | 4576 | 62 |
2457194 | 2457194 | 2022-04-29 | Shawano | Wisconsin | 55115 | 11699 | 151 |
2457195 | 2457195 | 2022-04-29 | Sheboygan | Wisconsin | 55117 | 32747 | 317 |
2457196 | 2457196 | 2022-04-29 | St. Croix | Wisconsin | 55109 | 25070 | 148 |
2457197 | 2457197 | 2022-04-29 | Taylor | Wisconsin | 55119 | 4845 | 72 |
2457198 | 2457198 | 2022-04-29 | Trempealeau | Wisconsin | 55121 | 8448 | 64 |
2457199 | 2457199 | 2022-04-29 | Vernon | Wisconsin | 55123 | 6113 | 97 |
2457200 | 2457200 | 2022-04-29 | Vilas | Wisconsin | 55125 | 5231 | 89 |
2457201 | 2457201 | 2022-04-29 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2457202 | 2457202 | 2022-04-29 | Washburn | Wisconsin | 55129 | 4024 | 46 |
2457203 | 2457203 | 2022-04-29 | Washington | Wisconsin | 55131 | 38411 | 341 |
2457204 | 2457204 | 2022-04-29 | Waukesha | Wisconsin | 55133 | 113772 | 1091 |
2457205 | 2457205 | 2022-04-29 | Waupaca | Wisconsin | 55135 | 13669 | 252 |
2457206 | 2457206 | 2022-04-29 | Waushara | Wisconsin | 55137 | 6442 | 87 |
2457207 | 2457207 | 2022-04-29 | Winnebago | Wisconsin | 55139 | 52229 | 380 |
2457208 | 2457208 | 2022-04-29 | Wood | Wisconsin | 55141 | 21128 | 230 |
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);