ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2020-11-14" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
732109 | 732109 | 2020-11-14 | Adams | Wisconsin | 55001 | 888 | 7 |
732110 | 732110 | 2020-11-14 | Ashland | Wisconsin | 55003 | 506 | 5 |
732111 | 732111 | 2020-11-14 | Barron | Wisconsin | 55005 | 2441 | 30 |
732112 | 732112 | 2020-11-14 | Bayfield | Wisconsin | 55007 | 519 | 3 |
732113 | 732113 | 2020-11-14 | Brown | Wisconsin | 55009 | 20227 | 123 |
732114 | 732114 | 2020-11-14 | Buffalo | Wisconsin | 55011 | 562 | 3 |
732115 | 732115 | 2020-11-14 | Burnett | Wisconsin | 55013 | 546 | 7 |
732116 | 732116 | 2020-11-14 | Calumet | Wisconsin | 55015 | 3624 | 22 |
732117 | 732117 | 2020-11-14 | Chippewa | Wisconsin | 55017 | 3478 | 38 |
732118 | 732118 | 2020-11-14 | Clark | Wisconsin | 55019 | 1746 | 27 |
732119 | 732119 | 2020-11-14 | Columbia | Wisconsin | 55021 | 2790 | 11 |
732120 | 732120 | 2020-11-14 | Crawford | Wisconsin | 55023 | 651 | 4 |
732121 | 732121 | 2020-11-14 | Dane | Wisconsin | 55025 | 21965 | 63 |
732122 | 732122 | 2020-11-14 | Dodge | Wisconsin | 55027 | 6843 | 57 |
732123 | 732123 | 2020-11-14 | Door | Wisconsin | 55029 | 1450 | 10 |
732124 | 732124 | 2020-11-14 | Douglas | Wisconsin | 55031 | 1304 | 1 |
732125 | 732125 | 2020-11-14 | Dunn | Wisconsin | 55033 | 1952 | 2 |
732126 | 732126 | 2020-11-14 | Eau Claire | Wisconsin | 55035 | 5721 | 44 |
732127 | 732127 | 2020-11-14 | Florence | Wisconsin | 55037 | 285 | 11 |
732128 | 732128 | 2020-11-14 | Fond du Lac | Wisconsin | 55039 | 7251 | 36 |
732129 | 732129 | 2020-11-14 | Forest | Wisconsin | 55041 | 679 | 12 |
732130 | 732130 | 2020-11-14 | Grant | Wisconsin | 55043 | 2958 | 53 |
732131 | 732131 | 2020-11-14 | Green | Wisconsin | 55045 | 1357 | 5 |
732132 | 732132 | 2020-11-14 | Green Lake | Wisconsin | 55047 | 1203 | 4 |
732133 | 732133 | 2020-11-14 | Iowa | Wisconsin | 55049 | 978 | 4 |
732134 | 732134 | 2020-11-14 | Iron | Wisconsin | 55051 | 346 | 7 |
732135 | 732135 | 2020-11-14 | Jackson | Wisconsin | 55053 | 1190 | 2 |
732136 | 732136 | 2020-11-14 | Jefferson | Wisconsin | 55055 | 4324 | 31 |
732137 | 732137 | 2020-11-14 | Juneau | Wisconsin | 55057 | 1547 | 6 |
732138 | 732138 | 2020-11-14 | Kenosha | Wisconsin | 55059 | 8042 | 109 |
732139 | 732139 | 2020-11-14 | Kewaunee | Wisconsin | 55061 | 1444 | 13 |
732140 | 732140 | 2020-11-14 | La Crosse | Wisconsin | 55063 | 6454 | 30 |
732141 | 732141 | 2020-11-14 | Lafayette | Wisconsin | 55065 | 882 | 2 |
732142 | 732142 | 2020-11-14 | Langlade | Wisconsin | 55067 | 1395 | 25 |
732143 | 732143 | 2020-11-14 | Lincoln | Wisconsin | 55069 | 1555 | 19 |
732144 | 732144 | 2020-11-14 | Manitowoc | Wisconsin | 55071 | 4467 | 33 |
732145 | 732145 | 2020-11-14 | Marathon | Wisconsin | 55073 | 8371 | 106 |
732146 | 732146 | 2020-11-14 | Marinette | Wisconsin | 55075 | 2645 | 22 |
732147 | 732147 | 2020-11-14 | Marquette | Wisconsin | 55077 | 1000 | 7 |
732148 | 732148 | 2020-11-14 | Menominee | Wisconsin | 55078 | 486 | 2 |
732149 | 732149 | 2020-11-14 | Milwaukee | Wisconsin | 55079 | 58485 | 652 |
732150 | 732150 | 2020-11-14 | Monroe | Wisconsin | 55081 | 1862 | 11 |
732151 | 732151 | 2020-11-14 | Oconto | Wisconsin | 55083 | 2922 | 24 |
732152 | 732152 | 2020-11-14 | Oneida | Wisconsin | 55085 | 1874 | 21 |
732153 | 732153 | 2020-11-14 | Outagamie | Wisconsin | 55087 | 12508 | 100 |
732154 | 732154 | 2020-11-14 | Ozaukee | Wisconsin | 55089 | 4173 | 32 |
732155 | 732155 | 2020-11-14 | Pepin | Wisconsin | 55091 | 330 | 1 |
732156 | 732156 | 2020-11-14 | Pierce | Wisconsin | 55093 | 1718 | 11 |
732157 | 732157 | 2020-11-14 | Polk | Wisconsin | 55095 | 1421 | 5 |
732158 | 732158 | 2020-11-14 | Portage | Wisconsin | 55097 | 4019 | 32 |
732159 | 732159 | 2020-11-14 | Price | Wisconsin | 55099 | 572 | 3 |
732160 | 732160 | 2020-11-14 | Racine | Wisconsin | 55101 | 12325 | 143 |
732161 | 732161 | 2020-11-14 | Richland | Wisconsin | 55103 | 712 | 10 |
732162 | 732162 | 2020-11-14 | Rock | Wisconsin | 55105 | 7698 | 61 |
732163 | 732163 | 2020-11-14 | Rusk | Wisconsin | 55107 | 558 | 5 |
732164 | 732164 | 2020-11-14 | Sauk | Wisconsin | 55111 | 2936 | 10 |
732165 | 732165 | 2020-11-14 | Sawyer | Wisconsin | 55113 | 622 | 5 |
732166 | 732166 | 2020-11-14 | Shawano | Wisconsin | 55115 | 3321 | 42 |
732167 | 732167 | 2020-11-14 | Sheboygan | Wisconsin | 55117 | 7410 | 45 |
732168 | 732168 | 2020-11-14 | St. Croix | Wisconsin | 55109 | 3368 | 18 |
732169 | 732169 | 2020-11-14 | Taylor | Wisconsin | 55119 | 870 | 10 |
732170 | 732170 | 2020-11-14 | Trempealeau | Wisconsin | 55121 | 1714 | 7 |
732171 | 732171 | 2020-11-14 | Vernon | Wisconsin | 55123 | 802 | 5 |
732172 | 732172 | 2020-11-14 | Vilas | Wisconsin | 55125 | 958 | 9 |
732173 | 732173 | 2020-11-14 | Walworth | Wisconsin | 55127 | 5279 | 45 |
732174 | 732174 | 2020-11-14 | Washburn | Wisconsin | 55129 | 443 | 2 |
732175 | 732175 | 2020-11-14 | Washington | Wisconsin | 55131 | 7601 | 62 |
732176 | 732176 | 2020-11-14 | Waukesha | Wisconsin | 55133 | 20164 | 167 |
732177 | 732177 | 2020-11-14 | Waupaca | Wisconsin | 55135 | 3561 | 95 |
732178 | 732178 | 2020-11-14 | Waushara | Wisconsin | 55137 | 1610 | 6 |
732179 | 732179 | 2020-11-14 | Winnebago | Wisconsin | 55139 | 12434 | 94 |
732180 | 732180 | 2020-11-14 | Wood | Wisconsin | 55141 | 3262 | 19 |
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);