TdlM / taskmaster

Menu
  • Make shortlink

task_winners

17 rows where winner = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
526 The nicest thing to put in your mouth 431 Daisy May Cooper 53
533 Get all the exercise balls in the hoops while in a boat 439 Daisy May Cooper 53
534 Guess what is making the noises 440 Daisy May Cooper 53 ✓
539 Put the most spaghetti in a grapefruit 444 Daisy May Cooper 53
540 Catapult a shoe into a bathtub 445 Daisy May Cooper 53
541 Draw an object on a rotating canvas 446 Daisy May Cooper 53 ✓ ✓
545 Persuade the security guard to look in your bag 449 Daisy May Cooper 53 ✓
547 Drop a water balloon as far as possible without it bursting 450 Daisy May Cooper 53
553 Paint a howling wolf on a rotating teapot 454 Daisy May Cooper 53
555 Do something out of character with £20 455 Daisy May Cooper 53
557 Feed your team-mate(s) the most watermelon 456 Daisy May Cooper 53 ✓
559 List words of a certain length without hesitating 457 Daisy May Cooper 53 ✓
573 Communicate things to the Taskmaster using only sounds 467 Daisy May Cooper 53 ✓
583 Complete the most tasks behind the five motorised doors 476 Daisy May Cooper 53
584 Work out how many balls are in the basket 477 Daisy May Cooper 53
587 Put the wellies on the spider’s feet 480 Daisy May Cooper 53
588 Complete the best performance of a specific song 481 Daisy May Cooper 53 ✓

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 9.802ms