ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2020-11-27" 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 |
---|---|---|---|---|---|---|---|
774304 | 774304 | 2020-11-27 | Adams | Wisconsin | 55001 | 1082 | 7 |
774305 | 774305 | 2020-11-27 | Ashland | Wisconsin | 55003 | 665 | 9 |
774306 | 774306 | 2020-11-27 | Barron | Wisconsin | 55005 | 3526 | 41 |
774307 | 774307 | 2020-11-27 | Bayfield | Wisconsin | 55007 | 661 | 11 |
774308 | 774308 | 2020-11-27 | Brown | Wisconsin | 55009 | 22933 | 139 |
774309 | 774309 | 2020-11-27 | Buffalo | Wisconsin | 55011 | 789 | 4 |
774310 | 774310 | 2020-11-27 | Burnett | Wisconsin | 55013 | 788 | 11 |
774311 | 774311 | 2020-11-27 | Calumet | Wisconsin | 55015 | 4199 | 26 |
774312 | 774312 | 2020-11-27 | Chippewa | Wisconsin | 55017 | 4581 | 52 |
774313 | 774313 | 2020-11-27 | Clark | Wisconsin | 55019 | 2273 | 40 |
774314 | 774314 | 2020-11-27 | Columbia | Wisconsin | 55021 | 3550 | 11 |
774315 | 774315 | 2020-11-27 | Crawford | Wisconsin | 55023 | 1184 | 7 |
774316 | 774316 | 2020-11-27 | Dane | Wisconsin | 55025 | 27164 | 83 |
774317 | 774317 | 2020-11-27 | Dodge | Wisconsin | 55027 | 8607 | 75 |
774318 | 774318 | 2020-11-27 | Door | Wisconsin | 55029 | 1680 | 11 |
774319 | 774319 | 2020-11-27 | Douglas | Wisconsin | 55031 | 2057 | 1 |
774320 | 774320 | 2020-11-27 | Dunn | Wisconsin | 55033 | 2829 | 12 |
774321 | 774321 | 2020-11-27 | Eau Claire | Wisconsin | 55035 | 7674 | 62 |
774322 | 774322 | 2020-11-27 | Florence | Wisconsin | 55037 | 323 | 11 |
774323 | 774323 | 2020-11-27 | Fond du Lac | Wisconsin | 55039 | 8574 | 56 |
774324 | 774324 | 2020-11-27 | Forest | Wisconsin | 55041 | 757 | 19 |
774325 | 774325 | 2020-11-27 | Grant | Wisconsin | 55043 | 3610 | 64 |
774326 | 774326 | 2020-11-27 | Green | Wisconsin | 55045 | 1673 | 6 |
774327 | 774327 | 2020-11-27 | Green Lake | Wisconsin | 55047 | 1402 | 6 |
774328 | 774328 | 2020-11-27 | Iowa | Wisconsin | 55049 | 1296 | 6 |
774329 | 774329 | 2020-11-27 | Iron | Wisconsin | 55051 | 405 | 13 |
774330 | 774330 | 2020-11-27 | Jackson | Wisconsin | 55053 | 1652 | 4 |
774331 | 774331 | 2020-11-27 | Jefferson | Wisconsin | 55055 | 5500 | 38 |
774332 | 774332 | 2020-11-27 | Juneau | Wisconsin | 55057 | 1883 | 7 |
774333 | 774333 | 2020-11-27 | Kenosha | Wisconsin | 55059 | 10087 | 145 |
774334 | 774334 | 2020-11-27 | Kewaunee | Wisconsin | 55061 | 1692 | 16 |
774335 | 774335 | 2020-11-27 | La Crosse | Wisconsin | 55063 | 8079 | 35 |
774336 | 774336 | 2020-11-27 | Lafayette | Wisconsin | 55065 | 1095 | 3 |
774337 | 774337 | 2020-11-27 | Langlade | Wisconsin | 55067 | 1588 | 32 |
774338 | 774338 | 2020-11-27 | Lincoln | Wisconsin | 55069 | 1966 | 35 |
774339 | 774339 | 2020-11-27 | Manitowoc | Wisconsin | 55071 | 5379 | 40 |
774340 | 774340 | 2020-11-27 | Marathon | Wisconsin | 55073 | 10269 | 139 |
774341 | 774341 | 2020-11-27 | Marinette | Wisconsin | 55075 | 3122 | 27 |
774342 | 774342 | 2020-11-27 | Marquette | Wisconsin | 55077 | 1135 | 15 |
774343 | 774343 | 2020-11-27 | Menominee | Wisconsin | 55078 | 557 | 8 |
774344 | 774344 | 2020-11-27 | Milwaukee | Wisconsin | 55079 | 70735 | 742 |
774345 | 774345 | 2020-11-27 | Monroe | Wisconsin | 55081 | 2490 | 12 |
774346 | 774346 | 2020-11-27 | Oconto | Wisconsin | 55083 | 3264 | 30 |
774347 | 774347 | 2020-11-27 | Oneida | Wisconsin | 55085 | 2257 | 30 |
774348 | 774348 | 2020-11-27 | Outagamie | Wisconsin | 55087 | 14252 | 122 |
774349 | 774349 | 2020-11-27 | Ozaukee | Wisconsin | 55089 | 5190 | 40 |
774350 | 774350 | 2020-11-27 | Pepin | Wisconsin | 55091 | 463 | 2 |
774351 | 774351 | 2020-11-27 | Pierce | Wisconsin | 55093 | 2429 | 21 |
774352 | 774352 | 2020-11-27 | Polk | Wisconsin | 55095 | 2091 | 14 |
774353 | 774353 | 2020-11-27 | Portage | Wisconsin | 55097 | 4789 | 38 |
774354 | 774354 | 2020-11-27 | Price | Wisconsin | 55099 | 736 | 4 |
774355 | 774355 | 2020-11-27 | Racine | Wisconsin | 55101 | 15121 | 168 |
774356 | 774356 | 2020-11-27 | Richland | Wisconsin | 55103 | 876 | 13 |
774357 | 774357 | 2020-11-27 | Rock | Wisconsin | 55105 | 9412 | 80 |
774358 | 774358 | 2020-11-27 | Rusk | Wisconsin | 55107 | 852 | 7 |
774359 | 774359 | 2020-11-27 | Sauk | Wisconsin | 55111 | 3539 | 17 |
774360 | 774360 | 2020-11-27 | Sawyer | Wisconsin | 55113 | 871 | 7 |
774361 | 774361 | 2020-11-27 | Shawano | Wisconsin | 55115 | 3778 | 50 |
774362 | 774362 | 2020-11-27 | Sheboygan | Wisconsin | 55117 | 9133 | 55 |
774363 | 774363 | 2020-11-27 | St. Croix | Wisconsin | 55109 | 4387 | 20 |
774364 | 774364 | 2020-11-27 | Taylor | Wisconsin | 55119 | 1265 | 13 |
774365 | 774365 | 2020-11-27 | Trempealeau | Wisconsin | 55121 | 2344 | 15 |
774366 | 774366 | 2020-11-27 | Vernon | Wisconsin | 55123 | 1102 | 9 |
774367 | 774367 | 2020-11-27 | Vilas | Wisconsin | 55125 | 1246 | 13 |
774368 | 774368 | 2020-11-27 | Walworth | Wisconsin | 55127 | 6686 | 50 |
774369 | 774369 | 2020-11-27 | Washburn | Wisconsin | 55129 | 684 | 2 |
774370 | 774370 | 2020-11-27 | Washington | Wisconsin | 55131 | 9588 | 74 |
774371 | 774371 | 2020-11-27 | Waukesha | Wisconsin | 55133 | 27464 | 202 |
774372 | 774372 | 2020-11-27 | Waupaca | Wisconsin | 55135 | 4067 | 119 |
774373 | 774373 | 2020-11-27 | Waushara | Wisconsin | 55137 | 1792 | 8 |
774374 | 774374 | 2020-11-27 | Winnebago | Wisconsin | 55139 | 14049 | 110 |
774375 | 774375 | 2020-11-27 | Wood | Wisconsin | 55141 | 4319 | 30 |
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);