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 73
- 55025 624
- 55093 591
- 55133 590
- 55039 589
- 55117 588
- 55079 587
- 55101 587
- 55139 587
- 55141 585
- 55087 584
- 55059 583
- 55131 583
- 55009 582
- 55063 582
- 55127 582
- 55007 581
- 55015 581
- 55021 581
- 55035 581
- 55089 581
- 55109 581
- 55111 581
- 55017 580
- 55031 580
- 55033 580
- 55045 580
- 55055 580
- 55073 580
- 55105 580
- 55027 577
- 55043 575
- 55049 575
- 55057 575
- 55081 575
- 55125 575
- 55019 574
- 55097 574
- 55135 574
- 55051 573
- 55075 573
- 55103 573
- 55085 572
- 55029 570
- 55053 570
- 55077 570
- 55003 569
- 55011 569
- 55083 569
- 55023 568
- 55078 568
- 55121 568
- 55001 567
- 55005 566
- 55107 566
- 55115 566
- 55071 565
- 55037 564
- 55137 564
- 55061 563
- 55065 562
- 55113 561
- 55095 559
- 55099 558
- 55047 556
- 55129 556
- 55123 546
- 55069 538
- 55041 533
- 55013 525
- 55091 525
- 55119 519
- 55067 518
- - 135
county 73
- Dane 624
- Pierce 591
- Waukesha 590
- Fond du Lac 589
- Sheboygan 588
- Milwaukee 587
- Racine 587
- Winnebago 587
- Wood 585
- Outagamie 584
- Kenosha 583
- Washington 583
- Brown 582
- La Crosse 582
- Walworth 582
- Bayfield 581
- Calumet 581
- Columbia 581
- Eau Claire 581
- Ozaukee 581
- Sauk 581
- St. Croix 581
- Chippewa 580
- Douglas 580
- Dunn 580
- Green 580
- Jefferson 580
- Marathon 580
- Rock 580
- Dodge 577
- Grant 575
- Iowa 575
- Juneau 575
- Monroe 575
- Vilas 575
- Clark 574
- Portage 574
- Waupaca 574
- Iron 573
- Marinette 573
- Richland 573
- Oneida 572
- Door 570
- Jackson 570
- Marquette 570
- Ashland 569
- Buffalo 569
- Oconto 569
- Crawford 568
- Menominee 568
- Trempealeau 568
- Adams 567
- Barron 566
- Rusk 566
- Shawano 566
- Manitowoc 565
- Florence 564
- Waushara 564
- Kewaunee 563
- Lafayette 562
- Sawyer 561
- Polk 559
- Price 558
- Green Lake 556
- Washburn 556
- Vernon 546
- Lincoln 538
- Forest 533
- Burnett 525
- Pepin 525
- Taylor 519
- Langlade 518
- Unknown 135
state 1
- Wisconsin · 41,249 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1839318 | 1839318 | 2021-10-21 | Sawyer | Wisconsin | 55113 | 2498 | 31 |
1839319 | 1839319 | 2021-10-21 | Shawano | Wisconsin | 55115 | 6978 | 90 |
1839320 | 1839320 | 2021-10-21 | Sheboygan | Wisconsin | 55117 | 17996 | 186 |
1839321 | 1839321 | 2021-10-21 | St. Croix | Wisconsin | 55109 | 12738 | 85 |
1839322 | 1839322 | 2021-10-21 | Taylor | Wisconsin | 55119 | 2971 | 44 |
1839323 | 1839323 | 2021-10-21 | Trempealeau | Wisconsin | 55121 | 4897 | 52 |
1839324 | 1839324 | 2021-10-21 | Vernon | Wisconsin | 55123 | 2858 | 56 |
1839325 | 1839325 | 2021-10-21 | Vilas | Wisconsin | 55125 | 3043 | 53 |
1839326 | 1839326 | 2021-10-21 | Walworth | Wisconsin | 55127 | 15627 | 188 |
1839327 | 1839327 | 2021-10-21 | Washburn | Wisconsin | 55129 | 2179 | 27 |
1839328 | 1839328 | 2021-10-21 | Washington | Wisconsin | 55131 | 22252 | 220 |
1839329 | 1839329 | 2021-10-21 | Waukesha | Wisconsin | 55133 | 61985 | 716 |
1839330 | 1839330 | 2021-10-21 | Waupaca | Wisconsin | 55135 | 8136 | 183 |
1839331 | 1839331 | 2021-10-21 | Waushara | Wisconsin | 55137 | 3639 | 50 |
1839332 | 1839332 | 2021-10-21 | Winnebago | Wisconsin | 55139 | 27126 | 259 |
1839333 | 1839333 | 2021-10-21 | Wood | Wisconsin | 55141 | 10459 | 135 |
1836013 | 1836013 | 2021-10-20 | Adams | Wisconsin | 55001 | 2717 | 33 |
1836014 | 1836014 | 2021-10-20 | Ashland | Wisconsin | 55003 | 1801 | 16 |
1836015 | 1836015 | 2021-10-20 | Barron | Wisconsin | 55005 | 8255 | 92 |
1836016 | 1836016 | 2021-10-20 | Bayfield | Wisconsin | 55007 | 1607 | 25 |
1836017 | 1836017 | 2021-10-20 | Brown | Wisconsin | 55009 | 45172 | 316 |
1836018 | 1836018 | 2021-10-20 | Buffalo | Wisconsin | 55011 | 1938 | 8 |
1836019 | 1836019 | 2021-10-20 | Burnett | Wisconsin | 55013 | 2195 | 30 |
1836020 | 1836020 | 2021-10-20 | Calumet | Wisconsin | 55015 | 8178 | 59 |
1836021 | 1836021 | 2021-10-20 | Chippewa | Wisconsin | 55017 | 10749 | 115 |
1836022 | 1836022 | 2021-10-20 | Clark | Wisconsin | 55019 | 4723 | 76 |
1836023 | 1836023 | 2021-10-20 | Columbia | Wisconsin | 55021 | 7832 | 78 |
1836024 | 1836024 | 2021-10-20 | Crawford | Wisconsin | 55023 | 2269 | 22 |
1836025 | 1836025 | 2021-10-20 | Dane | Wisconsin | 55025 | 57148 | 369 |
1836026 | 1836026 | 2021-10-20 | Dodge | Wisconsin | 55027 | 15873 | 226 |
1836027 | 1836027 | 2021-10-20 | Door | Wisconsin | 55029 | 3714 | 39 |
1836028 | 1836028 | 2021-10-20 | Douglas | Wisconsin | 55031 | 5910 | 66 |
1836029 | 1836029 | 2021-10-20 | Dunn | Wisconsin | 55033 | 6930 | 46 |
1836030 | 1836030 | 2021-10-20 | Eau Claire | Wisconsin | 55035 | 15990 | 138 |
1836031 | 1836031 | 2021-10-20 | Florence | Wisconsin | 55037 | 629 | 14 |
1836032 | 1836032 | 2021-10-20 | Fond du Lac | Wisconsin | 55039 | 17838 | 159 |
1836033 | 1836033 | 2021-10-20 | Forest | Wisconsin | 55041 | 1503 | 31 |
1836034 | 1836034 | 2021-10-20 | Grant | Wisconsin | 55043 | 7475 | 114 |
1836035 | 1836035 | 2021-10-20 | Green | Wisconsin | 55045 | 4522 | 30 |
1836036 | 1836036 | 2021-10-20 | Green Lake | Wisconsin | 55047 | 3000 | 30 |
1836037 | 1836037 | 2021-10-20 | Iowa | Wisconsin | 55049 | 2713 | 16 |
1836038 | 1836038 | 2021-10-20 | Iron | Wisconsin | 55051 | 871 | 42 |
1836039 | 1836039 | 2021-10-20 | Jackson | Wisconsin | 55053 | 3332 | 31 |
1836040 | 1836040 | 2021-10-20 | Jefferson | Wisconsin | 55055 | 11692 | 148 |
1836041 | 1836041 | 2021-10-20 | Juneau | Wisconsin | 55057 | 4149 | 34 |
1836042 | 1836042 | 2021-10-20 | Kenosha | Wisconsin | 55059 | 23707 | 377 |
1836043 | 1836043 | 2021-10-20 | Kewaunee | Wisconsin | 55061 | 3545 | 41 |
1836044 | 1836044 | 2021-10-20 | La Crosse | Wisconsin | 55063 | 17110 | 109 |
1836045 | 1836045 | 2021-10-20 | Lafayette | Wisconsin | 55065 | 2082 | 12 |
1836046 | 1836046 | 2021-10-20 | Langlade | Wisconsin | 55067 | 3101 | 54 |
1836047 | 1836047 | 2021-10-20 | Lincoln | Wisconsin | 55069 | 4296 | 108 |
1836048 | 1836048 | 2021-10-20 | Manitowoc | Wisconsin | 55071 | 11491 | 106 |
1836049 | 1836049 | 2021-10-20 | Marathon | Wisconsin | 55073 | 20764 | 264 |
1836050 | 1836050 | 2021-10-20 | Marinette | Wisconsin | 55075 | 6621 | 78 |
1836051 | 1836051 | 2021-10-20 | Marquette | Wisconsin | 55077 | 2248 | 32 |
1836052 | 1836052 | 2021-10-20 | Menominee | Wisconsin | 55078 | 943 | 11 |
1836053 | 1836053 | 2021-10-20 | Milwaukee | Wisconsin | 55079 | 149598 | 1592 |
1836054 | 1836054 | 2021-10-20 | Monroe | Wisconsin | 55081 | 6338 | 54 |
1836055 | 1836055 | 2021-10-20 | Oconto | Wisconsin | 55083 | 7081 | 76 |
1836056 | 1836056 | 2021-10-20 | Oneida | Wisconsin | 55085 | 4882 | 88 |
1836057 | 1836057 | 2021-10-20 | Outagamie | Wisconsin | 55087 | 30089 | 267 |
1836058 | 1836058 | 2021-10-20 | Ozaukee | Wisconsin | 55089 | 12237 | 114 |
1836059 | 1836059 | 2021-10-20 | Pepin | Wisconsin | 55091 | 1153 | 10 |
1836060 | 1836060 | 2021-10-20 | Pierce | Wisconsin | 55093 | 6214 | 45 |
1836061 | 1836061 | 2021-10-20 | Polk | Wisconsin | 55095 | 6668 | 81 |
1836062 | 1836062 | 2021-10-20 | Portage | Wisconsin | 55097 | 9386 | 96 |
1836063 | 1836063 | 2021-10-20 | Price | Wisconsin | 55099 | 1782 | 11 |
1836064 | 1836064 | 2021-10-20 | Racine | Wisconsin | 55101 | 31324 | 445 |
1836065 | 1836065 | 2021-10-20 | Richland | Wisconsin | 55103 | 2144 | 23 |
1836066 | 1836066 | 2021-10-20 | Rock | Wisconsin | 55105 | 22059 | 243 |
1836067 | 1836067 | 2021-10-20 | Rusk | Wisconsin | 55107 | 2176 | 32 |
1836068 | 1836068 | 2021-10-20 | Sauk | Wisconsin | 55111 | 8221 | 66 |
1836069 | 1836069 | 2021-10-20 | Sawyer | Wisconsin | 55113 | 2484 | 31 |
1836070 | 1836070 | 2021-10-20 | Shawano | Wisconsin | 55115 | 6946 | 90 |
1836071 | 1836071 | 2021-10-20 | Sheboygan | Wisconsin | 55117 | 17934 | 186 |
1836072 | 1836072 | 2021-10-20 | St. Croix | Wisconsin | 55109 | 12674 | 85 |
1836073 | 1836073 | 2021-10-20 | Taylor | Wisconsin | 55119 | 2943 | 44 |
1836074 | 1836074 | 2021-10-20 | Trempealeau | Wisconsin | 55121 | 4884 | 52 |
1836075 | 1836075 | 2021-10-20 | Vernon | Wisconsin | 55123 | 2842 | 55 |
1836076 | 1836076 | 2021-10-20 | Vilas | Wisconsin | 55125 | 3032 | 53 |
1836077 | 1836077 | 2021-10-20 | Walworth | Wisconsin | 55127 | 15505 | 187 |
1836078 | 1836078 | 2021-10-20 | Washburn | Wisconsin | 55129 | 2164 | 27 |
1836079 | 1836079 | 2021-10-20 | Washington | Wisconsin | 55131 | 22198 | 220 |
1836080 | 1836080 | 2021-10-20 | Waukesha | Wisconsin | 55133 | 61868 | 715 |
1836081 | 1836081 | 2021-10-20 | Waupaca | Wisconsin | 55135 | 8107 | 181 |
1836082 | 1836082 | 2021-10-20 | Waushara | Wisconsin | 55137 | 3623 | 50 |
1836083 | 1836083 | 2021-10-20 | Winnebago | Wisconsin | 55139 | 27029 | 258 |
1836084 | 1836084 | 2021-10-20 | Wood | Wisconsin | 55141 | 10427 | 135 |
1832764 | 1832764 | 2021-10-19 | Adams | Wisconsin | 55001 | 2709 | 33 |
1832765 | 1832765 | 2021-10-19 | Ashland | Wisconsin | 55003 | 1793 | 16 |
1832766 | 1832766 | 2021-10-19 | Barron | Wisconsin | 55005 | 8221 | 91 |
1832767 | 1832767 | 2021-10-19 | Bayfield | Wisconsin | 55007 | 1601 | 25 |
1832768 | 1832768 | 2021-10-19 | Brown | Wisconsin | 55009 | 44827 | 315 |
1832769 | 1832769 | 2021-10-19 | Buffalo | Wisconsin | 55011 | 1932 | 8 |
1832770 | 1832770 | 2021-10-19 | Burnett | Wisconsin | 55013 | 2187 | 30 |
1832771 | 1832771 | 2021-10-19 | Calumet | Wisconsin | 55015 | 8151 | 59 |
1832772 | 1832772 | 2021-10-19 | Chippewa | Wisconsin | 55017 | 10736 | 115 |
1832773 | 1832773 | 2021-10-19 | Clark | Wisconsin | 55019 | 4708 | 76 |
1832774 | 1832774 | 2021-10-19 | Columbia | Wisconsin | 55021 | 7814 | 78 |
1832775 | 1832775 | 2021-10-19 | Crawford | Wisconsin | 55023 | 2259 | 22 |
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);