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

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_01_30_13 93 99905 lion tiger 1675115414.170777 2023-01-30T21:50:14.170777+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.1861408 2023-01-30T21:50:14.186141+00:00 1 10 1285 725 880 850 1660 842 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.2023187 2023-01-30T21:50:14.202319+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.2184963 2023-01-30T21:50:14.218496+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.2346752 2023-01-30T21:50:14.234675+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.2508545 2023-01-30T21:50:14.250854+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.266052 2023-01-30T21:50:14.266052+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.2822933 2023-01-30T21:50:14.282293+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.2984622 2023-01-30T21:50:14.298462+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.3146238 2023-01-30T21:50:14.314624+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.3307965 2023-01-30T21:50:14.330796+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.3469725 2023-01-30T21:50:14.346972+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.3631365 2023-01-30T21:50:14.363137+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.3792644 2023-01-30T21:50:14.379264+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.3954294 2023-01-30T21:50:14.395429+00:00 1 10 1285 725 880 850 1660 841 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.4115973 2023-01-30T21:50:14.411597+00:00 1 10 1285 725 880 850 1660 842 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.427777 2023-01-30T21:50:14.427777+00:00 1 10 1285 725 880 850 1660 842 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.4439414 2023-01-30T21:50:14.443941+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.459101 2023-01-30T21:50:14.459101+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.4752548 2023-01-30T21:50:14.475255+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.4914343 2023-01-30T21:50:14.491434+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.5076034 2023-01-30T21:50:14.507603+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.5237422 2023-01-30T21:50:14.523742+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.5399072 2023-01-30T21:50:14.539907+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.5550723 2023-01-30T21:50:14.555072+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.5712543 2023-01-30T21:50:14.571254+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.5874376 2023-01-30T21:50:14.587438+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.6036081 2023-01-30T21:50:14.603608+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.6197886 2023-01-30T21:50:14.619789+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.6359546 2023-01-30T21:50:14.635955+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.6511283 2023-01-30T21:50:14.651128+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.6673238 2023-01-30T21:50:14.667324+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.6834962 2023-01-30T21:50:14.683496+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.6996582 2023-01-30T21:50:14.699658+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.7158244 2023-01-30T21:50:14.715824+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.731987 2023-01-30T21:50:14.731987+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.748151 2023-01-30T21:50:14.748151+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.7643175 2023-01-30T21:50:14.764318+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.780482 2023-01-30T21:50:14.780482+00:00 1 10 1285 725 880 850 1660 843 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.7966473 2023-01-30T21:50:14.796647+00:00 1 10 1285 725 880 850 1660 842 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.8128104 2023-01-30T21:50:14.812810+00:00 1 10 1285 725 880 850 1660 840 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.828975 2023-01-30T21:50:14.828975+00:00 1 10 1285 725 880 850 1660 840 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.8441405 2023-01-30T21:50:14.844141+00:00 1 10 1285 725 880 850 1660 838 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.860298 2023-01-30T21:50:14.860298+00:00 1 10 1285 725 880 850 1660 836 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.8764505 2023-01-30T21:50:14.876451+00:00 1 10 1285 725 880 850 1660 832 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.8926141 2023-01-30T21:50:14.892614+00:00 1 10 1285 725 880 850 1660 829 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.9087768 2023-01-30T21:50:14.908777+00:00 1 10 1285 725 880 850 1660 828 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.9249396 2023-01-30T21:50:14.924940+00:00 1 10 1285 725 880 850 1660 828 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.9400978 2023-01-30T21:50:14.940098+00:00 1 10 1285 725 880 850 1660 826 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.9562469 2023-01-30T21:50:14.956247+00:00 1 10 1285 725 880 850 1660 824 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.972415 2023-01-30T21:50:14.972415+00:00 1 10 1285 725 880 850 1660 824 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115414.9885879 2023-01-30T21:50:14.988588+00:00 1 10 1285 725 880 850 1660 823 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.0047584 2023-01-30T21:50:15.004758+00:00 1 10 1285 725 880 850 1660 823 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.0209334 2023-01-30T21:50:15.020933+00:00 1 10 1285 725 880 850 1660 822 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.0361288 2023-01-30T21:50:15.036129+00:00 1 10 1285 725 880 850 1660 822 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.0523171 2023-01-30T21:50:15.052317+00:00 1 10 1285 725 880 850 1660 822 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.0684881 2023-01-30T21:50:15.068488+00:00 1 10 1285 725 880 850 1660 822 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.0846705 2023-01-30T21:50:15.084671+00:00 1 10 1285 725 880 850 1660 822 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.1008375 2023-01-30T21:50:15.100837+00:00 1 10 1285 725 880 850 1660 822 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.1170115 2023-01-30T21:50:15.117012+00:00 1 10 1285 725 880 850 1660 822 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.133203 2023-01-30T21:50:15.133203+00:00 1 10 1285 725 880 850 1660 813 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.1493726 2023-01-30T21:50:15.149373+00:00 1 10 1285 725 880 850 1660 813 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.165524 2023-01-30T21:50:15.165524+00:00 1 10 1285 725 880 850 1660 811 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.181691 2023-01-30T21:50:15.181691+00:00 1 10 1285 725 880 850 1660 811 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.197897 2023-01-30T21:50:15.197897+00:00 1 9 1285 725 880 850 1660 811 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.21314 2023-01-30T21:50:15.213140+00:00 1 9 1285 725 880 850 1660 811 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.2293403 2023-01-30T21:50:15.229340+00:00 1 9 1285 725 880 850 1660 809 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.2455473 2023-01-30T21:50:15.245547+00:00 1 9 1285 725 880 850 1660 807 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.2617667 2023-01-30T21:50:15.261767+00:00 1 9 1285 725 880 850 1660 797 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.2779934 2023-01-30T21:50:15.277993+00:00 1 9 1285 725 880 850 1660 797 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.2932198 2023-01-30T21:50:15.293220+00:00 1 9 1285 725 880 850 1660 786 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.309447 2023-01-30T21:50:15.309447+00:00 1 9 1285 725 880 850 1660 773 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.3256798 2023-01-30T21:50:15.325680+00:00 1 9 1285 725 880 850 1660 758 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.3419044 2023-01-30T21:50:15.341904+00:00 1 9 1285 725 880 850 1660 745 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.3570983 2023-01-30T21:50:15.357098+00:00 1 9 1285 725 880 850 1660 737 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.373319 2023-01-30T21:50:15.373319+00:00 1 9 1285 725 880 850 1660 731 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.389537 2023-01-30T21:50:15.389537+00:00 1 9 1285 725 880 850 1660 728 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.405717 2023-01-30T21:50:15.405717+00:00 1 9 1285 725 880 850 1660 725 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.4219394 2023-01-30T21:50:15.421939+00:00 1 9 1285 725 880 850 1660 724 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.4371612 2023-01-30T21:50:15.437161+00:00 1 9 1285 725 880 850 1660 724 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.4533808 2023-01-30T21:50:15.453381+00:00 1 9 1285 725 880 850 1660 724 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.4696217 2023-01-30T21:50:15.469622+00:00 1 9 1285 725 880 850 1660 724 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.485827 2023-01-30T21:50:15.485827+00:00 1 9 1285 725 880 846 1660 724 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.502028 2023-01-30T21:50:15.502028+00:00 1 9 1285 725 880 843 1660 724 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.5182 2023-01-30T21:50:15.518200+00:00 1 9 1285 725 880 843 1660 724 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.5343678 2023-01-30T21:50:15.534368+00:00 1 9 1285 725 880 843 1660 725 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.5505807 2023-01-30T21:50:15.550581+00:00 1 9 1285 725 880 843 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.56675 2023-01-30T21:50:15.566750+00:00 1 9 1285 725 880 843 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.582897 2023-01-30T21:50:15.582897+00:00 1 9 1285 725 880 843 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.5990472 2023-01-30T21:50:15.599047+00:00 1 9 1285 725 880 843 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.615174 2023-01-30T21:50:15.615174+00:00 1 9 1285 725 880 843 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.6313145 2023-01-30T21:50:15.631315+00:00 1 9 1285 725 880 843 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.6474495 2023-01-30T21:50:15.647449+00:00 1 9 1285 725 880 843 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.6635826 2023-01-30T21:50:15.663583+00:00 1 9 1285 725 880 843 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.67974 2023-01-30T21:50:15.679740+00:00 1 9 1285 725 880 850 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.6958733 2023-01-30T21:50:15.695873+00:00 1 9 1285 725 880 850 1660 726 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.7120078 2023-01-30T21:50:15.712008+00:00 1 9 1285 725 880 850 1660 725 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.7271469 2023-01-30T21:50:15.727147+00:00 1 9 1285 725 880 850 1660 721 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.7432542 2023-01-30T21:50:15.743254+00:00 1 9 1285 725 880 850 1660 721 0 0
exp_2023_01_30_13 93 99905 lion tiger 1675115415.7594013 2023-01-30T21:50:15.759401+00:00 1 9 1285 725 880 850 1660 720 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]);