ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2021-10-05" 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 |
---|---|---|---|---|---|---|---|
1787278 | 1787278 | 2021-10-05 | Adams | Wisconsin | 55001 | 2570 | 33 |
1787279 | 1787279 | 2021-10-05 | Ashland | Wisconsin | 55003 | 1735 | 16 |
1787280 | 1787280 | 2021-10-05 | Barron | Wisconsin | 55005 | 7816 | 87 |
1787281 | 1787281 | 2021-10-05 | Bayfield | Wisconsin | 55007 | 1532 | 24 |
1787282 | 1787282 | 2021-10-05 | Brown | Wisconsin | 55009 | 42669 | 315 |
1787283 | 1787283 | 2021-10-05 | Buffalo | Wisconsin | 55011 | 1835 | 7 |
1787284 | 1787284 | 2021-10-05 | Burnett | Wisconsin | 55013 | 1975 | 29 |
1787285 | 1787285 | 2021-10-05 | Calumet | Wisconsin | 55015 | 7806 | 59 |
1787286 | 1787286 | 2021-10-05 | Chippewa | Wisconsin | 55017 | 10175 | 113 |
1787287 | 1787287 | 2021-10-05 | Clark | Wisconsin | 55019 | 4549 | 73 |
1787288 | 1787288 | 2021-10-05 | Columbia | Wisconsin | 55021 | 7433 | 78 |
1787289 | 1787289 | 2021-10-05 | Crawford | Wisconsin | 55023 | 2133 | 22 |
1787290 | 1787290 | 2021-10-05 | Dane | Wisconsin | 55025 | 55362 | 359 |
1787291 | 1787291 | 2021-10-05 | Dodge | Wisconsin | 55027 | 15296 | 219 |
1787292 | 1787292 | 2021-10-05 | Door | Wisconsin | 55029 | 3503 | 38 |
1787293 | 1787293 | 2021-10-05 | Douglas | Wisconsin | 55031 | 5623 | 66 |
1787294 | 1787294 | 2021-10-05 | Dunn | Wisconsin | 55033 | 6540 | 43 |
1787295 | 1787295 | 2021-10-05 | Eau Claire | Wisconsin | 55035 | 15105 | 132 |
1787296 | 1787296 | 2021-10-05 | Florence | Wisconsin | 55037 | 577 | 13 |
1787297 | 1787297 | 2021-10-05 | Fond du Lac | Wisconsin | 55039 | 16950 | 154 |
1787298 | 1787298 | 2021-10-05 | Forest | Wisconsin | 55041 | 1421 | 31 |
1787299 | 1787299 | 2021-10-05 | Grant | Wisconsin | 55043 | 7022 | 106 |
1787300 | 1787300 | 2021-10-05 | Green | Wisconsin | 55045 | 4323 | 26 |
1787301 | 1787301 | 2021-10-05 | Green Lake | Wisconsin | 55047 | 2820 | 29 |
1787302 | 1787302 | 2021-10-05 | Iowa | Wisconsin | 55049 | 2578 | 16 |
1787303 | 1787303 | 2021-10-05 | Iron | Wisconsin | 55051 | 826 | 42 |
1787304 | 1787304 | 2021-10-05 | Jackson | Wisconsin | 55053 | 3208 | 31 |
1787305 | 1787305 | 2021-10-05 | Jefferson | Wisconsin | 55055 | 11345 | 147 |
1787306 | 1787306 | 2021-10-05 | Juneau | Wisconsin | 55057 | 3979 | 33 |
1787307 | 1787307 | 2021-10-05 | Kenosha | Wisconsin | 55059 | 22946 | 364 |
1787308 | 1787308 | 2021-10-05 | Kewaunee | Wisconsin | 55061 | 3330 | 41 |
1787309 | 1787309 | 2021-10-05 | La Crosse | Wisconsin | 55063 | 16477 | 105 |
1787310 | 1787310 | 2021-10-05 | Lafayette | Wisconsin | 55065 | 2001 | 12 |
1787311 | 1787311 | 2021-10-05 | Langlade | Wisconsin | 55067 | 2887 | 54 |
1787312 | 1787312 | 2021-10-05 | Lincoln | Wisconsin | 55069 | 3995 | 106 |
1787313 | 1787313 | 2021-10-05 | Manitowoc | Wisconsin | 55071 | 10836 | 103 |
1787314 | 1787314 | 2021-10-05 | Marathon | Wisconsin | 55073 | 19661 | 254 |
1787315 | 1787315 | 2021-10-05 | Marinette | Wisconsin | 55075 | 6013 | 78 |
1787316 | 1787316 | 2021-10-05 | Marquette | Wisconsin | 55077 | 2033 | 30 |
1787317 | 1787317 | 2021-10-05 | Menominee | Wisconsin | 55078 | 915 | 11 |
1787318 | 1787318 | 2021-10-05 | Milwaukee | Wisconsin | 55079 | 145197 | 1562 |
1787319 | 1787319 | 2021-10-05 | Monroe | Wisconsin | 55081 | 5950 | 54 |
1787320 | 1787320 | 2021-10-05 | Oconto | Wisconsin | 55083 | 6628 | 76 |
1787321 | 1787321 | 2021-10-05 | Oneida | Wisconsin | 55085 | 4592 | 85 |
1787322 | 1787322 | 2021-10-05 | Outagamie | Wisconsin | 55087 | 28591 | 261 |
1787323 | 1787323 | 2021-10-05 | Ozaukee | Wisconsin | 55089 | 11684 | 113 |
1787324 | 1787324 | 2021-10-05 | Pepin | Wisconsin | 55091 | 1110 | 10 |
1787325 | 1787325 | 2021-10-05 | Pierce | Wisconsin | 55093 | 5934 | 44 |
1787326 | 1787326 | 2021-10-05 | Polk | Wisconsin | 55095 | 6270 | 75 |
1787327 | 1787327 | 2021-10-05 | Portage | Wisconsin | 55097 | 8979 | 90 |
1787328 | 1787328 | 2021-10-05 | Price | Wisconsin | 55099 | 1642 | 9 |
1787329 | 1787329 | 2021-10-05 | Racine | Wisconsin | 55101 | 30439 | 440 |
1787330 | 1787330 | 2021-10-05 | Richland | Wisconsin | 55103 | 1886 | 22 |
1787331 | 1787331 | 2021-10-05 | Rock | Wisconsin | 55105 | 21397 | 227 |
1787332 | 1787332 | 2021-10-05 | Rusk | Wisconsin | 55107 | 2032 | 31 |
1787333 | 1787333 | 2021-10-05 | Sauk | Wisconsin | 55111 | 7765 | 63 |
1787334 | 1787334 | 2021-10-05 | Sawyer | Wisconsin | 55113 | 2312 | 31 |
1787335 | 1787335 | 2021-10-05 | Shawano | Wisconsin | 55115 | 6600 | 89 |
1787336 | 1787336 | 2021-10-05 | Sheboygan | Wisconsin | 55117 | 17273 | 175 |
1787337 | 1787337 | 2021-10-05 | St. Croix | Wisconsin | 55109 | 12058 | 83 |
1787338 | 1787338 | 2021-10-05 | Taylor | Wisconsin | 55119 | 2764 | 43 |
1787339 | 1787339 | 2021-10-05 | Trempealeau | Wisconsin | 55121 | 4676 | 52 |
1787340 | 1787340 | 2021-10-05 | Vernon | Wisconsin | 55123 | 2680 | 54 |
1787341 | 1787341 | 2021-10-05 | Vilas | Wisconsin | 55125 | 2870 | 50 |
1787342 | 1787342 | 2021-10-05 | Walworth | Wisconsin | 55127 | 14934 | 183 |
1787343 | 1787343 | 2021-10-05 | Washburn | Wisconsin | 55129 | 2043 | 25 |
1787344 | 1787344 | 2021-10-05 | Washington | Wisconsin | 55131 | 21100 | 218 |
1787345 | 1787345 | 2021-10-05 | Waukesha | Wisconsin | 55133 | 59609 | 695 |
1787346 | 1787346 | 2021-10-05 | Waupaca | Wisconsin | 55135 | 7621 | 178 |
1787347 | 1787347 | 2021-10-05 | Waushara | Wisconsin | 55137 | 3359 | 48 |
1787348 | 1787348 | 2021-10-05 | Winnebago | Wisconsin | 55139 | 26021 | 248 |
1787349 | 1787349 | 2021-10-05 | Wood | Wisconsin | 55141 | 9883 | 127 |
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);