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

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_14_12 38 80 84 1668458193.0743933 2022-11-14T20:36:33.074393+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_11_14_12 38 80 84 1668458193.0903254 2022-11-14T20:36:33.090325+00:00 1 10 1285 725 880 639 880 880 880 616 1660 627 0 0
exp_2022_11_14_12 38 80 84 1668458193.1065023 2022-11-14T20:36:33.106502+00:00 1 10 1285 725 880 639 880 880 880 616 1660 639 0 0
exp_2022_11_14_12 38 80 84 1668458193.1226997 2022-11-14T20:36:33.122700+00:00 1 10 1285 725 880 639 880 880 880 616 1660 651 0 0
exp_2022_11_14_12 38 80 84 1668458193.138888 2022-11-14T20:36:33.138888+00:00 1 10 1285 725 880 639 880 880 880 616 1660 663 0 0
exp_2022_11_14_12 38 80 84 1668458193.1550841 2022-11-14T20:36:33.155084+00:00 1 10 1285 725 880 639 880 880 880 616 1660 675 0 0
exp_2022_11_14_12 38 80 84 1668458193.171268 2022-11-14T20:36:33.171268+00:00 1 10 1285 725 880 639 880 880 880 616 1660 681 0 0
exp_2022_11_14_12 38 80 84 1668458193.187451 2022-11-14T20:36:33.187451+00:00 1 10 1285 725 880 639 880 880 880 616 1660 683 0 0
exp_2022_11_14_12 38 80 84 1668458193.2036705 2022-11-14T20:36:33.203671+00:00 1 10 1285 725 880 639 880 880 880 616 1660 683 0 0
exp_2022_11_14_12 38 80 84 1668458193.219972 2022-11-14T20:36:33.219972+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.2362046 2022-11-14T20:36:33.236205+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.2513871 2022-11-14T20:36:33.251387+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.2675822 2022-11-14T20:36:33.267582+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.2837825 2022-11-14T20:36:33.283782+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.2999523 2022-11-14T20:36:33.299952+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.3161707 2022-11-14T20:36:33.316171+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.3314054 2022-11-14T20:36:33.331405+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.3475947 2022-11-14T20:36:33.347595+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.3637736 2022-11-14T20:36:33.363774+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.3799624 2022-11-14T20:36:33.379962+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.396135 2022-11-14T20:36:33.396135+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.4113202 2022-11-14T20:36:33.411320+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.4275172 2022-11-14T20:36:33.427517+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.4437091 2022-11-14T20:36:33.443709+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.4599082 2022-11-14T20:36:33.459908+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.4761336 2022-11-14T20:36:33.476134+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.4913244 2022-11-14T20:36:33.491324+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.5075252 2022-11-14T20:36:33.507525+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.5237134 2022-11-14T20:36:33.523713+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.5399055 2022-11-14T20:36:33.539906+00:00 1 10 1285 725 880 639 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.5560932 2022-11-14T20:36:33.556093+00:00 1 10 1285 725 880 780 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.5722802 2022-11-14T20:36:33.572280+00:00 1 10 1285 725 880 780 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.588465 2022-11-14T20:36:33.588465+00:00 1 10 1285 725 880 780 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.6046486 2022-11-14T20:36:33.604649+00:00 1 10 1285 725 880 780 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.6208336 2022-11-14T20:36:33.620834+00:00 1 10 1285 725 880 780 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.6370187 2022-11-14T20:36:33.637019+00:00 1 10 1285 725 880 780 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.6532063 2022-11-14T20:36:33.653206+00:00 1 10 1285 725 880 779 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.668397 2022-11-14T20:36:33.668397+00:00 1 10 1285 725 880 776 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.6845884 2022-11-14T20:36:33.684588+00:00 1 10 1285 725 880 761 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.7007842 2022-11-14T20:36:33.700784+00:00 1 10 1285 725 880 761 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.716981 2022-11-14T20:36:33.716981+00:00 1 10 1285 725 880 761 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.7331605 2022-11-14T20:36:33.733160+00:00 1 10 1285 725 880 754 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.7483425 2022-11-14T20:36:33.748343+00:00 1 10 1285 725 880 753 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.764523 2022-11-14T20:36:33.764523+00:00 1 10 1285 725 880 753 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.7806487 2022-11-14T20:36:33.780649+00:00 1 10 1285 725 880 728 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.7967706 2022-11-14T20:36:33.796771+00:00 1 10 1285 725 880 703 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.8129053 2022-11-14T20:36:33.812905+00:00 1 10 1285 725 880 687 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.8290672 2022-11-14T20:36:33.829067+00:00 1 10 1285 725 880 683 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.8452191 2022-11-14T20:36:33.845219+00:00 1 10 1285 725 880 674 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.8604016 2022-11-14T20:36:33.860402+00:00 1 10 1285 725 880 674 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.876581 2022-11-14T20:36:33.876581+00:00 1 10 1285 725 880 673 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.8927646 2022-11-14T20:36:33.892765+00:00 1 10 1285 725 880 673 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.9089587 2022-11-14T20:36:33.908959+00:00 1 10 1285 725 880 673 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.9251416 2022-11-14T20:36:33.925142+00:00 1 10 1285 725 880 673 880 880 880 616 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.9403272 2022-11-14T20:36:33.940327+00:00 1 10 1285 725 880 673 880 880 880 557 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.9565096 2022-11-14T20:36:33.956510+00:00 1 10 1285 725 880 673 880 880 880 557 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.9727037 2022-11-14T20:36:33.972704+00:00 1 10 1285 725 880 668 880 880 880 557 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458193.9888856 2022-11-14T20:36:33.988886+00:00 1 10 1285 725 880 664 880 880 880 557 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.0050666 2022-11-14T20:36:34.005067+00:00 1 10 1285 725 880 661 880 880 880 557 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.021251 2022-11-14T20:36:34.021251+00:00 1 10 1285 725 880 660 880 880 880 557 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.0364294 2022-11-14T20:36:34.036429+00:00 1 10 1285 725 880 660 880 880 880 557 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.0526114 2022-11-14T20:36:34.052611+00:00 1 10 1285 725 880 660 880 880 880 557 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.0688043 2022-11-14T20:36:34.068804+00:00 1 10 1285 725 880 660 880 880 880 557 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.0849874 2022-11-14T20:36:34.084987+00:00 1 10 1285 725 880 659 880 880 880 558 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.1011717 2022-11-14T20:36:34.101172+00:00 1 9 1285 725 880 656 880 880 880 558 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.1163578 2022-11-14T20:36:34.116358+00:00 1 9 1285 725 880 650 880 880 880 558 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.1325378 2022-11-14T20:36:34.132538+00:00 1 9 1285 725 880 641 880 880 880 558 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.1487384 2022-11-14T20:36:34.148738+00:00 1 9 1285 725 880 637 880 880 880 558 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.164924 2022-11-14T20:36:34.164924+00:00 1 9 1285 725 880 636 880 880 880 558 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.181106 2022-11-14T20:36:34.181106+00:00 1 9 1285 725 880 636 880 880 880 558 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.197283 2022-11-14T20:36:34.197283+00:00 1 9 1285 725 880 636 880 880 880 558 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.2134745 2022-11-14T20:36:34.213475+00:00 1 9 1285 725 880 636 880 880 880 559 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.2296731 2022-11-14T20:36:34.229673+00:00 1 9 1285 725 880 636 880 880 880 561 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.2458577 2022-11-14T20:36:34.245858+00:00 1 9 1285 725 880 636 880 880 880 561 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.2620456 2022-11-14T20:36:34.262046+00:00 1 9 1285 725 880 636 880 880 880 561 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.2782836 2022-11-14T20:36:34.278284+00:00 1 9 1285 725 880 635 880 877 880 563 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.294467 2022-11-14T20:36:34.294467+00:00 1 9 1285 725 880 635 880 870 880 563 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.3106542 2022-11-14T20:36:34.310654+00:00 1 9 1285 725 880 634 880 861 880 564 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.3268366 2022-11-14T20:36:34.326837+00:00 1 9 1285 725 880 620 880 852 880 566 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.343028 2022-11-14T20:36:34.343028+00:00 1 9 1285 725 880 604 880 843 880 568 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.3592212 2022-11-14T20:36:34.359221+00:00 1 9 1285 725 880 599 880 836 880 570 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.3744042 2022-11-14T20:36:34.374404+00:00 1 9 1285 725 880 595 880 832 880 573 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.390582 2022-11-14T20:36:34.390582+00:00 1 9 1285 725 880 595 880 830 880 576 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.4067583 2022-11-14T20:36:34.406758+00:00 1 9 1285 725 880 591 880 830 880 577 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.4229527 2022-11-14T20:36:34.422953+00:00 1 9 1285 725 880 591 880 830 880 577 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.439137 2022-11-14T20:36:34.439137+00:00 1 9 1285 725 880 583 880 830 880 578 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.4553218 2022-11-14T20:36:34.455322+00:00 1 9 1285 725 880 574 880 830 880 579 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.471517 2022-11-14T20:36:34.471517+00:00 1 9 1285 725 880 564 880 833 880 580 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.4877102 2022-11-14T20:36:34.487710+00:00 1 9 1285 725 880 553 880 837 880 581 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.5038917 2022-11-14T20:36:34.503892+00:00 1 9 1285 725 880 549 880 841 880 581 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.520085 2022-11-14T20:36:34.520085+00:00 1 9 1285 725 880 549 880 841 880 581 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.536309 2022-11-14T20:36:34.536309+00:00 1 9 1285 725 880 549 880 847 880 581 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.5524807 2022-11-14T20:36:34.552481+00:00 1 9 1285 725 880 549 880 853 880 581 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.5686545 2022-11-14T20:36:34.568655+00:00 1 9 1285 725 880 549 880 860 880 581 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.5848336 2022-11-14T20:36:34.584834+00:00 1 9 1285 725 880 549 880 867 880 575 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.6010063 2022-11-14T20:36:34.601006+00:00 1 9 1285 725 880 549 880 873 880 567 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.617183 2022-11-14T20:36:34.617183+00:00 1 9 1285 725 880 549 880 879 880 558 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.6323647 2022-11-14T20:36:34.632365+00:00 1 9 1285 725 880 549 880 880 880 548 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.6485486 2022-11-14T20:36:34.648549+00:00 1 9 1285 725 880 549 880 880 880 539 1660 684 0 0
exp_2022_11_14_12 38 80 84 1668458194.6647377 2022-11-14T20:36:34.664738+00:00 1 9 1285 725 880 549 880 880 880 526 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]);