TdlM / taskmaster

Menu
  • Make shortlink

tasks_by_objective

16 rows where objective = 35

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task objective
56 Keep the basketball on the treadmill 100 time ▲ 35
69 Make the longest continuous noise 123 time ▲ 35
77 Hide from Alex 135 time ▲ 35
116 Make something spin for the longest 220 time ▲ 35
155 Don’t blink 302 time ▲ 35
162 Tie yourself up as securely as possible 321 time ▲ 35
189 Hide three aubergines from Alex 380 time ▲ 35
208 Use a spread to delay a pop-up toy 430 time ▲ 35
227 Make the best and longest-lasting marble run 466 time ▲ 35
244 Have an argument 497 time ▲ 35
279 Complete the course as slowly as possible 558 time ▲ 35
284 Prevent Alex from scoring a goal 565 time ▲ 35
299 Have the longest telephone conversation 584 time ▲ 35
326 Poke your tongue out for the longest time 639 time ▲ 35
378 Pour your sand into the other bottle 735 time ▲ 35
411 Avoid the rubbish robots 795 time ▲ 35

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