TdlM / taskmaster

Menu
  • Make shortlink

tasks_by_objective

8 rows where objective = 10

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task objective
15 Grow the longest nail 29 centimeters ▲ 10
37 Build a bridge for the potato 64 centimeters ▲ 10
51 Move water from one bucket to another 90 centimeters ▲ 10
138 Build the tallest cardboard box tower 267 centimeters ▲ 10
215 Select a wind-up dinosaur 441 centimeters ▲ 10
222 Bag the heaviest thing from the greatest distance 453 centimeters ▲ 10
307 Navigate the course with the pole 596 centimeters ▲ 10
418 Pop your party popper the furthest 804 centimeters ▲ 10

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