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_2_id = 119

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

= != 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_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

= != 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_1_station Sort by player_2_station 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_1_score Sort by player_2_score

descending

✎ View and edit SQL

This data as json, copyable

0 records

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