Skip to content
AWS for Query.Farm

aws.rekognition.get_celebrity_recognition

Example SQL Queries

SELECT * FROM
aws.rekognition.get_celebrity_recognition
WHERE
"job_id" = 'VALUE';

Description

Gets the celebrity recognition results for a Amazon Rekognition Video analysis started by StartCelebrityRecognition.

Celebrity recognition in a video is an asynchronous operation. Analysis is started by a call to StartCelebrityRecognition which returns a job identifier (JobId).

When the celebrity recognition operation finishes, Amazon Rekognition Video publishes a completion status to the Amazon Simple Notification Service topic registered in the initial call to StartCelebrityRecognition. To get the results of the celebrity recognition analysis, first check that the status value published to the Amazon SNS topic is SUCCEEDED. If so, call GetCelebrityDetection and pass the job identifier (JobId) from the initial call to StartCelebrityDetection.

For more information, see Working With Stored Videos in the Amazon Rekognition Developer Guide.

GetCelebrityRecognition returns detected celebrities and the time(s) they are detected in an array (Celebrities) of CelebrityRecognition objects. Each CelebrityRecognition contains information about the celebrity in a CelebrityDetail object and the time, Timestamp, the celebrity was detected. This CelebrityDetail object stores information about the detected celebrity's face attributes, a face bounding box, known gender, the celebrity's name, and a confidence estimate.

GetCelebrityRecognition only returns the default facial attributes (BoundingBox, Confidence, Landmarks, Pose, and Quality). The BoundingBox field only applies to the detected face instance. The other facial attributes listed in the Face object of the following response syntax are not returned. For more information, see FaceDetail in the Amazon Rekognition Developer Guide.

By default, the Celebrities array is sorted by time (milliseconds from the start of the video). You can also sort the array by celebrity by specifying the value ID in the SortBy input parameter.

The CelebrityDetail object includes the celebrity identifer and additional information urls. If you don't store the additional information urls, you can get them later by calling GetCelebrityInfo with the celebrity identifer.

No information is returned for faces not recognized as celebrities.

Use MaxResults parameter to limit the number of labels returned. If there are more results than specified in MaxResults, the value of NextToken in the operation response contains a pagination token for getting the next set of results. To get the next page of results, call GetCelebrityDetection and populate the NextToken request parameter with the token value returned from the previous call to GetCelebrityRecognition.

Table Definition

Column NameColumn Data Type
job_id Required Input Column

Job identifier for the celebrity recognition operation for which you want to obtain results. The job identifer is returned by an initial call to StartCelebrityRecognition.

VARCHAR
max_results Input Column

Maximum number of results to return per paginated call. The largest value you can specify is 1000. If you specify a value greater than 1000, a maximum of 1000 results is returned. The default value is 1000.

BIGINT
next_token Input Column

If the response is truncated, Amazon Rekognition Video returns this token that you can use in the subsequent request to retrieve the next set of celebrities.

VARCHAR
sort_by Input Column

Sort to use for celebrities returned in Celebrities field. Specify ID to sort by the celebrity identifier, specify TIMESTAMP to sort by the time the celebrity was recognized.

VARCHAR
_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.

_aws_region Input Column

The AWS region to use.

VARCHAR
celebrities

Array of celebrities recognized in the video.

