ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where "date" is on date 2020-04-30 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
103784 | 103784 | 2020-04-30 | Adams | Wisconsin | 55001 | 4 | 1 |
103785 | 103785 | 2020-04-30 | Ashland | Wisconsin | 55003 | 2 | 0 |
103786 | 103786 | 2020-04-30 | Barron | Wisconsin | 55005 | 6 | 0 |
103787 | 103787 | 2020-04-30 | Bayfield | Wisconsin | 55007 | 3 | 1 |
103788 | 103788 | 2020-04-30 | Brown | Wisconsin | 55009 | 1057 | 3 |
103789 | 103789 | 2020-04-30 | Buffalo | Wisconsin | 55011 | 4 | 1 |
103790 | 103790 | 2020-04-30 | Calumet | Wisconsin | 55015 | 13 | 0 |
103791 | 103791 | 2020-04-30 | Chippewa | Wisconsin | 55017 | 22 | 0 |
103792 | 103792 | 2020-04-30 | Clark | Wisconsin | 55019 | 20 | 4 |
103793 | 103793 | 2020-04-30 | Columbia | Wisconsin | 55021 | 27 | 1 |
103794 | 103794 | 2020-04-30 | Crawford | Wisconsin | 55023 | 3 | 0 |
103795 | 103795 | 2020-04-30 | Dane | Wisconsin | 55025 | 428 | 22 |
103796 | 103796 | 2020-04-30 | Dodge | Wisconsin | 55027 | 33 | 1 |
103797 | 103797 | 2020-04-30 | Door | Wisconsin | 55029 | 12 | 2 |
103798 | 103798 | 2020-04-30 | Douglas | Wisconsin | 55031 | 9 | 0 |
103799 | 103799 | 2020-04-30 | Dunn | Wisconsin | 55033 | 9 | 0 |
103800 | 103800 | 2020-04-30 | Eau Claire | Wisconsin | 55035 | 28 | 0 |
103801 | 103801 | 2020-04-30 | Florence | Wisconsin | 55037 | 2 | 0 |
103802 | 103802 | 2020-04-30 | Fond du Lac | Wisconsin | 55039 | 69 | 3 |
103803 | 103803 | 2020-04-30 | Grant | Wisconsin | 55043 | 37 | 6 |
103804 | 103804 | 2020-04-30 | Green | Wisconsin | 55045 | 12 | 0 |
103805 | 103805 | 2020-04-30 | Green Lake | Wisconsin | 55047 | 2 | 0 |
103806 | 103806 | 2020-04-30 | Iowa | Wisconsin | 55049 | 7 | 0 |
103807 | 103807 | 2020-04-30 | Iron | Wisconsin | 55051 | 2 | 1 |
103808 | 103808 | 2020-04-30 | Jackson | Wisconsin | 55053 | 12 | 1 |
103809 | 103809 | 2020-04-30 | Jefferson | Wisconsin | 55055 | 45 | 0 |
103810 | 103810 | 2020-04-30 | Juneau | Wisconsin | 55057 | 17 | 1 |
103811 | 103811 | 2020-04-30 | Kenosha | Wisconsin | 55059 | 391 | 12 |
103812 | 103812 | 2020-04-30 | Kewaunee | Wisconsin | 55061 | 14 | 1 |
103813 | 103813 | 2020-04-30 | La Crosse | Wisconsin | 55063 | 28 | 0 |
103814 | 103814 | 2020-04-30 | Lafayette | Wisconsin | 55065 | 4 | 0 |
103815 | 103815 | 2020-04-30 | Manitowoc | Wisconsin | 55071 | 11 | 1 |
103816 | 103816 | 2020-04-30 | Marathon | Wisconsin | 55073 | 18 | 1 |
103817 | 103817 | 2020-04-30 | Marinette | Wisconsin | 55075 | 8 | 1 |
103818 | 103818 | 2020-04-30 | Marquette | Wisconsin | 55077 | 3 | 1 |
103819 | 103819 | 2020-04-30 | Menominee | Wisconsin | 55078 | 1 | 0 |
103820 | 103820 | 2020-04-30 | Milwaukee | Wisconsin | 55079 | 2940 | 181 |
103821 | 103821 | 2020-04-30 | Monroe | Wisconsin | 55081 | 14 | 1 |
103822 | 103822 | 2020-04-30 | Oconto | Wisconsin | 55083 | 10 | 0 |
103823 | 103823 | 2020-04-30 | Oneida | Wisconsin | 55085 | 6 | 0 |
103824 | 103824 | 2020-04-30 | Outagamie | Wisconsin | 55087 | 54 | 2 |
103825 | 103825 | 2020-04-30 | Ozaukee | Wisconsin | 55089 | 88 | 9 |
103826 | 103826 | 2020-04-30 | Pierce | Wisconsin | 55093 | 10 | 0 |
103827 | 103827 | 2020-04-30 | Polk | Wisconsin | 55095 | 4 | 0 |
103828 | 103828 | 2020-04-30 | Portage | Wisconsin | 55097 | 5 | 0 |
103829 | 103829 | 2020-04-30 | Price | Wisconsin | 55099 | 1 | 0 |
103830 | 103830 | 2020-04-30 | Racine | Wisconsin | 55101 | 474 | 12 |
103831 | 103831 | 2020-04-30 | Richland | Wisconsin | 55103 | 12 | 2 |
103832 | 103832 | 2020-04-30 | Rock | Wisconsin | 55105 | 198 | 6 |
103833 | 103833 | 2020-04-30 | Rusk | Wisconsin | 55107 | 4 | 0 |
103834 | 103834 | 2020-04-30 | Sauk | Wisconsin | 55111 | 45 | 3 |
103835 | 103835 | 2020-04-30 | Sawyer | Wisconsin | 55113 | 3 | 0 |
103836 | 103836 | 2020-04-30 | Shawano | Wisconsin | 55115 | 10 | 0 |
103837 | 103837 | 2020-04-30 | Sheboygan | Wisconsin | 55117 | 47 | 2 |
103838 | 103838 | 2020-04-30 | St. Croix | Wisconsin | 55109 | 16 | 0 |
103839 | 103839 | 2020-04-30 | Trempealeau | Wisconsin | 55121 | 3 | 0 |
103840 | 103840 | 2020-04-30 | Vernon | Wisconsin | 55123 | 1 | 0 |
103841 | 103841 | 2020-04-30 | Vilas | Wisconsin | 55125 | 4 | 0 |
103842 | 103842 | 2020-04-30 | Walworth | Wisconsin | 55127 | 161 | 8 |
103843 | 103843 | 2020-04-30 | Washburn | Wisconsin | 55129 | 1 | 0 |
103844 | 103844 | 2020-04-30 | Washington | Wisconsin | 55131 | 98 | 4 |
103845 | 103845 | 2020-04-30 | Waukesha | Wisconsin | 55133 | 336 | 19 |
103846 | 103846 | 2020-04-30 | Waupaca | Wisconsin | 55135 | 8 | 1 |
103847 | 103847 | 2020-04-30 | Waushara | Wisconsin | 55137 | 2 | 0 |
103848 | 103848 | 2020-04-30 | Winnebago | Wisconsin | 55139 | 53 | 1 |
103849 | 103849 | 2020-04-30 | 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);