TdlM / taskmaster

Menu
  • Make shortlink

task_winners

15 rows where winner = 70

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
665 Paint a flattering picture of the Taskmaster in action 544 Guz Khan 70
668 The most awesome square 547 Guz Khan 70
670 Scale the mountain 548 Guz Khan 70 ✓
674 Put on the medallion 551 Guz Khan 70 ✓
680 Convey objects using shadows 556 Guz Khan 70 ✓ ✓
684 Spread jam on toast in a really cool way 559 Guz Khan 70
688 The most elegant thing beginning with 'G' 562 Guz Khan 70
691 Pop the most balloons 566 Guz Khan 70 ✓
694 Make a cute toy for a cute dog 569 Guz Khan 70
697 Make paper aeroplanes 571 Guz Khan 70 ✓
706 Make a popcorn necklace and do the right thing 578 Guz Khan 70
709 Play and commentate on a socially-distanced sport 579 Guz Khan 70 ✓
721 Duck-slide 587 Guz Khan 70 ✓ ✓
727 Propose to Alex 591 Guz Khan 70
729 Make noises without being identified by the Taskmaster 592 Guz Khan 70 ✓

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