STRUCT(
    "timestamp" BIGINT,
    "celebrity" STRUCT(
        "urls" VARCHAR[],
        "name" VARCHAR,
        "id" VARCHAR,
        "confidence" DOUBLE,
        "bounding_box" STRUCT(
            "width" DOUBLE,
            "height" DOUBLE,
            "left" DOUBLE,
            "top" DOUBLE
        ),
        "face" STRUCT(
            "bounding_box" STRUCT(
                "width" DOUBLE,
                "height" DOUBLE,
                "left" DOUBLE,
                "top" DOUBLE
            ),
            "age_range" STRUCT(
                "low" BIGINT,
                "high" BIGINT
            ),
            "smile" STRUCT(
                "value" BOOLEAN,
                "confidence" DOUBLE
            ),
            "eyeglasses" STRUCT(
                "value" BOOLEAN,
                "confidence" DOUBLE
            ),
            "sunglasses" STRUCT(
                "value" BOOLEAN,
                "confidence" DOUBLE
            ),
            "gender" STRUCT(
                "value" VARCHAR,
                "confidence" DOUBLE
            ),
            "beard" STRUCT(
                "value" BOOLEAN,
                "confidence" DOUBLE
            ),
            "mustache" STRUCT(
                "value" BOOLEAN,
                "confidence" DOUBLE
            ),
            "eyes_open" STRUCT(
                "value" BOOLEAN,
                "confidence" DOUBLE
            ),
            "mouth_open" STRUCT(
                "value" BOOLEAN,
                "confidence" DOUBLE
            ),
            "emotions" STRUCT(
                "type" VARCHAR,
                "confidence" DOUBLE
            )[],
            "landmarks" STRUCT(
                "type" VARCHAR,
                "x" DOUBLE,
                "y" DOUBLE
            )[],
            "pose" STRUCT(
                "roll" DOUBLE,
                "yaw" DOUBLE,
                "pitch" DOUBLE
            ),
            "quality" STRUCT(
                "brightness" DOUBLE,
                "sharpness" DOUBLE
            ),
            "confidence" DOUBLE,
            "face_occluded" STRUCT(
                "value" BOOLEAN,
                "confidence" DOUBLE
            ),
            "eye_direction" STRUCT(
                "yaw" DOUBLE,
                "pitch" DOUBLE,
                "confidence" DOUBLE
            )
        ),
        "known_gender" STRUCT(
            "type" VARCHAR
        )
    )
)[]
Show child fields
celebrities[]
Show child fields
celebrities[].celebrity

Information about a recognized celebrity.

Show child fields
celebrities[].celebrity.bounding_box

Bounding box around the body of a celebrity.

Show child fields
celebrities[].celebrity.bounding_box.height

Height of the bounding box as a ratio of the overall image height.

celebrities[].celebrity.bounding_box.left

Left coordinate of the bounding box as a ratio of overall image width.

celebrities[].celebrity.bounding_box.top

Top coordinate of the bounding box as a ratio of overall image height.

celebrities[].celebrity.bounding_box.width

Width of the bounding box as a ratio of the overall image width.

celebrities[].celebrity.confidence

The confidence, in percentage, that Amazon Rekognition has that the recognized face is the celebrity.

celebrities[].celebrity.face

Face details for the recognized celebrity.

Show child fields
celebrities[].celebrity.face.age_range

The estimated age range, in years, for the face. Low represents the lowest estimated age and High represents the highest estimated age.

Show child fields
celebrities[].celebrity.face.age_range.high

The highest estimated age.

celebrities[].celebrity.face.age_range.low

The lowest estimated age.

celebrities[].celebrity.face.beard

Indicates whether or not the face has a beard, and the confidence level in the determination.

Show child fields
celebrities[].celebrity.face.beard.confidence

Level of confidence in the determination.

celebrities[].celebrity.face.beard.value

Boolean value that indicates whether the face has beard or not.

celebrities[].celebrity.face.bounding_box

Bounding box of the face. Default attribute.

Show child fields
celebrities[].celebrity.face.bounding_box.height

Height of the bounding box as a ratio of the overall image height.

celebrities[].celebrity.face.bounding_box.left

Left coordinate of the bounding box as a ratio of overall image width.

celebrities[].celebrity.face.bounding_box.top

Top coordinate of the bounding box as a ratio of overall image height.

celebrities[].celebrity.face.bounding_box.width

Width of the bounding box as a ratio of the overall image width.

celebrities[].celebrity.face.confidence

Confidence level that the bounding box contains a face (and not a different object such as a tree). Default attribute.

