ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2020-12-13" 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 |
---|---|---|---|---|---|---|---|
826228 | 826228 | 2020-12-13 | Adams | Wisconsin | 55001 | 1287 | 12 |
826229 | 826229 | 2020-12-13 | Ashland | Wisconsin | 55003 | 908 | 13 |
826230 | 826230 | 2020-12-13 | Barron | Wisconsin | 55005 | 4098 | 50 |
826231 | 826231 | 2020-12-13 | Bayfield | Wisconsin | 55007 | 841 | 16 |
826232 | 826232 | 2020-12-13 | Brown | Wisconsin | 55009 | 25542 | 160 |
826233 | 826233 | 2020-12-13 | Buffalo | Wisconsin | 55011 | 920 | 6 |
826234 | 826234 | 2020-12-13 | Burnett | Wisconsin | 55013 | 1005 | 15 |
826235 | 826235 | 2020-12-13 | Calumet | Wisconsin | 55015 | 4661 | 31 |
826236 | 826236 | 2020-12-13 | Chippewa | Wisconsin | 55017 | 5506 | 62 |
826237 | 826237 | 2020-12-13 | Clark | Wisconsin | 55019 | 2740 | 48 |
826238 | 826238 | 2020-12-13 | Columbia | Wisconsin | 55021 | 4124 | 20 |
826239 | 826239 | 2020-12-13 | Crawford | Wisconsin | 55023 | 1505 | 10 |
826240 | 826240 | 2020-12-13 | Dane | Wisconsin | 55025 | 31508 | 117 |
826241 | 826241 | 2020-12-13 | Dodge | Wisconsin | 55027 | 10176 | 94 |
826242 | 826242 | 2020-12-13 | Door | Wisconsin | 55029 | 1926 | 12 |
826243 | 826243 | 2020-12-13 | Douglas | Wisconsin | 55031 | 2913 | 26 |
826244 | 826244 | 2020-12-13 | Dunn | Wisconsin | 55033 | 3347 | 18 |
826245 | 826245 | 2020-12-13 | Eau Claire | Wisconsin | 55035 | 8673 | 74 |
826246 | 826246 | 2020-12-13 | Florence | Wisconsin | 55037 | 401 | 12 |
826247 | 826247 | 2020-12-13 | Fond du Lac | Wisconsin | 55039 | 10204 | 66 |
826248 | 826248 | 2020-12-13 | Forest | Wisconsin | 55041 | 835 | 22 |
826249 | 826249 | 2020-12-13 | Grant | Wisconsin | 55043 | 4223 | 74 |
826250 | 826250 | 2020-12-13 | Green | Wisconsin | 55045 | 2057 | 9 |
826251 | 826251 | 2020-12-13 | Green Lake | Wisconsin | 55047 | 1588 | 11 |
826252 | 826252 | 2020-12-13 | Iowa | Wisconsin | 55049 | 1544 | 6 |
826253 | 826253 | 2020-12-13 | Iron | Wisconsin | 55051 | 477 | 16 |
826254 | 826254 | 2020-12-13 | Jackson | Wisconsin | 55053 | 2091 | 6 |
826255 | 826255 | 2020-12-13 | Jefferson | Wisconsin | 55055 | 6546 | 48 |
826256 | 826256 | 2020-12-13 | Juneau | Wisconsin | 55057 | 2194 | 8 |
826257 | 826257 | 2020-12-13 | Kenosha | Wisconsin | 55059 | 12172 | 184 |
826258 | 826258 | 2020-12-13 | Kewaunee | Wisconsin | 55061 | 1946 | 23 |
826259 | 826259 | 2020-12-13 | La Crosse | Wisconsin | 55063 | 9497 | 43 |
826260 | 826260 | 2020-12-13 | Lafayette | Wisconsin | 55065 | 1240 | 5 |
826261 | 826261 | 2020-12-13 | Langlade | Wisconsin | 55067 | 1764 | 39 |
826262 | 826262 | 2020-12-13 | Lincoln | Wisconsin | 55069 | 2314 | 50 |
826263 | 826263 | 2020-12-13 | Manitowoc | Wisconsin | 55071 | 6269 | 51 |
826264 | 826264 | 2020-12-13 | Marathon | Wisconsin | 55073 | 11916 | 162 |
826265 | 826265 | 2020-12-13 | Marinette | Wisconsin | 55075 | 3581 | 36 |
826266 | 826266 | 2020-12-13 | Marquette | Wisconsin | 55077 | 1243 | 17 |
826267 | 826267 | 2020-12-13 | Menominee | Wisconsin | 55078 | 645 | 8 |
826268 | 826268 | 2020-12-13 | Milwaukee | Wisconsin | 55079 | 82954 | 829 |
826269 | 826269 | 2020-12-13 | Monroe | Wisconsin | 55081 | 3081 | 20 |
826270 | 826270 | 2020-12-13 | Oconto | Wisconsin | 55083 | 3748 | 37 |
826271 | 826271 | 2020-12-13 | Oneida | Wisconsin | 55085 | 2679 | 49 |
826272 | 826272 | 2020-12-13 | Outagamie | Wisconsin | 55087 | 16049 | 142 |
826273 | 826273 | 2020-12-13 | Ozaukee | Wisconsin | 55089 | 6219 | 48 |
826274 | 826274 | 2020-12-13 | Pepin | Wisconsin | 55091 | 587 | 5 |
826275 | 826275 | 2020-12-13 | Pierce | Wisconsin | 55093 | 3156 | 26 |
826276 | 826276 | 2020-12-13 | Polk | Wisconsin | 55095 | 2685 | 20 |
826277 | 826277 | 2020-12-13 | Portage | Wisconsin | 55097 | 5423 | 46 |
826278 | 826278 | 2020-12-13 | Price | Wisconsin | 55099 | 912 | 4 |
826279 | 826279 | 2020-12-13 | Racine | Wisconsin | 55101 | 17413 | 227 |
826280 | 826280 | 2020-12-13 | Richland | Wisconsin | 55103 | 1005 | 13 |
826281 | 826281 | 2020-12-13 | Rock | Wisconsin | 55105 | 11517 | 105 |
826282 | 826282 | 2020-12-13 | Rusk | Wisconsin | 55107 | 1045 | 11 |
826283 | 826283 | 2020-12-13 | Sauk | Wisconsin | 55111 | 4197 | 24 |
826284 | 826284 | 2020-12-13 | Sawyer | Wisconsin | 55113 | 1061 | 8 |
826285 | 826285 | 2020-12-13 | Shawano | Wisconsin | 55115 | 4201 | 59 |
826286 | 826286 | 2020-12-13 | Sheboygan | Wisconsin | 55117 | 10580 | 81 |
826287 | 826287 | 2020-12-13 | St. Croix | Wisconsin | 55109 | 5578 | 22 |
826288 | 826288 | 2020-12-13 | Taylor | Wisconsin | 55119 | 1625 | 18 |
826289 | 826289 | 2020-12-13 | Trempealeau | Wisconsin | 55121 | 2784 | 25 |
826290 | 826290 | 2020-12-13 | Vernon | Wisconsin | 55123 | 1371 | 17 |
826291 | 826291 | 2020-12-13 | Vilas | Wisconsin | 55125 | 1472 | 21 |
826292 | 826292 | 2020-12-13 | Walworth | Wisconsin | 55127 | 8341 | 74 |
826293 | 826293 | 2020-12-13 | Washburn | Wisconsin | 55129 | 954 | 8 |
826294 | 826294 | 2020-12-13 | Washington | Wisconsin | 55131 | 11565 | 92 |
826295 | 826295 | 2020-12-13 | Waukesha | Wisconsin | 55133 | 32730 | 301 |
826296 | 826296 | 2020-12-13 | Waupaca | Wisconsin | 55135 | 4466 | 129 |
826297 | 826297 | 2020-12-13 | Waushara | Wisconsin | 55137 | 1950 | 14 |
826298 | 826298 | 2020-12-13 | Winnebago | Wisconsin | 55139 | 15872 | 149 |
826299 | 826299 | 2020-12-13 | Wood | Wisconsin | 55141 | 5309 | 40 |
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);