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

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_17_15 73 76 lion tiger 1668732032.4966037 2022-11-18T00:40:32.496604+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.5124223 2022-11-18T00:40:32.512422+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.528623 2022-11-18T00:40:32.528623+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.5448344 2022-11-18T00:40:32.544834+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.5610104 2022-11-18T00:40:32.561010+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.5771716 2022-11-18T00:40:32.577172+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.5923357 2022-11-18T00:40:32.592336+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.6085138 2022-11-18T00:40:32.608514+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.6246893 2022-11-18T00:40:32.624689+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.6408553 2022-11-18T00:40:32.640855+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.6570222 2022-11-18T00:40:32.657022+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.673191 2022-11-18T00:40:32.673191+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.6883438 2022-11-18T00:40:32.688344+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.7044697 2022-11-18T00:40:32.704470+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.7205994 2022-11-18T00:40:32.720599+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.7367346 2022-11-18T00:40:32.736735+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.7529058 2022-11-18T00:40:32.752906+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.7690704 2022-11-18T00:40:32.769070+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.78523 2022-11-18T00:40:32.785230+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.8013878 2022-11-18T00:40:32.801388+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.8175547 2022-11-18T00:40:32.817555+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.8337119 2022-11-18T00:40:32.833712+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.84988 2022-11-18T00:40:32.849880+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.866046 2022-11-18T00:40:32.866046+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.8822055 2022-11-18T00:40:32.882205+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.8973792 2022-11-18T00:40:32.897379+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.9135568 2022-11-18T00:40:32.913557+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.9297125 2022-11-18T00:40:32.929713+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.9458735 2022-11-18T00:40:32.945873+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.9620373 2022-11-18T00:40:32.962037+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.9782004 2022-11-18T00:40:32.978200+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732032.9933646 2022-11-18T00:40:32.993365+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.0095458 2022-11-18T00:40:33.009546+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.0257132 2022-11-18T00:40:33.025713+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.041928 2022-11-18T00:40:33.041928+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.0581675 2022-11-18T00:40:33.058167+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.0733378 2022-11-18T00:40:33.073338+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.0894992 2022-11-18T00:40:33.089499+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.1056652 2022-11-18T00:40:33.105665+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.1218376 2022-11-18T00:40:33.121838+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.1380115 2022-11-18T00:40:33.138011+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.154221 2022-11-18T00:40:33.154221+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.1693873 2022-11-18T00:40:33.169387+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.185552 2022-11-18T00:40:33.185552+00:00 1 10 1285 725 880 737 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.2017148 2022-11-18T00:40:33.201715+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.21789 2022-11-18T00:40:33.217890+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.2340553 2022-11-18T00:40:33.234055+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.250222 2022-11-18T00:40:33.250222+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.2654154 2022-11-18T00:40:33.265415+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.281641 2022-11-18T00:40:33.281641+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.29782 2022-11-18T00:40:33.297820+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.3139844 2022-11-18T00:40:33.313984+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.3301077 2022-11-18T00:40:33.330108+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.3462815 2022-11-18T00:40:33.346282+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.3624418 2022-11-18T00:40:33.362442+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.378597 2022-11-18T00:40:33.378597+00:00 1 10 1285 725 880 737 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.3947651 2022-11-18T00:40:33.394765+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.4109392 2022-11-18T00:40:33.410939+00:00 1 10 1285 725 880 773 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.4270906 2022-11-18T00:40:33.427091+00:00 1 10 1285 725 880 773 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.4432378 2022-11-18T00:40:33.443238+00:00 1 10 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.4584057 2022-11-18T00:40:33.458406+00:00 1 10 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.474556 2022-11-18T00:40:33.474556+00:00 1 10 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.490717 2022-11-18T00:40:33.490717+00:00 1 10 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.5068793 2022-11-18T00:40:33.506879+00:00 1 10 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.5230236 2022-11-18T00:40:33.523024+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.5391695 2022-11-18T00:40:33.539170+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.5543346 2022-11-18T00:40:33.554335+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.5704987 2022-11-18T00:40:33.570499+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.5866475 2022-11-18T00:40:33.586648+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.6028214 2022-11-18T00:40:33.602821+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.618999 2022-11-18T00:40:33.618999+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.6351755 2022-11-18T00:40:33.635175+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.650351 2022-11-18T00:40:33.650351+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.6665502 2022-11-18T00:40:33.666550+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.6827927 2022-11-18T00:40:33.682793+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.6989882 2022-11-18T00:40:33.698988+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.7151601 2022-11-18T00:40:33.715160+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.731287 2022-11-18T00:40:33.731287+00:00 1 9 1285 725 880 774 1660 850 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.7474678 2022-11-18T00:40:33.747468+00:00 1 9 1285 725 880 774 1660 849 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.763645 2022-11-18T00:40:33.763645+00:00 1 9 1285 725 880 774 1660 848 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.7798088 2022-11-18T00:40:33.779809+00:00 1 9 1285 725 880 774 1660 847 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.7959714 2022-11-18T00:40:33.795971+00:00 1 9 1285 725 880 774 1660 844 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.812141 2022-11-18T00:40:33.812141+00:00 1 9 1285 725 880 774 1660 843 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.8283038 2022-11-18T00:40:33.828304+00:00 1 9 1285 725 880 774 1660 843 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.8444679 2022-11-18T00:40:33.844468+00:00 1 9 1285 725 880 774 1660 842 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.8606346 2022-11-18T00:40:33.860635+00:00 1 9 1285 725 880 774 1660 841 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.8767972 2022-11-18T00:40:33.876797+00:00 1 9 1285 725 880 774 1660 840 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.8929672 2022-11-18T00:40:33.892967+00:00 1 9 1285 725 880 774 1660 839 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.9091609 2022-11-18T00:40:33.909161+00:00 1 9 1285 725 880 774 1660 838 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.9253292 2022-11-18T00:40:33.925329+00:00 1 9 1285 725 880 774 1660 837 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.9414995 2022-11-18T00:40:33.941499+00:00 1 9 1285 725 880 774 1660 836 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.9576638 2022-11-18T00:40:33.957664+00:00 1 9 1285 725 880 774 1660 834 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.9738374 2022-11-18T00:40:33.973837+00:00 1 9 1285 725 880 774 1660 833 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732033.990005 2022-11-18T00:40:33.990005+00:00 1 9 1285 725 880 774 1660 832 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732034.006167 2022-11-18T00:40:34.006167+00:00 1 9 1285 725 880 774 1660 831 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732034.0223393 2022-11-18T00:40:34.022339+00:00 1 9 1285 725 880 774 1660 830 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732034.0385141 2022-11-18T00:40:34.038514+00:00 1 9 1285 725 880 774 1660 830 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732034.0546799 2022-11-18T00:40:34.054680+00:00 1 9 1285 725 880 774 1660 827 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732034.0708518 2022-11-18T00:40:34.070852+00:00 1 9 1285 725 880 774 1660 826 0 0
exp_2022_11_17_15 73 76 lion tiger 1668732034.0870175 2022-11-18T00:40:34.087018+00:00 1 9 1285 725 880 774 1660 825 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]);