ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2020-05-02 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
109517 | 109517 | 2020-05-02 | Adams | Wisconsin | 55001 | 4 | 1 |
109518 | 109518 | 2020-05-02 | Ashland | Wisconsin | 55003 | 2 | 0 |
109519 | 109519 | 2020-05-02 | Barron | Wisconsin | 55005 | 7 | 0 |
109520 | 109520 | 2020-05-02 | Bayfield | Wisconsin | 55007 | 3 | 1 |
109521 | 109521 | 2020-05-02 | Brown | Wisconsin | 55009 | 1272 | 6 |
109522 | 109522 | 2020-05-02 | Buffalo | Wisconsin | 55011 | 4 | 1 |
109523 | 109523 | 2020-05-02 | Calumet | Wisconsin | 55015 | 16 | 0 |
109524 | 109524 | 2020-05-02 | Chippewa | Wisconsin | 55017 | 23 | 0 |
109525 | 109525 | 2020-05-02 | Clark | Wisconsin | 55019 | 20 | 4 |
109526 | 109526 | 2020-05-02 | Columbia | Wisconsin | 55021 | 29 | 1 |
109527 | 109527 | 2020-05-02 | Crawford | Wisconsin | 55023 | 4 | 0 |
109528 | 109528 | 2020-05-02 | Dane | Wisconsin | 55025 | 433 | 22 |
109529 | 109529 | 2020-05-02 | Dodge | Wisconsin | 55027 | 38 | 1 |
109530 | 109530 | 2020-05-02 | Door | Wisconsin | 55029 | 14 | 3 |
109531 | 109531 | 2020-05-02 | Douglas | Wisconsin | 55031 | 9 | 0 |
109532 | 109532 | 2020-05-02 | Dunn | Wisconsin | 55033 | 10 | 0 |
109533 | 109533 | 2020-05-02 | Eau Claire | Wisconsin | 55035 | 34 | 0 |
109534 | 109534 | 2020-05-02 | Florence | Wisconsin | 55037 | 2 | 0 |
109535 | 109535 | 2020-05-02 | Fond du Lac | Wisconsin | 55039 | 73 | 3 |
109536 | 109536 | 2020-05-02 | Grant | Wisconsin | 55043 | 43 | 6 |
109537 | 109537 | 2020-05-02 | Green | Wisconsin | 55045 | 13 | 0 |
109538 | 109538 | 2020-05-02 | Green Lake | Wisconsin | 55047 | 3 | 0 |
109539 | 109539 | 2020-05-02 | Iowa | Wisconsin | 55049 | 7 | 0 |
109540 | 109540 | 2020-05-02 | Iron | Wisconsin | 55051 | 2 | 1 |
109541 | 109541 | 2020-05-02 | Jackson | Wisconsin | 55053 | 12 | 1 |
109542 | 109542 | 2020-05-02 | Jefferson | Wisconsin | 55055 | 46 | 0 |
109543 | 109543 | 2020-05-02 | Juneau | Wisconsin | 55057 | 18 | 1 |
109544 | 109544 | 2020-05-02 | Kenosha | Wisconsin | 55059 | 521 | 13 |
109545 | 109545 | 2020-05-02 | Kewaunee | Wisconsin | 55061 | 15 | 1 |
109546 | 109546 | 2020-05-02 | La Crosse | Wisconsin | 55063 | 29 | 0 |
109547 | 109547 | 2020-05-02 | Lafayette | Wisconsin | 55065 | 6 | 0 |
109548 | 109548 | 2020-05-02 | Lincoln | Wisconsin | 55069 | 1 | 0 |
109549 | 109549 | 2020-05-02 | Manitowoc | Wisconsin | 55071 | 13 | 1 |
109550 | 109550 | 2020-05-02 | Marathon | Wisconsin | 55073 | 19 | 1 |
109551 | 109551 | 2020-05-02 | Marinette | Wisconsin | 55075 | 10 | 1 |
109552 | 109552 | 2020-05-02 | Marquette | Wisconsin | 55077 | 3 | 1 |
109553 | 109553 | 2020-05-02 | Menominee | Wisconsin | 55078 | 1 | 0 |
109554 | 109554 | 2020-05-02 | Milwaukee | Wisconsin | 55079 | 3147 | 191 |
109555 | 109555 | 2020-05-02 | Monroe | Wisconsin | 55081 | 14 | 1 |
109556 | 109556 | 2020-05-02 | Oconto | Wisconsin | 55083 | 15 | 0 |
109557 | 109557 | 2020-05-02 | Oneida | Wisconsin | 55085 | 6 | 0 |
109558 | 109558 | 2020-05-02 | Outagamie | Wisconsin | 55087 | 63 | 2 |
109559 | 109559 | 2020-05-02 | Ozaukee | Wisconsin | 55089 | 89 | 9 |
109560 | 109560 | 2020-05-02 | Pierce | Wisconsin | 55093 | 10 | 0 |
109561 | 109561 | 2020-05-02 | Polk | Wisconsin | 55095 | 4 | 0 |
109562 | 109562 | 2020-05-02 | Portage | Wisconsin | 55097 | 6 | 0 |
109563 | 109563 | 2020-05-02 | Price | Wisconsin | 55099 | 1 | 0 |
109564 | 109564 | 2020-05-02 | Racine | Wisconsin | 55101 | 533 | 13 |
109565 | 109565 | 2020-05-02 | Richland | Wisconsin | 55103 | 12 | 2 |
109566 | 109566 | 2020-05-02 | Rock | Wisconsin | 55105 | 243 | 7 |
109567 | 109567 | 2020-05-02 | Rusk | Wisconsin | 55107 | 4 | 0 |
109568 | 109568 | 2020-05-02 | Sauk | Wisconsin | 55111 | 64 | 3 |
109569 | 109569 | 2020-05-02 | Sawyer | Wisconsin | 55113 | 3 | 0 |
109570 | 109570 | 2020-05-02 | Shawano | Wisconsin | 55115 | 16 | 0 |
109571 | 109571 | 2020-05-02 | Sheboygan | Wisconsin | 55117 | 51 | 2 |
109572 | 109572 | 2020-05-02 | St. Croix | Wisconsin | 55109 | 16 | 0 |
109573 | 109573 | 2020-05-02 | Trempealeau | Wisconsin | 55121 | 3 | 0 |
109574 | 109574 | 2020-05-02 | Vernon | Wisconsin | 55123 | 1 | 0 |
109575 | 109575 | 2020-05-02 | Vilas | Wisconsin | 55125 | 4 | 0 |
109576 | 109576 | 2020-05-02 | Walworth | Wisconsin | 55127 | 183 | 8 |
109577 | 109577 | 2020-05-02 | Washburn | Wisconsin | 55129 | 1 | 0 |
109578 | 109578 | 2020-05-02 | Washington | Wisconsin | 55131 | 100 | 4 |
109579 | 109579 | 2020-05-02 | Waukesha | Wisconsin | 55133 | 356 | 20 |
109580 | 109580 | 2020-05-02 | Waupaca | Wisconsin | 55135 | 10 | 1 |
109581 | 109581 | 2020-05-02 | Waushara | Wisconsin | 55137 | 2 | 0 |
109582 | 109582 | 2020-05-02 | Winnebago | Wisconsin | 55139 | 67 | 1 |
109583 | 109583 | 2020-05-02 | Wood | Wisconsin | 55141 | 2 | 0 |
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);