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

View and edit SQL

Suggested facets: 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_18_14 134 136 lion tiger 1681857449.6093326 2023-04-18T22:37:29.609333+00:00 0 10 1285 725 880 660 1660 660 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.6255867 2023-04-18T22:37:29.625587+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.6417835 2023-04-18T22:37:29.641783+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.6569815 2023-04-18T22:37:29.656981+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.6731758 2023-04-18T22:37:29.673176+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.6893687 2023-04-18T22:37:29.689369+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.7055576 2023-04-18T22:37:29.705558+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.7217453 2023-04-18T22:37:29.721745+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.7369614 2023-04-18T22:37:29.736961+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.7532299 2023-04-18T22:37:29.753230+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.7695053 2023-04-18T22:37:29.769505+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.7857308 2023-04-18T22:37:29.785731+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.8009324 2023-04-18T22:37:29.800932+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.8171165 2023-04-18T22:37:29.817116+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.833323 2023-04-18T22:37:29.833323+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.8495555 2023-04-18T22:37:29.849555+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.865727 2023-04-18T22:37:29.865727+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.8809392 2023-04-18T22:37:29.880939+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.897136 2023-04-18T22:37:29.897136+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.9133058 2023-04-18T22:37:29.913306+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.929557 2023-04-18T22:37:29.929557+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.945819 2023-04-18T22:37:29.945819+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.9610362 2023-04-18T22:37:29.961036+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.9772441 2023-04-18T22:37:29.977244+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857449.993443 2023-04-18T22:37:29.993443+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.0096488 2023-04-18T22:37:30.009649+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.025847 2023-04-18T22:37:30.025847+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.0410662 2023-04-18T22:37:30.041066+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.0572865 2023-04-18T22:37:30.057287+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.0734856 2023-04-18T22:37:30.073486+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.0896995 2023-04-18T22:37:30.089700+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.1059256 2023-04-18T22:37:30.105926+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.122151 2023-04-18T22:37:30.122151+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.13838 2023-04-18T22:37:30.138380+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.1546557 2023-04-18T22:37:30.154656+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.1708713 2023-04-18T22:37:30.170871+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.1870704 2023-04-18T22:37:30.187070+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.2032635 2023-04-18T22:37:30.203264+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.2194707 2023-04-18T22:37:30.219471+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.2356813 2023-04-18T22:37:30.235681+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.2518775 2023-04-18T22:37:30.251878+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.2681231 2023-04-18T22:37:30.268123+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.284339 2023-04-18T22:37:30.284339+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.300578 2023-04-18T22:37:30.300578+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.3168032 2023-04-18T22:37:30.316803+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.3320422 2023-04-18T22:37:30.332042+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.3482745 2023-04-18T22:37:30.348274+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.3645656 2023-04-18T22:37:30.364566+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.380773 2023-04-18T22:37:30.380773+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.3959608 2023-04-18T22:37:30.395961+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.412154 2023-04-18T22:37:30.412154+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.4283314 2023-04-18T22:37:30.428331+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.4445333 2023-04-18T22:37:30.444533+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.4607258 2023-04-18T22:37:30.460726+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.4769328 2023-04-18T22:37:30.476933+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.4931715 2023-04-18T22:37:30.493171+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.5094175 2023-04-18T22:37:30.509418+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.5256655 2023-04-18T22:37:30.525666+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.5419116 2023-04-18T22:37:30.541912+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.5582247 2023-04-18T22:37:30.558225+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.574466 2023-04-18T22:37:30.574466+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.590676 2023-04-18T22:37:30.590676+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.6068938 2023-04-18T22:37:30.606894+00:00 0 10 1285 725 880 803 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.6231058 2023-04-18T22:37:30.623106+00:00 0 10 1285 725 880 805 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.639331 2023-04-18T22:37:30.639331+00:00 0 9 1285 725 880 806 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.6555405 2023-04-18T22:37:30.655540+00:00 0 9 1285 725 880 810 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.6717606 2023-04-18T22:37:30.671761+00:00 0 9 1285 725 880 811 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.6869657 2023-04-18T22:37:30.686966+00:00 0 9 1285 725 880 814 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.7031834 2023-04-18T22:37:30.703183+00:00 0 9 1285 725 880 815 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.7194219 2023-04-18T22:37:30.719422+00:00 0 9 1285 725 880 816 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.7356603 2023-04-18T22:37:30.735660+00:00 0 9 1285 725 880 820 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.7518923 2023-04-18T22:37:30.751892+00:00 0 9 1285 725 880 821 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.767175 2023-04-18T22:37:30.767175+00:00 0 9 1285 725 880 822 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.7834342 2023-04-18T22:37:30.783434+00:00 0 9 1285 725 880 822 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.799679 2023-04-18T22:37:30.799679+00:00 0 9 1285 725 880 822 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.8159444 2023-04-18T22:37:30.815944+00:00 0 9 1285 725 880 822 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.8321822 2023-04-18T22:37:30.832182+00:00 0 9 1285 725 880 822 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.8483965 2023-04-18T22:37:30.848397+00:00 0 9 1285 725 880 824 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.864667 2023-04-18T22:37:30.864667+00:00 0 9 1285 725 880 824 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.880812 2023-04-18T22:37:30.880812+00:00 0 9 1285 725 880 824 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.896016 2023-04-18T22:37:30.896016+00:00 0 9 1285 725 880 824 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.912186 2023-04-18T22:37:30.912186+00:00 0 9 1285 725 880 824 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.9283495 2023-04-18T22:37:30.928349+00:00 0 9 1285 725 880 825 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.9445384 2023-04-18T22:37:30.944538+00:00 0 9 1285 725 880 828 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.9607463 2023-04-18T22:37:30.960746+00:00 0 9 1285 725 880 833 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.9769483 2023-04-18T22:37:30.976948+00:00 0 9 1285 725 880 838 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857450.993209 2023-04-18T22:37:30.993209+00:00 0 9 1285 725 880 839 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.009407 2023-04-18T22:37:31.009407+00:00 0 9 1285 725 880 839 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.02561 2023-04-18T22:37:31.025610+00:00 0 9 1285 725 880 842 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.0418048 2023-04-18T22:37:31.041805+00:00 0 9 1285 725 880 842 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.0570042 2023-04-18T22:37:31.057004+00:00 0 9 1285 725 880 842 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.073197 2023-04-18T22:37:31.073197+00:00 0 9 1285 725 880 842 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.0893934 2023-04-18T22:37:31.089393+00:00 0 9 1285 725 880 842 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.1056151 2023-04-18T22:37:31.105615+00:00 0 9 1285 725 880 842 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.1218605 2023-04-18T22:37:31.121861+00:00 0 9 1285 725 880 842 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.137083 2023-04-18T22:37:31.137083+00:00 0 9 1285 725 880 842 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.153311 2023-04-18T22:37:31.153311+00:00 0 9 1285 725 880 839 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.169524 2023-04-18T22:37:31.169524+00:00 0 9 1285 725 880 835 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.1857443 2023-04-18T22:37:31.185744+00:00 0 9 1285 725 880 830 1660 850 0 0
exp_2023_04_18_14 134 136 lion tiger 1681857451.2019756 2023-04-18T22:37:31.201976+00:00 0 9 1285 725 880 818 1660 850 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]);