ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where "date" is on date 2020-03-25 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12324 | 12324 | 2020-03-25 | Bayfield | Wisconsin | 55007 | 1 | 0 |
12325 | 12325 | 2020-03-25 | Brown | Wisconsin | 55009 | 3 | 0 |
12326 | 12326 | 2020-03-25 | Calumet | Wisconsin | 55015 | 1 | 0 |
12327 | 12327 | 2020-03-25 | Chippewa | Wisconsin | 55017 | 1 | 0 |
12328 | 12328 | 2020-03-25 | Columbia | Wisconsin | 55021 | 5 | 0 |
12329 | 12329 | 2020-03-25 | Dane | Wisconsin | 55025 | 88 | 1 |
12330 | 12330 | 2020-03-25 | Dodge | Wisconsin | 55027 | 3 | 0 |
12331 | 12331 | 2020-03-25 | Douglas | Wisconsin | 55031 | 4 | 0 |
12332 | 12332 | 2020-03-25 | Dunn | Wisconsin | 55033 | 1 | 0 |
12333 | 12333 | 2020-03-25 | Eau Claire | Wisconsin | 55035 | 5 | 0 |
12334 | 12334 | 2020-03-25 | Fond du Lac | Wisconsin | 55039 | 18 | 1 |
12335 | 12335 | 2020-03-25 | Grant | Wisconsin | 55043 | 1 | 0 |
12336 | 12336 | 2020-03-25 | Green | Wisconsin | 55045 | 1 | 0 |
12337 | 12337 | 2020-03-25 | Iowa | Wisconsin | 55049 | 3 | 0 |
12338 | 12338 | 2020-03-25 | Jefferson | Wisconsin | 55055 | 5 | 0 |
12339 | 12339 | 2020-03-25 | Juneau | Wisconsin | 55057 | 1 | 0 |
12340 | 12340 | 2020-03-25 | Kenosha | Wisconsin | 55059 | 14 | 0 |
12341 | 12341 | 2020-03-25 | La Crosse | Wisconsin | 55063 | 12 | 0 |
12342 | 12342 | 2020-03-25 | Marathon | Wisconsin | 55073 | 1 | 0 |
12343 | 12343 | 2020-03-25 | Milwaukee | Wisconsin | 55079 | 325 | 4 |
12344 | 12344 | 2020-03-25 | Monroe | Wisconsin | 55081 | 1 | 0 |
12345 | 12345 | 2020-03-25 | Outagamie | Wisconsin | 55087 | 4 | 0 |
12346 | 12346 | 2020-03-25 | Ozaukee | Wisconsin | 55089 | 20 | 1 |
12347 | 12347 | 2020-03-25 | Pierce | Wisconsin | 55093 | 3 | 0 |
12348 | 12348 | 2020-03-25 | Racine | Wisconsin | 55101 | 7 | 0 |
12349 | 12349 | 2020-03-25 | Rock | Wisconsin | 55105 | 4 | 0 |
12350 | 12350 | 2020-03-25 | Sauk | Wisconsin | 55111 | 6 | 0 |
12351 | 12351 | 2020-03-25 | Sheboygan | Wisconsin | 55117 | 7 | 0 |
12352 | 12352 | 2020-03-25 | St. Croix | Wisconsin | 55109 | 4 | 0 |
12353 | 12353 | 2020-03-25 | Walworth | Wisconsin | 55127 | 5 | 0 |
12354 | 12354 | 2020-03-25 | Washington | Wisconsin | 55131 | 21 | 0 |
12355 | 12355 | 2020-03-25 | Waukesha | Wisconsin | 55133 | 42 | 0 |
12356 | 12356 | 2020-03-25 | Winnebago | Wisconsin | 55139 | 5 | 0 |
12357 | 12357 | 2020-03-25 | Wood | Wisconsin | 55141 | 1 | 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);