task_winners

20 rows where winner = 42

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
315 Build the tallest cardboard box tower 267 Rhod Gilbert 42
317 Make the most exotic fruit hat 269 Rhod Gilbert 42 ✓
318 The boldest belt 270 Rhod Gilbert 42
322 Paint a blindfolded still life 272 Rhod Gilbert 42 ✓
330 Get the ball into the hole by striking it 280 Rhod Gilbert 42
334 Change your appearance in a lift 284 Rhod Gilbert 42
337 Make the best toilet paper plane 287 Rhod Gilbert 42
343 Make the most white circles on the target 290 Rhod Gilbert 42
348 Make yourselves appear as large or small as possible 292 Rhod Gilbert 42 ✓
356 Make a soap opera cliffhanger 297 Rhod Gilbert 42 ✓
358 Get your inflatable ring as high as possible 299 Rhod Gilbert 42 ✓
360 The most exciting thing beginning with 'G' 300 Rhod Gilbert 42
361 Throw something into the bin behind the fence 301 Rhod Gilbert 42
362 Don’t blink 302 Rhod Gilbert 42
366 Beat on the drum after exactly 9.58 seconds 305 Rhod Gilbert 42 ✓
368 The creepiest thing 306 Rhod Gilbert 42
369 Poke something unexpected through the hole 307 Rhod Gilbert 42
372 Bob, pat, kneel, stew, or wane 310 Rhod Gilbert 42 ✓
377 Find the satsuma in a sock 314 Rhod Gilbert 42
385 Tie yourself up as securely as possible 321 Rhod Gilbert 42

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