ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where "date" is on date 2020-04-02 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
28328 | 28328 | 2020-04-02 | Adams | Wisconsin | 55001 | 1 | 0 |
28329 | 28329 | 2020-04-02 | Ashland | Wisconsin | 55003 | 1 | 0 |
28330 | 28330 | 2020-04-02 | Bayfield | Wisconsin | 55007 | 3 | 0 |
28331 | 28331 | 2020-04-02 | Brown | Wisconsin | 55009 | 17 | 0 |
28332 | 28332 | 2020-04-02 | Buffalo | Wisconsin | 55011 | 2 | 0 |
28333 | 28333 | 2020-04-02 | Calumet | Wisconsin | 55015 | 3 | 0 |
28334 | 28334 | 2020-04-02 | Chippewa | Wisconsin | 55017 | 11 | 0 |
28335 | 28335 | 2020-04-02 | Clark | Wisconsin | 55019 | 6 | 0 |
28336 | 28336 | 2020-04-02 | Columbia | Wisconsin | 55021 | 15 | 0 |
28337 | 28337 | 2020-04-02 | Crawford | Wisconsin | 55023 | 1 | 0 |
28338 | 28338 | 2020-04-02 | Dane | Wisconsin | 55025 | 228 | 3 |
28339 | 28339 | 2020-04-02 | Dodge | Wisconsin | 55027 | 13 | 0 |
28340 | 28340 | 2020-04-02 | Door | Wisconsin | 55029 | 2 | 0 |
28341 | 28341 | 2020-04-02 | Douglas | Wisconsin | 55031 | 6 | 0 |
28342 | 28342 | 2020-04-02 | Dunn | Wisconsin | 55033 | 3 | 0 |
28343 | 28343 | 2020-04-02 | Eau Claire | Wisconsin | 55035 | 14 | 0 |
28344 | 28344 | 2020-04-02 | Fond du Lac | Wisconsin | 55039 | 28 | 2 |
28345 | 28345 | 2020-04-02 | Grant | Wisconsin | 55043 | 2 | 0 |
28346 | 28346 | 2020-04-02 | Green | Wisconsin | 55045 | 7 | 0 |
28347 | 28347 | 2020-04-02 | Iowa | Wisconsin | 55049 | 3 | 0 |
28348 | 28348 | 2020-04-02 | Iron | Wisconsin | 55051 | 1 | 1 |
28349 | 28349 | 2020-04-02 | Jackson | Wisconsin | 55053 | 2 | 0 |
28350 | 28350 | 2020-04-02 | Jefferson | Wisconsin | 55055 | 12 | 0 |
28351 | 28351 | 2020-04-02 | Juneau | Wisconsin | 55057 | 4 | 0 |
28352 | 28352 | 2020-04-02 | Kenosha | Wisconsin | 55059 | 67 | 0 |
28353 | 28353 | 2020-04-02 | La Crosse | Wisconsin | 55063 | 19 | 0 |
28354 | 28354 | 2020-04-02 | Marathon | Wisconsin | 55073 | 8 | 0 |
28355 | 28355 | 2020-04-02 | Marinette | Wisconsin | 55075 | 2 | 0 |
28356 | 28356 | 2020-04-02 | Marquette | Wisconsin | 55077 | 2 | 0 |
28357 | 28357 | 2020-04-02 | Menominee | Wisconsin | 55078 | 1 | 0 |
28358 | 28358 | 2020-04-02 | Milwaukee | Wisconsin | 55079 | 869 | 18 |
28359 | 28359 | 2020-04-02 | Monroe | Wisconsin | 55081 | 3 | 0 |
28360 | 28360 | 2020-04-02 | Oconto | Wisconsin | 55083 | 1 | 0 |
28361 | 28361 | 2020-04-02 | Oneida | Wisconsin | 55085 | 3 | 0 |
28362 | 28362 | 2020-04-02 | Outagamie | Wisconsin | 55087 | 14 | 0 |
28363 | 28363 | 2020-04-02 | Ozaukee | Wisconsin | 55089 | 47 | 5 |
28364 | 28364 | 2020-04-02 | Pierce | Wisconsin | 55093 | 7 | 0 |
28365 | 28365 | 2020-04-02 | Portage | Wisconsin | 55097 | 2 | 0 |
28366 | 28366 | 2020-04-02 | Racine | Wisconsin | 55101 | 35 | 0 |
28367 | 28367 | 2020-04-02 | Richland | Wisconsin | 55103 | 2 | 0 |
28368 | 28368 | 2020-04-02 | Rock | Wisconsin | 55105 | 19 | 1 |
28369 | 28369 | 2020-04-02 | Sauk | Wisconsin | 55111 | 16 | 2 |
28370 | 28370 | 2020-04-02 | Sheboygan | Wisconsin | 55117 | 16 | 1 |
28371 | 28371 | 2020-04-02 | St. Croix | Wisconsin | 55109 | 6 | 0 |
28372 | 28372 | 2020-04-02 | Trempealeau | Wisconsin | 55121 | 1 | 0 |
28373 | 28373 | 2020-04-02 | Vilas | Wisconsin | 55125 | 3 | 0 |
28374 | 28374 | 2020-04-02 | Walworth | Wisconsin | 55127 | 15 | 0 |
28375 | 28375 | 2020-04-02 | Washington | Wisconsin | 55131 | 46 | 2 |
28376 | 28376 | 2020-04-02 | Waukesha | Wisconsin | 55133 | 120 | 1 |
28377 | 28377 | 2020-04-02 | Waupaca | Wisconsin | 55135 | 2 | 1 |
28378 | 28378 | 2020-04-02 | Winnebago | Wisconsin | 55139 | 17 | 0 |
28379 | 28379 | 2020-04-02 | 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);