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
county >30
- Dane 143
- Pierce 111
- Waukesha 109
- Fond du Lac 108
- Milwaukee 107
- Racine 107
- Sheboygan 107
- Winnebago 106
- Outagamie 104
- Wood 104
- Kenosha 103
- La Crosse 102
- Washington 102
- Brown 101
- Ozaukee 101
- Sauk 101
- Walworth 101
- Bayfield 100
- Calumet 100
- Columbia 100
- Eau Claire 100
- Jefferson 100
- Marathon 100
- Rock 100
- St. Croix 100
- Chippewa 99
- Douglas 99
- Dunn 99
- Green 99
- Dodge 96
- …
state 1
- Wisconsin · 6,529 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280719 | 280719 | 2020-06-27 | Jefferson | Wisconsin | 55055 | 222 | 4 |
280720 | 280720 | 2020-06-27 | Juneau | Wisconsin | 55057 | 32 | 1 |
280721 | 280721 | 2020-06-27 | Kenosha | Wisconsin | 55059 | 1468 | 43 |
280722 | 280722 | 2020-06-27 | Kewaunee | Wisconsin | 55061 | 54 | 1 |
280723 | 280723 | 2020-06-27 | La Crosse | Wisconsin | 55063 | 396 | 0 |
280724 | 280724 | 2020-06-27 | Lafayette | Wisconsin | 55065 | 68 | 0 |
280725 | 280725 | 2020-06-27 | Langlade | Wisconsin | 55067 | 7 | 0 |
280726 | 280726 | 2020-06-27 | Lincoln | Wisconsin | 55069 | 9 | 0 |
280727 | 280727 | 2020-06-27 | Manitowoc | Wisconsin | 55071 | 87 | 1 |
280728 | 280728 | 2020-06-27 | Marathon | Wisconsin | 55073 | 148 | 1 |
280729 | 280729 | 2020-06-27 | Marinette | Wisconsin | 55075 | 50 | 3 |
280730 | 280730 | 2020-06-27 | Marquette | Wisconsin | 55077 | 12 | 1 |
280731 | 280731 | 2020-06-27 | Menominee | Wisconsin | 55078 | 6 | 0 |
280732 | 280732 | 2020-06-27 | Milwaukee | Wisconsin | 55079 | 10983 | 389 |
280733 | 280733 | 2020-06-27 | Monroe | Wisconsin | 55081 | 61 | 1 |
280734 | 280734 | 2020-06-27 | Oconto | Wisconsin | 55083 | 53 | 0 |
280735 | 280735 | 2020-06-27 | Oneida | Wisconsin | 55085 | 19 | 0 |
280736 | 280736 | 2020-06-27 | Outagamie | Wisconsin | 55087 | 447 | 8 |
280737 | 280737 | 2020-06-27 | Ozaukee | Wisconsin | 55089 | 222 | 16 |
280738 | 280738 | 2020-06-27 | Pepin | Wisconsin | 55091 | 1 | 0 |
280739 | 280739 | 2020-06-27 | Pierce | Wisconsin | 55093 | 65 | 0 |
280740 | 280740 | 2020-06-27 | Polk | Wisconsin | 55095 | 43 | 1 |
280741 | 280741 | 2020-06-27 | Portage | Wisconsin | 55097 | 128 | 0 |
280742 | 280742 | 2020-06-27 | Price | Wisconsin | 55099 | 2 | 0 |
280743 | 280743 | 2020-06-27 | Racine | Wisconsin | 55101 | 2475 | 61 |
280744 | 280744 | 2020-06-27 | Richland | Wisconsin | 55103 | 15 | 4 |
280745 | 280745 | 2020-06-27 | Rock | Wisconsin | 55105 | 932 | 23 |
280746 | 280746 | 2020-06-27 | Rusk | Wisconsin | 55107 | 11 | 0 |
280747 | 280747 | 2020-06-27 | Sauk | Wisconsin | 55111 | 100 | 3 |
280748 | 280748 | 2020-06-27 | Sawyer | Wisconsin | 55113 | 12 | 0 |
280749 | 280749 | 2020-06-27 | Shawano | Wisconsin | 55115 | 75 | 0 |
280750 | 280750 | 2020-06-27 | Sheboygan | Wisconsin | 55117 | 195 | 4 |
280751 | 280751 | 2020-06-27 | St. Croix | Wisconsin | 55109 | 155 | 1 |
280752 | 280752 | 2020-06-27 | Taylor | Wisconsin | 55119 | 11 | 0 |
280753 | 280753 | 2020-06-27 | Trempealeau | Wisconsin | 55121 | 111 | 0 |
280754 | 280754 | 2020-06-27 | Unknown | Wisconsin | 2521 | 7 | |
280755 | 280755 | 2020-06-27 | Vernon | Wisconsin | 55123 | 32 | 0 |
280756 | 280756 | 2020-06-27 | Vilas | Wisconsin | 55125 | 10 | 0 |
280757 | 280757 | 2020-06-27 | Walworth | Wisconsin | 55127 | 570 | 18 |
280758 | 280758 | 2020-06-27 | Washburn | Wisconsin | 55129 | 4 | 0 |
280759 | 280759 | 2020-06-27 | Washington | Wisconsin | 55131 | 348 | 16 |
280760 | 280760 | 2020-06-27 | Waukesha | Wisconsin | 55133 | 1119 | 38 |
280761 | 280761 | 2020-06-27 | Waupaca | Wisconsin | 55135 | 106 | 6 |
280762 | 280762 | 2020-06-27 | Waushara | Wisconsin | 55137 | 21 | 0 |
280763 | 280763 | 2020-06-27 | Winnebago | Wisconsin | 55139 | 643 | 11 |
280764 | 280764 | 2020-06-27 | Wood | Wisconsin | 55141 | 42 | 1 |
277544 | 277544 | 2020-06-26 | Adams | Wisconsin | 55001 | 14 | 2 |
277545 | 277545 | 2020-06-26 | Ashland | Wisconsin | 55003 | 3 | 0 |
277546 | 277546 | 2020-06-26 | Barron | Wisconsin | 55005 | 32 | 0 |
277547 | 277547 | 2020-06-26 | Bayfield | Wisconsin | 55007 | 3 | 1 |
277548 | 277548 | 2020-06-26 | Brown | Wisconsin | 55009 | 2738 | 41 |
277549 | 277549 | 2020-06-26 | Buffalo | Wisconsin | 55011 | 7 | 2 |
277550 | 277550 | 2020-06-26 | Burnett | Wisconsin | 55013 | 2 | 1 |
277551 | 277551 | 2020-06-26 | Calumet | Wisconsin | 55015 | 96 | 2 |
277552 | 277552 | 2020-06-26 | Chippewa | Wisconsin | 55017 | 78 | 0 |
277553 | 277553 | 2020-06-26 | Clark | Wisconsin | 55019 | 67 | 6 |
277554 | 277554 | 2020-06-26 | Columbia | Wisconsin | 55021 | 76 | 1 |
277555 | 277555 | 2020-06-26 | Crawford | Wisconsin | 55023 | 32 | 0 |
277556 | 277556 | 2020-06-26 | Dane | Wisconsin | 55025 | 1446 | 32 |
277557 | 277557 | 2020-06-26 | Dodge | Wisconsin | 55027 | 447 | 5 |
277558 | 277558 | 2020-06-26 | Door | Wisconsin | 55029 | 43 | 3 |
277559 | 277559 | 2020-06-26 | Douglas | Wisconsin | 55031 | 22 | 0 |
277560 | 277560 | 2020-06-26 | Dunn | Wisconsin | 55033 | 34 | 0 |
277561 | 277561 | 2020-06-26 | Eau Claire | Wisconsin | 55035 | 180 | 1 |
277562 | 277562 | 2020-06-26 | Florence | Wisconsin | 55037 | 3 | 0 |
277563 | 277563 | 2020-06-26 | Fond du Lac | Wisconsin | 55039 | 306 | 6 |
277564 | 277564 | 2020-06-26 | Forest | Wisconsin | 55041 | 38 | 3 |
277565 | 277565 | 2020-06-26 | Grant | Wisconsin | 55043 | 141 | 12 |
277566 | 277566 | 2020-06-26 | Green | Wisconsin | 55045 | 84 | 1 |
277567 | 277567 | 2020-06-26 | Green Lake | Wisconsin | 55047 | 29 | 0 |
277568 | 277568 | 2020-06-26 | Iowa | Wisconsin | 55049 | 27 | 0 |
277569 | 277569 | 2020-06-26 | Iron | Wisconsin | 55051 | 3 | 1 |
277570 | 277570 | 2020-06-26 | Jackson | Wisconsin | 55053 | 26 | 1 |
277571 | 277571 | 2020-06-26 | Jefferson | Wisconsin | 55055 | 211 | 4 |
277572 | 277572 | 2020-06-26 | Juneau | Wisconsin | 55057 | 31 | 1 |
277573 | 277573 | 2020-06-26 | Kenosha | Wisconsin | 55059 | 1455 | 41 |
277574 | 277574 | 2020-06-26 | Kewaunee | Wisconsin | 55061 | 52 | 1 |
277575 | 277575 | 2020-06-26 | La Crosse | Wisconsin | 55063 | 371 | 0 |
277576 | 277576 | 2020-06-26 | Lafayette | Wisconsin | 55065 | 66 | 0 |
277577 | 277577 | 2020-06-26 | Langlade | Wisconsin | 55067 | 7 | 0 |
277578 | 277578 | 2020-06-26 | Lincoln | Wisconsin | 55069 | 9 | 0 |
277579 | 277579 | 2020-06-26 | Manitowoc | Wisconsin | 55071 | 83 | 1 |
277580 | 277580 | 2020-06-26 | Marathon | Wisconsin | 55073 | 140 | 1 |
277581 | 277581 | 2020-06-26 | Marinette | Wisconsin | 55075 | 49 | 3 |
277582 | 277582 | 2020-06-26 | Marquette | Wisconsin | 55077 | 12 | 1 |
277583 | 277583 | 2020-06-26 | Menominee | Wisconsin | 55078 | 5 | 0 |
277584 | 277584 | 2020-06-26 | Milwaukee | Wisconsin | 55079 | 10818 | 382 |
277585 | 277585 | 2020-06-26 | Monroe | Wisconsin | 55081 | 59 | 1 |
277586 | 277586 | 2020-06-26 | Oconto | Wisconsin | 55083 | 52 | 0 |
277587 | 277587 | 2020-06-26 | Oneida | Wisconsin | 55085 | 18 | 0 |
277588 | 277588 | 2020-06-26 | Outagamie | Wisconsin | 55087 | 436 | 8 |
277589 | 277589 | 2020-06-26 | Ozaukee | Wisconsin | 55089 | 222 | 16 |
277590 | 277590 | 2020-06-26 | Pepin | Wisconsin | 55091 | 1 | 0 |
277591 | 277591 | 2020-06-26 | Pierce | Wisconsin | 55093 | 64 | 0 |
277592 | 277592 | 2020-06-26 | Polk | Wisconsin | 55095 | 43 | 1 |
277593 | 277593 | 2020-06-26 | Portage | Wisconsin | 55097 | 117 | 0 |
277594 | 277594 | 2020-06-26 | Price | Wisconsin | 55099 | 2 | 0 |
277595 | 277595 | 2020-06-26 | Racine | Wisconsin | 55101 | 2471 | 61 |
277596 | 277596 | 2020-06-26 | Richland | Wisconsin | 55103 | 15 | 4 |
277597 | 277597 | 2020-06-26 | Rock | Wisconsin | 55105 | 932 | 23 |
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);