ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where "date" is on date 2020-06-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 |
---|---|---|---|---|---|---|---|
258737 | 258737 | 2020-06-20 | Adams | Wisconsin | 55001 | 10 | 2 |
258738 | 258738 | 2020-06-20 | Ashland | Wisconsin | 55003 | 3 | 0 |
258739 | 258739 | 2020-06-20 | Barron | Wisconsin | 55005 | 31 | 0 |
258740 | 258740 | 2020-06-20 | Bayfield | Wisconsin | 55007 | 3 | 1 |
258741 | 258741 | 2020-06-20 | Brown | Wisconsin | 55009 | 2572 | 39 |
258742 | 258742 | 2020-06-20 | Buffalo | Wisconsin | 55011 | 6 | 2 |
258743 | 258743 | 2020-06-20 | Burnett | Wisconsin | 55013 | 2 | 1 |
258744 | 258744 | 2020-06-20 | Calumet | Wisconsin | 55015 | 90 | 2 |
258745 | 258745 | 2020-06-20 | Chippewa | Wisconsin | 55017 | 67 | 0 |
258746 | 258746 | 2020-06-20 | Clark | Wisconsin | 55019 | 58 | 6 |
258747 | 258747 | 2020-06-20 | Columbia | Wisconsin | 55021 | 64 | 1 |
258748 | 258748 | 2020-06-20 | Crawford | Wisconsin | 55023 | 29 | 0 |
258749 | 258749 | 2020-06-20 | Dane | Wisconsin | 55025 | 1069 | 32 |
258750 | 258750 | 2020-06-20 | Dodge | Wisconsin | 55027 | 434 | 5 |
258751 | 258751 | 2020-06-20 | Door | Wisconsin | 55029 | 40 | 3 |
258752 | 258752 | 2020-06-20 | Douglas | Wisconsin | 55031 | 20 | 0 |
258753 | 258753 | 2020-06-20 | Dunn | Wisconsin | 55033 | 29 | 0 |
258754 | 258754 | 2020-06-20 | Eau Claire | Wisconsin | 55035 | 156 | 0 |
258755 | 258755 | 2020-06-20 | Florence | Wisconsin | 55037 | 2 | 0 |
258756 | 258756 | 2020-06-20 | Fond du Lac | Wisconsin | 55039 | 286 | 6 |
258757 | 258757 | 2020-06-20 | Forest | Wisconsin | 55041 | 35 | 3 |
258758 | 258758 | 2020-06-20 | Grant | Wisconsin | 55043 | 124 | 12 |
258759 | 258759 | 2020-06-20 | Green | Wisconsin | 55045 | 79 | 1 |
258760 | 258760 | 2020-06-20 | Green Lake | Wisconsin | 55047 | 24 | 0 |
258761 | 258761 | 2020-06-20 | Iowa | Wisconsin | 55049 | 19 | 0 |
258762 | 258762 | 2020-06-20 | Iron | Wisconsin | 55051 | 2 | 1 |
258763 | 258763 | 2020-06-20 | Jackson | Wisconsin | 55053 | 24 | 1 |
258764 | 258764 | 2020-06-20 | Jefferson | Wisconsin | 55055 | 172 | 4 |
258765 | 258765 | 2020-06-20 | Juneau | Wisconsin | 55057 | 27 | 1 |
258766 | 258766 | 2020-06-20 | Kenosha | Wisconsin | 55059 | 1406 | 39 |
258767 | 258767 | 2020-06-20 | Kewaunee | Wisconsin | 55061 | 43 | 1 |
258768 | 258768 | 2020-06-20 | La Crosse | Wisconsin | 55063 | 229 | 0 |
258769 | 258769 | 2020-06-20 | Lafayette | Wisconsin | 55065 | 53 | 0 |
258770 | 258770 | 2020-06-20 | Langlade | Wisconsin | 55067 | 7 | 0 |
258771 | 258771 | 2020-06-20 | Lincoln | Wisconsin | 55069 | 8 | 0 |
258772 | 258772 | 2020-06-20 | Manitowoc | Wisconsin | 55071 | 63 | 1 |
258773 | 258773 | 2020-06-20 | Marathon | Wisconsin | 55073 | 107 | 1 |
258774 | 258774 | 2020-06-20 | Marinette | Wisconsin | 55075 | 42 | 3 |
258775 | 258775 | 2020-06-20 | Marquette | Wisconsin | 55077 | 9 | 1 |
258776 | 258776 | 2020-06-20 | Menominee | Wisconsin | 55078 | 4 | 0 |
258777 | 258777 | 2020-06-20 | Milwaukee | Wisconsin | 55079 | 10167 | 371 |
258778 | 258778 | 2020-06-20 | Monroe | Wisconsin | 55081 | 45 | 1 |
258779 | 258779 | 2020-06-20 | Oconto | Wisconsin | 55083 | 46 | 0 |
258780 | 258780 | 2020-06-20 | Oneida | Wisconsin | 55085 | 17 | 0 |
258781 | 258781 | 2020-06-20 | Outagamie | Wisconsin | 55087 | 387 | 8 |
258782 | 258782 | 2020-06-20 | Ozaukee | Wisconsin | 55089 | 213 | 15 |
258783 | 258783 | 2020-06-20 | Pepin | Wisconsin | 55091 | 1 | 0 |
258784 | 258784 | 2020-06-20 | Pierce | Wisconsin | 55093 | 57 | 0 |
258785 | 258785 | 2020-06-20 | Polk | Wisconsin | 55095 | 40 | 1 |
258786 | 258786 | 2020-06-20 | Portage | Wisconsin | 55097 | 90 | 0 |
258787 | 258787 | 2020-06-20 | Price | Wisconsin | 55099 | 2 | 0 |
258788 | 258788 | 2020-06-20 | Racine | Wisconsin | 55101 | 2407 | 58 |
258789 | 258789 | 2020-06-20 | Richland | Wisconsin | 55103 | 15 | 4 |
258790 | 258790 | 2020-06-20 | Rock | Wisconsin | 55105 | 881 | 23 |
258791 | 258791 | 2020-06-20 | Rusk | Wisconsin | 55107 | 11 | 0 |
258792 | 258792 | 2020-06-20 | Sauk | Wisconsin | 55111 | 94 | 3 |
258793 | 258793 | 2020-06-20 | Sawyer | Wisconsin | 55113 | 9 | 0 |
258794 | 258794 | 2020-06-20 | Shawano | Wisconsin | 55115 | 68 | 0 |
258795 | 258795 | 2020-06-20 | Sheboygan | Wisconsin | 55117 | 179 | 4 |
258796 | 258796 | 2020-06-20 | St. Croix | Wisconsin | 55109 | 126 | 1 |
258797 | 258797 | 2020-06-20 | Taylor | Wisconsin | 55119 | 9 | 0 |
258798 | 258798 | 2020-06-20 | Trempealeau | Wisconsin | 55121 | 91 | 0 |
258799 | 258799 | 2020-06-20 | Unknown | Wisconsin | 2329 | 7 | |
258800 | 258800 | 2020-06-20 | Vernon | Wisconsin | 55123 | 29 | 0 |
258801 | 258801 | 2020-06-20 | Vilas | Wisconsin | 55125 | 10 | 0 |
258802 | 258802 | 2020-06-20 | Walworth | Wisconsin | 55127 | 497 | 18 |
258803 | 258803 | 2020-06-20 | Washburn | Wisconsin | 55129 | 4 | 0 |
258804 | 258804 | 2020-06-20 | Washington | Wisconsin | 55131 | 318 | 13 |
258805 | 258805 | 2020-06-20 | Waukesha | Wisconsin | 55133 | 991 | 38 |
258806 | 258806 | 2020-06-20 | Waupaca | Wisconsin | 55135 | 89 | 5 |
258807 | 258807 | 2020-06-20 | Waushara | Wisconsin | 55137 | 20 | 0 |
258808 | 258808 | 2020-06-20 | Winnebago | Wisconsin | 55139 | 593 | 11 |
258809 | 258809 | 2020-06-20 | Wood | Wisconsin | 55141 | 31 | 1 |
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);