ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where "date" is on date 2020-09-22 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
560225 | 560225 | 2020-09-22 | Adams | Wisconsin | 55001 | 222 | 4 |
560226 | 560226 | 2020-09-22 | Ashland | Wisconsin | 55003 | 77 | 2 |
560227 | 560227 | 2020-09-22 | Barron | Wisconsin | 55005 | 443 | 4 |
560228 | 560228 | 2020-09-22 | Bayfield | Wisconsin | 55007 | 94 | 1 |
560229 | 560229 | 2020-09-22 | Brown | Wisconsin | 55009 | 7878 | 60 |
560230 | 560230 | 2020-09-22 | Buffalo | Wisconsin | 55011 | 128 | 2 |
560231 | 560231 | 2020-09-22 | Burnett | Wisconsin | 55013 | 144 | 3 |
560232 | 560232 | 2020-09-22 | Calumet | Wisconsin | 55015 | 956 | 2 |
560233 | 560233 | 2020-09-22 | Chippewa | Wisconsin | 55017 | 507 | 0 |
560234 | 560234 | 2020-09-22 | Clark | Wisconsin | 55019 | 360 | 8 |
560235 | 560235 | 2020-09-22 | Columbia | Wisconsin | 55021 | 577 | 2 |
560236 | 560236 | 2020-09-22 | Crawford | Wisconsin | 55023 | 145 | 0 |
560237 | 560237 | 2020-09-22 | Dane | Wisconsin | 55025 | 9406 | 41 |
560238 | 560238 | 2020-09-22 | Dodge | Wisconsin | 55027 | 1676 | 10 |
560239 | 560239 | 2020-09-22 | Door | Wisconsin | 55029 | 262 | 3 |
560240 | 560240 | 2020-09-22 | Douglas | Wisconsin | 55031 | 401 | 0 |
560241 | 560241 | 2020-09-22 | Dunn | Wisconsin | 55033 | 426 | 0 |
560242 | 560242 | 2020-09-22 | Eau Claire | Wisconsin | 55035 | 1671 | 6 |
560243 | 560243 | 2020-09-22 | Florence | Wisconsin | 55037 | 69 | 1 |
560244 | 560244 | 2020-09-22 | Fond du Lac | Wisconsin | 55039 | 1847 | 13 |
560245 | 560245 | 2020-09-22 | Forest | Wisconsin | 55041 | 226 | 4 |
560246 | 560246 | 2020-09-22 | Grant | Wisconsin | 55043 | 887 | 19 |
560247 | 560247 | 2020-09-22 | Green | Wisconsin | 55045 | 469 | 2 |
560248 | 560248 | 2020-09-22 | Green Lake | Wisconsin | 55047 | 249 | 0 |
560249 | 560249 | 2020-09-22 | Iowa | Wisconsin | 55049 | 179 | 0 |
560250 | 560250 | 2020-09-22 | Iron | Wisconsin | 55051 | 144 | 1 |
560251 | 560251 | 2020-09-22 | Jackson | Wisconsin | 55053 | 111 | 1 |
560252 | 560252 | 2020-09-22 | Jefferson | Wisconsin | 55055 | 1316 | 7 |
560253 | 560253 | 2020-09-22 | Juneau | Wisconsin | 55057 | 335 | 2 |
560254 | 560254 | 2020-09-22 | Kenosha | Wisconsin | 55059 | 3695 | 65 |
560255 | 560255 | 2020-09-22 | Kewaunee | Wisconsin | 55061 | 420 | 2 |
560256 | 560256 | 2020-09-22 | La Crosse | Wisconsin | 55063 | 2846 | 2 |
560257 | 560257 | 2020-09-22 | Lafayette | Wisconsin | 55065 | 231 | 0 |
560258 | 560258 | 2020-09-22 | Langlade | Wisconsin | 55067 | 137 | 2 |
560259 | 560259 | 2020-09-22 | Lincoln | Wisconsin | 55069 | 169 | 1 |
560260 | 560260 | 2020-09-22 | Manitowoc | Wisconsin | 55071 | 963 | 2 |
560261 | 560261 | 2020-09-22 | Marathon | Wisconsin | 55073 | 1210 | 14 |
560262 | 560262 | 2020-09-22 | Marinette | Wisconsin | 55075 | 788 | 7 |
560263 | 560263 | 2020-09-22 | Marquette | Wisconsin | 55077 | 210 | 1 |
560264 | 560264 | 2020-09-22 | Menominee | Wisconsin | 55078 | 55 | 0 |
560265 | 560265 | 2020-09-22 | Milwaukee | Wisconsin | 55079 | 28843 | 525 |
560266 | 560266 | 2020-09-22 | Monroe | Wisconsin | 55081 | 421 | 2 |
560267 | 560267 | 2020-09-22 | Oconto | Wisconsin | 55083 | 744 | 4 |
560268 | 560268 | 2020-09-22 | Oneida | Wisconsin | 55085 | 362 | 2 |
560269 | 560269 | 2020-09-22 | Outagamie | Wisconsin | 55087 | 3923 | 28 |
560270 | 560270 | 2020-09-22 | Ozaukee | Wisconsin | 55089 | 1334 | 19 |
560271 | 560271 | 2020-09-22 | Pepin | Wisconsin | 55091 | 59 | 0 |
560272 | 560272 | 2020-09-22 | Pierce | Wisconsin | 55093 | 628 | 6 |
560273 | 560273 | 2020-09-22 | Polk | Wisconsin | 55095 | 230 | 2 |
560274 | 560274 | 2020-09-22 | Portage | Wisconsin | 55097 | 1281 | 4 |
560275 | 560275 | 2020-09-22 | Price | Wisconsin | 55099 | 57 | 0 |
560276 | 560276 | 2020-09-22 | Racine | Wisconsin | 55101 | 5036 | 94 |
560277 | 560277 | 2020-09-22 | Richland | Wisconsin | 55103 | 104 | 4 |
560278 | 560278 | 2020-09-22 | Rock | Wisconsin | 55105 | 2478 | 32 |
560279 | 560279 | 2020-09-22 | Rusk | Wisconsin | 55107 | 58 | 1 |
560280 | 560280 | 2020-09-22 | Sauk | Wisconsin | 55111 | 879 | 3 |
560281 | 560281 | 2020-09-22 | Sawyer | Wisconsin | 55113 | 196 | 1 |
560282 | 560282 | 2020-09-22 | Shawano | Wisconsin | 55115 | 611 | 1 |
560283 | 560283 | 2020-09-22 | Sheboygan | Wisconsin | 55117 | 1544 | 15 |
560284 | 560284 | 2020-09-22 | St. Croix | Wisconsin | 55109 | 901 | 8 |
560285 | 560285 | 2020-09-22 | Taylor | Wisconsin | 55119 | 159 | 3 |
560286 | 560286 | 2020-09-22 | Trempealeau | Wisconsin | 55121 | 586 | 2 |
560287 | 560287 | 2020-09-22 | Unknown | Wisconsin | 0 | 8 | |
560288 | 560288 | 2020-09-22 | Vernon | Wisconsin | 55123 | 188 | 0 |
560289 | 560289 | 2020-09-22 | Vilas | Wisconsin | 55125 | 178 | 1 |
560290 | 560290 | 2020-09-22 | Walworth | Wisconsin | 55127 | 2630 | 34 |
560291 | 560291 | 2020-09-22 | Washburn | Wisconsin | 55129 | 97 | 1 |
560292 | 560292 | 2020-09-22 | Washington | Wisconsin | 55131 | 2395 | 32 |
560293 | 560293 | 2020-09-22 | Waukesha | Wisconsin | 55133 | 7386 | 85 |
560294 | 560294 | 2020-09-22 | Waupaca | Wisconsin | 55135 | 1039 | 19 |
560295 | 560295 | 2020-09-22 | Waushara | Wisconsin | 55137 | 290 | 2 |
560296 | 560296 | 2020-09-22 | Winnebago | Wisconsin | 55139 | 3079 | 23 |
560297 | 560297 | 2020-09-22 | Wood | Wisconsin | 55141 | 748 | 4 |
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);