ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

7,870 rows where state = "Wisconsin" sorted by date descending

View and edit SQL

fips

county

state

  • Wisconsin · 7,870
Link rowid date ▲ county state fips cases deaths
337473 2020-07-15 Adams Wisconsin 55001 45 2
337474 2020-07-15 Ashland Wisconsin 55003 8 0
337475 2020-07-15 Barron Wisconsin 55005 54 1
337476 2020-07-15 Bayfield Wisconsin 55007 11 1
337477 2020-07-15 Brown Wisconsin 55009 3348 44
337478 2020-07-15 Buffalo Wisconsin 55011 21 2
337479 2020-07-15 Burnett Wisconsin 55013 5 1
337480 2020-07-15 Calumet Wisconsin 55015 165 2
337481 2020-07-15 Chippewa Wisconsin 55017 145 0
337482 2020-07-15 Clark Wisconsin 55019 121 7
337483 2020-07-15 Columbia Wisconsin 55021 129 1
337484 2020-07-15 Crawford Wisconsin 55023 46 0
337485 2020-07-15 Dane Wisconsin 55025 3250 33
337486 2020-07-15 Dodge Wisconsin 55027 537 5
337487 2020-07-15 Door Wisconsin 55029 65 3
337488 2020-07-15 Douglas Wisconsin 55031 64 0
337489 2020-07-15 Dunn Wisconsin 55033 59 0
337490 2020-07-15 Eau Claire Wisconsin 55035 351 1
337491 2020-07-15 Florence Wisconsin 55037 5 0
337492 2020-07-15 Fond du Lac Wisconsin 55039 405 6
337493 2020-07-15 Forest Wisconsin 55041 49 3
337494 2020-07-15 Grant Wisconsin 55043 223 13
337495 2020-07-15 Green Wisconsin 55045 110 1
337496 2020-07-15 Green Lake Wisconsin 55047 43 0
337497 2020-07-15 Iowa Wisconsin 55049 47 0
337498 2020-07-15 Iron Wisconsin 55051 21 1
337499 2020-07-15 Jackson Wisconsin 55053 37 1
337500 2020-07-15 Jefferson Wisconsin 55055 384 4
337501 2020-07-15 Juneau Wisconsin 55057 59 1
337502 2020-07-15 Kenosha Wisconsin 55059 1833 47
337503 2020-07-15 Kewaunee Wisconsin 55061 86 1
337504 2020-07-15 La Crosse Wisconsin 55063 618 0
337505 2020-07-15 Lafayette Wisconsin 55065 84 0
337506 2020-07-15 Langlade Wisconsin 55067 11 1
337507 2020-07-15 Lincoln Wisconsin 55069 24 0
337508 2020-07-15 Manitowoc Wisconsin 55071 167 1
337509 2020-07-15 Marathon Wisconsin 55073 312 1
337510 2020-07-15 Marinette Wisconsin 55075 126 3
337511 2020-07-15 Marquette Wisconsin 55077 55 1
337512 2020-07-15 Menominee Wisconsin 55078 10 0
337513 2020-07-15 Milwaukee Wisconsin 55079 14807 403
337514 2020-07-15 Monroe Wisconsin 55081 145 1
337515 2020-07-15 Oconto Wisconsin 55083 101 0
337516 2020-07-15 Oneida Wisconsin 55085 38 0
337517 2020-07-15 Outagamie Wisconsin 55087 719 9
337518 2020-07-15 Ozaukee Wisconsin 55089 358 17
337519 2020-07-15 Pepin Wisconsin 55091 18 0
337520 2020-07-15 Pierce Wisconsin 55093 113 0
337521 2020-07-15 Polk Wisconsin 55095 74 2
337522 2020-07-15 Portage Wisconsin 55097 260 0
337523 2020-07-15 Price Wisconsin 55099 9 0
337524 2020-07-15 Racine Wisconsin 55101 2418 65
337525 2020-07-15 Richland Wisconsin 55103 17 4
337526 2020-07-15 Rock Wisconsin 55105 1200 24
337527 2020-07-15 Rusk Wisconsin 55107 12 1
337528 2020-07-15 Sauk Wisconsin 55111 191 3
337529 2020-07-15 Sawyer Wisconsin 55113 15 0
337530 2020-07-15 Shawano Wisconsin 55115 104 0
337531 2020-07-15 Sheboygan Wisconsin 55117 326 4
337532 2020-07-15 St. Croix Wisconsin 55109 297 2
337533 2020-07-15 Taylor Wisconsin 55119 25 0
337534 2020-07-15 Trempealeau Wisconsin 55121 194 0
337535 2020-07-15 Unknown Wisconsin   3351 7
337536 2020-07-15 Vernon Wisconsin 55123 42 0
337537 2020-07-15 Vilas Wisconsin 55125 17 0
337538 2020-07-15 Walworth Wisconsin 55127 815 18
337539 2020-07-15 Washburn Wisconsin 55129 6 0
337540 2020-07-15 Washington Wisconsin 55131 523 19
337541 2020-07-15 Waukesha Wisconsin 55133 1921 40
337542 2020-07-15 Waupaca Wisconsin 55135 196 13
337543 2020-07-15 Waushara Wisconsin 55137 48 0
337544 2020-07-15 Winnebago Wisconsin 55139 804 14
337545 2020-07-15 Wood Wisconsin 55141 112 1
334280 2020-07-14 Adams Wisconsin 55001 43 2
334281 2020-07-14 Ashland Wisconsin 55003 8 0
334282 2020-07-14 Barron Wisconsin 55005 51 1
334283 2020-07-14 Bayfield Wisconsin 55007 9 1
334284 2020-07-14 Brown Wisconsin 55009 3305 44
334285 2020-07-14 Buffalo Wisconsin 55011 16 2
334286 2020-07-14 Burnett Wisconsin 55013 5 1
334287 2020-07-14 Calumet Wisconsin 55015 161 2
334288 2020-07-14 Chippewa Wisconsin 55017 141 0
334289 2020-07-14 Clark Wisconsin 55019 118 7
334290 2020-07-14 Columbia Wisconsin 55021 125 1
334291 2020-07-14 Crawford Wisconsin 55023 45 0
334292 2020-07-14 Dane Wisconsin 55025 3151 33
334293 2020-07-14 Dodge Wisconsin 55027 528 5
334294 2020-07-14 Door Wisconsin 55029 58 3
334295 2020-07-14 Douglas Wisconsin 55031 63 0
334296 2020-07-14 Dunn Wisconsin 55033 57 0
334297 2020-07-14 Eau Claire Wisconsin 55035 346 1
334298 2020-07-14 Florence Wisconsin 55037 5 0
334299 2020-07-14 Fond du Lac Wisconsin 55039 403 6
334300 2020-07-14 Forest Wisconsin 55041 48 3
334301 2020-07-14 Grant Wisconsin 55043 218 13
334302 2020-07-14 Green Wisconsin 55045 110 1
334303 2020-07-14 Green Lake Wisconsin 55047 43 0
334304 2020-07-14 Iowa Wisconsin 55049 47 0
334305 2020-07-14 Iron Wisconsin 55051 17 1
334306 2020-07-14 Jackson Wisconsin 55053 36 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1537.237ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette