TdlM / taskmaster

Menu
  • Make shortlink

tasks_by_objective

8 rows where objective = 36

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task objective
58 Put an egg in an egg cup without touching either 103 penalties ▼ 36
67 Don the diving gear while maintaining eye contact and small talk 120 penalties ▼ 36
75 Cross the bunting to give Alex his lunch 134 penalties ▼ 36
240 Deliver all the plates to Alex 493 penalties ▼ 36
278 Complete the course as slowly as possible 558 penalties ▼ 36
306 Navigate the course with the pole 596 penalties ▼ 36
396 Get the duck into the lake 770 penalties ▼ 36
402 Get underneath the most unique things 780 penalties ▼ 36

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE tasks_by_objective (
   id        INTEGER PRIMARY KEY,
   task      INTEGER REFERENCES tasks(id),
   objective INTEGER REFERENCES objectives(id)
);
Powered by Datasette · Queries took 4.567ms