ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Marathon" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
732145 | 732145 | 2020-11-14 | Marathon | Wisconsin | 55073 | 8371 | 106 |
728900 | 728900 | 2020-11-13 | Marathon | Wisconsin | 55073 | 8296 | 106 |
725657 | 725657 | 2020-11-12 | Marathon | Wisconsin | 55073 | 8069 | 101 |
722414 | 722414 | 2020-11-11 | Marathon | Wisconsin | 55073 | 7840 | 97 |
719171 | 719171 | 2020-11-10 | Marathon | Wisconsin | 55073 | 7593 | 92 |
715928 | 715928 | 2020-11-09 | Marathon | Wisconsin | 55073 | 7347 | 85 |
712684 | 712684 | 2020-11-08 | Marathon | Wisconsin | 55073 | 7159 | 80 |
709440 | 709440 | 2020-11-07 | Marathon | Wisconsin | 55073 | 6988 | 80 |
706196 | 706196 | 2020-11-06 | Marathon | Wisconsin | 55073 | 6741 | 79 |
702953 | 702953 | 2020-11-05 | Marathon | Wisconsin | 55073 | 6573 | 78 |
699710 | 699710 | 2020-11-04 | Marathon | Wisconsin | 55073 | 6383 | 75 |
696466 | 696466 | 2020-11-03 | Marathon | Wisconsin | 55073 | 6127 | 72 |
693224 | 693224 | 2020-11-02 | Marathon | Wisconsin | 55073 | 5992 | 66 |
689980 | 689980 | 2020-11-01 | Marathon | Wisconsin | 55073 | 5851 | 66 |
686735 | 686735 | 2020-10-31 | Marathon | Wisconsin | 55073 | 5726 | 61 |
683492 | 683492 | 2020-10-30 | Marathon | Wisconsin | 55073 | 5508 | 58 |
680249 | 680249 | 2020-10-29 | Marathon | Wisconsin | 55073 | 5257 | 57 |
677006 | 677006 | 2020-10-28 | Marathon | Wisconsin | 55073 | 5086 | 57 |
673763 | 673763 | 2020-10-27 | Marathon | Wisconsin | 55073 | 4961 | 56 |
670521 | 670521 | 2020-10-26 | Marathon | Wisconsin | 55073 | 4828 | 55 |
667278 | 667278 | 2020-10-25 | Marathon | Wisconsin | 55073 | 4635 | 50 |
664033 | 664033 | 2020-10-24 | Marathon | Wisconsin | 55073 | 4487 | 48 |
660789 | 660789 | 2020-10-23 | Marathon | Wisconsin | 55073 | 4301 | 48 |
657545 | 657545 | 2020-10-22 | Marathon | Wisconsin | 55073 | 4125 | 42 |
654300 | 654300 | 2020-10-21 | Marathon | Wisconsin | 55073 | 3959 | 41 |
651055 | 651055 | 2020-10-20 | Marathon | Wisconsin | 55073 | 3763 | 40 |
647811 | 647811 | 2020-10-19 | Marathon | Wisconsin | 55073 | 3604 | 35 |
644565 | 644565 | 2020-10-18 | Marathon | Wisconsin | 55073 | 3362 | 32 |
641317 | 641317 | 2020-10-17 | Marathon | Wisconsin | 55073 | 3362 | 32 |
638070 | 638070 | 2020-10-16 | Marathon | Wisconsin | 55073 | 3362 | 32 |
634825 | 634825 | 2020-10-15 | Marathon | Wisconsin | 55073 | 3212 | 31 |
631580 | 631580 | 2020-10-14 | Marathon | Wisconsin | 55073 | 3074 | 31 |
628336 | 628336 | 2020-10-13 | Marathon | Wisconsin | 55073 | 2865 | 31 |
625093 | 625093 | 2020-10-12 | Marathon | Wisconsin | 55073 | 2783 | 30 |
621850 | 621850 | 2020-10-11 | Marathon | Wisconsin | 55073 | 2688 | 30 |
618607 | 618607 | 2020-10-10 | Marathon | Wisconsin | 55073 | 2577 | 30 |
615365 | 615365 | 2020-10-09 | Marathon | Wisconsin | 55073 | 2470 | 27 |
612124 | 612124 | 2020-10-08 | Marathon | Wisconsin | 55073 | 2314 | 24 |
608882 | 608882 | 2020-10-07 | Marathon | Wisconsin | 55073 | 2214 | 23 |
605639 | 605639 | 2020-10-06 | Marathon | Wisconsin | 55073 | 2135 | 22 |
602397 | 602397 | 2020-10-05 | Marathon | Wisconsin | 55073 | 2037 | 17 |
599154 | 599154 | 2020-10-04 | Marathon | Wisconsin | 55073 | 1977 | 16 |
595911 | 595911 | 2020-10-03 | Marathon | Wisconsin | 55073 | 1924 | 16 |
592669 | 592669 | 2020-10-02 | Marathon | Wisconsin | 55073 | 1828 | 15 |
589429 | 589429 | 2020-10-01 | Marathon | Wisconsin | 55073 | 1740 | 15 |
586188 | 586188 | 2020-09-30 | Marathon | Wisconsin | 55073 | 1653 | 15 |
582948 | 582948 | 2020-09-29 | Marathon | Wisconsin | 55073 | 1563 | 14 |
579709 | 579709 | 2020-09-28 | Marathon | Wisconsin | 55073 | 1536 | 14 |
576468 | 576468 | 2020-09-27 | Marathon | Wisconsin | 55073 | 1480 | 14 |
573224 | 573224 | 2020-09-26 | Marathon | Wisconsin | 55073 | 1414 | 14 |
569982 | 569982 | 2020-09-25 | Marathon | Wisconsin | 55073 | 1333 | 14 |
566741 | 566741 | 2020-09-24 | Marathon | Wisconsin | 55073 | 1291 | 14 |
563500 | 563500 | 2020-09-23 | Marathon | Wisconsin | 55073 | 1248 | 14 |
560261 | 560261 | 2020-09-22 | Marathon | Wisconsin | 55073 | 1210 | 14 |
557025 | 557025 | 2020-09-21 | Marathon | Wisconsin | 55073 | 1177 | 14 |
553788 | 553788 | 2020-09-20 | Marathon | Wisconsin | 55073 | 1147 | 14 |
550549 | 550549 | 2020-09-19 | Marathon | Wisconsin | 55073 | 1098 | 14 |
547310 | 547310 | 2020-09-18 | Marathon | Wisconsin | 55073 | 1061 | 14 |
544073 | 544073 | 2020-09-17 | Marathon | Wisconsin | 55073 | 1034 | 14 |
540837 | 540837 | 2020-09-16 | Marathon | Wisconsin | 55073 | 1006 | 14 |
537600 | 537600 | 2020-09-15 | Marathon | Wisconsin | 55073 | 985 | 14 |
534364 | 534364 | 2020-09-14 | Marathon | Wisconsin | 55073 | 968 | 14 |
531129 | 531129 | 2020-09-13 | Marathon | Wisconsin | 55073 | 964 | 14 |
527892 | 527892 | 2020-09-12 | Marathon | Wisconsin | 55073 | 933 | 14 |
524656 | 524656 | 2020-09-11 | Marathon | Wisconsin | 55073 | 928 | 14 |
521420 | 521420 | 2020-09-10 | Marathon | Wisconsin | 55073 | 914 | 14 |
518183 | 518183 | 2020-09-09 | Marathon | Wisconsin | 55073 | 904 | 14 |
514948 | 514948 | 2020-09-08 | Marathon | Wisconsin | 55073 | 906 | 14 |
511715 | 511715 | 2020-09-07 | Marathon | Wisconsin | 55073 | 898 | 14 |
508482 | 508482 | 2020-09-06 | Marathon | Wisconsin | 55073 | 890 | 14 |
505250 | 505250 | 2020-09-05 | Marathon | Wisconsin | 55073 | 880 | 14 |
502016 | 502016 | 2020-09-04 | Marathon | Wisconsin | 55073 | 872 | 14 |
498782 | 498782 | 2020-09-03 | Marathon | Wisconsin | 55073 | 791 | 14 |
495549 | 495549 | 2020-09-02 | Marathon | Wisconsin | 55073 | 788 | 14 |
492315 | 492315 | 2020-09-01 | Marathon | Wisconsin | 55073 | 784 | 14 |
489082 | 489082 | 2020-08-31 | Marathon | Wisconsin | 55073 | 778 | 13 |
485849 | 485849 | 2020-08-30 | Marathon | Wisconsin | 55073 | 773 | 13 |
482614 | 482614 | 2020-08-29 | Marathon | Wisconsin | 55073 | 771 | 13 |
479380 | 479380 | 2020-08-28 | Marathon | Wisconsin | 55073 | 764 | 13 |
476147 | 476147 | 2020-08-27 | Marathon | Wisconsin | 55073 | 753 | 13 |
472914 | 472914 | 2020-08-26 | Marathon | Wisconsin | 55073 | 748 | 13 |
469682 | 469682 | 2020-08-25 | Marathon | Wisconsin | 55073 | 738 | 13 |
466453 | 466453 | 2020-08-24 | Marathon | Wisconsin | 55073 | 733 | 13 |
463224 | 463224 | 2020-08-23 | Marathon | Wisconsin | 55073 | 731 | 13 |
459995 | 459995 | 2020-08-22 | Marathon | Wisconsin | 55073 | 722 | 13 |
456768 | 456768 | 2020-08-21 | Marathon | Wisconsin | 55073 | 720 | 13 |
453540 | 453540 | 2020-08-20 | Marathon | Wisconsin | 55073 | 718 | 13 |
450312 | 450312 | 2020-08-19 | Marathon | Wisconsin | 55073 | 717 | 12 |
447084 | 447084 | 2020-08-18 | Marathon | Wisconsin | 55073 | 705 | 12 |
443857 | 443857 | 2020-08-17 | Marathon | Wisconsin | 55073 | 703 | 12 |
440631 | 440631 | 2020-08-16 | Marathon | Wisconsin | 55073 | 697 | 12 |
437405 | 437405 | 2020-08-15 | Marathon | Wisconsin | 55073 | 691 | 12 |
434179 | 434179 | 2020-08-14 | Marathon | Wisconsin | 55073 | 680 | 11 |
430954 | 430954 | 2020-08-13 | Marathon | Wisconsin | 55073 | 671 | 10 |
427726 | 427726 | 2020-08-12 | Marathon | Wisconsin | 55073 | 668 | 10 |
424502 | 424502 | 2020-08-11 | Marathon | Wisconsin | 55073 | 662 | 10 |
421281 | 421281 | 2020-08-10 | Marathon | Wisconsin | 55073 | 655 | 9 |
418060 | 418060 | 2020-08-09 | Marathon | Wisconsin | 55073 | 646 | 9 |
414839 | 414839 | 2020-08-08 | Marathon | Wisconsin | 55073 | 629 | 9 |
411619 | 411619 | 2020-08-07 | Marathon | Wisconsin | 55073 | 623 | 9 |
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);