task_winners

3 rows where task = 634

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task winner team live
778 Create an edible sculpture 634 Bridget Christie 79
779 Create an edible sculpture 634 Chris Ramsey 80
780 Create an edible sculpture 634 Sophie Duker 82

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