task_winners

19 rows where winner = 49

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
456 Hide three aubergines from Alex 380 Ed Gamble 49
457 Arrange the lollies in rainbow order 381 Ed Gamble 49
462 Identify which bin Alex is in 385 Ed Gamble 49
464 Say the word ‘demeaning’ 387 Ed Gamble 49 ✓
473 Fill a glass with water 394 Ed Gamble 49 ✓
474 The best thing to celebrate with on stage 395 Ed Gamble 49
475 Make the most striking water feature 396 Ed Gamble 49
477 Bring a classic board game to life 397 Ed Gamble 49 ✓
486 Get to know a person who alternately tells the truth, lies, and brags 403 Ed Gamble 49 ✓
489 Build a tower behind you using a mirror and litter pickers 404 Ed Gamble 49 ✓
491 The thing you’d be most pleased to find in a field 405 Ed Gamble 49
493 Push a watermelon up a slide using breadsticks 407 Ed Gamble 49
494 Serenade yourself 408 Ed Gamble 49
502 Find and put the gold rings on the stick 413 Ed Gamble 49
506 Throw something into a pedal bin 416 Ed Gamble 49
508 Supply a soundtrack for a film 418 Ed Gamble 49 ✓
514 Inflate, tie, and pop the most balloons 422 Ed Gamble 49
523 Complete the seven tasks in any order 428 Ed Gamble 49
525 Use a spread to delay a pop-up toy 430 Ed Gamble 49

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