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-10-11 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
621814 | 621814 | 2020-10-11 | Adams | Wisconsin | 55001 | 325 | 4 |
621815 | 621815 | 2020-10-11 | Ashland | Wisconsin | 55003 | 203 | 2 |
621816 | 621816 | 2020-10-11 | Barron | Wisconsin | 55005 | 644 | 6 |
621817 | 621817 | 2020-10-11 | Bayfield | Wisconsin | 55007 | 159 | 1 |
621818 | 621818 | 2020-10-11 | Brown | Wisconsin | 55009 | 12029 | 75 |
621819 | 621819 | 2020-10-11 | Buffalo | Wisconsin | 55011 | 178 | 2 |
621820 | 621820 | 2020-10-11 | Burnett | Wisconsin | 55013 | 262 | 4 |
621821 | 621821 | 2020-10-11 | Calumet | Wisconsin | 55015 | 1941 | 9 |
621822 | 621822 | 2020-10-11 | Chippewa | Wisconsin | 55017 | 839 | 0 |
621823 | 621823 | 2020-10-11 | Clark | Wisconsin | 55019 | 593 | 9 |
621824 | 621824 | 2020-10-11 | Columbia | Wisconsin | 55021 | 1160 | 3 |
621825 | 621825 | 2020-10-11 | Crawford | Wisconsin | 55023 | 246 | 0 |
621826 | 621826 | 2020-10-11 | Dane | Wisconsin | 55025 | 11905 | 44 |
621827 | 621827 | 2020-10-11 | Dodge | Wisconsin | 55027 | 2618 | 19 |
621828 | 621828 | 2020-10-11 | Door | Wisconsin | 55029 | 542 | 4 |
621829 | 621829 | 2020-10-11 | Douglas | Wisconsin | 55031 | 628 | 0 |
621830 | 621830 | 2020-10-11 | Dunn | Wisconsin | 55033 | 808 | 1 |
621831 | 621831 | 2020-10-11 | Eau Claire | Wisconsin | 55035 | 2414 | 8 |
621832 | 621832 | 2020-10-11 | Florence | Wisconsin | 55037 | 135 | 3 |
621833 | 621833 | 2020-10-11 | Fond du Lac | Wisconsin | 55039 | 2967 | 15 |
621834 | 621834 | 2020-10-11 | Forest | Wisconsin | 55041 | 369 | 7 |
621835 | 621835 | 2020-10-11 | Grant | Wisconsin | 55043 | 1453 | 19 |
621836 | 621836 | 2020-10-11 | Green | Wisconsin | 55045 | 702 | 3 |
621837 | 621837 | 2020-10-11 | Green Lake | Wisconsin | 55047 | 537 | 1 |
621838 | 621838 | 2020-10-11 | Iowa | Wisconsin | 55049 | 301 | 0 |
621839 | 621839 | 2020-10-11 | Iron | Wisconsin | 55051 | 161 | 1 |
621840 | 621840 | 2020-10-11 | Jackson | Wisconsin | 55053 | 215 | 1 |
621841 | 621841 | 2020-10-11 | Jefferson | Wisconsin | 55055 | 1956 | 8 |
621842 | 621842 | 2020-10-11 | Juneau | Wisconsin | 55057 | 535 | 2 |
621843 | 621843 | 2020-10-11 | Kenosha | Wisconsin | 55059 | 4412 | 68 |
621844 | 621844 | 2020-10-11 | Kewaunee | Wisconsin | 55061 | 838 | 3 |
621845 | 621845 | 2020-10-11 | La Crosse | Wisconsin | 55063 | 3683 | 10 |
621846 | 621846 | 2020-10-11 | Lafayette | Wisconsin | 55065 | 408 | 0 |
621847 | 621847 | 2020-10-11 | Langlade | Wisconsin | 55067 | 464 | 2 |
621848 | 621848 | 2020-10-11 | Lincoln | Wisconsin | 55069 | 437 | 4 |
621849 | 621849 | 2020-10-11 | Manitowoc | Wisconsin | 55071 | 1932 | 6 |
621850 | 621850 | 2020-10-11 | Marathon | Wisconsin | 55073 | 2688 | 30 |
621851 | 621851 | 2020-10-11 | Marinette | Wisconsin | 55075 | 1337 | 9 |
621852 | 621852 | 2020-10-11 | Marquette | Wisconsin | 55077 | 419 | 2 |
621853 | 621853 | 2020-10-11 | Menominee | Wisconsin | 55078 | 167 | 0 |
621854 | 621854 | 2020-10-11 | Milwaukee | Wisconsin | 55079 | 34295 | 549 |
621855 | 621855 | 2020-10-11 | Monroe | Wisconsin | 55081 | 782 | 3 |
621856 | 621856 | 2020-10-11 | Oconto | Wisconsin | 55083 | 1577 | 4 |
621857 | 621857 | 2020-10-11 | Oneida | Wisconsin | 55085 | 765 | 5 |
621858 | 621858 | 2020-10-11 | Outagamie | Wisconsin | 55087 | 6873 | 37 |
621859 | 621859 | 2020-10-11 | Ozaukee | Wisconsin | 55089 | 1777 | 21 |
621860 | 621860 | 2020-10-11 | Pepin | Wisconsin | 55091 | 81 | 0 |
621861 | 621861 | 2020-10-11 | Pierce | Wisconsin | 55093 | 782 | 7 |
621862 | 621862 | 2020-10-11 | Polk | Wisconsin | 55095 | 344 | 2 |
621863 | 621863 | 2020-10-11 | Portage | Wisconsin | 55097 | 1927 | 14 |
621864 | 621864 | 2020-10-11 | Price | Wisconsin | 55099 | 231 | 0 |
621865 | 621865 | 2020-10-11 | Racine | Wisconsin | 55101 | 6141 | 100 |
621866 | 621866 | 2020-10-11 | Richland | Wisconsin | 55103 | 314 | 4 |
621867 | 621867 | 2020-10-11 | Rock | Wisconsin | 55105 | 3486 | 36 |
621868 | 621868 | 2020-10-11 | Rusk | Wisconsin | 55107 | 106 | 1 |
621869 | 621869 | 2020-10-11 | Sauk | Wisconsin | 55111 | 1291 | 6 |
621870 | 621870 | 2020-10-11 | Sawyer | Wisconsin | 55113 | 282 | 1 |
621871 | 621871 | 2020-10-11 | Shawano | Wisconsin | 55115 | 1598 | 7 |
621872 | 621872 | 2020-10-11 | Sheboygan | Wisconsin | 55117 | 2711 | 20 |
621873 | 621873 | 2020-10-11 | St. Croix | Wisconsin | 55109 | 1289 | 9 |
621874 | 621874 | 2020-10-11 | Taylor | Wisconsin | 55119 | 287 | 4 |
621875 | 621875 | 2020-10-11 | Trempealeau | Wisconsin | 55121 | 807 | 2 |
621876 | 621876 | 2020-10-11 | Unknown | Wisconsin | 0 | 10 | |
621877 | 621877 | 2020-10-11 | Vernon | Wisconsin | 55123 | 373 | 1 |
621878 | 621878 | 2020-10-11 | Vilas | Wisconsin | 55125 | 354 | 1 |
621879 | 621879 | 2020-10-11 | Walworth | Wisconsin | 55127 | 3104 | 36 |
621880 | 621880 | 2020-10-11 | Washburn | Wisconsin | 55129 | 157 | 2 |
621881 | 621881 | 2020-10-11 | Washington | Wisconsin | 55131 | 3425 | 37 |
621882 | 621882 | 2020-10-11 | Waukesha | Wisconsin | 55133 | 9754 | 97 |
621883 | 621883 | 2020-10-11 | Waupaca | Wisconsin | 55135 | 1741 | 24 |
621884 | 621884 | 2020-10-11 | Waushara | Wisconsin | 55137 | 603 | 3 |
621885 | 621885 | 2020-10-11 | Winnebago | Wisconsin | 55139 | 6379 | 42 |
621886 | 621886 | 2020-10-11 | Wood | Wisconsin | 55141 | 1180 | 7 |
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);