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