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

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_24_13 151 153 lion tiger 1682371634.4788332 2023-04-24T21:27:14.478833+00:00 0 10 1285 725 880 660 1660 660 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.494085 2023-04-24T21:27:14.494085+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.510291 2023-04-24T21:27:14.510291+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.5264647 2023-04-24T21:27:14.526465+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.5426557 2023-04-24T21:27:14.542656+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.558853 2023-04-24T21:27:14.558853+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.574035 2023-04-24T21:27:14.574035+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.5901978 2023-04-24T21:27:14.590198+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.606373 2023-04-24T21:27:14.606373+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.622555 2023-04-24T21:27:14.622555+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.6387064 2023-04-24T21:27:14.638706+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.654892 2023-04-24T21:27:14.654892+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.670076 2023-04-24T21:27:14.670076+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.6862464 2023-04-24T21:27:14.686246+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.7024415 2023-04-24T21:27:14.702441+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.7186353 2023-04-24T21:27:14.718635+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.7348044 2023-04-24T21:27:14.734804+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.75098 2023-04-24T21:27:14.750980+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.7671747 2023-04-24T21:27:14.767175+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.7833755 2023-04-24T21:27:14.783376+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.7996101 2023-04-24T21:27:14.799610+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.815828 2023-04-24T21:27:14.815828+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.8310347 2023-04-24T21:27:14.831035+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.8472323 2023-04-24T21:27:14.847232+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.8634229 2023-04-24T21:27:14.863423+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.8796382 2023-04-24T21:27:14.879638+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.8958344 2023-04-24T21:27:14.895834+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.9110367 2023-04-24T21:27:14.911037+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.9272428 2023-04-24T21:27:14.927243+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.94342 2023-04-24T21:27:14.943420+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.959621 2023-04-24T21:27:14.959621+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.9758165 2023-04-24T21:27:14.975816+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371634.9919856 2023-04-24T21:27:14.991986+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.0081823 2023-04-24T21:27:15.008182+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.0243504 2023-04-24T21:27:15.024350+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.0405345 2023-04-24T21:27:15.040534+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.0567148 2023-04-24T21:27:15.056715+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.0729084 2023-04-24T21:27:15.072908+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.0881023 2023-04-24T21:27:15.088102+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.1043046 2023-04-24T21:27:15.104305+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.120473 2023-04-24T21:27:15.120473+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.1366384 2023-04-24T21:27:15.136638+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.152806 2023-04-24T21:27:15.152806+00:00 0 10 1285 725 880 850 1660 813 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.168991 2023-04-24T21:27:15.168991+00:00 0 10 1285 725 880 850 1660 612 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.1851757 2023-04-24T21:27:15.185176+00:00 0 10 1285 725 880 850 1660 612 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.2014081 2023-04-24T21:27:15.201408+00:00 0 10 1285 725 880 850 1660 612 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.217647 2023-04-24T21:27:15.217647+00:00 0 10 1285 725 880 850 1660 612 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.2338455 2023-04-24T21:27:15.233845+00:00 0 10 1285 725 880 850 1660 612 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.2500367 2023-04-24T21:27:15.250037+00:00 0 10 1285 725 880 850 1660 612 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.2662637 2023-04-24T21:27:15.266264+00:00 0 10 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.2824059 2023-04-24T21:27:15.282406+00:00 0 10 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.29854 2023-04-24T21:27:15.298540+00:00 0 10 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.3146787 2023-04-24T21:27:15.314679+00:00 0 10 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.3308187 2023-04-24T21:27:15.330819+00:00 0 10 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.3470125 2023-04-24T21:27:15.347013+00:00 0 10 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.36321 2023-04-24T21:27:15.363210+00:00 0 10 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.3793764 2023-04-24T21:27:15.379376+00:00 0 10 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.3955452 2023-04-24T21:27:15.395545+00:00 0 10 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.411746 2023-04-24T21:27:15.411746+00:00 0 10 1285 725 880 850 1660 610 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.4279418 2023-04-24T21:27:15.427942+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.44314 2023-04-24T21:27:15.443140+00:00 0 10 1285 725 880 850 1660 607 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.4593403 2023-04-24T21:27:15.459340+00:00 0 10 1285 725 880 850 1660 607 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.4755335 2023-04-24T21:27:15.475533+00:00 0 10 1285 725 880 850 1660 607 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.4916961 2023-04-24T21:27:15.491696+00:00 0 10 1285 725 880 850 1660 607 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.5079083 2023-04-24T21:27:15.507908+00:00 0 9 1285 725 880 850 1660 607 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.5231194 2023-04-24T21:27:15.523119+00:00 0 9 1285 725 880 850 1660 606 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.539303 2023-04-24T21:27:15.539303+00:00 0 9 1285 725 880 850 1660 606 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.5555074 2023-04-24T21:27:15.555507+00:00 0 9 1285 725 880 850 1660 603 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.5717018 2023-04-24T21:27:15.571702+00:00 0 9 1285 725 880 850 1660 600 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.5878723 2023-04-24T21:27:15.587872+00:00 0 9 1285 725 880 850 1660 597 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.603067 2023-04-24T21:27:15.603067+00:00 0 9 1285 725 880 850 1660 595 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.6192315 2023-04-24T21:27:15.619231+00:00 0 9 1285 725 880 850 1660 594 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.6354268 2023-04-24T21:27:15.635427+00:00 0 9 1285 725 880 850 1660 594 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.6515965 2023-04-24T21:27:15.651597+00:00 0 9 1285 725 880 850 1660 594 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.6678011 2023-04-24T21:27:15.667801+00:00 0 9 1285 725 880 850 1660 594 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.683977 2023-04-24T21:27:15.683977+00:00 0 9 1285 725 880 850 1660 593 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.699156 2023-04-24T21:27:15.699156+00:00 0 9 1285 725 880 850 1660 591 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.7153504 2023-04-24T21:27:15.715350+00:00 0 9 1285 725 880 850 1660 590 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.7315774 2023-04-24T21:27:15.731577+00:00 0 9 1285 725 880 850 1660 589 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.7477658 2023-04-24T21:27:15.747766+00:00 0 9 1285 725 880 850 1660 589 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.7640133 2023-04-24T21:27:15.764013+00:00 0 9 1285 725 880 850 1660 589 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.7802145 2023-04-24T21:27:15.780215+00:00 0 9 1285 725 880 850 1660 589 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.7964227 2023-04-24T21:27:15.796423+00:00 0 9 1285 725 880 850 1660 589 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.8126721 2023-04-24T21:27:15.812672+00:00 0 9 1285 725 880 850 1660 590 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.8289168 2023-04-24T21:27:15.828917+00:00 0 9 1285 725 880 850 1660 593 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.8441362 2023-04-24T21:27:15.844136+00:00 0 9 1285 725 880 850 1660 593 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.8604224 2023-04-24T21:27:15.860422+00:00 0 9 1285 725 880 850 1660 599 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.876699 2023-04-24T21:27:15.876699+00:00 0 9 1285 725 880 850 1660 605 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.8929448 2023-04-24T21:27:15.892945+00:00 0 9 1285 725 880 850 1660 611 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.9081986 2023-04-24T21:27:15.908199+00:00 0 9 1285 725 880 850 1660 617 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.9245095 2023-04-24T21:27:15.924510+00:00 0 9 1285 725 880 850 1660 621 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.9407368 2023-04-24T21:27:15.940737+00:00 0 9 1285 725 880 850 1660 624 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.9569302 2023-04-24T21:27:15.956930+00:00 0 9 1285 725 880 850 1660 624 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.972145 2023-04-24T21:27:15.972145+00:00 0 9 1285 725 880 850 1660 624 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371635.9883397 2023-04-24T21:27:15.988340+00:00 0 9 1285 725 880 850 1660 624 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371636.0045621 2023-04-24T21:27:16.004562+00:00 0 9 1285 725 880 850 1660 624 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371636.0207639 2023-04-24T21:27:16.020764+00:00 0 9 1285 725 880 850 1660 618 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371636.036962 2023-04-24T21:27:16.036962+00:00 0 9 1285 725 880 850 1660 599 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371636.0521605 2023-04-24T21:27:16.052161+00:00 0 9 1285 725 880 850 1660 585 0 0
exp_2023_04_24_13 151 153 lion tiger 1682371636.0683663 2023-04-24T21:27:16.068366+00:00 0 9 1285 725 880 850 1660 570 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]);