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

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_12_05_12 85 90 lion tiger 1670273019.9606223 2022-12-05T20:43:39.960622+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273019.976339 2022-12-05T20:43:39.976339+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273019.992505 2022-12-05T20:43:39.992505+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.0086567 2022-12-05T20:43:40.008657+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.024819 2022-12-05T20:43:40.024819+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.0409875 2022-12-05T20:43:40.040987+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.0571501 2022-12-05T20:43:40.057150+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.0723152 2022-12-05T20:43:40.072315+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.0884736 2022-12-05T20:43:40.088474+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.1046326 2022-12-05T20:43:40.104633+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.1208258 2022-12-05T20:43:40.120826+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.1369956 2022-12-05T20:43:40.136996+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.1531565 2022-12-05T20:43:40.153157+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.1683204 2022-12-05T20:43:40.168320+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.184481 2022-12-05T20:43:40.184481+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.2006457 2022-12-05T20:43:40.200646+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.2168097 2022-12-05T20:43:40.216810+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.2329752 2022-12-05T20:43:40.232975+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.2491844 2022-12-05T20:43:40.249184+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.264344 2022-12-05T20:43:40.264344+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.2804923 2022-12-05T20:43:40.280492+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.2966588 2022-12-05T20:43:40.296659+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.312819 2022-12-05T20:43:40.312819+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.3289676 2022-12-05T20:43:40.328968+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.3451343 2022-12-05T20:43:40.345134+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.3612928 2022-12-05T20:43:40.361293+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.3774362 2022-12-05T20:43:40.377436+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.393602 2022-12-05T20:43:40.393602+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.4097655 2022-12-05T20:43:40.409765+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.4259064 2022-12-05T20:43:40.425906+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.442074 2022-12-05T20:43:40.442074+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.4582472 2022-12-05T20:43:40.458247+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.4734275 2022-12-05T20:43:40.473428+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.489598 2022-12-05T20:43:40.489598+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.5057561 2022-12-05T20:43:40.505756+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.5219214 2022-12-05T20:43:40.521921+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.5380714 2022-12-05T20:43:40.538071+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.55423 2022-12-05T20:43:40.554230+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.5693882 2022-12-05T20:43:40.569388+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.585603 2022-12-05T20:43:40.585603+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.6017718 2022-12-05T20:43:40.601772+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.61795 2022-12-05T20:43:40.617950+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.6340783 2022-12-05T20:43:40.634078+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.650247 2022-12-05T20:43:40.650247+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.66541 2022-12-05T20:43:40.665410+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.6815798 2022-12-05T20:43:40.681580+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.6977274 2022-12-05T20:43:40.697727+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.7138777 2022-12-05T20:43:40.713878+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.7300305 2022-12-05T20:43:40.730031+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.7461953 2022-12-05T20:43:40.746195+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.761386 2022-12-05T20:43:40.761386+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.7775946 2022-12-05T20:43:40.777595+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.7937539 2022-12-05T20:43:40.793754+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.8099234 2022-12-05T20:43:40.809923+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.826098 2022-12-05T20:43:40.826098+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.8422532 2022-12-05T20:43:40.842253+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.8574047 2022-12-05T20:43:40.857405+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.8736086 2022-12-05T20:43:40.873609+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.8897662 2022-12-05T20:43:40.889766+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.9059594 2022-12-05T20:43:40.905959+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.9221323 2022-12-05T20:43:40.922132+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.9383001 2022-12-05T20:43:40.938300+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.954466 2022-12-05T20:43:40.954466+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.9706306 2022-12-05T20:43:40.970631+00:00 1 10 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273020.9867966 2022-12-05T20:43:40.986797+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.002958 2022-12-05T20:43:41.002958+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.019124 2022-12-05T20:43:41.019124+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.035285 2022-12-05T20:43:41.035285+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.0504591 2022-12-05T20:43:41.050459+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.0666196 2022-12-05T20:43:41.066620+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.0828004 2022-12-05T20:43:41.082800+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.098971 2022-12-05T20:43:41.098971+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.1151292 2022-12-05T20:43:41.115129+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.13131 2022-12-05T20:43:41.131310+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.1474545 2022-12-05T20:43:41.147455+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.1636176 2022-12-05T20:43:41.163618+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.1797917 2022-12-05T20:43:41.179792+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.1959348 2022-12-05T20:43:41.195935+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.2121408 2022-12-05T20:43:41.212141+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.228309 2022-12-05T20:43:41.228309+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.2444677 2022-12-05T20:43:41.244468+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.2606382 2022-12-05T20:43:41.260638+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.2768066 2022-12-05T20:43:41.276807+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.2929544 2022-12-05T20:43:41.292954+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.309105 2022-12-05T20:43:41.309105+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.325278 2022-12-05T20:43:41.325278+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.3404264 2022-12-05T20:43:41.340426+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.3565645 2022-12-05T20:43:41.356565+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.372715 2022-12-05T20:43:41.372715+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.3888667 2022-12-05T20:43:41.388867+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.4050307 2022-12-05T20:43:41.405031+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.4211912 2022-12-05T20:43:41.421191+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.437342 2022-12-05T20:43:41.437342+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.4535005 2022-12-05T20:43:41.453501+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.4696627 2022-12-05T20:43:41.469663+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.4858282 2022-12-05T20:43:41.485828+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.501996 2022-12-05T20:43:41.501996+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.5181527 2022-12-05T20:43:41.518153+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.5343122 2022-12-05T20:43:41.534312+00:00 1 9 1285 725 880 630 1660 850 0 0
exp_2022_12_05_12 85 90 lion tiger 1670273021.5494819 2022-12-05T20:43:41.549482+00:00 1 9 1285 725 880 630 1660 850 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]);