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

55,993 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 >30

county >30

state 1

  • Wisconsin · 55,993 ✖
Link rowid date ▲ county state fips cases deaths
2502738 2502738 2022-05-13 Adams Wisconsin 55001 4738 61
2502739 2502739 2022-05-13 Ashland Wisconsin 55003 3364 36
2502740 2502740 2022-05-13 Barron Wisconsin 55005 13743 144
2502741 2502741 2022-05-13 Bayfield Wisconsin 55007 3425 41
2502742 2502742 2022-05-13 Brown Wisconsin 55009 85688 557
2502743 2502743 2022-05-13 Buffalo Wisconsin 55011 3608 12
2502744 2502744 2022-05-13 Burnett Wisconsin 55013 4062 43
2502745 2502745 2022-05-13 Calumet Wisconsin 55015 14749 121
2502746 2502746 2022-05-13 Chippewa Wisconsin 55017 19101 187
2502747 2502747 2022-05-13 Clark Wisconsin 55019 7694 122
2502748 2502748 2022-05-13 Columbia Wisconsin 55021 15821 128
2502749 2502749 2022-05-13 Crawford Wisconsin 55023 4299 28
2502750 2502750 2022-05-13 Dane Wisconsin 55025 134580 516
2502751 2502751 2022-05-13 Dodge Wisconsin 55027 27570 340
2502752 2502752 2022-05-13 Door Wisconsin 55029 7097 71
2502753 2502753 2022-05-13 Douglas Wisconsin 55031 11993 79
2502754 2502754 2022-05-13 Dunn Wisconsin 55033 13611 75
2502755 2502755 2022-05-13 Eau Claire Wisconsin 55035 31318 187
2502756 2502756 2022-05-13 Florence Wisconsin 55037 1093 17
2502757 2502757 2022-05-13 Fond du Lac Wisconsin 55039 32524 278
2502758 2502758 2022-05-13 Forest Wisconsin 55041 2694 52
2502759 2502759 2022-05-13 Grant Wisconsin 55043 12945 146
2502760 2502760 2022-05-13 Green Wisconsin 55045 9528 54
2502761 2502761 2022-05-13 Green Lake Wisconsin 55047 5268 64
2502762 2502762 2022-05-13 Iowa Wisconsin 55049 5424 29
2502763 2502763 2022-05-13 Iron Wisconsin 55051 1482 47
2502764 2502764 2022-05-13 Jackson Wisconsin 55053 5736 43
2502765 2502765 2022-05-13 Jefferson Wisconsin 55055 22026 243
2502766 2502766 2022-05-13 Juneau Wisconsin 55057 7859 68
2502767 2502767 2022-05-13 Kenosha Wisconsin 55059 45275 631
2502768 2502768 2022-05-13 Kewaunee Wisconsin 55061 5927 59
2502769 2502769 2022-05-13 La Crosse Wisconsin 55063 35988 186
2502770 2502770 2022-05-13 Lafayette Wisconsin 55065 3731 26
2502771 2502771 2022-05-13 Langlade Wisconsin 55067 5295 92
2502772 2502772 2022-05-13 Lincoln Wisconsin 55069 7188 148
2502773 2502773 2022-05-13 Manitowoc Wisconsin 55071 20803 189
2502774 2502774 2022-05-13 Marathon Wisconsin 55073 40330 491
2502775 2502775 2022-05-13 Marinette Wisconsin 55075 11760 127
2502776 2502776 2022-05-13 Marquette Wisconsin 55077 3873 61
2502777 2502777 2022-05-13 Menominee Wisconsin 55078 1987 14
2502778 2502778 2022-05-13 Milwaukee Wisconsin 55079 277430 2292
2502779 2502779 2022-05-13 Monroe Wisconsin 55081 12305 91
2502780 2502780 2022-05-13 Oconto Wisconsin 55083 11522 121
2502781 2502781 2022-05-13 Oneida Wisconsin 55085 8605 139
2502782 2502782 2022-05-13 Outagamie Wisconsin 55087 55321 406
2502783 2502783 2022-05-13 Ozaukee Wisconsin 55089 23174 186
2502784 2502784 2022-05-13 Pepin Wisconsin 55091 2001 18
2502785 2502785 2022-05-13 Pierce Wisconsin 55093 11879 73
2502786 2502786 2022-05-13 Polk Wisconsin 55095 12692 122
2502787 2502787 2022-05-13 Portage Wisconsin 55097 18469 161
2502788 2502788 2022-05-13 Price Wisconsin 55099 3283 33
2502789 2502789 2022-05-13 Racine Wisconsin 55101 57729 690
2502790 2502790 2022-05-13 Richland Wisconsin 55103 3995 48
2502791 2502791 2022-05-13 Rock Wisconsin 55105 44315 395
2502792 2502792 2022-05-13 Rusk Wisconsin 55107 3465 55
2502793 2502793 2022-05-13 Sauk Wisconsin 55111 16479 136
2502794 2502794 2022-05-13 Sawyer Wisconsin 55113 4651 62
2502795 2502795 2022-05-13 Shawano Wisconsin 55115 11994 152
2502796 2502796 2022-05-13 Sheboygan Wisconsin 55117 33090 319
2502797 2502797 2022-05-13 St. Croix Wisconsin 55109 25656 149
2502798 2502798 2022-05-13 Taylor Wisconsin 55119 4884 72
2502799 2502799 2022-05-13 Trempealeau Wisconsin 55121 8555 65
2502800 2502800 2022-05-13 Vernon Wisconsin 55123 6239 98
2502801 2502801 2022-05-13 Vilas Wisconsin 55125 5270 89
2502802 2502802 2022-05-13 Walworth Wisconsin 55127 27341 281
2502803 2502803 2022-05-13 Washburn Wisconsin 55129 4078 46
2502804 2502804 2022-05-13 Washington Wisconsin 55131 38986 343
2502805 2502805 2022-05-13 Waukesha Wisconsin 55133 115887 1093
2502806 2502806 2022-05-13 Waupaca Wisconsin 55135 13835 252
2502807 2502807 2022-05-13 Waushara Wisconsin 55137 6522 87
2502808 2502808 2022-05-13 Winnebago Wisconsin 55139 53045 382
2502809 2502809 2022-05-13 Wood Wisconsin 55141 21477 233
2499480 2499480 2022-05-12 Adams Wisconsin 55001 4727 61
2499481 2499481 2022-05-12 Ashland Wisconsin 55003 3357 36
2499482 2499482 2022-05-12 Barron Wisconsin 55005 13732 144
2499483 2499483 2022-05-12 Bayfield Wisconsin 55007 3417 41
2499484 2499484 2022-05-12 Brown Wisconsin 55009 85571 557
2499485 2499485 2022-05-12 Buffalo Wisconsin 55011 3604 12
2499486 2499486 2022-05-12 Burnett Wisconsin 55013 4052 43
2499487 2499487 2022-05-12 Calumet Wisconsin 55015 14741 121
2499488 2499488 2022-05-12 Chippewa Wisconsin 55017 19093 187
2499489 2499489 2022-05-12 Clark Wisconsin 55019 7688 122
2499490 2499490 2022-05-12 Columbia Wisconsin 55021 15792 128
2499491 2499491 2022-05-12 Crawford Wisconsin 55023 4291 28
2499492 2499492 2022-05-12 Dane Wisconsin 55025 134092 516
2499493 2499493 2022-05-12 Dodge Wisconsin 55027 27541 340
2499494 2499494 2022-05-12 Door Wisconsin 55029 7085 71
2499495 2499495 2022-05-12 Douglas Wisconsin 55031 11964 79
2499496 2499496 2022-05-12 Dunn Wisconsin 55033 13598 75
2499497 2499497 2022-05-12 Eau Claire Wisconsin 55035 31278 187
2499498 2499498 2022-05-12 Florence Wisconsin 55037 1091 17
2499499 2499499 2022-05-12 Fond du Lac Wisconsin 55039 32473 277
2499500 2499500 2022-05-12 Forest Wisconsin 55041 2692 52
2499501 2499501 2022-05-12 Grant Wisconsin 55043 12930 146
2499502 2499502 2022-05-12 Green Wisconsin 55045 9504 54
2499503 2499503 2022-05-12 Green Lake Wisconsin 55047 5260 64
2499504 2499504 2022-05-12 Iowa Wisconsin 55049 5420 29
2499505 2499505 2022-05-12 Iron Wisconsin 55051 1481 47
2499506 2499506 2022-05-12 Jackson Wisconsin 55053 5731 43
2499507 2499507 2022-05-12 Jefferson Wisconsin 55055 21985 243

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