ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where "date" is on date 2020-04-10 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
48345 | 48345 | 2020-04-10 | Adams | Wisconsin | 55001 | 2 | 0 |
48346 | 48346 | 2020-04-10 | Ashland | Wisconsin | 55003 | 1 | 0 |
48347 | 48347 | 2020-04-10 | Barron | Wisconsin | 55005 | 6 | 0 |
48348 | 48348 | 2020-04-10 | Bayfield | Wisconsin | 55007 | 3 | 0 |
48349 | 48349 | 2020-04-10 | Brown | Wisconsin | 55009 | 55 | 1 |
48350 | 48350 | 2020-04-10 | Buffalo | Wisconsin | 55011 | 2 | 1 |
48351 | 48351 | 2020-04-10 | Calumet | Wisconsin | 55015 | 4 | 0 |
48352 | 48352 | 2020-04-10 | Chippewa | Wisconsin | 55017 | 18 | 0 |
48353 | 48353 | 2020-04-10 | Clark | Wisconsin | 55019 | 7 | 0 |
48354 | 48354 | 2020-04-10 | Columbia | Wisconsin | 55021 | 24 | 1 |
48355 | 48355 | 2020-04-10 | Crawford | Wisconsin | 55023 | 3 | 0 |
48356 | 48356 | 2020-04-10 | Dane | Wisconsin | 55025 | 313 | 12 |
48357 | 48357 | 2020-04-10 | Dodge | Wisconsin | 55027 | 18 | 0 |
48358 | 48358 | 2020-04-10 | Door | Wisconsin | 55029 | 8 | 0 |
48359 | 48359 | 2020-04-10 | Douglas | Wisconsin | 55031 | 7 | 0 |
48360 | 48360 | 2020-04-10 | Dunn | Wisconsin | 55033 | 8 | 0 |
48361 | 48361 | 2020-04-10 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
48362 | 48362 | 2020-04-10 | Florence | Wisconsin | 55037 | 2 | 0 |
48363 | 48363 | 2020-04-10 | Fond du Lac | Wisconsin | 55039 | 52 | 2 |
48364 | 48364 | 2020-04-10 | Grant | Wisconsin | 55043 | 4 | 1 |
48365 | 48365 | 2020-04-10 | Green | Wisconsin | 55045 | 9 | 0 |
48366 | 48366 | 2020-04-10 | Iowa | Wisconsin | 55049 | 4 | 0 |
48367 | 48367 | 2020-04-10 | Iron | Wisconsin | 55051 | 1 | 1 |
48368 | 48368 | 2020-04-10 | Jackson | Wisconsin | 55053 | 10 | 0 |
48369 | 48369 | 2020-04-10 | Jefferson | Wisconsin | 55055 | 21 | 0 |
48370 | 48370 | 2020-04-10 | Juneau | Wisconsin | 55057 | 5 | 0 |
48371 | 48371 | 2020-04-10 | Kenosha | Wisconsin | 55059 | 147 | 1 |
48372 | 48372 | 2020-04-10 | Kewaunee | Wisconsin | 55061 | 1 | 0 |
48373 | 48373 | 2020-04-10 | La Crosse | Wisconsin | 55063 | 25 | 0 |
48374 | 48374 | 2020-04-10 | Lafayette | Wisconsin | 55065 | 2 | 0 |
48375 | 48375 | 2020-04-10 | Manitowoc | Wisconsin | 55071 | 3 | 0 |
48376 | 48376 | 2020-04-10 | Marathon | Wisconsin | 55073 | 12 | 0 |
48377 | 48377 | 2020-04-10 | Marinette | Wisconsin | 55075 | 3 | 0 |
48378 | 48378 | 2020-04-10 | Marquette | Wisconsin | 55077 | 2 | 0 |
48379 | 48379 | 2020-04-10 | Menominee | Wisconsin | 55078 | 1 | 0 |
48380 | 48380 | 2020-04-10 | Milwaukee | Wisconsin | 55079 | 1575 | 77 |
48381 | 48381 | 2020-04-10 | Monroe | Wisconsin | 55081 | 8 | 0 |
48382 | 48382 | 2020-04-10 | Oconto | Wisconsin | 55083 | 3 | 0 |
48383 | 48383 | 2020-04-10 | Oneida | Wisconsin | 55085 | 5 | 0 |
48384 | 48384 | 2020-04-10 | Outagamie | Wisconsin | 55087 | 29 | 2 |
48385 | 48385 | 2020-04-10 | Ozaukee | Wisconsin | 55089 | 71 | 12 |
48386 | 48386 | 2020-04-10 | Pierce | Wisconsin | 55093 | 7 | 0 |
48387 | 48387 | 2020-04-10 | Polk | Wisconsin | 55095 | 1 | 0 |
48388 | 48388 | 2020-04-10 | Portage | Wisconsin | 55097 | 4 | 0 |
48389 | 48389 | 2020-04-10 | Racine | Wisconsin | 55101 | 100 | 3 |
48390 | 48390 | 2020-04-10 | Richland | Wisconsin | 55103 | 4 | 0 |
48391 | 48391 | 2020-04-10 | Rock | Wisconsin | 55105 | 51 | 2 |
48392 | 48392 | 2020-04-10 | Rusk | Wisconsin | 55107 | 3 | 0 |
48393 | 48393 | 2020-04-10 | Sauk | Wisconsin | 55111 | 25 | 2 |
48394 | 48394 | 2020-04-10 | Sawyer | Wisconsin | 55113 | 1 | 0 |
48395 | 48395 | 2020-04-10 | Shawano | Wisconsin | 55115 | 5 | 0 |
48396 | 48396 | 2020-04-10 | Sheboygan | Wisconsin | 55117 | 33 | 2 |
48397 | 48397 | 2020-04-10 | St. Croix | Wisconsin | 55109 | 7 | 0 |
48398 | 48398 | 2020-04-10 | Trempealeau | Wisconsin | 55121 | 1 | 0 |
48399 | 48399 | 2020-04-10 | Vilas | Wisconsin | 55125 | 4 | 0 |
48400 | 48400 | 2020-04-10 | Walworth | Wisconsin | 55127 | 35 | 0 |
48401 | 48401 | 2020-04-10 | Washington | Wisconsin | 55131 | 67 | 3 |
48402 | 48402 | 2020-04-10 | Waukesha | Wisconsin | 55133 | 193 | 6 |
48403 | 48403 | 2020-04-10 | Waupaca | Wisconsin | 55135 | 3 | 1 |
48404 | 48404 | 2020-04-10 | Waushara | Wisconsin | 55137 | 2 | 0 |
48405 | 48405 | 2020-04-10 | Winnebago | Wisconsin | 55139 | 25 | 1 |
48406 | 48406 | 2020-04-10 | 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);