task_winners
11 rows where winner = 50
This data as json, CSV (advanced)
id ▲ | task | winner | team | live |
---|---|---|---|---|
467 | Arrange the playdough balls / Do the correct things with the balls 388 | Jo Brand 50 | ✓ | |
472 | Break something and put it back together 393 | Jo Brand 50 | ||
478 | Bring a classic board game to life 397 | Jo Brand 50 | ✓ | |
484 | Lasso Alex 401 | Jo Brand 50 | ||
485 | Make an accurate and inventive egg timer 402 | Jo Brand 50 | ||
492 | Make a body part abnormally long 406 | Jo Brand 50 | ||
495 | Serenade yourself 408 | Jo Brand 50 | ||
504 | Horse or laminator? 414 | Jo Brand 50 | ✓ | |
505 | The best thing from a shed 415 | Jo Brand 50 | ||
516 | Communicate pictures by drawing on your team-mate’s back 424 | Jo Brand 50 | ✓ | ✓ |
522 | Make a cup of tea 427 | Jo Brand 50 | ✓ |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE task_winners ( id INTEGER PRIMARY KEY, task INTEGER REFERENCES tasks(id), winner INTEGER REFERENCES people(id), team INTEGER, live INTEGER );