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-10-08 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1797024 | 1797024 | 2021-10-08 | Adams | Wisconsin | 55001 | 2617 | 33 |
1797025 | 1797025 | 2021-10-08 | Ashland | Wisconsin | 55003 | 1755 | 16 |
1797026 | 1797026 | 2021-10-08 | Barron | Wisconsin | 55005 | 7960 | 87 |
1797027 | 1797027 | 2021-10-08 | Bayfield | Wisconsin | 55007 | 1545 | 24 |
1797028 | 1797028 | 2021-10-08 | Brown | Wisconsin | 55009 | 43273 | 315 |
1797029 | 1797029 | 2021-10-08 | Buffalo | Wisconsin | 55011 | 1851 | 7 |
1797030 | 1797030 | 2021-10-08 | Burnett | Wisconsin | 55013 | 2030 | 29 |
1797031 | 1797031 | 2021-10-08 | Calumet | Wisconsin | 55015 | 7895 | 59 |
1797032 | 1797032 | 2021-10-08 | Chippewa | Wisconsin | 55017 | 10342 | 114 |
1797033 | 1797033 | 2021-10-08 | Clark | Wisconsin | 55019 | 4592 | 73 |
1797034 | 1797034 | 2021-10-08 | Columbia | Wisconsin | 55021 | 7529 | 78 |
1797035 | 1797035 | 2021-10-08 | Crawford | Wisconsin | 55023 | 2172 | 22 |
1797036 | 1797036 | 2021-10-08 | Dane | Wisconsin | 55025 | 55822 | 359 |
1797037 | 1797037 | 2021-10-08 | Dodge | Wisconsin | 55027 | 15458 | 223 |
1797038 | 1797038 | 2021-10-08 | Door | Wisconsin | 55029 | 3582 | 38 |
1797039 | 1797039 | 2021-10-08 | Douglas | Wisconsin | 55031 | 5698 | 66 |
1797040 | 1797040 | 2021-10-08 | Dunn | Wisconsin | 55033 | 6642 | 44 |
1797041 | 1797041 | 2021-10-08 | Eau Claire | Wisconsin | 55035 | 15310 | 135 |
1797042 | 1797042 | 2021-10-08 | Florence | Wisconsin | 55037 | 583 | 13 |
1797043 | 1797043 | 2021-10-08 | Fond du Lac | Wisconsin | 55039 | 17171 | 154 |
1797044 | 1797044 | 2021-10-08 | Forest | Wisconsin | 55041 | 1446 | 31 |
1797045 | 1797045 | 2021-10-08 | Grant | Wisconsin | 55043 | 7170 | 107 |
1797046 | 1797046 | 2021-10-08 | Green | Wisconsin | 55045 | 4365 | 28 |
1797047 | 1797047 | 2021-10-08 | Green Lake | Wisconsin | 55047 | 2885 | 29 |
1797048 | 1797048 | 2021-10-08 | Iowa | Wisconsin | 55049 | 2625 | 16 |
1797049 | 1797049 | 2021-10-08 | Iron | Wisconsin | 55051 | 836 | 42 |
1797050 | 1797050 | 2021-10-08 | Jackson | Wisconsin | 55053 | 3231 | 31 |
1797051 | 1797051 | 2021-10-08 | Jefferson | Wisconsin | 55055 | 11431 | 147 |
1797052 | 1797052 | 2021-10-08 | Juneau | Wisconsin | 55057 | 4043 | 34 |
1797053 | 1797053 | 2021-10-08 | Kenosha | Wisconsin | 55059 | 23175 | 368 |
1797054 | 1797054 | 2021-10-08 | Kewaunee | Wisconsin | 55061 | 3392 | 41 |
1797055 | 1797055 | 2021-10-08 | La Crosse | Wisconsin | 55063 | 16634 | 106 |
1797056 | 1797056 | 2021-10-08 | Lafayette | Wisconsin | 55065 | 2021 | 12 |
1797057 | 1797057 | 2021-10-08 | Langlade | Wisconsin | 55067 | 2942 | 54 |
1797058 | 1797058 | 2021-10-08 | Lincoln | Wisconsin | 55069 | 4089 | 106 |
1797059 | 1797059 | 2021-10-08 | Manitowoc | Wisconsin | 55071 | 10977 | 103 |
1797060 | 1797060 | 2021-10-08 | Marathon | Wisconsin | 55073 | 19923 | 256 |
1797061 | 1797061 | 2021-10-08 | Marinette | Wisconsin | 55075 | 6155 | 78 |
1797062 | 1797062 | 2021-10-08 | Marquette | Wisconsin | 55077 | 2091 | 31 |
1797063 | 1797063 | 2021-10-08 | Menominee | Wisconsin | 55078 | 922 | 11 |
1797064 | 1797064 | 2021-10-08 | Milwaukee | Wisconsin | 55079 | 146320 | 1566 |
1797065 | 1797065 | 2021-10-08 | Monroe | Wisconsin | 55081 | 6030 | 54 |
1797066 | 1797066 | 2021-10-08 | Oconto | Wisconsin | 55083 | 6798 | 76 |
1797067 | 1797067 | 2021-10-08 | Oneida | Wisconsin | 55085 | 4649 | 85 |
1797068 | 1797068 | 2021-10-08 | Outagamie | Wisconsin | 55087 | 28942 | 262 |
1797069 | 1797069 | 2021-10-08 | Ozaukee | Wisconsin | 55089 | 11808 | 114 |
1797070 | 1797070 | 2021-10-08 | Pepin | Wisconsin | 55091 | 1121 | 10 |
1797071 | 1797071 | 2021-10-08 | Pierce | Wisconsin | 55093 | 5996 | 44 |
1797072 | 1797072 | 2021-10-08 | Polk | Wisconsin | 55095 | 6386 | 76 |
1797073 | 1797073 | 2021-10-08 | Portage | Wisconsin | 55097 | 9093 | 92 |
1797074 | 1797074 | 2021-10-08 | Price | Wisconsin | 55099 | 1683 | 9 |
1797075 | 1797075 | 2021-10-08 | Racine | Wisconsin | 55101 | 30664 | 441 |
1797076 | 1797076 | 2021-10-08 | Richland | Wisconsin | 55103 | 1965 | 22 |
1797077 | 1797077 | 2021-10-08 | Rock | Wisconsin | 55105 | 21600 | 228 |
1797078 | 1797078 | 2021-10-08 | Rusk | Wisconsin | 55107 | 2077 | 31 |
1797079 | 1797079 | 2021-10-08 | Sauk | Wisconsin | 55111 | 7882 | 63 |
1797080 | 1797080 | 2021-10-08 | Sawyer | Wisconsin | 55113 | 2352 | 31 |
1797081 | 1797081 | 2021-10-08 | Shawano | Wisconsin | 55115 | 6695 | 90 |
1797082 | 1797082 | 2021-10-08 | Sheboygan | Wisconsin | 55117 | 17419 | 175 |
1797083 | 1797083 | 2021-10-08 | St. Croix | Wisconsin | 55109 | 12210 | 83 |
1797084 | 1797084 | 2021-10-08 | Taylor | Wisconsin | 55119 | 2822 | 43 |
1797085 | 1797085 | 2021-10-08 | Trempealeau | Wisconsin | 55121 | 4722 | 52 |
1797086 | 1797086 | 2021-10-08 | Vernon | Wisconsin | 55123 | 2717 | 54 |
1797087 | 1797087 | 2021-10-08 | Vilas | Wisconsin | 55125 | 2914 | 50 |
1797088 | 1797088 | 2021-10-08 | Walworth | Wisconsin | 55127 | 15095 | 185 |
1797089 | 1797089 | 2021-10-08 | Washburn | Wisconsin | 55129 | 2082 | 26 |
1797090 | 1797090 | 2021-10-08 | Washington | Wisconsin | 55131 | 21327 | 218 |
1797091 | 1797091 | 2021-10-08 | Waukesha | Wisconsin | 55133 | 60225 | 702 |
1797092 | 1797092 | 2021-10-08 | Waupaca | Wisconsin | 55135 | 7710 | 179 |
1797093 | 1797093 | 2021-10-08 | Waushara | Wisconsin | 55137 | 3453 | 48 |
1797094 | 1797094 | 2021-10-08 | Winnebago | Wisconsin | 55139 | 26264 | 250 |
1797095 | 1797095 | 2021-10-08 | Wood | Wisconsin | 55141 | 9992 | 127 |
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);