celebrities[].celebrity.face.emotions[]
Show child fields
celebrities[].celebrity.face.emotions[].confidence

Level of confidence in the determination.

celebrities[].celebrity.face.emotions[].type

Type of emotion detected.

celebrities[].celebrity.face.eye_direction

Indicates the direction the eyes are gazing in, as defined by pitch and yaw.

Show child fields
celebrities[].celebrity.face.eye_direction.confidence

The confidence that the service has in its predicted eye direction.

celebrities[].celebrity.face.eye_direction.pitch

Value representing eye direction on the pitch axis.

celebrities[].celebrity.face.eye_direction.yaw

Value representing eye direction on the yaw axis.

celebrities[].celebrity.face.eyeglasses

Indicates whether or not the face is wearing eye glasses, and the confidence level in the determination.

Show child fields
celebrities[].celebrity.face.eyeglasses.confidence

Level of confidence in the determination.

celebrities[].celebrity.face.eyeglasses.value

Boolean value that indicates whether the face is wearing eye glasses or not.

celebrities[].celebrity.face.eyes_open

Indicates whether or not the eyes on the face are open, and the confidence level in the determination.

Show child fields
celebrities[].celebrity.face.eyes_open.confidence

Level of confidence in the determination.

celebrities[].celebrity.face.eyes_open.value

Boolean value that indicates whether the eyes on the face are open.

celebrities[].celebrity.face.face_occluded

FaceOccluded should return "true" with a high confidence score if a detected face’s eyes, nose, and mouth are partially captured or if they are covered by masks, dark sunglasses, cell phones, hands, or other objects. FaceOccluded should return "false" with a high confidence score if common occurrences that do not impact face verification are detected, such as eye glasses, lightly tinted sunglasses, strands of hair, and others.

Show child fields
celebrities[].celebrity.face.face_occluded.confidence

The confidence that the service has detected the presence of a face occlusion.

celebrities[].celebrity.face.face_occluded.value

True if a detected face’s eyes, nose, and mouth are partially captured or if they are covered by masks, dark sunglasses, cell phones, hands, or other objects. False if common occurrences that do not impact face verification are detected, such as eye glasses, lightly tinted sunglasses, strands of hair, and others.

celebrities[].celebrity.face.gender

The predicted gender of a detected face.

Show child fields
celebrities[].celebrity.face.gender.confidence

Level of confidence in the prediction.

celebrities[].celebrity.face.gender.value

The predicted gender of the face.

celebrities[].celebrity.face.landmarks[]
Show child fields
celebrities[].celebrity.face.landmarks[].type

Type of landmark.

celebrities[].celebrity.face.landmarks[].x

The x-coordinate of the landmark expressed as a ratio of the width of the image. The x-coordinate is measured from the left-side of the image. For example, if the image is 700 pixels wide and the x-coordinate of the landmark is at 350 pixels, this value is 0.5.

celebrities[].celebrity.face.landmarks[].y

The y-coordinate of the landmark expressed as a ratio of the height of the image. The y-coordinate is measured from the top of the image. For example, if the image height is 200 pixels and the y-coordinate of the landmark is at 50 pixels, this value is 0.25.

celebrities[].celebrity.face.mouth_open

Indicates whether or not the mouth on the face is open, and the confidence level in the determination.

Show child fields
celebrities[].celebrity.face.mouth_open.confidence

Level of confidence in the determination.

celebrities[].celebrity.face.mouth_open.value

Boolean value that indicates whether the mouth on the face is open or not.

celebrities[].celebrity.face.mustache

Indicates whether or not the face has a mustache, and the confidence level in the determination.

Show child fields
celebrities[].celebrity.face.mustache.confidence

Level of confidence in the determination.

celebrities[].celebrity.face.mustache.value

Boolean value that indicates whether the face has mustache or not.

celebrities[].celebrity.face.pose

