TdlM / taskmaster

Menu
  • Make shortlink

task_winners

16 rows where winner = 52

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
458 Arrange the lollies in rainbow order 381 Rose Matafeo 52
459 Make the most dramatic entrance 382 Rose Matafeo 52
461 The best bag 384 Rose Matafeo 52
466 Say the word ‘demeaning’ 387 Rose Matafeo 52 ✓
471 Score a goal with a steamroller 392 Rose Matafeo 52
480 Bring a classic board game to life 397 Rose Matafeo 52 ✓
481 Fill a tray with things beginning with a letter you chose 398 Rose Matafeo 52
482 Throw objects, but not too far 399 Rose Matafeo 52 ✓
488 Get to know a person who alternately tells the truth, lies, and brags 403 Rose Matafeo 52 ✓
490 Build a tower behind you using a mirror and litter pickers 404 Rose Matafeo 52 ✓
496 Serenade yourself 408 Rose Matafeo 52
507 Write and perform lyrics for the Taskmaster theme tune 417 Rose Matafeo 52
510 Supply a soundtrack for a film 418 Rose Matafeo 52 ✓
518 Communicate pictures by drawing on your team-mate’s back 424 Rose Matafeo 52 ✓ ✓
520 Do the most preposterous thing with a chickpea 426 Rose Matafeo 52
524 Select the shortest breadstick 429 Rose Matafeo 52 ✓

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
);
Powered by Datasette · Queries took 6.131ms