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

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_04_10 52 -3 leopard cheetah 1667587857.513716 2022-11-04T18:50:57.513716+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.5290391 2022-11-04T18:50:57.529039+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.5451758 2022-11-04T18:50:57.545176+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.561304 2022-11-04T18:50:57.561304+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.5774643 2022-11-04T18:50:57.577464+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.5936255 2022-11-04T18:50:57.593626+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.6097727 2022-11-04T18:50:57.609773+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.6259544 2022-11-04T18:50:57.625954+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.64213 2022-11-04T18:50:57.642130+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.658343 2022-11-04T18:50:57.658343+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.6745396 2022-11-04T18:50:57.674540+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.6907372 2022-11-04T18:50:57.690737+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.7069485 2022-11-04T18:50:57.706949+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.722241 2022-11-04T18:50:57.722241+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.738415 2022-11-04T18:50:57.738415+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.7546065 2022-11-04T18:50:57.754606+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.770787 2022-11-04T18:50:57.770787+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.7869473 2022-11-04T18:50:57.786947+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.8021204 2022-11-04T18:50:57.802120+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.81829 2022-11-04T18:50:57.818290+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.8344631 2022-11-04T18:50:57.834463+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.8507195 2022-11-04T18:50:57.850719+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.8669481 2022-11-04T18:50:57.866948+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.8821595 2022-11-04T18:50:57.882159+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.8983672 2022-11-04T18:50:57.898367+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.9145792 2022-11-04T18:50:57.914579+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.930831 2022-11-04T18:50:57.930831+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.9470072 2022-11-04T18:50:57.947007+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.9631727 2022-11-04T18:50:57.963173+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.9793344 2022-11-04T18:50:57.979334+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587857.995494 2022-11-04T18:50:57.995494+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.0117173 2022-11-04T18:50:58.011717+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.0279043 2022-11-04T18:50:58.027904+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.0431037 2022-11-04T18:50:58.043104+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.0593212 2022-11-04T18:50:58.059321+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.0755384 2022-11-04T18:50:58.075538+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.0917244 2022-11-04T18:50:58.091724+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.1079357 2022-11-04T18:50:58.107936+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.1231678 2022-11-04T18:50:58.123168+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.1394143 2022-11-04T18:50:58.139414+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.1556027 2022-11-04T18:50:58.155603+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.1717575 2022-11-04T18:50:58.171757+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.1879182 2022-11-04T18:50:58.187918+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.2030702 2022-11-04T18:50:58.203070+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.219241 2022-11-04T18:50:58.219241+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.2354207 2022-11-04T18:50:58.235421+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.251614 2022-11-04T18:50:58.251614+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.267819 2022-11-04T18:50:58.267819+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.2840042 2022-11-04T18:50:58.284004+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.3002052 2022-11-04T18:50:58.300205+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.316418 2022-11-04T18:50:58.316418+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.3326223 2022-11-04T18:50:58.332622+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.3488092 2022-11-04T18:50:58.348809+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.3649828 2022-11-04T18:50:58.364983+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.3811553 2022-11-04T18:50:58.381155+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.3973336 2022-11-04T18:50:58.397334+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.413535 2022-11-04T18:50:58.413535+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.429778 2022-11-04T18:50:58.429778+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.4459608 2022-11-04T18:50:58.445961+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.4611287 2022-11-04T18:50:58.461129+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.4773443 2022-11-04T18:50:58.477344+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.4935746 2022-11-04T18:50:58.493575+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.5098083 2022-11-04T18:50:58.509808+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.5259845 2022-11-04T18:50:58.525985+00:00 1 10 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.5411735 2022-11-04T18:50:58.541173+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.557358 2022-11-04T18:50:58.557358+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.5735235 2022-11-04T18:50:58.573524+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.5896986 2022-11-04T18:50:58.589699+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.6059227 2022-11-04T18:50:58.605923+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.6211176 2022-11-04T18:50:58.621118+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.6373212 2022-11-04T18:50:58.637321+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.653526 2022-11-04T18:50:58.653526+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.6697447 2022-11-04T18:50:58.669745+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.685964 2022-11-04T18:50:58.685964+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.7011976 2022-11-04T18:50:58.701198+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.7173831 2022-11-04T18:50:58.717383+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.7335558 2022-11-04T18:50:58.733556+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.7497215 2022-11-04T18:50:58.749722+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.765884 2022-11-04T18:50:58.765884+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.781083 2022-11-04T18:50:58.781083+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.7972589 2022-11-04T18:50:58.797259+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.8134363 2022-11-04T18:50:58.813436+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.8296268 2022-11-04T18:50:58.829627+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.845808 2022-11-04T18:50:58.845808+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.861994 2022-11-04T18:50:58.861994+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.8771777 2022-11-04T18:50:58.877178+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.8934026 2022-11-04T18:50:58.893403+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.9095576 2022-11-04T18:50:58.909558+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.9257095 2022-11-04T18:50:58.925709+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.941864 2022-11-04T18:50:58.941864+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.9580343 2022-11-04T18:50:58.958034+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.9742002 2022-11-04T18:50:58.974200+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587858.9903636 2022-11-04T18:50:58.990364+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587859.006516 2022-11-04T18:50:59.006516+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587859.02269 2022-11-04T18:50:59.022690+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587859.0388448 2022-11-04T18:50:59.038845+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587859.054086 2022-11-04T18:50:59.054086+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587859.0702472 2022-11-04T18:50:59.070247+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587859.0864034 2022-11-04T18:50:59.086403+00:00 1 9 1285 725 880 522 1660 660 0 0
exp_2022_11_04_10 52 -3 leopard cheetah 1667587859.1025572 2022-11-04T18:50:59.102557+00:00 1 9 1285 725 880 522 1660 660 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]);