TdlM / taskmaster

Menu
  • Make shortlink

task_winners

13 rows where winner = 21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
114 Make the most fruit juice 98 Mel Giedroyc 21 ✓
119 Get the flour onto the target 102 Mel Giedroyc 21 ✓
121 Make the longest balloon chain 104 Mel Giedroyc 21 ✓
125 Make a Taskmaster movie trailer 107 Mel Giedroyc 21 ✓
132 Ringtone choreography 114 Mel Giedroyc 21
136 Do something incredible with a pommel horse 116 Mel Giedroyc 21
138 Make the tallest tube tower 117 Mel Giedroyc 21 ✓
140 Slide as far as possible 119 Mel Giedroyc 21
143 Do incompatible things with the bathtub 121 Mel Giedroyc 21 ✓
144 Throw something into something 122 Mel Giedroyc 21
148 Pass a camel through a small gap 126 Mel Giedroyc 21
167 Do something surprising with a duck 144 Mel Giedroyc 21
168 Draw the median duck 145 Mel Giedroyc 21 ✓

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