team_tasks

7 rows where team = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: win

id ▲ task team win
119 Scale the mountain 548 Alan and Victoria 27
121 Convey objects using shadows 556 Alan and Victoria 27
123 Solve the riddle 560 Alan and Victoria 27 ✓
125 Get the most balls in the net 564 Alan and Victoria 27
127 Play and commentate on a socially-distanced sport 579 Alan and Victoria 27 ✓
129 Duck-slide 587 Alan and Victoria 27
131 Describe the Taskmaster / Chocolate button / Guess the tasks 590 Alan and Victoria 27 ✓

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE team_tasks (
   id   INTEGER PRIMARY KEY,
   task INTEGER REFERENCES tasks(id),
   team INTEGER REFERENCES teams(id),
   win  INTEGER
);