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

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_20_01 112 99905 118 1676929392.1659348 2023-02-20T21:43:12.165935+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_02_20_01 112 99905 118 1676929392.182657 2023-02-20T21:43:12.182657+00:00 1 10 1285 725 880 545 880 674 880 730 1660 633 0 0
exp_2023_02_20_01 112 99905 118 1676929392.1978443 2023-02-20T21:43:12.197844+00:00 1 10 1285 725 880 545 880 674 880 730 1660 645 0 0
exp_2023_02_20_01 112 99905 118 1676929392.214036 2023-02-20T21:43:12.214036+00:00 1 10 1285 725 880 545 880 674 880 730 1660 645 0 0
exp_2023_02_20_01 112 99905 118 1676929392.2302268 2023-02-20T21:43:12.230227+00:00 1 10 1285 725 880 545 880 674 880 730 1660 657 0 0
exp_2023_02_20_01 112 99905 118 1676929392.2464316 2023-02-20T21:43:12.246432+00:00 1 10 1285 725 880 545 880 674 880 730 1660 669 0 0
exp_2023_02_20_01 112 99905 118 1676929392.2626219 2023-02-20T21:43:12.262622+00:00 1 10 1285 725 880 545 880 674 880 730 1660 678 0 0
exp_2023_02_20_01 112 99905 118 1676929392.277809 2023-02-20T21:43:12.277809+00:00 1 10 1285 725 880 545 880 674 880 800 1660 682 0 0
exp_2023_02_20_01 112 99905 118 1676929392.2939932 2023-02-20T21:43:12.293993+00:00 1 10 1285 725 880 545 880 674 880 800 1660 683 0 0
exp_2023_02_20_01 112 99905 118 1676929392.3102098 2023-02-20T21:43:12.310210+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.32641 2023-02-20T21:43:12.326410+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.3425944 2023-02-20T21:43:12.342594+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.3577874 2023-02-20T21:43:12.357787+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.373985 2023-02-20T21:43:12.373985+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.3901706 2023-02-20T21:43:12.390171+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.4063642 2023-02-20T21:43:12.406364+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.4225771 2023-02-20T21:43:12.422577+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.4387732 2023-02-20T21:43:12.438773+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.454961 2023-02-20T21:43:12.454961+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.4711554 2023-02-20T21:43:12.471155+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.4873466 2023-02-20T21:43:12.487347+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.5035439 2023-02-20T21:43:12.503544+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.5197284 2023-02-20T21:43:12.519728+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.5359244 2023-02-20T21:43:12.535924+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.55213 2023-02-20T21:43:12.552130+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.5683312 2023-02-20T21:43:12.568331+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.5845423 2023-02-20T21:43:12.584542+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.600743 2023-02-20T21:43:12.600743+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.6169353 2023-02-20T21:43:12.616935+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.6331441 2023-02-20T21:43:12.633144+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.649334 2023-02-20T21:43:12.649334+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.665525 2023-02-20T21:43:12.665525+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.6817145 2023-02-20T21:43:12.681715+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.6969223 2023-02-20T21:43:12.696922+00:00 1 10 1285 725 880 545 880 674 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.7131088 2023-02-20T21:43:12.713109+00:00 1 10 1285 725 880 545 880 671 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.7293046 2023-02-20T21:43:12.729305+00:00 1 10 1285 725 880 545 880 665 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.7454967 2023-02-20T21:43:12.745497+00:00 1 10 1285 725 880 545 880 662 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.7616882 2023-02-20T21:43:12.761688+00:00 1 10 1285 725 880 545 880 656 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.7768846 2023-02-20T21:43:12.776885+00:00 1 10 1285 725 880 553 880 653 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.7930691 2023-02-20T21:43:12.793069+00:00 1 10 1285 725 880 553 880 652 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.809254 2023-02-20T21:43:12.809254+00:00 1 10 1285 725 880 553 880 650 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.8254457 2023-02-20T21:43:12.825446+00:00 1 10 1285 725 880 553 880 648 880 800 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.8416333 2023-02-20T21:43:12.841633+00:00 1 10 1285 725 880 553 880 645 880 802 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.856827 2023-02-20T21:43:12.856827+00:00 1 10 1285 725 880 553 880 645 880 802 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.8730366 2023-02-20T21:43:12.873037+00:00 1 10 1285 725 880 553 880 642 880 803 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.8892276 2023-02-20T21:43:12.889228+00:00 1 10 1285 725 880 554 880 641 880 803 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.905418 2023-02-20T21:43:12.905418+00:00 1 10 1285 725 880 554 880 638 880 803 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.9216318 2023-02-20T21:43:12.921632+00:00 1 10 1285 725 880 555 880 637 880 803 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.9368541 2023-02-20T21:43:12.936854+00:00 1 10 1285 725 880 558 880 634 880 805 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.9530802 2023-02-20T21:43:12.953080+00:00 1 10 1285 725 880 565 880 633 880 809 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.9692342 2023-02-20T21:43:12.969234+00:00 1 10 1285 725 880 568 880 631 880 815 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929392.9854283 2023-02-20T21:43:12.985428+00:00 1 10 1285 725 880 572 880 629 880 817 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.0016294 2023-02-20T21:43:13.001629+00:00 1 10 1285 725 880 576 880 629 880 821 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.0178087 2023-02-20T21:43:13.017809+00:00 1 10 1285 725 880 578 880 627 880 824 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.0340734 2023-02-20T21:43:13.034073+00:00 1 10 1285 725 880 582 880 627 880 826 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.0503235 2023-02-20T21:43:13.050323+00:00 1 10 1285 725 880 584 880 627 880 829 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.0665503 2023-02-20T21:43:13.066550+00:00 1 10 1285 725 880 584 880 627 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.0827365 2023-02-20T21:43:13.082736+00:00 1 10 1285 725 880 585 880 626 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.0979395 2023-02-20T21:43:13.097939+00:00 1 10 1285 725 880 584 880 625 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.114172 2023-02-20T21:43:13.114172+00:00 1 10 1285 725 880 575 880 621 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.1303785 2023-02-20T21:43:13.130378+00:00 1 10 1285 725 880 559 880 618 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.1465738 2023-02-20T21:43:13.146574+00:00 1 10 1285 725 880 544 880 616 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.161827 2023-02-20T21:43:13.161827+00:00 1 10 1285 725 880 526 880 616 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.1780798 2023-02-20T21:43:13.178080+00:00 1 10 1285 725 880 508 880 615 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.1943626 2023-02-20T21:43:13.194363+00:00 1 9 1285 725 880 493 880 615 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.2106287 2023-02-20T21:43:13.210629+00:00 1 9 1285 725 880 492 880 615 880 830 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.2258615 2023-02-20T21:43:13.225862+00:00 1 9 1285 725 880 492 880 615 880 827 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.242102 2023-02-20T21:43:13.242102+00:00 1 9 1285 725 880 492 880 615 880 823 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.2583177 2023-02-20T21:43:13.258318+00:00 1 9 1285 725 880 492 880 615 880 817 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.2745817 2023-02-20T21:43:13.274582+00:00 1 9 1285 725 880 494 880 616 880 812 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.2908306 2023-02-20T21:43:13.290831+00:00 1 9 1285 725 880 512 880 622 880 807 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.3070996 2023-02-20T21:43:13.307100+00:00 1 9 1285 725 880 512 880 622 880 803 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.323364 2023-02-20T21:43:13.323364+00:00 1 9 1285 725 880 533 880 632 880 799 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.3395813 2023-02-20T21:43:13.339581+00:00 1 9 1285 725 880 558 880 638 880 796 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.3558104 2023-02-20T21:43:13.355810+00:00 1 9 1285 725 880 574 880 643 880 792 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.372061 2023-02-20T21:43:13.372061+00:00 1 9 1285 725 880 584 880 646 880 788 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.3883426 2023-02-20T21:43:13.388343+00:00 1 9 1285 725 880 600 880 650 880 784 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.4046006 2023-02-20T21:43:13.404601+00:00 1 9 1285 725 880 612 880 653 880 778 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.4207964 2023-02-20T21:43:13.420796+00:00 1 9 1285 725 880 619 880 658 880 772 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.4369829 2023-02-20T21:43:13.436983+00:00 1 9 1285 725 880 619 880 661 880 766 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.453188 2023-02-20T21:43:13.453188+00:00 1 9 1285 725 880 619 880 666 880 759 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.469384 2023-02-20T21:43:13.469384+00:00 1 9 1285 725 880 600 880 666 880 752 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.4855752 2023-02-20T21:43:13.485575+00:00 1 9 1285 725 880 596 880 668 880 738 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.501763 2023-02-20T21:43:13.501763+00:00 1 9 1285 725 880 559 880 669 880 732 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.517956 2023-02-20T21:43:13.517956+00:00 1 9 1285 725 880 550 880 670 880 732 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.5341454 2023-02-20T21:43:13.534145+00:00 1 9 1285 725 880 529 880 671 880 725 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.5503342 2023-02-20T21:43:13.550334+00:00 1 9 1285 725 880 522 880 671 880 722 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.5665207 2023-02-20T21:43:13.566521+00:00 1 9 1285 725 880 512 880 672 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.582715 2023-02-20T21:43:13.582715+00:00 1 9 1285 725 880 512 880 674 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.5979056 2023-02-20T21:43:13.597906+00:00 1 9 1285 725 880 509 880 675 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.6141255 2023-02-20T21:43:13.614125+00:00 1 9 1285 725 880 508 880 675 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.6303167 2023-02-20T21:43:13.630317+00:00 1 9 1285 725 880 508 880 676 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.6465003 2023-02-20T21:43:13.646500+00:00 1 9 1285 725 880 508 880 676 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.6626918 2023-02-20T21:43:13.662692+00:00 1 9 1285 725 880 508 880 676 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.6778831 2023-02-20T21:43:13.677883+00:00 1 9 1285 725 880 508 880 676 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.6940646 2023-02-20T21:43:13.694065+00:00 1 9 1285 725 880 508 880 677 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.7102468 2023-02-20T21:43:13.710247+00:00 1 9 1285 725 880 508 880 677 880 721 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.726439 2023-02-20T21:43:13.726439+00:00 1 9 1285 725 880 508 880 678 880 728 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.742621 2023-02-20T21:43:13.742621+00:00 1 9 1285 725 880 508 880 678 880 734 1660 684 0 0
exp_2023_02_20_01 112 99905 118 1676929393.7588027 2023-02-20T21:43:13.758803+00:00 1 9 1285 725 880 508 880 678 880 737 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]);