ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2022-04-27" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450625 | 2450625 | 2022-04-27 | Adams | Wisconsin | 55001 | 4654 | 61 |
2450626 | 2450626 | 2022-04-27 | Ashland | Wisconsin | 55003 | 3310 | 36 |
2450627 | 2450627 | 2022-04-27 | Barron | Wisconsin | 55005 | 13577 | 143 |
2450628 | 2450628 | 2022-04-27 | Bayfield | Wisconsin | 55007 | 3348 | 40 |
2450629 | 2450629 | 2022-04-27 | Brown | Wisconsin | 55009 | 84560 | 552 |
2450630 | 2450630 | 2022-04-27 | Buffalo | Wisconsin | 55011 | 3547 | 12 |
2450631 | 2450631 | 2022-04-27 | Burnett | Wisconsin | 55013 | 4004 | 43 |
2450632 | 2450632 | 2022-04-27 | Calumet | Wisconsin | 55015 | 14582 | 121 |
2450633 | 2450633 | 2022-04-27 | Chippewa | Wisconsin | 55017 | 18819 | 183 |
2450634 | 2450634 | 2022-04-27 | Clark | Wisconsin | 55019 | 7635 | 122 |
2450635 | 2450635 | 2022-04-27 | Columbia | Wisconsin | 55021 | 15435 | 127 |
2450636 | 2450636 | 2022-04-27 | Crawford | Wisconsin | 55023 | 4250 | 28 |
2450637 | 2450637 | 2022-04-27 | Dane | Wisconsin | 55025 | 128805 | 509 |
2450638 | 2450638 | 2022-04-27 | Dodge | Wisconsin | 55027 | 27298 | 339 |
2450639 | 2450639 | 2022-04-27 | Door | Wisconsin | 55029 | 6984 | 71 |
2450640 | 2450640 | 2022-04-27 | Douglas | Wisconsin | 55031 | 11721 | 79 |
2450641 | 2450641 | 2022-04-27 | Dunn | Wisconsin | 55033 | 13377 | 75 |
2450642 | 2450642 | 2022-04-27 | Eau Claire | Wisconsin | 55035 | 30551 | 185 |
2450643 | 2450643 | 2022-04-27 | Florence | Wisconsin | 55037 | 1085 | 16 |
2450644 | 2450644 | 2022-04-27 | Fond du Lac | Wisconsin | 55039 | 31995 | 273 |
2450645 | 2450645 | 2022-04-27 | Forest | Wisconsin | 55041 | 2680 | 52 |
2450646 | 2450646 | 2022-04-27 | Grant | Wisconsin | 55043 | 12768 | 145 |
2450647 | 2450647 | 2022-04-27 | Green | Wisconsin | 55045 | 9309 | 53 |
2450648 | 2450648 | 2022-04-27 | Green Lake | Wisconsin | 55047 | 5171 | 63 |
2450649 | 2450649 | 2022-04-27 | Iowa | Wisconsin | 55049 | 5299 | 28 |
2450650 | 2450650 | 2022-04-27 | Iron | Wisconsin | 55051 | 1471 | 47 |
2450651 | 2450651 | 2022-04-27 | Jackson | Wisconsin | 55053 | 5678 | 43 |
2450652 | 2450652 | 2022-04-27 | Jefferson | Wisconsin | 55055 | 21695 | 241 |
2450653 | 2450653 | 2022-04-27 | Juneau | Wisconsin | 55057 | 7732 | 68 |
2450654 | 2450654 | 2022-04-27 | Kenosha | Wisconsin | 55059 | 44506 | 627 |
2450655 | 2450655 | 2022-04-27 | Kewaunee | Wisconsin | 55061 | 5856 | 59 |
2450656 | 2450656 | 2022-04-27 | La Crosse | Wisconsin | 55063 | 35206 | 182 |
2450657 | 2450657 | 2022-04-27 | Lafayette | Wisconsin | 55065 | 3682 | 24 |
2450658 | 2450658 | 2022-04-27 | Langlade | Wisconsin | 55067 | 5215 | 90 |
2450659 | 2450659 | 2022-04-27 | Lincoln | Wisconsin | 55069 | 7057 | 148 |
2450660 | 2450660 | 2022-04-27 | Manitowoc | Wisconsin | 55071 | 20555 | 187 |
2450661 | 2450661 | 2022-04-27 | Marathon | Wisconsin | 55073 | 39499 | 490 |
2450662 | 2450662 | 2022-04-27 | Marinette | Wisconsin | 55075 | 11641 | 124 |
2450663 | 2450663 | 2022-04-27 | Marquette | Wisconsin | 55077 | 3827 | 61 |
2450664 | 2450664 | 2022-04-27 | Menominee | Wisconsin | 55078 | 1900 | 14 |
2450665 | 2450665 | 2022-04-27 | Milwaukee | Wisconsin | 55079 | 271883 | 2286 |
2450666 | 2450666 | 2022-04-27 | Monroe | Wisconsin | 55081 | 12100 | 89 |
2450667 | 2450667 | 2022-04-27 | Oconto | Wisconsin | 55083 | 11433 | 119 |
2450668 | 2450668 | 2022-04-27 | Oneida | Wisconsin | 55085 | 8520 | 138 |
2450669 | 2450669 | 2022-04-27 | Outagamie | Wisconsin | 55087 | 54708 | 405 |
2450670 | 2450670 | 2022-04-27 | Ozaukee | Wisconsin | 55089 | 22536 | 186 |
2450671 | 2450671 | 2022-04-27 | Pepin | Wisconsin | 55091 | 1977 | 18 |
2450672 | 2450672 | 2022-04-27 | Pierce | Wisconsin | 55093 | 11646 | 73 |
2450673 | 2450673 | 2022-04-27 | Polk | Wisconsin | 55095 | 12475 | 122 |
2450674 | 2450674 | 2022-04-27 | Portage | Wisconsin | 55097 | 18154 | 160 |
2450675 | 2450675 | 2022-04-27 | Price | Wisconsin | 55099 | 3257 | 33 |
2450676 | 2450676 | 2022-04-27 | Racine | Wisconsin | 55101 | 56735 | 688 |
2450677 | 2450677 | 2022-04-27 | Richland | Wisconsin | 55103 | 3905 | 48 |
2450678 | 2450678 | 2022-04-27 | Rock | Wisconsin | 55105 | 43409 | 391 |
2450679 | 2450679 | 2022-04-27 | Rusk | Wisconsin | 55107 | 3430 | 55 |
2450680 | 2450680 | 2022-04-27 | Sauk | Wisconsin | 55111 | 16063 | 133 |
2450681 | 2450681 | 2022-04-27 | Sawyer | Wisconsin | 55113 | 4574 | 62 |
2450682 | 2450682 | 2022-04-27 | Shawano | Wisconsin | 55115 | 11689 | 150 |
2450683 | 2450683 | 2022-04-27 | Sheboygan | Wisconsin | 55117 | 32690 | 318 |
2450684 | 2450684 | 2022-04-27 | St. Croix | Wisconsin | 55109 | 25013 | 148 |
2450685 | 2450685 | 2022-04-27 | Taylor | Wisconsin | 55119 | 4842 | 72 |
2450686 | 2450686 | 2022-04-27 | Trempealeau | Wisconsin | 55121 | 8438 | 64 |
2450687 | 2450687 | 2022-04-27 | Vernon | Wisconsin | 55123 | 6096 | 97 |
2450688 | 2450688 | 2022-04-27 | Vilas | Wisconsin | 55125 | 5228 | 89 |
2450689 | 2450689 | 2022-04-27 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2450690 | 2450690 | 2022-04-27 | Washburn | Wisconsin | 55129 | 4021 | 46 |
2450691 | 2450691 | 2022-04-27 | Washington | Wisconsin | 55131 | 38325 | 341 |
2450692 | 2450692 | 2022-04-27 | Waukesha | Wisconsin | 55133 | 113566 | 1091 |
2450693 | 2450693 | 2022-04-27 | Waupaca | Wisconsin | 55135 | 13661 | 251 |
2450694 | 2450694 | 2022-04-27 | Waushara | Wisconsin | 55137 | 6427 | 87 |
2450695 | 2450695 | 2022-04-27 | Winnebago | Wisconsin | 55139 | 52109 | 380 |
2450696 | 2450696 | 2022-04-27 | Wood | Wisconsin | 55141 | 21079 | 230 |
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);