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 player_2_id = 110

View and edit SQL

Suggested facets: 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_06_13 105 110 lion tiger 1675719709.2881064 2023-02-06T21:41:49.288106+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.3035364 2023-02-06T21:41:49.303536+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.319721 2023-02-06T21:41:49.319721+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.335886 2023-02-06T21:41:49.335886+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.3520448 2023-02-06T21:41:49.352045+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.368189 2023-02-06T21:41:49.368189+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.3843527 2023-02-06T21:41:49.384353+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.3995461 2023-02-06T21:41:49.399546+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.4157083 2023-02-06T21:41:49.415708+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.4318745 2023-02-06T21:41:49.431875+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.4480472 2023-02-06T21:41:49.448047+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.464209 2023-02-06T21:41:49.464209+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.480372 2023-02-06T21:41:49.480372+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.4955473 2023-02-06T21:41:49.495547+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.5116966 2023-02-06T21:41:49.511697+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.5278451 2023-02-06T21:41:49.527845+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.5440202 2023-02-06T21:41:49.544020+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.5601583 2023-02-06T21:41:49.560158+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.576303 2023-02-06T21:41:49.576303+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.5914695 2023-02-06T21:41:49.591470+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.607611 2023-02-06T21:41:49.607611+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.6237545 2023-02-06T21:41:49.623755+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.6399193 2023-02-06T21:41:49.639919+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.6560588 2023-02-06T21:41:49.656059+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.6722038 2023-02-06T21:41:49.672204+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.6883712 2023-02-06T21:41:49.688371+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.7035055 2023-02-06T21:41:49.703506+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.719633 2023-02-06T21:41:49.719633+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.7357705 2023-02-06T21:41:49.735770+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.7519007 2023-02-06T21:41:49.751901+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.768029 2023-02-06T21:41:49.768029+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.7841697 2023-02-06T21:41:49.784170+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.8003178 2023-02-06T21:41:49.800318+00:00 1 10 1285 725 880 798 1660 779 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.8164628 2023-02-06T21:41:49.816463+00:00 1 10 1285 725 880 798 1660 820 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.8326142 2023-02-06T21:41:49.832614+00:00 1 10 1285 725 880 798 1660 821 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.8487458 2023-02-06T21:41:49.848746+00:00 1 10 1285 725 880 798 1660 821 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.86487 2023-02-06T21:41:49.864870+00:00 1 10 1285 725 880 798 1660 821 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.8809972 2023-02-06T21:41:49.880997+00:00 1 10 1285 725 880 798 1660 821 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.8971343 2023-02-06T21:41:49.897134+00:00 1 10 1285 725 880 798 1660 821 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.9132597 2023-02-06T21:41:49.913260+00:00 1 10 1285 725 880 798 1660 821 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.9293914 2023-02-06T21:41:49.929391+00:00 1 10 1285 725 880 798 1660 822 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.9445326 2023-02-06T21:41:49.944533+00:00 1 10 1285 725 880 798 1660 823 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.9607022 2023-02-06T21:41:49.960702+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.97685 2023-02-06T21:41:49.976850+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719709.9930189 2023-02-06T21:41:49.993019+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.0091913 2023-02-06T21:41:50.009191+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.0253425 2023-02-06T21:41:50.025342+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.0404708 2023-02-06T21:41:50.040471+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.0566099 2023-02-06T21:41:50.056610+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.0727577 2023-02-06T21:41:50.072758+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.0889258 2023-02-06T21:41:50.088926+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.1050842 2023-02-06T21:41:50.105084+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.121218 2023-02-06T21:41:50.121218+00:00 1 10 1285 725 880 798 1660 825 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.1373806 2023-02-06T21:41:50.137381+00:00 1 10 1285 725 880 798 1660 823 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.1525483 2023-02-06T21:41:50.152548+00:00 1 10 1285 725 880 798 1660 820 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.1687124 2023-02-06T21:41:50.168712+00:00 1 10 1285 725 880 797 1660 820 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.1848786 2023-02-06T21:41:50.184879+00:00 1 10 1285 725 880 797 1660 814 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.2010655 2023-02-06T21:41:50.201066+00:00 1 10 1285 725 880 797 1660 811 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.2172415 2023-02-06T21:41:50.217242+00:00 1 10 1285 725 880 797 1660 808 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.233443 2023-02-06T21:41:50.233443+00:00 1 10 1285 725 880 797 1660 805 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.2496796 2023-02-06T21:41:50.249680+00:00 1 10 1285 725 880 797 1660 804 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.2658346 2023-02-06T21:41:50.265835+00:00 1 10 1285 725 880 797 1660 803 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.2819655 2023-02-06T21:41:50.281965+00:00 1 10 1285 725 880 797 1660 802 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.2980828 2023-02-06T21:41:50.298083+00:00 1 10 1285 725 880 797 1660 799 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.314211 2023-02-06T21:41:50.314211+00:00 1 9 1285 725 880 797 1660 798 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.330375 2023-02-06T21:41:50.330375+00:00 1 9 1285 725 880 797 1660 795 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.34555 2023-02-06T21:41:50.345550+00:00 1 9 1285 725 880 797 1660 794 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.3617098 2023-02-06T21:41:50.361710+00:00 1 9 1285 725 880 797 1660 794 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.3778563 2023-02-06T21:41:50.377856+00:00 1 9 1285 725 880 797 1660 793 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.3940375 2023-02-06T21:41:50.394037+00:00 1 9 1285 725 880 797 1660 792 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.4102194 2023-02-06T21:41:50.410219+00:00 1 9 1285 725 880 797 1660 791 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.4264355 2023-02-06T21:41:50.426435+00:00 1 9 1285 725 880 797 1660 790 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.4416907 2023-02-06T21:41:50.441691+00:00 1 9 1285 725 880 797 1660 786 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.4579248 2023-02-06T21:41:50.457925+00:00 1 9 1285 725 880 791 1660 783 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.4741488 2023-02-06T21:41:50.474149+00:00 1 9 1285 725 880 787 1660 780 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.4904044 2023-02-06T21:41:50.490404+00:00 1 9 1285 725 880 784 1660 777 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.5056317 2023-02-06T21:41:50.505632+00:00 1 9 1285 725 880 778 1660 775 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.5218785 2023-02-06T21:41:50.521878+00:00 1 9 1285 725 880 778 1660 773 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.538122 2023-02-06T21:41:50.538122+00:00 1 9 1285 725 880 778 1660 770 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.5543272 2023-02-06T21:41:50.554327+00:00 1 9 1285 725 880 778 1660 770 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.5695145 2023-02-06T21:41:50.569515+00:00 1 9 1285 725 880 778 1660 769 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.585713 2023-02-06T21:41:50.585713+00:00 1 9 1285 725 880 778 1660 767 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.6019506 2023-02-06T21:41:50.601951+00:00 1 9 1285 725 880 778 1660 763 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.6181884 2023-02-06T21:41:50.618188+00:00 1 9 1285 725 880 778 1660 759 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.6344368 2023-02-06T21:41:50.634437+00:00 1 9 1285 725 880 778 1660 754 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.649669 2023-02-06T21:41:50.649669+00:00 1 9 1285 725 880 778 1660 749 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.6658742 2023-02-06T21:41:50.665874+00:00 1 9 1285 725 880 778 1660 743 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.6820831 2023-02-06T21:41:50.682083+00:00 1 9 1285 725 880 778 1660 738 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.6983252 2023-02-06T21:41:50.698325+00:00 1 9 1285 725 880 778 1660 732 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.7135794 2023-02-06T21:41:50.713579+00:00 1 9 1285 725 880 778 1660 732 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.7298067 2023-02-06T21:41:50.729807+00:00 1 9 1285 725 880 777 1660 731 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.7459702 2023-02-06T21:41:50.745970+00:00 1 9 1285 725 880 776 1660 730 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.762153 2023-02-06T21:41:50.762153+00:00 1 9 1285 725 880 773 1660 729 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.7783117 2023-02-06T21:41:50.778312+00:00 1 9 1285 725 880 773 1660 727 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.7944765 2023-02-06T21:41:50.794477+00:00 1 9 1285 725 880 772 1660 726 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.810647 2023-02-06T21:41:50.810647+00:00 1 9 1285 725 880 772 1660 723 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.8268256 2023-02-06T21:41:50.826826+00:00 1 9 1285 725 880 768 1660 719 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.8429842 2023-02-06T21:41:50.842984+00:00 1 9 1285 725 880 765 1660 716 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.8591478 2023-02-06T21:41:50.859148+00:00 1 9 1285 725 880 762 1660 711 0 0
exp_2023_02_06_13 105 110 lion tiger 1675719710.8753018 2023-02-06T21:41:50.875302+00:00 1 9 1285 725 880 762 1660 710 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]);