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_1_id = 158

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_05_02_14 158 164 lion tiger 1683067559.7409108 2023-05-02T22:45:59.740911+00:00 0 10 1285 725 880 660 1660 660 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.7570226 2023-05-02T22:45:59.757023+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.77321 2023-05-02T22:45:59.773210+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.7883978 2023-05-02T22:45:59.788398+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.804602 2023-05-02T22:45:59.804602+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.820771 2023-05-02T22:45:59.820771+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.8369477 2023-05-02T22:45:59.836948+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.8531764 2023-05-02T22:45:59.853176+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.8683543 2023-05-02T22:45:59.868354+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.8845384 2023-05-02T22:45:59.884538+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.900725 2023-05-02T22:45:59.900725+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.9168987 2023-05-02T22:45:59.916899+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.9330947 2023-05-02T22:45:59.933095+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.9492261 2023-05-02T22:45:59.949226+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.9654462 2023-05-02T22:45:59.965446+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.9816666 2023-05-02T22:45:59.981667+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067559.997867 2023-05-02T22:45:59.997867+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.0140724 2023-05-02T22:46:00.014072+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.0302792 2023-05-02T22:46:00.030279+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.0464878 2023-05-02T22:46:00.046488+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.0626836 2023-05-02T22:46:00.062684+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.0788803 2023-05-02T22:46:00.078880+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.0950801 2023-05-02T22:46:00.095080+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.1112897 2023-05-02T22:46:00.111290+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.1274836 2023-05-02T22:46:00.127484+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.143678 2023-05-02T22:46:00.143678+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.1598685 2023-05-02T22:46:00.159868+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.1760533 2023-05-02T22:46:00.176053+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.192268 2023-05-02T22:46:00.192268+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.2084754 2023-05-02T22:46:00.208475+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.2246811 2023-05-02T22:46:00.224681+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.2408726 2023-05-02T22:46:00.240873+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.2570593 2023-05-02T22:46:00.257059+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.2732308 2023-05-02T22:46:00.273231+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.288433 2023-05-02T22:46:00.288433+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.304681 2023-05-02T22:46:00.304681+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.320878 2023-05-02T22:46:00.320878+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.3370776 2023-05-02T22:46:00.337078+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.3532698 2023-05-02T22:46:00.353270+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.369476 2023-05-02T22:46:00.369476+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.385665 2023-05-02T22:46:00.385665+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.4018373 2023-05-02T22:46:00.401837+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.4180334 2023-05-02T22:46:00.418033+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.4342299 2023-05-02T22:46:00.434230+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.4494293 2023-05-02T22:46:00.449429+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.4656188 2023-05-02T22:46:00.465619+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.4818203 2023-05-02T22:46:00.481820+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.4980154 2023-05-02T22:46:00.498015+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.5142114 2023-05-02T22:46:00.514211+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.5294132 2023-05-02T22:46:00.529413+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.5456085 2023-05-02T22:46:00.545609+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.5617998 2023-05-02T22:46:00.561800+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.578 2023-05-02T22:46:00.578000+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.5941966 2023-05-02T22:46:00.594197+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.609395 2023-05-02T22:46:00.609395+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.6255777 2023-05-02T22:46:00.625578+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.6417716 2023-05-02T22:46:00.641772+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.6579576 2023-05-02T22:46:00.657958+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.6741362 2023-05-02T22:46:00.674136+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.6893249 2023-05-02T22:46:00.689325+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.7055037 2023-05-02T22:46:00.705504+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.7216995 2023-05-02T22:46:00.721699+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.7378957 2023-05-02T22:46:00.737896+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.7540812 2023-05-02T22:46:00.754081+00:00 0 10 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.7702577 2023-05-02T22:46:00.770258+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.7864494 2023-05-02T22:46:00.786449+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.8026433 2023-05-02T22:46:00.802643+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.818832 2023-05-02T22:46:00.818832+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.8350265 2023-05-02T22:46:00.835027+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.851219 2023-05-02T22:46:00.851219+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.8664055 2023-05-02T22:46:00.866405+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.8825984 2023-05-02T22:46:00.882598+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.898797 2023-05-02T22:46:00.898797+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.9149883 2023-05-02T22:46:00.914988+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.9312117 2023-05-02T22:46:00.931212+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.9464235 2023-05-02T22:46:00.946424+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.9626133 2023-05-02T22:46:00.962613+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.9788063 2023-05-02T22:46:00.978806+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067560.99503 2023-05-02T22:46:00.995030+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.0112214 2023-05-02T22:46:01.011221+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.0264235 2023-05-02T22:46:01.026423+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.0426133 2023-05-02T22:46:01.042613+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.058805 2023-05-02T22:46:01.058805+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.0749948 2023-05-02T22:46:01.074995+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.0911891 2023-05-02T22:46:01.091189+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.1063526 2023-05-02T22:46:01.106353+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.1225548 2023-05-02T22:46:01.122555+00:00 0 9 1285 725 880 850 1660 608 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.138755 2023-05-02T22:46:01.138755+00:00 0 9 1285 725 880 850 1660 599 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.1549454 2023-05-02T22:46:01.154945+00:00 0 9 1285 725 880 850 1660 578 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.1711469 2023-05-02T22:46:01.171147+00:00 0 9 1285 725 880 850 1660 567 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.186352 2023-05-02T22:46:01.186352+00:00 0 9 1285 725 880 850 1660 561 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.2025394 2023-05-02T22:46:01.202539+00:00 0 9 1285 725 880 850 1660 560 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.2187307 2023-05-02T22:46:01.218731+00:00 0 9 1285 725 880 850 1660 560 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.23493 2023-05-02T22:46:01.234930+00:00 0 9 1285 725 880 850 1660 566 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.2511206 2023-05-02T22:46:01.251121+00:00 0 9 1285 725 880 850 1660 566 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.2673151 2023-05-02T22:46:01.267315+00:00 0 9 1285 725 880 850 1660 567 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.2835143 2023-05-02T22:46:01.283514+00:00 0 9 1285 725 880 850 1660 567 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.2997005 2023-05-02T22:46:01.299700+00:00 0 9 1285 725 880 850 1660 567 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.3158987 2023-05-02T22:46:01.315899+00:00 0 9 1285 725 880 850 1660 566 0 0
exp_2023_05_02_14 158 164 lion tiger 1683067561.3320987 2023-05-02T22:46:01.332099+00:00 0 9 1285 725 880 850 1660 562 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]);