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-19 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
72810 | 72810 | 2020-04-19 | Adams | Wisconsin | 55001 | 4 | 1 |
72811 | 72811 | 2020-04-19 | Ashland | Wisconsin | 55003 | 2 | 0 |
72812 | 72812 | 2020-04-19 | Barron | Wisconsin | 55005 | 6 | 0 |
72813 | 72813 | 2020-04-19 | Bayfield | Wisconsin | 55007 | 3 | 1 |
72814 | 72814 | 2020-04-19 | Brown | Wisconsin | 55009 | 215 | 1 |
72815 | 72815 | 2020-04-19 | Buffalo | Wisconsin | 55011 | 4 | 1 |
72816 | 72816 | 2020-04-19 | Calumet | Wisconsin | 55015 | 6 | 0 |
72817 | 72817 | 2020-04-19 | Chippewa | Wisconsin | 55017 | 20 | 0 |
72818 | 72818 | 2020-04-19 | Clark | Wisconsin | 55019 | 16 | 1 |
72819 | 72819 | 2020-04-19 | Columbia | Wisconsin | 55021 | 27 | 1 |
72820 | 72820 | 2020-04-19 | Crawford | Wisconsin | 55023 | 3 | 0 |
72821 | 72821 | 2020-04-19 | Dane | Wisconsin | 55025 | 361 | 20 |
72822 | 72822 | 2020-04-19 | Dodge | Wisconsin | 55027 | 19 | 1 |
72823 | 72823 | 2020-04-19 | Door | Wisconsin | 55029 | 9 | 1 |
72824 | 72824 | 2020-04-19 | Douglas | Wisconsin | 55031 | 8 | 0 |
72825 | 72825 | 2020-04-19 | Dunn | Wisconsin | 55033 | 9 | 0 |
72826 | 72826 | 2020-04-19 | Eau Claire | Wisconsin | 55035 | 22 | 0 |
72827 | 72827 | 2020-04-19 | Florence | Wisconsin | 55037 | 2 | 0 |
72828 | 72828 | 2020-04-19 | Fond du Lac | Wisconsin | 55039 | 62 | 3 |
72829 | 72829 | 2020-04-19 | Grant | Wisconsin | 55043 | 18 | 2 |
72830 | 72830 | 2020-04-19 | Green | Wisconsin | 55045 | 9 | 0 |
72831 | 72831 | 2020-04-19 | Green Lake | Wisconsin | 55047 | 1 | 0 |
72832 | 72832 | 2020-04-19 | Iowa | Wisconsin | 55049 | 6 | 0 |
72833 | 72833 | 2020-04-19 | Iron | Wisconsin | 55051 | 2 | 1 |
72834 | 72834 | 2020-04-19 | Jackson | Wisconsin | 55053 | 12 | 1 |
72835 | 72835 | 2020-04-19 | Jefferson | Wisconsin | 55055 | 32 | 0 |
72836 | 72836 | 2020-04-19 | Juneau | Wisconsin | 55057 | 10 | 1 |
72837 | 72837 | 2020-04-19 | Kenosha | Wisconsin | 55059 | 248 | 5 |
72838 | 72838 | 2020-04-19 | Kewaunee | Wisconsin | 55061 | 8 | 1 |
72839 | 72839 | 2020-04-19 | La Crosse | Wisconsin | 55063 | 25 | 0 |
72840 | 72840 | 2020-04-19 | Lafayette | Wisconsin | 55065 | 3 | 0 |
72841 | 72841 | 2020-04-19 | Manitowoc | Wisconsin | 55071 | 6 | 0 |
72842 | 72842 | 2020-04-19 | Marathon | Wisconsin | 55073 | 17 | 1 |
72843 | 72843 | 2020-04-19 | Marinette | Wisconsin | 55075 | 5 | 1 |
72844 | 72844 | 2020-04-19 | Marquette | Wisconsin | 55077 | 3 | 1 |
72845 | 72845 | 2020-04-19 | Menominee | Wisconsin | 55078 | 1 | 0 |
72846 | 72846 | 2020-04-19 | Milwaukee | Wisconsin | 55079 | 2150 | 125 |
72847 | 72847 | 2020-04-19 | Monroe | Wisconsin | 55081 | 13 | 0 |
72848 | 72848 | 2020-04-19 | Oconto | Wisconsin | 55083 | 4 | 0 |
72849 | 72849 | 2020-04-19 | Oneida | Wisconsin | 55085 | 6 | 0 |
72850 | 72850 | 2020-04-19 | Outagamie | Wisconsin | 55087 | 35 | 2 |
72851 | 72851 | 2020-04-19 | Ozaukee | Wisconsin | 55089 | 79 | 9 |
72852 | 72852 | 2020-04-19 | Pierce | Wisconsin | 55093 | 7 | 0 |
72853 | 72853 | 2020-04-19 | Polk | Wisconsin | 55095 | 4 | 0 |
72854 | 72854 | 2020-04-19 | Portage | Wisconsin | 55097 | 4 | 0 |
72855 | 72855 | 2020-04-19 | Price | Wisconsin | 55099 | 1 | 0 |
72856 | 72856 | 2020-04-19 | Racine | Wisconsin | 55101 | 168 | 9 |
72857 | 72857 | 2020-04-19 | Richland | Wisconsin | 55103 | 8 | 1 |
72858 | 72858 | 2020-04-19 | Rock | Wisconsin | 55105 | 74 | 4 |
72859 | 72859 | 2020-04-19 | Rusk | Wisconsin | 55107 | 4 | 0 |
72860 | 72860 | 2020-04-19 | Sauk | Wisconsin | 55111 | 33 | 3 |
72861 | 72861 | 2020-04-19 | Sawyer | Wisconsin | 55113 | 2 | 0 |
72862 | 72862 | 2020-04-19 | Shawano | Wisconsin | 55115 | 6 | 0 |
72863 | 72863 | 2020-04-19 | Sheboygan | Wisconsin | 55117 | 40 | 2 |
72864 | 72864 | 2020-04-19 | St. Croix | Wisconsin | 55109 | 11 | 0 |
72865 | 72865 | 2020-04-19 | Trempealeau | Wisconsin | 55121 | 1 | 0 |
72866 | 72866 | 2020-04-19 | Vilas | Wisconsin | 55125 | 4 | 0 |
72867 | 72867 | 2020-04-19 | Walworth | Wisconsin | 55127 | 89 | 6 |
72868 | 72868 | 2020-04-19 | Washburn | Wisconsin | 55129 | 1 | 0 |
72869 | 72869 | 2020-04-19 | Washington | Wisconsin | 55131 | 84 | 3 |
72870 | 72870 | 2020-04-19 | Waukesha | Wisconsin | 55133 | 265 | 11 |
72871 | 72871 | 2020-04-19 | Waupaca | Wisconsin | 55135 | 4 | 1 |
72872 | 72872 | 2020-04-19 | Waushara | Wisconsin | 55137 | 2 | 0 |
72873 | 72873 | 2020-04-19 | Winnebago | Wisconsin | 55139 | 41 | 1 |
72874 | 72874 | 2020-04-19 | 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);