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

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

- column - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

Sort... Sort by group_session Sort by player_1_id Sort by player_2_id Sort by player_3_id Sort by timestamp_unix Sort by timestamp_iso8601 Sort by task_started Sort by seconds Sort by ball_position_x Sort by ball_position_y Sort by player_1_paddle_position_x Sort by player_1_paddle_position_y Sort by player_2_paddle_position_x Sort by player_2_paddle_position_y Sort by player_3_paddle_position_x Sort by player_3_paddle_position_y Sort by ai_paddle_position_x Sort by ai_paddle_position_y Sort by team_score Sort by ai_score

descending

✎ View and edit SQL

This data as json, copyable

0 records

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]);