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 player_2_id = 154

View and edit SQL

Suggested facets: task_started, 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_2023_04_27_14 99901 154 161 1682635118.4040499 2023-04-27T22:38:38.404050+00:00 0 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_04_27_14 99901 154 161 1682635118.4200845 2023-04-27T22:38:38.420084+00:00 0 10 1285 725 880 648 880 470 880 809 1660 476 0 0
exp_2023_04_27_14 99901 154 161 1682635118.4363055 2023-04-27T22:38:38.436306+00:00 0 10 1285 725 880 648 880 470 880 809 1660 488 0 0
exp_2023_04_27_14 99901 154 161 1682635118.4525304 2023-04-27T22:38:38.452530+00:00 0 10 1285 725 880 648 880 470 880 809 1660 488 0 0
exp_2023_04_27_14 99901 154 161 1682635118.4687417 2023-04-27T22:38:38.468742+00:00 0 10 1285 725 880 648 880 470 880 809 1660 500 0 0
exp_2023_04_27_14 99901 154 161 1682635118.484952 2023-04-27T22:38:38.484952+00:00 0 10 1285 725 880 648 880 470 880 809 1660 512 0 0
exp_2023_04_27_14 99901 154 161 1682635118.500154 2023-04-27T22:38:38.500154+00:00 0 10 1285 725 880 648 880 470 880 809 1660 524 0 0
exp_2023_04_27_14 99901 154 161 1682635118.5163603 2023-04-27T22:38:38.516360+00:00 0 10 1285 725 880 648 880 470 880 809 1660 536 0 0
exp_2023_04_27_14 99901 154 161 1682635118.532558 2023-04-27T22:38:38.532558+00:00 0 10 1285 725 880 648 880 470 880 809 1660 548 0 0
exp_2023_04_27_14 99901 154 161 1682635118.5487576 2023-04-27T22:38:38.548758+00:00 0 10 1285 725 880 648 880 470 880 809 1660 548 0 0
exp_2023_04_27_14 99901 154 161 1682635118.5649793 2023-04-27T22:38:38.564979+00:00 0 10 1285 725 880 648 880 470 880 809 1660 560 0 0
exp_2023_04_27_14 99901 154 161 1682635118.5801833 2023-04-27T22:38:38.580183+00:00 0 10 1285 725 880 648 880 470 880 809 1660 572 0 0
exp_2023_04_27_14 99901 154 161 1682635118.5963814 2023-04-27T22:38:38.596381+00:00 0 10 1285 725 880 648 880 470 880 809 1660 584 0 0
exp_2023_04_27_14 99901 154 161 1682635118.6126008 2023-04-27T22:38:38.612601+00:00 0 10 1285 725 880 648 880 470 880 809 1660 584 0 0
exp_2023_04_27_14 99901 154 161 1682635118.628803 2023-04-27T22:38:38.628803+00:00 0 10 1285 725 880 648 880 470 880 809 1660 596 0 0
exp_2023_04_27_14 99901 154 161 1682635118.6450033 2023-04-27T22:38:38.645003+00:00 0 10 1285 725 880 648 880 470 880 809 1660 608 0 0
exp_2023_04_27_14 99901 154 161 1682635118.6602108 2023-04-27T22:38:38.660211+00:00 0 10 1285 725 880 648 880 470 880 809 1660 620 0 0
exp_2023_04_27_14 99901 154 161 1682635118.6764395 2023-04-27T22:38:38.676440+00:00 0 10 1285 725 880 648 880 470 880 809 1660 620 0 0
exp_2023_04_27_14 99901 154 161 1682635118.6927004 2023-04-27T22:38:38.692700+00:00 0 10 1285 725 880 648 880 470 880 809 1660 632 0 0
exp_2023_04_27_14 99901 154 161 1682635118.7089548 2023-04-27T22:38:38.708955+00:00 0 10 1285 725 880 648 880 470 880 809 1660 644 0 0
exp_2023_04_27_14 99901 154 161 1682635118.7241967 2023-04-27T22:38:38.724197+00:00 0 10 1285 725 880 648 880 470 880 809 1660 656 0 0
exp_2023_04_27_14 99901 154 161 1682635118.740398 2023-04-27T22:38:38.740398+00:00 0 10 1285 725 880 648 880 470 880 809 1660 656 0 0
exp_2023_04_27_14 99901 154 161 1682635118.7565536 2023-04-27T22:38:38.756554+00:00 0 10 1285 725 880 648 880 470 880 809 1660 668 0 0
exp_2023_04_27_14 99901 154 161 1682635118.7727618 2023-04-27T22:38:38.772762+00:00 0 10 1285 725 880 648 880 470 880 809 1660 678 0 0
exp_2023_04_27_14 99901 154 161 1682635118.7889738 2023-04-27T22:38:38.788974+00:00 0 10 1285 725 880 648 880 470 880 809 1660 682 0 0
exp_2023_04_27_14 99901 154 161 1682635118.8042135 2023-04-27T22:38:38.804214+00:00 0 10 1285 725 880 648 880 470 880 809 1660 682 0 0
exp_2023_04_27_14 99901 154 161 1682635118.8203683 2023-04-27T22:38:38.820368+00:00 0 10 1285 725 880 648 880 470 880 809 1660 683 0 0
exp_2023_04_27_14 99901 154 161 1682635118.8365893 2023-04-27T22:38:38.836589+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.85279 2023-04-27T22:38:38.852790+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.8690052 2023-04-27T22:38:38.869005+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.8842223 2023-04-27T22:38:38.884222+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.9004383 2023-04-27T22:38:38.900438+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.9166603 2023-04-27T22:38:38.916660+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.9328701 2023-04-27T22:38:38.932870+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.9480906 2023-04-27T22:38:38.948091+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.9643044 2023-04-27T22:38:38.964304+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.9804823 2023-04-27T22:38:38.980482+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635118.9966938 2023-04-27T22:38:38.996694+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.0129044 2023-04-27T22:38:39.012904+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.0281157 2023-04-27T22:38:39.028116+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.0443568 2023-04-27T22:38:39.044357+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.0606382 2023-04-27T22:38:39.060638+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.076927 2023-04-27T22:38:39.076927+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.0921977 2023-04-27T22:38:39.092198+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.108493 2023-04-27T22:38:39.108493+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.124792 2023-04-27T22:38:39.124792+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.141106 2023-04-27T22:38:39.141106+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.1574035 2023-04-27T22:38:39.157403+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.1736693 2023-04-27T22:38:39.173669+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.18995 2023-04-27T22:38:39.189950+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.2052577 2023-04-27T22:38:39.205258+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.2215924 2023-04-27T22:38:39.221592+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.2378798 2023-04-27T22:38:39.237880+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.2531774 2023-04-27T22:38:39.253177+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.2694561 2023-04-27T22:38:39.269456+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.2857568 2023-04-27T22:38:39.285757+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.302044 2023-04-27T22:38:39.302044+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.3173099 2023-04-27T22:38:39.317310+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.3336 2023-04-27T22:38:39.333600+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.3499148 2023-04-27T22:38:39.349915+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.3652031 2023-04-27T22:38:39.365203+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.3814776 2023-04-27T22:38:39.381478+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.3977523 2023-04-27T22:38:39.397752+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.4140182 2023-04-27T22:38:39.414018+00:00 0 10 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.4293194 2023-04-27T22:38:39.429319+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.4457126 2023-04-27T22:38:39.445713+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.4620414 2023-04-27T22:38:39.462041+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.4773333 2023-04-27T22:38:39.477333+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.493552 2023-04-27T22:38:39.493552+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.509791 2023-04-27T22:38:39.509791+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.52605 2023-04-27T22:38:39.526050+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.5413313 2023-04-27T22:38:39.541331+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.557568 2023-04-27T22:38:39.557568+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.5738156 2023-04-27T22:38:39.573816+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.5900602 2023-04-27T22:38:39.590060+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.6053348 2023-04-27T22:38:39.605335+00:00 0 9 1285 725 880 648 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.6215997 2023-04-27T22:38:39.621600+00:00 0 9 1285 725 880 532 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.63786 2023-04-27T22:38:39.637860+00:00 0 9 1285 725 880 532 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.6541739 2023-04-27T22:38:39.654174+00:00 0 9 1285 725 880 482 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.670443 2023-04-27T22:38:39.670443+00:00 0 9 1285 725 880 470 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.6866891 2023-04-27T22:38:39.686689+00:00 0 9 1285 725 880 470 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.702917 2023-04-27T22:38:39.702917+00:00 0 9 1285 725 880 470 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.7181315 2023-04-27T22:38:39.718132+00:00 0 9 1285 725 880 470 880 470 880 809 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.734366 2023-04-27T22:38:39.734366+00:00 0 9 1285 725 880 470 880 470 880 808 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.7506466 2023-04-27T22:38:39.750647+00:00 0 9 1285 725 880 470 880 470 880 799 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.767022 2023-04-27T22:38:39.767022+00:00 0 9 1285 725 880 470 880 470 880 799 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.78229 2023-04-27T22:38:39.782290+00:00 0 9 1285 725 880 470 880 470 880 788 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.798517 2023-04-27T22:38:39.798517+00:00 0 9 1285 725 880 470 880 470 880 778 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.8147845 2023-04-27T22:38:39.814785+00:00 0 9 1285 725 880 470 880 470 880 771 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.8310328 2023-04-27T22:38:39.831033+00:00 0 9 1285 725 880 470 880 470 880 763 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.846259 2023-04-27T22:38:39.846259+00:00 0 9 1285 725 880 470 880 470 880 755 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.8624887 2023-04-27T22:38:39.862489+00:00 0 9 1285 725 880 470 880 470 880 743 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.8787286 2023-04-27T22:38:39.878729+00:00 0 9 1285 725 880 470 880 470 880 737 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.8950093 2023-04-27T22:38:39.895009+00:00 0 9 1285 725 880 473 880 470 880 733 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.9102643 2023-04-27T22:38:39.910264+00:00 0 9 1285 725 880 477 880 470 880 730 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.92649 2023-04-27T22:38:39.926490+00:00 0 9 1285 725 880 520 880 470 880 729 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.9427161 2023-04-27T22:38:39.942716+00:00 0 9 1285 725 880 542 880 470 880 729 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.958988 2023-04-27T22:38:39.958988+00:00 0 9 1285 725 880 566 880 470 880 729 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.9741898 2023-04-27T22:38:39.974190+00:00 0 9 1285 725 880 566 880 470 880 729 1660 684 0 0
exp_2023_04_27_14 99901 154 161 1682635119.990387 2023-04-27T22:38:39.990387+00:00 0 9 1285 725 880 581 880 484 880 729 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]);