TdlM / taskmaster

Menu
  • Make shortlink

team_tasks

8 rows where team = 34

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: win

id ▲ task team win
164 Build a bridge over the red green for this potato 723 Jenny, Kiell and Mae 34
166 Perform a slow-motion fight scene 729 Jenny, Kiell and Mae 34
168 Salvage the most spoons 739 Jenny, Kiell and Mae 34 ✓
170 Stuff your team-mate's waders 740 Jenny, Kiell and Mae 34 ✓
172 Free yourselves and have a team hug 748 Jenny, Kiell and Mae 34 ✓
174 Use the scratching post to remove balls from your suit 755 Jenny, Kiell and Mae 34 ✓
176 Make these things the same colour 757 Jenny, Kiell and Mae 34 ✓
178 Perform a lullaby for a profession 764 Jenny, Kiell and Mae 34 ✓

Advanced export

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

CSV options:

CREATE TABLE team_tasks (
   id   INTEGER PRIMARY KEY,
   task INTEGER REFERENCES tasks(id),
   team INTEGER REFERENCES teams(id),
   win  INTEGER
);
Powered by Datasette · Queries took 5.559ms