ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2020-05-03 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
112392 | 112392 | 2020-05-03 | Adams | Wisconsin | 55001 | 4 | 1 |
112393 | 112393 | 2020-05-03 | Ashland | Wisconsin | 55003 | 2 | 0 |
112394 | 112394 | 2020-05-03 | Barron | Wisconsin | 55005 | 7 | 0 |
112395 | 112395 | 2020-05-03 | Bayfield | Wisconsin | 55007 | 3 | 1 |
112396 | 112396 | 2020-05-03 | Brown | Wisconsin | 55009 | 1358 | 6 |
112397 | 112397 | 2020-05-03 | Buffalo | Wisconsin | 55011 | 4 | 1 |
112398 | 112398 | 2020-05-03 | Calumet | Wisconsin | 55015 | 18 | 0 |
112399 | 112399 | 2020-05-03 | Chippewa | Wisconsin | 55017 | 25 | 0 |
112400 | 112400 | 2020-05-03 | Clark | Wisconsin | 55019 | 21 | 4 |
112401 | 112401 | 2020-05-03 | Columbia | Wisconsin | 55021 | 29 | 1 |
112402 | 112402 | 2020-05-03 | Crawford | Wisconsin | 55023 | 5 | 0 |
112403 | 112403 | 2020-05-03 | Dane | Wisconsin | 55025 | 436 | 22 |
112404 | 112404 | 2020-05-03 | Dodge | Wisconsin | 55027 | 38 | 1 |
112405 | 112405 | 2020-05-03 | Door | Wisconsin | 55029 | 15 | 3 |
112406 | 112406 | 2020-05-03 | Douglas | Wisconsin | 55031 | 9 | 0 |
112407 | 112407 | 2020-05-03 | Dunn | Wisconsin | 55033 | 12 | 0 |
112408 | 112408 | 2020-05-03 | Eau Claire | Wisconsin | 55035 | 36 | 0 |
112409 | 112409 | 2020-05-03 | Florence | Wisconsin | 55037 | 2 | 0 |
112410 | 112410 | 2020-05-03 | Fond du Lac | Wisconsin | 55039 | 73 | 3 |
112411 | 112411 | 2020-05-03 | Grant | Wisconsin | 55043 | 48 | 6 |
112412 | 112412 | 2020-05-03 | Green | Wisconsin | 55045 | 15 | 0 |
112413 | 112413 | 2020-05-03 | Green Lake | Wisconsin | 55047 | 3 | 0 |
112414 | 112414 | 2020-05-03 | Iowa | Wisconsin | 55049 | 7 | 0 |
112415 | 112415 | 2020-05-03 | Iron | Wisconsin | 55051 | 2 | 1 |
112416 | 112416 | 2020-05-03 | Jackson | Wisconsin | 55053 | 12 | 1 |
112417 | 112417 | 2020-05-03 | Jefferson | Wisconsin | 55055 | 46 | 0 |
112418 | 112418 | 2020-05-03 | Juneau | Wisconsin | 55057 | 18 | 1 |
112419 | 112419 | 2020-05-03 | Kenosha | Wisconsin | 55059 | 534 | 14 |
112420 | 112420 | 2020-05-03 | Kewaunee | Wisconsin | 55061 | 18 | 1 |
112421 | 112421 | 2020-05-03 | La Crosse | Wisconsin | 55063 | 29 | 0 |
112422 | 112422 | 2020-05-03 | Lafayette | Wisconsin | 55065 | 6 | 0 |
112423 | 112423 | 2020-05-03 | Lincoln | Wisconsin | 55069 | 1 | 0 |
112424 | 112424 | 2020-05-03 | Manitowoc | Wisconsin | 55071 | 13 | 1 |
112425 | 112425 | 2020-05-03 | Marathon | Wisconsin | 55073 | 19 | 1 |
112426 | 112426 | 2020-05-03 | Marinette | Wisconsin | 55075 | 11 | 1 |
112427 | 112427 | 2020-05-03 | Marquette | Wisconsin | 55077 | 3 | 1 |
112428 | 112428 | 2020-05-03 | Menominee | Wisconsin | 55078 | 1 | 0 |
112429 | 112429 | 2020-05-03 | Milwaukee | Wisconsin | 55079 | 3244 | 195 |
112430 | 112430 | 2020-05-03 | Monroe | Wisconsin | 55081 | 14 | 1 |
112431 | 112431 | 2020-05-03 | Oconto | Wisconsin | 55083 | 18 | 0 |
112432 | 112432 | 2020-05-03 | Oneida | Wisconsin | 55085 | 6 | 0 |
112433 | 112433 | 2020-05-03 | Outagamie | Wisconsin | 55087 | 68 | 2 |
112434 | 112434 | 2020-05-03 | Ozaukee | Wisconsin | 55089 | 92 | 9 |
112435 | 112435 | 2020-05-03 | Pierce | Wisconsin | 55093 | 10 | 0 |
112436 | 112436 | 2020-05-03 | Polk | Wisconsin | 55095 | 4 | 0 |
112437 | 112437 | 2020-05-03 | Portage | Wisconsin | 55097 | 6 | 0 |
112438 | 112438 | 2020-05-03 | Price | Wisconsin | 55099 | 1 | 0 |
112439 | 112439 | 2020-05-03 | Racine | Wisconsin | 55101 | 560 | 13 |
112440 | 112440 | 2020-05-03 | Richland | Wisconsin | 55103 | 13 | 2 |
112441 | 112441 | 2020-05-03 | Rock | Wisconsin | 55105 | 262 | 7 |
112442 | 112442 | 2020-05-03 | Rusk | Wisconsin | 55107 | 4 | 0 |
112443 | 112443 | 2020-05-03 | Sauk | Wisconsin | 55111 | 65 | 3 |
112444 | 112444 | 2020-05-03 | Sawyer | Wisconsin | 55113 | 3 | 0 |
112445 | 112445 | 2020-05-03 | Shawano | Wisconsin | 55115 | 16 | 0 |
112446 | 112446 | 2020-05-03 | Sheboygan | Wisconsin | 55117 | 52 | 2 |
112447 | 112447 | 2020-05-03 | St. Croix | Wisconsin | 55109 | 18 | 0 |
112448 | 112448 | 2020-05-03 | Trempealeau | Wisconsin | 55121 | 3 | 0 |
112449 | 112449 | 2020-05-03 | Vernon | Wisconsin | 55123 | 1 | 0 |
112450 | 112450 | 2020-05-03 | Vilas | Wisconsin | 55125 | 4 | 0 |
112451 | 112451 | 2020-05-03 | Walworth | Wisconsin | 55127 | 197 | 8 |
112452 | 112452 | 2020-05-03 | Washburn | Wisconsin | 55129 | 1 | 0 |
112453 | 112453 | 2020-05-03 | Washington | Wisconsin | 55131 | 101 | 4 |
112454 | 112454 | 2020-05-03 | Waukesha | Wisconsin | 55133 | 360 | 20 |
112455 | 112455 | 2020-05-03 | Waupaca | Wisconsin | 55135 | 10 | 1 |
112456 | 112456 | 2020-05-03 | Waushara | Wisconsin | 55137 | 2 | 0 |
112457 | 112457 | 2020-05-03 | Winnebago | Wisconsin | 55139 | 69 | 1 |
112458 | 112458 | 2020-05-03 | Wood | Wisconsin | 55141 | 2 | 0 |
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);