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

View and edit SQL

Suggested facets: 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_04_09 11 18 lion tiger 1664908359.7893286 2022-10-04T18:32:39.789329+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.805045 2022-10-04T18:32:39.805045+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.8212523 2022-10-04T18:32:39.821252+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.8374617 2022-10-04T18:32:39.837462+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.8526826 2022-10-04T18:32:39.852683+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.8688877 2022-10-04T18:32:39.868888+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.8851583 2022-10-04T18:32:39.885158+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.901386 2022-10-04T18:32:39.901386+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.916585 2022-10-04T18:32:39.916585+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.932776 2022-10-04T18:32:39.932776+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.9489439 2022-10-04T18:32:39.948944+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.9650974 2022-10-04T18:32:39.965097+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.981268 2022-10-04T18:32:39.981268+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908359.997431 2022-10-04T18:32:39.997431+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.0125766 2022-10-04T18:32:40.012577+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.0287373 2022-10-04T18:32:40.028737+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.0449443 2022-10-04T18:32:40.044944+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.0611362 2022-10-04T18:32:40.061136+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.0773208 2022-10-04T18:32:40.077321+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.0935187 2022-10-04T18:32:40.093519+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.1097362 2022-10-04T18:32:40.109736+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.1259587 2022-10-04T18:32:40.125959+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.1421392 2022-10-04T18:32:40.142139+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.1583343 2022-10-04T18:32:40.158334+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.1745052 2022-10-04T18:32:40.174505+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.1906757 2022-10-04T18:32:40.190676+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.2068243 2022-10-04T18:32:40.206824+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.2229865 2022-10-04T18:32:40.222986+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.2391813 2022-10-04T18:32:40.239181+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.2553818 2022-10-04T18:32:40.255382+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.270567 2022-10-04T18:32:40.270567+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.286774 2022-10-04T18:32:40.286774+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.3029826 2022-10-04T18:32:40.302983+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.3191583 2022-10-04T18:32:40.319158+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.3353603 2022-10-04T18:32:40.335360+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.3505769 2022-10-04T18:32:40.350577+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.366775 2022-10-04T18:32:40.366775+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.382979 2022-10-04T18:32:40.382979+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.399189 2022-10-04T18:32:40.399189+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.4154058 2022-10-04T18:32:40.415406+00:00 1 10 1285 725 880 785 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.4306304 2022-10-04T18:32:40.430630+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.446841 2022-10-04T18:32:40.446841+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.4630456 2022-10-04T18:32:40.463046+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.4792478 2022-10-04T18:32:40.479248+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.4954412 2022-10-04T18:32:40.495441+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.5106072 2022-10-04T18:32:40.510607+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.52677 2022-10-04T18:32:40.526770+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.5429363 2022-10-04T18:32:40.542936+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.5591083 2022-10-04T18:32:40.559108+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.5753207 2022-10-04T18:32:40.575321+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.5905802 2022-10-04T18:32:40.590580+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.606798 2022-10-04T18:32:40.606798+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.6230252 2022-10-04T18:32:40.623025+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.6392682 2022-10-04T18:32:40.639268+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.655486 2022-10-04T18:32:40.655486+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.6706986 2022-10-04T18:32:40.670699+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.686908 2022-10-04T18:32:40.686908+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.7030997 2022-10-04T18:32:40.703100+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.7192655 2022-10-04T18:32:40.719265+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.735435 2022-10-04T18:32:40.735435+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.7505963 2022-10-04T18:32:40.750596+00:00 1 10 1285 725 880 846 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.766762 2022-10-04T18:32:40.766762+00:00 1 10 1285 725 880 846 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.7829525 2022-10-04T18:32:40.782953+00:00 1 10 1285 725 880 841 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.799181 2022-10-04T18:32:40.799181+00:00 1 10 1285 725 880 841 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.8154585 2022-10-04T18:32:40.815459+00:00 1 9 1285 725 880 834 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.8307035 2022-10-04T18:32:40.830703+00:00 1 9 1285 725 880 829 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.846937 2022-10-04T18:32:40.846937+00:00 1 9 1285 725 880 829 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.863154 2022-10-04T18:32:40.863154+00:00 1 9 1285 725 880 823 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.8793628 2022-10-04T18:32:40.879363+00:00 1 9 1285 725 880 819 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.8945603 2022-10-04T18:32:40.894560+00:00 1 9 1285 725 880 818 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.910732 2022-10-04T18:32:40.910732+00:00 1 9 1285 725 880 817 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.9268599 2022-10-04T18:32:40.926860+00:00 1 9 1285 725 880 815 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.9430351 2022-10-04T18:32:40.943035+00:00 1 9 1285 725 880 815 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.9592028 2022-10-04T18:32:40.959203+00:00 1 9 1285 725 880 815 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.9753714 2022-10-04T18:32:40.975371+00:00 1 9 1285 725 880 815 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908360.9915578 2022-10-04T18:32:40.991558+00:00 1 9 1285 725 880 814 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.0077841 2022-10-04T18:32:41.007784+00:00 1 9 1285 725 880 813 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.0240777 2022-10-04T18:32:41.024078+00:00 1 9 1285 725 880 811 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.040372 2022-10-04T18:32:41.040372+00:00 1 9 1285 725 880 810 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.055604 2022-10-04T18:32:41.055604+00:00 1 9 1285 725 880 806 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.071783 2022-10-04T18:32:41.071783+00:00 1 9 1285 725 880 794 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.087985 2022-10-04T18:32:41.087985+00:00 1 9 1285 725 880 787 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.1041656 2022-10-04T18:32:41.104166+00:00 1 9 1285 725 880 778 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.120298 2022-10-04T18:32:41.120298+00:00 1 9 1285 725 880 778 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.1364238 2022-10-04T18:32:41.136424+00:00 1 9 1285 725 880 769 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.1515505 2022-10-04T18:32:41.151551+00:00 1 9 1285 725 880 760 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.1676815 2022-10-04T18:32:41.167681+00:00 1 9 1285 725 880 753 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.183837 2022-10-04T18:32:41.183837+00:00 1 9 1285 725 880 746 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.200012 2022-10-04T18:32:41.200012+00:00 1 9 1285 725 880 741 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.2162035 2022-10-04T18:32:41.216203+00:00 1 9 1285 725 880 737 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.2323902 2022-10-04T18:32:41.232390+00:00 1 9 1285 725 880 733 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.2475972 2022-10-04T18:32:41.247597+00:00 1 9 1285 725 880 718 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.2638047 2022-10-04T18:32:41.263805+00:00 1 9 1285 725 880 711 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.2800007 2022-10-04T18:32:41.280001+00:00 1 9 1285 725 880 705 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.2961884 2022-10-04T18:32:41.296188+00:00 1 9 1285 725 880 700 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.312378 2022-10-04T18:32:41.312378+00:00 1 9 1285 725 880 700 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.328543 2022-10-04T18:32:41.328543+00:00 1 9 1285 725 880 696 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.34471 2022-10-04T18:32:41.344710+00:00 1 9 1285 725 880 693 1660 850 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.3608675 2022-10-04T18:32:41.360868+00:00 1 9 1285 725 880 689 1660 822 0 0
exp_2022_10_04_09 11 18 lion tiger 1664908361.3770463 2022-10-04T18:32:41.377046+00:00 1 9 1285 725 880 683 1660 814 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]);