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-12-21 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
852193 | 852193 | 2020-12-21 | Adams | Wisconsin | 55001 | 1370 | 12 |
852194 | 852194 | 2020-12-21 | Ashland | Wisconsin | 55003 | 990 | 14 |
852195 | 852195 | 2020-12-21 | Barron | Wisconsin | 55005 | 4351 | 53 |
852196 | 852196 | 2020-12-21 | Bayfield | Wisconsin | 55007 | 905 | 16 |
852197 | 852197 | 2020-12-21 | Brown | Wisconsin | 55009 | 26464 | 167 |
852198 | 852198 | 2020-12-21 | Buffalo | Wisconsin | 55011 | 956 | 6 |
852199 | 852199 | 2020-12-21 | Burnett | Wisconsin | 55013 | 1064 | 16 |
852200 | 852200 | 2020-12-21 | Calumet | Wisconsin | 55015 | 4836 | 32 |
852201 | 852201 | 2020-12-21 | Chippewa | Wisconsin | 55017 | 5739 | 67 |
852202 | 852202 | 2020-12-21 | Clark | Wisconsin | 55019 | 2927 | 50 |
852203 | 852203 | 2020-12-21 | Columbia | Wisconsin | 55021 | 4312 | 28 |
852204 | 852204 | 2020-12-21 | Crawford | Wisconsin | 55023 | 1558 | 11 |
852205 | 852205 | 2020-12-21 | Dane | Wisconsin | 55025 | 32926 | 142 |
852206 | 852206 | 2020-12-21 | Dodge | Wisconsin | 55027 | 10600 | 119 |
852207 | 852207 | 2020-12-21 | Door | Wisconsin | 55029 | 2054 | 14 |
852208 | 852208 | 2020-12-21 | Douglas | Wisconsin | 55031 | 3250 | 29 |
852209 | 852209 | 2020-12-21 | Dunn | Wisconsin | 55033 | 3550 | 21 |
852210 | 852210 | 2020-12-21 | Eau Claire | Wisconsin | 55035 | 9027 | 79 |
852211 | 852211 | 2020-12-21 | Florence | Wisconsin | 55037 | 411 | 12 |
852212 | 852212 | 2020-12-21 | Fond du Lac | Wisconsin | 55039 | 10712 | 69 |
852213 | 852213 | 2020-12-21 | Forest | Wisconsin | 55041 | 861 | 23 |
852214 | 852214 | 2020-12-21 | Grant | Wisconsin | 55043 | 4376 | 82 |
852215 | 852215 | 2020-12-21 | Green | Wisconsin | 55045 | 2206 | 10 |
852216 | 852216 | 2020-12-21 | Green Lake | Wisconsin | 55047 | 1670 | 13 |
852217 | 852217 | 2020-12-21 | Iowa | Wisconsin | 55049 | 1660 | 6 |
852218 | 852218 | 2020-12-21 | Iron | Wisconsin | 55051 | 507 | 20 |
852219 | 852219 | 2020-12-21 | Jackson | Wisconsin | 55053 | 2270 | 13 |
852220 | 852220 | 2020-12-21 | Jefferson | Wisconsin | 55055 | 6877 | 54 |
852221 | 852221 | 2020-12-21 | Juneau | Wisconsin | 55057 | 2349 | 8 |
852222 | 852222 | 2020-12-21 | Kenosha | Wisconsin | 55059 | 12978 | 204 |
852223 | 852223 | 2020-12-21 | Kewaunee | Wisconsin | 55061 | 2065 | 23 |
852224 | 852224 | 2020-12-21 | La Crosse | Wisconsin | 55063 | 10009 | 52 |
852225 | 852225 | 2020-12-21 | Lafayette | Wisconsin | 55065 | 1292 | 6 |
852226 | 852226 | 2020-12-21 | Langlade | Wisconsin | 55067 | 1844 | 40 |
852227 | 852227 | 2020-12-21 | Lincoln | Wisconsin | 55069 | 2440 | 52 |
852228 | 852228 | 2020-12-21 | Manitowoc | Wisconsin | 55071 | 6624 | 55 |
852229 | 852229 | 2020-12-21 | Marathon | Wisconsin | 55073 | 12397 | 163 |
852230 | 852230 | 2020-12-21 | Marinette | Wisconsin | 55075 | 3747 | 39 |
852231 | 852231 | 2020-12-21 | Marquette | Wisconsin | 55077 | 1275 | 20 |
852232 | 852232 | 2020-12-21 | Menominee | Wisconsin | 55078 | 689 | 10 |
852233 | 852233 | 2020-12-21 | Milwaukee | Wisconsin | 55079 | 87522 | 921 |
852234 | 852234 | 2020-12-21 | Monroe | Wisconsin | 55081 | 3304 | 21 |
852235 | 852235 | 2020-12-21 | Oconto | Wisconsin | 55083 | 3911 | 41 |
852236 | 852236 | 2020-12-21 | Oneida | Wisconsin | 55085 | 2786 | 50 |
852237 | 852237 | 2020-12-21 | Outagamie | Wisconsin | 55087 | 16741 | 152 |
852238 | 852238 | 2020-12-21 | Ozaukee | Wisconsin | 55089 | 6597 | 50 |
852239 | 852239 | 2020-12-21 | Pepin | Wisconsin | 55091 | 628 | 5 |
852240 | 852240 | 2020-12-21 | Pierce | Wisconsin | 55093 | 3395 | 30 |
852241 | 852241 | 2020-12-21 | Polk | Wisconsin | 55095 | 2891 | 22 |
852242 | 852242 | 2020-12-21 | Portage | Wisconsin | 55097 | 5662 | 48 |
852243 | 852243 | 2020-12-21 | Price | Wisconsin | 55099 | 962 | 4 |
852244 | 852244 | 2020-12-21 | Racine | Wisconsin | 55101 | 18340 | 246 |
852245 | 852245 | 2020-12-21 | Richland | Wisconsin | 55103 | 1057 | 13 |
852246 | 852246 | 2020-12-21 | Rock | Wisconsin | 55105 | 12194 | 112 |
852247 | 852247 | 2020-12-21 | Rusk | Wisconsin | 55107 | 1096 | 11 |
852248 | 852248 | 2020-12-21 | Sauk | Wisconsin | 55111 | 4449 | 30 |
852249 | 852249 | 2020-12-21 | Sawyer | Wisconsin | 55113 | 1144 | 10 |
852250 | 852250 | 2020-12-21 | Shawano | Wisconsin | 55115 | 4375 | 61 |
852251 | 852251 | 2020-12-21 | Sheboygan | Wisconsin | 55117 | 11367 | 86 |
852252 | 852252 | 2020-12-21 | St. Croix | Wisconsin | 55109 | 6149 | 25 |
852253 | 852253 | 2020-12-21 | Taylor | Wisconsin | 55119 | 1702 | 18 |
852254 | 852254 | 2020-12-21 | Trempealeau | Wisconsin | 55121 | 2926 | 28 |
852255 | 852255 | 2020-12-21 | Vernon | Wisconsin | 55123 | 1456 | 22 |
852256 | 852256 | 2020-12-21 | Vilas | Wisconsin | 55125 | 1571 | 23 |
852257 | 852257 | 2020-12-21 | Walworth | Wisconsin | 55127 | 8902 | 88 |
852258 | 852258 | 2020-12-21 | Washburn | Wisconsin | 55129 | 1032 | 11 |
852259 | 852259 | 2020-12-21 | Washington | Wisconsin | 55131 | 12269 | 97 |
852260 | 852260 | 2020-12-21 | Waukesha | Wisconsin | 55133 | 35107 | 324 |
852261 | 852261 | 2020-12-21 | Waupaca | Wisconsin | 55135 | 4570 | 133 |
852262 | 852262 | 2020-12-21 | Waushara | Wisconsin | 55137 | 2012 | 15 |
852263 | 852263 | 2020-12-21 | Winnebago | Wisconsin | 55139 | 16441 | 161 |
852264 | 852264 | 2020-12-21 | Wood | Wisconsin | 55141 | 5657 | 46 |
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);