ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
999 rows where deaths = 3 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Sauk 167
- Door 158
- Marinette 66
- Barron 46
- Fond du Lac 36
- Taylor 34
- Forest 31
- Buffalo 28
- Sheboygan 28
- Adams 27
- Price 27
- Ashland 23
- Green 23
- Monroe 22
- Waushara 21
- Jefferson 19
- Wood 19
- Washington 18
- Polk 17
- Columbia 15
- Burnett 13
- Eau Claire 13
- Vernon 10
- Bayfield 9
- Lafayette 9
- Portage 9
- Grant 7
- Manitowoc 7
- Vilas 7
- Juneau 5
- …
state 1
- Wisconsin · 999 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
813289 | 813289 | 2020-12-09 | Pepin | Wisconsin | 55091 | 538 | 3 |
810045 | 810045 | 2020-12-08 | Pepin | Wisconsin | 55091 | 529 | 3 |
784072 | 784072 | 2020-11-30 | Lafayette | Wisconsin | 55065 | 1121 | 3 |
784105 | 784105 | 2020-11-30 | Washburn | Wisconsin | 55129 | 732 | 3 |
780827 | 780827 | 2020-11-29 | Lafayette | Wisconsin | 55065 | 1115 | 3 |
780860 | 780860 | 2020-11-29 | Washburn | Wisconsin | 55129 | 722 | 3 |
777581 | 777581 | 2020-11-28 | Lafayette | Wisconsin | 55065 | 1101 | 3 |
774336 | 774336 | 2020-11-27 | Lafayette | Wisconsin | 55065 | 1095 | 3 |
771091 | 771091 | 2020-11-26 | Lafayette | Wisconsin | 55065 | 1082 | 3 |
767845 | 767845 | 2020-11-25 | Lafayette | Wisconsin | 55065 | 1070 | 3 |
764600 | 764600 | 2020-11-24 | Lafayette | Wisconsin | 55065 | 1060 | 3 |
764618 | 764618 | 2020-11-24 | Price | Wisconsin | 55099 | 709 | 3 |
761355 | 761355 | 2020-11-23 | Lafayette | Wisconsin | 55065 | 1053 | 3 |
761373 | 761373 | 2020-11-23 | Price | Wisconsin | 55099 | 700 | 3 |
758110 | 758110 | 2020-11-22 | Lafayette | Wisconsin | 55065 | 1043 | 3 |
758128 | 758128 | 2020-11-22 | Price | Wisconsin | 55099 | 689 | 3 |
754881 | 754881 | 2020-11-21 | Price | Wisconsin | 55099 | 676 | 3 |
751635 | 751635 | 2020-11-20 | Price | Wisconsin | 55099 | 668 | 3 |
748389 | 748389 | 2020-11-19 | Price | Wisconsin | 55099 | 651 | 3 |
745143 | 745143 | 2020-11-18 | Price | Wisconsin | 55099 | 642 | 3 |
741851 | 741851 | 2020-11-17 | Buffalo | Wisconsin | 55011 | 612 | 3 |
741896 | 741896 | 2020-11-17 | Price | Wisconsin | 55099 | 621 | 3 |
738604 | 738604 | 2020-11-16 | Buffalo | Wisconsin | 55011 | 593 | 3 |
738615 | 738615 | 2020-11-16 | Dunn | Wisconsin | 55033 | 2148 | 3 |
738625 | 738625 | 2020-11-16 | Jackson | Wisconsin | 55053 | 1278 | 3 |
738649 | 738649 | 2020-11-16 | Price | Wisconsin | 55099 | 605 | 3 |
735360 | 735360 | 2020-11-15 | Buffalo | Wisconsin | 55011 | 579 | 3 |
735371 | 735371 | 2020-11-15 | Dunn | Wisconsin | 55033 | 2068 | 3 |
735405 | 735405 | 2020-11-15 | Price | Wisconsin | 55099 | 600 | 3 |
732112 | 732112 | 2020-11-14 | Bayfield | Wisconsin | 55007 | 519 | 3 |
732114 | 732114 | 2020-11-14 | Buffalo | Wisconsin | 55011 | 562 | 3 |
732159 | 732159 | 2020-11-14 | Price | Wisconsin | 55099 | 572 | 3 |
728867 | 728867 | 2020-11-13 | Bayfield | Wisconsin | 55007 | 501 | 3 |
728869 | 728869 | 2020-11-13 | Buffalo | Wisconsin | 55011 | 549 | 3 |
728914 | 728914 | 2020-11-13 | Price | Wisconsin | 55099 | 568 | 3 |
725624 | 725624 | 2020-11-12 | Bayfield | Wisconsin | 55007 | 482 | 3 |
725626 | 725626 | 2020-11-12 | Buffalo | Wisconsin | 55011 | 518 | 3 |
725671 | 725671 | 2020-11-12 | Price | Wisconsin | 55099 | 557 | 3 |
722381 | 722381 | 2020-11-11 | Bayfield | Wisconsin | 55007 | 454 | 3 |
722383 | 722383 | 2020-11-11 | Buffalo | Wisconsin | 55011 | 498 | 3 |
722389 | 722389 | 2020-11-11 | Crawford | Wisconsin | 55023 | 573 | 3 |
722428 | 722428 | 2020-11-11 | Price | Wisconsin | 55099 | 542 | 3 |
719138 | 719138 | 2020-11-10 | Bayfield | Wisconsin | 55007 | 446 | 3 |
719140 | 719140 | 2020-11-10 | Buffalo | Wisconsin | 55011 | 474 | 3 |
719146 | 719146 | 2020-11-10 | Crawford | Wisconsin | 55023 | 548 | 3 |
719185 | 719185 | 2020-11-10 | Price | Wisconsin | 55099 | 528 | 3 |
719189 | 719189 | 2020-11-10 | Rusk | Wisconsin | 55107 | 433 | 3 |
719197 | 719197 | 2020-11-10 | Vernon | Wisconsin | 55123 | 716 | 3 |
715895 | 715895 | 2020-11-09 | Bayfield | Wisconsin | 55007 | 418 | 3 |
715897 | 715897 | 2020-11-09 | Buffalo | Wisconsin | 55011 | 454 | 3 |
715942 | 715942 | 2020-11-09 | Price | Wisconsin | 55099 | 514 | 3 |
712651 | 712651 | 2020-11-08 | Bayfield | Wisconsin | 55007 | 402 | 3 |
712653 | 712653 | 2020-11-08 | Buffalo | Wisconsin | 55011 | 450 | 3 |
712696 | 712696 | 2020-11-08 | Polk | Wisconsin | 55095 | 977 | 3 |
712698 | 712698 | 2020-11-08 | Price | Wisconsin | 55099 | 508 | 3 |
709407 | 709407 | 2020-11-07 | Bayfield | Wisconsin | 55007 | 393 | 3 |
709409 | 709409 | 2020-11-07 | Buffalo | Wisconsin | 55011 | 440 | 3 |
709452 | 709452 | 2020-11-07 | Polk | Wisconsin | 55095 | 960 | 3 |
709454 | 709454 | 2020-11-07 | Price | Wisconsin | 55099 | 499 | 3 |
706163 | 706163 | 2020-11-06 | Bayfield | Wisconsin | 55007 | 371 | 3 |
706165 | 706165 | 2020-11-06 | Buffalo | Wisconsin | 55011 | 418 | 3 |
706208 | 706208 | 2020-11-06 | Polk | Wisconsin | 55095 | 960 | 3 |
706210 | 706210 | 2020-11-06 | Price | Wisconsin | 55099 | 493 | 3 |
702922 | 702922 | 2020-11-05 | Buffalo | Wisconsin | 55011 | 394 | 3 |
702965 | 702965 | 2020-11-05 | Polk | Wisconsin | 55095 | 871 | 3 |
702967 | 702967 | 2020-11-05 | Price | Wisconsin | 55099 | 472 | 3 |
699675 | 699675 | 2020-11-04 | Ashland | Wisconsin | 55003 | 349 | 3 |
699679 | 699679 | 2020-11-04 | Buffalo | Wisconsin | 55011 | 380 | 3 |
699722 | 699722 | 2020-11-04 | Polk | Wisconsin | 55095 | 823 | 3 |
699724 | 699724 | 2020-11-04 | Price | Wisconsin | 55099 | 457 | 3 |
696431 | 696431 | 2020-11-03 | Ashland | Wisconsin | 55003 | 334 | 3 |
696435 | 696435 | 2020-11-03 | Buffalo | Wisconsin | 55011 | 361 | 3 |
696478 | 696478 | 2020-11-03 | Polk | Wisconsin | 55095 | 786 | 3 |
696480 | 696480 | 2020-11-03 | Price | Wisconsin | 55099 | 446 | 3 |
693189 | 693189 | 2020-11-02 | Ashland | Wisconsin | 55003 | 317 | 3 |
693193 | 693193 | 2020-11-02 | Buffalo | Wisconsin | 55011 | 350 | 3 |
693236 | 693236 | 2020-11-02 | Polk | Wisconsin | 55095 | 743 | 3 |
693238 | 693238 | 2020-11-02 | Price | Wisconsin | 55099 | 436 | 3 |
689945 | 689945 | 2020-11-01 | Ashland | Wisconsin | 55003 | 311 | 3 |
689949 | 689949 | 2020-11-01 | Buffalo | Wisconsin | 55011 | 345 | 3 |
689992 | 689992 | 2020-11-01 | Polk | Wisconsin | 55095 | 680 | 3 |
689994 | 689994 | 2020-11-01 | Price | Wisconsin | 55099 | 430 | 3 |
686700 | 686700 | 2020-10-31 | Ashland | Wisconsin | 55003 | 310 | 3 |
686704 | 686704 | 2020-10-31 | Buffalo | Wisconsin | 55011 | 337 | 3 |
686747 | 686747 | 2020-10-31 | Polk | Wisconsin | 55095 | 656 | 3 |
686749 | 686749 | 2020-10-31 | Price | Wisconsin | 55099 | 427 | 3 |
683457 | 683457 | 2020-10-30 | Ashland | Wisconsin | 55003 | 301 | 3 |
683461 | 683461 | 2020-10-30 | Buffalo | Wisconsin | 55011 | 316 | 3 |
683504 | 683504 | 2020-10-30 | Polk | Wisconsin | 55095 | 643 | 3 |
683506 | 683506 | 2020-10-30 | Price | Wisconsin | 55099 | 401 | 3 |
683512 | 683512 | 2020-10-30 | Sawyer | Wisconsin | 55113 | 403 | 3 |
683517 | 683517 | 2020-10-30 | Trempealeau | Wisconsin | 55121 | 1124 | 3 |
680214 | 680214 | 2020-10-29 | Ashland | Wisconsin | 55003 | 295 | 3 |
680218 | 680218 | 2020-10-29 | Buffalo | Wisconsin | 55011 | 301 | 3 |
680236 | 680236 | 2020-10-29 | Green Lake | Wisconsin | 55047 | 882 | 3 |
680261 | 680261 | 2020-10-29 | Polk | Wisconsin | 55095 | 607 | 3 |
680263 | 680263 | 2020-10-29 | Price | Wisconsin | 55099 | 391 | 3 |
680269 | 680269 | 2020-10-29 | Sawyer | Wisconsin | 55113 | 394 | 3 |
680274 | 680274 | 2020-10-29 | Trempealeau | Wisconsin | 55121 | 1088 | 3 |
676971 | 676971 | 2020-10-28 | Ashland | Wisconsin | 55003 | 291 | 3 |
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);