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_1_station
Player 1's station.
player_2_station
Player 2's station.
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_1_score
Player 1's score.
player_2_score
Player 2's score.

where player_1_id = 12

View and edit SQL

Suggested facets: player_1_score, player_2_score, timestamp_iso8601 (date)

Link group_session player_1_id player_2_id player_1_station player_2_station 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_1_score player_2_score
exp_2022_09_30_10 12 13 lion tiger 1664564399.6640615 2022-09-30T18:59:59.664062+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.6798704 2022-09-30T18:59:59.679870+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.6960738 2022-09-30T18:59:59.696074+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.7112477 2022-09-30T18:59:59.711248+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.7273953 2022-09-30T18:59:59.727395+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.7435377 2022-09-30T18:59:59.743538+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.759711 2022-09-30T18:59:59.759711+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.775879 2022-09-30T18:59:59.775879+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.7920277 2022-09-30T18:59:59.792028+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.808201 2022-09-30T18:59:59.808201+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.824373 2022-09-30T18:59:59.824373+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.8405383 2022-09-30T18:59:59.840538+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.856712 2022-09-30T18:59:59.856712+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.8729024 2022-09-30T18:59:59.872902+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.8890696 2022-09-30T18:59:59.889070+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.9042351 2022-09-30T18:59:59.904235+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.920397 2022-09-30T18:59:59.920397+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.9365425 2022-09-30T18:59:59.936543+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.952688 2022-09-30T18:59:59.952688+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.9688308 2022-09-30T18:59:59.968831+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564399.9850056 2022-09-30T18:59:59.985006+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.0002291 2022-09-30T19:00:00.000229+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.016423 2022-09-30T19:00:00.016423+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.032569 2022-09-30T19:00:00.032569+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.048705 2022-09-30T19:00:00.048705+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.0648427 2022-09-30T19:00:00.064843+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.080971 2022-09-30T19:00:00.080971+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.097117 2022-09-30T19:00:00.097117+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.112256 2022-09-30T19:00:00.112256+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.128383 2022-09-30T19:00:00.128383+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.1445043 2022-09-30T19:00:00.144504+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.1606336 2022-09-30T19:00:00.160634+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.1767657 2022-09-30T19:00:00.176766+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.1928887 2022-09-30T19:00:00.192889+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.2090335 2022-09-30T19:00:00.209033+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.2251632 2022-09-30T19:00:00.225163+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.2413034 2022-09-30T19:00:00.241303+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.2574549 2022-09-30T19:00:00.257455+00:00 1 10 1285 725 880 470 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.2735813 2022-09-30T19:00:00.273581+00:00 1 10 1285 725 880 749 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.289715 2022-09-30T19:00:00.289715+00:00 1 10 1285 725 880 749 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.3058884 2022-09-30T19:00:00.305888+00:00 1 10 1285 725 880 749 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.3221602 2022-09-30T19:00:00.322160+00:00 1 10 1285 725 880 750 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.3383124 2022-09-30T19:00:00.338312+00:00 1 10 1285 725 880 754 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.3544369 2022-09-30T19:00:00.354437+00:00 1 10 1285 725 880 754 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.370543 2022-09-30T19:00:00.370543+00:00 1 10 1285 725 880 754 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.3866572 2022-09-30T19:00:00.386657+00:00 1 10 1285 725 880 754 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.402839 2022-09-30T19:00:00.402839+00:00 1 10 1285 725 880 754 1660 786 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.4190762 2022-09-30T19:00:00.419076+00:00 1 10 1285 725 880 754 1660 784 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.4342532 2022-09-30T19:00:00.434253+00:00 1 10 1285 725 880 754 1660 782 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.4504273 2022-09-30T19:00:00.450427+00:00 1 10 1285 725 880 754 1660 781 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.4665797 2022-09-30T19:00:00.466580+00:00 1 10 1285 725 880 754 1660 778 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.4827588 2022-09-30T19:00:00.482759+00:00 1 10 1285 725 880 760 1660 775 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.4989004 2022-09-30T19:00:00.498900+00:00 1 10 1285 725 880 770 1660 774 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.5150356 2022-09-30T19:00:00.515036+00:00 1 10 1285 725 880 796 1660 774 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.5311685 2022-09-30T19:00:00.531168+00:00 1 10 1285 725 880 817 1660 774 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.5473113 2022-09-30T19:00:00.547311+00:00 1 10 1285 725 880 823 1660 774 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.5634818 2022-09-30T19:00:00.563482+00:00 1 10 1285 725 880 823 1660 774 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.5796444 2022-09-30T19:00:00.579644+00:00 1 10 1285 725 880 822 1660 774 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.595834 2022-09-30T19:00:00.595834+00:00 1 10 1285 725 880 804 1660 775 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.6120114 2022-09-30T19:00:00.612011+00:00 1 10 1285 725 880 785 1660 776 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.6281767 2022-09-30T19:00:00.628177+00:00 1 10 1285 725 880 785 1660 777 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.644335 2022-09-30T19:00:00.644335+00:00 1 10 1285 725 880 785 1660 778 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.6605155 2022-09-30T19:00:00.660516+00:00 1 10 1285 725 880 782 1660 778 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.6766648 2022-09-30T19:00:00.676665+00:00 1 10 1285 725 880 782 1660 779 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.6928155 2022-09-30T19:00:00.692816+00:00 1 9 1285 725 880 782 1660 780 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.7090063 2022-09-30T19:00:00.709006+00:00 1 9 1285 725 880 782 1660 780 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.7251682 2022-09-30T19:00:00.725168+00:00 1 9 1285 725 880 783 1660 781 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.7413502 2022-09-30T19:00:00.741350+00:00 1 9 1285 725 880 787 1660 781 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.7575777 2022-09-30T19:00:00.757578+00:00 1 9 1285 725 880 797 1660 781 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.7738018 2022-09-30T19:00:00.773802+00:00 1 9 1285 725 880 803 1660 781 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.7899964 2022-09-30T19:00:00.789996+00:00 1 9 1285 725 880 803 1660 781 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.8062644 2022-09-30T19:00:00.806264+00:00 1 9 1285 725 880 807 1660 781 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.822532 2022-09-30T19:00:00.822532+00:00 1 9 1285 725 880 807 1660 781 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.8387773 2022-09-30T19:00:00.838777+00:00 1 9 1285 725 880 807 1660 781 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.8550155 2022-09-30T19:00:00.855016+00:00 1 9 1285 725 880 807 1660 778 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.8711867 2022-09-30T19:00:00.871187+00:00 1 9 1285 725 880 807 1660 773 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.8873718 2022-09-30T19:00:00.887372+00:00 1 9 1285 725 880 807 1660 764 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.9035952 2022-09-30T19:00:00.903595+00:00 1 9 1285 725 880 807 1660 755 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.919764 2022-09-30T19:00:00.919764+00:00 1 9 1285 725 880 807 1660 746 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.9359713 2022-09-30T19:00:00.935971+00:00 1 9 1285 725 880 807 1660 736 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.9521909 2022-09-30T19:00:00.952191+00:00 1 9 1285 725 880 807 1660 723 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.9683921 2022-09-30T19:00:00.968392+00:00 1 9 1285 725 880 807 1660 716 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564400.9845624 2022-09-30T19:00:00.984562+00:00 1 9 1285 725 880 807 1660 712 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.0007339 2022-09-30T19:00:01.000734+00:00 1 9 1285 725 880 807 1660 699 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.016868 2022-09-30T19:00:01.016868+00:00 1 9 1285 725 880 807 1660 695 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.0329988 2022-09-30T19:00:01.032999+00:00 1 9 1285 725 880 808 1660 686 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.0491426 2022-09-30T19:00:01.049143+00:00 1 9 1285 725 880 808 1660 672 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.06431 2022-09-30T19:00:01.064310+00:00 1 9 1285 725 880 808 1660 667 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.0804422 2022-09-30T19:00:01.080442+00:00 1 9 1285 725 880 808 1660 641 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.096586 2022-09-30T19:00:01.096586+00:00 1 9 1285 725 880 805 1660 629 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.112754 2022-09-30T19:00:01.112754+00:00 1 9 1285 725 880 798 1660 616 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.1288981 2022-09-30T19:00:01.128898+00:00 1 9 1285 725 880 788 1660 604 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.1450706 2022-09-30T19:00:01.145071+00:00 1 9 1285 725 880 777 1660 592 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.161238 2022-09-30T19:00:01.161238+00:00 1 9 1285 725 880 776 1660 592 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.1773803 2022-09-30T19:00:01.177380+00:00 1 9 1285 725 880 776 1660 582 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.1935222 2022-09-30T19:00:01.193522+00:00 1 9 1285 725 880 775 1660 573 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.2096894 2022-09-30T19:00:01.209689+00:00 1 9 1285 725 880 775 1660 565 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.2258332 2022-09-30T19:00:01.225833+00:00 1 9 1285 725 880 775 1660 559 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.2420044 2022-09-30T19:00:01.242004+00:00 1 9 1285 725 880 775 1660 554 0 0
exp_2022_09_30_10 12 13 lion tiger 1664564401.2581742 2022-09-30T19:00:01.258174+00:00 1 9 1285 725 880 776 1660 551 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "ping_pong_competitive_task_observation" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [player_1_id] INTEGER REFERENCES [participant]([id]),
   [player_2_id] INTEGER REFERENCES [participant]([id]),
   [player_1_station] TEXT REFERENCES [station]([id]),
   [player_2_station] TEXT REFERENCES [station]([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_1_score] INTEGER,
   [player_2_score] INTEGER,
   PRIMARY KEY ([group_session], [player_1_id], [player_2_id], [player_1_station], [player_2_station], [timestamp_unix])
);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_2_station]
    ON [ping_pong_competitive_task_observation] ([player_2_station]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_1_station]
    ON [ping_pong_competitive_task_observation] ([player_1_station]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_2_id]
    ON [ping_pong_competitive_task_observation] ([player_2_id]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_1_id]
    ON [ping_pong_competitive_task_observation] ([player_1_id]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_group_session]
    ON [ping_pong_competitive_task_observation] ([group_session]);