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

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_31_10 99907 64 69 1667242469.5351968 2022-10-31T18:54:29.535197+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_10_31_10 99907 64 69 1667242469.551092 2022-10-31T18:54:29.551092+00:00 1 10 1285 725 880 521 880 802 880 470 1660 633 0 0
exp_2022_10_31_10 99907 64 69 1667242469.5672853 2022-10-31T18:54:29.567285+00:00 1 10 1285 725 880 521 880 802 880 470 1660 645 0 0
exp_2022_10_31_10 99907 64 69 1667242469.582442 2022-10-31T18:54:29.582442+00:00 1 10 1285 725 880 521 880 802 880 470 1660 645 0 0
exp_2022_10_31_10 99907 64 69 1667242469.5986273 2022-10-31T18:54:29.598627+00:00 1 10 1285 725 880 521 880 802 880 470 1660 657 0 0
exp_2022_10_31_10 99907 64 69 1667242469.6148076 2022-10-31T18:54:29.614808+00:00 1 10 1285 725 880 521 880 802 880 470 1660 669 0 0
exp_2022_10_31_10 99907 64 69 1667242469.6309845 2022-10-31T18:54:29.630985+00:00 1 10 1285 725 880 521 880 802 880 470 1660 678 0 0
exp_2022_10_31_10 99907 64 69 1667242469.6471708 2022-10-31T18:54:29.647171+00:00 1 10 1285 725 880 521 880 802 880 470 1660 682 0 0
exp_2022_10_31_10 99907 64 69 1667242469.6633537 2022-10-31T18:54:29.663354+00:00 1 10 1285 725 880 521 880 802 880 470 1660 683 0 0
exp_2022_10_31_10 99907 64 69 1667242469.679533 2022-10-31T18:54:29.679533+00:00 1 10 1285 725 880 521 880 802 880 470 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.6957214 2022-10-31T18:54:29.695721+00:00 1 10 1285 725 880 521 880 802 880 470 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.7119026 2022-10-31T18:54:29.711903+00:00 1 10 1285 725 880 521 880 803 880 470 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.7280624 2022-10-31T18:54:29.728062+00:00 1 10 1285 725 880 521 880 807 880 470 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.7442563 2022-10-31T18:54:29.744256+00:00 1 10 1285 725 880 521 880 807 880 470 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.7594495 2022-10-31T18:54:29.759449+00:00 1 10 1285 725 880 521 880 807 880 470 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.7756536 2022-10-31T18:54:29.775654+00:00 1 10 1285 725 880 521 880 808 880 470 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.7918422 2022-10-31T18:54:29.791842+00:00 1 10 1285 725 880 521 880 808 880 470 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.8080304 2022-10-31T18:54:29.808030+00:00 1 10 1285 725 880 521 880 808 880 470 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.8241885 2022-10-31T18:54:29.824188+00:00 1 10 1285 725 880 521 880 808 880 473 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.840346 2022-10-31T18:54:29.840346+00:00 1 10 1285 725 880 521 880 808 880 479 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.8565218 2022-10-31T18:54:29.856522+00:00 1 10 1285 725 880 521 880 808 880 487 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.8726652 2022-10-31T18:54:29.872665+00:00 1 10 1285 725 880 521 880 808 880 492 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.8888152 2022-10-31T18:54:29.888815+00:00 1 10 1285 725 880 521 880 808 880 495 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.905 2022-10-31T18:54:29.905000+00:00 1 10 1285 725 880 521 880 808 880 496 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.9211934 2022-10-31T18:54:29.921193+00:00 1 10 1285 725 880 521 880 808 880 496 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.937334 2022-10-31T18:54:29.937334+00:00 1 10 1285 725 880 521 880 808 880 496 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.9525146 2022-10-31T18:54:29.952515+00:00 1 10 1285 725 880 521 880 804 880 496 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.9686835 2022-10-31T18:54:29.968683+00:00 1 10 1285 725 880 521 880 796 880 497 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242469.9848783 2022-10-31T18:54:29.984878+00:00 1 10 1285 725 880 521 880 786 880 498 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.0010662 2022-10-31T18:54:30.001066+00:00 1 10 1285 725 880 521 880 786 880 501 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.0172706 2022-10-31T18:54:30.017271+00:00 1 10 1285 725 880 521 880 771 880 503 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.03245 2022-10-31T18:54:30.032450+00:00 1 10 1285 725 880 521 880 754 880 507 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.0486424 2022-10-31T18:54:30.048642+00:00 1 10 1285 725 880 521 880 739 880 509 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.0648284 2022-10-31T18:54:30.064828+00:00 1 10 1285 725 880 521 880 721 880 510 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.0810122 2022-10-31T18:54:30.081012+00:00 1 10 1285 725 880 521 880 684 880 511 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.0972006 2022-10-31T18:54:30.097201+00:00 1 10 1285 725 880 521 880 659 880 514 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.1133795 2022-10-31T18:54:30.113379+00:00 1 10 1285 725 880 521 880 633 880 514 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.1295333 2022-10-31T18:54:30.129533+00:00 1 10 1285 725 880 521 880 633 880 516 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.1457074 2022-10-31T18:54:30.145707+00:00 1 10 1285 725 880 521 880 588 880 518 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.1618962 2022-10-31T18:54:30.161896+00:00 1 10 1285 725 880 521 880 551 880 519 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.178067 2022-10-31T18:54:30.178067+00:00 1 10 1285 725 880 521 880 514 880 520 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.194263 2022-10-31T18:54:30.194263+00:00 1 10 1285 725 880 521 880 476 880 521 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.209448 2022-10-31T18:54:30.209448+00:00 1 10 1285 725 880 521 880 470 880 522 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.2256002 2022-10-31T18:54:30.225600+00:00 1 10 1285 725 880 521 880 470 880 522 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.2417533 2022-10-31T18:54:30.241753+00:00 1 10 1285 725 880 521 880 470 880 522 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.2579358 2022-10-31T18:54:30.257936+00:00 1 10 1285 725 880 521 880 470 880 526 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.2741108 2022-10-31T18:54:30.274111+00:00 1 10 1285 725 880 521 880 470 880 526 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.2902975 2022-10-31T18:54:30.290298+00:00 1 10 1285 725 880 521 880 470 880 531 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.3054914 2022-10-31T18:54:30.305491+00:00 1 10 1285 725 880 521 880 470 880 537 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.321679 2022-10-31T18:54:30.321679+00:00 1 10 1285 725 880 521 880 470 880 544 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.3378658 2022-10-31T18:54:30.337866+00:00 1 10 1285 725 880 521 880 470 880 551 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.3540552 2022-10-31T18:54:30.354055+00:00 1 10 1285 725 880 521 880 470 880 558 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.3702185 2022-10-31T18:54:30.370219+00:00 1 10 1285 725 880 521 880 470 880 571 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.3864183 2022-10-31T18:54:30.386418+00:00 1 10 1285 725 880 521 880 470 880 577 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.4026558 2022-10-31T18:54:30.402656+00:00 1 10 1285 725 880 521 880 470 880 577 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.4188645 2022-10-31T18:54:30.418864+00:00 1 10 1285 725 880 521 880 470 880 584 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.4350846 2022-10-31T18:54:30.435085+00:00 1 10 1285 725 880 522 880 470 880 591 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.451241 2022-10-31T18:54:30.451241+00:00 1 10 1285 725 880 534 880 470 880 599 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.4664333 2022-10-31T18:54:30.466433+00:00 1 10 1285 725 880 548 880 470 880 607 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.482653 2022-10-31T18:54:30.482653+00:00 1 10 1285 725 880 564 880 470 880 616 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.49884 2022-10-31T18:54:30.498840+00:00 1 10 1285 725 880 587 880 470 880 625 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.5150201 2022-10-31T18:54:30.515020+00:00 1 10 1285 725 880 613 880 470 880 633 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.531183 2022-10-31T18:54:30.531183+00:00 1 10 1285 725 880 613 880 470 880 642 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.5473754 2022-10-31T18:54:30.547375+00:00 1 10 1285 725 880 629 880 470 880 648 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.5635629 2022-10-31T18:54:30.563563+00:00 1 9 1285 725 880 636 880 470 880 653 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.579713 2022-10-31T18:54:30.579713+00:00 1 9 1285 725 880 643 880 470 880 657 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.595914 2022-10-31T18:54:30.595914+00:00 1 9 1285 725 880 648 880 470 880 657 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.61217 2022-10-31T18:54:30.612170+00:00 1 9 1285 725 880 654 880 470 880 661 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.6283498 2022-10-31T18:54:30.628350+00:00 1 9 1285 725 880 663 880 470 880 667 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.6435387 2022-10-31T18:54:30.643539+00:00 1 9 1285 725 880 665 880 470 880 676 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.6597311 2022-10-31T18:54:30.659731+00:00 1 9 1285 725 880 665 880 470 880 689 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.6759126 2022-10-31T18:54:30.675913+00:00 1 9 1285 725 880 665 880 471 880 705 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.6920936 2022-10-31T18:54:30.692094+00:00 1 9 1285 725 880 665 880 471 880 723 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.708309 2022-10-31T18:54:30.708309+00:00 1 9 1285 725 880 665 880 475 880 741 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.723489 2022-10-31T18:54:30.723489+00:00 1 9 1285 725 880 665 880 482 880 756 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.7396827 2022-10-31T18:54:30.739683+00:00 1 9 1285 725 880 665 880 489 880 775 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.7558641 2022-10-31T18:54:30.755864+00:00 1 9 1285 725 880 665 880 496 880 787 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.7720478 2022-10-31T18:54:30.772048+00:00 1 9 1285 725 880 665 880 505 880 787 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.788237 2022-10-31T18:54:30.788237+00:00 1 9 1285 725 880 665 880 519 880 794 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.8044183 2022-10-31T18:54:30.804418+00:00 1 9 1285 725 880 665 880 529 880 799 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.8206036 2022-10-31T18:54:30.820604+00:00 1 9 1285 725 880 665 880 529 880 802 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.8367932 2022-10-31T18:54:30.836793+00:00 1 9 1285 725 880 665 880 540 880 804 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.8529367 2022-10-31T18:54:30.852937+00:00 1 9 1285 725 880 666 880 547 880 804 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.8690946 2022-10-31T18:54:30.869095+00:00 1 9 1285 725 880 667 880 553 880 804 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.8852937 2022-10-31T18:54:30.885294+00:00 1 9 1285 725 880 668 880 560 880 801 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.9004874 2022-10-31T18:54:30.900487+00:00 1 9 1285 725 880 674 880 567 880 789 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.9166594 2022-10-31T18:54:30.916659+00:00 1 9 1285 725 880 675 880 574 880 783 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.932832 2022-10-31T18:54:30.932832+00:00 1 9 1285 725 880 681 880 581 880 783 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.9490197 2022-10-31T18:54:30.949020+00:00 1 9 1285 725 880 696 880 590 880 776 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.9651916 2022-10-31T18:54:30.965192+00:00 1 9 1285 725 880 698 880 600 880 768 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.981419 2022-10-31T18:54:30.981419+00:00 1 9 1285 725 880 701 880 616 880 760 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242470.9976 2022-10-31T18:54:30.997600+00:00 1 9 1285 725 880 702 880 627 880 752 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242471.0137782 2022-10-31T18:54:31.013778+00:00 1 9 1285 725 880 702 880 641 880 736 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242471.0299575 2022-10-31T18:54:31.029958+00:00 1 9 1285 725 880 702 880 641 880 731 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242471.0461206 2022-10-31T18:54:31.046121+00:00 1 9 1285 725 880 702 880 651 880 725 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242471.062297 2022-10-31T18:54:31.062297+00:00 1 9 1285 725 880 702 880 660 880 725 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242471.077458 2022-10-31T18:54:31.077458+00:00 1 9 1285 725 880 702 880 668 880 720 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242471.0936239 2022-10-31T18:54:31.093624+00:00 1 9 1285 725 880 692 880 675 880 715 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242471.109819 2022-10-31T18:54:31.109819+00:00 1 9 1285 725 880 676 880 675 880 710 1660 684 0 0
exp_2022_10_31_10 99907 64 69 1667242471.1259935 2022-10-31T18:54:31.125993+00:00 1 9 1285 725 880 676 880 679 880 705 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]);