TdlM / taskmaster

Menu
  • Make shortlink

task_winners

14 rows where winner = 44

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
390 Sneak up on Alex 326 Joe Thomas 44
395 Transfer the rice to the bottle 331 Joe Thomas 44
396 Convey an object using only facial expressions, noises, adjectives & verbs 332 Joe Thomas 44 ✓
398 Travel the furthest while making a continuous noise 333 Joe Thomas 44
401 Build the best volcano 336 Joe Thomas 44
410 Get the most weight into a hammock 343 Joe Thomas 44 ✓
421 Recreate the scene you parade past 351 Joe Thomas 44 ✓
422 The best see-through item 352 Joe Thomas 44
424 Design an iconic album cover 354 Joe Thomas 44 ✓
430 Find the apples 359 Joe Thomas 44
431 Work out the crisp flavours 360 Joe Thomas 44
432 Do something powerful with your little finger 361 Joe Thomas 44
433 Answer the questions, pull the strings; do not release the green egg 362 Joe Thomas 44 ✓ ✓
448 Complete some tasks as one person 372 Joe Thomas 44 ✓

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