TdlM / taskmaster

Menu
  • Make shortlink

task_winners

9 rows where winner = 72

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
672 Work out the contents of the bags 549 Victoria Coren Mitchell 72
676 Copy Alex 553 Victoria Coren Mitchell 72
686 Solve the riddle 560 Victoria Coren Mitchell 72 ✓
689 Sit on a cake 563 Victoria Coren Mitchell 72
698 The most ridiculous thin thing 572 Victoria Coren Mitchell 72
704 Direct drawings using limited keywords 576 Victoria Coren Mitchell 72 ✓
711 Play and commentate on a socially-distanced sport 579 Victoria Coren Mitchell 72 ✓
713 Make your face look like another face when it's upside-down 580 Victoria Coren Mitchell 72
726 Describe the Taskmaster / Chocolate button / Guess the tasks 590 Victoria Coren Mitchell 72 ✓

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