ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 55117 and state = "Wisconsin" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
261922 | 261922 | 2020-06-21 | Sheboygan | Wisconsin | 55117 | 185 | 4 |
265051 | 265051 | 2020-06-22 | Sheboygan | Wisconsin | 55117 | 185 | 4 |
268180 | 268180 | 2020-06-23 | Sheboygan | Wisconsin | 55117 | 186 | 4 |
271314 | 271314 | 2020-06-24 | Sheboygan | Wisconsin | 55117 | 187 | 4 |
274454 | 274454 | 2020-06-25 | Sheboygan | Wisconsin | 55117 | 189 | 4 |
277602 | 277602 | 2020-06-26 | Sheboygan | Wisconsin | 55117 | 190 | 4 |
280750 | 280750 | 2020-06-27 | Sheboygan | Wisconsin | 55117 | 195 | 4 |
283896 | 283896 | 2020-06-28 | Sheboygan | Wisconsin | 55117 | 198 | 4 |
287042 | 287042 | 2020-06-29 | Sheboygan | Wisconsin | 55117 | 201 | 4 |
290192 | 290192 | 2020-06-30 | Sheboygan | Wisconsin | 55117 | 208 | 4 |
293345 | 293345 | 2020-07-01 | Sheboygan | Wisconsin | 55117 | 208 | 4 |
296500 | 296500 | 2020-07-02 | Sheboygan | Wisconsin | 55117 | 214 | 4 |
299662 | 299662 | 2020-07-03 | Sheboygan | Wisconsin | 55117 | 223 | 4 |
302826 | 302826 | 2020-07-04 | Sheboygan | Wisconsin | 55117 | 224 | 4 |
305990 | 305990 | 2020-07-05 | Sheboygan | Wisconsin | 55117 | 229 | 4 |
309159 | 309159 | 2020-07-06 | Sheboygan | Wisconsin | 55117 | 236 | 4 |
312328 | 312328 | 2020-07-07 | Sheboygan | Wisconsin | 55117 | 245 | 4 |
315503 | 315503 | 2020-07-08 | Sheboygan | Wisconsin | 55117 | 255 | 4 |
318676 | 318676 | 2020-07-09 | Sheboygan | Wisconsin | 55117 | 265 | 4 |
321855 | 321855 | 2020-07-10 | Sheboygan | Wisconsin | 55117 | 275 | 4 |
325036 | 325036 | 2020-07-11 | Sheboygan | Wisconsin | 55117 | 283 | 4 |
328222 | 328222 | 2020-07-12 | Sheboygan | Wisconsin | 55117 | 287 | 4 |
331408 | 331408 | 2020-07-13 | Sheboygan | Wisconsin | 55117 | 293 | 4 |
334601 | 334601 | 2020-07-14 | Sheboygan | Wisconsin | 55117 | 312 | 4 |
337796 | 337796 | 2020-07-15 | Sheboygan | Wisconsin | 55117 | 326 | 4 |
340992 | 340992 | 2020-07-16 | Sheboygan | Wisconsin | 55117 | 340 | 4 |
344191 | 344191 | 2020-07-17 | Sheboygan | Wisconsin | 55117 | 368 | 4 |
347391 | 347391 | 2020-07-18 | Sheboygan | Wisconsin | 55117 | 374 | 4 |
350592 | 350592 | 2020-07-19 | Sheboygan | Wisconsin | 55117 | 386 | 4 |
353794 | 353794 | 2020-07-20 | Sheboygan | Wisconsin | 55117 | 398 | 4 |
356997 | 356997 | 2020-07-21 | Sheboygan | Wisconsin | 55117 | 410 | 5 |
360202 | 360202 | 2020-07-22 | Sheboygan | Wisconsin | 55117 | 419 | 5 |
363408 | 363408 | 2020-07-23 | Sheboygan | Wisconsin | 55117 | 433 | 5 |
366615 | 366615 | 2020-07-24 | Sheboygan | Wisconsin | 55117 | 446 | 5 |
369825 | 369825 | 2020-07-25 | Sheboygan | Wisconsin | 55117 | 464 | 5 |
373037 | 373037 | 2020-07-26 | Sheboygan | Wisconsin | 55117 | 473 | 5 |
376251 | 376251 | 2020-07-27 | Sheboygan | Wisconsin | 55117 | 483 | 5 |
379467 | 379467 | 2020-07-28 | Sheboygan | Wisconsin | 55117 | 505 | 5 |
382684 | 382684 | 2020-07-29 | Sheboygan | Wisconsin | 55117 | 558 | 5 |
385902 | 385902 | 2020-07-30 | Sheboygan | Wisconsin | 55117 | 573 | 5 |
389119 | 389119 | 2020-07-31 | Sheboygan | Wisconsin | 55117 | 578 | 5 |
392336 | 392336 | 2020-08-01 | Sheboygan | Wisconsin | 55117 | 586 | 5 |
395552 | 395552 | 2020-08-02 | Sheboygan | Wisconsin | 55117 | 609 | 5 |
398768 | 398768 | 2020-08-03 | Sheboygan | Wisconsin | 55117 | 622 | 5 |
401984 | 401984 | 2020-08-04 | Sheboygan | Wisconsin | 55117 | 636 | 6 |
405202 | 405202 | 2020-08-05 | Sheboygan | Wisconsin | 55117 | 682 | 8 |
408422 | 408422 | 2020-08-06 | Sheboygan | Wisconsin | 55117 | 720 | 9 |
411641 | 411641 | 2020-08-07 | Sheboygan | Wisconsin | 55117 | 733 | 9 |
414861 | 414861 | 2020-08-08 | Sheboygan | Wisconsin | 55117 | 742 | 9 |
418082 | 418082 | 2020-08-09 | Sheboygan | Wisconsin | 55117 | 746 | 9 |
421303 | 421303 | 2020-08-10 | Sheboygan | Wisconsin | 55117 | 753 | 9 |
424524 | 424524 | 2020-08-11 | Sheboygan | Wisconsin | 55117 | 776 | 8 |
427748 | 427748 | 2020-08-12 | Sheboygan | Wisconsin | 55117 | 786 | 8 |
430976 | 430976 | 2020-08-13 | Sheboygan | Wisconsin | 55117 | 804 | 8 |
434201 | 434201 | 2020-08-14 | Sheboygan | Wisconsin | 55117 | 814 | 8 |
437427 | 437427 | 2020-08-15 | Sheboygan | Wisconsin | 55117 | 835 | 8 |
440653 | 440653 | 2020-08-16 | Sheboygan | Wisconsin | 55117 | 842 | 8 |
443879 | 443879 | 2020-08-17 | Sheboygan | Wisconsin | 55117 | 850 | 8 |
447106 | 447106 | 2020-08-18 | Sheboygan | Wisconsin | 55117 | 873 | 8 |
450334 | 450334 | 2020-08-19 | Sheboygan | Wisconsin | 55117 | 893 | 8 |
453562 | 453562 | 2020-08-20 | Sheboygan | Wisconsin | 55117 | 903 | 8 |
456790 | 456790 | 2020-08-21 | Sheboygan | Wisconsin | 55117 | 917 | 8 |
460017 | 460017 | 2020-08-22 | Sheboygan | Wisconsin | 55117 | 929 | 8 |
463246 | 463246 | 2020-08-23 | Sheboygan | Wisconsin | 55117 | 933 | 8 |
466475 | 466475 | 2020-08-24 | Sheboygan | Wisconsin | 55117 | 962 | 8 |
469704 | 469704 | 2020-08-25 | Sheboygan | Wisconsin | 55117 | 972 | 8 |
472936 | 472936 | 2020-08-26 | Sheboygan | Wisconsin | 55117 | 988 | 8 |
476169 | 476169 | 2020-08-27 | Sheboygan | Wisconsin | 55117 | 1005 | 8 |
479402 | 479402 | 2020-08-28 | Sheboygan | Wisconsin | 55117 | 1016 | 8 |
482636 | 482636 | 2020-08-29 | Sheboygan | Wisconsin | 55117 | 1022 | 8 |
485871 | 485871 | 2020-08-30 | Sheboygan | Wisconsin | 55117 | 1032 | 9 |
489104 | 489104 | 2020-08-31 | Sheboygan | Wisconsin | 55117 | 1071 | 9 |
492337 | 492337 | 2020-09-01 | Sheboygan | Wisconsin | 55117 | 1085 | 9 |
495571 | 495571 | 2020-09-02 | Sheboygan | Wisconsin | 55117 | 1091 | 9 |
498804 | 498804 | 2020-09-03 | Sheboygan | Wisconsin | 55117 | 1108 | 9 |
502038 | 502038 | 2020-09-04 | Sheboygan | Wisconsin | 55117 | 1187 | 9 |
505272 | 505272 | 2020-09-05 | Sheboygan | Wisconsin | 55117 | 1199 | 9 |
508504 | 508504 | 2020-09-06 | Sheboygan | Wisconsin | 55117 | 1214 | 9 |
511737 | 511737 | 2020-09-07 | Sheboygan | Wisconsin | 55117 | 1219 | 9 |
514970 | 514970 | 2020-09-08 | Sheboygan | Wisconsin | 55117 | 1224 | 10 |
518205 | 518205 | 2020-09-09 | Sheboygan | Wisconsin | 55117 | 1240 | 10 |
521442 | 521442 | 2020-09-10 | Sheboygan | Wisconsin | 55117 | 1246 | 10 |
524678 | 524678 | 2020-09-11 | Sheboygan | Wisconsin | 55117 | 1259 | 10 |
527914 | 527914 | 2020-09-12 | Sheboygan | Wisconsin | 55117 | 1276 | 11 |
531151 | 531151 | 2020-09-13 | Sheboygan | Wisconsin | 55117 | 1282 | 11 |
534386 | 534386 | 2020-09-14 | Sheboygan | Wisconsin | 55117 | 1292 | 11 |
537622 | 537622 | 2020-09-15 | Sheboygan | Wisconsin | 55117 | 1328 | 12 |
540859 | 540859 | 2020-09-16 | Sheboygan | Wisconsin | 55117 | 1345 | 14 |
544095 | 544095 | 2020-09-17 | Sheboygan | Wisconsin | 55117 | 1370 | 14 |
547332 | 547332 | 2020-09-18 | Sheboygan | Wisconsin | 55117 | 1468 | 14 |
550571 | 550571 | 2020-09-19 | Sheboygan | Wisconsin | 55117 | 1486 | 14 |
553810 | 553810 | 2020-09-20 | Sheboygan | Wisconsin | 55117 | 1495 | 14 |
557047 | 557047 | 2020-09-21 | Sheboygan | Wisconsin | 55117 | 1506 | 15 |
560283 | 560283 | 2020-09-22 | Sheboygan | Wisconsin | 55117 | 1544 | 15 |
563522 | 563522 | 2020-09-23 | Sheboygan | Wisconsin | 55117 | 1556 | 15 |
566763 | 566763 | 2020-09-24 | Sheboygan | Wisconsin | 55117 | 1588 | 15 |
570004 | 570004 | 2020-09-25 | Sheboygan | Wisconsin | 55117 | 1610 | 16 |
573246 | 573246 | 2020-09-26 | Sheboygan | Wisconsin | 55117 | 1633 | 16 |
576490 | 576490 | 2020-09-27 | Sheboygan | Wisconsin | 55117 | 1643 | 16 |
579731 | 579731 | 2020-09-28 | Sheboygan | Wisconsin | 55117 | 1686 | 16 |
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);