TdlM / taskmaster

Menu
  • Make shortlink

task_winners

13 rows where winner = 64

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
604 Make the balloon hover 496 Jamali Maddix 64
618 Put the bag of salt onto that table 507 Jamali Maddix 64 ✓
620 Get the sheet of loo roll as far away as possible 508 Jamali Maddix 64
621 Identify the contents of the bowl 509 Jamali Maddix 64 ✓
622 The best thing you can operate with your hand 510 Jamali Maddix 64
623 Cover your legs in cling film and gaffer tape / Put on the captain’s hat 511 Jamali Maddix 64
627 Slap and tong 514 Jamali Maddix 64 ✓ ✓
629 The most annoying thing 515 Jamali Maddix 64
630 Make a portrait of the Taskmaster on a door using your feet 517 Jamali Maddix 64
633 Identify the battered items 519 Jamali Maddix 64
635 Fire rubber bands into Alex’s bum bag 521 Jamali Maddix 64
638 Make the best babushka meal 524 Jamali Maddix 64
643 The most satisfying wobbly thing 527 Jamali Maddix 64

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.962ms