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 = 99909

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link 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
exp_2023_02_06_13 leopard 99909 115789 rest_state 1675718226.4664938 2023-02-06T21:17:06.466494+00:00 1.0 0.557265 0.269746 14444.7 23126.6 140515.0 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102049 0.185807 0.977273 0.0998409 0.137016 0.985524 30.7746 35.0858 3.81102 4.32401
exp_2023_02_06_13 leopard 99909 115790 rest_state 1675718226.4705286 2023-02-06T21:17:06.470529+00:00 1.0 0.556983 0.269457 5636.28 9079.43 55076.6 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102049 0.185807 0.977273 0.098509 0.138325 0.985476 30.7746 35.0708 3.81102 4.3227
exp_2023_02_06_13 leopard 99909 115791 rest_state 1675718226.474563 2023-02-06T21:17:06.474563+00:00 1.0 0.556373 0.269515 12348.9 20082.4 121874.0 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.100537 0.184894 0.977602 0.098509 0.138325 0.985476 30.8481 35.0708 3.82033 4.3227
exp_2023_02_06_13 leopard 99909 115792 rest_state 1675718226.4785976 2023-02-06T21:17:06.478598+00:00 1.0 0.555694 0.270701 2106.68 3441.0 21027.5 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.100537 0.184894 0.977602 0.095381 0.137904 0.985842 30.8481 35.1686 3.82033 4.33644
exp_2023_02_06_13 leopard 99909 115793 rest_state 1675718226.4826322 2023-02-06T21:17:06.482632+00:00 1.0 0.556398 0.270765 1297.79 2094.91 12805.1 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102281 0.185717 0.977265 0.095381 0.137904 0.985842 30.7349 35.1686 3.80596 4.33644
exp_2023_02_06_13 leopard 99909 115794 rest_state 1675718226.486667 2023-02-06T21:17:06.486667+00:00 1.0 0.556444 0.270058 1335.04 2162.01 13161.4 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102281 0.185717 0.977265 0.0955677 0.139123 0.985653 30.7349 35.3181 3.80596 4.35523
exp_2023_02_06_13 leopard 99909 115795 rest_state 1675718226.4907017 2023-02-06T21:17:06.490702+00:00 1.0 0.556073 0.269774 1693.63 2763.67 16797.5 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.101365 0.185724 0.97736 0.0955677 0.139123 0.985653 30.8101 35.3181 3.81542 4.35523
exp_2023_02_06_13 leopard 99909 115796 rest_state 1675718226.4947362 2023-02-06T21:17:06.494736+00:00 1.0 0.555933 0.269741 1401.99 2293.41 13937.0 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.101365 0.185724 0.97736 0.0949105 0.139562 0.985654 30.8101 35.1723 3.81542 4.33745
exp_2023_02_06_13 leopard 99909 115797 rest_state 1675718226.498771 2023-02-06T21:17:06.498771+00:00 1.0 0.556047 0.270067 1307.52 2131.04 12974.2 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.10164 0.185301 0.977411 0.0949105 0.139562 0.985654 30.8058 35.1723 3.81485 4.33745
exp_2023_02_06_13 leopard 99909 115798 rest_state 1675718226.5028055 2023-02-06T21:17:06.502805+00:00 1.0 0.556392 0.269956 2137.19 3465.96 21087.0 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.10164 0.185301 0.977411 0.0965244 0.13884 0.9856 30.8058 35.2086 3.81485 4.34205
exp_2023_02_06_13 leopard 99909 115799 rest_state 1675718226.5068402 2023-02-06T21:17:06.506840+00:00 1.0 0.5567 0.269981 1675.36 2703.16 16447.7 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102404 0.185668 0.977262 0.0965244 0.13884 0.9856 30.7722 35.2086 3.81061 4.34205
exp_2023_02_06_13 leopard 99909 115800 rest_state 1675718226.5108747 2023-02-06T21:17:06.510875+00:00 1.0 0.557106 0.26883 3575.05 5767.85 34862.0 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102404 0.185668 0.977262 0.0983753 0.139931 0.985262 30.7722 35.2131 3.81061 4.3419
exp_2023_02_06_13 leopard 99909 115801 rest_state 1675718226.5149095 2023-02-06T21:17:06.514910+00:00 1.0 0.557092 0.268854 3646.79 5884.09 35569.7 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102369 0.185606 0.977277 0.0983753 0.139931 0.985262 30.723 35.2131 3.8045 4.3419
exp_2023_02_06_13 leopard 99909 115802 rest_state 1675718226.5189443 2023-02-06T21:17:06.518944+00:00 1.0 0.557647 0.267087 6764.23 10924.7 65374.1 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102369 0.185606 0.977277 0.100892 0.141787 0.984742 30.723 35.0463 3.8045 4.32014
exp_2023_02_06_13 leopard 99909 115803 rest_state 1675718226.5229785 2023-02-06T21:17:06.522979+00:00 1.0 0.557798 0.267032 11739.7 18921.2 113187.0 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102743 0.185904 0.977181 0.100892 0.141787 0.984742 30.6739 35.0463 3.79835 4.32014
exp_2023_02_06_13 leopard 99909 115804 rest_state 1675718226.5270133 2023-02-06T21:17:06.527013+00:00 1.0 0.558226 0.266554 2337.56 3752.07 22382.9 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102743 0.185904 0.977181 0.102867 0.141539 0.984574 30.6739 35.2571 3.79835 4.34639
exp_2023_02_06_13 leopard 99909 115805 rest_state 1675718226.5310483 2023-02-06T21:17:06.531048+00:00 0.993389 0.55815 0.266251 2155.69 3470.08 20665.5 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102559 0.186336 0.977119 0.102867 0.141539 0.984574 30.7805 35.2571 3.81165 4.34639
exp_2023_02_06_13 leopard 99909 115806 rest_state 1675718226.535083 2023-02-06T21:17:06.535083+00:00 0.993389 0.558574 0.265161 1275.63 2052.01 12145.0 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102559 0.186336 0.977119 0.104796 0.142456 0.984238 30.7805 35.2209 3.81165 4.3418
exp_2023_02_06_13 leopard 99909 115807 rest_state 1675718226.5391178 2023-02-06T21:17:06.539118+00:00 1.0 0.558635 0.265046 1316.9 2117.72 12525.6 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102712 0.186619 0.977048 0.104796 0.142456 0.984238 30.7058 35.2209 3.80229 4.3418
exp_2023_02_06_13 leopard 99909 115808 rest_state 1675718226.5431523 2023-02-06T21:17:06.543152+00:00 1.0 0.559211 0.264675 823.528 1315.2 7762.11 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102712 0.186619 0.977048 0.107455 0.141604 0.984074 30.7058 35.0444 3.80229 4.32046
exp_2023_02_06_13 leopard 99909 115809 rest_state 1675718226.547187 2023-02-06T21:17:06.547187+00:00 1.0 0.559221 0.264906 828.578 1321.38 7808.68 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102734 0.186228 0.977121 0.107455 0.141604 0.984074 30.6802 35.0444 3.79916 4.32046
exp_2023_02_06_13 leopard 99909 115810 rest_state 1675718226.5512216 2023-02-06T21:17:06.551222+00:00 1.0 0.559509 0.262869 722.117 1159.25 6772.94 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102734 0.186228 0.977121 0.108702 0.144682 0.983489 30.6802 35.1744 3.79916 4.33645
exp_2023_02_06_13 leopard 99909 115811 rest_state 1675718226.5552564 2023-02-06T21:17:06.555256+00:00 1.0 0.559563 0.262676 733.065 1177.08 6869.71 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.10287 0.186638 0.977028 0.108702 0.144682 0.983489 30.7522 35.1744 3.80811 4.33645
exp_2023_02_06_13 leopard 99909 115812 rest_state 1675718226.5592911 2023-02-06T21:17:06.559291+00:00 1.0 0.5599 0.260751 631.886 1019.86 5889.0 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.10287 0.186638 0.977028 0.110184 0.147408 0.982919 30.7522 35.1501 3.80811 4.33322
exp_2023_02_06_13 leopard 99909 115813 rest_state 1675718226.5633256 2023-02-06T21:17:06.563326+00:00 1.0 0.559943 0.260155 636.357 1029.67 5926.23 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102985 0.187741 0.976805 0.110184 0.147408 0.982919 30.6367 35.1501 3.79361 4.33322
exp_2023_02_06_13 leopard 99909 115814 rest_state 1675718226.5673604 2023-02-06T21:17:06.567360+00:00 1.0 0.559588 0.260032 775.848 1263.04 7264.9 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102985 0.187741 0.976805 0.108538 0.148599 0.982923 30.6367 34.9847 3.79361 4.3133
exp_2023_02_06_13 leopard 99909 115815 rest_state 1675718226.571395 2023-02-06T21:17:06.571395+00:00 1.0 0.559442 0.2601 740.165 1207.23 6946.65 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102622 0.187425 0.976904 0.108538 0.148599 0.982923 30.7275 34.9847 3.805 4.3133
exp_2023_02_06_13 leopard 99909 115816 rest_state 1675718226.5754297 2023-02-06T21:17:06.575430+00:00 1.0 0.559179 0.260111 875.72 1434.04 8252.61 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102622 0.187425 0.976904 0.107321 0.14929 0.982952 30.7275 34.9133 3.805 4.30519
exp_2023_02_06_13 leopard 99909 115817 rest_state 1675718226.5794642 2023-02-06T21:17:06.579464+00:00 1.0 0.559162 0.260091 869.691 1424.72 8198.07 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102578 0.187436 0.976906 0.107321 0.14929 0.982952 30.7247 34.9133 3.80464 4.30519
exp_2023_02_06_13 leopard 99909 115818 rest_state 1675718226.5834992 2023-02-06T21:17:06.583499+00:00 1.0 0.559085 0.25897 943.29 1556.35 8901.08 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102578 0.187436 0.976906 0.106915 0.151618 0.98264 30.7247 35.0563 3.80464 4.32355
exp_2023_02_06_13 leopard 99909 115819 rest_state 1675718226.587534 2023-02-06T21:17:06.587534+00:00 1.0 0.558773 0.258413 832.417 1384.16 7892.74 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.101814 0.187995 0.976879 0.106915 0.151618 0.98264 30.8193 35.0563 3.81643 4.32355
exp_2023_02_06_13 leopard 99909 115820 rest_state 1675718226.5915685 2023-02-06T21:17:06.591568+00:00 1.0 0.558801 0.258402 817.287 1358.49 7745.87 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.101814 0.187995 0.976879 0.107045 0.151563 0.982634 30.8193 35.1206 3.81643 4.3323
exp_2023_02_06_13 leopard 99909 115821 rest_state 1675718226.5956032 2023-02-06T21:17:06.595603+00:00 1.0 0.559076 0.258579 906.897 1499.61 8558.32 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102493 0.188055 0.976796 0.107045 0.151563 0.982634 30.7089 35.1206 3.80257 4.3323
exp_2023_02_06_13 leopard 99909 115822 rest_state 1675718226.599638 2023-02-06T21:17:06.599638+00:00 1.0 0.558742 0.259138 1180.06 1955.65 11195.6 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102493 0.188055 0.976796 0.105518 0.151411 0.982823 30.7089 35.0471 3.80257 4.3231
exp_2023_02_06_13 leopard 99909 115823 rest_state 1675718226.6036725 2023-02-06T21:17:06.603673+00:00 1.0 0.558681 0.258908 1140.92 1894.9 10834.3 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102345 0.188377 0.97675 0.105518 0.151411 0.982823 30.7599 35.0471 3.80891 4.3231
exp_2023_02_06_13 leopard 99909 115824 rest_state 1675718226.6077073 2023-02-06T21:17:06.607707+00:00 1.0 0.558685 0.259278 1124.71 1864.19 10680.2 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102345 0.188377 0.97675 0.105553 0.150701 0.982928 30.7599 35.078 3.80891 4.32827
exp_2023_02_06_13 leopard 99909 115825 rest_state 1675718226.6117418 2023-02-06T21:17:06.611742+00:00 1.0 0.558912 0.25941 1264.78 2087.52 11967.8 17.1908 9.90296 -27.9338 -39.1245 13.9694 -21.6891 0.102906 0.18845 0.976676 0.105553 0.150701 0.982928 30.7335 35.078 3.80556 4.32827
exp_2023_02_06_13 leopard 99909 115826 rest_state 1675718226.6157765 2023-02-06T21:17:06.615777+00:00 1.0 0.557967 0.260782 23378.3 38876.1 224590.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.102906 0.18845 0.976676 0.101197 0.150691 0.983388 30.7335 35.0466 3.80556 4.31288
exp_2023_02_06_13 leopard 99909 115827 rest_state 1675718226.619811 2023-02-06T21:17:06.619811+00:00 1.0 0.557409 0.26029 3523.38 5926.58 34149.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.101533 0.188569 0.976797 0.101197 0.150691 0.983388 30.6337 35.0466 3.79319 4.31288
exp_2023_02_06_13 leopard 99909 115828 rest_state 1675718226.6238458 2023-02-06T21:17:06.623846+00:00 1.0 0.553897 0.264682 368.55 641.253 3787.81 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.101533 0.188569 0.976797 0.0848475 0.151911 0.984746 30.6337 35.0361 3.79319 4.30397
exp_2023_02_06_13 leopard 99909 115829 rest_state 1675718226.6278806 2023-02-06T21:17:06.627881+00:00 1.0 0.549447 0.262338 1284.02 2446.04 14270.3 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0905688 0.186786 0.978217 0.0848475 0.151911 0.984746 30.5827 35.0361 3.78772 4.30397
exp_2023_02_06_13 leopard 99909 115830 rest_state 1675718226.631915 2023-02-06T21:17:06.631915+00:00 1.0 0.545988 0.268748 236.143 463.529 2804.72 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0905688 0.186786 0.978217 0.0685505 0.149227 0.986424 30.5827 34.588 3.78772 4.2451
exp_2023_02_06_13 leopard 99909 115831 rest_state 1675718226.6359496 2023-02-06T21:17:06.635950+00:00 1.0 0.540828 0.266196 563.177 1246.19 7436.59 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0779281 0.184518 0.979735 0.0685505 0.149227 0.986424 30.71 34.588 3.80473 4.2451
exp_2023_02_06_13 leopard 99909 115832 rest_state 1675718226.6399841 2023-02-06T21:17:06.639984+00:00 1.0 0.542417 0.263674 188732.0 409360.0 2408120.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0779281 0.184518 0.979735 0.0761252 0.149595 0.985813 30.71 35.1304 3.80473 4.31621
exp_2023_02_06_13 leopard 99909 115833 rest_state 1675718226.644019 2023-02-06T21:17:06.644019+00:00 1.0 0.542492 0.26368 28215.2 61101.4 359446.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.078111 0.184608 0.979703 0.0761252 0.149595 0.985813 30.6111 35.1304 3.79237 4.31621
exp_2023_02_06_13 leopard 99909 115834 rest_state 1675718226.6480536 2023-02-06T21:17:06.648054+00:00 1.0 0.543107 0.263106 1574.23 3376.4 19798.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.078111 0.184608 0.979703 0.0790613 0.148972 0.985676 30.6111 35.2736 3.79237 4.33335
exp_2023_02_06_13 leopard 99909 115835 rest_state 1675718226.6520882 2023-02-06T21:17:06.652088+00:00 1.0 0.543763 0.263117 3584.68 7585.45 44477.3 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0797142 0.185454 0.979414 0.0790613 0.148972 0.985676 30.6203 35.2736 3.7933 4.33335
exp_2023_02_06_13 leopard 99909 115836 rest_state 1675718226.656123 2023-02-06T21:17:06.656123+00:00 1.0 0.54394 0.263766 2023.43 4251.44 25018.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0797142 0.185454 0.979414 0.0799418 0.14725 0.985863 30.6203 35.0934 3.7933 4.30933
exp_2023_02_06_13 leopard 99909 115837 rest_state 1675718226.6601574 2023-02-06T21:17:06.660157+00:00 1.0 0.543936 0.263163 1978.75 4171.45 24465.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0797171 0.186512 0.979213 0.0799418 0.14725 0.985863 30.6444 35.0934 3.79624 4.30933
exp_2023_02_06_13 leopard 99909 115838 rest_state 1675718226.6641922 2023-02-06T21:17:06.664192+00:00 1.0 0.543894 0.262501 2286.38 4841.33 28290.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0797171 0.186512 0.979213 0.0797086 0.148622 0.985676 30.6444 34.7503 3.79624 4.2657
exp_2023_02_06_13 leopard 99909 115839 rest_state 1675718226.668227 2023-02-06T21:17:06.668227+00:00 1.0 0.543467 0.262404 1491.71 3187.88 18619.1 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0786756 0.18612 0.979372 0.0797086 0.148622 0.985676 30.6652 34.7503 3.79897 4.2657
exp_2023_02_06_13 leopard 99909 115840 rest_state 1675718226.6722615 2023-02-06T21:17:06.672261+00:00 1.0 0.543872 0.261134 934.969 1995.24 11571.5 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0786756 0.18612 0.979372 0.0815956 0.149902 0.985328 30.6652 34.8723 3.79897 4.2814
exp_2023_02_06_13 leopard 99909 115841 rest_state 1675718226.6762962 2023-02-06T21:17:06.676296+00:00 1.0 0.543686 0.261585 858.121 1833.74 10661.6 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0782135 0.18508 0.979606 0.0815956 0.149902 0.985328 30.7167 34.8723 3.80552 4.2814
exp_2023_02_06_13 leopard 99909 115842 rest_state 1675718226.6803308 2023-02-06T21:17:06.680331+00:00 1.0 0.544034 0.261533 650.055 1379.74 8019.36 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0782135 0.18508 0.979606 0.0832627 0.149033 0.98532 30.7167 34.8659 3.80552 4.2811
exp_2023_02_06_13 leopard 99909 115843 rest_state 1675718226.684366 2023-02-06T21:17:06.684366+00:00 1.0 0.544158 0.261429 679.775 1440.03 8364.88 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0785166 0.185426 0.979516 0.0832627 0.149033 0.98532 30.6637 34.8659 3.79886 4.2811
exp_2023_02_06_13 leopard 99909 115844 rest_state 1675718226.6884005 2023-02-06T21:17:06.688401+00:00 1.0 0.544216 0.258913 689.551 1478.69 8471.96 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0785166 0.185426 0.979516 0.0834252 0.153633 0.9846 30.6637 34.716 3.79886 4.26176
exp_2023_02_06_13 leopard 99909 115845 rest_state 1675718226.692435 2023-02-06T21:17:06.692435+00:00 1.0 0.544026 0.258996 643.043 1383.66 7931.25 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0780503 0.185027 0.979629 0.0834252 0.153633 0.9846 30.6927 34.716 3.80253 4.26176
exp_2023_02_06_13 leopard 99909 115846 rest_state 1675718226.6964698 2023-02-06T21:17:06.696470+00:00 1.0 0.543668 0.259844 835.048 1801.78 10376.2 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0780503 0.185027 0.979629 0.081746 0.153027 0.984835 30.6927 34.8111 3.80253 4.27452
exp_2023_02_06_13 leopard 99909 115847 rest_state 1675718226.7005043 2023-02-06T21:17:06.700504+00:00 1.0 0.544118 0.259729 1050.82 2248.15 12938.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0791502 0.185824 0.97939 0.081746 0.153027 0.984835 30.4206 34.8111 3.76843 4.27452
exp_2023_02_06_13 leopard 99909 115848 rest_state 1675718226.704539 2023-02-06T21:17:06.704539+00:00 1.0 0.543072 0.260148 5377.06 11725.4 67642.5 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0791502 0.185824 0.97939 0.076734 0.155147 0.984907 30.4206 34.3061 3.76843 4.21158
exp_2023_02_06_13 leopard 99909 115849 rest_state 1675718226.7085738 2023-02-06T21:17:06.708574+00:00 1.0 0.542607 0.260105 15415.4 33948.5 195810.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0780139 0.185284 0.979583 0.076734 0.155147 0.984907 30.7125 34.3061 3.80493 4.21158
exp_2023_02_06_13 leopard 99909 115850 rest_state 1675718226.7126083 2023-02-06T21:17:06.712608+00:00 1.0 0.543953 0.258201 673.533 1457.5 8318.64 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0780139 0.185284 0.979583 0.083123 0.154995 0.984412 30.7125 34.7606 3.80493 4.26776
exp_2023_02_06_13 leopard 99909 115851 rest_state 1675718226.716643 2023-02-06T21:17:06.716643+00:00 1.0 0.544259 0.258388 762.414 1638.05 9358.26 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0787582 0.18536 0.979509 0.083123 0.154995 0.984412 30.6001 34.7606 3.79085 4.26776
exp_2023_02_06_13 leopard 99909 115852 rest_state 1675718226.7206776 2023-02-06T21:17:06.720678+00:00 1.0 0.544261 0.257626 776.566 1675.12 9530.66 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0787582 0.18536 0.979509 0.0830922 0.156435 0.984187 30.6001 34.8116 3.79085 4.27378
exp_2023_02_06_13 leopard 99909 115853 rest_state 1675718226.7247124 2023-02-06T21:17:06.724712+00:00 1.0 0.544065 0.257213 713.058 1547.55 8785.48 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0782885 0.185828 0.979459 0.0830922 0.156435 0.984187 30.5956 34.8116 3.79024 4.27378
exp_2023_02_06_13 leopard 99909 115854 rest_state 1675718226.728747 2023-02-06T21:17:06.728747+00:00 1.0 0.543549 0.257941 1152.89 2518.84 14356.7 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0782885 0.185828 0.979459 0.0806454 0.1565 0.98438 30.5956 34.5801 3.79024 4.24566
exp_2023_02_06_13 leopard 99909 115855 rest_state 1675718226.7327816 2023-02-06T21:17:06.732782+00:00 1.0 0.543229 0.258044 958.86 2107.55 12019.6 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0775057 0.185223 0.979635 0.0806454 0.1565 0.98438 30.5806 34.5801 3.78845 4.24566
exp_2023_02_06_13 leopard 99909 115856 rest_state 1675718226.7368164 2023-02-06T21:17:06.736816+00:00 1.0 0.542991 0.257818 1294.55 2862.77 16307.3 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0775057 0.185223 0.979635 0.0794884 0.157592 0.9843 30.5806 34.6857 3.78845 4.25991
exp_2023_02_06_13 leopard 99909 115857 rest_state 1675718226.7408507 2023-02-06T21:17:06.740851+00:00 1.0 0.542813 0.256978 1130.62 2520.52 14293.1 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0770883 0.186466 0.979432 0.0794884 0.157592 0.9843 30.5147 34.6857 3.78012 4.25991
exp_2023_02_06_13 leopard 99909 115858 rest_state 1675718226.7448854 2023-02-06T21:17:06.744885+00:00 1.0 0.542601 0.258149 1455.17 3238.41 18481.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0770883 0.186466 0.979432 0.0785211 0.155969 0.984636 30.5147 34.5727 3.78012 4.24556
exp_2023_02_06_13 leopard 99909 115859 rest_state 1675718226.74892 2023-02-06T21:17:06.748920+00:00 1.0 0.542993 0.258527 2151.15 4739.1 27099.3 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0780381 0.18632 0.979385 0.0785211 0.155969 0.984636 30.4706 34.5727 3.77456 4.24556
exp_2023_02_06_13 leopard 99909 115860 rest_state 1675718226.7529547 2023-02-06T21:17:06.752955+00:00 1.0 0.54312 0.257084 1794.17 3972.34 22538.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0780381 0.18632 0.979385 0.0790632 0.158347 0.984213 30.4706 34.665 3.77456 4.25733
exp_2023_02_06_13 leopard 99909 115861 rest_state 1675718226.7569895 2023-02-06T21:17:06.756989+00:00 1.0 0.543 0.257309 1614.55 3579.22 20332.5 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0777425 0.185765 0.979514 0.0790632 0.158347 0.984213 30.5373 34.665 3.78296 4.25733
exp_2023_02_06_13 leopard 99909 115862 rest_state 1675718226.761024 2023-02-06T21:17:06.761024+00:00 1.0 0.543247 0.25632 1164.87 2582.63 14592.9 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0777425 0.185765 0.979514 0.0802008 0.159532 0.98393 30.5373 34.595 3.78296 4.24858
exp_2023_02_06_13 leopard 99909 115863 rest_state 1675718226.7650588 2023-02-06T21:17:06.765059+00:00 1.0 0.542982 0.255879 987.462 2206.34 12437.6 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0771046 0.18619 0.979484 0.0802008 0.159532 0.98393 30.4288 34.595 3.76943 4.24858
exp_2023_02_06_13 leopard 99909 115864 rest_state 1675718226.7690933 2023-02-06T21:17:06.769093+00:00 1.0 0.542819 0.257559 1124.9 2499.86 14220.4 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0771046 0.18619 0.979484 0.0794969 0.156808 0.984425 30.4288 34.5987 3.76943 4.24945
exp_2023_02_06_13 leopard 99909 115865 rest_state 1675718226.773128 2023-02-06T21:17:06.773128+00:00 1.0 0.543136 0.257995 1416.45 3120.05 17789.5 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0778711 0.185842 0.979489 0.0794969 0.156808 0.984425 30.2861 34.5987 3.75163 4.24945
exp_2023_02_06_13 leopard 99909 115866 rest_state 1675718226.7771628 2023-02-06T21:17:06.777163+00:00 1.0 0.543106 0.257518 1522.22 3363.5 19128.3 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0778711 0.185842 0.979489 0.0793306 0.157794 0.98428 30.2861 34.5995 3.75163 4.2499
exp_2023_02_06_13 leopard 99909 115867 rest_state 1675718226.7811973 2023-02-06T21:17:06.781197+00:00 1.0 0.542701 0.256399 1111.25 2490.65 14080.0 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0769017 0.187276 0.979292 0.0793306 0.157794 0.98428 30.2625 34.5995 3.74863 4.2499
exp_2023_02_06_13 leopard 99909 115868 rest_state 1675718226.7852325 2023-02-06T21:17:06.785233+00:00 1.0 0.543 0.257504 788.024 1745.18 9924.23 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0769017 0.187276 0.979292 0.0808254 0.154864 0.984624 30.2625 34.6388 3.74863 4.25395
exp_2023_02_06_13 leopard 99909 115869 rest_state 1675718226.789267 2023-02-06T21:17:06.789267+00:00 1.0 0.543075 0.258009 820.513 1809.51 10318.1 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0770752 0.186486 0.97943 0.0808254 0.154864 0.984624 30.2974 34.6388 3.75306 4.25395
exp_2023_02_06_13 leopard 99909 115870 rest_state 1675718226.7933016 2023-02-06T21:17:06.793302+00:00 1.0 0.543354 0.257421 664.915 1462.5 8312.65 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0770752 0.186486 0.97943 0.0821393 0.155198 0.984463 30.2974 34.769 3.75306 4.27054
exp_2023_02_06_13 leopard 99909 115871 rest_state 1675718226.7973363 2023-02-06T21:17:06.797336+00:00 1.0 0.5434 0.256872 672.831 1482.75 8402.86 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0771987 0.187512 0.979224 0.0821393 0.155198 0.984463 30.1268 34.769 3.73172 4.27054
exp_2023_02_06_13 leopard 99909 115872 rest_state 1675718226.8013709 2023-02-06T21:17:06.801371+00:00 1.0 0.543425 0.257205 655.956 1442.31 8188.32 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0771987 0.187512 0.979224 0.0822749 0.154499 0.984561 30.1268 34.7626 3.73172 4.26955
exp_2023_02_06_13 leopard 99909 115873 rest_state 1675718226.8054056 2023-02-06T21:17:06.805406+00:00 1.0 0.543452 0.257758 666.378 1460.18 8314.5 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0772539 0.186574 0.979399 0.0822749 0.154499 0.984561 30.2804 34.7626 3.75097 4.26955
exp_2023_02_06_13 leopard 99909 115874 rest_state 1675718226.8094401 2023-02-06T21:17:06.809440+00:00 1.0 0.543421 0.258435 671.211 1466.46 8380.98 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0772539 0.186574 0.979399 0.0821585 0.153304 0.984758 30.2804 34.7967 3.75097 4.27332
exp_2023_02_06_13 leopard 99909 115875 rest_state 1675718226.813475 2023-02-06T21:17:06.813475+00:00 1.0 0.543421 0.258171 669.218 1464.16 8355.86 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0772575 0.187038 0.97931 0.0821585 0.153304 0.984758 30.2323 34.7967 3.74496 4.27332
exp_2023_02_06_13 leopard 99909 115876 rest_state 1675718226.8175097 2023-02-06T21:17:06.817510+00:00 1.0 0.544001 0.256838 482.382 1050.32 5950.73 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0772575 0.187038 0.97931 0.0848824 0.154204 0.984386 30.2323 34.5756 3.74496 4.24635
exp_2023_02_06_13 leopard 99909 115877 rest_state 1675718226.8215442 2023-02-06T21:17:06.821544+00:00 1.0 0.543483 0.255924 419.1 926.599 5224.4 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0760132 0.187958 0.979231 0.0848824 0.154204 0.984386 30.0659 34.5756 3.72426 4.24635
exp_2023_02_06_13 leopard 99909 115878 rest_state 1675718226.825579 2023-02-06T21:17:06.825579+00:00 1.0 0.54328 0.256582 456.613 1010.28 5716.49 17.1908 9.90296 -27.9338 -39.1963 13.9502 -21.621 0.0760132 0.187958 0.979231 0.083937 0.15353 0.984573 30.0659 34.5566 3.72426 4.24404
exp_2023_02_06_13 leopard 99909 115879 rest_state 1675718226.829614 2023-02-06T21:17:06.829614+00:00 1.0 0.539971 0.257438 236.056 557.826 3172.15 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0679492 0.182087 0.980932 0.083937 0.15353 0.984573 30.0203 34.5566 3.73567 4.24404
exp_2023_02_06_13 leopard 99909 115880 rest_state 1675718226.8336487 2023-02-06T21:17:06.833649+00:00 1.0 0.539748 0.25864 248.137 585.545 3351.59 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0679492 0.182087 0.980932 0.0829239 0.151887 0.984913 30.0203 34.6153 3.73567 4.25085
exp_2023_02_06_13 leopard 99909 115881 rest_state 1675718226.8376832 2023-02-06T21:17:06.837683+00:00 1.0 0.539673 0.258944 245.386 579.092 3320.15 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0677609 0.181456 0.981062 0.0829239 0.151887 0.984913 30.1789 34.6153 3.75565 4.25085
exp_2023_02_06_13 leopard 99909 115882 rest_state 1675718226.841718 2023-02-06T21:17:06.841718+00:00 1.0 0.539851 0.259448 232.881 545.961 3138.73 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0677609 0.181456 0.981062 0.0838049 0.150439 0.985061 30.1789 34.6804 3.75565 4.25925
exp_2023_02_06_13 leopard 99909 115883 rest_state 1675718226.8457527 2023-02-06T21:17:06.845753+00:00 1.0 0.538918 0.258358 201.93 486.143 2778.62 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0655269 0.182141 0.981086 0.0838049 0.150439 0.985061 30.0964 34.6804 3.74545 4.25925
exp_2023_02_06_13 leopard 99909 115884 rest_state 1675718226.849787 2023-02-06T21:17:06.849787+00:00 1.0 0.539089 0.257288 195.883 472.427 2684.62 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0655269 0.182141 0.981086 0.0845754 0.151974 0.984759 30.0964 34.4633 3.74545 4.23232
exp_2023_02_06_13 leopard 99909 115885 rest_state 1675718226.8538218 2023-02-06T21:17:06.853822+00:00 1.0 0.539127 0.25653 196.414 475.181 2689.26 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0656339 0.183519 0.980823 0.0845754 0.151974 0.984759 29.9582 34.4633 3.72802 4.23232
exp_2023_02_06_13 leopard 99909 115886 rest_state 1675718226.8578563 2023-02-06T21:17:06.857856+00:00 1.0 0.539811 0.254482 173.173 417.039 2334.34 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0656339 0.183519 0.980823 0.0877666 0.153904 0.98418 29.9582 34.7595 3.72802 4.26871
exp_2023_02_06_13 leopard 99909 115887 rest_state 1675718226.861891 2023-02-06T21:17:06.861891+00:00 1.0 0.539741 0.254959 171.939 413.683 2321.47 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0654555 0.182592 0.981008 0.0877666 0.153904 0.98418 30.0816 34.7595 3.7436 4.26871
exp_2023_02_06_13 leopard 99909 115888 rest_state 1675718226.8659258 2023-02-06T21:17:06.865926+00:00 1.0 0.539899 0.255117 166.844 399.705 2244.88 17.2264 9.89456 -28.1163 -39.1963 13.9502 -21.621 0.0654555 0.182592 0.981008 0.0885305 0.153165 0.984227 30.0816 34.5123 3.7436 4.23805

Next page

Advanced export

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

CSV options:

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]);