ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2020-11-10" 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 |
---|---|---|---|---|---|---|---|
719135 | 719135 | 2020-11-10 | Adams | Wisconsin | 55001 | 809 | 6 |
719136 | 719136 | 2020-11-10 | Ashland | Wisconsin | 55003 | 440 | 5 |
719137 | 719137 | 2020-11-10 | Barron | Wisconsin | 55005 | 2032 | 14 |
719138 | 719138 | 2020-11-10 | Bayfield | Wisconsin | 55007 | 446 | 3 |
719139 | 719139 | 2020-11-10 | Brown | Wisconsin | 55009 | 18667 | 117 |
719140 | 719140 | 2020-11-10 | Buffalo | Wisconsin | 55011 | 474 | 3 |
719141 | 719141 | 2020-11-10 | Burnett | Wisconsin | 55013 | 456 | 7 |
719142 | 719142 | 2020-11-10 | Calumet | Wisconsin | 55015 | 3376 | 18 |
719143 | 719143 | 2020-11-10 | Chippewa | Wisconsin | 55017 | 3022 | 33 |
719144 | 719144 | 2020-11-10 | Clark | Wisconsin | 55019 | 1469 | 26 |
719145 | 719145 | 2020-11-10 | Columbia | Wisconsin | 55021 | 2574 | 10 |
719146 | 719146 | 2020-11-10 | Crawford | Wisconsin | 55023 | 548 | 3 |
719147 | 719147 | 2020-11-10 | Dane | Wisconsin | 55025 | 20116 | 58 |
719148 | 719148 | 2020-11-10 | Dodge | Wisconsin | 55027 | 6209 | 49 |
719149 | 719149 | 2020-11-10 | Door | Wisconsin | 55029 | 1323 | 10 |
719150 | 719150 | 2020-11-10 | Douglas | Wisconsin | 55031 | 1106 | 1 |
719151 | 719151 | 2020-11-10 | Dunn | Wisconsin | 55033 | 1708 | 1 |
719152 | 719152 | 2020-11-10 | Eau Claire | Wisconsin | 55035 | 5280 | 37 |
719153 | 719153 | 2020-11-10 | Florence | Wisconsin | 55037 | 272 | 8 |
719154 | 719154 | 2020-11-10 | Fond du Lac | Wisconsin | 55039 | 6658 | 29 |
719155 | 719155 | 2020-11-10 | Forest | Wisconsin | 55041 | 635 | 11 |
719156 | 719156 | 2020-11-10 | Grant | Wisconsin | 55043 | 2604 | 48 |
719157 | 719157 | 2020-11-10 | Green | Wisconsin | 55045 | 1268 | 5 |
719158 | 719158 | 2020-11-10 | Green Lake | Wisconsin | 55047 | 1086 | 4 |
719159 | 719159 | 2020-11-10 | Iowa | Wisconsin | 55049 | 832 | 4 |
719160 | 719160 | 2020-11-10 | Iron | Wisconsin | 55051 | 325 | 6 |
719161 | 719161 | 2020-11-10 | Jackson | Wisconsin | 55053 | 944 | 2 |
719162 | 719162 | 2020-11-10 | Jefferson | Wisconsin | 55055 | 3875 | 28 |
719163 | 719163 | 2020-11-10 | Juneau | Wisconsin | 55057 | 1364 | 6 |
719164 | 719164 | 2020-11-10 | Kenosha | Wisconsin | 55059 | 7385 | 98 |
719165 | 719165 | 2020-11-10 | Kewaunee | Wisconsin | 55061 | 1370 | 11 |
719166 | 719166 | 2020-11-10 | La Crosse | Wisconsin | 55063 | 5802 | 27 |
719167 | 719167 | 2020-11-10 | Lafayette | Wisconsin | 55065 | 756 | 2 |
719168 | 719168 | 2020-11-10 | Langlade | Wisconsin | 55067 | 1301 | 22 |
719169 | 719169 | 2020-11-10 | Lincoln | Wisconsin | 55069 | 1380 | 16 |
719170 | 719170 | 2020-11-10 | Manitowoc | Wisconsin | 55071 | 4119 | 24 |
719171 | 719171 | 2020-11-10 | Marathon | Wisconsin | 55073 | 7593 | 92 |
719172 | 719172 | 2020-11-10 | Marinette | Wisconsin | 55075 | 2410 | 20 |
719173 | 719173 | 2020-11-10 | Marquette | Wisconsin | 55077 | 953 | 6 |
719174 | 719174 | 2020-11-10 | Menominee | Wisconsin | 55078 | 428 | 2 |
719175 | 719175 | 2020-11-10 | Milwaukee | Wisconsin | 55079 | 54391 | 636 |
719176 | 719176 | 2020-11-10 | Monroe | Wisconsin | 55081 | 1656 | 8 |
719177 | 719177 | 2020-11-10 | Oconto | Wisconsin | 55083 | 2740 | 23 |
719178 | 719178 | 2020-11-10 | Oneida | Wisconsin | 55085 | 1673 | 19 |
719179 | 719179 | 2020-11-10 | Outagamie | Wisconsin | 55087 | 11772 | 87 |
719180 | 719180 | 2020-11-10 | Ozaukee | Wisconsin | 55089 | 3584 | 30 |
719181 | 719181 | 2020-11-10 | Pepin | Wisconsin | 55091 | 274 | 0 |
719182 | 719182 | 2020-11-10 | Pierce | Wisconsin | 55093 | 1462 | 8 |
719183 | 719183 | 2020-11-10 | Polk | Wisconsin | 55095 | 1120 | 5 |
719184 | 719184 | 2020-11-10 | Portage | Wisconsin | 55097 | 3719 | 30 |
719185 | 719185 | 2020-11-10 | Price | Wisconsin | 55099 | 528 | 3 |
719186 | 719186 | 2020-11-10 | Racine | Wisconsin | 55101 | 11135 | 131 |
719187 | 719187 | 2020-11-10 | Richland | Wisconsin | 55103 | 645 | 10 |
719188 | 719188 | 2020-11-10 | Rock | Wisconsin | 55105 | 7089 | 57 |
719189 | 719189 | 2020-11-10 | Rusk | Wisconsin | 55107 | 433 | 3 |
719190 | 719190 | 2020-11-10 | Sauk | Wisconsin | 55111 | 2675 | 9 |
719191 | 719191 | 2020-11-10 | Sawyer | Wisconsin | 55113 | 535 | 4 |
719192 | 719192 | 2020-11-10 | Shawano | Wisconsin | 55115 | 3095 | 40 |
719193 | 719193 | 2020-11-10 | Sheboygan | Wisconsin | 55117 | 6572 | 42 |
719194 | 719194 | 2020-11-10 | St. Croix | Wisconsin | 55109 | 2949 | 16 |
719195 | 719195 | 2020-11-10 | Taylor | Wisconsin | 55119 | 768 | 10 |
719196 | 719196 | 2020-11-10 | Trempealeau | Wisconsin | 55121 | 1466 | 7 |
719197 | 719197 | 2020-11-10 | Vernon | Wisconsin | 55123 | 716 | 3 |
719198 | 719198 | 2020-11-10 | Vilas | Wisconsin | 55125 | 869 | 8 |
719199 | 719199 | 2020-11-10 | Walworth | Wisconsin | 55127 | 4791 | 41 |
719200 | 719200 | 2020-11-10 | Washburn | Wisconsin | 55129 | 364 | 2 |
719201 | 719201 | 2020-11-10 | Washington | Wisconsin | 55131 | 6672 | 55 |
719202 | 719202 | 2020-11-10 | Waukesha | Wisconsin | 55133 | 17722 | 151 |
719203 | 719203 | 2020-11-10 | Waupaca | Wisconsin | 55135 | 3365 | 78 |
719204 | 719204 | 2020-11-10 | Waushara | Wisconsin | 55137 | 1524 | 6 |
719205 | 719205 | 2020-11-10 | Winnebago | Wisconsin | 55139 | 11331 | 85 |
719206 | 719206 | 2020-11-10 | Wood | Wisconsin | 55141 | 2812 | 18 |
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);