task_winners

15 rows where winner = 24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
170 Give Alex a special cuddle 147 Bob Mortimer 24
172 Score a basket without your hands 149 Bob Mortimer 24
175 Make a coconut-flinging machine 152 Bob Mortimer 24
184 The proudest item 157 Bob Mortimer 24
185 Retrieve the table tennis ball from the tube 158 Bob Mortimer 24
190 Make marmite 163 Bob Mortimer 24
192 Do something remarkable synchronised 164 Bob Mortimer 24 ✓
196 Sneeze the fastest 167 Bob Mortimer 24
202 Build a can tower & greet Alex from different countries 174 Bob Mortimer 24
205 The best home-made item 176 Bob Mortimer 24
208 Light a candle using a cupcake 180 Bob Mortimer 24
212 Travel blindfolded for three minutes and retrace your steps 184 Bob Mortimer 24
215 Make a funny flick book 187 Bob Mortimer 24
217 Zipwire items to the Taskmaster 188 Bob Mortimer 24 ✓
223 Throw an egg through a basketball hoop 194 Bob Mortimer 24 ✓

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
);