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_07_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_07_10 27 -3 leopard cheetah 1667846334.844827 2022-11-07T18:38:54.844827+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846334.8604546 2022-11-07T18:38:54.860455+00:00 1 10 1285 725 880 688 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846334.8766935 2022-11-07T18:38:54.876693+00:00 1 10 1285 725 880 688 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846334.892889 2022-11-07T18:38:54.892889+00:00 1 10 1285 725 880 688 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846334.9090533 2022-11-07T18:38:54.909053+00:00 1 10 1285 725 880 688 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846334.9252179 2022-11-07T18:38:54.925218+00:00 1 10 1285 725 880 688 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846334.9414144 2022-11-07T18:38:54.941414+00:00 1 10 1285 725 880 688 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846334.9575906 2022-11-07T18:38:54.957591+00:00 1 10 1285 725 880 688 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846334.9737818 2022-11-07T18:38:54.973782+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846334.9889803 2022-11-07T18:38:54.988980+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.0051684 2022-11-07T18:38:55.005168+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.0213368 2022-11-07T18:38:55.021337+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.037505 2022-11-07T18:38:55.037505+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.053683 2022-11-07T18:38:55.053683+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.0698755 2022-11-07T18:38:55.069875+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.0850592 2022-11-07T18:38:55.085059+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.101288 2022-11-07T18:38:55.101288+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.117528 2022-11-07T18:38:55.117528+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.1337936 2022-11-07T18:38:55.133794+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.1490386 2022-11-07T18:38:55.149039+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.1652737 2022-11-07T18:38:55.165274+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.1815143 2022-11-07T18:38:55.181514+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.1977406 2022-11-07T18:38:55.197741+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.213955 2022-11-07T18:38:55.213955+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.2301803 2022-11-07T18:38:55.230180+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.246428 2022-11-07T18:38:55.246428+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.2627032 2022-11-07T18:38:55.262703+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.2789648 2022-11-07T18:38:55.278965+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.2952266 2022-11-07T18:38:55.295227+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.3115253 2022-11-07T18:38:55.311525+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.3277907 2022-11-07T18:38:55.327791+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.343041 2022-11-07T18:38:55.343041+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.359305 2022-11-07T18:38:55.359305+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.3755362 2022-11-07T18:38:55.375536+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.3917332 2022-11-07T18:38:55.391733+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.4078784 2022-11-07T18:38:55.407878+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.423027 2022-11-07T18:38:55.423027+00:00 1 10 1285 725 880 850 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.4391918 2022-11-07T18:38:55.439192+00:00 1 10 1285 725 880 848 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.455362 2022-11-07T18:38:55.455362+00:00 1 10 1285 725 880 841 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.4715226 2022-11-07T18:38:55.471523+00:00 1 10 1285 725 880 834 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.4876757 2022-11-07T18:38:55.487676+00:00 1 10 1285 725 880 827 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.5038276 2022-11-07T18:38:55.503828+00:00 1 10 1285 725 880 820 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.518981 2022-11-07T18:38:55.518981+00:00 1 10 1285 725 880 807 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.53513 2022-11-07T18:38:55.535130+00:00 1 10 1285 725 880 799 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.5512745 2022-11-07T18:38:55.551275+00:00 1 10 1285 725 880 786 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.567415 2022-11-07T18:38:55.567415+00:00 1 10 1285 725 880 786 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.5835385 2022-11-07T18:38:55.583539+00:00 1 10 1285 725 880 779 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.5996883 2022-11-07T18:38:55.599688+00:00 1 10 1285 725 880 772 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.6158404 2022-11-07T18:38:55.615840+00:00 1 10 1285 725 880 766 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.6309984 2022-11-07T18:38:55.630998+00:00 1 10 1285 725 880 762 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.6471438 2022-11-07T18:38:55.647144+00:00 1 10 1285 725 880 759 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.6633167 2022-11-07T18:38:55.663317+00:00 1 10 1285 725 880 757 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.6794832 2022-11-07T18:38:55.679483+00:00 1 10 1285 725 880 756 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.6956406 2022-11-07T18:38:55.695641+00:00 1 10 1285 725 880 756 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.7117946 2022-11-07T18:38:55.711795+00:00 1 10 1285 725 880 754 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.7279596 2022-11-07T18:38:55.727960+00:00 1 10 1285 725 880 753 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.74411 2022-11-07T18:38:55.744110+00:00 1 10 1285 725 880 752 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.7602613 2022-11-07T18:38:55.760261+00:00 1 10 1285 725 880 749 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.7764318 2022-11-07T18:38:55.776432+00:00 1 10 1285 725 880 748 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.792595 2022-11-07T18:38:55.792595+00:00 1 10 1285 725 880 746 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.8087614 2022-11-07T18:38:55.808761+00:00 1 10 1285 725 880 742 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.8249288 2022-11-07T18:38:55.824929+00:00 1 10 1285 725 880 742 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.8410962 2022-11-07T18:38:55.841096+00:00 1 10 1285 725 880 740 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.857249 2022-11-07T18:38:55.857249+00:00 1 10 1285 725 880 737 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.8734224 2022-11-07T18:38:55.873422+00:00 1 9 1285 725 880 732 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.8895845 2022-11-07T18:38:55.889585+00:00 1 9 1285 725 880 728 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.9057481 2022-11-07T18:38:55.905748+00:00 1 9 1285 725 880 719 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.921928 2022-11-07T18:38:55.921928+00:00 1 9 1285 725 880 716 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.9381018 2022-11-07T18:38:55.938102+00:00 1 9 1285 725 880 712 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.9542758 2022-11-07T18:38:55.954276+00:00 1 9 1285 725 880 708 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.9704418 2022-11-07T18:38:55.970442+00:00 1 9 1285 725 880 704 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846335.9866016 2022-11-07T18:38:55.986602+00:00 1 9 1285 725 880 704 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.0027544 2022-11-07T18:38:56.002754+00:00 1 9 1285 725 880 701 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.0189161 2022-11-07T18:38:56.018916+00:00 1 9 1285 725 880 700 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.0340915 2022-11-07T18:38:56.034091+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.0502548 2022-11-07T18:38:56.050255+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.066414 2022-11-07T18:38:56.066414+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.0825815 2022-11-07T18:38:56.082582+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.0987804 2022-11-07T18:38:56.098780+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.1149502 2022-11-07T18:38:56.114950+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.1311193 2022-11-07T18:38:56.131119+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.1472774 2022-11-07T18:38:56.147277+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.1634378 2022-11-07T18:38:56.163438+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.1796076 2022-11-07T18:38:56.179608+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.195766 2022-11-07T18:38:56.195766+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.2119222 2022-11-07T18:38:56.211922+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.227104 2022-11-07T18:38:56.227104+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.2432632 2022-11-07T18:38:56.243263+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.2594204 2022-11-07T18:38:56.259420+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.2755346 2022-11-07T18:38:56.275535+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.2916987 2022-11-07T18:38:56.291699+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.307852 2022-11-07T18:38:56.307852+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.323033 2022-11-07T18:38:56.323033+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.339207 2022-11-07T18:38:56.339207+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.3553793 2022-11-07T18:38:56.355379+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.3715334 2022-11-07T18:38:56.371533+00:00 1 9 1285 725 880 699 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.3876905 2022-11-07T18:38:56.387691+00:00 1 9 1285 725 880 698 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.4038475 2022-11-07T18:38:56.403847+00:00 1 9 1285 725 880 694 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.419018 2022-11-07T18:38:56.419018+00:00 1 9 1285 725 880 690 1660 660 0 0
exp_2022_11_07_10 27 -3 leopard cheetah 1667846336.435196 2022-11-07T18:38:56.435196+00:00 1 9 1285 725 880 690 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]);