task_winners

18 rows where winner = 65

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
600 Catch the rat 492 Lee Mack 65
601 Deliver all the plates to Alex 493 Lee Mack 65
605 Have an argument 497 Lee Mack 65 ✓
608 Correctly guess your standing in the group 499 Lee Mack 65 ✓
609 The most shocking cat- to pig-sized thing 500 Lee Mack 65
612 Get your luggage through security 503 Lee Mack 65
613 Act out nursery rhymes 504 Lee Mack 65 ✓ ✓
624 Make the best uniform for this bee 512 Lee Mack 65
631 Vandalise a wall creatively 518 Lee Mack 65 ✓
634 Tie the string to the glasses and put them on 520 Lee Mack 65 ✓
636 The best thing to hang on a wall that you wouldn’t normally hang on a wall 522 Lee Mack 65
639 Get out of the front gate 525 Lee Mack 65 ✓
641 Make your rubber gloves and wellies as heavy as possible 526 Lee Mack 65 ✓
644 The most satisfying wobbly thing 527 Lee Mack 65
648 Draw the best picture of a British animal 529 Lee Mack 65 ✓
651 One leg or two? 531 Lee Mack 65 ✓
659 Scientifically work out how much Alex’s feet and head weigh 539 Lee Mack 65
660 Direct a teammate into the red circle 540 Lee Mack 65 ✓

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