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

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_17_15 73 76 79 1668732198.072921 2022-11-18T00:43:18.072921+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_11_17_15 73 76 79 1668732198.08865 2022-11-18T00:43:18.088650+00:00 1 10 1285 725 880 556 880 643 880 823 1660 645 0 0
exp_2022_11_17_15 73 76 79 1668732198.1048267 2022-11-18T00:43:18.104827+00:00 1 10 1285 725 880 556 880 643 880 823 1660 657 0 0
exp_2022_11_17_15 73 76 79 1668732198.121021 2022-11-18T00:43:18.121021+00:00 1 10 1285 725 880 556 880 643 880 823 1660 669 0 0
exp_2022_11_17_15 73 76 79 1668732198.1372273 2022-11-18T00:43:18.137227+00:00 1 10 1285 725 880 556 880 643 880 823 1660 678 0 0
exp_2022_11_17_15 73 76 79 1668732198.1534152 2022-11-18T00:43:18.153415+00:00 1 10 1285 725 880 556 880 643 880 823 1660 682 0 0
exp_2022_11_17_15 73 76 79 1668732198.1685922 2022-11-18T00:43:18.168592+00:00 1 10 1285 725 880 556 880 643 880 823 1660 682 0 0
exp_2022_11_17_15 73 76 79 1668732198.1847947 2022-11-18T00:43:18.184795+00:00 1 10 1285 725 880 556 880 643 880 823 1660 683 0 0
exp_2022_11_17_15 73 76 79 1668732198.2009666 2022-11-18T00:43:18.200967+00:00 1 10 1285 725 880 556 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.2171488 2022-11-18T00:43:18.217149+00:00 1 10 1285 725 880 556 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.2333245 2022-11-18T00:43:18.233325+00:00 1 10 1285 725 880 556 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.248519 2022-11-18T00:43:18.248519+00:00 1 10 1285 725 880 556 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.264706 2022-11-18T00:43:18.264706+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.2809024 2022-11-18T00:43:18.280902+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.2970872 2022-11-18T00:43:18.297087+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.3132792 2022-11-18T00:43:18.313279+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.3294644 2022-11-18T00:43:18.329464+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.3456955 2022-11-18T00:43:18.345695+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.361896 2022-11-18T00:43:18.361896+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.3781512 2022-11-18T00:43:18.378151+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.3943403 2022-11-18T00:43:18.394340+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.4095387 2022-11-18T00:43:18.409539+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.4257393 2022-11-18T00:43:18.425739+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.441925 2022-11-18T00:43:18.441925+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.4581223 2022-11-18T00:43:18.458122+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.4743018 2022-11-18T00:43:18.474302+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.4904811 2022-11-18T00:43:18.490481+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.5066702 2022-11-18T00:43:18.506670+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.5228558 2022-11-18T00:43:18.522856+00:00 1 10 1285 725 880 567 880 643 880 823 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.539039 2022-11-18T00:43:18.539039+00:00 1 10 1285 725 880 567 880 643 880 755 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.5552232 2022-11-18T00:43:18.555223+00:00 1 10 1285 725 880 567 880 643 880 755 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.57141 2022-11-18T00:43:18.571410+00:00 1 10 1285 725 880 567 880 643 880 755 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.5866013 2022-11-18T00:43:18.586601+00:00 1 10 1285 725 880 567 880 643 880 757 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.6027703 2022-11-18T00:43:18.602770+00:00 1 10 1285 725 880 567 880 643 880 761 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.6189673 2022-11-18T00:43:18.618967+00:00 1 10 1285 725 880 567 880 646 880 775 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.6351507 2022-11-18T00:43:18.635151+00:00 1 10 1285 725 880 567 880 649 880 775 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.6513267 2022-11-18T00:43:18.651327+00:00 1 10 1285 725 880 567 880 651 880 788 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.667522 2022-11-18T00:43:18.667522+00:00 1 10 1285 725 880 567 880 652 880 788 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.6837199 2022-11-18T00:43:18.683720+00:00 1 10 1285 725 880 567 880 661 880 791 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.6999269 2022-11-18T00:43:18.699927+00:00 1 10 1285 725 880 567 880 664 880 793 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.7161345 2022-11-18T00:43:18.716135+00:00 1 10 1285 725 880 567 880 664 880 793 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.7322783 2022-11-18T00:43:18.732278+00:00 1 10 1285 725 880 569 880 668 880 793 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.7484767 2022-11-18T00:43:18.748477+00:00 1 10 1285 725 880 570 880 670 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.7646801 2022-11-18T00:43:18.764680+00:00 1 10 1285 725 880 570 880 672 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.780875 2022-11-18T00:43:18.780875+00:00 1 10 1285 725 880 572 880 672 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.7971098 2022-11-18T00:43:18.797110+00:00 1 10 1285 725 880 574 880 672 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.8133297 2022-11-18T00:43:18.813330+00:00 1 10 1285 725 880 577 880 673 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.8295274 2022-11-18T00:43:18.829527+00:00 1 10 1285 725 880 580 880 674 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.8457265 2022-11-18T00:43:18.845726+00:00 1 10 1285 725 880 581 880 674 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.8619163 2022-11-18T00:43:18.861916+00:00 1 10 1285 725 880 587 880 674 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.8781118 2022-11-18T00:43:18.878112+00:00 1 10 1285 725 880 588 880 674 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.8943014 2022-11-18T00:43:18.894301+00:00 1 10 1285 725 880 588 880 674 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.9105055 2022-11-18T00:43:18.910506+00:00 1 10 1285 725 880 591 880 674 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.926711 2022-11-18T00:43:18.926711+00:00 1 10 1285 725 880 591 880 671 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.942918 2022-11-18T00:43:18.942918+00:00 1 10 1285 725 880 594 880 665 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.9591162 2022-11-18T00:43:18.959116+00:00 1 10 1285 725 880 594 880 659 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.975311 2022-11-18T00:43:18.975311+00:00 1 10 1285 725 880 594 880 653 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732198.9915047 2022-11-18T00:43:18.991505+00:00 1 10 1285 725 880 595 880 650 880 794 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.0077438 2022-11-18T00:43:19.007744+00:00 1 10 1285 725 880 595 880 647 880 797 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.023941 2022-11-18T00:43:19.023941+00:00 1 10 1285 725 880 595 880 646 880 803 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.0401626 2022-11-18T00:43:19.040163+00:00 1 10 1285 725 880 595 880 646 880 810 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.0563703 2022-11-18T00:43:19.056370+00:00 1 10 1285 725 880 595 880 646 880 820 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.0715923 2022-11-18T00:43:19.071592+00:00 1 10 1285 725 880 595 880 646 880 826 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.0877748 2022-11-18T00:43:19.087775+00:00 1 10 1285 725 880 595 880 650 880 833 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.1039634 2022-11-18T00:43:19.103963+00:00 1 9 1285 725 880 594 880 659 880 840 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.1201553 2022-11-18T00:43:19.120155+00:00 1 9 1285 725 880 591 880 671 880 851 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.13634 2022-11-18T00:43:19.136340+00:00 1 9 1285 725 880 589 880 683 880 851 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.1515443 2022-11-18T00:43:19.151544+00:00 1 9 1285 725 880 579 880 711 880 855 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.1677294 2022-11-18T00:43:19.167729+00:00 1 9 1285 725 880 558 880 711 880 859 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.1840396 2022-11-18T00:43:19.184040+00:00 1 9 1285 725 880 554 880 725 880 861 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.2002306 2022-11-18T00:43:19.200231+00:00 1 9 1285 725 880 554 880 737 880 862 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.216443 2022-11-18T00:43:19.216443+00:00 1 9 1285 725 880 545 880 747 880 862 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.2316368 2022-11-18T00:43:19.231637+00:00 1 9 1285 725 880 536 880 753 880 865 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.2478294 2022-11-18T00:43:19.247829+00:00 1 9 1285 725 880 529 880 755 880 868 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.2640278 2022-11-18T00:43:19.264028+00:00 1 9 1285 725 880 516 880 755 880 871 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.280208 2022-11-18T00:43:19.280208+00:00 1 9 1285 725 880 504 880 755 880 874 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.2963953 2022-11-18T00:43:19.296395+00:00 1 9 1285 725 880 491 880 755 880 874 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.3115847 2022-11-18T00:43:19.311585+00:00 1 9 1285 725 880 484 880 752 880 874 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.3277664 2022-11-18T00:43:19.327766+00:00 1 9 1285 725 880 484 880 740 880 874 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.3439445 2022-11-18T00:43:19.343945+00:00 1 9 1285 725 880 484 880 722 880 874 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.3601248 2022-11-18T00:43:19.360125+00:00 1 9 1285 725 880 474 880 701 880 874 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.3763144 2022-11-18T00:43:19.376314+00:00 1 9 1285 725 880 470 880 679 880 871 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.3925133 2022-11-18T00:43:19.392513+00:00 1 9 1285 725 880 470 880 665 880 867 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.408712 2022-11-18T00:43:19.408712+00:00 1 9 1285 725 880 470 880 661 880 867 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.4249125 2022-11-18T00:43:19.424912+00:00 1 9 1285 725 880 470 880 663 880 862 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.4410968 2022-11-18T00:43:19.441097+00:00 1 9 1285 725 880 470 880 673 880 858 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.4572928 2022-11-18T00:43:19.457293+00:00 1 9 1285 725 880 470 880 673 880 852 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.4734867 2022-11-18T00:43:19.473487+00:00 1 9 1285 725 880 470 880 691 880 846 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.4886763 2022-11-18T00:43:19.488676+00:00 1 9 1285 725 880 470 880 714 880 839 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.5048819 2022-11-18T00:43:19.504882+00:00 1 9 1285 725 880 470 880 741 880 830 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.521078 2022-11-18T00:43:19.521078+00:00 1 9 1285 725 880 470 880 766 880 827 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.5372627 2022-11-18T00:43:19.537263+00:00 1 9 1285 725 880 470 880 779 880 827 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.5534594 2022-11-18T00:43:19.553459+00:00 1 9 1285 725 880 470 880 782 880 827 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.56866 2022-11-18T00:43:19.568660+00:00 1 9 1285 725 880 470 880 782 880 827 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.5848606 2022-11-18T00:43:19.584861+00:00 1 9 1285 725 880 470 880 766 880 832 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.6010506 2022-11-18T00:43:19.601051+00:00 1 9 1285 725 880 470 880 766 880 839 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.6172397 2022-11-18T00:43:19.617240+00:00 1 9 1285 725 880 470 880 731 880 839 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.6334355 2022-11-18T00:43:19.633435+00:00 1 9 1285 725 880 470 880 731 880 845 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.6486447 2022-11-18T00:43:19.648645+00:00 1 9 1285 725 880 470 880 694 880 852 1660 684 0 0
exp_2022_11_17_15 73 76 79 1668732199.6648462 2022-11-18T00:43:19.664846+00:00 1 9 1285 725 880 470 880 685 880 857 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]);