ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2020-06-05" 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 |
---|---|---|---|---|---|---|---|
212151 | 212151 | 2020-06-05 | Adams | Wisconsin | 55001 | 5 | 1 |
212152 | 212152 | 2020-06-05 | Ashland | Wisconsin | 55003 | 3 | 0 |
212153 | 212153 | 2020-06-05 | Barron | Wisconsin | 55005 | 20 | 0 |
212154 | 212154 | 2020-06-05 | Bayfield | Wisconsin | 55007 | 3 | 1 |
212155 | 212155 | 2020-06-05 | Brown | Wisconsin | 55009 | 2369 | 38 |
212156 | 212156 | 2020-06-05 | Buffalo | Wisconsin | 55011 | 6 | 2 |
212157 | 212157 | 2020-06-05 | Burnett | Wisconsin | 55013 | 1 | 1 |
212158 | 212158 | 2020-06-05 | Calumet | Wisconsin | 55015 | 79 | 1 |
212159 | 212159 | 2020-06-05 | Chippewa | Wisconsin | 55017 | 58 | 0 |
212160 | 212160 | 2020-06-05 | Clark | Wisconsin | 55019 | 39 | 4 |
212161 | 212161 | 2020-06-05 | Columbia | Wisconsin | 55021 | 44 | 1 |
212162 | 212162 | 2020-06-05 | Crawford | Wisconsin | 55023 | 26 | 0 |
212163 | 212163 | 2020-06-05 | Dane | Wisconsin | 55025 | 804 | 29 |
212164 | 212164 | 2020-06-05 | Dodge | Wisconsin | 55027 | 394 | 4 |
212165 | 212165 | 2020-06-05 | Door | Wisconsin | 55029 | 39 | 3 |
212166 | 212166 | 2020-06-05 | Douglas | Wisconsin | 55031 | 19 | 0 |
212167 | 212167 | 2020-06-05 | Dunn | Wisconsin | 55033 | 26 | 0 |
212168 | 212168 | 2020-06-05 | Eau Claire | Wisconsin | 55035 | 119 | 0 |
212169 | 212169 | 2020-06-05 | Florence | Wisconsin | 55037 | 2 | 0 |
212170 | 212170 | 2020-06-05 | Fond du Lac | Wisconsin | 55039 | 226 | 5 |
212171 | 212171 | 2020-06-05 | Forest | Wisconsin | 55041 | 34 | 2 |
212172 | 212172 | 2020-06-05 | Grant | Wisconsin | 55043 | 98 | 12 |
212173 | 212173 | 2020-06-05 | Green | Wisconsin | 55045 | 70 | 0 |
212174 | 212174 | 2020-06-05 | Green Lake | Wisconsin | 55047 | 22 | 0 |
212175 | 212175 | 2020-06-05 | Iowa | Wisconsin | 55049 | 16 | 0 |
212176 | 212176 | 2020-06-05 | Iron | Wisconsin | 55051 | 2 | 1 |
212177 | 212177 | 2020-06-05 | Jackson | Wisconsin | 55053 | 17 | 1 |
212178 | 212178 | 2020-06-05 | Jefferson | Wisconsin | 55055 | 122 | 3 |
212179 | 212179 | 2020-06-05 | Juneau | Wisconsin | 55057 | 22 | 1 |
212180 | 212180 | 2020-06-05 | Kenosha | Wisconsin | 55059 | 1267 | 34 |
212181 | 212181 | 2020-06-05 | Kewaunee | Wisconsin | 55061 | 36 | 1 |
212182 | 212182 | 2020-06-05 | La Crosse | Wisconsin | 55063 | 68 | 0 |
212183 | 212183 | 2020-06-05 | Lafayette | Wisconsin | 55065 | 29 | 0 |
212184 | 212184 | 2020-06-05 | Langlade | Wisconsin | 55067 | 4 | 0 |
212185 | 212185 | 2020-06-05 | Lincoln | Wisconsin | 55069 | 7 | 0 |
212186 | 212186 | 2020-06-05 | Manitowoc | Wisconsin | 55071 | 39 | 1 |
212187 | 212187 | 2020-06-05 | Marathon | Wisconsin | 55073 | 57 | 1 |
212188 | 212188 | 2020-06-05 | Marinette | Wisconsin | 55075 | 33 | 2 |
212189 | 212189 | 2020-06-05 | Marquette | Wisconsin | 55077 | 5 | 1 |
212190 | 212190 | 2020-06-05 | Menominee | Wisconsin | 55078 | 3 | 0 |
212191 | 212191 | 2020-06-05 | Milwaukee | Wisconsin | 55079 | 8608 | 317 |
212192 | 212192 | 2020-06-05 | Monroe | Wisconsin | 55081 | 18 | 1 |
212193 | 212193 | 2020-06-05 | Oconto | Wisconsin | 55083 | 39 | 0 |
212194 | 212194 | 2020-06-05 | Oneida | Wisconsin | 55085 | 12 | 0 |
212195 | 212195 | 2020-06-05 | Outagamie | Wisconsin | 55087 | 253 | 8 |
212196 | 212196 | 2020-06-05 | Ozaukee | Wisconsin | 55089 | 188 | 14 |
212197 | 212197 | 2020-06-05 | Pepin | Wisconsin | 55091 | 1 | 0 |
212198 | 212198 | 2020-06-05 | Pierce | Wisconsin | 55093 | 50 | 0 |
212199 | 212199 | 2020-06-05 | Polk | Wisconsin | 55095 | 31 | 1 |
212200 | 212200 | 2020-06-05 | Portage | Wisconsin | 55097 | 23 | 0 |
212201 | 212201 | 2020-06-05 | Price | Wisconsin | 55099 | 2 | 0 |
212202 | 212202 | 2020-06-05 | Racine | Wisconsin | 55101 | 2174 | 46 |
212203 | 212203 | 2020-06-05 | Richland | Wisconsin | 55103 | 14 | 4 |
212204 | 212204 | 2020-06-05 | Rock | Wisconsin | 55105 | 767 | 20 |
212205 | 212205 | 2020-06-05 | Rusk | Wisconsin | 55107 | 5 | 0 |
212206 | 212206 | 2020-06-05 | Sauk | Wisconsin | 55111 | 81 | 3 |
212207 | 212207 | 2020-06-05 | Sawyer | Wisconsin | 55113 | 8 | 0 |
212208 | 212208 | 2020-06-05 | Shawano | Wisconsin | 55115 | 53 | 0 |
212209 | 212209 | 2020-06-05 | Sheboygan | Wisconsin | 55117 | 105 | 3 |
212210 | 212210 | 2020-06-05 | St. Croix | Wisconsin | 55109 | 102 | 0 |
212211 | 212211 | 2020-06-05 | Taylor | Wisconsin | 55119 | 2 | 0 |
212212 | 212212 | 2020-06-05 | Trempealeau | Wisconsin | 55121 | 32 | 0 |
212213 | 212213 | 2020-06-05 | Vernon | Wisconsin | 55123 | 21 | 0 |
212214 | 212214 | 2020-06-05 | Vilas | Wisconsin | 55125 | 8 | 0 |
212215 | 212215 | 2020-06-05 | Walworth | Wisconsin | 55127 | 428 | 17 |
212216 | 212216 | 2020-06-05 | Washburn | Wisconsin | 55129 | 2 | 0 |
212217 | 212217 | 2020-06-05 | Washington | Wisconsin | 55131 | 272 | 9 |
212218 | 212218 | 2020-06-05 | Waukesha | Wisconsin | 55133 | 787 | 32 |
212219 | 212219 | 2020-06-05 | Waupaca | Wisconsin | 55135 | 49 | 1 |
212220 | 212220 | 2020-06-05 | Waushara | Wisconsin | 55137 | 10 | 0 |
212221 | 212221 | 2020-06-05 | Winnebago | Wisconsin | 55139 | 334 | 7 |
212222 | 212222 | 2020-06-05 | Wood | Wisconsin | 55141 | 11 | 1 |
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);