task_winners

11 rows where winner = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
1 The most unusual item 1 Tim Key 7
5 Pop up a tent and pop on a onesie 5 Tim Key 7 ✓
7 The most impressive item 7 Tim Key 7
9 Identify the contents of the pies 9 Tim Key 7
14 Throw a teabag into a mug 13 Tim Key 7
20 The most beautiful item 19 Tim Key 7
30 Memorise an Australian Rules Football team 26 Tim Key 7 ✓
35 Make a bed while holding hands 30 Tim Key 7 ✓
38 The most satisfying item 33 Tim Key 7
41 Stage a realistic home movie blooper 35 Tim Key 7 ✓
43 Separate the blue sweets 37 Tim Key 7 ✓

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