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_2022_10_04_09"

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_04_09 11 18 20 1664908547.5998743 2022-10-04T18:35:47.599874+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_10_04_09 11 18 20 1664908547.615809 2022-10-04T18:35:47.615809+00:00 1 10 1285 725 880 772 880 641 880 728 1660 633 0 0
exp_2022_10_04_09 11 18 20 1664908547.6309862 2022-10-04T18:35:47.630986+00:00 1 10 1285 725 880 772 880 641 880 728 1660 645 0 0
exp_2022_10_04_09 11 18 20 1664908547.6471734 2022-10-04T18:35:47.647173+00:00 1 10 1285 725 880 772 880 641 880 728 1660 657 0 0
exp_2022_10_04_09 11 18 20 1664908547.6633873 2022-10-04T18:35:47.663387+00:00 1 10 1285 725 880 772 880 641 880 728 1660 669 0 0
exp_2022_10_04_09 11 18 20 1664908547.679636 2022-10-04T18:35:47.679636+00:00 1 10 1285 725 880 772 880 641 880 728 1660 678 0 0
exp_2022_10_04_09 11 18 20 1664908547.6958418 2022-10-04T18:35:47.695842+00:00 1 10 1285 725 880 772 880 641 880 728 1660 678 0 0
exp_2022_10_04_09 11 18 20 1664908547.7110465 2022-10-04T18:35:47.711046+00:00 1 10 1285 725 880 772 880 641 880 728 1660 682 0 0
exp_2022_10_04_09 11 18 20 1664908547.7272418 2022-10-04T18:35:47.727242+00:00 1 10 1285 725 880 772 880 641 880 728 1660 683 0 0
exp_2022_10_04_09 11 18 20 1664908547.7434347 2022-10-04T18:35:47.743435+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.7596316 2022-10-04T18:35:47.759632+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.7758243 2022-10-04T18:35:47.775824+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.7910075 2022-10-04T18:35:47.791008+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.8072007 2022-10-04T18:35:47.807201+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.8233826 2022-10-04T18:35:47.823383+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.8395557 2022-10-04T18:35:47.839556+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.8557498 2022-10-04T18:35:47.855750+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.8719392 2022-10-04T18:35:47.871939+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.8881245 2022-10-04T18:35:47.888124+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.9043107 2022-10-04T18:35:47.904311+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.9205008 2022-10-04T18:35:47.920501+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.936688 2022-10-04T18:35:47.936688+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.9528773 2022-10-04T18:35:47.952877+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.9680722 2022-10-04T18:35:47.968072+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908547.9842632 2022-10-04T18:35:47.984263+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.0004482 2022-10-04T18:35:48.000448+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.0166388 2022-10-04T18:35:48.016639+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.0328097 2022-10-04T18:35:48.032810+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.0479944 2022-10-04T18:35:48.047994+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.0642478 2022-10-04T18:35:48.064248+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.080444 2022-10-04T18:35:48.080444+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.096632 2022-10-04T18:35:48.096632+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.112823 2022-10-04T18:35:48.112823+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.1280046 2022-10-04T18:35:48.128005+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.1441813 2022-10-04T18:35:48.144181+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.1603615 2022-10-04T18:35:48.160362+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.1765451 2022-10-04T18:35:48.176545+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.1927197 2022-10-04T18:35:48.192720+00:00 1 10 1285 725 880 772 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.208912 2022-10-04T18:35:48.208912+00:00 1 10 1285 725 880 615 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.2240994 2022-10-04T18:35:48.224099+00:00 1 10 1285 725 880 615 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.2403076 2022-10-04T18:35:48.240308+00:00 1 10 1285 725 880 615 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.256463 2022-10-04T18:35:48.256463+00:00 1 10 1285 725 880 616 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.27266 2022-10-04T18:35:48.272660+00:00 1 10 1285 725 880 617 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.2888522 2022-10-04T18:35:48.288852+00:00 1 10 1285 725 880 618 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.3040445 2022-10-04T18:35:48.304044+00:00 1 10 1285 725 880 618 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.3202245 2022-10-04T18:35:48.320225+00:00 1 10 1285 725 880 619 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.3363948 2022-10-04T18:35:48.336395+00:00 1 10 1285 725 880 619 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.3525949 2022-10-04T18:35:48.352595+00:00 1 10 1285 725 880 619 880 641 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.3687873 2022-10-04T18:35:48.368787+00:00 1 10 1285 725 880 619 880 640 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.3849735 2022-10-04T18:35:48.384974+00:00 1 10 1285 725 880 620 880 640 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.401178 2022-10-04T18:35:48.401178+00:00 1 10 1285 725 880 623 880 639 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.417448 2022-10-04T18:35:48.417448+00:00 1 10 1285 725 880 624 880 638 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.4336672 2022-10-04T18:35:48.433667+00:00 1 10 1285 725 880 627 880 638 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.4498734 2022-10-04T18:35:48.449873+00:00 1 10 1285 725 880 629 880 638 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.4650877 2022-10-04T18:35:48.465088+00:00 1 10 1285 725 880 629 880 637 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.481293 2022-10-04T18:35:48.481293+00:00 1 10 1285 725 880 629 880 637 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.497476 2022-10-04T18:35:48.497476+00:00 1 10 1285 725 880 629 880 637 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.5136998 2022-10-04T18:35:48.513700+00:00 1 10 1285 725 880 629 880 636 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.5298877 2022-10-04T18:35:48.529888+00:00 1 10 1285 725 880 629 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.545081 2022-10-04T18:35:48.545081+00:00 1 10 1285 725 880 629 880 634 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.5612745 2022-10-04T18:35:48.561275+00:00 1 10 1285 725 880 629 880 634 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.5774708 2022-10-04T18:35:48.577471+00:00 1 10 1285 725 880 629 880 634 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.593663 2022-10-04T18:35:48.593663+00:00 1 10 1285 725 880 629 880 634 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.6098576 2022-10-04T18:35:48.609858+00:00 1 10 1285 725 880 629 880 634 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.6250572 2022-10-04T18:35:48.625057+00:00 1 9 1285 725 880 629 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.6412551 2022-10-04T18:35:48.641255+00:00 1 9 1285 725 880 629 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.6574438 2022-10-04T18:35:48.657444+00:00 1 9 1285 725 880 629 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.6736302 2022-10-04T18:35:48.673630+00:00 1 9 1285 725 880 628 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.6898453 2022-10-04T18:35:48.689845+00:00 1 9 1285 725 880 625 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.7050393 2022-10-04T18:35:48.705039+00:00 1 9 1285 725 880 625 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.721239 2022-10-04T18:35:48.721239+00:00 1 9 1285 725 880 624 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.7374308 2022-10-04T18:35:48.737431+00:00 1 9 1285 725 880 623 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.7536201 2022-10-04T18:35:48.753620+00:00 1 9 1285 725 880 622 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.7698045 2022-10-04T18:35:48.769804+00:00 1 9 1285 725 880 622 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.7859995 2022-10-04T18:35:48.786000+00:00 1 9 1285 725 880 620 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.802198 2022-10-04T18:35:48.802198+00:00 1 9 1285 725 880 619 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.8183782 2022-10-04T18:35:48.818378+00:00 1 9 1285 725 880 618 880 635 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.8345597 2022-10-04T18:35:48.834560+00:00 1 9 1285 725 880 617 880 635 880 744 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.850744 2022-10-04T18:35:48.850744+00:00 1 9 1285 725 880 615 880 635 880 742 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.8669345 2022-10-04T18:35:48.866935+00:00 1 9 1285 725 880 614 880 635 880 742 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.882094 2022-10-04T18:35:48.882094+00:00 1 9 1285 725 880 614 880 635 880 740 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.8982801 2022-10-04T18:35:48.898280+00:00 1 9 1285 725 880 611 880 635 880 738 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.9144654 2022-10-04T18:35:48.914465+00:00 1 9 1285 725 880 607 880 635 880 737 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.9306545 2022-10-04T18:35:48.930655+00:00 1 9 1285 725 880 605 880 635 880 737 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.9468384 2022-10-04T18:35:48.946838+00:00 1 9 1285 725 880 603 880 635 880 737 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.962029 2022-10-04T18:35:48.962029+00:00 1 9 1285 725 880 600 880 635 880 737 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.9782252 2022-10-04T18:35:48.978225+00:00 1 9 1285 725 880 596 880 635 880 737 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908548.9944088 2022-10-04T18:35:48.994409+00:00 1 9 1285 725 880 596 880 635 880 737 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.010598 2022-10-04T18:35:49.010598+00:00 1 9 1285 725 880 594 880 635 880 737 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.0267837 2022-10-04T18:35:49.026784+00:00 1 9 1285 725 880 591 880 635 880 737 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.0429766 2022-10-04T18:35:49.042977+00:00 1 9 1285 725 880 591 880 635 880 736 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.059165 2022-10-04T18:35:49.059165+00:00 1 9 1285 725 880 587 880 635 880 732 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.0753784 2022-10-04T18:35:49.075378+00:00 1 9 1285 725 880 587 880 634 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.0915482 2022-10-04T18:35:49.091548+00:00 1 9 1285 725 880 587 880 634 880 728 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.1077404 2022-10-04T18:35:49.107740+00:00 1 9 1285 725 880 587 880 631 880 724 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.1239307 2022-10-04T18:35:49.123931+00:00 1 9 1285 725 880 587 880 627 880 720 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.1391294 2022-10-04T18:35:49.139129+00:00 1 9 1285 725 880 586 880 621 880 715 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.1552763 2022-10-04T18:35:49.155276+00:00 1 9 1285 725 880 583 880 615 880 711 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.1714647 2022-10-04T18:35:49.171465+00:00 1 9 1285 725 880 581 880 608 880 710 1660 684 0 0
exp_2022_10_04_09 11 18 20 1664908549.1876419 2022-10-04T18:35:49.187642+00:00 1 9 1285 725 880 580 880 601 880 709 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]);