task_winners

15 rows where winner = 71

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
664 Strike Alex with a ball 543 Morgana Robinson 71
667 Strike poses to represent a hobby, an animal, and a celebrity 546 Morgana Robinson 71 ✓
671 Scale the mountain 548 Morgana Robinson 71 ✓
673 Paint the space hopper green 550 Morgana Robinson 71
681 Convey objects using shadows 556 Morgana Robinson 71 ✓ ✓
687 Get the most forks in your bucket 561 Morgana Robinson 71 ✓
690 Prevent Alex from scoring a goal 565 Morgana Robinson 71
701 Write and perform a 30-second jingle 574 Morgana Robinson 71
710 Play and commentate on a socially-distanced sport 579 Morgana Robinson 71 ✓
714 Pop up before the objects 581 Morgana Robinson 71 ✓
718 Find the soldier with hindsight 585 Morgana Robinson 71
719 Get goosebumps 586 Morgana Robinson 71
722 Duck-slide 587 Morgana Robinson 71 ✓ ✓
728 Propose to Alex 591 Morgana Robinson 71
730 Make noises without being identified by the Taskmaster 592 Morgana Robinson 71 ✓

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