ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where date = "2020-10-15" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
634789 | 634789 | 2020-10-15 | Adams | Wisconsin | 55001 | 360 | 4 |
634790 | 634790 | 2020-10-15 | Ashland | Wisconsin | 55003 | 220 | 3 |
634791 | 634791 | 2020-10-15 | Barron | Wisconsin | 55005 | 728 | 6 |
634792 | 634792 | 2020-10-15 | Bayfield | Wisconsin | 55007 | 176 | 1 |
634793 | 634793 | 2020-10-15 | Brown | Wisconsin | 55009 | 12768 | 82 |
634794 | 634794 | 2020-10-15 | Buffalo | Wisconsin | 55011 | 195 | 2 |
634795 | 634795 | 2020-10-15 | Burnett | Wisconsin | 55013 | 269 | 6 |
634796 | 634796 | 2020-10-15 | Calumet | Wisconsin | 55015 | 2156 | 10 |
634797 | 634797 | 2020-10-15 | Chippewa | Wisconsin | 55017 | 988 | 2 |
634798 | 634798 | 2020-10-15 | Clark | Wisconsin | 55019 | 653 | 9 |
634799 | 634799 | 2020-10-15 | Columbia | Wisconsin | 55021 | 1325 | 4 |
634800 | 634800 | 2020-10-15 | Crawford | Wisconsin | 55023 | 275 | 0 |
634801 | 634801 | 2020-10-15 | Dane | Wisconsin | 55025 | 12593 | 46 |
634802 | 634802 | 2020-10-15 | Dodge | Wisconsin | 55027 | 2884 | 19 |
634803 | 634803 | 2020-10-15 | Door | Wisconsin | 55029 | 601 | 4 |
634804 | 634804 | 2020-10-15 | Douglas | Wisconsin | 55031 | 661 | 1 |
634805 | 634805 | 2020-10-15 | Dunn | Wisconsin | 55033 | 832 | 1 |
634806 | 634806 | 2020-10-15 | Eau Claire | Wisconsin | 55035 | 2529 | 9 |
634807 | 634807 | 2020-10-15 | Florence | Wisconsin | 55037 | 151 | 4 |
634808 | 634808 | 2020-10-15 | Fond du Lac | Wisconsin | 55039 | 3339 | 17 |
634809 | 634809 | 2020-10-15 | Forest | Wisconsin | 55041 | 394 | 10 |
634810 | 634810 | 2020-10-15 | Grant | Wisconsin | 55043 | 1592 | 23 |
634811 | 634811 | 2020-10-15 | Green | Wisconsin | 55045 | 780 | 3 |
634812 | 634812 | 2020-10-15 | Green Lake | Wisconsin | 55047 | 621 | 2 |
634813 | 634813 | 2020-10-15 | Iowa | Wisconsin | 55049 | 361 | 1 |
634814 | 634814 | 2020-10-15 | Iron | Wisconsin | 55051 | 172 | 1 |
634815 | 634815 | 2020-10-15 | Jackson | Wisconsin | 55053 | 252 | 1 |
634816 | 634816 | 2020-10-15 | Jefferson | Wisconsin | 55055 | 2190 | 9 |
634817 | 634817 | 2020-10-15 | Juneau | Wisconsin | 55057 | 570 | 3 |
634818 | 634818 | 2020-10-15 | Kenosha | Wisconsin | 55059 | 4650 | 69 |
634819 | 634819 | 2020-10-15 | Kewaunee | Wisconsin | 55061 | 873 | 4 |
634820 | 634820 | 2020-10-15 | La Crosse | Wisconsin | 55063 | 3811 | 11 |
634821 | 634821 | 2020-10-15 | Lafayette | Wisconsin | 55065 | 444 | 1 |
634822 | 634822 | 2020-10-15 | Langlade | Wisconsin | 55067 | 593 | 4 |
634823 | 634823 | 2020-10-15 | Lincoln | Wisconsin | 55069 | 502 | 4 |
634824 | 634824 | 2020-10-15 | Manitowoc | Wisconsin | 55071 | 2152 | 7 |
634825 | 634825 | 2020-10-15 | Marathon | Wisconsin | 55073 | 3212 | 31 |
634826 | 634826 | 2020-10-15 | Marinette | Wisconsin | 55075 | 1432 | 9 |
634827 | 634827 | 2020-10-15 | Marquette | Wisconsin | 55077 | 484 | 2 |
634828 | 634828 | 2020-10-15 | Menominee | Wisconsin | 55078 | 194 | 0 |
634829 | 634829 | 2020-10-15 | Milwaukee | Wisconsin | 55079 | 36134 | 554 |
634830 | 634830 | 2020-10-15 | Monroe | Wisconsin | 55081 | 871 | 3 |
634831 | 634831 | 2020-10-15 | Oconto | Wisconsin | 55083 | 1714 | 6 |
634832 | 634832 | 2020-10-15 | Oneida | Wisconsin | 55085 | 851 | 5 |
634833 | 634833 | 2020-10-15 | Outagamie | Wisconsin | 55087 | 7443 | 47 |
634834 | 634834 | 2020-10-15 | Ozaukee | Wisconsin | 55089 | 1917 | 22 |
634835 | 634835 | 2020-10-15 | Pepin | Wisconsin | 55091 | 88 | 0 |
634836 | 634836 | 2020-10-15 | Pierce | Wisconsin | 55093 | 809 | 7 |
634837 | 634837 | 2020-10-15 | Polk | Wisconsin | 55095 | 396 | 2 |
634838 | 634838 | 2020-10-15 | Portage | Wisconsin | 55097 | 2118 | 15 |
634839 | 634839 | 2020-10-15 | Price | Wisconsin | 55099 | 274 | 0 |
634840 | 634840 | 2020-10-15 | Racine | Wisconsin | 55101 | 6579 | 101 |
634841 | 634841 | 2020-10-15 | Richland | Wisconsin | 55103 | 363 | 6 |
634842 | 634842 | 2020-10-15 | Rock | Wisconsin | 55105 | 3844 | 37 |
634843 | 634843 | 2020-10-15 | Rusk | Wisconsin | 55107 | 117 | 1 |
634844 | 634844 | 2020-10-15 | Sauk | Wisconsin | 55111 | 1435 | 6 |
634845 | 634845 | 2020-10-15 | Sawyer | Wisconsin | 55113 | 305 | 1 |
634846 | 634846 | 2020-10-15 | Shawano | Wisconsin | 55115 | 1784 | 8 |
634847 | 634847 | 2020-10-15 | Sheboygan | Wisconsin | 55117 | 3257 | 20 |
634848 | 634848 | 2020-10-15 | St. Croix | Wisconsin | 55109 | 1417 | 9 |
634849 | 634849 | 2020-10-15 | Taylor | Wisconsin | 55119 | 330 | 6 |
634850 | 634850 | 2020-10-15 | Trempealeau | Wisconsin | 55121 | 840 | 2 |
634851 | 634851 | 2020-10-15 | Unknown | Wisconsin | 0 | 12 | |
634852 | 634852 | 2020-10-15 | Vernon | Wisconsin | 55123 | 406 | 3 |
634853 | 634853 | 2020-10-15 | Vilas | Wisconsin | 55125 | 406 | 3 |
634854 | 634854 | 2020-10-15 | Walworth | Wisconsin | 55127 | 3213 | 36 |
634855 | 634855 | 2020-10-15 | Washburn | Wisconsin | 55129 | 177 | 2 |
634856 | 634856 | 2020-10-15 | Washington | Wisconsin | 55131 | 3754 | 40 |
634857 | 634857 | 2020-10-15 | Waukesha | Wisconsin | 55133 | 10584 | 100 |
634858 | 634858 | 2020-10-15 | Waupaca | Wisconsin | 55135 | 1949 | 29 |
634859 | 634859 | 2020-10-15 | Waushara | Wisconsin | 55137 | 718 | 3 |
634860 | 634860 | 2020-10-15 | Winnebago | Wisconsin | 55139 | 7109 | 48 |
634861 | 634861 | 2020-10-15 | Wood | Wisconsin | 55141 | 1296 | 9 |
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);