TdlM / taskmaster

Menu
  • Make shortlink

task_winners

12 rows where winner = 68

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
666 Pop the balloon 545 Alan Davies 68
677 Make a sand bridge across the river 554 Alan Davies 68
682 The best thing that has quite a few layers 557 Alan Davies 68
685 Solve the riddle 560 Alan Davies 68 ✓
693 Land the iron on the ironing board 568 Alan Davies 68
699 Put up a shelf for the Taskmaster's snooker balls 573 Alan Davies 68
703 Direct drawings using limited keywords 576 Alan Davies 68 ✓
707 Play and commentate on a socially-distanced sport 579 Alan Davies 68 ✓
712 Make your face look like another face when it's upside-down 580 Alan Davies 68
715 Blow a feather across a table with your nose 582 Alan Davies 68
716 The best 40 identical things on a towel 583 Alan Davies 68
725 Describe the Taskmaster / Chocolate button / Guess the tasks 590 Alan Davies 68 ✓

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