TdlM / taskmaster

Menu
  • Make shortlink

task_winners

17 rows where winner = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
319 Write a ten word story while running 271 James Acaster 38
320 Paint a blindfolded still life 272 James Acaster 38 ✓
333 Work out what the switch does 283 James Acaster 38
335 Make the scales read exactly 31.770kg 285 James Acaster 38
336 Get dressed while wearing handcuffs 286 James Acaster 38 ✓
339 Spectacularly deliver the task to Alex 289 James Acaster 38
340 Make the most white circles on the target 290 James Acaster 38
344 Cheer up the traffic warden 291 James Acaster 38
346 Make yourselves appear as large or small as possible 292 James Acaster 38 ✓
352 Put 50 different things in the bin 295 James Acaster 38
353 Make a portrait of the Taskmaster using your 50 items 296 James Acaster 38
354 Make a soap opera cliffhanger 297 James Acaster 38 ✓
359 The most exciting thing beginning with 'G' 300 James Acaster 38
370 Follow the clues and then do what they spell 308 James Acaster 38
380 Draw a happy horse upside-down 316 James Acaster 38 ✓
383 Find the hard-boiled egg 319 James Acaster 38
384 Recreate a classic video game 320 James Acaster 38

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