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 588
- 55093 555
- 55039 553
- 55133 553
- 55079 551
- 55101 551
- 55117 551
- 55139 550
- 55087 548
- 55141 548
- 55059 547
- 55009 546
- 55063 546
- 55131 546
- 55007 545
- 55015 545
- 55021 545
- 55035 545
- 55089 545
- 55111 545
- 55127 545
- 55017 544
- 55031 544
- 55033 544
- 55045 544
- 55055 544
- 55073 544
- 55105 544
- 55109 544
- 55027 541
- …
county >30
- Dane 588
- Pierce 555
- Fond du Lac 553
- Waukesha 553
- Milwaukee 551
- Racine 551
- Sheboygan 551
- Winnebago 550
- Outagamie 548
- Wood 548
- Kenosha 547
- Brown 546
- La Crosse 546
- Washington 546
- Bayfield 545
- Calumet 545
- Columbia 545
- Eau Claire 545
- Ozaukee 545
- Sauk 545
- Walworth 545
- Chippewa 544
- Douglas 544
- Dunn 544
- Green 544
- Jefferson 544
- Marathon 544
- Rock 544
- St. Croix 544
- Dodge 541
- …
state 1
- Wisconsin · 38,641 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1719046 | 1719046 | 2021-09-14 | Adams | Wisconsin | 55001 | 2295 | 26 |
1719047 | 1719047 | 2021-09-14 | Ashland | Wisconsin | 55003 | 1543 | 16 |
1719048 | 1719048 | 2021-09-14 | Barron | Wisconsin | 55005 | 6845 | 86 |
1719049 | 1719049 | 2021-09-14 | Bayfield | Wisconsin | 55007 | 1431 | 22 |
1719050 | 1719050 | 2021-09-14 | Brown | Wisconsin | 55009 | 39243 | 315 |
1719051 | 1719051 | 2021-09-14 | Buffalo | Wisconsin | 55011 | 1650 | 7 |
1719052 | 1719052 | 2021-09-14 | Burnett | Wisconsin | 55013 | 1761 | 29 |
1719053 | 1719053 | 2021-09-14 | Calumet | Wisconsin | 55015 | 7269 | 57 |
1719054 | 1719054 | 2021-09-14 | Chippewa | Wisconsin | 55017 | 8986 | 105 |
1719055 | 1719055 | 2021-09-14 | Clark | Wisconsin | 55019 | 4201 | 69 |
1719056 | 1719056 | 2021-09-14 | Columbia | Wisconsin | 55021 | 6646 | 75 |
1719057 | 1719057 | 2021-09-14 | Crawford | Wisconsin | 55023 | 1945 | 22 |
1719058 | 1719058 | 2021-09-14 | Dane | Wisconsin | 55025 | 52025 | 350 |
1719059 | 1719059 | 2021-09-14 | Dodge | Wisconsin | 55027 | 14162 | 211 |
1719060 | 1719060 | 2021-09-14 | Door | Wisconsin | 55029 | 3156 | 38 |
1719061 | 1719061 | 2021-09-14 | Douglas | Wisconsin | 55031 | 5325 | 66 |
1719062 | 1719062 | 2021-09-14 | Dunn | Wisconsin | 55033 | 5929 | 38 |
1719063 | 1719063 | 2021-09-14 | Eau Claire | Wisconsin | 55035 | 13826 | 129 |
1719064 | 1719064 | 2021-09-14 | Florence | Wisconsin | 55037 | 541 | 13 |
1719065 | 1719065 | 2021-09-14 | Fond du Lac | Wisconsin | 55039 | 15342 | 151 |
1719066 | 1719066 | 2021-09-14 | Forest | Wisconsin | 55041 | 1239 | 29 |
1719067 | 1719067 | 2021-09-14 | Grant | Wisconsin | 55043 | 6295 | 101 |
1719068 | 1719068 | 2021-09-14 | Green | Wisconsin | 55045 | 4063 | 26 |
1719069 | 1719069 | 2021-09-14 | Green Lake | Wisconsin | 55047 | 2395 | 28 |
1719070 | 1719070 | 2021-09-14 | Iowa | Wisconsin | 55049 | 2388 | 16 |
1719071 | 1719071 | 2021-09-14 | Iron | Wisconsin | 55051 | 771 | 42 |
1719072 | 1719072 | 2021-09-14 | Jackson | Wisconsin | 55053 | 3007 | 29 |
1719073 | 1719073 | 2021-09-14 | Jefferson | Wisconsin | 55055 | 10606 | 141 |
1719074 | 1719074 | 2021-09-14 | Juneau | Wisconsin | 55057 | 3688 | 31 |
1719075 | 1719075 | 2021-09-14 | Kenosha | Wisconsin | 55059 | 21287 | 345 |
1719076 | 1719076 | 2021-09-14 | Kewaunee | Wisconsin | 55061 | 2998 | 40 |
1719077 | 1719077 | 2021-09-14 | La Crosse | Wisconsin | 55063 | 15203 | 100 |
1719078 | 1719078 | 2021-09-14 | Lafayette | Wisconsin | 55065 | 1831 | 10 |
1719079 | 1719079 | 2021-09-14 | Langlade | Wisconsin | 55067 | 2515 | 52 |
1719080 | 1719080 | 2021-09-14 | Lincoln | Wisconsin | 55069 | 3624 | 106 |
1719081 | 1719081 | 2021-09-14 | Manitowoc | Wisconsin | 55071 | 9877 | 99 |
1719082 | 1719082 | 2021-09-14 | Marathon | Wisconsin | 55073 | 18095 | 242 |
1719083 | 1719083 | 2021-09-14 | Marinette | Wisconsin | 55075 | 5203 | 77 |
1719084 | 1719084 | 2021-09-14 | Marquette | Wisconsin | 55077 | 1796 | 29 |
1719085 | 1719085 | 2021-09-14 | Menominee | Wisconsin | 55078 | 858 | 11 |
1719086 | 1719086 | 2021-09-14 | Milwaukee | Wisconsin | 55079 | 135679 | 1510 |
1719087 | 1719087 | 2021-09-14 | Monroe | Wisconsin | 55081 | 5491 | 52 |
1719088 | 1719088 | 2021-09-14 | Oconto | Wisconsin | 55083 | 5815 | 75 |
1719089 | 1719089 | 2021-09-14 | Oneida | Wisconsin | 55085 | 4157 | 83 |
1719090 | 1719090 | 2021-09-14 | Outagamie | Wisconsin | 55087 | 26402 | 256 |
1719091 | 1719091 | 2021-09-14 | Ozaukee | Wisconsin | 55089 | 10733 | 111 |
1719092 | 1719092 | 2021-09-14 | Pepin | Wisconsin | 55091 | 1004 | 7 |
1719093 | 1719093 | 2021-09-14 | Pierce | Wisconsin | 55093 | 5453 | 44 |
1719094 | 1719094 | 2021-09-14 | Polk | Wisconsin | 55095 | 5415 | 69 |
1719095 | 1719095 | 2021-09-14 | Portage | Wisconsin | 55097 | 8322 | 84 |
1719096 | 1719096 | 2021-09-14 | Price | Wisconsin | 55099 | 1492 | 8 |
1719097 | 1719097 | 2021-09-14 | Racine | Wisconsin | 55101 | 28447 | 421 |
1719098 | 1719098 | 2021-09-14 | Richland | Wisconsin | 55103 | 1594 | 19 |
1719099 | 1719099 | 2021-09-14 | Rock | Wisconsin | 55105 | 20240 | 222 |
1719100 | 1719100 | 2021-09-14 | Rusk | Wisconsin | 55107 | 1678 | 27 |
1719101 | 1719101 | 2021-09-14 | Sauk | Wisconsin | 55111 | 7059 | 61 |
1719102 | 1719102 | 2021-09-14 | Sawyer | Wisconsin | 55113 | 2060 | 29 |
1719103 | 1719103 | 2021-09-14 | Shawano | Wisconsin | 55115 | 5881 | 86 |
1719104 | 1719104 | 2021-09-14 | Sheboygan | Wisconsin | 55117 | 16293 | 173 |
1719105 | 1719105 | 2021-09-14 | St. Croix | Wisconsin | 55109 | 10951 | 75 |
1719106 | 1719106 | 2021-09-14 | Taylor | Wisconsin | 55119 | 2513 | 41 |
1719107 | 1719107 | 2021-09-14 | Trempealeau | Wisconsin | 55121 | 4209 | 51 |
1719108 | 1719108 | 2021-09-14 | Vernon | Wisconsin | 55123 | 2364 | 49 |
1719109 | 1719109 | 2021-09-14 | Vilas | Wisconsin | 55125 | 2612 | 48 |
1719110 | 1719110 | 2021-09-14 | Walworth | Wisconsin | 55127 | 13948 | 177 |
1719111 | 1719111 | 2021-09-14 | Washburn | Wisconsin | 55129 | 1788 | 25 |
1719112 | 1719112 | 2021-09-14 | Washington | Wisconsin | 55131 | 19129 | 212 |
1719113 | 1719113 | 2021-09-14 | Waukesha | Wisconsin | 55133 | 55537 | 678 |
1719114 | 1719114 | 2021-09-14 | Waupaca | Wisconsin | 55135 | 6785 | 176 |
1719115 | 1719115 | 2021-09-14 | Waushara | Wisconsin | 55137 | 2876 | 43 |
1719116 | 1719116 | 2021-09-14 | Winnebago | Wisconsin | 55139 | 23865 | 238 |
1719117 | 1719117 | 2021-09-14 | Wood | Wisconsin | 55141 | 8833 | 117 |
1715798 | 1715798 | 2021-09-13 | Adams | Wisconsin | 55001 | 2286 | 25 |
1715799 | 1715799 | 2021-09-13 | Ashland | Wisconsin | 55003 | 1530 | 16 |
1715800 | 1715800 | 2021-09-13 | Barron | Wisconsin | 55005 | 6820 | 86 |
1715801 | 1715801 | 2021-09-13 | Bayfield | Wisconsin | 55007 | 1421 | 22 |
1715802 | 1715802 | 2021-09-13 | Brown | Wisconsin | 55009 | 39110 | 315 |
1715803 | 1715803 | 2021-09-13 | Buffalo | Wisconsin | 55011 | 1641 | 7 |
1715804 | 1715804 | 2021-09-13 | Burnett | Wisconsin | 55013 | 1757 | 29 |
1715805 | 1715805 | 2021-09-13 | Calumet | Wisconsin | 55015 | 7237 | 57 |
1715806 | 1715806 | 2021-09-13 | Chippewa | Wisconsin | 55017 | 8934 | 105 |
1715807 | 1715807 | 2021-09-13 | Clark | Wisconsin | 55019 | 4185 | 68 |
1715808 | 1715808 | 2021-09-13 | Columbia | Wisconsin | 55021 | 6613 | 75 |
1715809 | 1715809 | 2021-09-13 | Crawford | Wisconsin | 55023 | 1944 | 22 |
1715810 | 1715810 | 2021-09-13 | Dane | Wisconsin | 55025 | 51895 | 350 |
1715811 | 1715811 | 2021-09-13 | Dodge | Wisconsin | 55027 | 14133 | 211 |
1715812 | 1715812 | 2021-09-13 | Door | Wisconsin | 55029 | 3141 | 38 |
1715813 | 1715813 | 2021-09-13 | Douglas | Wisconsin | 55031 | 5314 | 66 |
1715814 | 1715814 | 2021-09-13 | Dunn | Wisconsin | 55033 | 5893 | 38 |
1715815 | 1715815 | 2021-09-13 | Eau Claire | Wisconsin | 55035 | 13764 | 129 |
1715816 | 1715816 | 2021-09-13 | Florence | Wisconsin | 55037 | 540 | 13 |
1715817 | 1715817 | 2021-09-13 | Fond du Lac | Wisconsin | 55039 | 15288 | 151 |
1715818 | 1715818 | 2021-09-13 | Forest | Wisconsin | 55041 | 1227 | 28 |
1715819 | 1715819 | 2021-09-13 | Grant | Wisconsin | 55043 | 6241 | 101 |
1715820 | 1715820 | 2021-09-13 | Green | Wisconsin | 55045 | 4051 | 26 |
1715821 | 1715821 | 2021-09-13 | Green Lake | Wisconsin | 55047 | 2381 | 28 |
1715822 | 1715822 | 2021-09-13 | Iowa | Wisconsin | 55049 | 2379 | 16 |
1715823 | 1715823 | 2021-09-13 | Iron | Wisconsin | 55051 | 761 | 42 |
1715824 | 1715824 | 2021-09-13 | Jackson | Wisconsin | 55053 | 2998 | 29 |
1715825 | 1715825 | 2021-09-13 | Jefferson | Wisconsin | 55055 | 10560 | 140 |
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);