Column descriptions

group_session
The group session ID
player_1_id
Player 1's participant ID
player_2_id
Player 2's participant ID
player_3_id
Player 3's participant ID
timestamp_unix
Unix timestamp of the observation
timestamp_iso8601
ISO-8601 timestamp of the observation.
task_started
Whether the task has started (1) or not (0).
seconds
The number of seconds left in the game (not shown to participants).
ball_position_x
The x-coordinate of the ball.
ball_position_y
The y-coordinate of the ball.
player_1_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 1's paddle.
player_1_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 1's paddle.
player_2_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 2's paddle.
player_2_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 2's paddle.
player_3_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 3's paddle.
player_3_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 3's paddle.
ai_paddle_position_x
The x-coordinate of the pixel at the top left corner of the AI player's paddle.
ai_paddle_position_y
The y-coordinate of the pixel at the top left corner of the AI player's paddle.
team_score
The team's score.
ai_score
The score of the AI player.

where group_session = "exp_2023_02_07_14"

View and edit SQL

Suggested facets: team_score, ai_score, timestamp_iso8601 (date)

Link group_session player_1_id player_2_id player_3_id timestamp_unix timestamp_iso8601 task_started seconds ball_position_x ball_position_y player_1_paddle_position_x player_1_paddle_position_y player_2_paddle_position_x player_2_paddle_position_y player_3_paddle_position_x player_3_paddle_position_y ai_paddle_position_x ai_paddle_position_y team_score ai_score
exp_2023_02_07_14 97 111 99910 1675808918.7788088 2023-02-07T22:28:38.778809+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_02_07_14 97 111 99910 1675808918.7946045 2023-02-07T22:28:38.794605+00:00 1 10 1285 725 880 470 880 503 880 789 1660 645 0 0
exp_2023_02_07_14 97 111 99910 1675808918.810828 2023-02-07T22:28:38.810828+00:00 1 10 1285 725 880 470 880 503 880 789 1660 657 0 0
exp_2023_02_07_14 97 111 99910 1675808918.8270302 2023-02-07T22:28:38.827030+00:00 1 10 1285 725 880 470 880 503 880 789 1660 669 0 0
exp_2023_02_07_14 97 111 99910 1675808918.843215 2023-02-07T22:28:38.843215+00:00 1 10 1285 725 880 470 880 503 880 789 1660 678 0 0
exp_2023_02_07_14 97 111 99910 1675808918.8594341 2023-02-07T22:28:38.859434+00:00 1 10 1285 725 880 470 880 503 880 789 1660 682 0 0
exp_2023_02_07_14 97 111 99910 1675808918.8746054 2023-02-07T22:28:38.874605+00:00 1 10 1285 725 880 470 880 503 880 789 1660 682 0 0
exp_2023_02_07_14 97 111 99910 1675808918.8907795 2023-02-07T22:28:38.890779+00:00 1 10 1285 725 880 470 880 503 880 789 1660 683 0 0
exp_2023_02_07_14 97 111 99910 1675808918.9069989 2023-02-07T22:28:38.906999+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808918.923209 2023-02-07T22:28:38.923209+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808918.9394062 2023-02-07T22:28:38.939406+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808918.9545896 2023-02-07T22:28:38.954590+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808918.9707656 2023-02-07T22:28:38.970766+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808918.9869444 2023-02-07T22:28:38.986944+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.003138 2023-02-07T22:28:39.003138+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.0192842 2023-02-07T22:28:39.019284+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.03543 2023-02-07T22:28:39.035430+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.0506074 2023-02-07T22:28:39.050607+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.0667906 2023-02-07T22:28:39.066791+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.0829678 2023-02-07T22:28:39.082968+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.099137 2023-02-07T22:28:39.099137+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.1153064 2023-02-07T22:28:39.115306+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.1314821 2023-02-07T22:28:39.131482+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.1466577 2023-02-07T22:28:39.146658+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.1628335 2023-02-07T22:28:39.162833+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.1790102 2023-02-07T22:28:39.179010+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.1951928 2023-02-07T22:28:39.195193+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.2113767 2023-02-07T22:28:39.211377+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.2275622 2023-02-07T22:28:39.227562+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.243768 2023-02-07T22:28:39.243768+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.2600412 2023-02-07T22:28:39.260041+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.2763124 2023-02-07T22:28:39.276312+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.2925944 2023-02-07T22:28:39.292594+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.3088589 2023-02-07T22:28:39.308859+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.3251007 2023-02-07T22:28:39.325101+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.341331 2023-02-07T22:28:39.341331+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.3575845 2023-02-07T22:28:39.357584+00:00 1 10 1285 725 880 470 880 503 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.3738198 2023-02-07T22:28:39.373820+00:00 1 10 1285 725 880 470 880 725 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.3900537 2023-02-07T22:28:39.390054+00:00 1 10 1285 725 880 470 880 724 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.4063382 2023-02-07T22:28:39.406338+00:00 1 10 1285 725 880 470 880 723 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.4216158 2023-02-07T22:28:39.421616+00:00 1 10 1285 725 880 470 880 722 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.4378693 2023-02-07T22:28:39.437869+00:00 1 10 1285 725 880 470 880 721 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.4541078 2023-02-07T22:28:39.454108+00:00 1 10 1285 725 880 470 880 720 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.4703703 2023-02-07T22:28:39.470370+00:00 1 10 1285 725 880 470 880 720 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.4856422 2023-02-07T22:28:39.485642+00:00 1 10 1285 725 880 470 880 720 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.501924 2023-02-07T22:28:39.501924+00:00 1 10 1285 725 880 470 880 720 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.5182083 2023-02-07T22:28:39.518208+00:00 1 10 1285 725 880 470 880 720 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.534498 2023-02-07T22:28:39.534498+00:00 1 10 1285 725 880 470 880 719 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.5497878 2023-02-07T22:28:39.549788+00:00 1 10 1285 725 880 470 880 718 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.566044 2023-02-07T22:28:39.566044+00:00 1 10 1285 725 880 470 880 716 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.5823371 2023-02-07T22:28:39.582337+00:00 1 10 1285 725 880 470 880 714 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.598612 2023-02-07T22:28:39.598612+00:00 1 10 1285 725 880 470 880 713 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.6148903 2023-02-07T22:28:39.614890+00:00 1 10 1285 725 880 470 880 712 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.6311696 2023-02-07T22:28:39.631170+00:00 1 10 1285 725 880 470 880 712 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.6474493 2023-02-07T22:28:39.647449+00:00 1 10 1285 725 880 470 880 712 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.662723 2023-02-07T22:28:39.662723+00:00 1 10 1285 725 880 470 880 712 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.6789985 2023-02-07T22:28:39.678998+00:00 1 10 1285 725 880 470 880 712 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.695266 2023-02-07T22:28:39.695266+00:00 1 10 1285 725 880 470 880 712 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.7115357 2023-02-07T22:28:39.711536+00:00 1 10 1285 725 880 470 880 712 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.7267983 2023-02-07T22:28:39.726798+00:00 1 10 1285 725 880 470 880 713 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.7430758 2023-02-07T22:28:39.743076+00:00 1 10 1285 725 880 470 880 716 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.7593553 2023-02-07T22:28:39.759355+00:00 1 10 1285 725 880 470 880 721 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.7755911 2023-02-07T22:28:39.775591+00:00 1 10 1285 725 880 470 880 727 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.7917938 2023-02-07T22:28:39.791794+00:00 1 10 1285 725 880 470 880 739 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.8080282 2023-02-07T22:28:39.808028+00:00 1 9 1285 725 880 470 880 739 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.8242419 2023-02-07T22:28:39.824242+00:00 1 9 1285 725 880 470 880 741 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.8404882 2023-02-07T22:28:39.840488+00:00 1 9 1285 725 880 470 880 741 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.8557186 2023-02-07T22:28:39.855719+00:00 1 9 1285 725 880 536 880 740 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.8719935 2023-02-07T22:28:39.871994+00:00 1 9 1285 725 880 529 880 740 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.8882403 2023-02-07T22:28:39.888240+00:00 1 9 1285 725 880 522 880 735 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.9045117 2023-02-07T22:28:39.904512+00:00 1 9 1285 725 880 521 880 723 880 789 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.9197893 2023-02-07T22:28:39.919789+00:00 1 9 1285 725 880 519 880 714 880 758 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.936054 2023-02-07T22:28:39.936054+00:00 1 9 1285 725 880 517 880 710 880 750 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.952299 2023-02-07T22:28:39.952299+00:00 1 9 1285 725 880 516 880 701 880 731 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.96858 2023-02-07T22:28:39.968580+00:00 1 9 1285 725 880 515 880 688 880 731 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808919.9848826 2023-02-07T22:28:39.984883+00:00 1 9 1285 725 880 512 880 679 880 719 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.001108 2023-02-07T22:28:40.001108+00:00 1 9 1285 725 880 511 880 669 880 708 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.01738 2023-02-07T22:28:40.017380+00:00 1 9 1285 725 880 511 880 669 880 699 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.0326653 2023-02-07T22:28:40.032665+00:00 1 9 1285 725 880 510 880 658 880 693 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.0489085 2023-02-07T22:28:40.048908+00:00 1 9 1285 725 880 510 880 652 880 689 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.0651445 2023-02-07T22:28:40.065145+00:00 1 9 1285 725 880 510 880 648 880 685 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.081365 2023-02-07T22:28:40.081365+00:00 1 9 1285 725 880 510 880 646 880 683 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.0975745 2023-02-07T22:28:40.097574+00:00 1 9 1285 725 880 511 880 646 880 683 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.1137803 2023-02-07T22:28:40.113780+00:00 1 9 1285 725 880 519 880 646 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.1299818 2023-02-07T22:28:40.129982+00:00 1 9 1285 725 880 532 880 646 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.1461961 2023-02-07T22:28:40.146196+00:00 1 9 1285 725 880 560 880 646 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.162366 2023-02-07T22:28:40.162366+00:00 1 9 1285 725 880 586 880 646 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.1785772 2023-02-07T22:28:40.178577+00:00 1 9 1285 725 880 586 880 649 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.194796 2023-02-07T22:28:40.194796+00:00 1 9 1285 725 880 590 880 649 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.2110033 2023-02-07T22:28:40.211003+00:00 1 9 1285 725 880 600 880 652 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.2272503 2023-02-07T22:28:40.227250+00:00 1 9 1285 725 880 622 880 654 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.2434568 2023-02-07T22:28:40.243457+00:00 1 9 1285 725 880 627 880 657 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.25873 2023-02-07T22:28:40.258730+00:00 1 9 1285 725 880 648 880 660 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.2749727 2023-02-07T22:28:40.274973+00:00 1 9 1285 725 880 666 880 664 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.2912369 2023-02-07T22:28:40.291237+00:00 1 9 1285 725 880 670 880 670 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.307478 2023-02-07T22:28:40.307478+00:00 1 9 1285 725 880 670 880 679 880 682 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.3226984 2023-02-07T22:28:40.322698+00:00 1 9 1285 725 880 679 880 694 880 692 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.3388534 2023-02-07T22:28:40.338853+00:00 1 9 1285 725 880 688 880 694 880 710 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.3549926 2023-02-07T22:28:40.354993+00:00 1 9 1285 725 880 697 880 713 880 766 1660 684 0 0
exp_2023_02_07_14 97 111 99910 1675808920.371191 2023-02-07T22:28:40.371191+00:00 1 9 1285 725 880 697 880 726 880 793 1660 684 0 0

