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 224
- 55093 191
- 55039 189
- 55133 189
- 55079 187
- 55101 187
- 55117 187
- 55139 186
- 55087 184
- 55141 184
- 55059 183
- 55009 182
- 55063 182
- 55131 182
- 55007 181
- 55015 181
- 55021 181
- 55035 181
- 55089 181
- 55111 181
- 55127 181
- 55017 180
- 55031 180
- 55033 180
- 55045 180
- 55055 180
- 55073 180
- 55105 180
- 55109 180
- 55027 177
- …
county >30
- Dane 224
- Pierce 191
- Fond du Lac 189
- Waukesha 189
- Milwaukee 187
- Racine 187
- Sheboygan 187
- Winnebago 186
- Outagamie 184
- Wood 184
- Kenosha 183
- Brown 182
- La Crosse 182
- Washington 182
- Bayfield 181
- Calumet 181
- Columbia 181
- Eau Claire 181
- Ozaukee 181
- Sauk 181
- Walworth 181
- Chippewa 180
- Douglas 180
- Dunn 180
- Green 180
- Jefferson 180
- Marathon 180
- Rock 180
- St. Croix 180
- Dodge 177
- …
state 1
- Wisconsin · 12,396 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537564 | 537564 | 2020-09-15 | Adams | Wisconsin | 55001 | 183 | 3 |
537565 | 537565 | 2020-09-15 | Ashland | Wisconsin | 55003 | 49 | 1 |
537566 | 537566 | 2020-09-15 | Barron | Wisconsin | 55005 | 422 | 4 |
537567 | 537567 | 2020-09-15 | Bayfield | Wisconsin | 55007 | 77 | 1 |
537568 | 537568 | 2020-09-15 | Brown | Wisconsin | 55009 | 6831 | 58 |
537569 | 537569 | 2020-09-15 | Buffalo | Wisconsin | 55011 | 116 | 2 |
537570 | 537570 | 2020-09-15 | Burnett | Wisconsin | 55013 | 88 | 2 |
537571 | 537571 | 2020-09-15 | Calumet | Wisconsin | 55015 | 750 | 2 |
537572 | 537572 | 2020-09-15 | Chippewa | Wisconsin | 55017 | 447 | 0 |
537573 | 537573 | 2020-09-15 | Clark | Wisconsin | 55019 | 324 | 8 |
537574 | 537574 | 2020-09-15 | Columbia | Wisconsin | 55021 | 489 | 2 |
537575 | 537575 | 2020-09-15 | Crawford | Wisconsin | 55023 | 136 | 0 |
537576 | 537576 | 2020-09-15 | Dane | Wisconsin | 55025 | 8338 | 41 |
537577 | 537577 | 2020-09-15 | Dodge | Wisconsin | 55027 | 1482 | 8 |
537578 | 537578 | 2020-09-15 | Door | Wisconsin | 55029 | 202 | 3 |
537579 | 537579 | 2020-09-15 | Douglas | Wisconsin | 55031 | 343 | 0 |
537580 | 537580 | 2020-09-15 | Dunn | Wisconsin | 55033 | 275 | 0 |
537581 | 537581 | 2020-09-15 | Eau Claire | Wisconsin | 55035 | 1306 | 6 |
537582 | 537582 | 2020-09-15 | Florence | Wisconsin | 55037 | 49 | 0 |
537583 | 537583 | 2020-09-15 | Fond du Lac | Wisconsin | 55039 | 1535 | 12 |
537584 | 537584 | 2020-09-15 | Forest | Wisconsin | 55041 | 169 | 4 |
537585 | 537585 | 2020-09-15 | Grant | Wisconsin | 55043 | 661 | 19 |
537586 | 537586 | 2020-09-15 | Green | Wisconsin | 55045 | 382 | 2 |
537587 | 537587 | 2020-09-15 | Green Lake | Wisconsin | 55047 | 179 | 0 |
537588 | 537588 | 2020-09-15 | Iowa | Wisconsin | 55049 | 160 | 0 |
537589 | 537589 | 2020-09-15 | Iron | Wisconsin | 55051 | 143 | 1 |
537590 | 537590 | 2020-09-15 | Jackson | Wisconsin | 55053 | 97 | 1 |
537591 | 537591 | 2020-09-15 | Jefferson | Wisconsin | 55055 | 1167 | 7 |
537592 | 537592 | 2020-09-15 | Juneau | Wisconsin | 55057 | 281 | 1 |
537593 | 537593 | 2020-09-15 | Kenosha | Wisconsin | 55059 | 3525 | 65 |
537594 | 537594 | 2020-09-15 | Kewaunee | Wisconsin | 55061 | 281 | 2 |
537595 | 537595 | 2020-09-15 | La Crosse | Wisconsin | 55063 | 2018 | 2 |
537596 | 537596 | 2020-09-15 | Lafayette | Wisconsin | 55065 | 203 | 0 |
537597 | 537597 | 2020-09-15 | Langlade | Wisconsin | 55067 | 113 | 2 |
537598 | 537598 | 2020-09-15 | Lincoln | Wisconsin | 55069 | 123 | 1 |
537599 | 537599 | 2020-09-15 | Manitowoc | Wisconsin | 55071 | 767 | 2 |
537600 | 537600 | 2020-09-15 | Marathon | Wisconsin | 55073 | 985 | 14 |
537601 | 537601 | 2020-09-15 | Marinette | Wisconsin | 55075 | 691 | 7 |
537602 | 537602 | 2020-09-15 | Marquette | Wisconsin | 55077 | 156 | 1 |
537603 | 537603 | 2020-09-15 | Menominee | Wisconsin | 55078 | 34 | 1 |
537604 | 537604 | 2020-09-15 | Milwaukee | Wisconsin | 55079 | 27289 | 517 |
537605 | 537605 | 2020-09-15 | Monroe | Wisconsin | 55081 | 340 | 2 |
537606 | 537606 | 2020-09-15 | Oconto | Wisconsin | 55083 | 608 | 4 |
537607 | 537607 | 2020-09-15 | Oneida | Wisconsin | 55085 | 292 | 2 |
537608 | 537608 | 2020-09-15 | Outagamie | Wisconsin | 55087 | 3070 | 24 |
537609 | 537609 | 2020-09-15 | Ozaukee | Wisconsin | 55089 | 1202 | 19 |
537610 | 537610 | 2020-09-15 | Pepin | Wisconsin | 55091 | 53 | 0 |
537611 | 537611 | 2020-09-15 | Pierce | Wisconsin | 55093 | 439 | 6 |
537612 | 537612 | 2020-09-15 | Polk | Wisconsin | 55095 | 218 | 2 |
537613 | 537613 | 2020-09-15 | Portage | Wisconsin | 55097 | 1005 | 3 |
537614 | 537614 | 2020-09-15 | Price | Wisconsin | 55099 | 41 | 0 |
537615 | 537615 | 2020-09-15 | Racine | Wisconsin | 55101 | 4757 | 94 |
537616 | 537616 | 2020-09-15 | Richland | Wisconsin | 55103 | 85 | 4 |
537617 | 537617 | 2020-09-15 | Rock | Wisconsin | 55105 | 2239 | 32 |
537618 | 537618 | 2020-09-15 | Rusk | Wisconsin | 55107 | 44 | 1 |
537619 | 537619 | 2020-09-15 | Sauk | Wisconsin | 55111 | 787 | 3 |
537620 | 537620 | 2020-09-15 | Sawyer | Wisconsin | 55113 | 185 | 1 |
537621 | 537621 | 2020-09-15 | Shawano | Wisconsin | 55115 | 411 | 0 |
537622 | 537622 | 2020-09-15 | Sheboygan | Wisconsin | 55117 | 1328 | 12 |
537623 | 537623 | 2020-09-15 | St. Croix | Wisconsin | 55109 | 793 | 7 |
537624 | 537624 | 2020-09-15 | Taylor | Wisconsin | 55119 | 140 | 3 |
537625 | 537625 | 2020-09-15 | Trempealeau | Wisconsin | 55121 | 493 | 2 |
537626 | 537626 | 2020-09-15 | Unknown | Wisconsin | 0 | 9 | |
537627 | 537627 | 2020-09-15 | Vernon | Wisconsin | 55123 | 148 | 0 |
537628 | 537628 | 2020-09-15 | Vilas | Wisconsin | 55125 | 151 | 1 |
537629 | 537629 | 2020-09-15 | Walworth | Wisconsin | 55127 | 2380 | 33 |
537630 | 537630 | 2020-09-15 | Washburn | Wisconsin | 55129 | 85 | 1 |
537631 | 537631 | 2020-09-15 | Washington | Wisconsin | 55131 | 2084 | 32 |
537632 | 537632 | 2020-09-15 | Waukesha | Wisconsin | 55133 | 6768 | 85 |
537633 | 537633 | 2020-09-15 | Waupaca | Wisconsin | 55135 | 919 | 19 |
537634 | 537634 | 2020-09-15 | Waushara | Wisconsin | 55137 | 247 | 2 |
537635 | 537635 | 2020-09-15 | Winnebago | Wisconsin | 55139 | 2205 | 22 |
537636 | 537636 | 2020-09-15 | Wood | Wisconsin | 55141 | 619 | 3 |
534328 | 534328 | 2020-09-14 | Adams | Wisconsin | 55001 | 175 | 3 |
534329 | 534329 | 2020-09-14 | Ashland | Wisconsin | 55003 | 48 | 1 |
534330 | 534330 | 2020-09-14 | Barron | Wisconsin | 55005 | 419 | 4 |
534331 | 534331 | 2020-09-14 | Bayfield | Wisconsin | 55007 | 75 | 1 |
534332 | 534332 | 2020-09-14 | Brown | Wisconsin | 55009 | 6666 | 58 |
534333 | 534333 | 2020-09-14 | Buffalo | Wisconsin | 55011 | 109 | 2 |
534334 | 534334 | 2020-09-14 | Burnett | Wisconsin | 55013 | 80 | 2 |
534335 | 534335 | 2020-09-14 | Calumet | Wisconsin | 55015 | 735 | 2 |
534336 | 534336 | 2020-09-14 | Chippewa | Wisconsin | 55017 | 444 | 0 |
534337 | 534337 | 2020-09-14 | Clark | Wisconsin | 55019 | 316 | 8 |
534338 | 534338 | 2020-09-14 | Columbia | Wisconsin | 55021 | 478 | 2 |
534339 | 534339 | 2020-09-14 | Crawford | Wisconsin | 55023 | 134 | 0 |
534340 | 534340 | 2020-09-14 | Dane | Wisconsin | 55025 | 8280 | 41 |
534341 | 534341 | 2020-09-14 | Dodge | Wisconsin | 55027 | 1440 | 8 |
534342 | 534342 | 2020-09-14 | Door | Wisconsin | 55029 | 198 | 3 |
534343 | 534343 | 2020-09-14 | Douglas | Wisconsin | 55031 | 343 | 0 |
534344 | 534344 | 2020-09-14 | Dunn | Wisconsin | 55033 | 270 | 0 |
534345 | 534345 | 2020-09-14 | Eau Claire | Wisconsin | 55035 | 1279 | 6 |
534346 | 534346 | 2020-09-14 | Florence | Wisconsin | 55037 | 46 | 0 |
534347 | 534347 | 2020-09-14 | Fond du Lac | Wisconsin | 55039 | 1513 | 12 |
534348 | 534348 | 2020-09-14 | Forest | Wisconsin | 55041 | 160 | 4 |
534349 | 534349 | 2020-09-14 | Grant | Wisconsin | 55043 | 643 | 19 |
534350 | 534350 | 2020-09-14 | Green | Wisconsin | 55045 | 378 | 2 |
534351 | 534351 | 2020-09-14 | Green Lake | Wisconsin | 55047 | 173 | 0 |
534352 | 534352 | 2020-09-14 | Iowa | Wisconsin | 55049 | 160 | 0 |
534353 | 534353 | 2020-09-14 | Iron | Wisconsin | 55051 | 143 | 1 |
534354 | 534354 | 2020-09-14 | Jackson | Wisconsin | 55053 | 95 | 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);