task_winners

17 rows where winner = 69

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
663 The nicest thing to sit on 542 Desiree Burch 69
669 Scale the mountain 548 Desiree Burch 69 ✓
675 The most old-fashioned thing that you still use 552 Desiree Burch 69
678 Film a thrilling sequence with a welly-cam 555 Desiree Burch 69
679 Convey objects using shadows 556 Desiree Burch 69 ✓ ✓
683 Complete the course as slowly as possible 558 Desiree Burch 69
692 The most desirable thing for another contestant 567 Desiree Burch 69
695 Sit on the red chair in the secret tower 570 Desiree Burch 69
696 Make paper aeroplanes 571 Desiree Burch 69 ✓
700 Write and perform a 30-second jingle 574 Desiree Burch 69
702 Pass everything through the pipe and the pipe through everything 575 Desiree Burch 69
705 The best thing you have repurposed 577 Desiree Burch 69
708 Play and commentate on a socially-distanced sport 579 Desiree Burch 69 ✓
717 Have the longest telephone conversation 584 Desiree Burch 69
720 Duck-slide 587 Desiree Burch 69 ✓ ✓
723 The most magnificent floppy thing 588 Desiree Burch 69
724 Drink with your mouth open 589 Desiree Burch 69

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
);