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-12-07 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1992008 | 1992008 | 2021-12-07 | Adams | Wisconsin | 55001 | 3117 | 37 |
1992009 | 1992009 | 2021-12-07 | Ashland | Wisconsin | 55003 | 2198 | 23 |
1992010 | 1992010 | 2021-12-07 | Barron | Wisconsin | 55005 | 9778 | 101 |
1992011 | 1992011 | 2021-12-07 | Bayfield | Wisconsin | 55007 | 2045 | 30 |
1992012 | 1992012 | 2021-12-07 | Brown | Wisconsin | 55009 | 52922 | 335 |
1992013 | 1992013 | 2021-12-07 | Buffalo | Wisconsin | 55011 | 2307 | 8 |
1992014 | 1992014 | 2021-12-07 | Burnett | Wisconsin | 55013 | 2744 | 33 |
1992015 | 1992015 | 2021-12-07 | Calumet | Wisconsin | 55015 | 9719 | 73 |
1992016 | 1992016 | 2021-12-07 | Chippewa | Wisconsin | 55017 | 12563 | 130 |
1992017 | 1992017 | 2021-12-07 | Clark | Wisconsin | 55019 | 5584 | 87 |
1992018 | 1992018 | 2021-12-07 | Columbia | Wisconsin | 55021 | 9056 | 94 |
1992019 | 1992019 | 2021-12-07 | Crawford | Wisconsin | 55023 | 2710 | 23 |
1992020 | 1992020 | 2021-12-07 | Dane | Wisconsin | 55025 | 63533 | 388 |
1992021 | 1992021 | 2021-12-07 | Dodge | Wisconsin | 55027 | 18275 | 241 |
1992022 | 1992022 | 2021-12-07 | Door | Wisconsin | 55029 | 4263 | 42 |
1992023 | 1992023 | 2021-12-07 | Douglas | Wisconsin | 55031 | 7457 | 66 |
1992024 | 1992024 | 2021-12-07 | Dunn | Wisconsin | 55033 | 8608 | 53 |
1992025 | 1992025 | 2021-12-07 | Eau Claire | Wisconsin | 55035 | 18880 | 152 |
1992026 | 1992026 | 2021-12-07 | Florence | Wisconsin | 55037 | 724 | 14 |
1992027 | 1992027 | 2021-12-07 | Fond du Lac | Wisconsin | 55039 | 20433 | 176 |
1992028 | 1992028 | 2021-12-07 | Forest | Wisconsin | 55041 | 1756 | 33 |
1992029 | 1992029 | 2021-12-07 | Grant | Wisconsin | 55043 | 8605 | 121 |
1992030 | 1992030 | 2021-12-07 | Green | Wisconsin | 55045 | 5537 | 38 |
1992031 | 1992031 | 2021-12-07 | Green Lake | Wisconsin | 55047 | 3447 | 36 |
1992032 | 1992032 | 2021-12-07 | Iowa | Wisconsin | 55049 | 3140 | 19 |
1992033 | 1992033 | 2021-12-07 | Iron | Wisconsin | 55051 | 980 | 43 |
1992034 | 1992034 | 2021-12-07 | Jackson | Wisconsin | 55053 | 3884 | 35 |
1992035 | 1992035 | 2021-12-07 | Jefferson | Wisconsin | 55055 | 13666 | 168 |
1992036 | 1992036 | 2021-12-07 | Juneau | Wisconsin | 55057 | 5062 | 44 |
1992037 | 1992037 | 2021-12-07 | Kenosha | Wisconsin | 55059 | 26937 | 414 |
1992038 | 1992038 | 2021-12-07 | Kewaunee | Wisconsin | 55061 | 4133 | 49 |
1992039 | 1992039 | 2021-12-07 | La Crosse | Wisconsin | 55063 | 19958 | 128 |
1992040 | 1992040 | 2021-12-07 | Lafayette | Wisconsin | 55065 | 2459 | 13 |
1992041 | 1992041 | 2021-12-07 | Langlade | Wisconsin | 55067 | 3595 | 60 |
1992042 | 1992042 | 2021-12-07 | Lincoln | Wisconsin | 55069 | 4957 | 120 |
1992043 | 1992043 | 2021-12-07 | Manitowoc | Wisconsin | 55071 | 13849 | 123 |
1992044 | 1992044 | 2021-12-07 | Marathon | Wisconsin | 55073 | 25520 | 330 |
1992045 | 1992045 | 2021-12-07 | Marinette | Wisconsin | 55075 | 8195 | 83 |
1992046 | 1992046 | 2021-12-07 | Marquette | Wisconsin | 55077 | 2672 | 37 |
1992047 | 1992047 | 2021-12-07 | Menominee | Wisconsin | 55078 | 1006 | 11 |
1992048 | 1992048 | 2021-12-07 | Milwaukee | Wisconsin | 55079 | 163297 | 1702 |
1992049 | 1992049 | 2021-12-07 | Monroe | Wisconsin | 55081 | 7691 | 58 |
1992050 | 1992050 | 2021-12-07 | Oconto | Wisconsin | 55083 | 8061 | 78 |
1992051 | 1992051 | 2021-12-07 | Oneida | Wisconsin | 55085 | 5878 | 101 |
1992052 | 1992052 | 2021-12-07 | Outagamie | Wisconsin | 55087 | 35388 | 289 |
1992053 | 1992053 | 2021-12-07 | Ozaukee | Wisconsin | 55089 | 13869 | 123 |
1992054 | 1992054 | 2021-12-07 | Pepin | Wisconsin | 55091 | 1345 | 10 |
1992055 | 1992055 | 2021-12-07 | Pierce | Wisconsin | 55093 | 7665 | 55 |
1992056 | 1992056 | 2021-12-07 | Polk | Wisconsin | 55095 | 8493 | 98 |
1992057 | 1992057 | 2021-12-07 | Portage | Wisconsin | 55097 | 11248 | 110 |
1992058 | 1992058 | 2021-12-07 | Price | Wisconsin | 55099 | 2255 | 16 |
1992059 | 1992059 | 2021-12-07 | Racine | Wisconsin | 55101 | 35438 | 483 |
1992060 | 1992060 | 2021-12-07 | Richland | Wisconsin | 55103 | 2536 | 31 |
1992061 | 1992061 | 2021-12-07 | Rock | Wisconsin | 55105 | 25349 | 261 |
1992062 | 1992062 | 2021-12-07 | Rusk | Wisconsin | 55107 | 2471 | 37 |
1992063 | 1992063 | 2021-12-07 | Sauk | Wisconsin | 55111 | 9850 | 75 |
1992064 | 1992064 | 2021-12-07 | Sawyer | Wisconsin | 55113 | 3206 | 39 |
1992065 | 1992065 | 2021-12-07 | Shawano | Wisconsin | 55115 | 8000 | 97 |
1992066 | 1992066 | 2021-12-07 | Sheboygan | Wisconsin | 55117 | 21217 | 196 |
1992067 | 1992067 | 2021-12-07 | St. Croix | Wisconsin | 55109 | 16333 | 96 |
1992068 | 1992068 | 2021-12-07 | Taylor | Wisconsin | 55119 | 3525 | 49 |
1992069 | 1992069 | 2021-12-07 | Trempealeau | Wisconsin | 55121 | 5624 | 52 |
1992070 | 1992070 | 2021-12-07 | Vernon | Wisconsin | 55123 | 3605 | 69 |
1992071 | 1992071 | 2021-12-07 | Vilas | Wisconsin | 55125 | 3472 | 62 |
1992072 | 1992072 | 2021-12-07 | Walworth | Wisconsin | 55127 | 18034 | 206 |
1992073 | 1992073 | 2021-12-07 | Washburn | Wisconsin | 55129 | 2838 | 30 |
1992074 | 1992074 | 2021-12-07 | Washington | Wisconsin | 55131 | 25803 | 234 |
1992075 | 1992075 | 2021-12-07 | Waukesha | Wisconsin | 55133 | 70836 | 772 |
1992076 | 1992076 | 2021-12-07 | Waupaca | Wisconsin | 55135 | 9555 | 201 |
1992077 | 1992077 | 2021-12-07 | Waushara | Wisconsin | 55137 | 4147 | 59 |
1992078 | 1992078 | 2021-12-07 | Winnebago | Wisconsin | 55139 | 31731 | 287 |
1992079 | 1992079 | 2021-12-07 | Wood | Wisconsin | 55141 | 13013 | 151 |
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);