ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where "date" is on date 2021-01-30 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
982003 | 982003 | 2021-01-30 | Adams | Wisconsin | 55001 | 1654 | 14 |
982004 | 982004 | 2021-01-30 | Ashland | Wisconsin | 55003 | 1208 | 16 |
982005 | 982005 | 2021-01-30 | Barron | Wisconsin | 55005 | 5247 | 71 |
982006 | 982006 | 2021-01-30 | Bayfield | Wisconsin | 55007 | 1088 | 18 |
982007 | 982007 | 2021-01-30 | Brown | Wisconsin | 55009 | 31343 | 217 |
982008 | 982008 | 2021-01-30 | Buffalo | Wisconsin | 55011 | 1290 | 7 |
982009 | 982009 | 2021-01-30 | Burnett | Wisconsin | 55013 | 1220 | 23 |
982010 | 982010 | 2021-01-30 | Calumet | Wisconsin | 55015 | 5706 | 41 |
982011 | 982011 | 2021-01-30 | Chippewa | Wisconsin | 55017 | 6950 | 82 |
982012 | 982012 | 2021-01-30 | Clark | Wisconsin | 55019 | 3462 | 60 |
982013 | 982013 | 2021-01-30 | Columbia | Wisconsin | 55021 | 5194 | 50 |
982014 | 982014 | 2021-01-30 | Crawford | Wisconsin | 55023 | 1684 | 16 |
982015 | 982015 | 2021-01-30 | Dane | Wisconsin | 55025 | 39346 | 272 |
982016 | 982016 | 2021-01-30 | Dodge | Wisconsin | 55027 | 11860 | 164 |
982017 | 982017 | 2021-01-30 | Door | Wisconsin | 55029 | 2537 | 23 |
982018 | 982018 | 2021-01-30 | Douglas | Wisconsin | 55031 | 4095 | 32 |
982019 | 982019 | 2021-01-30 | Dunn | Wisconsin | 55033 | 4358 | 26 |
982020 | 982020 | 2021-01-30 | Eau Claire | Wisconsin | 55035 | 10829 | 108 |
982021 | 982021 | 2021-01-30 | Florence | Wisconsin | 55037 | 457 | 12 |
982022 | 982022 | 2021-01-30 | Fond du Lac | Wisconsin | 55039 | 12484 | 93 |
982023 | 982023 | 2021-01-30 | Forest | Wisconsin | 55041 | 980 | 25 |
982024 | 982024 | 2021-01-30 | Grant | Wisconsin | 55043 | 5118 | 84 |
982025 | 982025 | 2021-01-30 | Green | Wisconsin | 55045 | 2812 | 19 |
982026 | 982026 | 2021-01-30 | Green Lake | Wisconsin | 55047 | 1895 | 18 |
982027 | 982027 | 2021-01-30 | Iowa | Wisconsin | 55049 | 1878 | 10 |
982028 | 982028 | 2021-01-30 | Iron | Wisconsin | 55051 | 587 | 36 |
982029 | 982029 | 2021-01-30 | Jackson | Wisconsin | 55053 | 2587 | 23 |
982030 | 982030 | 2021-01-30 | Jefferson | Wisconsin | 55055 | 8391 | 77 |
982031 | 982031 | 2021-01-30 | Juneau | Wisconsin | 55057 | 2949 | 18 |
982032 | 982032 | 2021-01-30 | Kenosha | Wisconsin | 55059 | 16128 | 284 |
982033 | 982033 | 2021-01-30 | Kewaunee | Wisconsin | 55061 | 2505 | 27 |
982034 | 982034 | 2021-01-30 | La Crosse | Wisconsin | 55063 | 12299 | 72 |
982035 | 982035 | 2021-01-30 | Lafayette | Wisconsin | 55065 | 1520 | 8 |
982036 | 982036 | 2021-01-30 | Langlade | Wisconsin | 55067 | 2039 | 43 |
982037 | 982037 | 2021-01-30 | Lincoln | Wisconsin | 55069 | 2988 | 72 |
982038 | 982038 | 2021-01-30 | Manitowoc | Wisconsin | 55071 | 7971 | 75 |
982039 | 982039 | 2021-01-30 | Marathon | Wisconsin | 55073 | 14584 | 201 |
982040 | 982040 | 2021-01-30 | Marinette | Wisconsin | 55075 | 4273 | 62 |
982041 | 982041 | 2021-01-30 | Marquette | Wisconsin | 55077 | 1434 | 26 |
982042 | 982042 | 2021-01-30 | Menominee | Wisconsin | 55078 | 785 | 11 |
982043 | 982043 | 2021-01-30 | Milwaukee | Wisconsin | 55079 | 103083 | 1163 |
982044 | 982044 | 2021-01-30 | Monroe | Wisconsin | 55081 | 4154 | 31 |
982045 | 982045 | 2021-01-30 | Oconto | Wisconsin | 55083 | 4558 | 54 |
982046 | 982046 | 2021-01-30 | Oneida | Wisconsin | 55085 | 3303 | 61 |
982047 | 982047 | 2021-01-30 | Outagamie | Wisconsin | 55087 | 20469 | 188 |
982048 | 982048 | 2021-01-30 | Ozaukee | Wisconsin | 55089 | 8194 | 78 |
982049 | 982049 | 2021-01-30 | Pepin | Wisconsin | 55091 | 796 | 7 |
982050 | 982050 | 2021-01-30 | Pierce | Wisconsin | 55093 | 4134 | 38 |
982051 | 982051 | 2021-01-30 | Polk | Wisconsin | 55095 | 3632 | 43 |
982052 | 982052 | 2021-01-30 | Portage | Wisconsin | 55097 | 6620 | 62 |
982053 | 982053 | 2021-01-30 | Price | Wisconsin | 55099 | 1190 | 7 |
982054 | 982054 | 2021-01-30 | Racine | Wisconsin | 55101 | 22276 | 327 |
982055 | 982055 | 2021-01-30 | Richland | Wisconsin | 55103 | 1261 | 13 |
982056 | 982056 | 2021-01-30 | Rock | Wisconsin | 55105 | 15178 | 157 |
982057 | 982057 | 2021-01-30 | Rusk | Wisconsin | 55107 | 1268 | 16 |
982058 | 982058 | 2021-01-30 | Sauk | Wisconsin | 55111 | 5302 | 42 |
982059 | 982059 | 2021-01-30 | Sawyer | Wisconsin | 55113 | 1442 | 17 |
982060 | 982060 | 2021-01-30 | Shawano | Wisconsin | 55115 | 4976 | 80 |
982061 | 982061 | 2021-01-30 | Sheboygan | Wisconsin | 55117 | 13111 | 121 |
982062 | 982062 | 2021-01-30 | St. Croix | Wisconsin | 55109 | 7610 | 45 |
982063 | 982063 | 2021-01-30 | Taylor | Wisconsin | 55119 | 1962 | 29 |
982064 | 982064 | 2021-01-30 | Trempealeau | Wisconsin | 55121 | 3362 | 38 |
982065 | 982065 | 2021-01-30 | Vernon | Wisconsin | 55123 | 1794 | 37 |
982066 | 982066 | 2021-01-30 | Vilas | Wisconsin | 55125 | 2059 | 34 |
982067 | 982067 | 2021-01-30 | Walworth | Wisconsin | 55127 | 10848 | 131 |
982068 | 982068 | 2021-01-30 | Washburn | Wisconsin | 55129 | 1295 | 20 |
982069 | 982069 | 2021-01-30 | Washington | Wisconsin | 55131 | 14931 | 131 |
982070 | 982070 | 2021-01-30 | Waukesha | Wisconsin | 55133 | 42861 | 485 |
982071 | 982071 | 2021-01-30 | Waupaca | Wisconsin | 55135 | 5457 | 149 |
982072 | 982072 | 2021-01-30 | Waushara | Wisconsin | 55137 | 2307 | 27 |
982073 | 982073 | 2021-01-30 | Winnebago | Wisconsin | 55139 | 19019 | 188 |
982074 | 982074 | 2021-01-30 | Wood | Wisconsin | 55141 | 6810 | 78 |
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);