ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where "date" is on date 2021-01-14 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930079 | 930079 | 2021-01-14 | Adams | Wisconsin | 55001 | 1560 | 13 |
930080 | 930080 | 2021-01-14 | Ashland | Wisconsin | 55003 | 1138 | 16 |
930081 | 930081 | 2021-01-14 | Barron | Wisconsin | 55005 | 4920 | 61 |
930082 | 930082 | 2021-01-14 | Bayfield | Wisconsin | 55007 | 1026 | 18 |
930083 | 930083 | 2021-01-14 | Brown | Wisconsin | 55009 | 29850 | 183 |
930084 | 930084 | 2021-01-14 | Buffalo | Wisconsin | 55011 | 1168 | 7 |
930085 | 930085 | 2021-01-14 | Burnett | Wisconsin | 55013 | 1167 | 23 |
930086 | 930086 | 2021-01-14 | Calumet | Wisconsin | 55015 | 5380 | 40 |
930087 | 930087 | 2021-01-14 | Chippewa | Wisconsin | 55017 | 6553 | 74 |
930088 | 930088 | 2021-01-14 | Clark | Wisconsin | 55019 | 3298 | 58 |
930089 | 930089 | 2021-01-14 | Columbia | Wisconsin | 55021 | 4875 | 41 |
930090 | 930090 | 2021-01-14 | Crawford | Wisconsin | 55023 | 1659 | 13 |
930091 | 930091 | 2021-01-14 | Dane | Wisconsin | 55025 | 37364 | 237 |
930092 | 930092 | 2021-01-14 | Dodge | Wisconsin | 55027 | 11499 | 146 |
930093 | 930093 | 2021-01-14 | Door | Wisconsin | 55029 | 2419 | 19 |
930094 | 930094 | 2021-01-14 | Douglas | Wisconsin | 55031 | 3831 | 30 |
930095 | 930095 | 2021-01-14 | Dunn | Wisconsin | 55033 | 4096 | 25 |
930096 | 930096 | 2021-01-14 | Eau Claire | Wisconsin | 55035 | 10238 | 101 |
930097 | 930097 | 2021-01-14 | Florence | Wisconsin | 55037 | 441 | 12 |
930098 | 930098 | 2021-01-14 | Fond du Lac | Wisconsin | 55039 | 11989 | 79 |
930099 | 930099 | 2021-01-14 | Forest | Wisconsin | 55041 | 958 | 25 |
930100 | 930100 | 2021-01-14 | Grant | Wisconsin | 55043 | 4844 | 82 |
930101 | 930101 | 2021-01-14 | Green | Wisconsin | 55045 | 2578 | 14 |
930102 | 930102 | 2021-01-14 | Green Lake | Wisconsin | 55047 | 1810 | 17 |
930103 | 930103 | 2021-01-14 | Iowa | Wisconsin | 55049 | 1828 | 9 |
930104 | 930104 | 2021-01-14 | Iron | Wisconsin | 55051 | 550 | 36 |
930105 | 930105 | 2021-01-14 | Jackson | Wisconsin | 55053 | 2522 | 19 |
930106 | 930106 | 2021-01-14 | Jefferson | Wisconsin | 55055 | 7905 | 66 |
930107 | 930107 | 2021-01-14 | Juneau | Wisconsin | 55057 | 2798 | 12 |
930108 | 930108 | 2021-01-14 | Kenosha | Wisconsin | 55059 | 15225 | 257 |
930109 | 930109 | 2021-01-14 | Kewaunee | Wisconsin | 55061 | 2343 | 26 |
930110 | 930110 | 2021-01-14 | La Crosse | Wisconsin | 55063 | 11494 | 64 |
930111 | 930111 | 2021-01-14 | Lafayette | Wisconsin | 55065 | 1421 | 7 |
930112 | 930112 | 2021-01-14 | Langlade | Wisconsin | 55067 | 2004 | 41 |
930113 | 930113 | 2021-01-14 | Lincoln | Wisconsin | 55069 | 2848 | 64 |
930114 | 930114 | 2021-01-14 | Manitowoc | Wisconsin | 55071 | 7531 | 65 |
930115 | 930115 | 2021-01-14 | Marathon | Wisconsin | 55073 | 13929 | 193 |
930116 | 930116 | 2021-01-14 | Marinette | Wisconsin | 55075 | 4091 | 53 |
930117 | 930117 | 2021-01-14 | Marquette | Wisconsin | 55077 | 1362 | 25 |
930118 | 930118 | 2021-01-14 | Menominee | Wisconsin | 55078 | 766 | 11 |
930119 | 930119 | 2021-01-14 | Milwaukee | Wisconsin | 55079 | 98299 | 1030 |
930120 | 930120 | 2021-01-14 | Monroe | Wisconsin | 55081 | 3842 | 27 |
930121 | 930121 | 2021-01-14 | Oconto | Wisconsin | 55083 | 4397 | 46 |
930122 | 930122 | 2021-01-14 | Oneida | Wisconsin | 55085 | 3114 | 53 |
930123 | 930123 | 2021-01-14 | Outagamie | Wisconsin | 55087 | 19228 | 171 |
930124 | 930124 | 2021-01-14 | Ozaukee | Wisconsin | 55089 | 7730 | 64 |
930125 | 930125 | 2021-01-14 | Pepin | Wisconsin | 55091 | 762 | 6 |
930126 | 930126 | 2021-01-14 | Pierce | Wisconsin | 55093 | 3890 | 35 |
930127 | 930127 | 2021-01-14 | Polk | Wisconsin | 55095 | 3386 | 29 |
930128 | 930128 | 2021-01-14 | Portage | Wisconsin | 55097 | 6294 | 60 |
930129 | 930129 | 2021-01-14 | Price | Wisconsin | 55099 | 1070 | 6 |
930130 | 930130 | 2021-01-14 | Racine | Wisconsin | 55101 | 21221 | 290 |
930131 | 930131 | 2021-01-14 | Richland | Wisconsin | 55103 | 1212 | 13 |
930132 | 930132 | 2021-01-14 | Rock | Wisconsin | 55105 | 14241 | 136 |
930133 | 930133 | 2021-01-14 | Rusk | Wisconsin | 55107 | 1217 | 15 |
930134 | 930134 | 2021-01-14 | Sauk | Wisconsin | 55111 | 5036 | 37 |
930135 | 930135 | 2021-01-14 | Sawyer | Wisconsin | 55113 | 1336 | 17 |
930136 | 930136 | 2021-01-14 | Shawano | Wisconsin | 55115 | 4809 | 74 |
930137 | 930137 | 2021-01-14 | Sheboygan | Wisconsin | 55117 | 12604 | 110 |
930138 | 930138 | 2021-01-14 | St. Croix | Wisconsin | 55109 | 7080 | 35 |
930139 | 930139 | 2021-01-14 | Taylor | Wisconsin | 55119 | 1884 | 21 |
930140 | 930140 | 2021-01-14 | Trempealeau | Wisconsin | 55121 | 3233 | 33 |
930141 | 930141 | 2021-01-14 | Vernon | Wisconsin | 55123 | 1701 | 33 |
930142 | 930142 | 2021-01-14 | Vilas | Wisconsin | 55125 | 1856 | 33 |
930143 | 930143 | 2021-01-14 | Walworth | Wisconsin | 55127 | 10324 | 117 |
930144 | 930144 | 2021-01-14 | Washburn | Wisconsin | 55129 | 1202 | 17 |
930145 | 930145 | 2021-01-14 | Washington | Wisconsin | 55131 | 14272 | 111 |
930146 | 930146 | 2021-01-14 | Waukesha | Wisconsin | 55133 | 40764 | 410 |
930147 | 930147 | 2021-01-14 | Waupaca | Wisconsin | 55135 | 5151 | 141 |
930148 | 930148 | 2021-01-14 | Waushara | Wisconsin | 55137 | 2185 | 24 |
930149 | 930149 | 2021-01-14 | Winnebago | Wisconsin | 55139 | 18117 | 181 |
930150 | 930150 | 2021-01-14 | Wood | Wisconsin | 55141 | 6425 | 72 |
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);