ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where date = "2020-07-07" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312270 | 312270 | 2020-07-07 | Adams | Wisconsin | 55001 | 33 | 2 |
312271 | 312271 | 2020-07-07 | Ashland | Wisconsin | 55003 | 3 | 0 |
312272 | 312272 | 2020-07-07 | Barron | Wisconsin | 55005 | 36 | 1 |
312273 | 312273 | 2020-07-07 | Bayfield | Wisconsin | 55007 | 4 | 1 |
312274 | 312274 | 2020-07-07 | Brown | Wisconsin | 55009 | 3072 | 42 |
312275 | 312275 | 2020-07-07 | Buffalo | Wisconsin | 55011 | 9 | 2 |
312276 | 312276 | 2020-07-07 | Burnett | Wisconsin | 55013 | 5 | 1 |
312277 | 312277 | 2020-07-07 | Calumet | Wisconsin | 55015 | 125 | 2 |
312278 | 312278 | 2020-07-07 | Chippewa | Wisconsin | 55017 | 118 | 0 |
312279 | 312279 | 2020-07-07 | Clark | Wisconsin | 55019 | 87 | 7 |
312280 | 312280 | 2020-07-07 | Columbia | Wisconsin | 55021 | 104 | 1 |
312281 | 312281 | 2020-07-07 | Crawford | Wisconsin | 55023 | 41 | 0 |
312282 | 312282 | 2020-07-07 | Dane | Wisconsin | 55025 | 2510 | 32 |
312283 | 312283 | 2020-07-07 | Dodge | Wisconsin | 55027 | 487 | 5 |
312284 | 312284 | 2020-07-07 | Door | Wisconsin | 55029 | 49 | 3 |
312285 | 312285 | 2020-07-07 | Douglas | Wisconsin | 55031 | 46 | 0 |
312286 | 312286 | 2020-07-07 | Dunn | Wisconsin | 55033 | 47 | 0 |
312287 | 312287 | 2020-07-07 | Eau Claire | Wisconsin | 55035 | 300 | 1 |
312288 | 312288 | 2020-07-07 | Florence | Wisconsin | 55037 | 4 | 0 |
312289 | 312289 | 2020-07-07 | Fond du Lac | Wisconsin | 55039 | 339 | 6 |
312290 | 312290 | 2020-07-07 | Forest | Wisconsin | 55041 | 40 | 3 |
312291 | 312291 | 2020-07-07 | Grant | Wisconsin | 55043 | 178 | 13 |
312292 | 312292 | 2020-07-07 | Green | Wisconsin | 55045 | 100 | 1 |
312293 | 312293 | 2020-07-07 | Green Lake | Wisconsin | 55047 | 40 | 0 |
312294 | 312294 | 2020-07-07 | Iowa | Wisconsin | 55049 | 38 | 0 |
312295 | 312295 | 2020-07-07 | Iron | Wisconsin | 55051 | 8 | 1 |
312296 | 312296 | 2020-07-07 | Jackson | Wisconsin | 55053 | 31 | 1 |
312297 | 312297 | 2020-07-07 | Jefferson | Wisconsin | 55055 | 292 | 4 |
312298 | 312298 | 2020-07-07 | Juneau | Wisconsin | 55057 | 43 | 1 |
312299 | 312299 | 2020-07-07 | Kenosha | Wisconsin | 55059 | 1626 | 44 |
312300 | 312300 | 2020-07-07 | Kewaunee | Wisconsin | 55061 | 64 | 1 |
312301 | 312301 | 2020-07-07 | La Crosse | Wisconsin | 55063 | 524 | 0 |
312302 | 312302 | 2020-07-07 | Lafayette | Wisconsin | 55065 | 76 | 0 |
312303 | 312303 | 2020-07-07 | Langlade | Wisconsin | 55067 | 11 | 0 |
312304 | 312304 | 2020-07-07 | Lincoln | Wisconsin | 55069 | 17 | 0 |
312305 | 312305 | 2020-07-07 | Manitowoc | Wisconsin | 55071 | 122 | 1 |
312306 | 312306 | 2020-07-07 | Marathon | Wisconsin | 55073 | 226 | 1 |
312307 | 312307 | 2020-07-07 | Marinette | Wisconsin | 55075 | 71 | 3 |
312308 | 312308 | 2020-07-07 | Marquette | Wisconsin | 55077 | 31 | 1 |
312309 | 312309 | 2020-07-07 | Menominee | Wisconsin | 55078 | 7 | 0 |
312310 | 312310 | 2020-07-07 | Milwaukee | Wisconsin | 55079 | 12577 | 398 |
312311 | 312311 | 2020-07-07 | Monroe | Wisconsin | 55081 | 90 | 1 |
312312 | 312312 | 2020-07-07 | Oconto | Wisconsin | 55083 | 69 | 0 |
312313 | 312313 | 2020-07-07 | Oneida | Wisconsin | 55085 | 21 | 0 |
312314 | 312314 | 2020-07-07 | Outagamie | Wisconsin | 55087 | 577 | 9 |
312315 | 312315 | 2020-07-07 | Ozaukee | Wisconsin | 55089 | 282 | 17 |
312316 | 312316 | 2020-07-07 | Pepin | Wisconsin | 55091 | 1 | 0 |
312317 | 312317 | 2020-07-07 | Pierce | Wisconsin | 55093 | 77 | 0 |
312318 | 312318 | 2020-07-07 | Polk | Wisconsin | 55095 | 61 | 2 |
312319 | 312319 | 2020-07-07 | Portage | Wisconsin | 55097 | 200 | 0 |
312320 | 312320 | 2020-07-07 | Price | Wisconsin | 55099 | 2 | 0 |
312321 | 312321 | 2020-07-07 | Racine | Wisconsin | 55101 | 2594 | 65 |
312322 | 312322 | 2020-07-07 | Richland | Wisconsin | 55103 | 15 | 4 |
312323 | 312323 | 2020-07-07 | Rock | Wisconsin | 55105 | 1053 | 24 |
312324 | 312324 | 2020-07-07 | Rusk | Wisconsin | 55107 | 11 | 1 |
312325 | 312325 | 2020-07-07 | Sauk | Wisconsin | 55111 | 123 | 3 |
312326 | 312326 | 2020-07-07 | Sawyer | Wisconsin | 55113 | 13 | 0 |
312327 | 312327 | 2020-07-07 | Shawano | Wisconsin | 55115 | 86 | 0 |
312328 | 312328 | 2020-07-07 | Sheboygan | Wisconsin | 55117 | 245 | 4 |
312329 | 312329 | 2020-07-07 | St. Croix | Wisconsin | 55109 | 231 | 1 |
312330 | 312330 | 2020-07-07 | Taylor | Wisconsin | 55119 | 16 | 0 |
312331 | 312331 | 2020-07-07 | Trempealeau | Wisconsin | 55121 | 140 | 0 |
312332 | 312332 | 2020-07-07 | Unknown | Wisconsin | 2762 | 7 | |
312333 | 312333 | 2020-07-07 | Vernon | Wisconsin | 55123 | 38 | 0 |
312334 | 312334 | 2020-07-07 | Vilas | Wisconsin | 55125 | 14 | 0 |
312335 | 312335 | 2020-07-07 | Walworth | Wisconsin | 55127 | 701 | 18 |
312336 | 312336 | 2020-07-07 | Washburn | Wisconsin | 55129 | 5 | 0 |
312337 | 312337 | 2020-07-07 | Washington | Wisconsin | 55131 | 449 | 19 |
312338 | 312338 | 2020-07-07 | Waukesha | Wisconsin | 55133 | 1429 | 39 |
312339 | 312339 | 2020-07-07 | Waupaca | Wisconsin | 55135 | 145 | 10 |
312340 | 312340 | 2020-07-07 | Waushara | Wisconsin | 55137 | 34 | 0 |
312341 | 312341 | 2020-07-07 | Winnebago | Wisconsin | 55139 | 723 | 13 |
312342 | 312342 | 2020-07-07 | Wood | Wisconsin | 55141 | 86 | 1 |
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);