ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where date = "2020-07-26" 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 |
---|---|---|---|---|---|---|---|
372979 | 372979 | 2020-07-26 | Adams | Wisconsin | 55001 | 61 | 2 |
372980 | 372980 | 2020-07-26 | Ashland | Wisconsin | 55003 | 15 | 0 |
372981 | 372981 | 2020-07-26 | Barron | Wisconsin | 55005 | 116 | 3 |
372982 | 372982 | 2020-07-26 | Bayfield | Wisconsin | 55007 | 18 | 1 |
372983 | 372983 | 2020-07-26 | Brown | Wisconsin | 55009 | 3766 | 50 |
372984 | 372984 | 2020-07-26 | Buffalo | Wisconsin | 55011 | 36 | 2 |
372985 | 372985 | 2020-07-26 | Burnett | Wisconsin | 55013 | 9 | 1 |
372986 | 372986 | 2020-07-26 | Calumet | Wisconsin | 55015 | 215 | 2 |
372987 | 372987 | 2020-07-26 | Chippewa | Wisconsin | 55017 | 192 | 0 |
372988 | 372988 | 2020-07-26 | Clark | Wisconsin | 55019 | 157 | 7 |
372989 | 372989 | 2020-07-26 | Columbia | Wisconsin | 55021 | 195 | 1 |
372990 | 372990 | 2020-07-26 | Crawford | Wisconsin | 55023 | 52 | 0 |
372991 | 372991 | 2020-07-26 | Dane | Wisconsin | 55025 | 3831 | 33 |
372992 | 372992 | 2020-07-26 | Dodge | Wisconsin | 55027 | 617 | 5 |
372993 | 372993 | 2020-07-26 | Door | Wisconsin | 55029 | 82 | 3 |
372994 | 372994 | 2020-07-26 | Douglas | Wisconsin | 55031 | 92 | 0 |
372995 | 372995 | 2020-07-26 | Dunn | Wisconsin | 55033 | 88 | 0 |
372996 | 372996 | 2020-07-26 | Eau Claire | Wisconsin | 55035 | 433 | 3 |
372997 | 372997 | 2020-07-26 | Florence | Wisconsin | 55037 | 5 | 0 |
372998 | 372998 | 2020-07-26 | Fond du Lac | Wisconsin | 55039 | 493 | 6 |
372999 | 372999 | 2020-07-26 | Forest | Wisconsin | 55041 | 57 | 4 |
373000 | 373000 | 2020-07-26 | Grant | Wisconsin | 55043 | 286 | 14 |
373001 | 373001 | 2020-07-26 | Green | Wisconsin | 55045 | 120 | 1 |
373002 | 373002 | 2020-07-26 | Green Lake | Wisconsin | 55047 | 49 | 0 |
373003 | 373003 | 2020-07-26 | Iowa | Wisconsin | 55049 | 57 | 0 |
373004 | 373004 | 2020-07-26 | Iron | Wisconsin | 55051 | 60 | 1 |
373005 | 373005 | 2020-07-26 | Jackson | Wisconsin | 55053 | 39 | 1 |
373006 | 373006 | 2020-07-26 | Jefferson | Wisconsin | 55055 | 511 | 4 |
373007 | 373007 | 2020-07-26 | Juneau | Wisconsin | 55057 | 107 | 1 |
373008 | 373008 | 2020-07-26 | Kenosha | Wisconsin | 55059 | 2245 | 50 |
373009 | 373009 | 2020-07-26 | Kewaunee | Wisconsin | 55061 | 100 | 1 |
373010 | 373010 | 2020-07-26 | La Crosse | Wisconsin | 55063 | 735 | 1 |
373011 | 373011 | 2020-07-26 | Lafayette | Wisconsin | 55065 | 99 | 0 |
373012 | 373012 | 2020-07-26 | Langlade | Wisconsin | 55067 | 30 | 1 |
373013 | 373013 | 2020-07-26 | Lincoln | Wisconsin | 55069 | 52 | 0 |
373014 | 373014 | 2020-07-26 | Manitowoc | Wisconsin | 55071 | 247 | 1 |
373015 | 373015 | 2020-07-26 | Marathon | Wisconsin | 55073 | 494 | 4 |
373016 | 373016 | 2020-07-26 | Marinette | Wisconsin | 55075 | 231 | 3 |
373017 | 373017 | 2020-07-26 | Marquette | Wisconsin | 55077 | 67 | 1 |
373018 | 373018 | 2020-07-26 | Menominee | Wisconsin | 55078 | 17 | 0 |
373019 | 373019 | 2020-07-26 | Milwaukee | Wisconsin | 55079 | 18140 | 427 |
373020 | 373020 | 2020-07-26 | Monroe | Wisconsin | 55081 | 177 | 1 |
373021 | 373021 | 2020-07-26 | Oconto | Wisconsin | 55083 | 140 | 0 |
373022 | 373022 | 2020-07-26 | Oneida | Wisconsin | 55085 | 69 | 0 |
373023 | 373023 | 2020-07-26 | Outagamie | Wisconsin | 55087 | 965 | 12 |
373024 | 373024 | 2020-07-26 | Ozaukee | Wisconsin | 55089 | 473 | 17 |
373025 | 373025 | 2020-07-26 | Pepin | Wisconsin | 55091 | 38 | 0 |
373026 | 373026 | 2020-07-26 | Pierce | Wisconsin | 55093 | 148 | 0 |
373027 | 373027 | 2020-07-26 | Polk | Wisconsin | 55095 | 97 | 2 |
373028 | 373028 | 2020-07-26 | Portage | Wisconsin | 55097 | 321 | 0 |
373029 | 373029 | 2020-07-26 | Price | Wisconsin | 55099 | 19 | 0 |
373030 | 373030 | 2020-07-26 | Racine | Wisconsin | 55101 | 3276 | 72 |
373031 | 373031 | 2020-07-26 | Richland | Wisconsin | 55103 | 21 | 4 |
373032 | 373032 | 2020-07-26 | Rock | Wisconsin | 55105 | 1421 | 25 |
373033 | 373033 | 2020-07-26 | Rusk | Wisconsin | 55107 | 13 | 1 |
373034 | 373034 | 2020-07-26 | Sauk | Wisconsin | 55111 | 288 | 3 |
373035 | 373035 | 2020-07-26 | Sawyer | Wisconsin | 55113 | 24 | 0 |
373036 | 373036 | 2020-07-26 | Shawano | Wisconsin | 55115 | 129 | 0 |
373037 | 373037 | 2020-07-26 | Sheboygan | Wisconsin | 55117 | 473 | 5 |
373038 | 373038 | 2020-07-26 | St. Croix | Wisconsin | 55109 | 390 | 2 |
373039 | 373039 | 2020-07-26 | Taylor | Wisconsin | 55119 | 41 | 0 |
373040 | 373040 | 2020-07-26 | Trempealeau | Wisconsin | 55121 | 262 | 1 |
373041 | 373041 | 2020-07-26 | Unknown | Wisconsin | 3352 | 7 | |
373042 | 373042 | 2020-07-26 | Vernon | Wisconsin | 55123 | 48 | 0 |
373043 | 373043 | 2020-07-26 | Vilas | Wisconsin | 55125 | 22 | 0 |
373044 | 373044 | 2020-07-26 | Walworth | Wisconsin | 55127 | 1051 | 21 |
373045 | 373045 | 2020-07-26 | Washburn | Wisconsin | 55129 | 10 | 0 |
373046 | 373046 | 2020-07-26 | Washington | Wisconsin | 55131 | 700 | 20 |
373047 | 373047 | 2020-07-26 | Waukesha | Wisconsin | 55133 | 3001 | 43 |
373048 | 373048 | 2020-07-26 | Waupaca | Wisconsin | 55135 | 312 | 14 |
373049 | 373049 | 2020-07-26 | Waushara | Wisconsin | 55137 | 69 | 0 |
373050 | 373050 | 2020-07-26 | Winnebago | Wisconsin | 55139 | 954 | 16 |
373051 | 373051 | 2020-07-26 | Wood | Wisconsin | 55141 | 165 | 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);