ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55,993 rows where state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 55025 145
- 55093 112
- 55039 110
- 55133 110
- 55079 108
- 55101 108
- 55117 108
- 55139 107
- 55087 105
- 55141 105
- 55059 104
- 55009 103
- 55063 103
- 55131 103
- 55007 102
- 55015 102
- 55021 102
- 55035 102
- 55089 102
- 55111 102
- 55127 102
- 55017 101
- 55031 101
- 55033 101
- 55045 101
- 55055 101
- 55073 101
- 55105 101
- 55109 101
- 55027 98
- …
county >30
- Dane 145
- Pierce 112
- Fond du Lac 110
- Waukesha 110
- Milwaukee 108
- Racine 108
- Sheboygan 108
- Winnebago 107
- Outagamie 105
- Wood 105
- Kenosha 104
- Brown 103
- La Crosse 103
- Washington 103
- Bayfield 102
- Calumet 102
- Columbia 102
- Eau Claire 102
- Ozaukee 102
- Sauk 102
- Walworth 102
- Chippewa 101
- Douglas 101
- Dunn 101
- Green 101
- Jefferson 101
- Marathon 101
- Rock 101
- St. Croix 101
- Dodge 98
- …
state 1
- Wisconsin · 6,629 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
283838 | 283838 | 2020-06-28 | Adams | Wisconsin | 55001 | 15 | 2 |
283839 | 283839 | 2020-06-28 | Ashland | Wisconsin | 55003 | 3 | 0 |
283840 | 283840 | 2020-06-28 | Barron | Wisconsin | 55005 | 34 | 0 |
283841 | 283841 | 2020-06-28 | Bayfield | Wisconsin | 55007 | 3 | 1 |
283842 | 283842 | 2020-06-28 | Brown | Wisconsin | 55009 | 2826 | 42 |
283843 | 283843 | 2020-06-28 | Buffalo | Wisconsin | 55011 | 7 | 2 |
283844 | 283844 | 2020-06-28 | Burnett | Wisconsin | 55013 | 3 | 1 |
283845 | 283845 | 2020-06-28 | Calumet | Wisconsin | 55015 | 103 | 2 |
283846 | 283846 | 2020-06-28 | Chippewa | Wisconsin | 55017 | 82 | 0 |
283847 | 283847 | 2020-06-28 | Clark | Wisconsin | 55019 | 70 | 6 |
283848 | 283848 | 2020-06-28 | Columbia | Wisconsin | 55021 | 80 | 1 |
283849 | 283849 | 2020-06-28 | Crawford | Wisconsin | 55023 | 33 | 0 |
283850 | 283850 | 2020-06-28 | Dane | Wisconsin | 55025 | 1650 | 32 |
283851 | 283851 | 2020-06-28 | Dodge | Wisconsin | 55027 | 453 | 5 |
283852 | 283852 | 2020-06-28 | Door | Wisconsin | 55029 | 43 | 3 |
283853 | 283853 | 2020-06-28 | Douglas | Wisconsin | 55031 | 24 | 0 |
283854 | 283854 | 2020-06-28 | Dunn | Wisconsin | 55033 | 38 | 0 |
283855 | 283855 | 2020-06-28 | Eau Claire | Wisconsin | 55035 | 208 | 1 |
283856 | 283856 | 2020-06-28 | Florence | Wisconsin | 55037 | 3 | 0 |
283857 | 283857 | 2020-06-28 | Fond du Lac | Wisconsin | 55039 | 308 | 6 |
283858 | 283858 | 2020-06-28 | Forest | Wisconsin | 55041 | 38 | 3 |
283859 | 283859 | 2020-06-28 | Grant | Wisconsin | 55043 | 150 | 13 |
283860 | 283860 | 2020-06-28 | Green | Wisconsin | 55045 | 88 | 1 |
283861 | 283861 | 2020-06-28 | Green Lake | Wisconsin | 55047 | 32 | 0 |
283862 | 283862 | 2020-06-28 | Iowa | Wisconsin | 55049 | 29 | 0 |
283863 | 283863 | 2020-06-28 | Iron | Wisconsin | 55051 | 5 | 1 |
283864 | 283864 | 2020-06-28 | Jackson | Wisconsin | 55053 | 26 | 1 |
283865 | 283865 | 2020-06-28 | Jefferson | Wisconsin | 55055 | 228 | 4 |
283866 | 283866 | 2020-06-28 | Juneau | Wisconsin | 55057 | 32 | 1 |
283867 | 283867 | 2020-06-28 | Kenosha | Wisconsin | 55059 | 1478 | 43 |
283868 | 283868 | 2020-06-28 | Kewaunee | Wisconsin | 55061 | 55 | 1 |
283869 | 283869 | 2020-06-28 | La Crosse | Wisconsin | 55063 | 403 | 0 |
283870 | 283870 | 2020-06-28 | Lafayette | Wisconsin | 55065 | 70 | 0 |
283871 | 283871 | 2020-06-28 | Langlade | Wisconsin | 55067 | 7 | 0 |
283872 | 283872 | 2020-06-28 | Lincoln | Wisconsin | 55069 | 9 | 0 |
283873 | 283873 | 2020-06-28 | Manitowoc | Wisconsin | 55071 | 91 | 1 |
283874 | 283874 | 2020-06-28 | Marathon | Wisconsin | 55073 | 150 | 1 |
283875 | 283875 | 2020-06-28 | Marinette | Wisconsin | 55075 | 53 | 3 |
283876 | 283876 | 2020-06-28 | Marquette | Wisconsin | 55077 | 13 | 1 |
283877 | 283877 | 2020-06-28 | Menominee | Wisconsin | 55078 | 6 | 0 |
283878 | 283878 | 2020-06-28 | Milwaukee | Wisconsin | 55079 | 11110 | 389 |
283879 | 283879 | 2020-06-28 | Monroe | Wisconsin | 55081 | 61 | 1 |
283880 | 283880 | 2020-06-28 | Oconto | Wisconsin | 55083 | 56 | 0 |
283881 | 283881 | 2020-06-28 | Oneida | Wisconsin | 55085 | 19 | 0 |
283882 | 283882 | 2020-06-28 | Outagamie | Wisconsin | 55087 | 454 | 8 |
283883 | 283883 | 2020-06-28 | Ozaukee | Wisconsin | 55089 | 222 | 16 |
283884 | 283884 | 2020-06-28 | Pepin | Wisconsin | 55091 | 1 | 0 |
283885 | 283885 | 2020-06-28 | Pierce | Wisconsin | 55093 | 66 | 0 |
283886 | 283886 | 2020-06-28 | Polk | Wisconsin | 55095 | 46 | 1 |
283887 | 283887 | 2020-06-28 | Portage | Wisconsin | 55097 | 130 | 0 |
283888 | 283888 | 2020-06-28 | Price | Wisconsin | 55099 | 2 | 0 |
283889 | 283889 | 2020-06-28 | Racine | Wisconsin | 55101 | 2478 | 61 |
283890 | 283890 | 2020-06-28 | Richland | Wisconsin | 55103 | 15 | 4 |
283891 | 283891 | 2020-06-28 | Rock | Wisconsin | 55105 | 953 | 23 |
283892 | 283892 | 2020-06-28 | Rusk | Wisconsin | 55107 | 11 | 0 |
283893 | 283893 | 2020-06-28 | Sauk | Wisconsin | 55111 | 102 | 3 |
283894 | 283894 | 2020-06-28 | Sawyer | Wisconsin | 55113 | 12 | 0 |
283895 | 283895 | 2020-06-28 | Shawano | Wisconsin | 55115 | 75 | 0 |
283896 | 283896 | 2020-06-28 | Sheboygan | Wisconsin | 55117 | 198 | 4 |
283897 | 283897 | 2020-06-28 | St. Croix | Wisconsin | 55109 | 158 | 1 |
283898 | 283898 | 2020-06-28 | Taylor | Wisconsin | 55119 | 12 | 0 |
283899 | 283899 | 2020-06-28 | Trempealeau | Wisconsin | 55121 | 112 | 0 |
283900 | 283900 | 2020-06-28 | Unknown | Wisconsin | 2532 | 7 | |
283901 | 283901 | 2020-06-28 | Vernon | Wisconsin | 55123 | 32 | 0 |
283902 | 283902 | 2020-06-28 | Vilas | Wisconsin | 55125 | 10 | 0 |
283903 | 283903 | 2020-06-28 | Walworth | Wisconsin | 55127 | 572 | 18 |
283904 | 283904 | 2020-06-28 | Washburn | Wisconsin | 55129 | 4 | 0 |
283905 | 283905 | 2020-06-28 | Washington | Wisconsin | 55131 | 354 | 16 |
283906 | 283906 | 2020-06-28 | Waukesha | Wisconsin | 55133 | 1139 | 38 |
283907 | 283907 | 2020-06-28 | Waupaca | Wisconsin | 55135 | 106 | 6 |
283908 | 283908 | 2020-06-28 | Waushara | Wisconsin | 55137 | 23 | 0 |
283909 | 283909 | 2020-06-28 | Winnebago | Wisconsin | 55139 | 655 | 11 |
283910 | 283910 | 2020-06-28 | Wood | Wisconsin | 55141 | 47 | 1 |
280692 | 280692 | 2020-06-27 | Adams | Wisconsin | 55001 | 15 | 2 |
280693 | 280693 | 2020-06-27 | Ashland | Wisconsin | 55003 | 3 | 0 |
280694 | 280694 | 2020-06-27 | Barron | Wisconsin | 55005 | 34 | 0 |
280695 | 280695 | 2020-06-27 | Bayfield | Wisconsin | 55007 | 3 | 1 |
280696 | 280696 | 2020-06-27 | Brown | Wisconsin | 55009 | 2777 | 42 |
280697 | 280697 | 2020-06-27 | Buffalo | Wisconsin | 55011 | 7 | 2 |
280698 | 280698 | 2020-06-27 | Burnett | Wisconsin | 55013 | 3 | 1 |
280699 | 280699 | 2020-06-27 | Calumet | Wisconsin | 55015 | 97 | 2 |
280700 | 280700 | 2020-06-27 | Chippewa | Wisconsin | 55017 | 82 | 0 |
280701 | 280701 | 2020-06-27 | Clark | Wisconsin | 55019 | 69 | 6 |
280702 | 280702 | 2020-06-27 | Columbia | Wisconsin | 55021 | 79 | 1 |
280703 | 280703 | 2020-06-27 | Crawford | Wisconsin | 55023 | 32 | 0 |
280704 | 280704 | 2020-06-27 | Dane | Wisconsin | 55025 | 1530 | 32 |
280705 | 280705 | 2020-06-27 | Dodge | Wisconsin | 55027 | 450 | 5 |
280706 | 280706 | 2020-06-27 | Door | Wisconsin | 55029 | 43 | 3 |
280707 | 280707 | 2020-06-27 | Douglas | Wisconsin | 55031 | 22 | 0 |
280708 | 280708 | 2020-06-27 | Dunn | Wisconsin | 55033 | 36 | 0 |
280709 | 280709 | 2020-06-27 | Eau Claire | Wisconsin | 55035 | 194 | 1 |
280710 | 280710 | 2020-06-27 | Florence | Wisconsin | 55037 | 3 | 0 |
280711 | 280711 | 2020-06-27 | Fond du Lac | Wisconsin | 55039 | 307 | 6 |
280712 | 280712 | 2020-06-27 | Forest | Wisconsin | 55041 | 38 | 3 |
280713 | 280713 | 2020-06-27 | Grant | Wisconsin | 55043 | 145 | 13 |
280714 | 280714 | 2020-06-27 | Green | Wisconsin | 55045 | 85 | 1 |
280715 | 280715 | 2020-06-27 | Green Lake | Wisconsin | 55047 | 30 | 0 |
280716 | 280716 | 2020-06-27 | Iowa | Wisconsin | 55049 | 29 | 0 |
280717 | 280717 | 2020-06-27 | Iron | Wisconsin | 55051 | 5 | 1 |
280718 | 280718 | 2020-06-27 | Jackson | Wisconsin | 55053 | 26 | 1 |
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);