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 428
- 55093 395
- 55039 393
- 55133 393
- 55079 391
- 55101 391
- 55117 391
- 55139 390
- 55087 388
- 55141 388
- 55059 387
- 55009 386
- 55063 386
- 55131 386
- 55007 385
- 55015 385
- 55021 385
- 55035 385
- 55089 385
- 55111 385
- 55127 385
- 55017 384
- 55031 384
- 55033 384
- 55045 384
- 55055 384
- 55073 384
- 55105 384
- 55109 384
- 55027 381
- …
county >30
- Dane 428
- Pierce 395
- Fond du Lac 393
- Waukesha 393
- Milwaukee 391
- Racine 391
- Sheboygan 391
- Winnebago 390
- Outagamie 388
- Wood 388
- Kenosha 387
- Brown 386
- La Crosse 386
- Washington 386
- Bayfield 385
- Calumet 385
- Columbia 385
- Eau Claire 385
- Ozaukee 385
- Sauk 385
- Walworth 385
- Chippewa 384
- Douglas 384
- Dunn 384
- Green 384
- Jefferson 384
- Marathon 384
- Rock 384
- St. Croix 384
- Dodge 381
- …
state 1
- Wisconsin · 27,119 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199511 | 1199511 | 2021-04-07 | Adams | Wisconsin | 55001 | 1822 | 15 |
1199512 | 1199512 | 2021-04-07 | Ashland | Wisconsin | 55003 | 1291 | 16 |
1199513 | 1199513 | 2021-04-07 | Barron | Wisconsin | 55005 | 5724 | 76 |
1199514 | 1199514 | 2021-04-07 | Bayfield | Wisconsin | 55007 | 1206 | 19 |
1199515 | 1199515 | 2021-04-07 | Brown | Wisconsin | 55009 | 34027 | 272 |
1199516 | 1199516 | 2021-04-07 | Buffalo | Wisconsin | 55011 | 1363 | 7 |
1199517 | 1199517 | 2021-04-07 | Burnett | Wisconsin | 55013 | 1389 | 22 |
1199518 | 1199518 | 2021-04-07 | Calumet | Wisconsin | 55015 | 6270 | 50 |
1199519 | 1199519 | 2021-04-07 | Chippewa | Wisconsin | 55017 | 7395 | 96 |
1199520 | 1199520 | 2021-04-07 | Clark | Wisconsin | 55019 | 3571 | 62 |
1199521 | 1199521 | 2021-04-07 | Columbia | Wisconsin | 55021 | 5611 | 68 |
1199522 | 1199522 | 2021-04-07 | Crawford | Wisconsin | 55023 | 1737 | 17 |
1199523 | 1199523 | 2021-04-07 | Dane | Wisconsin | 55025 | 44022 | 312 |
1199524 | 1199524 | 2021-04-07 | Dodge | Wisconsin | 55027 | 12462 | 182 |
1199525 | 1199525 | 2021-04-07 | Door | Wisconsin | 55029 | 2751 | 26 |
1199526 | 1199526 | 2021-04-07 | Douglas | Wisconsin | 55031 | 4483 | 47 |
1199527 | 1199527 | 2021-04-07 | Dunn | Wisconsin | 55033 | 4845 | 31 |
1199528 | 1199528 | 2021-04-07 | Eau Claire | Wisconsin | 55035 | 11644 | 117 |
1199529 | 1199529 | 2021-04-07 | Florence | Wisconsin | 55037 | 484 | 12 |
1199530 | 1199530 | 2021-04-07 | Fond du Lac | Wisconsin | 55039 | 13327 | 114 |
1199531 | 1199531 | 2021-04-07 | Forest | Wisconsin | 55041 | 1012 | 26 |
1199532 | 1199532 | 2021-04-07 | Grant | Wisconsin | 55043 | 5506 | 89 |
1199533 | 1199533 | 2021-04-07 | Green | Wisconsin | 55045 | 3504 | 23 |
1199534 | 1199534 | 2021-04-07 | Green Lake | Wisconsin | 55047 | 1979 | 22 |
1199535 | 1199535 | 2021-04-07 | Iowa | Wisconsin | 55049 | 2050 | 11 |
1199536 | 1199536 | 2021-04-07 | Iron | Wisconsin | 55051 | 687 | 40 |
1199537 | 1199537 | 2021-04-07 | Jackson | Wisconsin | 55053 | 2645 | 28 |
1199538 | 1199538 | 2021-04-07 | Jefferson | Wisconsin | 55055 | 9252 | 128 |
1199539 | 1199539 | 2021-04-07 | Juneau | Wisconsin | 55057 | 3155 | 25 |
1199540 | 1199540 | 2021-04-07 | Kenosha | Wisconsin | 55059 | 17631 | 319 |
1199541 | 1199541 | 2021-04-07 | Kewaunee | Wisconsin | 55061 | 2625 | 33 |
1199542 | 1199542 | 2021-04-07 | La Crosse | Wisconsin | 55063 | 13257 | 80 |
1199543 | 1199543 | 2021-04-07 | Lafayette | Wisconsin | 55065 | 1664 | 8 |
1199544 | 1199544 | 2021-04-07 | Langlade | Wisconsin | 55067 | 2110 | 46 |
1199545 | 1199545 | 2021-04-07 | Lincoln | Wisconsin | 55069 | 3175 | 87 |
1199546 | 1199546 | 2021-04-07 | Manitowoc | Wisconsin | 55071 | 8559 | 86 |
1199547 | 1199547 | 2021-04-07 | Marathon | Wisconsin | 55073 | 15460 | 218 |
1199548 | 1199548 | 2021-04-07 | Marinette | Wisconsin | 55075 | 4437 | 68 |
1199549 | 1199549 | 2021-04-07 | Marquette | Wisconsin | 55077 | 1525 | 27 |
1199550 | 1199550 | 2021-04-07 | Menominee | Wisconsin | 55078 | 798 | 11 |
1199551 | 1199551 | 2021-04-07 | Milwaukee | Wisconsin | 55079 | 111272 | 1310 |
1199552 | 1199552 | 2021-04-07 | Monroe | Wisconsin | 55081 | 4498 | 37 |
1199553 | 1199553 | 2021-04-07 | Oconto | Wisconsin | 55083 | 4828 | 57 |
1199554 | 1199554 | 2021-04-07 | Oneida | Wisconsin | 55085 | 3674 | 74 |
1199555 | 1199555 | 2021-04-07 | Outagamie | Wisconsin | 55087 | 22815 | 216 |
1199556 | 1199556 | 2021-04-07 | Ozaukee | Wisconsin | 55089 | 8894 | 89 |
1199557 | 1199557 | 2021-04-07 | Pepin | Wisconsin | 55091 | 846 | 7 |
1199558 | 1199558 | 2021-04-07 | Pierce | Wisconsin | 55093 | 4614 | 41 |
1199559 | 1199559 | 2021-04-07 | Polk | Wisconsin | 55095 | 4188 | 48 |
1199560 | 1199560 | 2021-04-07 | Portage | Wisconsin | 55097 | 7133 | 70 |
1199561 | 1199561 | 2021-04-07 | Price | Wisconsin | 55099 | 1288 | 7 |
1199562 | 1199562 | 2021-04-07 | Racine | Wisconsin | 55101 | 23683 | 364 |
1199563 | 1199563 | 2021-04-07 | Richland | Wisconsin | 55103 | 1349 | 15 |
1199564 | 1199564 | 2021-04-07 | Rock | Wisconsin | 55105 | 16676 | 185 |
1199565 | 1199565 | 2021-04-07 | Rusk | Wisconsin | 55107 | 1325 | 17 |
1199566 | 1199566 | 2021-04-07 | Sauk | Wisconsin | 55111 | 5812 | 50 |
1199567 | 1199567 | 2021-04-07 | Sawyer | Wisconsin | 55113 | 1619 | 24 |
1199568 | 1199568 | 2021-04-07 | Shawano | Wisconsin | 55115 | 5198 | 81 |
1199569 | 1199569 | 2021-04-07 | Sheboygan | Wisconsin | 55117 | 14215 | 143 |
1199570 | 1199570 | 2021-04-07 | St. Croix | Wisconsin | 55109 | 8627 | 56 |
1199571 | 1199571 | 2021-04-07 | Taylor | Wisconsin | 55119 | 2065 | 32 |
1199572 | 1199572 | 2021-04-07 | Trempealeau | Wisconsin | 55121 | 3585 | 41 |
1199573 | 1199573 | 2021-04-07 | Vernon | Wisconsin | 55123 | 1951 | 41 |
1199574 | 1199574 | 2021-04-07 | Vilas | Wisconsin | 55125 | 2340 | 41 |
1199575 | 1199575 | 2021-04-07 | Walworth | Wisconsin | 55127 | 11969 | 155 |
1199576 | 1199576 | 2021-04-07 | Washburn | Wisconsin | 55129 | 1441 | 20 |
1199577 | 1199577 | 2021-04-07 | Washington | Wisconsin | 55131 | 16149 | 152 |
1199578 | 1199578 | 2021-04-07 | Waukesha | Wisconsin | 55133 | 47160 | 551 |
1199579 | 1199579 | 2021-04-07 | Waupaca | Wisconsin | 55135 | 5880 | 161 |
1199580 | 1199580 | 2021-04-07 | Waushara | Wisconsin | 55137 | 2442 | 35 |
1199581 | 1199581 | 2021-04-07 | Winnebago | Wisconsin | 55139 | 20599 | 211 |
1199582 | 1199582 | 2021-04-07 | Wood | Wisconsin | 55141 | 7261 | 90 |
1196262 | 1196262 | 2021-04-06 | Adams | Wisconsin | 55001 | 1817 | 15 |
1196263 | 1196263 | 2021-04-06 | Ashland | Wisconsin | 55003 | 1289 | 16 |
1196264 | 1196264 | 2021-04-06 | Barron | Wisconsin | 55005 | 5711 | 76 |
1196265 | 1196265 | 2021-04-06 | Bayfield | Wisconsin | 55007 | 1200 | 19 |
1196266 | 1196266 | 2021-04-06 | Brown | Wisconsin | 55009 | 34003 | 272 |
1196267 | 1196267 | 2021-04-06 | Buffalo | Wisconsin | 55011 | 1363 | 7 |
1196268 | 1196268 | 2021-04-06 | Burnett | Wisconsin | 55013 | 1383 | 22 |
1196269 | 1196269 | 2021-04-06 | Calumet | Wisconsin | 55015 | 6261 | 50 |
1196270 | 1196270 | 2021-04-06 | Chippewa | Wisconsin | 55017 | 7388 | 96 |
1196271 | 1196271 | 2021-04-06 | Clark | Wisconsin | 55019 | 3568 | 62 |
1196272 | 1196272 | 2021-04-06 | Columbia | Wisconsin | 55021 | 5598 | 68 |
1196273 | 1196273 | 2021-04-06 | Crawford | Wisconsin | 55023 | 1734 | 17 |
1196274 | 1196274 | 2021-04-06 | Dane | Wisconsin | 55025 | 43962 | 312 |
1196275 | 1196275 | 2021-04-06 | Dodge | Wisconsin | 55027 | 12451 | 182 |
1196276 | 1196276 | 2021-04-06 | Door | Wisconsin | 55029 | 2745 | 26 |
1196277 | 1196277 | 2021-04-06 | Douglas | Wisconsin | 55031 | 4462 | 47 |
1196278 | 1196278 | 2021-04-06 | Dunn | Wisconsin | 55033 | 4825 | 31 |
1196279 | 1196279 | 2021-04-06 | Eau Claire | Wisconsin | 55035 | 11635 | 117 |
1196280 | 1196280 | 2021-04-06 | Florence | Wisconsin | 55037 | 482 | 12 |
1196281 | 1196281 | 2021-04-06 | Fond du Lac | Wisconsin | 55039 | 13315 | 114 |
1196282 | 1196282 | 2021-04-06 | Forest | Wisconsin | 55041 | 1012 | 26 |
1196283 | 1196283 | 2021-04-06 | Grant | Wisconsin | 55043 | 5495 | 89 |
1196284 | 1196284 | 2021-04-06 | Green | Wisconsin | 55045 | 3501 | 23 |
1196285 | 1196285 | 2021-04-06 | Green Lake | Wisconsin | 55047 | 1977 | 22 |
1196286 | 1196286 | 2021-04-06 | Iowa | Wisconsin | 55049 | 2049 | 11 |
1196287 | 1196287 | 2021-04-06 | Iron | Wisconsin | 55051 | 687 | 40 |
1196288 | 1196288 | 2021-04-06 | Jackson | Wisconsin | 55053 | 2642 | 28 |
1196289 | 1196289 | 2021-04-06 | Jefferson | Wisconsin | 55055 | 9238 | 127 |
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);