task_winners

15 rows where winner = 82

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
739 Duel with Alex 601 Sophie Duker 82
742 Tie a ribbon round the maypole or hit it with a ping pong ball 604 Sophie Duker 82
753 Face leg or other leg? 612 Sophie Duker 82 ✓ ✓
762 High-five Alex 621 Sophie Duker 82
770 Correctly guess the person's first name 629 Sophie Duker 82 ✓
771 Display your vocal range 630 Sophie Duker 82
774 Show off 632 Sophie Duker 82
777 Deliver a cocktail to Greg 633 Sophie Duker 82 ✓
780 Create an edible sculpture 634 Sophie Duker 82
782 Build the tallest tower of toilet rolls 636 Sophie Duker 82 ✓
784 The loveliest thing to hold above your head 637 Sophie Duker 82
786 Poke your tongue out for the longest time 639 Sophie Duker 82
794 Poke a body part out of the shower curtain 645 Sophie Duker 82
797 Identify the liquids 648 Sophie Duker 82
801 Record a multi-track song about your team 650 Sophie Duker 82 ✓

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE task_winners (
   id     INTEGER PRIMARY KEY,
   task   INTEGER REFERENCES tasks(id),
   winner INTEGER REFERENCES people(id),
   team   INTEGER,
   live   INTEGER
);