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 = 112

View and edit SQL

Suggested facets: 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_20_01 112 99905 lion tiger 1676929214.3704698 2023-02-20T21:40:14.370470+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.3872192 2023-02-20T21:40:14.387219+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.4033833 2023-02-20T21:40:14.403383+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.4195626 2023-02-20T21:40:14.419563+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.4357264 2023-02-20T21:40:14.435726+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.4518948 2023-02-20T21:40:14.451895+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.468068 2023-02-20T21:40:14.468068+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.4842594 2023-02-20T21:40:14.484259+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.5004168 2023-02-20T21:40:14.500417+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.5165937 2023-02-20T21:40:14.516594+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.5327773 2023-02-20T21:40:14.532777+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.5489624 2023-02-20T21:40:14.548962+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.5651236 2023-02-20T21:40:14.565124+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.5812778 2023-02-20T21:40:14.581278+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.5974333 2023-02-20T21:40:14.597433+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.6135952 2023-02-20T21:40:14.613595+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.6297615 2023-02-20T21:40:14.629761+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.6459246 2023-02-20T21:40:14.645925+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.6620958 2023-02-20T21:40:14.662096+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.6782682 2023-02-20T21:40:14.678268+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.6944227 2023-02-20T21:40:14.694423+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.7105973 2023-02-20T21:40:14.710597+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.7267873 2023-02-20T21:40:14.726787+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.7429569 2023-02-20T21:40:14.742957+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.7591336 2023-02-20T21:40:14.759134+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.7753274 2023-02-20T21:40:14.775327+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.7905066 2023-02-20T21:40:14.790507+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.806678 2023-02-20T21:40:14.806678+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.8228438 2023-02-20T21:40:14.822844+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.8390038 2023-02-20T21:40:14.839004+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.8551695 2023-02-20T21:40:14.855170+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.8713481 2023-02-20T21:40:14.871348+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.886526 2023-02-20T21:40:14.886526+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.9026947 2023-02-20T21:40:14.902695+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.9188626 2023-02-20T21:40:14.918863+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.9350247 2023-02-20T21:40:14.935025+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.9511924 2023-02-20T21:40:14.951192+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.9673681 2023-02-20T21:40:14.967368+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.9825377 2023-02-20T21:40:14.982538+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929214.9987123 2023-02-20T21:40:14.998712+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.0148768 2023-02-20T21:40:15.014877+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.0310535 2023-02-20T21:40:15.031054+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.0472546 2023-02-20T21:40:15.047255+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.0625021 2023-02-20T21:40:15.062502+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.078689 2023-02-20T21:40:15.078689+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.09487 2023-02-20T21:40:15.094870+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.1110837 2023-02-20T21:40:15.111084+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.1272824 2023-02-20T21:40:15.127282+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.1434824 2023-02-20T21:40:15.143482+00:00 1 10 1285 725 880 777 1660 850 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.1596832 2023-02-20T21:40:15.159683+00:00 1 10 1285 725 880 777 1660 849 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.1758113 2023-02-20T21:40:15.175811+00:00 1 10 1285 725 880 777 1660 847 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.1919966 2023-02-20T21:40:15.191997+00:00 1 10 1285 725 880 773 1660 845 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.2081847 2023-02-20T21:40:15.208185+00:00 1 10 1285 725 880 769 1660 842 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.224349 2023-02-20T21:40:15.224349+00:00 1 10 1285 725 880 762 1660 837 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.23952 2023-02-20T21:40:15.239520+00:00 1 10 1285 725 880 755 1660 828 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.2557166 2023-02-20T21:40:15.255717+00:00 1 10 1285 725 880 749 1660 804 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.2718904 2023-02-20T21:40:15.271890+00:00 1 10 1285 725 880 745 1660 795 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.2880933 2023-02-20T21:40:15.288093+00:00 1 10 1285 725 880 745 1660 795 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.304263 2023-02-20T21:40:15.304263+00:00 1 10 1285 725 880 736 1660 790 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.32043 2023-02-20T21:40:15.320430+00:00 1 10 1285 725 880 724 1660 787 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.3366103 2023-02-20T21:40:15.336610+00:00 1 10 1285 725 880 712 1660 785 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.3527875 2023-02-20T21:40:15.352787+00:00 1 10 1285 725 880 703 1660 783 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.3689592 2023-02-20T21:40:15.368959+00:00 1 10 1285 725 880 692 1660 779 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.3851411 2023-02-20T21:40:15.385141+00:00 1 10 1285 725 880 680 1660 773 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.4013124 2023-02-20T21:40:15.401312+00:00 1 9 1285 725 880 668 1660 767 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.4164987 2023-02-20T21:40:15.416499+00:00 1 9 1285 725 880 665 1660 767 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.432678 2023-02-20T21:40:15.432678+00:00 1 9 1285 725 880 665 1660 761 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.4488556 2023-02-20T21:40:15.448856+00:00 1 9 1285 725 880 665 1660 752 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.465034 2023-02-20T21:40:15.465034+00:00 1 9 1285 725 880 665 1660 743 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.4812107 2023-02-20T21:40:15.481211+00:00 1 9 1285 725 880 665 1660 734 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.4973886 2023-02-20T21:40:15.497389+00:00 1 9 1285 725 880 665 1660 727 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.5125666 2023-02-20T21:40:15.512567+00:00 1 9 1285 725 880 665 1660 712 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.5287352 2023-02-20T21:40:15.528735+00:00 1 9 1285 725 880 672 1660 704 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.5448964 2023-02-20T21:40:15.544896+00:00 1 9 1285 725 880 681 1660 697 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.5610826 2023-02-20T21:40:15.561083+00:00 1 9 1285 725 880 708 1660 697 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.5772603 2023-02-20T21:40:15.577260+00:00 1 9 1285 725 880 710 1660 688 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.5934372 2023-02-20T21:40:15.593437+00:00 1 9 1285 725 880 722 1660 681 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.609614 2023-02-20T21:40:15.609614+00:00 1 9 1285 725 880 722 1660 674 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.6258178 2023-02-20T21:40:15.625818+00:00 1 9 1285 725 880 730 1660 668 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.6419916 2023-02-20T21:40:15.641992+00:00 1 9 1285 725 880 737 1660 662 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.6581645 2023-02-20T21:40:15.658165+00:00 1 9 1285 725 880 737 1660 656 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.6743338 2023-02-20T21:40:15.674334+00:00 1 9 1285 725 880 737 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.6895068 2023-02-20T21:40:15.689507+00:00 1 9 1285 725 880 737 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.7056775 2023-02-20T21:40:15.705678+00:00 1 9 1285 725 880 736 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.7218425 2023-02-20T21:40:15.721843+00:00 1 9 1285 725 880 724 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.738011 2023-02-20T21:40:15.738011+00:00 1 9 1285 725 880 724 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.7541811 2023-02-20T21:40:15.754181+00:00 1 9 1285 725 880 713 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.7703671 2023-02-20T21:40:15.770367+00:00 1 9 1285 725 880 703 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.785546 2023-02-20T21:40:15.785546+00:00 1 9 1285 725 880 689 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.801717 2023-02-20T21:40:15.801717+00:00 1 9 1285 725 880 669 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.8178937 2023-02-20T21:40:15.817894+00:00 1 9 1285 725 880 647 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.8340662 2023-02-20T21:40:15.834066+00:00 1 9 1285 725 880 641 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.8504608 2023-02-20T21:40:15.850461+00:00 1 9 1285 725 880 633 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.8666303 2023-02-20T21:40:15.866630+00:00 1 9 1285 725 880 630 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.8828166 2023-02-20T21:40:15.882817+00:00 1 9 1285 725 880 627 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.898986 2023-02-20T21:40:15.898986+00:00 1 9 1285 725 880 627 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.9151618 2023-02-20T21:40:15.915162+00:00 1 9 1285 725 880 627 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.9313369 2023-02-20T21:40:15.931337+00:00 1 9 1285 725 880 627 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.9465098 2023-02-20T21:40:15.946510+00:00 1 9 1285 725 880 627 1660 651 0 0
exp_2023_02_20_01 112 99905 lion tiger 1676929215.9626696 2023-02-20T21:40:15.962670+00:00 1 9 1285 725 880 627 1660 651 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]);