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 ball_position_y = 734 and group_session = "exp_2022_11_01_10"

View and edit SQL

Suggested facets: player_1_id, player_2_id, player_1_station, player_2_station, seconds, player_1_paddle_position_y, player_1_score, player_2_score

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_01_10 63 67 lion tiger 1667328456.2327998 2022-11-01T18:47:36.232800+00:00 1 111 1562 734 880 685 1660 698 1 1
exp_2022_11_01_10 63 67 lion tiger 1667328458.6116292 2022-11-01T18:47:38.611629+00:00 1 109 1566 734 880 850 1660 670 1 1
exp_2022_11_01_10 63 67 lion tiger 1667328460.95545 2022-11-01T18:47:40.955450+00:00 1 107 1368 734 880 699 1660 612 1 1
exp_2022_11_01_10 63 67 lion tiger 1667328477.8912508 2022-11-01T18:47:57.891251+00:00 1 90 1656 734 880 558 1660 594 3 3
exp_2022_11_01_10 63 67 lion tiger 1667328487.643234 2022-11-01T18:48:07.643234+00:00 1 80 952 734 880 631 1660 610 4 5
exp_2022_11_01_10 63 67 lion tiger 1667328502.186744 2022-11-01T18:48:22.186744+00:00 1 66 1503 734 880 472 1660 735 4 6
exp_2022_11_01_10 63 67 lion tiger 1667328506.7749505 2022-11-01T18:48:26.774951+00:00 1 61 1053 734 880 822 1660 515 4 6
exp_2022_11_01_10 63 67 lion tiger 1667328507.833676 2022-11-01T18:48:27.833676+00:00 1 60 1647 734 880 822 1660 765 4 6
exp_2022_11_01_10 63 67 lion tiger 1667328508.895745 2022-11-01T18:48:28.895745+00:00 1 59 1074 734 880 747 1660 526 4 6
exp_2022_11_01_10 63 67 lion tiger 1667328518.388976 2022-11-01T18:48:38.388976+00:00 1 49 1449 734 880 575 1660 715 5 6
exp_2022_11_01_10 63 67 lion tiger 1667328526.5328097 2022-11-01T18:48:46.532810+00:00 1 41 1440 734 880 554 1660 517 6 6
exp_2022_11_01_10 63 67 lion tiger 1667328531.706978 2022-11-01T18:48:51.706978+00:00 1 36 1305 734 880 598 1660 566 6 6
exp_2022_11_01_10 63 67 lion tiger 1667328538.0026321 2022-11-01T18:48:58.002632+00:00 1 30 1497 734 880 527 1660 539 6 6
exp_2022_11_01_10 63 67 lion tiger 1667328539.1869917 2022-11-01T18:48:59.186992+00:00 1 29 936 734 880 580 1660 580 6 7
exp_2022_11_01_10 63 67 lion tiger 1667328540.005031 2022-11-01T18:49:00.005031+00:00 1 28 1395 734 880 631 1660 618 6 7
exp_2022_11_01_10 63 67 lion tiger 1667328542.9464772 2022-11-01T18:49:02.946477+00:00 1 25 1530 734 880 614 1660 566 6 7
exp_2022_11_01_10 63 67 lion tiger 1667328546.3801236 2022-11-01T18:49:06.380124+00:00 1 21 1398 734 880 638 1660 771 6 8
exp_2022_11_01_10 63 67 lion tiger 1667328548.1482887 2022-11-01T18:49:08.148289+00:00 1 20 1348 734 880 599 1660 620 6 9
exp_2022_11_01_10 99905 -3 leopard cheetah 1667328450.9606292 2022-11-01T18:47:30.960629+00:00 1 117 1461 734 880 725 1660 744 1 0
exp_2022_11_01_10 99905 -3 leopard cheetah 1667328454.9178596 2022-11-01T18:47:34.917860+00:00 1 113 1035 734 880 679 1660 850 1 0
exp_2022_11_01_10 99905 -3 leopard cheetah 1667328471.0409122 2022-11-01T18:47:51.040912+00:00 1 97 936 734 880 655 1660 594 1 2
exp_2022_11_01_10 99905 -3 leopard cheetah 1667328533.8414075 2022-11-01T18:48:53.841408+00:00 1 34 1152 734 880 840 1660 819 4 4
exp_2022_11_01_10 99905 -3 leopard cheetah 1667328536.7519696 2022-11-01T18:48:56.751970+00:00 1 31 1233 734 880 755 1660 605 5 4
exp_2022_11_01_10 99905 -3 leopard cheetah 1667328543.1297278 2022-11-01T18:49:03.129728+00:00 1 25 1560 734 880 658 1660 850 5 5
exp_2022_11_01_10 99905 -3 leopard cheetah 1667328550.1214375 2022-11-01T18:49:10.121438+00:00 1 18 1051 734 880 518 1660 645 5 7
exp_2022_11_01_10 99905 -3 leopard cheetah 1667328551.5806293 2022-11-01T18:49:11.580629+00:00 1 16 1434 734 880 655 1660 822 5 7
exp_2022_11_01_10 99905 -3 leopard cheetah 1667328567.161394 2022-11-01T18:49:27.161394+00:00 1 1 1530 734 880 601 1660 622 5 7

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])
);