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_3_id = 47

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_18_10 29 46 47 1666119694.1933877 2022-10-18T19:01:34.193388+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_10_18_10 29 46 47 1666119694.2089877 2022-10-18T19:01:34.208988+00:00 1 10 1285 725 880 565 880 579 880 751 1660 627 0 0
exp_2022_10_18_10 29 46 47 1666119694.2251742 2022-10-18T19:01:34.225174+00:00 1 10 1285 725 880 565 880 579 880 754 1660 639 0 0
exp_2022_10_18_10 29 46 47 1666119694.2413616 2022-10-18T19:01:34.241362+00:00 1 10 1285 725 880 565 880 579 880 760 1660 651 0 0
exp_2022_10_18_10 29 46 47 1666119694.2565372 2022-10-18T19:01:34.256537+00:00 1 10 1285 725 880 565 880 579 880 760 1660 663 0 0
exp_2022_10_18_10 29 46 47 1666119694.2727177 2022-10-18T19:01:34.272718+00:00 1 10 1285 725 880 565 880 579 880 776 1660 675 0 0
exp_2022_10_18_10 29 46 47 1666119694.2889073 2022-10-18T19:01:34.288907+00:00 1 10 1285 725 880 565 880 579 880 783 1660 681 0 0
exp_2022_10_18_10 29 46 47 1666119694.3050845 2022-10-18T19:01:34.305084+00:00 1 10 1285 725 880 565 880 579 880 789 1660 683 0 0
exp_2022_10_18_10 29 46 47 1666119694.3212676 2022-10-18T19:01:34.321268+00:00 1 10 1285 725 880 565 880 579 880 795 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.3374553 2022-10-18T19:01:34.337455+00:00 1 10 1285 725 880 565 880 579 880 801 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.35363 2022-10-18T19:01:34.353630+00:00 1 10 1285 725 880 565 880 579 880 804 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.3698113 2022-10-18T19:01:34.369811+00:00 1 10 1285 725 880 565 880 579 880 806 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.3859994 2022-10-18T19:01:34.385999+00:00 1 10 1285 725 880 565 880 579 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.4021688 2022-10-18T19:01:34.402169+00:00 1 10 1285 725 880 565 880 579 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.4183552 2022-10-18T19:01:34.418355+00:00 1 10 1285 725 880 565 880 579 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.433531 2022-10-18T19:01:34.433531+00:00 1 10 1285 725 880 565 880 579 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.4497244 2022-10-18T19:01:34.449724+00:00 1 10 1285 725 880 565 880 579 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.465914 2022-10-18T19:01:34.465914+00:00 1 10 1285 725 880 565 880 579 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.482105 2022-10-18T19:01:34.482105+00:00 1 10 1285 725 880 565 880 579 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.4983087 2022-10-18T19:01:34.498309+00:00 1 10 1285 725 880 565 880 579 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.5134964 2022-10-18T19:01:34.513496+00:00 1 10 1285 725 880 565 880 470 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.529692 2022-10-18T19:01:34.529692+00:00 1 10 1285 725 880 565 880 470 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.5458872 2022-10-18T19:01:34.545887+00:00 1 10 1285 725 880 565 880 470 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.5620782 2022-10-18T19:01:34.562078+00:00 1 10 1285 725 880 565 880 470 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.5782628 2022-10-18T19:01:34.578263+00:00 1 10 1285 725 880 565 880 470 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.5944533 2022-10-18T19:01:34.594453+00:00 1 10 1285 725 880 565 880 470 880 806 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.610594 2022-10-18T19:01:34.610594+00:00 1 10 1285 725 880 565 880 470 880 806 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.6267214 2022-10-18T19:01:34.626721+00:00 1 10 1285 725 880 565 880 470 880 803 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.642861 2022-10-18T19:01:34.642861+00:00 1 10 1285 725 880 565 880 470 880 797 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.659009 2022-10-18T19:01:34.659009+00:00 1 10 1285 725 880 565 880 470 880 792 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.6751795 2022-10-18T19:01:34.675179+00:00 1 10 1285 725 880 565 880 470 880 786 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.6913354 2022-10-18T19:01:34.691335+00:00 1 10 1285 725 880 565 880 470 880 780 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.7064927 2022-10-18T19:01:34.706493+00:00 1 10 1285 725 880 565 880 470 880 774 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.7226522 2022-10-18T19:01:34.722652+00:00 1 10 1285 725 880 565 880 470 880 770 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.7388272 2022-10-18T19:01:34.738827+00:00 1 10 1285 725 880 565 880 470 880 769 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.7550228 2022-10-18T19:01:34.755023+00:00 1 10 1285 725 880 565 880 470 880 769 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.771225 2022-10-18T19:01:34.771225+00:00 1 10 1285 725 880 565 880 470 880 769 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.787421 2022-10-18T19:01:34.787421+00:00 1 10 1285 725 880 565 880 470 880 769 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.803627 2022-10-18T19:01:34.803627+00:00 1 10 1285 725 880 565 880 470 880 769 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.819839 2022-10-18T19:01:34.819839+00:00 1 10 1285 725 880 565 880 470 880 769 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.8360512 2022-10-18T19:01:34.836051+00:00 1 10 1285 725 880 580 880 470 880 769 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.852285 2022-10-18T19:01:34.852285+00:00 1 10 1285 725 880 580 880 470 880 769 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.8674903 2022-10-18T19:01:34.867490+00:00 1 10 1285 725 880 580 880 470 880 769 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.8836906 2022-10-18T19:01:34.883691+00:00 1 10 1285 725 880 579 880 470 880 770 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.8998904 2022-10-18T19:01:34.899890+00:00 1 10 1285 725 880 577 880 470 880 774 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.9160936 2022-10-18T19:01:34.916094+00:00 1 10 1285 725 880 574 880 470 880 778 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.9323277 2022-10-18T19:01:34.932328+00:00 1 10 1285 725 880 571 880 470 880 781 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.9476109 2022-10-18T19:01:34.947611+00:00 1 10 1285 725 880 571 880 470 880 781 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.963905 2022-10-18T19:01:34.963905+00:00 1 10 1285 725 880 570 880 470 880 785 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.980066 2022-10-18T19:01:34.980066+00:00 1 10 1285 725 880 569 880 470 880 788 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119694.9962332 2022-10-18T19:01:34.996233+00:00 1 10 1285 725 880 566 880 470 880 792 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.0124192 2022-10-18T19:01:35.012419+00:00 1 10 1285 725 880 566 880 470 880 797 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.027602 2022-10-18T19:01:35.027602+00:00 1 10 1285 725 880 566 880 470 880 802 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.0437903 2022-10-18T19:01:35.043790+00:00 1 10 1285 725 880 566 880 470 880 806 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.0599718 2022-10-18T19:01:35.059972+00:00 1 10 1285 725 880 566 880 470 880 809 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.076205 2022-10-18T19:01:35.076205+00:00 1 10 1285 725 880 566 880 470 880 810 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.0923746 2022-10-18T19:01:35.092375+00:00 1 10 1285 725 880 566 880 470 880 810 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.1075616 2022-10-18T19:01:35.107562+00:00 1 10 1285 725 880 566 880 470 880 810 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.123735 2022-10-18T19:01:35.123735+00:00 1 10 1285 725 880 566 880 470 880 807 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.1398866 2022-10-18T19:01:35.139887+00:00 1 10 1285 725 880 566 880 471 880 798 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.1560497 2022-10-18T19:01:35.156050+00:00 1 10 1285 725 880 566 880 473 880 786 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.1722467 2022-10-18T19:01:35.172247+00:00 1 10 1285 725 880 566 880 474 880 775 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.1884377 2022-10-18T19:01:35.188438+00:00 1 10 1285 725 880 566 880 474 880 763 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.2046187 2022-10-18T19:01:35.204619+00:00 1 10 1285 725 880 566 880 474 880 752 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.2208097 2022-10-18T19:01:35.220810+00:00 1 9 1285 725 880 569 880 474 880 743 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.236993 2022-10-18T19:01:35.236993+00:00 1 9 1285 725 880 573 880 474 880 734 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.2531831 2022-10-18T19:01:35.253183+00:00 1 9 1285 725 880 576 880 474 880 727 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.2693672 2022-10-18T19:01:35.269367+00:00 1 9 1285 725 880 579 880 474 880 727 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.284544 2022-10-18T19:01:35.284544+00:00 1 9 1285 725 880 584 880 474 880 727 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.300698 2022-10-18T19:01:35.300698+00:00 1 9 1285 725 880 584 880 472 880 727 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.3168874 2022-10-18T19:01:35.316887+00:00 1 9 1285 725 880 585 880 470 880 727 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.3330662 2022-10-18T19:01:35.333066+00:00 1 9 1285 725 880 585 880 470 880 727 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.349222 2022-10-18T19:01:35.349222+00:00 1 9 1285 725 880 585 880 470 880 727 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.3654048 2022-10-18T19:01:35.365405+00:00 1 9 1285 725 880 585 880 470 880 731 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.380586 2022-10-18T19:01:35.380586+00:00 1 9 1285 725 880 585 880 470 880 761 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.3967755 2022-10-18T19:01:35.396775+00:00 1 9 1285 725 880 585 880 470 880 761 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.4129674 2022-10-18T19:01:35.412967+00:00 1 9 1285 725 880 585 880 470 880 780 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.4291444 2022-10-18T19:01:35.429144+00:00 1 9 1285 725 880 585 880 470 880 799 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.4452927 2022-10-18T19:01:35.445293+00:00 1 9 1285 725 880 585 880 470 880 812 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.461447 2022-10-18T19:01:35.461447+00:00 1 9 1285 725 880 585 880 470 880 821 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.4776354 2022-10-18T19:01:35.477635+00:00 1 9 1285 725 880 585 880 470 880 822 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.4938176 2022-10-18T19:01:35.493818+00:00 1 9 1285 725 880 585 880 470 880 822 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.510012 2022-10-18T19:01:35.510012+00:00 1 9 1285 725 880 585 880 470 880 809 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.5261881 2022-10-18T19:01:35.526188+00:00 1 9 1285 725 880 585 880 470 880 795 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.5423894 2022-10-18T19:01:35.542389+00:00 1 9 1285 725 880 585 880 470 880 780 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.557545 2022-10-18T19:01:35.557545+00:00 1 9 1285 725 880 585 880 470 880 762 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.5737298 2022-10-18T19:01:35.573730+00:00 1 9 1285 725 880 585 880 470 880 762 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.5899172 2022-10-18T19:01:35.589917+00:00 1 9 1285 725 880 585 880 470 880 744 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.606101 2022-10-18T19:01:35.606101+00:00 1 9 1285 725 880 585 880 470 880 731 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.6222894 2022-10-18T19:01:35.622289+00:00 1 9 1285 725 880 585 880 470 880 724 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.6384604 2022-10-18T19:01:35.638460+00:00 1 9 1285 725 880 585 880 470 880 722 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.654644 2022-10-18T19:01:35.654644+00:00 1 9 1285 725 880 585 880 470 880 722 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.6708243 2022-10-18T19:01:35.670824+00:00 1 9 1285 725 880 585 880 470 880 722 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.6869802 2022-10-18T19:01:35.686980+00:00 1 9 1285 725 880 586 880 470 880 722 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.7031322 2022-10-18T19:01:35.703132+00:00 1 9 1285 725 880 589 880 470 880 723 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.7193172 2022-10-18T19:01:35.719317+00:00 1 9 1285 725 880 595 880 470 880 733 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.735472 2022-10-18T19:01:35.735472+00:00 1 9 1285 725 880 599 880 470 880 751 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.751627 2022-10-18T19:01:35.751627+00:00 1 9 1285 725 880 600 880 470 880 785 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.7678103 2022-10-18T19:01:35.767810+00:00 1 9 1285 725 880 602 880 470 880 794 1660 684 0 0
exp_2022_10_18_10 29 46 47 1666119695.7839918 2022-10-18T19:01:35.783992+00:00 1 9 1285 725 880 604 880 470 880 795 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]);