ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2021-09-02" 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 |
---|---|---|---|---|---|---|---|
1680063 | 1680063 | 2021-09-02 | Adams | Wisconsin | 55001 | 2214 | 21 |
1680064 | 1680064 | 2021-09-02 | Ashland | Wisconsin | 55003 | 1484 | 15 |
1680065 | 1680065 | 2021-09-02 | Barron | Wisconsin | 55005 | 6482 | 86 |
1680066 | 1680066 | 2021-09-02 | Bayfield | Wisconsin | 55007 | 1381 | 22 |
1680067 | 1680067 | 2021-09-02 | Brown | Wisconsin | 55009 | 38318 | 314 |
1680068 | 1680068 | 2021-09-02 | Buffalo | Wisconsin | 55011 | 1545 | 7 |
1680069 | 1680069 | 2021-09-02 | Burnett | Wisconsin | 55013 | 1715 | 29 |
1680070 | 1680070 | 2021-09-02 | Calumet | Wisconsin | 55015 | 7099 | 56 |
1680071 | 1680071 | 2021-09-02 | Chippewa | Wisconsin | 55017 | 8543 | 102 |
1680072 | 1680072 | 2021-09-02 | Clark | Wisconsin | 55019 | 4058 | 67 |
1680073 | 1680073 | 2021-09-02 | Columbia | Wisconsin | 55021 | 6367 | 75 |
1680074 | 1680074 | 2021-09-02 | Crawford | Wisconsin | 55023 | 1900 | 21 |
1680075 | 1680075 | 2021-09-02 | Dane | Wisconsin | 55025 | 50876 | 346 |
1680076 | 1680076 | 2021-09-02 | Dodge | Wisconsin | 55027 | 13844 | 204 |
1680077 | 1680077 | 2021-09-02 | Door | Wisconsin | 55029 | 3053 | 37 |
1680078 | 1680078 | 2021-09-02 | Douglas | Wisconsin | 55031 | 5209 | 66 |
1680079 | 1680079 | 2021-09-02 | Dunn | Wisconsin | 55033 | 5627 | 38 |
1680080 | 1680080 | 2021-09-02 | Eau Claire | Wisconsin | 55035 | 13275 | 127 |
1680081 | 1680081 | 2021-09-02 | Florence | Wisconsin | 55037 | 524 | 13 |
1680082 | 1680082 | 2021-09-02 | Fond du Lac | Wisconsin | 55039 | 14892 | 149 |
1680083 | 1680083 | 2021-09-02 | Forest | Wisconsin | 55041 | 1167 | 28 |
1680084 | 1680084 | 2021-09-02 | Grant | Wisconsin | 55043 | 6057 | 99 |
1680085 | 1680085 | 2021-09-02 | Green | Wisconsin | 55045 | 3939 | 26 |
1680086 | 1680086 | 2021-09-02 | Green Lake | Wisconsin | 55047 | 2287 | 27 |
1680087 | 1680087 | 2021-09-02 | Iowa | Wisconsin | 55049 | 2324 | 14 |
1680088 | 1680088 | 2021-09-02 | Iron | Wisconsin | 55051 | 738 | 42 |
1680089 | 1680089 | 2021-09-02 | Jackson | Wisconsin | 55053 | 2912 | 29 |
1680090 | 1680090 | 2021-09-02 | Jefferson | Wisconsin | 55055 | 10371 | 140 |
1680091 | 1680091 | 2021-09-02 | Juneau | Wisconsin | 55057 | 3586 | 31 |
1680092 | 1680092 | 2021-09-02 | Kenosha | Wisconsin | 55059 | 20524 | 343 |
1680093 | 1680093 | 2021-09-02 | Kewaunee | Wisconsin | 55061 | 2919 | 39 |
1680094 | 1680094 | 2021-09-02 | La Crosse | Wisconsin | 55063 | 14724 | 95 |
1680095 | 1680095 | 2021-09-02 | Lafayette | Wisconsin | 55065 | 1795 | 10 |
1680096 | 1680096 | 2021-09-02 | Langlade | Wisconsin | 55067 | 2412 | 51 |
1680097 | 1680097 | 2021-09-02 | Lincoln | Wisconsin | 55069 | 3539 | 102 |
1680098 | 1680098 | 2021-09-02 | Manitowoc | Wisconsin | 55071 | 9629 | 99 |
1680099 | 1680099 | 2021-09-02 | Marathon | Wisconsin | 55073 | 17594 | 236 |
1680100 | 1680100 | 2021-09-02 | Marinette | Wisconsin | 55075 | 5070 | 77 |
1680101 | 1680101 | 2021-09-02 | Marquette | Wisconsin | 55077 | 1736 | 29 |
1680102 | 1680102 | 2021-09-02 | Menominee | Wisconsin | 55078 | 854 | 11 |
1680103 | 1680103 | 2021-09-02 | Milwaukee | Wisconsin | 55079 | 132129 | 1487 |
1680104 | 1680104 | 2021-09-02 | Monroe | Wisconsin | 55081 | 5277 | 52 |
1680105 | 1680105 | 2021-09-02 | Oconto | Wisconsin | 55083 | 5596 | 75 |
1680106 | 1680106 | 2021-09-02 | Oneida | Wisconsin | 55085 | 4059 | 82 |
1680107 | 1680107 | 2021-09-02 | Outagamie | Wisconsin | 55087 | 25748 | 253 |
1680108 | 1680108 | 2021-09-02 | Ozaukee | Wisconsin | 55089 | 10410 | 111 |
1680109 | 1680109 | 2021-09-02 | Pepin | Wisconsin | 55091 | 965 | 7 |
1680110 | 1680110 | 2021-09-02 | Pierce | Wisconsin | 55093 | 5285 | 44 |
1680111 | 1680111 | 2021-09-02 | Polk | Wisconsin | 55095 | 5210 | 69 |
1680112 | 1680112 | 2021-09-02 | Portage | Wisconsin | 55097 | 8069 | 81 |
1680113 | 1680113 | 2021-09-02 | Price | Wisconsin | 55099 | 1434 | 8 |
1680114 | 1680114 | 2021-09-02 | Racine | Wisconsin | 55101 | 27765 | 414 |
1680115 | 1680115 | 2021-09-02 | Richland | Wisconsin | 55103 | 1528 | 19 |
1680116 | 1680116 | 2021-09-02 | Rock | Wisconsin | 55105 | 19844 | 218 |
1680117 | 1680117 | 2021-09-02 | Rusk | Wisconsin | 55107 | 1584 | 26 |
1680118 | 1680118 | 2021-09-02 | Sauk | Wisconsin | 55111 | 6867 | 59 |
1680119 | 1680119 | 2021-09-02 | Sawyer | Wisconsin | 55113 | 1991 | 29 |
1680120 | 1680120 | 2021-09-02 | Shawano | Wisconsin | 55115 | 5725 | 85 |
1680121 | 1680121 | 2021-09-02 | Sheboygan | Wisconsin | 55117 | 15951 | 174 |
1680122 | 1680122 | 2021-09-02 | St. Croix | Wisconsin | 55109 | 10611 | 76 |
1680123 | 1680123 | 2021-09-02 | Taylor | Wisconsin | 55119 | 2388 | 41 |
1680124 | 1680124 | 2021-09-02 | Trempealeau | Wisconsin | 55121 | 4024 | 49 |
1680125 | 1680125 | 2021-09-02 | Vernon | Wisconsin | 55123 | 2257 | 48 |
1680126 | 1680126 | 2021-09-02 | Vilas | Wisconsin | 55125 | 2545 | 46 |
1680127 | 1680127 | 2021-09-02 | Walworth | Wisconsin | 55127 | 13722 | 174 |
1680128 | 1680128 | 2021-09-02 | Washburn | Wisconsin | 55129 | 1694 | 25 |
1680129 | 1680129 | 2021-09-02 | Washington | Wisconsin | 55131 | 18568 | 208 |
1680130 | 1680130 | 2021-09-02 | Waukesha | Wisconsin | 55133 | 54292 | 668 |
1680131 | 1680131 | 2021-09-02 | Waupaca | Wisconsin | 55135 | 6608 | 170 |
1680132 | 1680132 | 2021-09-02 | Waushara | Wisconsin | 55137 | 2772 | 41 |
1680133 | 1680133 | 2021-09-02 | Winnebago | Wisconsin | 55139 | 23166 | 231 |
1680134 | 1680134 | 2021-09-02 | Wood | Wisconsin | 55141 | 8483 | 116 |
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);