ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

41,449 rows where state = "Wisconsin" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Wisconsin · 41,449 ✖
Link rowid date ▲ county state fips cases deaths
1845761 1845761 2021-10-23 Adams Wisconsin 55001 2721 33
1845762 1845762 2021-10-23 Ashland Wisconsin 55003 1820 16
1845763 1845763 2021-10-23 Barron Wisconsin 55005 8327 92
1845764 1845764 2021-10-23 Bayfield Wisconsin 55007 1625 25
1845765 1845765 2021-10-23 Brown Wisconsin 55009 45497 318
1845766 1845766 2021-10-23 Buffalo Wisconsin 55011 1952 8
1845767 1845767 2021-10-23 Burnett Wisconsin 55013 2217 32
1845768 1845768 2021-10-23 Calumet Wisconsin 55015 8232 59
1845769 1845769 2021-10-23 Chippewa Wisconsin 55017 10801 116
1845770 1845770 2021-10-23 Clark Wisconsin 55019 4745 78
1845771 1845771 2021-10-23 Columbia Wisconsin 55021 7885 78
1845772 1845772 2021-10-23 Crawford Wisconsin 55023 2285 22
1845773 1845773 2021-10-23 Dane Wisconsin 55025 57350 369
1845774 1845774 2021-10-23 Dodge Wisconsin 55027 15955 227
1845775 1845775 2021-10-23 Door Wisconsin 55029 3746 39
1845776 1845776 2021-10-23 Douglas Wisconsin 55031 5946 66
1845777 1845777 2021-10-23 Dunn Wisconsin 55033 6978 46
1845778 1845778 2021-10-23 Eau Claire Wisconsin 55035 16129 138
1845779 1845779 2021-10-23 Florence Wisconsin 55037 632 14
1845780 1845780 2021-10-23 Fond du Lac Wisconsin 55039 17959 158
1845781 1845781 2021-10-23 Forest Wisconsin 55041 1515 31
1845782 1845782 2021-10-23 Grant Wisconsin 55043 7536 116
1845783 1845783 2021-10-23 Green Wisconsin 55045 4565 30
1845784 1845784 2021-10-23 Green Lake Wisconsin 55047 3020 30
1845785 1845785 2021-10-23 Iowa Wisconsin 55049 2723 17
1845786 1845786 2021-10-23 Iron Wisconsin 55051 887 42
1845787 1845787 2021-10-23 Jackson Wisconsin 55053 3366 31
1845788 1845788 2021-10-23 Jefferson Wisconsin 55055 11736 149
1845789 1845789 2021-10-23 Juneau Wisconsin 55057 4174 35
1845790 1845790 2021-10-23 Kenosha Wisconsin 55059 23818 381
1845791 1845791 2021-10-23 Kewaunee Wisconsin 55061 3574 41
1845792 1845792 2021-10-23 La Crosse Wisconsin 55063 17186 110
1845793 1845793 2021-10-23 Lafayette Wisconsin 55065 2101 12
1845794 1845794 2021-10-23 Langlade Wisconsin 55067 3142 54
1845795 1845795 2021-10-23 Lincoln Wisconsin 55069 4323 109
1845796 1845796 2021-10-23 Manitowoc Wisconsin 55071 11620 106
1845797 1845797 2021-10-23 Marathon Wisconsin 55073 20913 266
1845798 1845798 2021-10-23 Marinette Wisconsin 55075 6692 79
1845799 1845799 2021-10-23 Marquette Wisconsin 55077 2279 33
1845800 1845800 2021-10-23 Menominee Wisconsin 55078 948 11
1845801 1845801 2021-10-23 Milwaukee Wisconsin 55079 150104 1594
1845802 1845802 2021-10-23 Monroe Wisconsin 55081 6400 56
1845803 1845803 2021-10-23 Oconto Wisconsin 55083 7126 76
1845804 1845804 2021-10-23 Oneida Wisconsin 55085 4946 91
1845805 1845805 2021-10-23 Outagamie Wisconsin 55087 30294 269
1845806 1845806 2021-10-23 Ozaukee Wisconsin 55089 12292 115
1845807 1845807 2021-10-23 Pepin Wisconsin 55091 1158 10
1845808 1845808 2021-10-23 Pierce Wisconsin 55093 6263 46
1845809 1845809 2021-10-23 Polk Wisconsin 55095 6749 84
1845810 1845810 2021-10-23 Portage Wisconsin 55097 9437 96
1845811 1845811 2021-10-23 Price Wisconsin 55099 1813 11
1845812 1845812 2021-10-23 Racine Wisconsin 55101 31441 447
1845813 1845813 2021-10-23 Richland Wisconsin 55103 2194 23
1845814 1845814 2021-10-23 Rock Wisconsin 55105 22145 244
1845815 1845815 2021-10-23 Rusk Wisconsin 55107 2189 34
1845816 1845816 2021-10-23 Sauk Wisconsin 55111 8272 66
1845817 1845817 2021-10-23 Sawyer Wisconsin 55113 2521 31
1845818 1845818 2021-10-23 Shawano Wisconsin 55115 7000 90
1845819 1845819 2021-10-23 Sheboygan Wisconsin 55117 18064 186
1845820 1845820 2021-10-23 St. Croix Wisconsin 55109 12788 85
1845821 1845821 2021-10-23 Taylor Wisconsin 55119 2986 45
1845822 1845822 2021-10-23 Trempealeau Wisconsin 55121 4918 52
1845823 1845823 2021-10-23 Vernon Wisconsin 55123 2873 57
1845824 1845824 2021-10-23 Vilas Wisconsin 55125 3065 53
1845825 1845825 2021-10-23 Walworth Wisconsin 55127 15627 188
1845826 1845826 2021-10-23 Washburn Wisconsin 55129 2191 27
1845827 1845827 2021-10-23 Washington Wisconsin 55131 22291 221
1845828 1845828 2021-10-23 Waukesha Wisconsin 55133 62105 718
1845829 1845829 2021-10-23 Waupaca Wisconsin 55135 8176 183
1845830 1845830 2021-10-23 Waushara Wisconsin 55137 3660 50
1845831 1845831 2021-10-23 Winnebago Wisconsin 55139 27209 259
1845832 1845832 2021-10-23 Wood Wisconsin 55141 10480 135
1842511 1842511 2021-10-22 Adams Wisconsin 55001 2721 33
1842512 1842512 2021-10-22 Ashland Wisconsin 55003 1820 16
1842513 1842513 2021-10-22 Barron Wisconsin 55005 8327 92
1842514 1842514 2021-10-22 Bayfield Wisconsin 55007 1625 25
1842515 1842515 2021-10-22 Brown Wisconsin 55009 45497 318
1842516 1842516 2021-10-22 Buffalo Wisconsin 55011 1952 8
1842517 1842517 2021-10-22 Burnett Wisconsin 55013 2217 32
1842518 1842518 2021-10-22 Calumet Wisconsin 55015 8232 59
1842519 1842519 2021-10-22 Chippewa Wisconsin 55017 10801 116
1842520 1842520 2021-10-22 Clark Wisconsin 55019 4745 78
1842521 1842521 2021-10-22 Columbia Wisconsin 55021 7885 78
1842522 1842522 2021-10-22 Crawford Wisconsin 55023 2285 22
1842523 1842523 2021-10-22 Dane Wisconsin 55025 57350 369
1842524 1842524 2021-10-22 Dodge Wisconsin 55027 15955 227
1842525 1842525 2021-10-22 Door Wisconsin 55029 3746 39
1842526 1842526 2021-10-22 Douglas Wisconsin 55031 5946 66
1842527 1842527 2021-10-22 Dunn Wisconsin 55033 6978 46
1842528 1842528 2021-10-22 Eau Claire Wisconsin 55035 16129 138
1842529 1842529 2021-10-22 Florence Wisconsin 55037 632 14
1842530 1842530 2021-10-22 Fond du Lac Wisconsin 55039 17959 158
1842531 1842531 2021-10-22 Forest Wisconsin 55041 1515 31
1842532 1842532 2021-10-22 Grant Wisconsin 55043 7536 116
1842533 1842533 2021-10-22 Green Wisconsin 55045 4565 30
1842534 1842534 2021-10-22 Green Lake Wisconsin 55047 3020 30
1842535 1842535 2021-10-22 Iowa Wisconsin 55049 2723 17
1842536 1842536 2021-10-22 Iron Wisconsin 55051 887 42
1842537 1842537 2021-10-22 Jackson Wisconsin 55053 3366 31
1842538 1842538 2021-10-22 Jefferson Wisconsin 55055 11736 149

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);