TdlM / taskmaster

Menu
  • Make shortlink

task_winners

15 rows where winner = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
110 The most interesting vegetable autograph 94 Noel Fielding 22
112 Draw a blind portrait 96 Noel Fielding 22
115 The most boastful item 99 Noel Fielding 22
117 Paint a portrait of the Taskmaster without touching the red mat 101 Noel Fielding 22
122 The best subscription 105 Noel Fielding 22
123 Camouflage yourself 106 Noel Fielding 22
131 Make the highest splash 113 Noel Fielding 22
133 Ringtone choreography 114 Noel Fielding 22
134 Make the best toilet paper celebrity portrait 115 Noel Fielding 22
152 Identify the contents of the sleeping bag 131 Noel Fielding 22
153 Prepare the items / Lift all the items in one hand 132 Noel Fielding 22 ✓
155 Cross the bunting to give Alex his lunch 134 Noel Fielding 22
159 Wheelie bin obstacle course 136 Noel Fielding 22 ✓
164 Create an exotic sandwich 141 Noel Fielding 22
166 Strike an item the farthest 143 Noel Fielding 22

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