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_1_id = 43

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_10_21_15 43 45 49 1666396102.118932 2022-10-21T23:48:22.118932+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_10_21_15 43 45 49 1666396102.1348104 2022-10-21T23:48:22.134810+00:00 1 10 1285 725 880 470 880 665 880 880 1660 633 0 0
exp_2022_10_21_15 43 45 49 1666396102.150994 2022-10-21T23:48:22.150994+00:00 1 10 1285 725 880 470 880 665 880 880 1660 645 0 0
exp_2022_10_21_15 43 45 49 1666396102.1671515 2022-10-21T23:48:22.167151+00:00 1 10 1285 725 880 470 880 665 880 880 1660 657 0 0
exp_2022_10_21_15 43 45 49 1666396102.1833408 2022-10-21T23:48:22.183341+00:00 1 10 1285 725 880 470 880 665 880 880 1660 669 0 0
exp_2022_10_21_15 43 45 49 1666396102.199534 2022-10-21T23:48:22.199534+00:00 1 10 1285 725 880 470 880 665 880 880 1660 669 0 0
exp_2022_10_21_15 43 45 49 1666396102.2156944 2022-10-21T23:48:22.215694+00:00 1 10 1285 725 880 470 880 665 880 880 1660 678 0 0
exp_2022_10_21_15 43 45 49 1666396102.2318802 2022-10-21T23:48:22.231880+00:00 1 10 1285 725 880 470 880 665 880 880 1660 687 0 0
exp_2022_10_21_15 43 45 49 1666396102.2480683 2022-10-21T23:48:22.248068+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.2642272 2022-10-21T23:48:22.264227+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.2804148 2022-10-21T23:48:22.280415+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.295608 2022-10-21T23:48:22.295608+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.311792 2022-10-21T23:48:22.311792+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.3279731 2022-10-21T23:48:22.327973+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.344162 2022-10-21T23:48:22.344162+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.3603425 2022-10-21T23:48:22.360343+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.3765175 2022-10-21T23:48:22.376518+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.3927028 2022-10-21T23:48:22.392703+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.408879 2022-10-21T23:48:22.408879+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.4250388 2022-10-21T23:48:22.425039+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.4412367 2022-10-21T23:48:22.441237+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.4574287 2022-10-21T23:48:22.457429+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.4726295 2022-10-21T23:48:22.472630+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.4888225 2022-10-21T23:48:22.488822+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.505008 2022-10-21T23:48:22.505008+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.5211294 2022-10-21T23:48:22.521129+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.5372581 2022-10-21T23:48:22.537258+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.5534124 2022-10-21T23:48:22.553412+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.5685768 2022-10-21T23:48:22.568577+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.584754 2022-10-21T23:48:22.584754+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.6009383 2022-10-21T23:48:22.600938+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.6171007 2022-10-21T23:48:22.617101+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.6332853 2022-10-21T23:48:22.633285+00:00 1 10 1285 725 880 470 880 665 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.6494899 2022-10-21T23:48:22.649490+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.664715 2022-10-21T23:48:22.664715+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.6809165 2022-10-21T23:48:22.680917+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.6971352 2022-10-21T23:48:22.697135+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.7133415 2022-10-21T23:48:22.713341+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.7295642 2022-10-21T23:48:22.729564+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.745784 2022-10-21T23:48:22.745784+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.7620149 2022-10-21T23:48:22.762015+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.778195 2022-10-21T23:48:22.778195+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.7944262 2022-10-21T23:48:22.794426+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.80962 2022-10-21T23:48:22.809620+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.825792 2022-10-21T23:48:22.825792+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.842036 2022-10-21T23:48:22.842036+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.8582587 2022-10-21T23:48:22.858259+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.874454 2022-10-21T23:48:22.874454+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.8896658 2022-10-21T23:48:22.889666+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.905861 2022-10-21T23:48:22.905861+00:00 1 10 1285 725 880 470 880 736 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.9220326 2022-10-21T23:48:22.922033+00:00 1 10 1285 725 880 470 880 735 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.9382558 2022-10-21T23:48:22.938256+00:00 1 10 1285 725 880 470 880 735 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.9544973 2022-10-21T23:48:22.954497+00:00 1 10 1285 725 880 470 880 729 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.9696722 2022-10-21T23:48:22.969672+00:00 1 10 1285 725 880 470 880 724 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396102.9858615 2022-10-21T23:48:22.985862+00:00 1 10 1285 725 880 470 880 719 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.0020676 2022-10-21T23:48:23.002068+00:00 1 10 1285 725 880 470 880 713 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.0182433 2022-10-21T23:48:23.018243+00:00 1 10 1285 725 880 470 880 707 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.0344617 2022-10-21T23:48:23.034462+00:00 1 10 1285 725 880 470 880 701 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.0496538 2022-10-21T23:48:23.049654+00:00 1 10 1285 725 880 470 880 696 880 880 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.0658197 2022-10-21T23:48:23.065820+00:00 1 10 1285 725 880 470 880 691 880 855 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.0819974 2022-10-21T23:48:23.081997+00:00 1 10 1285 725 880 470 880 687 880 855 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.0982044 2022-10-21T23:48:23.098204+00:00 1 10 1285 725 880 470 880 686 880 854 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.114402 2022-10-21T23:48:23.114402+00:00 1 10 1285 725 880 470 880 686 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.1295967 2022-10-21T23:48:23.129597+00:00 1 10 1285 725 880 470 880 686 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.1458218 2022-10-21T23:48:23.145822+00:00 1 9 1285 725 880 470 880 686 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.1620681 2022-10-21T23:48:23.162068+00:00 1 9 1285 725 880 470 880 686 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.1782627 2022-10-21T23:48:23.178263+00:00 1 9 1285 725 880 470 880 686 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.194483 2022-10-21T23:48:23.194483+00:00 1 9 1285 725 880 470 880 686 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.209697 2022-10-21T23:48:23.209697+00:00 1 9 1285 725 880 470 880 686 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.225877 2022-10-21T23:48:23.225877+00:00 1 9 1285 725 880 470 880 686 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.242072 2022-10-21T23:48:23.242072+00:00 1 9 1285 725 880 470 880 686 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.258234 2022-10-21T23:48:23.258234+00:00 1 9 1285 725 880 470 880 687 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.2743921 2022-10-21T23:48:23.274392+00:00 1 9 1285 725 880 470 880 692 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.2905889 2022-10-21T23:48:23.290589+00:00 1 9 1285 725 880 470 880 703 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.3067696 2022-10-21T23:48:23.306770+00:00 1 9 1285 725 880 470 880 710 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.3229408 2022-10-21T23:48:23.322941+00:00 1 9 1285 725 880 470 880 710 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.3391411 2022-10-21T23:48:23.339141+00:00 1 9 1285 725 880 470 880 716 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.3553326 2022-10-21T23:48:23.355333+00:00 1 9 1285 725 880 470 880 719 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.3715107 2022-10-21T23:48:23.371511+00:00 1 9 1285 725 880 470 880 719 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.3867025 2022-10-21T23:48:23.386703+00:00 1 9 1285 725 880 470 880 719 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.4028924 2022-10-21T23:48:23.402892+00:00 1 9 1285 725 880 470 880 719 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.4190416 2022-10-21T23:48:23.419042+00:00 1 9 1285 725 880 470 880 705 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.4352145 2022-10-21T23:48:23.435215+00:00 1 9 1285 725 880 470 880 694 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.4514055 2022-10-21T23:48:23.451406+00:00 1 9 1285 725 880 470 880 694 880 853 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.467606 2022-10-21T23:48:23.467606+00:00 1 9 1285 725 880 470 880 683 880 852 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.4838634 2022-10-21T23:48:23.483863+00:00 1 9 1285 725 880 470 880 671 880 852 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.5000534 2022-10-21T23:48:23.500053+00:00 1 9 1285 725 880 470 880 663 880 852 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.516178 2022-10-21T23:48:23.516178+00:00 1 9 1285 725 880 474 880 656 880 852 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.5323486 2022-10-21T23:48:23.532349+00:00 1 9 1285 725 880 474 880 652 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.5486016 2022-10-21T23:48:23.548602+00:00 1 9 1285 725 880 483 880 651 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.564855 2022-10-21T23:48:23.564855+00:00 1 9 1285 725 880 493 880 651 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.5810547 2022-10-21T23:48:23.581055+00:00 1 9 1285 725 880 505 880 651 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.5972853 2022-10-21T23:48:23.597285+00:00 1 9 1285 725 880 520 880 651 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.6134927 2022-10-21T23:48:23.613493+00:00 1 9 1285 725 880 532 880 651 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.628722 2022-10-21T23:48:23.628722+00:00 1 9 1285 725 880 538 880 654 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.644963 2022-10-21T23:48:23.644963+00:00 1 9 1285 725 880 540 880 660 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.661157 2022-10-21T23:48:23.661157+00:00 1 9 1285 725 880 540 880 666 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.67733 2022-10-21T23:48:23.677330+00:00 1 9 1285 725 880 540 880 673 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.693547 2022-10-21T23:48:23.693547+00:00 1 9 1285 725 880 540 880 680 880 851 1660 686 0 0
exp_2022_10_21_15 43 45 49 1666396103.708768 2022-10-21T23:48:23.708768+00:00 1 9 1285 725 880 540 880 680 880 851 1660 686 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]);