ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where "date" is on date 2020-07-06 and state = "Wisconsin" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
309101 | 309101 | 2020-07-06 | Adams | Wisconsin | 55001 | 33 | 2 |
309102 | 309102 | 2020-07-06 | Ashland | Wisconsin | 55003 | 3 | 0 |
309103 | 309103 | 2020-07-06 | Barron | Wisconsin | 55005 | 36 | 1 |
309104 | 309104 | 2020-07-06 | Bayfield | Wisconsin | 55007 | 3 | 1 |
309105 | 309105 | 2020-07-06 | Brown | Wisconsin | 55009 | 3049 | 42 |
309106 | 309106 | 2020-07-06 | Buffalo | Wisconsin | 55011 | 8 | 2 |
309107 | 309107 | 2020-07-06 | Burnett | Wisconsin | 55013 | 4 | 1 |
309108 | 309108 | 2020-07-06 | Calumet | Wisconsin | 55015 | 119 | 2 |
309109 | 309109 | 2020-07-06 | Chippewa | Wisconsin | 55017 | 105 | 0 |
309110 | 309110 | 2020-07-06 | Clark | Wisconsin | 55019 | 87 | 7 |
309111 | 309111 | 2020-07-06 | Columbia | Wisconsin | 55021 | 101 | 1 |
309112 | 309112 | 2020-07-06 | Crawford | Wisconsin | 55023 | 41 | 0 |
309113 | 309113 | 2020-07-06 | Dane | Wisconsin | 55025 | 2475 | 32 |
309114 | 309114 | 2020-07-06 | Dodge | Wisconsin | 55027 | 484 | 5 |
309115 | 309115 | 2020-07-06 | Door | Wisconsin | 55029 | 45 | 3 |
309116 | 309116 | 2020-07-06 | Douglas | Wisconsin | 55031 | 41 | 0 |
309117 | 309117 | 2020-07-06 | Dunn | Wisconsin | 55033 | 46 | 0 |
309118 | 309118 | 2020-07-06 | Eau Claire | Wisconsin | 55035 | 290 | 1 |
309119 | 309119 | 2020-07-06 | Florence | Wisconsin | 55037 | 4 | 0 |
309120 | 309120 | 2020-07-06 | Fond du Lac | Wisconsin | 55039 | 329 | 6 |
309121 | 309121 | 2020-07-06 | Forest | Wisconsin | 55041 | 39 | 3 |
309122 | 309122 | 2020-07-06 | Grant | Wisconsin | 55043 | 177 | 13 |
309123 | 309123 | 2020-07-06 | Green | Wisconsin | 55045 | 100 | 1 |
309124 | 309124 | 2020-07-06 | Green Lake | Wisconsin | 55047 | 40 | 0 |
309125 | 309125 | 2020-07-06 | Iowa | Wisconsin | 55049 | 37 | 0 |
309126 | 309126 | 2020-07-06 | Iron | Wisconsin | 55051 | 8 | 1 |
309127 | 309127 | 2020-07-06 | Jackson | Wisconsin | 55053 | 27 | 1 |
309128 | 309128 | 2020-07-06 | Jefferson | Wisconsin | 55055 | 291 | 4 |
309129 | 309129 | 2020-07-06 | Juneau | Wisconsin | 55057 | 43 | 1 |
309130 | 309130 | 2020-07-06 | Kenosha | Wisconsin | 55059 | 1601 | 44 |
309131 | 309131 | 2020-07-06 | Kewaunee | Wisconsin | 55061 | 64 | 1 |
309132 | 309132 | 2020-07-06 | La Crosse | Wisconsin | 55063 | 519 | 0 |
309133 | 309133 | 2020-07-06 | Lafayette | Wisconsin | 55065 | 76 | 0 |
309134 | 309134 | 2020-07-06 | Langlade | Wisconsin | 55067 | 11 | 0 |
309135 | 309135 | 2020-07-06 | Lincoln | Wisconsin | 55069 | 15 | 0 |
309136 | 309136 | 2020-07-06 | Manitowoc | Wisconsin | 55071 | 116 | 1 |
309137 | 309137 | 2020-07-06 | Marathon | Wisconsin | 55073 | 225 | 1 |
309138 | 309138 | 2020-07-06 | Marinette | Wisconsin | 55075 | 68 | 3 |
309139 | 309139 | 2020-07-06 | Marquette | Wisconsin | 55077 | 24 | 1 |
309140 | 309140 | 2020-07-06 | Menominee | Wisconsin | 55078 | 7 | 0 |
309141 | 309141 | 2020-07-06 | Milwaukee | Wisconsin | 55079 | 12436 | 391 |
309142 | 309142 | 2020-07-06 | Monroe | Wisconsin | 55081 | 88 | 1 |
309143 | 309143 | 2020-07-06 | Oconto | Wisconsin | 55083 | 67 | 0 |
309144 | 309144 | 2020-07-06 | Oneida | Wisconsin | 55085 | 20 | 0 |
309145 | 309145 | 2020-07-06 | Outagamie | Wisconsin | 55087 | 552 | 9 |
309146 | 309146 | 2020-07-06 | Ozaukee | Wisconsin | 55089 | 280 | 16 |
309147 | 309147 | 2020-07-06 | Pepin | Wisconsin | 55091 | 1 | 0 |
309148 | 309148 | 2020-07-06 | Pierce | Wisconsin | 55093 | 76 | 0 |
309149 | 309149 | 2020-07-06 | Polk | Wisconsin | 55095 | 60 | 1 |
309150 | 309150 | 2020-07-06 | Portage | Wisconsin | 55097 | 196 | 0 |
309151 | 309151 | 2020-07-06 | Price | Wisconsin | 55099 | 2 | 0 |
309152 | 309152 | 2020-07-06 | Racine | Wisconsin | 55101 | 2559 | 65 |
309153 | 309153 | 2020-07-06 | Richland | Wisconsin | 55103 | 15 | 4 |
309154 | 309154 | 2020-07-06 | Rock | Wisconsin | 55105 | 1046 | 24 |
309155 | 309155 | 2020-07-06 | Rusk | Wisconsin | 55107 | 11 | 0 |
309160 | 309160 | 2020-07-06 | St. Croix | Wisconsin | 55109 | 218 | 1 |
309156 | 309156 | 2020-07-06 | Sauk | Wisconsin | 55111 | 123 | 3 |
309157 | 309157 | 2020-07-06 | Sawyer | Wisconsin | 55113 | 12 | 0 |
309158 | 309158 | 2020-07-06 | Shawano | Wisconsin | 55115 | 86 | 0 |
309159 | 309159 | 2020-07-06 | Sheboygan | Wisconsin | 55117 | 236 | 4 |
309161 | 309161 | 2020-07-06 | Taylor | Wisconsin | 55119 | 15 | 0 |
309162 | 309162 | 2020-07-06 | Trempealeau | Wisconsin | 55121 | 137 | 0 |
309164 | 309164 | 2020-07-06 | Vernon | Wisconsin | 55123 | 38 | 0 |
309165 | 309165 | 2020-07-06 | Vilas | Wisconsin | 55125 | 11 | 0 |
309166 | 309166 | 2020-07-06 | Walworth | Wisconsin | 55127 | 691 | 18 |
309167 | 309167 | 2020-07-06 | Washburn | Wisconsin | 55129 | 4 | 0 |
309168 | 309168 | 2020-07-06 | Washington | Wisconsin | 55131 | 440 | 17 |
309169 | 309169 | 2020-07-06 | Waukesha | Wisconsin | 55133 | 1412 | 39 |
309170 | 309170 | 2020-07-06 | Waupaca | Wisconsin | 55135 | 139 | 10 |
309171 | 309171 | 2020-07-06 | Waushara | Wisconsin | 55137 | 33 | 0 |
309172 | 309172 | 2020-07-06 | Winnebago | Wisconsin | 55139 | 715 | 13 |
309173 | 309173 | 2020-07-06 | Wood | Wisconsin | 55141 | 86 | 1 |
309163 | 309163 | 2020-07-06 | Unknown | Wisconsin | 2722 | 7 |
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);