ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where cases = 8 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
427708 | 427708 | 2020-08-12 | Florence | Wisconsin | 55037 | 8 | 0 |
424484 | 424484 | 2020-08-11 | Florence | Wisconsin | 55037 | 8 | 0 |
421263 | 421263 | 2020-08-10 | Florence | Wisconsin | 55037 | 8 | 0 |
418042 | 418042 | 2020-08-09 | Florence | Wisconsin | 55037 | 8 | 0 |
414821 | 414821 | 2020-08-08 | Florence | Wisconsin | 55037 | 8 | 0 |
360210 | 360210 | 2020-07-22 | Washburn | Wisconsin | 55129 | 8 | 0 |
357005 | 357005 | 2020-07-21 | Washburn | Wisconsin | 55129 | 8 | 0 |
340935 | 340935 | 2020-07-16 | Ashland | Wisconsin | 55003 | 8 | 0 |
337739 | 337739 | 2020-07-15 | Ashland | Wisconsin | 55003 | 8 | 0 |
334544 | 334544 | 2020-07-14 | Ashland | Wisconsin | 55003 | 8 | 0 |
334593 | 334593 | 2020-07-14 | Price | Wisconsin | 55099 | 8 | 0 |
331351 | 331351 | 2020-07-13 | Ashland | Wisconsin | 55003 | 8 | 0 |
331400 | 331400 | 2020-07-13 | Price | Wisconsin | 55099 | 8 | 0 |
328165 | 328165 | 2020-07-12 | Ashland | Wisconsin | 55003 | 8 | 0 |
328214 | 328214 | 2020-07-12 | Price | Wisconsin | 55099 | 8 | 0 |
325028 | 325028 | 2020-07-11 | Price | Wisconsin | 55099 | 8 | 0 |
315470 | 315470 | 2020-07-08 | Iron | Wisconsin | 55051 | 8 | 1 |
312295 | 312295 | 2020-07-07 | Iron | Wisconsin | 55051 | 8 | 1 |
309106 | 309106 | 2020-07-06 | Buffalo | Wisconsin | 55011 | 8 | 2 |
309126 | 309126 | 2020-07-06 | Iron | Wisconsin | 55051 | 8 | 1 |
305937 | 305937 | 2020-07-05 | Buffalo | Wisconsin | 55011 | 8 | 2 |
305957 | 305957 | 2020-07-05 | Iron | Wisconsin | 55051 | 8 | 1 |
302773 | 302773 | 2020-07-04 | Buffalo | Wisconsin | 55011 | 8 | 2 |
302793 | 302793 | 2020-07-04 | Iron | Wisconsin | 55051 | 8 | 1 |
299609 | 299609 | 2020-07-03 | Buffalo | Wisconsin | 55011 | 8 | 2 |
293292 | 293292 | 2020-07-01 | Buffalo | Wisconsin | 55011 | 8 | 2 |
290167 | 290167 | 2020-06-30 | Langlade | Wisconsin | 55067 | 8 | 0 |
287017 | 287017 | 2020-06-29 | Langlade | Wisconsin | 55067 | 8 | 0 |
274429 | 274429 | 2020-06-25 | Langlade | Wisconsin | 55067 | 8 | 0 |
274430 | 274430 | 2020-06-25 | Lincoln | Wisconsin | 55069 | 8 | 0 |
271290 | 271290 | 2020-06-24 | Lincoln | Wisconsin | 55069 | 8 | 0 |
268156 | 268156 | 2020-06-23 | Lincoln | Wisconsin | 55069 | 8 | 0 |
265027 | 265027 | 2020-06-22 | Lincoln | Wisconsin | 55069 | 8 | 0 |
265053 | 265053 | 2020-06-22 | Taylor | Wisconsin | 55119 | 8 | 0 |
261898 | 261898 | 2020-06-21 | Lincoln | Wisconsin | 55069 | 8 | 0 |
258771 | 258771 | 2020-06-20 | Lincoln | Wisconsin | 55069 | 8 | 0 |
255644 | 255644 | 2020-06-19 | Lincoln | Wisconsin | 55069 | 8 | 0 |
255670 | 255670 | 2020-06-19 | Taylor | Wisconsin | 55119 | 8 | 0 |
252525 | 252525 | 2020-06-18 | Lincoln | Wisconsin | 55069 | 8 | 0 |
249410 | 249410 | 2020-06-17 | Lincoln | Wisconsin | 55069 | 8 | 0 |
249440 | 249440 | 2020-06-17 | Vilas | Wisconsin | 55125 | 8 | 0 |
246264 | 246264 | 2020-06-16 | Adams | Wisconsin | 55001 | 8 | 2 |
246328 | 246328 | 2020-06-16 | Vilas | Wisconsin | 55125 | 8 | 0 |
243151 | 243151 | 2020-06-15 | Adams | Wisconsin | 55001 | 8 | 2 |
243185 | 243185 | 2020-06-15 | Lincoln | Wisconsin | 55069 | 8 | 0 |
243215 | 243215 | 2020-06-15 | Vilas | Wisconsin | 55125 | 8 | 0 |
240040 | 240040 | 2020-06-14 | Adams | Wisconsin | 55001 | 8 | 1 |
240074 | 240074 | 2020-06-14 | Lincoln | Wisconsin | 55069 | 8 | 0 |
240104 | 240104 | 2020-06-14 | Vilas | Wisconsin | 55125 | 8 | 0 |
236996 | 236996 | 2020-06-13 | Vilas | Wisconsin | 55125 | 8 | 0 |
233889 | 233889 | 2020-06-12 | Vilas | Wisconsin | 55125 | 8 | 0 |
230784 | 230784 | 2020-06-11 | Vilas | Wisconsin | 55125 | 8 | 0 |
227680 | 227680 | 2020-06-10 | Vilas | Wisconsin | 55125 | 8 | 0 |
224579 | 224579 | 2020-06-09 | Vilas | Wisconsin | 55125 | 8 | 0 |
221453 | 221453 | 2020-06-08 | Langlade | Wisconsin | 55067 | 8 | 0 |
221476 | 221476 | 2020-06-08 | Sawyer | Wisconsin | 55113 | 8 | 0 |
221483 | 221483 | 2020-06-08 | Vilas | Wisconsin | 55125 | 8 | 0 |
218384 | 218384 | 2020-06-07 | Sawyer | Wisconsin | 55113 | 8 | 0 |
218391 | 218391 | 2020-06-07 | Vilas | Wisconsin | 55125 | 8 | 0 |
215294 | 215294 | 2020-06-06 | Sawyer | Wisconsin | 55113 | 8 | 0 |
215301 | 215301 | 2020-06-06 | Vilas | Wisconsin | 55125 | 8 | 0 |
212207 | 212207 | 2020-06-05 | Sawyer | Wisconsin | 55113 | 8 | 0 |
212214 | 212214 | 2020-06-05 | Vilas | Wisconsin | 55125 | 8 | 0 |
209122 | 209122 | 2020-06-04 | Sawyer | Wisconsin | 55113 | 8 | 0 |
209129 | 209129 | 2020-06-04 | Vilas | Wisconsin | 55125 | 8 | 0 |
206040 | 206040 | 2020-06-03 | Sawyer | Wisconsin | 55113 | 8 | 0 |
206047 | 206047 | 2020-06-03 | Vilas | Wisconsin | 55125 | 8 | 0 |
202961 | 202961 | 2020-06-02 | Sawyer | Wisconsin | 55113 | 8 | 0 |
202968 | 202968 | 2020-06-02 | Vilas | Wisconsin | 55125 | 8 | 0 |
202974 | 202974 | 2020-06-02 | Waushara | Wisconsin | 55137 | 8 | 0 |
199885 | 199885 | 2020-06-01 | Sawyer | Wisconsin | 55113 | 8 | 0 |
199892 | 199892 | 2020-06-01 | Vilas | Wisconsin | 55125 | 8 | 0 |
199898 | 199898 | 2020-06-01 | Waushara | Wisconsin | 55137 | 8 | 0 |
196812 | 196812 | 2020-05-31 | Sawyer | Wisconsin | 55113 | 8 | 0 |
196825 | 196825 | 2020-05-31 | Waushara | Wisconsin | 55137 | 8 | 0 |
193742 | 193742 | 2020-05-30 | Sawyer | Wisconsin | 55113 | 8 | 0 |
193755 | 193755 | 2020-05-30 | Waushara | Wisconsin | 55137 | 8 | 0 |
190676 | 190676 | 2020-05-29 | Sawyer | Wisconsin | 55113 | 8 | 0 |
190689 | 190689 | 2020-05-29 | Waushara | Wisconsin | 55137 | 8 | 0 |
187612 | 187612 | 2020-05-28 | Sawyer | Wisconsin | 55113 | 8 | 0 |
187625 | 187625 | 2020-05-28 | Waushara | Wisconsin | 55137 | 8 | 0 |
184542 | 184542 | 2020-05-27 | Oneida | Wisconsin | 55085 | 8 | 0 |
184568 | 184568 | 2020-05-27 | Waushara | Wisconsin | 55137 | 8 | 0 |
181517 | 181517 | 2020-05-26 | Waushara | Wisconsin | 55137 | 8 | 0 |
178473 | 178473 | 2020-05-25 | Waushara | Wisconsin | 55137 | 8 | 0 |
175428 | 175428 | 2020-05-24 | Waushara | Wisconsin | 55137 | 8 | 0 |
169324 | 169324 | 2020-05-22 | Portage | Wisconsin | 55097 | 8 | 0 |
166288 | 166288 | 2020-05-21 | Portage | Wisconsin | 55097 | 8 | 0 |
163279 | 163279 | 2020-05-20 | Wood | Wisconsin | 55141 | 8 | 0 |
160251 | 160251 | 2020-05-19 | Wood | Wisconsin | 55141 | 8 | 0 |
148181 | 148181 | 2020-05-15 | Vernon | Wisconsin | 55123 | 8 | 0 |
139147 | 139147 | 2020-05-12 | Green Lake | Wisconsin | 55047 | 8 | 0 |
136156 | 136156 | 2020-05-11 | Green Lake | Wisconsin | 55047 | 8 | 0 |
133166 | 133166 | 2020-05-10 | Green Lake | Wisconsin | 55047 | 8 | 0 |
121230 | 121230 | 2020-05-06 | Lafayette | Wisconsin | 55065 | 8 | 0 |
103817 | 103817 | 2020-04-30 | Marinette | Wisconsin | 55075 | 8 | 1 |
103846 | 103846 | 2020-04-30 | Waupaca | Wisconsin | 55135 | 8 | 1 |
100967 | 100967 | 2020-04-29 | Oconto | Wisconsin | 55083 | 8 | 0 |
100991 | 100991 | 2020-04-29 | Waupaca | Wisconsin | 55135 | 8 | 1 |
98117 | 98117 | 2020-04-28 | Oconto | Wisconsin | 55083 | 8 | 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);