team_tasks

2 rows where task = 59

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task team win
9 Construct something for the Taskmaster 59 Jon and Richard 3
10 Construct something for the Taskmaster 59 Doc, Joe and Katherine 4 ✓

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