TdlM / taskmaster

Menu
  • Make shortlink

task_winners

11 rows where winner = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
532 Make a portrait of the Taskmaster and his toy using balloons, pegs, and clothing 438 Johnny Vegas 54
537 The best thing that probably has a spring 442 Johnny Vegas 54
538 Make the best upside-down film 443 Johnny Vegas 54
546 Persuade the security guard to look in your bag 449 Johnny Vegas 54 ✓
548 Drop a water balloon as far as possible without it bursting 450 Johnny Vegas 54
550 Roll an edible sphere across a line as slowly as possible 451 Johnny Vegas 54 ✓
562 Draw the animal watching you from the mirror 460 Johnny Vegas 54
564 Draw animals using straight lines 462 Johnny Vegas 54 ✓ ✓
569 Communicate the safe contents via reversed audio 465 Johnny Vegas 54 ✓
574 Work out how many sheets are on a toilet roll 468 Johnny Vegas 54
578 Do not blink while staring at your opponent with a selected expression 473 Johnny Vegas 54 ✓ ✓

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