ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where date = "2020-04-29" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
100929 | 100929 | 2020-04-29 | Adams | Wisconsin | 55001 | 4 | 1 |
100930 | 100930 | 2020-04-29 | Ashland | Wisconsin | 55003 | 2 | 0 |
100931 | 100931 | 2020-04-29 | Barron | Wisconsin | 55005 | 6 | 0 |
100932 | 100932 | 2020-04-29 | Bayfield | Wisconsin | 55007 | 3 | 1 |
100933 | 100933 | 2020-04-29 | Brown | Wisconsin | 55009 | 971 | 3 |
100934 | 100934 | 2020-04-29 | Buffalo | Wisconsin | 55011 | 4 | 1 |
100935 | 100935 | 2020-04-29 | Calumet | Wisconsin | 55015 | 12 | 0 |
100936 | 100936 | 2020-04-29 | Chippewa | Wisconsin | 55017 | 21 | 0 |
100937 | 100937 | 2020-04-29 | Clark | Wisconsin | 55019 | 20 | 4 |
100938 | 100938 | 2020-04-29 | Columbia | Wisconsin | 55021 | 27 | 1 |
100939 | 100939 | 2020-04-29 | Crawford | Wisconsin | 55023 | 3 | 0 |
100940 | 100940 | 2020-04-29 | Dane | Wisconsin | 55025 | 424 | 22 |
100941 | 100941 | 2020-04-29 | Dodge | Wisconsin | 55027 | 33 | 1 |
100942 | 100942 | 2020-04-29 | Door | Wisconsin | 55029 | 12 | 2 |
100943 | 100943 | 2020-04-29 | Douglas | Wisconsin | 55031 | 9 | 0 |
100944 | 100944 | 2020-04-29 | Dunn | Wisconsin | 55033 | 9 | 0 |
100945 | 100945 | 2020-04-29 | Eau Claire | Wisconsin | 55035 | 27 | 0 |
100946 | 100946 | 2020-04-29 | Florence | Wisconsin | 55037 | 2 | 0 |
100947 | 100947 | 2020-04-29 | Fond du Lac | Wisconsin | 55039 | 69 | 3 |
100948 | 100948 | 2020-04-29 | Grant | Wisconsin | 55043 | 35 | 6 |
100949 | 100949 | 2020-04-29 | Green | Wisconsin | 55045 | 11 | 0 |
100950 | 100950 | 2020-04-29 | Green Lake | Wisconsin | 55047 | 2 | 0 |
100951 | 100951 | 2020-04-29 | Iowa | Wisconsin | 55049 | 7 | 0 |
100952 | 100952 | 2020-04-29 | Iron | Wisconsin | 55051 | 2 | 1 |
100953 | 100953 | 2020-04-29 | Jackson | Wisconsin | 55053 | 12 | 1 |
100954 | 100954 | 2020-04-29 | Jefferson | Wisconsin | 55055 | 45 | 0 |
100955 | 100955 | 2020-04-29 | Juneau | Wisconsin | 55057 | 14 | 1 |
100956 | 100956 | 2020-04-29 | Kenosha | Wisconsin | 55059 | 363 | 11 |
100957 | 100957 | 2020-04-29 | Kewaunee | Wisconsin | 55061 | 14 | 1 |
100958 | 100958 | 2020-04-29 | La Crosse | Wisconsin | 55063 | 27 | 0 |
100959 | 100959 | 2020-04-29 | Lafayette | Wisconsin | 55065 | 4 | 0 |
100960 | 100960 | 2020-04-29 | Manitowoc | Wisconsin | 55071 | 11 | 1 |
100961 | 100961 | 2020-04-29 | Marathon | Wisconsin | 55073 | 17 | 1 |
100962 | 100962 | 2020-04-29 | Marinette | Wisconsin | 55075 | 7 | 1 |
100963 | 100963 | 2020-04-29 | Marquette | Wisconsin | 55077 | 3 | 1 |
100964 | 100964 | 2020-04-29 | Menominee | Wisconsin | 55078 | 1 | 0 |
100965 | 100965 | 2020-04-29 | Milwaukee | Wisconsin | 55079 | 2815 | 177 |
100966 | 100966 | 2020-04-29 | Monroe | Wisconsin | 55081 | 14 | 1 |
100967 | 100967 | 2020-04-29 | Oconto | Wisconsin | 55083 | 8 | 0 |
100968 | 100968 | 2020-04-29 | Oneida | Wisconsin | 55085 | 6 | 0 |
100969 | 100969 | 2020-04-29 | Outagamie | Wisconsin | 55087 | 54 | 2 |
100970 | 100970 | 2020-04-29 | Ozaukee | Wisconsin | 55089 | 86 | 9 |
100971 | 100971 | 2020-04-29 | Pierce | Wisconsin | 55093 | 10 | 0 |
100972 | 100972 | 2020-04-29 | Polk | Wisconsin | 55095 | 4 | 0 |
100973 | 100973 | 2020-04-29 | Portage | Wisconsin | 55097 | 5 | 0 |
100974 | 100974 | 2020-04-29 | Price | Wisconsin | 55099 | 1 | 0 |
100975 | 100975 | 2020-04-29 | Racine | Wisconsin | 55101 | 418 | 12 |
100976 | 100976 | 2020-04-29 | Richland | Wisconsin | 55103 | 11 | 2 |
100977 | 100977 | 2020-04-29 | Rock | Wisconsin | 55105 | 183 | 6 |
100978 | 100978 | 2020-04-29 | Rusk | Wisconsin | 55107 | 4 | 0 |
100979 | 100979 | 2020-04-29 | Sauk | Wisconsin | 55111 | 44 | 3 |
100980 | 100980 | 2020-04-29 | Sawyer | Wisconsin | 55113 | 3 | 0 |
100981 | 100981 | 2020-04-29 | Shawano | Wisconsin | 55115 | 10 | 0 |
100982 | 100982 | 2020-04-29 | Sheboygan | Wisconsin | 55117 | 46 | 2 |
100983 | 100983 | 2020-04-29 | St. Croix | Wisconsin | 55109 | 13 | 0 |
100984 | 100984 | 2020-04-29 | Trempealeau | Wisconsin | 55121 | 2 | 0 |
100985 | 100985 | 2020-04-29 | Vernon | Wisconsin | 55123 | 1 | 0 |
100986 | 100986 | 2020-04-29 | Vilas | Wisconsin | 55125 | 4 | 0 |
100987 | 100987 | 2020-04-29 | Walworth | Wisconsin | 55127 | 156 | 8 |
100988 | 100988 | 2020-04-29 | Washburn | Wisconsin | 55129 | 1 | 0 |
100989 | 100989 | 2020-04-29 | Washington | Wisconsin | 55131 | 97 | 4 |
100990 | 100990 | 2020-04-29 | Waukesha | Wisconsin | 55133 | 329 | 16 |
100991 | 100991 | 2020-04-29 | Waupaca | Wisconsin | 55135 | 8 | 1 |
100992 | 100992 | 2020-04-29 | Waushara | Wisconsin | 55137 | 2 | 0 |
100993 | 100993 | 2020-04-29 | Winnebago | Wisconsin | 55139 | 51 | 1 |
100994 | 100994 | 2020-04-29 | Wood | Wisconsin | 55141 | 2 | 0 |
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);