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 group_session = "exp_2023_01_30_13"

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_01_30_13 93 99905 99 1675115592.6475093 2023-01-30T21:53:12.647509+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_01_30_13 93 99905 99 1675115592.6634796 2023-01-30T21:53:12.663480+00:00 1 10 1285 725 880 880 880 604 880 784 1660 621 0 0
exp_2023_01_30_13 93 99905 99 1675115592.679698 2023-01-30T21:53:12.679698+00:00 1 10 1285 725 880 880 880 604 880 788 1660 633 0 0
exp_2023_01_30_13 93 99905 99 1675115592.6959107 2023-01-30T21:53:12.695911+00:00 1 10 1285 725 880 880 880 604 880 795 1660 633 0 0
exp_2023_01_30_13 93 99905 99 1675115592.7121503 2023-01-30T21:53:12.712150+00:00 1 10 1285 725 880 880 880 604 880 798 1660 645 0 0
exp_2023_01_30_13 93 99905 99 1675115592.7283316 2023-01-30T21:53:12.728332+00:00 1 10 1285 725 880 880 880 604 880 798 1660 657 0 0
exp_2023_01_30_13 93 99905 99 1675115592.7435195 2023-01-30T21:53:12.743520+00:00 1 10 1285 725 880 880 880 604 880 801 1660 669 0 0
exp_2023_01_30_13 93 99905 99 1675115592.7597013 2023-01-30T21:53:12.759701+00:00 1 10 1285 725 880 880 880 604 880 804 1660 678 0 0
exp_2023_01_30_13 93 99905 99 1675115592.7758844 2023-01-30T21:53:12.775884+00:00 1 10 1285 725 880 880 880 604 880 806 1660 682 0 0
exp_2023_01_30_13 93 99905 99 1675115592.792069 2023-01-30T21:53:12.792069+00:00 1 10 1285 725 880 880 880 604 880 809 1660 683 0 0
exp_2023_01_30_13 93 99905 99 1675115592.808259 2023-01-30T21:53:12.808259+00:00 1 10 1285 725 880 880 880 604 880 810 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.823495 2023-01-30T21:53:12.823495+00:00 1 10 1285 725 880 880 880 604 880 811 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.8396635 2023-01-30T21:53:12.839664+00:00 1 10 1285 725 880 880 880 604 880 811 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.8558495 2023-01-30T21:53:12.855850+00:00 1 10 1285 725 880 880 880 604 880 811 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.8720455 2023-01-30T21:53:12.872046+00:00 1 10 1285 725 880 880 880 604 880 811 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.888227 2023-01-30T21:53:12.888227+00:00 1 10 1285 725 880 880 880 604 880 811 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.9044187 2023-01-30T21:53:12.904419+00:00 1 10 1285 725 880 880 880 604 880 811 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.9206061 2023-01-30T21:53:12.920606+00:00 1 10 1285 725 880 880 880 604 880 811 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.936788 2023-01-30T21:53:12.936788+00:00 1 10 1285 725 880 880 880 604 880 811 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.952968 2023-01-30T21:53:12.952968+00:00 1 10 1285 725 880 880 880 604 880 811 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.969159 2023-01-30T21:53:12.969159+00:00 1 10 1285 725 880 880 880 604 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115592.9853432 2023-01-30T21:53:12.985343+00:00 1 10 1285 725 880 880 880 604 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.0005453 2023-01-30T21:53:13.000545+00:00 1 10 1285 725 880 880 880 604 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.0167167 2023-01-30T21:53:13.016717+00:00 1 10 1285 725 880 880 880 604 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.032904 2023-01-30T21:53:13.032904+00:00 1 10 1285 725 880 880 880 604 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.0490925 2023-01-30T21:53:13.049093+00:00 1 10 1285 725 880 880 880 604 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.065286 2023-01-30T21:53:13.065286+00:00 1 10 1285 725 880 880 880 604 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.0804663 2023-01-30T21:53:13.080466+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.09665 2023-01-30T21:53:13.096650+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.112833 2023-01-30T21:53:13.112833+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.129024 2023-01-30T21:53:13.129024+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.145216 2023-01-30T21:53:13.145216+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.1614113 2023-01-30T21:53:13.161411+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.1776345 2023-01-30T21:53:13.177634+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.1938245 2023-01-30T21:53:13.193825+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.2100146 2023-01-30T21:53:13.210015+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.2262087 2023-01-30T21:53:13.226209+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.2424145 2023-01-30T21:53:13.242414+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.2586215 2023-01-30T21:53:13.258621+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.2748098 2023-01-30T21:53:13.274810+00:00 1 10 1285 725 880 880 880 667 880 812 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.2909956 2023-01-30T21:53:13.290996+00:00 1 10 1285 725 880 880 880 668 880 813 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.3071911 2023-01-30T21:53:13.307191+00:00 1 10 1285 725 880 880 880 668 880 813 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.3233564 2023-01-30T21:53:13.323356+00:00 1 10 1285 725 880 880 880 670 880 813 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.338561 2023-01-30T21:53:13.338561+00:00 1 10 1285 725 880 880 880 671 880 813 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.3547077 2023-01-30T21:53:13.354708+00:00 1 10 1285 725 880 880 880 674 880 813 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.3708458 2023-01-30T21:53:13.370846+00:00 1 10 1285 725 880 880 880 676 880 809 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.3869922 2023-01-30T21:53:13.386992+00:00 1 10 1285 725 880 880 880 678 880 806 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.4031804 2023-01-30T21:53:13.403180+00:00 1 10 1285 725 880 880 880 681 880 806 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.4193816 2023-01-30T21:53:13.419382+00:00 1 10 1285 725 880 470 880 681 880 804 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.4345827 2023-01-30T21:53:13.434583+00:00 1 10 1285 725 880 470 880 687 880 804 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.4507792 2023-01-30T21:53:13.450779+00:00 1 10 1285 725 880 470 880 688 880 804 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.466973 2023-01-30T21:53:13.466973+00:00 1 10 1285 725 880 470 880 688 880 804 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.4831555 2023-01-30T21:53:13.483155+00:00 1 10 1285 725 880 470 880 688 880 804 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.499358 2023-01-30T21:53:13.499358+00:00 1 10 1285 725 880 470 880 688 880 804 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.514551 2023-01-30T21:53:13.514551+00:00 1 10 1285 725 880 470 880 688 880 803 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.5307405 2023-01-30T21:53:13.530740+00:00 1 10 1285 725 880 470 880 686 880 803 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.546924 2023-01-30T21:53:13.546924+00:00 1 10 1285 725 880 470 880 680 880 800 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.563119 2023-01-30T21:53:13.563119+00:00 1 10 1285 725 880 470 880 672 880 796 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.5792665 2023-01-30T21:53:13.579267+00:00 1 10 1285 725 880 470 880 666 880 789 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.595462 2023-01-30T21:53:13.595462+00:00 1 10 1285 725 880 470 880 659 880 780 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.6116652 2023-01-30T21:53:13.611665+00:00 1 10 1285 725 880 470 880 656 880 771 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.6278532 2023-01-30T21:53:13.627853+00:00 1 10 1285 725 880 470 880 656 880 764 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.644044 2023-01-30T21:53:13.644044+00:00 1 10 1285 725 880 470 880 653 880 760 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.660237 2023-01-30T21:53:13.660237+00:00 1 10 1285 725 880 470 880 652 880 759 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.6764212 2023-01-30T21:53:13.676421+00:00 1 9 1285 725 880 470 880 651 880 759 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.6916096 2023-01-30T21:53:13.691610+00:00 1 9 1285 725 880 470 880 648 880 759 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.7077963 2023-01-30T21:53:13.707796+00:00 1 9 1285 725 880 470 880 645 880 759 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.7239969 2023-01-30T21:53:13.723997+00:00 1 9 1285 725 880 480 880 641 880 759 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.7402468 2023-01-30T21:53:13.740247+00:00 1 9 1285 725 880 492 880 638 880 759 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.7564366 2023-01-30T21:53:13.756437+00:00 1 9 1285 725 880 545 880 638 880 762 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.7726164 2023-01-30T21:53:13.772616+00:00 1 9 1285 725 880 561 880 635 880 766 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.7887874 2023-01-30T21:53:13.788787+00:00 1 9 1285 725 880 577 880 633 880 774 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.804965 2023-01-30T21:53:13.804965+00:00 1 9 1285 725 880 577 880 633 880 780 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.8211503 2023-01-30T21:53:13.821150+00:00 1 9 1285 725 880 582 880 633 880 787 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.8373313 2023-01-30T21:53:13.837331+00:00 1 9 1285 725 880 586 880 633 880 793 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.8525124 2023-01-30T21:53:13.852512+00:00 1 9 1285 725 880 589 880 633 880 794 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.8686905 2023-01-30T21:53:13.868690+00:00 1 9 1285 725 880 592 880 633 880 794 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.8848696 2023-01-30T21:53:13.884870+00:00 1 9 1285 725 880 592 880 633 880 794 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.9010508 2023-01-30T21:53:13.901051+00:00 1 9 1285 725 880 592 880 633 880 794 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.9172323 2023-01-30T21:53:13.917232+00:00 1 9 1285 725 880 592 880 633 880 792 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.933418 2023-01-30T21:53:13.933418+00:00 1 9 1285 725 880 592 880 633 880 783 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.9486082 2023-01-30T21:53:13.948608+00:00 1 9 1285 725 880 592 880 633 880 774 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.964874 2023-01-30T21:53:13.964874+00:00 1 9 1285 725 880 592 880 634 880 770 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.9811587 2023-01-30T21:53:13.981159+00:00 1 9 1285 725 880 592 880 634 880 763 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115593.9974418 2023-01-30T21:53:13.997442+00:00 1 9 1285 725 880 591 880 634 880 756 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.0127158 2023-01-30T21:53:14.012716+00:00 1 9 1285 725 880 582 880 636 880 755 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.0289536 2023-01-30T21:53:14.028954+00:00 1 9 1285 725 880 582 880 637 880 755 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.0452037 2023-01-30T21:53:14.045204+00:00 1 9 1285 725 880 570 880 640 880 755 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.0614572 2023-01-30T21:53:14.061457+00:00 1 9 1285 725 880 560 880 644 880 755 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.0776865 2023-01-30T21:53:14.077687+00:00 1 9 1285 725 880 548 880 650 880 760 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.0939357 2023-01-30T21:53:14.093936+00:00 1 9 1285 725 880 541 880 650 880 772 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.1101925 2023-01-30T21:53:14.110193+00:00 1 9 1285 725 880 536 880 654 880 787 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.1264331 2023-01-30T21:53:14.126433+00:00 1 9 1285 725 880 533 880 658 880 801 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.141663 2023-01-30T21:53:14.141663+00:00 1 9 1285 725 880 533 880 662 880 813 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.157902 2023-01-30T21:53:14.157902+00:00 1 9 1285 725 880 533 880 665 880 820 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.1741395 2023-01-30T21:53:14.174139+00:00 1 9 1285 725 880 533 880 669 880 822 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.190366 2023-01-30T21:53:14.190366+00:00 1 9 1285 725 880 533 880 670 880 822 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.2056062 2023-01-30T21:53:14.205606+00:00 1 9 1285 725 880 533 880 675 880 820 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.2218547 2023-01-30T21:53:14.221855+00:00 1 9 1285 725 880 539 880 678 880 820 1660 684 0 0
exp_2023_01_30_13 93 99905 99 1675115594.238093 2023-01-30T21:53:14.238093+00:00 1 9 1285 725 880 549 880 678 880 804 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]);