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 176
- 55093 144
- 55133 142
- 55039 141
- 55079 140
- 55101 140
- 55117 140
- 55139 139
- 55087 137
- 55141 137
- 55059 136
- 55063 135
- 55131 135
- 55009 134
- 55089 134
- 55111 134
- 55127 134
- 55007 133
- 55015 133
- 55021 133
- 55035 133
- 55055 133
- 55073 133
- 55105 133
- 55109 133
- 55017 132
- 55031 132
- 55033 132
- 55045 132
- 55027 129
- …
county >30
- Dane 176
- Pierce 144
- Waukesha 142
- Fond du Lac 141
- Milwaukee 140
- Racine 140
- Sheboygan 140
- Winnebago 139
- Outagamie 137
- Wood 137
- Kenosha 136
- La Crosse 135
- Washington 135
- Brown 134
- Ozaukee 134
- Sauk 134
- Walworth 134
- Bayfield 133
- Calumet 133
- Columbia 133
- Eau Claire 133
- Jefferson 133
- Marathon 133
- Rock 133
- St. Croix 133
- Chippewa 132
- Douglas 132
- Dunn 132
- Green 132
- Dodge 129
- …
state 1
- Wisconsin · 8,938 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
385871 | 385871 | 2020-07-30 | Jefferson | Wisconsin | 55055 | 542 | 5 |
385872 | 385872 | 2020-07-30 | Juneau | Wisconsin | 55057 | 117 | 1 |
385873 | 385873 | 2020-07-30 | Kenosha | Wisconsin | 55059 | 2374 | 51 |
385874 | 385874 | 2020-07-30 | Kewaunee | Wisconsin | 55061 | 109 | 2 |
385875 | 385875 | 2020-07-30 | La Crosse | Wisconsin | 55063 | 775 | 1 |
385876 | 385876 | 2020-07-30 | Lafayette | Wisconsin | 55065 | 102 | 0 |
385877 | 385877 | 2020-07-30 | Langlade | Wisconsin | 55067 | 42 | 1 |
385878 | 385878 | 2020-07-30 | Lincoln | Wisconsin | 55069 | 60 | 0 |
385879 | 385879 | 2020-07-30 | Manitowoc | Wisconsin | 55071 | 281 | 1 |
385880 | 385880 | 2020-07-30 | Marathon | Wisconsin | 55073 | 532 | 5 |
385881 | 385881 | 2020-07-30 | Marinette | Wisconsin | 55075 | 272 | 3 |
385882 | 385882 | 2020-07-30 | Marquette | Wisconsin | 55077 | 67 | 1 |
385883 | 385883 | 2020-07-30 | Menominee | Wisconsin | 55078 | 18 | 0 |
385884 | 385884 | 2020-07-30 | Milwaukee | Wisconsin | 55079 | 19069 | 433 |
385885 | 385885 | 2020-07-30 | Monroe | Wisconsin | 55081 | 200 | 1 |
385886 | 385886 | 2020-07-30 | Oconto | Wisconsin | 55083 | 164 | 0 |
385887 | 385887 | 2020-07-30 | Oneida | Wisconsin | 55085 | 79 | 0 |
385888 | 385888 | 2020-07-30 | Outagamie | Wisconsin | 55087 | 1037 | 12 |
385889 | 385889 | 2020-07-30 | Ozaukee | Wisconsin | 55089 | 533 | 17 |
385890 | 385890 | 2020-07-30 | Pepin | Wisconsin | 55091 | 40 | 0 |
385891 | 385891 | 2020-07-30 | Pierce | Wisconsin | 55093 | 160 | 0 |
385892 | 385892 | 2020-07-30 | Polk | Wisconsin | 55095 | 108 | 2 |
385893 | 385893 | 2020-07-30 | Portage | Wisconsin | 55097 | 330 | 0 |
385894 | 385894 | 2020-07-30 | Price | Wisconsin | 55099 | 18 | 0 |
385895 | 385895 | 2020-07-30 | Racine | Wisconsin | 55101 | 3446 | 75 |
385896 | 385896 | 2020-07-30 | Richland | Wisconsin | 55103 | 25 | 4 |
385897 | 385897 | 2020-07-30 | Rock | Wisconsin | 55105 | 1460 | 26 |
385898 | 385898 | 2020-07-30 | Rusk | Wisconsin | 55107 | 13 | 1 |
385899 | 385899 | 2020-07-30 | Sauk | Wisconsin | 55111 | 338 | 3 |
385900 | 385900 | 2020-07-30 | Sawyer | Wisconsin | 55113 | 31 | 0 |
385901 | 385901 | 2020-07-30 | Shawano | Wisconsin | 55115 | 143 | 0 |
385902 | 385902 | 2020-07-30 | Sheboygan | Wisconsin | 55117 | 573 | 5 |
385903 | 385903 | 2020-07-30 | St. Croix | Wisconsin | 55109 | 433 | 2 |
385904 | 385904 | 2020-07-30 | Taylor | Wisconsin | 55119 | 44 | 0 |
385905 | 385905 | 2020-07-30 | Trempealeau | Wisconsin | 55121 | 285 | 1 |
385906 | 385906 | 2020-07-30 | Unknown | Wisconsin | 3453 | 7 | |
385907 | 385907 | 2020-07-30 | Vernon | Wisconsin | 55123 | 54 | 0 |
385908 | 385908 | 2020-07-30 | Vilas | Wisconsin | 55125 | 28 | 0 |
385909 | 385909 | 2020-07-30 | Walworth | Wisconsin | 55127 | 1142 | 21 |
385910 | 385910 | 2020-07-30 | Washburn | Wisconsin | 55129 | 17 | 0 |
385911 | 385911 | 2020-07-30 | Washington | Wisconsin | 55131 | 804 | 23 |
385912 | 385912 | 2020-07-30 | Waukesha | Wisconsin | 55133 | 3380 | 51 |
385913 | 385913 | 2020-07-30 | Waupaca | Wisconsin | 55135 | 344 | 14 |
385914 | 385914 | 2020-07-30 | Waushara | Wisconsin | 55137 | 95 | 0 |
385915 | 385915 | 2020-07-30 | Winnebago | Wisconsin | 55139 | 997 | 16 |
385916 | 385916 | 2020-07-30 | Wood | Wisconsin | 55141 | 204 | 1 |
382626 | 382626 | 2020-07-29 | Adams | Wisconsin | 55001 | 65 | 2 |
382627 | 382627 | 2020-07-29 | Ashland | Wisconsin | 55003 | 15 | 0 |
382628 | 382628 | 2020-07-29 | Barron | Wisconsin | 55005 | 145 | 3 |
382629 | 382629 | 2020-07-29 | Bayfield | Wisconsin | 55007 | 19 | 1 |
382630 | 382630 | 2020-07-29 | Brown | Wisconsin | 55009 | 3855 | 50 |
382631 | 382631 | 2020-07-29 | Buffalo | Wisconsin | 55011 | 40 | 2 |
382632 | 382632 | 2020-07-29 | Burnett | Wisconsin | 55013 | 13 | 1 |
382633 | 382633 | 2020-07-29 | Calumet | Wisconsin | 55015 | 224 | 2 |
382634 | 382634 | 2020-07-29 | Chippewa | Wisconsin | 55017 | 198 | 0 |
382635 | 382635 | 2020-07-29 | Clark | Wisconsin | 55019 | 166 | 7 |
382636 | 382636 | 2020-07-29 | Columbia | Wisconsin | 55021 | 204 | 1 |
382637 | 382637 | 2020-07-29 | Crawford | Wisconsin | 55023 | 54 | 0 |
382638 | 382638 | 2020-07-29 | Dane | Wisconsin | 55025 | 3970 | 35 |
382639 | 382639 | 2020-07-29 | Dodge | Wisconsin | 55027 | 634 | 5 |
382640 | 382640 | 2020-07-29 | Door | Wisconsin | 55029 | 82 | 3 |
382641 | 382641 | 2020-07-29 | Douglas | Wisconsin | 55031 | 102 | 0 |
382642 | 382642 | 2020-07-29 | Dunn | Wisconsin | 55033 | 98 | 0 |
382643 | 382643 | 2020-07-29 | Eau Claire | Wisconsin | 55035 | 448 | 3 |
382644 | 382644 | 2020-07-29 | Florence | Wisconsin | 55037 | 5 | 0 |
382645 | 382645 | 2020-07-29 | Fond du Lac | Wisconsin | 55039 | 513 | 6 |
382646 | 382646 | 2020-07-29 | Forest | Wisconsin | 55041 | 57 | 4 |
382647 | 382647 | 2020-07-29 | Grant | Wisconsin | 55043 | 303 | 14 |
382648 | 382648 | 2020-07-29 | Green | Wisconsin | 55045 | 121 | 1 |
382649 | 382649 | 2020-07-29 | Green Lake | Wisconsin | 55047 | 50 | 0 |
382650 | 382650 | 2020-07-29 | Iowa | Wisconsin | 55049 | 56 | 0 |
382651 | 382651 | 2020-07-29 | Iron | Wisconsin | 55051 | 68 | 1 |
382652 | 382652 | 2020-07-29 | Jackson | Wisconsin | 55053 | 43 | 1 |
382653 | 382653 | 2020-07-29 | Jefferson | Wisconsin | 55055 | 535 | 4 |
382654 | 382654 | 2020-07-29 | Juneau | Wisconsin | 55057 | 114 | 1 |
382655 | 382655 | 2020-07-29 | Kenosha | Wisconsin | 55059 | 2348 | 51 |
382656 | 382656 | 2020-07-29 | Kewaunee | Wisconsin | 55061 | 106 | 2 |
382657 | 382657 | 2020-07-29 | La Crosse | Wisconsin | 55063 | 762 | 1 |
382658 | 382658 | 2020-07-29 | Lafayette | Wisconsin | 55065 | 101 | 0 |
382659 | 382659 | 2020-07-29 | Langlade | Wisconsin | 55067 | 38 | 1 |
382660 | 382660 | 2020-07-29 | Lincoln | Wisconsin | 55069 | 56 | 0 |
382661 | 382661 | 2020-07-29 | Manitowoc | Wisconsin | 55071 | 272 | 1 |
382662 | 382662 | 2020-07-29 | Marathon | Wisconsin | 55073 | 518 | 4 |
382663 | 382663 | 2020-07-29 | Marinette | Wisconsin | 55075 | 257 | 3 |
382664 | 382664 | 2020-07-29 | Marquette | Wisconsin | 55077 | 67 | 1 |
382665 | 382665 | 2020-07-29 | Menominee | Wisconsin | 55078 | 18 | 0 |
382666 | 382666 | 2020-07-29 | Milwaukee | Wisconsin | 55079 | 18827 | 429 |
382667 | 382667 | 2020-07-29 | Monroe | Wisconsin | 55081 | 192 | 1 |
382668 | 382668 | 2020-07-29 | Oconto | Wisconsin | 55083 | 154 | 0 |
382669 | 382669 | 2020-07-29 | Oneida | Wisconsin | 55085 | 74 | 0 |
382670 | 382670 | 2020-07-29 | Outagamie | Wisconsin | 55087 | 1008 | 12 |
382671 | 382671 | 2020-07-29 | Ozaukee | Wisconsin | 55089 | 518 | 17 |
382672 | 382672 | 2020-07-29 | Pepin | Wisconsin | 55091 | 41 | 0 |
382673 | 382673 | 2020-07-29 | Pierce | Wisconsin | 55093 | 159 | 0 |
382674 | 382674 | 2020-07-29 | Polk | Wisconsin | 55095 | 105 | 2 |
382675 | 382675 | 2020-07-29 | Portage | Wisconsin | 55097 | 327 | 0 |
382676 | 382676 | 2020-07-29 | Price | Wisconsin | 55099 | 18 | 0 |
382677 | 382677 | 2020-07-29 | Racine | Wisconsin | 55101 | 3399 | 75 |
382678 | 382678 | 2020-07-29 | Richland | Wisconsin | 55103 | 22 | 4 |
382679 | 382679 | 2020-07-29 | Rock | Wisconsin | 55105 | 1458 | 26 |
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);