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 659
- 55093 626
- 55039 624
- 55133 624
- 55079 622
- 55101 622
- 55117 622
- 55139 621
- 55087 619
- 55141 619
- 55059 618
- 55009 617
- 55063 617
- 55131 617
- 55007 616
- 55015 616
- 55021 616
- 55035 616
- 55089 616
- 55111 616
- 55127 616
- 55017 615
- 55031 615
- 55033 615
- 55045 615
- 55055 615
- 55073 615
- 55105 615
- 55109 615
- 55027 612
- …
county >30
- Dane 659
- Pierce 626
- Fond du Lac 624
- Waukesha 624
- Milwaukee 622
- Racine 622
- Sheboygan 622
- Winnebago 621
- Outagamie 619
- Wood 619
- Kenosha 618
- Brown 617
- La Crosse 617
- Washington 617
- Bayfield 616
- Calumet 616
- Columbia 616
- Eau Claire 616
- Ozaukee 616
- Sauk 616
- Walworth 616
- Chippewa 615
- Douglas 615
- Dunn 615
- Green 615
- Jefferson 615
- Marathon 615
- Rock 615
- St. Croix 615
- Dodge 612
- …
state 1
- Wisconsin · 43,753 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1949752 | 1949752 | 2021-11-24 | Adams | Wisconsin | 55001 | 3024 | 35 |
1949753 | 1949753 | 2021-11-24 | Ashland | Wisconsin | 55003 | 2067 | 21 |
1949754 | 1949754 | 2021-11-24 | Barron | Wisconsin | 55005 | 9411 | 101 |
1949755 | 1949755 | 2021-11-24 | Bayfield | Wisconsin | 55007 | 1947 | 26 |
1949756 | 1949756 | 2021-11-24 | Brown | Wisconsin | 55009 | 50864 | 335 |
1949757 | 1949757 | 2021-11-24 | Buffalo | Wisconsin | 55011 | 2249 | 8 |
1949758 | 1949758 | 2021-11-24 | Burnett | Wisconsin | 55013 | 2616 | 33 |
1949759 | 1949759 | 2021-11-24 | Calumet | Wisconsin | 55015 | 9387 | 69 |
1949760 | 1949760 | 2021-11-24 | Chippewa | Wisconsin | 55017 | 12121 | 127 |
1949761 | 1949761 | 2021-11-24 | Clark | Wisconsin | 55019 | 5385 | 86 |
1949762 | 1949762 | 2021-11-24 | Columbia | Wisconsin | 55021 | 8719 | 93 |
1949763 | 1949763 | 2021-11-24 | Crawford | Wisconsin | 55023 | 2611 | 23 |
1949764 | 1949764 | 2021-11-24 | Dane | Wisconsin | 55025 | 61764 | 386 |
1949765 | 1949765 | 2021-11-24 | Dodge | Wisconsin | 55027 | 17689 | 239 |
1949766 | 1949766 | 2021-11-24 | Door | Wisconsin | 55029 | 4117 | 41 |
1949767 | 1949767 | 2021-11-24 | Douglas | Wisconsin | 55031 | 7161 | 66 |
1949768 | 1949768 | 2021-11-24 | Dunn | Wisconsin | 55033 | 8175 | 49 |
1949769 | 1949769 | 2021-11-24 | Eau Claire | Wisconsin | 55035 | 18158 | 146 |
1949770 | 1949770 | 2021-11-24 | Florence | Wisconsin | 55037 | 700 | 14 |
1949771 | 1949771 | 2021-11-24 | Fond du Lac | Wisconsin | 55039 | 19791 | 173 |
1949772 | 1949772 | 2021-11-24 | Forest | Wisconsin | 55041 | 1662 | 33 |
1949773 | 1949773 | 2021-11-24 | Grant | Wisconsin | 55043 | 8306 | 119 |
1949774 | 1949774 | 2021-11-24 | Green | Wisconsin | 55045 | 5286 | 37 |
1949775 | 1949775 | 2021-11-24 | Green Lake | Wisconsin | 55047 | 3336 | 36 |
1949776 | 1949776 | 2021-11-24 | Iowa | Wisconsin | 55049 | 3012 | 17 |
1949777 | 1949777 | 2021-11-24 | Iron | Wisconsin | 55051 | 951 | 42 |
1949778 | 1949778 | 2021-11-24 | Jackson | Wisconsin | 55053 | 3738 | 34 |
1949779 | 1949779 | 2021-11-24 | Jefferson | Wisconsin | 55055 | 13170 | 165 |
1949780 | 1949780 | 2021-11-24 | Juneau | Wisconsin | 55057 | 4786 | 39 |
1949781 | 1949781 | 2021-11-24 | Kenosha | Wisconsin | 55059 | 26056 | 403 |
1949782 | 1949782 | 2021-11-24 | Kewaunee | Wisconsin | 55061 | 3969 | 48 |
1949783 | 1949783 | 2021-11-24 | La Crosse | Wisconsin | 55063 | 19198 | 123 |
1949784 | 1949784 | 2021-11-24 | Lafayette | Wisconsin | 55065 | 2381 | 12 |
1949785 | 1949785 | 2021-11-24 | Langlade | Wisconsin | 55067 | 3499 | 59 |
1949786 | 1949786 | 2021-11-24 | Lincoln | Wisconsin | 55069 | 4828 | 116 |
1949787 | 1949787 | 2021-11-24 | Manitowoc | Wisconsin | 55071 | 13421 | 114 |
1949788 | 1949788 | 2021-11-24 | Marathon | Wisconsin | 55073 | 24249 | 316 |
1949789 | 1949789 | 2021-11-24 | Marinette | Wisconsin | 55075 | 7941 | 82 |
1949790 | 1949790 | 2021-11-24 | Marquette | Wisconsin | 55077 | 2586 | 37 |
1949791 | 1949791 | 2021-11-24 | Menominee | Wisconsin | 55078 | 997 | 11 |
1949792 | 1949792 | 2021-11-24 | Milwaukee | Wisconsin | 55079 | 159508 | 1688 |
1949793 | 1949793 | 2021-11-24 | Monroe | Wisconsin | 55081 | 7341 | 58 |
1949794 | 1949794 | 2021-11-24 | Oconto | Wisconsin | 55083 | 7808 | 78 |
1949795 | 1949795 | 2021-11-24 | Oneida | Wisconsin | 55085 | 5707 | 95 |
1949796 | 1949796 | 2021-11-24 | Outagamie | Wisconsin | 55087 | 34042 | 284 |
1949797 | 1949797 | 2021-11-24 | Ozaukee | Wisconsin | 55089 | 13416 | 123 |
1949798 | 1949798 | 2021-11-24 | Pepin | Wisconsin | 55091 | 1286 | 10 |
1949799 | 1949799 | 2021-11-24 | Pierce | Wisconsin | 55093 | 7318 | 52 |
1949800 | 1949800 | 2021-11-24 | Polk | Wisconsin | 55095 | 8077 | 91 |
1949801 | 1949801 | 2021-11-24 | Portage | Wisconsin | 55097 | 10682 | 107 |
1949802 | 1949802 | 2021-11-24 | Price | Wisconsin | 55099 | 2149 | 16 |
1949803 | 1949803 | 2021-11-24 | Racine | Wisconsin | 55101 | 34235 | 474 |
1949804 | 1949804 | 2021-11-24 | Richland | Wisconsin | 55103 | 2441 | 29 |
1949805 | 1949805 | 2021-11-24 | Rock | Wisconsin | 55105 | 24299 | 256 |
1949806 | 1949806 | 2021-11-24 | Rusk | Wisconsin | 55107 | 2376 | 36 |
1949807 | 1949807 | 2021-11-24 | Sauk | Wisconsin | 55111 | 9422 | 75 |
1949808 | 1949808 | 2021-11-24 | Sawyer | Wisconsin | 55113 | 3083 | 37 |
1949809 | 1949809 | 2021-11-24 | Shawano | Wisconsin | 55115 | 7715 | 93 |
1949810 | 1949810 | 2021-11-24 | Sheboygan | Wisconsin | 55117 | 20434 | 196 |
1949811 | 1949811 | 2021-11-24 | St. Croix | Wisconsin | 55109 | 15553 | 90 |
1949812 | 1949812 | 2021-11-24 | Taylor | Wisconsin | 55119 | 3399 | 48 |
1949813 | 1949813 | 2021-11-24 | Trempealeau | Wisconsin | 55121 | 5467 | 52 |
1949814 | 1949814 | 2021-11-24 | Vernon | Wisconsin | 55123 | 3401 | 67 |
1949815 | 1949815 | 2021-11-24 | Vilas | Wisconsin | 55125 | 3382 | 60 |
1949816 | 1949816 | 2021-11-24 | Walworth | Wisconsin | 55127 | 17318 | 199 |
1949817 | 1949817 | 2021-11-24 | Washburn | Wisconsin | 55129 | 2688 | 29 |
1949818 | 1949818 | 2021-11-24 | Washington | Wisconsin | 55131 | 24996 | 232 |
1949819 | 1949819 | 2021-11-24 | Waukesha | Wisconsin | 55133 | 68707 | 759 |
1949820 | 1949820 | 2021-11-24 | Waupaca | Wisconsin | 55135 | 9164 | 191 |
1949821 | 1949821 | 2021-11-24 | Waushara | Wisconsin | 55137 | 4024 | 56 |
1949822 | 1949822 | 2021-11-24 | Winnebago | Wisconsin | 55139 | 30421 | 284 |
1949823 | 1949823 | 2021-11-24 | Wood | Wisconsin | 55141 | 12269 | 143 |
1946501 | 1946501 | 2021-11-23 | Adams | Wisconsin | 55001 | 3018 | 35 |
1946502 | 1946502 | 2021-11-23 | Ashland | Wisconsin | 55003 | 2056 | 21 |
1946503 | 1946503 | 2021-11-23 | Barron | Wisconsin | 55005 | 9353 | 100 |
1946504 | 1946504 | 2021-11-23 | Bayfield | Wisconsin | 55007 | 1922 | 26 |
1946505 | 1946505 | 2021-11-23 | Brown | Wisconsin | 55009 | 50476 | 333 |
1946506 | 1946506 | 2021-11-23 | Buffalo | Wisconsin | 55011 | 2236 | 8 |
1946507 | 1946507 | 2021-11-23 | Burnett | Wisconsin | 55013 | 2605 | 33 |
1946508 | 1946508 | 2021-11-23 | Calumet | Wisconsin | 55015 | 9334 | 68 |
1946509 | 1946509 | 2021-11-23 | Chippewa | Wisconsin | 55017 | 12049 | 126 |
1946510 | 1946510 | 2021-11-23 | Clark | Wisconsin | 55019 | 5339 | 86 |
1946511 | 1946511 | 2021-11-23 | Columbia | Wisconsin | 55021 | 8681 | 85 |
1946512 | 1946512 | 2021-11-23 | Crawford | Wisconsin | 55023 | 2597 | 23 |
1946513 | 1946513 | 2021-11-23 | Dane | Wisconsin | 55025 | 61576 | 386 |
1946514 | 1946514 | 2021-11-23 | Dodge | Wisconsin | 55027 | 17594 | 238 |
1946515 | 1946515 | 2021-11-23 | Door | Wisconsin | 55029 | 4103 | 41 |
1946516 | 1946516 | 2021-11-23 | Douglas | Wisconsin | 55031 | 7113 | 66 |
1946517 | 1946517 | 2021-11-23 | Dunn | Wisconsin | 55033 | 8083 | 48 |
1946518 | 1946518 | 2021-11-23 | Eau Claire | Wisconsin | 55035 | 18053 | 146 |
1946519 | 1946519 | 2021-11-23 | Florence | Wisconsin | 55037 | 698 | 14 |
1946520 | 1946520 | 2021-11-23 | Fond du Lac | Wisconsin | 55039 | 19760 | 171 |
1946521 | 1946521 | 2021-11-23 | Forest | Wisconsin | 55041 | 1646 | 33 |
1946522 | 1946522 | 2021-11-23 | Grant | Wisconsin | 55043 | 8259 | 119 |
1946523 | 1946523 | 2021-11-23 | Green | Wisconsin | 55045 | 5253 | 35 |
1946524 | 1946524 | 2021-11-23 | Green Lake | Wisconsin | 55047 | 3323 | 36 |
1946525 | 1946525 | 2021-11-23 | Iowa | Wisconsin | 55049 | 3001 | 17 |
1946526 | 1946526 | 2021-11-23 | Iron | Wisconsin | 55051 | 942 | 42 |
1946527 | 1946527 | 2021-11-23 | Jackson | Wisconsin | 55053 | 3715 | 34 |
1946528 | 1946528 | 2021-11-23 | Jefferson | Wisconsin | 55055 | 13083 | 164 |
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);