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

View and edit SQL

Suggested facets: task, 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_2022_10_04_09 tiger 18 1967 rest_state 1664906873.8933039 2022-10-04T18:07:53.893304+00:00 0.572289 0.435287 0.532396 -44.5851 -35.716 463.709       -213.915 310.014 144.651       0.33866 -0.69146 0.638116   29.2949   4.05851
exp_2022_10_04_09 tiger 18 1968 rest_state 1664906873.9013731 2022-10-04T18:07:53.901373+00:00 0.420718 0.430352 0.528194 -48.7125 -34.2267 467.461       -213.915 310.014 144.651       0.330406 -0.688482 0.64562   28.4442   3.93526
exp_2022_10_04_09 tiger 18 1969 rest_state 1664906873.8864827 2022-10-04T18:07:53.886483+00:00 1.0 0.406756 0.538808 -69.6931 -40.5506 486.546 -146.934 382.952 232.225       0.154482 -0.847005 0.508642       38.2476   3.98772  
exp_2022_10_04_09 tiger 18 1970 rest_state 1664906873.9106905 2022-10-04T18:07:53.910691+00:00 0.592371 0.427362 0.568678 -50.468 -51.0071 461.078 -146.934 382.952 232.225       0.192933 -0.867918 0.457706       37.4797   3.91397  
exp_2022_10_04_09 tiger 18 1971 rest_state 1664906873.9187608 2022-10-04T18:07:53.918761+00:00 0.371793 0.427744 0.585424 -48.9766 -56.696 449.283 -146.934 382.952 232.225       0.195915 -0.879296 0.434114       40.9138   4.27653  
exp_2022_10_04_09 tiger 18 1972 rest_state 1664906873.92683 2022-10-04T18:07:53.926830+00:00 0.266507 0.479334 0.622252 -10.0931 -65.0824 406.981 -146.934 382.952 232.225       0.273682 -0.896069 0.349511       40.2754   4.18527  
exp_2022_10_04_09 tiger 18 1973 rest_state 1664906873.9348993 2022-10-04T18:07:53.934899+00:00 0.276645 0.434351 0.586355 -43.8529 -56.7186 446.85 -146.934 382.952 232.225       0.206163 -0.879342 0.42925       38.0473   3.96911  
exp_2022_10_04_09 tiger 18 1974 rest_state 1664906873.9429686 2022-10-04T18:07:53.942969+00:00 0.241357 0.402686 0.607081 -66.424 -64.7352 439.817 -146.934 382.952 232.225       0.161021 -0.895375 0.415183       44.3132   4.65048  
exp_2022_10_04_09 tiger 18 1975 rest_state 1664906873.951038 2022-10-04T18:07:53.951038+00:00 0.292981 0.441866 0.603883 -37.1702 -61.8984 432.375 -146.934 382.952 232.225       0.219528 -0.889701 0.400299       41.5144   4.33219  
exp_2022_10_04_09 tiger 18 1976 rest_state 1664906873.9591072 2022-10-04T18:07:53.959107+00:00 0.339146 0.456697 0.604693 -26.3459 -61.3835 427.223 -146.934 382.952 232.225       0.241177 -0.888671 0.389996       42.3773   4.41732  
exp_2022_10_04_09 tiger 18 1977 rest_state 1664906873.9671762 2022-10-04T18:07:53.967176+00:00 0.361736 0.467284 0.596618 -19.0342 -58.4002 429.329 -146.934 382.952 232.225       0.2558 -0.882705 0.394207       38.9625   4.05177  
exp_2022_10_04_09 tiger 18 1978 rest_state 1664906873.9752457 2022-10-04T18:07:53.975246+00:00 0.52378 0.478092 0.588117 -11.5234 -55.2342 431.365 -146.934 382.952 232.225       0.270822 -0.876373 0.398279       37.8063   3.9263  
exp_2022_10_04_09 tiger 18 1979 rest_state 1664906873.9094427 2022-10-04T18:07:53.909443+00:00 0.96419 0.45451 0.53442 -29.4981 -35.8177 455.12       -213.915 310.014 144.651       0.368834 -0.691664 0.620937   15.2053   2.07824
exp_2022_10_04_09 tiger 18 1980 rest_state 1664906873.917512 2022-10-04T18:07:53.917512+00:00 0.87972 0.484409 0.192667 -9.47936 134.512 565.846       -213.915 310.014 144.651       0.408872 -0.351005 0.842389   15.1252   2.04802
exp_2022_10_04_09 tiger 18 1981 rest_state 1664906873.9255812 2022-10-04T18:07:53.925581+00:00 0.162405 0.454452 0.60692 -27.6129 -61.5975 422.493       -213.915 310.014 144.651       0.372605 -0.743223 0.555684   31.5986   4.41837
exp_2022_10_04_09 tiger 18 1982 rest_state 1664906873.9336503 2022-10-04T18:07:53.933650+00:00 0.16182 0.486341 0.634005 -5.31737 -67.8719 397.018       -213.915 310.014 144.651       0.417196 -0.755772 0.504734   32.4402   4.56424
exp_2022_10_04_09 tiger 18 1983 rest_state 1664906873.9417195 2022-10-04T18:07:53.941720+00:00 0.200113 0.378808 0.6065 -85.8024 -66.1261 448.14       -213.915 310.014 144.651       0.256226 -0.75228 0.606978   32.3304   4.48186
exp_2022_10_04_09 tiger 18 1984 rest_state 1664906873.9497888 2022-10-04T18:07:53.949789+00:00 0.17872 0.399836 0.569681 -71.2562 -51.5103 459.212       -213.915 310.014 144.651       0.285318 -0.723049 0.629121   34.7793   4.82692
exp_2022_10_04_09 tiger 18 1985 rest_state 1664906873.957858 2022-10-04T18:07:53.957858+00:00 0.296709 0.434538 0.545312 -44.6591 -40.7417 458.216       -213.915 310.014 144.651       0.338512 -0.701512 0.627129   37.1271   5.17596
exp_2022_10_04_09 tiger 18 1986 rest_state 1664906873.9659274 2022-10-04T18:07:53.965927+00:00 0.99 0.481627 0.576908 -8.8941 -49.9549 424.631       -213.915 310.014 144.651       0.410042 -0.719938 0.559959   23.0201   3.19892
exp_2022_10_04_09 tiger 18 1987 rest_state 1664906873.9739966 2022-10-04T18:07:53.973997+00:00 0.367699 0.460224 0.412572 -27.922 16.2761 503.99       -213.915 310.014 144.651       0.371987 -0.587476 0.718678   32.9668   4.55471
exp_2022_10_04_09 tiger 18 1988 rest_state 1664906873.9901352 2022-10-04T18:07:53.990135+00:00 0.414438 0.42839 0.483658 -52.2904 -15.828 487.732       -213.915 310.014 144.651       0.32325 -0.651684 0.686161   31.412   4.33731
exp_2022_10_04_09 tiger 18 1989 rest_state 1664906873.9982045 2022-10-04T18:07:53.998204+00:00 0.447373 0.395227 0.521139 -78.3575 -32.4504 482.796       -213.915 310.014 144.651       0.271116 -0.684929 0.67629   29.1271   4.01055
exp_2022_10_04_09 tiger 18 1990 rest_state 1664906873.983315 2022-10-04T18:07:53.983315+00:00 0.7975 0.499131 0.557201 3.30188 -44.1859 444.315 -146.934 382.952 232.225       0.300472 -0.854276 0.42418       38.5062   3.97771  
exp_2022_10_04_09 tiger 18 1991 rest_state 1664906875.7331085 2022-10-04T18:07:55.733109+00:00 0.536265 0.42935 0.524098 -49.7064 -32.6295 469.707       -213.883 310.005 144.672       0.328354 -0.685268 0.65007   26.1192   3.60658
exp_2022_10_04_09 tiger 18 1992 rest_state 1664906875.7411778 2022-10-04T18:07:55.741178+00:00 0.218523 0.384242 0.579198 -83.4578 -55.8561 459.529       -213.883 310.005 144.672       0.260851 -0.731721 0.629715   31.2567   4.32081
exp_2022_10_04_09 tiger 18 1993 rest_state 1664906875.7262921 2022-10-04T18:07:55.726292+00:00 1.0 0.394894 0.543727 -79.2012 -42.7988 485.597 -146.898 382.916 232.251       0.135393 -0.85143 0.506691       35.4264   3.68465  
exp_2022_10_04_09 tiger 18 1994 rest_state 1664906875.750501 2022-10-04T18:07:55.750501+00:00 0.586329 0.407411 0.577326 -65.5899 -54.7762 459.879 -146.898 382.916 232.251       0.162616 -0.875385 0.455255       35.339   3.68825  
exp_2022_10_04_09 tiger 18 1995 rest_state 1664906875.757316 2022-10-04T18:07:55.757316+00:00 0.180039 0.402545 0.598789 -67.2203 -61.9992 444.844       -213.883 310.005 144.672       0.293326 -0.744008 0.600344   30.2474   4.19485
exp_2022_10_04_09 tiger 18 1996 rest_state 1664906875.7653854 2022-10-04T18:07:55.765385+00:00 0.21953 0.448432 0.583633 -32.6742 -54.08 435.542       -213.883 310.005 144.672       0.362418 -0.728169 0.581741   28.9143   4.0251
exp_2022_10_04_09 tiger 18 1997 rest_state 1664906875.7734547 2022-10-04T18:07:55.773455+00:00 0.211884 0.484917 0.434103 -7.50493 6.14601 483.903       -213.883 310.005 144.672       0.412757 -0.607717 0.678463   31.9854   4.43571
exp_2022_10_04_09 tiger 18 1998 rest_state 1664906875.781524 2022-10-04T18:07:55.781524+00:00 0.187356 0.437809 0.588976 -40.4308 -56.5322 437.187       -213.883 310.005 144.672       0.346905 -0.733074 0.58503   29.3017   4.07603
exp_2022_10_04_09 tiger 18 1999 rest_state 1664906875.7895932 2022-10-04T18:07:55.789593+00:00 0.183291 0.331138 0.533826 -134.603 -39.7666 493.061       -213.883 310.005 144.672       0.158561 -0.699542 0.696778   30.835   4.21888
exp_2022_10_04_09 tiger 18 2000 rest_state 1664906875.7976623 2022-10-04T18:07:55.797662+00:00 0.189299 0.367371 0.519449 -102.962 -32.5302 491.611       -213.883 310.005 144.672       0.221844 -0.68507 0.693877   29.899   4.10144
exp_2022_10_04_09 tiger 18 2001 rest_state 1664906875.8057318 2022-10-04T18:07:55.805732+00:00 0.245849 0.432824 0.569972 -44.9911 -50.0263 447.745       -213.883 310.005 144.672       0.337785 -0.720062 0.606146   29.8114   4.13943
exp_2022_10_04_09 tiger 18 2002 rest_state 1664906875.7585702 2022-10-04T18:07:55.758570+00:00 0.6 0.417576 0.570638 -58.0786 -52.0677 462.251 -146.898 382.916 232.251       0.177639 -0.869968 0.46       33.2761   3.4673  
exp_2022_10_04_09 tiger 18 2003 rest_state 1664906875.7666395 2022-10-04T18:07:55.766639+00:00 0.264692 0.414069 0.595401 -58.7482 -60.5517 445.73 -146.897 382.911 232.258       0.176298 -0.886926 0.426944       36.9544   3.85423  
exp_2022_10_04_09 tiger 18 2004 rest_state 1664906875.7747087 2022-10-04T18:07:55.774709+00:00 0.99 0.408648 0.426238 -78.1499 11.1978 559.523 -146.897 382.911 232.258       0.137495 -0.743427 0.654531       13.7694   1.41469  
exp_2022_10_04_09 tiger 18 2005 rest_state 1664906875.7827778 2022-10-04T18:07:55.782778+00:00 0.841348 0.416093 0.382406 -74.5128 35.1326 584.125 -146.897 382.911 232.258       0.144769 -0.695558 0.703734       16.1469   1.65833  
exp_2022_10_04_09 tiger 18 2006 rest_state 1664906875.7908473 2022-10-04T18:07:55.790847+00:00 0.324738 0.429595 0.592604 -47.068 -58.9692 443.86 -146.897 382.911 232.258       0.199659 -0.883761 0.423205       34.4272   3.58111  
exp_2022_10_04_09 tiger 18 2007 rest_state 1664906875.7989166 2022-10-04T18:07:55.798917+00:00 0.347422 0.429707 0.592539 -46.9874 -58.9434 443.876 -146.897 382.911 232.258       0.19982 -0.88371 0.423237       35.2154   3.66404  
exp_2022_10_04_09 tiger 18 2008 rest_state 1664906875.8069859 2022-10-04T18:07:55.806986+00:00 0.468127 0.443037 0.560234 -38.7066 -47.4526 462.652 -146.897 382.911 232.258       0.216382 -0.860728 0.460789       30.0183   3.11652  
exp_2022_10_04_09 tiger 18 2009 rest_state 1664906875.8150551 2022-10-04T18:07:55.815055+00:00 0.529728 0.436572 0.576347 -42.79 -53.3046 453.34 -146.897 382.911 232.258       0.208215 -0.872432 0.442164       32.9521   3.42494  
exp_2022_10_04_09 tiger 18 2010 rest_state 1664906875.8218703 2022-10-04T18:07:55.821870+00:00 0.307546 0.428551 0.583541 -47.7039 -55.1312 443.102       -213.883 310.005 144.672       0.332359 -0.730272 0.596859   32.107   4.46637
exp_2022_10_04_09 tiger 18 2011 rest_state 1664906875.8299396 2022-10-04T18:07:55.829940+00:00 0.541502 0.469834 0.533568 -17.9389 -34.9435 449.002       -213.883 310.005 144.672       0.391889 -0.689896 0.608659   25.5793   3.55293
exp_2022_10_04_09 tiger 18 2012 rest_state 1664906875.8392627 2022-10-04T18:07:55.839263+00:00 0.591601 0.450989 0.577272 -31.742 -53.0119 448.383 -146.897 382.911 232.258       0.230311 -0.871846 0.432251       33.8852   3.51762  
exp_2022_10_04_09 tiger 18 2013 rest_state 1664906875.846079 2022-10-04T18:07:55.846079+00:00 0.486237 0.45836 0.578369 -25.5048 -51.7088 433.942       -213.883 310.005 144.672       0.376757 -0.723427 0.578539   30.5268   4.25676
exp_2022_10_04_09 tiger 18 2014 rest_state 1664906875.8541484 2022-10-04T18:07:55.854148+00:00 0.560168 0.468657 0.544092 -18.6361 -38.9182 444.891       -213.883 310.005 144.672       0.390495 -0.697846 0.600438   28.1841   3.92104
exp_2022_10_04_09 tiger 18 2015 rest_state 1664906877.2824173 2022-10-04T18:07:57.282417+00:00 0.452129 0.445487 0.585324 -34.7992 -54.8151 435.794       -213.89 309.999 144.526       0.358182 -0.729627 0.582537   33.6922   4.71708
exp_2022_10_04_09 tiger 18 2016 rest_state 1664906877.2904866 2022-10-04T18:07:57.290487+00:00 0.564518 0.421068 0.549059 -55.2029 -42.7125 461.406       -213.89 309.999 144.526       0.317374 -0.705422 0.633761   31.1909   4.33422
exp_2022_10_04_09 tiger 18 2017 rest_state 1664906877.275606 2022-10-04T18:07:57.275606+00:00 1.0 0.440154 0.550938 -41.5085 -44.1954 470.029 -146.87 382.86 232.285       0.210723 -0.854111 0.475489       37.419   3.87431  
exp_2022_10_04_09 tiger 18 2018 rest_state 1664906877.306625 2022-10-04T18:07:57.306625+00:00 0.466936 0.421266 0.535488 -55.7186 -37.4176 467.456       -213.89 309.999 144.526       0.316343 -0.694833 0.64586   28.2655   3.91772
exp_2022_10_04_09 tiger 18 2019 rest_state 1664906877.3146942 2022-10-04T18:07:57.314694+00:00 0.303038 0.404908 0.591021 -65.8043 -59.082 447.594       -213.89 309.999 144.526       0.296172 -0.738161 0.606135   33.1194   4.61389
exp_2022_10_04_09 tiger 18 2020 rest_state 1664906877.3227634 2022-10-04T18:07:57.322763+00:00 0.27908 0.390269 0.590701 -77.6209 -59.7732 452.259       -213.89 309.999 144.526       0.272538 -0.739544 0.615466   32.0776   4.45771
exp_2022_10_04_09 tiger 18 2021 rest_state 1664906877.330833 2022-10-04T18:07:57.330833+00:00 0.249648 0.400746 0.572451 -70.3206 -52.4966 457.551       -213.89 309.999 144.526       0.287139 -0.72499 0.626051   30.7485   4.26864
exp_2022_10_04_09 tiger 18 2022 rest_state 1664906877.3389022 2022-10-04T18:07:57.338902+00:00 0.186477 0.546054 0.324977 41.1317 55.3531 491.109       -213.89 309.999 144.526       0.510044 -0.509291 0.693165   31.1057   4.33693
exp_2022_10_04_09 tiger 18 2023 rest_state 1664906877.3469715 2022-10-04T18:07:57.346972+00:00 0.186771 0.49388 0.299766 -0.568376 71.7793 528.903       -213.89 309.999 144.526       0.426643 -0.476439 0.768753   31.1712   4.30583
exp_2022_10_04_09 tiger 18 2024 rest_state 1664906877.3550417 2022-10-04T18:07:57.355042+00:00 0.182905 0.405795 0.563104 -66.7903 -48.7365 460.233       -213.89 309.999 144.526       0.294199 -0.71747 0.631414   30.5739   4.24345
exp_2022_10_04_09 tiger 18 2025 rest_state 1664906877.3631108 2022-10-04T18:07:57.363111+00:00 0.148455 0.41086 0.553745 -63.2139 -44.9382 462.828       -213.89 309.999 144.526       0.301352 -0.709874 0.636605   30.6444   4.25297
exp_2022_10_04_09 tiger 18 2026 rest_state 1664906877.2998137 2022-10-04T18:07:57.299814+00:00 0.872625 0.444454 0.545723 -38.3776 -42.1193 472.33 -146.87 382.86 232.285       0.216985 -0.849959 0.48009       35.6214   3.68876  
exp_2022_10_04_09 tiger 18 2027 rest_state 1664906877.307883 2022-10-04T18:07:57.307883+00:00 0.503363 0.429219 0.59343 -47.3094 -59.2671 443.498 -146.87 382.86 232.285       0.199121 -0.884255 0.422426       38.9993   4.05572  
exp_2022_10_04_09 tiger 18 2028 rest_state 1664906877.3159525 2022-10-04T18:07:57.315953+00:00 0.566767 0.428773 0.576659 -48.8236 -53.7391 455.372 -146.87 382.86 232.285       0.196093 -0.873199 0.446174       35.0321   3.63951  
exp_2022_10_04_09 tiger 18 2029 rest_state 1664906877.3240216 2022-10-04T18:07:57.324022+00:00 0.355685 0.418333 0.6006 -55.0557 -62.0357 441.181 -146.87 382.86 232.285       0.183629 -0.889792 0.417792       39.3772   4.09979  
exp_2022_10_04_09 tiger 18 2030 rest_state 1664906877.37118 2022-10-04T18:07:57.371180+00:00 0.21661 0.508099 0.533644 9.44615 -33.5578 431.039       -213.89 309.999 144.526       0.446672 -0.687113 0.573027   29.5894   4.15033
exp_2022_10_04_09 tiger 18 2031 rest_state 1664906877.3792493 2022-10-04T18:07:57.379249+00:00 0.178287 0.392123 0.535479 -80.003 -38.4349 477.194       -213.89 309.999 144.526       0.267774 -0.696867 0.665337   29.8113   4.11986
exp_2022_10_04_09 tiger 18 2032 rest_state 1664906877.3873186 2022-10-04T18:07:57.387319+00:00 0.128901 0.537253 0.566442 27.911 -43.5445 402.478       -213.89 309.999 144.526       0.483602 -0.707086 0.515905   30.5834   4.31641
exp_2022_10_04_09 tiger 18 2033 rest_state 1664906877.3320909 2022-10-04T18:07:57.332091+00:00 0.852644 0.450076 0.523135 -34.9765 -33.2362 485.945 -146.87 382.86 232.285       0.223787 -0.832193 0.50732       17.186   1.76441  
exp_2022_10_04_09 tiger 18 2034 rest_state 1664906877.3401601 2022-10-04T18:07:57.340160+00:00 0.264289 0.4144 0.608655 -57.37 -64.7182 436.401 -146.87 382.86 232.285       0.179 -0.895157 0.408231       39.4125   4.10448  
exp_2022_10_04_09 tiger 18 2035 rest_state 1664906877.3482294 2022-10-04T18:07:57.348229+00:00 0.228986 0.485048 0.621448 -6.2782 -64.5522 405.651 -146.87 382.86 232.285       0.281183 -0.894825 0.346733       38.6814   3.99965  
exp_2022_10_04_09 tiger 18 2036 rest_state 1664906877.3562987 2022-10-04T18:07:57.356299+00:00 0.402583 0.577333 0.384499 69.102 29.8882 512.939 -146.87 382.86 232.285       0.431944 -0.705944 0.561308       36.6431   3.77368  
exp_2022_10_04_09 tiger 18 2037 rest_state 1664906877.364369 2022-10-04T18:07:57.364369+00:00 0.276788 0.520098 0.500958 19.5063 -22.7161 472.757 -146.87 382.86 232.285       0.332753 -0.811153 0.480944       38.1019   3.9321  
exp_2022_10_04_09 tiger 18 2038 rest_state 1664906877.3724382 2022-10-04T18:07:57.372438+00:00 0.249518 0.50615 0.478386 9.24577 -13.5812 493.937 -146.87 382.86 232.285       0.312231 -0.792883 0.523305       37.6774   3.89658  
exp_2022_10_04_09 tiger 18 2039 rest_state 1664906877.3805075 2022-10-04T18:07:57.380507+00:00 0.22536 0.524231 0.404843 25.4536 20.8792 531.073 -146.87 382.86 232.285       0.344647 -0.723962 0.597576       39.8441   4.12979  
exp_2022_10_04_09 tiger 18 2040 rest_state 1664906877.3885767 2022-10-04T18:07:57.388577+00:00 0.24685 0.549846 0.463336 43.0831 -6.68404 481.63 -146.87 382.86 232.285       0.379906 -0.779089 0.49869       37.3725   3.84832  
exp_2022_10_04_09 tiger 18 2041 rest_state 1664906877.396646 2022-10-04T18:07:57.396646+00:00 0.283461 0.544919 0.393171 42.9633 26.3748 527.041 -146.87 382.86 232.285       0.379667 -0.712971 0.589513       37.8068   3.90819  
exp_2022_10_04_09 tiger 18 2042 rest_state 1664906877.4047153 2022-10-04T18:07:57.404715+00:00 0.304887 0.55642 0.398307 51.8886 23.5082 517.524 -146.87 382.86 232.285       0.397517 -0.718704 0.570477       37.5704   3.8768  
exp_2022_10_04_09 tiger 18 2043 rest_state 1664906877.4127846 2022-10-04T18:07:57.412785+00:00 0.263829 0.487822 0.40092 -5.96113 23.5722 550.179 -146.87 382.86 232.285       0.281818 -0.718576 0.635788       37.9247   3.94892  
exp_2022_10_04_09 tiger 18 2044 rest_state 1664906877.4208539 2022-10-04T18:07:57.420854+00:00 0.307278 0.498601 0.407979 3.54478 19.7172 541.32 -146.87 382.86 232.285       0.300829 -0.726286 0.61807       39.0522   4.05985  
exp_2022_10_04_09 tiger 18 2045 rest_state 1664906877.4289231 2022-10-04T18:07:57.428923+00:00 0.317057 0.503197 0.415376 7.46411 15.8856 534.792 -146.87 382.86 232.285       0.308668 -0.73395 0.605014       40.3093   4.18786  
exp_2022_10_04_09 tiger 18 2046 rest_state 1664906877.4369922 2022-10-04T18:07:57.436992+00:00 0.276149 0.540186 0.417726 37.9887 14.2324 515.023 -146.87 382.86 232.285       0.369717 -0.737256 0.565476       38.0578   3.93132  
exp_2022_10_04_09 tiger 18 2047 rest_state 1664906877.4450614 2022-10-04T18:07:57.445061+00:00 0.294265 0.498675 0.408006 3.60945 19.7019 541.27 -146.87 382.86 232.285       0.300959 -0.726317 0.617971       40.0762   4.1679  
exp_2022_10_04_09 tiger 18 2048 rest_state 1664906877.4531307 2022-10-04T18:07:57.453131+00:00 0.310881 0.494243 0.400587 -0.261788 23.6284 547.655 -146.87 382.86 232.285       0.293216 -0.718464 0.630741       40.0834   4.17344  
exp_2022_10_04_09 tiger 18 2049 rest_state 1664906877.4612002 2022-10-04T18:07:57.461200+00:00 0.295158 0.494235 0.400599 -0.268756 23.6226 547.652 -146.87 382.86 232.285       0.293202 -0.718476 0.630734       40.1079   4.17603  
exp_2022_10_04_09 tiger 18 2050 rest_state 1664906877.4692705 2022-10-04T18:07:57.469270+00:00 0.274085 0.543368 0.401418 41.3041 22.2336 523.041 -146.87 382.86 232.285       0.376348 -0.721254 0.581511       38.3543   3.96432  
exp_2022_10_04_09 tiger 18 2051 rest_state 1664906877.4773397 2022-10-04T18:07:57.477340+00:00 0.288375 0.522034 0.413128 23.3891 16.7503 527.201 -146.87 382.86 232.285       0.340518 -0.73222 0.589831       36.0885   3.73504  
exp_2022_10_04_09 tiger 18 2052 rest_state 1664906877.485409 2022-10-04T18:07:57.485409+00:00 0.26787 0.520209 0.421254 21.6635 12.7562 523.179 -146.87 382.86 232.285       0.337067 -0.740208 0.581788       35.8015   3.70415  
exp_2022_10_04_09 tiger 18 2053 rest_state 1664906877.395388 2022-10-04T18:07:57.395388+00:00 0.882592 0.381681 0.0715599 -123.468 231.904 630.041       -213.89 309.999 144.526       0.180845 -0.156189 0.971031   25.5524   3.43249
exp_2022_10_04_09 tiger 18 2054 rest_state 1664906877.493478 2022-10-04T18:07:57.493478+00:00 0.309532 0.567238 0.443129 57.0895 2.1963 484.268 -146.87 382.86 232.285       0.407919 -0.761328 0.503966       37.35   3.84168  
exp_2022_10_04_09 tiger 18 2055 rest_state 1664906877.4034574 2022-10-04T18:07:57.403457+00:00 0.163327 0.471077 0.549364 -16.7648 -40.7418 441.381       -213.89 309.999 144.526       0.394251 -0.701481 0.59371   29.7329   4.15506
exp_2022_10_04_09 tiger 18 2056 rest_state 1664906877.5015473 2022-10-04T18:07:57.501547+00:00 0.265285 0.549803 0.400032 46.5408 22.7923 520.284 -146.87 382.86 232.285       0.386822 -0.720136 0.575997       37.9887   3.92324  
exp_2022_10_04_09 tiger 18 2057 rest_state 1664906877.4115264 2022-10-04T18:07:57.411526+00:00 0.170251 0.593803 0.597827 58.6965 -49.8567 359.469       -213.89 309.999 144.526       0.545173 -0.719711 0.429887   29.4323   4.1832
exp_2022_10_04_09 tiger 18 2058 rest_state 1664906877.5096166 2022-10-04T18:07:57.509617+00:00 0.289794 0.553322 0.44669 46.6135 0.628119 490.089 -146.87 382.86 232.285       0.386967 -0.764464 0.515607       36.656   3.77448  
exp_2022_10_04_09 tiger 18 2059 rest_state 1664906877.4195957 2022-10-04T18:07:57.419596+00:00 0.17521 0.492318 0.551252 -1.54959 -40.5031 430.987       -213.89 309.999 144.526       0.424681 -0.701004 0.572922   27.9903   3.91951
exp_2022_10_04_09 tiger 18 2060 rest_state 1664906877.427665 2022-10-04T18:07:57.427665+00:00 0.188083 0.492242 0.551168 -1.60273 -40.4767 431.059       -213.89 309.999 144.526       0.424575 -0.700951 0.573066   28.3409   3.96917
exp_2022_10_04_09 tiger 18 2061 rest_state 1664906877.4357343 2022-10-04T18:07:57.435734+00:00 0.153135 0.503135 0.558788 5.8812 -42.6488 422.627       -213.89 309.999 144.526       0.439543 -0.705295 0.556203   29.4618   4.13618
exp_2022_10_04_09 tiger 18 2062 rest_state 1664906877.4438035 2022-10-04T18:07:57.443804+00:00 0.202187 0.593614 0.59779 58.6009 -49.8583 359.588       -213.89 309.999 144.526       0.544982 -0.719714 0.430124   29.2853   4.16193
exp_2022_10_04_09 tiger 18 2063 rest_state 1664906877.4518728 2022-10-04T18:07:57.451873+00:00 0.176177 0.44016 0.524346 -41.0101 -32.3777 465.292       -213.89 309.999 144.526       0.34576 -0.684753 0.641532   29.3558   4.07768
exp_2022_10_04_09 tiger 18 2064 rest_state 1664906877.4599419 2022-10-04T18:07:57.459942+00:00 0.132822 0.455208 0.536778 -28.8964 -36.6845 453.699       -213.89 309.999 144.526       0.369987 -0.693366 0.618347   29.8844   4.16421
exp_2022_10_04_09 tiger 18 2065 rest_state 1664906877.4680111 2022-10-04T18:07:57.468011+00:00 0.118999 0.624522 0.521752 79.5467 -25.3835 371.272       -213.89 309.999 144.526       0.586874 -0.670764 0.453492   28.5899   4.062
exp_2022_10_04_09 tiger 18 2066 rest_state 1664906877.4760807 2022-10-04T18:07:57.476081+00:00 0.137384 0.460302 0.54099 -24.9284 -38.0826 449.703       -213.89 309.999 144.526       0.377923 -0.696162 0.610354   28.9896   4.04157

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