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 group_session = "exp_2023_04_27_14"

View and edit SQL

Suggested facets: player_1_id, player_2_id, player_1_station, player_2_station, task_started, 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_2023_04_27_14 161 -3 leopard cheetah 1682634658.3852026 2023-04-27T22:30:58.385203+00:00 0 10 1285 725 880 660 1660 660 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.4017293 2023-04-27T22:30:58.401729+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.4179215 2023-04-27T22:30:58.417922+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.4341075 2023-04-27T22:30:58.434108+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.450302 2023-04-27T22:30:58.450302+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.4665527 2023-04-27T22:30:58.466553+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.4828293 2023-04-27T22:30:58.482829+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.499121 2023-04-27T22:30:58.499121+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.5154247 2023-04-27T22:30:58.515425+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.5317023 2023-04-27T22:30:58.531702+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.5479774 2023-04-27T22:30:58.547977+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.563186 2023-04-27T22:30:58.563186+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.5794423 2023-04-27T22:30:58.579442+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.5957196 2023-04-27T22:30:58.595720+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.6119862 2023-04-27T22:30:58.611986+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.6273663 2023-04-27T22:30:58.627366+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.6436288 2023-04-27T22:30:58.643629+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.6598833 2023-04-27T22:30:58.659883+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.6751812 2023-04-27T22:30:58.675181+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.6914182 2023-04-27T22:30:58.691418+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.707641 2023-04-27T22:30:58.707641+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.7239132 2023-04-27T22:30:58.723913+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.7401516 2023-04-27T22:30:58.740152+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.756377 2023-04-27T22:30:58.756377+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.7726252 2023-04-27T22:30:58.772625+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.788881 2023-04-27T22:30:58.788881+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.8051374 2023-04-27T22:30:58.805137+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.821385 2023-04-27T22:30:58.821385+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.8376596 2023-04-27T22:30:58.837660+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.8539617 2023-04-27T22:30:58.853962+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.869287 2023-04-27T22:30:58.869287+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.8856122 2023-04-27T22:30:58.885612+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.9019864 2023-04-27T22:30:58.901986+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.9173076 2023-04-27T22:30:58.917308+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.9336617 2023-04-27T22:30:58.933662+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.9499476 2023-04-27T22:30:58.949948+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.9652386 2023-04-27T22:30:58.965239+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.981525 2023-04-27T22:30:58.981525+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634658.997805 2023-04-27T22:30:58.997805+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.0141075 2023-04-27T22:30:59.014107+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.0293915 2023-04-27T22:30:59.029392+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.0456648 2023-04-27T22:30:59.045665+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.0619326 2023-04-27T22:30:59.061933+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.0771916 2023-04-27T22:30:59.077192+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.0934854 2023-04-27T22:30:59.093485+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.1097715 2023-04-27T22:30:59.109771+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.1260552 2023-04-27T22:30:59.126055+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.1413355 2023-04-27T22:30:59.141335+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.1575863 2023-04-27T22:30:59.157586+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.1738188 2023-04-27T22:30:59.173819+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.1901042 2023-04-27T22:30:59.190104+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.205379 2023-04-27T22:30:59.205379+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.2216575 2023-04-27T22:30:59.221658+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.2379544 2023-04-27T22:30:59.237954+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.2532597 2023-04-27T22:30:59.253260+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.2695594 2023-04-27T22:30:59.269559+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.285875 2023-04-27T22:30:59.285875+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.301183 2023-04-27T22:30:59.301183+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.3174496 2023-04-27T22:30:59.317450+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.3337395 2023-04-27T22:30:59.333740+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.3500497 2023-04-27T22:30:59.350050+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.3653288 2023-04-27T22:30:59.365329+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.381593 2023-04-27T22:30:59.381593+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.3978498 2023-04-27T22:30:59.397850+00:00 0 10 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.4140737 2023-04-27T22:30:59.414074+00:00 0 9 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.4293387 2023-04-27T22:30:59.429339+00:00 0 9 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.4456332 2023-04-27T22:30:59.445633+00:00 0 9 1285 725 880 850 1660 850 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.4619894 2023-04-27T22:30:59.461989+00:00 0 9 1285 725 880 850 1660 837 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.4772449 2023-04-27T22:30:59.477245+00:00 0 9 1285 725 880 850 1660 813 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.4935038 2023-04-27T22:30:59.493504+00:00 0 9 1285 725 880 850 1660 783 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.509827 2023-04-27T22:30:59.509827+00:00 0 9 1285 725 880 850 1660 756 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.5261385 2023-04-27T22:30:59.526139+00:00 0 9 1285 725 880 850 1660 731 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.5424683 2023-04-27T22:30:59.542468+00:00 0 9 1285 725 880 850 1660 710 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.5587966 2023-04-27T22:30:59.558797+00:00 0 9 1285 725 880 850 1660 694 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.575054 2023-04-27T22:30:59.575054+00:00 0 9 1285 725 880 850 1660 681 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.5902994 2023-04-27T22:30:59.590299+00:00 0 9 1285 725 880 850 1660 671 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.6066084 2023-04-27T22:30:59.606608+00:00 0 9 1285 725 880 850 1660 665 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.6229105 2023-04-27T22:30:59.622910+00:00 0 9 1285 725 880 850 1660 663 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.6382334 2023-04-27T22:30:59.638233+00:00 0 9 1285 725 880 850 1660 663 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.654528 2023-04-27T22:30:59.654528+00:00 0 9 1285 725 880 850 1660 663 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.670888 2023-04-27T22:30:59.670888+00:00 0 9 1285 725 880 850 1660 659 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.687186 2023-04-27T22:30:59.687186+00:00 0 9 1285 725 880 850 1660 659 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.7034554 2023-04-27T22:30:59.703455+00:00 0 9 1285 725 880 850 1660 659 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.7197335 2023-04-27T22:30:59.719733+00:00 0 9 1285 725 880 850 1660 663 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.736023 2023-04-27T22:30:59.736023+00:00 0 9 1285 725 880 850 1660 672 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.7513218 2023-04-27T22:30:59.751322+00:00 0 9 1285 725 880 850 1660 688 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.767618 2023-04-27T22:30:59.767618+00:00 0 9 1285 725 880 850 1660 712 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.7839031 2023-04-27T22:30:59.783903+00:00 0 9 1285 725 880 850 1660 750 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.8002045 2023-04-27T22:30:59.800205+00:00 0 9 1285 725 880 850 1660 769 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.816518 2023-04-27T22:30:59.816518+00:00 0 9 1285 725 880 850 1660 782 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.832824 2023-04-27T22:30:59.832824+00:00 0 9 1285 725 880 850 1660 783 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.8491318 2023-04-27T22:30:59.849132+00:00 0 9 1285 725 880 850 1660 784 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.8644347 2023-04-27T22:30:59.864435+00:00 0 9 1285 725 880 850 1660 774 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.8806956 2023-04-27T22:30:59.880696+00:00 0 9 1285 725 880 850 1660 774 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.896912 2023-04-27T22:30:59.896912+00:00 0 9 1285 725 880 850 1660 759 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.9131937 2023-04-27T22:30:59.913194+00:00 0 9 1285 725 880 850 1660 741 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.929477 2023-04-27T22:30:59.929477+00:00 0 9 1285 725 880 850 1660 720 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.945747 2023-04-27T22:30:59.945747+00:00 0 9 1285 725 880 850 1660 698 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.9619973 2023-04-27T22:30:59.961997+00:00 0 9 1285 725 880 850 1660 683 0 0
exp_2023_04_27_14 161 -3 leopard cheetah 1682634659.9772284 2023-04-27T22:30:59.977228+00:00 0 9 1285 725 880 850 1660 668 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]);