ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where date = "2020-04-26" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
92404 | 92404 | 2020-04-26 | Adams | Wisconsin | 55001 | 4 | 1 |
92405 | 92405 | 2020-04-26 | Ashland | Wisconsin | 55003 | 2 | 0 |
92406 | 92406 | 2020-04-26 | Barron | Wisconsin | 55005 | 6 | 0 |
92407 | 92407 | 2020-04-26 | Bayfield | Wisconsin | 55007 | 3 | 1 |
92408 | 92408 | 2020-04-26 | Brown | Wisconsin | 55009 | 776 | 2 |
92409 | 92409 | 2020-04-26 | Buffalo | Wisconsin | 55011 | 4 | 1 |
92410 | 92410 | 2020-04-26 | Calumet | Wisconsin | 55015 | 7 | 0 |
92411 | 92411 | 2020-04-26 | Chippewa | Wisconsin | 55017 | 20 | 0 |
92412 | 92412 | 2020-04-26 | Clark | Wisconsin | 55019 | 19 | 2 |
92413 | 92413 | 2020-04-26 | Columbia | Wisconsin | 55021 | 27 | 1 |
92414 | 92414 | 2020-04-26 | Crawford | Wisconsin | 55023 | 3 | 0 |
92415 | 92415 | 2020-04-26 | Dane | Wisconsin | 55025 | 405 | 21 |
92416 | 92416 | 2020-04-26 | Dodge | Wisconsin | 55027 | 29 | 1 |
92417 | 92417 | 2020-04-26 | Door | Wisconsin | 55029 | 10 | 1 |
92418 | 92418 | 2020-04-26 | Douglas | Wisconsin | 55031 | 9 | 0 |
92419 | 92419 | 2020-04-26 | Dunn | Wisconsin | 55033 | 9 | 0 |
92420 | 92420 | 2020-04-26 | Eau Claire | Wisconsin | 55035 | 25 | 0 |
92421 | 92421 | 2020-04-26 | Florence | Wisconsin | 55037 | 2 | 0 |
92422 | 92422 | 2020-04-26 | Fond du Lac | Wisconsin | 55039 | 69 | 3 |
92423 | 92423 | 2020-04-26 | Grant | Wisconsin | 55043 | 30 | 3 |
92424 | 92424 | 2020-04-26 | Green | Wisconsin | 55045 | 11 | 0 |
92425 | 92425 | 2020-04-26 | Green Lake | Wisconsin | 55047 | 1 | 0 |
92426 | 92426 | 2020-04-26 | Iowa | Wisconsin | 55049 | 7 | 0 |
92427 | 92427 | 2020-04-26 | Iron | Wisconsin | 55051 | 2 | 1 |
92428 | 92428 | 2020-04-26 | Jackson | Wisconsin | 55053 | 12 | 1 |
92429 | 92429 | 2020-04-26 | Jefferson | Wisconsin | 55055 | 39 | 0 |
92430 | 92430 | 2020-04-26 | Juneau | Wisconsin | 55057 | 12 | 1 |
92431 | 92431 | 2020-04-26 | Kenosha | Wisconsin | 55059 | 339 | 7 |
92432 | 92432 | 2020-04-26 | Kewaunee | Wisconsin | 55061 | 10 | 1 |
92433 | 92433 | 2020-04-26 | La Crosse | Wisconsin | 55063 | 26 | 0 |
92434 | 92434 | 2020-04-26 | Lafayette | Wisconsin | 55065 | 4 | 0 |
92435 | 92435 | 2020-04-26 | Manitowoc | Wisconsin | 55071 | 10 | 1 |
92436 | 92436 | 2020-04-26 | Marathon | Wisconsin | 55073 | 17 | 1 |
92437 | 92437 | 2020-04-26 | Marinette | Wisconsin | 55075 | 7 | 1 |
92438 | 92438 | 2020-04-26 | Marquette | Wisconsin | 55077 | 3 | 1 |
92439 | 92439 | 2020-04-26 | Menominee | Wisconsin | 55078 | 1 | 0 |
92440 | 92440 | 2020-04-26 | Milwaukee | Wisconsin | 55079 | 2629 | 162 |
92441 | 92441 | 2020-04-26 | Monroe | Wisconsin | 55081 | 14 | 0 |
92442 | 92442 | 2020-04-26 | Oconto | Wisconsin | 55083 | 7 | 0 |
92443 | 92443 | 2020-04-26 | Oneida | Wisconsin | 55085 | 6 | 0 |
92444 | 92444 | 2020-04-26 | Outagamie | Wisconsin | 55087 | 46 | 2 |
92445 | 92445 | 2020-04-26 | Ozaukee | Wisconsin | 55089 | 85 | 9 |
92446 | 92446 | 2020-04-26 | Pierce | Wisconsin | 55093 | 9 | 0 |
92447 | 92447 | 2020-04-26 | Polk | Wisconsin | 55095 | 4 | 0 |
92448 | 92448 | 2020-04-26 | Portage | Wisconsin | 55097 | 4 | 0 |
92449 | 92449 | 2020-04-26 | Price | Wisconsin | 55099 | 1 | 0 |
92450 | 92450 | 2020-04-26 | Racine | Wisconsin | 55101 | 345 | 10 |
92451 | 92451 | 2020-04-26 | Richland | Wisconsin | 55103 | 11 | 1 |
92452 | 92452 | 2020-04-26 | Rock | Wisconsin | 55105 | 151 | 5 |
92453 | 92453 | 2020-04-26 | Rusk | Wisconsin | 55107 | 4 | 0 |
92454 | 92454 | 2020-04-26 | Sauk | Wisconsin | 55111 | 40 | 3 |
92455 | 92455 | 2020-04-26 | Sawyer | Wisconsin | 55113 | 3 | 0 |
92456 | 92456 | 2020-04-26 | Shawano | Wisconsin | 55115 | 8 | 0 |
92457 | 92457 | 2020-04-26 | Sheboygan | Wisconsin | 55117 | 45 | 2 |
92458 | 92458 | 2020-04-26 | St. Croix | Wisconsin | 55109 | 13 | 0 |
92459 | 92459 | 2020-04-26 | Trempealeau | Wisconsin | 55121 | 2 | 0 |
92460 | 92460 | 2020-04-26 | Vernon | Wisconsin | 55123 | 1 | 0 |
92461 | 92461 | 2020-04-26 | Vilas | Wisconsin | 55125 | 4 | 0 |
92462 | 92462 | 2020-04-26 | Walworth | Wisconsin | 55127 | 135 | 8 |
92463 | 92463 | 2020-04-26 | Washburn | Wisconsin | 55129 | 1 | 0 |
92464 | 92464 | 2020-04-26 | Washington | Wisconsin | 55131 | 92 | 4 |
92465 | 92465 | 2020-04-26 | Waukesha | Wisconsin | 55133 | 307 | 14 |
92466 | 92466 | 2020-04-26 | Waupaca | Wisconsin | 55135 | 7 | 1 |
92467 | 92467 | 2020-04-26 | Waushara | Wisconsin | 55137 | 2 | 0 |
92468 | 92468 | 2020-04-26 | Winnebago | Wisconsin | 55139 | 48 | 1 |
92469 | 92469 | 2020-04-26 | 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);