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_2_id = 30

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_2022_11_15_13 14 30 lion tiger 1668548155.015425 2022-11-15T21:35:55.015425+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.032052 2022-11-15T21:35:55.032052+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.048224 2022-11-15T21:35:55.048224+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.0633912 2022-11-15T21:35:55.063391+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.0795522 2022-11-15T21:35:55.079552+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.0957153 2022-11-15T21:35:55.095715+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.111872 2022-11-15T21:35:55.111872+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.128034 2022-11-15T21:35:55.128034+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.1441922 2022-11-15T21:35:55.144192+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.1593482 2022-11-15T21:35:55.159348+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.1755164 2022-11-15T21:35:55.175516+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.1916738 2022-11-15T21:35:55.191674+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.2078285 2022-11-15T21:35:55.207829+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.2239902 2022-11-15T21:35:55.223990+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.2401366 2022-11-15T21:35:55.240137+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.2562795 2022-11-15T21:35:55.256279+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.272434 2022-11-15T21:35:55.272434+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.2886045 2022-11-15T21:35:55.288604+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.3047748 2022-11-15T21:35:55.304775+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.3209424 2022-11-15T21:35:55.320942+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.337102 2022-11-15T21:35:55.337102+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.3532631 2022-11-15T21:35:55.353263+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.3684347 2022-11-15T21:35:55.368435+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.3845959 2022-11-15T21:35:55.384596+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.400778 2022-11-15T21:35:55.400778+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.4169636 2022-11-15T21:35:55.416964+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.4331274 2022-11-15T21:35:55.433127+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.4492905 2022-11-15T21:35:55.449291+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.4654522 2022-11-15T21:35:55.465452+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.4816139 2022-11-15T21:35:55.481614+00:00 1 10 1285 725 880 850 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.4977787 2022-11-15T21:35:55.497779+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.513951 2022-11-15T21:35:55.513951+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.530123 2022-11-15T21:35:55.530123+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.5462828 2022-11-15T21:35:55.546283+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.5614543 2022-11-15T21:35:55.561454+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.5776162 2022-11-15T21:35:55.577616+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.5937831 2022-11-15T21:35:55.593783+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.6099467 2022-11-15T21:35:55.609947+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.626111 2022-11-15T21:35:55.626111+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.6422832 2022-11-15T21:35:55.642283+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.6574457 2022-11-15T21:35:55.657446+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.6736166 2022-11-15T21:35:55.673617+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.6897824 2022-11-15T21:35:55.689782+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.705961 2022-11-15T21:35:55.705961+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.7221272 2022-11-15T21:35:55.722127+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.7382884 2022-11-15T21:35:55.738288+00:00 1 10 1285 725 880 789 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.7534575 2022-11-15T21:35:55.753458+00:00 1 10 1285 725 880 790 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.7696197 2022-11-15T21:35:55.769620+00:00 1 10 1285 725 880 793 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.7857828 2022-11-15T21:35:55.785783+00:00 1 10 1285 725 880 795 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.8019443 2022-11-15T21:35:55.801944+00:00 1 10 1285 725 880 795 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.8181078 2022-11-15T21:35:55.818108+00:00 1 10 1285 725 880 795 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.8342805 2022-11-15T21:35:55.834280+00:00 1 10 1285 725 880 795 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.8494427 2022-11-15T21:35:55.849443+00:00 1 10 1285 725 880 795 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.8656063 2022-11-15T21:35:55.865606+00:00 1 10 1285 725 880 795 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.881773 2022-11-15T21:35:55.881773+00:00 1 10 1285 725 880 795 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.8979409 2022-11-15T21:35:55.897941+00:00 1 10 1285 725 880 795 1660 847 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.9141183 2022-11-15T21:35:55.914118+00:00 1 10 1285 725 880 795 1660 844 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.930285 2022-11-15T21:35:55.930285+00:00 1 10 1285 725 880 795 1660 844 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.9454548 2022-11-15T21:35:55.945455+00:00 1 10 1285 725 880 795 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.9616237 2022-11-15T21:35:55.961624+00:00 1 10 1285 725 880 788 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.9778805 2022-11-15T21:35:55.977880+00:00 1 10 1285 725 880 788 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548155.9940574 2022-11-15T21:35:55.994057+00:00 1 10 1285 725 880 779 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.0102196 2022-11-15T21:35:56.010220+00:00 1 10 1285 725 880 775 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.0253825 2022-11-15T21:35:56.025383+00:00 1 10 1285 725 880 769 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.0415664 2022-11-15T21:35:56.041566+00:00 1 9 1285 725 880 768 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.057724 2022-11-15T21:35:56.057724+00:00 1 9 1285 725 880 761 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.0738895 2022-11-15T21:35:56.073889+00:00 1 9 1285 725 880 759 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.0900445 2022-11-15T21:35:56.090044+00:00 1 9 1285 725 880 750 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.1061995 2022-11-15T21:35:56.106200+00:00 1 9 1285 725 880 747 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.1223629 2022-11-15T21:35:56.122363+00:00 1 9 1285 725 880 738 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.1385267 2022-11-15T21:35:56.138527+00:00 1 9 1285 725 880 733 1660 841 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.15469 2022-11-15T21:35:56.154690+00:00 1 9 1285 725 880 733 1660 840 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.1708577 2022-11-15T21:35:56.170858+00:00 1 9 1285 725 880 723 1660 835 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.187022 2022-11-15T21:35:56.187022+00:00 1 9 1285 725 880 720 1660 822 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.2031908 2022-11-15T21:35:56.203191+00:00 1 9 1285 725 880 704 1660 807 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.2193463 2022-11-15T21:35:56.219346+00:00 1 9 1285 725 880 701 1660 797 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.2355204 2022-11-15T21:35:56.235520+00:00 1 9 1285 725 880 693 1660 797 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.2516904 2022-11-15T21:35:56.251690+00:00 1 9 1285 725 880 688 1660 788 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.2678738 2022-11-15T21:35:56.267874+00:00 1 9 1285 725 880 683 1660 779 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.2840495 2022-11-15T21:35:56.284050+00:00 1 9 1285 725 880 683 1660 775 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.3002286 2022-11-15T21:35:56.300229+00:00 1 9 1285 725 880 681 1660 773 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.316369 2022-11-15T21:35:56.316369+00:00 1 9 1285 725 880 674 1660 772 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.3325415 2022-11-15T21:35:56.332541+00:00 1 9 1285 725 880 670 1660 772 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.348709 2022-11-15T21:35:56.348709+00:00 1 9 1285 725 880 669 1660 772 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.3648808 2022-11-15T21:35:56.364881+00:00 1 9 1285 725 880 668 1660 772 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.3810477 2022-11-15T21:35:56.381048+00:00 1 9 1285 725 880 668 1660 772 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.3972116 2022-11-15T21:35:56.397212+00:00 1 9 1285 725 880 668 1660 773 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.4133806 2022-11-15T21:35:56.413381+00:00 1 9 1285 725 880 668 1660 779 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.4295413 2022-11-15T21:35:56.429541+00:00 1 9 1285 725 880 668 1660 788 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.445711 2022-11-15T21:35:56.445711+00:00 1 9 1285 725 880 668 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.461873 2022-11-15T21:35:56.461873+00:00 1 9 1285 725 880 668 1660 799 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.4779902 2022-11-15T21:35:56.477990+00:00 1 9 1285 725 880 668 1660 812 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.494116 2022-11-15T21:35:56.494116+00:00 1 9 1285 725 880 675 1660 823 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.5102677 2022-11-15T21:35:56.510268+00:00 1 9 1285 725 880 680 1660 833 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.5253916 2022-11-15T21:35:56.525392+00:00 1 9 1285 725 880 692 1660 842 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.5415404 2022-11-15T21:35:56.541540+00:00 1 9 1285 725 880 703 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.557696 2022-11-15T21:35:56.557696+00:00 1 9 1285 725 880 712 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.5738618 2022-11-15T21:35:56.573862+00:00 1 9 1285 725 880 725 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.5900106 2022-11-15T21:35:56.590011+00:00 1 9 1285 725 880 742 1660 850 0 0
exp_2022_11_15_13 14 30 lion tiger 1668548156.60617 2022-11-15T21:35:56.606170+00:00 1 9 1285 725 880 745 1660 850 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]);