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

View and edit SQL

Suggested facets: 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_21_14 109 116 lion tiger 1677018959.7662265 2023-02-21T22:35:59.766227+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.7820637 2023-02-21T22:35:59.782064+00:00 1 10 1285 725 880 830 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.798229 2023-02-21T22:35:59.798229+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.814383 2023-02-21T22:35:59.814383+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.8305442 2023-02-21T22:35:59.830544+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.8466952 2023-02-21T22:35:59.846695+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.862867 2023-02-21T22:35:59.862867+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.8790429 2023-02-21T22:35:59.879043+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.895208 2023-02-21T22:35:59.895208+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.9113715 2023-02-21T22:35:59.911371+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.9275336 2023-02-21T22:35:59.927534+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.9437037 2023-02-21T22:35:59.943704+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.9598677 2023-02-21T22:35:59.959868+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.9760425 2023-02-21T22:35:59.976043+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018959.9922216 2023-02-21T22:35:59.992222+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.0084047 2023-02-21T22:36:00.008405+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.0246098 2023-02-21T22:36:00.024610+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.0407865 2023-02-21T22:36:00.040787+00:00 1 10 1285 725 880 829 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.0569537 2023-02-21T22:36:00.056954+00:00 1 10 1285 725 880 830 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.0721264 2023-02-21T22:36:00.072126+00:00 1 10 1285 725 880 830 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.088289 2023-02-21T22:36:00.088289+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.1044633 2023-02-21T22:36:00.104463+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.1206384 2023-02-21T22:36:00.120638+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.136811 2023-02-21T22:36:00.136811+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.1529868 2023-02-21T22:36:00.152987+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.1681633 2023-02-21T22:36:00.168163+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.1843815 2023-02-21T22:36:00.184381+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.2005703 2023-02-21T22:36:00.200570+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.2167513 2023-02-21T22:36:00.216751+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.2329228 2023-02-21T22:36:00.232923+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.2480855 2023-02-21T22:36:00.248085+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.264251 2023-02-21T22:36:00.264251+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.2804348 2023-02-21T22:36:00.280435+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.2966077 2023-02-21T22:36:00.296608+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.312763 2023-02-21T22:36:00.312763+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.3289187 2023-02-21T22:36:00.328919+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.3440855 2023-02-21T22:36:00.344085+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.3602538 2023-02-21T22:36:00.360254+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.3764236 2023-02-21T22:36:00.376424+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.3925593 2023-02-21T22:36:00.392559+00:00 1 10 1285 725 880 832 1660 797 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.4086926 2023-02-21T22:36:00.408693+00:00 1 10 1285 725 880 832 1660 835 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.424799 2023-02-21T22:36:00.424799+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.440982 2023-02-21T22:36:00.440982+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.4561694 2023-02-21T22:36:00.456169+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.4723275 2023-02-21T22:36:00.472327+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.4884918 2023-02-21T22:36:00.488492+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.504677 2023-02-21T22:36:00.504677+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.5208313 2023-02-21T22:36:00.520831+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.5369723 2023-02-21T22:36:00.536972+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.552144 2023-02-21T22:36:00.552144+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.5683186 2023-02-21T22:36:00.568319+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.5844657 2023-02-21T22:36:00.584466+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.60061 2023-02-21T22:36:00.600610+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.6168149 2023-02-21T22:36:00.616815+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.6329925 2023-02-21T22:36:00.632993+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.64817 2023-02-21T22:36:00.648170+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.6643457 2023-02-21T22:36:00.664346+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.680523 2023-02-21T22:36:00.680523+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.696692 2023-02-21T22:36:00.696692+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.7128537 2023-02-21T22:36:00.712854+00:00 1 10 1285 725 880 832 1660 837 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.7290223 2023-02-21T22:36:00.729022+00:00 1 10 1285 725 880 832 1660 833 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.745228 2023-02-21T22:36:00.745228+00:00 1 10 1285 725 880 832 1660 824 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.7614436 2023-02-21T22:36:00.761444+00:00 1 10 1285 725 880 832 1660 815 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.777609 2023-02-21T22:36:00.777609+00:00 1 10 1285 725 880 832 1660 807 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.7937713 2023-02-21T22:36:00.793771+00:00 1 9 1285 725 880 832 1660 800 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.8099358 2023-02-21T22:36:00.809936+00:00 1 9 1285 725 880 832 1660 796 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.8251112 2023-02-21T22:36:00.825111+00:00 1 9 1285 725 880 832 1660 794 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.841286 2023-02-21T22:36:00.841286+00:00 1 9 1285 725 880 832 1660 794 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.857453 2023-02-21T22:36:00.857453+00:00 1 9 1285 725 880 832 1660 794 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.8736255 2023-02-21T22:36:00.873626+00:00 1 9 1285 725 880 832 1660 794 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.8898087 2023-02-21T22:36:00.889809+00:00 1 9 1285 725 880 832 1660 794 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.9060144 2023-02-21T22:36:00.906014+00:00 1 9 1285 725 880 832 1660 794 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.9211776 2023-02-21T22:36:00.921178+00:00 1 9 1285 725 880 832 1660 794 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.9373863 2023-02-21T22:36:00.937386+00:00 1 9 1285 725 880 832 1660 794 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.9535584 2023-02-21T22:36:00.953558+00:00 1 9 1285 725 880 832 1660 794 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.9697266 2023-02-21T22:36:00.969727+00:00 1 9 1285 725 880 832 1660 798 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018960.985899 2023-02-21T22:36:00.985899+00:00 1 9 1285 725 880 832 1660 809 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.002073 2023-02-21T22:36:01.002073+00:00 1 9 1285 725 880 832 1660 816 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.0182724 2023-02-21T22:36:01.018272+00:00 1 9 1285 725 880 832 1660 820 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.0344598 2023-02-21T22:36:01.034460+00:00 1 9 1285 725 880 832 1660 823 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.050644 2023-02-21T22:36:01.050644+00:00 1 9 1285 725 880 832 1660 823 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.0668118 2023-02-21T22:36:01.066812+00:00 1 9 1285 725 880 832 1660 826 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.0829763 2023-02-21T22:36:01.082976+00:00 1 9 1285 725 880 832 1660 828 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.0981562 2023-02-21T22:36:01.098156+00:00 1 9 1285 725 880 832 1660 828 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.1143098 2023-02-21T22:36:01.114310+00:00 1 9 1285 725 880 832 1660 828 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.130486 2023-02-21T22:36:01.130486+00:00 1 9 1285 725 880 832 1660 828 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.14666 2023-02-21T22:36:01.146660+00:00 1 9 1285 725 880 832 1660 828 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.1628196 2023-02-21T22:36:01.162820+00:00 1 9 1285 725 880 832 1660 828 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.17898 2023-02-21T22:36:01.178980+00:00 1 9 1285 725 880 832 1660 828 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.194214 2023-02-21T22:36:01.194214+00:00 1 9 1285 725 880 832 1660 828 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.2104092 2023-02-21T22:36:01.210409+00:00 1 9 1285 725 880 832 1660 819 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.2265856 2023-02-21T22:36:01.226586+00:00 1 9 1285 725 880 832 1660 812 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.2427645 2023-02-21T22:36:01.242764+00:00 1 9 1285 725 880 832 1660 803 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.2589412 2023-02-21T22:36:01.258941+00:00 1 9 1285 725 880 832 1660 803 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.274115 2023-02-21T22:36:01.274115+00:00 1 9 1285 725 880 832 1660 796 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.2902968 2023-02-21T22:36:01.290297+00:00 1 9 1285 725 880 832 1660 790 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.306467 2023-02-21T22:36:01.306467+00:00 1 9 1285 725 880 832 1660 784 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.3226366 2023-02-21T22:36:01.322637+00:00 1 9 1285 725 880 832 1660 780 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.3388093 2023-02-21T22:36:01.338809+00:00 1 9 1285 725 880 832 1660 776 0 0
exp_2023_02_21_14 109 116 lion tiger 1677018961.3549998 2023-02-21T22:36:01.355000+00:00 1 9 1285 725 880 832 1660 773 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]);