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_2023_02_07_14"

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_2023_02_07_14 97 111 lion tiger 1675808742.400618 2023-02-07T22:25:42.400618+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.4169917 2023-02-07T22:25:42.416992+00:00 1 10 1285 725 880 850 1660 703 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.4331555 2023-02-07T22:25:42.433156+00:00 1 10 1285 725 880 829 1660 713 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.4493155 2023-02-07T22:25:42.449316+00:00 1 10 1285 725 880 829 1660 714 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.4654567 2023-02-07T22:25:42.465457+00:00 1 10 1285 725 880 829 1660 715 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.4816165 2023-02-07T22:25:42.481616+00:00 1 10 1285 725 880 829 1660 716 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.4977689 2023-02-07T22:25:42.497769+00:00 1 10 1285 725 880 829 1660 717 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.513909 2023-02-07T22:25:42.513909+00:00 1 10 1285 725 880 829 1660 717 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.5300646 2023-02-07T22:25:42.530065+00:00 1 10 1285 725 880 829 1660 718 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.546219 2023-02-07T22:25:42.546219+00:00 1 10 1285 725 880 829 1660 719 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.5613742 2023-02-07T22:25:42.561374+00:00 1 10 1285 725 880 829 1660 721 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.5775297 2023-02-07T22:25:42.577530+00:00 1 10 1285 725 880 829 1660 722 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.5936885 2023-02-07T22:25:42.593688+00:00 1 10 1285 725 880 829 1660 723 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.6098378 2023-02-07T22:25:42.609838+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.6259723 2023-02-07T22:25:42.625972+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.6421335 2023-02-07T22:25:42.642133+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.658271 2023-02-07T22:25:42.658271+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.6734354 2023-02-07T22:25:42.673435+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.6896026 2023-02-07T22:25:42.689603+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.7057438 2023-02-07T22:25:42.705744+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.7218711 2023-02-07T22:25:42.721871+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.7379856 2023-02-07T22:25:42.737986+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.7541459 2023-02-07T22:25:42.754146+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.770301 2023-02-07T22:25:42.770301+00:00 1 10 1285 725 880 829 1660 724 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.7864408 2023-02-07T22:25:42.786441+00:00 1 10 1285 725 880 829 1660 725 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.8026035 2023-02-07T22:25:42.802603+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.818741 2023-02-07T22:25:42.818741+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.8348818 2023-02-07T22:25:42.834882+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.8510425 2023-02-07T22:25:42.851043+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.8672101 2023-02-07T22:25:42.867210+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.8823743 2023-02-07T22:25:42.882374+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.8985405 2023-02-07T22:25:42.898540+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.9146807 2023-02-07T22:25:42.914681+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.9308162 2023-02-07T22:25:42.930816+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.9469752 2023-02-07T22:25:42.946975+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.9631228 2023-02-07T22:25:42.963123+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.9792836 2023-02-07T22:25:42.979284+00:00 1 10 1285 725 880 829 1660 726 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808742.9944386 2023-02-07T22:25:42.994439+00:00 1 10 1285 725 880 829 1660 723 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.0105736 2023-02-07T22:25:43.010574+00:00 1 10 1285 725 880 828 1660 722 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.0267146 2023-02-07T22:25:43.026715+00:00 1 10 1285 725 880 827 1660 718 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.04289 2023-02-07T22:25:43.042890+00:00 1 10 1285 725 880 827 1660 713 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.059057 2023-02-07T22:25:43.059057+00:00 1 10 1285 725 880 827 1660 713 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.0752008 2023-02-07T22:25:43.075201+00:00 1 10 1285 725 880 827 1660 707 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.091371 2023-02-07T22:25:43.091371+00:00 1 10 1285 725 880 827 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.1075356 2023-02-07T22:25:43.107536+00:00 1 10 1285 725 880 827 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.1236725 2023-02-07T22:25:43.123672+00:00 1 10 1285 725 880 827 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.1398494 2023-02-07T22:25:43.139849+00:00 1 10 1285 725 880 827 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.1560159 2023-02-07T22:25:43.156016+00:00 1 10 1285 725 880 823 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.1721585 2023-02-07T22:25:43.172158+00:00 1 10 1285 725 880 816 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.188328 2023-02-07T22:25:43.188328+00:00 1 10 1285 725 880 816 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.2044928 2023-02-07T22:25:43.204493+00:00 1 10 1285 725 880 816 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.2206333 2023-02-07T22:25:43.220633+00:00 1 10 1285 725 880 816 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.2368069 2023-02-07T22:25:43.236807+00:00 1 10 1285 725 880 816 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.2529738 2023-02-07T22:25:43.252974+00:00 1 10 1285 725 880 816 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.2691128 2023-02-07T22:25:43.269113+00:00 1 10 1285 725 880 816 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.2852788 2023-02-07T22:25:43.285279+00:00 1 10 1285 725 880 816 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.3004427 2023-02-07T22:25:43.300443+00:00 1 10 1285 725 880 816 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.3166378 2023-02-07T22:25:43.316638+00:00 1 10 1285 725 880 815 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.332798 2023-02-07T22:25:43.332798+00:00 1 10 1285 725 880 814 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.3489614 2023-02-07T22:25:43.348961+00:00 1 10 1285 725 880 814 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.365127 2023-02-07T22:25:43.365127+00:00 1 10 1285 725 880 814 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.3813028 2023-02-07T22:25:43.381303+00:00 1 10 1285 725 880 813 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.3964844 2023-02-07T22:25:43.396484+00:00 1 10 1285 725 880 809 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.4126453 2023-02-07T22:25:43.412645+00:00 1 10 1285 725 880 803 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.4287806 2023-02-07T22:25:43.428781+00:00 1 9 1285 725 880 803 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.444945 2023-02-07T22:25:43.444945+00:00 1 9 1285 725 880 802 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.4610736 2023-02-07T22:25:43.461074+00:00 1 9 1285 725 880 799 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.477207 2023-02-07T22:25:43.477207+00:00 1 9 1285 725 880 796 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.4933789 2023-02-07T22:25:43.493379+00:00 1 9 1285 725 880 796 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.5095432 2023-02-07T22:25:43.509543+00:00 1 9 1285 725 880 796 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.5256853 2023-02-07T22:25:43.525685+00:00 1 9 1285 725 880 801 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.5418565 2023-02-07T22:25:43.541857+00:00 1 9 1285 725 880 811 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.5580227 2023-02-07T22:25:43.558023+00:00 1 9 1285 725 880 824 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.5741708 2023-02-07T22:25:43.574171+00:00 1 9 1285 725 880 840 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.5903375 2023-02-07T22:25:43.590338+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.6065023 2023-02-07T22:25:43.606502+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.6226575 2023-02-07T22:25:43.622658+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.6388175 2023-02-07T22:25:43.638818+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.654996 2023-02-07T22:25:43.654996+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.6711261 2023-02-07T22:25:43.671126+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.6872852 2023-02-07T22:25:43.687285+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.702435 2023-02-07T22:25:43.702435+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.718571 2023-02-07T22:25:43.718571+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.7347324 2023-02-07T22:25:43.734732+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.7508898 2023-02-07T22:25:43.750890+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.7670379 2023-02-07T22:25:43.767038+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.7832005 2023-02-07T22:25:43.783201+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.7993612 2023-02-07T22:25:43.799361+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.8154995 2023-02-07T22:25:43.815500+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.8316598 2023-02-07T22:25:43.831660+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.8478317 2023-02-07T22:25:43.847832+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.8639977 2023-02-07T22:25:43.863998+00:00 1 9 1285 725 880 850 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.8801334 2023-02-07T22:25:43.880133+00:00 1 9 1285 725 880 847 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.896302 2023-02-07T22:25:43.896302+00:00 1 9 1285 725 880 833 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.9114459 2023-02-07T22:25:43.911446+00:00 1 9 1285 725 880 819 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.9275815 2023-02-07T22:25:43.927582+00:00 1 9 1285 725 880 794 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.943748 2023-02-07T22:25:43.943748+00:00 1 9 1285 725 880 777 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.9599195 2023-02-07T22:25:43.959919+00:00 1 9 1285 725 880 768 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.9760787 2023-02-07T22:25:43.976079+00:00 1 9 1285 725 880 739 1660 705 0 0
exp_2023_02_07_14 97 111 lion tiger 1675808743.9922483 2023-02-07T22:25:43.992248+00:00 1 9 1285 725 880 739 1660 705 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]);