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

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_10_10 74 75 82 1668106341.951711 2022-11-10T18:52:21.951711+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_11_10_10 74 75 82 1668106341.968369 2022-11-10T18:52:21.968369+00:00 1 10 1285 725 880 672 880 470 880 880 1660 633 0 0
exp_2022_11_10_10 74 75 82 1668106341.9835653 2022-11-10T18:52:21.983565+00:00 1 10 1285 725 880 672 880 470 880 880 1660 645 0 0
exp_2022_11_10_10 74 75 82 1668106341.999803 2022-11-10T18:52:21.999803+00:00 1 10 1285 725 880 672 880 470 880 880 1660 657 0 0
exp_2022_11_10_10 74 75 82 1668106342.0160255 2022-11-10T18:52:22.016026+00:00 1 10 1285 725 880 672 880 470 880 880 1660 657 0 0
exp_2022_11_10_10 74 75 82 1668106342.0322218 2022-11-10T18:52:22.032222+00:00 1 10 1285 725 880 672 880 470 880 880 1660 669 0 0
exp_2022_11_10_10 74 75 82 1668106342.0484147 2022-11-10T18:52:22.048415+00:00 1 10 1285 725 880 672 880 470 880 880 1660 678 0 0
exp_2022_11_10_10 74 75 82 1668106342.0636513 2022-11-10T18:52:22.063651+00:00 1 10 1285 725 880 672 880 470 880 880 1660 682 0 0
exp_2022_11_10_10 74 75 82 1668106342.0798366 2022-11-10T18:52:22.079837+00:00 1 10 1285 725 880 672 880 470 880 880 1660 683 0 0
exp_2022_11_10_10 74 75 82 1668106342.096005 2022-11-10T18:52:22.096005+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.1121714 2022-11-10T18:52:22.112171+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.128357 2022-11-10T18:52:22.128357+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.1435916 2022-11-10T18:52:22.143592+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.1598153 2022-11-10T18:52:22.159815+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.1760936 2022-11-10T18:52:22.176094+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.1923547 2022-11-10T18:52:22.192355+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.2075944 2022-11-10T18:52:22.207594+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.2238011 2022-11-10T18:52:22.223801+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.2399719 2022-11-10T18:52:22.239972+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.256134 2022-11-10T18:52:22.256134+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.272302 2022-11-10T18:52:22.272302+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.2874925 2022-11-10T18:52:22.287493+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.303696 2022-11-10T18:52:22.303696+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.319896 2022-11-10T18:52:22.319896+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.336075 2022-11-10T18:52:22.336075+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.3522432 2022-11-10T18:52:22.352243+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.3684194 2022-11-10T18:52:22.368419+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.3836343 2022-11-10T18:52:22.383634+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.399949 2022-11-10T18:52:22.399949+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.416192 2022-11-10T18:52:22.416192+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.4324362 2022-11-10T18:52:22.432436+00:00 1 10 1285 725 880 672 880 470 880 880 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.4487367 2022-11-10T18:52:22.448737+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.4650202 2022-11-10T18:52:22.465020+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.4812722 2022-11-10T18:52:22.481272+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.497509 2022-11-10T18:52:22.497509+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.5137749 2022-11-10T18:52:22.513775+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.5300434 2022-11-10T18:52:22.530043+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.5463023 2022-11-10T18:52:22.546302+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.5615437 2022-11-10T18:52:22.561544+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.5777264 2022-11-10T18:52:22.577726+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.593922 2022-11-10T18:52:22.593922+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.6101282 2022-11-10T18:52:22.610128+00:00 1 10 1285 725 880 672 880 470 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.6263394 2022-11-10T18:52:22.626339+00:00 1 10 1285 725 880 672 880 741 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.6415606 2022-11-10T18:52:22.641561+00:00 1 10 1285 725 880 672 880 742 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.6577733 2022-11-10T18:52:22.657773+00:00 1 10 1285 725 880 672 880 743 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.673964 2022-11-10T18:52:22.673964+00:00 1 10 1285 725 880 672 880 744 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.6901488 2022-11-10T18:52:22.690149+00:00 1 10 1285 725 880 672 880 744 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.7063468 2022-11-10T18:52:22.706347+00:00 1 10 1285 725 880 672 880 744 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.7215593 2022-11-10T18:52:22.721559+00:00 1 10 1285 725 880 672 880 744 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.7377994 2022-11-10T18:52:22.737799+00:00 1 10 1285 725 880 672 880 744 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.7540503 2022-11-10T18:52:22.754050+00:00 1 10 1285 725 880 672 880 744 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.770264 2022-11-10T18:52:22.770264+00:00 1 10 1285 725 880 620 880 744 880 470 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.7864666 2022-11-10T18:52:22.786467+00:00 1 10 1285 725 880 620 880 744 880 471 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.8027732 2022-11-10T18:52:22.802773+00:00 1 10 1285 725 880 625 880 744 880 474 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.8189785 2022-11-10T18:52:22.818979+00:00 1 10 1285 725 880 627 880 744 880 483 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.835183 2022-11-10T18:52:22.835183+00:00 1 10 1285 725 880 627 880 744 880 490 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.851376 2022-11-10T18:52:22.851376+00:00 1 10 1285 725 880 627 880 741 880 499 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.8665717 2022-11-10T18:52:22.866572+00:00 1 10 1285 725 880 627 880 732 880 510 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.882755 2022-11-10T18:52:22.882755+00:00 1 10 1285 725 880 627 880 719 880 520 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.8989544 2022-11-10T18:52:22.898954+00:00 1 10 1285 725 880 627 880 715 880 532 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.915178 2022-11-10T18:52:22.915178+00:00 1 10 1285 725 880 627 880 700 880 549 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.9313574 2022-11-10T18:52:22.931357+00:00 1 10 1285 725 880 627 880 700 880 549 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.9466505 2022-11-10T18:52:22.946651+00:00 1 10 1285 725 880 627 880 695 880 561 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.9628792 2022-11-10T18:52:22.962879+00:00 1 10 1285 725 880 627 880 692 880 571 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.979058 2022-11-10T18:52:22.979058+00:00 1 9 1285 725 880 627 880 692 880 582 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106342.9952815 2022-11-10T18:52:22.995281+00:00 1 9 1285 725 880 627 880 692 880 593 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.010574 2022-11-10T18:52:23.010574+00:00 1 9 1285 725 880 627 880 692 880 603 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.0268028 2022-11-10T18:52:23.026803+00:00 1 9 1285 725 880 627 880 695 880 617 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.043014 2022-11-10T18:52:23.043014+00:00 1 9 1285 725 880 631 880 702 880 628 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.0592108 2022-11-10T18:52:23.059211+00:00 1 9 1285 725 880 632 880 711 880 634 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.0753953 2022-11-10T18:52:23.075395+00:00 1 9 1285 725 880 633 880 732 880 638 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.0905864 2022-11-10T18:52:23.090586+00:00 1 9 1285 725 880 633 880 742 880 641 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.1067853 2022-11-10T18:52:23.106785+00:00 1 9 1285 725 880 634 880 742 880 641 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.1230352 2022-11-10T18:52:23.123035+00:00 1 9 1285 725 880 635 880 751 880 644 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.1392977 2022-11-10T18:52:23.139298+00:00 1 9 1285 725 880 635 880 758 880 645 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.1545546 2022-11-10T18:52:23.154555+00:00 1 9 1285 725 880 635 880 764 880 646 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.1707773 2022-11-10T18:52:23.170777+00:00 1 9 1285 725 880 636 880 770 880 647 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.1870227 2022-11-10T18:52:23.187023+00:00 1 9 1285 725 880 636 880 780 880 648 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.2032816 2022-11-10T18:52:23.203282+00:00 1 9 1285 725 880 636 880 782 880 649 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.2195256 2022-11-10T18:52:23.219526+00:00 1 9 1285 725 880 636 880 782 880 652 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.2357779 2022-11-10T18:52:23.235778+00:00 1 9 1285 725 880 636 880 783 880 653 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.2520213 2022-11-10T18:52:23.252021+00:00 1 9 1285 725 880 636 880 784 880 653 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.2682607 2022-11-10T18:52:23.268261+00:00 1 9 1285 725 880 637 880 784 880 653 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.2845044 2022-11-10T18:52:23.284504+00:00 1 9 1285 725 880 637 880 784 880 652 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.3008122 2022-11-10T18:52:23.300812+00:00 1 9 1285 725 880 637 880 784 880 649 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.317082 2022-11-10T18:52:23.317082+00:00 1 9 1285 725 880 637 880 784 880 643 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.3333437 2022-11-10T18:52:23.333344+00:00 1 9 1285 725 880 637 880 765 880 634 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.3485801 2022-11-10T18:52:23.348580+00:00 1 9 1285 725 880 637 880 749 880 624 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.364862 2022-11-10T18:52:23.364862+00:00 1 9 1285 725 880 637 880 749 880 612 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.3811405 2022-11-10T18:52:23.381140+00:00 1 9 1285 725 880 637 880 734 880 602 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.3974059 2022-11-10T18:52:23.397406+00:00 1 9 1285 725 880 631 880 712 880 591 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.4126601 2022-11-10T18:52:23.412660+00:00 1 9 1285 725 880 623 880 699 880 581 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.4289162 2022-11-10T18:52:23.428916+00:00 1 9 1285 725 880 616 880 692 880 573 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.4451656 2022-11-10T18:52:23.445166+00:00 1 9 1285 725 880 616 880 682 880 562 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.461414 2022-11-10T18:52:23.461414+00:00 1 9 1285 725 880 609 880 673 880 556 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.476594 2022-11-10T18:52:23.476594+00:00 1 9 1285 725 880 602 880 673 880 552 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.492764 2022-11-10T18:52:23.492764+00:00 1 9 1285 725 880 599 880 673 880 552 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.5089343 2022-11-10T18:52:23.508934+00:00 1 9 1285 725 880 595 880 673 880 551 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.5253696 2022-11-10T18:52:23.525370+00:00 1 9 1285 725 880 589 880 689 880 551 1660 684 0 0
exp_2022_11_10_10 74 75 82 1668106343.5406313 2022-11-10T18:52:23.540631+00:00 1 9 1285 725 880 582 880 705 880 551 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]);