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-06-27 and state = "Wisconsin" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280692 | 280692 | 2020-06-27 | Adams | Wisconsin | 55001 | 15 | 2 |
280693 | 280693 | 2020-06-27 | Ashland | Wisconsin | 55003 | 3 | 0 |
280694 | 280694 | 2020-06-27 | Barron | Wisconsin | 55005 | 34 | 0 |
280695 | 280695 | 2020-06-27 | Bayfield | Wisconsin | 55007 | 3 | 1 |
280696 | 280696 | 2020-06-27 | Brown | Wisconsin | 55009 | 2777 | 42 |
280697 | 280697 | 2020-06-27 | Buffalo | Wisconsin | 55011 | 7 | 2 |
280698 | 280698 | 2020-06-27 | Burnett | Wisconsin | 55013 | 3 | 1 |
280699 | 280699 | 2020-06-27 | Calumet | Wisconsin | 55015 | 97 | 2 |
280700 | 280700 | 2020-06-27 | Chippewa | Wisconsin | 55017 | 82 | 0 |
280701 | 280701 | 2020-06-27 | Clark | Wisconsin | 55019 | 69 | 6 |
280702 | 280702 | 2020-06-27 | Columbia | Wisconsin | 55021 | 79 | 1 |
280703 | 280703 | 2020-06-27 | Crawford | Wisconsin | 55023 | 32 | 0 |
280704 | 280704 | 2020-06-27 | Dane | Wisconsin | 55025 | 1530 | 32 |
280705 | 280705 | 2020-06-27 | Dodge | Wisconsin | 55027 | 450 | 5 |
280706 | 280706 | 2020-06-27 | Door | Wisconsin | 55029 | 43 | 3 |
280707 | 280707 | 2020-06-27 | Douglas | Wisconsin | 55031 | 22 | 0 |
280708 | 280708 | 2020-06-27 | Dunn | Wisconsin | 55033 | 36 | 0 |
280709 | 280709 | 2020-06-27 | Eau Claire | Wisconsin | 55035 | 194 | 1 |
280710 | 280710 | 2020-06-27 | Florence | Wisconsin | 55037 | 3 | 0 |
280711 | 280711 | 2020-06-27 | Fond du Lac | Wisconsin | 55039 | 307 | 6 |
280712 | 280712 | 2020-06-27 | Forest | Wisconsin | 55041 | 38 | 3 |
280713 | 280713 | 2020-06-27 | Grant | Wisconsin | 55043 | 145 | 13 |
280714 | 280714 | 2020-06-27 | Green | Wisconsin | 55045 | 85 | 1 |
280715 | 280715 | 2020-06-27 | Green Lake | Wisconsin | 55047 | 30 | 0 |
280716 | 280716 | 2020-06-27 | Iowa | Wisconsin | 55049 | 29 | 0 |
280717 | 280717 | 2020-06-27 | Iron | Wisconsin | 55051 | 5 | 1 |
280718 | 280718 | 2020-06-27 | Jackson | Wisconsin | 55053 | 26 | 1 |
280719 | 280719 | 2020-06-27 | Jefferson | Wisconsin | 55055 | 222 | 4 |
280720 | 280720 | 2020-06-27 | Juneau | Wisconsin | 55057 | 32 | 1 |
280721 | 280721 | 2020-06-27 | Kenosha | Wisconsin | 55059 | 1468 | 43 |
280722 | 280722 | 2020-06-27 | Kewaunee | Wisconsin | 55061 | 54 | 1 |
280723 | 280723 | 2020-06-27 | La Crosse | Wisconsin | 55063 | 396 | 0 |
280724 | 280724 | 2020-06-27 | Lafayette | Wisconsin | 55065 | 68 | 0 |
280725 | 280725 | 2020-06-27 | Langlade | Wisconsin | 55067 | 7 | 0 |
280726 | 280726 | 2020-06-27 | Lincoln | Wisconsin | 55069 | 9 | 0 |
280727 | 280727 | 2020-06-27 | Manitowoc | Wisconsin | 55071 | 87 | 1 |
280728 | 280728 | 2020-06-27 | Marathon | Wisconsin | 55073 | 148 | 1 |
280729 | 280729 | 2020-06-27 | Marinette | Wisconsin | 55075 | 50 | 3 |
280730 | 280730 | 2020-06-27 | Marquette | Wisconsin | 55077 | 12 | 1 |
280731 | 280731 | 2020-06-27 | Menominee | Wisconsin | 55078 | 6 | 0 |
280732 | 280732 | 2020-06-27 | Milwaukee | Wisconsin | 55079 | 10983 | 389 |
280733 | 280733 | 2020-06-27 | Monroe | Wisconsin | 55081 | 61 | 1 |
280734 | 280734 | 2020-06-27 | Oconto | Wisconsin | 55083 | 53 | 0 |
280735 | 280735 | 2020-06-27 | Oneida | Wisconsin | 55085 | 19 | 0 |
280736 | 280736 | 2020-06-27 | Outagamie | Wisconsin | 55087 | 447 | 8 |
280737 | 280737 | 2020-06-27 | Ozaukee | Wisconsin | 55089 | 222 | 16 |
280738 | 280738 | 2020-06-27 | Pepin | Wisconsin | 55091 | 1 | 0 |
280739 | 280739 | 2020-06-27 | Pierce | Wisconsin | 55093 | 65 | 0 |
280740 | 280740 | 2020-06-27 | Polk | Wisconsin | 55095 | 43 | 1 |
280741 | 280741 | 2020-06-27 | Portage | Wisconsin | 55097 | 128 | 0 |
280742 | 280742 | 2020-06-27 | Price | Wisconsin | 55099 | 2 | 0 |
280743 | 280743 | 2020-06-27 | Racine | Wisconsin | 55101 | 2475 | 61 |
280744 | 280744 | 2020-06-27 | Richland | Wisconsin | 55103 | 15 | 4 |
280745 | 280745 | 2020-06-27 | Rock | Wisconsin | 55105 | 932 | 23 |
280746 | 280746 | 2020-06-27 | Rusk | Wisconsin | 55107 | 11 | 0 |
280747 | 280747 | 2020-06-27 | Sauk | Wisconsin | 55111 | 100 | 3 |
280748 | 280748 | 2020-06-27 | Sawyer | Wisconsin | 55113 | 12 | 0 |
280749 | 280749 | 2020-06-27 | Shawano | Wisconsin | 55115 | 75 | 0 |
280750 | 280750 | 2020-06-27 | Sheboygan | Wisconsin | 55117 | 195 | 4 |
280751 | 280751 | 2020-06-27 | St. Croix | Wisconsin | 55109 | 155 | 1 |
280752 | 280752 | 2020-06-27 | Taylor | Wisconsin | 55119 | 11 | 0 |
280753 | 280753 | 2020-06-27 | Trempealeau | Wisconsin | 55121 | 111 | 0 |
280754 | 280754 | 2020-06-27 | Unknown | Wisconsin | 2521 | 7 | |
280755 | 280755 | 2020-06-27 | Vernon | Wisconsin | 55123 | 32 | 0 |
280756 | 280756 | 2020-06-27 | Vilas | Wisconsin | 55125 | 10 | 0 |
280757 | 280757 | 2020-06-27 | Walworth | Wisconsin | 55127 | 570 | 18 |
280758 | 280758 | 2020-06-27 | Washburn | Wisconsin | 55129 | 4 | 0 |
280759 | 280759 | 2020-06-27 | Washington | Wisconsin | 55131 | 348 | 16 |
280760 | 280760 | 2020-06-27 | Waukesha | Wisconsin | 55133 | 1119 | 38 |
280761 | 280761 | 2020-06-27 | Waupaca | Wisconsin | 55135 | 106 | 6 |
280762 | 280762 | 2020-06-27 | Waushara | Wisconsin | 55137 | 21 | 0 |
280763 | 280763 | 2020-06-27 | Winnebago | Wisconsin | 55139 | 643 | 11 |
280764 | 280764 | 2020-06-27 | Wood | Wisconsin | 55141 | 42 | 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);