task_winners

8 rows where winner = 16

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
78 Reach the microwave in the fewest steps 67 Rob Beckett 16
83 Surprise Alex 72 Rob Beckett 16
84 Release Alex 73 Rob Beckett 16 ✓
87 Burst all of the balloons 75 Rob Beckett 16
89 The best battery-operated item 77 Rob Beckett 16
101 Cover yourself in sticky notes 87 Rob Beckett 16 ✓
107 Create an impressive time-lapse or slow motion film 92 Rob Beckett 16
109 The lowest unique number of doughnuts 93 Rob Beckett 16 ✓

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