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_2022_10_27_10"

View and edit SQL

Suggested facets: player_1_id, player_2_id, player_1_station, player_2_station, 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_10_27_10 66 -3 leopard cheetah 1666896510.2952468 2022-10-27T18:48:30.295247+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.310951 2022-10-27T18:48:30.310951+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.3271153 2022-10-27T18:48:30.327115+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.3432772 2022-10-27T18:48:30.343277+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.3594382 2022-10-27T18:48:30.359438+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.3745995 2022-10-27T18:48:30.374599+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.3907578 2022-10-27T18:48:30.390758+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.406926 2022-10-27T18:48:30.406926+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.4230928 2022-10-27T18:48:30.423093+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.439279 2022-10-27T18:48:30.439279+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.4554555 2022-10-27T18:48:30.455456+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.4706478 2022-10-27T18:48:30.470648+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.4868426 2022-10-27T18:48:30.486843+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.503063 2022-10-27T18:48:30.503063+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.5192242 2022-10-27T18:48:30.519224+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.5353913 2022-10-27T18:48:30.535391+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.5515525 2022-10-27T18:48:30.551553+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.5677123 2022-10-27T18:48:30.567712+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.583871 2022-10-27T18:48:30.583871+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.600036 2022-10-27T18:48:30.600036+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.6162019 2022-10-27T18:48:30.616202+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.6323698 2022-10-27T18:48:30.632370+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.648527 2022-10-27T18:48:30.648527+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.6637378 2022-10-27T18:48:30.663738+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.6798954 2022-10-27T18:48:30.679895+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.6960618 2022-10-27T18:48:30.696062+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.7122278 2022-10-27T18:48:30.712228+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.7283905 2022-10-27T18:48:30.728390+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.744556 2022-10-27T18:48:30.744556+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.7607136 2022-10-27T18:48:30.760714+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.7768693 2022-10-27T18:48:30.776869+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.7930298 2022-10-27T18:48:30.793030+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.8091974 2022-10-27T18:48:30.809197+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.8253496 2022-10-27T18:48:30.825350+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.841506 2022-10-27T18:48:30.841506+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.8566647 2022-10-27T18:48:30.856665+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.872824 2022-10-27T18:48:30.872824+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.8889818 2022-10-27T18:48:30.888982+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.9051428 2022-10-27T18:48:30.905143+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.921305 2022-10-27T18:48:30.921305+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.9374647 2022-10-27T18:48:30.937465+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.95263 2022-10-27T18:48:30.952630+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.9687874 2022-10-27T18:48:30.968787+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896510.984952 2022-10-27T18:48:30.984952+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.0011241 2022-10-27T18:48:31.001124+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.0172546 2022-10-27T18:48:31.017255+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.033406 2022-10-27T18:48:31.033406+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.0495374 2022-10-27T18:48:31.049537+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.064658 2022-10-27T18:48:31.064658+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.0807707 2022-10-27T18:48:31.080771+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.096888 2022-10-27T18:48:31.096888+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.1130009 2022-10-27T18:48:31.113001+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.1291227 2022-10-27T18:48:31.129123+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.1452725 2022-10-27T18:48:31.145272+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.1614275 2022-10-27T18:48:31.161427+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.1775856 2022-10-27T18:48:31.177586+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.1937509 2022-10-27T18:48:31.193751+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.2099087 2022-10-27T18:48:31.209909+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.2260575 2022-10-27T18:48:31.226058+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.242212 2022-10-27T18:48:31.242212+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.258328 2022-10-27T18:48:31.258328+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.274484 2022-10-27T18:48:31.274484+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.2896478 2022-10-27T18:48:31.289648+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.3058043 2022-10-27T18:48:31.305804+00:00 1 10 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.3219643 2022-10-27T18:48:31.321964+00:00 1 9 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.3381143 2022-10-27T18:48:31.338114+00:00 1 9 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.3542957 2022-10-27T18:48:31.354296+00:00 1 9 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.3704834 2022-10-27T18:48:31.370483+00:00 1 9 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.385641 2022-10-27T18:48:31.385641+00:00 1 9 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.401787 2022-10-27T18:48:31.401787+00:00 1 9 1285 725 880 589 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.4179335 2022-10-27T18:48:31.417933+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.4341016 2022-10-27T18:48:31.434102+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.4502597 2022-10-27T18:48:31.450260+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.4664357 2022-10-27T18:48:31.466436+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.482598 2022-10-27T18:48:31.482598+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.4987562 2022-10-27T18:48:31.498756+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.5149136 2022-10-27T18:48:31.514914+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.531071 2022-10-27T18:48:31.531071+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.5472608 2022-10-27T18:48:31.547261+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.5634162 2022-10-27T18:48:31.563416+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.5795817 2022-10-27T18:48:31.579582+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.594742 2022-10-27T18:48:31.594742+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.610899 2022-10-27T18:48:31.610899+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.627033 2022-10-27T18:48:31.627033+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.643208 2022-10-27T18:48:31.643208+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.6593597 2022-10-27T18:48:31.659360+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.67548 2022-10-27T18:48:31.675480+00:00 1 9 1285 725 880 470 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.6906557 2022-10-27T18:48:31.690656+00:00 1 9 1285 725 880 473 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.7067854 2022-10-27T18:48:31.706785+00:00 1 9 1285 725 880 476 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.722913 2022-10-27T18:48:31.722913+00:00 1 9 1285 725 880 480 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.7390485 2022-10-27T18:48:31.739048+00:00 1 9 1285 725 880 484 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.755217 2022-10-27T18:48:31.755217+00:00 1 9 1285 725 880 484 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.7713835 2022-10-27T18:48:31.771384+00:00 1 9 1285 725 880 489 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.7875388 2022-10-27T18:48:31.787539+00:00 1 9 1285 725 880 495 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.8026912 2022-10-27T18:48:31.802691+00:00 1 9 1285 725 880 501 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.8188362 2022-10-27T18:48:31.818836+00:00 1 9 1285 725 880 506 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.8349934 2022-10-27T18:48:31.834993+00:00 1 9 1285 725 880 512 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.8511438 2022-10-27T18:48:31.851144+00:00 1 9 1285 725 880 526 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.8672888 2022-10-27T18:48:31.867289+00:00 1 9 1285 725 880 534 1660 660 0 0
exp_2022_10_27_10 66 -3 leopard cheetah 1666896511.8834453 2022-10-27T18:48:31.883445+00:00 1 9 1285 725 880 541 1660 660 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]);