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_1_station
Player 1's station.
player_2_station
Player 2's station.
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_1_score
Player 1's score.
player_2_score
Player 2's score.

where group_session = "exp_2023_02_03_10"

View and edit SQL

Suggested facets: player_1_station, player_2_station, player_1_score, player_2_score, timestamp_iso8601 (date)

Link group_session player_1_id player_2_id player_1_station player_2_station 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_1_score player_2_score
exp_2023_02_03_10 96 101 lion tiger 1675450203.5603557 2023-02-03T18:50:03.560356+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.5772243 2023-02-03T18:50:03.577224+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.5933878 2023-02-03T18:50:03.593388+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.6095448 2023-02-03T18:50:03.609545+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.6257029 2023-02-03T18:50:03.625703+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.64186 2023-02-03T18:50:03.641860+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.6580129 2023-02-03T18:50:03.658013+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.6741703 2023-02-03T18:50:03.674170+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.689331 2023-02-03T18:50:03.689331+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.7054935 2023-02-03T18:50:03.705493+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.7216668 2023-02-03T18:50:03.721667+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.737809 2023-02-03T18:50:03.737809+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.753979 2023-02-03T18:50:03.753979+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.7701411 2023-02-03T18:50:03.770141+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.7852995 2023-02-03T18:50:03.785300+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.8014734 2023-02-03T18:50:03.801473+00:00 1 10 1285 725 880 850 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.817648 2023-02-03T18:50:03.817648+00:00 1 10 1285 725 880 739 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.8338182 2023-02-03T18:50:03.833818+00:00 1 10 1285 725 880 738 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.8499463 2023-02-03T18:50:03.849946+00:00 1 10 1285 725 880 735 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.8660753 2023-02-03T18:50:03.866075+00:00 1 10 1285 725 880 734 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.8822572 2023-02-03T18:50:03.882257+00:00 1 10 1285 725 880 733 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.8984346 2023-02-03T18:50:03.898435+00:00 1 10 1285 725 880 723 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.914624 2023-02-03T18:50:03.914624+00:00 1 10 1285 725 880 719 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.9308589 2023-02-03T18:50:03.930859+00:00 1 10 1285 725 880 715 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.9470801 2023-02-03T18:50:03.947080+00:00 1 10 1285 725 880 709 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.9632785 2023-02-03T18:50:03.963279+00:00 1 10 1285 725 880 704 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.9794836 2023-02-03T18:50:03.979484+00:00 1 10 1285 725 880 701 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450203.9956894 2023-02-03T18:50:03.995689+00:00 1 10 1285 725 880 698 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.0118866 2023-02-03T18:50:04.011887+00:00 1 10 1285 725 880 697 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.028124 2023-02-03T18:50:04.028124+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.0433307 2023-02-03T18:50:04.043331+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.0595074 2023-02-03T18:50:04.059507+00:00 1 10 1285 725 880 695 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.0757086 2023-02-03T18:50:04.075709+00:00 1 10 1285 725 880 695 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.0918655 2023-02-03T18:50:04.091866+00:00 1 10 1285 725 880 695 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.1080387 2023-02-03T18:50:04.108039+00:00 1 10 1285 725 880 695 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.124193 2023-02-03T18:50:04.124193+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.1393497 2023-02-03T18:50:04.139350+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.155505 2023-02-03T18:50:04.155505+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.171661 2023-02-03T18:50:04.171661+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.1878116 2023-02-03T18:50:04.187812+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.2039778 2023-02-03T18:50:04.203978+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.2201529 2023-02-03T18:50:04.220153+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.2353196 2023-02-03T18:50:04.235320+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.2515063 2023-02-03T18:50:04.251506+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.267661 2023-02-03T18:50:04.267661+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.28382 2023-02-03T18:50:04.283820+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.2999897 2023-02-03T18:50:04.299990+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.3161635 2023-02-03T18:50:04.316164+00:00 1 10 1285 725 880 696 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.331321 2023-02-03T18:50:04.331321+00:00 1 10 1285 725 880 688 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.3474793 2023-02-03T18:50:04.347479+00:00 1 10 1285 725 880 688 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.3636553 2023-02-03T18:50:04.363655+00:00 1 10 1285 725 880 664 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.3798552 2023-02-03T18:50:04.379855+00:00 1 10 1285 725 880 652 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.3960266 2023-02-03T18:50:04.396027+00:00 1 10 1285 725 880 637 1660 470 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.4121928 2023-02-03T18:50:04.412193+00:00 1 10 1285 725 880 615 1660 474 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.4273157 2023-02-03T18:50:04.427316+00:00 1 10 1285 725 880 604 1660 481 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.4435008 2023-02-03T18:50:04.443501+00:00 1 10 1285 725 880 597 1660 484 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.459661 2023-02-03T18:50:04.459661+00:00 1 10 1285 725 880 582 1660 490 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.4758606 2023-02-03T18:50:04.475861+00:00 1 10 1285 725 880 579 1660 497 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.492014 2023-02-03T18:50:04.492014+00:00 1 10 1285 725 880 579 1660 497 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.5082183 2023-02-03T18:50:04.508218+00:00 1 10 1285 725 880 576 1660 497 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.523388 2023-02-03T18:50:04.523388+00:00 1 10 1285 725 880 574 1660 497 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.5395563 2023-02-03T18:50:04.539556+00:00 1 10 1285 725 880 574 1660 497 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.555733 2023-02-03T18:50:04.555733+00:00 1 10 1285 725 880 574 1660 497 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.5718997 2023-02-03T18:50:04.571900+00:00 1 10 1285 725 880 574 1660 497 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.5880654 2023-02-03T18:50:04.588065+00:00 1 9 1285 725 880 574 1660 497 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.6042364 2023-02-03T18:50:04.604236+00:00 1 9 1285 725 880 574 1660 492 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.6194062 2023-02-03T18:50:04.619406+00:00 1 9 1285 725 880 574 1660 492 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.635583 2023-02-03T18:50:04.635583+00:00 1 9 1285 725 880 574 1660 489 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.6517606 2023-02-03T18:50:04.651761+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.6679294 2023-02-03T18:50:04.667929+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.6841073 2023-02-03T18:50:04.684107+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.7002892 2023-02-03T18:50:04.700289+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.7164826 2023-02-03T18:50:04.716483+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.7326322 2023-02-03T18:50:04.732632+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.748878 2023-02-03T18:50:04.748878+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.765099 2023-02-03T18:50:04.765099+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.781266 2023-02-03T18:50:04.781266+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.797434 2023-02-03T18:50:04.797434+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.8136532 2023-02-03T18:50:04.813653+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.829821 2023-02-03T18:50:04.829821+00:00 1 9 1285 725 880 574 1660 488 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.8459857 2023-02-03T18:50:04.845986+00:00 1 9 1285 725 880 574 1660 487 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.862156 2023-02-03T18:50:04.862156+00:00 1 9 1285 725 880 574 1660 486 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.8773282 2023-02-03T18:50:04.877328+00:00 1 9 1285 725 880 574 1660 485 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.8934891 2023-02-03T18:50:04.893489+00:00 1 9 1285 725 880 574 1660 485 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.9096553 2023-02-03T18:50:04.909655+00:00 1 9 1285 725 880 574 1660 484 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.9258192 2023-02-03T18:50:04.925819+00:00 1 9 1285 725 880 574 1660 484 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.9419794 2023-02-03T18:50:04.941979+00:00 1 9 1285 725 880 583 1660 483 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.9581382 2023-02-03T18:50:04.958138+00:00 1 9 1285 725 880 597 1660 480 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.9742756 2023-02-03T18:50:04.974276+00:00 1 9 1285 725 880 601 1660 479 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450204.990432 2023-02-03T18:50:04.990432+00:00 1 9 1285 725 880 614 1660 479 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.0066059 2023-02-03T18:50:05.006606+00:00 1 9 1285 725 880 627 1660 479 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.022779 2023-02-03T18:50:05.022779+00:00 1 9 1285 725 880 648 1660 479 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.0389187 2023-02-03T18:50:05.038919+00:00 1 9 1285 725 880 663 1660 485 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.055083 2023-02-03T18:50:05.055083+00:00 1 9 1285 725 880 663 1660 485 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.0712285 2023-02-03T18:50:05.071229+00:00 1 9 1285 725 880 671 1660 493 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.0863929 2023-02-03T18:50:05.086393+00:00 1 9 1285 725 880 676 1660 501 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.1025708 2023-02-03T18:50:05.102571+00:00 1 9 1285 725 880 676 1660 508 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.1187618 2023-02-03T18:50:05.118762+00:00 1 9 1285 725 880 676 1660 515 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.13497 2023-02-03T18:50:05.134970+00:00 1 9 1285 725 880 676 1660 519 0 0
exp_2023_02_03_10 96 101 lion tiger 1675450205.151198 2023-02-03T18:50:05.151198+00:00 1 9 1285 725 880 676 1660 523 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "ping_pong_competitive_task_observation" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [player_1_id] INTEGER REFERENCES [participant]([id]),
   [player_2_id] INTEGER REFERENCES [participant]([id]),
   [player_1_station] TEXT REFERENCES [station]([id]),
   [player_2_station] TEXT REFERENCES [station]([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_1_score] INTEGER,
   [player_2_score] INTEGER,
   PRIMARY KEY ([group_session], [player_1_id], [player_2_id], [player_1_station], [player_2_station], [timestamp_unix])
);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_2_station]
    ON [ping_pong_competitive_task_observation] ([player_2_station]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_1_station]
    ON [ping_pong_competitive_task_observation] ([player_1_station]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_2_id]
    ON [ping_pong_competitive_task_observation] ([player_2_id]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_1_id]
    ON [ping_pong_competitive_task_observation] ([player_1_id]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_group_session]
    ON [ping_pong_competitive_task_observation] ([group_session]);