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-16 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
340934 | 340934 | 2020-07-16 | Adams | Wisconsin | 55001 | 46 | 2 |
340935 | 340935 | 2020-07-16 | Ashland | Wisconsin | 55003 | 8 | 0 |
340936 | 340936 | 2020-07-16 | Barron | Wisconsin | 55005 | 59 | 1 |
340937 | 340937 | 2020-07-16 | Bayfield | Wisconsin | 55007 | 11 | 1 |
340938 | 340938 | 2020-07-16 | Brown | Wisconsin | 55009 | 3393 | 44 |
340939 | 340939 | 2020-07-16 | Buffalo | Wisconsin | 55011 | 21 | 2 |
340940 | 340940 | 2020-07-16 | Burnett | Wisconsin | 55013 | 5 | 1 |
340941 | 340941 | 2020-07-16 | Calumet | Wisconsin | 55015 | 169 | 2 |
340942 | 340942 | 2020-07-16 | Chippewa | Wisconsin | 55017 | 151 | 0 |
340943 | 340943 | 2020-07-16 | Clark | Wisconsin | 55019 | 128 | 7 |
340944 | 340944 | 2020-07-16 | Columbia | Wisconsin | 55021 | 131 | 1 |
340945 | 340945 | 2020-07-16 | Crawford | Wisconsin | 55023 | 46 | 0 |
340946 | 340946 | 2020-07-16 | Dane | Wisconsin | 55025 | 3301 | 33 |
340947 | 340947 | 2020-07-16 | Dodge | Wisconsin | 55027 | 541 | 5 |
340948 | 340948 | 2020-07-16 | Door | Wisconsin | 55029 | 66 | 3 |
340949 | 340949 | 2020-07-16 | Douglas | Wisconsin | 55031 | 66 | 0 |
340950 | 340950 | 2020-07-16 | Dunn | Wisconsin | 55033 | 59 | 0 |
340951 | 340951 | 2020-07-16 | Eau Claire | Wisconsin | 55035 | 365 | 1 |
340952 | 340952 | 2020-07-16 | Florence | Wisconsin | 55037 | 5 | 0 |
340953 | 340953 | 2020-07-16 | Fond du Lac | Wisconsin | 55039 | 410 | 6 |
340954 | 340954 | 2020-07-16 | Forest | Wisconsin | 55041 | 49 | 3 |
340955 | 340955 | 2020-07-16 | Grant | Wisconsin | 55043 | 231 | 14 |
340956 | 340956 | 2020-07-16 | Green | Wisconsin | 55045 | 113 | 1 |
340957 | 340957 | 2020-07-16 | Green Lake | Wisconsin | 55047 | 44 | 0 |
340958 | 340958 | 2020-07-16 | Iowa | Wisconsin | 55049 | 47 | 0 |
340959 | 340959 | 2020-07-16 | Iron | Wisconsin | 55051 | 24 | 1 |
340960 | 340960 | 2020-07-16 | Jackson | Wisconsin | 55053 | 36 | 1 |
340961 | 340961 | 2020-07-16 | Jefferson | Wisconsin | 55055 | 393 | 4 |
340962 | 340962 | 2020-07-16 | Juneau | Wisconsin | 55057 | 66 | 1 |
340963 | 340963 | 2020-07-16 | Kenosha | Wisconsin | 55059 | 1879 | 47 |
340964 | 340964 | 2020-07-16 | Kewaunee | Wisconsin | 55061 | 86 | 1 |
340965 | 340965 | 2020-07-16 | La Crosse | Wisconsin | 55063 | 628 | 0 |
340966 | 340966 | 2020-07-16 | Lafayette | Wisconsin | 55065 | 84 | 0 |
340967 | 340967 | 2020-07-16 | Langlade | Wisconsin | 55067 | 11 | 1 |
340968 | 340968 | 2020-07-16 | Lincoln | Wisconsin | 55069 | 25 | 0 |
340969 | 340969 | 2020-07-16 | Manitowoc | Wisconsin | 55071 | 177 | 1 |
340970 | 340970 | 2020-07-16 | Marathon | Wisconsin | 55073 | 326 | 2 |
340971 | 340971 | 2020-07-16 | Marinette | Wisconsin | 55075 | 133 | 3 |
340972 | 340972 | 2020-07-16 | Marquette | Wisconsin | 55077 | 55 | 1 |
340973 | 340973 | 2020-07-16 | Menominee | Wisconsin | 55078 | 9 | 0 |
340974 | 340974 | 2020-07-16 | Milwaukee | Wisconsin | 55079 | 15179 | 403 |
340975 | 340975 | 2020-07-16 | Monroe | Wisconsin | 55081 | 148 | 1 |
340976 | 340976 | 2020-07-16 | Oconto | Wisconsin | 55083 | 104 | 0 |
340977 | 340977 | 2020-07-16 | Oneida | Wisconsin | 55085 | 39 | 0 |
340978 | 340978 | 2020-07-16 | Outagamie | Wisconsin | 55087 | 728 | 10 |
340979 | 340979 | 2020-07-16 | Ozaukee | Wisconsin | 55089 | 370 | 17 |
340980 | 340980 | 2020-07-16 | Pepin | Wisconsin | 55091 | 19 | 0 |
340981 | 340981 | 2020-07-16 | Pierce | Wisconsin | 55093 | 119 | 0 |
340982 | 340982 | 2020-07-16 | Polk | Wisconsin | 55095 | 75 | 2 |
340983 | 340983 | 2020-07-16 | Portage | Wisconsin | 55097 | 263 | 0 |
340984 | 340984 | 2020-07-16 | Price | Wisconsin | 55099 | 9 | 0 |
340985 | 340985 | 2020-07-16 | Racine | Wisconsin | 55101 | 2818 | 66 |
340986 | 340986 | 2020-07-16 | Richland | Wisconsin | 55103 | 17 | 4 |
340987 | 340987 | 2020-07-16 | Rock | Wisconsin | 55105 | 1219 | 24 |
340988 | 340988 | 2020-07-16 | Rusk | Wisconsin | 55107 | 13 | 1 |
340989 | 340989 | 2020-07-16 | Sauk | Wisconsin | 55111 | 194 | 3 |
340990 | 340990 | 2020-07-16 | Sawyer | Wisconsin | 55113 | 15 | 0 |
340991 | 340991 | 2020-07-16 | Shawano | Wisconsin | 55115 | 106 | 0 |
340992 | 340992 | 2020-07-16 | Sheboygan | Wisconsin | 55117 | 340 | 4 |
340993 | 340993 | 2020-07-16 | St. Croix | Wisconsin | 55109 | 310 | 2 |
340994 | 340994 | 2020-07-16 | Taylor | Wisconsin | 55119 | 26 | 0 |
340995 | 340995 | 2020-07-16 | Trempealeau | Wisconsin | 55121 | 213 | 0 |
340996 | 340996 | 2020-07-16 | Unknown | Wisconsin | 3041 | 7 | |
340997 | 340997 | 2020-07-16 | Vernon | Wisconsin | 55123 | 42 | 0 |
340998 | 340998 | 2020-07-16 | Vilas | Wisconsin | 55125 | 17 | 0 |
340999 | 340999 | 2020-07-16 | Walworth | Wisconsin | 55127 | 826 | 18 |
341000 | 341000 | 2020-07-16 | Washburn | Wisconsin | 55129 | 6 | 0 |
341001 | 341001 | 2020-07-16 | Washington | Wisconsin | 55131 | 537 | 19 |
341002 | 341002 | 2020-07-16 | Waukesha | Wisconsin | 55133 | 1990 | 40 |
341003 | 341003 | 2020-07-16 | Waupaca | Wisconsin | 55135 | 202 | 13 |
341004 | 341004 | 2020-07-16 | Waushara | Wisconsin | 55137 | 49 | 0 |
341005 | 341005 | 2020-07-16 | Winnebago | Wisconsin | 55139 | 810 | 14 |
341006 | 341006 | 2020-07-16 | Wood | Wisconsin | 55141 | 120 | 1 |
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);