TdlM / taskmaster

Menu
  • Make shortlink

team_tasks

8 rows where team = 33

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: win

id ▲ task team win
163 Build a bridge over the red green for this potato 723 Frankie and Ivo 33 ✓
165 Perform a slow-motion fight scene 729 Frankie and Ivo 33 ✓
167 Salvage the most spoons 739 Frankie and Ivo 33
169 Stuff your team-mate's waders 740 Frankie and Ivo 33
171 Free yourselves and have a team hug 748 Frankie and Ivo 33
173 Use the scratching post to remove balls from your suit 755 Frankie and Ivo 33
175 Make these things the same colour 757 Frankie and Ivo 33 ✓
177 Perform a lullaby for a profession 764 Frankie and Ivo 33

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.473ms