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

View and edit SQL

Suggested facets: player_1_id, player_2_id, 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_2022_10_07_15 32 33 lion tiger 1665186312.47877 2022-10-07T23:45:12.478770+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.4951558 2022-10-07T23:45:12.495156+00:00 1 10 1285 725 880 850 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.5114367 2022-10-07T23:45:12.511437+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.5266533 2022-10-07T23:45:12.526653+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.5428512 2022-10-07T23:45:12.542851+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.55909 2022-10-07T23:45:12.559090+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.5753512 2022-10-07T23:45:12.575351+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.5915995 2022-10-07T23:45:12.591599+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.6078196 2022-10-07T23:45:12.607820+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.6239717 2022-10-07T23:45:12.623972+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.6401417 2022-10-07T23:45:12.640142+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.656319 2022-10-07T23:45:12.656319+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.6725016 2022-10-07T23:45:12.672502+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.6876996 2022-10-07T23:45:12.687700+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.7039285 2022-10-07T23:45:12.703928+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.7201622 2022-10-07T23:45:12.720162+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.7364326 2022-10-07T23:45:12.736433+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.7516563 2022-10-07T23:45:12.751656+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.7679 2022-10-07T23:45:12.767900+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.7841756 2022-10-07T23:45:12.784176+00:00 1 10 1285 725 880 648 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.8004248 2022-10-07T23:45:12.800425+00:00 1 10 1285 725 880 654 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.8156376 2022-10-07T23:45:12.815638+00:00 1 10 1285 725 880 654 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.831839 2022-10-07T23:45:12.831839+00:00 1 10 1285 725 880 657 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.847983 2022-10-07T23:45:12.847983+00:00 1 10 1285 725 880 658 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.8641193 2022-10-07T23:45:12.864119+00:00 1 10 1285 725 880 658 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.880298 2022-10-07T23:45:12.880298+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.8965268 2022-10-07T23:45:12.896527+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.9117656 2022-10-07T23:45:12.911766+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.9279852 2022-10-07T23:45:12.927985+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.9442575 2022-10-07T23:45:12.944257+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.960529 2022-10-07T23:45:12.960529+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.9757955 2022-10-07T23:45:12.975796+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186312.9920723 2022-10-07T23:45:12.992072+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.0083385 2022-10-07T23:45:13.008338+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.024615 2022-10-07T23:45:13.024615+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.0408876 2022-10-07T23:45:13.040888+00:00 1 10 1285 725 880 659 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.0571635 2022-10-07T23:45:13.057163+00:00 1 10 1285 725 880 658 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.0734372 2022-10-07T23:45:13.073437+00:00 1 10 1285 725 880 656 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.0887012 2022-10-07T23:45:13.088701+00:00 1 10 1285 725 880 652 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.1049862 2022-10-07T23:45:13.104986+00:00 1 10 1285 725 880 649 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.121256 2022-10-07T23:45:13.121256+00:00 1 10 1285 725 880 645 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.1375544 2022-10-07T23:45:13.137554+00:00 1 10 1285 725 880 642 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.1528778 2022-10-07T23:45:13.152878+00:00 1 10 1285 725 880 641 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.1691349 2022-10-07T23:45:13.169135+00:00 1 10 1285 725 880 641 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.185427 2022-10-07T23:45:13.185427+00:00 1 10 1285 725 880 641 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.2007089 2022-10-07T23:45:13.200709+00:00 1 10 1285 725 880 641 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.2169988 2022-10-07T23:45:13.216999+00:00 1 10 1285 725 880 641 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.233313 2022-10-07T23:45:13.233313+00:00 1 10 1285 725 880 641 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.2495794 2022-10-07T23:45:13.249579+00:00 1 10 1285 725 880 640 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.2648516 2022-10-07T23:45:13.264852+00:00 1 10 1285 725 880 640 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.2811177 2022-10-07T23:45:13.281118+00:00 1 10 1285 725 880 640 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.2973983 2022-10-07T23:45:13.297398+00:00 1 10 1285 725 880 641 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.3136554 2022-10-07T23:45:13.313655+00:00 1 10 1285 725 880 641 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.329934 2022-10-07T23:45:13.329934+00:00 1 10 1285 725 880 654 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.346213 2022-10-07T23:45:13.346213+00:00 1 10 1285 725 880 663 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.3624907 2022-10-07T23:45:13.362491+00:00 1 10 1285 725 880 676 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.3777633 2022-10-07T23:45:13.377763+00:00 1 10 1285 725 880 691 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.3940384 2022-10-07T23:45:13.394038+00:00 1 10 1285 725 880 707 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.410247 2022-10-07T23:45:13.410247+00:00 1 10 1285 725 880 710 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.4264486 2022-10-07T23:45:13.426449+00:00 1 10 1285 725 880 717 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.4416833 2022-10-07T23:45:13.441683+00:00 1 10 1285 725 880 717 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.4578817 2022-10-07T23:45:13.457882+00:00 1 10 1285 725 880 722 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.474115 2022-10-07T23:45:13.474115+00:00 1 10 1285 725 880 726 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.4903727 2022-10-07T23:45:13.490373+00:00 1 10 1285 725 880 727 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.5066345 2022-10-07T23:45:13.506634+00:00 1 9 1285 725 880 730 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.522902 2022-10-07T23:45:13.522902+00:00 1 9 1285 725 880 744 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.5391629 2022-10-07T23:45:13.539163+00:00 1 9 1285 725 880 758 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.5553982 2022-10-07T23:45:13.555398+00:00 1 9 1285 725 880 773 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.5706754 2022-10-07T23:45:13.570675+00:00 1 9 1285 725 880 773 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.586927 2022-10-07T23:45:13.586927+00:00 1 9 1285 725 880 779 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.603071 2022-10-07T23:45:13.603071+00:00 1 9 1285 725 880 779 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.6192315 2022-10-07T23:45:13.619231+00:00 1 9 1285 725 880 779 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.635464 2022-10-07T23:45:13.635464+00:00 1 9 1285 725 880 779 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.6506894 2022-10-07T23:45:13.650689+00:00 1 9 1285 725 880 779 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.6669025 2022-10-07T23:45:13.666903+00:00 1 9 1285 725 880 776 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.6830714 2022-10-07T23:45:13.683071+00:00 1 9 1285 725 880 771 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.6992097 2022-10-07T23:45:13.699210+00:00 1 9 1285 725 880 756 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.7153587 2022-10-07T23:45:13.715359+00:00 1 9 1285 725 880 742 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.731512 2022-10-07T23:45:13.731512+00:00 1 9 1285 725 880 727 1660 730 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.7466795 2022-10-07T23:45:13.746680+00:00 1 9 1285 725 880 718 1660 533 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.7628763 2022-10-07T23:45:13.762876+00:00 1 9 1285 725 880 707 1660 533 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.7791104 2022-10-07T23:45:13.779110+00:00 1 9 1285 725 880 707 1660 533 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.7953362 2022-10-07T23:45:13.795336+00:00 1 9 1285 725 880 698 1660 533 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.8115392 2022-10-07T23:45:13.811539+00:00 1 9 1285 725 880 691 1660 533 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.8267014 2022-10-07T23:45:13.826701+00:00 1 9 1285 725 880 691 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.8428764 2022-10-07T23:45:13.842876+00:00 1 9 1285 725 880 688 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.859072 2022-10-07T23:45:13.859072+00:00 1 9 1285 725 880 686 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.8752546 2022-10-07T23:45:13.875255+00:00 1 9 1285 725 880 686 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.8914628 2022-10-07T23:45:13.891463+00:00 1 9 1285 725 880 686 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.9067066 2022-10-07T23:45:13.906707+00:00 1 9 1285 725 880 686 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.9229257 2022-10-07T23:45:13.922926+00:00 1 9 1285 725 880 686 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.939183 2022-10-07T23:45:13.939183+00:00 1 9 1285 725 880 686 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.9554121 2022-10-07T23:45:13.955412+00:00 1 9 1285 725 880 686 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.9716103 2022-10-07T23:45:13.971610+00:00 1 9 1285 725 880 686 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186313.9878292 2022-10-07T23:45:13.987829+00:00 1 9 1285 725 880 687 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186314.0040824 2022-10-07T23:45:14.004082+00:00 1 9 1285 725 880 687 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186314.0203218 2022-10-07T23:45:14.020322+00:00 1 9 1285 725 880 687 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186314.0365458 2022-10-07T23:45:14.036546+00:00 1 9 1285 725 880 687 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186314.0517592 2022-10-07T23:45:14.051759+00:00 1 9 1285 725 880 689 1660 534 0 0
exp_2022_10_07_15 32 33 lion tiger 1665186314.067945 2022-10-07T23:45:14.067945+00:00 1 9 1285 725 880 691 1660 534 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]);