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

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_2023_02_21_14 tiger 116 1476 rest_state 1677017434.3749187 2023-02-21T22:10:34.374919+00:00 0.551355 0.22921 0.865769 -195.85 -173.594 381.568       -219.411 218.542 72.2562       0.0471229 -0.784273 0.618624   46.8536   3.67486
exp_2023_02_21_14 tiger 116 1477 rest_state 1677017434.382375 2023-02-21T22:10:34.382375+00:00 0.561706 0.375507 0.804682 -77.6198 -130.92 377.147 55.6592 -172.939 -102.927       -0.266558 0.0840369 0.960148       39.4418   4.02514  
exp_2023_02_21_14 tiger 116 1478 rest_state 1677017434.3904443 2023-02-21T22:10:34.390444+00:00 0.414212 0.360932 0.835387 -88.0066 -143.633 375.091 55.6592 -172.939 -102.927       -0.287332 0.0586109 0.956036       42.1207   4.30595  
exp_2023_02_21_14 tiger 116 1479 rest_state 1677017434.3985136 2023-02-21T22:10:34.398514+00:00 0.365409 0.358459 0.807543 -88.6256 -131.807 374.032 55.6592 -172.939 -102.927       -0.28857 0.0822641 0.953918       40.3813   4.12184  
exp_2023_02_21_14 tiger 116 1480 rest_state 1677017434.4065826 2023-02-21T22:10:34.406583+00:00 0.261252 0.399816 0.554201 -56.5073 -35.6399 364.585 55.6592 -172.939 -102.927       -0.224333 0.274598 0.935024       43.0533   4.37682  
exp_2023_02_21_14 tiger 116 1481 rest_state 1677017434.382988 2023-02-21T22:10:34.382988+00:00 0.719537 0.367396 0.820512 -86.6803 -142.951 391.168       -219.411 218.542 72.2562       0.265462 -0.722987 0.637824   33.3632   2.57691
exp_2023_02_21_14 tiger 116 1482 rest_state 1677017434.3910573 2023-02-21T22:10:34.391057+00:00 0.761466 0.375424 0.771379 -83.0099 -126.848 407.07       -219.411 218.542 72.2562       0.272803 -0.690781 0.669627   28.5837   2.19229
exp_2023_02_21_14 tiger 116 1483 rest_state 1677017434.4071958 2023-02-21T22:10:34.407196+00:00 0.355188 0.370605 0.654614 -92.5951 -86.8781 447.271       -219.411 218.542 72.2562       0.253632 -0.610841 0.750029   52.6411   4.03703
exp_2023_02_21_14 tiger 116 1484 rest_state 1677017434.4152648 2023-02-21T22:10:34.415265+00:00 0.229815 0.364784 0.623456 -99.0665 -75.3862 458.421       -219.411 218.542 72.2562       0.24069 -0.587857 0.772329   54.6415   4.17003
exp_2023_02_21_14 tiger 116 1485 rest_state 1677017434.4227211 2023-02-21T22:10:34.422721+00:00 0.213298 0.360128 0.542405 -79.3825 -31.3627 357.204 55.6592 -172.939 -102.927       -0.270083 0.283152 0.920261       45.2371   4.60128  
exp_2023_02_21_14 tiger 116 1486 rest_state 1677017434.4307907 2023-02-21T22:10:34.430791+00:00 0.18162 0.469445 0.691318 -15.9199 -86.8688 384.381 55.6592 -172.939 -102.927       -0.143158 0.17214 0.974615       40.475   4.12879  
exp_2023_02_21_14 tiger 116 1487 rest_state 1677017434.43886 2023-02-21T22:10:34.438860+00:00 0.154806 0.289555 0.636834 -124.129 -64.3558 350.82 55.6592 -172.939 -102.927       -0.359576 0.217166 0.907493       41.3247   4.20497  
exp_2023_02_21_14 tiger 116 1488 rest_state 1677017434.4469292 2023-02-21T22:10:34.446929+00:00 0.155909 0.431456 0.648381 -39.1244 -69.94 377.081 55.6592 -172.939 -102.927       -0.189567 0.205998 0.960015       41.5731   4.23339  
exp_2023_02_21_14 tiger 116 1489 rest_state 1677017434.4549985 2023-02-21T22:10:34.454998+00:00 0.155973 0.430462 0.601191 -39.0624 -52.5491 373.029 55.6592 -172.939 -102.927       -0.189443 0.240779 0.951912       41.3503   4.20664  
exp_2023_02_21_14 tiger 116 1490 rest_state 1677017434.4630675 2023-02-21T22:10:34.463068+00:00 0.166607 0.516234 0.612434 13.4908 -57.5468 381.745 55.6592 -172.939 -102.927       -0.0843368 0.230784 0.969343       44.1141   4.50842  
exp_2023_02_21_14 tiger 116 1491 rest_state 1677017434.4711368 2023-02-21T22:10:34.471137+00:00 0.150107 0.516498 0.596816 13.5794 -51.7896 380.346 55.6592 -172.939 -102.927       -0.0841597 0.242298 0.966545       44.9234   4.59154  
exp_2023_02_21_14 tiger 116 1492 rest_state 1677017434.479206 2023-02-21T22:10:34.479206+00:00 0.123164 0.516534 0.596959 13.6024 -51.8422 380.361 55.6592 -172.939 -102.927       -0.0841136 0.242193 0.966575       45.0899   4.6089  
exp_2023_02_21_14 tiger 116 1493 rest_state 1677017434.4872763 2023-02-21T22:10:34.487276+00:00 0.129823 0.516532 0.597055 13.6018 -51.8776 380.37 55.6592 -172.939 -102.927       -0.0841148 0.242122 0.966593       45.8336   4.68644  
exp_2023_02_21_14 tiger 116 1494 rest_state 1677017434.4953456 2023-02-21T22:10:34.495346+00:00 0.124023 0.440279 0.601091 -33.1326 -52.6012 374.184 55.6592 -172.939 -102.927       -0.177584 0.240675 0.954222       42.6088   4.33754  
exp_2023_02_21_14 tiger 116 1495 rest_state 1677017434.4233341 2023-02-21T22:10:34.423334+00:00 0.76946 0.238334 0.387751 -241.446 32.0051 535.633       -219.411 218.542 72.2562       -0.0440703 -0.373074 0.926754   16.8481   1.20938
exp_2023_02_21_14 tiger 116 1496 rest_state 1677017434.5034149 2023-02-21T22:10:34.503415+00:00 0.122252 0.374028 0.624202 -73.417 -60.4085 366.835 55.6592 -172.939 -102.927       -0.258152 0.225061 0.939524       41.3731   4.20763  
exp_2023_02_21_14 tiger 116 1497 rest_state 1677017434.5114844 2023-02-21T22:10:34.511484+00:00 0.145183 0.40431 0.667946 -56.1109 -76.9793 374.88 55.6592 -172.939 -102.927       -0.22354 0.191919 0.955613       41.8795   4.26446  
exp_2023_02_21_14 tiger 116 1498 rest_state 1677017434.4314036 2023-02-21T22:10:34.431404+00:00 0.159684 0.327124 0.655037 -129.453 -90.1005 455.202       -219.411 218.542 72.2562       0.179917 -0.617286 0.765891   53.643   4.09272
exp_2023_02_21_14 tiger 116 1499 rest_state 1677017434.5195534 2023-02-21T22:10:34.519553+00:00 0.187282 0.469164 0.583685 -15.4789 -46.5683 375.581 55.6592 -172.939 -102.927       -0.142276 0.252741 0.957016       42.9775   4.37858  
exp_2023_02_21_14 tiger 116 1500 rest_state 1677017434.439473 2023-02-21T22:10:34.439473+00:00 0.150495 0.451036 0.669268 -30.117 -86.2085 420.53       -219.411 218.542 72.2562       0.378589 -0.609501 0.696548   50.4542   3.92603
exp_2023_02_21_14 tiger 116 1501 rest_state 1677017434.4475422 2023-02-21T22:10:34.447542+00:00 0.128892 0.336248 0.789936 -112.659 -136.987 407.224       -219.411 218.542 72.2562       0.213505 -0.711058 0.669935   52.6482   4.1059
exp_2023_02_21_14 tiger 116 1502 rest_state 1677017434.4556115 2023-02-21T22:10:34.455611+00:00 0.142902 0.352535 0.787873 -99.8734 -134.551 405.477       -219.411 218.542 72.2562       0.239076 -0.706187 0.66644   50.7306   3.95957
exp_2023_02_21_14 tiger 116 1503 rest_state 1677017434.4636805 2023-02-21T22:10:34.463681+00:00 0.123043 0.304529 0.750375 -141.804 -127.021 425.191       -219.411 218.542 72.2562       0.155216 -0.691126 0.70587   53.9269   4.16866
exp_2023_02_21_14 tiger 116 1504 rest_state 1677017434.4717498 2023-02-21T22:10:34.471750+00:00 0.164692 0.324772 0.709213 -127.646 -110.547 437.331       -219.411 218.542 72.2562       0.183531 -0.658178 0.730149   55.1682   4.24567
exp_2023_02_21_14 tiger 116 1505 rest_state 1677017434.47982 2023-02-21T22:10:34.479820+00:00 0.126985 0.461428 0.863846 -20.303 -143.488 353.842       -219.411 218.542 72.2562       0.398217 -0.72406 0.563171   50.33   4.02477
exp_2023_02_21_14 tiger 116 1506 rest_state 1677017434.4878893 2023-02-21T22:10:34.487889+00:00 0.152465 0.439634 0.850041 -34.5984 -142.587 364.54       -219.411 218.542 72.2562       0.369626 -0.722259 0.584567   48.7269   3.87651
exp_2023_02_21_14 tiger 116 1507 rest_state 1677017434.4959586 2023-02-21T22:10:34.495959+00:00 0.769494 0.214847 0.276289 -280.942 97.1426 553.376       -219.411 218.542 72.2562       -0.123062 -0.242799 0.962239   24.4246   1.77922
exp_2023_02_21_14 tiger 116 1508 rest_state 1677017434.504028 2023-02-21T22:10:34.504028+00:00 0.26501 0.500874 0.631515 4.28011 -69.8061 414.042       -219.411 218.542 72.2562       0.447383 -0.576697 0.683571   52.6668   4.12035
exp_2023_02_21_14 tiger 116 1509 rest_state 1677017434.5120974 2023-02-21T22:10:34.512097+00:00 0.20488 0.464767 0.706522 -19.9419 -97.4505 404.462       -219.411 218.542 72.2562       0.398939 -0.631986 0.664411   52.6827   4.13219
exp_2023_02_21_14 tiger 116 1510 rest_state 1677017434.5282357 2023-02-21T22:10:34.528236+00:00 0.256131 0.0490896 0.214086 -500.803 148.004 479.495       -219.411 218.542 72.2562       -0.562783 -0.141076 0.814477   51.5128   3.83519
exp_2023_02_21_14 tiger 116 1511 rest_state 1677017434.536305 2023-02-21T22:10:34.536305+00:00 0.306985 0.0827972 0.32663 -436.324 72.4038 498.393       -219.411 218.542 72.2562       -0.433826 -0.292277 0.852273   52.6248   3.87158
exp_2023_02_21_14 tiger 116 1512 rest_state 1677017434.5443742 2023-02-21T22:10:34.544374+00:00 0.284739 0.0827277 0.326405 -436.453 72.547 498.376       -219.411 218.542 72.2562       -0.434084 -0.291991 0.85224   53.2382   3.91728
exp_2023_02_21_14 tiger 116 1513 rest_state 1677017434.5524435 2023-02-21T22:10:34.552444+00:00 0.290046 0.0827149 0.326222 -436.503 72.6625 498.391       -219.411 218.542 72.2562       -0.434183 -0.29176 0.852269   55.7064   4.10123
exp_2023_02_21_14 tiger 116 1514 rest_state 1677017434.5605128 2023-02-21T22:10:34.560513+00:00 0.329574 0.0813299 0.346746 -434.553 59.9438 494.821       -219.411 218.542 72.2562       -0.430283 -0.317197 0.845129   54.4105   4.00756
exp_2023_02_21_14 tiger 116 1515 rest_state 1677017434.568582 2023-02-21T22:10:34.568582+00:00 0.276898 0.152077 0.268455 -358.246 105.763 539.167       -219.411 218.542 72.2562       -0.27767 -0.225558 0.933822   57.4873   4.19375
exp_2023_02_21_14 tiger 116 1516 rest_state 1677017434.576651 2023-02-21T22:10:34.576651+00:00 0.25037 0.152526 0.30157 -352.847 85.0736 535.269       -219.411 218.542 72.2562       -0.266872 -0.266937 0.926026   55.6766   4.05563
exp_2023_02_21_14 tiger 116 1517 rest_state 1677017434.5847206 2023-02-21T22:10:34.584721+00:00 0.278177 0.147346 0.319318 -356.59 74.4297 530.965       -219.411 218.542 72.2562       -0.274357 -0.288225 0.917417   57.1094   4.16177
exp_2023_02_21_14 tiger 116 1518 rest_state 1677017434.5276227 2023-02-21T22:10:34.527623+00:00 0.766958 0.366821 0.362161 -71.0702 26.9233 337.522 55.6592 -172.939 -102.927       -0.253459 0.399724 0.880897       13.8358   1.38063  
exp_2023_02_21_14 tiger 116 1519 rest_state 1677017434.535692 2023-02-21T22:10:34.535692+00:00 0.210515 0.488794 0.550965 -3.47748 -35.0533 374.033 55.6592 -172.939 -102.927       -0.118273 0.275771 0.953919       42.9254   4.37494  
exp_2023_02_21_14 tiger 116 1520 rest_state 1677017434.5437613 2023-02-21T22:10:34.543761+00:00 0.281993 0.295726 0.588538 -118.392 -47.0931 348.592 55.6592 -172.939 -102.927       -0.348101 0.251691 0.903038       43.1031   4.38645  
exp_2023_02_21_14 tiger 116 1521 rest_state 1677017434.5518305 2023-02-21T22:10:34.551831+00:00 0.357624 0.314658 0.585221 -107.22 -46.0241 352.445 55.6592 -172.939 -102.927       -0.325758 0.253829 0.910743       43.7124   4.44829  
exp_2023_02_21_14 tiger 116 1522 rest_state 1677017434.5598998 2023-02-21T22:10:34.559900+00:00 0.224375 0.488539 0.63108 -3.73818 -64.1579 381.468 55.6592 -172.939 -102.927       -0.118795 0.217562 0.96879       41.4603   4.22859  
exp_2023_02_21_14 tiger 116 1523 rest_state 1677017434.5679688 2023-02-21T22:10:34.567969+00:00 0.320695 0.294711 0.572581 -118.311 -41.5027 347.028 55.6592 -172.939 -102.927       -0.34794 0.262872 0.899909       43.8549   4.46374  
exp_2023_02_21_14 tiger 116 1524 rest_state 1677017434.5760381 2023-02-21T22:10:34.576038+00:00 0.223439 0.479277 0.662782 -9.59935 -76.0139 383.228 55.6592 -172.939 -102.927       -0.130517 0.19385 0.97231       41.7152   4.25599  
exp_2023_02_21_14 tiger 116 1525 rest_state 1677017434.5841076 2023-02-21T22:10:34.584108+00:00 0.422476 0.313836 0.569462 -107.099 -40.5042 350.913 55.6592 -172.939 -102.927       -0.325517 0.264869 0.90768       43.7945   4.45625  
exp_2023_02_21_14 tiger 116 1526 rest_state 1677017434.592177 2023-02-21T22:10:34.592177+00:00 0.427294 0.323463 0.568011 -101.459 -40.0453 352.763 55.6592 -172.939 -102.927       -0.314236 0.265787 0.91138       43.7683   4.45284  
exp_2023_02_21_14 tiger 116 1527 rest_state 1677017434.6002462 2023-02-21T22:10:34.600246+00:00 0.422541 0.323528 0.568194 -101.428 -40.1094 352.792 55.6592 -172.939 -102.927       -0.314174 0.265659 0.911438       43.3487   4.40953  
exp_2023_02_21_14 tiger 116 1528 rest_state 1677017434.6083155 2023-02-21T22:10:34.608315+00:00 0.423154 0.323585 0.568324 -101.4 -40.1551 352.816 55.6592 -172.939 -102.927       -0.314118 0.265567 0.911485       43.7422   4.45016  
exp_2023_02_21_14 tiger 116 1529 rest_state 1677017434.59279 2023-02-21T22:10:34.592790+00:00 0.719648 0.351864 0.563172 -113.637 -51.6088 479.479       -219.411 218.542 72.2562       0.211548 -0.540302 0.814445   48.5393   3.67454
exp_2023_02_21_14 tiger 116 1530 rest_state 1677017434.6089284 2023-02-21T22:10:34.608928+00:00 0.275031 0.141959 0.336574 -360.588 64.1774 526.393       -219.411 218.542 72.2562       -0.282354 -0.30873 0.908274   58.5191   4.26836
exp_2023_02_21_14 tiger 116 1531 rest_state 1677017434.6405923 2023-02-21T22:10:34.640592+00:00 0.578295 0.332545 0.550984 -95.6078 -34.1931 352.999 55.6592 -172.939 -102.927       -0.302534 0.277491 0.911851       42.6446   4.33557  
exp_2023_02_21_14 tiger 116 1532 rest_state 1677017434.6648014 2023-02-21T22:10:34.664801+00:00 0.56473 0.343261 0.566492 -89.8955 -39.6162 356.463 55.6592 -172.939 -102.927       -0.29111 0.266645 0.918779       42.7271   4.34418  
exp_2023_02_21_14 tiger 116 1533 rest_state 1677017434.6728706 2023-02-21T22:10:34.672871+00:00 0.549128 0.333668 0.568031 -95.5289 -40.1031 354.781 55.6592 -172.939 -102.927       -0.302376 0.265671 0.915417       43.9164   4.4675  
exp_2023_02_21_14 tiger 116 1534 rest_state 1677017434.657345 2023-02-21T22:10:34.657345+00:00 0.909284 0.3639 0.529195 -104.856 -36.6527 486.513       -219.373 218.573 72.0911       0.229034 -0.510451 0.828845   49.9969   3.8243
exp_2023_02_21_14 tiger 116 1535 rest_state 1677017434.689009 2023-02-21T22:10:34.689009+00:00 0.521357 0.333783 0.568313 -95.4717 -40.2021 354.829 55.6592 -172.939 -102.927       -0.302262 0.265473 0.915512       44.4069   4.51819  
exp_2023_02_21_14 tiger 116 1536 rest_state 1677017434.6970782 2023-02-21T22:10:34.697078+00:00 0.547249 0.353927 0.581965 -84.1367 -45.1033 359.799 55.6592 -172.939 -102.927       -0.279592 0.255671 0.925452       44.5378   4.53158  
exp_2023_02_21_14 tiger 116 1537 rest_state 1677017434.7051475 2023-02-21T22:10:34.705148+00:00 0.533504 0.333903 0.568623 -95.4122 -40.3105 354.88 55.6592 -172.939 -102.927       -0.302143 0.265256 0.915614       44.4822   4.52598  
exp_2023_02_21_14 tiger 116 1538 rest_state 1677017434.7132168 2023-02-21T22:10:34.713217+00:00 0.469846 0.35404 0.582255 -84.0793 -45.2064 359.845 55.6592 -172.939 -102.927       -0.279477 0.255465 0.925543       44.8776   4.56675  
exp_2023_02_21_14 tiger 116 1539 rest_state 1677017434.721286 2023-02-21T22:10:34.721286+00:00 0.444757 0.344503 0.583777 -89.7195 -45.6853 358.237 55.6592 -172.939 -102.927       -0.290757 0.254507 0.922327       45.2058   4.60114  
exp_2023_02_21_14 tiger 116 1540 rest_state 1677017434.729355 2023-02-21T22:10:34.729355+00:00 0.483251 0.363786 0.58128 -78.3264 -44.9231 361.465 55.6592 -172.939 -102.927       -0.267971 0.256031 0.928784       44.4677   4.52409  
exp_2023_02_21_14 tiger 116 1541 rest_state 1677017434.7374246 2023-02-21T22:10:34.737425+00:00 0.431084 0.363845 0.581437 -78.2959 -44.979 361.489 55.6592 -172.939 -102.927       -0.26791 0.255919 0.928832       44.4606   4.52336  
exp_2023_02_21_14 tiger 116 1542 rest_state 1677017434.745494 2023-02-21T22:10:34.745494+00:00 0.442461 0.36391 0.581612 -78.2625 -45.0413 361.516 55.6592 -172.939 -102.927       -0.267843 0.255795 0.928886       44.1933   4.49574  
exp_2023_02_21_14 tiger 116 1543 rest_state 1677017434.7535632 2023-02-21T22:10:34.753563+00:00 0.442588 0.344747 0.584415 -89.5965 -45.9123 358.338 55.6592 -172.939 -102.927       -0.290512 0.254053 0.922529       44.9937   4.57921  
exp_2023_02_21_14 tiger 116 1544 rest_state 1677017434.7616324 2023-02-21T22:10:34.761632+00:00 0.443745 0.373661 0.580661 -72.4978 -44.7678 363.065 55.6592 -172.939 -102.927       -0.256314 0.256342 0.931983       44.5399   4.53146  
exp_2023_02_21_14 tiger 116 1545 rest_state 1677017434.681553 2023-02-21T22:10:34.681553+00:00 0.93712 0.353218 0.524052 -114.693 -34.711 490.289       -219.373 218.573 72.0911       0.209361 -0.506567 0.836396   50.3202   3.85662
exp_2023_02_21_14 tiger 116 1546 rest_state 1677017434.7697017 2023-02-21T22:10:34.769702+00:00 0.481919 0.364088 0.582083 -78.171 -45.2089 361.589 55.6592 -172.939 -102.927       -0.26766 0.25546 0.929031       44.1929   4.49573  
exp_2023_02_21_14 tiger 116 1547 rest_state 1677017434.689622 2023-02-21T22:10:34.689622+00:00 0.901888 0.342228 0.539011 -123.725 -41.5852 488.227       -219.373 218.573 72.0911       0.191297 -0.520316 0.832272   50.5364   3.87614
exp_2023_02_21_14 tiger 116 1548 rest_state 1677017434.7777708 2023-02-21T22:10:34.777771+00:00 0.461682 0.37378 0.580979 -72.436 -44.8811 363.113 55.6592 -172.939 -102.927       -0.25619 0.256115 0.932079       44.49   4.52632  
exp_2023_02_21_14 tiger 116 1549 rest_state 1677017434.6976912 2023-02-21T22:10:34.697691+00:00 0.972105 0.340983 0.562805 -123.33 -51.8763 481.521       -219.373 218.573 72.0911       0.192087 -0.540898 0.81886   50.4793   3.86988
exp_2023_02_21_14 tiger 116 1550 rest_state 1677017434.7057605 2023-02-21T22:10:34.705760+00:00 0.89856 0.352957 0.55138 -113.322 -46.5488 482.534       -219.373 218.573 72.0911       0.212103 -0.530243 0.820887   50.6056   3.8791
exp_2023_02_21_14 tiger 116 1551 rest_state 1677017434.7138298 2023-02-21T22:10:34.713830+00:00 0.884576 0.366376 0.540636 -102.061 -41.4953 482.704       -219.373 218.573 72.0911       0.234624 -0.520136 0.821225   50.6203   3.8793
exp_2023_02_21_14 tiger 116 1552 rest_state 1677017434.721899 2023-02-21T22:10:34.721899+00:00 0.914389 0.375369 0.536699 -94.4103 -39.5242 481.689       -219.373 218.573 72.0911       0.249926 -0.516194 0.819195   50.6081   3.87756
exp_2023_02_21_14 tiger 116 1553 rest_state 1677017434.7299683 2023-02-21T22:10:34.729968+00:00 0.881183 0.380665 0.535937 -89.864 -39.0323 480.585       -219.373 218.573 72.0911       0.259018 -0.51521 0.816987   50.6177   3.87779
exp_2023_02_21_14 tiger 116 1554 rest_state 1677017434.7380376 2023-02-21T22:10:34.738038+00:00 0.961186 0.383744 0.537786 -87.1329 -39.7159 479.276       -219.373 218.573 72.0911       0.264481 -0.516577 0.81437   50.3769   3.85895
exp_2023_02_21_14 tiger 116 1555 rest_state 1677017434.7461069 2023-02-21T22:10:34.746107+00:00 0.99523 0.386898 0.53857 -84.401 -39.9439 478.233       -219.373 218.573 72.0911       0.269944 -0.517033 0.812285   50.3212   3.85472
exp_2023_02_21_14 tiger 116 1556 rest_state 1677017434.7541761 2023-02-21T22:10:34.754176+00:00 0.867332 0.387168 0.538855 -84.1574 -40.0551 478.082       -219.373 218.573 72.0911       0.270432 -0.517255 0.811981   50.234   3.84855
exp_2023_02_21_14 tiger 116 1557 rest_state 1677017434.7622454 2023-02-21T22:10:34.762245+00:00 0.95568 0.388707 0.539335 -82.827 -40.2061 477.54       -219.373 218.573 72.0911       0.273092 -0.517558 0.810897   50.2141   3.84661
exp_2023_02_21_14 tiger 116 1558 rest_state 1677017434.7939093 2023-02-21T22:10:34.793909+00:00 0.381488 0.351895 0.695797 -88.9361 -86.9573 367.923 55.6592 -172.939 -102.927       -0.289191 0.171963 0.941699       43.6233   4.44531  
exp_2023_02_21_14 tiger 116 1559 rest_state 1677017434.8019786 2023-02-21T22:10:34.801979+00:00 0.399684 0.327466 0.730756 -105.215 -100.229 364.869 55.6592 -172.939 -102.927       -0.321749 0.14542 0.935591       43.7465   4.46111  
exp_2023_02_21_14 tiger 116 1560 rest_state 1677017434.7864542 2023-02-21T22:10:34.786454+00:00 0.94181 0.391499 0.53793 -80.5159 -39.5253 477.189       -219.373 218.573 72.0911       0.277715 -0.516196 0.810195   49.9295   3.82338
exp_2023_02_21_14 tiger 116 1561 rest_state 1677017434.8181183 2023-02-21T22:10:34.818118+00:00 0.354427 0.336627 0.729632 -99.5007 -99.8845 366.681 55.7122 -172.989 -102.962       -0.310426 0.146209 0.939286       44.3587   4.53437  
exp_2023_02_21_14 tiger 116 1562 rest_state 1677017434.834257 2023-02-21T22:10:34.834257+00:00 0.428414 0.383325 0.752712 -71.1512 -109.727 376.521 55.7122 -172.989 -102.962       -0.253727 0.126524 0.958965       44.3666   4.53932  
exp_2023_02_21_14 tiger 116 1563 rest_state 1677017434.842326 2023-02-21T22:10:34.842326+00:00 0.40267 0.388328 0.824547 -69.9234 -139.537 379.839 55.7122 -172.989 -102.962       -0.251271 0.0669045 0.965602       45.8458   4.7044  
exp_2023_02_21_14 tiger 116 1564 rest_state 1677017434.8503952 2023-02-21T22:10:34.850395+00:00 0.408587 0.400983 0.878595 -63.0589 -163.362 382.631 55.7122 -172.989 -102.962       -0.237542 0.0192539 0.971186       44.7774   4.60302  
exp_2023_02_21_14 tiger 116 1565 rest_state 1677017434.8268006 2023-02-21T22:10:34.826801+00:00 0.99 0.398722 0.588007 -72.49 -59.5994 460.737       -219.373 218.573 72.0911       0.293766 -0.556344 0.777292   48.394   3.74475
exp_2023_02_21_14 tiger 116 1566 rest_state 1677017434.8348699 2023-02-21T22:10:34.834870+00:00 0.99 0.402967 0.640858 -67.0896 -79.5174 443.51       -219.373 218.573 72.0911       0.304567 -0.59618 0.742838   47.5642   3.71218
exp_2023_02_21_14 tiger 116 1567 rest_state 1677017434.8665338 2023-02-21T22:10:34.866534+00:00 0.585567 0.417818 0.877566 -51.8288 -163.335 385.241 55.7122 -172.989 -102.962       -0.215082 0.0193084 0.976405       38.604   3.96007  
exp_2023_02_21_14 tiger 116 1568 rest_state 1677017441.031489 2023-02-21T22:10:41.031489+00:00 0.585288 0.466231 0.897717 -19.4717 -174.046 391.816 55.4291 -172.701 -102.54       -0.149802 -0.00268984 0.988712       39.849   4.02597  
exp_2023_02_21_14 tiger 116 1569 rest_state 1677017441.0476274 2023-02-21T22:10:41.047627+00:00 0.349986 0.433908 0.716733 -38.6313 -96.3695 382.564 55.4291 -172.701 -102.54       -0.188121 0.152664 0.970208       41.9175   4.20695  
exp_2023_02_21_14 tiger 116 1570 rest_state 1677017441.055697 2023-02-21T22:10:41.055697+00:00 0.316166 0.47068 0.728831 -15.3734 -101.829 387.321 55.4291 -172.701 -102.54       -0.141605 0.141744 0.979723       39.82   3.99996  
exp_2023_02_21_14 tiger 116 1571 rest_state 1677017441.0637662 2023-02-21T22:10:41.063766+00:00 0.263037 0.515373 0.755268 13.6684 -113.515 392.185 55.4291 -172.701 -102.54       -0.0835215 0.118373 0.98945       41.5874   4.1922  
exp_2023_02_21_14 tiger 116 1572 rest_state 1677017441.0718365 2023-02-21T22:10:41.071836+00:00 0.300574 0.439966 0.526764 -32.5044 -26.3822 367.416 55.4291 -172.701 -102.54       -0.175867 0.292638 0.939912       42.7273   4.2749  
exp_2023_02_21_14 tiger 116 1573 rest_state 1677017441.0799055 2023-02-21T22:10:41.079906+00:00 0.304908 0.539413 0.491582 26.9083 -14.6826 370.975 55.4291 -172.701 -102.54       -0.0570416 0.316037 0.94703       43.4102   4.36467  
exp_2023_02_21_14 tiger 116 1574 rest_state 1677017441.0879748 2023-02-21T22:10:41.087975+00:00 0.311049 0.539152 0.508232 26.9043 -20.4199 372.851 55.4291 -172.701 -102.54       -0.0570496 0.304563 0.950782       41.3282   4.1526  
exp_2023_02_21_14 tiger 116 1575 rest_state 1677017441.096044 2023-02-21T22:10:41.096044+00:00 0.301155 0.470316 0.475527 -14.2525 -9.08729 364.766 55.4291 -172.701 -102.54       -0.139363 0.327228 0.934612       42.0592   4.21031  

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