Indicates the pose of the face as determined by its pitch, roll, and yaw. Default attribute.

Show child fields
celebrities[].celebrity.face.pose.pitch

Value representing the face rotation on the pitch axis.

celebrities[].celebrity.face.pose.roll

Value representing the face rotation on the roll axis.

celebrities[].celebrity.face.pose.yaw

Value representing the face rotation on the yaw axis.

celebrities[].celebrity.face.quality

Identifies image brightness and sharpness. Default attribute.

Show child fields
celebrities[].celebrity.face.quality.brightness

Value representing brightness of the face. The service returns a value between 0 and 100 (inclusive). A higher value indicates a brighter face image.

celebrities[].celebrity.face.quality.sharpness

Value representing sharpness of the face. The service returns a value between 0 and 100 (inclusive). A higher value indicates a sharper face image.

celebrities[].celebrity.face.smile

Indicates whether or not the face is smiling, and the confidence level in the determination.

Show child fields
celebrities[].celebrity.face.smile.confidence

Level of confidence in the determination.

celebrities[].celebrity.face.smile.value

Boolean value that indicates whether the face is smiling or not.

celebrities[].celebrity.face.sunglasses

Indicates whether or not the face is wearing sunglasses, and the confidence level in the determination.

Show child fields
celebrities[].celebrity.face.sunglasses.confidence

Level of confidence in the determination.

celebrities[].celebrity.face.sunglasses.value

Boolean value that indicates whether the face is wearing sunglasses or not.

celebrities[].celebrity.id

The unique identifier for the celebrity.

celebrities[].celebrity.known_gender

Retrieves the known gender for the celebrity.

Show child fields
celebrities[].celebrity.known_gender.type

A string value of the KnownGender info about the Celebrity.

celebrities[].celebrity.name

The name of the celebrity.

celebrities[].celebrity.urls[]
celebrities[].timestamp

The time, in milliseconds from the start of the video, that the celebrity was recognized. Note that Timestamp is not guaranteed to be accurate to the individual frame where the celebrity first appears.

job_status

The current status of the celebrity recognition job.

VARCHAR
job_tag

A job identifier specified in the call to StartCelebrityRecognition and returned in the job completion notification sent to your Amazon Simple Notification Service topic.

VARCHAR
status_message

If the job fails, StatusMessage provides a descriptive error message.

VARCHAR
video

Video file stored in an Amazon S3 bucket. Amazon Rekognition video start operations such as StartLabelDetection use Video to specify a video for analysis. The supported file formats are .mp4, .mov and .avi.

STRUCT(
    "s3_object" STRUCT(
        "bucket" VARCHAR,
        "name" VARCHAR,
        "version" VARCHAR
    )
)
Show child fields
video.s3_object

The Amazon S3 bucket name and file name for the video.

Show child fields
video.s3_object.bucket

Name of the S3 bucket.

video.s3_object.name

S3 object key name.

video.s3_object.version

If the bucket is versioning enabled, you can specify the object version.

video_metadata

Information about a video that Amazon Rekognition Video analyzed. Videometadata is returned in every page of paginated responses from a Amazon Rekognition Video operation.

STRUCT(
    "codec" VARCHAR,
    "duration_millis" BIGINT,
    "format" VARCHAR,
    "frame_rate" DOUBLE,
    "frame_height" BIGINT,
    "frame_width" BIGINT,
    "color_range" VARCHAR
)
Show child fields
video_metadata.codec

Type of compression used in the analyzed video.

video_metadata.color_range

A description of the range of luminance values in a video, either LIMITED (16 to 235) or FULL (0 to 255).

video_metadata.duration_millis

Length of the video in milliseconds.

video_metadata.format

Format of the analyzed video. Possible values are MP4, MOV and AVI.

video_metadata.frame_height

Vertical pixel dimension of the video.

video_metadata.frame_rate

Number of frames per second in the video.

video_metadata.frame_width

Horizontal pixel dimension of the video.