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_2_id = 103

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_10_10 102 103 113 1676054987.5867605 2023-02-10T18:49:47.586761+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_02_10_10 102 103 113 1676054987.6025255 2023-02-10T18:49:47.602525+00:00 1 10 1285 725 880 556 880 730 880 719 1660 615 0 0
exp_2023_02_10_10 102 103 113 1676054987.6187181 2023-02-10T18:49:47.618718+00:00 1 10 1285 725 880 556 880 730 880 719 1660 627 0 0
exp_2023_02_10_10 102 103 113 1676054987.6349068 2023-02-10T18:49:47.634907+00:00 1 10 1285 725 880 556 880 730 880 719 1660 639 0 0
exp_2023_02_10_10 102 103 113 1676054987.6510832 2023-02-10T18:49:47.651083+00:00 1 10 1285 725 880 556 880 730 880 719 1660 651 0 0
exp_2023_02_10_10 102 103 113 1676054987.66727 2023-02-10T18:49:47.667270+00:00 1 10 1285 725 880 556 880 730 880 719 1660 663 0 0
exp_2023_02_10_10 102 103 113 1676054987.683451 2023-02-10T18:49:47.683451+00:00 1 10 1285 725 880 556 880 730 880 719 1660 675 0 0
exp_2023_02_10_10 102 103 113 1676054987.6996334 2023-02-10T18:49:47.699633+00:00 1 10 1285 725 880 556 880 730 880 719 1660 681 0 0
exp_2023_02_10_10 102 103 113 1676054987.7158217 2023-02-10T18:49:47.715822+00:00 1 10 1285 725 880 556 880 730 880 719 1660 683 0 0
exp_2023_02_10_10 102 103 113 1676054987.7320263 2023-02-10T18:49:47.732026+00:00 1 10 1285 725 880 556 880 730 880 719 1660 683 0 0
exp_2023_02_10_10 102 103 113 1676054987.7472115 2023-02-10T18:49:47.747211+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.7634325 2023-02-10T18:49:47.763433+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.7796638 2023-02-10T18:49:47.779664+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.795903 2023-02-10T18:49:47.795903+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.8111365 2023-02-10T18:49:47.811136+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.8273795 2023-02-10T18:49:47.827379+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.8436162 2023-02-10T18:49:47.843616+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.8598497 2023-02-10T18:49:47.859850+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.8760996 2023-02-10T18:49:47.876100+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.892371 2023-02-10T18:49:47.892371+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.9086814 2023-02-10T18:49:47.908681+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.9249651 2023-02-10T18:49:47.924965+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.9401946 2023-02-10T18:49:47.940195+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.9563997 2023-02-10T18:49:47.956400+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.972601 2023-02-10T18:49:47.972601+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054987.9888046 2023-02-10T18:49:47.988805+00:00 1 10 1285 725 880 556 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.0050156 2023-02-10T18:49:48.005016+00:00 1 10 1285 725 880 471 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.0202246 2023-02-10T18:49:48.020225+00:00 1 10 1285 725 880 471 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.0364363 2023-02-10T18:49:48.036436+00:00 1 10 1285 725 880 471 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.0526917 2023-02-10T18:49:48.052692+00:00 1 10 1285 725 880 471 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.0689094 2023-02-10T18:49:48.068909+00:00 1 10 1285 725 880 471 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.0851295 2023-02-10T18:49:48.085129+00:00 1 10 1285 725 880 471 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.1013453 2023-02-10T18:49:48.101345+00:00 1 10 1285 725 880 471 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.1175575 2023-02-10T18:49:48.117558+00:00 1 10 1285 725 880 471 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.1337895 2023-02-10T18:49:48.133790+00:00 1 10 1285 725 880 472 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.149989 2023-02-10T18:49:48.149989+00:00 1 10 1285 725 880 475 880 730 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.1651793 2023-02-10T18:49:48.165179+00:00 1 10 1285 725 880 479 880 744 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.1813753 2023-02-10T18:49:48.181375+00:00 1 10 1285 725 880 482 880 744 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.1975849 2023-02-10T18:49:48.197585+00:00 1 10 1285 725 880 485 880 744 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.2138226 2023-02-10T18:49:48.213823+00:00 1 10 1285 725 880 489 880 745 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.2301016 2023-02-10T18:49:48.230102+00:00 1 10 1285 725 880 490 880 746 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.246368 2023-02-10T18:49:48.246368+00:00 1 10 1285 725 880 490 880 747 880 719 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.2625492 2023-02-10T18:49:48.262549+00:00 1 10 1285 725 880 490 880 749 880 700 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.2787445 2023-02-10T18:49:48.278744+00:00 1 10 1285 725 880 490 880 757 880 698 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.2949593 2023-02-10T18:49:48.294959+00:00 1 10 1285 725 880 490 880 757 880 696 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.3102708 2023-02-10T18:49:48.310271+00:00 1 10 1285 725 880 490 880 760 880 690 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.3265502 2023-02-10T18:49:48.326550+00:00 1 10 1285 725 880 490 880 764 880 685 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.3428094 2023-02-10T18:49:48.342809+00:00 1 10 1285 725 880 490 880 767 880 684 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.359062 2023-02-10T18:49:48.359062+00:00 1 10 1285 725 880 490 880 770 880 684 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.374313 2023-02-10T18:49:48.374313+00:00 1 10 1285 725 880 490 880 773 880 683 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.390541 2023-02-10T18:49:48.390541+00:00 1 10 1285 725 880 490 880 774 880 683 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.4067316 2023-02-10T18:49:48.406732+00:00 1 10 1285 725 880 490 880 775 880 683 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.4229264 2023-02-10T18:49:48.422926+00:00 1 10 1285 725 880 490 880 776 880 682 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.4391224 2023-02-10T18:49:48.439122+00:00 1 10 1285 725 880 490 880 777 880 681 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.4553509 2023-02-10T18:49:48.455351+00:00 1 10 1285 725 880 490 880 778 880 681 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.4715753 2023-02-10T18:49:48.471575+00:00 1 10 1285 725 880 490 880 779 880 681 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.4878106 2023-02-10T18:49:48.487811+00:00 1 10 1285 725 880 489 880 779 880 681 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.5040333 2023-02-10T18:49:48.504033+00:00 1 10 1285 725 880 488 880 779 880 681 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.5192478 2023-02-10T18:49:48.519248+00:00 1 10 1285 725 880 488 880 779 880 681 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.535476 2023-02-10T18:49:48.535476+00:00 1 10 1285 725 880 488 880 779 880 681 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.5517116 2023-02-10T18:49:48.551712+00:00 1 10 1285 725 880 488 880 779 880 687 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.567952 2023-02-10T18:49:48.567952+00:00 1 10 1285 725 880 488 880 778 880 696 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.583194 2023-02-10T18:49:48.583194+00:00 1 10 1285 725 880 487 880 776 880 706 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.599479 2023-02-10T18:49:48.599479+00:00 1 10 1285 725 880 484 880 770 880 718 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.6157742 2023-02-10T18:49:48.615774+00:00 1 9 1285 725 880 483 880 770 880 728 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.6320648 2023-02-10T18:49:48.632065+00:00 1 9 1285 725 880 482 880 764 880 738 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.6473436 2023-02-10T18:49:48.647344+00:00 1 9 1285 725 880 477 880 758 880 746 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.6636283 2023-02-10T18:49:48.663628+00:00 1 9 1285 725 880 474 880 751 880 750 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.6799684 2023-02-10T18:49:48.679968+00:00 1 9 1285 725 880 471 880 747 880 754 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.6952627 2023-02-10T18:49:48.695263+00:00 1 9 1285 725 880 471 880 743 880 754 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.7115586 2023-02-10T18:49:48.711559+00:00 1 9 1285 725 880 470 880 739 880 755 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.72787 2023-02-10T18:49:48.727870+00:00 1 9 1285 725 880 470 880 730 880 756 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.744166 2023-02-10T18:49:48.744166+00:00 1 9 1285 725 880 470 880 726 880 759 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.7604625 2023-02-10T18:49:48.760463+00:00 1 9 1285 725 880 470 880 722 880 763 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.776757 2023-02-10T18:49:48.776757+00:00 1 9 1285 725 880 470 880 719 880 771 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.7930558 2023-02-10T18:49:48.793056+00:00 1 9 1285 725 880 470 880 715 880 782 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.808362 2023-02-10T18:49:48.808362+00:00 1 9 1285 725 880 470 880 712 880 797 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.8246837 2023-02-10T18:49:48.824684+00:00 1 9 1285 725 880 470 880 711 880 812 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.8409767 2023-02-10T18:49:48.840977+00:00 1 9 1285 725 880 472 880 711 880 825 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.856289 2023-02-10T18:49:48.856289+00:00 1 9 1285 725 880 477 880 711 880 832 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.872586 2023-02-10T18:49:48.872586+00:00 1 9 1285 725 880 484 880 711 880 832 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.88885 2023-02-10T18:49:48.888850+00:00 1 9 1285 725 880 493 880 711 880 832 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.9050674 2023-02-10T18:49:48.905067+00:00 1 9 1285 725 880 493 880 711 880 826 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.9202814 2023-02-10T18:49:48.920281+00:00 1 9 1285 725 880 503 880 712 880 815 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.9364734 2023-02-10T18:49:48.936473+00:00 1 9 1285 725 880 510 880 718 880 813 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.952659 2023-02-10T18:49:48.952659+00:00 1 9 1285 725 880 523 880 726 880 809 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.9688532 2023-02-10T18:49:48.968853+00:00 1 9 1285 725 880 536 880 737 880 807 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054988.9850352 2023-02-10T18:49:48.985035+00:00 1 9 1285 725 880 542 880 749 880 806 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.000222 2023-02-10T18:49:49.000222+00:00 1 9 1285 725 880 544 880 762 880 806 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.016408 2023-02-10T18:49:49.016408+00:00 1 9 1285 725 880 544 880 772 880 806 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.0326095 2023-02-10T18:49:49.032609+00:00 1 9 1285 725 880 552 880 782 880 806 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.048796 2023-02-10T18:49:49.048796+00:00 1 9 1285 725 880 558 880 794 880 806 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.0649793 2023-02-10T18:49:49.064979+00:00 1 9 1285 725 880 562 880 805 880 806 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.0811613 2023-02-10T18:49:49.081161+00:00 1 9 1285 725 880 562 880 815 880 809 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.0973465 2023-02-10T18:49:49.097347+00:00 1 9 1285 725 880 562 880 825 880 813 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.113524 2023-02-10T18:49:49.113524+00:00 1 9 1285 725 880 562 880 830 880 817 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.1297154 2023-02-10T18:49:49.129715+00:00 1 9 1285 725 880 563 880 832 880 825 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.1458995 2023-02-10T18:49:49.145900+00:00 1 9 1285 725 880 563 880 832 880 830 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.1620848 2023-02-10T18:49:49.162085+00:00 1 9 1285 725 880 563 880 832 880 834 1660 684 0 0
exp_2023_02_10_10 102 103 113 1676054989.177291 2023-02-10T18:49:49.177291+00:00 1 9 1285 725 880 563 880 816 880 838 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]);