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_3_id
Player 3's participant ID
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_3_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 3's paddle.
player_3_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 3's paddle.
ai_paddle_position_x
The x-coordinate of the pixel at the top left corner of the AI player's paddle.
ai_paddle_position_y
The y-coordinate of the pixel at the top left corner of the AI player's paddle.
team_score
The team's score.
ai_score
The score of the AI player.

where group_session = "exp_2022_11_22_10"

View and edit SQL

Suggested facets: team_score, ai_score, timestamp_iso8601 (date)

Link group_session player_1_id player_2_id player_3_id 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_3_paddle_position_x player_3_paddle_position_y ai_paddle_position_x ai_paddle_position_y team_score ai_score
exp_2022_11_22_10 55 81 88 1669143453.2153125 2022-11-22T18:57:33.215312+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_11_22_10 55 81 88 1669143453.2310183 2022-11-22T18:57:33.231018+00:00 1 10 1285 725 880 538 880 470 880 880 1660 621 0 0
exp_2022_11_22_10 55 81 88 1669143453.2472034 2022-11-22T18:57:33.247203+00:00 1 10 1285 725 880 538 880 470 880 880 1660 621 0 0
exp_2022_11_22_10 55 81 88 1669143453.2633939 2022-11-22T18:57:33.263394+00:00 1 10 1285 725 880 538 880 470 880 880 1660 633 0 0
exp_2022_11_22_10 55 81 88 1669143453.2795568 2022-11-22T18:57:33.279557+00:00 1 10 1285 725 880 538 880 470 880 880 1660 645 0 0
exp_2022_11_22_10 55 81 88 1669143453.2957416 2022-11-22T18:57:33.295742+00:00 1 10 1285 725 880 538 880 470 880 880 1660 657 0 0
exp_2022_11_22_10 55 81 88 1669143453.3119242 2022-11-22T18:57:33.311924+00:00 1 10 1285 725 880 538 880 470 880 880 1660 669 0 0
exp_2022_11_22_10 55 81 88 1669143453.3281052 2022-11-22T18:57:33.328105+00:00 1 10 1285 725 880 538 880 470 880 880 1660 678 0 0
exp_2022_11_22_10 55 81 88 1669143453.3442974 2022-11-22T18:57:33.344297+00:00 1 10 1285 725 880 538 880 470 880 880 1660 682 0 0
exp_2022_11_22_10 55 81 88 1669143453.3604834 2022-11-22T18:57:33.360483+00:00 1 10 1285 725 880 538 880 470 880 880 1660 683 0 0
exp_2022_11_22_10 55 81 88 1669143453.3766837 2022-11-22T18:57:33.376684+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.3918664 2022-11-22T18:57:33.391866+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.4080496 2022-11-22T18:57:33.408050+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.424232 2022-11-22T18:57:33.424232+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.4404159 2022-11-22T18:57:33.440416+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.4566011 2022-11-22T18:57:33.456601+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.471784 2022-11-22T18:57:33.471784+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.4879673 2022-11-22T18:57:33.487967+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.5041494 2022-11-22T18:57:33.504149+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.5203307 2022-11-22T18:57:33.520331+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.5365162 2022-11-22T18:57:33.536516+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.5526993 2022-11-22T18:57:33.552699+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.5678782 2022-11-22T18:57:33.567878+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.5840583 2022-11-22T18:57:33.584058+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.6002471 2022-11-22T18:57:33.600247+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.6164262 2022-11-22T18:57:33.616426+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.632607 2022-11-22T18:57:33.632607+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.6477914 2022-11-22T18:57:33.647791+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.6639936 2022-11-22T18:57:33.663994+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.6801865 2022-11-22T18:57:33.680187+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.6963663 2022-11-22T18:57:33.696366+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.7125545 2022-11-22T18:57:33.712554+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.728741 2022-11-22T18:57:33.728741+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.7449074 2022-11-22T18:57:33.744907+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.7610974 2022-11-22T18:57:33.761097+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.777282 2022-11-22T18:57:33.777282+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.793434 2022-11-22T18:57:33.793434+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.8095856 2022-11-22T18:57:33.809586+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.8248096 2022-11-22T18:57:33.824810+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.8409953 2022-11-22T18:57:33.840995+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.8571644 2022-11-22T18:57:33.857164+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.8733478 2022-11-22T18:57:33.873348+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.889532 2022-11-22T18:57:33.889532+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.9057176 2022-11-22T18:57:33.905718+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.9209251 2022-11-22T18:57:33.920925+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.9371274 2022-11-22T18:57:33.937127+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.953314 2022-11-22T18:57:33.953314+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.969495 2022-11-22T18:57:33.969495+00:00 1 10 1285 725 880 537 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143453.9856424 2022-11-22T18:57:33.985642+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.0008366 2022-11-22T18:57:34.000837+00:00 1 10 1285 725 880 538 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.0170434 2022-11-22T18:57:34.017043+00:00 1 10 1285 725 880 539 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.033187 2022-11-22T18:57:34.033187+00:00 1 10 1285 725 880 539 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.04937 2022-11-22T18:57:34.049370+00:00 1 10 1285 725 880 540 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.0655565 2022-11-22T18:57:34.065557+00:00 1 10 1285 725 880 540 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.0817413 2022-11-22T18:57:34.081741+00:00 1 10 1285 725 880 541 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.0979292 2022-11-22T18:57:34.097929+00:00 1 10 1285 725 880 541 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.114154 2022-11-22T18:57:34.114154+00:00 1 10 1285 725 880 540 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.130421 2022-11-22T18:57:34.130421+00:00 1 10 1285 725 880 536 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.146563 2022-11-22T18:57:34.146563+00:00 1 10 1285 725 880 536 880 470 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.1627536 2022-11-22T18:57:34.162754+00:00 1 10 1285 725 880 535 880 470 880 802 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.178948 2022-11-22T18:57:34.178948+00:00 1 10 1285 725 880 535 880 470 880 802 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.1951487 2022-11-22T18:57:34.195149+00:00 1 10 1285 725 880 535 880 470 880 802 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.2113423 2022-11-22T18:57:34.211342+00:00 1 10 1285 725 880 535 880 470 880 802 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.2275538 2022-11-22T18:57:34.227554+00:00 1 10 1285 725 880 535 880 470 880 800 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.24378 2022-11-22T18:57:34.243780+00:00 1 9 1285 725 880 535 880 470 880 797 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.259986 2022-11-22T18:57:34.259986+00:00 1 9 1285 725 880 535 880 470 880 795 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.2761812 2022-11-22T18:57:34.276181+00:00 1 9 1285 725 880 535 880 470 880 793 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.2924268 2022-11-22T18:57:34.292427+00:00 1 9 1285 725 880 535 880 689 880 793 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.308618 2022-11-22T18:57:34.308618+00:00 1 9 1285 725 880 535 880 689 880 793 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.3237996 2022-11-22T18:57:34.323800+00:00 1 9 1285 725 880 536 880 689 880 795 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.3399918 2022-11-22T18:57:34.339992+00:00 1 9 1285 725 880 551 880 691 880 802 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.3561785 2022-11-22T18:57:34.356179+00:00 1 9 1285 725 880 570 880 709 880 808 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.3723676 2022-11-22T18:57:34.372368+00:00 1 9 1285 725 880 577 880 719 880 816 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.3885684 2022-11-22T18:57:34.388568+00:00 1 9 1285 725 880 577 880 729 880 816 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.4047527 2022-11-22T18:57:34.404753+00:00 1 9 1285 725 880 577 880 729 880 828 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.4209728 2022-11-22T18:57:34.420973+00:00 1 9 1285 725 880 577 880 736 880 838 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.437158 2022-11-22T18:57:34.437158+00:00 1 9 1285 725 880 578 880 741 880 851 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.4533436 2022-11-22T18:57:34.453344+00:00 1 9 1285 725 880 579 880 744 880 861 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.4695399 2022-11-22T18:57:34.469540+00:00 1 9 1285 725 880 579 880 748 880 872 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.485728 2022-11-22T18:57:34.485728+00:00 1 9 1285 725 880 579 880 751 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.5009127 2022-11-22T18:57:34.500913+00:00 1 9 1285 725 880 579 880 760 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.517097 2022-11-22T18:57:34.517097+00:00 1 9 1285 725 880 579 880 760 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.533281 2022-11-22T18:57:34.533281+00:00 1 9 1285 725 880 579 880 761 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.549473 2022-11-22T18:57:34.549473+00:00 1 9 1285 725 880 575 880 761 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.565658 2022-11-22T18:57:34.565658+00:00 1 9 1285 725 880 569 880 761 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.5808465 2022-11-22T18:57:34.580847+00:00 1 9 1285 725 880 560 880 761 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.5970306 2022-11-22T18:57:34.597031+00:00 1 9 1285 725 880 560 880 761 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.6132238 2022-11-22T18:57:34.613224+00:00 1 9 1285 725 880 550 880 761 880 880 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.62941 2022-11-22T18:57:34.629410+00:00 1 9 1285 725 880 549 880 761 880 876 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.6455936 2022-11-22T18:57:34.645594+00:00 1 9 1285 725 880 544 880 761 880 870 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.661781 2022-11-22T18:57:34.661781+00:00 1 9 1285 725 880 537 880 757 880 861 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.677971 2022-11-22T18:57:34.677971+00:00 1 9 1285 725 880 537 880 750 880 846 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.6941662 2022-11-22T18:57:34.694166+00:00 1 9 1285 725 880 522 880 750 880 840 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.71035 2022-11-22T18:57:34.710350+00:00 1 9 1285 725 880 522 880 741 880 823 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.726584 2022-11-22T18:57:34.726584+00:00 1 9 1285 725 880 516 880 728 880 813 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.7427695 2022-11-22T18:57:34.742769+00:00 1 9 1285 725 880 516 880 716 880 798 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.758957 2022-11-22T18:57:34.758957+00:00 1 9 1285 725 880 512 880 705 880 798 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.775151 2022-11-22T18:57:34.775151+00:00 1 9 1285 725 880 500 880 697 880 793 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.791335 2022-11-22T18:57:34.791335+00:00 1 9 1285 725 880 479 880 689 880 790 1660 684 0 0
exp_2022_11_22_10 55 81 88 1669143454.807529 2022-11-22T18:57:34.807529+00:00 1 9 1285 725 880 471 880 689 880 786 1660 684 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "ping_pong_cooperative_task_observation" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [player_1_id] INTEGER REFERENCES [participant]([id]),
   [player_2_id] INTEGER REFERENCES [participant]([id]),
   [player_3_id] INTEGER REFERENCES [participant]([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_3_paddle_position_x] INTEGER,
   [player_3_paddle_position_y] INTEGER,
   [ai_paddle_position_x] INTEGER,
   [ai_paddle_position_y] INTEGER,
   [team_score] INTEGER,
   [ai_score] INTEGER,
   PRIMARY KEY ([group_session], [player_1_id], [player_2_id], [player_3_id], [timestamp_unix])
);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_3_id]
    ON [ping_pong_cooperative_task_observation] ([player_3_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_2_id]
    ON [ping_pong_cooperative_task_observation] ([player_2_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_1_id]
    ON [ping_pong_cooperative_task_observation] ([player_1_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_group_session]
    ON [ping_pong_cooperative_task_observation] ([group_session]);