ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where date = "2020-09-26" 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 |
---|---|---|---|---|---|---|---|
573188 | 573188 | 2020-09-26 | Adams | Wisconsin | 55001 | 241 | 4 |
573189 | 573189 | 2020-09-26 | Ashland | Wisconsin | 55003 | 109 | 2 |
573190 | 573190 | 2020-09-26 | Barron | Wisconsin | 55005 | 477 | 4 |
573191 | 573191 | 2020-09-26 | Bayfield | Wisconsin | 55007 | 109 | 1 |
573192 | 573192 | 2020-09-26 | Brown | Wisconsin | 55009 | 8963 | 62 |
573193 | 573193 | 2020-09-26 | Buffalo | Wisconsin | 55011 | 142 | 2 |
573194 | 573194 | 2020-09-26 | Burnett | Wisconsin | 55013 | 193 | 3 |
573195 | 573195 | 2020-09-26 | Calumet | Wisconsin | 55015 | 1152 | 3 |
573196 | 573196 | 2020-09-26 | Chippewa | Wisconsin | 55017 | 549 | 0 |
573197 | 573197 | 2020-09-26 | Clark | Wisconsin | 55019 | 417 | 8 |
573198 | 573198 | 2020-09-26 | Columbia | Wisconsin | 55021 | 652 | 2 |
573199 | 573199 | 2020-09-26 | Crawford | Wisconsin | 55023 | 164 | 0 |
573200 | 573200 | 2020-09-26 | Dane | Wisconsin | 55025 | 9958 | 41 |
573201 | 573201 | 2020-09-26 | Dodge | Wisconsin | 55027 | 1831 | 16 |
573202 | 573202 | 2020-09-26 | Door | Wisconsin | 55029 | 343 | 3 |
573203 | 573203 | 2020-09-26 | Douglas | Wisconsin | 55031 | 445 | 0 |
573204 | 573204 | 2020-09-26 | Dunn | Wisconsin | 55033 | 524 | 0 |
573205 | 573205 | 2020-09-26 | Eau Claire | Wisconsin | 55035 | 1862 | 6 |
573206 | 573206 | 2020-09-26 | Florence | Wisconsin | 55037 | 89 | 2 |
573207 | 573207 | 2020-09-26 | Fond du Lac | Wisconsin | 55039 | 2068 | 13 |
573208 | 573208 | 2020-09-26 | Forest | Wisconsin | 55041 | 272 | 4 |
573209 | 573209 | 2020-09-26 | Grant | Wisconsin | 55043 | 995 | 19 |
573210 | 573210 | 2020-09-26 | Green | Wisconsin | 55045 | 505 | 3 |
573211 | 573211 | 2020-09-26 | Green Lake | Wisconsin | 55047 | 315 | 0 |
573212 | 573212 | 2020-09-26 | Iowa | Wisconsin | 55049 | 204 | 0 |
573213 | 573213 | 2020-09-26 | Iron | Wisconsin | 55051 | 148 | 1 |
573214 | 573214 | 2020-09-26 | Jackson | Wisconsin | 55053 | 149 | 1 |
573215 | 573215 | 2020-09-26 | Jefferson | Wisconsin | 55055 | 1468 | 8 |
573216 | 573216 | 2020-09-26 | Juneau | Wisconsin | 55057 | 371 | 2 |
573217 | 573217 | 2020-09-26 | Kenosha | Wisconsin | 55059 | 3879 | 65 |
573218 | 573218 | 2020-09-26 | Kewaunee | Wisconsin | 55061 | 521 | 2 |
573219 | 573219 | 2020-09-26 | La Crosse | Wisconsin | 55063 | 3142 | 2 |
573220 | 573220 | 2020-09-26 | Lafayette | Wisconsin | 55065 | 272 | 0 |
573221 | 573221 | 2020-09-26 | Langlade | Wisconsin | 55067 | 170 | 2 |
573222 | 573222 | 2020-09-26 | Lincoln | Wisconsin | 55069 | 217 | 1 |
573223 | 573223 | 2020-09-26 | Manitowoc | Wisconsin | 55071 | 1128 | 3 |
573224 | 573224 | 2020-09-26 | Marathon | Wisconsin | 55073 | 1414 | 14 |
573225 | 573225 | 2020-09-26 | Marinette | Wisconsin | 55075 | 903 | 8 |
573226 | 573226 | 2020-09-26 | Marquette | Wisconsin | 55077 | 262 | 1 |
573227 | 573227 | 2020-09-26 | Menominee | Wisconsin | 55078 | 66 | 0 |
573228 | 573228 | 2020-09-26 | Milwaukee | Wisconsin | 55079 | 29974 | 528 |
573229 | 573229 | 2020-09-26 | Monroe | Wisconsin | 55081 | 508 | 2 |
573230 | 573230 | 2020-09-26 | Oconto | Wisconsin | 55083 | 908 | 4 |
573231 | 573231 | 2020-09-26 | Oneida | Wisconsin | 55085 | 441 | 2 |
573232 | 573232 | 2020-09-26 | Outagamie | Wisconsin | 55087 | 4490 | 29 |
573233 | 573233 | 2020-09-26 | Ozaukee | Wisconsin | 55089 | 1424 | 19 |
573234 | 573234 | 2020-09-26 | Pepin | Wisconsin | 55091 | 65 | 0 |
573235 | 573235 | 2020-09-26 | Pierce | Wisconsin | 55093 | 676 | 7 |
573236 | 573236 | 2020-09-26 | Polk | Wisconsin | 55095 | 251 | 2 |
573237 | 573237 | 2020-09-26 | Portage | Wisconsin | 55097 | 1418 | 4 |
573238 | 573238 | 2020-09-26 | Price | Wisconsin | 55099 | 90 | 0 |
573239 | 573239 | 2020-09-26 | Racine | Wisconsin | 55101 | 5282 | 95 |
573240 | 573240 | 2020-09-26 | Richland | Wisconsin | 55103 | 134 | 4 |
573241 | 573241 | 2020-09-26 | Rock | Wisconsin | 55105 | 2669 | 32 |
573242 | 573242 | 2020-09-26 | Rusk | Wisconsin | 55107 | 68 | 1 |
573243 | 573243 | 2020-09-26 | Sauk | Wisconsin | 55111 | 944 | 3 |
573244 | 573244 | 2020-09-26 | Sawyer | Wisconsin | 55113 | 206 | 1 |
573245 | 573245 | 2020-09-26 | Shawano | Wisconsin | 55115 | 797 | 1 |
573246 | 573246 | 2020-09-26 | Sheboygan | Wisconsin | 55117 | 1633 | 16 |
573247 | 573247 | 2020-09-26 | St. Croix | Wisconsin | 55109 | 966 | 8 |
573248 | 573248 | 2020-09-26 | Taylor | Wisconsin | 55119 | 177 | 4 |
573249 | 573249 | 2020-09-26 | Trempealeau | Wisconsin | 55121 | 640 | 2 |
573250 | 573250 | 2020-09-26 | Unknown | Wisconsin | 0 | 10 | |
573251 | 573251 | 2020-09-26 | Vernon | Wisconsin | 55123 | 220 | 0 |
573252 | 573252 | 2020-09-26 | Vilas | Wisconsin | 55125 | 206 | 1 |
573253 | 573253 | 2020-09-26 | Walworth | Wisconsin | 55127 | 2724 | 35 |
573254 | 573254 | 2020-09-26 | Washburn | Wisconsin | 55129 | 107 | 1 |
573255 | 573255 | 2020-09-26 | Washington | Wisconsin | 55131 | 2607 | 32 |
573256 | 573256 | 2020-09-26 | Waukesha | Wisconsin | 55133 | 7925 | 87 |
573257 | 573257 | 2020-09-26 | Waupaca | Wisconsin | 55135 | 1123 | 20 |
573258 | 573258 | 2020-09-26 | Waushara | Wisconsin | 55137 | 337 | 2 |
573259 | 573259 | 2020-09-26 | Winnebago | Wisconsin | 55139 | 3710 | 26 |
573260 | 573260 | 2020-09-26 | Wood | Wisconsin | 55141 | 840 | 5 |
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);