ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where "date" is on date 2022-03-20 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2326949 | 2326949 | 2022-03-20 | Adams | Wisconsin | 55001 | 4613 | 57 |
2326950 | 2326950 | 2022-03-20 | Ashland | Wisconsin | 55003 | 3258 | 35 |
2326951 | 2326951 | 2022-03-20 | Barron | Wisconsin | 55005 | 13413 | 140 |
2326952 | 2326952 | 2022-03-20 | Bayfield | Wisconsin | 55007 | 3251 | 38 |
2326953 | 2326953 | 2022-03-20 | Brown | Wisconsin | 55009 | 83709 | 510 |
2326954 | 2326954 | 2022-03-20 | Buffalo | Wisconsin | 55011 | 3440 | 12 |
2326955 | 2326955 | 2022-03-20 | Burnett | Wisconsin | 55013 | 3951 | 43 |
2326956 | 2326956 | 2022-03-20 | Calumet | Wisconsin | 55015 | 14441 | 119 |
2326957 | 2326957 | 2022-03-20 | Chippewa | Wisconsin | 55017 | 18573 | 179 |
2326958 | 2326958 | 2022-03-20 | Clark | Wisconsin | 55019 | 7584 | 120 |
2326959 | 2326959 | 2022-03-20 | Columbia | Wisconsin | 55021 | 15145 | 125 |
2326960 | 2326960 | 2022-03-20 | Crawford | Wisconsin | 55023 | 4216 | 28 |
2326961 | 2326961 | 2022-03-20 | Dane | Wisconsin | 55025 | 123244 | 497 |
2326962 | 2326962 | 2022-03-20 | Dodge | Wisconsin | 55027 | 26982 | 322 |
2326963 | 2326963 | 2022-03-20 | Door | Wisconsin | 55029 | 6928 | 69 |
2326964 | 2326964 | 2022-03-20 | Douglas | Wisconsin | 55031 | 11476 | 76 |
2326965 | 2326965 | 2022-03-20 | Dunn | Wisconsin | 55033 | 13232 | 71 |
2326966 | 2326966 | 2022-03-20 | Eau Claire | Wisconsin | 55035 | 29970 | 182 |
2326967 | 2326967 | 2022-03-20 | Florence | Wisconsin | 55037 | 1077 | 16 |
2326968 | 2326968 | 2022-03-20 | Fond du Lac | Wisconsin | 55039 | 31614 | 260 |
2326969 | 2326969 | 2022-03-20 | Forest | Wisconsin | 55041 | 2667 | 51 |
2326970 | 2326970 | 2022-03-20 | Grant | Wisconsin | 55043 | 12622 | 143 |
2326971 | 2326971 | 2022-03-20 | Green | Wisconsin | 55045 | 9039 | 53 |
2326972 | 2326972 | 2022-03-20 | Green Lake | Wisconsin | 55047 | 5058 | 61 |
2326973 | 2326973 | 2022-03-20 | Iowa | Wisconsin | 55049 | 5195 | 26 |
2326974 | 2326974 | 2022-03-20 | Iron | Wisconsin | 55051 | 1463 | 47 |
2326975 | 2326975 | 2022-03-20 | Jackson | Wisconsin | 55053 | 5633 | 42 |
2326976 | 2326976 | 2022-03-20 | Jefferson | Wisconsin | 55055 | 21367 | 230 |
2326977 | 2326977 | 2022-03-20 | Juneau | Wisconsin | 55057 | 7660 | 65 |
2326978 | 2326978 | 2022-03-20 | Kenosha | Wisconsin | 55059 | 43812 | 619 |
2326979 | 2326979 | 2022-03-20 | Kewaunee | Wisconsin | 55061 | 5825 | 58 |
2326980 | 2326980 | 2022-03-20 | La Crosse | Wisconsin | 55063 | 34484 | 176 |
2326981 | 2326981 | 2022-03-20 | Lafayette | Wisconsin | 55065 | 3620 | 22 |
2326982 | 2326982 | 2022-03-20 | Langlade | Wisconsin | 55067 | 5184 | 83 |
2326983 | 2326983 | 2022-03-20 | Lincoln | Wisconsin | 55069 | 6989 | 146 |
2326984 | 2326984 | 2022-03-20 | Manitowoc | Wisconsin | 55071 | 20344 | 185 |
2326985 | 2326985 | 2022-03-20 | Marathon | Wisconsin | 55073 | 39102 | 481 |
2326986 | 2326986 | 2022-03-20 | Marinette | Wisconsin | 55075 | 11552 | 116 |
2326987 | 2326987 | 2022-03-20 | Marquette | Wisconsin | 55077 | 3792 | 57 |
2326988 | 2326988 | 2022-03-20 | Menominee | Wisconsin | 55078 | 1900 | 13 |
2326989 | 2326989 | 2022-03-20 | Milwaukee | Wisconsin | 55079 | 267474 | 2209 |
2326990 | 2326990 | 2022-03-20 | Monroe | Wisconsin | 55081 | 11880 | 86 |
2326991 | 2326991 | 2022-03-20 | Oconto | Wisconsin | 55083 | 11361 | 115 |
2326992 | 2326992 | 2022-03-20 | Oneida | Wisconsin | 55085 | 8456 | 135 |
2326993 | 2326993 | 2022-03-20 | Outagamie | Wisconsin | 55087 | 54082 | 390 |
2326994 | 2326994 | 2022-03-20 | Ozaukee | Wisconsin | 55089 | 22045 | 172 |
2326995 | 2326995 | 2022-03-20 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2326996 | 2326996 | 2022-03-20 | Pierce | Wisconsin | 55093 | 11461 | 72 |
2326997 | 2326997 | 2022-03-20 | Polk | Wisconsin | 55095 | 12240 | 120 |
2326998 | 2326998 | 2022-03-20 | Portage | Wisconsin | 55097 | 17881 | 158 |
2326999 | 2326999 | 2022-03-20 | Price | Wisconsin | 55099 | 3243 | 32 |
2327000 | 2327000 | 2022-03-20 | Racine | Wisconsin | 55101 | 56039 | 671 |
2327001 | 2327001 | 2022-03-20 | Richland | Wisconsin | 55103 | 3822 | 45 |
2327002 | 2327002 | 2022-03-20 | Rock | Wisconsin | 55105 | 42515 | 378 |
2327003 | 2327003 | 2022-03-20 | Rusk | Wisconsin | 55107 | 3402 | 54 |
2327004 | 2327004 | 2022-03-20 | Sauk | Wisconsin | 55111 | 15787 | 120 |
2327005 | 2327005 | 2022-03-20 | Sawyer | Wisconsin | 55113 | 4529 | 60 |
2327006 | 2327006 | 2022-03-20 | Shawano | Wisconsin | 55115 | 11625 | 146 |
2327007 | 2327007 | 2022-03-20 | Sheboygan | Wisconsin | 55117 | 32338 | 302 |
2327008 | 2327008 | 2022-03-20 | St. Croix | Wisconsin | 55109 | 24399 | 144 |
2327009 | 2327009 | 2022-03-20 | Taylor | Wisconsin | 55119 | 4812 | 72 |
2327010 | 2327010 | 2022-03-20 | Trempealeau | Wisconsin | 55121 | 8351 | 62 |
2327011 | 2327011 | 2022-03-20 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2327012 | 2327012 | 2022-03-20 | Vilas | Wisconsin | 55125 | 5192 | 87 |
2327013 | 2327013 | 2022-03-20 | Walworth | Wisconsin | 55127 | 26793 | 275 |
2327014 | 2327014 | 2022-03-20 | Washburn | Wisconsin | 55129 | 3953 | 46 |
2327015 | 2327015 | 2022-03-20 | Washington | Wisconsin | 55131 | 37855 | 328 |
2327016 | 2327016 | 2022-03-20 | Waukesha | Wisconsin | 55133 | 111608 | 1060 |
2327017 | 2327017 | 2022-03-20 | Waupaca | Wisconsin | 55135 | 13578 | 249 |
2327018 | 2327018 | 2022-03-20 | Waushara | Wisconsin | 55137 | 6359 | 87 |
2327019 | 2327019 | 2022-03-20 | Winnebago | Wisconsin | 55139 | 51338 | 374 |
2327020 | 2327020 | 2022-03-20 | Wood | Wisconsin | 55141 | 20776 | 228 |
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);