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 = 99902

View and edit SQL

Suggested facets: group_session, team_score, ai_score

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_27_10 99902 68 66 1666896780.9907885 2022-10-27T18:53:00.990788+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_10_27_10 99902 68 66 1666896781.0074959 2022-10-27T18:53:01.007496+00:00 1 10 1285 725 880 470 880 706 880 470 1660 633 0 0
exp_2022_10_27_10 99902 68 66 1666896781.0226874 2022-10-27T18:53:01.022687+00:00 1 10 1285 725 880 470 880 706 880 470 1660 633 0 0
exp_2022_10_27_10 99902 68 66 1666896781.0388722 2022-10-27T18:53:01.038872+00:00 1 10 1285 725 880 470 880 706 880 470 1660 645 0 0
exp_2022_10_27_10 99902 68 66 1666896781.055059 2022-10-27T18:53:01.055059+00:00 1 10 1285 725 880 470 880 706 880 470 1660 657 0 0
exp_2022_10_27_10 99902 68 66 1666896781.0712805 2022-10-27T18:53:01.071280+00:00 1 10 1285 725 880 470 880 706 880 470 1660 669 0 0
exp_2022_10_27_10 99902 68 66 1666896781.0875854 2022-10-27T18:53:01.087585+00:00 1 10 1285 725 880 470 880 706 880 470 1660 678 0 0
exp_2022_10_27_10 99902 68 66 1666896781.1038837 2022-10-27T18:53:01.103884+00:00 1 10 1285 725 880 470 880 706 880 470 1660 682 0 0
exp_2022_10_27_10 99902 68 66 1666896781.120162 2022-10-27T18:53:01.120162+00:00 1 10 1285 725 880 470 880 706 880 470 1660 683 0 0
exp_2022_10_27_10 99902 68 66 1666896781.1364348 2022-10-27T18:53:01.136435+00:00 1 10 1285 725 880 470 880 706 880 470 1660 683 0 0
exp_2022_10_27_10 99902 68 66 1666896781.1516926 2022-10-27T18:53:01.151693+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.1678991 2022-10-27T18:53:01.167899+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.1840825 2022-10-27T18:53:01.184083+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.200275 2022-10-27T18:53:01.200275+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.2164733 2022-10-27T18:53:01.216473+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.231666 2022-10-27T18:53:01.231666+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.2478313 2022-10-27T18:53:01.247831+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.2640212 2022-10-27T18:53:01.264021+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.2802017 2022-10-27T18:53:01.280202+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.2964017 2022-10-27T18:53:01.296402+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.3117075 2022-10-27T18:53:01.311707+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.3279881 2022-10-27T18:53:01.327988+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.344232 2022-10-27T18:53:01.344232+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.3605058 2022-10-27T18:53:01.360506+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.3757658 2022-10-27T18:53:01.375766+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.3919723 2022-10-27T18:53:01.391972+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.4081674 2022-10-27T18:53:01.408167+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.4243464 2022-10-27T18:53:01.424346+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.4405282 2022-10-27T18:53:01.440528+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.4557202 2022-10-27T18:53:01.455720+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.4719281 2022-10-27T18:53:01.471928+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.4882264 2022-10-27T18:53:01.488226+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.5045192 2022-10-27T18:53:01.504519+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.5197885 2022-10-27T18:53:01.519789+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.5360408 2022-10-27T18:53:01.536041+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.5523126 2022-10-27T18:53:01.552313+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.5685833 2022-10-27T18:53:01.568583+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.584836 2022-10-27T18:53:01.584836+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.6010847 2022-10-27T18:53:01.601085+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.6172776 2022-10-27T18:53:01.617278+00:00 1 10 1285 725 880 470 880 706 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.6334608 2022-10-27T18:53:01.633461+00:00 1 10 1285 725 880 470 880 487 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.6486511 2022-10-27T18:53:01.648651+00:00 1 10 1285 725 880 470 880 487 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.664834 2022-10-27T18:53:01.664834+00:00 1 10 1285 725 880 470 880 488 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.6810188 2022-10-27T18:53:01.681019+00:00 1 10 1285 725 880 470 880 492 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.6972451 2022-10-27T18:53:01.697245+00:00 1 10 1285 725 880 470 880 497 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.7135334 2022-10-27T18:53:01.713533+00:00 1 10 1285 725 880 470 880 497 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.7288275 2022-10-27T18:53:01.728827+00:00 1 10 1285 725 880 470 880 498 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.7451322 2022-10-27T18:53:01.745132+00:00 1 10 1285 725 880 470 880 499 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.7614274 2022-10-27T18:53:01.761427+00:00 1 10 1285 725 880 470 880 499 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.7767045 2022-10-27T18:53:01.776705+00:00 1 10 1285 725 880 470 880 500 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.7929873 2022-10-27T18:53:01.792987+00:00 1 10 1285 725 880 470 880 501 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.8092155 2022-10-27T18:53:01.809216+00:00 1 10 1285 725 880 470 880 503 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.8254526 2022-10-27T18:53:01.825453+00:00 1 10 1285 725 880 470 880 504 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.8406336 2022-10-27T18:53:01.840634+00:00 1 10 1285 725 880 470 880 504 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.856762 2022-10-27T18:53:01.856762+00:00 1 10 1285 725 880 470 880 505 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.8728838 2022-10-27T18:53:01.872884+00:00 1 10 1285 725 880 470 880 505 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.8890355 2022-10-27T18:53:01.889035+00:00 1 10 1285 725 880 470 880 505 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.9052668 2022-10-27T18:53:01.905267+00:00 1 10 1285 725 880 470 880 507 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.9215121 2022-10-27T18:53:01.921512+00:00 1 10 1285 725 880 470 880 507 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.9367886 2022-10-27T18:53:01.936789+00:00 1 10 1285 725 880 470 880 507 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.9530635 2022-10-27T18:53:01.953063+00:00 1 10 1285 725 880 470 880 507 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.9693685 2022-10-27T18:53:01.969368+00:00 1 10 1285 725 880 470 880 507 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896781.9856439 2022-10-27T18:53:01.985644+00:00 1 10 1285 725 880 470 880 507 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.0018945 2022-10-27T18:53:02.001894+00:00 1 10 1285 725 880 470 880 507 880 470 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.01817 2022-10-27T18:53:02.018170+00:00 1 9 1285 725 880 470 880 507 880 472 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.0344248 2022-10-27T18:53:02.034425+00:00 1 9 1285 725 880 470 880 507 880 473 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.0506473 2022-10-27T18:53:02.050647+00:00 1 9 1285 725 880 626 880 507 880 473 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.0669067 2022-10-27T18:53:02.066907+00:00 1 9 1285 725 880 626 880 506 880 474 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.083093 2022-10-27T18:53:02.083093+00:00 1 9 1285 725 880 673 880 506 880 475 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.0993226 2022-10-27T18:53:02.099323+00:00 1 9 1285 725 880 705 880 506 880 476 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.115622 2022-10-27T18:53:02.115622+00:00 1 9 1285 725 880 721 880 506 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.1318634 2022-10-27T18:53:02.131863+00:00 1 9 1285 725 880 724 880 506 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.1480887 2022-10-27T18:53:02.148089+00:00 1 9 1285 725 880 744 880 506 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.1643603 2022-10-27T18:53:02.164360+00:00 1 9 1285 725 880 768 880 506 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.1806228 2022-10-27T18:53:02.180623+00:00 1 9 1285 725 880 795 880 506 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.1969004 2022-10-27T18:53:02.196900+00:00 1 9 1285 725 880 821 880 506 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.21319 2022-10-27T18:53:02.213190+00:00 1 9 1285 725 880 821 880 505 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.2294676 2022-10-27T18:53:02.229468+00:00 1 9 1285 725 880 821 880 500 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.2447443 2022-10-27T18:53:02.244744+00:00 1 9 1285 725 880 849 880 497 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.2610161 2022-10-27T18:53:02.261016+00:00 1 9 1285 725 880 869 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.2772322 2022-10-27T18:53:02.277232+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.2934318 2022-10-27T18:53:02.293432+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.3096304 2022-10-27T18:53:02.309630+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.3258772 2022-10-27T18:53:02.325877+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.342124 2022-10-27T18:53:02.342124+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.358382 2022-10-27T18:53:02.358382+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.3746152 2022-10-27T18:53:02.374615+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.39085 2022-10-27T18:53:02.390850+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.4070444 2022-10-27T18:53:02.407044+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.423262 2022-10-27T18:53:02.423262+00:00 1 9 1285 725 880 880 880 496 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.4395454 2022-10-27T18:53:02.439545+00:00 1 9 1285 725 880 880 880 500 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.4548106 2022-10-27T18:53:02.454811+00:00 1 9 1285 725 880 880 880 509 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.4710474 2022-10-27T18:53:02.471047+00:00 1 9 1285 725 880 880 880 520 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.487293 2022-10-27T18:53:02.487293+00:00 1 9 1285 725 880 879 880 530 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.5034935 2022-10-27T18:53:02.503494+00:00 1 9 1285 725 880 871 880 542 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.5187151 2022-10-27T18:53:02.518715+00:00 1 9 1285 725 880 870 880 555 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.5349517 2022-10-27T18:53:02.534952+00:00 1 9 1285 725 880 870 880 574 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.551192 2022-10-27T18:53:02.551192+00:00 1 9 1285 725 880 852 880 581 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.567463 2022-10-27T18:53:02.567463+00:00 1 9 1285 725 880 852 880 593 880 477 1660 684 0 0
exp_2022_10_27_10 99902 68 66 1666896782.5827131 2022-10-27T18:53:02.582713+00:00 1 9 1285 725 880 828 880 621 880 477 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]);