Column descriptions

group_session

Group session ID

task

Task ID.

station

The iMac that the participant was stationed at.

participant

Participant ID. A participant ID of -1 indicates an unknown participant. All rows that do not have values for the `task` column will have their participant ID set to -1. In the future, we will label some of these inter/pre/post task rows with the correct participant ID.

timestamp_unix

The Unix timestamp of the event.

timestamp_iso8601

The ISO-8601 timestamp of the event.

confidence

Computed confidence between 0 (not confident) - 1 (confident).

norm_pos_x

X position in the eye image frame in normalized coordinates.

norm_pos_y

Y position in the eye image frame in normalized coordinates.

gaze_point_3d_x

X position of the 3d gaze point (the point the subject looks at) in the world camera coordinate system.

gaze_point_3d_y

Y position of the 3d gaze point (the point the subject looks at) in the world camera coordinate system.

gaze_point_3d_z

X position of the 3d gaze point (the point the subject looks at) in the world camera coordinate system.

eye_center0_3d_x

X center of eye-ball 0 in the world camera coordinate system.

eye_center0_3d_y

Y center of eye-ball 0 in the world camera coordinate system.

eye_center0_3d_z

Z center of eye-ball 0 in the world camera coordinate system.

eye_center1_3d_x

X center of eye-ball 1 in the world camera coordinate system.

eye_center1_3d_y

Y center of eye-ball 1 in the world camera coordinate system.

eye_center1_3d_z

Z center of eye-ball 1 in the world camera coordinate system.

gaze_normal0_x

X normal of the visual axis for eye 0 in the world camera coordinate system. The visual axis goes through the eye ball center and the object that is looked at.

gaze_normal0_y

Y normal of the visual axis for eye 0 in the world camera coordinate system. The visual axis goes through the eye ball center and the object that is looked at.

gaze_normal0_z

Z normal of the visual axis for eye 0 in the world camera coordinate system. The visual axis goes through the eye ball center and the object that is looked at.

gaze_normal1_x

X normal of the visual axis for eye 1 in the world camera coordinate system. The visual axis goes through the eye ball center and the object that is looked at.

gaze_normal1_y

Y normal of the visual axis for eye 1 in the world camera coordinate system. The visual axis goes through the eye ball center and the object that is looked at.

gaze_normal1_z

Z normal of the visual axis for eye 1 in the world camera coordinate system. The visual axis goes through the eye ball center and the object that is looked at.

diameter0_2d

Diameter of the eye-ball 0's pupil in image pixels as observed in the eye image frame (not corrected for perspective).

diameter1_2d

Diameter of the eye-ball 1's pupil in image pixels as observed in the eye image frame (not corrected for perspective).

diameter0_3d

Diameter of the eye-ball 0's pupil scaled to mm based on anthropomorphic avg eye ball diameter and corrected for perspective.

diameter1_3d

Diameter of the eye-ball 1's pupil scaled to mm based on anthropomorphic avg eye ball diameter and corrected for perspective.

where participant = "-2"

- remove filter - group_session station participant id task timestamp_unix timestamp_iso8601 confidence norm_pos_x norm_pos_y gaze_point_3d_x gaze_point_3d_y gaze_point_3d_z eye_center0_3d_x eye_center0_3d_y eye_center0_3d_z eye_center1_3d_x eye_center1_3d_y eye_center1_3d_z gaze_normal0_x gaze_normal0_y gaze_normal0_z gaze_normal1_x gaze_normal1_y gaze_normal1_z diameter0_2d diameter1_2d diameter0_3d diameter1_3d

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

- column - group_session station participant id task timestamp_unix timestamp_iso8601 confidence norm_pos_x norm_pos_y gaze_point_3d_x gaze_point_3d_y gaze_point_3d_z eye_center0_3d_x eye_center0_3d_y eye_center0_3d_z eye_center1_3d_x eye_center1_3d_y eye_center1_3d_z gaze_normal0_x gaze_normal0_y gaze_normal0_z gaze_normal1_x gaze_normal1_y gaze_normal1_z diameter0_2d diameter1_2d diameter0_3d diameter1_3d

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

Sort... Sort by group_session Sort by station Sort by participant Sort by id Sort by task Sort by timestamp_unix Sort by timestamp_iso8601 Sort by confidence Sort by norm_pos_x Sort by norm_pos_y Sort by gaze_point_3d_x Sort by gaze_point_3d_y Sort by gaze_point_3d_z Sort by eye_center0_3d_x Sort by eye_center0_3d_y Sort by eye_center0_3d_z Sort by eye_center1_3d_x Sort by eye_center1_3d_y Sort by eye_center1_3d_z Sort by gaze_normal0_x Sort by gaze_normal0_y Sort by gaze_normal0_z Sort by gaze_normal1_x Sort by gaze_normal1_y Sort by gaze_normal1_z Sort by diameter0_2d Sort by diameter1_2d Sort by diameter0_3d Sort by diameter1_3d

descending

✎ View and edit SQL

This data as json, copyable

0 records

CREATE TABLE "gaze_raw" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [station] TEXT REFERENCES [station]([id]),
   [participant] INTEGER REFERENCES [participant]([id]),
   [id] INTEGER,
   [task] TEXT REFERENCES [task]([id]),
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [confidence] FLOAT,
   [norm_pos_x] FLOAT,
   [norm_pos_y] FLOAT,
   [gaze_point_3d_x] FLOAT,
   [gaze_point_3d_y] FLOAT,
   [gaze_point_3d_z] FLOAT,
   [eye_center0_3d_x] FLOAT,
   [eye_center0_3d_y] FLOAT,
   [eye_center0_3d_z] FLOAT,
   [eye_center1_3d_x] FLOAT,
   [eye_center1_3d_y] FLOAT,
   [eye_center1_3d_z] FLOAT,
   [gaze_normal0_x] FLOAT,
   [gaze_normal0_y] FLOAT,
   [gaze_normal0_z] FLOAT,
   [gaze_normal1_x] FLOAT,
   [gaze_normal1_y] FLOAT,
   [gaze_normal1_z] FLOAT,
   [diameter0_2d] FLOAT,
   [diameter1_2d] FLOAT,
   [diameter0_3d] FLOAT,
   [diameter1_3d] FLOAT,
   PRIMARY KEY ([group_session], [station], [participant], [id])
);
CREATE INDEX [idx_gaze_raw_task]
    ON [gaze_raw] ([task]);
CREATE INDEX [idx_gaze_raw_participant]
    ON [gaze_raw] ([participant]);
CREATE INDEX [idx_gaze_raw_station]
    ON [gaze_raw] ([station]);
CREATE INDEX [idx_gaze_raw_group_session]
    ON [gaze_raw] ([group_session]);