task_winners

10 rows where winner = 19

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
111 Beautifully destroy a cake 95 Joe Lycett 19
126 Persuade three animals to stand on the mat 108 Joe Lycett 19
127 Transfer water from one fishbowl to another 109 Joe Lycett 19
128 Musical words 110 Joe Lycett 19 ✓
129 Decant wine from one bottle to another 111 Joe Lycett 19
145 Make the longest continuous noise 123 Joe Lycett 19 ✓
150 Identify the contents of the sleeping bag 131 Joe Lycett 19
157 Wheelie bin obstacle course 136 Joe Lycett 19 ✓
160 Invent a new handshake 137 Joe Lycett 19
162 Open the jar of mayonnaise 139 Joe Lycett 19

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