ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where "date" is on date 2020-03-26 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13977 | 13977 | 2020-03-26 | Bayfield | Wisconsin | 55007 | 1 | 0 |
13978 | 13978 | 2020-03-26 | Brown | Wisconsin | 55009 | 4 | 0 |
13979 | 13979 | 2020-03-26 | Calumet | Wisconsin | 55015 | 1 | 0 |
13980 | 13980 | 2020-03-26 | Chippewa | Wisconsin | 55017 | 1 | 0 |
13981 | 13981 | 2020-03-26 | Clark | Wisconsin | 55019 | 1 | 0 |
13982 | 13982 | 2020-03-26 | Columbia | Wisconsin | 55021 | 5 | 0 |
13983 | 13983 | 2020-03-26 | Dane | Wisconsin | 55025 | 114 | 1 |
13984 | 13984 | 2020-03-26 | Dodge | Wisconsin | 55027 | 3 | 0 |
13985 | 13985 | 2020-03-26 | Douglas | Wisconsin | 55031 | 4 | 0 |
13986 | 13986 | 2020-03-26 | Dunn | Wisconsin | 55033 | 1 | 0 |
13987 | 13987 | 2020-03-26 | Eau Claire | Wisconsin | 55035 | 6 | 0 |
13988 | 13988 | 2020-03-26 | Fond du Lac | Wisconsin | 55039 | 17 | 1 |
13989 | 13989 | 2020-03-26 | Grant | Wisconsin | 55043 | 1 | 0 |
13990 | 13990 | 2020-03-26 | Green | Wisconsin | 55045 | 1 | 0 |
13991 | 13991 | 2020-03-26 | Iowa | Wisconsin | 55049 | 3 | 0 |
13992 | 13992 | 2020-03-26 | Jefferson | Wisconsin | 55055 | 5 | 0 |
13993 | 13993 | 2020-03-26 | Juneau | Wisconsin | 55057 | 1 | 0 |
13994 | 13994 | 2020-03-26 | Kenosha | Wisconsin | 55059 | 19 | 0 |
13995 | 13995 | 2020-03-26 | La Crosse | Wisconsin | 55063 | 12 | 0 |
13996 | 13996 | 2020-03-26 | Marathon | Wisconsin | 55073 | 1 | 0 |
13997 | 13997 | 2020-03-26 | Milwaukee | Wisconsin | 55079 | 393 | 7 |
13998 | 13998 | 2020-03-26 | Monroe | Wisconsin | 55081 | 1 | 0 |
13999 | 13999 | 2020-03-26 | Outagamie | Wisconsin | 55087 | 4 | 0 |
14000 | 14000 | 2020-03-26 | Ozaukee | Wisconsin | 55089 | 22 | 1 |
14001 | 14001 | 2020-03-26 | Pierce | Wisconsin | 55093 | 3 | 0 |
14002 | 14002 | 2020-03-26 | Portage | Wisconsin | 55097 | 1 | 0 |
14003 | 14003 | 2020-03-26 | Racine | Wisconsin | 55101 | 8 | 0 |
14004 | 14004 | 2020-03-26 | Rock | Wisconsin | 55105 | 8 | 0 |
14005 | 14005 | 2020-03-26 | Sauk | Wisconsin | 55111 | 7 | 0 |
14006 | 14006 | 2020-03-26 | Sheboygan | Wisconsin | 55117 | 7 | 0 |
14007 | 14007 | 2020-03-26 | St. Croix | Wisconsin | 55109 | 4 | 0 |
14008 | 14008 | 2020-03-26 | Vilas | Wisconsin | 55125 | 1 | 0 |
14009 | 14009 | 2020-03-26 | Walworth | Wisconsin | 55127 | 5 | 0 |
14010 | 14010 | 2020-03-26 | Washington | Wisconsin | 55131 | 25 | 0 |
14011 | 14011 | 2020-03-26 | Waukesha | Wisconsin | 55133 | 56 | 0 |
14012 | 14012 | 2020-03-26 | Winnebago | Wisconsin | 55139 | 6 | 0 |
14013 | 14013 | 2020-03-26 | 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);