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 player_1_id = 39

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_2022_10_14_10 39 41 44 1665773661.5005932 2022-10-14T18:54:21.500593+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_10_14_10 39 41 44 1665773661.517501 2022-10-14T18:54:21.517501+00:00 1 10 1285 725 880 470 880 725 880 589 1660 633 0 0
exp_2022_10_14_10 39 41 44 1665773661.5326862 2022-10-14T18:54:21.532686+00:00 1 10 1285 725 880 470 880 725 880 589 1660 645 0 0
exp_2022_10_14_10 39 41 44 1665773661.548901 2022-10-14T18:54:21.548901+00:00 1 10 1285 725 880 470 880 725 880 589 1660 657 0 0
exp_2022_10_14_10 39 41 44 1665773661.565078 2022-10-14T18:54:21.565078+00:00 1 10 1285 725 880 470 880 725 880 589 1660 669 0 0
exp_2022_10_14_10 39 41 44 1665773661.5812533 2022-10-14T18:54:21.581253+00:00 1 10 1285 725 880 470 880 725 880 589 1660 669 0 0
exp_2022_10_14_10 39 41 44 1665773661.5974164 2022-10-14T18:54:21.597416+00:00 1 10 1285 725 880 470 880 725 880 589 1660 678 0 0
exp_2022_10_14_10 39 41 44 1665773661.6135821 2022-10-14T18:54:21.613582+00:00 1 10 1285 725 880 470 880 725 880 589 1660 682 0 0
exp_2022_10_14_10 39 41 44 1665773661.6297534 2022-10-14T18:54:21.629753+00:00 1 10 1285 725 880 470 880 725 880 589 1660 683 0 0
exp_2022_10_14_10 39 41 44 1665773661.6459172 2022-10-14T18:54:21.645917+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.6620839 2022-10-14T18:54:21.662084+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.6782544 2022-10-14T18:54:21.678254+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.6944368 2022-10-14T18:54:21.694437+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.7096436 2022-10-14T18:54:21.709644+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.7258382 2022-10-14T18:54:21.725838+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.742054 2022-10-14T18:54:21.742054+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.758221 2022-10-14T18:54:21.758221+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.7744117 2022-10-14T18:54:21.774412+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.7896066 2022-10-14T18:54:21.789607+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.8057816 2022-10-14T18:54:21.805782+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.8219645 2022-10-14T18:54:21.821965+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.8381288 2022-10-14T18:54:21.838129+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.8542922 2022-10-14T18:54:21.854292+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.8704839 2022-10-14T18:54:21.870484+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.885692 2022-10-14T18:54:21.885692+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.9018927 2022-10-14T18:54:21.901893+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.9180646 2022-10-14T18:54:21.918065+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.9342332 2022-10-14T18:54:21.934233+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.9504032 2022-10-14T18:54:21.950403+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.9665837 2022-10-14T18:54:21.966584+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.982775 2022-10-14T18:54:21.982775+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773661.998937 2022-10-14T18:54:21.998937+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.0151138 2022-10-14T18:54:22.015114+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.031316 2022-10-14T18:54:22.031316+00:00 1 10 1285 725 880 470 880 725 880 589 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.0474818 2022-10-14T18:54:22.047482+00:00 1 10 1285 725 880 470 880 725 880 647 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.0626585 2022-10-14T18:54:22.062659+00:00 1 10 1285 725 880 470 880 725 880 644 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.0788598 2022-10-14T18:54:22.078860+00:00 1 10 1285 725 880 470 880 725 880 641 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.0950274 2022-10-14T18:54:22.095027+00:00 1 10 1285 725 880 471 880 725 880 637 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.1112099 2022-10-14T18:54:22.111210+00:00 1 10 1285 725 880 471 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.1274111 2022-10-14T18:54:22.127411+00:00 1 10 1285 725 880 477 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.143587 2022-10-14T18:54:22.143587+00:00 1 10 1285 725 880 489 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.159773 2022-10-14T18:54:22.159773+00:00 1 10 1285 725 880 505 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.1759148 2022-10-14T18:54:22.175915+00:00 1 10 1285 725 880 528 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.19204 2022-10-14T18:54:22.192040+00:00 1 10 1285 725 880 546 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.2081769 2022-10-14T18:54:22.208177+00:00 1 10 1285 725 880 556 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.2243621 2022-10-14T18:54:22.224362+00:00 1 10 1285 725 880 578 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.240544 2022-10-14T18:54:22.240544+00:00 1 10 1285 725 880 583 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.255709 2022-10-14T18:54:22.255709+00:00 1 10 1285 725 880 583 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.271881 2022-10-14T18:54:22.271881+00:00 1 10 1285 725 880 587 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.2880375 2022-10-14T18:54:22.288038+00:00 1 10 1285 725 880 588 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.3042045 2022-10-14T18:54:22.304204+00:00 1 10 1285 725 880 588 880 725 880 635 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.3203864 2022-10-14T18:54:22.320386+00:00 1 10 1285 725 880 588 880 725 880 636 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.3365517 2022-10-14T18:54:22.336552+00:00 1 10 1285 725 880 587 880 725 880 640 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.3527243 2022-10-14T18:54:22.352724+00:00 1 10 1285 725 880 583 880 725 880 644 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.3688734 2022-10-14T18:54:22.368873+00:00 1 10 1285 725 880 577 880 725 880 648 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.3850393 2022-10-14T18:54:22.385039+00:00 1 10 1285 725 880 577 880 725 880 648 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.4012082 2022-10-14T18:54:22.401208+00:00 1 10 1285 725 880 577 880 744 880 652 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.4173656 2022-10-14T18:54:22.417366+00:00 1 10 1285 725 880 577 880 741 880 657 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.433544 2022-10-14T18:54:22.433544+00:00 1 10 1285 725 880 577 880 739 880 663 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.4486957 2022-10-14T18:54:22.448696+00:00 1 10 1285 725 880 577 880 738 880 672 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.4648595 2022-10-14T18:54:22.464859+00:00 1 10 1285 725 880 582 880 738 880 688 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.4810274 2022-10-14T18:54:22.481027+00:00 1 10 1285 725 880 590 880 736 880 701 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.4971802 2022-10-14T18:54:22.497180+00:00 1 10 1285 725 880 599 880 732 880 705 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.5133243 2022-10-14T18:54:22.513324+00:00 1 10 1285 725 880 599 880 729 880 706 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.5294898 2022-10-14T18:54:22.529490+00:00 1 9 1285 725 880 606 880 726 880 706 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.544659 2022-10-14T18:54:22.544659+00:00 1 9 1285 725 880 609 880 723 880 706 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.560843 2022-10-14T18:54:22.560843+00:00 1 9 1285 725 880 610 880 719 880 706 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.577025 2022-10-14T18:54:22.577025+00:00 1 9 1285 725 880 609 880 718 880 706 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.5932755 2022-10-14T18:54:22.593276+00:00 1 9 1285 725 880 595 880 718 880 706 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.6094935 2022-10-14T18:54:22.609493+00:00 1 9 1285 725 880 588 880 718 880 705 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.624697 2022-10-14T18:54:22.624697+00:00 1 9 1285 725 880 542 880 718 880 701 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.6409137 2022-10-14T18:54:22.640914+00:00 1 9 1285 725 880 542 880 718 880 697 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.6571205 2022-10-14T18:54:22.657120+00:00 1 9 1285 725 880 523 880 718 880 693 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.6733341 2022-10-14T18:54:22.673334+00:00 1 9 1285 725 880 501 880 718 880 687 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.6895566 2022-10-14T18:54:22.689557+00:00 1 9 1285 725 880 476 880 718 880 684 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.7047663 2022-10-14T18:54:22.704766+00:00 1 9 1285 725 880 470 880 718 880 684 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.7210455 2022-10-14T18:54:22.721045+00:00 1 9 1285 725 880 470 880 718 880 680 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.7372859 2022-10-14T18:54:22.737286+00:00 1 9 1285 725 880 470 880 719 880 674 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.7535498 2022-10-14T18:54:22.753550+00:00 1 9 1285 725 880 470 880 729 880 667 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.7688003 2022-10-14T18:54:22.768800+00:00 1 9 1285 725 880 470 880 739 880 663 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.7850327 2022-10-14T18:54:22.785033+00:00 1 9 1285 725 880 470 880 746 880 659 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.8012097 2022-10-14T18:54:22.801210+00:00 1 9 1285 725 880 470 880 776 880 657 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.8174021 2022-10-14T18:54:22.817402+00:00 1 9 1285 725 880 470 880 791 880 655 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.8336134 2022-10-14T18:54:22.833613+00:00 1 9 1285 725 880 470 880 791 880 652 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.8497958 2022-10-14T18:54:22.849796+00:00 1 9 1285 725 880 470 880 804 880 652 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.8659844 2022-10-14T18:54:22.865984+00:00 1 9 1285 725 880 470 880 815 880 652 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.882197 2022-10-14T18:54:22.882197+00:00 1 9 1285 725 880 470 880 824 880 652 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.8983872 2022-10-14T18:54:22.898387+00:00 1 9 1285 725 880 470 880 830 880 652 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.914587 2022-10-14T18:54:22.914587+00:00 1 9 1285 725 880 470 880 834 880 652 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.9307964 2022-10-14T18:54:22.930796+00:00 1 9 1285 725 880 470 880 841 880 652 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.9469826 2022-10-14T18:54:22.946983+00:00 1 9 1285 725 880 479 880 843 880 653 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.963191 2022-10-14T18:54:22.963191+00:00 1 9 1285 725 880 495 880 843 880 657 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.9794047 2022-10-14T18:54:22.979405+00:00 1 9 1285 725 880 495 880 844 880 663 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773662.995606 2022-10-14T18:54:22.995606+00:00 1 9 1285 725 880 496 880 847 880 672 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773663.011804 2022-10-14T18:54:23.011804+00:00 1 9 1285 725 880 500 880 848 880 682 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773663.0279863 2022-10-14T18:54:23.027986+00:00 1 9 1285 725 880 500 880 848 880 698 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773663.0441747 2022-10-14T18:54:23.044175+00:00 1 9 1285 725 880 500 880 848 880 712 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773663.0604873 2022-10-14T18:54:23.060487+00:00 1 9 1285 725 880 500 880 848 880 728 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773663.075716 2022-10-14T18:54:23.075716+00:00 1 9 1285 725 880 500 880 848 880 744 1660 684 0 0
exp_2022_10_14_10 39 41 44 1665773663.0919075 2022-10-14T18:54:23.091908+00:00 1 9 1285 725 880 494 880 848 880 744 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]);