ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where date = "2020-08-30" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
485813 | 485813 | 2020-08-30 | Adams | Wisconsin | 55001 | 110 | 3 |
485814 | 485814 | 2020-08-30 | Ashland | Wisconsin | 55003 | 34 | 1 |
485815 | 485815 | 2020-08-30 | Barron | Wisconsin | 55005 | 370 | 3 |
485816 | 485816 | 2020-08-30 | Bayfield | Wisconsin | 55007 | 45 | 1 |
485817 | 485817 | 2020-08-30 | Brown | Wisconsin | 55009 | 5370 | 58 |
485818 | 485818 | 2020-08-30 | Buffalo | Wisconsin | 55011 | 64 | 2 |
485819 | 485819 | 2020-08-30 | Burnett | Wisconsin | 55013 | 40 | 2 |
485820 | 485820 | 2020-08-30 | Calumet | Wisconsin | 55015 | 500 | 2 |
485821 | 485821 | 2020-08-30 | Chippewa | Wisconsin | 55017 | 345 | 0 |
485822 | 485822 | 2020-08-30 | Clark | Wisconsin | 55019 | 240 | 8 |
485823 | 485823 | 2020-08-30 | Columbia | Wisconsin | 55021 | 351 | 2 |
485824 | 485824 | 2020-08-30 | Crawford | Wisconsin | 55023 | 102 | 0 |
485825 | 485825 | 2020-08-30 | Dane | Wisconsin | 55025 | 5427 | 40 |
485826 | 485826 | 2020-08-30 | Dodge | Wisconsin | 55027 | 1133 | 5 |
485827 | 485827 | 2020-08-30 | Door | Wisconsin | 55029 | 128 | 3 |
485828 | 485828 | 2020-08-30 | Douglas | Wisconsin | 55031 | 249 | 0 |
485829 | 485829 | 2020-08-30 | Dunn | Wisconsin | 55033 | 176 | 0 |
485830 | 485830 | 2020-08-30 | Eau Claire | Wisconsin | 55035 | 801 | 6 |
485831 | 485831 | 2020-08-30 | Florence | Wisconsin | 55037 | 25 | 0 |
485832 | 485832 | 2020-08-30 | Fond du Lac | Wisconsin | 55039 | 1093 | 10 |
485833 | 485833 | 2020-08-30 | Forest | Wisconsin | 55041 | 77 | 4 |
485834 | 485834 | 2020-08-30 | Grant | Wisconsin | 55043 | 435 | 17 |
485835 | 485835 | 2020-08-30 | Green | Wisconsin | 55045 | 268 | 1 |
485836 | 485836 | 2020-08-30 | Green Lake | Wisconsin | 55047 | 91 | 0 |
485837 | 485837 | 2020-08-30 | Iowa | Wisconsin | 55049 | 120 | 0 |
485838 | 485838 | 2020-08-30 | Iron | Wisconsin | 55051 | 122 | 1 |
485839 | 485839 | 2020-08-30 | Jackson | Wisconsin | 55053 | 76 | 1 |
485840 | 485840 | 2020-08-30 | Jefferson | Wisconsin | 55055 | 900 | 6 |
485841 | 485841 | 2020-08-30 | Juneau | Wisconsin | 55057 | 197 | 1 |
485842 | 485842 | 2020-08-30 | Kenosha | Wisconsin | 55059 | 2961 | 63 |
485843 | 485843 | 2020-08-30 | Kewaunee | Wisconsin | 55061 | 171 | 2 |
485844 | 485844 | 2020-08-30 | La Crosse | Wisconsin | 55063 | 1177 | 1 |
485845 | 485845 | 2020-08-30 | Lafayette | Wisconsin | 55065 | 185 | 0 |
485846 | 485846 | 2020-08-30 | Langlade | Wisconsin | 55067 | 83 | 2 |
485847 | 485847 | 2020-08-30 | Lincoln | Wisconsin | 55069 | 82 | 1 |
485848 | 485848 | 2020-08-30 | Manitowoc | Wisconsin | 55071 | 517 | 2 |
485849 | 485849 | 2020-08-30 | Marathon | Wisconsin | 55073 | 773 | 13 |
485850 | 485850 | 2020-08-30 | Marinette | Wisconsin | 55075 | 610 | 6 |
485851 | 485851 | 2020-08-30 | Marquette | Wisconsin | 55077 | 89 | 1 |
485852 | 485852 | 2020-08-30 | Menominee | Wisconsin | 55078 | 29 | 0 |
485853 | 485853 | 2020-08-30 | Milwaukee | Wisconsin | 55079 | 24040 | 489 |
485854 | 485854 | 2020-08-30 | Monroe | Wisconsin | 55081 | 281 | 2 |
485855 | 485855 | 2020-08-30 | Oconto | Wisconsin | 55083 | 424 | 2 |
485856 | 485856 | 2020-08-30 | Oneida | Wisconsin | 55085 | 210 | 0 |
485857 | 485857 | 2020-08-30 | Outagamie | Wisconsin | 55087 | 1845 | 20 |
485858 | 485858 | 2020-08-30 | Ozaukee | Wisconsin | 55089 | 915 | 19 |
485859 | 485859 | 2020-08-30 | Pepin | Wisconsin | 55091 | 46 | 0 |
485860 | 485860 | 2020-08-30 | Pierce | Wisconsin | 55093 | 291 | 5 |
485861 | 485861 | 2020-08-30 | Polk | Wisconsin | 55095 | 171 | 2 |
485862 | 485862 | 2020-08-30 | Portage | Wisconsin | 55097 | 596 | 1 |
485863 | 485863 | 2020-08-30 | Price | Wisconsin | 55099 | 36 | 0 |
485864 | 485864 | 2020-08-30 | Racine | Wisconsin | 55101 | 4429 | 89 |
485865 | 485865 | 2020-08-30 | Richland | Wisconsin | 55103 | 49 | 4 |
485866 | 485866 | 2020-08-30 | Rock | Wisconsin | 55105 | 1818 | 26 |
485867 | 485867 | 2020-08-30 | Rusk | Wisconsin | 55107 | 24 | 1 |
485868 | 485868 | 2020-08-30 | Sauk | Wisconsin | 55111 | 644 | 3 |
485869 | 485869 | 2020-08-30 | Sawyer | Wisconsin | 55113 | 159 | 0 |
485870 | 485870 | 2020-08-30 | Shawano | Wisconsin | 55115 | 268 | 0 |
485871 | 485871 | 2020-08-30 | Sheboygan | Wisconsin | 55117 | 1032 | 9 |
485872 | 485872 | 2020-08-30 | St. Croix | Wisconsin | 55109 | 640 | 7 |
485873 | 485873 | 2020-08-30 | Taylor | Wisconsin | 55119 | 103 | 3 |
485874 | 485874 | 2020-08-30 | Trempealeau | Wisconsin | 55121 | 411 | 2 |
485875 | 485875 | 2020-08-30 | Unknown | Wisconsin | 4381 | 8 | |
485876 | 485876 | 2020-08-30 | Vernon | Wisconsin | 55123 | 98 | 0 |
485877 | 485877 | 2020-08-30 | Vilas | Wisconsin | 55125 | 104 | 0 |
485878 | 485878 | 2020-08-30 | Walworth | Wisconsin | 55127 | 1695 | 27 |
485879 | 485879 | 2020-08-30 | Washburn | Wisconsin | 55129 | 64 | 0 |
485880 | 485880 | 2020-08-30 | Washington | Wisconsin | 55131 | 1622 | 29 |
485881 | 485881 | 2020-08-30 | Waukesha | Wisconsin | 55133 | 5565 | 74 |
485882 | 485882 | 2020-08-30 | Waupaca | Wisconsin | 55135 | 662 | 17 |
485883 | 485883 | 2020-08-30 | Waushara | Wisconsin | 55137 | 154 | 2 |
485884 | 485884 | 2020-08-30 | Winnebago | Wisconsin | 55139 | 1512 | 21 |
485885 | 485885 | 2020-08-30 | Wood | Wisconsin | 55141 | 456 | 2 |
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);