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

21,071 rows where state = "Wisconsin" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • Wisconsin · 21,071 ✖
Link rowid date ▲ county state fips cases deaths
926914 926914 2021-01-13 Adams Wisconsin 55001 1549 13
926915 926915 2021-01-13 Ashland Wisconsin 55003 1133 16
926916 926916 2021-01-13 Barron Wisconsin 55005 4886 61
926917 926917 2021-01-13 Bayfield Wisconsin 55007 1015 18
926918 926918 2021-01-13 Brown Wisconsin 55009 29669 184
926919 926919 2021-01-13 Buffalo Wisconsin 55011 1160 7
926920 926920 2021-01-13 Burnett Wisconsin 55013 1163 23
926921 926921 2021-01-13 Calumet Wisconsin 55015 5359 40
926922 926922 2021-01-13 Chippewa Wisconsin 55017 6482 74
926923 926923 2021-01-13 Clark Wisconsin 55019 3285 58
926924 926924 2021-01-13 Columbia Wisconsin 55021 4830 39
926925 926925 2021-01-13 Crawford Wisconsin 55023 1656 13
926926 926926 2021-01-13 Dane Wisconsin 55025 37115 233
926927 926927 2021-01-13 Dodge Wisconsin 55027 11476 144
926928 926928 2021-01-13 Door Wisconsin 55029 2388 19
926929 926929 2021-01-13 Douglas Wisconsin 55031 3801 30
926930 926930 2021-01-13 Dunn Wisconsin 55033 4057 25
926931 926931 2021-01-13 Eau Claire Wisconsin 55035 10179 100
926932 926932 2021-01-13 Florence Wisconsin 55037 440 12
926933 926933 2021-01-13 Fond du Lac Wisconsin 55039 11935 79
926934 926934 2021-01-13 Forest Wisconsin 55041 958 25
926935 926935 2021-01-13 Grant Wisconsin 55043 4821 82
926936 926936 2021-01-13 Green Wisconsin 55045 2566 14
926937 926937 2021-01-13 Green Lake Wisconsin 55047 1806 17
926938 926938 2021-01-13 Iowa Wisconsin 55049 1818 9
926939 926939 2021-01-13 Iron Wisconsin 55051 546 36
926940 926940 2021-01-13 Jackson Wisconsin 55053 2515 19
926941 926941 2021-01-13 Jefferson Wisconsin 55055 7848 66
926942 926942 2021-01-13 Juneau Wisconsin 55057 2775 12
926943 926943 2021-01-13 Kenosha Wisconsin 55059 15100 256
926944 926944 2021-01-13 Kewaunee Wisconsin 55061 2333 26
926945 926945 2021-01-13 La Crosse Wisconsin 55063 11465 64
926946 926946 2021-01-13 Lafayette Wisconsin 55065 1419 7
926947 926947 2021-01-13 Langlade Wisconsin 55067 1998 41
926948 926948 2021-01-13 Lincoln Wisconsin 55069 2841 64
926949 926949 2021-01-13 Manitowoc Wisconsin 55071 7480 64
926950 926950 2021-01-13 Marathon Wisconsin 55073 13893 193
926951 926951 2021-01-13 Marinette Wisconsin 55075 4070 51
926952 926952 2021-01-13 Marquette Wisconsin 55077 1361 25
926953 926953 2021-01-13 Menominee Wisconsin 55078 762 11
926954 926954 2021-01-13 Milwaukee Wisconsin 55079 97758 1025
926955 926955 2021-01-13 Monroe Wisconsin 55081 3814 26
926956 926956 2021-01-13 Oconto Wisconsin 55083 4368 46
926957 926957 2021-01-13 Oneida Wisconsin 55085 3097 51
926958 926958 2021-01-13 Outagamie Wisconsin 55087 19093 169
926959 926959 2021-01-13 Ozaukee Wisconsin 55089 7672 64
926960 926960 2021-01-13 Pepin Wisconsin 55091 761 6
926961 926961 2021-01-13 Pierce Wisconsin 55093 3887 35
926962 926962 2021-01-13 Polk Wisconsin 55095 3365 29
926963 926963 2021-01-13 Portage Wisconsin 55097 6272 57
926964 926964 2021-01-13 Price Wisconsin 55099 1068 6
926965 926965 2021-01-13 Racine Wisconsin 55101 21126 285
926966 926966 2021-01-13 Richland Wisconsin 55103 1209 13
926967 926967 2021-01-13 Rock Wisconsin 55105 14126 135
926968 926968 2021-01-13 Rusk Wisconsin 55107 1213 15
926969 926969 2021-01-13 Sauk Wisconsin 55111 5001 37
926970 926970 2021-01-13 Sawyer Wisconsin 55113 1331 17
926971 926971 2021-01-13 Shawano Wisconsin 55115 4793 74
926972 926972 2021-01-13 Sheboygan Wisconsin 55117 12553 102
926973 926973 2021-01-13 St. Croix Wisconsin 55109 7059 34
926974 926974 2021-01-13 Taylor Wisconsin 55119 1874 19
926975 926975 2021-01-13 Trempealeau Wisconsin 55121 3221 32
926976 926976 2021-01-13 Vernon Wisconsin 55123 1693 32
926977 926977 2021-01-13 Vilas Wisconsin 55125 1842 31
926978 926978 2021-01-13 Walworth Wisconsin 55127 10268 117
926979 926979 2021-01-13 Washburn Wisconsin 55129 1189 17
926980 926980 2021-01-13 Washington Wisconsin 55131 14187 111
926981 926981 2021-01-13 Waukesha Wisconsin 55133 40520 410
926982 926982 2021-01-13 Waupaca Wisconsin 55135 5119 140
926983 926983 2021-01-13 Waushara Wisconsin 55137 2178 24
926984 926984 2021-01-13 Winnebago Wisconsin 55139 18011 180
926985 926985 2021-01-13 Wood Wisconsin 55141 6399 70
923668 923668 2021-01-12 Adams Wisconsin 55001 1544 13
923669 923669 2021-01-12 Ashland Wisconsin 55003 1121 16
923670 923670 2021-01-12 Barron Wisconsin 55005 4873 58
923671 923671 2021-01-12 Bayfield Wisconsin 55007 1012 18
923672 923672 2021-01-12 Brown Wisconsin 55009 29461 182
923673 923673 2021-01-12 Buffalo Wisconsin 55011 1129 7
923674 923674 2021-01-12 Burnett Wisconsin 55013 1158 21
923675 923675 2021-01-12 Calumet Wisconsin 55015 5331 40
923676 923676 2021-01-12 Chippewa Wisconsin 55017 6460 72
923677 923677 2021-01-12 Clark Wisconsin 55019 3277 58
923678 923678 2021-01-12 Columbia Wisconsin 55021 4821 39
923679 923679 2021-01-12 Crawford Wisconsin 55023 1645 13
923680 923680 2021-01-12 Dane Wisconsin 55025 36971 233
923681 923681 2021-01-12 Dodge Wisconsin 55027 11417 144
923682 923682 2021-01-12 Door Wisconsin 55029 2358 18
923683 923683 2021-01-12 Douglas Wisconsin 55031 3782 30
923684 923684 2021-01-12 Dunn Wisconsin 55033 4027 25
923685 923685 2021-01-12 Eau Claire Wisconsin 55035 10112 99
923686 923686 2021-01-12 Florence Wisconsin 55037 439 12
923687 923687 2021-01-12 Fond du Lac Wisconsin 55039 11874 79
923688 923688 2021-01-12 Forest Wisconsin 55041 954 25
923689 923689 2021-01-12 Grant Wisconsin 55043 4797 82
923690 923690 2021-01-12 Green Wisconsin 55045 2542 14
923691 923691 2021-01-12 Green Lake Wisconsin 55047 1802 17
923692 923692 2021-01-12 Iowa Wisconsin 55049 1812 9
923693 923693 2021-01-12 Iron Wisconsin 55051 545 36
923694 923694 2021-01-12 Jackson Wisconsin 55053 2511 18
923695 923695 2021-01-12 Jefferson Wisconsin 55055 7813 66

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