Skip to content
AWS for Query.Farm

aws.mturk.list_review_policy_results_for_hit

Example SQL Queries

SELECT * FROM
aws.mturk.list_review_policy_results_for_hit
WHERE
"hit_id" = 'VALUE';

Description

The ListReviewPolicyResultsForHIT operation retrieves the computed results and the actions taken in the course of executing your Review Policies for a given HIT. For information about how to specify Review Policies when you call CreateHIT, see Review Policies. The ListReviewPolicyResultsForHIT operation can return results for both Assignment-level and HIT-level review results.

Table Definition

Column NameColumn Data Type
hit_id Required Input Column

The HITId of the HIT for which results have been returned.

VARCHAR
max_results Input Column

Limit the number of results returned.

BIGINT
next_token Input Column

If the previous response was incomplete (because there is more data to retrieve), Amazon Mechanical Turk returns a pagination token in the response. You can use this pagination token to retrieve the next set of results. 

VARCHAR
policy_levels Input Column

The Policy Level(s) to retrieve review results for - HIT or Assignment. If omitted, the default behavior is to retrieve all data for both policy levels. For a list of all the described policies, see Review Policies. 

VARCHAR[]
Show child fields
policy_levels[]
retrieve_actions Input Column

Specify if the operation should retrieve a list of the actions taken executing the Review Policies and their outcomes. 

BOOLEAN
retrieve_results Input Column

Specify if the operation should retrieve a list of the results computed by the Review Policies. 

BOOLEAN
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

assignment_review_policy

The name of the Assignment-level Review Policy. This contains only the PolicyName element. 

STRUCT(
    "policy_name" VARCHAR,
    "parameters" STRUCT(
        "key" VARCHAR,
        "values" VARCHAR[],
        "map_entries" STRUCT(
            "key" VARCHAR,
            "values" VARCHAR[]
        )[]
    )[]
)
Show child fields
assignment_review_policy.parameters[]
Show child fields
assignment_review_policy.parameters[].key

Name of the parameter from the list of Review Polices.

assignment_review_policy.parameters[].map_entries[]
Show child fields
assignment_review_policy.parameters[].map_entries[].key

The QuestionID from the HIT that is used to identify which question requires Mechanical Turk to score as part of the ScoreMyKnownAnswers/2011-09-01 Review Policy.

assignment_review_policy.parameters[].map_entries[].values[]
assignment_review_policy.parameters[].values[]
assignment_review_policy.policy_name

Name of a Review Policy: SimplePlurality/2011-09-01 or ScoreMyKnownAnswers/2011-09-01

assignment_review_report

Contains both ReviewResult and ReviewAction elements for an Assignment. 

STRUCT(
    "review_results" STRUCT(
        "action_id" VARCHAR,
        "subject_id" VARCHAR,
        "subject_type" VARCHAR,
        "question_id" VARCHAR,
        "key" VARCHAR,
        "value" VARCHAR
    )[],
    "review_actions" STRUCT(
        "action_id" VARCHAR,
        "action_name" VARCHAR,
        "target_id" VARCHAR,
        "target_type" VARCHAR,
        "status" VARCHAR,
        "complete_time" TIMESTAMP_S,
        "result" VARCHAR,
        "error_code" VARCHAR
    )[]
)
Show child fields
assignment_review_report.review_actions[]
Show child fields
assignment_review_report.review_actions[].action_id

The unique identifier for the action.

assignment_review_report.review_actions[].action_name

The nature of the action itself. The Review Policy is responsible for examining the HIT and Assignments, emitting results, and deciding which other actions will be necessary.

assignment_review_report.review_actions[].complete_time

The date when the action was completed.

assignment_review_report.review_actions[].error_code

Present only when the Results have a FAILED Status.

assignment_review_report.review_actions[].result

A description of the outcome of the review.

assignment_review_report.review_actions[].status

The current disposition of the action: INTENDED, SUCCEEDED, FAILED, or CANCELLED.

assignment_review_report.review_actions[].target_id

The specific HITId or AssignmentID targeted by the action.

assignment_review_report.review_actions[].target_type

The type of object in TargetId.

assignment_review_report.review_results[]
Show child fields
assignment_review_report.review_results[].action_id

A unique identifier of the Review action result.

assignment_review_report.review_results[].key

Key identifies the particular piece of reviewed information.

