task_winners

15 rows where winner = 80

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
737 Find all ten ducks in the lab 599 Chris Ramsey 80
738 Create a lipstick portrait of the Taskmaster 600 Chris Ramsey 80
740 Count to 13 602 Chris Ramsey 80 ✓
745 Score an exercise ball hat-trick using a buggy 606 Chris Ramsey 80 ✓
749 Make all the things happen at the same time 610 Chris Ramsey 80
755 Guess Shoe 614 Chris Ramsey 80
757 Give Alex the best stag minute 615 Chris Ramsey 80 ✓
767 Use a cement mixer 626 Chris Ramsey 80
773 Show off 632 Chris Ramsey 80
779 Create an edible sculpture 634 Chris Ramsey 80
789 Write down things that fit the category 641 Chris Ramsey 80 ✓ ✓
791 Get the most surprising thing delivered 643 Chris Ramsey 80
793 Poke a body part out of the shower curtain 645 Chris Ramsey 80
798 Get the most ducks in Alex's basket 649 Chris Ramsey 80
803 Draw a life-size self portrait with your nose in the canvas 651 Chris Ramsey 80 ✓

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