ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2020-06-09" 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 |
---|---|---|---|---|---|---|---|
224516 | 224516 | 2020-06-09 | Adams | Wisconsin | 55001 | 6 | 1 |
224517 | 224517 | 2020-06-09 | Ashland | Wisconsin | 55003 | 3 | 0 |
224518 | 224518 | 2020-06-09 | Barron | Wisconsin | 55005 | 20 | 0 |
224519 | 224519 | 2020-06-09 | Bayfield | Wisconsin | 55007 | 3 | 1 |
224520 | 224520 | 2020-06-09 | Brown | Wisconsin | 55009 | 2399 | 38 |
224521 | 224521 | 2020-06-09 | Buffalo | Wisconsin | 55011 | 6 | 2 |
224522 | 224522 | 2020-06-09 | Burnett | Wisconsin | 55013 | 1 | 1 |
224523 | 224523 | 2020-06-09 | Calumet | Wisconsin | 55015 | 81 | 1 |
224524 | 224524 | 2020-06-09 | Chippewa | Wisconsin | 55017 | 59 | 0 |
224525 | 224525 | 2020-06-09 | Clark | Wisconsin | 55019 | 45 | 4 |
224526 | 224526 | 2020-06-09 | Columbia | Wisconsin | 55021 | 47 | 1 |
224527 | 224527 | 2020-06-09 | Crawford | Wisconsin | 55023 | 26 | 0 |
224528 | 224528 | 2020-06-09 | Dane | Wisconsin | 55025 | 871 | 30 |
224529 | 224529 | 2020-06-09 | Dodge | Wisconsin | 55027 | 406 | 4 |
224530 | 224530 | 2020-06-09 | Door | Wisconsin | 55029 | 39 | 3 |
224531 | 224531 | 2020-06-09 | Douglas | Wisconsin | 55031 | 20 | 0 |
224532 | 224532 | 2020-06-09 | Dunn | Wisconsin | 55033 | 29 | 0 |
224533 | 224533 | 2020-06-09 | Eau Claire | Wisconsin | 55035 | 124 | 0 |
224534 | 224534 | 2020-06-09 | Florence | Wisconsin | 55037 | 2 | 0 |
224535 | 224535 | 2020-06-09 | Fond du Lac | Wisconsin | 55039 | 241 | 6 |
224536 | 224536 | 2020-06-09 | Forest | Wisconsin | 55041 | 34 | 2 |
224537 | 224537 | 2020-06-09 | Grant | Wisconsin | 55043 | 99 | 12 |
224538 | 224538 | 2020-06-09 | Green | Wisconsin | 55045 | 71 | 0 |
224539 | 224539 | 2020-06-09 | Green Lake | Wisconsin | 55047 | 23 | 0 |
224540 | 224540 | 2020-06-09 | Iowa | Wisconsin | 55049 | 16 | 0 |
224541 | 224541 | 2020-06-09 | Iron | Wisconsin | 55051 | 2 | 1 |
224542 | 224542 | 2020-06-09 | Jackson | Wisconsin | 55053 | 19 | 1 |
224543 | 224543 | 2020-06-09 | Jefferson | Wisconsin | 55055 | 134 | 3 |
224544 | 224544 | 2020-06-09 | Juneau | Wisconsin | 55057 | 23 | 1 |
224545 | 224545 | 2020-06-09 | Kenosha | Wisconsin | 55059 | 1296 | 36 |
224546 | 224546 | 2020-06-09 | Kewaunee | Wisconsin | 55061 | 37 | 1 |
224547 | 224547 | 2020-06-09 | La Crosse | Wisconsin | 55063 | 77 | 0 |
224548 | 224548 | 2020-06-09 | Lafayette | Wisconsin | 55065 | 35 | 0 |
224549 | 224549 | 2020-06-09 | Langlade | Wisconsin | 55067 | 5 | 0 |
224550 | 224550 | 2020-06-09 | Lincoln | Wisconsin | 55069 | 7 | 0 |
224551 | 224551 | 2020-06-09 | Manitowoc | Wisconsin | 55071 | 40 | 1 |
224552 | 224552 | 2020-06-09 | Marathon | Wisconsin | 55073 | 66 | 1 |
224553 | 224553 | 2020-06-09 | Marinette | Wisconsin | 55075 | 37 | 3 |
224554 | 224554 | 2020-06-09 | Marquette | Wisconsin | 55077 | 6 | 1 |
224555 | 224555 | 2020-06-09 | Menominee | Wisconsin | 55078 | 3 | 0 |
224556 | 224556 | 2020-06-09 | Milwaukee | Wisconsin | 55079 | 9001 | 331 |
224557 | 224557 | 2020-06-09 | Monroe | Wisconsin | 55081 | 19 | 1 |
224558 | 224558 | 2020-06-09 | Oconto | Wisconsin | 55083 | 42 | 0 |
224559 | 224559 | 2020-06-09 | Oneida | Wisconsin | 55085 | 13 | 0 |
224560 | 224560 | 2020-06-09 | Outagamie | Wisconsin | 55087 | 289 | 8 |
224561 | 224561 | 2020-06-09 | Ozaukee | Wisconsin | 55089 | 193 | 14 |
224562 | 224562 | 2020-06-09 | Pepin | Wisconsin | 55091 | 1 | 0 |
224563 | 224563 | 2020-06-09 | Pierce | Wisconsin | 55093 | 51 | 0 |
224564 | 224564 | 2020-06-09 | Polk | Wisconsin | 55095 | 34 | 1 |
224565 | 224565 | 2020-06-09 | Portage | Wisconsin | 55097 | 39 | 0 |
224566 | 224566 | 2020-06-09 | Price | Wisconsin | 55099 | 2 | 0 |
224567 | 224567 | 2020-06-09 | Racine | Wisconsin | 55101 | 2242 | 51 |
224568 | 224568 | 2020-06-09 | Richland | Wisconsin | 55103 | 14 | 4 |
224569 | 224569 | 2020-06-09 | Rock | Wisconsin | 55105 | 799 | 21 |
224570 | 224570 | 2020-06-09 | Rusk | Wisconsin | 55107 | 5 | 0 |
224571 | 224571 | 2020-06-09 | Sauk | Wisconsin | 55111 | 84 | 3 |
224572 | 224572 | 2020-06-09 | Sawyer | Wisconsin | 55113 | 9 | 0 |
224573 | 224573 | 2020-06-09 | Shawano | Wisconsin | 55115 | 60 | 0 |
224574 | 224574 | 2020-06-09 | Sheboygan | Wisconsin | 55117 | 118 | 3 |
224575 | 224575 | 2020-06-09 | St. Croix | Wisconsin | 55109 | 107 | 0 |
224576 | 224576 | 2020-06-09 | Taylor | Wisconsin | 55119 | 2 | 0 |
224577 | 224577 | 2020-06-09 | Trempealeau | Wisconsin | 55121 | 43 | 0 |
224578 | 224578 | 2020-06-09 | Vernon | Wisconsin | 55123 | 22 | 0 |
224579 | 224579 | 2020-06-09 | Vilas | Wisconsin | 55125 | 8 | 0 |
224580 | 224580 | 2020-06-09 | Walworth | Wisconsin | 55127 | 452 | 17 |
224581 | 224581 | 2020-06-09 | Washburn | Wisconsin | 55129 | 3 | 0 |
224582 | 224582 | 2020-06-09 | Washington | Wisconsin | 55131 | 281 | 10 |
224583 | 224583 | 2020-06-09 | Waukesha | Wisconsin | 55133 | 833 | 34 |
224584 | 224584 | 2020-06-09 | Waupaca | Wisconsin | 55135 | 58 | 1 |
224585 | 224585 | 2020-06-09 | Waushara | Wisconsin | 55137 | 13 | 0 |
224586 | 224586 | 2020-06-09 | Winnebago | Wisconsin | 55139 | 431 | 7 |
224587 | 224587 | 2020-06-09 | Wood | Wisconsin | 55141 | 12 | 1 |
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);