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_1_id = 99902

View and edit SQL

Suggested facets: group_session, player_2_id, 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_27_10 99902 68 lion tiger 1666896510.2832363 2022-10-27T18:48:30.283236+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.2987008 2022-10-27T18:48:30.298701+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.3149369 2022-10-27T18:48:30.314937+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.3311582 2022-10-27T18:48:30.331158+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.3473651 2022-10-27T18:48:30.347365+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.363563 2022-10-27T18:48:30.363563+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.3797653 2022-10-27T18:48:30.379765+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.395989 2022-10-27T18:48:30.395989+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.4121346 2022-10-27T18:48:30.412135+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.428282 2022-10-27T18:48:30.428282+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.4444306 2022-10-27T18:48:30.444431+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.4595933 2022-10-27T18:48:30.459593+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.4757435 2022-10-27T18:48:30.475744+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.4918838 2022-10-27T18:48:30.491884+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.5080397 2022-10-27T18:48:30.508040+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.5242584 2022-10-27T18:48:30.524258+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.5404997 2022-10-27T18:48:30.540500+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.5557103 2022-10-27T18:48:30.555710+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.5719042 2022-10-27T18:48:30.571904+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.5880916 2022-10-27T18:48:30.588092+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.604231 2022-10-27T18:48:30.604231+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.620381 2022-10-27T18:48:30.620381+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.6365323 2022-10-27T18:48:30.636532+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.6516905 2022-10-27T18:48:30.651690+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.6678445 2022-10-27T18:48:30.667845+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.683999 2022-10-27T18:48:30.683999+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.7001595 2022-10-27T18:48:30.700160+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.7163255 2022-10-27T18:48:30.716326+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.7324934 2022-10-27T18:48:30.732493+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.7481806 2022-10-27T18:48:30.748181+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.7644184 2022-10-27T18:48:30.764418+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.7805352 2022-10-27T18:48:30.780535+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.7956767 2022-10-27T18:48:30.795677+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.8118384 2022-10-27T18:48:30.811838+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.8280208 2022-10-27T18:48:30.828021+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.8441834 2022-10-27T18:48:30.844183+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.8603566 2022-10-27T18:48:30.860357+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.8765287 2022-10-27T18:48:30.876529+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.8916998 2022-10-27T18:48:30.891700+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.907896 2022-10-27T18:48:30.907896+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.924086 2022-10-27T18:48:30.924086+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.9402688 2022-10-27T18:48:30.940269+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.9564672 2022-10-27T18:48:30.956467+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.9716651 2022-10-27T18:48:30.971665+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896510.9878817 2022-10-27T18:48:30.987882+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.0040827 2022-10-27T18:48:31.004083+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.02023 2022-10-27T18:48:31.020230+00:00 1 10 1285 725 880 784 1660 850 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.0364003 2022-10-27T18:48:31.036400+00:00 1 10 1285 725 880 784 1660 796 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.0525398 2022-10-27T18:48:31.052540+00:00 1 10 1285 725 880 784 1660 800 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.067717 2022-10-27T18:48:31.067717+00:00 1 10 1285 725 880 784 1660 806 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.0838833 2022-10-27T18:48:31.083883+00:00 1 10 1285 725 880 848 1660 806 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.1000574 2022-10-27T18:48:31.100057+00:00 1 10 1285 725 880 848 1660 812 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.1162267 2022-10-27T18:48:31.116227+00:00 1 10 1285 725 880 847 1660 817 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.1323872 2022-10-27T18:48:31.132387+00:00 1 10 1285 725 880 844 1660 822 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.148551 2022-10-27T18:48:31.148551+00:00 1 10 1285 725 880 842 1660 827 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.1637166 2022-10-27T18:48:31.163717+00:00 1 10 1285 725 880 842 1660 835 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.1798902 2022-10-27T18:48:31.179890+00:00 1 10 1285 725 880 835 1660 837 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.1960292 2022-10-27T18:48:31.196029+00:00 1 10 1285 725 880 831 1660 837 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.2121975 2022-10-27T18:48:31.212198+00:00 1 10 1285 725 880 821 1660 839 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.2283945 2022-10-27T18:48:31.228395+00:00 1 10 1285 725 880 821 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.244599 2022-10-27T18:48:31.244599+00:00 1 10 1285 725 880 809 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.2607412 2022-10-27T18:48:31.260741+00:00 1 10 1285 725 880 809 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.276903 2022-10-27T18:48:31.276903+00:00 1 10 1285 725 880 799 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.2930732 2022-10-27T18:48:31.293073+00:00 1 10 1285 725 880 786 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.3092399 2022-10-27T18:48:31.309240+00:00 1 9 1285 725 880 777 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.3254118 2022-10-27T18:48:31.325412+00:00 1 9 1285 725 880 771 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.3415778 2022-10-27T18:48:31.341578+00:00 1 9 1285 725 880 759 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.3577251 2022-10-27T18:48:31.357725+00:00 1 9 1285 725 880 743 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.373881 2022-10-27T18:48:31.373881+00:00 1 9 1285 725 880 730 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.3900664 2022-10-27T18:48:31.390066+00:00 1 9 1285 725 880 694 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.4062483 2022-10-27T18:48:31.406248+00:00 1 9 1285 725 880 685 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.4224586 2022-10-27T18:48:31.422459+00:00 1 9 1285 725 880 685 1660 841 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.4376686 2022-10-27T18:48:31.437669+00:00 1 9 1285 725 880 652 1660 839 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.4538772 2022-10-27T18:48:31.453877+00:00 1 9 1285 725 880 631 1660 839 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.470135 2022-10-27T18:48:31.470135+00:00 1 9 1285 725 880 612 1660 839 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.4863544 2022-10-27T18:48:31.486354+00:00 1 9 1285 725 880 605 1660 831 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.5024896 2022-10-27T18:48:31.502490+00:00 1 9 1285 725 880 589 1660 825 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.5186315 2022-10-27T18:48:31.518631+00:00 1 9 1285 725 880 568 1660 817 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.5348375 2022-10-27T18:48:31.534837+00:00 1 9 1285 725 880 535 1660 813 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.551 2022-10-27T18:48:31.551000+00:00 1 9 1285 725 880 522 1660 809 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.5671406 2022-10-27T18:48:31.567141+00:00 1 9 1285 725 880 511 1660 806 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.58331 2022-10-27T18:48:31.583310+00:00 1 9 1285 725 880 511 1660 803 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.5994685 2022-10-27T18:48:31.599468+00:00 1 9 1285 725 880 495 1660 800 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.615609 2022-10-27T18:48:31.615609+00:00 1 9 1285 725 880 495 1660 799 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.631791 2022-10-27T18:48:31.631791+00:00 1 9 1285 725 880 495 1660 796 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.6479886 2022-10-27T18:48:31.647989+00:00 1 9 1285 725 880 495 1660 795 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.6641996 2022-10-27T18:48:31.664200+00:00 1 9 1285 725 880 495 1660 794 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.6803975 2022-10-27T18:48:31.680398+00:00 1 9 1285 725 880 495 1660 794 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.6965685 2022-10-27T18:48:31.696568+00:00 1 9 1285 725 880 527 1660 794 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.7117302 2022-10-27T18:48:31.711730+00:00 1 9 1285 725 880 569 1660 793 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.7279038 2022-10-27T18:48:31.727904+00:00 1 9 1285 725 880 620 1660 791 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.7440903 2022-10-27T18:48:31.744090+00:00 1 9 1285 725 880 708 1660 790 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.760252 2022-10-27T18:48:31.760252+00:00 1 9 1285 725 880 775 1660 789 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.776466 2022-10-27T18:48:31.776466+00:00 1 9 1285 725 880 843 1660 788 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.7917159 2022-10-27T18:48:31.791716+00:00 1 9 1285 725 880 850 1660 787 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.8079424 2022-10-27T18:48:31.807942+00:00 1 9 1285 725 880 850 1660 786 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.8241696 2022-10-27T18:48:31.824170+00:00 1 9 1285 725 880 850 1660 785 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.8404121 2022-10-27T18:48:31.840412+00:00 1 9 1285 725 880 850 1660 785 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.855681 2022-10-27T18:48:31.855681+00:00 1 9 1285 725 880 850 1660 782 0 0
exp_2022_10_27_10 99902 68 lion tiger 1666896511.8719065 2022-10-27T18:48:31.871907+00:00 1 9 1285 725 880 850 1660 779 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]);