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-06-29 and state = "Wisconsin" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
286984 | 286984 | 2020-06-29 | Adams | Wisconsin | 55001 | 19 | 2 |
286985 | 286985 | 2020-06-29 | Ashland | Wisconsin | 55003 | 3 | 0 |
286986 | 286986 | 2020-06-29 | Barron | Wisconsin | 55005 | 34 | 0 |
286987 | 286987 | 2020-06-29 | Bayfield | Wisconsin | 55007 | 3 | 1 |
286988 | 286988 | 2020-06-29 | Brown | Wisconsin | 55009 | 2825 | 42 |
286989 | 286989 | 2020-06-29 | Buffalo | Wisconsin | 55011 | 7 | 2 |
286990 | 286990 | 2020-06-29 | Burnett | Wisconsin | 55013 | 3 | 1 |
286991 | 286991 | 2020-06-29 | Calumet | Wisconsin | 55015 | 106 | 2 |
286992 | 286992 | 2020-06-29 | Chippewa | Wisconsin | 55017 | 84 | 0 |
286993 | 286993 | 2020-06-29 | Clark | Wisconsin | 55019 | 70 | 6 |
286994 | 286994 | 2020-06-29 | Columbia | Wisconsin | 55021 | 83 | 1 |
286995 | 286995 | 2020-06-29 | Crawford | Wisconsin | 55023 | 33 | 0 |
286996 | 286996 | 2020-06-29 | Dane | Wisconsin | 55025 | 1751 | 32 |
286997 | 286997 | 2020-06-29 | Dodge | Wisconsin | 55027 | 456 | 5 |
286998 | 286998 | 2020-06-29 | Door | Wisconsin | 55029 | 43 | 3 |
286999 | 286999 | 2020-06-29 | Douglas | Wisconsin | 55031 | 24 | 0 |
287000 | 287000 | 2020-06-29 | Dunn | Wisconsin | 55033 | 37 | 0 |
287001 | 287001 | 2020-06-29 | Eau Claire | Wisconsin | 55035 | 218 | 1 |
287002 | 287002 | 2020-06-29 | Florence | Wisconsin | 55037 | 3 | 0 |
287003 | 287003 | 2020-06-29 | Fond du Lac | Wisconsin | 55039 | 309 | 6 |
287004 | 287004 | 2020-06-29 | Forest | Wisconsin | 55041 | 38 | 3 |
287005 | 287005 | 2020-06-29 | Grant | Wisconsin | 55043 | 152 | 13 |
287006 | 287006 | 2020-06-29 | Green | Wisconsin | 55045 | 88 | 1 |
287007 | 287007 | 2020-06-29 | Green Lake | Wisconsin | 55047 | 32 | 0 |
287008 | 287008 | 2020-06-29 | Iowa | Wisconsin | 55049 | 29 | 0 |
287009 | 287009 | 2020-06-29 | Iron | Wisconsin | 55051 | 6 | 1 |
287010 | 287010 | 2020-06-29 | Jackson | Wisconsin | 55053 | 26 | 1 |
287011 | 287011 | 2020-06-29 | Jefferson | Wisconsin | 55055 | 234 | 4 |
287012 | 287012 | 2020-06-29 | Juneau | Wisconsin | 55057 | 35 | 1 |
287013 | 287013 | 2020-06-29 | Kenosha | Wisconsin | 55059 | 1492 | 43 |
287014 | 287014 | 2020-06-29 | Kewaunee | Wisconsin | 55061 | 55 | 1 |
287015 | 287015 | 2020-06-29 | La Crosse | Wisconsin | 55063 | 404 | 0 |
287016 | 287016 | 2020-06-29 | Lafayette | Wisconsin | 55065 | 70 | 0 |
287017 | 287017 | 2020-06-29 | Langlade | Wisconsin | 55067 | 8 | 0 |
287018 | 287018 | 2020-06-29 | Lincoln | Wisconsin | 55069 | 9 | 0 |
287019 | 287019 | 2020-06-29 | Manitowoc | Wisconsin | 55071 | 92 | 1 |
287020 | 287020 | 2020-06-29 | Marathon | Wisconsin | 55073 | 158 | 1 |
287021 | 287021 | 2020-06-29 | Marinette | Wisconsin | 55075 | 53 | 3 |
287022 | 287022 | 2020-06-29 | Marquette | Wisconsin | 55077 | 13 | 1 |
287023 | 287023 | 2020-06-29 | Menominee | Wisconsin | 55078 | 6 | 0 |
287024 | 287024 | 2020-06-29 | Milwaukee | Wisconsin | 55079 | 11232 | 389 |
287025 | 287025 | 2020-06-29 | Monroe | Wisconsin | 55081 | 63 | 1 |
287026 | 287026 | 2020-06-29 | Oconto | Wisconsin | 55083 | 56 | 0 |
287027 | 287027 | 2020-06-29 | Oneida | Wisconsin | 55085 | 19 | 0 |
287028 | 287028 | 2020-06-29 | Outagamie | Wisconsin | 55087 | 463 | 8 |
287029 | 287029 | 2020-06-29 | Ozaukee | Wisconsin | 55089 | 237 | 16 |
287030 | 287030 | 2020-06-29 | Pepin | Wisconsin | 55091 | 1 | 0 |
287031 | 287031 | 2020-06-29 | Pierce | Wisconsin | 55093 | 68 | 0 |
287032 | 287032 | 2020-06-29 | Polk | Wisconsin | 55095 | 48 | 1 |
287033 | 287033 | 2020-06-29 | Portage | Wisconsin | 55097 | 135 | 0 |
287034 | 287034 | 2020-06-29 | Price | Wisconsin | 55099 | 2 | 0 |
287035 | 287035 | 2020-06-29 | Racine | Wisconsin | 55101 | 2488 | 61 |
287036 | 287036 | 2020-06-29 | Richland | Wisconsin | 55103 | 15 | 4 |
287037 | 287037 | 2020-06-29 | Rock | Wisconsin | 55105 | 957 | 23 |
287038 | 287038 | 2020-06-29 | Rusk | Wisconsin | 55107 | 11 | 0 |
287039 | 287039 | 2020-06-29 | Sauk | Wisconsin | 55111 | 105 | 3 |
287040 | 287040 | 2020-06-29 | Sawyer | Wisconsin | 55113 | 12 | 0 |
287041 | 287041 | 2020-06-29 | Shawano | Wisconsin | 55115 | 76 | 0 |
287042 | 287042 | 2020-06-29 | Sheboygan | Wisconsin | 55117 | 201 | 4 |
287043 | 287043 | 2020-06-29 | St. Croix | Wisconsin | 55109 | 159 | 1 |
287044 | 287044 | 2020-06-29 | Taylor | Wisconsin | 55119 | 12 | 0 |
287045 | 287045 | 2020-06-29 | Trempealeau | Wisconsin | 55121 | 111 | 0 |
287046 | 287046 | 2020-06-29 | Unknown | Wisconsin | 2538 | 7 | |
287047 | 287047 | 2020-06-29 | Vernon | Wisconsin | 55123 | 32 | 0 |
287048 | 287048 | 2020-06-29 | Vilas | Wisconsin | 55125 | 10 | 0 |
287049 | 287049 | 2020-06-29 | Walworth | Wisconsin | 55127 | 574 | 18 |
287050 | 287050 | 2020-06-29 | Washburn | Wisconsin | 55129 | 4 | 0 |
287051 | 287051 | 2020-06-29 | Washington | Wisconsin | 55131 | 366 | 16 |
287052 | 287052 | 2020-06-29 | Waukesha | Wisconsin | 55133 | 1157 | 38 |
287053 | 287053 | 2020-06-29 | Waupaca | Wisconsin | 55135 | 106 | 6 |
287054 | 287054 | 2020-06-29 | Waushara | Wisconsin | 55137 | 23 | 0 |
287055 | 287055 | 2020-06-29 | Winnebago | Wisconsin | 55139 | 662 | 11 |
287056 | 287056 | 2020-06-29 | Wood | Wisconsin | 55141 | 49 | 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);