task_winners

10 rows where winner = 67

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
602 Stack your buckets so that they are taller than you 494 Sarah Kendall 67 ✓
607 Make the house haunted 498 Sarah Kendall 67
610 Make the sauna stones hiss 501 Sarah Kendall 67
611 Create a days in month mnemonic 502 Sarah Kendall 67
615 The craziest thing 505 Sarah Kendall 67
616 Get all of the banana in the bottle 506 Sarah Kendall 67
619 Put the bag of salt onto that table 507 Sarah Kendall 67 ✓
628 Slap and tong 514 Sarah Kendall 67 ✓ ✓
646 The most satisfying wobbly thing 527 Sarah Kendall 67
658 Make the best picture of a big, scary dinosaur 538 Sarah Kendall 67

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