ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where date = "2020-09-02" 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 |
---|---|---|---|---|---|---|---|
495513 | 495513 | 2020-09-02 | Adams | Wisconsin | 55001 | 121 | 3 |
495514 | 495514 | 2020-09-02 | Ashland | Wisconsin | 55003 | 35 | 1 |
495515 | 495515 | 2020-09-02 | Barron | Wisconsin | 55005 | 375 | 3 |
495516 | 495516 | 2020-09-02 | Bayfield | Wisconsin | 55007 | 47 | 1 |
495517 | 495517 | 2020-09-02 | Brown | Wisconsin | 55009 | 5508 | 58 |
495518 | 495518 | 2020-09-02 | Buffalo | Wisconsin | 55011 | 69 | 2 |
495519 | 495519 | 2020-09-02 | Burnett | Wisconsin | 55013 | 43 | 2 |
495520 | 495520 | 2020-09-02 | Calumet | Wisconsin | 55015 | 520 | 2 |
495521 | 495521 | 2020-09-02 | Chippewa | Wisconsin | 55017 | 354 | 0 |
495522 | 495522 | 2020-09-02 | Clark | Wisconsin | 55019 | 247 | 8 |
495523 | 495523 | 2020-09-02 | Columbia | Wisconsin | 55021 | 366 | 2 |
495524 | 495524 | 2020-09-02 | Crawford | Wisconsin | 55023 | 107 | 0 |
495525 | 495525 | 2020-09-02 | Dane | Wisconsin | 55025 | 5568 | 40 |
495526 | 495526 | 2020-09-02 | Dodge | Wisconsin | 55027 | 1200 | 5 |
495527 | 495527 | 2020-09-02 | Door | Wisconsin | 55029 | 134 | 3 |
495528 | 495528 | 2020-09-02 | Douglas | Wisconsin | 55031 | 258 | 0 |
495529 | 495529 | 2020-09-02 | Dunn | Wisconsin | 55033 | 179 | 0 |
495530 | 495530 | 2020-09-02 | Eau Claire | Wisconsin | 55035 | 838 | 6 |
495531 | 495531 | 2020-09-02 | Florence | Wisconsin | 55037 | 27 | 0 |
495532 | 495532 | 2020-09-02 | Fond du Lac | Wisconsin | 55039 | 1176 | 10 |
495533 | 495533 | 2020-09-02 | Forest | Wisconsin | 55041 | 81 | 4 |
495534 | 495534 | 2020-09-02 | Grant | Wisconsin | 55043 | 435 | 18 |
495535 | 495535 | 2020-09-02 | Green | Wisconsin | 55045 | 269 | 1 |
495536 | 495536 | 2020-09-02 | Green Lake | Wisconsin | 55047 | 94 | 0 |
495537 | 495537 | 2020-09-02 | Iowa | Wisconsin | 55049 | 122 | 0 |
495538 | 495538 | 2020-09-02 | Iron | Wisconsin | 55051 | 126 | 1 |
495539 | 495539 | 2020-09-02 | Jackson | Wisconsin | 55053 | 76 | 1 |
495540 | 495540 | 2020-09-02 | Jefferson | Wisconsin | 55055 | 932 | 6 |
495541 | 495541 | 2020-09-02 | Juneau | Wisconsin | 55057 | 240 | 1 |
495542 | 495542 | 2020-09-02 | Kenosha | Wisconsin | 55059 | 3004 | 64 |
495543 | 495543 | 2020-09-02 | Kewaunee | Wisconsin | 55061 | 191 | 2 |
495544 | 495544 | 2020-09-02 | La Crosse | Wisconsin | 55063 | 1208 | 2 |
495545 | 495545 | 2020-09-02 | Lafayette | Wisconsin | 55065 | 185 | 0 |
495546 | 495546 | 2020-09-02 | Langlade | Wisconsin | 55067 | 84 | 2 |
495547 | 495547 | 2020-09-02 | Lincoln | Wisconsin | 55069 | 85 | 1 |
495548 | 495548 | 2020-09-02 | Manitowoc | Wisconsin | 55071 | 541 | 2 |
495549 | 495549 | 2020-09-02 | Marathon | Wisconsin | 55073 | 788 | 14 |
495550 | 495550 | 2020-09-02 | Marinette | Wisconsin | 55075 | 618 | 6 |
495551 | 495551 | 2020-09-02 | Marquette | Wisconsin | 55077 | 91 | 1 |
495552 | 495552 | 2020-09-02 | Menominee | Wisconsin | 55078 | 29 | 0 |
495553 | 495553 | 2020-09-02 | Milwaukee | Wisconsin | 55079 | 24263 | 494 |
495554 | 495554 | 2020-09-02 | Monroe | Wisconsin | 55081 | 290 | 2 |
495555 | 495555 | 2020-09-02 | Oconto | Wisconsin | 55083 | 436 | 2 |
495556 | 495556 | 2020-09-02 | Oneida | Wisconsin | 55085 | 218 | 0 |
495557 | 495557 | 2020-09-02 | Outagamie | Wisconsin | 55087 | 1974 | 20 |
495558 | 495558 | 2020-09-02 | Ozaukee | Wisconsin | 55089 | 956 | 19 |
495559 | 495559 | 2020-09-02 | Pepin | Wisconsin | 55091 | 48 | 0 |
495560 | 495560 | 2020-09-02 | Pierce | Wisconsin | 55093 | 294 | 6 |
495561 | 495561 | 2020-09-02 | Polk | Wisconsin | 55095 | 179 | 2 |
495562 | 495562 | 2020-09-02 | Portage | Wisconsin | 55097 | 652 | 1 |
495563 | 495563 | 2020-09-02 | Price | Wisconsin | 55099 | 36 | 0 |
495564 | 495564 | 2020-09-02 | Racine | Wisconsin | 55101 | 4484 | 91 |
495565 | 495565 | 2020-09-02 | Richland | Wisconsin | 55103 | 51 | 4 |
495566 | 495566 | 2020-09-02 | Rock | Wisconsin | 55105 | 1880 | 26 |
495567 | 495567 | 2020-09-02 | Rusk | Wisconsin | 55107 | 25 | 1 |
495568 | 495568 | 2020-09-02 | Sauk | Wisconsin | 55111 | 654 | 3 |
495569 | 495569 | 2020-09-02 | Sawyer | Wisconsin | 55113 | 162 | 0 |
495570 | 495570 | 2020-09-02 | Shawano | Wisconsin | 55115 | 287 | 0 |
495571 | 495571 | 2020-09-02 | Sheboygan | Wisconsin | 55117 | 1091 | 9 |
495572 | 495572 | 2020-09-02 | St. Croix | Wisconsin | 55109 | 658 | 7 |
495573 | 495573 | 2020-09-02 | Taylor | Wisconsin | 55119 | 113 | 3 |
495574 | 495574 | 2020-09-02 | Trempealeau | Wisconsin | 55121 | 426 | 2 |
495575 | 495575 | 2020-09-02 | Unknown | Wisconsin | 4456 | 8 | |
495576 | 495576 | 2020-09-02 | Vernon | Wisconsin | 55123 | 105 | 0 |
495577 | 495577 | 2020-09-02 | Vilas | Wisconsin | 55125 | 114 | 0 |
495578 | 495578 | 2020-09-02 | Walworth | Wisconsin | 55127 | 1726 | 31 |
495579 | 495579 | 2020-09-02 | Washburn | Wisconsin | 55129 | 69 | 0 |
495580 | 495580 | 2020-09-02 | Washington | Wisconsin | 55131 | 1670 | 29 |
495581 | 495581 | 2020-09-02 | Waukesha | Wisconsin | 55133 | 5650 | 75 |
495582 | 495582 | 2020-09-02 | Waupaca | Wisconsin | 55135 | 709 | 18 |
495583 | 495583 | 2020-09-02 | Waushara | Wisconsin | 55137 | 167 | 2 |
495584 | 495584 | 2020-09-02 | Winnebago | Wisconsin | 55139 | 1569 | 21 |
495585 | 495585 | 2020-09-02 | Wood | Wisconsin | 55141 | 478 | 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);