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

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_09_30_10 12 13 19 1664564606.3024921 2022-09-30T19:03:26.302492+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_09_30_10 12 13 19 1664564606.3182635 2022-09-30T19:03:26.318264+00:00 1 10 1285 725 880 470 880 548 880 880 1660 645 0 0
exp_2022_09_30_10 12 13 19 1664564606.3344362 2022-09-30T19:03:26.334436+00:00 1 10 1285 725 880 470 880 548 880 880 1660 657 0 0
exp_2022_09_30_10 12 13 19 1664564606.3506138 2022-09-30T19:03:26.350614+00:00 1 10 1285 725 880 470 880 548 880 880 1660 669 0 0
exp_2022_09_30_10 12 13 19 1664564606.3667936 2022-09-30T19:03:26.366794+00:00 1 10 1285 725 880 470 880 548 880 880 1660 678 0 0
exp_2022_09_30_10 12 13 19 1664564606.3829744 2022-09-30T19:03:26.382974+00:00 1 10 1285 725 880 470 880 548 880 880 1660 682 0 0
exp_2022_09_30_10 12 13 19 1664564606.3991537 2022-09-30T19:03:26.399154+00:00 1 10 1285 725 880 470 880 548 880 880 1660 683 0 0
exp_2022_09_30_10 12 13 19 1664564606.4143271 2022-09-30T19:03:26.414327+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.430503 2022-09-30T19:03:26.430503+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.4466906 2022-09-30T19:03:26.446691+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.46288 2022-09-30T19:03:26.462880+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.479069 2022-09-30T19:03:26.479069+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.494252 2022-09-30T19:03:26.494252+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.5104396 2022-09-30T19:03:26.510440+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.5266185 2022-09-30T19:03:26.526618+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.542812 2022-09-30T19:03:26.542812+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.558996 2022-09-30T19:03:26.558996+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.5751877 2022-09-30T19:03:26.575188+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.5904005 2022-09-30T19:03:26.590400+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.6065872 2022-09-30T19:03:26.606587+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.6227806 2022-09-30T19:03:26.622781+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.6389766 2022-09-30T19:03:26.638977+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.6551719 2022-09-30T19:03:26.655172+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.6703582 2022-09-30T19:03:26.670358+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.6865478 2022-09-30T19:03:26.686548+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.7027364 2022-09-30T19:03:26.702736+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.7189107 2022-09-30T19:03:26.718911+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.735106 2022-09-30T19:03:26.735106+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.7502944 2022-09-30T19:03:26.750294+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.7664824 2022-09-30T19:03:26.766482+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.7826765 2022-09-30T19:03:26.782676+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.7988682 2022-09-30T19:03:26.798868+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.8150554 2022-09-30T19:03:26.815055+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.8312392 2022-09-30T19:03:26.831239+00:00 1 10 1285 725 880 470 880 548 880 880 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.846428 2022-09-30T19:03:26.846428+00:00 1 10 1285 725 880 470 880 548 880 699 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.8626106 2022-09-30T19:03:26.862611+00:00 1 10 1285 725 880 470 880 548 880 698 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.8787947 2022-09-30T19:03:26.878795+00:00 1 10 1285 725 880 470 880 548 880 698 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.89499 2022-09-30T19:03:26.894990+00:00 1 10 1285 725 880 470 880 548 880 698 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.91119 2022-09-30T19:03:26.911190+00:00 1 10 1285 725 880 470 880 548 880 694 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.9263833 2022-09-30T19:03:26.926383+00:00 1 10 1285 725 880 470 880 548 880 690 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.942607 2022-09-30T19:03:26.942607+00:00 1 10 1285 725 880 767 880 548 880 689 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.9587972 2022-09-30T19:03:26.958797+00:00 1 10 1285 725 880 776 880 548 880 689 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.9749937 2022-09-30T19:03:26.974994+00:00 1 10 1285 725 880 790 880 548 880 688 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564606.9911852 2022-09-30T19:03:26.991185+00:00 1 10 1285 725 880 794 880 548 880 688 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.0063624 2022-09-30T19:03:27.006362+00:00 1 10 1285 725 880 794 880 548 880 688 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.0225775 2022-09-30T19:03:27.022578+00:00 1 10 1285 725 880 806 880 548 880 686 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.0387645 2022-09-30T19:03:27.038764+00:00 1 10 1285 725 880 816 880 548 880 681 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.0549552 2022-09-30T19:03:27.054955+00:00 1 10 1285 725 880 823 880 548 880 676 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.0711486 2022-09-30T19:03:27.071149+00:00 1 10 1285 725 880 837 880 548 880 670 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.0863335 2022-09-30T19:03:27.086334+00:00 1 10 1285 725 880 847 880 548 880 667 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.1025035 2022-09-30T19:03:27.102504+00:00 1 10 1285 725 880 856 880 548 880 665 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.1186786 2022-09-30T19:03:27.118679+00:00 1 10 1285 725 880 862 880 548 880 665 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.1348734 2022-09-30T19:03:27.134873+00:00 1 10 1285 725 880 869 880 548 880 665 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.1510665 2022-09-30T19:03:27.151067+00:00 1 10 1285 725 880 869 880 548 880 665 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.1672595 2022-09-30T19:03:27.167259+00:00 1 10 1285 725 880 880 880 548 880 665 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.1834438 2022-09-30T19:03:27.183444+00:00 1 10 1285 725 880 880 880 548 880 665 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.1996362 2022-09-30T19:03:27.199636+00:00 1 10 1285 725 880 880 880 548 880 668 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.2158282 2022-09-30T19:03:27.215828+00:00 1 10 1285 725 880 880 880 548 880 670 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.2320282 2022-09-30T19:03:27.232028+00:00 1 10 1285 725 880 880 880 548 880 671 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.2482376 2022-09-30T19:03:27.248238+00:00 1 10 1285 725 880 880 880 668 880 672 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.2644413 2022-09-30T19:03:27.264441+00:00 1 10 1285 725 880 880 880 666 880 672 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.280639 2022-09-30T19:03:27.280639+00:00 1 10 1285 725 880 880 880 665 880 673 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.2968311 2022-09-30T19:03:27.296831+00:00 1 10 1285 725 880 880 880 665 880 674 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.313029 2022-09-30T19:03:27.313029+00:00 1 10 1285 725 880 880 880 665 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.3292215 2022-09-30T19:03:27.329221+00:00 1 9 1285 725 880 880 880 665 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.345457 2022-09-30T19:03:27.345457+00:00 1 9 1285 725 880 880 880 668 880 676 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.3616393 2022-09-30T19:03:27.361639+00:00 1 9 1285 725 880 871 880 668 880 676 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.3778193 2022-09-30T19:03:27.377819+00:00 1 9 1285 725 880 844 880 674 880 677 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.3940349 2022-09-30T19:03:27.394035+00:00 1 9 1285 725 880 843 880 683 880 678 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.4102411 2022-09-30T19:03:27.410241+00:00 1 9 1285 725 880 843 880 699 880 678 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.426427 2022-09-30T19:03:27.426427+00:00 1 9 1285 725 880 840 880 712 880 678 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.4426138 2022-09-30T19:03:27.442614+00:00 1 9 1285 725 880 828 880 719 880 680 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.4588037 2022-09-30T19:03:27.458804+00:00 1 9 1285 725 880 825 880 719 880 680 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.4749887 2022-09-30T19:03:27.474989+00:00 1 9 1285 725 880 823 880 731 880 681 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.4911814 2022-09-30T19:03:27.491181+00:00 1 9 1285 725 880 822 880 740 880 682 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.5063543 2022-09-30T19:03:27.506354+00:00 1 9 1285 725 880 822 880 745 880 682 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.5225413 2022-09-30T19:03:27.522541+00:00 1 9 1285 725 880 819 880 746 880 682 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.5387347 2022-09-30T19:03:27.538735+00:00 1 9 1285 725 880 813 880 747 880 682 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.5549197 2022-09-30T19:03:27.554920+00:00 1 9 1285 725 880 810 880 747 880 682 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.5711145 2022-09-30T19:03:27.571115+00:00 1 9 1285 725 880 810 880 747 880 682 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.586311 2022-09-30T19:03:27.586311+00:00 1 9 1285 725 880 810 880 747 880 682 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.602495 2022-09-30T19:03:27.602495+00:00 1 9 1285 725 880 810 880 747 880 682 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.6186624 2022-09-30T19:03:27.618662+00:00 1 9 1285 725 880 807 880 747 880 681 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.6348534 2022-09-30T19:03:27.634853+00:00 1 9 1285 725 880 807 880 747 880 678 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.6510284 2022-09-30T19:03:27.651028+00:00 1 9 1285 725 880 807 880 747 880 676 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.6671698 2022-09-30T19:03:27.667170+00:00 1 9 1285 725 880 807 880 747 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.6823184 2022-09-30T19:03:27.682318+00:00 1 9 1285 725 880 807 880 747 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.6985116 2022-09-30T19:03:27.698512+00:00 1 9 1285 725 880 807 880 747 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.7147171 2022-09-30T19:03:27.714717+00:00 1 9 1285 725 880 807 880 747 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.730859 2022-09-30T19:03:27.730859+00:00 1 9 1285 725 880 807 880 747 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.7470372 2022-09-30T19:03:27.747037+00:00 1 9 1285 725 880 807 880 747 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.7632208 2022-09-30T19:03:27.763221+00:00 1 9 1285 725 880 807 880 747 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.778408 2022-09-30T19:03:27.778408+00:00 1 9 1285 725 880 807 880 746 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.794594 2022-09-30T19:03:27.794594+00:00 1 9 1285 725 880 807 880 746 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.8107948 2022-09-30T19:03:27.810795+00:00 1 9 1285 725 880 807 880 746 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.8270092 2022-09-30T19:03:27.827009+00:00 1 9 1285 725 880 807 880 745 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.843206 2022-09-30T19:03:27.843206+00:00 1 9 1285 725 880 807 880 745 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.8583937 2022-09-30T19:03:27.858394+00:00 1 9 1285 725 880 807 880 745 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.8745832 2022-09-30T19:03:27.874583+00:00 1 9 1285 725 880 806 880 745 880 675 1660 684 0 0
exp_2022_09_30_10 12 13 19 1664564607.8907802 2022-09-30T19:03:27.890780+00:00 1 9 1285 725 880 806 880 745 880 674 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]);