ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where "date" is on date 2020-08-11 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
424466 | 424466 | 2020-08-11 | Adams | Wisconsin | 55001 | 86 | 2 |
424467 | 424467 | 2020-08-11 | Ashland | Wisconsin | 55003 | 26 | 1 |
424468 | 424468 | 2020-08-11 | Barron | Wisconsin | 55005 | 296 | 3 |
424469 | 424469 | 2020-08-11 | Bayfield | Wisconsin | 55007 | 29 | 1 |
424470 | 424470 | 2020-08-11 | Brown | Wisconsin | 55009 | 4340 | 54 |
424471 | 424471 | 2020-08-11 | Buffalo | Wisconsin | 55011 | 44 | 2 |
424472 | 424472 | 2020-08-11 | Burnett | Wisconsin | 55013 | 22 | 1 |
424473 | 424473 | 2020-08-11 | Calumet | Wisconsin | 55015 | 334 | 2 |
424474 | 424474 | 2020-08-11 | Chippewa | Wisconsin | 55017 | 241 | 0 |
424475 | 424475 | 2020-08-11 | Clark | Wisconsin | 55019 | 189 | 8 |
424476 | 424476 | 2020-08-11 | Columbia | Wisconsin | 55021 | 255 | 2 |
424477 | 424477 | 2020-08-11 | Crawford | Wisconsin | 55023 | 76 | 0 |
424478 | 424478 | 2020-08-11 | Dane | Wisconsin | 55025 | 4578 | 38 |
424479 | 424479 | 2020-08-11 | Dodge | Wisconsin | 55027 | 845 | 5 |
424480 | 424480 | 2020-08-11 | Door | Wisconsin | 55029 | 107 | 3 |
424481 | 424481 | 2020-08-11 | Douglas | Wisconsin | 55031 | 191 | 0 |
424482 | 424482 | 2020-08-11 | Dunn | Wisconsin | 55033 | 128 | 0 |
424483 | 424483 | 2020-08-11 | Eau Claire | Wisconsin | 55035 | 596 | 4 |
424484 | 424484 | 2020-08-11 | Florence | Wisconsin | 55037 | 8 | 0 |
424485 | 424485 | 2020-08-11 | Fond du Lac | Wisconsin | 55039 | 676 | 7 |
424486 | 424486 | 2020-08-11 | Forest | Wisconsin | 55041 | 60 | 4 |
424487 | 424487 | 2020-08-11 | Grant | Wisconsin | 55043 | 362 | 15 |
424488 | 424488 | 2020-08-11 | Green | Wisconsin | 55045 | 169 | 1 |
424489 | 424489 | 2020-08-11 | Green Lake | Wisconsin | 55047 | 57 | 0 |
424490 | 424490 | 2020-08-11 | Iowa | Wisconsin | 55049 | 83 | 0 |
424491 | 424491 | 2020-08-11 | Iron | Wisconsin | 55051 | 76 | 1 |
424492 | 424492 | 2020-08-11 | Jackson | Wisconsin | 55053 | 58 | 1 |
424493 | 424493 | 2020-08-11 | Jefferson | Wisconsin | 55055 | 647 | 5 |
424494 | 424494 | 2020-08-11 | Juneau | Wisconsin | 55057 | 138 | 1 |
424495 | 424495 | 2020-08-11 | Kenosha | Wisconsin | 55059 | 2694 | 60 |
424496 | 424496 | 2020-08-11 | Kewaunee | Wisconsin | 55061 | 135 | 2 |
424497 | 424497 | 2020-08-11 | La Crosse | Wisconsin | 55063 | 921 | 1 |
424498 | 424498 | 2020-08-11 | Lafayette | Wisconsin | 55065 | 147 | 0 |
424499 | 424499 | 2020-08-11 | Langlade | Wisconsin | 55067 | 63 | 1 |
424500 | 424500 | 2020-08-11 | Lincoln | Wisconsin | 55069 | 69 | 0 |
424501 | 424501 | 2020-08-11 | Manitowoc | Wisconsin | 55071 | 351 | 1 |
424502 | 424502 | 2020-08-11 | Marathon | Wisconsin | 55073 | 662 | 10 |
424503 | 424503 | 2020-08-11 | Marinette | Wisconsin | 55075 | 432 | 4 |
424504 | 424504 | 2020-08-11 | Marquette | Wisconsin | 55077 | 80 | 1 |
424505 | 424505 | 2020-08-11 | Menominee | Wisconsin | 55078 | 25 | 0 |
424506 | 424506 | 2020-08-11 | Milwaukee | Wisconsin | 55079 | 21331 | 458 |
424507 | 424507 | 2020-08-11 | Monroe | Wisconsin | 55081 | 245 | 2 |
424508 | 424508 | 2020-08-11 | Oconto | Wisconsin | 55083 | 259 | 0 |
424509 | 424509 | 2020-08-11 | Oneida | Wisconsin | 55085 | 153 | 0 |
424510 | 424510 | 2020-08-11 | Outagamie | Wisconsin | 55087 | 1299 | 14 |
424511 | 424511 | 2020-08-11 | Ozaukee | Wisconsin | 55089 | 737 | 18 |
424512 | 424512 | 2020-08-11 | Pepin | Wisconsin | 55091 | 42 | 0 |
424513 | 424513 | 2020-08-11 | Pierce | Wisconsin | 55093 | 224 | 3 |
424514 | 424514 | 2020-08-11 | Polk | Wisconsin | 55095 | 137 | 2 |
424515 | 424515 | 2020-08-11 | Portage | Wisconsin | 55097 | 426 | 0 |
424516 | 424516 | 2020-08-11 | Price | Wisconsin | 55099 | 33 | 0 |
424517 | 424517 | 2020-08-11 | Racine | Wisconsin | 55101 | 3980 | 79 |
424518 | 424518 | 2020-08-11 | Richland | Wisconsin | 55103 | 37 | 4 |
424519 | 424519 | 2020-08-11 | Rock | Wisconsin | 55105 | 1580 | 26 |
424520 | 424520 | 2020-08-11 | Rusk | Wisconsin | 55107 | 21 | 1 |
424521 | 424521 | 2020-08-11 | Sauk | Wisconsin | 55111 | 452 | 3 |
424522 | 424522 | 2020-08-11 | Sawyer | Wisconsin | 55113 | 76 | 0 |
424523 | 424523 | 2020-08-11 | Shawano | Wisconsin | 55115 | 204 | 0 |
424524 | 424524 | 2020-08-11 | Sheboygan | Wisconsin | 55117 | 776 | 8 |
424525 | 424525 | 2020-08-11 | St. Croix | Wisconsin | 55109 | 512 | 7 |
424526 | 424526 | 2020-08-11 | Taylor | Wisconsin | 55119 | 71 | 1 |
424527 | 424527 | 2020-08-11 | Trempealeau | Wisconsin | 55121 | 345 | 2 |
424528 | 424528 | 2020-08-11 | Unknown | Wisconsin | 3789 | 7 | |
424529 | 424529 | 2020-08-11 | Vernon | Wisconsin | 55123 | 66 | 0 |
424530 | 424530 | 2020-08-11 | Vilas | Wisconsin | 55125 | 60 | 0 |
424531 | 424531 | 2020-08-11 | Walworth | Wisconsin | 55127 | 1359 | 23 |
424532 | 424532 | 2020-08-11 | Washburn | Wisconsin | 55129 | 47 | 0 |
424533 | 424533 | 2020-08-11 | Washington | Wisconsin | 55131 | 1108 | 23 |
424534 | 424534 | 2020-08-11 | Waukesha | Wisconsin | 55133 | 4354 | 59 |
424535 | 424535 | 2020-08-11 | Waupaca | Wisconsin | 55135 | 473 | 15 |
424536 | 424536 | 2020-08-11 | Waushara | Wisconsin | 55137 | 120 | 1 |
424537 | 424537 | 2020-08-11 | Winnebago | Wisconsin | 55139 | 1212 | 18 |
424538 | 424538 | 2020-08-11 | Wood | Wisconsin | 55141 | 322 | 2 |
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);