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

24,239 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 · 24,239 ✖
Link rowid date ▲ county state fips cases deaths
1069638 1069638 2021-02-26 Adams Wisconsin 55001 1736 15
1069639 1069639 2021-02-26 Ashland Wisconsin 55003 1240 16
1069640 1069640 2021-02-26 Barron Wisconsin 55005 5483 76
1069641 1069641 2021-02-26 Bayfield Wisconsin 55007 1137 19
1069642 1069642 2021-02-26 Brown Wisconsin 55009 32575 249
1069643 1069643 2021-02-26 Buffalo Wisconsin 55011 1351 7
1069644 1069644 2021-02-26 Burnett Wisconsin 55013 1335 23
1069645 1069645 2021-02-26 Calumet Wisconsin 55015 6002 45
1069646 1069646 2021-02-26 Chippewa Wisconsin 55017 7210 94
1069647 1069647 2021-02-26 Clark Wisconsin 55019 3542 61
1069648 1069648 2021-02-26 Columbia Wisconsin 55021 5396 60
1069649 1069649 2021-02-26 Crawford Wisconsin 55023 1717 17
1069650 1069650 2021-02-26 Dane Wisconsin 55025 41844 296
1069651 1069651 2021-02-26 Dodge Wisconsin 55027 12175 176
1069652 1069652 2021-02-26 Door Wisconsin 55029 2609 25
1069653 1069653 2021-02-26 Douglas Wisconsin 55031 4231 40
1069654 1069654 2021-02-26 Dunn Wisconsin 55033 4584 28
1069655 1069655 2021-02-26 Eau Claire Wisconsin 55035 11290 114
1069656 1069656 2021-02-26 Florence Wisconsin 55037 469 12
1069657 1069657 2021-02-26 Fond du Lac Wisconsin 55039 13012 101
1069658 1069658 2021-02-26 Forest Wisconsin 55041 993 26
1069659 1069659 2021-02-26 Grant Wisconsin 55043 5329 85
1069660 1069660 2021-02-26 Green Wisconsin 55045 3230 22
1069661 1069661 2021-02-26 Green Lake Wisconsin 55047 1943 21
1069662 1069662 2021-02-26 Iowa Wisconsin 55049 1939 10
1069663 1069663 2021-02-26 Iron Wisconsin 55051 656 39
1069664 1069664 2021-02-26 Jackson Wisconsin 55053 2614 23
1069665 1069665 2021-02-26 Jefferson Wisconsin 55055 8809 125
1069666 1069666 2021-02-26 Juneau Wisconsin 55057 3067 20
1069667 1069667 2021-02-26 Kenosha Wisconsin 55059 16914 314
1069668 1069668 2021-02-26 Kewaunee Wisconsin 55061 2579 28
1069669 1069669 2021-02-26 La Crosse Wisconsin 55063 12845 78
1069670 1069670 2021-02-26 Lafayette Wisconsin 55065 1606 8
1069671 1069671 2021-02-26 Langlade Wisconsin 55067 2090 44
1069672 1069672 2021-02-26 Lincoln Wisconsin 55069 3095 75
1069673 1069673 2021-02-26 Manitowoc Wisconsin 55071 8359 80
1069674 1069674 2021-02-26 Marathon Wisconsin 55073 14995 209
1069675 1069675 2021-02-26 Marinette Wisconsin 55075 4362 66
1069676 1069676 2021-02-26 Marquette Wisconsin 55077 1480 26
1069677 1069677 2021-02-26 Menominee Wisconsin 55078 797 11
1069678 1069678 2021-02-26 Milwaukee Wisconsin 55079 106908 1268
1069679 1069679 2021-02-26 Monroe Wisconsin 55081 4400 32
1069680 1069680 2021-02-26 Oconto Wisconsin 55083 4700 55
1069681 1069681 2021-02-26 Oneida Wisconsin 55085 3493 71
1069682 1069682 2021-02-26 Outagamie Wisconsin 55087 21526 205
1069683 1069683 2021-02-26 Ozaukee Wisconsin 55089 8516 83
1069684 1069684 2021-02-26 Pepin Wisconsin 55091 825 7
1069685 1069685 2021-02-26 Pierce Wisconsin 55093 4355 39
1069686 1069686 2021-02-26 Polk Wisconsin 55095 3972 46
1069687 1069687 2021-02-26 Portage Wisconsin 55097 6985 67
1069688 1069688 2021-02-26 Price Wisconsin 55099 1251 7
1069689 1069689 2021-02-26 Racine Wisconsin 55101 22899 349
1069690 1069690 2021-02-26 Richland Wisconsin 55103 1320 14
1069691 1069691 2021-02-26 Rock Wisconsin 55105 15932 172
1069692 1069692 2021-02-26 Rusk Wisconsin 55107 1293 17
1069693 1069693 2021-02-26 Sauk Wisconsin 55111 5509 46
1069694 1069694 2021-02-26 Sawyer Wisconsin 55113 1543 21
1069695 1069695 2021-02-26 Shawano Wisconsin 55115 5092 81
1069696 1069696 2021-02-26 Sheboygan Wisconsin 55117 13622 136
1069697 1069697 2021-02-26 St. Croix Wisconsin 55109 7984 47
1069698 1069698 2021-02-26 Taylor Wisconsin 55119 2009 30
1069699 1069699 2021-02-26 Trempealeau Wisconsin 55121 3476 38
1069700 1069700 2021-02-26 Vernon Wisconsin 55123 1892 39
1069701 1069701 2021-02-26 Vilas Wisconsin 55125 2243 38
1069702 1069702 2021-02-26 Walworth Wisconsin 55127 11206 145
1069703 1069703 2021-02-26 Washburn Wisconsin 55129 1363 20
1069704 1069704 2021-02-26 Washington Wisconsin 55131 15490 142
1069705 1069705 2021-02-26 Waukesha Wisconsin 55133 44677 525
1069706 1069706 2021-02-26 Waupaca Wisconsin 55135 5656 157
1069707 1069707 2021-02-26 Waushara Wisconsin 55137 2404 34
1069708 1069708 2021-02-26 Winnebago Wisconsin 55139 19723 204
1069709 1069709 2021-02-26 Wood Wisconsin 55141 7125 85
1066393 1066393 2021-02-25 Adams Wisconsin 55001 1736 15
1066394 1066394 2021-02-25 Ashland Wisconsin 55003 1238 16
1066395 1066395 2021-02-25 Barron Wisconsin 55005 5474 76
1066396 1066396 2021-02-25 Bayfield Wisconsin 55007 1136 19
1066397 1066397 2021-02-25 Brown Wisconsin 55009 32538 249
1066398 1066398 2021-02-25 Buffalo Wisconsin 55011 1347 7
1066399 1066399 2021-02-25 Burnett Wisconsin 55013 1332 23
1066400 1066400 2021-02-25 Calumet Wisconsin 55015 5993 45
1066401 1066401 2021-02-25 Chippewa Wisconsin 55017 7202 94
1066402 1066402 2021-02-25 Clark Wisconsin 55019 3542 61
1066403 1066403 2021-02-25 Columbia Wisconsin 55021 5385 60
1066404 1066404 2021-02-25 Crawford Wisconsin 55023 1717 17
1066405 1066405 2021-02-25 Dane Wisconsin 55025 41764 295
1066406 1066406 2021-02-25 Dodge Wisconsin 55027 12164 176
1066407 1066407 2021-02-25 Door Wisconsin 55029 2606 25
1066408 1066408 2021-02-25 Douglas Wisconsin 55031 4228 40
1066409 1066409 2021-02-25 Dunn Wisconsin 55033 4582 28
1066410 1066410 2021-02-25 Eau Claire Wisconsin 55035 11278 114
1066411 1066411 2021-02-25 Florence Wisconsin 55037 469 12
1066412 1066412 2021-02-25 Fond du Lac Wisconsin 55039 12987 101
1066413 1066413 2021-02-25 Forest Wisconsin 55041 993 26
1066414 1066414 2021-02-25 Grant Wisconsin 55043 5323 85
1066415 1066415 2021-02-25 Green Wisconsin 55045 3219 22
1066416 1066416 2021-02-25 Green Lake Wisconsin 55047 1942 21
1066417 1066417 2021-02-25 Iowa Wisconsin 55049 1939 10
1066418 1066418 2021-02-25 Iron Wisconsin 55051 654 39
1066419 1066419 2021-02-25 Jackson Wisconsin 55053 2618 23
1066420 1066420 2021-02-25 Jefferson Wisconsin 55055 8801 125

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