ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2021-05-07" 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 |
---|---|---|---|---|---|---|---|
1296927 | 1296927 | 2021-05-07 | Adams | Wisconsin | 55001 | 1922 | 17 |
1296928 | 1296928 | 2021-05-07 | Ashland | Wisconsin | 55003 | 1354 | 15 |
1296929 | 1296929 | 2021-05-07 | Barron | Wisconsin | 55005 | 5922 | 83 |
1296930 | 1296930 | 2021-05-07 | Bayfield | Wisconsin | 55007 | 1262 | 19 |
1296931 | 1296931 | 2021-05-07 | Brown | Wisconsin | 55009 | 35075 | 288 |
1296932 | 1296932 | 2021-05-07 | Buffalo | Wisconsin | 55011 | 1388 | 7 |
1296933 | 1296933 | 2021-05-07 | Burnett | Wisconsin | 55013 | 1506 | 22 |
1296934 | 1296934 | 2021-05-07 | Calumet | Wisconsin | 55015 | 6433 | 54 |
1296935 | 1296935 | 2021-05-07 | Chippewa | Wisconsin | 55017 | 7556 | 96 |
1296936 | 1296936 | 2021-05-07 | Clark | Wisconsin | 55019 | 3648 | 62 |
1296937 | 1296937 | 2021-05-07 | Columbia | Wisconsin | 55021 | 5798 | 69 |
1296938 | 1296938 | 2021-05-07 | Crawford | Wisconsin | 55023 | 1774 | 17 |
1296939 | 1296939 | 2021-05-07 | Dane | Wisconsin | 55025 | 46013 | 325 |
1296940 | 1296940 | 2021-05-07 | Dodge | Wisconsin | 55027 | 12757 | 185 |
1296941 | 1296941 | 2021-05-07 | Door | Wisconsin | 55029 | 2819 | 28 |
1296942 | 1296942 | 2021-05-07 | Douglas | Wisconsin | 55031 | 4811 | 52 |
1296943 | 1296943 | 2021-05-07 | Dunn | Wisconsin | 55033 | 5044 | 32 |
1296944 | 1296944 | 2021-05-07 | Eau Claire | Wisconsin | 55035 | 11862 | 119 |
1296945 | 1296945 | 2021-05-07 | Florence | Wisconsin | 55037 | 501 | 12 |
1296946 | 1296946 | 2021-05-07 | Fond du Lac | Wisconsin | 55039 | 13614 | 121 |
1296947 | 1296947 | 2021-05-07 | Forest | Wisconsin | 55041 | 1039 | 26 |
1296948 | 1296948 | 2021-05-07 | Grant | Wisconsin | 55043 | 5674 | 90 |
1296949 | 1296949 | 2021-05-07 | Green | Wisconsin | 55045 | 3619 | 24 |
1296950 | 1296950 | 2021-05-07 | Green Lake | Wisconsin | 55047 | 2011 | 22 |
1296951 | 1296951 | 2021-05-07 | Iowa | Wisconsin | 55049 | 2109 | 11 |
1296952 | 1296952 | 2021-05-07 | Iron | Wisconsin | 55051 | 695 | 40 |
1296953 | 1296953 | 2021-05-07 | Jackson | Wisconsin | 55053 | 2690 | 28 |
1296954 | 1296954 | 2021-05-07 | Jefferson | Wisconsin | 55055 | 9561 | 132 |
1296955 | 1296955 | 2021-05-07 | Juneau | Wisconsin | 55057 | 3274 | 27 |
1296956 | 1296956 | 2021-05-07 | Kenosha | Wisconsin | 55059 | 18310 | 324 |
1296957 | 1296957 | 2021-05-07 | Kewaunee | Wisconsin | 55061 | 2685 | 35 |
1296958 | 1296958 | 2021-05-07 | La Crosse | Wisconsin | 55063 | 13535 | 86 |
1296959 | 1296959 | 2021-05-07 | Lafayette | Wisconsin | 55065 | 1708 | 9 |
1296960 | 1296960 | 2021-05-07 | Langlade | Wisconsin | 55067 | 2163 | 46 |
1296961 | 1296961 | 2021-05-07 | Lincoln | Wisconsin | 55069 | 3270 | 92 |
1296962 | 1296962 | 2021-05-07 | Manitowoc | Wisconsin | 55071 | 8780 | 88 |
1296963 | 1296963 | 2021-05-07 | Marathon | Wisconsin | 55073 | 16142 | 224 |
1296964 | 1296964 | 2021-05-07 | Marinette | Wisconsin | 55075 | 4596 | 70 |
1296965 | 1296965 | 2021-05-07 | Marquette | Wisconsin | 55077 | 1559 | 28 |
1296966 | 1296966 | 2021-05-07 | Menominee | Wisconsin | 55078 | 811 | 11 |
1296967 | 1296967 | 2021-05-07 | Milwaukee | Wisconsin | 55079 | 115667 | 1348 |
1296968 | 1296968 | 2021-05-07 | Monroe | Wisconsin | 55081 | 4636 | 38 |
1296969 | 1296969 | 2021-05-07 | Oconto | Wisconsin | 55083 | 4996 | 62 |
1296970 | 1296970 | 2021-05-07 | Oneida | Wisconsin | 55085 | 3789 | 77 |
1296971 | 1296971 | 2021-05-07 | Outagamie | Wisconsin | 55087 | 23554 | 221 |
1296972 | 1296972 | 2021-05-07 | Ozaukee | Wisconsin | 55089 | 9156 | 93 |
1296973 | 1296973 | 2021-05-07 | Pepin | Wisconsin | 55091 | 879 | 7 |
1296974 | 1296974 | 2021-05-07 | Pierce | Wisconsin | 55093 | 4917 | 43 |
1296975 | 1296975 | 2021-05-07 | Polk | Wisconsin | 55095 | 4607 | 54 |
1296976 | 1296976 | 2021-05-07 | Portage | Wisconsin | 55097 | 7312 | 72 |
1296977 | 1296977 | 2021-05-07 | Price | Wisconsin | 55099 | 1336 | 7 |
1296978 | 1296978 | 2021-05-07 | Racine | Wisconsin | 55101 | 24752 | 373 |
1296979 | 1296979 | 2021-05-07 | Richland | Wisconsin | 55103 | 1376 | 15 |
1296980 | 1296980 | 2021-05-07 | Rock | Wisconsin | 55105 | 17845 | 192 |
1296981 | 1296981 | 2021-05-07 | Rusk | Wisconsin | 55107 | 1366 | 18 |
1296982 | 1296982 | 2021-05-07 | Sauk | Wisconsin | 55111 | 6086 | 53 |
1296983 | 1296983 | 2021-05-07 | Sawyer | Wisconsin | 55113 | 1734 | 26 |
1296984 | 1296984 | 2021-05-07 | Shawano | Wisconsin | 55115 | 5271 | 83 |
1296985 | 1296985 | 2021-05-07 | Sheboygan | Wisconsin | 55117 | 14624 | 153 |
1296986 | 1296986 | 2021-05-07 | St. Croix | Wisconsin | 55109 | 9497 | 59 |
1296987 | 1296987 | 2021-05-07 | Taylor | Wisconsin | 55119 | 2103 | 32 |
1296988 | 1296988 | 2021-05-07 | Trempealeau | Wisconsin | 55121 | 3641 | 44 |
1296989 | 1296989 | 2021-05-07 | Vernon | Wisconsin | 55123 | 1987 | 42 |
1296990 | 1296990 | 2021-05-07 | Vilas | Wisconsin | 55125 | 2393 | 41 |
1296991 | 1296991 | 2021-05-07 | Walworth | Wisconsin | 55127 | 12487 | 159 |
1296992 | 1296992 | 2021-05-07 | Washburn | Wisconsin | 55129 | 1543 | 21 |
1296993 | 1296993 | 2021-05-07 | Washington | Wisconsin | 55131 | 16695 | 167 |
1296994 | 1296994 | 2021-05-07 | Waukesha | Wisconsin | 55133 | 48645 | 577 |
1296995 | 1296995 | 2021-05-07 | Waupaca | Wisconsin | 55135 | 6010 | 164 |
1296996 | 1296996 | 2021-05-07 | Waushara | Wisconsin | 55137 | 2497 | 37 |
1296997 | 1296997 | 2021-05-07 | Winnebago | Wisconsin | 55139 | 21200 | 218 |
1296998 | 1296998 | 2021-05-07 | Wood | Wisconsin | 55141 | 7531 | 93 |
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);