ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 91 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
576450 | 576450 | 2020-09-27 | Florence | Wisconsin | 55037 | 91 | 2 |
566706 | 566706 | 2020-09-24 | Ashland | Wisconsin | 55003 | 91 | 2 |
556992 | 556992 | 2020-09-21 | Bayfield | Wisconsin | 55007 | 91 | 1 |
544089 | 544089 | 2020-09-17 | Richland | Wisconsin | 55103 | 91 | 4 |
518180 | 518180 | 2020-09-09 | Langlade | Wisconsin | 55067 | 91 | 2 |
495551 | 495551 | 2020-09-02 | Marquette | Wisconsin | 55077 | 91 | 1 |
489084 | 489084 | 2020-08-31 | Marquette | Wisconsin | 55077 | 91 | 1 |
485836 | 485836 | 2020-08-30 | Green Lake | Wisconsin | 55047 | 91 | 0 |
447059 | 447059 | 2020-08-18 | Crawford | Wisconsin | 55023 | 91 | 0 |
430918 | 430918 | 2020-08-13 | Adams | Wisconsin | 55001 | 91 | 2 |
401940 | 401940 | 2020-08-04 | Door | Wisconsin | 55029 | 91 | 3 |
376209 | 376209 | 2020-07-27 | Dunn | Wisconsin | 55033 | 91 | 0 |
363398 | 363398 | 2020-07-23 | Polk | Wisconsin | 55095 | 91 | 2 |
356969 | 356969 | 2020-07-21 | Kewaunee | Wisconsin | 55061 | 91 | 1 |
350564 | 350564 | 2020-07-19 | Kewaunee | Wisconsin | 55061 | 91 | 1 |
321854 | 321854 | 2020-07-10 | Shawano | Wisconsin | 55115 | 91 | 0 |
299614 | 299614 | 2020-07-03 | Columbia | Wisconsin | 55021 | 91 | 1 |
296450 | 296450 | 2020-07-02 | Chippewa | Wisconsin | 55017 | 91 | 0 |
283873 | 283873 | 2020-06-28 | Manitowoc | Wisconsin | 55071 | 91 | 1 |
265062 | 265062 | 2020-06-22 | Waupaca | Wisconsin | 55135 | 91 | 5 |
261913 | 261913 | 2020-06-21 | Portage | Wisconsin | 55097 | 91 | 0 |
261925 | 261925 | 2020-06-21 | Trempealeau | Wisconsin | 55121 | 91 | 0 |
261933 | 261933 | 2020-06-21 | Waupaca | Wisconsin | 55135 | 91 | 5 |
258798 | 258798 | 2020-06-20 | Trempealeau | Wisconsin | 55121 | 91 | 0 |
127230 | 127230 | 2020-05-08 | Winnebago | Wisconsin | 55139 | 91 | 1 |
86830 | 86830 | 2020-04-24 | Washington | Wisconsin | 55131 | 91 | 4 |
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);