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

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_2022_10_14_10 39 41 lion tiger 1665773461.616336 2022-10-14T18:51:01.616336+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.6320686 2022-10-14T18:51:01.632069+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.648244 2022-10-14T18:51:01.648244+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.6644068 2022-10-14T18:51:01.664407+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.680564 2022-10-14T18:51:01.680564+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.6957133 2022-10-14T18:51:01.695713+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.7118757 2022-10-14T18:51:01.711876+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.7280507 2022-10-14T18:51:01.728051+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.7442083 2022-10-14T18:51:01.744208+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.7603679 2022-10-14T18:51:01.760368+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.7765276 2022-10-14T18:51:01.776528+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.7916834 2022-10-14T18:51:01.791683+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.807845 2022-10-14T18:51:01.807845+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.8240144 2022-10-14T18:51:01.824014+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.8401814 2022-10-14T18:51:01.840181+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.8563387 2022-10-14T18:51:01.856339+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.8725054 2022-10-14T18:51:01.872505+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.8876684 2022-10-14T18:51:01.887668+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.9038315 2022-10-14T18:51:01.903831+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.9200034 2022-10-14T18:51:01.920003+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.9361644 2022-10-14T18:51:01.936164+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.9522974 2022-10-14T18:51:01.952297+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.9684303 2022-10-14T18:51:01.968430+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.9845967 2022-10-14T18:51:01.984597+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773461.9997468 2022-10-14T18:51:01.999747+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.0159068 2022-10-14T18:51:02.015907+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.0320709 2022-10-14T18:51:02.032071+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.0482223 2022-10-14T18:51:02.048222+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.0643532 2022-10-14T18:51:02.064353+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.0805175 2022-10-14T18:51:02.080518+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.0956795 2022-10-14T18:51:02.095680+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.111837 2022-10-14T18:51:02.111837+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.12801 2022-10-14T18:51:02.128010+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.144173 2022-10-14T18:51:02.144173+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.1603315 2022-10-14T18:51:02.160331+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.176499 2022-10-14T18:51:02.176499+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.1926575 2022-10-14T18:51:02.192657+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.2088153 2022-10-14T18:51:02.208815+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.2249708 2022-10-14T18:51:02.224971+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.2411342 2022-10-14T18:51:02.241134+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.2572892 2022-10-14T18:51:02.257289+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.2734559 2022-10-14T18:51:02.273456+00:00 1 10 1285 725 880 850 1660 770 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.2896204 2022-10-14T18:51:02.289620+00:00 1 10 1285 725 880 850 1660 770 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.3057787 2022-10-14T18:51:02.305779+00:00 1 10 1285 725 880 850 1660 770 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.3219426 2022-10-14T18:51:02.321943+00:00 1 10 1285 725 880 850 1660 770 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.3381038 2022-10-14T18:51:02.338104+00:00 1 10 1285 725 880 850 1660 770 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.3542688 2022-10-14T18:51:02.354269+00:00 1 10 1285 725 880 850 1660 771 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.3704374 2022-10-14T18:51:02.370437+00:00 1 10 1285 725 880 850 1660 772 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.3865933 2022-10-14T18:51:02.386593+00:00 1 10 1285 725 880 850 1660 773 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.4017336 2022-10-14T18:51:02.401734+00:00 1 10 1285 725 880 850 1660 776 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.417909 2022-10-14T18:51:02.417909+00:00 1 10 1285 725 880 850 1660 777 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.4340444 2022-10-14T18:51:02.434044+00:00 1 10 1285 725 880 850 1660 778 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.450227 2022-10-14T18:51:02.450227+00:00 1 10 1285 725 880 850 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.4663146 2022-10-14T18:51:02.466315+00:00 1 10 1285 725 880 470 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.4824288 2022-10-14T18:51:02.482429+00:00 1 10 1285 725 880 470 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.4985538 2022-10-14T18:51:02.498554+00:00 1 10 1285 725 880 470 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.5136926 2022-10-14T18:51:02.513693+00:00 1 10 1285 725 880 470 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.5298789 2022-10-14T18:51:02.529879+00:00 1 10 1285 725 880 470 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.5460498 2022-10-14T18:51:02.546050+00:00 1 10 1285 725 880 481 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.5622 2022-10-14T18:51:02.562200+00:00 1 10 1285 725 880 489 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.5783687 2022-10-14T18:51:02.578369+00:00 1 10 1285 725 880 489 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.5945342 2022-10-14T18:51:02.594534+00:00 1 10 1285 725 880 494 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.609698 2022-10-14T18:51:02.609698+00:00 1 10 1285 725 880 507 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.6258724 2022-10-14T18:51:02.625872+00:00 1 10 1285 725 880 519 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.6420574 2022-10-14T18:51:02.642057+00:00 1 9 1285 725 880 524 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.658224 2022-10-14T18:51:02.658224+00:00 1 9 1285 725 880 534 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.6744032 2022-10-14T18:51:02.674403+00:00 1 9 1285 725 880 541 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.6905673 2022-10-14T18:51:02.690567+00:00 1 9 1285 725 880 541 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.7057326 2022-10-14T18:51:02.705733+00:00 1 9 1285 725 880 541 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.7218986 2022-10-14T18:51:02.721899+00:00 1 9 1285 725 880 541 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.7380662 2022-10-14T18:51:02.738066+00:00 1 9 1285 725 880 541 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.7542155 2022-10-14T18:51:02.754215+00:00 1 9 1285 725 880 541 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.7703848 2022-10-14T18:51:02.770385+00:00 1 9 1285 725 880 541 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.7865546 2022-10-14T18:51:02.786555+00:00 1 9 1285 725 880 532 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.8017442 2022-10-14T18:51:02.801744+00:00 1 9 1285 725 880 519 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.817937 2022-10-14T18:51:02.817937+00:00 1 9 1285 725 880 501 1660 779 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.8341908 2022-10-14T18:51:02.834191+00:00 1 9 1285 725 880 501 1660 784 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.850335 2022-10-14T18:51:02.850335+00:00 1 9 1285 725 880 480 1660 784 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.8665252 2022-10-14T18:51:02.866525+00:00 1 9 1285 725 880 470 1660 787 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.8817084 2022-10-14T18:51:02.881708+00:00 1 9 1285 725 880 470 1660 791 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.8978813 2022-10-14T18:51:02.897881+00:00 1 9 1285 725 880 470 1660 795 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.9140546 2022-10-14T18:51:02.914055+00:00 1 9 1285 725 880 470 1660 802 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.9302268 2022-10-14T18:51:02.930227+00:00 1 9 1285 725 880 470 1660 810 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.9464023 2022-10-14T18:51:02.946402+00:00 1 9 1285 725 880 470 1660 822 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.9625568 2022-10-14T18:51:02.962557+00:00 1 9 1285 725 880 470 1660 834 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.9777336 2022-10-14T18:51:02.977734+00:00 1 9 1285 725 880 480 1660 841 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773462.9939206 2022-10-14T18:51:02.993921+00:00 1 9 1285 725 880 494 1660 848 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.0100884 2022-10-14T18:51:03.010088+00:00 1 9 1285 725 880 525 1660 848 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.0262587 2022-10-14T18:51:03.026259+00:00 1 9 1285 725 880 595 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.0424447 2022-10-14T18:51:03.042445+00:00 1 9 1285 725 880 631 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.05861 2022-10-14T18:51:03.058610+00:00 1 9 1285 725 880 689 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.073778 2022-10-14T18:51:03.073778+00:00 1 9 1285 725 880 768 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.089943 2022-10-14T18:51:03.089943+00:00 1 9 1285 725 880 768 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.1061091 2022-10-14T18:51:03.106109+00:00 1 9 1285 725 880 799 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.1222796 2022-10-14T18:51:03.122280+00:00 1 9 1285 725 880 802 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.1384535 2022-10-14T18:51:03.138453+00:00 1 9 1285 725 880 804 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.1545951 2022-10-14T18:51:03.154595+00:00 1 9 1285 725 880 804 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.1697395 2022-10-14T18:51:03.169739+00:00 1 9 1285 725 880 804 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.185909 2022-10-14T18:51:03.185909+00:00 1 9 1285 725 880 804 1660 850 0 0
exp_2022_10_14_10 39 41 lion tiger 1665773463.2020602 2022-10-14T18:51:03.202060+00:00 1 9 1285 725 880 804 1660 850 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]);