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_3_id = 119

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_2023_02_21_14 109 116 119 1677019136.9296377 2023-02-21T22:38:56.929638+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_02_21_14 109 116 119 1677019136.9455311 2023-02-21T22:38:56.945531+00:00 1 10 1285 725 880 603 880 630 880 780 1660 633 0 0
exp_2023_02_21_14 109 116 119 1677019136.961717 2023-02-21T22:38:56.961717+00:00 1 10 1285 725 880 603 880 630 880 780 1660 645 0 0
exp_2023_02_21_14 109 116 119 1677019136.9779143 2023-02-21T22:38:56.977914+00:00 1 10 1285 725 880 603 880 630 880 780 1660 657 0 0
exp_2023_02_21_14 109 116 119 1677019136.9941025 2023-02-21T22:38:56.994102+00:00 1 10 1285 725 880 603 880 630 880 780 1660 657 0 0
exp_2023_02_21_14 109 116 119 1677019137.0102682 2023-02-21T22:38:57.010268+00:00 1 10 1285 725 880 603 880 630 880 780 1660 669 0 0
exp_2023_02_21_14 109 116 119 1677019137.0254543 2023-02-21T22:38:57.025454+00:00 1 10 1285 725 880 603 880 630 880 780 1660 678 0 0
exp_2023_02_21_14 109 116 119 1677019137.041641 2023-02-21T22:38:57.041641+00:00 1 10 1285 725 880 603 880 630 880 780 1660 682 0 0
exp_2023_02_21_14 109 116 119 1677019137.057805 2023-02-21T22:38:57.057805+00:00 1 10 1285 725 880 603 880 630 880 780 1660 683 0 0
exp_2023_02_21_14 109 116 119 1677019137.0739908 2023-02-21T22:38:57.073991+00:00 1 10 1285 725 880 603 880 630 880 780 1660 683 0 0
exp_2023_02_21_14 109 116 119 1677019137.0901763 2023-02-21T22:38:57.090176+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.1063406 2023-02-21T22:38:57.106341+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.1225247 2023-02-21T22:38:57.122525+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.13871 2023-02-21T22:38:57.138710+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.154875 2023-02-21T22:38:57.154875+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.171058 2023-02-21T22:38:57.171058+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.187242 2023-02-21T22:38:57.187242+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.2024148 2023-02-21T22:38:57.202415+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.2186167 2023-02-21T22:38:57.218617+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.2348175 2023-02-21T22:38:57.234818+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.2510066 2023-02-21T22:38:57.251007+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.26721 2023-02-21T22:38:57.267210+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.2823832 2023-02-21T22:38:57.282383+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.2985656 2023-02-21T22:38:57.298566+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.3147557 2023-02-21T22:38:57.314756+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.3309748 2023-02-21T22:38:57.330975+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.3471682 2023-02-21T22:38:57.347168+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.363307 2023-02-21T22:38:57.363307+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.3784807 2023-02-21T22:38:57.378481+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.3946164 2023-02-21T22:38:57.394616+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.4107609 2023-02-21T22:38:57.410761+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.426953 2023-02-21T22:38:57.426953+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.4431436 2023-02-21T22:38:57.443144+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.459334 2023-02-21T22:38:57.459334+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.4755137 2023-02-21T22:38:57.475514+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.4917068 2023-02-21T22:38:57.491707+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.5079052 2023-02-21T22:38:57.507905+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.5240984 2023-02-21T22:38:57.524098+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.5403142 2023-02-21T22:38:57.540314+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.5555043 2023-02-21T22:38:57.555504+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.5716999 2023-02-21T22:38:57.571700+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.5878835 2023-02-21T22:38:57.587883+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.6040685 2023-02-21T22:38:57.604069+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.6202505 2023-02-21T22:38:57.620250+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.6354647 2023-02-21T22:38:57.635465+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.651653 2023-02-21T22:38:57.651653+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.667872 2023-02-21T22:38:57.667872+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.6840618 2023-02-21T22:38:57.684062+00:00 1 10 1285 725 880 603 880 630 880 780 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.7002556 2023-02-21T22:38:57.700256+00:00 1 10 1285 725 880 603 880 630 880 781 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.7154377 2023-02-21T22:38:57.715438+00:00 1 10 1285 725 880 603 880 630 880 781 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.7316191 2023-02-21T22:38:57.731619+00:00 1 10 1285 725 880 603 880 630 880 781 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.747802 2023-02-21T22:38:57.747802+00:00 1 10 1285 725 880 603 880 630 880 781 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.7639902 2023-02-21T22:38:57.763990+00:00 1 10 1285 725 880 603 880 630 880 781 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.7801728 2023-02-21T22:38:57.780173+00:00 1 10 1285 725 880 603 880 630 880 782 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.7963626 2023-02-21T22:38:57.796363+00:00 1 10 1285 725 880 603 880 630 880 782 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.8125744 2023-02-21T22:38:57.812574+00:00 1 10 1285 725 880 603 880 627 880 783 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.8287563 2023-02-21T22:38:57.828756+00:00 1 10 1285 725 880 603 880 623 880 784 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.8449419 2023-02-21T22:38:57.844942+00:00 1 10 1285 725 880 603 880 619 880 786 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.8611524 2023-02-21T22:38:57.861152+00:00 1 10 1285 725 880 603 880 615 880 787 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.8773475 2023-02-21T22:38:57.877347+00:00 1 10 1285 725 880 603 880 612 880 792 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.8935325 2023-02-21T22:38:57.893533+00:00 1 10 1285 725 880 603 880 609 880 795 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.9097278 2023-02-21T22:38:57.909728+00:00 1 10 1285 725 880 603 880 609 880 797 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.9259226 2023-02-21T22:38:57.925923+00:00 1 10 1285 725 880 603 880 609 880 800 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.9421391 2023-02-21T22:38:57.942139+00:00 1 10 1285 725 880 603 880 609 880 803 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.9583302 2023-02-21T22:38:57.958330+00:00 1 9 1285 725 880 603 880 609 880 805 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.9735196 2023-02-21T22:38:57.973520+00:00 1 9 1285 725 880 603 880 609 880 805 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019137.9897008 2023-02-21T22:38:57.989701+00:00 1 9 1285 725 880 603 880 609 880 807 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.0059109 2023-02-21T22:38:58.005911+00:00 1 9 1285 725 880 603 880 609 880 808 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.0221014 2023-02-21T22:38:58.022101+00:00 1 9 1285 725 880 603 880 609 880 808 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.0382874 2023-02-21T22:38:58.038287+00:00 1 9 1285 725 880 603 880 609 880 808 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.0534759 2023-02-21T22:38:58.053476+00:00 1 9 1285 725 880 603 880 612 880 808 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.0696585 2023-02-21T22:38:58.069659+00:00 1 9 1285 725 880 603 880 616 880 808 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.0858665 2023-02-21T22:38:58.085866+00:00 1 9 1285 725 880 603 880 622 880 808 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.1020672 2023-02-21T22:38:58.102067+00:00 1 9 1285 725 880 579 880 635 880 808 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.1182578 2023-02-21T22:38:58.118258+00:00 1 9 1285 725 880 578 880 639 880 806 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.1334584 2023-02-21T22:38:58.133458+00:00 1 9 1285 725 880 578 880 639 880 803 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.1496422 2023-02-21T22:38:58.149642+00:00 1 9 1285 725 880 576 880 642 880 793 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.165845 2023-02-21T22:38:58.165845+00:00 1 9 1285 725 880 566 880 642 880 787 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.182027 2023-02-21T22:38:58.182027+00:00 1 9 1285 725 880 560 880 642 880 787 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.1982088 2023-02-21T22:38:58.198209+00:00 1 9 1285 725 880 557 880 642 880 781 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.2143989 2023-02-21T22:38:58.214399+00:00 1 9 1285 725 880 557 880 642 880 775 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.2305832 2023-02-21T22:38:58.230583+00:00 1 9 1285 725 880 556 880 642 880 769 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.2467768 2023-02-21T22:38:58.246777+00:00 1 9 1285 725 880 556 880 641 880 764 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.262972 2023-02-21T22:38:58.262972+00:00 1 9 1285 725 880 556 880 637 880 761 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.27916 2023-02-21T22:38:58.279160+00:00 1 9 1285 725 880 556 880 637 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.2953572 2023-02-21T22:38:58.295357+00:00 1 9 1285 725 880 556 880 630 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.3105574 2023-02-21T22:38:58.310557+00:00 1 9 1285 725 880 556 880 621 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.326706 2023-02-21T22:38:58.326706+00:00 1 9 1285 725 880 562 880 612 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.342894 2023-02-21T22:38:58.342894+00:00 1 9 1285 725 880 572 880 605 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.359085 2023-02-21T22:38:58.359085+00:00 1 9 1285 725 880 580 880 598 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.375269 2023-02-21T22:38:58.375269+00:00 1 9 1285 725 880 590 880 589 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.3904543 2023-02-21T22:38:58.390454+00:00 1 9 1285 725 880 601 880 589 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.406652 2023-02-21T22:38:58.406652+00:00 1 9 1285 725 880 612 880 588 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.4228396 2023-02-21T22:38:58.422840+00:00 1 9 1285 725 880 616 880 588 880 759 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.4390364 2023-02-21T22:38:58.439036+00:00 1 9 1285 725 880 617 880 588 880 760 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.4551904 2023-02-21T22:38:58.455190+00:00 1 9 1285 725 880 617 880 588 880 760 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.4713728 2023-02-21T22:38:58.471373+00:00 1 9 1285 725 880 617 880 588 880 762 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.487552 2023-02-21T22:38:58.487552+00:00 1 9 1285 725 880 617 880 588 880 762 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.5037076 2023-02-21T22:38:58.503708+00:00 1 9 1285 725 880 617 880 592 880 763 1660 684 0 0
exp_2023_02_21_14 109 116 119 1677019138.5199022 2023-02-21T22:38:58.519902+00:00 1 9 1285 725 880 617 880 598 880 763 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]);