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_3_id = 59

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_08_11 50 54 59 1667936951.9309492 2022-11-08T19:49:11.930949+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_11_08_11 50 54 59 1667936951.947638 2022-11-08T19:49:11.947638+00:00 1 10 1285 725 880 532 880 542 880 727 1660 633 0 0
exp_2022_11_08_11 50 54 59 1667936951.9627783 2022-11-08T19:49:11.962778+00:00 1 10 1285 725 880 532 880 543 880 727 1660 645 0 0
exp_2022_11_08_11 50 54 59 1667936951.97891 2022-11-08T19:49:11.978910+00:00 1 10 1285 725 880 532 880 543 880 727 1660 657 0 0
exp_2022_11_08_11 50 54 59 1667936951.9950397 2022-11-08T19:49:11.995040+00:00 1 10 1285 725 880 532 880 543 880 757 1660 669 0 0
exp_2022_11_08_11 50 54 59 1667936952.0111942 2022-11-08T19:49:12.011194+00:00 1 10 1285 725 880 532 880 543 880 757 1660 678 0 0
exp_2022_11_08_11 50 54 59 1667936952.0273447 2022-11-08T19:49:12.027345+00:00 1 10 1285 725 880 532 880 543 880 757 1660 682 0 0
exp_2022_11_08_11 50 54 59 1667936952.0434995 2022-11-08T19:49:12.043499+00:00 1 10 1285 725 880 532 880 543 880 757 1660 682 0 0
exp_2022_11_08_11 50 54 59 1667936952.0596764 2022-11-08T19:49:12.059676+00:00 1 10 1285 725 880 532 880 543 880 757 1660 683 0 0
exp_2022_11_08_11 50 54 59 1667936952.0758345 2022-11-08T19:49:12.075835+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.091998 2022-11-08T19:49:12.091998+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.108151 2022-11-08T19:49:12.108151+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.1243057 2022-11-08T19:49:12.124306+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.1404722 2022-11-08T19:49:12.140472+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.1566603 2022-11-08T19:49:12.156660+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.1718247 2022-11-08T19:49:12.171825+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.188023 2022-11-08T19:49:12.188023+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.2042053 2022-11-08T19:49:12.204205+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.2203686 2022-11-08T19:49:12.220369+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.2365243 2022-11-08T19:49:12.236524+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.2526944 2022-11-08T19:49:12.252694+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.2688477 2022-11-08T19:49:12.268848+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.2850065 2022-11-08T19:49:12.285007+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.3011959 2022-11-08T19:49:12.301196+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.3173633 2022-11-08T19:49:12.317363+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.3335552 2022-11-08T19:49:12.333555+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.3497245 2022-11-08T19:49:12.349725+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.3658717 2022-11-08T19:49:12.365872+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.3820415 2022-11-08T19:49:12.382041+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.3982265 2022-11-08T19:49:12.398226+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.4143913 2022-11-08T19:49:12.414391+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.4305544 2022-11-08T19:49:12.430554+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.4467318 2022-11-08T19:49:12.446732+00:00 1 10 1285 725 880 532 880 543 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.4628985 2022-11-08T19:49:12.462898+00:00 1 10 1285 725 880 532 880 544 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.479086 2022-11-08T19:49:12.479086+00:00 1 10 1285 725 880 532 880 551 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.4952602 2022-11-08T19:49:12.495260+00:00 1 10 1285 725 880 532 880 551 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.5114484 2022-11-08T19:49:12.511448+00:00 1 10 1285 725 880 532 880 557 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.5276437 2022-11-08T19:49:12.527644+00:00 1 10 1285 725 880 528 880 561 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.5428324 2022-11-08T19:49:12.542832+00:00 1 10 1285 725 880 522 880 565 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.5590026 2022-11-08T19:49:12.559003+00:00 1 10 1285 725 880 514 880 571 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.5751817 2022-11-08T19:49:12.575182+00:00 1 10 1285 725 880 496 880 577 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.5913548 2022-11-08T19:49:12.591355+00:00 1 10 1285 725 880 488 880 583 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.6075325 2022-11-08T19:49:12.607533+00:00 1 10 1285 725 880 488 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.6237159 2022-11-08T19:49:12.623716+00:00 1 10 1285 725 880 485 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.6398919 2022-11-08T19:49:12.639892+00:00 1 10 1285 725 880 485 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.6560988 2022-11-08T19:49:12.656099+00:00 1 10 1285 725 880 485 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.6722975 2022-11-08T19:49:12.672297+00:00 1 10 1285 725 880 485 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.6884985 2022-11-08T19:49:12.688498+00:00 1 10 1285 725 880 483 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.7046876 2022-11-08T19:49:12.704688+00:00 1 10 1285 725 880 483 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.7198799 2022-11-08T19:49:12.719880+00:00 1 10 1285 725 880 483 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.736065 2022-11-08T19:49:12.736065+00:00 1 10 1285 725 880 483 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.7522607 2022-11-08T19:49:12.752261+00:00 1 10 1285 725 880 483 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.768438 2022-11-08T19:49:12.768438+00:00 1 10 1285 725 880 483 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.7846107 2022-11-08T19:49:12.784611+00:00 1 10 1285 725 880 483 880 590 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.799788 2022-11-08T19:49:12.799788+00:00 1 10 1285 725 880 483 880 587 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.8159606 2022-11-08T19:49:12.815961+00:00 1 10 1285 725 880 483 880 583 880 757 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.8321388 2022-11-08T19:49:12.832139+00:00 1 10 1285 725 880 483 880 583 880 758 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.8483102 2022-11-08T19:49:12.848310+00:00 1 10 1285 725 880 491 880 579 880 758 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.86449 2022-11-08T19:49:12.864490+00:00 1 10 1285 725 880 499 880 575 880 758 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.8806775 2022-11-08T19:49:12.880677+00:00 1 10 1285 725 880 526 880 572 880 758 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.8958735 2022-11-08T19:49:12.895874+00:00 1 10 1285 725 880 538 880 570 880 759 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.9120588 2022-11-08T19:49:12.912059+00:00 1 10 1285 725 880 552 880 569 880 760 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.928241 2022-11-08T19:49:12.928241+00:00 1 10 1285 725 880 552 880 566 880 761 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.9444208 2022-11-08T19:49:12.944421+00:00 1 10 1285 725 880 563 880 563 880 764 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.960602 2022-11-08T19:49:12.960602+00:00 1 9 1285 725 880 575 880 559 880 768 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.9757857 2022-11-08T19:49:12.975786+00:00 1 9 1285 725 880 587 880 552 880 773 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936952.9919806 2022-11-08T19:49:12.991981+00:00 1 9 1285 725 880 589 880 549 880 777 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.008165 2022-11-08T19:49:13.008165+00:00 1 9 1285 725 880 597 880 549 880 780 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.0243878 2022-11-08T19:49:13.024388+00:00 1 9 1285 725 880 603 880 546 880 787 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.040572 2022-11-08T19:49:13.040572+00:00 1 9 1285 725 880 612 880 545 880 788 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.056766 2022-11-08T19:49:13.056766+00:00 1 9 1285 725 880 617 880 545 880 794 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.0729494 2022-11-08T19:49:13.072949+00:00 1 9 1285 725 880 620 880 545 880 794 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.089189 2022-11-08T19:49:13.089189+00:00 1 9 1285 725 880 620 880 546 880 795 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.1053748 2022-11-08T19:49:13.105375+00:00 1 9 1285 725 880 620 880 552 880 796 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.1215646 2022-11-08T19:49:13.121565+00:00 1 9 1285 725 880 635 880 573 880 797 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.1377215 2022-11-08T19:49:13.137722+00:00 1 9 1285 725 880 645 880 585 880 799 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.153906 2022-11-08T19:49:13.153906+00:00 1 9 1285 725 880 655 880 594 880 801 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.170112 2022-11-08T19:49:13.170112+00:00 1 9 1285 725 880 667 880 599 880 807 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.1863077 2022-11-08T19:49:13.186308+00:00 1 9 1285 725 880 674 880 600 880 809 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.2024975 2022-11-08T19:49:13.202497+00:00 1 9 1285 725 880 679 880 601 880 815 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.2186742 2022-11-08T19:49:13.218674+00:00 1 9 1285 725 880 704 880 602 880 822 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.2338622 2022-11-08T19:49:13.233862+00:00 1 9 1285 725 880 704 880 602 880 825 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.2500606 2022-11-08T19:49:13.250061+00:00 1 9 1285 725 880 714 880 605 880 825 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.266235 2022-11-08T19:49:13.266235+00:00 1 9 1285 725 880 719 880 607 880 829 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.2824242 2022-11-08T19:49:13.282424+00:00 1 9 1285 725 880 722 880 609 880 833 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.298612 2022-11-08T19:49:13.298612+00:00 1 9 1285 725 880 722 880 610 880 838 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.3147855 2022-11-08T19:49:13.314785+00:00 1 9 1285 725 880 722 880 611 880 844 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.3309727 2022-11-08T19:49:13.330973+00:00 1 9 1285 725 880 722 880 611 880 854 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.3471737 2022-11-08T19:49:13.347174+00:00 1 9 1285 725 880 722 880 611 880 858 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.3633559 2022-11-08T19:49:13.363356+00:00 1 9 1285 725 880 722 880 611 880 865 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.3795872 2022-11-08T19:49:13.379587+00:00 1 9 1285 725 880 722 880 606 880 869 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.3948705 2022-11-08T19:49:13.394871+00:00 1 9 1285 725 880 722 880 606 880 869 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.4110389 2022-11-08T19:49:13.411039+00:00 1 9 1285 725 880 722 880 601 880 872 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.4272344 2022-11-08T19:49:13.427234+00:00 1 9 1285 725 880 722 880 592 880 874 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.443421 2022-11-08T19:49:13.443421+00:00 1 9 1285 725 880 722 880 585 880 877 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.4595861 2022-11-08T19:49:13.459586+00:00 1 9 1285 725 880 722 880 579 880 879 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.475779 2022-11-08T19:49:13.475779+00:00 1 9 1285 725 880 722 880 572 880 880 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.4919827 2022-11-08T19:49:13.491983+00:00 1 9 1285 725 880 722 880 565 880 880 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.5081766 2022-11-08T19:49:13.508177+00:00 1 9 1285 725 880 722 880 556 880 878 1660 684 0 0
exp_2022_11_08_11 50 54 59 1667936953.5243773 2022-11-08T19:49:13.524377+00:00 1 9 1285 725 880 722 880 542 880 872 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]);