Next page

Advanced export

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

CSV options:

CREATE TABLE "ping_pong_cooperative_task_observation" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [player_1_id] INTEGER REFERENCES [participant]([id]),
   [player_2_id] INTEGER REFERENCES [participant]([id]),
   [player_3_id] INTEGER REFERENCES [participant]([id]),
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [task_started] INTEGER,
   [seconds] INTEGER,
   [ball_position_x] INTEGER,
   [ball_position_y] INTEGER,
   [player_1_paddle_position_x] INTEGER,
   [player_1_paddle_position_y] INTEGER,
   [player_2_paddle_position_x] INTEGER,
   [player_2_paddle_position_y] INTEGER,
   [player_3_paddle_position_x] INTEGER,
   [player_3_paddle_position_y] INTEGER,
   [ai_paddle_position_x] INTEGER,
   [ai_paddle_position_y] INTEGER,
   [team_score] INTEGER,
   [ai_score] INTEGER,
   PRIMARY KEY ([group_session], [player_1_id], [player_2_id], [player_3_id], [timestamp_unix])
);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_3_id]
    ON [ping_pong_cooperative_task_observation] ([player_3_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_2_id]
    ON [ping_pong_cooperative_task_observation] ([player_2_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_1_id]
    ON [ping_pong_cooperative_task_observation] ([player_1_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_group_session]
    ON [ping_pong_cooperative_task_observation] ([group_session]);