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_2022_10_07_15"

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_07_15 32 33 34 1665186493.3023682 2022-10-07T23:48:13.302368+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_10_07_15 32 33 34 1665186493.318065 2022-10-07T23:48:13.318065+00:00 1 10 1285 725 880 519 880 880 880 812 1660 621 0 0
exp_2022_10_07_15 32 33 34 1665186493.3343203 2022-10-07T23:48:13.334320+00:00 1 10 1285 725 880 519 880 880 880 812 1660 633 0 0
exp_2022_10_07_15 32 33 34 1665186493.350512 2022-10-07T23:48:13.350512+00:00 1 10 1285 725 880 519 880 880 880 812 1660 645 0 0
exp_2022_10_07_15 32 33 34 1665186493.366703 2022-10-07T23:48:13.366703+00:00 1 10 1285 725 880 519 880 880 880 812 1660 657 0 0
exp_2022_10_07_15 32 33 34 1665186493.3829029 2022-10-07T23:48:13.382903+00:00 1 10 1285 725 880 519 880 880 880 812 1660 669 0 0
exp_2022_10_07_15 32 33 34 1665186493.3991137 2022-10-07T23:48:13.399114+00:00 1 10 1285 725 880 519 880 880 880 812 1660 678 0 0
exp_2022_10_07_15 32 33 34 1665186493.4153101 2022-10-07T23:48:13.415310+00:00 1 10 1285 725 880 519 880 880 880 812 1660 678 0 0
exp_2022_10_07_15 32 33 34 1665186493.4314947 2022-10-07T23:48:13.431495+00:00 1 10 1285 725 880 519 880 880 880 812 1660 682 0 0
exp_2022_10_07_15 32 33 34 1665186493.447707 2022-10-07T23:48:13.447707+00:00 1 10 1285 725 880 519 880 880 880 812 1660 683 0 0
exp_2022_10_07_15 32 33 34 1665186493.4638913 2022-10-07T23:48:13.463891+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.480058 2022-10-07T23:48:13.480058+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.496254 2022-10-07T23:48:13.496254+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.512441 2022-10-07T23:48:13.512441+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.528622 2022-10-07T23:48:13.528622+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.5447943 2022-10-07T23:48:13.544794+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.5599797 2022-10-07T23:48:13.559980+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.5761702 2022-10-07T23:48:13.576170+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.5923564 2022-10-07T23:48:13.592356+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.6085377 2022-10-07T23:48:13.608538+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.624731 2022-10-07T23:48:13.624731+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.6399224 2022-10-07T23:48:13.639922+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.6561193 2022-10-07T23:48:13.656119+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.67237 2022-10-07T23:48:13.672370+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.6885586 2022-10-07T23:48:13.688559+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.704746 2022-10-07T23:48:13.704746+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.719932 2022-10-07T23:48:13.719932+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.7361221 2022-10-07T23:48:13.736122+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.7523053 2022-10-07T23:48:13.752305+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.7684798 2022-10-07T23:48:13.768480+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.7846632 2022-10-07T23:48:13.784663+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.8008468 2022-10-07T23:48:13.800847+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.8160365 2022-10-07T23:48:13.816036+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.832214 2022-10-07T23:48:13.832214+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.8483908 2022-10-07T23:48:13.848391+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.8645782 2022-10-07T23:48:13.864578+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.88079 2022-10-07T23:48:13.880790+00:00 1 10 1285 725 880 519 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.8959672 2022-10-07T23:48:13.895967+00:00 1 10 1285 725 880 507 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.9121892 2022-10-07T23:48:13.912189+00:00 1 10 1285 725 880 501 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.9283397 2022-10-07T23:48:13.928340+00:00 1 10 1285 725 880 493 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.9445088 2022-10-07T23:48:13.944509+00:00 1 10 1285 725 880 489 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.9606807 2022-10-07T23:48:13.960681+00:00 1 10 1285 725 880 485 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.9768646 2022-10-07T23:48:13.976865+00:00 1 10 1285 725 880 482 880 880 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186493.993043 2022-10-07T23:48:13.993043+00:00 1 10 1285 725 880 481 880 486 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.0092294 2022-10-07T23:48:14.009229+00:00 1 10 1285 725 880 480 880 485 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.0254047 2022-10-07T23:48:14.025405+00:00 1 10 1285 725 880 480 880 484 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.041617 2022-10-07T23:48:14.041617+00:00 1 10 1285 725 880 479 880 482 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.057799 2022-10-07T23:48:14.057799+00:00 1 10 1285 725 880 476 880 479 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.0729833 2022-10-07T23:48:14.072983+00:00 1 10 1285 725 880 475 880 479 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.0891473 2022-10-07T23:48:14.089147+00:00 1 10 1285 725 880 475 880 475 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.105338 2022-10-07T23:48:14.105338+00:00 1 10 1285 725 880 475 880 470 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.1215367 2022-10-07T23:48:14.121537+00:00 1 10 1285 725 880 475 880 470 880 812 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.1377218 2022-10-07T23:48:14.137722+00:00 1 10 1285 725 880 475 880 470 880 773 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.1539152 2022-10-07T23:48:14.153915+00:00 1 10 1285 725 880 475 880 470 880 772 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.1701078 2022-10-07T23:48:14.170108+00:00 1 10 1285 725 880 475 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.1863046 2022-10-07T23:48:14.186305+00:00 1 10 1285 725 880 475 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.2025578 2022-10-07T23:48:14.202558+00:00 1 10 1285 725 880 475 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.2187717 2022-10-07T23:48:14.218772+00:00 1 10 1285 725 880 475 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.23404 2022-10-07T23:48:14.234040+00:00 1 10 1285 725 880 475 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.2502587 2022-10-07T23:48:14.250259+00:00 1 10 1285 725 880 475 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.2664542 2022-10-07T23:48:14.266454+00:00 1 10 1285 725 880 475 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.282657 2022-10-07T23:48:14.282657+00:00 1 10 1285 725 880 475 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.298856 2022-10-07T23:48:14.298856+00:00 1 10 1285 725 880 475 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.3140538 2022-10-07T23:48:14.314054+00:00 1 10 1285 725 880 482 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.3302522 2022-10-07T23:48:14.330252+00:00 1 9 1285 725 880 491 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.346443 2022-10-07T23:48:14.346443+00:00 1 9 1285 725 880 503 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.3626397 2022-10-07T23:48:14.362640+00:00 1 9 1285 725 880 512 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.3788269 2022-10-07T23:48:14.378827+00:00 1 9 1285 725 880 512 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.394035 2022-10-07T23:48:14.394035+00:00 1 9 1285 725 880 516 880 470 880 771 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.4102204 2022-10-07T23:48:14.410220+00:00 1 9 1285 725 880 516 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.426409 2022-10-07T23:48:14.426409+00:00 1 9 1285 725 880 516 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.4425976 2022-10-07T23:48:14.442598+00:00 1 9 1285 725 880 516 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.4587831 2022-10-07T23:48:14.458783+00:00 1 9 1285 725 880 516 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.4739656 2022-10-07T23:48:14.473966+00:00 1 9 1285 725 880 516 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.49015 2022-10-07T23:48:14.490150+00:00 1 9 1285 725 880 516 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.506339 2022-10-07T23:48:14.506339+00:00 1 9 1285 725 880 519 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.5225263 2022-10-07T23:48:14.522526+00:00 1 9 1285 725 880 519 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.5387075 2022-10-07T23:48:14.538707+00:00 1 9 1285 725 880 519 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.5548916 2022-10-07T23:48:14.554892+00:00 1 9 1285 725 880 519 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.5710714 2022-10-07T23:48:14.571071+00:00 1 9 1285 725 880 519 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.5872607 2022-10-07T23:48:14.587261+00:00 1 9 1285 725 880 519 880 470 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.603464 2022-10-07T23:48:14.603464+00:00 1 9 1285 725 880 519 880 470 880 769 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.619649 2022-10-07T23:48:14.619649+00:00 1 9 1285 725 880 523 880 470 880 769 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.635844 2022-10-07T23:48:14.635844+00:00 1 9 1285 725 880 528 880 470 880 769 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.6510293 2022-10-07T23:48:14.651029+00:00 1 9 1285 725 880 535 880 473 880 769 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.6672113 2022-10-07T23:48:14.667211+00:00 1 9 1285 725 880 540 880 475 880 768 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.683404 2022-10-07T23:48:14.683404+00:00 1 9 1285 725 880 544 880 478 880 768 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.6995926 2022-10-07T23:48:14.699593+00:00 1 9 1285 725 880 550 880 482 880 768 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.7157798 2022-10-07T23:48:14.715780+00:00 1 9 1285 725 880 553 880 486 880 768 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.7309933 2022-10-07T23:48:14.730993+00:00 1 9 1285 725 880 561 880 496 880 768 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.7471614 2022-10-07T23:48:14.747161+00:00 1 9 1285 725 880 561 880 500 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.763359 2022-10-07T23:48:14.763359+00:00 1 9 1285 725 880 565 880 504 880 770 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.7795384 2022-10-07T23:48:14.779538+00:00 1 9 1285 725 880 565 880 504 880 774 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.7957075 2022-10-07T23:48:14.795707+00:00 1 9 1285 725 880 565 880 507 880 781 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.8118966 2022-10-07T23:48:14.811897+00:00 1 9 1285 725 880 565 880 511 880 788 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.8280842 2022-10-07T23:48:14.828084+00:00 1 9 1285 725 880 565 880 515 880 797 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.8442693 2022-10-07T23:48:14.844269+00:00 1 9 1285 725 880 568 880 519 880 806 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.8604543 2022-10-07T23:48:14.860454+00:00 1 9 1285 725 880 573 880 520 880 816 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.8766313 2022-10-07T23:48:14.876631+00:00 1 9 1285 725 880 577 880 526 880 827 1660 684 0 0
exp_2022_10_07_15 32 33 34 1665186494.8927999 2022-10-07T23:48:14.892800+00:00 1 9 1285 725 880 577 880 530 880 842 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]);