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

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_10_21_15 43 45 lion tiger 1666395919.4779794 2022-10-21T23:45:19.477979+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.4947486 2022-10-21T23:45:19.494749+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.5099297 2022-10-21T23:45:19.509930+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.5260916 2022-10-21T23:45:19.526092+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.5422492 2022-10-21T23:45:19.542249+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.558427 2022-10-21T23:45:19.558427+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.5746033 2022-10-21T23:45:19.574603+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.5907643 2022-10-21T23:45:19.590764+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.6069202 2022-10-21T23:45:19.606920+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.6230953 2022-10-21T23:45:19.623095+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.639252 2022-10-21T23:45:19.639252+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.655413 2022-10-21T23:45:19.655413+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.671587 2022-10-21T23:45:19.671587+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.6877463 2022-10-21T23:45:19.687746+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.7039154 2022-10-21T23:45:19.703915+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.7200894 2022-10-21T23:45:19.720089+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.736243 2022-10-21T23:45:19.736243+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.7524042 2022-10-21T23:45:19.752404+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.7685788 2022-10-21T23:45:19.768579+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.7847338 2022-10-21T23:45:19.784734+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.800897 2022-10-21T23:45:19.800897+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.8171031 2022-10-21T23:45:19.817103+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.8332782 2022-10-21T23:45:19.833278+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.8494241 2022-10-21T23:45:19.849424+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.8656042 2022-10-21T23:45:19.865604+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.8817818 2022-10-21T23:45:19.881782+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.8979049 2022-10-21T23:45:19.897905+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.9140365 2022-10-21T23:45:19.914037+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.9301634 2022-10-21T23:45:19.930163+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.9463348 2022-10-21T23:45:19.946335+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.9625058 2022-10-21T23:45:19.962506+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.9786596 2022-10-21T23:45:19.978660+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395919.9948077 2022-10-21T23:45:19.994808+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.0099764 2022-10-21T23:45:20.009976+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.0261333 2022-10-21T23:45:20.026133+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.0422885 2022-10-21T23:45:20.042289+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.0584736 2022-10-21T23:45:20.058474+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.07466 2022-10-21T23:45:20.074660+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.090828 2022-10-21T23:45:20.090828+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.1060019 2022-10-21T23:45:20.106002+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.1221886 2022-10-21T23:45:20.122189+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.1383536 2022-10-21T23:45:20.138354+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.1545217 2022-10-21T23:45:20.154522+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.170696 2022-10-21T23:45:20.170696+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.186853 2022-10-21T23:45:20.186853+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.2020152 2022-10-21T23:45:20.202015+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.2181854 2022-10-21T23:45:20.218185+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.2343428 2022-10-21T23:45:20.234343+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.2504954 2022-10-21T23:45:20.250495+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.266665 2022-10-21T23:45:20.266665+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.2828195 2022-10-21T23:45:20.282820+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.2979908 2022-10-21T23:45:20.297991+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.3141758 2022-10-21T23:45:20.314176+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.330338 2022-10-21T23:45:20.330338+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.3465056 2022-10-21T23:45:20.346506+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.3626797 2022-10-21T23:45:20.362680+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.3788373 2022-10-21T23:45:20.378837+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.3939981 2022-10-21T23:45:20.393998+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.4101543 2022-10-21T23:45:20.410154+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.4263291 2022-10-21T23:45:20.426329+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.4424868 2022-10-21T23:45:20.442487+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.4586523 2022-10-21T23:45:20.458652+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.4748206 2022-10-21T23:45:20.474821+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.4899926 2022-10-21T23:45:20.489993+00:00 1 10 1285 725 880 727 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.5061505 2022-10-21T23:45:20.506150+00:00 1 9 1285 725 880 734 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.5223339 2022-10-21T23:45:20.522334+00:00 1 9 1285 725 880 734 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.538501 2022-10-21T23:45:20.538501+00:00 1 9 1285 725 880 734 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.5546663 2022-10-21T23:45:20.554666+00:00 1 9 1285 725 880 734 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.5708313 2022-10-21T23:45:20.570831+00:00 1 9 1285 725 880 734 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.5860047 2022-10-21T23:45:20.586005+00:00 1 9 1285 725 880 731 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.6021671 2022-10-21T23:45:20.602167+00:00 1 9 1285 725 880 728 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.6183295 2022-10-21T23:45:20.618330+00:00 1 9 1285 725 880 728 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.6344821 2022-10-21T23:45:20.634482+00:00 1 9 1285 725 880 728 1660 661 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.6506274 2022-10-21T23:45:20.650627+00:00 1 9 1285 725 880 728 1660 627 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.6667855 2022-10-21T23:45:20.666785+00:00 1 9 1285 725 880 728 1660 627 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.682926 2022-10-21T23:45:20.682926+00:00 1 9 1285 725 880 728 1660 628 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.699067 2022-10-21T23:45:20.699067+00:00 1 9 1285 725 880 724 1660 628 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.7152264 2022-10-21T23:45:20.715226+00:00 1 9 1285 725 880 717 1660 629 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.7314086 2022-10-21T23:45:20.731409+00:00 1 9 1285 725 880 683 1660 630 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.7475524 2022-10-21T23:45:20.747552+00:00 1 9 1285 725 880 675 1660 630 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.7637174 2022-10-21T23:45:20.763717+00:00 1 9 1285 725 880 665 1660 630 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.7798655 2022-10-21T23:45:20.779866+00:00 1 9 1285 725 880 665 1660 631 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.795005 2022-10-21T23:45:20.795005+00:00 1 9 1285 725 880 671 1660 632 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.8111665 2022-10-21T23:45:20.811167+00:00 1 9 1285 725 880 686 1660 632 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.8273246 2022-10-21T23:45:20.827325+00:00 1 9 1285 725 880 703 1660 633 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.8434572 2022-10-21T23:45:20.843457+00:00 1 9 1285 725 880 705 1660 634 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.8595903 2022-10-21T23:45:20.859590+00:00 1 9 1285 725 880 713 1660 634 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.8757293 2022-10-21T23:45:20.875729+00:00 1 9 1285 725 880 714 1660 634 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.891878 2022-10-21T23:45:20.891878+00:00 1 9 1285 725 880 714 1660 634 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.9070396 2022-10-21T23:45:20.907040+00:00 1 9 1285 725 880 714 1660 634 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.9232047 2022-10-21T23:45:20.923205+00:00 1 9 1285 725 880 714 1660 634 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.9393759 2022-10-21T23:45:20.939376+00:00 1 9 1285 725 880 714 1660 631 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.955536 2022-10-21T23:45:20.955536+00:00 1 9 1285 725 880 713 1660 626 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.9717042 2022-10-21T23:45:20.971704+00:00 1 9 1285 725 880 713 1660 620 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395920.987864 2022-10-21T23:45:20.987864+00:00 1 9 1285 725 880 711 1660 605 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395921.003019 2022-10-21T23:45:21.003019+00:00 1 9 1285 725 880 705 1660 605 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395921.019183 2022-10-21T23:45:21.019183+00:00 1 9 1285 725 880 705 1660 599 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395921.035328 2022-10-21T23:45:21.035328+00:00 1 9 1285 725 880 699 1660 594 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395921.0514693 2022-10-21T23:45:21.051469+00:00 1 9 1285 725 880 692 1660 590 0 0
exp_2022_10_21_15 43 45 lion tiger 1666395921.0675983 2022-10-21T23:45:21.067598+00:00 1 9 1285 725 880 686 1660 586 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]);