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

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_11_01_10 63 67 99905 1667328612.3831239 2022-11-01T18:50:12.383124+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_11_01_10 63 67 99905 1667328612.3988776 2022-11-01T18:50:12.398878+00:00 1 10 1285 725 880 653 880 626 880 880 1660 633 0 0
exp_2022_11_01_10 63 67 99905 1667328612.4150927 2022-11-01T18:50:12.415093+00:00 1 10 1285 725 880 653 880 626 880 880 1660 645 0 0
exp_2022_11_01_10 63 67 99905 1667328612.431278 2022-11-01T18:50:12.431278+00:00 1 10 1285 725 880 653 880 626 880 880 1660 657 0 0
exp_2022_11_01_10 63 67 99905 1667328612.4474788 2022-11-01T18:50:12.447479+00:00 1 10 1285 725 880 653 880 626 880 880 1660 669 0 0
exp_2022_11_01_10 63 67 99905 1667328612.4637454 2022-11-01T18:50:12.463745+00:00 1 10 1285 725 880 653 880 626 880 880 1660 669 0 0
exp_2022_11_01_10 63 67 99905 1667328612.4790032 2022-11-01T18:50:12.479003+00:00 1 10 1285 725 880 653 880 626 880 880 1660 678 0 0
exp_2022_11_01_10 63 67 99905 1667328612.4952004 2022-11-01T18:50:12.495200+00:00 1 10 1285 725 880 653 880 626 880 880 1660 682 0 0
exp_2022_11_01_10 63 67 99905 1667328612.511402 2022-11-01T18:50:12.511402+00:00 1 10 1285 725 880 653 880 626 880 880 1660 683 0 0
exp_2022_11_01_10 63 67 99905 1667328612.5275989 2022-11-01T18:50:12.527599+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.543793 2022-11-01T18:50:12.543793+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.5599394 2022-11-01T18:50:12.559939+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.576142 2022-11-01T18:50:12.576142+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.5923285 2022-11-01T18:50:12.592329+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.608515 2022-11-01T18:50:12.608515+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.6247218 2022-11-01T18:50:12.624722+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.639909 2022-11-01T18:50:12.639909+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.6560946 2022-11-01T18:50:12.656095+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.6722739 2022-11-01T18:50:12.672274+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.688441 2022-11-01T18:50:12.688441+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.7046244 2022-11-01T18:50:12.704624+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.720812 2022-11-01T18:50:12.720812+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.7369995 2022-11-01T18:50:12.737000+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.7531893 2022-11-01T18:50:12.753189+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.7693772 2022-11-01T18:50:12.769377+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.785598 2022-11-01T18:50:12.785598+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.8017852 2022-11-01T18:50:12.801785+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.8179688 2022-11-01T18:50:12.817969+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.8341506 2022-11-01T18:50:12.834151+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.8503366 2022-11-01T18:50:12.850337+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.8665278 2022-11-01T18:50:12.866528+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.8827226 2022-11-01T18:50:12.882723+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.897908 2022-11-01T18:50:12.897908+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.9140933 2022-11-01T18:50:12.914093+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.930281 2022-11-01T18:50:12.930281+00:00 1 10 1285 725 880 653 880 626 880 880 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.9464743 2022-11-01T18:50:12.946474+00:00 1 10 1285 725 880 653 880 626 880 708 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.962662 2022-11-01T18:50:12.962662+00:00 1 10 1285 725 880 653 880 626 880 708 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.97785 2022-11-01T18:50:12.977850+00:00 1 10 1285 725 880 653 880 626 880 707 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328612.9940522 2022-11-01T18:50:12.994052+00:00 1 10 1285 725 880 653 880 626 880 703 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.0102336 2022-11-01T18:50:13.010234+00:00 1 10 1285 725 880 653 880 626 880 696 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.0264122 2022-11-01T18:50:13.026412+00:00 1 10 1285 725 880 653 880 626 880 687 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.042607 2022-11-01T18:50:13.042607+00:00 1 10 1285 725 880 653 880 626 880 687 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.0587952 2022-11-01T18:50:13.058795+00:00 1 10 1285 725 880 653 880 626 880 681 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.0750089 2022-11-01T18:50:13.075009+00:00 1 10 1285 725 880 653 880 626 880 672 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.0912094 2022-11-01T18:50:13.091209+00:00 1 10 1285 725 880 653 880 626 880 665 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.107403 2022-11-01T18:50:13.107403+00:00 1 10 1285 725 880 653 880 470 880 658 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.1236055 2022-11-01T18:50:13.123605+00:00 1 10 1285 725 880 653 880 470 880 657 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.139822 2022-11-01T18:50:13.139822+00:00 1 10 1285 725 880 653 880 470 880 649 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.156016 2022-11-01T18:50:13.156016+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.1722007 2022-11-01T18:50:13.172201+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.1883845 2022-11-01T18:50:13.188385+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.2045822 2022-11-01T18:50:13.204582+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.2208107 2022-11-01T18:50:13.220811+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.2370381 2022-11-01T18:50:13.237038+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.2532766 2022-11-01T18:50:13.253277+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.2695181 2022-11-01T18:50:13.269518+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.2857404 2022-11-01T18:50:13.285740+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.3009295 2022-11-01T18:50:13.300930+00:00 1 10 1285 725 880 653 880 470 880 645 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.3171291 2022-11-01T18:50:13.317129+00:00 1 10 1285 725 880 653 880 470 880 644 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.333366 2022-11-01T18:50:13.333366+00:00 1 10 1285 725 880 653 880 470 880 643 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.3495731 2022-11-01T18:50:13.349573+00:00 1 10 1285 725 880 653 880 470 880 641 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.3657851 2022-11-01T18:50:13.365785+00:00 1 10 1285 725 880 653 880 470 880 638 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.3819792 2022-11-01T18:50:13.381979+00:00 1 10 1285 725 880 653 880 470 880 635 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.3981714 2022-11-01T18:50:13.398171+00:00 1 10 1285 725 880 653 880 470 880 633 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.4143693 2022-11-01T18:50:13.414369+00:00 1 9 1285 725 880 653 880 470 880 633 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.4305496 2022-11-01T18:50:13.430550+00:00 1 9 1285 725 880 653 880 470 880 633 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.4467392 2022-11-01T18:50:13.446739+00:00 1 9 1285 725 880 653 880 470 880 633 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.4619253 2022-11-01T18:50:13.461925+00:00 1 9 1285 725 880 653 880 470 880 633 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.478148 2022-11-01T18:50:13.478148+00:00 1 9 1285 725 880 653 880 470 880 633 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.4943445 2022-11-01T18:50:13.494344+00:00 1 9 1285 725 880 653 880 470 880 633 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.5105245 2022-11-01T18:50:13.510525+00:00 1 9 1285 725 880 653 880 470 880 633 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.5266929 2022-11-01T18:50:13.526693+00:00 1 9 1285 725 880 653 880 470 880 633 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.541893 2022-11-01T18:50:13.541893+00:00 1 9 1285 725 880 539 880 470 880 635 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.5580819 2022-11-01T18:50:13.558082+00:00 1 9 1285 725 880 549 880 470 880 638 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.5742846 2022-11-01T18:50:13.574285+00:00 1 9 1285 725 880 582 880 470 880 640 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.5904748 2022-11-01T18:50:13.590475+00:00 1 9 1285 725 880 645 880 470 880 640 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.6066756 2022-11-01T18:50:13.606676+00:00 1 9 1285 725 880 680 880 470 880 643 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.621883 2022-11-01T18:50:13.621883+00:00 1 9 1285 725 880 690 880 470 880 649 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.638067 2022-11-01T18:50:13.638067+00:00 1 9 1285 725 880 690 880 470 880 650 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.6542563 2022-11-01T18:50:13.654256+00:00 1 9 1285 725 880 690 880 470 880 654 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.6704478 2022-11-01T18:50:13.670448+00:00 1 9 1285 725 880 690 880 470 880 661 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.6866782 2022-11-01T18:50:13.686678+00:00 1 9 1285 725 880 690 880 470 880 664 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.7018669 2022-11-01T18:50:13.701867+00:00 1 9 1285 725 880 663 880 470 880 667 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.7180529 2022-11-01T18:50:13.718053+00:00 1 9 1285 725 880 647 880 470 880 667 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.7342489 2022-11-01T18:50:13.734249+00:00 1 9 1285 725 880 614 880 476 880 670 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.7504413 2022-11-01T18:50:13.750441+00:00 1 9 1285 725 880 557 880 494 880 671 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.766637 2022-11-01T18:50:13.766637+00:00 1 9 1285 725 880 494 880 500 880 672 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.7828288 2022-11-01T18:50:13.782829+00:00 1 9 1285 725 880 470 880 507 880 672 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.799013 2022-11-01T18:50:13.799013+00:00 1 9 1285 725 880 470 880 534 880 672 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.8152032 2022-11-01T18:50:13.815203+00:00 1 9 1285 725 880 470 880 557 880 672 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.8313916 2022-11-01T18:50:13.831392+00:00 1 9 1285 725 880 470 880 570 880 672 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.8475661 2022-11-01T18:50:13.847566+00:00 1 9 1285 725 880 470 880 570 880 672 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.8637652 2022-11-01T18:50:13.863765+00:00 1 9 1285 725 880 470 880 590 880 672 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.878957 2022-11-01T18:50:13.878957+00:00 1 9 1285 725 880 484 880 599 880 672 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.8951516 2022-11-01T18:50:13.895152+00:00 1 9 1285 725 880 521 880 607 880 673 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.9113548 2022-11-01T18:50:13.911355+00:00 1 9 1285 725 880 534 880 616 880 673 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.9275503 2022-11-01T18:50:13.927550+00:00 1 9 1285 725 880 568 880 639 880 673 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.9437652 2022-11-01T18:50:13.943765+00:00 1 9 1285 725 880 568 880 661 880 673 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.9589484 2022-11-01T18:50:13.958948+00:00 1 9 1285 725 880 710 880 661 880 673 1660 684 0 0
exp_2022_11_01_10 63 67 99905 1667328613.9751408 2022-11-01T18:50:13.975141+00:00 1 9 1285 725 880 756 880 704 880 673 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]);