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-06-06 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
215238 | 215238 | 2020-06-06 | Adams | Wisconsin | 55001 | 5 | 1 |
215239 | 215239 | 2020-06-06 | Ashland | Wisconsin | 55003 | 3 | 0 |
215240 | 215240 | 2020-06-06 | Barron | Wisconsin | 55005 | 20 | 0 |
215241 | 215241 | 2020-06-06 | Bayfield | Wisconsin | 55007 | 3 | 1 |
215242 | 215242 | 2020-06-06 | Brown | Wisconsin | 55009 | 2374 | 38 |
215243 | 215243 | 2020-06-06 | Buffalo | Wisconsin | 55011 | 6 | 2 |
215244 | 215244 | 2020-06-06 | Burnett | Wisconsin | 55013 | 1 | 1 |
215245 | 215245 | 2020-06-06 | Calumet | Wisconsin | 55015 | 79 | 1 |
215246 | 215246 | 2020-06-06 | Chippewa | Wisconsin | 55017 | 58 | 0 |
215247 | 215247 | 2020-06-06 | Clark | Wisconsin | 55019 | 42 | 4 |
215248 | 215248 | 2020-06-06 | Columbia | Wisconsin | 55021 | 44 | 1 |
215249 | 215249 | 2020-06-06 | Crawford | Wisconsin | 55023 | 26 | 0 |
215250 | 215250 | 2020-06-06 | Dane | Wisconsin | 55025 | 824 | 29 |
215251 | 215251 | 2020-06-06 | Dodge | Wisconsin | 55027 | 395 | 4 |
215252 | 215252 | 2020-06-06 | Door | Wisconsin | 55029 | 39 | 3 |
215253 | 215253 | 2020-06-06 | Douglas | Wisconsin | 55031 | 20 | 0 |
215254 | 215254 | 2020-06-06 | Dunn | Wisconsin | 55033 | 27 | 0 |
215255 | 215255 | 2020-06-06 | Eau Claire | Wisconsin | 55035 | 121 | 0 |
215256 | 215256 | 2020-06-06 | Florence | Wisconsin | 55037 | 2 | 0 |
215257 | 215257 | 2020-06-06 | Fond du Lac | Wisconsin | 55039 | 233 | 6 |
215258 | 215258 | 2020-06-06 | Forest | Wisconsin | 55041 | 33 | 2 |
215259 | 215259 | 2020-06-06 | Grant | Wisconsin | 55043 | 98 | 12 |
215260 | 215260 | 2020-06-06 | Green | Wisconsin | 55045 | 71 | 0 |
215261 | 215261 | 2020-06-06 | Green Lake | Wisconsin | 55047 | 22 | 0 |
215262 | 215262 | 2020-06-06 | Iowa | Wisconsin | 55049 | 16 | 0 |
215263 | 215263 | 2020-06-06 | Iron | Wisconsin | 55051 | 2 | 1 |
215264 | 215264 | 2020-06-06 | Jackson | Wisconsin | 55053 | 18 | 1 |
215265 | 215265 | 2020-06-06 | Jefferson | Wisconsin | 55055 | 124 | 3 |
215266 | 215266 | 2020-06-06 | Juneau | Wisconsin | 55057 | 23 | 1 |
215267 | 215267 | 2020-06-06 | Kenosha | Wisconsin | 55059 | 1267 | 34 |
215268 | 215268 | 2020-06-06 | Kewaunee | Wisconsin | 55061 | 36 | 1 |
215269 | 215269 | 2020-06-06 | La Crosse | Wisconsin | 55063 | 68 | 0 |
215270 | 215270 | 2020-06-06 | Lafayette | Wisconsin | 55065 | 30 | 0 |
215271 | 215271 | 2020-06-06 | Langlade | Wisconsin | 55067 | 4 | 0 |
215272 | 215272 | 2020-06-06 | Lincoln | Wisconsin | 55069 | 7 | 0 |
215273 | 215273 | 2020-06-06 | Manitowoc | Wisconsin | 55071 | 39 | 1 |
215274 | 215274 | 2020-06-06 | Marathon | Wisconsin | 55073 | 63 | 1 |
215275 | 215275 | 2020-06-06 | Marinette | Wisconsin | 55075 | 33 | 3 |
215276 | 215276 | 2020-06-06 | Marquette | Wisconsin | 55077 | 5 | 1 |
215277 | 215277 | 2020-06-06 | Menominee | Wisconsin | 55078 | 3 | 0 |
215278 | 215278 | 2020-06-06 | Milwaukee | Wisconsin | 55079 | 8709 | 325 |
215279 | 215279 | 2020-06-06 | Monroe | Wisconsin | 55081 | 18 | 1 |
215280 | 215280 | 2020-06-06 | Oconto | Wisconsin | 55083 | 41 | 0 |
215281 | 215281 | 2020-06-06 | Oneida | Wisconsin | 55085 | 12 | 0 |
215282 | 215282 | 2020-06-06 | Outagamie | Wisconsin | 55087 | 263 | 8 |
215283 | 215283 | 2020-06-06 | Ozaukee | Wisconsin | 55089 | 190 | 14 |
215284 | 215284 | 2020-06-06 | Pepin | Wisconsin | 55091 | 1 | 0 |
215285 | 215285 | 2020-06-06 | Pierce | Wisconsin | 55093 | 50 | 0 |
215286 | 215286 | 2020-06-06 | Polk | Wisconsin | 55095 | 33 | 1 |
215287 | 215287 | 2020-06-06 | Portage | Wisconsin | 55097 | 33 | 0 |
215288 | 215288 | 2020-06-06 | Price | Wisconsin | 55099 | 2 | 0 |
215289 | 215289 | 2020-06-06 | Racine | Wisconsin | 55101 | 2202 | 47 |
215290 | 215290 | 2020-06-06 | Richland | Wisconsin | 55103 | 14 | 4 |
215291 | 215291 | 2020-06-06 | Rock | Wisconsin | 55105 | 770 | 21 |
215292 | 215292 | 2020-06-06 | Rusk | Wisconsin | 55107 | 5 | 0 |
215293 | 215293 | 2020-06-06 | Sauk | Wisconsin | 55111 | 81 | 3 |
215294 | 215294 | 2020-06-06 | Sawyer | Wisconsin | 55113 | 8 | 0 |
215295 | 215295 | 2020-06-06 | Shawano | Wisconsin | 55115 | 56 | 0 |
215296 | 215296 | 2020-06-06 | Sheboygan | Wisconsin | 55117 | 111 | 3 |
215297 | 215297 | 2020-06-06 | St. Croix | Wisconsin | 55109 | 105 | 0 |
215298 | 215298 | 2020-06-06 | Taylor | Wisconsin | 55119 | 2 | 0 |
215299 | 215299 | 2020-06-06 | Trempealeau | Wisconsin | 55121 | 38 | 0 |
215300 | 215300 | 2020-06-06 | Vernon | Wisconsin | 55123 | 21 | 0 |
215301 | 215301 | 2020-06-06 | Vilas | Wisconsin | 55125 | 8 | 0 |
215302 | 215302 | 2020-06-06 | Walworth | Wisconsin | 55127 | 435 | 17 |
215303 | 215303 | 2020-06-06 | Washburn | Wisconsin | 55129 | 3 | 0 |
215304 | 215304 | 2020-06-06 | Washington | Wisconsin | 55131 | 277 | 9 |
215305 | 215305 | 2020-06-06 | Waukesha | Wisconsin | 55133 | 799 | 32 |
215306 | 215306 | 2020-06-06 | Waupaca | Wisconsin | 55135 | 51 | 1 |
215307 | 215307 | 2020-06-06 | Waushara | Wisconsin | 55137 | 10 | 0 |
215308 | 215308 | 2020-06-06 | Winnebago | Wisconsin | 55139 | 354 | 7 |
215309 | 215309 | 2020-06-06 | Wood | Wisconsin | 55141 | 11 | 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);