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 2021-09-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 |
---|---|---|---|---|---|---|---|
1693063 | 1693063 | 2021-09-06 | Adams | Wisconsin | 55001 | 2248 | 21 |
1693064 | 1693064 | 2021-09-06 | Ashland | Wisconsin | 55003 | 1499 | 15 |
1693065 | 1693065 | 2021-09-06 | Barron | Wisconsin | 55005 | 6612 | 86 |
1693066 | 1693066 | 2021-09-06 | Bayfield | Wisconsin | 55007 | 1392 | 22 |
1693067 | 1693067 | 2021-09-06 | Brown | Wisconsin | 55009 | 38661 | 314 |
1693068 | 1693068 | 2021-09-06 | Buffalo | Wisconsin | 55011 | 1568 | 7 |
1693069 | 1693069 | 2021-09-06 | Burnett | Wisconsin | 55013 | 1723 | 29 |
1693070 | 1693070 | 2021-09-06 | Calumet | Wisconsin | 55015 | 7152 | 56 |
1693071 | 1693071 | 2021-09-06 | Chippewa | Wisconsin | 55017 | 8670 | 104 |
1693072 | 1693072 | 2021-09-06 | Clark | Wisconsin | 55019 | 4117 | 67 |
1693073 | 1693073 | 2021-09-06 | Columbia | Wisconsin | 55021 | 6449 | 75 |
1693074 | 1693074 | 2021-09-06 | Crawford | Wisconsin | 55023 | 1908 | 21 |
1693075 | 1693075 | 2021-09-06 | Dane | Wisconsin | 55025 | 51303 | 348 |
1693076 | 1693076 | 2021-09-06 | Dodge | Wisconsin | 55027 | 13973 | 204 |
1693077 | 1693077 | 2021-09-06 | Door | Wisconsin | 55029 | 3096 | 37 |
1693078 | 1693078 | 2021-09-06 | Douglas | Wisconsin | 55031 | 5254 | 66 |
1693079 | 1693079 | 2021-09-06 | Dunn | Wisconsin | 55033 | 5724 | 38 |
1693080 | 1693080 | 2021-09-06 | Eau Claire | Wisconsin | 55035 | 13478 | 127 |
1693081 | 1693081 | 2021-09-06 | Florence | Wisconsin | 55037 | 527 | 13 |
1693082 | 1693082 | 2021-09-06 | Fond du Lac | Wisconsin | 55039 | 15048 | 150 |
1693083 | 1693083 | 2021-09-06 | Forest | Wisconsin | 55041 | 1182 | 28 |
1693084 | 1693084 | 2021-09-06 | Grant | Wisconsin | 55043 | 6098 | 100 |
1693085 | 1693085 | 2021-09-06 | Green | Wisconsin | 55045 | 3985 | 26 |
1693086 | 1693086 | 2021-09-06 | Green Lake | Wisconsin | 55047 | 2319 | 27 |
1693087 | 1693087 | 2021-09-06 | Iowa | Wisconsin | 55049 | 2340 | 14 |
1693088 | 1693088 | 2021-09-06 | Iron | Wisconsin | 55051 | 743 | 42 |
1693089 | 1693089 | 2021-09-06 | Jackson | Wisconsin | 55053 | 2934 | 29 |
1693090 | 1693090 | 2021-09-06 | Jefferson | Wisconsin | 55055 | 10435 | 140 |
1693091 | 1693091 | 2021-09-06 | Juneau | Wisconsin | 55057 | 3622 | 31 |
1693092 | 1693092 | 2021-09-06 | Kenosha | Wisconsin | 55059 | 20721 | 343 |
1693093 | 1693093 | 2021-09-06 | Kewaunee | Wisconsin | 55061 | 2936 | 39 |
1693094 | 1693094 | 2021-09-06 | La Crosse | Wisconsin | 55063 | 14916 | 96 |
1693095 | 1693095 | 2021-09-06 | Lafayette | Wisconsin | 55065 | 1800 | 10 |
1693096 | 1693096 | 2021-09-06 | Langlade | Wisconsin | 55067 | 2442 | 51 |
1693097 | 1693097 | 2021-09-06 | Lincoln | Wisconsin | 55069 | 3565 | 102 |
1693098 | 1693098 | 2021-09-06 | Manitowoc | Wisconsin | 55071 | 9699 | 99 |
1693099 | 1693099 | 2021-09-06 | Marathon | Wisconsin | 55073 | 17722 | 239 |
1693100 | 1693100 | 2021-09-06 | Marinette | Wisconsin | 55075 | 5101 | 77 |
1693101 | 1693101 | 2021-09-06 | Marquette | Wisconsin | 55077 | 1762 | 29 |
1693102 | 1693102 | 2021-09-06 | Menominee | Wisconsin | 55078 | 855 | 11 |
1693103 | 1693103 | 2021-09-06 | Milwaukee | Wisconsin | 55079 | 133315 | 1490 |
1693104 | 1693104 | 2021-09-06 | Monroe | Wisconsin | 55081 | 5368 | 52 |
1693105 | 1693105 | 2021-09-06 | Oconto | Wisconsin | 55083 | 5652 | 75 |
1693106 | 1693106 | 2021-09-06 | Oneida | Wisconsin | 55085 | 4088 | 83 |
1693107 | 1693107 | 2021-09-06 | Outagamie | Wisconsin | 55087 | 25983 | 254 |
1693108 | 1693108 | 2021-09-06 | Ozaukee | Wisconsin | 55089 | 10473 | 111 |
1693109 | 1693109 | 2021-09-06 | Pepin | Wisconsin | 55091 | 980 | 7 |
1693110 | 1693110 | 2021-09-06 | Pierce | Wisconsin | 55093 | 5350 | 44 |
1693111 | 1693111 | 2021-09-06 | Polk | Wisconsin | 55095 | 5289 | 69 |
1693112 | 1693112 | 2021-09-06 | Portage | Wisconsin | 55097 | 8159 | 82 |
1693113 | 1693113 | 2021-09-06 | Price | Wisconsin | 55099 | 1453 | 8 |
1693114 | 1693114 | 2021-09-06 | Racine | Wisconsin | 55101 | 27908 | 419 |
1693115 | 1693115 | 2021-09-06 | Richland | Wisconsin | 55103 | 1551 | 19 |
1693116 | 1693116 | 2021-09-06 | Rock | Wisconsin | 55105 | 20023 | 219 |
1693117 | 1693117 | 2021-09-06 | Rusk | Wisconsin | 55107 | 1600 | 26 |
1693118 | 1693118 | 2021-09-06 | Sauk | Wisconsin | 55111 | 6938 | 59 |
1693119 | 1693119 | 2021-09-06 | Sawyer | Wisconsin | 55113 | 2012 | 29 |
1693120 | 1693120 | 2021-09-06 | Shawano | Wisconsin | 55115 | 5750 | 85 |
1693121 | 1693121 | 2021-09-06 | Sheboygan | Wisconsin | 55117 | 16035 | 174 |
1693122 | 1693122 | 2021-09-06 | St. Croix | Wisconsin | 55109 | 10728 | 75 |
1693123 | 1693123 | 2021-09-06 | Taylor | Wisconsin | 55119 | 2433 | 41 |
1693124 | 1693124 | 2021-09-06 | Trempealeau | Wisconsin | 55121 | 4074 | 49 |
1693125 | 1693125 | 2021-09-06 | Vernon | Wisconsin | 55123 | 2300 | 49 |
1693126 | 1693126 | 2021-09-06 | Vilas | Wisconsin | 55125 | 2570 | 46 |
1693127 | 1693127 | 2021-09-06 | Walworth | Wisconsin | 55127 | 13722 | 174 |
1693128 | 1693128 | 2021-09-06 | Washburn | Wisconsin | 55129 | 1724 | 25 |
1693129 | 1693129 | 2021-09-06 | Washington | Wisconsin | 55131 | 18710 | 209 |
1693130 | 1693130 | 2021-09-06 | Waukesha | Wisconsin | 55133 | 54571 | 668 |
1693131 | 1693131 | 2021-09-06 | Waupaca | Wisconsin | 55135 | 6647 | 172 |
1693132 | 1693132 | 2021-09-06 | Waushara | Wisconsin | 55137 | 2799 | 42 |
1693133 | 1693133 | 2021-09-06 | Winnebago | Wisconsin | 55139 | 23417 | 232 |
1693134 | 1693134 | 2021-09-06 | Wood | Wisconsin | 55141 | 8636 | 116 |
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);