task_winners

9 rows where winner = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
45 Place the exercise balls on the yoga mat 39 Richard Osman 12
48 Pack a suitcase 42 Richard Osman 12 ✓
50 Quickly eat an egg 44 Richard Osman 12
53 A photo of an object that looks like you 46 Richard Osman 12
59 Buy a gift for the Taskmaster 52 Richard Osman 12
61 See no potato, hear no potato, speak no potato 53 Richard Osman 12 ✓
71 The best piece of memorabilia 61 Richard Osman 12
74 Create a stop-motion film starring a potato 63 Richard Osman 12 ✓
76 Put on gloves, eat a banana, put on a tie, and clap 65 Richard Osman 12 ✓

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