task_winners

11 rows where winner = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
46 Get the potato into the hole 40 Jon Richardson 10
52 Create a nursery rhyme video 45 Jon Richardson 10
54 Order a pizza without using certain words 47 Jon Richardson 10
55 Put potatoes in a basket 48 Jon Richardson 10 ✓
58 Make an unexpected silhouette 51 Jon Richardson 10
60 See no potato, hear no potato, speak no potato 53 Jon Richardson 10 ✓
63 The coolest blue item 55 Jon Richardson 10
65 Conceal a pineapple on your person 57 Jon Richardson 10
66 Set a task / Guess who set the tasks 58 Jon Richardson 10
73 Create a stop-motion film starring a potato 63 Jon Richardson 10 ✓
75 Build a bridge for the potato 64 Jon Richardson 10

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