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 = 59
✎ 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]);