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

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_2023_02_10_10 102 103 lion tiger 1676054818.6693056 2023-02-10T18:46:58.669306+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.685836 2023-02-10T18:46:58.685836+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.7020907 2023-02-10T18:46:58.702091+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.7173102 2023-02-10T18:46:58.717310+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.7335095 2023-02-10T18:46:58.733510+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.7496948 2023-02-10T18:46:58.749695+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.7658923 2023-02-10T18:46:58.765892+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.7821257 2023-02-10T18:46:58.782126+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.7973518 2023-02-10T18:46:58.797352+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.8136005 2023-02-10T18:46:58.813601+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.8298545 2023-02-10T18:46:58.829854+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.846135 2023-02-10T18:46:58.846135+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.8613443 2023-02-10T18:46:58.861344+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.8775697 2023-02-10T18:46:58.877570+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.8937802 2023-02-10T18:46:58.893780+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.91 2023-02-10T18:46:58.910000+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.926244 2023-02-10T18:46:58.926244+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.9424815 2023-02-10T18:46:58.942482+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.9587295 2023-02-10T18:46:58.958730+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.9749644 2023-02-10T18:46:58.974964+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054818.9911776 2023-02-10T18:46:58.991178+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.0073957 2023-02-10T18:46:59.007396+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.0236244 2023-02-10T18:46:59.023624+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.0398824 2023-02-10T18:46:59.039882+00:00 1 10 1285 725 880 795 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.0561376 2023-02-10T18:46:59.056138+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.071366 2023-02-10T18:46:59.071366+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.087585 2023-02-10T18:46:59.087585+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.103819 2023-02-10T18:46:59.103819+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.1200466 2023-02-10T18:46:59.120047+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.1352496 2023-02-10T18:46:59.135250+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.151474 2023-02-10T18:46:59.151474+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.1677115 2023-02-10T18:46:59.167711+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.1839268 2023-02-10T18:46:59.183927+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.200141 2023-02-10T18:46:59.200141+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.2153275 2023-02-10T18:46:59.215328+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.2314913 2023-02-10T18:46:59.231491+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.2476563 2023-02-10T18:46:59.247656+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.2638452 2023-02-10T18:46:59.263845+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.2800312 2023-02-10T18:46:59.280031+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.296254 2023-02-10T18:46:59.296254+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.3124974 2023-02-10T18:46:59.312497+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.328719 2023-02-10T18:46:59.328719+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.3449397 2023-02-10T18:46:59.344940+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.3611822 2023-02-10T18:46:59.361182+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.3764348 2023-02-10T18:46:59.376435+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.3927026 2023-02-10T18:46:59.392703+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.4089434 2023-02-10T18:46:59.408943+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.4251842 2023-02-10T18:46:59.425184+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.4404323 2023-02-10T18:46:59.440432+00:00 1 10 1285 725 880 470 1660 574 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.456679 2023-02-10T18:46:59.456679+00:00 1 10 1285 725 880 470 1660 576 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.472891 2023-02-10T18:46:59.472891+00:00 1 10 1285 725 880 470 1660 576 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.4891033 2023-02-10T18:46:59.489103+00:00 1 10 1285 725 880 470 1660 578 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.504337 2023-02-10T18:46:59.504337+00:00 1 10 1285 725 880 470 1660 579 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.5205772 2023-02-10T18:46:59.520577+00:00 1 10 1285 725 880 470 1660 582 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.5367897 2023-02-10T18:46:59.536790+00:00 1 10 1285 725 880 470 1660 586 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.5530355 2023-02-10T18:46:59.553035+00:00 1 10 1285 725 880 470 1660 594 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.5682797 2023-02-10T18:46:59.568280+00:00 1 10 1285 725 880 470 1660 594 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.5845022 2023-02-10T18:46:59.584502+00:00 1 10 1285 725 880 470 1660 600 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.600721 2023-02-10T18:46:59.600721+00:00 1 10 1285 725 880 470 1660 603 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.6169155 2023-02-10T18:46:59.616915+00:00 1 10 1285 725 880 470 1660 607 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.6331258 2023-02-10T18:46:59.633126+00:00 1 10 1285 725 880 470 1660 610 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.648371 2023-02-10T18:46:59.648371+00:00 1 10 1285 725 880 470 1660 613 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.6646788 2023-02-10T18:46:59.664679+00:00 1 10 1285 725 880 470 1660 616 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.6809301 2023-02-10T18:46:59.680930+00:00 1 10 1285 725 880 470 1660 619 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.6972504 2023-02-10T18:46:59.697250+00:00 1 9 1285 725 880 473 1660 621 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.7134724 2023-02-10T18:46:59.713472+00:00 1 9 1285 725 880 475 1660 622 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.729677 2023-02-10T18:46:59.729677+00:00 1 9 1285 725 880 478 1660 622 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.7458844 2023-02-10T18:46:59.745884+00:00 1 9 1285 725 880 484 1660 622 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.7620764 2023-02-10T18:46:59.762076+00:00 1 9 1285 725 880 490 1660 622 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.7782698 2023-02-10T18:46:59.778270+00:00 1 9 1285 725 880 496 1660 622 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.7944932 2023-02-10T18:46:59.794493+00:00 1 9 1285 725 880 502 1660 622 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.8106847 2023-02-10T18:46:59.810685+00:00 1 9 1285 725 880 507 1660 622 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.8268652 2023-02-10T18:46:59.826865+00:00 1 9 1285 725 880 508 1660 622 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.8430502 2023-02-10T18:46:59.843050+00:00 1 9 1285 725 880 511 1660 620 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.859245 2023-02-10T18:46:59.859245+00:00 1 9 1285 725 880 512 1660 614 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.8754249 2023-02-10T18:46:59.875425+00:00 1 9 1285 725 880 512 1660 607 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.891636 2023-02-10T18:46:59.891636+00:00 1 9 1285 725 880 516 1660 597 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.9078548 2023-02-10T18:46:59.907855+00:00 1 9 1285 725 880 519 1660 585 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.924096 2023-02-10T18:46:59.924096+00:00 1 9 1285 725 880 522 1660 567 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.9392986 2023-02-10T18:46:59.939299+00:00 1 9 1285 725 880 525 1660 549 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.9555206 2023-02-10T18:46:59.955521+00:00 1 9 1285 725 880 529 1660 549 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.9717166 2023-02-10T18:46:59.971717+00:00 1 9 1285 725 880 529 1660 536 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054819.987932 2023-02-10T18:46:59.987932+00:00 1 9 1285 725 880 531 1660 523 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.004164 2023-02-10T18:47:00.004164+00:00 1 9 1285 725 880 534 1660 511 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.0193977 2023-02-10T18:47:00.019398+00:00 1 9 1285 725 880 535 1660 499 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.035639 2023-02-10T18:47:00.035639+00:00 1 9 1285 725 880 535 1660 490 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.0518916 2023-02-10T18:47:00.051892+00:00 1 9 1285 725 880 538 1660 478 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.0681207 2023-02-10T18:47:00.068121+00:00 1 9 1285 725 880 546 1660 475 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.083333 2023-02-10T18:47:00.083333+00:00 1 9 1285 725 880 546 1660 475 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.0995655 2023-02-10T18:47:00.099566+00:00 1 9 1285 725 880 555 1660 475 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.11583 2023-02-10T18:47:00.115830+00:00 1 9 1285 725 880 564 1660 475 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.1320815 2023-02-10T18:47:00.132082+00:00 1 9 1285 725 880 576 1660 475 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.147344 2023-02-10T18:47:00.147344+00:00 1 9 1285 725 880 584 1660 475 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.163601 2023-02-10T18:47:00.163601+00:00 1 9 1285 725 880 592 1660 475 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.1798522 2023-02-10T18:47:00.179852+00:00 1 9 1285 725 880 601 1660 479 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.1961095 2023-02-10T18:47:00.196110+00:00 1 9 1285 725 880 616 1660 490 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.2113626 2023-02-10T18:47:00.211363+00:00 1 9 1285 725 880 623 1660 494 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.2276068 2023-02-10T18:47:00.227607+00:00 1 9 1285 725 880 623 1660 494 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.2438502 2023-02-10T18:47:00.243850+00:00 1 9 1285 725 880 628 1660 500 0 0
exp_2023_02_10_10 102 103 lion tiger 1676054820.2601013 2023-02-10T18:47:00.260101+00:00 1 9 1285 725 880 631 1660 507 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]);