ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where date = "2020-05-06" 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 |
---|---|---|---|---|---|---|---|
121199 | 121199 | 2020-05-06 | Adams | Wisconsin | 55001 | 4 | 1 |
121200 | 121200 | 2020-05-06 | Ashland | Wisconsin | 55003 | 2 | 0 |
121201 | 121201 | 2020-05-06 | Barron | Wisconsin | 55005 | 7 | 0 |
121202 | 121202 | 2020-05-06 | Bayfield | Wisconsin | 55007 | 3 | 1 |
121203 | 121203 | 2020-05-06 | Brown | Wisconsin | 55009 | 1653 | 11 |
121204 | 121204 | 2020-05-06 | Buffalo | Wisconsin | 55011 | 6 | 1 |
121205 | 121205 | 2020-05-06 | Calumet | Wisconsin | 55015 | 20 | 0 |
121206 | 121206 | 2020-05-06 | Chippewa | Wisconsin | 55017 | 27 | 0 |
121207 | 121207 | 2020-05-06 | Clark | Wisconsin | 55019 | 22 | 4 |
121208 | 121208 | 2020-05-06 | Columbia | Wisconsin | 55021 | 32 | 1 |
121209 | 121209 | 2020-05-06 | Crawford | Wisconsin | 55023 | 7 | 0 |
121210 | 121210 | 2020-05-06 | Dane | Wisconsin | 55025 | 445 | 22 |
121211 | 121211 | 2020-05-06 | Dodge | Wisconsin | 55027 | 42 | 1 |
121212 | 121212 | 2020-05-06 | Door | Wisconsin | 55029 | 18 | 3 |
121213 | 121213 | 2020-05-06 | Douglas | Wisconsin | 55031 | 10 | 0 |
121214 | 121214 | 2020-05-06 | Dunn | Wisconsin | 55033 | 13 | 0 |
121215 | 121215 | 2020-05-06 | Eau Claire | Wisconsin | 55035 | 45 | 0 |
121216 | 121216 | 2020-05-06 | Florence | Wisconsin | 55037 | 2 | 0 |
121217 | 121217 | 2020-05-06 | Fond du Lac | Wisconsin | 55039 | 83 | 3 |
121218 | 121218 | 2020-05-06 | Forest | Wisconsin | 55041 | 1 | 0 |
121219 | 121219 | 2020-05-06 | Grant | Wisconsin | 55043 | 60 | 7 |
121220 | 121220 | 2020-05-06 | Green | Wisconsin | 55045 | 20 | 0 |
121221 | 121221 | 2020-05-06 | Green Lake | Wisconsin | 55047 | 5 | 0 |
121222 | 121222 | 2020-05-06 | Iowa | Wisconsin | 55049 | 10 | 0 |
121223 | 121223 | 2020-05-06 | Iron | Wisconsin | 55051 | 2 | 1 |
121224 | 121224 | 2020-05-06 | Jackson | Wisconsin | 55053 | 12 | 1 |
121225 | 121225 | 2020-05-06 | Jefferson | Wisconsin | 55055 | 47 | 0 |
121226 | 121226 | 2020-05-06 | Juneau | Wisconsin | 55057 | 19 | 1 |
121227 | 121227 | 2020-05-06 | Kenosha | Wisconsin | 55059 | 580 | 14 |
121228 | 121228 | 2020-05-06 | Kewaunee | Wisconsin | 55061 | 25 | 1 |
121229 | 121229 | 2020-05-06 | La Crosse | Wisconsin | 55063 | 32 | 0 |
121230 | 121230 | 2020-05-06 | Lafayette | Wisconsin | 55065 | 8 | 0 |
121231 | 121231 | 2020-05-06 | Lincoln | Wisconsin | 55069 | 1 | 0 |
121232 | 121232 | 2020-05-06 | Manitowoc | Wisconsin | 55071 | 17 | 1 |
121233 | 121233 | 2020-05-06 | Marathon | Wisconsin | 55073 | 21 | 1 |
121234 | 121234 | 2020-05-06 | Marinette | Wisconsin | 55075 | 13 | 1 |
121235 | 121235 | 2020-05-06 | Marquette | Wisconsin | 55077 | 3 | 1 |
121236 | 121236 | 2020-05-06 | Menominee | Wisconsin | 55078 | 1 | 0 |
121237 | 121237 | 2020-05-06 | Milwaukee | Wisconsin | 55079 | 3469 | 204 |
121238 | 121238 | 2020-05-06 | Monroe | Wisconsin | 55081 | 14 | 1 |
121239 | 121239 | 2020-05-06 | Oconto | Wisconsin | 55083 | 23 | 0 |
121240 | 121240 | 2020-05-06 | Oneida | Wisconsin | 55085 | 6 | 0 |
121241 | 121241 | 2020-05-06 | Outagamie | Wisconsin | 55087 | 83 | 2 |
121242 | 121242 | 2020-05-06 | Ozaukee | Wisconsin | 55089 | 95 | 9 |
121243 | 121243 | 2020-05-06 | Pierce | Wisconsin | 55093 | 11 | 0 |
121244 | 121244 | 2020-05-06 | Polk | Wisconsin | 55095 | 5 | 0 |
121245 | 121245 | 2020-05-06 | Portage | Wisconsin | 55097 | 7 | 0 |
121246 | 121246 | 2020-05-06 | Price | Wisconsin | 55099 | 1 | 0 |
121247 | 121247 | 2020-05-06 | Racine | Wisconsin | 55101 | 710 | 15 |
121248 | 121248 | 2020-05-06 | Richland | Wisconsin | 55103 | 13 | 2 |
121249 | 121249 | 2020-05-06 | Rock | Wisconsin | 55105 | 311 | 10 |
121250 | 121250 | 2020-05-06 | Rusk | Wisconsin | 55107 | 4 | 0 |
121251 | 121251 | 2020-05-06 | Sauk | Wisconsin | 55111 | 70 | 3 |
121252 | 121252 | 2020-05-06 | Sawyer | Wisconsin | 55113 | 4 | 0 |
121253 | 121253 | 2020-05-06 | Shawano | Wisconsin | 55115 | 17 | 0 |
121254 | 121254 | 2020-05-06 | Sheboygan | Wisconsin | 55117 | 59 | 2 |
121255 | 121255 | 2020-05-06 | St. Croix | Wisconsin | 55109 | 23 | 0 |
121256 | 121256 | 2020-05-06 | Trempealeau | Wisconsin | 55121 | 5 | 0 |
121257 | 121257 | 2020-05-06 | Vernon | Wisconsin | 55123 | 2 | 0 |
121258 | 121258 | 2020-05-06 | Vilas | Wisconsin | 55125 | 4 | 0 |
121259 | 121259 | 2020-05-06 | Walworth | Wisconsin | 55127 | 215 | 9 |
121260 | 121260 | 2020-05-06 | Washburn | Wisconsin | 55129 | 1 | 0 |
121261 | 121261 | 2020-05-06 | Washington | Wisconsin | 55131 | 107 | 4 |
121262 | 121262 | 2020-05-06 | Waukesha | Wisconsin | 55133 | 374 | 22 |
121263 | 121263 | 2020-05-06 | Waupaca | Wisconsin | 55135 | 10 | 1 |
121264 | 121264 | 2020-05-06 | Waushara | Wisconsin | 55137 | 4 | 0 |
121265 | 121265 | 2020-05-06 | Winnebago | Wisconsin | 55139 | 85 | 1 |
121266 | 121266 | 2020-05-06 | Wood | Wisconsin | 55141 | 2 | 0 |
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);