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_11_01_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_11_01_10 63 67 lion tiger 1667328437.1777327 2022-11-01T18:47:17.177733+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.1935632 2022-11-01T18:47:17.193563+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.2097328 2022-11-01T18:47:17.209733+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.2248957 2022-11-01T18:47:17.224896+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.2410574 2022-11-01T18:47:17.241057+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.2572012 2022-11-01T18:47:17.257201+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.2733624 2022-11-01T18:47:17.273362+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.2895262 2022-11-01T18:47:17.289526+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.3056757 2022-11-01T18:47:17.305676+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.3208237 2022-11-01T18:47:17.320824+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.3369853 2022-11-01T18:47:17.336985+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.3531494 2022-11-01T18:47:17.353149+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.369309 2022-11-01T18:47:17.369309+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.3854628 2022-11-01T18:47:17.385463+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.4016147 2022-11-01T18:47:17.401615+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.4177606 2022-11-01T18:47:17.417761+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.4339125 2022-11-01T18:47:17.433913+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.4500654 2022-11-01T18:47:17.450065+00:00 1 10 1285 725 880 802 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.466214 2022-11-01T18:47:17.466214+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.4823704 2022-11-01T18:47:17.482370+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.4985344 2022-11-01T18:47:17.498534+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.5146909 2022-11-01T18:47:17.514691+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.5298605 2022-11-01T18:47:17.529860+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.5460315 2022-11-01T18:47:17.546031+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.5622172 2022-11-01T18:47:17.562217+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.5784085 2022-11-01T18:47:17.578408+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.594588 2022-11-01T18:47:17.594588+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.6107707 2022-11-01T18:47:17.610771+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.6269562 2022-11-01T18:47:17.626956+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.6431475 2022-11-01T18:47:17.643147+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.6592796 2022-11-01T18:47:17.659280+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.6753953 2022-11-01T18:47:17.675395+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.6915197 2022-11-01T18:47:17.691520+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.707661 2022-11-01T18:47:17.707661+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.7228286 2022-11-01T18:47:17.722829+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.7389631 2022-11-01T18:47:17.738963+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.7550988 2022-11-01T18:47:17.755099+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.7712288 2022-11-01T18:47:17.771229+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.787358 2022-11-01T18:47:17.787358+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.803493 2022-11-01T18:47:17.803493+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.8196309 2022-11-01T18:47:17.819631+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.8357584 2022-11-01T18:47:17.835758+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.8518965 2022-11-01T18:47:17.851897+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.8680227 2022-11-01T18:47:17.868023+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.8841546 2022-11-01T18:47:17.884155+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.9002833 2022-11-01T18:47:17.900283+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.9164128 2022-11-01T18:47:17.916413+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.9325464 2022-11-01T18:47:17.932546+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.9486752 2022-11-01T18:47:17.948675+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.9648046 2022-11-01T18:47:17.964805+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.9809396 2022-11-01T18:47:17.980940+00:00 1 10 1285 725 880 850 1660 611 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328437.9970684 2022-11-01T18:47:17.997068+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.0131974 2022-11-01T18:47:18.013197+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.0293317 2022-11-01T18:47:18.029332+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.0454717 2022-11-01T18:47:18.045472+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.0616438 2022-11-01T18:47:18.061644+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.076858 2022-11-01T18:47:18.076858+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.0930512 2022-11-01T18:47:18.093051+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.109261 2022-11-01T18:47:18.109261+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.1254451 2022-11-01T18:47:18.125445+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.14163 2022-11-01T18:47:18.141630+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.1578252 2022-11-01T18:47:18.157825+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.1740155 2022-11-01T18:47:18.174016+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.1901948 2022-11-01T18:47:18.190195+00:00 1 10 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.2064362 2022-11-01T18:47:18.206436+00:00 1 9 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.2227194 2022-11-01T18:47:18.222719+00:00 1 9 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.237988 2022-11-01T18:47:18.237988+00:00 1 9 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.2542346 2022-11-01T18:47:18.254235+00:00 1 9 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.270401 2022-11-01T18:47:18.270401+00:00 1 9 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.2865376 2022-11-01T18:47:18.286538+00:00 1 9 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.302692 2022-11-01T18:47:18.302692+00:00 1 9 1285 725 880 850 1660 662 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.317855 2022-11-01T18:47:18.317855+00:00 1 9 1285 725 880 850 1660 661 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.3340266 2022-11-01T18:47:18.334027+00:00 1 9 1285 725 880 850 1660 661 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.350177 2022-11-01T18:47:18.350177+00:00 1 9 1285 725 880 850 1660 661 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.3663337 2022-11-01T18:47:18.366334+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.3824852 2022-11-01T18:47:18.382485+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.3986633 2022-11-01T18:47:18.398663+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.4148374 2022-11-01T18:47:18.414837+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.4309995 2022-11-01T18:47:18.431000+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.4471798 2022-11-01T18:47:18.447180+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.4633608 2022-11-01T18:47:18.463361+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.479533 2022-11-01T18:47:18.479533+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.4956791 2022-11-01T18:47:18.495679+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.511836 2022-11-01T18:47:18.511836+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.5280247 2022-11-01T18:47:18.528025+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.5442595 2022-11-01T18:47:18.544260+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.5604677 2022-11-01T18:47:18.560468+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.5765853 2022-11-01T18:47:18.576585+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.5927038 2022-11-01T18:47:18.592704+00:00 1 9 1285 725 880 850 1660 660 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.6088765 2022-11-01T18:47:18.608876+00:00 1 9 1285 725 880 850 1660 663 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.625153 2022-11-01T18:47:18.625153+00:00 1 9 1285 725 880 850 1660 664 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.6414137 2022-11-01T18:47:18.641414+00:00 1 9 1285 725 880 850 1660 664 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.6576426 2022-11-01T18:47:18.657643+00:00 1 9 1285 725 880 850 1660 665 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.6738439 2022-11-01T18:47:18.673844+00:00 1 9 1285 725 880 850 1660 665 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.6900532 2022-11-01T18:47:18.690053+00:00 1 9 1285 725 880 850 1660 665 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.7062585 2022-11-01T18:47:18.706259+00:00 1 9 1285 725 880 850 1660 664 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.7223988 2022-11-01T18:47:18.722399+00:00 1 9 1285 725 880 850 1660 663 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.7385535 2022-11-01T18:47:18.738554+00:00 1 9 1285 725 880 850 1660 663 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.754708 2022-11-01T18:47:18.754708+00:00 1 9 1285 725 880 850 1660 663 0 0
exp_2022_11_01_10 63 67 lion tiger 1667328438.7698693 2022-11-01T18:47:18.769869+00:00 1 9 1285 725 880 850 1660 663 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]);