ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where deaths = 1, fips = 55071 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 |
---|---|---|---|---|---|---|---|
479379 | 479379 | 2020-08-28 | Manitowoc | Wisconsin | 55071 | 505 | 1 |
476146 | 476146 | 2020-08-27 | Manitowoc | Wisconsin | 55071 | 488 | 1 |
472913 | 472913 | 2020-08-26 | Manitowoc | Wisconsin | 55071 | 478 | 1 |
469681 | 469681 | 2020-08-25 | Manitowoc | Wisconsin | 55071 | 468 | 1 |
466452 | 466452 | 2020-08-24 | Manitowoc | Wisconsin | 55071 | 457 | 1 |
463223 | 463223 | 2020-08-23 | Manitowoc | Wisconsin | 55071 | 452 | 1 |
459994 | 459994 | 2020-08-22 | Manitowoc | Wisconsin | 55071 | 446 | 1 |
456767 | 456767 | 2020-08-21 | Manitowoc | Wisconsin | 55071 | 436 | 1 |
453539 | 453539 | 2020-08-20 | Manitowoc | Wisconsin | 55071 | 429 | 1 |
450311 | 450311 | 2020-08-19 | Manitowoc | Wisconsin | 55071 | 424 | 1 |
447083 | 447083 | 2020-08-18 | Manitowoc | Wisconsin | 55071 | 414 | 1 |
443856 | 443856 | 2020-08-17 | Manitowoc | Wisconsin | 55071 | 406 | 1 |
440630 | 440630 | 2020-08-16 | Manitowoc | Wisconsin | 55071 | 399 | 1 |
437404 | 437404 | 2020-08-15 | Manitowoc | Wisconsin | 55071 | 391 | 1 |
434178 | 434178 | 2020-08-14 | Manitowoc | Wisconsin | 55071 | 373 | 1 |
430953 | 430953 | 2020-08-13 | Manitowoc | Wisconsin | 55071 | 361 | 1 |
427725 | 427725 | 2020-08-12 | Manitowoc | Wisconsin | 55071 | 354 | 1 |
424501 | 424501 | 2020-08-11 | Manitowoc | Wisconsin | 55071 | 351 | 1 |
421280 | 421280 | 2020-08-10 | Manitowoc | Wisconsin | 55071 | 345 | 1 |
418059 | 418059 | 2020-08-09 | Manitowoc | Wisconsin | 55071 | 337 | 1 |
414838 | 414838 | 2020-08-08 | Manitowoc | Wisconsin | 55071 | 332 | 1 |
411618 | 411618 | 2020-08-07 | Manitowoc | Wisconsin | 55071 | 325 | 1 |
408399 | 408399 | 2020-08-06 | Manitowoc | Wisconsin | 55071 | 321 | 1 |
405179 | 405179 | 2020-08-05 | Manitowoc | Wisconsin | 55071 | 318 | 1 |
401961 | 401961 | 2020-08-04 | Manitowoc | Wisconsin | 55071 | 311 | 1 |
398745 | 398745 | 2020-08-03 | Manitowoc | Wisconsin | 55071 | 306 | 1 |
395529 | 395529 | 2020-08-02 | Manitowoc | Wisconsin | 55071 | 301 | 1 |
392313 | 392313 | 2020-08-01 | Manitowoc | Wisconsin | 55071 | 295 | 1 |
389096 | 389096 | 2020-07-31 | Manitowoc | Wisconsin | 55071 | 287 | 1 |
385879 | 385879 | 2020-07-30 | Manitowoc | Wisconsin | 55071 | 281 | 1 |
382661 | 382661 | 2020-07-29 | Manitowoc | Wisconsin | 55071 | 272 | 1 |
379444 | 379444 | 2020-07-28 | Manitowoc | Wisconsin | 55071 | 257 | 1 |
376228 | 376228 | 2020-07-27 | Manitowoc | Wisconsin | 55071 | 255 | 1 |
373014 | 373014 | 2020-07-26 | Manitowoc | Wisconsin | 55071 | 247 | 1 |
369802 | 369802 | 2020-07-25 | Manitowoc | Wisconsin | 55071 | 228 | 1 |
366592 | 366592 | 2020-07-24 | Manitowoc | Wisconsin | 55071 | 224 | 1 |
363385 | 363385 | 2020-07-23 | Manitowoc | Wisconsin | 55071 | 219 | 1 |
360179 | 360179 | 2020-07-22 | Manitowoc | Wisconsin | 55071 | 212 | 1 |
356974 | 356974 | 2020-07-21 | Manitowoc | Wisconsin | 55071 | 207 | 1 |
353771 | 353771 | 2020-07-20 | Manitowoc | Wisconsin | 55071 | 202 | 1 |
350569 | 350569 | 2020-07-19 | Manitowoc | Wisconsin | 55071 | 199 | 1 |
347368 | 347368 | 2020-07-18 | Manitowoc | Wisconsin | 55071 | 189 | 1 |
344168 | 344168 | 2020-07-17 | Manitowoc | Wisconsin | 55071 | 180 | 1 |
340969 | 340969 | 2020-07-16 | Manitowoc | Wisconsin | 55071 | 177 | 1 |
337773 | 337773 | 2020-07-15 | Manitowoc | Wisconsin | 55071 | 167 | 1 |
334578 | 334578 | 2020-07-14 | Manitowoc | Wisconsin | 55071 | 162 | 1 |
331385 | 331385 | 2020-07-13 | Manitowoc | Wisconsin | 55071 | 155 | 1 |
328199 | 328199 | 2020-07-12 | Manitowoc | Wisconsin | 55071 | 152 | 1 |
325013 | 325013 | 2020-07-11 | Manitowoc | Wisconsin | 55071 | 147 | 1 |
321832 | 321832 | 2020-07-10 | Manitowoc | Wisconsin | 55071 | 139 | 1 |
318653 | 318653 | 2020-07-09 | Manitowoc | Wisconsin | 55071 | 132 | 1 |
315480 | 315480 | 2020-07-08 | Manitowoc | Wisconsin | 55071 | 128 | 1 |
312305 | 312305 | 2020-07-07 | Manitowoc | Wisconsin | 55071 | 122 | 1 |
309136 | 309136 | 2020-07-06 | Manitowoc | Wisconsin | 55071 | 116 | 1 |
305967 | 305967 | 2020-07-05 | Manitowoc | Wisconsin | 55071 | 114 | 1 |
302803 | 302803 | 2020-07-04 | Manitowoc | Wisconsin | 55071 | 108 | 1 |
299639 | 299639 | 2020-07-03 | Manitowoc | Wisconsin | 55071 | 104 | 1 |
296477 | 296477 | 2020-07-02 | Manitowoc | Wisconsin | 55071 | 100 | 1 |
293322 | 293322 | 2020-07-01 | Manitowoc | Wisconsin | 55071 | 99 | 1 |
290169 | 290169 | 2020-06-30 | Manitowoc | Wisconsin | 55071 | 94 | 1 |
287019 | 287019 | 2020-06-29 | Manitowoc | Wisconsin | 55071 | 92 | 1 |
283873 | 283873 | 2020-06-28 | Manitowoc | Wisconsin | 55071 | 91 | 1 |
280727 | 280727 | 2020-06-27 | Manitowoc | Wisconsin | 55071 | 87 | 1 |
277579 | 277579 | 2020-06-26 | Manitowoc | Wisconsin | 55071 | 83 | 1 |
274431 | 274431 | 2020-06-25 | Manitowoc | Wisconsin | 55071 | 81 | 1 |
271291 | 271291 | 2020-06-24 | Manitowoc | Wisconsin | 55071 | 81 | 1 |
268157 | 268157 | 2020-06-23 | Manitowoc | Wisconsin | 55071 | 76 | 1 |
265028 | 265028 | 2020-06-22 | Manitowoc | Wisconsin | 55071 | 70 | 1 |
261899 | 261899 | 2020-06-21 | Manitowoc | Wisconsin | 55071 | 68 | 1 |
258772 | 258772 | 2020-06-20 | Manitowoc | Wisconsin | 55071 | 63 | 1 |
255645 | 255645 | 2020-06-19 | Manitowoc | Wisconsin | 55071 | 58 | 1 |
252526 | 252526 | 2020-06-18 | Manitowoc | Wisconsin | 55071 | 56 | 1 |
249411 | 249411 | 2020-06-17 | Manitowoc | Wisconsin | 55071 | 50 | 1 |
246299 | 246299 | 2020-06-16 | Manitowoc | Wisconsin | 55071 | 48 | 1 |
243186 | 243186 | 2020-06-15 | Manitowoc | Wisconsin | 55071 | 47 | 1 |
240075 | 240075 | 2020-06-14 | Manitowoc | Wisconsin | 55071 | 45 | 1 |
236967 | 236967 | 2020-06-13 | Manitowoc | Wisconsin | 55071 | 42 | 1 |
233860 | 233860 | 2020-06-12 | Manitowoc | Wisconsin | 55071 | 42 | 1 |
230755 | 230755 | 2020-06-11 | Manitowoc | Wisconsin | 55071 | 40 | 1 |
227651 | 227651 | 2020-06-10 | Manitowoc | Wisconsin | 55071 | 40 | 1 |
224551 | 224551 | 2020-06-09 | Manitowoc | Wisconsin | 55071 | 40 | 1 |
221455 | 221455 | 2020-06-08 | Manitowoc | Wisconsin | 55071 | 40 | 1 |
218363 | 218363 | 2020-06-07 | Manitowoc | Wisconsin | 55071 | 39 | 1 |
215273 | 215273 | 2020-06-06 | Manitowoc | Wisconsin | 55071 | 39 | 1 |
212186 | 212186 | 2020-06-05 | Manitowoc | Wisconsin | 55071 | 39 | 1 |
209101 | 209101 | 2020-06-04 | Manitowoc | Wisconsin | 55071 | 38 | 1 |
206019 | 206019 | 2020-06-03 | Manitowoc | Wisconsin | 55071 | 38 | 1 |
202940 | 202940 | 2020-06-02 | Manitowoc | Wisconsin | 55071 | 36 | 1 |
199864 | 199864 | 2020-06-01 | Manitowoc | Wisconsin | 55071 | 36 | 1 |
196791 | 196791 | 2020-05-31 | Manitowoc | Wisconsin | 55071 | 36 | 1 |
193721 | 193721 | 2020-05-30 | Manitowoc | Wisconsin | 55071 | 36 | 1 |
190655 | 190655 | 2020-05-29 | Manitowoc | Wisconsin | 55071 | 36 | 1 |
187591 | 187591 | 2020-05-28 | Manitowoc | Wisconsin | 55071 | 36 | 1 |
184534 | 184534 | 2020-05-27 | Manitowoc | Wisconsin | 55071 | 32 | 1 |
181483 | 181483 | 2020-05-26 | Manitowoc | Wisconsin | 55071 | 31 | 1 |
178439 | 178439 | 2020-05-25 | Manitowoc | Wisconsin | 55071 | 29 | 1 |
175394 | 175394 | 2020-05-24 | Manitowoc | Wisconsin | 55071 | 29 | 1 |
172351 | 172351 | 2020-05-23 | Manitowoc | Wisconsin | 55071 | 28 | 1 |
169310 | 169310 | 2020-05-22 | Manitowoc | Wisconsin | 55071 | 28 | 1 |
166274 | 166274 | 2020-05-21 | Manitowoc | Wisconsin | 55071 | 28 | 1 |
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);