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

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_11_15_13 14 30 40 1668548333.4444542 2022-11-15T21:38:53.444454+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_11_15_13 14 30 40 1668548333.4610174 2022-11-15T21:38:53.461017+00:00 1 10 1285 725 880 615 880 572 880 783 1660 633 0 0
exp_2022_11_15_13 14 30 40 1668548333.4772243 2022-11-15T21:38:53.477224+00:00 1 10 1285 725 880 615 880 572 880 783 1660 633 0 0
exp_2022_11_15_13 14 30 40 1668548333.492511 2022-11-15T21:38:53.492511+00:00 1 10 1285 725 880 615 880 572 880 809 1660 645 0 0
exp_2022_11_15_13 14 30 40 1668548333.5087914 2022-11-15T21:38:53.508791+00:00 1 10 1285 725 880 615 880 572 880 835 1660 657 0 0
exp_2022_11_15_13 14 30 40 1668548333.5250847 2022-11-15T21:38:53.525085+00:00 1 10 1285 725 880 615 880 572 880 869 1660 669 0 0
exp_2022_11_15_13 14 30 40 1668548333.5413682 2022-11-15T21:38:53.541368+00:00 1 10 1285 725 880 615 880 572 880 876 1660 678 0 0
exp_2022_11_15_13 14 30 40 1668548333.556647 2022-11-15T21:38:53.556647+00:00 1 10 1285 725 880 615 880 572 880 880 1660 682 0 0
exp_2022_11_15_13 14 30 40 1668548333.5729454 2022-11-15T21:38:53.572945+00:00 1 10 1285 725 880 615 880 572 880 880 1660 683 0 0
exp_2022_11_15_13 14 30 40 1668548333.5892959 2022-11-15T21:38:53.589296+00:00 1 10 1285 725 880 615 880 572 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.604601 2022-11-15T21:38:53.604601+00:00 1 10 1285 725 880 615 880 572 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.6208515 2022-11-15T21:38:53.620852+00:00 1 10 1285 725 880 615 880 572 880 872 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.637151 2022-11-15T21:38:53.637151+00:00 1 10 1285 725 880 615 880 572 880 860 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.6534324 2022-11-15T21:38:53.653432+00:00 1 10 1285 725 880 615 880 572 880 848 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.668691 2022-11-15T21:38:53.668691+00:00 1 10 1285 725 880 615 880 572 880 838 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.6849751 2022-11-15T21:38:53.684975+00:00 1 10 1285 725 880 615 880 572 880 831 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.7012534 2022-11-15T21:38:53.701253+00:00 1 10 1285 725 880 615 880 572 880 828 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.7165246 2022-11-15T21:38:53.716525+00:00 1 10 1285 725 880 615 880 572 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.7328043 2022-11-15T21:38:53.732804+00:00 1 10 1285 725 880 615 880 572 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.7490625 2022-11-15T21:38:53.749063+00:00 1 10 1285 725 880 615 880 572 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.7653396 2022-11-15T21:38:53.765340+00:00 1 10 1285 725 880 615 880 572 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.7806077 2022-11-15T21:38:53.780608+00:00 1 10 1285 725 880 615 880 572 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.7968762 2022-11-15T21:38:53.796876+00:00 1 10 1285 725 880 615 880 572 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.81315 2022-11-15T21:38:53.813150+00:00 1 10 1285 725 880 615 880 572 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.8294275 2022-11-15T21:38:53.829427+00:00 1 10 1285 725 880 615 880 694 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.8446949 2022-11-15T21:38:53.844695+00:00 1 10 1285 725 880 615 880 694 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.8609731 2022-11-15T21:38:53.860973+00:00 1 10 1285 725 880 615 880 694 880 827 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.8772235 2022-11-15T21:38:53.877223+00:00 1 10 1285 725 880 615 880 694 880 828 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.893479 2022-11-15T21:38:53.893479+00:00 1 10 1285 725 880 615 880 694 880 828 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.909764 2022-11-15T21:38:53.909764+00:00 1 10 1285 725 880 615 880 694 880 828 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.9260461 2022-11-15T21:38:53.926046+00:00 1 10 1285 725 880 527 880 694 880 828 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.9423282 2022-11-15T21:38:53.942328+00:00 1 10 1285 725 880 537 880 694 880 829 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.957632 2022-11-15T21:38:53.957632+00:00 1 10 1285 725 880 549 880 697 880 830 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.9739132 2022-11-15T21:38:53.973913+00:00 1 10 1285 725 880 552 880 697 880 831 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548333.9901986 2022-11-15T21:38:53.990199+00:00 1 10 1285 725 880 553 880 706 880 831 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.0064738 2022-11-15T21:38:54.006474+00:00 1 10 1285 725 880 553 880 710 880 832 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.0227568 2022-11-15T21:38:54.022757+00:00 1 10 1285 725 880 553 880 714 880 832 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.0390337 2022-11-15T21:38:54.039034+00:00 1 10 1285 725 880 553 880 719 880 832 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.0553346 2022-11-15T21:38:54.055335+00:00 1 10 1285 725 880 553 880 724 880 832 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.070628 2022-11-15T21:38:54.070628+00:00 1 10 1285 725 880 553 880 729 880 832 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.086906 2022-11-15T21:38:54.086906+00:00 1 10 1285 725 880 553 880 733 880 832 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.1031826 2022-11-15T21:38:54.103183+00:00 1 10 1285 725 880 553 880 736 880 822 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.1194606 2022-11-15T21:38:54.119461+00:00 1 10 1285 725 880 553 880 737 880 813 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.1357517 2022-11-15T21:38:54.135752+00:00 1 10 1285 725 880 553 880 737 880 803 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.1519978 2022-11-15T21:38:54.151998+00:00 1 10 1285 725 880 553 880 737 880 803 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.168193 2022-11-15T21:38:54.168193+00:00 1 10 1285 725 880 553 880 737 880 794 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.184364 2022-11-15T21:38:54.184364+00:00 1 10 1285 725 880 553 880 737 880 787 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.1995423 2022-11-15T21:38:54.199542+00:00 1 10 1285 725 880 553 880 737 880 782 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.2157085 2022-11-15T21:38:54.215708+00:00 1 10 1285 725 880 553 880 737 880 782 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.2318945 2022-11-15T21:38:54.231894+00:00 1 10 1285 725 880 553 880 737 880 782 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.2480636 2022-11-15T21:38:54.248064+00:00 1 10 1285 725 880 553 880 736 880 782 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.264296 2022-11-15T21:38:54.264296+00:00 1 10 1285 725 880 553 880 734 880 788 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.2795372 2022-11-15T21:38:54.279537+00:00 1 10 1285 725 880 553 880 728 880 803 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.295768 2022-11-15T21:38:54.295768+00:00 1 10 1285 725 880 548 880 728 880 815 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.3119845 2022-11-15T21:38:54.311985+00:00 1 10 1285 725 880 541 880 705 880 829 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.3282123 2022-11-15T21:38:54.328212+00:00 1 10 1285 725 880 541 880 692 880 843 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.3444943 2022-11-15T21:38:54.344494+00:00 1 10 1285 725 880 540 880 680 880 843 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.3607817 2022-11-15T21:38:54.360782+00:00 1 10 1285 725 880 534 880 671 880 858 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.3770692 2022-11-15T21:38:54.377069+00:00 1 10 1285 725 880 531 880 665 880 870 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.3933434 2022-11-15T21:38:54.393343+00:00 1 10 1285 725 880 531 880 659 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.408636 2022-11-15T21:38:54.408636+00:00 1 10 1285 725 880 531 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.424935 2022-11-15T21:38:54.424935+00:00 1 10 1285 725 880 531 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.4412222 2022-11-15T21:38:54.441222+00:00 1 10 1285 725 880 531 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.4565525 2022-11-15T21:38:54.456553+00:00 1 10 1285 725 880 531 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.472835 2022-11-15T21:38:54.472835+00:00 1 9 1285 725 880 531 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.4891098 2022-11-15T21:38:54.489110+00:00 1 9 1285 725 880 531 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.505389 2022-11-15T21:38:54.505389+00:00 1 9 1285 725 880 529 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.5206904 2022-11-15T21:38:54.520690+00:00 1 9 1285 725 880 527 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.5369172 2022-11-15T21:38:54.536917+00:00 1 9 1285 725 880 524 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.5531528 2022-11-15T21:38:54.553153+00:00 1 9 1285 725 880 523 880 653 880 880 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.5693755 2022-11-15T21:38:54.569376+00:00 1 9 1285 725 880 523 880 653 880 878 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.5845892 2022-11-15T21:38:54.584589+00:00 1 9 1285 725 880 522 880 653 880 864 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.6008065 2022-11-15T21:38:54.600806+00:00 1 9 1285 725 880 517 880 653 880 846 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.617043 2022-11-15T21:38:54.617043+00:00 1 9 1285 725 880 511 880 653 880 800 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.6332912 2022-11-15T21:38:54.633291+00:00 1 9 1285 725 880 508 880 653 880 774 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.6495147 2022-11-15T21:38:54.649515+00:00 1 9 1285 725 880 508 880 653 880 750 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.6657398 2022-11-15T21:38:54.665740+00:00 1 9 1285 725 880 499 880 650 880 730 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.6819766 2022-11-15T21:38:54.681977+00:00 1 9 1285 725 880 499 880 648 880 715 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.698231 2022-11-15T21:38:54.698231+00:00 1 9 1285 725 880 499 880 648 880 715 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.7145236 2022-11-15T21:38:54.714524+00:00 1 9 1285 725 880 484 880 648 880 703 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.7307982 2022-11-15T21:38:54.730798+00:00 1 9 1285 725 880 479 880 649 880 694 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.7470767 2022-11-15T21:38:54.747077+00:00 1 9 1285 725 880 479 880 658 880 690 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.7633245 2022-11-15T21:38:54.763324+00:00 1 9 1285 725 880 479 880 679 880 689 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.7785463 2022-11-15T21:38:54.778546+00:00 1 9 1285 725 880 478 880 689 880 689 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.7947822 2022-11-15T21:38:54.794782+00:00 1 9 1285 725 880 478 880 698 880 689 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.8110068 2022-11-15T21:38:54.811007+00:00 1 9 1285 725 880 478 880 705 880 689 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.8272293 2022-11-15T21:38:54.827229+00:00 1 9 1285 725 880 478 880 705 880 689 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.8434253 2022-11-15T21:38:54.843425+00:00 1 9 1285 725 880 478 880 711 880 689 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.8586237 2022-11-15T21:38:54.858624+00:00 1 9 1285 725 880 478 880 714 880 690 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.8748114 2022-11-15T21:38:54.874811+00:00 1 9 1285 725 880 478 880 717 880 691 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.8910089 2022-11-15T21:38:54.891009+00:00 1 9 1285 725 880 478 880 718 880 691 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.9071965 2022-11-15T21:38:54.907197+00:00 1 9 1285 725 880 478 880 719 880 691 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.9233813 2022-11-15T21:38:54.923381+00:00 1 9 1285 725 880 478 880 720 880 691 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.9385545 2022-11-15T21:38:54.938555+00:00 1 9 1285 725 880 478 880 720 880 691 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.9547246 2022-11-15T21:38:54.954725+00:00 1 9 1285 725 880 484 880 721 880 691 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.9709008 2022-11-15T21:38:54.970901+00:00 1 9 1285 725 880 491 880 722 880 691 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548334.9870756 2022-11-15T21:38:54.987076+00:00 1 9 1285 725 880 491 880 722 880 687 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548335.0032582 2022-11-15T21:38:55.003258+00:00 1 9 1285 725 880 498 880 723 880 681 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548335.0194883 2022-11-15T21:38:55.019488+00:00 1 9 1285 725 880 499 880 723 880 660 1660 684 0 0
exp_2022_11_15_13 14 30 40 1668548335.0357141 2022-11-15T21:38:55.035714+00:00 1 9 1285 725 880 503 880 723 880 647 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]);