assignment_review_report.review_results[].question_id

Specifies the QuestionId the result is describing. Depending on whether the TargetType is a HIT or Assignment this results could specify multiple values. If TargetType is HIT and QuestionId is absent, then the result describes results of the HIT, including the HIT agreement score. If ObjectType is Assignment and QuestionId is absent, then the result describes the Worker's performance on the HIT.

assignment_review_report.review_results[].subject_id

The HITID or AssignmentId about which this result was taken. Note that HIT-level Review Policies will often emit results about both the HIT itself and its Assignments, while Assignment-level review policies generally only emit results about the Assignment itself.

assignment_review_report.review_results[].subject_type

The type of the object from the SubjectId field.

assignment_review_report.review_results[].value

The values of Key provided by the review policies you have selected.

hit_review_policy

The name of the HIT-level Review Policy. This contains only the PolicyName element.

STRUCT(
    "policy_name" VARCHAR,
    "parameters" STRUCT(
        "key" VARCHAR,
        "values" VARCHAR[],
        "map_entries" STRUCT(
            "key" VARCHAR,
            "values" VARCHAR[]
        )[]
    )[]
)
Show child fields
hit_review_policy.parameters[]
Show child fields
hit_review_policy.parameters[].key

Name of the parameter from the list of Review Polices.

hit_review_policy.parameters[].map_entries[]
Show child fields
hit_review_policy.parameters[].map_entries[].key

The QuestionID from the HIT that is used to identify which question requires Mechanical Turk to score as part of the ScoreMyKnownAnswers/2011-09-01 Review Policy.

hit_review_policy.parameters[].map_entries[].values[]
hit_review_policy.parameters[].values[]
hit_review_policy.policy_name

Name of a Review Policy: SimplePlurality/2011-09-01 or ScoreMyKnownAnswers/2011-09-01

hit_review_report

Contains both ReviewResult and ReviewAction elements for a particular HIT. 

STRUCT(
    "review_results" STRUCT(
        "action_id" VARCHAR,
        "subject_id" VARCHAR,
        "subject_type" VARCHAR,
        "question_id" VARCHAR,
        "key" VARCHAR,
        "value" VARCHAR
    )[],
    "review_actions" STRUCT(
        "action_id" VARCHAR,
        "action_name" VARCHAR,
        "target_id" VARCHAR,
        "target_type" VARCHAR,
        "status" VARCHAR,
        "complete_time" TIMESTAMP_S,
        "result" VARCHAR,
        "error_code" VARCHAR
    )[]
)
Show child fields
hit_review_report.review_actions[]
Show child fields
hit_review_report.review_actions[].action_id

The unique identifier for the action.

hit_review_report.review_actions[].action_name

The nature of the action itself. The Review Policy is responsible for examining the HIT and Assignments, emitting results, and deciding which other actions will be necessary.

hit_review_report.review_actions[].complete_time

The date when the action was completed.

hit_review_report.review_actions[].error_code

Present only when the Results have a FAILED Status.

hit_review_report.review_actions[].result

A description of the outcome of the review.

hit_review_report.review_actions[].status

The current disposition of the action: INTENDED, SUCCEEDED, FAILED, or CANCELLED.

hit_review_report.review_actions[].target_id

The specific HITId or AssignmentID targeted by the action.

hit_review_report.review_actions[].target_type

The type of object in TargetId.

hit_review_report.review_results[]
Show child fields
hit_review_report.review_results[].action_id

A unique identifier of the Review action result.

hit_review_report.review_results[].key

Key identifies the particular piece of reviewed information.

hit_review_report.review_results[].question_id

Specifies the QuestionId the result is describing. Depending on whether the TargetType is a HIT or Assignment this results could specify multiple values. If TargetType is HIT and QuestionId is absent, then the result describes results of the HIT, including the HIT agreement score. If ObjectType is Assignment and QuestionId is absent, then the result describes the Worker's performance on the HIT.

hit_review_report.review_results[].subject_id

The HITID or AssignmentId about which this result was taken. Note that HIT-level Review Policies will often emit results about both the HIT itself and its Assignments, while Assignment-level review policies generally only emit results about the Assignment itself.

hit_review_report.review_results[].subject_type

The type of the object from the SubjectId field.

hit_review_report.review_results[].value

The values of Key provided by the review policies you have selected.