ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where "date" is on date 2020-04-20 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
75586 | 75586 | 2020-04-20 | Adams | Wisconsin | 55001 | 4 | 1 |
75587 | 75587 | 2020-04-20 | Ashland | Wisconsin | 55003 | 2 | 0 |
75588 | 75588 | 2020-04-20 | Barron | Wisconsin | 55005 | 6 | 0 |
75589 | 75589 | 2020-04-20 | Bayfield | Wisconsin | 55007 | 3 | 1 |
75590 | 75590 | 2020-04-20 | Brown | Wisconsin | 55009 | 285 | 1 |
75591 | 75591 | 2020-04-20 | Buffalo | Wisconsin | 55011 | 4 | 1 |
75592 | 75592 | 2020-04-20 | Calumet | Wisconsin | 55015 | 6 | 0 |
75593 | 75593 | 2020-04-20 | Chippewa | Wisconsin | 55017 | 20 | 0 |
75594 | 75594 | 2020-04-20 | Clark | Wisconsin | 55019 | 16 | 1 |
75595 | 75595 | 2020-04-20 | Columbia | Wisconsin | 55021 | 27 | 1 |
75596 | 75596 | 2020-04-20 | Crawford | Wisconsin | 55023 | 3 | 0 |
75597 | 75597 | 2020-04-20 | Dane | Wisconsin | 55025 | 364 | 20 |
75598 | 75598 | 2020-04-20 | Dodge | Wisconsin | 55027 | 19 | 1 |
75599 | 75599 | 2020-04-20 | Door | Wisconsin | 55029 | 9 | 1 |
75600 | 75600 | 2020-04-20 | Douglas | Wisconsin | 55031 | 8 | 0 |
75601 | 75601 | 2020-04-20 | Dunn | Wisconsin | 55033 | 9 | 0 |
75602 | 75602 | 2020-04-20 | Eau Claire | Wisconsin | 55035 | 22 | 0 |
75603 | 75603 | 2020-04-20 | Florence | Wisconsin | 55037 | 2 | 0 |
75604 | 75604 | 2020-04-20 | Fond du Lac | Wisconsin | 55039 | 65 | 3 |
75605 | 75605 | 2020-04-20 | Grant | Wisconsin | 55043 | 23 | 3 |
75606 | 75606 | 2020-04-20 | Green | Wisconsin | 55045 | 9 | 0 |
75607 | 75607 | 2020-04-20 | Green Lake | Wisconsin | 55047 | 1 | 0 |
75608 | 75608 | 2020-04-20 | Iowa | Wisconsin | 55049 | 6 | 0 |
75609 | 75609 | 2020-04-20 | Iron | Wisconsin | 55051 | 2 | 1 |
75610 | 75610 | 2020-04-20 | Jackson | Wisconsin | 55053 | 12 | 1 |
75611 | 75611 | 2020-04-20 | Jefferson | Wisconsin | 55055 | 32 | 0 |
75612 | 75612 | 2020-04-20 | Juneau | Wisconsin | 55057 | 10 | 1 |
75613 | 75613 | 2020-04-20 | Kenosha | Wisconsin | 55059 | 257 | 5 |
75614 | 75614 | 2020-04-20 | Kewaunee | Wisconsin | 55061 | 8 | 1 |
75615 | 75615 | 2020-04-20 | La Crosse | Wisconsin | 55063 | 25 | 0 |
75616 | 75616 | 2020-04-20 | Lafayette | Wisconsin | 55065 | 3 | 0 |
75617 | 75617 | 2020-04-20 | Manitowoc | Wisconsin | 55071 | 7 | 0 |
75618 | 75618 | 2020-04-20 | Marathon | Wisconsin | 55073 | 17 | 1 |
75619 | 75619 | 2020-04-20 | Marinette | Wisconsin | 55075 | 5 | 1 |
75620 | 75620 | 2020-04-20 | Marquette | Wisconsin | 55077 | 3 | 1 |
75621 | 75621 | 2020-04-20 | Menominee | Wisconsin | 55078 | 1 | 0 |
75622 | 75622 | 2020-04-20 | Milwaukee | Wisconsin | 55079 | 2191 | 132 |
75623 | 75623 | 2020-04-20 | Monroe | Wisconsin | 55081 | 13 | 0 |
75624 | 75624 | 2020-04-20 | Oconto | Wisconsin | 55083 | 5 | 0 |
75625 | 75625 | 2020-04-20 | Oneida | Wisconsin | 55085 | 6 | 0 |
75626 | 75626 | 2020-04-20 | Outagamie | Wisconsin | 55087 | 35 | 2 |
75627 | 75627 | 2020-04-20 | Ozaukee | Wisconsin | 55089 | 80 | 9 |
75628 | 75628 | 2020-04-20 | Pierce | Wisconsin | 55093 | 7 | 0 |
75629 | 75629 | 2020-04-20 | Polk | Wisconsin | 55095 | 4 | 0 |
75630 | 75630 | 2020-04-20 | Portage | Wisconsin | 55097 | 4 | 0 |
75631 | 75631 | 2020-04-20 | Price | Wisconsin | 55099 | 1 | 0 |
75632 | 75632 | 2020-04-20 | Racine | Wisconsin | 55101 | 239 | 10 |
75633 | 75633 | 2020-04-20 | Richland | Wisconsin | 55103 | 8 | 1 |
75634 | 75634 | 2020-04-20 | Rock | Wisconsin | 55105 | 80 | 4 |
75635 | 75635 | 2020-04-20 | Rusk | Wisconsin | 55107 | 4 | 0 |
75636 | 75636 | 2020-04-20 | Sauk | Wisconsin | 55111 | 34 | 3 |
75637 | 75637 | 2020-04-20 | Sawyer | Wisconsin | 55113 | 2 | 0 |
75638 | 75638 | 2020-04-20 | Shawano | Wisconsin | 55115 | 6 | 0 |
75639 | 75639 | 2020-04-20 | Sheboygan | Wisconsin | 55117 | 43 | 2 |
75640 | 75640 | 2020-04-20 | St. Croix | Wisconsin | 55109 | 11 | 0 |
75641 | 75641 | 2020-04-20 | Trempealeau | Wisconsin | 55121 | 1 | 0 |
75642 | 75642 | 2020-04-20 | Vilas | Wisconsin | 55125 | 4 | 0 |
75643 | 75643 | 2020-04-20 | Walworth | Wisconsin | 55127 | 86 | 6 |
75644 | 75644 | 2020-04-20 | Washburn | Wisconsin | 55129 | 1 | 0 |
75645 | 75645 | 2020-04-20 | Washington | Wisconsin | 55131 | 86 | 3 |
75646 | 75646 | 2020-04-20 | Waukesha | Wisconsin | 55133 | 269 | 11 |
75647 | 75647 | 2020-04-20 | Waupaca | Wisconsin | 55135 | 4 | 1 |
75648 | 75648 | 2020-04-20 | Waushara | Wisconsin | 55137 | 2 | 0 |
75649 | 75649 | 2020-04-20 | Winnebago | Wisconsin | 55139 | 41 | 1 |
75650 | 75650 | 2020-04-20 | Wood | Wisconsin | 55141 | 2 | 0 |
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);