ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where date = "2020-03-20" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6047 | 6047 | 2020-03-20 | Bayfield | Wisconsin | 55007 | 1 | 0 |
6048 | 6048 | 2020-03-20 | Brown | Wisconsin | 55009 | 2 | 0 |
6049 | 6049 | 2020-03-20 | Calumet | Wisconsin | 55015 | 1 | 0 |
6050 | 6050 | 2020-03-20 | Chippewa | Wisconsin | 55017 | 1 | 0 |
6051 | 6051 | 2020-03-20 | Columbia | Wisconsin | 55021 | 5 | 0 |
6052 | 6052 | 2020-03-20 | Dane | Wisconsin | 55025 | 32 | 0 |
6053 | 6053 | 2020-03-20 | Douglas | Wisconsin | 55031 | 1 | 0 |
6054 | 6054 | 2020-03-20 | Dunn | Wisconsin | 55033 | 1 | 0 |
6055 | 6055 | 2020-03-20 | Eau Claire | Wisconsin | 55035 | 1 | 0 |
6056 | 6056 | 2020-03-20 | Fond du Lac | Wisconsin | 55039 | 14 | 1 |
6057 | 6057 | 2020-03-20 | Green | Wisconsin | 55045 | 1 | 0 |
6058 | 6058 | 2020-03-20 | Jefferson | Wisconsin | 55055 | 1 | 0 |
6059 | 6059 | 2020-03-20 | Kenosha | Wisconsin | 55059 | 4 | 0 |
6060 | 6060 | 2020-03-20 | La Crosse | Wisconsin | 55063 | 4 | 0 |
6061 | 6061 | 2020-03-20 | Marathon | Wisconsin | 55073 | 1 | 0 |
6062 | 6062 | 2020-03-20 | Milwaukee | Wisconsin | 55079 | 95 | 1 |
6063 | 6063 | 2020-03-20 | Outagamie | Wisconsin | 55087 | 2 | 0 |
6064 | 6064 | 2020-03-20 | Ozaukee | Wisconsin | 55089 | 7 | 1 |
6065 | 6065 | 2020-03-20 | Pierce | Wisconsin | 55093 | 1 | 0 |
6066 | 6066 | 2020-03-20 | Racine | Wisconsin | 55101 | 3 | 0 |
6067 | 6067 | 2020-03-20 | Rock | Wisconsin | 55105 | 1 | 0 |
6068 | 6068 | 2020-03-20 | Sauk | Wisconsin | 55111 | 2 | 0 |
6069 | 6069 | 2020-03-20 | Sheboygan | Wisconsin | 55117 | 6 | 0 |
6070 | 6070 | 2020-03-20 | St. Croix | Wisconsin | 55109 | 2 | 0 |
6071 | 6071 | 2020-03-20 | Walworth | Wisconsin | 55127 | 3 | 0 |
6072 | 6072 | 2020-03-20 | Washington | Wisconsin | 55131 | 3 | 0 |
6073 | 6073 | 2020-03-20 | Waukesha | Wisconsin | 55133 | 15 | 0 |
6074 | 6074 | 2020-03-20 | Winnebago | Wisconsin | 55139 | 5 | 0 |
6075 | 6075 | 2020-03-20 | 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);