ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55,993 rows where state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 55025 178
- 55093 145
- 55039 143
- 55133 143
- 55079 141
- 55101 141
- 55117 141
- 55139 140
- 55087 138
- 55141 138
- 55059 137
- 55009 136
- 55063 136
- 55131 136
- 55007 135
- 55015 135
- 55021 135
- 55035 135
- 55089 135
- 55111 135
- 55127 135
- 55017 134
- 55031 134
- 55033 134
- 55045 134
- 55055 134
- 55073 134
- 55105 134
- 55109 134
- 55027 131
- …
county >30
- Dane 178
- Pierce 145
- Fond du Lac 143
- Waukesha 143
- Milwaukee 141
- Racine 141
- Sheboygan 141
- Winnebago 140
- Outagamie 138
- Wood 138
- Kenosha 137
- Brown 136
- La Crosse 136
- Washington 136
- Bayfield 135
- Calumet 135
- Columbia 135
- Eau Claire 135
- Ozaukee 135
- Sauk 135
- Walworth 135
- Chippewa 134
- Douglas 134
- Dunn 134
- Green 134
- Jefferson 134
- Marathon 134
- Rock 134
- St. Croix 134
- Dodge 131
- …
state 1
- Wisconsin · 9,038 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389061 | 389061 | 2020-07-31 | Adams | Wisconsin | 55001 | 69 | 2 |
389062 | 389062 | 2020-07-31 | Ashland | Wisconsin | 55003 | 15 | 0 |
389063 | 389063 | 2020-07-31 | Barron | Wisconsin | 55005 | 228 | 3 |
389064 | 389064 | 2020-07-31 | Bayfield | Wisconsin | 55007 | 18 | 1 |
389065 | 389065 | 2020-07-31 | Brown | Wisconsin | 55009 | 3919 | 51 |
389066 | 389066 | 2020-07-31 | Buffalo | Wisconsin | 55011 | 41 | 2 |
389067 | 389067 | 2020-07-31 | Burnett | Wisconsin | 55013 | 13 | 1 |
389068 | 389068 | 2020-07-31 | Calumet | Wisconsin | 55015 | 236 | 2 |
389069 | 389069 | 2020-07-31 | Chippewa | Wisconsin | 55017 | 208 | 0 |
389070 | 389070 | 2020-07-31 | Clark | Wisconsin | 55019 | 168 | 7 |
389071 | 389071 | 2020-07-31 | Columbia | Wisconsin | 55021 | 213 | 1 |
389072 | 389072 | 2020-07-31 | Crawford | Wisconsin | 55023 | 56 | 0 |
389073 | 389073 | 2020-07-31 | Dane | Wisconsin | 55025 | 4086 | 37 |
389074 | 389074 | 2020-07-31 | Dodge | Wisconsin | 55027 | 655 | 5 |
389075 | 389075 | 2020-07-31 | Door | Wisconsin | 55029 | 84 | 3 |
389076 | 389076 | 2020-07-31 | Douglas | Wisconsin | 55031 | 113 | 0 |
389077 | 389077 | 2020-07-31 | Dunn | Wisconsin | 55033 | 102 | 0 |
389078 | 389078 | 2020-07-31 | Eau Claire | Wisconsin | 55035 | 474 | 3 |
389079 | 389079 | 2020-07-31 | Florence | Wisconsin | 55037 | 7 | 0 |
389080 | 389080 | 2020-07-31 | Fond du Lac | Wisconsin | 55039 | 529 | 6 |
389081 | 389081 | 2020-07-31 | Forest | Wisconsin | 55041 | 58 | 4 |
389082 | 389082 | 2020-07-31 | Grant | Wisconsin | 55043 | 318 | 14 |
389083 | 389083 | 2020-07-31 | Green | Wisconsin | 55045 | 123 | 1 |
389084 | 389084 | 2020-07-31 | Green Lake | Wisconsin | 55047 | 52 | 0 |
389085 | 389085 | 2020-07-31 | Iowa | Wisconsin | 55049 | 62 | 0 |
389086 | 389086 | 2020-07-31 | Iron | Wisconsin | 55051 | 71 | 1 |
389087 | 389087 | 2020-07-31 | Jackson | Wisconsin | 55053 | 46 | 1 |
389088 | 389088 | 2020-07-31 | Jefferson | Wisconsin | 55055 | 544 | 5 |
389089 | 389089 | 2020-07-31 | Juneau | Wisconsin | 55057 | 119 | 1 |
389090 | 389090 | 2020-07-31 | Kenosha | Wisconsin | 55059 | 2427 | 52 |
389091 | 389091 | 2020-07-31 | Kewaunee | Wisconsin | 55061 | 109 | 2 |
389092 | 389092 | 2020-07-31 | La Crosse | Wisconsin | 55063 | 788 | 1 |
389093 | 389093 | 2020-07-31 | Lafayette | Wisconsin | 55065 | 103 | 0 |
389094 | 389094 | 2020-07-31 | Langlade | Wisconsin | 55067 | 43 | 1 |
389095 | 389095 | 2020-07-31 | Lincoln | Wisconsin | 55069 | 60 | 0 |
389096 | 389096 | 2020-07-31 | Manitowoc | Wisconsin | 55071 | 287 | 1 |
389097 | 389097 | 2020-07-31 | Marathon | Wisconsin | 55073 | 547 | 5 |
389098 | 389098 | 2020-07-31 | Marinette | Wisconsin | 55075 | 280 | 3 |
389099 | 389099 | 2020-07-31 | Marquette | Wisconsin | 55077 | 69 | 1 |
389100 | 389100 | 2020-07-31 | Menominee | Wisconsin | 55078 | 18 | 0 |
389101 | 389101 | 2020-07-31 | Milwaukee | Wisconsin | 55079 | 19248 | 438 |
389102 | 389102 | 2020-07-31 | Monroe | Wisconsin | 55081 | 205 | 1 |
389103 | 389103 | 2020-07-31 | Oconto | Wisconsin | 55083 | 164 | 0 |
389104 | 389104 | 2020-07-31 | Oneida | Wisconsin | 55085 | 81 | 0 |
389105 | 389105 | 2020-07-31 | Outagamie | Wisconsin | 55087 | 1061 | 12 |
389106 | 389106 | 2020-07-31 | Ozaukee | Wisconsin | 55089 | 564 | 17 |
389107 | 389107 | 2020-07-31 | Pepin | Wisconsin | 55091 | 40 | 0 |
389108 | 389108 | 2020-07-31 | Pierce | Wisconsin | 55093 | 164 | 0 |
389109 | 389109 | 2020-07-31 | Polk | Wisconsin | 55095 | 111 | 2 |
389110 | 389110 | 2020-07-31 | Portage | Wisconsin | 55097 | 337 | 0 |
389111 | 389111 | 2020-07-31 | Price | Wisconsin | 55099 | 19 | 0 |
389112 | 389112 | 2020-07-31 | Racine | Wisconsin | 55101 | 3483 | 77 |
389113 | 389113 | 2020-07-31 | Richland | Wisconsin | 55103 | 25 | 4 |
389114 | 389114 | 2020-07-31 | Rock | Wisconsin | 55105 | 1477 | 26 |
389115 | 389115 | 2020-07-31 | Rusk | Wisconsin | 55107 | 14 | 1 |
389116 | 389116 | 2020-07-31 | Sauk | Wisconsin | 55111 | 347 | 3 |
389117 | 389117 | 2020-07-31 | Sawyer | Wisconsin | 55113 | 34 | 0 |
389118 | 389118 | 2020-07-31 | Shawano | Wisconsin | 55115 | 147 | 0 |
389119 | 389119 | 2020-07-31 | Sheboygan | Wisconsin | 55117 | 578 | 5 |
389120 | 389120 | 2020-07-31 | St. Croix | Wisconsin | 55109 | 439 | 2 |
389121 | 389121 | 2020-07-31 | Taylor | Wisconsin | 55119 | 47 | 0 |
389122 | 389122 | 2020-07-31 | Trempealeau | Wisconsin | 55121 | 301 | 2 |
389123 | 389123 | 2020-07-31 | Unknown | Wisconsin | 3471 | 7 | |
389124 | 389124 | 2020-07-31 | Vernon | Wisconsin | 55123 | 55 | 0 |
389125 | 389125 | 2020-07-31 | Vilas | Wisconsin | 55125 | 29 | 0 |
389126 | 389126 | 2020-07-31 | Walworth | Wisconsin | 55127 | 1179 | 21 |
389127 | 389127 | 2020-07-31 | Washburn | Wisconsin | 55129 | 21 | 0 |
389128 | 389128 | 2020-07-31 | Washington | Wisconsin | 55131 | 854 | 23 |
389129 | 389129 | 2020-07-31 | Waukesha | Wisconsin | 55133 | 3488 | 53 |
389130 | 389130 | 2020-07-31 | Waupaca | Wisconsin | 55135 | 350 | 14 |
389131 | 389131 | 2020-07-31 | Waushara | Wisconsin | 55137 | 99 | 0 |
389132 | 389132 | 2020-07-31 | Winnebago | Wisconsin | 55139 | 1014 | 17 |
389133 | 389133 | 2020-07-31 | Wood | Wisconsin | 55141 | 216 | 1 |
385844 | 385844 | 2020-07-30 | Adams | Wisconsin | 55001 | 66 | 2 |
385845 | 385845 | 2020-07-30 | Ashland | Wisconsin | 55003 | 15 | 0 |
385846 | 385846 | 2020-07-30 | Barron | Wisconsin | 55005 | 207 | 3 |
385847 | 385847 | 2020-07-30 | Bayfield | Wisconsin | 55007 | 18 | 1 |
385848 | 385848 | 2020-07-30 | Brown | Wisconsin | 55009 | 3896 | 50 |
385849 | 385849 | 2020-07-30 | Buffalo | Wisconsin | 55011 | 41 | 2 |
385850 | 385850 | 2020-07-30 | Burnett | Wisconsin | 55013 | 13 | 1 |
385851 | 385851 | 2020-07-30 | Calumet | Wisconsin | 55015 | 230 | 2 |
385852 | 385852 | 2020-07-30 | Chippewa | Wisconsin | 55017 | 203 | 0 |
385853 | 385853 | 2020-07-30 | Clark | Wisconsin | 55019 | 167 | 7 |
385854 | 385854 | 2020-07-30 | Columbia | Wisconsin | 55021 | 210 | 1 |
385855 | 385855 | 2020-07-30 | Crawford | Wisconsin | 55023 | 55 | 0 |
385856 | 385856 | 2020-07-30 | Dane | Wisconsin | 55025 | 4007 | 35 |
385857 | 385857 | 2020-07-30 | Dodge | Wisconsin | 55027 | 642 | 5 |
385858 | 385858 | 2020-07-30 | Door | Wisconsin | 55029 | 84 | 3 |
385859 | 385859 | 2020-07-30 | Douglas | Wisconsin | 55031 | 110 | 0 |
385860 | 385860 | 2020-07-30 | Dunn | Wisconsin | 55033 | 101 | 0 |
385861 | 385861 | 2020-07-30 | Eau Claire | Wisconsin | 55035 | 462 | 3 |
385862 | 385862 | 2020-07-30 | Florence | Wisconsin | 55037 | 7 | 0 |
385863 | 385863 | 2020-07-30 | Fond du Lac | Wisconsin | 55039 | 522 | 6 |
385864 | 385864 | 2020-07-30 | Forest | Wisconsin | 55041 | 57 | 4 |
385865 | 385865 | 2020-07-30 | Grant | Wisconsin | 55043 | 313 | 14 |
385866 | 385866 | 2020-07-30 | Green | Wisconsin | 55045 | 121 | 1 |
385867 | 385867 | 2020-07-30 | Green Lake | Wisconsin | 55047 | 50 | 0 |
385868 | 385868 | 2020-07-30 | Iowa | Wisconsin | 55049 | 62 | 0 |
385869 | 385869 | 2020-07-30 | Iron | Wisconsin | 55051 | 69 | 1 |
385870 | 385870 | 2020-07-30 | Jackson | Wisconsin | 55053 | 45 | 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);