TdlM / taskmaster

Menu
  • Make shortlink

task_winners

17 rows where winner = 43

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
388 Find the baby monitor receiver 324 Iain Stirling 43
389 Make and be seduced by a ventriloquist dummy 325 Iain Stirling 43
392 Peel a banana with your feet 328 Iain Stirling 43
405 Get into two sleeping bags and complete other actions 339 Iain Stirling 43 ✓
407 Get the toilet paper through the toilet seat 341 Iain Stirling 43
414 The best face 346 Iain Stirling 43
417 Play long-distance catch with a beach ball 349 Iain Stirling 43 ✓
420 Herd the ping pong balls into a pen 350 Iain Stirling 43
423 Conceal yourself inside a phone box 353 Iain Stirling 43
436 Make a portrait of a former contestant using sand and one tool 364 Iain Stirling 43
437 Catch the tennis balls 365 Iain Stirling 43 ✓
440 Move the beach ball across the finish line using only water 366 Iain Stirling 43
444 Make a delicious dust meal 370 Iain Stirling 43
445 Make yourselves look like one person 371 Iain Stirling 43 ✓
451 The best thing that will change your life for the better 374 Iain Stirling 43
452 Erase the eraser 375 Iain Stirling 43
454 Blindly drive a mobility scooter around a course 377 Iain Stirling 43

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