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 707
- 55093 675
- 55133 673
- 55039 672
- 55079 671
- 55101 671
- 55117 671
- 55139 670
- 55087 668
- 55141 668
- 55059 667
- 55063 666
- 55131 666
- 55009 665
- 55089 665
- 55111 665
- 55127 665
- 55007 664
- 55015 664
- 55021 664
- 55035 664
- 55073 664
- 55105 664
- 55109 664
- 55017 663
- 55031 663
- 55033 663
- 55045 663
- 55055 663
- 55027 660
- …
county >30
- Dane 707
- Pierce 675
- Waukesha 673
- Fond du Lac 672
- Milwaukee 671
- Racine 671
- Sheboygan 671
- Winnebago 670
- Outagamie 668
- Wood 668
- Kenosha 667
- La Crosse 666
- Washington 666
- Brown 665
- Ozaukee 665
- Sauk 665
- Walworth 665
- Bayfield 664
- Calumet 664
- Columbia 664
- Eau Claire 664
- Marathon 664
- Rock 664
- St. Croix 664
- Chippewa 663
- Douglas 663
- Dunn 663
- Green 663
- Jefferson 663
- Dodge 660
- …
state 1
- Wisconsin · 47,253 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109061 | 2109061 | 2022-01-12 | Juneau | Wisconsin | 55057 | 6198 | 54 |
2109062 | 2109062 | 2022-01-12 | Kenosha | Wisconsin | 55059 | 34769 | 502 |
2109063 | 2109063 | 2022-01-12 | Kewaunee | Wisconsin | 55061 | 5004 | 51 |
2109064 | 2109064 | 2022-01-12 | La Crosse | Wisconsin | 55063 | 25899 | 142 |
2109065 | 2109065 | 2022-01-12 | Lafayette | Wisconsin | 55065 | 2961 | 18 |
2109066 | 2109066 | 2022-01-12 | Langlade | Wisconsin | 55067 | 4218 | 66 |
2109067 | 2109067 | 2022-01-12 | Lincoln | Wisconsin | 55069 | 5837 | 125 |
2109068 | 2109068 | 2022-01-12 | Manitowoc | Wisconsin | 55071 | 17113 | 151 |
2109069 | 2109069 | 2022-01-12 | Marathon | Wisconsin | 55073 | 31936 | 420 |
2109070 | 2109070 | 2022-01-12 | Marinette | Wisconsin | 55075 | 9723 | 99 |
2109071 | 2109071 | 2022-01-12 | Marquette | Wisconsin | 55077 | 3170 | 41 |
2109072 | 2109072 | 2022-01-12 | Menominee | Wisconsin | 55078 | 1306 | 12 |
2109073 | 2109073 | 2022-01-12 | Milwaukee | Wisconsin | 55079 | 220055 | 1857 |
2109074 | 2109074 | 2022-01-12 | Monroe | Wisconsin | 55081 | 9308 | 72 |
2109075 | 2109075 | 2022-01-12 | Oconto | Wisconsin | 55083 | 9687 | 89 |
2109076 | 2109076 | 2022-01-12 | Oneida | Wisconsin | 55085 | 6959 | 116 |
2109077 | 2109077 | 2022-01-12 | Outagamie | Wisconsin | 55087 | 44563 | 311 |
2109078 | 2109078 | 2022-01-12 | Ozaukee | Wisconsin | 55089 | 17783 | 132 |
2109079 | 2109079 | 2022-01-12 | Pepin | Wisconsin | 55091 | 1605 | 16 |
2109080 | 2109080 | 2022-01-12 | Pierce | Wisconsin | 55093 | 9329 | 65 |
2109081 | 2109081 | 2022-01-12 | Polk | Wisconsin | 55095 | 10069 | 111 |
2109082 | 2109082 | 2022-01-12 | Portage | Wisconsin | 55097 | 14927 | 130 |
2109083 | 2109083 | 2022-01-12 | Price | Wisconsin | 55099 | 2750 | 23 |
2109084 | 2109084 | 2022-01-12 | Racine | Wisconsin | 55101 | 47558 | 549 |
2109085 | 2109085 | 2022-01-12 | Richland | Wisconsin | 55103 | 2966 | 38 |
2109086 | 2109086 | 2022-01-12 | Rock | Wisconsin | 55105 | 33188 | 292 |
2109087 | 2109087 | 2022-01-12 | Rusk | Wisconsin | 55107 | 2924 | 41 |
2109088 | 2109088 | 2022-01-12 | Sauk | Wisconsin | 55111 | 12410 | 86 |
2109089 | 2109089 | 2022-01-12 | Sawyer | Wisconsin | 55113 | 3839 | 51 |
2109090 | 2109090 | 2022-01-12 | Shawano | Wisconsin | 55115 | 9587 | 117 |
2109091 | 2109091 | 2022-01-12 | Sheboygan | Wisconsin | 55117 | 26085 | 209 |
2109092 | 2109092 | 2022-01-12 | St. Croix | Wisconsin | 55109 | 20000 | 121 |
2109093 | 2109093 | 2022-01-12 | Taylor | Wisconsin | 55119 | 4119 | 62 |
2109094 | 2109094 | 2022-01-12 | Trempealeau | Wisconsin | 55121 | 6739 | 56 |
2109095 | 2109095 | 2022-01-12 | Vernon | Wisconsin | 55123 | 4535 | 76 |
2109096 | 2109096 | 2022-01-12 | Vilas | Wisconsin | 55125 | 4149 | 77 |
2109097 | 2109097 | 2022-01-12 | Walworth | Wisconsin | 55127 | 21774 | 230 |
2109098 | 2109098 | 2022-01-12 | Washburn | Wisconsin | 55129 | 3291 | 37 |
2109099 | 2109099 | 2022-01-12 | Washington | Wisconsin | 55131 | 31160 | 259 |
2109100 | 2109100 | 2022-01-12 | Waukesha | Wisconsin | 55133 | 83186 | 850 |
2109101 | 2109101 | 2022-01-12 | Waupaca | Wisconsin | 55135 | 11416 | 221 |
2109102 | 2109102 | 2022-01-12 | Waushara | Wisconsin | 55137 | 5023 | 74 |
2109103 | 2109103 | 2022-01-12 | Winnebago | Wisconsin | 55139 | 40985 | 321 |
2109104 | 2109104 | 2022-01-12 | Wood | Wisconsin | 55141 | 16434 | 192 |
2105782 | 2105782 | 2022-01-11 | Adams | Wisconsin | 55001 | 3655 | 43 |
2105783 | 2105783 | 2022-01-11 | Ashland | Wisconsin | 55003 | 2553 | 28 |
2105784 | 2105784 | 2022-01-11 | Barron | Wisconsin | 55005 | 11228 | 121 |
2105785 | 2105785 | 2022-01-11 | Bayfield | Wisconsin | 55007 | 2450 | 34 |
2105786 | 2105786 | 2022-01-11 | Brown | Wisconsin | 55009 | 65295 | 384 |
2105787 | 2105787 | 2022-01-11 | Buffalo | Wisconsin | 55011 | 2754 | 10 |
2105788 | 2105788 | 2022-01-11 | Burnett | Wisconsin | 55013 | 3221 | 36 |
2105789 | 2105789 | 2022-01-11 | Calumet | Wisconsin | 55015 | 11876 | 99 |
2105790 | 2105790 | 2022-01-11 | Chippewa | Wisconsin | 55017 | 14679 | 150 |
2105791 | 2105791 | 2022-01-11 | Clark | Wisconsin | 55019 | 6398 | 110 |
2105792 | 2105792 | 2022-01-11 | Columbia | Wisconsin | 55021 | 11477 | 105 |
2105793 | 2105793 | 2022-01-11 | Crawford | Wisconsin | 55023 | 3276 | 26 |
2105794 | 2105794 | 2022-01-11 | Dane | Wisconsin | 55025 | 77908 | 427 |
2105795 | 2105795 | 2022-01-11 | Dodge | Wisconsin | 55027 | 21712 | 280 |
2105796 | 2105796 | 2022-01-11 | Door | Wisconsin | 55029 | 5555 | 52 |
2105797 | 2105797 | 2022-01-11 | Douglas | Wisconsin | 55031 | 8679 | 71 |
2105798 | 2105798 | 2022-01-11 | Dunn | Wisconsin | 55033 | 10352 | 63 |
2105799 | 2105799 | 2022-01-11 | Eau Claire | Wisconsin | 55035 | 23220 | 166 |
2105800 | 2105800 | 2022-01-11 | Florence | Wisconsin | 55037 | 844 | 15 |
2105801 | 2105801 | 2022-01-11 | Fond du Lac | Wisconsin | 55039 | 25368 | 203 |
2105802 | 2105802 | 2022-01-11 | Forest | Wisconsin | 55041 | 2051 | 44 |
2105803 | 2105803 | 2022-01-11 | Grant | Wisconsin | 55043 | 10273 | 129 |
2105804 | 2105804 | 2022-01-11 | Green | Wisconsin | 55045 | 6917 | 46 |
2105805 | 2105805 | 2022-01-11 | Green Lake | Wisconsin | 55047 | 4094 | 49 |
2105806 | 2105806 | 2022-01-11 | Iowa | Wisconsin | 55049 | 3910 | 24 |
2105807 | 2105807 | 2022-01-11 | Iron | Wisconsin | 55051 | 1108 | 44 |
2105808 | 2105808 | 2022-01-11 | Jackson | Wisconsin | 55053 | 4653 | 40 |
2105809 | 2105809 | 2022-01-11 | Jefferson | Wisconsin | 55055 | 16880 | 195 |
2105810 | 2105810 | 2022-01-11 | Juneau | Wisconsin | 55057 | 6080 | 54 |
2105811 | 2105811 | 2022-01-11 | Kenosha | Wisconsin | 55059 | 34448 | 500 |
2105812 | 2105812 | 2022-01-11 | Kewaunee | Wisconsin | 55061 | 4901 | 51 |
2105813 | 2105813 | 2022-01-11 | La Crosse | Wisconsin | 55063 | 25431 | 141 |
2105814 | 2105814 | 2022-01-11 | Lafayette | Wisconsin | 55065 | 2909 | 18 |
2105815 | 2105815 | 2022-01-11 | Langlade | Wisconsin | 55067 | 4174 | 66 |
2105816 | 2105816 | 2022-01-11 | Lincoln | Wisconsin | 55069 | 5805 | 125 |
2105817 | 2105817 | 2022-01-11 | Manitowoc | Wisconsin | 55071 | 16804 | 151 |
2105818 | 2105818 | 2022-01-11 | Marathon | Wisconsin | 55073 | 31539 | 416 |
2105819 | 2105819 | 2022-01-11 | Marinette | Wisconsin | 55075 | 9590 | 99 |
2105820 | 2105820 | 2022-01-11 | Marquette | Wisconsin | 55077 | 3128 | 41 |
2105821 | 2105821 | 2022-01-11 | Menominee | Wisconsin | 55078 | 1263 | 12 |
2105822 | 2105822 | 2022-01-11 | Milwaukee | Wisconsin | 55079 | 213964 | 1857 |
2105823 | 2105823 | 2022-01-11 | Monroe | Wisconsin | 55081 | 9213 | 72 |
2105824 | 2105824 | 2022-01-11 | Oconto | Wisconsin | 55083 | 9547 | 89 |
2105825 | 2105825 | 2022-01-11 | Oneida | Wisconsin | 55085 | 6892 | 116 |
2105826 | 2105826 | 2022-01-11 | Outagamie | Wisconsin | 55087 | 43569 | 310 |
2105827 | 2105827 | 2022-01-11 | Ozaukee | Wisconsin | 55089 | 17561 | 132 |
2105828 | 2105828 | 2022-01-11 | Pepin | Wisconsin | 55091 | 1592 | 15 |
2105829 | 2105829 | 2022-01-11 | Pierce | Wisconsin | 55093 | 9240 | 64 |
2105830 | 2105830 | 2022-01-11 | Polk | Wisconsin | 55095 | 9998 | 111 |
2105831 | 2105831 | 2022-01-11 | Portage | Wisconsin | 55097 | 14565 | 130 |
2105832 | 2105832 | 2022-01-11 | Price | Wisconsin | 55099 | 2723 | 23 |
2105833 | 2105833 | 2022-01-11 | Racine | Wisconsin | 55101 | 46684 | 533 |
2105834 | 2105834 | 2022-01-11 | Richland | Wisconsin | 55103 | 2947 | 38 |
2105835 | 2105835 | 2022-01-11 | Rock | Wisconsin | 55105 | 32820 | 290 |
2105836 | 2105836 | 2022-01-11 | Rusk | Wisconsin | 55107 | 2904 | 41 |
2105837 | 2105837 | 2022-01-11 | Sauk | Wisconsin | 55111 | 12289 | 85 |
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);