TdlM / taskmaster

Menu
  • Make shortlink

task_winners

16 rows where winner = 40

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
314 Make the best quick-change outfit 266 Kerry Godliman 40
316 Work out the perimeter of the caravan in beans 268 Kerry Godliman 40
324 Draw the biggest and best circle 274 Kerry Godliman 40
325 Build a tower of cans within a hoop 275 Kerry Godliman 40 ✓
326 Guess the number on Alex’s forearm 276 Kerry Godliman 40 ✓
327 The best thing from the 90s 277 Kerry Godliman 40
342 Make the most white circles on the target 290 Kerry Godliman 40
350 Place objects on the hanger without it falling 293 Kerry Godliman 40 ✓ ✓
351 The best key 294 Kerry Godliman 40
364 Build an extension to the Taskmaster house 303 Kerry Godliman 40 ✓
367 The creepiest thing 306 Kerry Godliman 40
374 Put the largest numeric value of money in the floating bowl 312 Kerry Godliman 40
376 Find the satsuma in a sock 314 Kerry Godliman 40
379 Complete a 24-shot rally 315 Kerry Godliman 40 ✓
381 The most magnificent stationery 317 Kerry Godliman 40
386 Sausage or finger? 322 Kerry Godliman 40 ✓

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