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 group_session = "exp_2023_05_03_10"

View and edit SQL

Suggested facets: player_1_id, player_2_id, player_1_station, player_2_station, task_started, 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_05_03_10 166 -3 leopard cheetah 1683138456.1124816 2023-05-03T18:27:36.112482+00:00 0 10 1285 725 880 660 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.128392 2023-05-03T18:27:36.128392+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.143726 2023-05-03T18:27:36.143726+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.1600225 2023-05-03T18:27:36.160022+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.1763382 2023-05-03T18:27:36.176338+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.1916044 2023-05-03T18:27:36.191604+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.207802 2023-05-03T18:27:36.207802+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.2239995 2023-05-03T18:27:36.224000+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.240191 2023-05-03T18:27:36.240191+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.256389 2023-05-03T18:27:36.256389+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.2715971 2023-05-03T18:27:36.271597+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.2877972 2023-05-03T18:27:36.287797+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.3039887 2023-05-03T18:27:36.303989+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.320208 2023-05-03T18:27:36.320208+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.336422 2023-05-03T18:27:36.336422+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.3516355 2023-05-03T18:27:36.351635+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.3678346 2023-05-03T18:27:36.367835+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.384022 2023-05-03T18:27:36.384022+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.4002168 2023-05-03T18:27:36.400217+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.4164102 2023-05-03T18:27:36.416410+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.4316287 2023-05-03T18:27:36.431629+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.4478312 2023-05-03T18:27:36.447831+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.4640217 2023-05-03T18:27:36.464022+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.4802096 2023-05-03T18:27:36.480210+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.496394 2023-05-03T18:27:36.496394+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.5115914 2023-05-03T18:27:36.511591+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.5277836 2023-05-03T18:27:36.527784+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.5439758 2023-05-03T18:27:36.543976+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.5601466 2023-05-03T18:27:36.560147+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.5763423 2023-05-03T18:27:36.576342+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.592542 2023-05-03T18:27:36.592542+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.6087332 2023-05-03T18:27:36.608733+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.6249294 2023-05-03T18:27:36.624929+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.6411266 2023-05-03T18:27:36.641127+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.6573207 2023-05-03T18:27:36.657321+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.6735044 2023-05-03T18:27:36.673504+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.6896908 2023-05-03T18:27:36.689691+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.7058752 2023-05-03T18:27:36.705875+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.7220721 2023-05-03T18:27:36.722072+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.738278 2023-05-03T18:27:36.738278+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.754471 2023-05-03T18:27:36.754471+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.7696886 2023-05-03T18:27:36.769689+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.7858846 2023-05-03T18:27:36.785885+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.8020797 2023-05-03T18:27:36.802080+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.8182695 2023-05-03T18:27:36.818269+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.83446 2023-05-03T18:27:36.834460+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.849653 2023-05-03T18:27:36.849653+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.8658376 2023-05-03T18:27:36.865838+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.8820496 2023-05-03T18:27:36.882050+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.8982584 2023-05-03T18:27:36.898258+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.9144802 2023-05-03T18:27:36.914480+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.9296927 2023-05-03T18:27:36.929693+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.9458778 2023-05-03T18:27:36.945878+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.9620547 2023-05-03T18:27:36.962055+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.9782376 2023-05-03T18:27:36.978238+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138456.9944417 2023-05-03T18:27:36.994442+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.0096438 2023-05-03T18:27:37.009644+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.0258322 2023-05-03T18:27:37.025832+00:00 0 10 1285 725 880 847 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.042026 2023-05-03T18:27:37.042026+00:00 0 10 1285 725 880 766 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.058225 2023-05-03T18:27:37.058225+00:00 0 10 1285 725 880 764 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.0744119 2023-05-03T18:27:37.074412+00:00 0 10 1285 725 880 759 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.0896125 2023-05-03T18:27:37.089612+00:00 0 10 1285 725 880 753 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.10581 2023-05-03T18:27:37.105810+00:00 0 10 1285 725 880 751 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.122001 2023-05-03T18:27:37.122001+00:00 0 10 1285 725 880 742 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.1382382 2023-05-03T18:27:37.138238+00:00 0 9 1285 725 880 733 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.1545138 2023-05-03T18:27:37.154514+00:00 0 9 1285 725 880 720 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.1697578 2023-05-03T18:27:37.169758+00:00 0 9 1285 725 880 713 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.1859438 2023-05-03T18:27:37.185944+00:00 0 9 1285 725 880 710 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.202123 2023-05-03T18:27:37.202123+00:00 0 9 1285 725 880 704 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.2182777 2023-05-03T18:27:37.218278+00:00 0 9 1285 725 880 692 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.2345185 2023-05-03T18:27:37.234519+00:00 0 9 1285 725 880 692 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.2498038 2023-05-03T18:27:37.249804+00:00 0 9 1285 725 880 687 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.2659712 2023-05-03T18:27:37.265971+00:00 0 9 1285 725 880 686 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.2821517 2023-05-03T18:27:37.282152+00:00 0 9 1285 725 880 683 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.2983224 2023-05-03T18:27:37.298322+00:00 0 9 1285 725 880 681 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.3144603 2023-05-03T18:27:37.314460+00:00 0 9 1285 725 880 678 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.3296304 2023-05-03T18:27:37.329630+00:00 0 9 1285 725 880 677 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.3457754 2023-05-03T18:27:37.345775+00:00 0 9 1285 725 880 676 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.3619566 2023-05-03T18:27:37.361957+00:00 0 9 1285 725 880 676 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.378099 2023-05-03T18:27:37.378099+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.3942502 2023-05-03T18:27:37.394250+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.410443 2023-05-03T18:27:37.410443+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.4256585 2023-05-03T18:27:37.425658+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.4418452 2023-05-03T18:27:37.441845+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.458015 2023-05-03T18:27:37.458015+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.4741883 2023-05-03T18:27:37.474188+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.4903722 2023-05-03T18:27:37.490372+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.5065553 2023-05-03T18:27:37.506555+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.5227973 2023-05-03T18:27:37.522797+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.538981 2023-05-03T18:27:37.538981+00:00 0 9 1285 725 880 675 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.5551422 2023-05-03T18:27:37.555142+00:00 0 9 1285 725 880 676 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.571305 2023-05-03T18:27:37.571305+00:00 0 9 1285 725 880 683 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.5875359 2023-05-03T18:27:37.587536+00:00 0 9 1285 725 880 683 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.6027648 2023-05-03T18:27:37.602765+00:00 0 9 1285 725 880 698 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.6189861 2023-05-03T18:27:37.618986+00:00 0 9 1285 725 880 708 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.6352422 2023-05-03T18:27:37.635242+00:00 0 9 1285 725 880 718 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.651422 2023-05-03T18:27:37.651422+00:00 0 9 1285 725 880 728 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.6675994 2023-05-03T18:27:37.667599+00:00 0 9 1285 725 880 736 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.6838589 2023-05-03T18:27:37.683859+00:00 0 9 1285 725 880 742 1660 660 0 0
exp_2023_05_03_10 166 -3 leopard cheetah 1683138457.700139 2023-05-03T18:27:37.700139+00:00 0 9 1285 725 880 745 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]);