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

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 99906 53 lion tiger 1667587857.4909391 2022-11-04T18:50:57.490939+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.5065403 2022-11-04T18:50:57.506540+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.5227845 2022-11-04T18:50:57.522784+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.5389705 2022-11-04T18:50:57.538970+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.555141 2022-11-04T18:50:57.555141+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.5712998 2022-11-04T18:50:57.571300+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.5874662 2022-11-04T18:50:57.587466+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.6036422 2022-11-04T18:50:57.603642+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.6198013 2022-11-04T18:50:57.619801+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.63599 2022-11-04T18:50:57.635990+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.6521966 2022-11-04T18:50:57.652197+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.6683917 2022-11-04T18:50:57.668392+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.6845891 2022-11-04T18:50:57.684589+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.700799 2022-11-04T18:50:57.700799+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.7170162 2022-11-04T18:50:57.717016+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.7332623 2022-11-04T18:50:57.733262+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.7494771 2022-11-04T18:50:57.749477+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.765678 2022-11-04T18:50:57.765678+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.7818632 2022-11-04T18:50:57.781863+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.7970316 2022-11-04T18:50:57.797032+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.813238 2022-11-04T18:50:57.813238+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.8294184 2022-11-04T18:50:57.829418+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.845636 2022-11-04T18:50:57.845636+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.8618596 2022-11-04T18:50:57.861860+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.8770578 2022-11-04T18:50:57.877058+00:00 1 10 1285 725 880 732 1660 850 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.8932505 2022-11-04T18:50:57.893250+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.9094615 2022-11-04T18:50:57.909461+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.9256952 2022-11-04T18:50:57.925695+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.9419255 2022-11-04T18:50:57.941926+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.957059 2022-11-04T18:50:57.957059+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.9732113 2022-11-04T18:50:57.973211+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587857.9894092 2022-11-04T18:50:57.989409+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.0056062 2022-11-04T18:50:58.005606+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.0218015 2022-11-04T18:50:58.021801+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.037994 2022-11-04T18:50:58.037994+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.0541852 2022-11-04T18:50:58.054185+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.0703862 2022-11-04T18:50:58.070386+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.0865815 2022-11-04T18:50:58.086581+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.1028097 2022-11-04T18:50:58.102810+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.1180668 2022-11-04T18:50:58.118067+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.1342962 2022-11-04T18:50:58.134296+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.1505003 2022-11-04T18:50:58.150500+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.1666737 2022-11-04T18:50:58.166674+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.1828372 2022-11-04T18:50:58.182837+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.1990142 2022-11-04T18:50:58.199014+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.2151997 2022-11-04T18:50:58.215200+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.2313766 2022-11-04T18:50:58.231377+00:00 1 10 1285 725 880 732 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.2475357 2022-11-04T18:50:58.247536+00:00 1 10 1285 725 880 738 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.2637165 2022-11-04T18:50:58.263716+00:00 1 10 1285 725 880 741 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.2799075 2022-11-04T18:50:58.279907+00:00 1 10 1285 725 880 745 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.2950962 2022-11-04T18:50:58.295096+00:00 1 10 1285 725 880 745 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.3112779 2022-11-04T18:50:58.311278+00:00 1 10 1285 725 880 750 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.32746 2022-11-04T18:50:58.327460+00:00 1 10 1285 725 880 756 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.3436399 2022-11-04T18:50:58.343640+00:00 1 10 1285 725 880 756 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.3598392 2022-11-04T18:50:58.359839+00:00 1 10 1285 725 880 759 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.3760307 2022-11-04T18:50:58.376031+00:00 1 10 1285 725 880 763 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.3921807 2022-11-04T18:50:58.392181+00:00 1 10 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.4083374 2022-11-04T18:50:58.408337+00:00 1 10 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.4245136 2022-11-04T18:50:58.424514+00:00 1 10 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.4407306 2022-11-04T18:50:58.440731+00:00 1 10 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.4569597 2022-11-04T18:50:58.456960+00:00 1 10 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.4721942 2022-11-04T18:50:58.472194+00:00 1 10 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.488363 2022-11-04T18:50:58.488363+00:00 1 10 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.504548 2022-11-04T18:50:58.504548+00:00 1 10 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.5207968 2022-11-04T18:50:58.520797+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.5370347 2022-11-04T18:50:58.537035+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.5532355 2022-11-04T18:50:58.553236+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.5694242 2022-11-04T18:50:58.569424+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.5856233 2022-11-04T18:50:58.585623+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.6018176 2022-11-04T18:50:58.601818+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.6179905 2022-11-04T18:50:58.617990+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.6341474 2022-11-04T18:50:58.634147+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.6503158 2022-11-04T18:50:58.650316+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.6664877 2022-11-04T18:50:58.666488+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.6826875 2022-11-04T18:50:58.682688+00:00 1 9 1285 725 880 764 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.6988754 2022-11-04T18:50:58.698875+00:00 1 9 1285 725 880 763 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.7140675 2022-11-04T18:50:58.714067+00:00 1 9 1285 725 880 756 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.7302568 2022-11-04T18:50:58.730257+00:00 1 9 1285 725 880 749 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.7464674 2022-11-04T18:50:58.746467+00:00 1 9 1285 725 880 748 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.762668 2022-11-04T18:50:58.762668+00:00 1 9 1285 725 880 742 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.7788653 2022-11-04T18:50:58.778865+00:00 1 9 1285 725 880 733 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.7950537 2022-11-04T18:50:58.795054+00:00 1 9 1285 725 880 717 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.8112624 2022-11-04T18:50:58.811262+00:00 1 9 1285 725 880 696 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.8275285 2022-11-04T18:50:58.827528+00:00 1 9 1285 725 880 696 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.8437965 2022-11-04T18:50:58.843796+00:00 1 9 1285 725 880 684 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.8600497 2022-11-04T18:50:58.860050+00:00 1 9 1285 725 880 674 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.8763037 2022-11-04T18:50:58.876304+00:00 1 9 1285 725 880 667 1660 470 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.8925762 2022-11-04T18:50:58.892576+00:00 1 9 1285 725 880 664 1660 473 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.9088478 2022-11-04T18:50:58.908848+00:00 1 9 1285 725 880 664 1660 481 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.9241123 2022-11-04T18:50:58.924112+00:00 1 9 1285 725 880 664 1660 502 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.9403942 2022-11-04T18:50:58.940394+00:00 1 9 1285 725 880 664 1660 517 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.9566622 2022-11-04T18:50:58.956662+00:00 1 9 1285 725 880 664 1660 531 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.9729404 2022-11-04T18:50:58.972940+00:00 1 9 1285 725 880 664 1660 544 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587858.988223 2022-11-04T18:50:58.988223+00:00 1 9 1285 725 880 664 1660 557 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587859.0045 2022-11-04T18:50:59.004500+00:00 1 9 1285 725 880 664 1660 557 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587859.0207732 2022-11-04T18:50:59.020773+00:00 1 9 1285 725 880 664 1660 573 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587859.0370412 2022-11-04T18:50:59.037041+00:00 1 9 1285 725 880 664 1660 581 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587859.0532923 2022-11-04T18:50:59.053292+00:00 1 9 1285 725 880 664 1660 585 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587859.0695112 2022-11-04T18:50:59.069511+00:00 1 9 1285 725 880 664 1660 586 0 0
exp_2022_11_04_10 99906 53 lion tiger 1667587859.0857413 2022-11-04T18:50:59.085741+00:00 1 9 1285 725 880 664 1660 586 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]);