ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where date = "2020-08-27" 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 |
---|---|---|---|---|---|---|---|
476111 | 476111 | 2020-08-27 | Adams | Wisconsin | 55001 | 103 | 3 |
476112 | 476112 | 2020-08-27 | Ashland | Wisconsin | 55003 | 34 | 1 |
476113 | 476113 | 2020-08-27 | Barron | Wisconsin | 55005 | 363 | 3 |
476114 | 476114 | 2020-08-27 | Bayfield | Wisconsin | 55007 | 42 | 1 |
476115 | 476115 | 2020-08-27 | Brown | Wisconsin | 55009 | 5194 | 58 |
476116 | 476116 | 2020-08-27 | Buffalo | Wisconsin | 55011 | 58 | 2 |
476117 | 476117 | 2020-08-27 | Burnett | Wisconsin | 55013 | 39 | 1 |
476118 | 476118 | 2020-08-27 | Calumet | Wisconsin | 55015 | 473 | 2 |
476119 | 476119 | 2020-08-27 | Chippewa | Wisconsin | 55017 | 323 | 0 |
476120 | 476120 | 2020-08-27 | Clark | Wisconsin | 55019 | 236 | 8 |
476121 | 476121 | 2020-08-27 | Columbia | Wisconsin | 55021 | 340 | 2 |
476122 | 476122 | 2020-08-27 | Crawford | Wisconsin | 55023 | 99 | 0 |
476123 | 476123 | 2020-08-27 | Dane | Wisconsin | 55025 | 5294 | 39 |
476124 | 476124 | 2020-08-27 | Dodge | Wisconsin | 55027 | 1076 | 5 |
476125 | 476125 | 2020-08-27 | Door | Wisconsin | 55029 | 128 | 3 |
476126 | 476126 | 2020-08-27 | Douglas | Wisconsin | 55031 | 244 | 0 |
476127 | 476127 | 2020-08-27 | Dunn | Wisconsin | 55033 | 163 | 0 |
476128 | 476128 | 2020-08-27 | Eau Claire | Wisconsin | 55035 | 768 | 6 |
476129 | 476129 | 2020-08-27 | Florence | Wisconsin | 55037 | 23 | 0 |
476130 | 476130 | 2020-08-27 | Fond du Lac | Wisconsin | 55039 | 1051 | 10 |
476131 | 476131 | 2020-08-27 | Forest | Wisconsin | 55041 | 67 | 4 |
476132 | 476132 | 2020-08-27 | Grant | Wisconsin | 55043 | 425 | 17 |
476133 | 476133 | 2020-08-27 | Green | Wisconsin | 55045 | 261 | 1 |
476134 | 476134 | 2020-08-27 | Green Lake | Wisconsin | 55047 | 88 | 0 |
476135 | 476135 | 2020-08-27 | Iowa | Wisconsin | 55049 | 114 | 0 |
476136 | 476136 | 2020-08-27 | Iron | Wisconsin | 55051 | 118 | 1 |
476137 | 476137 | 2020-08-27 | Jackson | Wisconsin | 55053 | 74 | 1 |
476138 | 476138 | 2020-08-27 | Jefferson | Wisconsin | 55055 | 848 | 6 |
476139 | 476139 | 2020-08-27 | Juneau | Wisconsin | 55057 | 188 | 1 |
476140 | 476140 | 2020-08-27 | Kenosha | Wisconsin | 55059 | 2920 | 62 |
476141 | 476141 | 2020-08-27 | Kewaunee | Wisconsin | 55061 | 163 | 2 |
476142 | 476142 | 2020-08-27 | La Crosse | Wisconsin | 55063 | 1109 | 1 |
476143 | 476143 | 2020-08-27 | Lafayette | Wisconsin | 55065 | 185 | 0 |
476144 | 476144 | 2020-08-27 | Langlade | Wisconsin | 55067 | 79 | 2 |
476145 | 476145 | 2020-08-27 | Lincoln | Wisconsin | 55069 | 78 | 1 |
476146 | 476146 | 2020-08-27 | Manitowoc | Wisconsin | 55071 | 488 | 1 |
476147 | 476147 | 2020-08-27 | Marathon | Wisconsin | 55073 | 753 | 13 |
476148 | 476148 | 2020-08-27 | Marinette | Wisconsin | 55075 | 582 | 6 |
476149 | 476149 | 2020-08-27 | Marquette | Wisconsin | 55077 | 86 | 1 |
476150 | 476150 | 2020-08-27 | Menominee | Wisconsin | 55078 | 28 | 0 |
476151 | 476151 | 2020-08-27 | Milwaukee | Wisconsin | 55079 | 23676 | 485 |
476152 | 476152 | 2020-08-27 | Monroe | Wisconsin | 55081 | 274 | 2 |
476153 | 476153 | 2020-08-27 | Oconto | Wisconsin | 55083 | 405 | 2 |
476154 | 476154 | 2020-08-27 | Oneida | Wisconsin | 55085 | 203 | 0 |
476155 | 476155 | 2020-08-27 | Outagamie | Wisconsin | 55087 | 1692 | 19 |
476156 | 476156 | 2020-08-27 | Ozaukee | Wisconsin | 55089 | 910 | 19 |
476157 | 476157 | 2020-08-27 | Pepin | Wisconsin | 55091 | 47 | 0 |
476158 | 476158 | 2020-08-27 | Pierce | Wisconsin | 55093 | 281 | 5 |
476159 | 476159 | 2020-08-27 | Polk | Wisconsin | 55095 | 170 | 2 |
476160 | 476160 | 2020-08-27 | Portage | Wisconsin | 55097 | 550 | 1 |
476161 | 476161 | 2020-08-27 | Price | Wisconsin | 55099 | 37 | 0 |
476162 | 476162 | 2020-08-27 | Racine | Wisconsin | 55101 | 4362 | 89 |
476163 | 476163 | 2020-08-27 | Richland | Wisconsin | 55103 | 44 | 4 |
476164 | 476164 | 2020-08-27 | Rock | Wisconsin | 55105 | 1764 | 26 |
476165 | 476165 | 2020-08-27 | Rusk | Wisconsin | 55107 | 24 | 1 |
476166 | 476166 | 2020-08-27 | Sauk | Wisconsin | 55111 | 628 | 3 |
476167 | 476167 | 2020-08-27 | Sawyer | Wisconsin | 55113 | 151 | 0 |
476168 | 476168 | 2020-08-27 | Shawano | Wisconsin | 55115 | 245 | 0 |
476169 | 476169 | 2020-08-27 | Sheboygan | Wisconsin | 55117 | 1005 | 8 |
476170 | 476170 | 2020-08-27 | St. Croix | Wisconsin | 55109 | 631 | 7 |
476171 | 476171 | 2020-08-27 | Taylor | Wisconsin | 55119 | 90 | 3 |
476172 | 476172 | 2020-08-27 | Trempealeau | Wisconsin | 55121 | 411 | 2 |
476173 | 476173 | 2020-08-27 | Unknown | Wisconsin | 4284 | 8 | |
476174 | 476174 | 2020-08-27 | Vernon | Wisconsin | 55123 | 93 | 0 |
476175 | 476175 | 2020-08-27 | Vilas | Wisconsin | 55125 | 97 | 0 |
476176 | 476176 | 2020-08-27 | Walworth | Wisconsin | 55127 | 1654 | 27 |
476177 | 476177 | 2020-08-27 | Washburn | Wisconsin | 55129 | 59 | 0 |
476178 | 476178 | 2020-08-27 | Washington | Wisconsin | 55131 | 1566 | 29 |
476179 | 476179 | 2020-08-27 | Waukesha | Wisconsin | 55133 | 5416 | 73 |
476180 | 476180 | 2020-08-27 | Waupaca | Wisconsin | 55135 | 656 | 17 |
476181 | 476181 | 2020-08-27 | Waushara | Wisconsin | 55137 | 142 | 2 |
476182 | 476182 | 2020-08-27 | Winnebago | Wisconsin | 55139 | 1433 | 21 |
476183 | 476183 | 2020-08-27 | Wood | Wisconsin | 55141 | 431 | 2 |
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);