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

View and edit SQL

Suggested facets: 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_10_10 74 75 lion tiger 1668106125.3528483 2022-11-10T18:48:45.352848+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.369221 2022-11-10T18:48:45.369221+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.385447 2022-11-10T18:48:45.385447+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.4016466 2022-11-10T18:48:45.401647+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.4178572 2022-11-10T18:48:45.417857+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.4340928 2022-11-10T18:48:45.434093+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.450306 2022-11-10T18:48:45.450306+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.4664674 2022-11-10T18:48:45.466467+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.4826624 2022-11-10T18:48:45.482662+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.4988563 2022-11-10T18:48:45.498856+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.5150502 2022-11-10T18:48:45.515050+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.5312402 2022-11-10T18:48:45.531240+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.547398 2022-11-10T18:48:45.547398+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.5635424 2022-11-10T18:48:45.563542+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.5786898 2022-11-10T18:48:45.578690+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.5948715 2022-11-10T18:48:45.594872+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.6110373 2022-11-10T18:48:45.611037+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.627216 2022-11-10T18:48:45.627216+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.6433396 2022-11-10T18:48:45.643340+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.6594708 2022-11-10T18:48:45.659471+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.6756508 2022-11-10T18:48:45.675651+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.6919217 2022-11-10T18:48:45.691922+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.7081678 2022-11-10T18:48:45.708168+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.724373 2022-11-10T18:48:45.724373+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.7405689 2022-11-10T18:48:45.740569+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.755761 2022-11-10T18:48:45.755761+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.7720041 2022-11-10T18:48:45.772004+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.7881985 2022-11-10T18:48:45.788198+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.804367 2022-11-10T18:48:45.804367+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.82052 2022-11-10T18:48:45.820520+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.8357038 2022-11-10T18:48:45.835704+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.8518844 2022-11-10T18:48:45.851884+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.8680723 2022-11-10T18:48:45.868072+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.8842516 2022-11-10T18:48:45.884252+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.9004269 2022-11-10T18:48:45.900427+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.9166315 2022-11-10T18:48:45.916631+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.931855 2022-11-10T18:48:45.931855+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.9481132 2022-11-10T18:48:45.948113+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.96431 2022-11-10T18:48:45.964310+00:00 1 10 1285 725 880 470 1660 772 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.9805415 2022-11-10T18:48:45.980541+00:00 1 10 1285 725 880 470 1660 820 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106125.9957807 2022-11-10T18:48:45.995781+00:00 1 10 1285 725 880 470 1660 823 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.0120082 2022-11-10T18:48:46.012008+00:00 1 10 1285 725 880 470 1660 826 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.0282512 2022-11-10T18:48:46.028251+00:00 1 10 1285 725 880 470 1660 828 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.044523 2022-11-10T18:48:46.044523+00:00 1 10 1285 725 880 470 1660 828 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.0598278 2022-11-10T18:48:46.059828+00:00 1 10 1285 725 880 470 1660 830 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.076049 2022-11-10T18:48:46.076049+00:00 1 10 1285 725 880 470 1660 830 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.0922225 2022-11-10T18:48:46.092222+00:00 1 10 1285 725 880 470 1660 830 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.1083815 2022-11-10T18:48:46.108382+00:00 1 10 1285 725 880 470 1660 830 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.124555 2022-11-10T18:48:46.124555+00:00 1 10 1285 725 880 850 1660 830 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.139751 2022-11-10T18:48:46.139751+00:00 1 10 1285 725 880 850 1660 817 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.1559215 2022-11-10T18:48:46.155921+00:00 1 10 1285 725 880 850 1660 817 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.1720977 2022-11-10T18:48:46.172098+00:00 1 10 1285 725 880 850 1660 802 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.1882713 2022-11-10T18:48:46.188271+00:00 1 10 1285 725 880 850 1660 787 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.2044616 2022-11-10T18:48:46.204462+00:00 1 10 1285 725 880 850 1660 775 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.220709 2022-11-10T18:48:46.220709+00:00 1 10 1285 725 880 850 1660 770 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.2369356 2022-11-10T18:48:46.236936+00:00 1 10 1285 725 880 850 1660 770 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.253161 2022-11-10T18:48:46.253161+00:00 1 10 1285 725 880 850 1660 776 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.26941 2022-11-10T18:48:46.269410+00:00 1 10 1285 725 880 850 1660 802 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.28559 2022-11-10T18:48:46.285590+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.300778 2022-11-10T18:48:46.300778+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.316954 2022-11-10T18:48:46.316954+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.333125 2022-11-10T18:48:46.333125+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.3493283 2022-11-10T18:48:46.349328+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.3655741 2022-11-10T18:48:46.365574+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.380811 2022-11-10T18:48:46.380811+00:00 1 9 1285 725 880 850 1660 849 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.3970597 2022-11-10T18:48:46.397060+00:00 1 9 1285 725 880 846 1660 821 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.4133034 2022-11-10T18:48:46.413303+00:00 1 9 1285 725 880 839 1660 759 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.4295485 2022-11-10T18:48:46.429549+00:00 1 9 1285 725 880 828 1660 674 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.4447773 2022-11-10T18:48:46.444777+00:00 1 9 1285 725 880 813 1660 475 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.4610026 2022-11-10T18:48:46.461003+00:00 1 9 1285 725 880 802 1660 470 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.477174 2022-11-10T18:48:46.477174+00:00 1 9 1285 725 880 790 1660 470 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.4933345 2022-11-10T18:48:46.493335+00:00 1 9 1285 725 880 778 1660 470 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.5094879 2022-11-10T18:48:46.509488+00:00 1 9 1285 725 880 769 1660 470 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.5256395 2022-11-10T18:48:46.525640+00:00 1 9 1285 725 880 754 1660 470 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.5408146 2022-11-10T18:48:46.540815+00:00 1 9 1285 725 880 754 1660 482 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.5569997 2022-11-10T18:48:46.557000+00:00 1 9 1285 725 880 753 1660 498 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.5731862 2022-11-10T18:48:46.573186+00:00 1 9 1285 725 880 748 1660 545 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.5894158 2022-11-10T18:48:46.589416+00:00 1 9 1285 725 880 738 1660 605 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.6056566 2022-11-10T18:48:46.605657+00:00 1 9 1285 725 880 726 1660 664 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.620918 2022-11-10T18:48:46.620918+00:00 1 9 1285 725 880 719 1660 718 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.6371834 2022-11-10T18:48:46.637183+00:00 1 9 1285 725 880 714 1660 736 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.6534398 2022-11-10T18:48:46.653440+00:00 1 9 1285 725 880 713 1660 736 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.6697266 2022-11-10T18:48:46.669727+00:00 1 9 1285 725 880 713 1660 734 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.6859827 2022-11-10T18:48:46.685983+00:00 1 9 1285 725 880 713 1660 705 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.7022321 2022-11-10T18:48:46.702232+00:00 1 9 1285 725 880 713 1660 661 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.7184896 2022-11-10T18:48:46.718490+00:00 1 9 1285 725 880 713 1660 595 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.7337508 2022-11-10T18:48:46.733751+00:00 1 9 1285 725 880 713 1660 595 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.749996 2022-11-10T18:48:46.749996+00:00 1 9 1285 725 880 713 1660 491 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.766221 2022-11-10T18:48:46.766221+00:00 1 9 1285 725 880 713 1660 470 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.7824721 2022-11-10T18:48:46.782472+00:00 1 9 1285 725 880 712 1660 470 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.7987375 2022-11-10T18:48:46.798738+00:00 1 9 1285 725 880 712 1660 470 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.81497 2022-11-10T18:48:46.814970+00:00 1 9 1285 725 880 709 1660 476 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.8312192 2022-11-10T18:48:46.831219+00:00 1 9 1285 725 880 703 1660 506 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.8474708 2022-11-10T18:48:46.847471+00:00 1 9 1285 725 880 694 1660 605 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.8627546 2022-11-10T18:48:46.862755+00:00 1 9 1285 725 880 688 1660 605 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.878986 2022-11-10T18:48:46.878986+00:00 1 9 1285 725 880 667 1660 726 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.8952053 2022-11-10T18:48:46.895205+00:00 1 9 1285 725 880 663 1660 793 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.911465 2022-11-10T18:48:46.911465+00:00 1 9 1285 725 880 663 1660 836 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.9277318 2022-11-10T18:48:46.927732+00:00 1 9 1285 725 880 641 1660 850 0 0
exp_2022_11_10_10 74 75 lion tiger 1668106126.9439783 2022-11-10T18:48:46.943978+00:00 1 9 1285 725 880 625 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]);